APPS.PAY_PRG_PROCESS_EVENTS dependencies on PAY_PROCESS_EVENTS_SHADOW

Line 426: -- deleted data into pay_process_events_shadow table.

422: -------------------------------------------------------------------------------------
423: -- Name : Purge_process_events
424: -- Type : Private
425: -- Function : To purge data from pay_process_events table and archive it deleted
426: -- deleted data into pay_process_events_shadow table.
427: -- Pre-reqs :
428: -- Parameters :
429: -- IN : p_purge_date
430: -- p_debug_flag

Line 463: type ppes_t is table of PAY_PROCESS_EVENTS_SHADOW%ROWTYPE index by binary_integer;

459: lv_param_found boolean default FALSE;
460:
461:
462: type ppe_t is table of PAY_PROCESS_EVENTS%ROWTYPE index by binary_integer;
463: type ppes_t is table of PAY_PROCESS_EVENTS_SHADOW%ROWTYPE index by binary_integer;
464: type process_event_t is table of PAY_PROCESS_EVENTS.PROCESS_EVENT_ID%TYPE index by binary_integer;
465:
466: ppe_table_rec ppe_t;
467: ppes_table_rec ppes_t;

Line 546: insert into PAY_PROCESS_EVENTS_SHADOW

542:
543: END LOOP;
544:
545: forall x in 1 .. ppe_table_rec.count
546: insert into PAY_PROCESS_EVENTS_SHADOW
547: values ppes_table_rec(x);
548:
549: forall x in 1 .. process_event_rec.count
550: delete from PAY_PROCESS_EVENTS