[Home] [Help]
409: l_prtn_eff_end_dt_cd ben_prtn_elig_f.prtn_eff_end_dt_cd%TYPE;
410: l_prtn_eff_strt_dt_rl ben_prtn_elig_f.prtn_eff_strt_dt_rl%TYPE;
411: l_prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%TYPE;
412: l_outputs ff_exec.outputs_t;
413: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
414: l_pl_rec ben_pl_f%rowtype;
415: l_elig_pgm_rec ben_cobj_cache.g_etpr_inst_row;
416: l_elig_ptip_rec ben_cobj_cache.g_etpr_inst_row;
417: l_elig_plip_rec ben_cobj_cache.g_etpr_inst_row;
411: l_prtn_eff_end_dt_rl ben_prtn_elig_f.prtn_eff_end_dt_rl%TYPE;
412: l_outputs ff_exec.outputs_t;
413: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
414: l_pl_rec ben_pl_f%rowtype;
415: l_elig_pgm_rec ben_cobj_cache.g_etpr_inst_row;
416: l_elig_ptip_rec ben_cobj_cache.g_etpr_inst_row;
417: l_elig_plip_rec ben_cobj_cache.g_etpr_inst_row;
418: l_elig_pl_rec ben_cobj_cache.g_etpr_inst_row;
419: l_elig_oipl_rec ben_cobj_cache.g_etpr_inst_row;
412: l_outputs ff_exec.outputs_t;
413: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
414: l_pl_rec ben_pl_f%rowtype;
415: l_elig_pgm_rec ben_cobj_cache.g_etpr_inst_row;
416: l_elig_ptip_rec ben_cobj_cache.g_etpr_inst_row;
417: l_elig_plip_rec ben_cobj_cache.g_etpr_inst_row;
418: l_elig_pl_rec ben_cobj_cache.g_etpr_inst_row;
419: l_elig_oipl_rec ben_cobj_cache.g_etpr_inst_row;
420: l_prtn_elig_pl_rec ben_cobj_cache.g_prel_inst_row;
413: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
414: l_pl_rec ben_pl_f%rowtype;
415: l_elig_pgm_rec ben_cobj_cache.g_etpr_inst_row;
416: l_elig_ptip_rec ben_cobj_cache.g_etpr_inst_row;
417: l_elig_plip_rec ben_cobj_cache.g_etpr_inst_row;
418: l_elig_pl_rec ben_cobj_cache.g_etpr_inst_row;
419: l_elig_oipl_rec ben_cobj_cache.g_etpr_inst_row;
420: l_prtn_elig_pl_rec ben_cobj_cache.g_prel_inst_row;
421: l_prtn_elig_pgm_rec ben_cobj_cache.g_prel_inst_row;
414: l_pl_rec ben_pl_f%rowtype;
415: l_elig_pgm_rec ben_cobj_cache.g_etpr_inst_row;
416: l_elig_ptip_rec ben_cobj_cache.g_etpr_inst_row;
417: l_elig_plip_rec ben_cobj_cache.g_etpr_inst_row;
418: l_elig_pl_rec ben_cobj_cache.g_etpr_inst_row;
419: l_elig_oipl_rec ben_cobj_cache.g_etpr_inst_row;
420: l_prtn_elig_pl_rec ben_cobj_cache.g_prel_inst_row;
421: l_prtn_elig_pgm_rec ben_cobj_cache.g_prel_inst_row;
422: l_prtn_elig_oipl_rec ben_cobj_cache.g_prel_inst_row;
415: l_elig_pgm_rec ben_cobj_cache.g_etpr_inst_row;
416: l_elig_ptip_rec ben_cobj_cache.g_etpr_inst_row;
417: l_elig_plip_rec ben_cobj_cache.g_etpr_inst_row;
418: l_elig_pl_rec ben_cobj_cache.g_etpr_inst_row;
419: l_elig_oipl_rec ben_cobj_cache.g_etpr_inst_row;
420: l_prtn_elig_pl_rec ben_cobj_cache.g_prel_inst_row;
421: l_prtn_elig_pgm_rec ben_cobj_cache.g_prel_inst_row;
422: l_prtn_elig_oipl_rec ben_cobj_cache.g_prel_inst_row;
423: l_prtn_elig_plip_rec ben_cobj_cache.g_prel_inst_row;
416: l_elig_ptip_rec ben_cobj_cache.g_etpr_inst_row;
417: l_elig_plip_rec ben_cobj_cache.g_etpr_inst_row;
418: l_elig_pl_rec ben_cobj_cache.g_etpr_inst_row;
419: l_elig_oipl_rec ben_cobj_cache.g_etpr_inst_row;
420: l_prtn_elig_pl_rec ben_cobj_cache.g_prel_inst_row;
421: l_prtn_elig_pgm_rec ben_cobj_cache.g_prel_inst_row;
422: l_prtn_elig_oipl_rec ben_cobj_cache.g_prel_inst_row;
423: l_prtn_elig_plip_rec ben_cobj_cache.g_prel_inst_row;
424: l_prtn_elig_ptip_rec ben_cobj_cache.g_prel_inst_row;
417: l_elig_plip_rec ben_cobj_cache.g_etpr_inst_row;
418: l_elig_pl_rec ben_cobj_cache.g_etpr_inst_row;
419: l_elig_oipl_rec ben_cobj_cache.g_etpr_inst_row;
420: l_prtn_elig_pl_rec ben_cobj_cache.g_prel_inst_row;
421: l_prtn_elig_pgm_rec ben_cobj_cache.g_prel_inst_row;
422: l_prtn_elig_oipl_rec ben_cobj_cache.g_prel_inst_row;
423: l_prtn_elig_plip_rec ben_cobj_cache.g_prel_inst_row;
424: l_prtn_elig_ptip_rec ben_cobj_cache.g_prel_inst_row;
425: l_ass_rec per_all_assignments_f%rowtype;
418: l_elig_pl_rec ben_cobj_cache.g_etpr_inst_row;
419: l_elig_oipl_rec ben_cobj_cache.g_etpr_inst_row;
420: l_prtn_elig_pl_rec ben_cobj_cache.g_prel_inst_row;
421: l_prtn_elig_pgm_rec ben_cobj_cache.g_prel_inst_row;
422: l_prtn_elig_oipl_rec ben_cobj_cache.g_prel_inst_row;
423: l_prtn_elig_plip_rec ben_cobj_cache.g_prel_inst_row;
424: l_prtn_elig_ptip_rec ben_cobj_cache.g_prel_inst_row;
425: l_ass_rec per_all_assignments_f%rowtype;
426: l_loc_rec hr_locations_all%rowtype;
419: l_elig_oipl_rec ben_cobj_cache.g_etpr_inst_row;
420: l_prtn_elig_pl_rec ben_cobj_cache.g_prel_inst_row;
421: l_prtn_elig_pgm_rec ben_cobj_cache.g_prel_inst_row;
422: l_prtn_elig_oipl_rec ben_cobj_cache.g_prel_inst_row;
423: l_prtn_elig_plip_rec ben_cobj_cache.g_prel_inst_row;
424: l_prtn_elig_ptip_rec ben_cobj_cache.g_prel_inst_row;
425: l_ass_rec per_all_assignments_f%rowtype;
426: l_loc_rec hr_locations_all%rowtype;
427: l_jurisdiction_code varchar2(30);
420: l_prtn_elig_pl_rec ben_cobj_cache.g_prel_inst_row;
421: l_prtn_elig_pgm_rec ben_cobj_cache.g_prel_inst_row;
422: l_prtn_elig_oipl_rec ben_cobj_cache.g_prel_inst_row;
423: l_prtn_elig_plip_rec ben_cobj_cache.g_prel_inst_row;
424: l_prtn_elig_ptip_rec ben_cobj_cache.g_prel_inst_row;
425: l_ass_rec per_all_assignments_f%rowtype;
426: l_loc_rec hr_locations_all%rowtype;
427: l_jurisdiction_code varchar2(30);
428: --
490: -- hr_utility.set_location('get pgm l_prtn_eff_strt_dt_cd',123);
491: --
492: -- Performance fix to reduce cache calls
493: --
494: l_elig_pgm_rec := ben_cobj_cache.g_pgmetpr_currow;
495: --
496: l_prtn_eff_strt_dt_rl := l_elig_pgm_rec.prtn_eff_strt_dt_rl;
497: l_prtn_eff_end_dt_rl := l_elig_pgm_rec.prtn_eff_end_dt_rl;
498: l_prtn_eff_strt_dt_cd := l_elig_pgm_rec.prtn_eff_strt_dt_cd;
502: -- them in prtn_elig_f.
503: --
504: if l_prtn_eff_strt_dt_cd is null then
505: --
506: l_prtn_elig_pgm_rec := ben_cobj_cache.g_pgmprel_currow;
507: --
508: l_prtn_eff_strt_dt_cd := l_prtn_elig_pgm_rec.prtn_eff_strt_dt_cd;
509: l_prtn_eff_end_dt_cd := l_prtn_elig_pgm_rec.prtn_eff_end_dt_cd;
510: l_prtn_eff_strt_dt_rl := l_prtn_elig_pgm_rec.prtn_eff_strt_dt_rl;
517: if p_ptip_id is not null then
518: --
519: -- Performance fix to reduce cache calls
520: --
521: l_elig_ptip_rec := ben_cobj_cache.g_ptipetpr_currow;
522: --
523: l_prtn_eff_strt_dt_cd := l_elig_ptip_rec.prtn_eff_strt_dt_cd;
524: l_prtn_eff_end_dt_cd := l_elig_ptip_rec.prtn_eff_end_dt_cd;
525: l_prtn_eff_strt_dt_rl := l_elig_ptip_rec.prtn_eff_strt_dt_rl;
529: -- them in prtn_elig_f.
530: --
531: if l_prtn_eff_strt_dt_cd is null then
532: --
533: l_prtn_elig_ptip_rec := ben_cobj_cache.g_ptipprel_currow;
534: --
535: l_prtn_eff_strt_dt_cd := l_prtn_elig_ptip_rec.prtn_eff_strt_dt_cd;
536: l_prtn_eff_end_dt_cd := l_prtn_elig_ptip_rec.prtn_eff_end_dt_cd;
537: l_prtn_eff_strt_dt_rl := l_prtn_elig_ptip_rec.prtn_eff_strt_dt_rl;
540: --
541: -- if cd is still null then get it from pgm
542: --
543: if l_prtn_eff_strt_dt_cd is null then
544: l_elig_pgm_rec := ben_cobj_cache.g_pgmetpr_currow;
545: --
546: l_prtn_elig_pgm_rec := ben_cobj_cache.g_pgmprel_currow;
547: --
548: l_prtn_eff_strt_dt_cd := nvl(l_elig_pgm_rec.prtn_eff_strt_dt_cd,l_prtn_elig_pgm_rec.prtn_eff_strt_dt_cd);
542: --
543: if l_prtn_eff_strt_dt_cd is null then
544: l_elig_pgm_rec := ben_cobj_cache.g_pgmetpr_currow;
545: --
546: l_prtn_elig_pgm_rec := ben_cobj_cache.g_pgmprel_currow;
547: --
548: l_prtn_eff_strt_dt_cd := nvl(l_elig_pgm_rec.prtn_eff_strt_dt_cd,l_prtn_elig_pgm_rec.prtn_eff_strt_dt_cd);
549: l_prtn_eff_end_dt_cd := nvl(l_elig_pgm_rec.prtn_eff_end_dt_cd ,l_prtn_elig_pgm_rec.prtn_eff_end_dt_cd );
550: l_prtn_eff_strt_dt_rl := nvl(l_elig_pgm_rec.prtn_eff_strt_dt_rl,l_prtn_elig_pgm_rec.prtn_eff_strt_dt_rl);
556: -- hr_utility.set_location('PLIP NN ben_determine_eligibility2.get_start_end_dates',10);
557: if p_plip_id is not null then
558: -- hr_utility.set_location('get plip l_prtn_eff_strt_dt_cd',123);
559: --
560: l_elig_plip_rec := ben_cobj_cache.g_plipetpr_currow;
561: l_prtn_eff_strt_dt_cd := l_elig_plip_rec.prtn_eff_strt_dt_cd;
562: l_prtn_eff_end_dt_cd := l_elig_plip_rec.prtn_eff_end_dt_cd;
563: l_prtn_eff_strt_dt_rl := l_elig_plip_rec.prtn_eff_strt_dt_rl;
564: l_prtn_eff_end_dt_rl := l_elig_plip_rec.prtn_eff_end_dt_rl;
566: -- If the date codes are not found in the elig_to_prte_rsn table, look for
567: -- them in prtn_elig_f.
568: --
569: if l_prtn_eff_strt_dt_cd is null then
570: l_prtn_elig_plip_rec := ben_cobj_cache.g_plipprel_currow;
571: l_prtn_eff_strt_dt_cd := l_prtn_elig_plip_rec.prtn_eff_strt_dt_cd;
572: l_prtn_eff_end_dt_cd := l_prtn_elig_plip_rec.prtn_eff_end_dt_cd;
573: l_prtn_eff_strt_dt_rl := l_prtn_elig_plip_rec.prtn_eff_strt_dt_rl;
574: l_prtn_eff_end_dt_rl := l_prtn_elig_plip_rec.prtn_eff_end_dt_rl;
576: --
577: -- if cd is still null then look in ptip then pgm
578: --
579: if l_prtn_eff_strt_dt_cd is null then
580: l_elig_ptip_rec := ben_cobj_cache.g_ptipetpr_currow;
581: l_prtn_elig_ptip_rec := ben_cobj_cache.g_ptipprel_currow;
582: l_prtn_eff_strt_dt_cd := nvl(l_elig_ptip_rec.prtn_eff_strt_dt_cd,l_prtn_elig_ptip_rec.prtn_eff_strt_dt_cd);
583: l_prtn_eff_end_dt_cd := nvl(l_elig_ptip_rec.prtn_eff_end_dt_cd ,l_prtn_elig_ptip_rec.prtn_eff_end_dt_cd );
584: l_prtn_eff_strt_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_strt_dt_rl,l_prtn_elig_ptip_rec.prtn_eff_strt_dt_rl);
577: -- if cd is still null then look in ptip then pgm
578: --
579: if l_prtn_eff_strt_dt_cd is null then
580: l_elig_ptip_rec := ben_cobj_cache.g_ptipetpr_currow;
581: l_prtn_elig_ptip_rec := ben_cobj_cache.g_ptipprel_currow;
582: l_prtn_eff_strt_dt_cd := nvl(l_elig_ptip_rec.prtn_eff_strt_dt_cd,l_prtn_elig_ptip_rec.prtn_eff_strt_dt_cd);
583: l_prtn_eff_end_dt_cd := nvl(l_elig_ptip_rec.prtn_eff_end_dt_cd ,l_prtn_elig_ptip_rec.prtn_eff_end_dt_cd );
584: l_prtn_eff_strt_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_strt_dt_rl,l_prtn_elig_ptip_rec.prtn_eff_strt_dt_rl);
585: l_prtn_eff_end_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_end_dt_rl ,l_prtn_elig_ptip_rec.prtn_eff_end_dt_rl );
584: l_prtn_eff_strt_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_strt_dt_rl,l_prtn_elig_ptip_rec.prtn_eff_strt_dt_rl);
585: l_prtn_eff_end_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_end_dt_rl ,l_prtn_elig_ptip_rec.prtn_eff_end_dt_rl );
586:
587: if l_prtn_eff_strt_dt_cd is null then
588: l_elig_pgm_rec := ben_cobj_cache.g_pgmetpr_currow;
589: l_prtn_elig_pgm_rec := ben_cobj_cache.g_pgmprel_currow;
590: l_prtn_eff_strt_dt_cd := nvl(l_elig_pgm_rec.prtn_eff_strt_dt_cd,l_prtn_elig_pgm_rec.prtn_eff_strt_dt_cd);
591: l_prtn_eff_end_dt_cd := nvl(l_elig_pgm_rec.prtn_eff_end_dt_cd ,l_prtn_elig_pgm_rec.prtn_eff_end_dt_cd );
592: l_prtn_eff_strt_dt_rl := nvl(l_elig_pgm_rec.prtn_eff_strt_dt_rl,l_prtn_elig_pgm_rec.prtn_eff_strt_dt_rl);
585: l_prtn_eff_end_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_end_dt_rl ,l_prtn_elig_ptip_rec.prtn_eff_end_dt_rl );
586:
587: if l_prtn_eff_strt_dt_cd is null then
588: l_elig_pgm_rec := ben_cobj_cache.g_pgmetpr_currow;
589: l_prtn_elig_pgm_rec := ben_cobj_cache.g_pgmprel_currow;
590: l_prtn_eff_strt_dt_cd := nvl(l_elig_pgm_rec.prtn_eff_strt_dt_cd,l_prtn_elig_pgm_rec.prtn_eff_strt_dt_cd);
591: l_prtn_eff_end_dt_cd := nvl(l_elig_pgm_rec.prtn_eff_end_dt_cd ,l_prtn_elig_pgm_rec.prtn_eff_end_dt_cd );
592: l_prtn_eff_strt_dt_rl := nvl(l_elig_pgm_rec.prtn_eff_strt_dt_rl,l_prtn_elig_pgm_rec.prtn_eff_strt_dt_rl);
593: l_prtn_eff_end_dt_rl := nvl(l_elig_pgm_rec.prtn_eff_end_dt_rl ,l_prtn_elig_pgm_rec.prtn_eff_end_dt_rl );
600: if p_pl_id is not null then
601:
602: -- For plans in pgm, look at plip first.
603: if l_envplip_id is not null then
604: l_elig_plip_rec := ben_cobj_cache.g_plipetpr_currow;
605: l_prtn_elig_plip_rec := ben_cobj_cache.g_plipprel_currow;
606: l_prtn_eff_strt_dt_cd := nvl(l_elig_plip_rec.prtn_eff_strt_dt_cd,l_prtn_elig_plip_rec.prtn_eff_strt_dt_cd);
607: l_prtn_eff_end_dt_cd := nvl(l_elig_plip_rec.prtn_eff_end_dt_cd ,l_prtn_elig_plip_rec.prtn_eff_end_dt_cd );
608: l_prtn_eff_strt_dt_rl := nvl(l_elig_plip_rec.prtn_eff_strt_dt_rl,l_prtn_elig_plip_rec.prtn_eff_strt_dt_rl);
601:
602: -- For plans in pgm, look at plip first.
603: if l_envplip_id is not null then
604: l_elig_plip_rec := ben_cobj_cache.g_plipetpr_currow;
605: l_prtn_elig_plip_rec := ben_cobj_cache.g_plipprel_currow;
606: l_prtn_eff_strt_dt_cd := nvl(l_elig_plip_rec.prtn_eff_strt_dt_cd,l_prtn_elig_plip_rec.prtn_eff_strt_dt_cd);
607: l_prtn_eff_end_dt_cd := nvl(l_elig_plip_rec.prtn_eff_end_dt_cd ,l_prtn_elig_plip_rec.prtn_eff_end_dt_cd );
608: l_prtn_eff_strt_dt_rl := nvl(l_elig_plip_rec.prtn_eff_strt_dt_rl,l_prtn_elig_plip_rec.prtn_eff_strt_dt_rl);
609: l_prtn_eff_end_dt_rl := nvl(l_elig_plip_rec.prtn_eff_end_dt_rl ,l_prtn_elig_plip_rec.prtn_eff_end_dt_rl );
612: -- if plip not found, or plan not in program, look at pl level
613: if l_prtn_eff_strt_dt_cd is null then
614: -- hr_utility.set_location('get pl l_prtn_eff_strt_dt_cd',123);
615: --
616: l_elig_pl_rec := ben_cobj_cache.g_pletpr_currow;
617: l_prtn_eff_strt_dt_cd := l_elig_pl_rec.prtn_eff_strt_dt_cd;
618: l_prtn_eff_end_dt_cd := l_elig_pl_rec.prtn_eff_end_dt_cd;
619: l_prtn_eff_strt_dt_rl := l_elig_pl_rec.prtn_eff_strt_dt_rl;
620: l_prtn_eff_end_dt_rl := l_elig_pl_rec.prtn_eff_end_dt_rl;
622: -- If the date codes are not found in the elig_to_prte_rsn table, look for
623: -- them in prtn_elig_f.
624: --
625: if l_prtn_eff_strt_dt_cd is null then
626: l_prtn_elig_pl_rec := ben_cobj_cache.g_plprel_currow;
627: l_prtn_eff_strt_dt_cd := l_prtn_elig_pl_rec.prtn_eff_strt_dt_cd;
628: l_prtn_eff_end_dt_cd := l_prtn_elig_pl_rec.prtn_eff_end_dt_cd;
629: l_prtn_eff_strt_dt_rl := l_prtn_elig_pl_rec.prtn_eff_strt_dt_rl;
630: l_prtn_eff_end_dt_rl := l_prtn_elig_pl_rec.prtn_eff_end_dt_rl;
632:
633: -- if cd is still null and pl is in pgm, get from ptip or pgm.
634: --
635: if l_prtn_eff_strt_dt_cd is null and l_envptip_id is not null then
636: l_elig_ptip_rec := ben_cobj_cache.g_ptipetpr_currow;
637: l_prtn_elig_ptip_rec := ben_cobj_cache.g_ptipprel_currow;
638: l_prtn_eff_strt_dt_cd := nvl(l_elig_ptip_rec.prtn_eff_strt_dt_cd,l_prtn_elig_ptip_rec.prtn_eff_strt_dt_cd);
639: l_prtn_eff_end_dt_cd := nvl(l_elig_ptip_rec.prtn_eff_end_dt_cd ,l_prtn_elig_ptip_rec.prtn_eff_end_dt_cd );
640: l_prtn_eff_strt_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_strt_dt_rl,l_prtn_elig_ptip_rec.prtn_eff_strt_dt_rl);
633: -- if cd is still null and pl is in pgm, get from ptip or pgm.
634: --
635: if l_prtn_eff_strt_dt_cd is null and l_envptip_id is not null then
636: l_elig_ptip_rec := ben_cobj_cache.g_ptipetpr_currow;
637: l_prtn_elig_ptip_rec := ben_cobj_cache.g_ptipprel_currow;
638: l_prtn_eff_strt_dt_cd := nvl(l_elig_ptip_rec.prtn_eff_strt_dt_cd,l_prtn_elig_ptip_rec.prtn_eff_strt_dt_cd);
639: l_prtn_eff_end_dt_cd := nvl(l_elig_ptip_rec.prtn_eff_end_dt_cd ,l_prtn_elig_ptip_rec.prtn_eff_end_dt_cd );
640: l_prtn_eff_strt_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_strt_dt_rl,l_prtn_elig_ptip_rec.prtn_eff_strt_dt_rl);
641: l_prtn_eff_end_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_end_dt_rl ,l_prtn_elig_ptip_rec.prtn_eff_end_dt_rl );
640: l_prtn_eff_strt_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_strt_dt_rl,l_prtn_elig_ptip_rec.prtn_eff_strt_dt_rl);
641: l_prtn_eff_end_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_end_dt_rl ,l_prtn_elig_ptip_rec.prtn_eff_end_dt_rl );
642:
643: if l_prtn_eff_strt_dt_cd is null then
644: l_elig_pgm_rec := ben_cobj_cache.g_pgmetpr_currow;
645: l_prtn_elig_pgm_rec := ben_cobj_cache.g_pgmprel_currow;
646: l_prtn_eff_strt_dt_cd := nvl(l_elig_pgm_rec.prtn_eff_strt_dt_cd,l_prtn_elig_pgm_rec.prtn_eff_strt_dt_cd);
647: l_prtn_eff_end_dt_cd := nvl(l_elig_pgm_rec.prtn_eff_end_dt_cd ,l_prtn_elig_pgm_rec.prtn_eff_end_dt_cd );
648: l_prtn_eff_strt_dt_rl := nvl(l_elig_pgm_rec.prtn_eff_strt_dt_rl,l_prtn_elig_pgm_rec.prtn_eff_strt_dt_rl);
641: l_prtn_eff_end_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_end_dt_rl ,l_prtn_elig_ptip_rec.prtn_eff_end_dt_rl );
642:
643: if l_prtn_eff_strt_dt_cd is null then
644: l_elig_pgm_rec := ben_cobj_cache.g_pgmetpr_currow;
645: l_prtn_elig_pgm_rec := ben_cobj_cache.g_pgmprel_currow;
646: l_prtn_eff_strt_dt_cd := nvl(l_elig_pgm_rec.prtn_eff_strt_dt_cd,l_prtn_elig_pgm_rec.prtn_eff_strt_dt_cd);
647: l_prtn_eff_end_dt_cd := nvl(l_elig_pgm_rec.prtn_eff_end_dt_cd ,l_prtn_elig_pgm_rec.prtn_eff_end_dt_cd );
648: l_prtn_eff_strt_dt_rl := nvl(l_elig_pgm_rec.prtn_eff_strt_dt_rl,l_prtn_elig_pgm_rec.prtn_eff_strt_dt_rl);
649: l_prtn_eff_end_dt_rl := nvl(l_elig_pgm_rec.prtn_eff_end_dt_rl ,l_prtn_elig_pgm_rec.prtn_eff_end_dt_rl );
655: end if;
656: -- hr_utility.set_location('OIPL NN ben_determine_eligibility2.get_start_end_dates',10);
657: if p_oipl_id is not null then
658: -- hr_utility.set_location('getting oipl l_prtn_eff_strt_dt_cd',123);
659: l_elig_oipl_rec := ben_cobj_cache.g_oipletpr_currow;
660: l_prtn_eff_strt_dt_cd := l_elig_oipl_rec.prtn_eff_strt_dt_cd;
661: l_prtn_eff_end_dt_cd := l_elig_oipl_rec.prtn_eff_end_dt_cd;
662: l_prtn_eff_strt_dt_rl := l_elig_oipl_rec.prtn_eff_strt_dt_rl;
663: l_prtn_eff_end_dt_rl := l_elig_oipl_rec.prtn_eff_end_dt_rl;
665: -- If the date codes are not found in the elig_to_prte_rsn table, look for
666: -- them in prtn_elig_f.
667: --
668: if l_prtn_eff_strt_dt_cd is null then
669: l_prtn_elig_oipl_rec := ben_cobj_cache.g_oiplprel_currow;
670: l_prtn_eff_strt_dt_cd := l_prtn_elig_oipl_rec.prtn_eff_strt_dt_cd;
671: l_prtn_eff_end_dt_cd := l_prtn_elig_oipl_rec.prtn_eff_end_dt_cd;
672: l_prtn_eff_strt_dt_rl := l_prtn_elig_oipl_rec.prtn_eff_strt_dt_rl;
673: l_prtn_eff_end_dt_rl := l_prtn_elig_oipl_rec.prtn_eff_end_dt_rl;
675: --
676: -- if cd is still null then get from plip if in pgm, plan if not
677: --
678: if l_prtn_eff_strt_dt_cd is null and l_envplip_id is not null then
679: l_elig_plip_rec := ben_cobj_cache.g_plipetpr_currow;
680: l_prtn_elig_plip_rec := ben_cobj_cache.g_plipprel_currow;
681: l_prtn_eff_strt_dt_cd := nvl(l_elig_plip_rec.prtn_eff_strt_dt_cd,l_prtn_elig_plip_rec.prtn_eff_strt_dt_cd);
682: l_prtn_eff_end_dt_cd := nvl(l_elig_plip_rec.prtn_eff_end_dt_cd ,l_prtn_elig_plip_rec.prtn_eff_end_dt_cd );
683: l_prtn_eff_strt_dt_rl := nvl(l_elig_plip_rec.prtn_eff_strt_dt_rl,l_prtn_elig_plip_rec.prtn_eff_strt_dt_rl);
676: -- if cd is still null then get from plip if in pgm, plan if not
677: --
678: if l_prtn_eff_strt_dt_cd is null and l_envplip_id is not null then
679: l_elig_plip_rec := ben_cobj_cache.g_plipetpr_currow;
680: l_prtn_elig_plip_rec := ben_cobj_cache.g_plipprel_currow;
681: l_prtn_eff_strt_dt_cd := nvl(l_elig_plip_rec.prtn_eff_strt_dt_cd,l_prtn_elig_plip_rec.prtn_eff_strt_dt_cd);
682: l_prtn_eff_end_dt_cd := nvl(l_elig_plip_rec.prtn_eff_end_dt_cd ,l_prtn_elig_plip_rec.prtn_eff_end_dt_cd );
683: l_prtn_eff_strt_dt_rl := nvl(l_elig_plip_rec.prtn_eff_strt_dt_rl,l_prtn_elig_plip_rec.prtn_eff_strt_dt_rl);
684: l_prtn_eff_end_dt_rl := nvl(l_elig_plip_rec.prtn_eff_end_dt_rl ,l_prtn_elig_plip_rec.prtn_eff_end_dt_rl );
684: l_prtn_eff_end_dt_rl := nvl(l_elig_plip_rec.prtn_eff_end_dt_rl ,l_prtn_elig_plip_rec.prtn_eff_end_dt_rl );
685: end if;
686:
687: if l_prtn_eff_strt_dt_cd is null then
688: l_elig_pl_rec := ben_cobj_cache.g_pletpr_currow;
689: l_prtn_elig_pl_rec := ben_cobj_cache.g_plprel_currow;
690: l_prtn_eff_strt_dt_cd := nvl(l_elig_pl_rec.prtn_eff_strt_dt_cd,l_prtn_elig_pl_rec.prtn_eff_strt_dt_cd);
691: l_prtn_eff_end_dt_cd := nvl(l_elig_pl_rec.prtn_eff_end_dt_cd ,l_prtn_elig_pl_rec.prtn_eff_end_dt_cd );
692: l_prtn_eff_strt_dt_rl := nvl(l_elig_pl_rec.prtn_eff_strt_dt_rl,l_prtn_elig_pl_rec.prtn_eff_strt_dt_rl);
685: end if;
686:
687: if l_prtn_eff_strt_dt_cd is null then
688: l_elig_pl_rec := ben_cobj_cache.g_pletpr_currow;
689: l_prtn_elig_pl_rec := ben_cobj_cache.g_plprel_currow;
690: l_prtn_eff_strt_dt_cd := nvl(l_elig_pl_rec.prtn_eff_strt_dt_cd,l_prtn_elig_pl_rec.prtn_eff_strt_dt_cd);
691: l_prtn_eff_end_dt_cd := nvl(l_elig_pl_rec.prtn_eff_end_dt_cd ,l_prtn_elig_pl_rec.prtn_eff_end_dt_cd );
692: l_prtn_eff_strt_dt_rl := nvl(l_elig_pl_rec.prtn_eff_strt_dt_rl,l_prtn_elig_pl_rec.prtn_eff_strt_dt_rl);
693: l_prtn_eff_end_dt_rl := nvl(l_elig_pl_rec.prtn_eff_end_dt_rl ,l_prtn_elig_pl_rec.prtn_eff_end_dt_rl );
693: l_prtn_eff_end_dt_rl := nvl(l_elig_pl_rec.prtn_eff_end_dt_rl ,l_prtn_elig_pl_rec.prtn_eff_end_dt_rl );
694:
695: -- if cd is still null and oipl is in a program then get from ptip or pgm
696: if l_prtn_eff_strt_dt_cd is null and l_envptip_id is not null then
697: l_elig_ptip_rec := ben_cobj_cache.g_ptipetpr_currow;
698: l_prtn_elig_ptip_rec := ben_cobj_cache.g_ptipprel_currow;
699: l_prtn_eff_strt_dt_cd := nvl(l_elig_ptip_rec.prtn_eff_strt_dt_cd,l_prtn_elig_ptip_rec.prtn_eff_strt_dt_cd);
700: l_prtn_eff_end_dt_cd := nvl(l_elig_ptip_rec.prtn_eff_end_dt_cd ,l_prtn_elig_ptip_rec.prtn_eff_end_dt_cd );
701: l_prtn_eff_strt_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_strt_dt_rl,l_prtn_elig_ptip_rec.prtn_eff_strt_dt_rl);
694:
695: -- if cd is still null and oipl is in a program then get from ptip or pgm
696: if l_prtn_eff_strt_dt_cd is null and l_envptip_id is not null then
697: l_elig_ptip_rec := ben_cobj_cache.g_ptipetpr_currow;
698: l_prtn_elig_ptip_rec := ben_cobj_cache.g_ptipprel_currow;
699: l_prtn_eff_strt_dt_cd := nvl(l_elig_ptip_rec.prtn_eff_strt_dt_cd,l_prtn_elig_ptip_rec.prtn_eff_strt_dt_cd);
700: l_prtn_eff_end_dt_cd := nvl(l_elig_ptip_rec.prtn_eff_end_dt_cd ,l_prtn_elig_ptip_rec.prtn_eff_end_dt_cd );
701: l_prtn_eff_strt_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_strt_dt_rl,l_prtn_elig_ptip_rec.prtn_eff_strt_dt_rl);
702: l_prtn_eff_end_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_end_dt_rl ,l_prtn_elig_ptip_rec.prtn_eff_end_dt_rl );
701: l_prtn_eff_strt_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_strt_dt_rl,l_prtn_elig_ptip_rec.prtn_eff_strt_dt_rl);
702: l_prtn_eff_end_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_end_dt_rl ,l_prtn_elig_ptip_rec.prtn_eff_end_dt_rl );
703:
704: if l_prtn_eff_strt_dt_cd is null then
705: l_elig_pgm_rec := ben_cobj_cache.g_pgmetpr_currow;
706: l_prtn_elig_pgm_rec := ben_cobj_cache.g_pgmprel_currow;
707: l_prtn_eff_strt_dt_cd := nvl(l_elig_pgm_rec.prtn_eff_strt_dt_cd,l_prtn_elig_pgm_rec.prtn_eff_strt_dt_cd);
708: l_prtn_eff_end_dt_cd := nvl(l_elig_pgm_rec.prtn_eff_end_dt_cd ,l_prtn_elig_pgm_rec.prtn_eff_end_dt_cd );
709: l_prtn_eff_strt_dt_rl := nvl(l_elig_pgm_rec.prtn_eff_strt_dt_rl,l_prtn_elig_pgm_rec.prtn_eff_strt_dt_rl);
702: l_prtn_eff_end_dt_rl := nvl(l_elig_ptip_rec.prtn_eff_end_dt_rl ,l_prtn_elig_ptip_rec.prtn_eff_end_dt_rl );
703:
704: if l_prtn_eff_strt_dt_cd is null then
705: l_elig_pgm_rec := ben_cobj_cache.g_pgmetpr_currow;
706: l_prtn_elig_pgm_rec := ben_cobj_cache.g_pgmprel_currow;
707: l_prtn_eff_strt_dt_cd := nvl(l_elig_pgm_rec.prtn_eff_strt_dt_cd,l_prtn_elig_pgm_rec.prtn_eff_strt_dt_cd);
708: l_prtn_eff_end_dt_cd := nvl(l_elig_pgm_rec.prtn_eff_end_dt_cd ,l_prtn_elig_pgm_rec.prtn_eff_end_dt_cd );
709: l_prtn_eff_strt_dt_rl := nvl(l_elig_pgm_rec.prtn_eff_strt_dt_rl,l_prtn_elig_pgm_rec.prtn_eff_strt_dt_rl);
710: l_prtn_eff_end_dt_rl := nvl(l_elig_pgm_rec.prtn_eff_end_dt_rl ,l_prtn_elig_pgm_rec.prtn_eff_end_dt_rl );
801: end if;
802: --
803: if p_oipl_id is not null then
804: --
805: l_oipl_rec := ben_cobj_cache.g_oipl_currow;
806: --
807: end if;
808: --
809: l_outputs := benutils.formula
1010: end if;
1011: --
1012: if p_oipl_id is not null then
1013: --
1014: l_oipl_rec := ben_cobj_cache.g_oipl_currow;
1015: --
1016: end if;
1017: --
1018: l_outputs := benutils.formula
1179: l_correction boolean;
1180: l_update boolean;
1181: l_update_override boolean;
1182: l_update_change_insert boolean;
1183: l_oipl_rec ben_cobj_cache.g_oipl_inst_row;
1184: --
1185: l_envpgm_id number;
1186: l_envptip_id number;
1187: l_envplip_id number;
1420:
1421: l_ptnl_le c_ptnl_le%rowtype;
1422: --
1423: l_trk_inelig_per_flag varchar2(30);
1424: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
1425: l_pl_rec ben_cobj_cache.g_pl_inst_row;
1426: l_plip_rec ben_cobj_cache.g_plip_inst_row;
1427: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
1428: l_prtn_st_dt_aftr_wtg date;
1421: l_ptnl_le c_ptnl_le%rowtype;
1422: --
1423: l_trk_inelig_per_flag varchar2(30);
1424: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
1425: l_pl_rec ben_cobj_cache.g_pl_inst_row;
1426: l_plip_rec ben_cobj_cache.g_plip_inst_row;
1427: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
1428: l_prtn_st_dt_aftr_wtg date;
1429: l_prtn_eff_strt_dt_cd varchar2(80);
1422: --
1423: l_trk_inelig_per_flag varchar2(30);
1424: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
1425: l_pl_rec ben_cobj_cache.g_pl_inst_row;
1426: l_plip_rec ben_cobj_cache.g_plip_inst_row;
1427: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
1428: l_prtn_st_dt_aftr_wtg date;
1429: l_prtn_eff_strt_dt_cd varchar2(80);
1430: l_prtn_eff_strt_dt_rl number(15);
1423: l_trk_inelig_per_flag varchar2(30);
1424: l_pgm_rec ben_cobj_cache.g_pgm_inst_row;
1425: l_pl_rec ben_cobj_cache.g_pl_inst_row;
1426: l_plip_rec ben_cobj_cache.g_plip_inst_row;
1427: l_ptip_rec ben_cobj_cache.g_ptip_inst_row;
1428: l_prtn_st_dt_aftr_wtg date;
1429: l_prtn_eff_strt_dt_cd varchar2(80);
1430: l_prtn_eff_strt_dt_rl number(15);
1431: l_plan_ordr_num ben_pl_f.ordr_num%type;
1617: -- Check for previous eligibility for oipl.
1618: --
1619: if p_oipl_id is not null then --a
1620: --
1621: l_oipl_rec := ben_cobj_cache.g_oipl_currow;
1622: --
1623: if g_debug then
1624: hr_utility.set_location('open c_prvoptelch ben_determine_eligibility2.check_prev_elig', 10);
1625: end if;
3979: end if;
3980: --
3981: if p_pgm_id is not null then
3982: --
3983: l_pgm_rec := ben_cobj_cache.g_pgm_currow;
3984: --
3985: end if;
3986: --
3987: if p_pl_id is not null then
3985: end if;
3986: --
3987: if p_pl_id is not null then
3988: --
3989: l_pl_rec := ben_cobj_cache.g_pl_currow;
3990: --
3991: end if;
3992: --
3993: if p_plip_id is not null then
3991: end if;
3992: --
3993: if p_plip_id is not null then
3994: --
3995: l_plip_rec := ben_cobj_cache.g_plip_currow;
3996: --
3997: end if;
3998: --
3999: if p_ptip_id is not null then
3997: end if;
3998: --
3999: if p_ptip_id is not null then
4000: --
4001: l_ptip_rec := ben_cobj_cache.g_ptip_currow;
4002: --
4003: end if;
4004: --
4005: if not l_prev_eligibility