197: TYPE t_asg_seq IS TABLE OF assignment_seq_rec_type INDEX BY Binary_Integer;
198: g_assignment_seq_rec t_asg_seq;
199:
200: TYPE date_rows IS RECORD
201: (old_start ben_ext_chg_evt_log.old_val1%TYPE
202: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
203: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
204: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
205: );
198: g_assignment_seq_rec t_asg_seq;
199:
200: TYPE date_rows IS RECORD
201: (old_start ben_ext_chg_evt_log.old_val1%TYPE
202: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
203: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
204: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
205: );
206: TYPE t_date_rows IS TABLE OF date_rows INDEX BY Binary_Integer;
199:
200: TYPE date_rows IS RECORD
201: (old_start ben_ext_chg_evt_log.old_val1%TYPE
202: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
203: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
204: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
205: );
206: TYPE t_date_rows IS TABLE OF date_rows INDEX BY Binary_Integer;
207:
200: TYPE date_rows IS RECORD
201: (old_start ben_ext_chg_evt_log.old_val1%TYPE
202: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
203: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
204: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
205: );
206: TYPE t_date_rows IS TABLE OF date_rows INDEX BY Binary_Integer;
207:
208: g_fur_dates t_date_rows;
208: g_fur_dates t_date_rows;
209: g_ipap_dates t_date_rows;
210:
211: TYPE rec_05_rows IS RECORD
212: (old_start ben_ext_chg_evt_log.old_val1%TYPE
213: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
214: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
215: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
216: ,partn_kind varchar2(30)
209: g_ipap_dates t_date_rows;
210:
211: TYPE rec_05_rows IS RECORD
212: (old_start ben_ext_chg_evt_log.old_val1%TYPE
213: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
214: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
215: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
216: ,partn_kind varchar2(30)
217: ,partn_value varchar2(30)
210:
211: TYPE rec_05_rows IS RECORD
212: (old_start ben_ext_chg_evt_log.old_val1%TYPE
213: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
214: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
215: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
216: ,partn_kind varchar2(30)
217: ,partn_value varchar2(30)
218: ,dt_chg ben_ext_chg_evt_log.prmtr_07%TYPE
211: TYPE rec_05_rows IS RECORD
212: (old_start ben_ext_chg_evt_log.old_val1%TYPE
213: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
214: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
215: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
216: ,partn_kind varchar2(30)
217: ,partn_value varchar2(30)
218: ,dt_chg ben_ext_chg_evt_log.prmtr_07%TYPE
219: ,eddt_chg ben_ext_chg_evt_log.prmtr_07%TYPE
214: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
215: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
216: ,partn_kind varchar2(30)
217: ,partn_value varchar2(30)
218: ,dt_chg ben_ext_chg_evt_log.prmtr_07%TYPE
219: ,eddt_chg ben_ext_chg_evt_log.prmtr_07%TYPE
220: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE
221: ,part_time_perc number(9,2)
222: ,ppp_kind varchar2(1)
215: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
216: ,partn_kind varchar2(30)
217: ,partn_value varchar2(30)
218: ,dt_chg ben_ext_chg_evt_log.prmtr_07%TYPE
219: ,eddt_chg ben_ext_chg_evt_log.prmtr_07%TYPE
220: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE
221: ,part_time_perc number(9,2)
222: ,ppp_kind varchar2(1)
223: ,opnp_kind varchar2(1)
216: ,partn_kind varchar2(30)
217: ,partn_value varchar2(30)
218: ,dt_chg ben_ext_chg_evt_log.prmtr_07%TYPE
219: ,eddt_chg ben_ext_chg_evt_log.prmtr_07%TYPE
220: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE
221: ,part_time_perc number(9,2)
222: ,ppp_kind varchar2(1)
223: ,opnp_kind varchar2(1)
224: ,fpu_kind varchar2(1)
228:
229: g_rec05_rows t_rec_05_rows;
230:
231: TYPE si_date_rows IS RECORD
232: (start_date ben_ext_chg_evt_log.new_val1%TYPE
233: ,end_date ben_ext_chg_evt_log.new_val2%TYPE
234: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
235: ,old_start ben_ext_chg_evt_log.old_val1%TYPE
236: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
229: g_rec05_rows t_rec_05_rows;
230:
231: TYPE si_date_rows IS RECORD
232: (start_date ben_ext_chg_evt_log.new_val1%TYPE
233: ,end_date ben_ext_chg_evt_log.new_val2%TYPE
234: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
235: ,old_start ben_ext_chg_evt_log.old_val1%TYPE
236: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
237: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
230:
231: TYPE si_date_rows IS RECORD
232: (start_date ben_ext_chg_evt_log.new_val1%TYPE
233: ,end_date ben_ext_chg_evt_log.new_val2%TYPE
234: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
235: ,old_start ben_ext_chg_evt_log.old_val1%TYPE
236: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
237: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
238: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE
231: TYPE si_date_rows IS RECORD
232: (start_date ben_ext_chg_evt_log.new_val1%TYPE
233: ,end_date ben_ext_chg_evt_log.new_val2%TYPE
234: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
235: ,old_start ben_ext_chg_evt_log.old_val1%TYPE
236: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
237: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
238: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE
239: ,part_time_perc NUMBER(9,2)
232: (start_date ben_ext_chg_evt_log.new_val1%TYPE
233: ,end_date ben_ext_chg_evt_log.new_val2%TYPE
234: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
235: ,old_start ben_ext_chg_evt_log.old_val1%TYPE
236: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
237: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
238: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE
239: ,part_time_perc NUMBER(9,2)
240: ,display_si_flag VARCHAR2(1)
233: ,end_date ben_ext_chg_evt_log.new_val2%TYPE
234: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
235: ,old_start ben_ext_chg_evt_log.old_val1%TYPE
236: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
237: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
238: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE
239: ,part_time_perc NUMBER(9,2)
240: ,display_si_flag VARCHAR2(1)
241: );
234: ,new_start ben_ext_chg_evt_log.new_val1%TYPE
235: ,old_start ben_ext_chg_evt_log.old_val1%TYPE
236: ,new_end ben_ext_chg_evt_log.new_val2%TYPE
237: ,old_end ben_ext_chg_evt_log.old_val2%TYPE
238: ,end_reason ben_ext_chg_evt_log.prmtr_09%TYPE
239: ,part_time_perc NUMBER(9,2)
240: ,display_si_flag VARCHAR2(1)
241: );
242: TYPE t_si_date_rows IS TABLE OF si_date_rows INDEX BY Binary_Integer;