[Home] [Help]
523: l_bckdt_per_in_ler_rec get_bckdt_per_in_ler%ROWTYPE;
524: --
525: begin
526: --
527: hr_utility.set_location('Entering:'|| l_proc, 10);
528: --
529: open get_bckdt_per_in_ler;
530: fetch get_bckdt_per_in_ler into l_bckdt_per_in_ler_rec;
531: --
535: g_pil_id_cs_bckdt := l_bckdt_per_in_ler_rec.bckt_per_in_ler_id;
536: --
537: if get_bckdt_per_in_ler%found then
538: --
539: hr_utility.set_location('backout per in ler :'|| p_bckdt_per_in_ler_id, 10);
540: fnd_message.set_name('BEN','BEN_92246_BCKDT_PIL_FOUND');
541: fnd_message.set_token('LER_NAME',l_bckdt_per_in_ler_rec.name);
542: benutils.write(p_text => fnd_message.get);
543: --
543: --
544: end if;
545: close get_bckdt_per_in_ler;
546: --
547: hr_utility.set_location('Leaving:'|| l_proc, 10);
548: --
549: end get_ori_bckdt_pil;
550: --
551: -- ----------------------------------------------------------------------------
592: l_enrt_rslt_exists varchar2(1) := 'N';
593: --
594: begin
595: --
596: hr_utility.set_location ('Entering '||l_proc,10);
597: --
598: open c_enrt_rslt_exists;
599: fetch c_enrt_rslt_exists into l_enrt_rslt_exists;
600: close c_enrt_rslt_exists;
598: open c_enrt_rslt_exists;
599: fetch c_enrt_rslt_exists into l_enrt_rslt_exists;
600: close c_enrt_rslt_exists;
601: --
602: hr_utility.set_location ('Leaving '||l_proc,10);
603: --
604: return l_enrt_rslt_exists;
605: --
606: end ele_made_for_bckdt_pil;
650: l_found boolean;
651: --
652: begin
653: --
654: hr_utility.set_location ('Entering '||l_proc,10);
655: hr_utility.set_location ('Entering bck pil id '||p_prev_per_in_ler_id,10);
656: hr_utility.set_location ('Entering pil id '||p_new_per_in_ler_id,10);
657: --
658: --
651: --
652: begin
653: --
654: hr_utility.set_location ('Entering '||l_proc,10);
655: hr_utility.set_location ('Entering bck pil id '||p_prev_per_in_ler_id,10);
656: hr_utility.set_location ('Entering pil id '||p_new_per_in_ler_id,10);
657: --
658: --
659: for int_pen_rec in c_pen_dat(p_new_per_in_ler_id)
652: begin
653: --
654: hr_utility.set_location ('Entering '||l_proc,10);
655: hr_utility.set_location ('Entering bck pil id '||p_prev_per_in_ler_id,10);
656: hr_utility.set_location ('Entering pil id '||p_new_per_in_ler_id,10);
657: --
658: --
659: for int_pen_rec in c_pen_dat(p_new_per_in_ler_id)
660: loop
668: --
669: if nvl(l_int_pen_table.last, 0) = 0 then
670: --
671: l_differ := 'N';
672: hr_utility.set_location('Leaving: ' || l_differ
673: ||' 0 '|| l_proc, 10);
674: return l_differ;
675: --
676: end if;
676: end if;
677: --
678: -- Now compare the original pen record and new pen record.
679: --
680: hr_utility.set_location(to_char(nvl(l_int_pen_table.last, 0)) ,4987);
681: --
682: --
683: hr_utility.set_location(' Before first Loop ',4987);
684: for l_int_count in l_int_pen_table.first..l_int_pen_table.last loop
679: --
680: hr_utility.set_location(to_char(nvl(l_int_pen_table.last, 0)) ,4987);
681: --
682: --
683: hr_utility.set_location(' Before first Loop ',4987);
684: for l_int_count in l_int_pen_table.first..l_int_pen_table.last loop
685: --
686: l_found := FALSE;
687: --
684: for l_int_count in l_int_pen_table.first..l_int_pen_table.last loop
685: --
686: l_found := FALSE;
687: --
688: hr_utility.set_location(' Before Loop ',4987);
689: for prev_pen_rec in c_pen_dat(p_prev_per_in_ler_id)
690: loop
691: --
692: hr_utility.set_location(' Before if ',4987);
688: hr_utility.set_location(' Before Loop ',4987);
689: for prev_pen_rec in c_pen_dat(p_prev_per_in_ler_id)
690: loop
691: --
692: hr_utility.set_location(' Before if ',4987);
693: if nvl(prev_pen_rec.SSPNDD_FLAG, '$') =
694: nvl(l_int_pen_table(l_int_count).SSPNDD_FLAG, '$') and
695: nvl(prev_pen_rec.PGM_ID, -1) =
696: nvl(l_int_pen_table(l_int_count).PGM_ID, -1) and
714: end if;
715: --
716: end loop;
717: --
718: hr_utility.set_location('Leaving:' || l_differ || l_proc, 10);
719: --
720: return l_differ;
721: --
722: end comp_prev_new_pen;
789: l_count number := 0;
790: --
791: begin
792: --
793: hr_utility.set_location ('Entering '||l_proc,10);
794: --
795: p_inter_pil_cnt := 0;
796: open c_bckt_csd_pil;
797: fetch c_bckt_csd_pil into l_bckt_csd_lf_evt_ocrd_dt,l_bckt_csd_per_in_ler_id;
817: end if;
818: --
819: close c_inter_pil_cnt;
820: --
821: hr_utility.set_location ('Leaving '||l_proc,10);
822: --
823: end get_inter_pil_cnt;
824: --
825: -- ----------------------------------------------------------------------------
894: l_differ varchar2(30) := 'N';
895: --
896: begin
897: --
898: hr_utility.set_location ('Entering '||l_proc,10);
899: --
900: --First Get the intervening life event count
901: --
902: open c_ele_md_for_inter_pil;
916: p_inter_pil_cnt => l_inter_pil_cnt,
917: p_inter_pil_le_dt => l_inter_pil_le_dt,
918: p_effective_date => p_effective_date);
919: --
920: hr_utility.set_location ('l_inter_pil_cnt '||l_inter_pil_cnt,199);
921: hr_utility.set_location ('l_inter_pil_le_dt '||l_inter_pil_le_dt,199);
922: hr_utility.set_location ('l_inter_per_in_ler_id '||l_inter_per_in_ler_id,199);
923: hr_utility.set_location ('l_bckt_csd_lf_evt_ocrd_dt '||l_bckt_csd_lf_evt_ocrd_dt,199);
924: hr_utility.set_location ('l_bckt_csd_per_in_ler_id '||l_bckt_csd_per_in_ler_id,199);
917: p_inter_pil_le_dt => l_inter_pil_le_dt,
918: p_effective_date => p_effective_date);
919: --
920: hr_utility.set_location ('l_inter_pil_cnt '||l_inter_pil_cnt,199);
921: hr_utility.set_location ('l_inter_pil_le_dt '||l_inter_pil_le_dt,199);
922: hr_utility.set_location ('l_inter_per_in_ler_id '||l_inter_per_in_ler_id,199);
923: hr_utility.set_location ('l_bckt_csd_lf_evt_ocrd_dt '||l_bckt_csd_lf_evt_ocrd_dt,199);
924: hr_utility.set_location ('l_bckt_csd_per_in_ler_id '||l_bckt_csd_per_in_ler_id,199);
925: --
918: p_effective_date => p_effective_date);
919: --
920: hr_utility.set_location ('l_inter_pil_cnt '||l_inter_pil_cnt,199);
921: hr_utility.set_location ('l_inter_pil_le_dt '||l_inter_pil_le_dt,199);
922: hr_utility.set_location ('l_inter_per_in_ler_id '||l_inter_per_in_ler_id,199);
923: hr_utility.set_location ('l_bckt_csd_lf_evt_ocrd_dt '||l_bckt_csd_lf_evt_ocrd_dt,199);
924: hr_utility.set_location ('l_bckt_csd_per_in_ler_id '||l_bckt_csd_per_in_ler_id,199);
925: --
926: if l_inter_pil_cnt = 0 then
919: --
920: hr_utility.set_location ('l_inter_pil_cnt '||l_inter_pil_cnt,199);
921: hr_utility.set_location ('l_inter_pil_le_dt '||l_inter_pil_le_dt,199);
922: hr_utility.set_location ('l_inter_per_in_ler_id '||l_inter_per_in_ler_id,199);
923: hr_utility.set_location ('l_bckt_csd_lf_evt_ocrd_dt '||l_bckt_csd_lf_evt_ocrd_dt,199);
924: hr_utility.set_location ('l_bckt_csd_per_in_ler_id '||l_bckt_csd_per_in_ler_id,199);
925: --
926: if l_inter_pil_cnt = 0 then
927: --
920: hr_utility.set_location ('l_inter_pil_cnt '||l_inter_pil_cnt,199);
921: hr_utility.set_location ('l_inter_pil_le_dt '||l_inter_pil_le_dt,199);
922: hr_utility.set_location ('l_inter_per_in_ler_id '||l_inter_per_in_ler_id,199);
923: hr_utility.set_location ('l_bckt_csd_lf_evt_ocrd_dt '||l_bckt_csd_lf_evt_ocrd_dt,199);
924: hr_utility.set_location ('l_bckt_csd_per_in_ler_id '||l_bckt_csd_per_in_ler_id,199);
925: --
926: if l_inter_pil_cnt = 0 then
927: --
928: --Get the previous life event
931: close c_prev_pil;
932: --
933: if l_prev_per_in_ler_id is not null then
934: --
935: hr_utility.set_location ('l_prev_per_in_ler_id '||l_prev_per_in_ler_id,199);
936: --
937: l_differ := comp_prev_new_pen(p_person_id => p_person_id
938: ,p_business_group_id => p_business_group_id
939: ,p_effective_date => p_effective_date
939: ,p_effective_date => p_effective_date
940: ,p_new_per_in_ler_id => l_bckt_csd_per_in_ler_id
941: ,p_prev_per_in_ler_id=> l_prev_per_in_ler_id);
942: --
943: hr_utility.set_location (' l_differ '||l_differ,199);
944: if l_differ = 'N' then
945: --
946: l_enrt_rslt_exists := 'N';
947: --
973: ,p_effective_date => p_effective_date
974: ,p_new_per_in_ler_id => l_inter_per_in_ler_id
975: ,p_prev_per_in_ler_id=> l_bckt_csd_per_in_ler_id );
976: --
977: hr_utility.set_location (' l_differ '||l_differ,299);
978: if l_differ = 'N' then
979: --
980: l_enrt_rslt_exists := 'N';
981: --
996: l_enrt_rslt_exists := 'N';
997: --
998: end if;
999: --
1000: hr_utility.set_location ('Leaving l_enrt_rslt_exists '||l_enrt_rslt_exists,199);
1001: --
1002: hr_utility.set_location ('Leaving '||l_proc,10);
1003: --
1004: return l_enrt_rslt_exists;
998: end if;
999: --
1000: hr_utility.set_location ('Leaving l_enrt_rslt_exists '||l_enrt_rslt_exists,199);
1001: --
1002: hr_utility.set_location ('Leaving '||l_proc,10);
1003: --
1004: return l_enrt_rslt_exists;
1005: --
1006: end ele_made_for_inter_pil;
1052: l_bckdt_epe_egd_count number;
1053: --
1054: begin
1055: --
1056: hr_utility.set_location ('Entering '||l_proc,10);
1057: --
1058: select count(*) into l_bckdt_epe_egd_count
1059: from ben_elig_dpnt epe_egd
1060: where epe_egd.elig_per_elctbl_chc_id = p_bckdt_epe_id
1078: nvl(l_bckdt_epe_egd_count,0) = 0
1079: then
1080: --
1081: l_differ := 'N';
1082: hr_utility.set_location ('Leaving : N : 0 '||l_proc,10);
1083: return l_differ;
1084: --
1085: elsif nvl(l_curr_epe_egd_table.last, 0) <> nvl(l_bckdt_epe_egd_count,0) then
1086: --
1084: --
1085: elsif nvl(l_curr_epe_egd_table.last, 0) <> nvl(l_bckdt_epe_egd_count,0) then
1086: --
1087: l_differ := 'Y';
1088: hr_utility.set_location ('Leaving : Y : <>0 '||l_proc,10);
1089: hr_utility.set_location ('Leaving : Y : ' || nvl(l_curr_epe_egd_table.last, 0)
1090: || ' ' || nvl(l_bckdt_epe_egd_count,0) || ' ' ||
1091: l_proc,10);
1092: return l_differ;
1085: elsif nvl(l_curr_epe_egd_table.last, 0) <> nvl(l_bckdt_epe_egd_count,0) then
1086: --
1087: l_differ := 'Y';
1088: hr_utility.set_location ('Leaving : Y : <>0 '||l_proc,10);
1089: hr_utility.set_location ('Leaving : Y : ' || nvl(l_curr_epe_egd_table.last, 0)
1090: || ' ' || nvl(l_bckdt_epe_egd_count,0) || ' ' ||
1091: l_proc,10);
1092: return l_differ;
1093: --
1147: end if;
1148: --
1149: end loop;
1150: --
1151: hr_utility.set_location('Leaving: ' || l_differ || l_proc, 10);
1152: --
1153: return l_differ;
1154: --
1155: end comp_ori_new_egd;
1202: l_bckdt_enb_ecr_count number;
1203: --
1204: begin
1205: --
1206: hr_utility.set_location ('Entering '||l_proc,10);
1207: --
1208: select count(*) into l_bckdt_enb_ecr_count
1209: from ben_enrt_rt enb_ecr
1210: where enb_ecr.enrt_bnft_id = p_bckdt_enb_id
1227: nvl(l_bckdt_enb_ecr_count,0) = 0
1228: then
1229: --
1230: l_differ := 'N';
1231: hr_utility.set_location ('Leavingi : N : 0 '||l_proc,10);
1232: return l_differ;
1233: --
1234: elsif nvl(l_curr_enb_ecr_table.last, 0) <> nvl(l_bckdt_enb_ecr_count,0) then
1235: --
1233: --
1234: elsif nvl(l_curr_enb_ecr_table.last, 0) <> nvl(l_bckdt_enb_ecr_count,0) then
1235: --
1236: l_differ := 'Y';
1237: hr_utility.set_location ('Leavingi : Y : <>0 '||l_proc,10);
1238: return l_differ;
1239: --
1240: end if;
1241: --
1305: end if;
1306: --
1307: end loop;
1308: --
1309: hr_utility.set_location('Leaving:' || l_differ || l_proc, 10);
1310: --
1311: return l_differ;
1312: --
1313: end comp_ori_new_enb_ecr;
1359: l_bckdt_epe_ecr_count number;
1360: --
1361: begin
1362: --
1363: hr_utility.set_location ('Entering '||l_proc,10);
1364: --
1365: select count(*) into l_bckdt_epe_ecr_count
1366: from ben_enrt_rt epe_ecr
1367: where epe_ecr.elig_per_elctbl_chc_id = p_bckdt_epe_id
1396: nvl(l_bckdt_epe_ecr_count,0) = 0
1397: then
1398: --
1399: l_differ := 'N';
1400: hr_utility.set_location ('Leavingi : N : 0 '||l_proc,10);
1401: return l_differ;
1402: --
1403: elsif nvl(l_curr_epe_ecr_table.last, 0) <> nvl(l_bckdt_epe_ecr_count,0) then
1404: --
1402: --
1403: elsif nvl(l_curr_epe_ecr_table.last, 0) <> nvl(l_bckdt_epe_ecr_count,0) then
1404: --
1405: l_differ := 'Y';
1406: hr_utility.set_location ('Leavingi : Y : <>0 '||l_proc,10);
1407: return l_differ;
1408: --
1409: end if;
1410: --
1474: end if;
1475: --
1476: end loop;
1477: --
1478: hr_utility.set_location('Leaving:'||l_differ || l_proc, 10);
1479: --
1480: return l_differ;
1481: --
1482: end comp_ori_new_epe_ecr;
1551: l_bckdt_enb_count number;
1552: --
1553: begin
1554: --
1555: hr_utility.set_location ('Entering '||l_proc,10);
1556: --
1557: select count(*) into l_bckdt_enb_count
1558: from ben_enrt_bnft enb
1559: where enb.elig_per_elctbl_chc_id = p_bckdt_epe_id
1589: then
1590: --
1591: l_differ := 'N';
1592:
1593: hr_utility.set_location('Leaving: ' || l_differ ||' 0 '|| l_proc, 10);
1594: return l_differ;
1595: --
1596: elsif nvl(l_curr_enb_table.last, 0) <> nvl(l_bckdt_enb_count,0) then
1597: --
1596: elsif nvl(l_curr_enb_table.last, 0) <> nvl(l_bckdt_enb_count,0) then
1597: --
1598: l_differ := 'Y';
1599:
1600: hr_utility.set_location('Leaving: ' || l_differ ||' <>0 '|| l_proc, 10);
1601: return l_differ;
1602: --
1603: end if;
1604: --
1680: --
1681: end loop;
1682: --
1683:
1684: hr_utility.set_location('Leaving:' || l_differ || l_proc, 10);
1685: --
1686: return l_differ;
1687: --
1688: end comp_ori_new_enb;
1760: l_bckdt_ecd_count number;
1761: --
1762: begin
1763: --
1764: hr_utility.set_location ('Entering '||l_proc,10);
1765: --
1766: select count(*) into l_bckdt_ecd_count
1767: from ben_elig_cvrd_dpnt_f ecd,
1768: ben_per_in_ler pil
1793: then
1794: --
1795: l_differ := 'N';
1796:
1797: hr_utility.set_location('Leaving: ' || l_differ ||' 0 '|| l_proc, 10);
1798: return l_differ;
1799: --
1800: elsif nvl(l_curr_ecd_table.last, 0) <> nvl(l_bckdt_ecd_count,0) then
1801: --
1800: elsif nvl(l_curr_ecd_table.last, 0) <> nvl(l_bckdt_ecd_count,0) then
1801: --
1802: l_differ := 'Y';
1803:
1804: hr_utility.set_location('Leaving: ' || l_differ ||' <>0 '|| l_proc, 10);
1805: return l_differ;
1806: --
1807: end if;
1808: --
1839: --
1840: end loop;
1841: --
1842:
1843: hr_utility.set_location('Leaving: ' || l_differ ||' 0 '|| l_proc, 10);
1844: --
1845: return l_differ;
1846: --
1847: end comp_ori_new_ecd;
1935: l_found boolean;
1936: --
1937: begin
1938: --
1939: hr_utility.set_location ('Entering '||l_proc,10);
1940: --
1941: open c_bckdt_epe_cnt;
1942: fetch c_bckdt_epe_cnt into l_bckdt_epe_cnt;
1943: close c_bckdt_epe_cnt;
1986: --
1987: for l_count in l_bckdt_epe_table.first..l_bckdt_epe_table.last loop
1988: --
1989: /*
1990: hr_utility.set_location('pl_id = ' || nvl(l_bckdt_epe_table(l_count).pl_id, -1), 1234);
1991: hr_utility.set_location('oipl_id = ' || nvl(l_bckdt_epe_table(l_count).oipl_id, -1), 1234);
1992: hr_utility.set_location('PGM_ID = ' || nvl(l_bckdt_epe_table(l_count).PGM_ID, -1), 1234);
1993: hr_utility.set_location('PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PLIP_ID, -1), 1234);
1994: hr_utility.set_location('PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PTIP_ID, -1), 1234);
1987: for l_count in l_bckdt_epe_table.first..l_bckdt_epe_table.last loop
1988: --
1989: /*
1990: hr_utility.set_location('pl_id = ' || nvl(l_bckdt_epe_table(l_count).pl_id, -1), 1234);
1991: hr_utility.set_location('oipl_id = ' || nvl(l_bckdt_epe_table(l_count).oipl_id, -1), 1234);
1992: hr_utility.set_location('PGM_ID = ' || nvl(l_bckdt_epe_table(l_count).PGM_ID, -1), 1234);
1993: hr_utility.set_location('PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PLIP_ID, -1), 1234);
1994: hr_utility.set_location('PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PTIP_ID, -1), 1234);
1995: hr_utility.set_location('PL_TYP_ID = ' || nvl(l_bckdt_epe_table(l_count).PL_TYP_ID, -1), 1234);
1988: --
1989: /*
1990: hr_utility.set_location('pl_id = ' || nvl(l_bckdt_epe_table(l_count).pl_id, -1), 1234);
1991: hr_utility.set_location('oipl_id = ' || nvl(l_bckdt_epe_table(l_count).oipl_id, -1), 1234);
1992: hr_utility.set_location('PGM_ID = ' || nvl(l_bckdt_epe_table(l_count).PGM_ID, -1), 1234);
1993: hr_utility.set_location('PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PLIP_ID, -1), 1234);
1994: hr_utility.set_location('PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PTIP_ID, -1), 1234);
1995: hr_utility.set_location('PL_TYP_ID = ' || nvl(l_bckdt_epe_table(l_count).PL_TYP_ID, -1), 1234);
1996: hr_utility.set_location('CMBN_PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_ID, -1), 1234);
1989: /*
1990: hr_utility.set_location('pl_id = ' || nvl(l_bckdt_epe_table(l_count).pl_id, -1), 1234);
1991: hr_utility.set_location('oipl_id = ' || nvl(l_bckdt_epe_table(l_count).oipl_id, -1), 1234);
1992: hr_utility.set_location('PGM_ID = ' || nvl(l_bckdt_epe_table(l_count).PGM_ID, -1), 1234);
1993: hr_utility.set_location('PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PLIP_ID, -1), 1234);
1994: hr_utility.set_location('PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PTIP_ID, -1), 1234);
1995: hr_utility.set_location('PL_TYP_ID = ' || nvl(l_bckdt_epe_table(l_count).PL_TYP_ID, -1), 1234);
1996: hr_utility.set_location('CMBN_PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_ID, -1), 1234);
1997: hr_utility.set_location('CMBN_PTIP_OPT_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_OPT_ID, -1), 1234);
1990: hr_utility.set_location('pl_id = ' || nvl(l_bckdt_epe_table(l_count).pl_id, -1), 1234);
1991: hr_utility.set_location('oipl_id = ' || nvl(l_bckdt_epe_table(l_count).oipl_id, -1), 1234);
1992: hr_utility.set_location('PGM_ID = ' || nvl(l_bckdt_epe_table(l_count).PGM_ID, -1), 1234);
1993: hr_utility.set_location('PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PLIP_ID, -1), 1234);
1994: hr_utility.set_location('PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PTIP_ID, -1), 1234);
1995: hr_utility.set_location('PL_TYP_ID = ' || nvl(l_bckdt_epe_table(l_count).PL_TYP_ID, -1), 1234);
1996: hr_utility.set_location('CMBN_PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_ID, -1), 1234);
1997: hr_utility.set_location('CMBN_PTIP_OPT_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_OPT_ID, -1), 1234);
1998: hr_utility.set_location('CMBN_PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PLIP_ID, -1), 1234);
1991: hr_utility.set_location('oipl_id = ' || nvl(l_bckdt_epe_table(l_count).oipl_id, -1), 1234);
1992: hr_utility.set_location('PGM_ID = ' || nvl(l_bckdt_epe_table(l_count).PGM_ID, -1), 1234);
1993: hr_utility.set_location('PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PLIP_ID, -1), 1234);
1994: hr_utility.set_location('PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PTIP_ID, -1), 1234);
1995: hr_utility.set_location('PL_TYP_ID = ' || nvl(l_bckdt_epe_table(l_count).PL_TYP_ID, -1), 1234);
1996: hr_utility.set_location('CMBN_PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_ID, -1), 1234);
1997: hr_utility.set_location('CMBN_PTIP_OPT_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_OPT_ID, -1), 1234);
1998: hr_utility.set_location('CMBN_PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PLIP_ID, -1), 1234);
1999: hr_utility.set_location('SPCL_RT_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_PL_ID, -1), 1234);
1992: hr_utility.set_location('PGM_ID = ' || nvl(l_bckdt_epe_table(l_count).PGM_ID, -1), 1234);
1993: hr_utility.set_location('PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PLIP_ID, -1), 1234);
1994: hr_utility.set_location('PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PTIP_ID, -1), 1234);
1995: hr_utility.set_location('PL_TYP_ID = ' || nvl(l_bckdt_epe_table(l_count).PL_TYP_ID, -1), 1234);
1996: hr_utility.set_location('CMBN_PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_ID, -1), 1234);
1997: hr_utility.set_location('CMBN_PTIP_OPT_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_OPT_ID, -1), 1234);
1998: hr_utility.set_location('CMBN_PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PLIP_ID, -1), 1234);
1999: hr_utility.set_location('SPCL_RT_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_PL_ID, -1), 1234);
2000: hr_utility.set_location('SPCL_RT_OIPL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_OIPL_ID, -1), 1234);
1993: hr_utility.set_location('PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PLIP_ID, -1), 1234);
1994: hr_utility.set_location('PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PTIP_ID, -1), 1234);
1995: hr_utility.set_location('PL_TYP_ID = ' || nvl(l_bckdt_epe_table(l_count).PL_TYP_ID, -1), 1234);
1996: hr_utility.set_location('CMBN_PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_ID, -1), 1234);
1997: hr_utility.set_location('CMBN_PTIP_OPT_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_OPT_ID, -1), 1234);
1998: hr_utility.set_location('CMBN_PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PLIP_ID, -1), 1234);
1999: hr_utility.set_location('SPCL_RT_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_PL_ID, -1), 1234);
2000: hr_utility.set_location('SPCL_RT_OIPL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_OIPL_ID, -1), 1234);
2001: hr_utility.set_location('MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
1994: hr_utility.set_location('PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).PTIP_ID, -1), 1234);
1995: hr_utility.set_location('PL_TYP_ID = ' || nvl(l_bckdt_epe_table(l_count).PL_TYP_ID, -1), 1234);
1996: hr_utility.set_location('CMBN_PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_ID, -1), 1234);
1997: hr_utility.set_location('CMBN_PTIP_OPT_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_OPT_ID, -1), 1234);
1998: hr_utility.set_location('CMBN_PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PLIP_ID, -1), 1234);
1999: hr_utility.set_location('SPCL_RT_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_PL_ID, -1), 1234);
2000: hr_utility.set_location('SPCL_RT_OIPL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_OIPL_ID, -1), 1234);
2001: hr_utility.set_location('MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2002: hr_utility.set_location('DFLT_FLAG = ' || l_bckdt_epe_table(l_count).DFLT_FLAG, 1234);
1995: hr_utility.set_location('PL_TYP_ID = ' || nvl(l_bckdt_epe_table(l_count).PL_TYP_ID, -1), 1234);
1996: hr_utility.set_location('CMBN_PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_ID, -1), 1234);
1997: hr_utility.set_location('CMBN_PTIP_OPT_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_OPT_ID, -1), 1234);
1998: hr_utility.set_location('CMBN_PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PLIP_ID, -1), 1234);
1999: hr_utility.set_location('SPCL_RT_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_PL_ID, -1), 1234);
2000: hr_utility.set_location('SPCL_RT_OIPL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_OIPL_ID, -1), 1234);
2001: hr_utility.set_location('MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2002: hr_utility.set_location('DFLT_FLAG = ' || l_bckdt_epe_table(l_count).DFLT_FLAG, 1234);
2003: hr_utility.set_location('ELCTBL_FLAG = ' || l_bckdt_epe_table(l_count).ELCTBL_FLAG, 1234);
1996: hr_utility.set_location('CMBN_PTIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_ID, -1), 1234);
1997: hr_utility.set_location('CMBN_PTIP_OPT_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_OPT_ID, -1), 1234);
1998: hr_utility.set_location('CMBN_PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PLIP_ID, -1), 1234);
1999: hr_utility.set_location('SPCL_RT_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_PL_ID, -1), 1234);
2000: hr_utility.set_location('SPCL_RT_OIPL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_OIPL_ID, -1), 1234);
2001: hr_utility.set_location('MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2002: hr_utility.set_location('DFLT_FLAG = ' || l_bckdt_epe_table(l_count).DFLT_FLAG, 1234);
2003: hr_utility.set_location('ELCTBL_FLAG = ' || l_bckdt_epe_table(l_count).ELCTBL_FLAG, 1234);
2004: hr_utility.set_location('MNDTRY_FLAG = ' || l_bckdt_epe_table(l_count).MNDTRY_FLAG, 1234);
1997: hr_utility.set_location('CMBN_PTIP_OPT_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PTIP_OPT_ID, -1), 1234);
1998: hr_utility.set_location('CMBN_PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PLIP_ID, -1), 1234);
1999: hr_utility.set_location('SPCL_RT_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_PL_ID, -1), 1234);
2000: hr_utility.set_location('SPCL_RT_OIPL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_OIPL_ID, -1), 1234);
2001: hr_utility.set_location('MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2002: hr_utility.set_location('DFLT_FLAG = ' || l_bckdt_epe_table(l_count).DFLT_FLAG, 1234);
2003: hr_utility.set_location('ELCTBL_FLAG = ' || l_bckdt_epe_table(l_count).ELCTBL_FLAG, 1234);
2004: hr_utility.set_location('MNDTRY_FLAG = ' || l_bckdt_epe_table(l_count).MNDTRY_FLAG, 1234);
2005: hr_utility.set_location('ALWS_DPNT_DSGN_FLAG = ' || l_bckdt_epe_table(l_count).ALWS_DPNT_DSGN_FLAG, 1234);
1998: hr_utility.set_location('CMBN_PLIP_ID = ' || nvl(l_bckdt_epe_table(l_count).CMBN_PLIP_ID, -1), 1234);
1999: hr_utility.set_location('SPCL_RT_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_PL_ID, -1), 1234);
2000: hr_utility.set_location('SPCL_RT_OIPL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_OIPL_ID, -1), 1234);
2001: hr_utility.set_location('MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2002: hr_utility.set_location('DFLT_FLAG = ' || l_bckdt_epe_table(l_count).DFLT_FLAG, 1234);
2003: hr_utility.set_location('ELCTBL_FLAG = ' || l_bckdt_epe_table(l_count).ELCTBL_FLAG, 1234);
2004: hr_utility.set_location('MNDTRY_FLAG = ' || l_bckdt_epe_table(l_count).MNDTRY_FLAG, 1234);
2005: hr_utility.set_location('ALWS_DPNT_DSGN_FLAG = ' || l_bckdt_epe_table(l_count).ALWS_DPNT_DSGN_FLAG, 1234);
2006: hr_utility.set_location('AUTO_ENRT_FLAG = ' || l_bckdt_epe_table(l_count).AUTO_ENRT_FLAG, 1234);
1999: hr_utility.set_location('SPCL_RT_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_PL_ID, -1), 1234);
2000: hr_utility.set_location('SPCL_RT_OIPL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_OIPL_ID, -1), 1234);
2001: hr_utility.set_location('MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2002: hr_utility.set_location('DFLT_FLAG = ' || l_bckdt_epe_table(l_count).DFLT_FLAG, 1234);
2003: hr_utility.set_location('ELCTBL_FLAG = ' || l_bckdt_epe_table(l_count).ELCTBL_FLAG, 1234);
2004: hr_utility.set_location('MNDTRY_FLAG = ' || l_bckdt_epe_table(l_count).MNDTRY_FLAG, 1234);
2005: hr_utility.set_location('ALWS_DPNT_DSGN_FLAG = ' || l_bckdt_epe_table(l_count).ALWS_DPNT_DSGN_FLAG, 1234);
2006: hr_utility.set_location('AUTO_ENRT_FLAG = ' || l_bckdt_epe_table(l_count).AUTO_ENRT_FLAG, 1234);
2007: hr_utility.set_location('CTFN_RQD_FLAG = ' || l_bckdt_epe_table(l_count).CTFN_RQD_FLAG, 1234);
2000: hr_utility.set_location('SPCL_RT_OIPL_ID = ' || nvl(l_bckdt_epe_table(l_count).SPCL_RT_OIPL_ID, -1), 1234);
2001: hr_utility.set_location('MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2002: hr_utility.set_location('DFLT_FLAG = ' || l_bckdt_epe_table(l_count).DFLT_FLAG, 1234);
2003: hr_utility.set_location('ELCTBL_FLAG = ' || l_bckdt_epe_table(l_count).ELCTBL_FLAG, 1234);
2004: hr_utility.set_location('MNDTRY_FLAG = ' || l_bckdt_epe_table(l_count).MNDTRY_FLAG, 1234);
2005: hr_utility.set_location('ALWS_DPNT_DSGN_FLAG = ' || l_bckdt_epe_table(l_count).ALWS_DPNT_DSGN_FLAG, 1234);
2006: hr_utility.set_location('AUTO_ENRT_FLAG = ' || l_bckdt_epe_table(l_count).AUTO_ENRT_FLAG, 1234);
2007: hr_utility.set_location('CTFN_RQD_FLAG = ' || l_bckdt_epe_table(l_count).CTFN_RQD_FLAG, 1234);
2008: hr_utility.set_location('BNFT_PRVDR_POOL_ID = ' || nvl(l_bckdt_epe_table(l_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2001: hr_utility.set_location('MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_bckdt_epe_table(l_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2002: hr_utility.set_location('DFLT_FLAG = ' || l_bckdt_epe_table(l_count).DFLT_FLAG, 1234);
2003: hr_utility.set_location('ELCTBL_FLAG = ' || l_bckdt_epe_table(l_count).ELCTBL_FLAG, 1234);
2004: hr_utility.set_location('MNDTRY_FLAG = ' || l_bckdt_epe_table(l_count).MNDTRY_FLAG, 1234);
2005: hr_utility.set_location('ALWS_DPNT_DSGN_FLAG = ' || l_bckdt_epe_table(l_count).ALWS_DPNT_DSGN_FLAG, 1234);
2006: hr_utility.set_location('AUTO_ENRT_FLAG = ' || l_bckdt_epe_table(l_count).AUTO_ENRT_FLAG, 1234);
2007: hr_utility.set_location('CTFN_RQD_FLAG = ' || l_bckdt_epe_table(l_count).CTFN_RQD_FLAG, 1234);
2008: hr_utility.set_location('BNFT_PRVDR_POOL_ID = ' || nvl(l_bckdt_epe_table(l_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2009: hr_utility.set_location('YR_PERD_ID = ' || nvl(l_bckdt_epe_table(l_count).YR_PERD_ID, -1), 1234);
2002: hr_utility.set_location('DFLT_FLAG = ' || l_bckdt_epe_table(l_count).DFLT_FLAG, 1234);
2003: hr_utility.set_location('ELCTBL_FLAG = ' || l_bckdt_epe_table(l_count).ELCTBL_FLAG, 1234);
2004: hr_utility.set_location('MNDTRY_FLAG = ' || l_bckdt_epe_table(l_count).MNDTRY_FLAG, 1234);
2005: hr_utility.set_location('ALWS_DPNT_DSGN_FLAG = ' || l_bckdt_epe_table(l_count).ALWS_DPNT_DSGN_FLAG, 1234);
2006: hr_utility.set_location('AUTO_ENRT_FLAG = ' || l_bckdt_epe_table(l_count).AUTO_ENRT_FLAG, 1234);
2007: hr_utility.set_location('CTFN_RQD_FLAG = ' || l_bckdt_epe_table(l_count).CTFN_RQD_FLAG, 1234);
2008: hr_utility.set_location('BNFT_PRVDR_POOL_ID = ' || nvl(l_bckdt_epe_table(l_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2009: hr_utility.set_location('YR_PERD_ID = ' || nvl(l_bckdt_epe_table(l_count).YR_PERD_ID, -1), 1234);
2010: hr_utility.set_location('ENRT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2003: hr_utility.set_location('ELCTBL_FLAG = ' || l_bckdt_epe_table(l_count).ELCTBL_FLAG, 1234);
2004: hr_utility.set_location('MNDTRY_FLAG = ' || l_bckdt_epe_table(l_count).MNDTRY_FLAG, 1234);
2005: hr_utility.set_location('ALWS_DPNT_DSGN_FLAG = ' || l_bckdt_epe_table(l_count).ALWS_DPNT_DSGN_FLAG, 1234);
2006: hr_utility.set_location('AUTO_ENRT_FLAG = ' || l_bckdt_epe_table(l_count).AUTO_ENRT_FLAG, 1234);
2007: hr_utility.set_location('CTFN_RQD_FLAG = ' || l_bckdt_epe_table(l_count).CTFN_RQD_FLAG, 1234);
2008: hr_utility.set_location('BNFT_PRVDR_POOL_ID = ' || nvl(l_bckdt_epe_table(l_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2009: hr_utility.set_location('YR_PERD_ID = ' || nvl(l_bckdt_epe_table(l_count).YR_PERD_ID, -1), 1234);
2010: hr_utility.set_location('ENRT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2011: hr_utility.set_location('ENRT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2004: hr_utility.set_location('MNDTRY_FLAG = ' || l_bckdt_epe_table(l_count).MNDTRY_FLAG, 1234);
2005: hr_utility.set_location('ALWS_DPNT_DSGN_FLAG = ' || l_bckdt_epe_table(l_count).ALWS_DPNT_DSGN_FLAG, 1234);
2006: hr_utility.set_location('AUTO_ENRT_FLAG = ' || l_bckdt_epe_table(l_count).AUTO_ENRT_FLAG, 1234);
2007: hr_utility.set_location('CTFN_RQD_FLAG = ' || l_bckdt_epe_table(l_count).CTFN_RQD_FLAG, 1234);
2008: hr_utility.set_location('BNFT_PRVDR_POOL_ID = ' || nvl(l_bckdt_epe_table(l_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2009: hr_utility.set_location('YR_PERD_ID = ' || nvl(l_bckdt_epe_table(l_count).YR_PERD_ID, -1), 1234);
2010: hr_utility.set_location('ENRT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2011: hr_utility.set_location('ENRT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2012: hr_utility.set_location('DPNT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2005: hr_utility.set_location('ALWS_DPNT_DSGN_FLAG = ' || l_bckdt_epe_table(l_count).ALWS_DPNT_DSGN_FLAG, 1234);
2006: hr_utility.set_location('AUTO_ENRT_FLAG = ' || l_bckdt_epe_table(l_count).AUTO_ENRT_FLAG, 1234);
2007: hr_utility.set_location('CTFN_RQD_FLAG = ' || l_bckdt_epe_table(l_count).CTFN_RQD_FLAG, 1234);
2008: hr_utility.set_location('BNFT_PRVDR_POOL_ID = ' || nvl(l_bckdt_epe_table(l_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2009: hr_utility.set_location('YR_PERD_ID = ' || nvl(l_bckdt_epe_table(l_count).YR_PERD_ID, -1), 1234);
2010: hr_utility.set_location('ENRT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2011: hr_utility.set_location('ENRT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2012: hr_utility.set_location('DPNT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2013: hr_utility.set_location('LER_CHG_DPNT_CVG_CD = ' || nvl(l_bckdt_epe_table(l_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2006: hr_utility.set_location('AUTO_ENRT_FLAG = ' || l_bckdt_epe_table(l_count).AUTO_ENRT_FLAG, 1234);
2007: hr_utility.set_location('CTFN_RQD_FLAG = ' || l_bckdt_epe_table(l_count).CTFN_RQD_FLAG, 1234);
2008: hr_utility.set_location('BNFT_PRVDR_POOL_ID = ' || nvl(l_bckdt_epe_table(l_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2009: hr_utility.set_location('YR_PERD_ID = ' || nvl(l_bckdt_epe_table(l_count).YR_PERD_ID, -1), 1234);
2010: hr_utility.set_location('ENRT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2011: hr_utility.set_location('ENRT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2012: hr_utility.set_location('DPNT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2013: hr_utility.set_location('LER_CHG_DPNT_CVG_CD = ' || nvl(l_bckdt_epe_table(l_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2014: hr_utility.set_location('DPNT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2007: hr_utility.set_location('CTFN_RQD_FLAG = ' || l_bckdt_epe_table(l_count).CTFN_RQD_FLAG, 1234);
2008: hr_utility.set_location('BNFT_PRVDR_POOL_ID = ' || nvl(l_bckdt_epe_table(l_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2009: hr_utility.set_location('YR_PERD_ID = ' || nvl(l_bckdt_epe_table(l_count).YR_PERD_ID, -1), 1234);
2010: hr_utility.set_location('ENRT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2011: hr_utility.set_location('ENRT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2012: hr_utility.set_location('DPNT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2013: hr_utility.set_location('LER_CHG_DPNT_CVG_CD = ' || nvl(l_bckdt_epe_table(l_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2014: hr_utility.set_location('DPNT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2015: hr_utility.set_location('ENRT_CVG_STRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);
2008: hr_utility.set_location('BNFT_PRVDR_POOL_ID = ' || nvl(l_bckdt_epe_table(l_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2009: hr_utility.set_location('YR_PERD_ID = ' || nvl(l_bckdt_epe_table(l_count).YR_PERD_ID, -1), 1234);
2010: hr_utility.set_location('ENRT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2011: hr_utility.set_location('ENRT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2012: hr_utility.set_location('DPNT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2013: hr_utility.set_location('LER_CHG_DPNT_CVG_CD = ' || nvl(l_bckdt_epe_table(l_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2014: hr_utility.set_location('DPNT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2015: hr_utility.set_location('ENRT_CVG_STRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);
2016: hr_utility.set_location('ERLST_DEENRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot), 1234);
2009: hr_utility.set_location('YR_PERD_ID = ' || nvl(l_bckdt_epe_table(l_count).YR_PERD_ID, -1), 1234);
2010: hr_utility.set_location('ENRT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2011: hr_utility.set_location('ENRT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2012: hr_utility.set_location('DPNT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2013: hr_utility.set_location('LER_CHG_DPNT_CVG_CD = ' || nvl(l_bckdt_epe_table(l_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2014: hr_utility.set_location('DPNT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2015: hr_utility.set_location('ENRT_CVG_STRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);
2016: hr_utility.set_location('ERLST_DEENRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot), 1234);
2017: */
2010: hr_utility.set_location('ENRT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2011: hr_utility.set_location('ENRT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2012: hr_utility.set_location('DPNT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2013: hr_utility.set_location('LER_CHG_DPNT_CVG_CD = ' || nvl(l_bckdt_epe_table(l_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2014: hr_utility.set_location('DPNT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2015: hr_utility.set_location('ENRT_CVG_STRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);
2016: hr_utility.set_location('ERLST_DEENRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot), 1234);
2017: */
2018: l_found := FALSE;
2011: hr_utility.set_location('ENRT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2012: hr_utility.set_location('DPNT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2013: hr_utility.set_location('LER_CHG_DPNT_CVG_CD = ' || nvl(l_bckdt_epe_table(l_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2014: hr_utility.set_location('DPNT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2015: hr_utility.set_location('ENRT_CVG_STRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);
2016: hr_utility.set_location('ERLST_DEENRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot), 1234);
2017: */
2018: l_found := FALSE;
2019: l_diff_auto_flag := TRUE ;
2012: hr_utility.set_location('DPNT_CVG_STRT_DT_CD = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2013: hr_utility.set_location('LER_CHG_DPNT_CVG_CD = ' || nvl(l_bckdt_epe_table(l_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2014: hr_utility.set_location('DPNT_CVG_STRT_DT_RL = ' || nvl(l_bckdt_epe_table(l_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2015: hr_utility.set_location('ENRT_CVG_STRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);
2016: hr_utility.set_location('ERLST_DEENRT_DT = ' || nvl(l_bckdt_epe_table(l_count).ERLST_DEENRT_DT, hr_api.g_eot), 1234);
2017: */
2018: l_found := FALSE;
2019: l_diff_auto_flag := TRUE ;
2020: --
2020: --
2021: for l_curr_count in l_curr_epe_table.first..l_curr_epe_table.last loop
2022: --
2023: /*
2024: hr_utility.set_location('Curr pl_id = ' || nvl(l_curr_epe_table(l_curr_count).pl_id, -1), 1234);
2025: hr_utility.set_location('Curr oipl_id = ' || nvl(l_curr_epe_table(l_curr_count).oipl_id, -1), 1234);
2026: hr_utility.set_location('Curr PGM_ID = ' || nvl(l_curr_epe_table(l_curr_count).PGM_ID, -1), 1234);
2027: hr_utility.set_location('Curr PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PLIP_ID, -1), 1234);
2028: hr_utility.set_location('Curr PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PTIP_ID, -1), 1234);
2021: for l_curr_count in l_curr_epe_table.first..l_curr_epe_table.last loop
2022: --
2023: /*
2024: hr_utility.set_location('Curr pl_id = ' || nvl(l_curr_epe_table(l_curr_count).pl_id, -1), 1234);
2025: hr_utility.set_location('Curr oipl_id = ' || nvl(l_curr_epe_table(l_curr_count).oipl_id, -1), 1234);
2026: hr_utility.set_location('Curr PGM_ID = ' || nvl(l_curr_epe_table(l_curr_count).PGM_ID, -1), 1234);
2027: hr_utility.set_location('Curr PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PLIP_ID, -1), 1234);
2028: hr_utility.set_location('Curr PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PTIP_ID, -1), 1234);
2029: hr_utility.set_location('Curr PL_TYP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PL_TYP_ID, -1), 1234);
2022: --
2023: /*
2024: hr_utility.set_location('Curr pl_id = ' || nvl(l_curr_epe_table(l_curr_count).pl_id, -1), 1234);
2025: hr_utility.set_location('Curr oipl_id = ' || nvl(l_curr_epe_table(l_curr_count).oipl_id, -1), 1234);
2026: hr_utility.set_location('Curr PGM_ID = ' || nvl(l_curr_epe_table(l_curr_count).PGM_ID, -1), 1234);
2027: hr_utility.set_location('Curr PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PLIP_ID, -1), 1234);
2028: hr_utility.set_location('Curr PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PTIP_ID, -1), 1234);
2029: hr_utility.set_location('Curr PL_TYP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PL_TYP_ID, -1), 1234);
2030: hr_utility.set_location('Curr CMBN_PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_ID, -1), 1234);
2023: /*
2024: hr_utility.set_location('Curr pl_id = ' || nvl(l_curr_epe_table(l_curr_count).pl_id, -1), 1234);
2025: hr_utility.set_location('Curr oipl_id = ' || nvl(l_curr_epe_table(l_curr_count).oipl_id, -1), 1234);
2026: hr_utility.set_location('Curr PGM_ID = ' || nvl(l_curr_epe_table(l_curr_count).PGM_ID, -1), 1234);
2027: hr_utility.set_location('Curr PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PLIP_ID, -1), 1234);
2028: hr_utility.set_location('Curr PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PTIP_ID, -1), 1234);
2029: hr_utility.set_location('Curr PL_TYP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PL_TYP_ID, -1), 1234);
2030: hr_utility.set_location('Curr CMBN_PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_ID, -1), 1234);
2031: hr_utility.set_location('Curr CMBN_PTIP_OPT_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_OPT_ID, -1), 1234);
2024: hr_utility.set_location('Curr pl_id = ' || nvl(l_curr_epe_table(l_curr_count).pl_id, -1), 1234);
2025: hr_utility.set_location('Curr oipl_id = ' || nvl(l_curr_epe_table(l_curr_count).oipl_id, -1), 1234);
2026: hr_utility.set_location('Curr PGM_ID = ' || nvl(l_curr_epe_table(l_curr_count).PGM_ID, -1), 1234);
2027: hr_utility.set_location('Curr PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PLIP_ID, -1), 1234);
2028: hr_utility.set_location('Curr PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PTIP_ID, -1), 1234);
2029: hr_utility.set_location('Curr PL_TYP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PL_TYP_ID, -1), 1234);
2030: hr_utility.set_location('Curr CMBN_PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_ID, -1), 1234);
2031: hr_utility.set_location('Curr CMBN_PTIP_OPT_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_OPT_ID, -1), 1234);
2032: hr_utility.set_location('Curr CMBN_PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PLIP_ID, -1), 1234);
2025: hr_utility.set_location('Curr oipl_id = ' || nvl(l_curr_epe_table(l_curr_count).oipl_id, -1), 1234);
2026: hr_utility.set_location('Curr PGM_ID = ' || nvl(l_curr_epe_table(l_curr_count).PGM_ID, -1), 1234);
2027: hr_utility.set_location('Curr PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PLIP_ID, -1), 1234);
2028: hr_utility.set_location('Curr PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PTIP_ID, -1), 1234);
2029: hr_utility.set_location('Curr PL_TYP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PL_TYP_ID, -1), 1234);
2030: hr_utility.set_location('Curr CMBN_PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_ID, -1), 1234);
2031: hr_utility.set_location('Curr CMBN_PTIP_OPT_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_OPT_ID, -1), 1234);
2032: hr_utility.set_location('Curr CMBN_PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PLIP_ID, -1), 1234);
2033: hr_utility.set_location('Curr SPCL_RT_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_PL_ID, -1), 1234);
2026: hr_utility.set_location('Curr PGM_ID = ' || nvl(l_curr_epe_table(l_curr_count).PGM_ID, -1), 1234);
2027: hr_utility.set_location('Curr PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PLIP_ID, -1), 1234);
2028: hr_utility.set_location('Curr PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PTIP_ID, -1), 1234);
2029: hr_utility.set_location('Curr PL_TYP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PL_TYP_ID, -1), 1234);
2030: hr_utility.set_location('Curr CMBN_PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_ID, -1), 1234);
2031: hr_utility.set_location('Curr CMBN_PTIP_OPT_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_OPT_ID, -1), 1234);
2032: hr_utility.set_location('Curr CMBN_PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PLIP_ID, -1), 1234);
2033: hr_utility.set_location('Curr SPCL_RT_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_PL_ID, -1), 1234);
2034: hr_utility.set_location('Curr SPCL_RT_OIPL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_OIPL_ID, -1), 1234);
2027: hr_utility.set_location('Curr PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PLIP_ID, -1), 1234);
2028: hr_utility.set_location('Curr PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PTIP_ID, -1), 1234);
2029: hr_utility.set_location('Curr PL_TYP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PL_TYP_ID, -1), 1234);
2030: hr_utility.set_location('Curr CMBN_PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_ID, -1), 1234);
2031: hr_utility.set_location('Curr CMBN_PTIP_OPT_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_OPT_ID, -1), 1234);
2032: hr_utility.set_location('Curr CMBN_PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PLIP_ID, -1), 1234);
2033: hr_utility.set_location('Curr SPCL_RT_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_PL_ID, -1), 1234);
2034: hr_utility.set_location('Curr SPCL_RT_OIPL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_OIPL_ID, -1), 1234);
2035: hr_utility.set_location('Curr MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2028: hr_utility.set_location('Curr PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PTIP_ID, -1), 1234);
2029: hr_utility.set_location('Curr PL_TYP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PL_TYP_ID, -1), 1234);
2030: hr_utility.set_location('Curr CMBN_PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_ID, -1), 1234);
2031: hr_utility.set_location('Curr CMBN_PTIP_OPT_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_OPT_ID, -1), 1234);
2032: hr_utility.set_location('Curr CMBN_PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PLIP_ID, -1), 1234);
2033: hr_utility.set_location('Curr SPCL_RT_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_PL_ID, -1), 1234);
2034: hr_utility.set_location('Curr SPCL_RT_OIPL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_OIPL_ID, -1), 1234);
2035: hr_utility.set_location('Curr MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2036: hr_utility.set_location('Curr DFLT_FLAG = ' || l_curr_epe_table(l_curr_count).DFLT_FLAG, 1234);
2029: hr_utility.set_location('Curr PL_TYP_ID = ' || nvl(l_curr_epe_table(l_curr_count).PL_TYP_ID, -1), 1234);
2030: hr_utility.set_location('Curr CMBN_PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_ID, -1), 1234);
2031: hr_utility.set_location('Curr CMBN_PTIP_OPT_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_OPT_ID, -1), 1234);
2032: hr_utility.set_location('Curr CMBN_PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PLIP_ID, -1), 1234);
2033: hr_utility.set_location('Curr SPCL_RT_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_PL_ID, -1), 1234);
2034: hr_utility.set_location('Curr SPCL_RT_OIPL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_OIPL_ID, -1), 1234);
2035: hr_utility.set_location('Curr MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2036: hr_utility.set_location('Curr DFLT_FLAG = ' || l_curr_epe_table(l_curr_count).DFLT_FLAG, 1234);
2037: hr_utility.set_location('Curr ELCTBL_FLAG = ' || l_curr_epe_table(l_curr_count).ELCTBL_FLAG, 1234);
2030: hr_utility.set_location('Curr CMBN_PTIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_ID, -1), 1234);
2031: hr_utility.set_location('Curr CMBN_PTIP_OPT_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_OPT_ID, -1), 1234);
2032: hr_utility.set_location('Curr CMBN_PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PLIP_ID, -1), 1234);
2033: hr_utility.set_location('Curr SPCL_RT_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_PL_ID, -1), 1234);
2034: hr_utility.set_location('Curr SPCL_RT_OIPL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_OIPL_ID, -1), 1234);
2035: hr_utility.set_location('Curr MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2036: hr_utility.set_location('Curr DFLT_FLAG = ' || l_curr_epe_table(l_curr_count).DFLT_FLAG, 1234);
2037: hr_utility.set_location('Curr ELCTBL_FLAG = ' || l_curr_epe_table(l_curr_count).ELCTBL_FLAG, 1234);
2038: hr_utility.set_location('Curr MNDTRY_FLAG = ' || l_curr_epe_table(l_curr_count).MNDTRY_FLAG, 1234);
2031: hr_utility.set_location('Curr CMBN_PTIP_OPT_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PTIP_OPT_ID, -1), 1234);
2032: hr_utility.set_location('Curr CMBN_PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PLIP_ID, -1), 1234);
2033: hr_utility.set_location('Curr SPCL_RT_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_PL_ID, -1), 1234);
2034: hr_utility.set_location('Curr SPCL_RT_OIPL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_OIPL_ID, -1), 1234);
2035: hr_utility.set_location('Curr MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2036: hr_utility.set_location('Curr DFLT_FLAG = ' || l_curr_epe_table(l_curr_count).DFLT_FLAG, 1234);
2037: hr_utility.set_location('Curr ELCTBL_FLAG = ' || l_curr_epe_table(l_curr_count).ELCTBL_FLAG, 1234);
2038: hr_utility.set_location('Curr MNDTRY_FLAG = ' || l_curr_epe_table(l_curr_count).MNDTRY_FLAG, 1234);
2039: hr_utility.set_location('Curr ALWS_DPNT_DSGN_FLAG = ' || l_curr_epe_table(l_curr_count).ALWS_DPNT_DSGN_FLAG, 1234);
2032: hr_utility.set_location('Curr CMBN_PLIP_ID = ' || nvl(l_curr_epe_table(l_curr_count).CMBN_PLIP_ID, -1), 1234);
2033: hr_utility.set_location('Curr SPCL_RT_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_PL_ID, -1), 1234);
2034: hr_utility.set_location('Curr SPCL_RT_OIPL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_OIPL_ID, -1), 1234);
2035: hr_utility.set_location('Curr MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2036: hr_utility.set_location('Curr DFLT_FLAG = ' || l_curr_epe_table(l_curr_count).DFLT_FLAG, 1234);
2037: hr_utility.set_location('Curr ELCTBL_FLAG = ' || l_curr_epe_table(l_curr_count).ELCTBL_FLAG, 1234);
2038: hr_utility.set_location('Curr MNDTRY_FLAG = ' || l_curr_epe_table(l_curr_count).MNDTRY_FLAG, 1234);
2039: hr_utility.set_location('Curr ALWS_DPNT_DSGN_FLAG = ' || l_curr_epe_table(l_curr_count).ALWS_DPNT_DSGN_FLAG, 1234);
2040: hr_utility.set_location('Curr AUTO_ENRT_FLAG = ' || l_curr_epe_table(l_curr_count).AUTO_ENRT_FLAG, 1234);
2033: hr_utility.set_location('Curr SPCL_RT_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_PL_ID, -1), 1234);
2034: hr_utility.set_location('Curr SPCL_RT_OIPL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_OIPL_ID, -1), 1234);
2035: hr_utility.set_location('Curr MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2036: hr_utility.set_location('Curr DFLT_FLAG = ' || l_curr_epe_table(l_curr_count).DFLT_FLAG, 1234);
2037: hr_utility.set_location('Curr ELCTBL_FLAG = ' || l_curr_epe_table(l_curr_count).ELCTBL_FLAG, 1234);
2038: hr_utility.set_location('Curr MNDTRY_FLAG = ' || l_curr_epe_table(l_curr_count).MNDTRY_FLAG, 1234);
2039: hr_utility.set_location('Curr ALWS_DPNT_DSGN_FLAG = ' || l_curr_epe_table(l_curr_count).ALWS_DPNT_DSGN_FLAG, 1234);
2040: hr_utility.set_location('Curr AUTO_ENRT_FLAG = ' || l_curr_epe_table(l_curr_count).AUTO_ENRT_FLAG, 1234);
2041: hr_utility.set_location('Curr CTFN_RQD_FLAG = ' || l_curr_epe_table(l_curr_count).CTFN_RQD_FLAG, 1234);
2034: hr_utility.set_location('Curr SPCL_RT_OIPL_ID = ' || nvl(l_curr_epe_table(l_curr_count).SPCL_RT_OIPL_ID, -1), 1234);
2035: hr_utility.set_location('Curr MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2036: hr_utility.set_location('Curr DFLT_FLAG = ' || l_curr_epe_table(l_curr_count).DFLT_FLAG, 1234);
2037: hr_utility.set_location('Curr ELCTBL_FLAG = ' || l_curr_epe_table(l_curr_count).ELCTBL_FLAG, 1234);
2038: hr_utility.set_location('Curr MNDTRY_FLAG = ' || l_curr_epe_table(l_curr_count).MNDTRY_FLAG, 1234);
2039: hr_utility.set_location('Curr ALWS_DPNT_DSGN_FLAG = ' || l_curr_epe_table(l_curr_count).ALWS_DPNT_DSGN_FLAG, 1234);
2040: hr_utility.set_location('Curr AUTO_ENRT_FLAG = ' || l_curr_epe_table(l_curr_count).AUTO_ENRT_FLAG, 1234);
2041: hr_utility.set_location('Curr CTFN_RQD_FLAG = ' || l_curr_epe_table(l_curr_count).CTFN_RQD_FLAG, 1234);
2042: hr_utility.set_location('Curr BNFT_PRVDR_POOL_ID = ' || nvl(l_curr_epe_table(l_curr_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2035: hr_utility.set_location('Curr MUST_ENRL_ANTHR_PL_ID = ' || nvl(l_curr_epe_table(l_curr_count).MUST_ENRL_ANTHR_PL_ID, -1), 1234);
2036: hr_utility.set_location('Curr DFLT_FLAG = ' || l_curr_epe_table(l_curr_count).DFLT_FLAG, 1234);
2037: hr_utility.set_location('Curr ELCTBL_FLAG = ' || l_curr_epe_table(l_curr_count).ELCTBL_FLAG, 1234);
2038: hr_utility.set_location('Curr MNDTRY_FLAG = ' || l_curr_epe_table(l_curr_count).MNDTRY_FLAG, 1234);
2039: hr_utility.set_location('Curr ALWS_DPNT_DSGN_FLAG = ' || l_curr_epe_table(l_curr_count).ALWS_DPNT_DSGN_FLAG, 1234);
2040: hr_utility.set_location('Curr AUTO_ENRT_FLAG = ' || l_curr_epe_table(l_curr_count).AUTO_ENRT_FLAG, 1234);
2041: hr_utility.set_location('Curr CTFN_RQD_FLAG = ' || l_curr_epe_table(l_curr_count).CTFN_RQD_FLAG, 1234);
2042: hr_utility.set_location('Curr BNFT_PRVDR_POOL_ID = ' || nvl(l_curr_epe_table(l_curr_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2043: hr_utility.set_location('Curr YR_PERD_ID = ' || nvl(l_curr_epe_table(l_curr_count).YR_PERD_ID, -1), 1234);
2036: hr_utility.set_location('Curr DFLT_FLAG = ' || l_curr_epe_table(l_curr_count).DFLT_FLAG, 1234);
2037: hr_utility.set_location('Curr ELCTBL_FLAG = ' || l_curr_epe_table(l_curr_count).ELCTBL_FLAG, 1234);
2038: hr_utility.set_location('Curr MNDTRY_FLAG = ' || l_curr_epe_table(l_curr_count).MNDTRY_FLAG, 1234);
2039: hr_utility.set_location('Curr ALWS_DPNT_DSGN_FLAG = ' || l_curr_epe_table(l_curr_count).ALWS_DPNT_DSGN_FLAG, 1234);
2040: hr_utility.set_location('Curr AUTO_ENRT_FLAG = ' || l_curr_epe_table(l_curr_count).AUTO_ENRT_FLAG, 1234);
2041: hr_utility.set_location('Curr CTFN_RQD_FLAG = ' || l_curr_epe_table(l_curr_count).CTFN_RQD_FLAG, 1234);
2042: hr_utility.set_location('Curr BNFT_PRVDR_POOL_ID = ' || nvl(l_curr_epe_table(l_curr_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2043: hr_utility.set_location('Curr YR_PERD_ID = ' || nvl(l_curr_epe_table(l_curr_count).YR_PERD_ID, -1), 1234);
2044: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2037: hr_utility.set_location('Curr ELCTBL_FLAG = ' || l_curr_epe_table(l_curr_count).ELCTBL_FLAG, 1234);
2038: hr_utility.set_location('Curr MNDTRY_FLAG = ' || l_curr_epe_table(l_curr_count).MNDTRY_FLAG, 1234);
2039: hr_utility.set_location('Curr ALWS_DPNT_DSGN_FLAG = ' || l_curr_epe_table(l_curr_count).ALWS_DPNT_DSGN_FLAG, 1234);
2040: hr_utility.set_location('Curr AUTO_ENRT_FLAG = ' || l_curr_epe_table(l_curr_count).AUTO_ENRT_FLAG, 1234);
2041: hr_utility.set_location('Curr CTFN_RQD_FLAG = ' || l_curr_epe_table(l_curr_count).CTFN_RQD_FLAG, 1234);
2042: hr_utility.set_location('Curr BNFT_PRVDR_POOL_ID = ' || nvl(l_curr_epe_table(l_curr_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2043: hr_utility.set_location('Curr YR_PERD_ID = ' || nvl(l_curr_epe_table(l_curr_count).YR_PERD_ID, -1), 1234);
2044: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2045: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2038: hr_utility.set_location('Curr MNDTRY_FLAG = ' || l_curr_epe_table(l_curr_count).MNDTRY_FLAG, 1234);
2039: hr_utility.set_location('Curr ALWS_DPNT_DSGN_FLAG = ' || l_curr_epe_table(l_curr_count).ALWS_DPNT_DSGN_FLAG, 1234);
2040: hr_utility.set_location('Curr AUTO_ENRT_FLAG = ' || l_curr_epe_table(l_curr_count).AUTO_ENRT_FLAG, 1234);
2041: hr_utility.set_location('Curr CTFN_RQD_FLAG = ' || l_curr_epe_table(l_curr_count).CTFN_RQD_FLAG, 1234);
2042: hr_utility.set_location('Curr BNFT_PRVDR_POOL_ID = ' || nvl(l_curr_epe_table(l_curr_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2043: hr_utility.set_location('Curr YR_PERD_ID = ' || nvl(l_curr_epe_table(l_curr_count).YR_PERD_ID, -1), 1234);
2044: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2045: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2046: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2039: hr_utility.set_location('Curr ALWS_DPNT_DSGN_FLAG = ' || l_curr_epe_table(l_curr_count).ALWS_DPNT_DSGN_FLAG, 1234);
2040: hr_utility.set_location('Curr AUTO_ENRT_FLAG = ' || l_curr_epe_table(l_curr_count).AUTO_ENRT_FLAG, 1234);
2041: hr_utility.set_location('Curr CTFN_RQD_FLAG = ' || l_curr_epe_table(l_curr_count).CTFN_RQD_FLAG, 1234);
2042: hr_utility.set_location('Curr BNFT_PRVDR_POOL_ID = ' || nvl(l_curr_epe_table(l_curr_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2043: hr_utility.set_location('Curr YR_PERD_ID = ' || nvl(l_curr_epe_table(l_curr_count).YR_PERD_ID, -1), 1234);
2044: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2045: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2046: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2047: hr_utility.set_location('Curr LER_CHG_DPNT_CVG_CD = ' || nvl(l_curr_epe_table(l_curr_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2040: hr_utility.set_location('Curr AUTO_ENRT_FLAG = ' || l_curr_epe_table(l_curr_count).AUTO_ENRT_FLAG, 1234);
2041: hr_utility.set_location('Curr CTFN_RQD_FLAG = ' || l_curr_epe_table(l_curr_count).CTFN_RQD_FLAG, 1234);
2042: hr_utility.set_location('Curr BNFT_PRVDR_POOL_ID = ' || nvl(l_curr_epe_table(l_curr_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2043: hr_utility.set_location('Curr YR_PERD_ID = ' || nvl(l_curr_epe_table(l_curr_count).YR_PERD_ID, -1), 1234);
2044: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2045: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2046: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2047: hr_utility.set_location('Curr LER_CHG_DPNT_CVG_CD = ' || nvl(l_curr_epe_table(l_curr_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2048: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2041: hr_utility.set_location('Curr CTFN_RQD_FLAG = ' || l_curr_epe_table(l_curr_count).CTFN_RQD_FLAG, 1234);
2042: hr_utility.set_location('Curr BNFT_PRVDR_POOL_ID = ' || nvl(l_curr_epe_table(l_curr_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2043: hr_utility.set_location('Curr YR_PERD_ID = ' || nvl(l_curr_epe_table(l_curr_count).YR_PERD_ID, -1), 1234);
2044: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2045: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2046: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2047: hr_utility.set_location('Curr LER_CHG_DPNT_CVG_CD = ' || nvl(l_curr_epe_table(l_curr_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2048: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2049: hr_utility.set_location('Curr ENRT_CVG_STRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);
2042: hr_utility.set_location('Curr BNFT_PRVDR_POOL_ID = ' || nvl(l_curr_epe_table(l_curr_count).BNFT_PRVDR_POOL_ID, -1), 1234);
2043: hr_utility.set_location('Curr YR_PERD_ID = ' || nvl(l_curr_epe_table(l_curr_count).YR_PERD_ID, -1), 1234);
2044: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2045: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2046: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2047: hr_utility.set_location('Curr LER_CHG_DPNT_CVG_CD = ' || nvl(l_curr_epe_table(l_curr_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2048: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2049: hr_utility.set_location('Curr ENRT_CVG_STRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);
2050: hr_utility.set_location('Curr ERLST_DEENRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot) , 1234);
2043: hr_utility.set_location('Curr YR_PERD_ID = ' || nvl(l_curr_epe_table(l_curr_count).YR_PERD_ID, -1), 1234);
2044: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2045: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2046: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2047: hr_utility.set_location('Curr LER_CHG_DPNT_CVG_CD = ' || nvl(l_curr_epe_table(l_curr_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2048: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2049: hr_utility.set_location('Curr ENRT_CVG_STRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);
2050: hr_utility.set_location('Curr ERLST_DEENRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot) , 1234);
2051:
2044: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_CD, '$'), 1234);
2045: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2046: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2047: hr_utility.set_location('Curr LER_CHG_DPNT_CVG_CD = ' || nvl(l_curr_epe_table(l_curr_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2048: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2049: hr_utility.set_location('Curr ENRT_CVG_STRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);
2050: hr_utility.set_location('Curr ERLST_DEENRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot) , 1234);
2051:
2052:
2045: hr_utility.set_location('Curr ENRT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT_RL, -1), 1234);
2046: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2047: hr_utility.set_location('Curr LER_CHG_DPNT_CVG_CD = ' || nvl(l_curr_epe_table(l_curr_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2048: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2049: hr_utility.set_location('Curr ENRT_CVG_STRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);
2050: hr_utility.set_location('Curr ERLST_DEENRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot) , 1234);
2051:
2052:
2053: if l_bckdt_epe_table(l_count).AUTO_ENRT_FLAG = 'Y' and
2046: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_CD = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_CD, '$'), 1234);
2047: hr_utility.set_location('Curr LER_CHG_DPNT_CVG_CD = ' || nvl(l_curr_epe_table(l_curr_count).LER_CHG_DPNT_CVG_CD, '$'), 1234);
2048: hr_utility.set_location('Curr DPNT_CVG_STRT_DT_RL = ' || nvl(l_curr_epe_table(l_curr_count).DPNT_CVG_STRT_DT_RL, -1), 1234);
2049: hr_utility.set_location('Curr ENRT_CVG_STRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot), 1234);
2050: hr_utility.set_location('Curr ERLST_DEENRT_DT = ' || nvl(l_curr_epe_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot) , 1234);
2051:
2052:
2053: if l_bckdt_epe_table(l_count).AUTO_ENRT_FLAG = 'Y' and
2054: l_curr_epe_table(l_curr_count).AUTO_ENRT_FLAG = 'Y' and
2222: --
2223: end if; -- epe ckecks if statement
2224: --
2225:
2226: hr_utility.set_location('Leaving:' || l_differ || l_proc, 10);
2227: --
2228: return l_differ;
2229: --
2230: end comp_ori_new_pil_outcome;
2337: l_found boolean;
2338: --
2339: begin
2340: --
2341: hr_utility.set_location ('Entering '||l_proc,10);
2342: --
2343: open c_bckdt_epe_cnt;
2344: fetch c_bckdt_epe_cnt into l_bckdt_epe_cnt;
2345: close c_bckdt_epe_cnt;
2554: --
2555: end if; -- epe ckecks if statement
2556: --
2557:
2558: hr_utility.set_location('Leaving:' || l_differ || l_proc, 10);
2559: --
2560: return l_differ;
2561: --
2562: end comp_ori_new_pil_for_popl;
2594: and pcd.effective_end_date;
2595:
2596: begin
2597: --
2598: hr_utility.set_location('Entering:'|| l_proc, 10);
2599: --
2600: for per_cm_rec in c_per_cm loop
2601: --
2602: ben_per_cm_prvdd_api.update_per_cm_prvdd
2610: ,p_datetrack_mode => hr_api.g_correction);
2611: --
2612: end loop;
2613: --
2614: hr_utility.set_location('Leaving:'|| l_proc, 10);
2615: --
2616: end void_literature;
2617: --
2618: procedure pad_cmnt_to_rsnd_lit(
2651: and pcd.effective_end_date;
2652: --
2653: begin
2654: --
2655: hr_utility.set_location('Entering:'|| l_proc, 10);
2656: --
2657: for per_cm_rec in c_per_cm loop
2658: --
2659: --
2670: ,p_datetrack_mode => hr_api.g_correction);
2671: --
2672: end loop;
2673: --
2674: hr_utility.set_location('Leaving:'|| l_proc, 10);
2675: --
2676: end pad_cmnt_to_rsnd_lit;
2677: --
2678: procedure extend_enrt_date(p_person_id in number
2695: --
2696: l_move_out_by number;
2697: begin
2698: --
2699: hr_utility.set_location('Entering:'|| l_proc, 10);
2700: --
2701: -- Only extend the dates if the pel status was STRTD
2702: --
2703: if g_bckdt_pil_prvs_stat_cd = 'STRTD' then
2734: end loop;
2735: --
2736: end if;
2737: --
2738: hr_utility.set_location('Leaving:'|| l_proc, 10);
2739: --
2740: end extend_enrt_date;
2741: --
2742: -- ----------------------------------------------------------------------------
2782: l_cqb_rec c_cqb%rowtype;
2783: l_crp_rec c_get_cbr_per_in_ler%rowtype;
2784: begin
2785: --
2786: hr_utility.set_location('Entering:'|| l_proc, 10);
2787: --
2788: -- If backout event was a secondary COBRA qualifying event,
2789: -- re-instate the COBRA eligibility end date.
2790: --
2829: where cqb.per_in_ler_id = p_bckdt_per_in_ler_id
2830: and cqb.business_group_id = p_business_group_id
2831: and cqb.bkup_tbl_typ_cd = 'BEN_CBR_QUALD_BNF';
2832: --
2833: hr_utility.set_location('Leaving:'|| l_proc, 10);
2834:
2835: end reinstate_cbr_dates;
2836: --
2837: -- ----------------------------------------------------------------------------
2881: l_bckdt_prv_count number;
2882: --
2883: begin
2884: --
2885: hr_utility.set_location ('Entering '||l_proc,10);
2886: --
2887: select count(*) into l_bckdt_prv_count
2888: from ben_prtt_rt_val prv
2889: where prv.prtt_enrt_rslt_id = p_bckdt_pen_id
2906: then
2907: --
2908: l_differ := 'N';
2909:
2910: hr_utility.set_location('Leaving: ' || l_differ ||' 0 '|| l_proc, 10);
2911: return l_differ;
2912: --
2913: elsif nvl(l_curr_prv_table.last, 0) <> nvl(l_bckdt_prv_count,0) then
2914: --
2913: elsif nvl(l_curr_prv_table.last, 0) <> nvl(l_bckdt_prv_count,0) then
2914: --
2915: l_differ := 'Y';
2916:
2917: hr_utility.set_location('Leaving: ' || l_differ ||'<> 0 '|| l_proc, 10);
2918: return l_differ;
2919: --
2920: end if;
2921: --
2995: --
2996: end loop;
2997: --
2998:
2999: hr_utility.set_location('Leaving:' || l_differ || l_proc, 10);
3000: --
3001: return l_differ;
3002: --
3003: end comp_ori_new_prv;
3229: l_found boolean;
3230: --
3231: begin
3232: --
3233: hr_utility.set_location ('Entering '||l_proc,10);
3234: hr_utility.set_location ('Entering bck pil id '||p_bckdt_per_in_ler_id,10);
3235: hr_utility.set_location ('Entering pil id '||p_per_in_ler_id,10);
3236: --
3237: -- Bug 1266433 : Do not consider the results of flex credits and
3230: --
3231: begin
3232: --
3233: hr_utility.set_location ('Entering '||l_proc,10);
3234: hr_utility.set_location ('Entering bck pil id '||p_bckdt_per_in_ler_id,10);
3235: hr_utility.set_location ('Entering pil id '||p_per_in_ler_id,10);
3236: --
3237: -- Bug 1266433 : Do not consider the results of flex credits and
3238: -- imputed income as they are not considered in c_curr_pen_dat
3231: begin
3232: --
3233: hr_utility.set_location ('Entering '||l_proc,10);
3234: hr_utility.set_location ('Entering bck pil id '||p_bckdt_per_in_ler_id,10);
3235: hr_utility.set_location ('Entering pil id '||p_per_in_ler_id,10);
3236: --
3237: -- Bug 1266433 : Do not consider the results of flex credits and
3238: -- imputed income as they are not considered in c_curr_pen_dat
3239: --
3274: then
3275: --
3276: l_differ := 'N';
3277:
3278: hr_utility.set_location('Leaving: ' || l_differ
3279: ||' 0 '|| l_proc, 10);
3280: return l_differ;
3281: --
3282: elsif nvl(l_curr_pen_table.last, 0) = 0 and
3283: p_dont_check_cnt_flag = 'Y' then
3284: --
3285: l_differ := 'N';
3286:
3287: hr_utility.set_location('Leaving: ' || l_differ
3288: ||' 0 '|| l_proc, 10);
3289: return l_differ;
3290: --
3291: elsif nvl(l_curr_pen_table.last, 0) <> nvl(l_bckdt_pen_cnt,0) and
3292: p_dont_check_cnt_flag = 'N' then
3293: --
3294: l_differ := 'Y';
3295:
3296: hr_utility.set_location('Leaving: ' || l_differ ||' <>0 '||
3297: nvl(l_curr_pen_table.last, 0) || ' bck= '
3298: || nvl(l_bckdt_pen_cnt,0) || l_proc, 10);
3299: return l_differ;
3300: --
3303: -- Now compare the original pen record and new pen record.
3304: --
3305: l_found := FALSE;
3306: --
3307: hr_utility.set_location(to_char(nvl(l_curr_pen_table.last, 0)) ,4987);
3308: if nvl(l_curr_pen_table.last, 0) > 0 then
3309: --
3310: hr_utility.set_location(' Before first Loop ',4987);
3311: for l_curr_count in l_curr_pen_table.first..l_curr_pen_table.last loop
3306: --
3307: hr_utility.set_location(to_char(nvl(l_curr_pen_table.last, 0)) ,4987);
3308: if nvl(l_curr_pen_table.last, 0) > 0 then
3309: --
3310: hr_utility.set_location(' Before first Loop ',4987);
3311: for l_curr_count in l_curr_pen_table.first..l_curr_pen_table.last loop
3312: --
3313: l_found := FALSE;
3314: --
3311: for l_curr_count in l_curr_pen_table.first..l_curr_pen_table.last loop
3312: --
3313: l_found := FALSE;
3314: --
3315: hr_utility.set_location(' Before Loop ',4987);
3316: for bckdt_pen_rec in c_bckdt_pen_dat
3317: loop
3318: --
3319:
3316: for bckdt_pen_rec in c_bckdt_pen_dat
3317: loop
3318: --
3319:
3320: hr_utility.set_location(' Before if ',4987);
3321: /*
3322: hr_utility.set_location( 'SSPNDD_FLAG ' ||
3323: nvl(bckdt_pen_rec.SSPNDD_FLAG, '$r') ||'--'||
3324: nvl(l_curr_pen_table(l_curr_count).SSPNDD_FLAG, '$'),4987);
3318: --
3319:
3320: hr_utility.set_location(' Before if ',4987);
3321: /*
3322: hr_utility.set_location( 'SSPNDD_FLAG ' ||
3323: nvl(bckdt_pen_rec.SSPNDD_FLAG, '$r') ||'--'||
3324: nvl(l_curr_pen_table(l_curr_count).SSPNDD_FLAG, '$'),4987);
3325: hr_utility.set_location( 'ENRT_CVG_STRT_DT '
3326: || nvl(bckdt_pen_rec.ENRT_CVG_STRT_DT, hr_api.g_eot) ||'--'||
3321: /*
3322: hr_utility.set_location( 'SSPNDD_FLAG ' ||
3323: nvl(bckdt_pen_rec.SSPNDD_FLAG, '$r') ||'--'||
3324: nvl(l_curr_pen_table(l_curr_count).SSPNDD_FLAG, '$'),4987);
3325: hr_utility.set_location( 'ENRT_CVG_STRT_DT '
3326: || nvl(bckdt_pen_rec.ENRT_CVG_STRT_DT, hr_api.g_eot) ||'--'||
3327: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot),4987);
3328: hr_utility.set_location( 'ENRT_CVG_THRU_DT '
3329: || nvl(bckdt_pen_rec.ENRT_CVG_THRU_DT, hr_api.g_eot)||'--'||
3324: nvl(l_curr_pen_table(l_curr_count).SSPNDD_FLAG, '$'),4987);
3325: hr_utility.set_location( 'ENRT_CVG_STRT_DT '
3326: || nvl(bckdt_pen_rec.ENRT_CVG_STRT_DT, hr_api.g_eot) ||'--'||
3327: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot),4987);
3328: hr_utility.set_location( 'ENRT_CVG_THRU_DT '
3329: || nvl(bckdt_pen_rec.ENRT_CVG_THRU_DT, hr_api.g_eot)||'--'||
3330: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_THRU_DT, hr_api.g_eot),4987);
3331: hr_utility.set_location( 'PRTT_IS_CVRD_FLA '
3332: || nvl(bckdt_pen_rec.PRTT_IS_CVRD_FLAG, '$') ||'--'||
3327: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_STRT_DT, hr_api.g_eot),4987);
3328: hr_utility.set_location( 'ENRT_CVG_THRU_DT '
3329: || nvl(bckdt_pen_rec.ENRT_CVG_THRU_DT, hr_api.g_eot)||'--'||
3330: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_THRU_DT, hr_api.g_eot),4987);
3331: hr_utility.set_location( 'PRTT_IS_CVRD_FLA '
3332: || nvl(bckdt_pen_rec.PRTT_IS_CVRD_FLAG, '$') ||'--'||
3333: nvl(l_curr_pen_table(l_curr_count).PRTT_IS_CVRD_FLAG, '$'),4987);
3334: hr_utility.set_location( 'PRTT_IS_CVRD_FLAG'
3335: || nvl(bckdt_pen_rec.BNFT_AMT, -1)||'--'||
3330: nvl(l_curr_pen_table(l_curr_count).ENRT_CVG_THRU_DT, hr_api.g_eot),4987);
3331: hr_utility.set_location( 'PRTT_IS_CVRD_FLA '
3332: || nvl(bckdt_pen_rec.PRTT_IS_CVRD_FLAG, '$') ||'--'||
3333: nvl(l_curr_pen_table(l_curr_count).PRTT_IS_CVRD_FLAG, '$'),4987);
3334: hr_utility.set_location( 'PRTT_IS_CVRD_FLAG'
3335: || nvl(bckdt_pen_rec.BNFT_AMT, -1)||'--'||
3336: nvl(l_curr_pen_table(l_curr_count).BNFT_AMT, -1),4987);
3337: hr_utility.set_location( 'BNFT_NNMNTRY_UOM '
3338: || nvl(bckdt_pen_rec.BNFT_NNMNTRY_UOM, '$') ||'--'||
3333: nvl(l_curr_pen_table(l_curr_count).PRTT_IS_CVRD_FLAG, '$'),4987);
3334: hr_utility.set_location( 'PRTT_IS_CVRD_FLAG'
3335: || nvl(bckdt_pen_rec.BNFT_AMT, -1)||'--'||
3336: nvl(l_curr_pen_table(l_curr_count).BNFT_AMT, -1),4987);
3337: hr_utility.set_location( 'BNFT_NNMNTRY_UOM '
3338: || nvl(bckdt_pen_rec.BNFT_NNMNTRY_UOM, '$') ||'--'||
3339: nvl(l_curr_pen_table(l_curr_count).BNFT_NNMNTRY_UOM, '$'),4987);
3340: hr_utility.set_location( 'BNFT_TYP_CD '
3341: || nvl(bckdt_pen_rec.BNFT_TYP_CD, '$') ||'--'||
3336: nvl(l_curr_pen_table(l_curr_count).BNFT_AMT, -1),4987);
3337: hr_utility.set_location( 'BNFT_NNMNTRY_UOM '
3338: || nvl(bckdt_pen_rec.BNFT_NNMNTRY_UOM, '$') ||'--'||
3339: nvl(l_curr_pen_table(l_curr_count).BNFT_NNMNTRY_UOM, '$'),4987);
3340: hr_utility.set_location( 'BNFT_TYP_CD '
3341: || nvl(bckdt_pen_rec.BNFT_TYP_CD, '$') ||'--'||
3342: nvl(l_curr_pen_table(l_curr_count).BNFT_TYP_CD, '$'),4987);
3343: hr_utility.set_location( 'UOM ' || nvl(bckdt_pen_rec.UOM, '$') ||'--'||
3344: nvl(l_curr_pen_table(l_curr_count).UOM, '$'),4987);
3339: nvl(l_curr_pen_table(l_curr_count).BNFT_NNMNTRY_UOM, '$'),4987);
3340: hr_utility.set_location( 'BNFT_TYP_CD '
3341: || nvl(bckdt_pen_rec.BNFT_TYP_CD, '$') ||'--'||
3342: nvl(l_curr_pen_table(l_curr_count).BNFT_TYP_CD, '$'),4987);
3343: hr_utility.set_location( 'UOM ' || nvl(bckdt_pen_rec.UOM, '$') ||'--'||
3344: nvl(l_curr_pen_table(l_curr_count).UOM, '$'),4987);
3345: hr_utility.set_location( 'ORGNL_ENRT_DT '
3346: || nvl(bckdt_pen_rec.ORGNL_ENRT_DT, hr_api.g_eot) ||'--'||
3347: nvl(l_curr_pen_table(l_curr_count).ORGNL_ENRT_DT, hr_api.g_eot),4987);
3341: || nvl(bckdt_pen_rec.BNFT_TYP_CD, '$') ||'--'||
3342: nvl(l_curr_pen_table(l_curr_count).BNFT_TYP_CD, '$'),4987);
3343: hr_utility.set_location( 'UOM ' || nvl(bckdt_pen_rec.UOM, '$') ||'--'||
3344: nvl(l_curr_pen_table(l_curr_count).UOM, '$'),4987);
3345: hr_utility.set_location( 'ORGNL_ENRT_DT '
3346: || nvl(bckdt_pen_rec.ORGNL_ENRT_DT, hr_api.g_eot) ||'--'||
3347: nvl(l_curr_pen_table(l_curr_count).ORGNL_ENRT_DT, hr_api.g_eot),4987);
3348: hr_utility.set_location( 'ENRT_MTHD_CD '
3349: || nvl(bckdt_pen_rec.ENRT_MTHD_CD, '$') ||'--'||
3344: nvl(l_curr_pen_table(l_curr_count).UOM, '$'),4987);
3345: hr_utility.set_location( 'ORGNL_ENRT_DT '
3346: || nvl(bckdt_pen_rec.ORGNL_ENRT_DT, hr_api.g_eot) ||'--'||
3347: nvl(l_curr_pen_table(l_curr_count).ORGNL_ENRT_DT, hr_api.g_eot),4987);
3348: hr_utility.set_location( 'ENRT_MTHD_CD '
3349: || nvl(bckdt_pen_rec.ENRT_MTHD_CD, '$') ||'--'||
3350: nvl(l_curr_pen_table(l_curr_count).ENRT_MTHD_CD, '$'),4987);
3351: hr_utility.set_location( 'ENRT_OVRIDN_FLAG '||
3352: nvl(bckdt_pen_rec.ENRT_OVRIDN_FLAG, '$') ||'--'||
3347: nvl(l_curr_pen_table(l_curr_count).ORGNL_ENRT_DT, hr_api.g_eot),4987);
3348: hr_utility.set_location( 'ENRT_MTHD_CD '
3349: || nvl(bckdt_pen_rec.ENRT_MTHD_CD, '$') ||'--'||
3350: nvl(l_curr_pen_table(l_curr_count).ENRT_MTHD_CD, '$'),4987);
3351: hr_utility.set_location( 'ENRT_OVRIDN_FLAG '||
3352: nvl(bckdt_pen_rec.ENRT_OVRIDN_FLAG, '$') ||'--'||
3353: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRIDN_FLAG, '$'),4987);
3354: hr_utility.set_location( 'ENRT_OVRID_RSN_CD '
3355: || nvl(bckdt_pen_rec.ENRT_OVRID_RSN_CD, '$')||'--'||
3350: nvl(l_curr_pen_table(l_curr_count).ENRT_MTHD_CD, '$'),4987);
3351: hr_utility.set_location( 'ENRT_OVRIDN_FLAG '||
3352: nvl(bckdt_pen_rec.ENRT_OVRIDN_FLAG, '$') ||'--'||
3353: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRIDN_FLAG, '$'),4987);
3354: hr_utility.set_location( 'ENRT_OVRID_RSN_CD '
3355: || nvl(bckdt_pen_rec.ENRT_OVRID_RSN_CD, '$')||'--'||
3356: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_RSN_CD, '$'),4987);
3357: hr_utility.set_location( 'ERLST_DEENRT_DT '
3358: || nvl(bckdt_pen_rec.ERLST_DEENRT_DT, hr_api.g_eot)||'--'||
3353: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRIDN_FLAG, '$'),4987);
3354: hr_utility.set_location( 'ENRT_OVRID_RSN_CD '
3355: || nvl(bckdt_pen_rec.ENRT_OVRID_RSN_CD, '$')||'--'||
3356: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_RSN_CD, '$'),4987);
3357: hr_utility.set_location( 'ERLST_DEENRT_DT '
3358: || nvl(bckdt_pen_rec.ERLST_DEENRT_DT, hr_api.g_eot)||'--'||
3359: nvl(l_curr_pen_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot),4987);
3360:
3361: hr_utility.set_location( 'ENRT_OVRID_THRU_DT'
3357: hr_utility.set_location( 'ERLST_DEENRT_DT '
3358: || nvl(bckdt_pen_rec.ERLST_DEENRT_DT, hr_api.g_eot)||'--'||
3359: nvl(l_curr_pen_table(l_curr_count).ERLST_DEENRT_DT, hr_api.g_eot),4987);
3360:
3361: hr_utility.set_location( 'ENRT_OVRID_THRU_DT'
3362: || nvl(bckdt_pen_rec.ENRT_OVRID_THRU_DT, hr_api.g_eot) ||'--'||
3363: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_THRU_DT, hr_api.g_eot),4987);
3364: hr_utility.set_location( 'NO_LNGR_ELIG_FLAG'
3365: || nvl(bckdt_pen_rec.NO_LNGR_ELIG_FLAG, '$')||'--'||
3360:
3361: hr_utility.set_location( 'ENRT_OVRID_THRU_DT'
3362: || nvl(bckdt_pen_rec.ENRT_OVRID_THRU_DT, hr_api.g_eot) ||'--'||
3363: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_THRU_DT, hr_api.g_eot),4987);
3364: hr_utility.set_location( 'NO_LNGR_ELIG_FLAG'
3365: || nvl(bckdt_pen_rec.NO_LNGR_ELIG_FLAG, '$')||'--'||
3366: nvl(l_curr_pen_table(l_curr_count).NO_LNGR_ELIG_FLAG, '$'),4987);
3367: hr_utility.set_location( 'PRTT_ENRT_RSLT_STAT_CD'
3368: || nvl(bckdt_pen_rec.PRTT_ENRT_RSLT_STAT_CD, '$')||'--'||
3363: nvl(l_curr_pen_table(l_curr_count).ENRT_OVRID_THRU_DT, hr_api.g_eot),4987);
3364: hr_utility.set_location( 'NO_LNGR_ELIG_FLAG'
3365: || nvl(bckdt_pen_rec.NO_LNGR_ELIG_FLAG, '$')||'--'||
3366: nvl(l_curr_pen_table(l_curr_count).NO_LNGR_ELIG_FLAG, '$'),4987);
3367: hr_utility.set_location( 'PRTT_ENRT_RSLT_STAT_CD'
3368: || nvl(bckdt_pen_rec.PRTT_ENRT_RSLT_STAT_CD, '$')||'--'||
3369: nvl(l_curr_pen_table(l_curr_count).PRTT_ENRT_RSLT_STAT_CD, '$')
3370: ||'--'|| p_dont_check_cnt_flag ,4987);
3371: hr_utility.set_location( 'COMP_LVL_CD' || nvl(bckdt_pen_rec.COMP_LVL_CD, '$')||'--'||
3367: hr_utility.set_location( 'PRTT_ENRT_RSLT_STAT_CD'
3368: || nvl(bckdt_pen_rec.PRTT_ENRT_RSLT_STAT_CD, '$')||'--'||
3369: nvl(l_curr_pen_table(l_curr_count).PRTT_ENRT_RSLT_STAT_CD, '$')
3370: ||'--'|| p_dont_check_cnt_flag ,4987);
3371: hr_utility.set_location( 'COMP_LVL_CD' || nvl(bckdt_pen_rec.COMP_LVL_CD, '$')||'--'||
3372: nvl(l_curr_pen_table(l_curr_count). COMP_LVL_CD, '$'),4987);
3373: hr_utility.set_location( 'PGM_ID ' || nvl(bckdt_pen_rec.PGM_ID, -1)||'--'||
3374: nvl(l_curr_pen_table(l_curr_count).PGM_ID,-1),4987);
3375: hr_utility.set_location( 'PL_ID ' || nvl(bckdt_pen_rec.PL_ID, -1)||'--'||
3369: nvl(l_curr_pen_table(l_curr_count).PRTT_ENRT_RSLT_STAT_CD, '$')
3370: ||'--'|| p_dont_check_cnt_flag ,4987);
3371: hr_utility.set_location( 'COMP_LVL_CD' || nvl(bckdt_pen_rec.COMP_LVL_CD, '$')||'--'||
3372: nvl(l_curr_pen_table(l_curr_count). COMP_LVL_CD, '$'),4987);
3373: hr_utility.set_location( 'PGM_ID ' || nvl(bckdt_pen_rec.PGM_ID, -1)||'--'||
3374: nvl(l_curr_pen_table(l_curr_count).PGM_ID,-1),4987);
3375: hr_utility.set_location( 'PL_ID ' || nvl(bckdt_pen_rec.PL_ID, -1)||'--'||
3376: nvl(l_curr_pen_table(l_curr_count).PL_ID, -1), 4987);
3377: hr_utility.set_location( 'PL_TYP_ID '||nvl(bckdt_pen_rec.PL_TYP_ID, -1)||'--'||
3371: hr_utility.set_location( 'COMP_LVL_CD' || nvl(bckdt_pen_rec.COMP_LVL_CD, '$')||'--'||
3372: nvl(l_curr_pen_table(l_curr_count). COMP_LVL_CD, '$'),4987);
3373: hr_utility.set_location( 'PGM_ID ' || nvl(bckdt_pen_rec.PGM_ID, -1)||'--'||
3374: nvl(l_curr_pen_table(l_curr_count).PGM_ID,-1),4987);
3375: hr_utility.set_location( 'PL_ID ' || nvl(bckdt_pen_rec.PL_ID, -1)||'--'||
3376: nvl(l_curr_pen_table(l_curr_count).PL_ID, -1), 4987);
3377: hr_utility.set_location( 'PL_TYP_ID '||nvl(bckdt_pen_rec.PL_TYP_ID, -1)||'--'||
3378: nvl(l_curr_pen_table(l_curr_count).PL_TYP_ID, -1),4987);
3379:
3373: hr_utility.set_location( 'PGM_ID ' || nvl(bckdt_pen_rec.PGM_ID, -1)||'--'||
3374: nvl(l_curr_pen_table(l_curr_count).PGM_ID,-1),4987);
3375: hr_utility.set_location( 'PL_ID ' || nvl(bckdt_pen_rec.PL_ID, -1)||'--'||
3376: nvl(l_curr_pen_table(l_curr_count).PL_ID, -1), 4987);
3377: hr_utility.set_location( 'PL_TYP_ID '||nvl(bckdt_pen_rec.PL_TYP_ID, -1)||'--'||
3378: nvl(l_curr_pen_table(l_curr_count).PL_TYP_ID, -1),4987);
3379:
3380: hr_utility.set_location( 'OIPL_ID' || nvl(bckdt_pen_rec.OIPL_ID, -1) ||'--'||
3381: nvl(l_curr_pen_table(l_curr_count).OIPL_ID, -1),4987);
3376: nvl(l_curr_pen_table(l_curr_count).PL_ID, -1), 4987);
3377: hr_utility.set_location( 'PL_TYP_ID '||nvl(bckdt_pen_rec.PL_TYP_ID, -1)||'--'||
3378: nvl(l_curr_pen_table(l_curr_count).PL_TYP_ID, -1),4987);
3379:
3380: hr_utility.set_location( 'OIPL_ID' || nvl(bckdt_pen_rec.OIPL_ID, -1) ||'--'||
3381: nvl(l_curr_pen_table(l_curr_count).OIPL_ID, -1),4987);
3382: hr_utility.set_location( 'PTIP_ID ' || nvl(bckdt_pen_rec.PTIP_ID, -1) ||'--'||
3383: nvl(l_curr_pen_table(l_curr_count).PTIP_ID, -1),4987);
3384: hr_utility.set_location( 'LER_ID ' || nvl(bckdt_pen_rec.LER_ID, -1) ||'--'||
3378: nvl(l_curr_pen_table(l_curr_count).PL_TYP_ID, -1),4987);
3379:
3380: hr_utility.set_location( 'OIPL_ID' || nvl(bckdt_pen_rec.OIPL_ID, -1) ||'--'||
3381: nvl(l_curr_pen_table(l_curr_count).OIPL_ID, -1),4987);
3382: hr_utility.set_location( 'PTIP_ID ' || nvl(bckdt_pen_rec.PTIP_ID, -1) ||'--'||
3383: nvl(l_curr_pen_table(l_curr_count).PTIP_ID, -1),4987);
3384: hr_utility.set_location( 'LER_ID ' || nvl(bckdt_pen_rec.LER_ID, -1) ||'--'||
3385: nvl(l_curr_pen_table(l_curr_count).LER_ID, -1),4987);
3386: hr_utility.set_location( 'RPLCS_SSPNDD_RSLT_ID '
3380: hr_utility.set_location( 'OIPL_ID' || nvl(bckdt_pen_rec.OIPL_ID, -1) ||'--'||
3381: nvl(l_curr_pen_table(l_curr_count).OIPL_ID, -1),4987);
3382: hr_utility.set_location( 'PTIP_ID ' || nvl(bckdt_pen_rec.PTIP_ID, -1) ||'--'||
3383: nvl(l_curr_pen_table(l_curr_count).PTIP_ID, -1),4987);
3384: hr_utility.set_location( 'LER_ID ' || nvl(bckdt_pen_rec.LER_ID, -1) ||'--'||
3385: nvl(l_curr_pen_table(l_curr_count).LER_ID, -1),4987);
3386: hr_utility.set_location( 'RPLCS_SSPNDD_RSLT_ID '
3387: || nvl(bckdt_pen_rec.RPLCS_SSPNDD_RSLT_ID, -1)||'--'||
3388: nvl(l_curr_pen_table(l_curr_count).RPLCS_SSPNDD_RSLT_ID, -1),4987);
3382: hr_utility.set_location( 'PTIP_ID ' || nvl(bckdt_pen_rec.PTIP_ID, -1) ||'--'||
3383: nvl(l_curr_pen_table(l_curr_count).PTIP_ID, -1),4987);
3384: hr_utility.set_location( 'LER_ID ' || nvl(bckdt_pen_rec.LER_ID, -1) ||'--'||
3385: nvl(l_curr_pen_table(l_curr_count).LER_ID, -1),4987);
3386: hr_utility.set_location( 'RPLCS_SSPNDD_RSLT_ID '
3387: || nvl(bckdt_pen_rec.RPLCS_SSPNDD_RSLT_ID, -1)||'--'||
3388: nvl(l_curr_pen_table(l_curr_count).RPLCS_SSPNDD_RSLT_ID, -1),4987);
3389:
3390: */
3496: --
3497: end if;
3498: --
3499:
3500: hr_utility.set_location('Leaving:' || l_differ || l_proc, 10);
3501: --
3502: return l_differ;
3503: --
3504: end comp_ori_new_pen;
3567: l_count number := 0;
3568: --
3569: begin
3570: --
3571: hr_utility.set_location ('Entering '||l_proc,10);
3572: --
3573: p_inter_pil_cnt := 0;
3574: open c_bckt_csd_pil;
3575: fetch c_bckt_csd_pil into l_bckt_csd_lf_evt_ocrd_dt;
3592: end if;
3593: --
3594: close c_inter_pil_cnt;
3595: --
3596: hr_utility.set_location ('Leaving '||l_proc,10);
3597: --
3598: end get_inter_pil_cnt;
3599: */
3600: --
3807: l_bnft_prvdd_ldgr_id number;
3808: --
3809: begin
3810: --
3811: hr_utility.set_location ('Entering '||l_proc,10);
3812: --
3813: for l_bckdt_pen_rec in c_bckdt_pen loop
3814: --
3815: for l_curr_pen_rec in c_curr_pen(l_bckdt_pen_rec.pl_id ,
3879: end loop;
3880: end loop;
3881: end loop;
3882: --
3883: hr_utility.set_location('Leaving:'|| l_proc, 10);
3884: --
3885: end reinstate_bpl_per_pen;
3886: --
3887: procedure reinstate_ppr_per_pen(
4030: l_datetrack_mode varchar2(80);
4031: --
4032: begin
4033: --
4034: hr_utility.set_location('Entering ' || l_proc,10);
4035: hr_utility.set_location('p_bckdt_prtt_enrt_rslt_id ' || p_bckdt_prtt_enrt_rslt_id,10);
4036: hr_utility.set_location('p_prtt_enrt_rslt_id ' || p_prtt_enrt_rslt_id,10);
4037: hr_utility.set_location('p_effective_date ' || p_effective_date,10);
4038: hr_utility.set_location('p_bckdt_elig_cvrd_dpnt_id ' || p_bckdt_elig_cvrd_dpnt_id,10);
4031: --
4032: begin
4033: --
4034: hr_utility.set_location('Entering ' || l_proc,10);
4035: hr_utility.set_location('p_bckdt_prtt_enrt_rslt_id ' || p_bckdt_prtt_enrt_rslt_id,10);
4036: hr_utility.set_location('p_prtt_enrt_rslt_id ' || p_prtt_enrt_rslt_id,10);
4037: hr_utility.set_location('p_effective_date ' || p_effective_date,10);
4038: hr_utility.set_location('p_bckdt_elig_cvrd_dpnt_id ' || p_bckdt_elig_cvrd_dpnt_id,10);
4039: --
4032: begin
4033: --
4034: hr_utility.set_location('Entering ' || l_proc,10);
4035: hr_utility.set_location('p_bckdt_prtt_enrt_rslt_id ' || p_bckdt_prtt_enrt_rslt_id,10);
4036: hr_utility.set_location('p_prtt_enrt_rslt_id ' || p_prtt_enrt_rslt_id,10);
4037: hr_utility.set_location('p_effective_date ' || p_effective_date,10);
4038: hr_utility.set_location('p_bckdt_elig_cvrd_dpnt_id ' || p_bckdt_elig_cvrd_dpnt_id,10);
4039: --
4040: -- for participant
4033: --
4034: hr_utility.set_location('Entering ' || l_proc,10);
4035: hr_utility.set_location('p_bckdt_prtt_enrt_rslt_id ' || p_bckdt_prtt_enrt_rslt_id,10);
4036: hr_utility.set_location('p_prtt_enrt_rslt_id ' || p_prtt_enrt_rslt_id,10);
4037: hr_utility.set_location('p_effective_date ' || p_effective_date,10);
4038: hr_utility.set_location('p_bckdt_elig_cvrd_dpnt_id ' || p_bckdt_elig_cvrd_dpnt_id,10);
4039: --
4040: -- for participant
4041: --
4034: hr_utility.set_location('Entering ' || l_proc,10);
4035: hr_utility.set_location('p_bckdt_prtt_enrt_rslt_id ' || p_bckdt_prtt_enrt_rslt_id,10);
4036: hr_utility.set_location('p_prtt_enrt_rslt_id ' || p_prtt_enrt_rslt_id,10);
4037: hr_utility.set_location('p_effective_date ' || p_effective_date,10);
4038: hr_utility.set_location('p_bckdt_elig_cvrd_dpnt_id ' || p_bckdt_elig_cvrd_dpnt_id,10);
4039: --
4040: -- for participant
4041: --
4042: IF p_bckdt_prtt_enrt_rslt_id is not null
4052: FETCH c_curr_ppr INTO l_curr_ppr;
4053:
4054: IF c_curr_ppr%NOTFOUND
4055: THEN
4056: hr_utility.set_location('Reinstate Provider by Creating ',99099);
4057: ben_prmry_care_prvdr_api.create_prmry_care_prvdr (p_validate => FALSE,
4058: p_prmry_care_prvdr_id => l_prmry_care_prvdr_id,
4059: p_effective_start_date => l_ppr_effective_start_date,
4060: p_effective_end_date => l_ppr_effective_end_date,
4111: l_datetrack_mode := hr_api.g_correction;
4112: ELSE
4113: l_datetrack_mode := hr_api.g_update;
4114: END IF;
4115: hr_utility.set_location('Reinstate Provider by Updating in mode '||l_datetrack_mode,99099);
4116: ben_prmry_care_prvdr_api.update_prmry_care_prvdr (p_validate => FALSE,
4117: p_prmry_care_prvdr_id => l_old_ppr_rec.prmry_care_prvdr_id,
4118: p_effective_start_date => l_ppr_effective_start_date,
4119: p_effective_end_date => l_ppr_effective_end_date,
4167: END LOOP;
4168: --
4169: END IF;
4170: --
4171: hr_utility.set_location('after participant ' || l_proc,20);
4172: -- for dependent
4173: --
4174: IF p_bckdt_prtt_enrt_rslt_id is null
4175: and p_bckdt_elig_cvrd_dpnt_id is not null
4184: FETCH c_curr_ppr INTO l_curr_ppr;
4185:
4186: IF c_curr_ppr%NOTFOUND
4187: THEN
4188: hr_utility.set_location('Reinstate Provider by Creating ',99099);
4189: ben_prmry_care_prvdr_api.create_prmry_care_prvdr (p_validate => FALSE,
4190: p_prmry_care_prvdr_id => l_prmry_care_prvdr_id,
4191: p_effective_start_date => l_ppr_effective_start_date,
4192: p_effective_end_date => l_ppr_effective_end_date,
4243: l_datetrack_mode := hr_api.g_correction;
4244: ELSE
4245: l_datetrack_mode := hr_api.g_update;
4246: END IF;
4247: hr_utility.set_location('Reinstate Provider by Updating in mode '||l_datetrack_mode,99099);
4248: ben_prmry_care_prvdr_api.update_prmry_care_prvdr (p_validate => FALSE,
4249: p_prmry_care_prvdr_id => l_old_ppr_rec.prmry_care_prvdr_id,
4250: p_effective_start_date => l_ppr_effective_start_date,
4251: p_effective_end_date => l_ppr_effective_end_date,
4299: END LOOP;
4300: --
4301: END IF;
4302: --
4303: hr_utility.set_location('Leaving ' || l_proc,30);
4304: --
4305: end reinstate_ppr_per_pen;
4306: --
4307: procedure reinstate_pea_per_pen(
4380: l_rslt_ovn number;
4381: --
4382: begin
4383: --
4384: hr_utility.set_location('Entering benleclr' || l_proc,10);
4385: --
4386: for l_old_pea_rec in c_old_pea loop
4387: --
4388: open c_pea(l_old_pea_rec.actn_typ_id);
4430: --
4431: close c_pea;
4432: end loop;
4433: --
4434: hr_utility.set_location('Leaving ' || l_proc,10);
4435: --
4436: end reinstate_pea_per_pen;
4437:
4438: procedure reinstate_cpp_per_pdp(
4496: l_datetrack_mode varchar2(80) := null;
4497: --
4498: begin
4499: --
4500: hr_utility.set_location('Entering ' || l_proc,10);
4501: --
4502: for l_old_cpp_rec in c_old_cpp loop
4503: --
4504: open c_cpp(l_old_cpp_rec.actn_typ_id, l_old_cpp_rec.dpnt_dsgn_ctfn_typ_cd);
4575: --
4576: close c_cpp;
4577: end loop;
4578: --
4579: hr_utility.set_location('Leaving ' || l_proc,10);
4580: --
4581: end reinstate_cpp_per_pdp;
4582: --
4583: -- This procedure creates the enrollment results based on what participant
4799: l_enrt_cvg_strt_dt date; -- bug 5895645
4800: --
4801: begin
4802: --
4803: hr_utility.set_location('Entering ' || l_proc,10);
4804: hr_utility.set_location('p_bckdt_per_in_ler_id ' || p_bckdt_per_in_ler_id,10);
4805: hr_utility.set_location('p_bckdt_prtt_enrt_rslt_id ' || p_bckdt_prtt_enrt_rslt_id,10);
4806: hr_utility.set_location('p_prtt_enrt_rslt_id ' || p_prtt_enrt_rslt_id,10);
4807: --
4800: --
4801: begin
4802: --
4803: hr_utility.set_location('Entering ' || l_proc,10);
4804: hr_utility.set_location('p_bckdt_per_in_ler_id ' || p_bckdt_per_in_ler_id,10);
4805: hr_utility.set_location('p_bckdt_prtt_enrt_rslt_id ' || p_bckdt_prtt_enrt_rslt_id,10);
4806: hr_utility.set_location('p_prtt_enrt_rslt_id ' || p_prtt_enrt_rslt_id,10);
4807: --
4808:
4801: begin
4802: --
4803: hr_utility.set_location('Entering ' || l_proc,10);
4804: hr_utility.set_location('p_bckdt_per_in_ler_id ' || p_bckdt_per_in_ler_id,10);
4805: hr_utility.set_location('p_bckdt_prtt_enrt_rslt_id ' || p_bckdt_prtt_enrt_rslt_id,10);
4806: hr_utility.set_location('p_prtt_enrt_rslt_id ' || p_prtt_enrt_rslt_id,10);
4807: --
4808:
4809: --
4802: --
4803: hr_utility.set_location('Entering ' || l_proc,10);
4804: hr_utility.set_location('p_bckdt_per_in_ler_id ' || p_bckdt_per_in_ler_id,10);
4805: hr_utility.set_location('p_bckdt_prtt_enrt_rslt_id ' || p_bckdt_prtt_enrt_rslt_id,10);
4806: hr_utility.set_location('p_prtt_enrt_rslt_id ' || p_prtt_enrt_rslt_id,10);
4807: --
4808:
4809: --
4810: for bckdt_pen_dpnts_rec in c_bckdt_pen_dpnts loop
4808:
4809: --
4810: for bckdt_pen_dpnts_rec in c_bckdt_pen_dpnts loop
4811: --
4812: hr_utility.set_location('Reinstating dependent person id = ' ||
4813: bckdt_pen_dpnts_rec.dpnt_person_id, 999);
4814: open c_pen_dpnts(bckdt_pen_dpnts_rec.dpnt_person_id);
4815: fetch c_pen_dpnts into l_pen_dpnts_rec;
4816: if c_pen_dpnts%notfound then
4813: bckdt_pen_dpnts_rec.dpnt_person_id, 999);
4814: open c_pen_dpnts(bckdt_pen_dpnts_rec.dpnt_person_id);
4815: fetch c_pen_dpnts into l_pen_dpnts_rec;
4816: if c_pen_dpnts%notfound then
4817: hr_utility.set_location('Creating new dependent row', 8085);
4818: --
4819: -- Create the dependents row.
4820: --
4821: -- Calculate Dependents Coverage Start Date
4854: l_cvg_strt_dt := nvl(p_enrt_cvg_strt_dt,l_enrt_cvg_strt_dt);
4855: --
4856: end if;
4857: --
4858: hr_utility.set_location('Cvg start dt ='||to_char(l_cvg_strt_dt), 25);
4859: hr_utility.set_location('p_enrt_cvg_strt_dt ='||to_char(p_enrt_cvg_strt_dt), 25);
4860: hr_utility.set_location('l_enrt_cvg_strt_dt =' || l_enrt_cvg_strt_dt, 25);
4861: --
4862: -- Now hook the depenedent to the new enrollment result.
4855: --
4856: end if;
4857: --
4858: hr_utility.set_location('Cvg start dt ='||to_char(l_cvg_strt_dt), 25);
4859: hr_utility.set_location('p_enrt_cvg_strt_dt ='||to_char(p_enrt_cvg_strt_dt), 25);
4860: hr_utility.set_location('l_enrt_cvg_strt_dt =' || l_enrt_cvg_strt_dt, 25);
4861: --
4862: -- Now hook the depenedent to the new enrollment result.
4863: --
4856: end if;
4857: --
4858: hr_utility.set_location('Cvg start dt ='||to_char(l_cvg_strt_dt), 25);
4859: hr_utility.set_location('p_enrt_cvg_strt_dt ='||to_char(p_enrt_cvg_strt_dt), 25);
4860: hr_utility.set_location('l_enrt_cvg_strt_dt =' || l_enrt_cvg_strt_dt, 25);
4861: --
4862: -- Now hook the depenedent to the new enrollment result.
4863: --
4864: open c_epe_dpnt(bckdt_pen_dpnts_rec.dpnt_person_id);
4883: close c_epe_dpnt;
4884: --
4885: --
4886: elsif bckdt_pen_dpnts_rec.cvg_thru_dt <> hr_api.g_eot then
4887: hr_utility.set_location('End-dated row found - vvp', 7777);
4888:
4889: --5692797 Check whether backed out PDP record exists for the dependent in same enrollment
4890: --with valid coverage. If yes, no need to reinstate this end-dated record.
4891: l_chk_valid_pdp := null;
4892: open c_chk_valid_pdp(bckdt_pen_dpnts_rec.elig_cvrd_dpnt_id);
4893: fetch c_chk_valid_pdp into l_chk_valid_pdp;
4894: close c_chk_valid_pdp;
4895:
4896: hr_utility.set_location('l_chk_valid_pdp = '|| l_chk_valid_pdp, 8085);
4897: if l_chk_valid_pdp is null then
4898: open c_epe_dpnt(bckdt_pen_dpnts_rec.dpnt_person_id);
4899: fetch c_epe_dpnt into l_epe_dpnt_rec;
4900: if c_epe_dpnt%found then
4918: end if; --end l_chk_valid_pdp
4919: end if;
4920: close c_pen_dpnts;
4921: --
4922: hr_utility.set_location('l_elig_cvrd_dpnt_id ='||l_elig_cvrd_dpnt_id, 25);
4923: hr_utility.set_location('p_bckdt_prtt_enrt_rslt_id'||p_bckdt_prtt_enrt_rslt_id,25);
4924: hr_utility.set_location('bckdt_pen_dpnts_rec.elig_cvrd_dpnt_id'||bckdt_pen_dpnts_rec.elig_cvrd_dpnt_id,25);
4925: hr_utility.set_location('p_prtt_enrt_rslt_id'||p_prtt_enrt_rslt_id,25);
4926: hr_utility.set_location('p_business_group_id'||p_business_group_id,25);
4919: end if;
4920: close c_pen_dpnts;
4921: --
4922: hr_utility.set_location('l_elig_cvrd_dpnt_id ='||l_elig_cvrd_dpnt_id, 25);
4923: hr_utility.set_location('p_bckdt_prtt_enrt_rslt_id'||p_bckdt_prtt_enrt_rslt_id,25);
4924: hr_utility.set_location('bckdt_pen_dpnts_rec.elig_cvrd_dpnt_id'||bckdt_pen_dpnts_rec.elig_cvrd_dpnt_id,25);
4925: hr_utility.set_location('p_prtt_enrt_rslt_id'||p_prtt_enrt_rslt_id,25);
4926: hr_utility.set_location('p_business_group_id'||p_business_group_id,25);
4927: hr_utility.set_location('p_effective_date'||p_effective_date,25);
4920: close c_pen_dpnts;
4921: --
4922: hr_utility.set_location('l_elig_cvrd_dpnt_id ='||l_elig_cvrd_dpnt_id, 25);
4923: hr_utility.set_location('p_bckdt_prtt_enrt_rslt_id'||p_bckdt_prtt_enrt_rslt_id,25);
4924: hr_utility.set_location('bckdt_pen_dpnts_rec.elig_cvrd_dpnt_id'||bckdt_pen_dpnts_rec.elig_cvrd_dpnt_id,25);
4925: hr_utility.set_location('p_prtt_enrt_rslt_id'||p_prtt_enrt_rslt_id,25);
4926: hr_utility.set_location('p_business_group_id'||p_business_group_id,25);
4927: hr_utility.set_location('p_effective_date'||p_effective_date,25);
4928: hr_utility.set_location('p_person_id '||p_person_id,25);
4921: --
4922: hr_utility.set_location('l_elig_cvrd_dpnt_id ='||l_elig_cvrd_dpnt_id, 25);
4923: hr_utility.set_location('p_bckdt_prtt_enrt_rslt_id'||p_bckdt_prtt_enrt_rslt_id,25);
4924: hr_utility.set_location('bckdt_pen_dpnts_rec.elig_cvrd_dpnt_id'||bckdt_pen_dpnts_rec.elig_cvrd_dpnt_id,25);
4925: hr_utility.set_location('p_prtt_enrt_rslt_id'||p_prtt_enrt_rslt_id,25);
4926: hr_utility.set_location('p_business_group_id'||p_business_group_id,25);
4927: hr_utility.set_location('p_effective_date'||p_effective_date,25);
4928: hr_utility.set_location('p_person_id '||p_person_id,25);
4929: --
4922: hr_utility.set_location('l_elig_cvrd_dpnt_id ='||l_elig_cvrd_dpnt_id, 25);
4923: hr_utility.set_location('p_bckdt_prtt_enrt_rslt_id'||p_bckdt_prtt_enrt_rslt_id,25);
4924: hr_utility.set_location('bckdt_pen_dpnts_rec.elig_cvrd_dpnt_id'||bckdt_pen_dpnts_rec.elig_cvrd_dpnt_id,25);
4925: hr_utility.set_location('p_prtt_enrt_rslt_id'||p_prtt_enrt_rslt_id,25);
4926: hr_utility.set_location('p_business_group_id'||p_business_group_id,25);
4927: hr_utility.set_location('p_effective_date'||p_effective_date,25);
4928: hr_utility.set_location('p_person_id '||p_person_id,25);
4929: --
4930: if l_elig_cvrd_dpnt_id is not null then
4923: hr_utility.set_location('p_bckdt_prtt_enrt_rslt_id'||p_bckdt_prtt_enrt_rslt_id,25);
4924: hr_utility.set_location('bckdt_pen_dpnts_rec.elig_cvrd_dpnt_id'||bckdt_pen_dpnts_rec.elig_cvrd_dpnt_id,25);
4925: hr_utility.set_location('p_prtt_enrt_rslt_id'||p_prtt_enrt_rslt_id,25);
4926: hr_utility.set_location('p_business_group_id'||p_business_group_id,25);
4927: hr_utility.set_location('p_effective_date'||p_effective_date,25);
4928: hr_utility.set_location('p_person_id '||p_person_id,25);
4929: --
4930: if l_elig_cvrd_dpnt_id is not null then
4931: --Reinstates PCP at dependent level.
4924: hr_utility.set_location('bckdt_pen_dpnts_rec.elig_cvrd_dpnt_id'||bckdt_pen_dpnts_rec.elig_cvrd_dpnt_id,25);
4925: hr_utility.set_location('p_prtt_enrt_rslt_id'||p_prtt_enrt_rslt_id,25);
4926: hr_utility.set_location('p_business_group_id'||p_business_group_id,25);
4927: hr_utility.set_location('p_effective_date'||p_effective_date,25);
4928: hr_utility.set_location('p_person_id '||p_person_id,25);
4929: --
4930: if l_elig_cvrd_dpnt_id is not null then
4931: --Reinstates PCP at dependent level.
4932: reinstate_ppr_per_pen(
4979: );
4980: --
4981: end if;
4982: --
4983: hr_utility.set_location('Leaving ' || l_proc,10);
4984: --
4985: end reinstate_dpnts_per_pen;
4986: --
4987: procedure reinstate_pbc_per_pbn(
5041: l_datetrack_mode varchar2(80) := null;
5042: --
5043: begin
5044: --
5045: hr_utility.set_location('Entering ' || l_proc,10);
5046: --
5047: for l_old_pbc_rec in c_old_pbc loop
5048: --
5049: open c_pbc(l_old_pbc_rec.actn_typ_id, l_old_pbc_rec.BNF_CTFN_TYP_CD);
5120: --
5121: close c_pbc;
5122: end loop;
5123: --
5124: hr_utility.set_location('Leaving ' || l_proc,10);
5125: --
5126: end reinstate_pbc_per_pbn;
5127: --
5128: -- This procedure creates the enrollment beneficiary records for each
5292: l_datetrack_mode varchar2(80) := null;
5293: --
5294: begin
5295: --
5296: hr_utility.set_location('Entering ' || l_proc,10);
5297: --
5298: for l_old_bnf_rec in c_old_bnf loop
5299: --
5300: open c_bnf(l_old_bnf_rec.bnf_person_id);
5471: close c_bnf;
5472: end loop;
5473: --
5474: --We need to add the call to process_bnf_actn_items which will
5475: hr_utility.set_location('Leaving ' || l_proc,10);
5476: --
5477: end reinstate_pbn_per_pen;
5478: --
5479: procedure reinstate_pcs_per_pen(
5532: l_datetrack_mode varchar2(80) := null;
5533: --
5534: begin
5535: --
5536: hr_utility.set_location('Entering ' || l_proc,10);
5537: --
5538: for l_old_pcs_rec in c_old_pcs loop
5539: --
5540: open c_pcs(l_old_pcs_rec.enrt_ctfn_typ_cd,
5588: --
5589: close c_pcs;
5590: end loop;
5591: --
5592: hr_utility.set_location('Leaving ' || l_proc,10);
5593: --
5594: end reinstate_pcs_per_pen;
5595: --
5596: -- This procedure creates the enrollment results based on what participant
6121: l_enrt_cvg_strt_dt date;
6122: --
6123: begin
6124: --
6125: hr_utility.set_location('Entering ' || l_proc,10);
6126: --
6127: open c_bckdt_pil;
6128: fetch c_bckdt_pil into l_bckdt_pil_prev_stat_cd, l_bckdt_pil_ovn, l_bckt_csd_per_in_ler_id;
6129: close c_bckdt_pil;
6158: --
6159: -- If the enrollment record is valid for the current
6160: -- effective_date then recreate the enrollment.
6161: --
6162: hr_utility.set_location('Inside BCKDT pen loop ' || l_proc,20);
6163: --
6164: -- if p_effective_date <= l_bckdt_pen_rec.effective_end_date
6165: --
6166: l_bckt_csd_pen_esd := null;
6186: l_bckdt_pen_rec.pgm_id,
6187: l_bckdt_pen_rec.oipl_id);
6188: fetch c_epe_pen into l_epe_pen_rec;
6189: close c_epe_pen;
6190: hr_utility.set_location('After epe fetch ' || l_proc,30);
6191: --
6192: g_sys_date := greatest(trunc(l_epe_pen_rec.enrt_perd_strt_dt),
6193: nvl(nvl(l_bckt_csd_pen_esd, g_bckt_csd_lf_evt_ocrd_dt), hr_api.g_sot),
6194: l_bckdt_pen_rec.effective_start_date);
6200: --
6201: l_max_enrt_esd := greatest(g_sys_date, nvl(l_max_enrt_esd, hr_api.g_sot));
6202: --
6203: --
6204: hr_utility.set_location('Date used to reinstate the enrollment = ' || g_sys_date, 333);
6205: if g_sys_date <= l_bckdt_pen_rec.effective_end_date
6206: then
6207: --
6208: -- Get the benefits Information.
6213: --
6214: open c_bnft(l_epe_pen_rec.elig_per_elctbl_chc_id,l_bckdt_pen_rec.bnft_ordr_num );
6215: loop
6216: --
6217: hr_utility.set_location('Inside bnft loop ' || l_proc,40);
6218: --Bug 3315323 we need to reinstate the previuos benefit amount for the case
6219: --of SAAEAR also as enb record may have null value there for first enrollment
6220: --or it may not be the right amount.
6221: --
6250: l_bnft_rec.val := l_bckdt_pen_rec.BNFT_AMT;
6251: --
6252: end if;
6253: end if;
6254: hr_utility.set_location(l_proc,50);
6255: close c_bnft;
6256: --
6257: for l_count in 1..10 loop
6258: --
6270: for l_rec in c_rt(l_epe_pen_rec.elig_per_elctbl_chc_id,
6271: l_bnft_rec.enrt_bnft_id)
6272: loop
6273: --
6274: hr_utility.set_location('Inside rate loop ' ||l_proc,50);
6275: --
6276: -- Get the prtt rate val for this enrollment result.
6277: -- Use to pass to the enrollment process.
6278: --
6278: --
6279: -- Bug : 1634870 : If the user not selected the rate before backout
6280: -- then do not pass it to the reinstate process.
6281: --
6282: hr_utility.set_location('enrt_rt_id : dflt_val : val : entr_val' ||
6283: '_at_enrt_flag : acty_base_rt_id : ' , 501);
6284: hr_utility.set_location(l_rec.enrt_rt_id || ' : ' || l_rec.dflt_val || ' : ' || l_rec.val || ' : '
6285: || l_rec.entr_val_at_enrt_flag || ' : ' ||
6286: l_rec.acty_base_rt_id, 501);
6280: -- then do not pass it to the reinstate process.
6281: --
6282: hr_utility.set_location('enrt_rt_id : dflt_val : val : entr_val' ||
6283: '_at_enrt_flag : acty_base_rt_id : ' , 501);
6284: hr_utility.set_location(l_rec.enrt_rt_id || ' : ' || l_rec.dflt_val || ' : ' || l_rec.val || ' : '
6285: || l_rec.entr_val_at_enrt_flag || ' : ' ||
6286: l_rec.acty_base_rt_id, 501);
6287: --
6288: l_prv_rec := l_prv_rec_nulls;
6291: fetch c_prv into l_prv_rec;
6292: if c_prv%found then -- l_prv_rec.prtt_rt_val_id is not null then
6293: --
6294: l_count := l_count+1;
6295: hr_utility.set_location('prtt_rt_val_id : rt_val : ' ||
6296: l_prv_rec.prtt_rt_val_id || ' : ' || l_prv_rec.rt_val
6297: || ' : ' || l_prv_rec.acty_base_rt_id , 502);
6298: l_rt_table(l_count).enrt_rt_id := l_rec.enrt_rt_id;
6299: if l_prv_rec.mlt_cd in ('CL','CVG','AP','PRNT','CLANDCVG','APANDCVG','PRNTANDCVG') then
6344: then
6345: l_enrt_cvg_strt_dt := l_bckdt_pen_rec.enrt_cvg_strt_dt ;
6346: end if ;
6347: -- 5746429 ends
6348: hr_utility.set_location('Calling ben_election_information ' ||l_proc,60);
6349: hr_utility.set_location('Calling l_bnft_rec.val ' ||l_bnft_rec.val,60);
6350: hr_utility.set_location('Calling l_enrt_cvg_strt_dt ' ||l_enrt_cvg_strt_dt,60);
6351: --
6352: --
6345: l_enrt_cvg_strt_dt := l_bckdt_pen_rec.enrt_cvg_strt_dt ;
6346: end if ;
6347: -- 5746429 ends
6348: hr_utility.set_location('Calling ben_election_information ' ||l_proc,60);
6349: hr_utility.set_location('Calling l_bnft_rec.val ' ||l_bnft_rec.val,60);
6350: hr_utility.set_location('Calling l_enrt_cvg_strt_dt ' ||l_enrt_cvg_strt_dt,60);
6351: --
6352: --
6353: ben_election_information.election_information
6346: end if ;
6347: -- 5746429 ends
6348: hr_utility.set_location('Calling ben_election_information ' ||l_proc,60);
6349: hr_utility.set_location('Calling l_bnft_rec.val ' ||l_bnft_rec.val,60);
6350: hr_utility.set_location('Calling l_enrt_cvg_strt_dt ' ||l_enrt_cvg_strt_dt,60);
6351: --
6352: --
6353: ben_election_information.election_information
6354: (p_elig_per_elctbl_chc_id => l_epe_pen_rec.elig_per_elctbl_chc_id,
6538: := l_epe_pen_rec.dpnt_cvg_strt_dt_cd;
6539: l_enrt_table(l_enrt_count).dpnt_cvg_strt_dt_rl
6540: := l_epe_pen_rec.dpnt_cvg_strt_dt_rl;
6541: /* Trace messages for the enrollments, uncomment for tracing bugs */
6542: hr_utility.set_location('prtt_enrt_rslt_id = ' ||
6543: l_enrt_table(l_enrt_count).prtt_enrt_rslt_id, 9999);
6544: hr_utility.set_location('bckdt_prtt_enrt_rslt_id = ' ||
6545: l_enrt_table(l_enrt_count).bckdt_prtt_enrt_rslt_id, 9999);
6546: hr_utility.set_location('bckdt_enrt_ovridn_flag = ' ||
6540: := l_epe_pen_rec.dpnt_cvg_strt_dt_rl;
6541: /* Trace messages for the enrollments, uncomment for tracing bugs */
6542: hr_utility.set_location('prtt_enrt_rslt_id = ' ||
6543: l_enrt_table(l_enrt_count).prtt_enrt_rslt_id, 9999);
6544: hr_utility.set_location('bckdt_prtt_enrt_rslt_id = ' ||
6545: l_enrt_table(l_enrt_count).bckdt_prtt_enrt_rslt_id, 9999);
6546: hr_utility.set_location('bckdt_enrt_ovridn_flag = ' ||
6547: l_enrt_table(l_enrt_count).bckdt_enrt_ovridn_flag, 72);
6548: hr_utility.set_location('bckdt_enrt_cvg_strt_dt = ' ||
6542: hr_utility.set_location('prtt_enrt_rslt_id = ' ||
6543: l_enrt_table(l_enrt_count).prtt_enrt_rslt_id, 9999);
6544: hr_utility.set_location('bckdt_prtt_enrt_rslt_id = ' ||
6545: l_enrt_table(l_enrt_count).bckdt_prtt_enrt_rslt_id, 9999);
6546: hr_utility.set_location('bckdt_enrt_ovridn_flag = ' ||
6547: l_enrt_table(l_enrt_count).bckdt_enrt_ovridn_flag, 72);
6548: hr_utility.set_location('bckdt_enrt_cvg_strt_dt = ' ||
6549: l_enrt_table(l_enrt_count).bckdt_enrt_cvg_strt_dt, 72);
6550: hr_utility.set_location('pen_ovn_number = ' ||
6544: hr_utility.set_location('bckdt_prtt_enrt_rslt_id = ' ||
6545: l_enrt_table(l_enrt_count).bckdt_prtt_enrt_rslt_id, 9999);
6546: hr_utility.set_location('bckdt_enrt_ovridn_flag = ' ||
6547: l_enrt_table(l_enrt_count).bckdt_enrt_ovridn_flag, 72);
6548: hr_utility.set_location('bckdt_enrt_cvg_strt_dt = ' ||
6549: l_enrt_table(l_enrt_count).bckdt_enrt_cvg_strt_dt, 72);
6550: hr_utility.set_location('pen_ovn_number = ' ||
6551: l_enrt_table(l_enrt_count).pen_ovn_number, 9999);
6552: hr_utility.set_location('old_pl_id = ' ||
6546: hr_utility.set_location('bckdt_enrt_ovridn_flag = ' ||
6547: l_enrt_table(l_enrt_count).bckdt_enrt_ovridn_flag, 72);
6548: hr_utility.set_location('bckdt_enrt_cvg_strt_dt = ' ||
6549: l_enrt_table(l_enrt_count).bckdt_enrt_cvg_strt_dt, 72);
6550: hr_utility.set_location('pen_ovn_number = ' ||
6551: l_enrt_table(l_enrt_count).pen_ovn_number, 9999);
6552: hr_utility.set_location('old_pl_id = ' ||
6553: l_enrt_table(l_enrt_count).old_pl_id, 9999);
6554: hr_utility.set_location('new_pl_id = ' ||
6548: hr_utility.set_location('bckdt_enrt_cvg_strt_dt = ' ||
6549: l_enrt_table(l_enrt_count).bckdt_enrt_cvg_strt_dt, 72);
6550: hr_utility.set_location('pen_ovn_number = ' ||
6551: l_enrt_table(l_enrt_count).pen_ovn_number, 9999);
6552: hr_utility.set_location('old_pl_id = ' ||
6553: l_enrt_table(l_enrt_count).old_pl_id, 9999);
6554: hr_utility.set_location('new_pl_id = ' ||
6555: l_enrt_table(l_enrt_count).new_pl_id, 9999);
6556: hr_utility.set_location('old_oipl_id = ' ||
6550: hr_utility.set_location('pen_ovn_number = ' ||
6551: l_enrt_table(l_enrt_count).pen_ovn_number, 9999);
6552: hr_utility.set_location('old_pl_id = ' ||
6553: l_enrt_table(l_enrt_count).old_pl_id, 9999);
6554: hr_utility.set_location('new_pl_id = ' ||
6555: l_enrt_table(l_enrt_count).new_pl_id, 9999);
6556: hr_utility.set_location('old_oipl_id = ' ||
6557: l_enrt_table(l_enrt_count).old_oipl_id, 9999);
6558: hr_utility.set_location('new_oipl_id = ' ||
6552: hr_utility.set_location('old_pl_id = ' ||
6553: l_enrt_table(l_enrt_count).old_pl_id, 9999);
6554: hr_utility.set_location('new_pl_id = ' ||
6555: l_enrt_table(l_enrt_count).new_pl_id, 9999);
6556: hr_utility.set_location('old_oipl_id = ' ||
6557: l_enrt_table(l_enrt_count).old_oipl_id, 9999);
6558: hr_utility.set_location('new_oipl_id = ' ||
6559: l_enrt_table(l_enrt_count).new_oipl_id, 9999);
6560: hr_utility.set_location('old_pl_typ_id = ' ||
6554: hr_utility.set_location('new_pl_id = ' ||
6555: l_enrt_table(l_enrt_count).new_pl_id, 9999);
6556: hr_utility.set_location('old_oipl_id = ' ||
6557: l_enrt_table(l_enrt_count).old_oipl_id, 9999);
6558: hr_utility.set_location('new_oipl_id = ' ||
6559: l_enrt_table(l_enrt_count).new_oipl_id, 9999);
6560: hr_utility.set_location('old_pl_typ_id = ' ||
6561: l_enrt_table(l_enrt_count).old_pl_typ_id, 9999);
6562: hr_utility.set_location('new_pl_typ_id = ' ||
6556: hr_utility.set_location('old_oipl_id = ' ||
6557: l_enrt_table(l_enrt_count).old_oipl_id, 9999);
6558: hr_utility.set_location('new_oipl_id = ' ||
6559: l_enrt_table(l_enrt_count).new_oipl_id, 9999);
6560: hr_utility.set_location('old_pl_typ_id = ' ||
6561: l_enrt_table(l_enrt_count).old_pl_typ_id, 9999);
6562: hr_utility.set_location('new_pl_typ_id = ' ||
6563: l_enrt_table(l_enrt_count).new_pl_typ_id, 9999);
6564: hr_utility.set_location('pgm_id = ' ||
6558: hr_utility.set_location('new_oipl_id = ' ||
6559: l_enrt_table(l_enrt_count).new_oipl_id, 9999);
6560: hr_utility.set_location('old_pl_typ_id = ' ||
6561: l_enrt_table(l_enrt_count).old_pl_typ_id, 9999);
6562: hr_utility.set_location('new_pl_typ_id = ' ||
6563: l_enrt_table(l_enrt_count).new_pl_typ_id, 9999);
6564: hr_utility.set_location('pgm_id = ' ||
6565: l_enrt_table(l_enrt_count).pgm_id, 9999);
6566: hr_utility.set_location('elig_per_elctbl_chc_id = ' ||
6560: hr_utility.set_location('old_pl_typ_id = ' ||
6561: l_enrt_table(l_enrt_count).old_pl_typ_id, 9999);
6562: hr_utility.set_location('new_pl_typ_id = ' ||
6563: l_enrt_table(l_enrt_count).new_pl_typ_id, 9999);
6564: hr_utility.set_location('pgm_id = ' ||
6565: l_enrt_table(l_enrt_count).pgm_id, 9999);
6566: hr_utility.set_location('elig_per_elctbl_chc_id = ' ||
6567: l_enrt_table(l_enrt_count).elig_per_elctbl_chc_id, 9999);
6568: /**/
6562: hr_utility.set_location('new_pl_typ_id = ' ||
6563: l_enrt_table(l_enrt_count).new_pl_typ_id, 9999);
6564: hr_utility.set_location('pgm_id = ' ||
6565: l_enrt_table(l_enrt_count).pgm_id, 9999);
6566: hr_utility.set_location('elig_per_elctbl_chc_id = ' ||
6567: l_enrt_table(l_enrt_count).elig_per_elctbl_chc_id, 9999);
6568: /**/
6569: --
6570: end if;
6677: end if;
6678: --
6679: if l_bckdt_pil_prev_stat_cd<>'STRTD' or
6680: l_found_non_automatics then
6681: hr_utility.set_location('Date for multi row edits = ' ||
6682: l_pgm_table(l_cnt).max_enrt_esd || ' ' || ' pgm = ' ||
6683: l_pgm_table(l_cnt).pgm_id, 333);
6684: ben_prtt_enrt_result_api.multi_rows_edit
6685: (p_person_id => p_person_id,
6705: -- created.
6706: --
6707: -- Call multi row edits just as miscellanious form calls.
6708: --
6709: hr_utility.set_location('Date for multi row edits = ' ||
6710: l_max_enrt_esd , 333);
6711: ben_prtt_enrt_result_api.multi_rows_edit
6712: (p_person_id => p_person_id,
6713: p_effective_date => l_max_enrt_esd,
6778: for l_cnt in 1..l_pl_table.LAST loop
6779: --
6780: -- Invoke post result process
6781: --
6782: hr_utility.set_location('Date = ' || l_pl_table(l_cnt).max_enrt_esd, 333);
6783: hr_utility.set_location('PL = ' || l_pl_table(l_cnt).pl_id, 333);
6784: --RCHASE - ensure automatics are handled differently than
6785: -- form enrollments by process_post_enrollment
6786: -- Bug 5623259.
6779: --
6780: -- Invoke post result process
6781: --
6782: hr_utility.set_location('Date = ' || l_pl_table(l_cnt).max_enrt_esd, 333);
6783: hr_utility.set_location('PL = ' || l_pl_table(l_cnt).pl_id, 333);
6784: --RCHASE - ensure automatics are handled differently than
6785: -- form enrollments by process_post_enrollment
6786: -- Bug 5623259.
6787: --
6822: for l_cnt in 1..l_enrt_table.LAST loop
6823: --
6824: -- Reinstate the enrollment beneficiary rows.
6825: --
6826: hr_utility.set_location('Enrt Date = ' ||
6827: l_enrt_table(l_cnt).effective_start_date, 333);
6828: hr_utility.set_location('Reinstate the enrollment beneficiary rows',12);
6829: reinstate_pbn_per_pen(
6830: p_person_id => p_person_id
6824: -- Reinstate the enrollment beneficiary rows.
6825: --
6826: hr_utility.set_location('Enrt Date = ' ||
6827: l_enrt_table(l_cnt).effective_start_date, 333);
6828: hr_utility.set_location('Reinstate the enrollment beneficiary rows',12);
6829: reinstate_pbn_per_pen(
6830: p_person_id => p_person_id
6831: ,p_bckdt_prtt_enrt_rslt_id
6832: => l_enrt_table(l_cnt).bckdt_prtt_enrt_rslt_id
6916: for i in 1..l_enrt_table.last loop
6917: --
6918: if l_enrt_table(i).bckdt_enrt_ovridn_flag = 'Y' then
6919: --
6920: hr_utility.set_location('Restoring the overriden result: ' ||
6921: l_enrt_table(i).bckdt_prtt_enrt_rslt_id, 72);
6922: --
6923: -- Get the latest object version number as the post enrollment process
6924: -- may have updated the new enrt result.
6948: for l_rt_rec in c_ovridn_rt(l_enrt_table(i).bckdt_prtt_enrt_rslt_id
6949: ,l_enrt_table(i).prtt_enrt_rslt_id )
6950: loop
6951: --
6952: hr_utility.set_location('Updating new prv: ' || l_rt_rec.new_prv_id ||
6953: ' with overriden prv_id: ' ||
6954: l_rt_rec.prtt_rt_val_id, 72);
6955: --
6956: ben_prtt_rt_val_api.update_prtt_rt_val
6977: ,l_enrt_table(i).prtt_enrt_rslt_id
6978: ,l_enrt_table(i).g_sys_date)
6979: loop
6980: --
6981: hr_utility.set_location('Updating new ecd with overriden ecd_id: ' ||
6982: l_dpnt_rec.elig_cvrd_dpnt_id, 72);
6983: --
6984: ben_elig_cvrd_dpnt_api.update_elig_cvrd_dpnt
6985: (p_elig_cvrd_dpnt_id => l_dpnt_rec.new_pdp_id
7036: ,p_ler_id => null
7037: ,p_per_in_ler_id => p_per_in_ler_id
7038: );
7039: --
7040: hr_utility.set_location ('Leaving '||l_proc,10);
7041: --
7042: end reinstate_the_prev_enrt;
7043: --
7044: -- ----------------------------------------------------------------------------
7064:
7065: --
7066: begin
7067: --
7068: hr_utility.set_location ('Entering '||l_proc,10);
7069: --
7070: get_inter_pil_cnt (
7071: p_bckdt_per_in_ler_id => p_bckdt_per_in_ler_id,
7072: p_per_in_ler_id => p_per_in_ler_id,
7079: p_inter_pil_cnt => l_inter_pil_cnt,
7080: p_inter_pil_le_dt => l_inter_pil_le_dt,
7081: p_effective_date => p_effective_date);
7082: --
7083: hr_utility.set_location ('Entering Inter pil ='|| l_inter_pil_cnt , 4987);
7084: if l_inter_pil_cnt = 0
7085: then
7086: --
7087: -- No intervening pil's so need to check the backed out
7271: l_found boolean;
7272: --
7273: begin
7274: --
7275: hr_utility.set_location ('Entering '||l_proc,10);
7276: l_found := FALSE;
7277: --
7278: if nvl(p_bckdt_epe_row.pl_id, -1) = nvl(p_current_epe_row.pl_id, -1) and
7279: nvl(p_bckdt_epe_row.oipl_id, -1) = nvl(p_current_epe_row.oipl_id, -1) and
7393: l_differ := 'Y';
7394: --
7395: end if; -- epe ckecks if statement
7396: --
7397: hr_utility.set_location('Leaving:' || l_differ || l_proc, 10);
7398: --
7399: return l_differ;
7400: --
7401: end comp_ori_new_epe;
7433: --
7434: --
7435: begin
7436: --
7437: hr_utility.set_location('Entering ' || l_proc,10);
7438: --
7439: l_bkd_penepe_counter := 0 ;
7440: l_bkd_pilepe_inst_table.delete ;
7441: l_bckdt_pen_table.delete ;
7447: c_pgm_id => p_pgm_id,
7448: c_pl_id => p_pl_id ) loop
7449: --
7450: --
7451: hr_utility.set_location('Inside BCKDT pen loop ' || l_proc,20);
7452: --
7453: ben_reinstate_epe_cache.get_pilcobjepe_dets(
7454: p_per_in_ler_id => p_bckdt_per_in_ler_id
7455: ,p_pgm_id => l_bckdt_pen_rec.pgm_id
7481: end loop;
7482: p_pilepe_inst_table := l_bkd_pilepe_inst_table ;
7483: p_bckdt_pen_table := l_bckdt_pen_table ;
7484: --
7485: hr_utility.set_location ('Leaving '||l_proc,10);
7486: --
7487: end get_backedout_results;
7488: --
7489: /**** NO LONGER USED.... NEEDS TO BE DELETED COMPLETD
7523: l_schema VARCHAR2(10);
7524: --
7525: begin
7526: --
7527: hr_utility.set_location ('Entering '||l_proc,10);
7528: --
7529: -- 9999 Remove it after complete test.
7530: -- bug 4615207 : added GHR product installation chk -Multiple Rate chk to be performed only for GHR
7531: IF (fnd_installation.get_app_info('GHR',l_dummy1, l_dummy2, l_schema)) THEN
7533: fetch c_multiple_rate into l_dummy;
7534: if c_multiple_rate%found then
7535: close c_multiple_rate;
7536: -- Multiple rate is found and no reinstate
7537: hr_utility.set_location ('Multiple rate found and no reinstate done',11);
7538: return;
7539: end if;
7540: close c_multiple_rate;
7541:
7615: p_effective_date => p_effective_date);
7616: --
7617: end if;
7618: --
7619: hr_utility.set_location('Leaving:'|| l_proc, 10);
7620: --
7621: end p_lf_evt_clps_restore_old;
7622: -- New reinstate Enrollment routine
7623: */
7814: l_enrt_cvg_strt_dt date;
7815: --
7816: begin
7817: --
7818: hr_utility.set_location('Entering ' || l_proc,10);
7819: --
7820: open c_bckdt_pil;
7821: fetch c_bckdt_pil into l_bckdt_pil_prev_stat_cd, l_bckdt_pil_ovn, l_bckt_csd_per_in_ler_id;
7822: close c_bckdt_pil;
7855: --
7856: -- If the enrollment record is valid for the current
7857: -- effective_date then recreate the enrollment.
7858: --
7859: hr_utility.set_location('Inside BCKDT pen loop ' || l_proc,20);
7860: --
7861: --
7862: l_bckt_csd_pen_esd := null;
7863: l_bckt_csd_pil_leod := null;
7880: --
7881: --
7882: l_epe_pen_rec := p_epe_table(l_pen_record);
7883: --
7884: hr_utility.set_location('After epe fetch ' || l_proc,30);
7885: --
7886: g_sys_date := greatest(trunc(p_enrt_perd_strt_dt),
7887: nvl(nvl(l_bckt_csd_pen_esd, g_bckt_csd_lf_evt_ocrd_dt), hr_api.g_sot),
7888: l_bckdt_pen_rec.effective_start_date);
7889: --
7890: l_max_enrt_esd := greatest(g_sys_date, nvl(l_max_enrt_esd, hr_api.g_sot));
7891: --
7892: --
7893: hr_utility.set_location('Date used to reinstate the enrollment = ' || g_sys_date, 333);
7894: --
7895: if g_sys_date <= l_bckdt_pen_rec.effective_end_date
7896: then
7897: --
7903: --
7904: open c_bnft(l_epe_pen_rec.elig_per_elctbl_chc_id,l_bckdt_pen_rec.bnft_ordr_num );
7905: loop
7906: --
7907: hr_utility.set_location('Inside bnft loop ' || l_proc,40);
7908: --Bug 3315323 we need to reinstate the previuos benefit amount for the case
7909: --of SAAEAR also as enb record may have null value there for first enrollment
7910: --or it may not be the right amount.
7911: --
7940: l_bnft_rec.val := l_bckdt_pen_rec.BNFT_AMT;
7941: --
7942: end if;
7943: end if;
7944: hr_utility.set_location(l_proc,50);
7945: close c_bnft;
7946: --
7947: for l_count in 1..10 loop
7948: --
7960: for l_rec in c_rt(l_epe_pen_rec.elig_per_elctbl_chc_id,
7961: l_bnft_rec.enrt_bnft_id)
7962: loop
7963: --
7964: hr_utility.set_location('Inside rate loop ' ||l_proc,50);
7965: --
7966: -- Get the prtt rate val for this enrollment result.
7967: -- Use to pass to the enrollment process.
7968: --
7968: --
7969: -- Bug : 1634870 : If the user not selected the rate before backout
7970: -- then do not pass it to the reinstate process.
7971: --
7972: hr_utility.set_location('enrt_rt_id : dflt_val : val : entr_val' ||
7973: '_at_enrt_flag : acty_base_rt_id : ' , 501);
7974: hr_utility.set_location(l_rec.enrt_rt_id || ' : ' || l_rec.dflt_val || ' : ' || l_rec.val || ' : '
7975: || l_rec.entr_val_at_enrt_flag || ' : ' ||
7976: l_rec.acty_base_rt_id, 501);
7970: -- then do not pass it to the reinstate process.
7971: --
7972: hr_utility.set_location('enrt_rt_id : dflt_val : val : entr_val' ||
7973: '_at_enrt_flag : acty_base_rt_id : ' , 501);
7974: hr_utility.set_location(l_rec.enrt_rt_id || ' : ' || l_rec.dflt_val || ' : ' || l_rec.val || ' : '
7975: || l_rec.entr_val_at_enrt_flag || ' : ' ||
7976: l_rec.acty_base_rt_id, 501);
7977: --
7978: l_prv_rec := l_prv_rec_nulls;
7981: fetch c_prv into l_prv_rec;
7982: if c_prv%found then -- l_prv_rec.prtt_rt_val_id is not null then
7983: --
7984: l_count := l_count+1;
7985: hr_utility.set_location('prtt_rt_val_id : rt_val : ' ||
7986: l_prv_rec.prtt_rt_val_id || ' : ' || l_prv_rec.rt_val
7987: || ' : ' || l_prv_rec.acty_base_rt_id , 502);
7988: l_rt_table(l_count).enrt_rt_id := l_rec.enrt_rt_id;
7989: if l_prv_rec.mlt_cd in ('CL','CVG','AP','PRNT','CLANDCVG','APANDCVG','PRNTANDCVG') then
8035: l_enrt_cvg_strt_dt := l_bckdt_pen_rec.enrt_cvg_strt_dt ;
8036: end if ;
8037: -- 5746429 ends
8038: --
8039: hr_utility.set_location('Calling ben_election_information ' ||l_proc,60);
8040: hr_utility.set_location('Calling l_bnft_rec.val ' ||l_bnft_rec.val,60);
8041: hr_utility.set_location('Calling l_enrt_cvg_strt_dt ' ||l_enrt_cvg_strt_dt,60);
8042: --
8043: --
8036: end if ;
8037: -- 5746429 ends
8038: --
8039: hr_utility.set_location('Calling ben_election_information ' ||l_proc,60);
8040: hr_utility.set_location('Calling l_bnft_rec.val ' ||l_bnft_rec.val,60);
8041: hr_utility.set_location('Calling l_enrt_cvg_strt_dt ' ||l_enrt_cvg_strt_dt,60);
8042: --
8043: --
8044: ben_election_information.election_information
8037: -- 5746429 ends
8038: --
8039: hr_utility.set_location('Calling ben_election_information ' ||l_proc,60);
8040: hr_utility.set_location('Calling l_bnft_rec.val ' ||l_bnft_rec.val,60);
8041: hr_utility.set_location('Calling l_enrt_cvg_strt_dt ' ||l_enrt_cvg_strt_dt,60);
8042: --
8043: --
8044: ben_election_information.election_information
8045: (p_elig_per_elctbl_chc_id => l_epe_pen_rec.elig_per_elctbl_chc_id,
8343: end if;
8344: --
8345: if l_bckdt_pil_prev_stat_cd<>'STRTD' or
8346: l_found_non_automatics then
8347: hr_utility.set_location('Date for multi row edits = ' ||
8348: l_pgm_table(l_cnt).max_enrt_esd || ' ' || ' pgm = ' ||
8349: l_pgm_table(l_cnt).pgm_id, 333);
8350: ben_prtt_enrt_result_api.multi_rows_edit
8351: (p_person_id => p_person_id,
8366: p_pl_table := l_pl_table ;
8367: p_enrt_table := l_enrt_table ;
8368: p_max_enrt_esd := l_max_enrt_esd ;
8369: --
8370: hr_utility.set_location ('Leaving '||l_proc,10);
8371: --
8372: end reinstate_prev_enrt_for_popl ;
8373: --
8374: procedure reinstate_post_enrt(
8396:
8397: --
8398: begin
8399: --
8400: hr_utility.set_location ('Entering '||l_proc,10);
8401: --
8402: ben_prtt_enrt_result_api.multi_rows_edit
8403: (p_person_id => p_person_id,
8404: p_effective_date => p_max_enrt_esd,
8468: for l_cnt in 1..p_pl_table.LAST loop
8469: --
8470: -- Invoke post result process
8471: --
8472: hr_utility.set_location('Date = ' || p_pl_table(l_cnt).max_enrt_esd, 333);
8473: hr_utility.set_location('PL = ' || p_pl_table(l_cnt).pl_id, 333);
8474: --
8475: -- Bug 5623259.
8476: --
8469: --
8470: -- Invoke post result process
8471: --
8472: hr_utility.set_location('Date = ' || p_pl_table(l_cnt).max_enrt_esd, 333);
8473: hr_utility.set_location('PL = ' || p_pl_table(l_cnt).pl_id, 333);
8474: --
8475: -- Bug 5623259.
8476: --
8477: if p_pl_table(l_cnt).enrt_mthd_cd = 'E' then
8513: for l_cnt in 1..p_enrt_table.LAST loop
8514: --
8515: -- Reinstate the enrollment beneficiary rows.
8516: --
8517: hr_utility.set_location('Enrt Date = ' ||
8518: p_enrt_table(l_cnt).effective_start_date, 333);
8519: hr_utility.set_location('Reinstate the enrollment beneficiary rows',13);
8520: reinstate_pbn_per_pen(
8521: p_person_id => p_person_id
8515: -- Reinstate the enrollment beneficiary rows.
8516: --
8517: hr_utility.set_location('Enrt Date = ' ||
8518: p_enrt_table(l_cnt).effective_start_date, 333);
8519: hr_utility.set_location('Reinstate the enrollment beneficiary rows',13);
8520: reinstate_pbn_per_pen(
8521: p_person_id => p_person_id
8522: ,p_bckdt_prtt_enrt_rslt_id
8523: => p_enrt_table(l_cnt).bckdt_prtt_enrt_rslt_id
8769: l_rate_flex_ovrrd_exists varchar2(30):= 'N';
8770: --
8771: begin
8772: --
8773: hr_utility.set_location ('Entering '||l_proc,10);
8774: -- If any of the backed out enrt rslts were overriden, then update the new
8775: -- rslts with the overriden data.
8776: --
8777: if nvl(p_enrt_table.last, 0) > 0 then
8785: ,p_pl_id => p_enrt_table(i).old_pl_id
8786: ,p_oipl_id => p_enrt_table(i).old_oipl_id
8787: );
8788: --
8789: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,178);
8790: hr_utility.set_location('p_enrt_table(i).pgm_id '||p_enrt_table(i).pgm_id,178);
8791: hr_utility.set_location('p_enrt_table(i).new_pl_id '||p_enrt_table(i).new_pl_id,178);
8792: hr_utility.set_location('l_pgm_id '||l_pgm_id,178);
8793: hr_utility.set_location('l_pl_id '||l_pl_id,178);
8786: ,p_oipl_id => p_enrt_table(i).old_oipl_id
8787: );
8788: --
8789: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,178);
8790: hr_utility.set_location('p_enrt_table(i).pgm_id '||p_enrt_table(i).pgm_id,178);
8791: hr_utility.set_location('p_enrt_table(i).new_pl_id '||p_enrt_table(i).new_pl_id,178);
8792: hr_utility.set_location('l_pgm_id '||l_pgm_id,178);
8793: hr_utility.set_location('l_pl_id '||l_pl_id,178);
8794: --
8787: );
8788: --
8789: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,178);
8790: hr_utility.set_location('p_enrt_table(i).pgm_id '||p_enrt_table(i).pgm_id,178);
8791: hr_utility.set_location('p_enrt_table(i).new_pl_id '||p_enrt_table(i).new_pl_id,178);
8792: hr_utility.set_location('l_pgm_id '||l_pgm_id,178);
8793: hr_utility.set_location('l_pl_id '||l_pl_id,178);
8794: --
8795: if l_pgm_id <> nvl(p_enrt_table(i).pgm_id,l_pgm_id) or
8788: --
8789: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,178);
8790: hr_utility.set_location('p_enrt_table(i).pgm_id '||p_enrt_table(i).pgm_id,178);
8791: hr_utility.set_location('p_enrt_table(i).new_pl_id '||p_enrt_table(i).new_pl_id,178);
8792: hr_utility.set_location('l_pgm_id '||l_pgm_id,178);
8793: hr_utility.set_location('l_pl_id '||l_pl_id,178);
8794: --
8795: if l_pgm_id <> nvl(p_enrt_table(i).pgm_id,l_pgm_id) or
8796: l_pl_id <> nvl(p_enrt_table(i).new_pl_id,l_pl_id)
8789: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,178);
8790: hr_utility.set_location('p_enrt_table(i).pgm_id '||p_enrt_table(i).pgm_id,178);
8791: hr_utility.set_location('p_enrt_table(i).new_pl_id '||p_enrt_table(i).new_pl_id,178);
8792: hr_utility.set_location('l_pgm_id '||l_pgm_id,178);
8793: hr_utility.set_location('l_pl_id '||l_pl_id,178);
8794: --
8795: if l_pgm_id <> nvl(p_enrt_table(i).pgm_id,l_pgm_id) or
8796: l_pl_id <> nvl(p_enrt_table(i).new_pl_id,l_pl_id)
8797: then
8803: l_pl_id := l_pel.pl_id; -- p_enrt_table(i).new_pl_id ;
8804: l_reinstate_cd := l_pel.reinstate_cd;
8805: l_reinstate_ovrdn_cd := l_pel.reinstate_ovrdn_cd;
8806: --
8807: hr_utility.set_location('l_pgm_id '||l_pgm_id,168);
8808: hr_utility.set_location('l_pl_id '||l_pl_id,168);
8809: --
8810: close c_pel;
8811: --
8804: l_reinstate_cd := l_pel.reinstate_cd;
8805: l_reinstate_ovrdn_cd := l_pel.reinstate_ovrdn_cd;
8806: --
8807: hr_utility.set_location('l_pgm_id '||l_pgm_id,168);
8808: hr_utility.set_location('l_pl_id '||l_pl_id,168);
8809: --
8810: close c_pel;
8811: --
8812: end if;
8812: end if;
8813: --
8814: --Check if the program is a flex credits one.
8815: --
8816: --hr_utility.set_location('l_pl_id '||l_pl_id,199);
8817: --hr_utility.set_location('p_enrt_table(i).new_pl_id '||p_enrt_table(i).new_pl_id,199);
8818: --hr_utility.set_location('p_enrt_table(i).pgm_id '||p_enrt_table(i).pgm_id,199);
8819: --hr_utility.set_location('l_pgm_id '||l_pgm_id,199);
8820: --hr_utility.set_location('p_enrt_table(i).g_sys_date '||p_enrt_table(i).g_sys_date,199);
8813: --
8814: --Check if the program is a flex credits one.
8815: --
8816: --hr_utility.set_location('l_pl_id '||l_pl_id,199);
8817: --hr_utility.set_location('p_enrt_table(i).new_pl_id '||p_enrt_table(i).new_pl_id,199);
8818: --hr_utility.set_location('p_enrt_table(i).pgm_id '||p_enrt_table(i).pgm_id,199);
8819: --hr_utility.set_location('l_pgm_id '||l_pgm_id,199);
8820: --hr_utility.set_location('p_enrt_table(i).g_sys_date '||p_enrt_table(i).g_sys_date,199);
8821: --
8814: --Check if the program is a flex credits one.
8815: --
8816: --hr_utility.set_location('l_pl_id '||l_pl_id,199);
8817: --hr_utility.set_location('p_enrt_table(i).new_pl_id '||p_enrt_table(i).new_pl_id,199);
8818: --hr_utility.set_location('p_enrt_table(i).pgm_id '||p_enrt_table(i).pgm_id,199);
8819: --hr_utility.set_location('l_pgm_id '||l_pgm_id,199);
8820: --hr_utility.set_location('p_enrt_table(i).g_sys_date '||p_enrt_table(i).g_sys_date,199);
8821: --
8822: open c_flx_pgm(p_enrt_table(i).pgm_id,p_enrt_table(i).g_sys_date );
8815: --
8816: --hr_utility.set_location('l_pl_id '||l_pl_id,199);
8817: --hr_utility.set_location('p_enrt_table(i).new_pl_id '||p_enrt_table(i).new_pl_id,199);
8818: --hr_utility.set_location('p_enrt_table(i).pgm_id '||p_enrt_table(i).pgm_id,199);
8819: --hr_utility.set_location('l_pgm_id '||l_pgm_id,199);
8820: --hr_utility.set_location('p_enrt_table(i).g_sys_date '||p_enrt_table(i).g_sys_date,199);
8821: --
8822: open c_flx_pgm(p_enrt_table(i).pgm_id,p_enrt_table(i).g_sys_date );
8823: fetch c_flx_pgm into l_flex_program_flag ;
8816: --hr_utility.set_location('l_pl_id '||l_pl_id,199);
8817: --hr_utility.set_location('p_enrt_table(i).new_pl_id '||p_enrt_table(i).new_pl_id,199);
8818: --hr_utility.set_location('p_enrt_table(i).pgm_id '||p_enrt_table(i).pgm_id,199);
8819: --hr_utility.set_location('l_pgm_id '||l_pgm_id,199);
8820: --hr_utility.set_location('p_enrt_table(i).g_sys_date '||p_enrt_table(i).g_sys_date,199);
8821: --
8822: open c_flx_pgm(p_enrt_table(i).pgm_id,p_enrt_table(i).g_sys_date );
8823: fetch c_flx_pgm into l_flex_program_flag ;
8824: close c_flx_pgm ;
8832: end if;
8833: --
8834: if p_enrt_table(i).bckdt_enrt_ovridn_flag = 'Y' then
8835: --
8836: hr_utility.set_location('Restoring the overriden result: ' ||
8837: p_enrt_table(i).bckdt_prtt_enrt_rslt_id, 72);
8838: -- 9999Why we are not updating the override thru date and
8839: -- and all other information on pen record which can be overriden ?
8840: -- Get the latest object version number as the post enrollment process
8870: for l_rt_rec in c_ovridn_rt(p_enrt_table(i).bckdt_prtt_enrt_rslt_id
8871: ,p_enrt_table(i).prtt_enrt_rslt_id )
8872: loop
8873: --
8874: hr_utility.set_location('Updating new prv: ' || l_rt_rec.new_prv_id ||
8875: ' with overriden prv_id: ' || l_rt_rec.prtt_rt_val_id, 72);
8876: --
8877: if l_reinstate_cd = 'VALIDATE_RESULT' and
8878: l_reinstate_ovrdn_cd = 'OVERRIDE_IF_NO_CHANGE' then
8896: ,p_curr_epe_id => l_elig_per_elctbl_chc_id
8897: ,p_bckdt_epe_id => l_bckdt_epe_id
8898: );
8899: --
8900: hr_utility.set_location('l_epe_ecr_differ '||l_epe_ecr_differ,20);
8901: if l_epe_ecr_differ = 'Y' then
8902: l_override := 'N';
8903: end if;
8904: --
8924: ,p_curr_enb_id => l_enrt_bnft_id
8925: ,p_bckdt_enb_id => l_bckdt_enrt_bnft_id
8926: );
8927: --
8928: hr_utility.set_location('l_enb_ecr_differ '||l_enb_ecr_differ,20);
8929: --
8930: if l_enb_ecr_differ = 'Y' then
8931: l_override := 'N';
8932: end if;
8935: end if;
8936: --
8937: end if;
8938: --
8939: hr_utility.set_location(' l_override '||l_override,199);
8940: --
8941: if l_override = 'Y' then
8942: --
8943: l_rate_flex_ovrrd_exists := 'Y';
8959: --
8960: --Call Override Routines for flex credits
8961: --Bug 4384574 we need to handle the ledger entries also when the rates are
8962: --overriden
8963: hr_utility.set_location(' l_flex_program_flag '||l_flex_program_flag,199);
8964: hr_utility.set_location(' l_flex_prtt_enrt_rslt_id '||l_flex_prtt_enrt_rslt_id,199);
8965: --
8966: if l_flex_program_flag = 'Y' and l_flex_prtt_enrt_rslt_id is not null then
8967: --
8960: --Call Override Routines for flex credits
8961: --Bug 4384574 we need to handle the ledger entries also when the rates are
8962: --overriden
8963: hr_utility.set_location(' l_flex_program_flag '||l_flex_program_flag,199);
8964: hr_utility.set_location(' l_flex_prtt_enrt_rslt_id '||l_flex_prtt_enrt_rslt_id,199);
8965: --
8966: if l_flex_program_flag = 'Y' and l_flex_prtt_enrt_rslt_id is not null then
8967: --
8968: open c_abp(l_rt_rec.acty_base_rt_id,p_enrt_table(i).pgm_id,p_enrt_table(i).g_sys_date) ;
8966: if l_flex_program_flag = 'Y' and l_flex_prtt_enrt_rslt_id is not null then
8967: --
8968: open c_abp(l_rt_rec.acty_base_rt_id,p_enrt_table(i).pgm_id,p_enrt_table(i).g_sys_date) ;
8969: fetch c_abp into l_bnft_prvdr_pool_id ;
8970: hr_utility.set_location(' l_bnft_prvdr_pool_id '||l_bnft_prvdr_pool_id,199);
8971: --
8972: if c_abp%found then
8973: --
8974: ben_manage_override.override_debit_ledger_entry
9004: ,p_enrt_table(i).prtt_enrt_rslt_id
9005: ,p_enrt_table(i).g_sys_date)
9006: loop
9007: --
9008: hr_utility.set_location('Updating new ecd with overriden ecd_id: ' ||
9009: l_dpnt_rec.elig_cvrd_dpnt_id, 72);
9010: --
9011: ben_elig_cvrd_dpnt_api.update_elig_cvrd_dpnt
9012: (p_elig_cvrd_dpnt_id => l_dpnt_rec.new_pdp_id
9030: --
9031: if l_rate_flex_ovrrd_exists = 'Y' and nvl(p_pgm_table.LAST, 0) > 0 then
9032: for l_cnt in 1..p_pgm_table.LAST loop
9033: --
9034: hr_utility.set_location('p_pgm_table(l_cnt).pgm_id '||p_pgm_table(l_cnt).pgm_id,166);
9035: hr_utility.set_location('p_pgm_table(l_cnt).max_enrt_esd '||p_pgm_table(l_cnt).max_enrt_esd,166);
9036: --
9037: l_flex_prtt_enrt_rslt_id:= null;
9038: l_flex_elig_per_elctbl_chc_id:=null;
9031: if l_rate_flex_ovrrd_exists = 'Y' and nvl(p_pgm_table.LAST, 0) > 0 then
9032: for l_cnt in 1..p_pgm_table.LAST loop
9033: --
9034: hr_utility.set_location('p_pgm_table(l_cnt).pgm_id '||p_pgm_table(l_cnt).pgm_id,166);
9035: hr_utility.set_location('p_pgm_table(l_cnt).max_enrt_esd '||p_pgm_table(l_cnt).max_enrt_esd,166);
9036: --
9037: l_flex_prtt_enrt_rslt_id:= null;
9038: l_flex_elig_per_elctbl_chc_id:=null;
9039: l_flex_pgm_id:=null;
9104: end if;
9105: --
9106: end if;
9107: --
9108: hr_utility.set_location ('Leaving '||l_proc,10);
9109: --
9110: end reinstate_override;
9111: -- ----------------------------------------------------------------------------
9112: -- |------------------------< p_lf_evt_clps_restore_new >-------------------------|
9220: -- Bug 6328780
9221:
9222: begin
9223: --
9224: hr_utility.set_location ('Entering '||l_proc,10);
9225: --
9226: -- Remove it after complete test.
9227: --
9228: l_pgm_table.delete;
9235: fetch c_multiple_rate into l_dummy;
9236: if c_multiple_rate%found then
9237: close c_multiple_rate;
9238: -- Multiple rate is found and no reinstate
9239: hr_utility.set_location ('Multiple rate found and no reinstate done',11);
9240: return;
9241: end if;
9242: close c_multiple_rate;
9243: end if; --if l_status
9274: p_business_group_id => p_business_group_id,
9275: p_effective_date => p_effective_date
9276: );
9277: --
9278: hr_utility.set_location ('l_int_rslts_exist_flag '||l_int_rslts_exist_flag,15);
9279: --
9280: l_invalid_count := 0;
9281: l_invalid_pen_table.delete;
9282: l_invalid_epe_table.delete;
9286: l_valid_count := 0;
9287: l_valid_pen_table.delete;
9288: l_valid_epe_table.delete;
9289: --
9290: hr_utility.set_location ('r_pel.pgm_id :'||r_pel.pgm_id,20);
9291: hr_utility.set_location ('r_pel.pl_id :'||r_pel.pl_id,20);
9292: hr_utility.set_location ('r_pel.reinstate_cd :'||r_pel.reinstate_cd,20);
9293: --
9294: if l_int_rslts_exist_flag = 'Y' then
9287: l_valid_pen_table.delete;
9288: l_valid_epe_table.delete;
9289: --
9290: hr_utility.set_location ('r_pel.pgm_id :'||r_pel.pgm_id,20);
9291: hr_utility.set_location ('r_pel.pl_id :'||r_pel.pl_id,20);
9292: hr_utility.set_location ('r_pel.reinstate_cd :'||r_pel.reinstate_cd,20);
9293: --
9294: if l_int_rslts_exist_flag = 'Y' then
9295: if r_pel.reinstate_cd = 'DONOT_REINSTATE' then
9288: l_valid_epe_table.delete;
9289: --
9290: hr_utility.set_location ('r_pel.pgm_id :'||r_pel.pgm_id,20);
9291: hr_utility.set_location ('r_pel.pl_id :'||r_pel.pl_id,20);
9292: hr_utility.set_location ('r_pel.reinstate_cd :'||r_pel.reinstate_cd,20);
9293: --
9294: if l_int_rslts_exist_flag = 'Y' then
9295: if r_pel.reinstate_cd = 'DONOT_REINSTATE' then
9296: --
9293: --
9294: if l_int_rslts_exist_flag = 'Y' then
9295: if r_pel.reinstate_cd = 'DONOT_REINSTATE' then
9296: --
9297: hr_utility.set_location('reinstate_cd '||r_pel.reinstate_cd,30);
9298: hr_utility.set_location('Leaving:'|| l_proc, 30);
9299: exit ;
9300: --
9301: else
9294: if l_int_rslts_exist_flag = 'Y' then
9295: if r_pel.reinstate_cd = 'DONOT_REINSTATE' then
9296: --
9297: hr_utility.set_location('reinstate_cd '||r_pel.reinstate_cd,30);
9298: hr_utility.set_location('Leaving:'|| l_proc, 30);
9299: exit ;
9300: --
9301: else
9302: --Call the default process for the program or plan not in program
9299: exit ;
9300: --
9301: else
9302: --Call the default process for the program or plan not in program
9303: hr_utility.set_location ('Before call to default_comp_obj '||l_proc,40);
9304: --
9305: if fnd_global.conc_request_id in (0,-1) then
9306: --
9307: l_batch_flag := FALSE ;
9338: benutils.write(p_text => fnd_message.get);
9339: --
9340: end if;
9341: --
9342: hr_utility.set_location ('After call to default_comp_obj '||l_proc,40);
9343: --
9344: end if;
9345: else
9346: --Now see other reinstate codes and process accordingly.
9351: ,p_business_group_id => p_business_group_id
9352: ,p_effective_date => p_effective_date
9353: );
9354: --
9355: hr_utility.set_location('l_rslt_exist_flag '||l_rslt_exist_flag,140);
9356:
9357: hr_utility.set_location('reinstate_cd '||r_pel.reinstate_cd,50);
9358: --
9359: if r_pel.reinstate_cd = 'DONOT_REINSTATE' then
9353: );
9354: --
9355: hr_utility.set_location('l_rslt_exist_flag '||l_rslt_exist_flag,140);
9356:
9357: hr_utility.set_location('reinstate_cd '||r_pel.reinstate_cd,50);
9358: --
9359: if r_pel.reinstate_cd = 'DONOT_REINSTATE' then
9360: --
9361: hr_utility.set_location('Leaving:'|| l_proc, 60);
9357: hr_utility.set_location('reinstate_cd '||r_pel.reinstate_cd,50);
9358: --
9359: if r_pel.reinstate_cd = 'DONOT_REINSTATE' then
9360: --
9361: hr_utility.set_location('Leaving:'|| l_proc, 60);
9362: exit ;
9363: --
9364: elsif NVL(r_pel.reinstate_cd,'VALIDATE_ALL') = 'VALIDATE_ALL' then
9365: ---
9364: elsif NVL(r_pel.reinstate_cd,'VALIDATE_ALL') = 'VALIDATE_ALL' then
9365: ---
9366: --This needs to be changed to validate for each program or plan not in program
9367: --
9368: hr_utility.set_location('Before call to l_chages_ocrd_flag',70);
9369: --
9370: l_chages_ocrd_flag := comp_ori_new_pil_for_popl(
9371: p_person_id => p_person_id
9372: ,p_business_group_id => p_business_group_id
9377: ,p_pgm_id => r_pel.pgm_id
9378: ,p_pl_id => r_pel.pl_id
9379: );
9380: --
9381: hr_utility.set_location(' l_chages_ocrd_flag '||l_chages_ocrd_flag,80);
9382: --
9383: if l_chages_ocrd_flag = 'N' then
9384: --
9385: --Now Reinstate all the results
9383: if l_chages_ocrd_flag = 'N' then
9384: --
9385: --Now Reinstate all the results
9386: --
9387: hr_utility.set_location('Before call to get_backedout_results ',90);
9388: --
9389: get_backedout_results(
9390: p_person_id => p_person_id
9391: ,p_pgm_id => r_pel.pgm_id
9395: ,p_pilepe_inst_table => l_bckdt_pilepe_table
9396: ,p_bckdt_pen_table => l_bckdt_pen_table
9397: );
9398: --
9399: hr_utility.set_location('After call to get_backedout_results ',90);
9400: --
9401: l_bckdt_epe_count := l_bckdt_pilepe_table.COUNT;
9402: hr_utility.set_location(' l_bckdt_epe_count '||l_bckdt_epe_count,90);
9403: --
9398: --
9399: hr_utility.set_location('After call to get_backedout_results ',90);
9400: --
9401: l_bckdt_epe_count := l_bckdt_pilepe_table.COUNT;
9402: hr_utility.set_location(' l_bckdt_epe_count '||l_bckdt_epe_count,90);
9403: --
9404: for l_bckdt_epe in 1..l_bckdt_epe_count loop
9405: --
9406: --Get the current per_in_ler info
9406: --Get the current per_in_ler info
9407: --
9408: l_bckdt_pilepe_inst_row := l_bckdt_pilepe_table(l_bckdt_epe);
9409: --
9410: hr_utility.set_location('Calling ben_reinstate_epe_cache.get_pilcobjepe_dets',100);
9411: hr_utility.set_location('pgm '||l_bckdt_pen_table(l_bckdt_epe).pgm_id,100);
9412: hr_utility.set_location('pln '||l_bckdt_pen_table(l_bckdt_epe).pl_id,100);
9413: hr_utility.set_location('oipl '||l_bckdt_pen_table(l_bckdt_epe).oipl_id,100);
9414: --
9407: --
9408: l_bckdt_pilepe_inst_row := l_bckdt_pilepe_table(l_bckdt_epe);
9409: --
9410: hr_utility.set_location('Calling ben_reinstate_epe_cache.get_pilcobjepe_dets',100);
9411: hr_utility.set_location('pgm '||l_bckdt_pen_table(l_bckdt_epe).pgm_id,100);
9412: hr_utility.set_location('pln '||l_bckdt_pen_table(l_bckdt_epe).pl_id,100);
9413: hr_utility.set_location('oipl '||l_bckdt_pen_table(l_bckdt_epe).oipl_id,100);
9414: --
9415: ben_reinstate_epe_cache.get_pilcobjepe_dets(
9408: l_bckdt_pilepe_inst_row := l_bckdt_pilepe_table(l_bckdt_epe);
9409: --
9410: hr_utility.set_location('Calling ben_reinstate_epe_cache.get_pilcobjepe_dets',100);
9411: hr_utility.set_location('pgm '||l_bckdt_pen_table(l_bckdt_epe).pgm_id,100);
9412: hr_utility.set_location('pln '||l_bckdt_pen_table(l_bckdt_epe).pl_id,100);
9413: hr_utility.set_location('oipl '||l_bckdt_pen_table(l_bckdt_epe).oipl_id,100);
9414: --
9415: ben_reinstate_epe_cache.get_pilcobjepe_dets(
9416: p_per_in_ler_id => p_per_in_ler_id
9409: --
9410: hr_utility.set_location('Calling ben_reinstate_epe_cache.get_pilcobjepe_dets',100);
9411: hr_utility.set_location('pgm '||l_bckdt_pen_table(l_bckdt_epe).pgm_id,100);
9412: hr_utility.set_location('pln '||l_bckdt_pen_table(l_bckdt_epe).pl_id,100);
9413: hr_utility.set_location('oipl '||l_bckdt_pen_table(l_bckdt_epe).oipl_id,100);
9414: --
9415: ben_reinstate_epe_cache.get_pilcobjepe_dets(
9416: p_per_in_ler_id => p_per_in_ler_id
9417: ,p_pgm_id => l_bckdt_pen_table(l_bckdt_epe).pgm_id
9419: ,p_oipl_id => l_bckdt_pen_table(l_bckdt_epe).oipl_id
9420: ,p_inst_row => l_pilepe_inst_row
9421: );
9422: --
9423: hr_utility.set_location('from l_pilepe_inst_row EPE'||
9424: l_pilepe_inst_row.elig_per_elctbl_chc_id,110);
9425: --
9426: if l_pilepe_inst_row.elig_per_elctbl_chc_id is not null then
9427: --Lucky Guy found a choice ... You are going be reinstated.
9441: end if ;
9442: --
9443: end loop;
9444: --
9445: hr_utility.set_location('Valid results '||l_valid_count,120);
9446: hr_utility.set_location('Invalid results '||l_invalid_count,120);
9447: --
9448: --
9449: else
9442: --
9443: end loop;
9444: --
9445: hr_utility.set_location('Valid results '||l_valid_count,120);
9446: hr_utility.set_location('Invalid results '||l_invalid_count,120);
9447: --
9448: --
9449: else
9450: --
9447: --
9448: --
9449: else
9450: --
9451: hr_utility.set_location('Not Reinstating - changes occured ' ,125);
9452: l_not_reinstate := 2 ;
9453: --
9454: end if;
9455: --
9464: ,p_pilepe_inst_table => l_bckdt_pilepe_table
9465: ,p_bckdt_pen_table => l_bckdt_pen_table
9466: );
9467: --
9468: hr_utility.set_location('Got get_backedout_results '||l_bckdt_pilepe_table.COUNT ,130);
9469: --
9470: l_bckdt_epe_count := l_bckdt_pilepe_table.COUNT;
9471: --
9472: if r_pel.reinstate_cd = 'VALIDATE_RESULT_ALL' then
9472: if r_pel.reinstate_cd = 'VALIDATE_RESULT_ALL' then
9473: --In this routine compare all old and new Choice data and if it matches then reinstate else no
9474: --return
9475: --
9476: hr_utility.set_location('Entering VALIDATE_RESULT_ALL',140);
9477: --
9478: for l_bckdt_epe in 1..l_bckdt_epe_count loop
9479: --Get the current per_in_ler info
9480: --
9479: --Get the current per_in_ler info
9480: --
9481: l_bckdt_pilepe_inst_row := l_bckdt_pilepe_table(l_bckdt_epe);
9482: --
9483: hr_utility.set_location(' Calling ben_reinstate_epe_cache.get_pilcobjepe_dets '||l_bckdt_pen_table(l_bckdt_epe).pgm_id
9484: ||' PLN '||l_bckdt_pen_table(l_bckdt_epe).pl_id||' OIPL '
9485: ||l_bckdt_pen_table(l_bckdt_epe).oipl_id,145);
9486: ben_reinstate_epe_cache.get_pilcobjepe_dets(
9487: p_per_in_ler_id => p_per_in_ler_id
9505: ,p_business_group_id => p_business_group_id
9506: ,p_effective_date => p_effective_date
9507: );
9508: --
9509: hr_utility.set_location(' l_pilepe_inst_row.elig_per_elctbl_chc_id '||l_pilepe_inst_row.elig_per_elctbl_chc_id,150);
9510: hr_utility.set_location(' l_chages_ocrd_flag '||l_chages_ocrd_flag,150);
9511: --
9512: if l_chages_ocrd_flag = 'N' then
9513: --Lucky Guy No Changes... You are going be reinstated.
9506: ,p_effective_date => p_effective_date
9507: );
9508: --
9509: hr_utility.set_location(' l_pilepe_inst_row.elig_per_elctbl_chc_id '||l_pilepe_inst_row.elig_per_elctbl_chc_id,150);
9510: hr_utility.set_location(' l_chages_ocrd_flag '||l_chages_ocrd_flag,150);
9511: --
9512: if l_chages_ocrd_flag = 'N' then
9513: --Lucky Guy No Changes... You are going be reinstated.
9514: --
9530: l_invalid_count := l_invalid_count + 1 ;
9531: l_invalid_epe_table(l_invalid_count) := l_pilepe_inst_row ;
9532: l_invalid_pen_table(l_invalid_count) := l_bckdt_pen_table(l_bckdt_epe);
9533: --
9534: hr_utility.set_location('NO EPE '||l_bckdt_pilepe_inst_row.elig_per_elctbl_chc_id,160);
9535: --
9536: end if;
9537: --
9538: end loop;
9536: end if;
9537: --
9538: end loop;
9539: --
9540: hr_utility.set_location(' l_invalid_count '||l_invalid_count,160);
9541: hr_utility.set_location(' l_valid_count '||l_valid_count,160);
9542: --
9543: elsif r_pel.reinstate_cd = 'VALIDATE_RESULT' then
9544: --If you get a hit for EPE ENB ECR in the NEW PIL then enroll in the new EPE ENB ECR
9537: --
9538: end loop;
9539: --
9540: hr_utility.set_location(' l_invalid_count '||l_invalid_count,160);
9541: hr_utility.set_location(' l_valid_count '||l_valid_count,160);
9542: --
9543: elsif r_pel.reinstate_cd = 'VALIDATE_RESULT' then
9544: --If you get a hit for EPE ENB ECR in the NEW PIL then enroll in the new EPE ENB ECR
9545: --
9542: --
9543: elsif r_pel.reinstate_cd = 'VALIDATE_RESULT' then
9544: --If you get a hit for EPE ENB ECR in the NEW PIL then enroll in the new EPE ENB ECR
9545: --
9546: hr_utility.set_location('Entering VALIDATE_RESULT',170);
9547: --
9548: for l_bckdt_epe in 1..l_bckdt_epe_count loop
9549: --Get the current per_in_ler info
9550: --
9549: --Get the current per_in_ler info
9550: --
9551: l_bckdt_pilepe_inst_row := l_bckdt_pilepe_table(l_bckdt_epe);
9552: --
9553: hr_utility.set_location(' Calling ben_reinstate_epe_cache.get_pilcobjepe_dets '||l_bckdt_pen_table(l_bckdt_epe).pgm_id
9554: ||' PLN '||l_bckdt_pen_table(l_bckdt_epe).pl_id||' OIPL '
9555: ||l_bckdt_pen_table(l_bckdt_epe).oipl_id,175);
9556: --
9557: ben_reinstate_epe_cache.get_pilcobjepe_dets(
9577: l_invalid_count := l_invalid_count + 1 ;
9578: l_invalid_epe_table(l_invalid_count) := l_pilepe_inst_row ;
9579: l_invalid_pen_table(l_invalid_count) := l_bckdt_pen_table(l_bckdt_epe);
9580: --
9581: hr_utility.set_location('NO EPE '||l_bckdt_pilepe_inst_row.elig_per_elctbl_chc_id,250);
9582: --
9583: end if ;
9584: --
9585: end loop;
9582: --
9583: end if ;
9584: --
9585: end loop;
9586: hr_utility.set_location(' l_invalid_count '||l_invalid_count,260);
9587: hr_utility.set_location(' l_valid_count '||l_valid_count,260);
9588: --
9589: end if;
9590: --
9583: end if ;
9584: --
9585: end loop;
9586: hr_utility.set_location(' l_invalid_count '||l_invalid_count,260);
9587: hr_utility.set_location(' l_valid_count '||l_valid_count,260);
9588: --
9589: end if;
9590: --
9591: end if; -- Else for VALIDATE_ALL
9596: loop
9597: fetch c_en_dtd_pen_bckdt_pil into l_en_dtd_pen_bckdt_pil;
9598: exit when c_en_dtd_pen_bckdt_pil%NOTFOUND;
9599: --
9600: hr_utility.set_location('PEN'||l_en_dtd_pen_bckdt_pil.bkup_tbl_id,234234);
9601: --
9602: ben_prtt_enrt_result_api.delete_enrollment(
9603: p_validate => false,
9604: p_per_in_ler_id => p_per_in_ler_id,
9615: --
9616: close c_en_dtd_pen_bckdt_pil;
9617: --
9618: if l_valid_pen_table.COUNT > 0 and l_valid_epe_table.COUNT > 0 then
9619: hr_utility.set_location('Calling reinstate_prev_enrt_for_popl '
9620: ||r_pel.pgm_id||' PLN '||r_pel.pl_id,300);
9621: --
9622: reinstate_prev_enrt_for_popl(
9623: p_bckdt_pen_table => l_valid_pen_table
9635: ,p_enrt_perd_strt_dt => r_pel.enrt_perd_strt_dt
9636: ,p_max_enrt_esd => l_max_enrt_esd_out
9637: );
9638: --
9639: hr_utility.set_location('Done reinstate_prev_enrt_for_popl',310);
9640: --
9641: else
9642: --
9643: hr_utility.set_location('Not Calling reinstate_prev_enrt_for_popl ',310);
9639: hr_utility.set_location('Done reinstate_prev_enrt_for_popl',310);
9640: --
9641: else
9642: --
9643: hr_utility.set_location('Not Calling reinstate_prev_enrt_for_popl ',310);
9644: --
9645: end if;
9646: --
9647: if l_max_enrt_esd_out >= nvl(l_max_enrt_esd,l_max_enrt_esd_out) then
9663: open c_bckdt_pil ;
9664: fetch c_bckdt_pil into l_bckdt_pil ;
9665: close c_bckdt_pil ;
9666: --
9667: hr_utility.set_location('Calling reinstate_post_enrt ',400);
9668: reinstate_post_enrt(
9669: p_pgm_table => l_pgm_table
9670: ,p_pl_table => l_pl_table
9671: ,p_enrt_table => l_enrt_table
9677: ,p_bckdt_per_in_ler_id => p_bckdt_per_in_ler_id
9678: ,p_cls_enrt_flag => false --999
9679: );
9680: --
9681: hr_utility.set_location('Done reinstate_post_enrt ',410);
9682: --
9683: -- This needs to be handled for new codes
9684: --
9685: hr_utility.set_location('Calling reinstate_override ',500);
9681: hr_utility.set_location('Done reinstate_post_enrt ',410);
9682: --
9683: -- This needs to be handled for new codes
9684: --
9685: hr_utility.set_location('Calling reinstate_override ',500);
9686: --
9687: reinstate_override(
9688: p_pgm_table => l_pgm_table
9689: ,p_pl_table => l_pl_table
9696: ,p_bckdt_per_in_ler_id => p_bckdt_per_in_ler_id
9697: ,p_cls_enrt_flag => false --999
9698: );
9699: --
9700: hr_utility.set_location('Done reinstate_override ',510);
9701: --
9702: --
9703: --Now Determine the logic for close enrollment process.
9704: --to call close enrollment all of the following conditions must satisfy
9706: --all the enrollments should be reinstated
9707: --
9708: if l_bckdt_pil.prvs_stat_cd = 'PROCD' and nvl(l_invalid_pen_table.COUNT,0) = 0 then
9709: --
9710: hr_utility.set_location('Calling close_single_enrollment ',600);
9711: --
9712: ben_close_enrollment.close_single_enrollment
9713: (p_per_in_ler_id => p_per_in_ler_id
9714: ,p_effective_date => nvl(l_max_enrt_esd,p_effective_date)
9717: ,p_validate => FALSE
9718: ,p_close_uneai_flag => NULL
9719: ,p_uneai_effective_date => NULL);
9720: --
9721: hr_utility.set_location('Done close_single_enrollment ',610);
9722: --
9723: end if;
9724: --
9725: --
9723: end if;
9724: --
9725: --
9726: /*
9727: hr_utility.set_location('Calling Void update_person_life_event' ,700);
9728: --
9729: ben_Person_Life_Event_api.update_person_life_event
9730: (p_per_in_ler_id => p_bckdt_per_in_ler_id
9731: ,p_per_in_ler_stat_cd => 'VOIDD'
9735: ,P_STRTD_DT => l_strtd_dt
9736: ,P_VOIDD_DT => l_voidd_dt );
9737: */
9738: --
9739: hr_utility.set_location('Done update_person_life_event',710);
9740: --
9741: if l_invalid_pen_table.COUNT > 0 then
9742: --
9743: if fnd_global.conc_request_id in (0,-1) then
9771: end if;
9772:
9773: -- Void the communications created to new per_in ler.
9774: --
9775: hr_utility.set_location('Calling void_literature ',800);
9776: --
9777: void_literature(p_person_id => p_person_id
9778: ,p_business_group_id => p_business_group_id
9779: ,p_effective_date => nvl(l_max_enrt_esd,p_effective_date)
9780: ,p_ler_id => null
9781: ,p_per_in_ler_id => p_per_in_ler_id
9782: );
9783: --
9784: hr_utility.set_location('Done void_literature ',810);
9785: --
9786: end if;
9787: --
9788: --
9785: --
9786: end if;
9787: --
9788: --
9789: hr_utility.set_location('Calling Void update_person_life_event' ,700);
9790: --
9791: open c_bckdt_pil ;
9792: fetch c_bckdt_pil into l_bckdt_pil ;
9793: close c_bckdt_pil ;
9803: --
9804: if l_int_rslts_exist_flag = 'N' and
9805: ( l_enrt_table.COUNT = 0 or l_not_reinstate = 2 ) then
9806: --
9807: hr_utility.set_location(' Inside l_int_rslts_exist_flag pad_cmnt_to_rsnd_lit '||l_not_reinstate,820);
9808: hr_utility.set_location(' l_invalid_count '||l_invalid_count,820);
9809: hr_utility.set_location(' l_int_rslts_exist_flag '||l_int_rslts_exist_flag,820);
9810: --
9811: if l_rslt_exist_flag = 'Y' then
9804: if l_int_rslts_exist_flag = 'N' and
9805: ( l_enrt_table.COUNT = 0 or l_not_reinstate = 2 ) then
9806: --
9807: hr_utility.set_location(' Inside l_int_rslts_exist_flag pad_cmnt_to_rsnd_lit '||l_not_reinstate,820);
9808: hr_utility.set_location(' l_invalid_count '||l_invalid_count,820);
9809: hr_utility.set_location(' l_int_rslts_exist_flag '||l_int_rslts_exist_flag,820);
9810: --
9811: if l_rslt_exist_flag = 'Y' then
9812: -- Add comments to new literature sent out
9805: ( l_enrt_table.COUNT = 0 or l_not_reinstate = 2 ) then
9806: --
9807: hr_utility.set_location(' Inside l_int_rslts_exist_flag pad_cmnt_to_rsnd_lit '||l_not_reinstate,820);
9808: hr_utility.set_location(' l_invalid_count '||l_invalid_count,820);
9809: hr_utility.set_location(' l_int_rslts_exist_flag '||l_int_rslts_exist_flag,820);
9810: --
9811: if l_rslt_exist_flag = 'Y' then
9812: -- Add comments to new literature sent out
9813: -- Comment Ex: Because you have experienced another enrollment, your
9849: --
9850: --we need to log the enrollments which were not being reinstated into the log file here
9851: --from l_invalid_pen_table table
9852: --
9853: hr_utility.set_location('Done calls to pad_cmnt_to_rsnd_lit ',850);
9854: --
9855: end if;
9856: --
9857: hr_utility.set_location('Completed all PEL records',90);
9853: hr_utility.set_location('Done calls to pad_cmnt_to_rsnd_lit ',850);
9854: --
9855: end if;
9856: --
9857: hr_utility.set_location('Completed all PEL records',90);
9858: --
9859: hr_utility.set_location('Leaving:'|| l_proc, 10);
9860: --
9861: end p_lf_evt_clps_restore;
9855: end if;
9856: --
9857: hr_utility.set_location('Completed all PEL records',90);
9858: --
9859: hr_utility.set_location('Leaving:'|| l_proc, 10);
9860: --
9861: end p_lf_evt_clps_restore;
9862: -- ----------------------------------------------------------------------------
9863: -- |------------------------< update_ptnl_per_for_ler >-------------------------|
9886: l_voidd_dt date;
9887: --
9888: begin
9889: --
9890: hr_utility.set_location('Entering:'|| l_proc, 10);
9891: --
9892: if p_ptnl_ler_for_per_stat_cd = 'MNL' then
9893: --
9894: l_mnl_dt := p_effective_date;
9898: open c_ptnl;
9899: fetch c_ptnl into l_ptnl_rec;
9900: if c_ptnl%found then
9901: --
9902: hr_utility.set_location('Voiding '||p_ptnl_ler_for_per_id,10);
9903: --
9904: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
9905: (p_validate => false
9906: ,p_ptnl_ler_for_per_id => l_ptnl_rec.ptnl_ler_for_per_id
9916: --
9917: end if;
9918: close c_ptnl;
9919: --
9920: hr_utility.set_location('Leaving:'|| l_proc, 10);
9921: --
9922: end update_ptnl_per_for_ler;
9923: --
9924: procedure p_reinstate_info_to_form (
10364: l_enrt_cvg_strt_dt date;
10365: --
10366: begin
10367: --
10368: hr_utility.set_location('Entering ' || l_proc,10);
10369: --
10370: open c_bckdt_pil;
10371: fetch c_bckdt_pil into l_bckdt_pil_prev_stat_cd, l_bckdt_pil_ovn, l_bckdt_lf_evt_ocrd_dt ;
10372: close c_bckdt_pil;
10371: fetch c_bckdt_pil into l_bckdt_pil_prev_stat_cd, l_bckdt_pil_ovn, l_bckdt_lf_evt_ocrd_dt ;
10372: close c_bckdt_pil;
10373: l_bckt_csd_per_in_ler_id := p_bckdt_per_in_ler_id ;
10374:
10375: hr_utility.set_location( ' p_bckdt_per_in_ler_id'||p_bckdt_per_in_ler_id,99) ;
10376: hr_utility.set_location( ' l_bckt_csd_per_in_ler_id ' || l_bckt_csd_per_in_ler_id, 99 );
10377:
10378: ben_close_enrollment.reopen_single_life_event
10379: (p_per_in_ler_id => p_bckdt_per_in_ler_id
10372: close c_bckdt_pil;
10373: l_bckt_csd_per_in_ler_id := p_bckdt_per_in_ler_id ;
10374:
10375: hr_utility.set_location( ' p_bckdt_per_in_ler_id'||p_bckdt_per_in_ler_id,99) ;
10376: hr_utility.set_location( ' l_bckt_csd_per_in_ler_id ' || l_bckt_csd_per_in_ler_id, 99 );
10377:
10378: ben_close_enrollment.reopen_single_life_event
10379: (p_per_in_ler_id => p_bckdt_per_in_ler_id
10380: ,p_person_id => p_person_id
10415: --
10416: -- If the enrollment record is valid for the current
10417: -- effective_date then recreate the enrollment.
10418: --
10419: hr_utility.set_location('Inside BCKDT pen loop ' || l_proc,20);
10420: --
10421: -- 9999 modify the if clause to look at effective_end_date
10422: -- Why this condition? Is it to look at only the enrollments
10423: -- which are valid as of benmngle run date? If so then should it
10458: l_bckdt_pen_rec.effective_start_date);
10459: --
10460: l_max_enrt_esd := greatest(g_sys_date, nvl(l_max_enrt_esd, hr_api.g_sot));
10461: --
10462: hr_utility.set_location('Date used to reinstate the enrollment = ' || g_sys_date, 333);
10463: if g_sys_date <= l_bckdt_pen_rec.effective_end_date
10464: then
10465: --
10466: -- Get the electable choice data to create enrollment row.
10464: then
10465: --
10466: -- Get the electable choice data to create enrollment row.
10467: --
10468: hr_utility.set_location('epe fetch pl ' || l_bckdt_pen_rec.pl_id,30);
10469: hr_utility.set_location('epe fetch pgm ' || l_bckdt_pen_rec.pgm_id,30);
10470: hr_utility.set_location('epe fetch oipl ' || l_bckdt_pen_rec.oipl_id,30);
10471: hr_utility.set_location('epe fetch pil ' || l_bckt_csd_per_in_ler_id,30);
10472: open c_epe_pen(l_bckdt_pen_rec.pl_id,
10465: --
10466: -- Get the electable choice data to create enrollment row.
10467: --
10468: hr_utility.set_location('epe fetch pl ' || l_bckdt_pen_rec.pl_id,30);
10469: hr_utility.set_location('epe fetch pgm ' || l_bckdt_pen_rec.pgm_id,30);
10470: hr_utility.set_location('epe fetch oipl ' || l_bckdt_pen_rec.oipl_id,30);
10471: hr_utility.set_location('epe fetch pil ' || l_bckt_csd_per_in_ler_id,30);
10472: open c_epe_pen(l_bckdt_pen_rec.pl_id,
10473: l_bckdt_pen_rec.pgm_id,
10466: -- Get the electable choice data to create enrollment row.
10467: --
10468: hr_utility.set_location('epe fetch pl ' || l_bckdt_pen_rec.pl_id,30);
10469: hr_utility.set_location('epe fetch pgm ' || l_bckdt_pen_rec.pgm_id,30);
10470: hr_utility.set_location('epe fetch oipl ' || l_bckdt_pen_rec.oipl_id,30);
10471: hr_utility.set_location('epe fetch pil ' || l_bckt_csd_per_in_ler_id,30);
10472: open c_epe_pen(l_bckdt_pen_rec.pl_id,
10473: l_bckdt_pen_rec.pgm_id,
10474: l_bckdt_pen_rec.oipl_id,
10467: --
10468: hr_utility.set_location('epe fetch pl ' || l_bckdt_pen_rec.pl_id,30);
10469: hr_utility.set_location('epe fetch pgm ' || l_bckdt_pen_rec.pgm_id,30);
10470: hr_utility.set_location('epe fetch oipl ' || l_bckdt_pen_rec.oipl_id,30);
10471: hr_utility.set_location('epe fetch pil ' || l_bckt_csd_per_in_ler_id,30);
10472: open c_epe_pen(l_bckdt_pen_rec.pl_id,
10473: l_bckdt_pen_rec.pgm_id,
10474: l_bckdt_pen_rec.oipl_id,
10475: l_bckt_csd_per_in_ler_id);
10474: l_bckdt_pen_rec.oipl_id,
10475: l_bckt_csd_per_in_ler_id);
10476: fetch c_epe_pen into l_epe_pen_rec;
10477: close c_epe_pen;
10478: hr_utility.set_location('After epe fetch ' || l_proc,30);
10479: hr_utility.set_location('After epe epe ' || l_epe_pen_rec.elig_per_elctbl_chc_id,30);
10480: --
10481: --
10482: l_num_bnft_recs := 0;
10475: l_bckt_csd_per_in_ler_id);
10476: fetch c_epe_pen into l_epe_pen_rec;
10477: close c_epe_pen;
10478: hr_utility.set_location('After epe fetch ' || l_proc,30);
10479: hr_utility.set_location('After epe epe ' || l_epe_pen_rec.elig_per_elctbl_chc_id,30);
10480: --
10481: --
10482: l_num_bnft_recs := 0;
10483: l_bnft_entr_val_found := FALSE;
10485: --
10486: open c_bnft(l_epe_pen_rec.elig_per_elctbl_chc_id,l_bckdt_pen_rec.bnft_ordr_num );
10487: loop
10488: --
10489: hr_utility.set_location('Inside bnft loop ' || l_proc,40);
10490: -- BUG 3315323
10491: --
10492: fetch c_bnft into l_bnft_rec;
10493: exit when c_bnft%notfound;
10520: l_bnft_rec.val := l_bckdt_pen_rec.BNFT_AMT;
10521: --
10522: end if;
10523: end if;
10524: hr_utility.set_location(l_proc,50);
10525: close c_bnft;
10526: --
10527: for l_count in 1..10 loop
10528: --
10540: for l_rec in c_rt(l_epe_pen_rec.elig_per_elctbl_chc_id,
10541: l_bnft_rec.enrt_bnft_id)
10542: loop
10543: --
10544: hr_utility.set_location('Inside rate loop ' ||l_proc,50);
10545: --
10546: -- Get the prtt rate val for this enrollment result.
10547: -- Use to pass to the enrollment process.
10548: --
10548: --
10549: -- Bug : 1634870 : If the user not selected the rate before backout
10550: -- then do not pass it to the reinstate process.
10551: --
10552: hr_utility.set_location('enrt_rt_id : dflt_val : val : entr_val' ||
10553: '_at_enrt_flag : acty_base_rt_id : ' , 501);
10554: hr_utility.set_location(l_rec.enrt_rt_id || ' : ' || l_rec.dflt_val || ' : ' || l_rec.val || '
10555: : '
10556: || l_rec.entr_val_at_enrt_flag || ' : ' ||
10550: -- then do not pass it to the reinstate process.
10551: --
10552: hr_utility.set_location('enrt_rt_id : dflt_val : val : entr_val' ||
10553: '_at_enrt_flag : acty_base_rt_id : ' , 501);
10554: hr_utility.set_location(l_rec.enrt_rt_id || ' : ' || l_rec.dflt_val || ' : ' || l_rec.val || '
10555: : '
10556: || l_rec.entr_val_at_enrt_flag || ' : ' ||
10557: l_rec.acty_base_rt_id, 501);
10558: --
10562: fetch c_prv into l_prv_rec;
10563: if c_prv%found then -- l_prv_rec.prtt_rt_val_id is not null then
10564: --
10565: l_count := l_count+1;
10566: hr_utility.set_location('prtt_rt_val_id : rt_val : ' ||
10567: l_prv_rec.prtt_rt_val_id || ' : ' || l_prv_rec.rt_val
10568: || ' : ' || l_prv_rec.acty_base_rt_id , 502);
10569: l_rt_table(l_count).enrt_rt_id := l_rec.enrt_rt_id;
10570: if l_prv_rec.mlt_cd in ('CL','CVG','AP','PRNT','CLANDCVG','APANDCVG','PRNTANDCVG') then
10618: l_enrt_cvg_strt_dt := l_bckdt_pen_rec.enrt_cvg_strt_dt ;
10619: end if ;
10620: -- 5746429 ends
10621:
10622: hr_utility.set_location('Calling ben_election_information ' ||l_proc,60);
10623: hr_utility.set_location('Calling l_bnft_rec.val ' ||l_bnft_rec.val,60);
10624: hr_utility.set_location('Calling l_epe_pen_rec.prtt_enrt_rslt_id ' ||l_epe_pen_rec.prtt_enrt_rslt_id,60);
10625: hr_utility.set_location('Calling l_bnft_rec.prtt_enrt_rslt_id ' ||l_bnft_rec.prtt_enrt_rslt_id,60);
10626: hr_utility.set_location('Calling l_enrt_cvg_strt_dt ' ||l_enrt_cvg_strt_dt,60);
10619: end if ;
10620: -- 5746429 ends
10621:
10622: hr_utility.set_location('Calling ben_election_information ' ||l_proc,60);
10623: hr_utility.set_location('Calling l_bnft_rec.val ' ||l_bnft_rec.val,60);
10624: hr_utility.set_location('Calling l_epe_pen_rec.prtt_enrt_rslt_id ' ||l_epe_pen_rec.prtt_enrt_rslt_id,60);
10625: hr_utility.set_location('Calling l_bnft_rec.prtt_enrt_rslt_id ' ||l_bnft_rec.prtt_enrt_rslt_id,60);
10626: hr_utility.set_location('Calling l_enrt_cvg_strt_dt ' ||l_enrt_cvg_strt_dt,60);
10627:
10620: -- 5746429 ends
10621:
10622: hr_utility.set_location('Calling ben_election_information ' ||l_proc,60);
10623: hr_utility.set_location('Calling l_bnft_rec.val ' ||l_bnft_rec.val,60);
10624: hr_utility.set_location('Calling l_epe_pen_rec.prtt_enrt_rslt_id ' ||l_epe_pen_rec.prtt_enrt_rslt_id,60);
10625: hr_utility.set_location('Calling l_bnft_rec.prtt_enrt_rslt_id ' ||l_bnft_rec.prtt_enrt_rslt_id,60);
10626: hr_utility.set_location('Calling l_enrt_cvg_strt_dt ' ||l_enrt_cvg_strt_dt,60);
10627:
10628: -- since it is the result level backout the result id are nullified so
10621:
10622: hr_utility.set_location('Calling ben_election_information ' ||l_proc,60);
10623: hr_utility.set_location('Calling l_bnft_rec.val ' ||l_bnft_rec.val,60);
10624: hr_utility.set_location('Calling l_epe_pen_rec.prtt_enrt_rslt_id ' ||l_epe_pen_rec.prtt_enrt_rslt_id,60);
10625: hr_utility.set_location('Calling l_bnft_rec.prtt_enrt_rslt_id ' ||l_bnft_rec.prtt_enrt_rslt_id,60);
10626: hr_utility.set_location('Calling l_enrt_cvg_strt_dt ' ||l_enrt_cvg_strt_dt,60);
10627:
10628: -- since it is the result level backout the result id are nullified so
10629: -- Election information wont look for the result id to get the old result information
10622: hr_utility.set_location('Calling ben_election_information ' ||l_proc,60);
10623: hr_utility.set_location('Calling l_bnft_rec.val ' ||l_bnft_rec.val,60);
10624: hr_utility.set_location('Calling l_epe_pen_rec.prtt_enrt_rslt_id ' ||l_epe_pen_rec.prtt_enrt_rslt_id,60);
10625: hr_utility.set_location('Calling l_bnft_rec.prtt_enrt_rslt_id ' ||l_bnft_rec.prtt_enrt_rslt_id,60);
10626: hr_utility.set_location('Calling l_enrt_cvg_strt_dt ' ||l_enrt_cvg_strt_dt,60);
10627:
10628: -- since it is the result level backout the result id are nullified so
10629: -- Election information wont look for the result id to get the old result information
10630:
10841: := l_epe_pen_rec.dpnt_cvg_strt_dt_cd;
10842: l_enrt_table(l_enrt_count).dpnt_cvg_strt_dt_rl
10843: := l_epe_pen_rec.dpnt_cvg_strt_dt_rl;
10844: /* Trace messages for the enrollments, uncomment for tracing bugs */
10845: hr_utility.set_location('prtt_enrt_rslt_id = ' ||
10846: l_enrt_table(l_enrt_count).prtt_enrt_rslt_id, 9999);
10847: hr_utility.set_location('bckdt_prtt_enrt_rslt_id = ' ||
10848: l_enrt_table(l_enrt_count).bckdt_prtt_enrt_rslt_id, 9999);
10849: hr_utility.set_location('bckdt_enrt_ovridn_flag = ' ||
10843: := l_epe_pen_rec.dpnt_cvg_strt_dt_rl;
10844: /* Trace messages for the enrollments, uncomment for tracing bugs */
10845: hr_utility.set_location('prtt_enrt_rslt_id = ' ||
10846: l_enrt_table(l_enrt_count).prtt_enrt_rslt_id, 9999);
10847: hr_utility.set_location('bckdt_prtt_enrt_rslt_id = ' ||
10848: l_enrt_table(l_enrt_count).bckdt_prtt_enrt_rslt_id, 9999);
10849: hr_utility.set_location('bckdt_enrt_ovridn_flag = ' ||
10850: l_enrt_table(l_enrt_count).bckdt_enrt_ovridn_flag, 72);
10851: hr_utility.set_location('bckdt_enrt_cvg_strt_dt = ' ||
10845: hr_utility.set_location('prtt_enrt_rslt_id = ' ||
10846: l_enrt_table(l_enrt_count).prtt_enrt_rslt_id, 9999);
10847: hr_utility.set_location('bckdt_prtt_enrt_rslt_id = ' ||
10848: l_enrt_table(l_enrt_count).bckdt_prtt_enrt_rslt_id, 9999);
10849: hr_utility.set_location('bckdt_enrt_ovridn_flag = ' ||
10850: l_enrt_table(l_enrt_count).bckdt_enrt_ovridn_flag, 72);
10851: hr_utility.set_location('bckdt_enrt_cvg_strt_dt = ' ||
10852: l_enrt_table(l_enrt_count).bckdt_enrt_cvg_strt_dt, 72);
10853: hr_utility.set_location('pen_ovn_number = ' ||
10847: hr_utility.set_location('bckdt_prtt_enrt_rslt_id = ' ||
10848: l_enrt_table(l_enrt_count).bckdt_prtt_enrt_rslt_id, 9999);
10849: hr_utility.set_location('bckdt_enrt_ovridn_flag = ' ||
10850: l_enrt_table(l_enrt_count).bckdt_enrt_ovridn_flag, 72);
10851: hr_utility.set_location('bckdt_enrt_cvg_strt_dt = ' ||
10852: l_enrt_table(l_enrt_count).bckdt_enrt_cvg_strt_dt, 72);
10853: hr_utility.set_location('pen_ovn_number = ' ||
10854: l_enrt_table(l_enrt_count).pen_ovn_number, 9999);
10855: hr_utility.set_location('old_pl_id = ' ||
10849: hr_utility.set_location('bckdt_enrt_ovridn_flag = ' ||
10850: l_enrt_table(l_enrt_count).bckdt_enrt_ovridn_flag, 72);
10851: hr_utility.set_location('bckdt_enrt_cvg_strt_dt = ' ||
10852: l_enrt_table(l_enrt_count).bckdt_enrt_cvg_strt_dt, 72);
10853: hr_utility.set_location('pen_ovn_number = ' ||
10854: l_enrt_table(l_enrt_count).pen_ovn_number, 9999);
10855: hr_utility.set_location('old_pl_id = ' ||
10856: l_enrt_table(l_enrt_count).old_pl_id, 9999);
10857: hr_utility.set_location('new_pl_id = ' ||
10851: hr_utility.set_location('bckdt_enrt_cvg_strt_dt = ' ||
10852: l_enrt_table(l_enrt_count).bckdt_enrt_cvg_strt_dt, 72);
10853: hr_utility.set_location('pen_ovn_number = ' ||
10854: l_enrt_table(l_enrt_count).pen_ovn_number, 9999);
10855: hr_utility.set_location('old_pl_id = ' ||
10856: l_enrt_table(l_enrt_count).old_pl_id, 9999);
10857: hr_utility.set_location('new_pl_id = ' ||
10858: l_enrt_table(l_enrt_count).new_pl_id, 9999);
10859: hr_utility.set_location('old_oipl_id = ' ||
10853: hr_utility.set_location('pen_ovn_number = ' ||
10854: l_enrt_table(l_enrt_count).pen_ovn_number, 9999);
10855: hr_utility.set_location('old_pl_id = ' ||
10856: l_enrt_table(l_enrt_count).old_pl_id, 9999);
10857: hr_utility.set_location('new_pl_id = ' ||
10858: l_enrt_table(l_enrt_count).new_pl_id, 9999);
10859: hr_utility.set_location('old_oipl_id = ' ||
10860: l_enrt_table(l_enrt_count).old_oipl_id, 9999);
10861: hr_utility.set_location('new_oipl_id = ' ||
10855: hr_utility.set_location('old_pl_id = ' ||
10856: l_enrt_table(l_enrt_count).old_pl_id, 9999);
10857: hr_utility.set_location('new_pl_id = ' ||
10858: l_enrt_table(l_enrt_count).new_pl_id, 9999);
10859: hr_utility.set_location('old_oipl_id = ' ||
10860: l_enrt_table(l_enrt_count).old_oipl_id, 9999);
10861: hr_utility.set_location('new_oipl_id = ' ||
10862: l_enrt_table(l_enrt_count).new_oipl_id, 9999);
10863: hr_utility.set_location('old_pl_typ_id = ' ||
10857: hr_utility.set_location('new_pl_id = ' ||
10858: l_enrt_table(l_enrt_count).new_pl_id, 9999);
10859: hr_utility.set_location('old_oipl_id = ' ||
10860: l_enrt_table(l_enrt_count).old_oipl_id, 9999);
10861: hr_utility.set_location('new_oipl_id = ' ||
10862: l_enrt_table(l_enrt_count).new_oipl_id, 9999);
10863: hr_utility.set_location('old_pl_typ_id = ' ||
10864: l_enrt_table(l_enrt_count).old_pl_typ_id, 9999);
10865: hr_utility.set_location('new_pl_typ_id = ' ||
10859: hr_utility.set_location('old_oipl_id = ' ||
10860: l_enrt_table(l_enrt_count).old_oipl_id, 9999);
10861: hr_utility.set_location('new_oipl_id = ' ||
10862: l_enrt_table(l_enrt_count).new_oipl_id, 9999);
10863: hr_utility.set_location('old_pl_typ_id = ' ||
10864: l_enrt_table(l_enrt_count).old_pl_typ_id, 9999);
10865: hr_utility.set_location('new_pl_typ_id = ' ||
10866: l_enrt_table(l_enrt_count).new_pl_typ_id, 9999);
10867: hr_utility.set_location('pgm_id = ' ||
10861: hr_utility.set_location('new_oipl_id = ' ||
10862: l_enrt_table(l_enrt_count).new_oipl_id, 9999);
10863: hr_utility.set_location('old_pl_typ_id = ' ||
10864: l_enrt_table(l_enrt_count).old_pl_typ_id, 9999);
10865: hr_utility.set_location('new_pl_typ_id = ' ||
10866: l_enrt_table(l_enrt_count).new_pl_typ_id, 9999);
10867: hr_utility.set_location('pgm_id = ' ||
10868: l_enrt_table(l_enrt_count).pgm_id, 9999);
10869: hr_utility.set_location('elig_per_elctbl_chc_id = ' ||
10863: hr_utility.set_location('old_pl_typ_id = ' ||
10864: l_enrt_table(l_enrt_count).old_pl_typ_id, 9999);
10865: hr_utility.set_location('new_pl_typ_id = ' ||
10866: l_enrt_table(l_enrt_count).new_pl_typ_id, 9999);
10867: hr_utility.set_location('pgm_id = ' ||
10868: l_enrt_table(l_enrt_count).pgm_id, 9999);
10869: hr_utility.set_location('elig_per_elctbl_chc_id = ' ||
10870: l_enrt_table(l_enrt_count).elig_per_elctbl_chc_id, 9999);
10871: /**/
10865: hr_utility.set_location('new_pl_typ_id = ' ||
10866: l_enrt_table(l_enrt_count).new_pl_typ_id, 9999);
10867: hr_utility.set_location('pgm_id = ' ||
10868: l_enrt_table(l_enrt_count).pgm_id, 9999);
10869: hr_utility.set_location('elig_per_elctbl_chc_id = ' ||
10870: l_enrt_table(l_enrt_count).elig_per_elctbl_chc_id, 9999);
10871: /**/
10872: --
10873: end if;
10976: end if;
10977: --
10978: if l_bckdt_pil_prev_stat_cd<>'STRTD' or
10979: l_found_non_automatics then
10980: hr_utility.set_location('Date for multi row edits = ' ||
10981: l_pgm_table(l_cnt).max_enrt_esd || ' ' || ' pgm = ' ||
10982:
10983: l_pgm_table(l_cnt).pgm_id, 333);
10984: ben_prtt_enrt_result_api.multi_rows_edit
11005: -- created.
11006: --
11007: -- Call multi row edits just as miscellanious form calls.
11008: --
11009: hr_utility.set_location('Date for multi row edits = ' ||
11010: l_max_enrt_esd , 333);
11011: ben_prtt_enrt_result_api.multi_rows_edit
11012: (p_person_id => p_person_id,
11013: p_effective_date => l_max_enrt_esd,
11080: for l_cnt in 1..l_pl_table.LAST loop
11081: --
11082: -- Invoke post result process
11083: --
11084: hr_utility.set_location('Date = ' || l_pl_table(l_cnt).max_enrt_esd, 333);
11085: hr_utility.set_location('PL = ' || l_pl_table(l_cnt).pl_id, 333);
11086: --RCHASE - ensure automatics are handled differently than
11087: -- form enrollments by process_post_enrollment
11088: -- Bug 5623259.
11081: --
11082: -- Invoke post result process
11083: --
11084: hr_utility.set_location('Date = ' || l_pl_table(l_cnt).max_enrt_esd, 333);
11085: hr_utility.set_location('PL = ' || l_pl_table(l_cnt).pl_id, 333);
11086: --RCHASE - ensure automatics are handled differently than
11087: -- form enrollments by process_post_enrollment
11088: -- Bug 5623259.
11089: --
11123: for l_cnt in 1..l_enrt_table.LAST loop
11124: --
11125: -- Reinstate the enrollment beneficiary rows.
11126: --
11127: hr_utility.set_location('Enrt Date = ' ||
11128: l_enrt_table(l_cnt).effective_start_date, 333);
11129: hr_utility.set_location('Reinstate the enrollment beneficiary rows',14);
11130: reinstate_pbn_per_pen(
11131: p_person_id => p_person_id
11125: -- Reinstate the enrollment beneficiary rows.
11126: --
11127: hr_utility.set_location('Enrt Date = ' ||
11128: l_enrt_table(l_cnt).effective_start_date, 333);
11129: hr_utility.set_location('Reinstate the enrollment beneficiary rows',14);
11130: reinstate_pbn_per_pen(
11131: p_person_id => p_person_id
11132: ,p_bckdt_prtt_enrt_rslt_id
11133: => l_enrt_table(l_cnt).bckdt_prtt_enrt_rslt_id
11205: for i in 1..l_enrt_table.last loop
11206: --
11207: if l_enrt_table(i).bckdt_enrt_ovridn_flag = 'Y' then
11208: --
11209: hr_utility.set_location('Restoring the overriden result: ' ||
11210: l_enrt_table(i).bckdt_prtt_enrt_rslt_id, 72);
11211: --
11212: -- Get the latest object version number as the post enrollment process
11213: -- may have updated the new enrt result.
11235: for l_rt_rec in c_ovridn_rt(l_enrt_table(i).bckdt_prtt_enrt_rslt_id
11236: ,l_enrt_table(i).prtt_enrt_rslt_id )
11237: loop
11238: --
11239: hr_utility.set_location('Updating new prv: ' || l_rt_rec.new_prv_id ||
11240: ' with overriden prv_id: ' ||
11241: l_rt_rec.prtt_rt_val_id, 72);
11242: --
11243: ben_prtt_rt_val_api.update_prtt_rt_val
11263: ,l_enrt_table(i).prtt_enrt_rslt_id
11264: ,l_enrt_table(i).g_sys_date)
11265: loop
11266: --
11267: hr_utility.set_location('Updating new ecd with overriden ecd_id: ' ||
11268: l_dpnt_rec.elig_cvrd_dpnt_id, 72);
11269: --
11270: ben_elig_cvrd_dpnt_api.update_elig_cvrd_dpnt
11271: (p_elig_cvrd_dpnt_id => l_dpnt_rec.new_pdp_id
11301: ,p_uneai_effective_date => NULL);
11302: --
11303: --end if;
11304: --
11305: hr_utility.set_location ('Leaving '||l_proc,10);
11306: --
11307: --
11308: end reinstate_the_prev_enrt_rslt;
11309: --