DBA Data[Home] [Help]

APPS.ARP_PROCESS_RCTS dependencies on XLA_EVENTS

Line 306: l_event_source_info xla_events_pub_pkg.t_event_source_info;

302: 2);
303:
304: /* Bug 4173339 */
305: l_trx_sum_hist_rec AR_TRX_SUMMARY_HIST%rowtype;
306: l_event_source_info xla_events_pub_pkg.t_event_source_info;
307: l_security xla_events_pub_pkg.t_security;
308: l_event_id NUMBER;
309:
310: CURSOR get_app_ev is

Line 307: l_security xla_events_pub_pkg.t_security;

303:
304: /* Bug 4173339 */
305: l_trx_sum_hist_rec AR_TRX_SUMMARY_HIST%rowtype;
306: l_event_source_info xla_events_pub_pkg.t_event_source_info;
307: l_security xla_events_pub_pkg.t_security;
308: l_event_id NUMBER;
309:
310: CURSOR get_app_ev is
311: select distinct ra.event_id event_id , ra.cash_receipt_id cash_receipt_id from

Line 316: ( select 'x' from xla_events where event_id = ra.event_id

312: ar_receivable_applications ra where ra.cash_receipt_id = p_cash_receipt_id
313: and ra.status not in ('UNAPP','UNID')
314: and ra.event_id is not null
315: and exists
316: ( select 'x' from xla_events where event_id = ra.event_id
317: and application_id = 222 ) ;
318:
319:
320: CURSOR get_existing_ps IS

Line 417: ARP_XLA_EVENTS.delete_event( p_document_id => p_cash_receipt_id,

413: --Bug # 6450286
414: --------------------------------
415: -- Delete the corresponding event in XLA schema
416: --------------------------------
417: ARP_XLA_EVENTS.delete_event( p_document_id => p_cash_receipt_id,
418: p_doc_table => 'CRH');
419:
420:
421: -- delete all AR_CASH_RECEIPT_HISTORY records created for this

Line 458: xla_events_pub_pkg.delete_event

454: l_event_source_info.application_id := 222;
455: l_event_source_info.ledger_id := arp_standard.sysparm.set_of_books_id; --to be set
456: l_event_source_info.source_id_int_1 := l_get_ev.cash_receipt_id ;
457:
458: xla_events_pub_pkg.delete_event
459: ( p_event_source_info => l_event_source_info,
460: p_event_id => l_event_id,
461: p_valuation_method => NULL,
462: p_security_context => l_security);