173: (
174: dated_table_id pay_dated_tables.dated_table_id%TYPE ,
175: datetracked_event pay_datetracked_events.datetracked_event_id%TYPE ,
176: update_type pay_datetracked_events.update_type%TYPE ,
177: surrogate_key pay_process_events.surrogate_key%type ,
178: column_name pay_event_updates.column_name%TYPE ,
179: effective_date date,
180: creation_date date,
181: old_value varchar2(2000),
181: old_value varchar2(2000),
182: new_value varchar2(2000),
183: change_values varchar2(2000),
184: proration_type varchar2(10),
185: change_mode pay_process_events.change_type%type,--'DATE_PROCESSED' etc
186: element_entry_id pay_element_entries_f.element_entry_id%type,
187: next_ee number
188: );
189:
259: t_proration_group_tab t_proration_group_table ;
260:
261: TYPE t_process_event_rec IS RECORD
262: (
263: process_event_id pay_process_events.process_event_id%TYPE
264: );
265:
266: TYPE t_process_event_table IS TABLE OF t_process_event_rec;
267:
442: (
443: updated_column_name pay_event_updates.column_name%type,
444: event_type pay_event_updates.event_type%type,
445: event_update_id pay_event_updates.event_update_id%type,
446: effective_date pay_process_events.effective_date%type,
447: assignment_id pay_process_events.assignment_id%type,
448: surrogate_key pay_process_events.surrogate_key%type,
449: process_event_id pay_process_events.surrogate_key%type,
450: change_values pay_process_events.description%type,
443: updated_column_name pay_event_updates.column_name%type,
444: event_type pay_event_updates.event_type%type,
445: event_update_id pay_event_updates.event_update_id%type,
446: effective_date pay_process_events.effective_date%type,
447: assignment_id pay_process_events.assignment_id%type,
448: surrogate_key pay_process_events.surrogate_key%type,
449: process_event_id pay_process_events.surrogate_key%type,
450: change_values pay_process_events.description%type,
451: calculation_date pay_process_events.calculation_date%type,
444: event_type pay_event_updates.event_type%type,
445: event_update_id pay_event_updates.event_update_id%type,
446: effective_date pay_process_events.effective_date%type,
447: assignment_id pay_process_events.assignment_id%type,
448: surrogate_key pay_process_events.surrogate_key%type,
449: process_event_id pay_process_events.surrogate_key%type,
450: change_values pay_process_events.description%type,
451: calculation_date pay_process_events.calculation_date%type,
452: creation_date pay_process_events.creation_date%type,
445: event_update_id pay_event_updates.event_update_id%type,
446: effective_date pay_process_events.effective_date%type,
447: assignment_id pay_process_events.assignment_id%type,
448: surrogate_key pay_process_events.surrogate_key%type,
449: process_event_id pay_process_events.surrogate_key%type,
450: change_values pay_process_events.description%type,
451: calculation_date pay_process_events.calculation_date%type,
452: creation_date pay_process_events.creation_date%type,
453: change_mode pay_process_events.change_type%type,
446: effective_date pay_process_events.effective_date%type,
447: assignment_id pay_process_events.assignment_id%type,
448: surrogate_key pay_process_events.surrogate_key%type,
449: process_event_id pay_process_events.surrogate_key%type,
450: change_values pay_process_events.description%type,
451: calculation_date pay_process_events.calculation_date%type,
452: creation_date pay_process_events.creation_date%type,
453: change_mode pay_process_events.change_type%type,
454: table_name pay_dated_tables.table_name%TYPE
447: assignment_id pay_process_events.assignment_id%type,
448: surrogate_key pay_process_events.surrogate_key%type,
449: process_event_id pay_process_events.surrogate_key%type,
450: change_values pay_process_events.description%type,
451: calculation_date pay_process_events.calculation_date%type,
452: creation_date pay_process_events.creation_date%type,
453: change_mode pay_process_events.change_type%type,
454: table_name pay_dated_tables.table_name%TYPE
455: );
448: surrogate_key pay_process_events.surrogate_key%type,
449: process_event_id pay_process_events.surrogate_key%type,
450: change_values pay_process_events.description%type,
451: calculation_date pay_process_events.calculation_date%type,
452: creation_date pay_process_events.creation_date%type,
453: change_mode pay_process_events.change_type%type,
454: table_name pay_dated_tables.table_name%TYPE
455: );
456:
449: process_event_id pay_process_events.surrogate_key%type,
450: change_values pay_process_events.description%type,
451: calculation_date pay_process_events.calculation_date%type,
452: creation_date pay_process_events.creation_date%type,
453: change_mode pay_process_events.change_type%type,
454: table_name pay_dated_tables.table_name%TYPE
455: );
456:
457: --used in extra_tests_dbt_i and extra_tests_dbt_p
457: --used in extra_tests_dbt_i and extra_tests_dbt_p
458: TYPE t_key_date_cache_rec is record
459: (
460: key varchar2(240),
461: min_date pay_process_events.creation_date%type,
462: max_date pay_process_events.creation_date%type,
463: got_flag varchar2(15) default 'N'
464: );
465: TYPE t_key_date_cache is
458: TYPE t_key_date_cache_rec is record
459: (
460: key varchar2(240),
461: min_date pay_process_events.creation_date%type,
462: max_date pay_process_events.creation_date%type,
463: got_flag varchar2(15) default 'N'
464: );
465: TYPE t_key_date_cache is
466: table of t_key_date_cache_rec INDEX BY BINARY_INTEGER;