DBA Data[Home] [Help]

APPS.PAY_INTERPRETER_PKG dependencies on PAY_PROCESS_EVENTS

Line 177: surrogate_key pay_process_events.surrogate_key%type ,

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),

Line 185: change_mode pay_process_events.change_type%type,--'DATE_PROCESSED' etc

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:

Line 263: process_event_id pay_process_events.process_event_id%TYPE

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:

Line 446: effective_date pay_process_events.effective_date%type,

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,

Line 447: assignment_id pay_process_events.assignment_id%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,

Line 448: surrogate_key pay_process_events.surrogate_key%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,

Line 449: process_event_id pay_process_events.surrogate_key%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,

Line 450: change_values pay_process_events.description%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

Line 451: calculation_date pay_process_events.calculation_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
455: );

Line 452: creation_date pay_process_events.creation_date%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: );
456:

Line 453: change_mode pay_process_events.change_type%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:
457: --used in extra_tests_dbt_i and extra_tests_dbt_p

Line 461: min_date pay_process_events.creation_date%type,

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

Line 462: max_date pay_process_events.creation_date%type,

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;