DECLARE x_return_status VARCHAR2 (200) := NULL; x_msg_count NUMBER := 0; x_msg_data VARCHAR2 (200) := NULL; t_output VARCHAR2 (200) := NULL; t_msg_dummy VARCHAR2 (200) := NULL; l_payee_upd_status iby_disbursement_setup_pub.ext_payee_update_tab_type; p_external_payee_tab_type iby_disbursement_setup_pub.external_payee_tab_type; p_ext_payee_id_tab_type…
Read MoreDECLARE x_return_status VARCHAR2 (200) := NULL; x_msg_count NUMBER := 0; x_msg_data VARCHAR2 (200) := NULL; t_output VARCHAR2 (200) := NULL; t_msg_dummy VARCHAR2 (200) := NULL; l_payee_upd_status iby_disbursement_setup_pub.ext_payee_update_tab_type; p_external_payee_tab_type iby_disbursement_setup_pub.external_payee_tab_type; p_ext_payee_id_tab_type…
Read More–Create Table create table papf_16082018 (person_id number, employee_number varchar2(10)); –Insert Data insert into papf_16082018 values (53687,’215677′); commit; update apps.fnd_user set employee_id=null where employee_id in (select distinct p.person_id from apps.per_all_people_f…
Read MoreOracle has provided an API to get the dynamic list of approvers for AME. ame_dynamic_approval_pkg.get_ame_apprs_and_ins_list. We need to pass the transaction type id and transaction number. Rransaction Id is available…
Read MoreHow to programmatically close PO using PO_ACTIONS API PO_ACTIONS.CLOSE_PO is the API used to programmatically close/final close Purchase Order. We have to pass P_ACTION parameter value as ‘CLOSE’/’FINALLY CLOSE’ depending…
Read MoreDECLARE CURSOR c1 IS SELECT a.rowid row_id,a.* FROM temp_gl_code a WHERE process_flag= ‘N’; l_segment1 …
Read MoreA responsibility is an important configuration which allows the user to navigate to the various menus and form functions within that responsibility.Oracle API is used to load responsibility from one…
Read MoreThe custom lookup parameters can be passed to the below API’s to insert data into Oracle standard tables fnd_lookup_values and fnd_lookup_types *fnd_lookup_types_pkg.insert_row *fnd_lookup_values_pkg.insert_row Sample script with description to…
Read MoreThis blog describes the process and technical information required for creating new employee using API. In any business organization employee should there to do the work, so Oracle provide hr_employee_api.create_employee…
Read MoreThis blog describes the technical information required for creating Inventory organization and their classification using API.In order to create Inventory organization we can use three API which are Apps.hr_organization_api.create_organization Apps.hr_organization_api.update_organization …
Read More