APPS.PAY_INTERPRETER_PKG dependencies on PAY_DATETRACKED_EVENTS

Line 146: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,

142: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,
143: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,
144: start_date_name pay_dated_tables.start_date_name%TYPE ,
145: end_date_name pay_dated_tables.end_date_name%TYPE ,
146: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,
147: column_name pay_datetracked_events.column_name%TYPE ,
148: update_type pay_datetracked_events.update_type%TYPE ,
149: proration_type pay_datetracked_events.proration_style%TYPE
150: );

Line 147: column_name pay_datetracked_events.column_name%TYPE ,

143: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,
144: start_date_name pay_dated_tables.start_date_name%TYPE ,
145: end_date_name pay_dated_tables.end_date_name%TYPE ,
146: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,
147: column_name pay_datetracked_events.column_name%TYPE ,
148: update_type pay_datetracked_events.update_type%TYPE ,
149: proration_type pay_datetracked_events.proration_style%TYPE
150: );
151:

Line 148: update_type pay_datetracked_events.update_type%TYPE ,

144: start_date_name pay_dated_tables.start_date_name%TYPE ,
145: end_date_name pay_dated_tables.end_date_name%TYPE ,
146: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,
147: column_name pay_datetracked_events.column_name%TYPE ,
148: update_type pay_datetracked_events.update_type%TYPE ,
149: proration_type pay_datetracked_events.proration_style%TYPE
150: );
151:
152: TYPE t_distinct_table IS TABLE OF t_distinct_table_rec

Line 149: proration_type pay_datetracked_events.proration_style%TYPE

145: end_date_name pay_dated_tables.end_date_name%TYPE ,
146: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,
147: column_name pay_datetracked_events.column_name%TYPE ,
148: update_type pay_datetracked_events.update_type%TYPE ,
149: proration_type pay_datetracked_events.proration_style%TYPE
150: );
151:
152: TYPE t_distinct_table IS TABLE OF t_distinct_table_rec
153: INDEX BY BINARY_INTEGER ;

Line 159: datetracked_event pay_datetracked_events.datetracked_event_id%TYPE ,

155:
156: TYPE t_detailed_output_tab_rec IS RECORD
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,

Line 160: update_type pay_datetracked_events.update_type%TYPE ,

156: TYPE t_detailed_output_tab_rec IS RECORD
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,

Line 183: datetracked_evt_id pay_datetracked_events.datetracked_event_id%TYPE ,

179: TYPE t_detailed_output_table_type IS TABLE OF t_detailed_output_tab_rec
180: INDEX BY BINARY_INTEGER ;
181: TYPE t_datetrack_ee_rec IS RECORD
182: (
183: datetracked_evt_id pay_datetracked_events.datetracked_event_id%TYPE ,
184: element_entry_id pay_element_entries_f.element_entry_id%type,
185: next_ptr number
186: );
187:

Line 257: date_tracked_id pay_datetracked_events.datetracked_event_id%TYPE ,

253: -- The following type will hold the records that will contain the column_name,
254: -- its old and new value.
255: TYPE t_dynamic_sql_rec IS RECORD
256: (
257: date_tracked_id pay_datetracked_events.datetracked_event_id%TYPE ,
258: column_name pay_datetracked_events.column_name%TYPE ,
259: old_value VARCHAR2(100) ,
260: new_value VARCHAR2(100) ,
261: proration_style pay_datetracked_events.proration_style%TYPE

Line 258: column_name pay_datetracked_events.column_name%TYPE ,

254: -- its old and new value.
255: TYPE t_dynamic_sql_rec IS RECORD
256: (
257: date_tracked_id pay_datetracked_events.datetracked_event_id%TYPE ,
258: column_name pay_datetracked_events.column_name%TYPE ,
259: old_value VARCHAR2(100) ,
260: new_value VARCHAR2(100) ,
261: proration_style pay_datetracked_events.proration_style%TYPE
262: );

Line 261: proration_style pay_datetracked_events.proration_style%TYPE

257: date_tracked_id pay_datetracked_events.datetracked_event_id%TYPE ,
258: column_name pay_datetracked_events.column_name%TYPE ,
259: old_value VARCHAR2(100) ,
260: new_value VARCHAR2(100) ,
261: proration_style pay_datetracked_events.proration_style%TYPE
262: );
263: TYPE t_dynamic_sql_tab IS TABLE OF t_dynamic_sql_rec INDEX BY BINARY_INTEGER;
264: -->
265: