eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_PROCESS_HEADER dependencies on XLA_EVENTS

Line 413: l_event_source_info xla_events_pub_pkg.t_event_source_info;

409: l_status5 varchar2(100);
410: l_status6 varchar2(100);
411: l_status7 varchar2(100);
412:
413: l_event_source_info xla_events_pub_pkg.t_event_source_info;
414: l_security xla_events_pub_pkg.t_security;
415: l_event_id NUMBER;
416:
417:

Line 414: l_security xla_events_pub_pkg.t_security;

410: l_status6 varchar2(100);
411: l_status7 varchar2(100);
412:
413: l_event_source_info xla_events_pub_pkg.t_event_source_info;
414: l_security xla_events_pub_pkg.t_security;
415: l_event_id NUMBER;
416:
417:
418: CURSOR c_ct IS

Line 430: (Select 1 from xla_events

426: and gld.posting_control_id = -3
427: and gld.account_set_flag = 'N'
428: AND gld.event_id is not null
429: AND exists
430: (Select 1 from xla_events
431: where entity_id in (
432: Select entity_id from xla_transaction_entities
433: where entity_code = 'TRANSACTIONS'
434: and nvl(source_id_int_1 , -99) = ra.customer_trx_id

Line 459: xla_events_pub_pkg.delete_event

455: l_event_source_info.application_id := 222;
456: l_event_source_info.ledger_id := arp_standard.sysparm.set_of_books_id;
457: l_event_source_info.source_id_int_1 := p_customer_trx_id;
458:
459: xla_events_pub_pkg.delete_event
460: ( p_event_source_info => l_event_source_info,
461: p_event_id => l_event_id,
462: p_valuation_method => NULL,
463: p_security_context => l_security);

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

777:
778: BEGIN
779:
780: --6870437
781: ARP_XLA_EVENTS.delete_reverse_revrec_event( p_document_id => p_customer_trx_id,
782: p_doc_table => 'CT');
783:
784: arp_ctlgd_pkg.delete_f_ct_id(p_customer_trx_id,
785: 'N',

Line 886: l_ev_rec arp_xla_events.xla_events_type;

882: l_trx_rec ra_customer_trx%rowtype;
883: l_status1 varchar2(100);
884: l_status2 varchar2(100);
885: --Bug# 2750340
886: l_ev_rec arp_xla_events.xla_events_type;
887:
888: /* bug 3609567 */
889: l_error_message VARCHAR2(128) := '';
890: l_dist_count NUMBER;

Line 1075: -- Bug# 2750340 : Call AR_XLA_EVENTS

1071: THEN p_status := l_status2;
1072: ELSE p_status := 'OK';
1073: END IF;
1074:
1075: -- Bug# 2750340 : Call AR_XLA_EVENTS
1076: ------------------------------------------------------------
1077: -- This call to ARP_XLA_EVENT is required when
1078: -- user creates a document through the transaction Workbench
1079: ------------------------------------------------------------

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

1085: l_ev_rec.xla_doc_event := NULL;
1086: l_ev_rec.xla_mode := 'O';
1087: l_ev_rec.xla_call := 'B';
1088: l_ev_rec.xla_fetch_size := 999;
1089: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1090:
1091: arp_util.debug('arp_process_header.insert_header()-');
1092:
1093: EXCEPTION

Line 1182: l_ev_rec arp_xla_events.xla_events_type;

1178: l_status2 varchar2(100);
1179: l_status3 varchar2(100);
1180:
1181: --Bug# 2750340
1182: l_ev_rec arp_xla_events.xla_events_type;
1183:
1184: --BUG#5192414
1185: CURSOR cpost IS
1186: SELECT 'Y'

Line 1193: l_event_source_info xla_events_pub_pkg.t_event_source_info;

1189: AND posting_control_id <> -3
1190: AND account_set_flag = 'N';
1191: l_test VARCHAR2(1);
1192: --BUG#7366912
1193: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1194: l_event_id NUMBER;
1195: l_security xla_events_pub_pkg.t_security;
1196: l_post_to_gl varchar2(100);
1197: l_event_status_code varchar2(100);

Line 1195: l_security xla_events_pub_pkg.t_security;

1191: l_test VARCHAR2(1);
1192: --BUG#7366912
1193: l_event_source_info xla_events_pub_pkg.t_event_source_info;
1194: l_event_id NUMBER;
1195: l_security xla_events_pub_pkg.t_security;
1196: l_post_to_gl varchar2(100);
1197: l_event_status_code varchar2(100);
1198: BEGIN
1199:

Line 1750: xla_events xe

1746: from
1747: ra_customer_trx ct ,
1748: ra_cust_trx_types ctt,
1749: xla_transaction_entities_upg xet ,
1750: xla_events xe
1751: where ct.customer_trx_id = p_customer_trx_id
1752: and ctt.cust_trx_type_id = ct.cust_trx_type_id
1753: and ct.customer_trx_id = nvl(xet.source_id_int_1,-99)
1754: AND ct.SET_OF_BOOKS_ID = xet.LEDGER_ID

Line 1763: xla_events_pub_pkg.delete_event

1759:
1760: IF ((l_post_to_gl ='N')
1761: AND (l_event_status_code = 'I')) THEN
1762:
1763: xla_events_pub_pkg.delete_event
1764: ( p_event_source_info => l_event_source_info,
1765: p_event_id => l_event_id,
1766: p_valuation_method => NULL,
1767: p_security_context => l_security);

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

1781: END IF;
1782:
1783: --Bug# 2750340
1784: ---------------------------------------------------------
1785: -- Call to ARP_XLA_EVENTS for transaction updation in
1786: -- Trx Workbench. Mandatory when user complete a document
1787: ---------------------------------------------------------
1788: l_ev_rec.xla_from_doc_id := p_customer_trx_id;
1789: l_ev_rec.xla_to_doc_id := p_customer_trx_id;

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

1793: l_ev_rec.xla_doc_event := NULL;
1794: l_ev_rec.xla_mode := 'O';
1795: l_ev_rec.xla_call := 'B';
1796: l_ev_rec.xla_fetch_size := 999;
1797: arp_xla_events.create_events(p_xla_ev_rec => l_ev_rec );
1798:
1799: END IF;
1800: CLOSE cpost;
1801:

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

1947: --Bug # 6450286
1948: --------------------------------
1949: -- Delete the corresponding event in XLA schema
1950: --------------------------------
1951: ARP_XLA_EVENTS.delete_event( p_document_id => p_customer_trx_id,
1952: p_doc_table => 'CT');
1953:
1954: --added for bug 7478499
1955: delete_cont_defer_data(p_customer_trx_id);