APPS.IGC_CBC_GL_FC_PKG dependencies on PSA_BC_XLA_EVENTS_GT

Line 349: from psa_bc_xla_events_gt psa

345: from xla_events xla
346: where xla.event_id in
347: (
348: Select psa.event_id
349: from psa_bc_xla_events_gt psa
350: )
351: and application_id = 201;
352:
353: TYPE t_event_details IS TABLE OF c_event_details%ROWTYPE index by PLS_INTEGER;

Line 381: SELECT event_id,result_code from psa_bc_xla_events_gt;

377: l_user_id NUMBER;
378: l_rec_count NUMBER;
379:
380: cursor c_psa_events is
381: SELECT event_id,result_code from psa_bc_xla_events_gt;
382: Type tbl_psa_event is TABLE OF c_psa_events%ROWTYPE INDEX BY PLS_INTEGER;
383: l_tbl_psa_event tbl_psa_event;
384:
385: l_cbc_mode VARCHAR2(1) ;

Line 423: delete from psa_bc_xla_events_gt;

419: FETCH c_event_details
420: BULK COLLECT INTO l_event_details;
421: CLOSE c_event_details;
422:
423: delete from psa_bc_xla_events_gt;
424:
425: -- nvl(l_event_details.LAST,0)
426: FOR i_evt in 1..nvl(l_event_details.LAST,0)
427: LOOP

Line 796: INSERT INTO psa_bc_xla_events_gt(event_id,result_code )

792: END LOOP;
793:
794: FOR Idx IN l_tbl_psa_event.FIRST .. l_tbl_psa_event.LAST
795: LOOP
796: INSERT INTO psa_bc_xla_events_gt(event_id,result_code )
797: VALUES
798: (l_tbl_psa_event(Idx).event_id,l_tbl_psa_event(Idx).result_code );
799: END LOOP;
800: