-
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 :=…
-
API: Update event status code in XLA_EVENTS
— Created by Prudhvi DECLARE p_event_source_info xla_events_pub_pkg.t_event_source_info; BEGIN p_event_source_info.source_application_id := NULL; p_event_source_info.application_id := 222; — AR p_event_source_info.legal_entity_id := 12340; — change it p_event_source_info.ledger_id := 1; — change it p_event_source_info.entity_type_code := ‘TRANSACTIONS’; p_event_source_info.transaction_number := ‘1234’; — change it p_event_source_info.source_id_int_1 := 1234; –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…
-
API: ARP_NOTES_PKG
API: ARP_NOTES_PKG.insert_p to create new AR Notes DECLARE v_notes_rec ar_notes%rowtype; begin –Set the org_id for apps 11i –fnd_client_info.set_org_context(‘204’); — set org_id for apps R12 mo_global.init(‘AR’); mo_global.set_policy_context(‘S’,’204′); — to initialize the variables v_notes_rec.note_type := ‘MAINTAIN’; v_notes_rec.customer_trx_id := 759812; v_notes_rec.text := ‘AR Notes API Demo form erpSchools.com’; v_notes_rec.customer_call_topic_id := NULL; v_notes_rec.call_action_id := NULL; v_notes_rec.customer_call_id := NULL;…
-
Trading Community Architecture (TCA) API
Overview: Trading Community Architecture (TCA) is an architecture concept designed to support complex trading communities. This document provides information about how to create a customer using TCA API. These APIs utilize the new TCA model, inserting directly to the HZ tables. Architecture Create Organization DECLARE p_organization_rec hz_party_v2pub.organization_rec_type; x_return_status VARCHAR2 (2000); x_msg_count NUMBER; x_msg_data VARCHAR2 (2000); x_party_id NUMBER; x_party_number VARCHAR2 (2000); x_profile_id NUMBER; BEGIN p_organization_rec.organization_name := ‘erpschools’;…