DBA Data[Home] [Help]

APPS.ARP_PROCESS_HEADER dependencies on XLA_EVENTS

Line 724: ARP_XLA_EVENTS.delete_reverse_revrec_event( p_document_id => p_customer_trx_id,

720:
721: BEGIN
722:
723: --6870437
724: ARP_XLA_EVENTS.delete_reverse_revrec_event( p_document_id => p_customer_trx_id,
725: p_doc_table => 'CT');
726:
727: arp_ctlgd_pkg.delete_f_ct_id(p_customer_trx_id,
728: 'N',

Line 829: l_ev_rec arp_xla_events.xla_events_type;

825: l_trx_rec ra_customer_trx%rowtype;
826: l_status1 varchar2(100);
827: l_status2 varchar2(100);
828: --Bug# 2750340
829: l_ev_rec arp_xla_events.xla_events_type;
830:
831: /* bug 3609567 */
832: l_error_message VARCHAR2(128) := '';
833: l_dist_count NUMBER;

Line 1018: -- Bug# 2750340 : Call AR_XLA_EVENTS

1014: THEN p_status := l_status2;
1015: ELSE p_status := 'OK';
1016: END IF;
1017:
1018: -- Bug# 2750340 : Call AR_XLA_EVENTS
1019: ------------------------------------------------------------
1020: -- This call to ARP_XLA_EVENT is required when
1021: -- user creates a document through the transaction Workbench
1022: ------------------------------------------------------------

Line 1032: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );

1028: l_ev_rec.xla_doc_event := NULL;
1029: l_ev_rec.xla_mode := 'O';
1030: l_ev_rec.xla_call := 'B';
1031: l_ev_rec.xla_fetch_size := 999;
1032: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1033:
1034: arp_util.debug('arp_process_header.insert_header()-');
1035:
1036: EXCEPTION

Line 1125: l_ev_rec arp_xla_events.xla_events_type;

1121: l_status2 varchar2(100);
1122: l_status3 varchar2(100);
1123:
1124: --Bug# 2750340
1125: l_ev_rec arp_xla_events.xla_events_type;
1126:
1127: --BUG#5192414
1128: CURSOR cpost IS
1129: SELECT 'Y'

Line 1136: l_event_source_info xla_events_pub_pkg.t_event_source_info;

1132: AND posting_control_id <> -3
1133: AND account_set_flag = 'N';
1134: l_test VARCHAR2(1);
1135: --BUG#7366912
1136: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1137: l_event_id NUMBER;
1138: l_security xla_events_pub_pkg.t_security;
1139: l_post_to_gl varchar2(100);
1140: l_event_status_code varchar2(100);

Line 1138: l_security xla_events_pub_pkg.t_security;

1134: l_test VARCHAR2(1);
1135: --BUG#7366912
1136: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1137: l_event_id NUMBER;
1138: l_security xla_events_pub_pkg.t_security;
1139: l_post_to_gl varchar2(100);
1140: l_event_status_code varchar2(100);
1141: BEGIN
1142:

Line 1670: xla_events xe

1666: from
1667: ra_customer_trx ct ,
1668: ra_cust_trx_types ctt,
1669: xla_transaction_entities_upg xet ,
1670: xla_events xe
1671: where ct.customer_trx_id = p_customer_trx_id
1672: and ctt.cust_trx_type_id = ct.cust_trx_type_id
1673: and ct.customer_trx_id = nvl(xet.source_id_int_1,-99)
1674: AND ct.SET_OF_BOOKS_ID = xet.LEDGER_ID

Line 1683: xla_events_pub_pkg.delete_event

1679:
1680: IF ((l_post_to_gl ='N')
1681: AND (l_event_status_code = 'I')) THEN
1682:
1683: xla_events_pub_pkg.delete_event
1684: ( p_event_source_info => l_event_source_info,
1685: p_event_id => l_event_id,
1686: p_valuation_method => NULL,
1687: p_security_context => l_security);

Line 1705: -- Call to ARP_XLA_EVENTS for transaction updation in

1701: END IF;
1702:
1703: --Bug# 2750340
1704: ---------------------------------------------------------
1705: -- Call to ARP_XLA_EVENTS for transaction updation in
1706: -- Trx Workbench. Mandatory when user complete a document
1707: ---------------------------------------------------------
1708: l_ev_rec.xla_from_doc_id := p_customer_trx_id;
1709: l_ev_rec.xla_to_doc_id := p_customer_trx_id;

Line 1717: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );

1713: l_ev_rec.xla_doc_event := NULL;
1714: l_ev_rec.xla_mode := 'O';
1715: l_ev_rec.xla_call := 'B';
1716: l_ev_rec.xla_fetch_size := 999;
1717: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1718:
1719: END IF;
1720: CLOSE cpost;
1721:

Line 1871: ARP_XLA_EVENTS.delete_event( p_document_id => p_customer_trx_id,

1867: --Bug # 6450286
1868: --------------------------------
1869: -- Delete the corresponding event in XLA schema
1870: --------------------------------
1871: ARP_XLA_EVENTS.delete_event( p_document_id => p_customer_trx_id,
1872: p_doc_table => 'CT');
1873:
1874: --added for bug 7478499
1875: delete_cont_defer_data(p_customer_trx_id);