erpSchools

Tag: API

  • XLA: Delete event XLA_EVENTS

    — Creted by Prudhvi </code> DECLARE p_event_source_info xla_events_pub_pkg.t_event_source_info; BEGIN p_event_source_info.source_application_id := NULL; –101 GL — 602 XLE p_event_source_info.application_id := 222; — AR p_event_source_info.legal_entity_id := 1234; p_event_source_info.ledger_id := 1; p_event_source_info.entity_type_code := ‘TRANSACTIONS’; p_event_source_info.transaction_number := NULL; p_event_source_info.source_id_int_1 := 1234; — Customer Transaction ID; p_event_source_info.source_id_int_2 := NULL; p_event_source_info.source_id_int_3 := NULL; p_event_source_info.source_id_int_4 := NULL; p_event_source_info.source_id_char_1 := NULL; p_event_source_info.source_id_char_2 :=…

  • OZF_FUND_UTILIZED_PVT.create_utilization

        SET serveroutput on; DECLARE l_user_name VARCHAR2(100) ; l_user_id NUMBER; l_resp_id NUMBER; l_adj_rec OZF_FUND_UTILIZED_PVT.utilization_rec_type; l_return_status VARCHAR2(1); l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_utilization_id NUMBER; BEGIN BEGIN select responsibility_id into l_resp_id from fnd_responsibility_vl where responsibility_key = ‘OZF_USER’; EXCEPTION WHEN OTHERS THEN l_resp_id := NULL; END; FND_GLOBAL.apps_initialize (user_id => 1234 — change this value , resp_id => l_resp_id,…

  • Item import (Item conversion)

    Overview: Item import program can be used to create new Inventory items or to update existing inventory items.  We can import items with all attributes information or use item templates to set attributes and import items linking with item template. Uses: Import New Inventory Items in Master Organization Assign Items to child Organization (Step1 has to be…

  • API: DBMS_CRYPTO: encrypt and decrypt information

    To Encrypt or decrypt, we will need a key. This key will be stored in a table which can be accessed only by the authorized personnel. In the below examples, the key has been hardcoded. dbms_crypto example to encrypt information Declare l_key varchar2(2000) := ‘1234567890123456’; l_mod number := dbms_crypto.ENCRYPT_AES128 + dbms_crypto.CHAIN_CBC + dbms_crypto.PAD_PKCS5; l_enc raw…

  • OE_ORDER_PUB: Cancel Sales Order Line

    set serveroutput on; DECLARE v_api_version_number NUMBER := 1; v_return_status VARCHAR2 (2000); v_msg_count NUMBER; v_msg_data VARCHAR2 (2000); l_debug_level NUMBER := 1 — IN Variables — v_header_rec oe_order_pub.header_rec_type; v_line_tbl oe_order_pub.line_tbl_type; v_action_request_tbl oe_order_pub.request_tbl_type; v_line_adj_tbl oe_order_pub.line_adj_tbl_type; — OUT Variables — v_header_rec_out oe_order_pub.header_rec_type; v_header_val_rec_out oe_order_pub.header_val_rec_type; v_header_adj_tbl_out oe_order_pub.header_adj_tbl_type; v_header_adj_val_tbl_out oe_order_pub.header_adj_val_tbl_type; v_header_price_att_tbl_out oe_order_pub.header_price_att_tbl_type; v_header_adj_att_tbl_out oe_order_pub.header_adj_att_tbl_type; v_header_adj_assoc_tbl_out oe_order_pub.header_adj_assoc_tbl_type; v_header_scredit_tbl_out oe_order_pub.header_scredit_tbl_type; v_header_scredit_val_tbl_out oe_order_pub.header_scredit_val_tbl_type; v_line_tbl_out…

  • OE_ORDER_PUB: Book existing Sales Order

    set serveroutput on; DECLARE l_api_version_number NUMBER := 1; l_return_status VARCHAR2(2000); l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_debug_level NUMBER := 1; — OM DEBUG LEVEL (MAX 5) — IN Variables — l_header_rec oe_order_pub.header_rec_type; l_line_tbl oe_order_pub.line_tbl_type; l_action_request_tbl oe_order_pub.Request_Tbl_Type; — OUT Variables — l_header_rec_out oe_order_pub.header_rec_type; l_header_val_rec_out oe_order_pub.header_val_rec_type; l_header_adj_tbl_out oe_order_pub.header_adj_tbl_type; l_header_adj_val_tbl_out oe_order_pub.header_adj_val_tbl_type; l_header_price_att_tbl_out oe_order_pub.header_price_att_tbl_type; l_header_adj_att_tbl_out oe_order_pub.header_adj_att_tbl_type; l_header_adj_assoc_tbl_out oe_order_pub.header_adj_assoc_tbl_type; l_header_scredit_tbl_out oe_order_pub.header_scredit_tbl_type; l_header_scredit_val_tbl_out…

  • OE_ORDER_PUB: Add lines to existing Sales Order

    OE_ORDER_PUB: Add lines to existing Sales Order set serveroutput on; DECLARE l_api_version_number NUMBER := 1; l_return_status VARCHAR2(2000); l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_debug_level NUMBER := 1; — OM DEBUG LEVEL (MAX 5) — IN Variables — l_header_rec oe_order_pub.header_rec_type; l_line_tbl oe_order_pub.line_tbl_type; l_action_request_tbl oe_order_pub.Request_Tbl_Type; — OUT Variables — l_header_rec_out oe_order_pub.header_rec_type; l_header_val_rec_out oe_order_pub.header_val_rec_type; l_header_adj_tbl_out oe_order_pub.header_adj_tbl_type; l_header_adj_val_tbl_out oe_order_pub.header_adj_val_tbl_type; l_header_price_att_tbl_out oe_order_pub.header_price_att_tbl_type;…

  • OE_ORDER_PUB: Create and Book Sales Order

    Create and Book Sales Order set serveroutput on; DECLARE l_api_version_number NUMBER := 1; l_return_status VARCHAR2(2000); l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_debug_level NUMBER := 1; — OM DEBUG LEVEL (MAX 5) — IN Variables — l_header_rec oe_order_pub.header_rec_type; l_line_tbl oe_order_pub.line_tbl_type; l_action_request_tbl oe_order_pub.Request_Tbl_Type; — OUT Variables — l_header_rec_out oe_order_pub.header_rec_type; l_header_val_rec_out oe_order_pub.header_val_rec_type; l_header_adj_tbl_out oe_order_pub.header_adj_tbl_type; l_header_adj_val_tbl_out oe_order_pub.header_adj_val_tbl_type; l_header_price_att_tbl_out oe_order_pub.header_price_att_tbl_type; l_header_adj_att_tbl_out oe_order_pub.header_adj_att_tbl_type;…

  • OE_ORDER_PUB: Create Sales Order in Entered Status

    set serveroutput on; DECLARE l_api_version_number NUMBER := 1; l_return_status VARCHAR2(2000); l_msg_count NUMBER; l_msg_data VARCHAR2(2000); l_debug_level NUMBER := 1; — OM DEBUG LEVEL (MAX 5) — IN Variables — l_header_rec oe_order_pub.header_rec_type; l_line_tbl oe_order_pub.line_tbl_type; l_action_request_tbl oe_order_pub.Request_Tbl_Type; — OUT Variables — l_header_rec_out oe_order_pub.header_rec_type; l_header_val_rec_out oe_order_pub.header_val_rec_type; l_header_adj_tbl_out oe_order_pub.header_adj_tbl_type; l_header_adj_val_tbl_out oe_order_pub.header_adj_val_tbl_type; l_header_price_att_tbl_out oe_order_pub.header_price_att_tbl_type; l_header_adj_att_tbl_out oe_order_pub.header_adj_att_tbl_type; l_header_adj_assoc_tbl_out oe_order_pub.header_adj_assoc_tbl_type; l_header_scredit_tbl_out oe_order_pub.header_scredit_tbl_type; l_header_scredit_val_tbl_out…

  • API: FND_USER_PKG: Create User,reset Password and add Responsibilities

    1) API to create FND User BEGIN fnd_user_pkg.CreateUser ( x_user_name => ‘Operations’, x_owner => NULL, x_unencrypted_password =>’welcome1′, x_start_date => TO_DATE(’01-JAN-2000′), x_end_date => NULL, x_last_logon_date => NULL, x_description => ‘Operations User’, x_password_date => NULL, x_password_accesses_left => NULL, x_employee_id => NULL, x_email_address => NULL, x_fax => NULL, x_customer_id => NULL, x_supplier_id => NULL); COMMIT; END; 2) API…

  • API: Concurrent Program and Request Group related

    1) API to create concurrent program executable BEGIN fnd_program.executable( ‘Test User Executable’ –User Executable Name ,’System Administration’ –Application Name ,’TEST_SHORT_EXEC’ –Short Name ,’Test Executable Creation’ –Description ,’PL/SQL Stored Procedure’ –Execution Method ,’test_pkg.test_proc’ ,” — subroutine_name ,” –icon_name ,’US’ –language_code ,” –execution file path ); COMMIT; END; 2) API to create or register concurrent program for…