APPS.PAY_INTERPRETER_PKG dependencies on PAY_DATETRACKED_EVENTS

Line 162: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,

158: dyt_type pay_dated_tables.dyn_trigger_type%TYPE ,
159: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,
160: start_date_name pay_dated_tables.start_date_name%TYPE ,
161: end_date_name pay_dated_tables.end_date_name%TYPE ,
162: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,
163: column_name pay_datetracked_events.column_name%TYPE ,
164: update_type pay_datetracked_events.update_type%TYPE ,
165: proration_type pay_datetracked_events.proration_style%TYPE
166: );

Line 163: column_name pay_datetracked_events.column_name%TYPE ,

159: surrogate_key_name pay_dated_tables.surrogate_key_name%TYPE ,
160: start_date_name pay_dated_tables.start_date_name%TYPE ,
161: end_date_name pay_dated_tables.end_date_name%TYPE ,
162: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,
163: column_name pay_datetracked_events.column_name%TYPE ,
164: update_type pay_datetracked_events.update_type%TYPE ,
165: proration_type pay_datetracked_events.proration_style%TYPE
166: );
167:

Line 164: update_type pay_datetracked_events.update_type%TYPE ,

160: start_date_name pay_dated_tables.start_date_name%TYPE ,
161: end_date_name pay_dated_tables.end_date_name%TYPE ,
162: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,
163: column_name pay_datetracked_events.column_name%TYPE ,
164: update_type pay_datetracked_events.update_type%TYPE ,
165: proration_type pay_datetracked_events.proration_style%TYPE
166: );
167:
168: TYPE t_distinct_table IS TABLE OF t_distinct_table_rec

Line 165: proration_type pay_datetracked_events.proration_style%TYPE

161: end_date_name pay_dated_tables.end_date_name%TYPE ,
162: datetracked_event_id pay_datetracked_events.datetracked_event_id%TYPE,
163: column_name pay_datetracked_events.column_name%TYPE ,
164: update_type pay_datetracked_events.update_type%TYPE ,
165: proration_type pay_datetracked_events.proration_style%TYPE
166: );
167:
168: TYPE t_distinct_table IS TABLE OF t_distinct_table_rec
169: INDEX BY BINARY_INTEGER ;

Line 175: datetracked_event pay_datetracked_events.datetracked_event_id%TYPE ,

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

Line 176: update_type pay_datetracked_events.update_type%TYPE ,

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

Line 199: datetracked_evt_id pay_datetracked_events.datetracked_event_id%TYPE ,

195: TYPE t_detailed_output_table_type IS TABLE OF t_detailed_output_tab_rec
196: INDEX BY BINARY_INTEGER ;
197: TYPE t_datetrack_ee_rec IS RECORD
198: (
199: datetracked_evt_id pay_datetracked_events.datetracked_event_id%TYPE ,
200: element_entry_id pay_element_entries_f.element_entry_id%type,
201: next_ptr number
202: );
203:

Line 273: date_tracked_id pay_datetracked_events.datetracked_event_id%TYPE ,

269: -- The following type will hold the records that will contain the column_name,
270: -- its old and new value.
271: TYPE t_dynamic_sql_rec IS RECORD
272: (
273: date_tracked_id pay_datetracked_events.datetracked_event_id%TYPE ,
274: column_name pay_datetracked_events.column_name%TYPE ,
275: old_value VARCHAR2(100) ,
276: new_value VARCHAR2(100) ,
277: proration_style pay_datetracked_events.proration_style%TYPE

Line 274: column_name pay_datetracked_events.column_name%TYPE ,

270: -- its old and new value.
271: TYPE t_dynamic_sql_rec IS RECORD
272: (
273: date_tracked_id pay_datetracked_events.datetracked_event_id%TYPE ,
274: column_name pay_datetracked_events.column_name%TYPE ,
275: old_value VARCHAR2(100) ,
276: new_value VARCHAR2(100) ,
277: proration_style pay_datetracked_events.proration_style%TYPE
278: );

Line 277: proration_style pay_datetracked_events.proration_style%TYPE

273: date_tracked_id pay_datetracked_events.datetracked_event_id%TYPE ,
274: column_name pay_datetracked_events.column_name%TYPE ,
275: old_value VARCHAR2(100) ,
276: new_value VARCHAR2(100) ,
277: proration_style pay_datetracked_events.proration_style%TYPE
278: );
279: TYPE t_dynamic_sql_tab IS TABLE OF t_dynamic_sql_rec INDEX BY BINARY_INTEGER;
280: -->
281: