Entries by Oracle ERP Apps Guide

, ,

API – Allocate and Transact Orders (Transact Move Orders)

create or replace procedure XX_ALOCATE_TRANSACT_MOVE_ORDER (P_REQUEST_NUMBER VARCHAR2 ,P_ORGANIZATION_ID NUMBER,P_TRANSACTION_DATE varchar2)as—————– ALLOCATE MOVE ORDER API REQUIREMENTS ————————-l_api_version NUMBER := 1.0;l_init_msg_list VARCHAR2 (2) := fnd_api.g_true;l_return_values VARCHAR2 (2) := fnd_api.g_false;l_commit VARCHAR2 (2) := fnd_api.g_false;x_return_status VARCHAR2 (2);x_msg_count NUMBER := 0;x_msg_data VARCHAR2 (255);l_user_id NUMBER ;l_resp_id NUMBER ;l_appl_id NUMBER ;l_row_cnt NUMBER := 1;l_trohdr_rec inv_move_order_pub.trohdr_rec_type;l_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;x_trohdr_rec inv_move_order_pub.trohdr_rec_type;x_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;l_validation_flag VARCHAR2 (2) := inv_move_order_pub.g_validation_yes;l_trolin_tbl […]

/by
,

API to cancel AP Invoice

AP_CANCEL_PKG.IS_INVOICE_CANCELLABLE:Is_Invoice_Cancellable is a Function in the AP_CANCEL_PKG package that checks that an Invoice is cancellable or not when an Invoice Cancellation process starts.It follows the following steps and returns a Boolean value depending on the result. If invoice contains distribution that does not have open GL period return FALSE. If invoice has an effective payment, […]

/by
, , ,

Submit the Concurrent Program from Backend

The following is the Sample Code to Submit the Concurrent Program from the backend. Note:- This is the Concurrent Program, not the Request Set. To Submit the Request Set from the backend, We have different API. I have already document, for submitting the request set from the backend in the Following URL. http://oracleerpappsguide.blogspot.com/2011/09/registering-executable-concurrent.html DECLAREl_success NUMBER;BEGINBEGIN […]

/by