Entries by Oracle ERP Apps Guide

, ,

API – Ship Confirm of the Deliveries

declarep_api_version_number NUMBER;p_init_msg_list VARCHAR2(2000);V_return_status VARCHAR2(2000);V_msg_data VARCHAR2(2000);p_action_code VARCHAR2(2000);p_delivery_id NUMBER ;V_trip_id VARCHAR2(30);V_trip_name VARCHAR2(30);V_msg_details VARCHAR2(3000);V_msg_summary VARCHAR2(3000);V_msg_count NUMBER;V_init_msg_list VARCHAR(2000); begin p_delivery_id := 7102;           — dELIVERY ID FROM SALES TRANSACTION SCREEN p_action_code :=’CONFIRM’; WSH_DELIVERIES_PUB.Delivery_Action(                                    p_api_version_number => 1.0,                                    p_init_msg_list => V_init_msg_list,                                    x_return_status => V_return_status,                                    x_msg_count => V_msg_count,                                    x_msg_data => V_msg_data,                                    p_action_code => p_action_code,                                    p_delivery_id => p_delivery_id,                                    x_trip_id => V_trip_id,                                    x_trip_name => V_trip_name); […]

/by
, ,

API – GL Code Combination Creation

1) Custom Table to store account segments.create table XX_ACCOUNT_COMBINATIONS (CODE VARCHAR2(2000))===========================================================================================2) Function to Create or Check the Code Combinations in GL create or replace function create_ccid ( p_concat_segs in varchar2) return varchar2is — pragma autonomous_transaction; — if you need autonomy! l_keyval_status BOOLEAN; l_coa_id NUMBER; l_err_msg varchar2(2000); l_error varchar2(255);begin begin select chart_of_accounts_id into l_coa_id from gl_sets_of_books […]

/by
,

API – User Creation and Reponsibility Assignment

Declare          l_user_id         NUMBER;       v_customer_id       NUMBER;       l_email           VARCHAR2 (240);       l_error_message   VARCHAR2 (240);       l_record_status   BOOLEAN;       CURSOR c1       IS          SELECT     *                FROM XX_CONC_USERS               where status = ‘R’               and error_mesg is null               FOR UPDATE;    BEGIN       FOR i IN c1       LOOP          l_record_status := […]

/by
,

Unix Commands

1) Editing the FILE:-————————– *) To come to end of file:- G *) To delete the single word(can be free space):- dw *) to delete the current single char:- (Esc and x) *) To delete the complete line:- dd *) To right over in the file:- cw *) To remove the case sensitive:- :set ic *) […]

/by
, ,

API – Creating Values in Independant and dependant Value Sets

declare x varchar2(200); v_msg varchar2(2000); begin fnd_global.apps_initialize (1090, 51007, 401);   FND_FLEX_VAL_API.create_independent_vset_value  (‘XX_IND_VSET’,’10’,’Inserted from API’,’Y’,sysdate,NULL,’N’,NULL,NULL,X);     DBMS_OUTPUT.PUT_LINE(X); exception when others then v_msg:=fnd_flex_val_api.message;   DBMS_OUTPUT.PUT_LINE(v_msg); end; / COMMIT ——    Inserting child dependent Value Set Values ——————————- declare x varchar2(200); v_msg varchar2(2000); begin fnd_global.apps_initialize (1090, 51007, 401);  FND_FLEX_VAL_API.create_dependent_vset_value   (‘XX_DEP_VSET’,’10’,’10.1′,’Dependent Value inserted through API’,’Y’,sysdate,NULL,NULL,x);     DBMS_OUTPUT.PUT_LINE(X); exception […]

/by