APPS.PAY_PRG_PROCESS_EVENTS dependencies on PAY_PROCESS_EVENTS

Line 275: l_table_name varchar2(30) := 'PAY_PROCESS_EVENTS';

271:
272: l_module constant varchar2(90) := 'PAY_PRG_PROCESS_EVENTS.Purge_process_events_PAY_WKR';
273: l_worker_id number;
274: l_product varchar2(30);
275: l_table_name varchar2(30) := 'PAY_PROCESS_EVENTS';
276: l_id_column varchar2(30) := 'ASSIGNMENT_ID';
277: l_update_name varchar2(30);
278:
279: l_table_owner varchar2(30);

Line 425: -- Function : To purge data from pay_process_events table and archive it deleted

421:
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

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 462: type ppe_t is table of PAY_PROCESS_EVENTS%ROWTYPE index by binary_integer;

458: lv_bulk_limit number;
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;

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 464: type process_event_t is table of PAY_PROCESS_EVENTS.PROCESS_EVENT_ID%TYPE index by binary_integer;

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;
468: process_event_rec process_event_t;

Line 473: from pay_process_events ppe

469:
470: /* Cursor that defines what data to purge and archive */
471: cursor get_archive_events is
472: select ppe.*
473: from pay_process_events ppe
474: where ppe.creation_date < fnd_date.canonical_to_date(p_purge_date)
475: and ppe.assignment_id between x_start_id and x_end_id
476: and (not exists
477: (select 1

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

Line 550: delete from PAY_PROCESS_EVENTS

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
551: where process_event_id = process_event_rec(x);
552:
553: exit when get_archive_events%notfound;
554: commit;