372: ,p_inst_row in out NOCOPY g_etpr_inst_row
373: );
374: --
375: type g_prel_inst_row is record
376: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
377: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
378: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
379: ,pgm_id ben_prtn_elig_f.pgm_id%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type
373: );
374: --
375: type g_prel_inst_row is record
376: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
377: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
378: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
379: ,pgm_id ben_prtn_elig_f.pgm_id%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type
381: ,plip_id ben_prtn_elig_f.plip_id%type
374: --
375: type g_prel_inst_row is record
376: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
377: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
378: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
379: ,pgm_id ben_prtn_elig_f.pgm_id%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type
381: ,plip_id ben_prtn_elig_f.plip_id%type
382: ,pl_id ben_prtn_elig_f.pl_id%type
375: type g_prel_inst_row is record
376: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
377: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
378: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
379: ,pgm_id ben_prtn_elig_f.pgm_id%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type
381: ,plip_id ben_prtn_elig_f.plip_id%type
382: ,pl_id ben_prtn_elig_f.pl_id%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type
376: (prtn_elig_id ben_prtn_elig_f.prtn_elig_id%type
377: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
378: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
379: ,pgm_id ben_prtn_elig_f.pgm_id%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type
381: ,plip_id ben_prtn_elig_f.plip_id%type
382: ,pl_id ben_prtn_elig_f.pl_id%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
377: ,effective_start_date ben_prtn_elig_f.effective_start_date%type
378: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
379: ,pgm_id ben_prtn_elig_f.pgm_id%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type
381: ,plip_id ben_prtn_elig_f.plip_id%type
382: ,pl_id ben_prtn_elig_f.pl_id%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
378: ,effective_end_date ben_prtn_elig_f.effective_end_date%type
379: ,pgm_id ben_prtn_elig_f.pgm_id%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type
381: ,plip_id ben_prtn_elig_f.plip_id%type
382: ,pl_id ben_prtn_elig_f.pl_id%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
379: ,pgm_id ben_prtn_elig_f.pgm_id%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type
381: ,plip_id ben_prtn_elig_f.plip_id%type
382: ,pl_id ben_prtn_elig_f.pl_id%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
380: ,ptip_id ben_prtn_elig_f.ptip_id%type
381: ,plip_id ben_prtn_elig_f.plip_id%type
382: ,pl_id ben_prtn_elig_f.pl_id%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
381: ,plip_id ben_prtn_elig_f.plip_id%type
382: ,pl_id ben_prtn_elig_f.pl_id%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
382: ,pl_id ben_prtn_elig_f.pl_id%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
390: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
383: ,oipl_id ben_prtn_elig_f.oipl_id%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
390: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
391: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
384: ,wait_perd_dt_to_use_cd ben_prtn_elig_f.wait_perd_dt_to_use_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
390: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
391: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
392: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type
385: ,wait_perd_dt_to_use_rl ben_prtn_elig_f.wait_perd_dt_to_use_rl%type
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
390: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
391: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
392: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type
393: );
386: ,wait_perd_rl ben_prtn_elig_f.wait_perd_rl%type
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
390: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
391: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
392: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type
393: );
394: --
387: ,wait_perd_uom ben_prtn_elig_f.wait_perd_uom%type
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
390: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
391: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
392: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type
393: );
394: --
395: type g_prel_inst_tbl is table of g_prel_inst_row
388: ,wait_perd_val ben_prtn_elig_f.wait_perd_val%type
389: ,prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%type
390: ,prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%type
391: ,prtn_eff_strt_dt_cd ben_prtn_elig_f.prtn_eff_strt_dt_cd%type
392: ,prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%type
393: );
394: --
395: type g_prel_inst_tbl is table of g_prel_inst_row
396: index by binary_integer;