DBA Data[Home] [Help]

APPS.PAY_INTERPRETER_PKG dependencies on PAY_PROCESS_EVENTS

Line 161: surrogate_key pay_process_events.surrogate_key%type ,

157: (
158: dated_table_id pay_dated_tables.dated_table_id%TYPE ,
159: datetracked_event pay_datetracked_events.datetracked_event_id%TYPE ,
160: update_type pay_datetracked_events.update_type%TYPE ,
161: surrogate_key pay_process_events.surrogate_key%type ,
162: column_name pay_event_updates.column_name%TYPE ,
163: effective_date date,
164: creation_date date,
165: old_value varchar2(2000),

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

165: old_value varchar2(2000),
166: new_value varchar2(2000),
167: change_values varchar2(2000),
168: proration_type varchar2(10),
169: change_mode pay_process_events.change_type%type,--'DATE_PROCESSED' etc
170: element_entry_id pay_element_entries_f.element_entry_id%type,
171: next_ee number
172: );
173:

Line 247: process_event_id pay_process_events.process_event_id%TYPE

243: t_proration_group_tab t_proration_group_table ;
244:
245: TYPE t_process_event_rec IS RECORD
246: (
247: process_event_id pay_process_events.process_event_id%TYPE
248: );
249:
250: TYPE t_process_event_table IS TABLE OF t_process_event_rec;
251:

Line 430: effective_date pay_process_events.effective_date%type,

426: (
427: updated_column_name pay_event_updates.column_name%type,
428: event_type pay_event_updates.event_type%type,
429: event_update_id pay_event_updates.event_update_id%type,
430: effective_date pay_process_events.effective_date%type,
431: assignment_id pay_process_events.assignment_id%type,
432: surrogate_key pay_process_events.surrogate_key%type,
433: process_event_id pay_process_events.surrogate_key%type,
434: change_values pay_process_events.description%type,

Line 431: assignment_id pay_process_events.assignment_id%type,

427: updated_column_name pay_event_updates.column_name%type,
428: event_type pay_event_updates.event_type%type,
429: event_update_id pay_event_updates.event_update_id%type,
430: effective_date pay_process_events.effective_date%type,
431: assignment_id pay_process_events.assignment_id%type,
432: surrogate_key pay_process_events.surrogate_key%type,
433: process_event_id pay_process_events.surrogate_key%type,
434: change_values pay_process_events.description%type,
435: calculation_date pay_process_events.calculation_date%type,

Line 432: surrogate_key pay_process_events.surrogate_key%type,

428: event_type pay_event_updates.event_type%type,
429: event_update_id pay_event_updates.event_update_id%type,
430: effective_date pay_process_events.effective_date%type,
431: assignment_id pay_process_events.assignment_id%type,
432: surrogate_key pay_process_events.surrogate_key%type,
433: process_event_id pay_process_events.surrogate_key%type,
434: change_values pay_process_events.description%type,
435: calculation_date pay_process_events.calculation_date%type,
436: creation_date pay_process_events.creation_date%type,

Line 433: process_event_id pay_process_events.surrogate_key%type,

429: event_update_id pay_event_updates.event_update_id%type,
430: effective_date pay_process_events.effective_date%type,
431: assignment_id pay_process_events.assignment_id%type,
432: surrogate_key pay_process_events.surrogate_key%type,
433: process_event_id pay_process_events.surrogate_key%type,
434: change_values pay_process_events.description%type,
435: calculation_date pay_process_events.calculation_date%type,
436: creation_date pay_process_events.creation_date%type,
437: change_mode pay_process_events.change_type%type,

Line 434: change_values pay_process_events.description%type,

430: effective_date pay_process_events.effective_date%type,
431: assignment_id pay_process_events.assignment_id%type,
432: surrogate_key pay_process_events.surrogate_key%type,
433: process_event_id pay_process_events.surrogate_key%type,
434: change_values pay_process_events.description%type,
435: calculation_date pay_process_events.calculation_date%type,
436: creation_date pay_process_events.creation_date%type,
437: change_mode pay_process_events.change_type%type,
438: table_name pay_dated_tables.table_name%TYPE

Line 435: calculation_date pay_process_events.calculation_date%type,

431: assignment_id pay_process_events.assignment_id%type,
432: surrogate_key pay_process_events.surrogate_key%type,
433: process_event_id pay_process_events.surrogate_key%type,
434: change_values pay_process_events.description%type,
435: calculation_date pay_process_events.calculation_date%type,
436: creation_date pay_process_events.creation_date%type,
437: change_mode pay_process_events.change_type%type,
438: table_name pay_dated_tables.table_name%TYPE
439: );

Line 436: creation_date pay_process_events.creation_date%type,

432: surrogate_key pay_process_events.surrogate_key%type,
433: process_event_id pay_process_events.surrogate_key%type,
434: change_values pay_process_events.description%type,
435: calculation_date pay_process_events.calculation_date%type,
436: creation_date pay_process_events.creation_date%type,
437: change_mode pay_process_events.change_type%type,
438: table_name pay_dated_tables.table_name%TYPE
439: );
440:

Line 437: change_mode pay_process_events.change_type%type,

433: process_event_id pay_process_events.surrogate_key%type,
434: change_values pay_process_events.description%type,
435: calculation_date pay_process_events.calculation_date%type,
436: creation_date pay_process_events.creation_date%type,
437: change_mode pay_process_events.change_type%type,
438: table_name pay_dated_tables.table_name%TYPE
439: );
440:
441: --used in extra_tests_dbt_i and extra_tests_dbt_p

Line 445: min_date pay_process_events.creation_date%type,

441: --used in extra_tests_dbt_i and extra_tests_dbt_p
442: TYPE t_key_date_cache_rec is record
443: (
444: key varchar2(240),
445: min_date pay_process_events.creation_date%type,
446: max_date pay_process_events.creation_date%type,
447: got_flag varchar2(15) default 'N'
448: );
449: TYPE t_key_date_cache is

Line 446: max_date pay_process_events.creation_date%type,

442: TYPE t_key_date_cache_rec is record
443: (
444: key varchar2(240),
445: min_date pay_process_events.creation_date%type,
446: max_date pay_process_events.creation_date%type,
447: got_flag varchar2(15) default 'N'
448: );
449: TYPE t_key_date_cache is
450: table of t_key_date_cache_rec INDEX BY BINARY_INTEGER;