APPS.IGC_CBC_GL_FC_PKG dependencies on XLA_EVENTS

Line 355: from xla_events xla

351:
352: CURSOR c_event_details
353: is
354: Select event_id, application_id, event_type_code, event_status_code, entity_id
355: from xla_events xla
356: where xla.event_id in
357: (
358: Select psa.event_id
359: from psa_bc_xla_events_gt psa

Line 359: from psa_bc_xla_events_gt psa

355: from xla_events xla
356: where xla.event_id in
357: (
358: Select psa.event_id
359: from psa_bc_xla_events_gt psa
360: )
361: and application_id = 201;
362:
363: TYPE t_event_details IS TABLE OF c_event_details%ROWTYPE index by PLS_INTEGER;

Line 391: SELECT event_id,result_code from psa_bc_xla_events_gt;

387: l_user_id NUMBER;
388: l_rec_count NUMBER;
389:
390: cursor c_psa_events is
391: SELECT event_id,result_code from psa_bc_xla_events_gt;
392: Type tbl_psa_event is TABLE OF c_psa_events%ROWTYPE INDEX BY PLS_INTEGER;
393: l_tbl_psa_event tbl_psa_event;
394:
395: l_cbc_mode VARCHAR2(1) ;

Line 434: delete from psa_bc_xla_events_gt;

430: FETCH c_event_details
431: BULK COLLECT INTO l_event_details;
432: CLOSE c_event_details;
433:
434: delete from psa_bc_xla_events_gt;
435:
436: -- nvl(l_event_details.LAST,0)
437: FOR i_evt in 1..nvl(l_event_details.LAST,0)
438: LOOP

Line 825: INSERT INTO psa_bc_xla_events_gt(event_id,result_code )

821: END LOOP;
822:
823: FOR Idx IN l_tbl_psa_event.FIRST .. l_tbl_psa_event.LAST
824: LOOP
825: INSERT INTO psa_bc_xla_events_gt(event_id,result_code )
826: VALUES
827: (l_tbl_psa_event(Idx).event_id,l_tbl_psa_event(Idx).result_code );
828: END LOOP;
829: