eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PROVIDER_POOLS dependencies on HR_API

Line 639: p_old_result_id number default hr_api.g_number,

635: --------------------------------------------------------------------------------
636: function person_enrolled_in_choice(
637: p_person_id number,
638: p_epe_rec ben_epe_shd.g_rec_type,
639: p_old_result_id number default hr_api.g_number,
640: p_effective_date date) return boolean is
641:
642: l_proc varchar2(72) := g_package||'.person_enrolled_in_choice';
643:

Line 652: enrt_cvg_thru_dt=hr_api.g_eot) and

648: per.business_group_id=p_epe_rec.business_group_id and
649: p_effective_date between
650: per.effective_start_date and per.effective_end_date and
651: (enrt_cvg_thru_dt is null or
652: enrt_cvg_thru_dt=hr_api.g_eot) and
653: per.effective_end_date = hr_api.g_eot and
654: per.pgm_id=p_epe_rec.pgm_id and
655: per.prtt_enrt_rslt_id<>p_old_result_id and
656: per.prtt_enrt_rslt_stat_cd is null and

Line 653: per.effective_end_date = hr_api.g_eot and

649: p_effective_date between
650: per.effective_start_date and per.effective_end_date and
651: (enrt_cvg_thru_dt is null or
652: enrt_cvg_thru_dt=hr_api.g_eot) and
653: per.effective_end_date = hr_api.g_eot and
654: per.pgm_id=p_epe_rec.pgm_id and
655: per.prtt_enrt_rslt_id<>p_old_result_id and
656: per.prtt_enrt_rslt_stat_cd is null and
657: -- Bug 4538041

Line 672: enrt_cvg_thru_dt=hr_api.g_eot) and

668: per.business_group_id=p_epe_rec.business_group_id and
669: p_effective_date between
670: per.effective_start_date and per.effective_end_date and
671: (enrt_cvg_thru_dt is null or
672: enrt_cvg_thru_dt=hr_api.g_eot) and
673: per.effective_end_date = hr_api.g_eot and
674: per.pl_id=pl.pl_id and
675: pl.business_group_id=p_epe_rec.business_group_id and
676: per.prtt_enrt_rslt_id<>p_old_result_id and

Line 673: per.effective_end_date = hr_api.g_eot and

669: p_effective_date between
670: per.effective_start_date and per.effective_end_date and
671: (enrt_cvg_thru_dt is null or
672: enrt_cvg_thru_dt=hr_api.g_eot) and
673: per.effective_end_date = hr_api.g_eot and
674: per.pl_id=pl.pl_id and
675: pl.business_group_id=p_epe_rec.business_group_id and
676: per.prtt_enrt_rslt_id<>p_old_result_id and
677: per.sspndd_flag='N' and

Line 694: enrt_cvg_thru_dt=hr_api.g_eot) and

690: per.business_group_id=p_epe_rec.business_group_id and
691: p_effective_date between
692: per.effective_start_date and per.effective_end_date and
693: (enrt_cvg_thru_dt is null or
694: enrt_cvg_thru_dt=hr_api.g_eot) and
695: per.effective_end_date = hr_api.g_eot and
696: per.pl_id=pl.pl_id and
697: pl.business_group_id=p_epe_rec.business_group_id and
698: per.prtt_enrt_rslt_id<>p_old_result_id and

Line 695: per.effective_end_date = hr_api.g_eot and

691: p_effective_date between
692: per.effective_start_date and per.effective_end_date and
693: (enrt_cvg_thru_dt is null or
694: enrt_cvg_thru_dt=hr_api.g_eot) and
695: per.effective_end_date = hr_api.g_eot and
696: per.pl_id=pl.pl_id and
697: pl.business_group_id=p_epe_rec.business_group_id and
698: per.prtt_enrt_rslt_id<>p_old_result_id and
699: per.sspndd_flag='N' and

Line 716: enrt_cvg_thru_dt=hr_api.g_eot) and

712: per.business_group_id=p_epe_rec.business_group_id and
713: p_effective_date between
714: per.effective_start_date and per.effective_end_date and
715: (enrt_cvg_thru_dt is null or
716: enrt_cvg_thru_dt=hr_api.g_eot) and
717: per.effective_end_date = hr_api.g_eot and
718: per.pl_id=pl.pl_id and
719: pl.business_group_id=p_epe_rec.business_group_id and
720: per.prtt_enrt_rslt_id<>p_old_result_id and

Line 717: per.effective_end_date = hr_api.g_eot and

713: p_effective_date between
714: per.effective_start_date and per.effective_end_date and
715: (enrt_cvg_thru_dt is null or
716: enrt_cvg_thru_dt=hr_api.g_eot) and
717: per.effective_end_date = hr_api.g_eot and
718: per.pl_id=pl.pl_id and
719: pl.business_group_id=p_epe_rec.business_group_id and
720: per.prtt_enrt_rslt_id<>p_old_result_id and
721: per.sspndd_flag='N' and

Line 740: enrt_cvg_thru_dt=hr_api.g_eot) and

736: per.business_group_id=p_epe_rec.business_group_id and
737: p_effective_date between
738: per.effective_start_date and per.effective_end_date and
739: (enrt_cvg_thru_dt is null or
740: enrt_cvg_thru_dt=hr_api.g_eot) and
741: per.pl_id=pl.pl_id and
742: pl.business_group_id=p_epe_rec.business_group_id and
743: per.prtt_enrt_rslt_id<>p_old_result_id and
744: per.sspndd_flag='N' and

Line 771: enrt_cvg_thru_dt=hr_api.g_eot) and

767: per.business_group_id=p_epe_rec.business_group_id and
768: p_effective_date between
769: per.effective_start_date and per.effective_end_date and
770: (enrt_cvg_thru_dt is null or
771: enrt_cvg_thru_dt=hr_api.g_eot) and
772: per.effective_end_date = hr_api.g_eot and
773: per.pl_id=pl.pl_id and
774: pl.business_group_id=p_epe_rec.business_group_id and
775: per.prtt_enrt_rslt_id<>p_old_result_id and

Line 772: per.effective_end_date = hr_api.g_eot and

768: p_effective_date between
769: per.effective_start_date and per.effective_end_date and
770: (enrt_cvg_thru_dt is null or
771: enrt_cvg_thru_dt=hr_api.g_eot) and
772: per.effective_end_date = hr_api.g_eot and
773: per.pl_id=pl.pl_id and
774: pl.business_group_id=p_epe_rec.business_group_id and
775: per.prtt_enrt_rslt_id<>p_old_result_id and
776: per.sspndd_flag='N' and

Line 802: enrt_cvg_thru_dt=hr_api.g_eot) and

798: per.prtt_enrt_rslt_stat_cd is null and
799: p_effective_date between
800: per.effective_start_date and per.effective_end_date and
801: (enrt_cvg_thru_dt is null or
802: enrt_cvg_thru_dt=hr_api.g_eot) and
803: per.effective_end_date = hr_api.g_eot and
804: p_epe_rec.pl_id=per.pl_id and
805: p_epe_rec.pgm_id = per.pgm_id; -- Added : 4964766
806:

Line 803: per.effective_end_date = hr_api.g_eot and

799: p_effective_date between
800: per.effective_start_date and per.effective_end_date and
801: (enrt_cvg_thru_dt is null or
802: enrt_cvg_thru_dt=hr_api.g_eot) and
803: per.effective_end_date = hr_api.g_eot and
804: p_epe_rec.pl_id=per.pl_id and
805: p_epe_rec.pgm_id = per.pgm_id; -- Added : 4964766
806:
807: cursor c_oipl_enrolment is

Line 818: enrt_cvg_thru_dt=hr_api.g_eot) and

814: per.prtt_enrt_rslt_stat_cd is null and
815: p_effective_date between
816: per.effective_start_date and per.effective_end_date and
817: (enrt_cvg_thru_dt is null or
818: enrt_cvg_thru_dt=hr_api.g_eot) and
819: per.effective_end_date = hr_api.g_eot and
820: p_epe_rec.oipl_id=per.oipl_id and
821: p_epe_rec.pgm_id = per.pgm_id; -- Added : 4964766
822:

Line 819: per.effective_end_date = hr_api.g_eot and

815: p_effective_date between
816: per.effective_start_date and per.effective_end_date and
817: (enrt_cvg_thru_dt is null or
818: enrt_cvg_thru_dt=hr_api.g_eot) and
819: per.effective_end_date = hr_api.g_eot and
820: p_epe_rec.oipl_id=per.oipl_id and
821: p_epe_rec.pgm_id = per.pgm_id; -- Added : 4964766
822:
823: cursor c_oiplip_enrolment is

Line 834: enrt_cvg_thru_dt=hr_api.g_eot) and

830: per.prtt_enrt_rslt_stat_cd is null and
831: p_effective_date between
832: per.effective_start_date and per.effective_end_date and
833: (enrt_cvg_thru_dt is null or
834: enrt_cvg_thru_dt=hr_api.g_eot) and
835: per.effective_end_date = hr_api.g_eot and
836: cpp.pgm_id = p_epe_rec.pgm_id and
837: per.pl_id = cpp.pl_id and
838: cpp.plip_id = oiplip.plip_id and

Line 835: per.effective_end_date = hr_api.g_eot and

831: p_effective_date between
832: per.effective_start_date and per.effective_end_date and
833: (enrt_cvg_thru_dt is null or
834: enrt_cvg_thru_dt=hr_api.g_eot) and
835: per.effective_end_date = hr_api.g_eot and
836: cpp.pgm_id = p_epe_rec.pgm_id and
837: per.pl_id = cpp.pl_id and
838: cpp.plip_id = oiplip.plip_id and
839: per.oipl_id = oiplip.oipl_id and

Line 1235: l_datetrack_mode:=hr_api.g_correction;

1231: --
1232: elsif l_val<>l_prvdd_val and nvl(p_enrt_mthd_cd,'E') <> 'O' then
1233: /*
1234: if l_effective_start_date=p_effective_date then
1235: l_datetrack_mode:=hr_api.g_correction;
1236: else
1237: l_datetrack_mode:=hr_api.g_update;
1238: end if;
1239: */

Line 1237: l_datetrack_mode:=hr_api.g_update;

1233: /*
1234: if l_effective_start_date=p_effective_date then
1235: l_datetrack_mode:=hr_api.g_correction;
1236: else
1237: l_datetrack_mode:=hr_api.g_update;
1238: end if;
1239: */
1240: Get_DT_Upd_Mode
1241: (p_effective_date => p_effective_date,

Line 1483: l_datetrack_mode:=hr_api.g_correction;

1479: );
1480: hr_utility.set_location('CREATED LEDGER ID='||to_char(p_bnft_prvdd_ldgr_id),41);
1481: else
1482: /*if l_effective_start_date=p_effective_date then
1483: l_datetrack_mode:=hr_api.g_correction;
1484: else
1485: l_datetrack_mode:=hr_api.g_update;
1486: end if;*/
1487: Get_DT_Upd_Mode

Line 1485: l_datetrack_mode:=hr_api.g_update;

1481: else
1482: /*if l_effective_start_date=p_effective_date then
1483: l_datetrack_mode:=hr_api.g_correction;
1484: else
1485: l_datetrack_mode:=hr_api.g_update;
1486: end if;*/
1487: Get_DT_Upd_Mode
1488: (p_effective_date => p_effective_date,
1489: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',

Line 1687: and effective_end_date = hr_api.g_eot

1683: where person_id = p_person_id
1684: and comp_lvl_cd = 'PLANFC'
1685: and prtt_enrt_rslt_stat_cd is null
1686: -- added effective_end_date line Bug# 2254326
1687: and effective_end_date = hr_api.g_eot
1688: and p_effective_date between enrt_cvg_strt_dt
1689: and enrt_cvg_thru_dt;
1690: --
1691: cursor c_bnft_prvdd_ldgr(c_per_in_ler_id number) is

Line 1700: -- and bpl.effective_end_date = hr_api.g_eot

1696: from ben_bnft_prvdd_ldgr_f bpl,
1697: ben_per_in_ler pil
1698: where bpl.acty_base_rt_id = l_acty_base_rt_id
1699: and bpl.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
1700: -- and bpl.effective_end_date = hr_api.g_eot
1701: and p_effective_date between bpl.effective_start_date
1702: and bpl.effective_end_date
1703: and bpl.per_in_ler_id = pil.per_in_ler_id
1704: and bpl.per_in_ler_id = nvl(c_per_in_ler_id,bpl.per_in_ler_id)

Line 1715: and pen1.effective_end_date = hr_api.g_eot

1711: ben_prtt_enrt_rslt_f pen2
1712: where pen1.person_id = p_person_id
1713: and pen1.comp_lvl_cd = 'PLANFC'
1714: and pen1.prtt_enrt_rslt_stat_cd is null
1715: and pen1.effective_end_date = hr_api.g_eot
1716: and p_effective_date between pen1.enrt_cvg_strt_dt
1717: and pen1.enrt_cvg_thru_dt
1718: and pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1719: and p_effective_date between pen2.effective_start_date

Line 1721: and ( (pen2.enrt_cvg_thru_dt <> hr_api.g_eot and pen2.per_in_ler_id <> pen1.per_in_ler_id)

1717: and pen1.enrt_cvg_thru_dt
1718: and pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1719: and p_effective_date between pen2.effective_start_date
1720: and pen2.effective_end_date
1721: and ( (pen2.enrt_cvg_thru_dt <> hr_api.g_eot and pen2.per_in_ler_id <> pen1.per_in_ler_id)
1722: or (pen2.per_in_ler_id = pen1.per_in_ler_id) ) ;
1723:
1724: l_per_in_ler_id_1 number;
1725: --

Line 1763: --and bpl.effective_end_date = hr_api.g_eot

1759: ben_per_in_ler pil
1760: where bpl.bnft_prvdr_pool_id = l_epe.bnft_prvdr_pool_id
1761: and bpl.prtt_enrt_rslt_id = l_prtt_enrt_rslt_id
1762: and bpl.acty_base_rt_id = p_acty_base_rt_id
1763: --and bpl.effective_end_date = hr_api.g_eot
1764: and p_effective_date between bpl.effective_start_date
1765: and bpl.effective_end_date
1766: and bpl.per_in_ler_id = pil.per_in_ler_id
1767: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');

Line 1794: and pen.enrt_cvg_thru_dt = hr_api.g_eot

1790: and pen.person_id = p_person_id
1791: and pen.prtt_enrt_rslt_stat_cd is null
1792: and epe.business_group_id = pen.business_group_id
1793: and pen.sspndd_flag = 'N'
1794: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1795: and pen.effective_end_date = hr_api.g_eot
1796: and epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id
1797: and enb.enrt_bnft_id = ecr.enrt_bnft_id
1798: and ecr.acty_base_rt_id = l_acty_base_rt_id;

Line 1795: and pen.effective_end_date = hr_api.g_eot

1791: and pen.prtt_enrt_rslt_stat_cd is null
1792: and epe.business_group_id = pen.business_group_id
1793: and pen.sspndd_flag = 'N'
1794: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1795: and pen.effective_end_date = hr_api.g_eot
1796: and epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id
1797: and enb.enrt_bnft_id = ecr.enrt_bnft_id
1798: and ecr.acty_base_rt_id = l_acty_base_rt_id;
1799: --

Line 1867: --nvl(l_rt_usg_cd,hr_api.g_varchar2)<>'FLXCR') then

1863: if c_ldgr_exist%notfound then
1864: close c_ldgr_exist;
1865: else
1866:
1867: --nvl(l_rt_usg_cd,hr_api.g_varchar2)<>'FLXCR') then
1868: hr_utility.set_location('Deleting ledger='||to_char(l_bnft_prvdd_ldgr_id), 50);
1869: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
1870: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id,
1871: p_effective_start_date => l_effective_start_date,

Line 1875: p_datetrack_mode => hr_api.g_zap,

1871: p_effective_start_date => l_effective_start_date,
1872: p_effective_end_date => l_effective_end_date,
1873: p_object_version_number => l_object_version_number,
1874: p_effective_date => p_effective_date,
1875: p_datetrack_mode => hr_api.g_zap,
1876: p_business_group_id => p_business_group_id
1877: );
1878: close c_ldgr_exist;
1879: end if;

Line 1903: l_datetrack_mode := hr_api.g_zap;

1899: hr_utility.set_location('ldgr id is'||l_bnft_prvdd_ldgr_id, 51);
1900: if c_bnft_prvdd_ldgr%found then
1901: if p_effective_date = l_bpl_esd
1902: then
1903: l_datetrack_mode := hr_api.g_zap;
1904: l_effective_date := l_bpl_esd ;
1905: else
1906: l_datetrack_mode := hr_api.g_delete;
1907: l_effective_date := p_effective_date - 1 ;

Line 1906: l_datetrack_mode := hr_api.g_delete;

1902: then
1903: l_datetrack_mode := hr_api.g_zap;
1904: l_effective_date := l_bpl_esd ;
1905: else
1906: l_datetrack_mode := hr_api.g_delete;
1907: l_effective_date := p_effective_date - 1 ;
1908: end if;
1909: --
1910: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

Line 1946: if l_rslt.enrt_cvg_thru_dt <>hr_api.g_eot or

1942: close c_rslt;
1943: hr_utility.set_location('Thru dt ' ||l_rslt.enrt_cvg_thru_dt, 70);
1944: hr_utility.set_location('stat Cd '||l_rslt.prtt_enrt_rslt_stat_cd, 70);
1945: hr_utility.set_location('sspndd '||l_rslt.sspndd_flag, 70);
1946: if l_rslt.enrt_cvg_thru_dt <>hr_api.g_eot or
1947: l_rslt.prtt_enrt_rslt_stat_cd in ('VOIDD','BCKDT') or
1948: nvl(l_rslt.sspndd_flag,'N') = 'Y' then -- Bug 5185351
1949: l_purge := 'Y';
1950: end if;

Line 1954: /*if(l_rslt.enrt_cvg_thru_dt <> hr_api.g_eot) then

1950: end if;
1951: --
1952: --
1953: /*Bug 13010726 */
1954: /*if(l_rslt.enrt_cvg_thru_dt <> hr_api.g_eot) then
1955:
1956: open c_flx_credit_plan_deenrt;
1957: fetch c_flx_credit_plan_deenrt into l_prtt_enrt_rslt_id,l_per_in_ler_id_1;
1958: close c_flx_credit_plan_deenrt;

Line 1992: /*if(l_rslt.enrt_cvg_thru_dt <> hr_api.g_eot) then

1988: -- this case, we do not want to delete the ledger as the
1989: -- person is still enrolled in the fsa plan. Bug 2119974.
1990: --
1991: /* Bug 13010726 : Added if..else condition*/
1992: /*if(l_rslt.enrt_cvg_thru_dt <> hr_api.g_eot) then
1993: l_delete_bpl := true;
1994: else*/
1995: if l_prtt_ro_of_unusd_amt_flag = 'Y' then
1996: open c_person_enrolled;

Line 2017: l_datetrack_mode := hr_api.g_zap;

2013: -- Following call is delete of USED_VAL BPL entries.
2014: --
2015: if p_effective_date = l_bpl_esd
2016: then
2017: l_datetrack_mode := hr_api.g_zap;
2018: l_effective_date := l_bpl_esd ;
2019: else
2020: l_datetrack_mode := hr_api.g_delete;
2021: l_effective_date := p_effective_date - 1 ;

Line 2020: l_datetrack_mode := hr_api.g_delete;

2016: then
2017: l_datetrack_mode := hr_api.g_zap;
2018: l_effective_date := l_bpl_esd ;
2019: else
2020: l_datetrack_mode := hr_api.g_delete;
2021: l_effective_date := p_effective_date - 1 ;
2022: end if;
2023: --
2024: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

Line 2104: l_datetrack_mode := hr_api.g_zap;

2100: --
2101: -- Bug 5500864
2102: if p_effective_date = l_bpl_esd
2103: then
2104: l_datetrack_mode := hr_api.g_zap;
2105: l_effective_date := l_bpl_esd ;
2106: else
2107: l_datetrack_mode := hr_api.g_delete;
2108: l_effective_date := p_effective_date - 1 ;

Line 2107: l_datetrack_mode := hr_api.g_delete;

2103: then
2104: l_datetrack_mode := hr_api.g_zap;
2105: l_effective_date := l_bpl_esd ;
2106: else
2107: l_datetrack_mode := hr_api.g_delete;
2108: l_effective_date := p_effective_date - 1 ;
2109: end if;
2110: --
2111: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(

Line 2254: (nvl(l_rt_usg_cd,hr_api.g_varchar2)<>'FLXCR' and

2250: -- rt_usg_cd<>'FLXCR' and not directly enrolled
2251: -- then remove the ledger entry
2252: --
2253: if ((not l_person_enrolled) or
2254: (nvl(l_rt_usg_cd,hr_api.g_varchar2)<>'FLXCR' and
2255: l_epe.prtt_enrt_rslt_id is null)) then
2256: hr_utility.set_location('Deleting ledger='||to_char(l_bnft_prvdd_ldgr_id), 50);
2257: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
2258: p_bnft_prvdd_ldgr_id => l_bnft_prvdd_ldgr_id,

Line 2263: p_datetrack_mode => hr_api.g_zap,

2259: p_effective_start_date => l_effective_start_date,
2260: p_effective_end_date => l_effective_end_date,
2261: p_object_version_number => l_object_version_number,
2262: p_effective_date => p_effective_date,
2263: p_datetrack_mode => hr_api.g_zap,
2264: p_business_group_id => p_business_group_id
2265: );
2266: hr_utility.set_location(l_proc, 60);
2267: end if;

Line 2413: nvl(p_rt_val,hr_api.g_number) <> hr_api.g_number ) then --Bug 3864152

2409: open c_flex_credit_choice;
2410: fetch c_flex_credit_choice into l_flex_credit_choice;
2411: --
2412: if (c_flex_credit_choice%notfound and
2413: nvl(p_rt_val,hr_api.g_number) <> hr_api.g_number ) then --Bug 3864152
2414: hr_utility.set_location('BEN_91726_NO_FLX_CR_CHOICE', 20);
2415: fnd_message.set_name('BEN','BEN_91726_NO_FLX_CR_CHOICE');
2416: fnd_message.set_token('PROC',l_proc);
2417: fnd_message.set_token('PERSON_ID', to_char(p_person_id));

Line 2592: p_datetrack_mode => hr_api.g_insert,

2588: p_effective_end_date => l_effective_end_date,
2589: p_enrt_mthd_cd => p_enrt_mthd_cd,
2590: p_enrt_bnft_id => null,
2591: p_bnft_val => null,
2592: p_datetrack_mode => hr_api.g_insert,
2593: p_suspend_flag => l_suspend_flag,
2594: p_object_version_number => l_flex_credit_choice.object_version_number,
2595: p_prtt_enrt_interim_id => l_prtt_enrt_interim_id,
2596: p_rt_val1 => p_rt_val,

Line 2630: p_datetrack_mode => hr_api.g_correction,

2626: p_effective_end_date => l_effective_end_date,
2627: p_enrt_mthd_cd => p_enrt_mthd_cd,
2628: p_enrt_bnft_id => null,
2629: p_bnft_val => null,
2630: p_datetrack_mode => hr_api.g_correction,
2631: p_suspend_flag => l_suspend_flag,
2632: p_object_version_number => l_flex_credit_choice.object_version_number,
2633: p_prtt_enrt_interim_id => l_prtt_enrt_interim_id,
2634: p_rt_val1 => p_rt_val,

Line 2668: p_datetrack_mode => hr_api.g_correction,

2664: p_effective_end_date => l_effective_end_date,
2665: p_enrt_mthd_cd => p_enrt_mthd_cd,
2666: p_enrt_bnft_id => null,
2667: p_bnft_val => null,
2668: p_datetrack_mode => hr_api.g_correction,
2669: p_suspend_flag => l_suspend_flag,
2670: p_object_version_number => l_flex_credit_choice.object_version_number,
2671: p_prtt_enrt_interim_id => l_prtt_enrt_interim_id,
2672: p_rt_val1 => l_prnt_rt_val,

Line 2867: l_datetrack_mode:=hr_api.g_correction;

2863: -- update ledger row
2864: --
2865: /*
2866: if l_effective_start_date=p_effective_date then
2867: l_datetrack_mode:=hr_api.g_correction;
2868: else
2869: l_datetrack_mode:=hr_api.g_update;
2870: end if;
2871: */

Line 2869: l_datetrack_mode:=hr_api.g_update;

2865: /*
2866: if l_effective_start_date=p_effective_date then
2867: l_datetrack_mode:=hr_api.g_correction;
2868: else
2869: l_datetrack_mode:=hr_api.g_update;
2870: end if;
2871: */
2872: Get_DT_Upd_Mode
2873: (p_effective_date => p_effective_date,

Line 3404: l_datetrack_mode:=hr_api.g_correction;

3400: then
3401: hr_utility.set_location(l_proc, 310);
3402: /* if l_effective_start_date=p_effective_date then
3403: hr_utility.set_location(l_proc,320 );
3404: l_datetrack_mode:=hr_api.g_correction;
3405: else
3406: hr_utility.set_location(l_proc,330 );
3407: l_datetrack_mode:=hr_api.g_update;
3408: end if; */

Line 3407: l_datetrack_mode:=hr_api.g_update;

3403: hr_utility.set_location(l_proc,320 );
3404: l_datetrack_mode:=hr_api.g_correction;
3405: else
3406: hr_utility.set_location(l_proc,330 );
3407: l_datetrack_mode:=hr_api.g_update;
3408: end if; */
3409: Get_DT_Upd_Mode
3410: (p_effective_date => p_effective_date,
3411: p_base_table_name => 'BEN_BNFT_PRVDD_LDGR_F',

Line 3426: ,p_per_in_ler_id => nvl(p_per_in_ler_id, hr_api.g_number) /* Bug 4251187 */

3422: ,p_prvdd_val => null
3423: ,p_used_val => null
3424: ,p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id
3425: ,p_acty_base_rt_id => l_acty_base_rt_id
3426: ,p_per_in_ler_id => nvl(p_per_in_ler_id, hr_api.g_number) /* Bug 4251187 */
3427: ,p_prtt_enrt_rslt_id => g_credit_pool_result_id
3428: ,p_business_group_id => p_business_group_id
3429: ,p_object_version_number => l_object_version_number
3430: ,p_cash_recd_val => l_cash_val

Line 4010: l_datetrack_mode:=hr_api.g_correction;

4006: else --if l_old_rlovr_val<>l_balance then-------Bug 7363185
4007: hr_utility.set_location(l_proc, 110);
4008: /*
4009: if l_effective_start_date=p_effective_date then
4010: l_datetrack_mode:=hr_api.g_correction;
4011: else
4012: l_datetrack_mode:=hr_api.g_update;
4013: end if;
4014: */

Line 4012: l_datetrack_mode:=hr_api.g_update;

4008: /*
4009: if l_effective_start_date=p_effective_date then
4010: l_datetrack_mode:=hr_api.g_correction;
4011: else
4012: l_datetrack_mode:=hr_api.g_update;
4013: end if;
4014: */
4015: Get_DT_Upd_Mode
4016: (p_effective_date => p_effective_date,

Line 4457: l_datetrack_mode:=hr_api.g_correction;

4453: -- call election_information api to create prtt enrt result
4454: --
4455: --
4456: if l_rlovr_chc.prtt_enrt_rslt_id is not null then
4457: l_datetrack_mode:=hr_api.g_correction;
4458: else
4459: l_datetrack_mode:=hr_api.g_insert;
4460: end if;
4461: --

Line 4459: l_datetrack_mode:=hr_api.g_insert;

4455: --
4456: if l_rlovr_chc.prtt_enrt_rslt_id is not null then
4457: l_datetrack_mode:=hr_api.g_correction;
4458: else
4459: l_datetrack_mode:=hr_api.g_insert;
4460: end if;
4461: --
4462: hr_utility.set_location(l_proc, 70);
4463: ben_election_information.election_information(

Line 4688: and pen.effective_end_date = hr_api.g_eot ;

4684: and pen.prtt_enrt_rslt_stat_cd is null
4685: and pen.enrt_mthd_cd = 'D'
4686: and p_effective_date between
4687: pen.enrt_cvg_strt_dt and pen.enrt_cvg_thru_dt
4688: and pen.effective_end_date = hr_api.g_eot ;
4689:
4690: l_default_enrt_flag varchar2(1) := 'N' ;
4691: l_dummy_var varchar2(1) ;
4692: begin

Line 5403: ,p_rt_end_dt => hr_api.g_eot

5399: ,p_mlt_cd => l_prv_rec.mlt_cd
5400: ,p_acty_ref_perd_cd => l_prv_rec.acty_ref_perd_cd
5401: ,p_rt_val => p_val
5402: ,p_rt_strt_dt => l_rt_strt_dt
5403: ,p_rt_end_dt => hr_api.g_eot
5404: ,p_ann_rt_val => null
5405: ,p_bnft_rt_typ_cd => l_prv_rec.bnft_rt_typ_cd
5406: ,p_cmcd_ref_perd_cd => l_prv_rec.cmcd_ref_perd_cd
5407: ,p_cmcd_rt_val => p_val

Line 5485: and pen.enrt_cvg_thru_dt = hr_api.g_eot

5481: and prv.prtt_rt_val_stat_cd is null
5482: and prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
5483: and pen.person_id = p_person_id
5484: and pen.prtt_enrt_rslt_stat_cd is null
5485: and pen.enrt_cvg_thru_dt = hr_api.g_eot
5486: and p_effective_date between
5487: pen.effective_start_date and pen.effective_end_date
5488: and prv.acty_base_rt_id = abr.acty_base_rt_id
5489: and p_effective_date between

Line 5513: l_datetrack_mode := hr_api.g_zap;

5509: --
5510: hr_utility.set_location(l_proc,10);
5511: if p_effective_date = l_bpl_rec.effective_start_date then
5512: --
5513: l_datetrack_mode := hr_api.g_zap;
5514: l_effective_date := p_effective_date;
5515: --
5516: else
5517: --

Line 5518: l_datetrack_mode := hr_api.g_delete;

5514: l_effective_date := p_effective_date;
5515: --
5516: else
5517: --
5518: l_datetrack_mode := hr_api.g_delete;
5519: l_effective_date := p_effective_date -1;
5520: --
5521: end if;
5522: --

Line 5568: l_datetrack_mode := hr_api.g_zap;

5564: -- enrollment.
5565: --
5566: if p_effective_date = l_pen_effective_start_date then
5567: --
5568: l_datetrack_mode := hr_api.g_zap;
5569: --
5570: else
5571: --
5572: l_datetrack_mode := hr_api.g_delete;

Line 5572: l_datetrack_mode := hr_api.g_delete;

5568: l_datetrack_mode := hr_api.g_zap;
5569: --
5570: else
5571: --
5572: l_datetrack_mode := hr_api.g_delete;
5573: --
5574: end if;
5575: --
5576: ben_prtt_enrt_result_api.delete_enrollment(

Line 5683: rslt.enrt_cvg_thru_dt = hr_api.g_eot and

5679: prv.prtt_enrt_rslt_id = rslt.prtt_enrt_rslt_id and
5680: rslt.person_id=p_person_id and
5681: rslt.business_group_id=p_business_group_id and
5682: rslt.prtt_enrt_rslt_stat_cd is null and
5683: rslt.enrt_cvg_thru_dt = hr_api.g_eot and
5684: prv.business_group_id =p_business_group_id and
5685: prv.prtt_rt_val_stat_cd is null and
5686: p_effective_date between
5687: rslt.effective_start_date and rslt.effective_end_date and

Line 6002: l_datetrack_mode:=hr_api.g_correction;

5998: --
5999: hr_utility.set_location(l_proc, 110);
6000: /*
6001: if l_effective_start_date=p_effective_date then
6002: l_datetrack_mode:=hr_api.g_correction;
6003: else
6004: l_datetrack_mode:=hr_api.g_update;
6005: end if;
6006: */

Line 6004: l_datetrack_mode:=hr_api.g_update;

6000: /*
6001: if l_effective_start_date=p_effective_date then
6002: l_datetrack_mode:=hr_api.g_correction;
6003: else
6004: l_datetrack_mode:=hr_api.g_update;
6005: end if;
6006: */
6007: Get_DT_Upd_Mode
6008: (p_effective_date => p_effective_date,

Line 6632: ,p_rt_end_dt => hr_api.g_eot

6628: ,p_mlt_cd => l_abr_rec.rt_mlt_cd
6629: ,p_acty_ref_perd_cd => l_acty_ref_perd_cd
6630: ,p_rt_val => p_def_exc_amount
6631: ,p_rt_strt_dt => l_rt_strt_dt
6632: ,p_rt_end_dt => hr_api.g_eot
6633: ,p_ann_rt_val => null
6634: ,p_bnft_rt_typ_cd => l_abr_rec.bnft_rt_typ_cd
6635: ,p_cmcd_ref_perd_cd => l_cmcd_ref_perd_cd
6636: ,p_cmcd_rt_val => p_def_exc_amount

Line 6723: ,p_rt_end_dt => hr_api.g_eot

6719: ,p_mlt_cd => l_abr_rec.rt_mlt_cd
6720: ,p_acty_ref_perd_cd => l_acty_ref_perd_cd
6721: ,p_rt_val => l_child_rt_val
6722: ,p_rt_strt_dt => l_rt_strt_dt
6723: ,p_rt_end_dt => hr_api.g_eot
6724: ,p_ann_rt_val => null
6725: ,p_bnft_rt_typ_cd => l_abr_rec.bnft_rt_typ_cd
6726: ,p_cmcd_ref_perd_cd => l_cmcd_ref_perd_cd
6727: ,p_cmcd_rt_val => l_child_rt_val

Line 6807: and enrt_pen.enrt_cvg_thru_dt = hr_api.g_eot

6803: ben_per_in_ler pil,
6804: ben_prtt_enrt_rslt_f flex_pen
6805: where enrt_pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6806: and enrt_pen.prtt_enrt_rslt_stat_cd is null
6807: and enrt_pen.enrt_cvg_thru_dt = hr_api.g_eot
6808: and p_effective_date between
6809: enrt_pen.effective_start_date and enrt_pen.effective_end_date
6810: and enrt_pen.prtt_enrt_rslt_id = enrt_prv.prtt_enrt_rslt_id
6811: and enrt_prv.prtt_rt_val_stat_cd is null

Line 6819: and flex_pen.enrt_cvg_thru_dt = hr_api.g_eot

6815: bpl.effective_start_date and bpl.effective_end_date
6816: and bpl.prtt_enrt_rslt_id = flex_pen.prtt_enrt_rslt_id
6817: and flex_pen.person_id = p_person_id
6818: and flex_pen.prtt_enrt_rslt_stat_cd is null
6819: and flex_pen.enrt_cvg_thru_dt = hr_api.g_eot
6820: and p_effective_date between
6821: flex_pen.effective_start_date and flex_pen.effective_end_date
6822: and pil.per_in_ler_id=bpl.per_in_ler_id
6823: and pil.business_group_id=bpl.business_group_id

Line 6851: and flex_pen.enrt_cvg_thru_dt = hr_api.g_eot

6847: ben_bnft_prvdr_pool_f bpp
6848: where flex_pen.person_id = p_person_id
6849: and flex_pen.pgm_id = p_pgm_id
6850: and flex_pen.prtt_enrt_rslt_stat_cd is null
6851: and flex_pen.enrt_cvg_thru_dt = hr_api.g_eot
6852: and p_effective_date between
6853: flex_pen.effective_start_date and flex_pen.effective_end_date
6854: and flex_pen.prtt_enrt_rslt_id = bpl.prtt_enrt_rslt_id
6855: and bpl.prvdd_val is not null

Line 6994: l_datetrack_mode := hr_api.g_zap;

6990: l_flex_rslt_id := l_dbt_bpl_rec.prtt_enrt_rslt_id;
6991: --
6992: /* if l_dbt_bpl_rec.effective_start_date = p_effective_date then
6993: --
6994: l_datetrack_mode := hr_api.g_zap;
6995: l_effective_date := p_effective_date;
6996: --
6997: else
6998: --

Line 6999: l_datetrack_mode := hr_api.g_delete;

6995: l_effective_date := p_effective_date;
6996: --
6997: else
6998: --
6999: l_datetrack_mode := hr_api.g_delete;
7000: l_effective_date := p_effective_date -1;
7001: --
7002: end if;*/
7003: Open c_bpl_esd(l_dbt_bpl_rec.bnft_prvdd_ldgr_id);

Line 7011: l_datetrack_mode := hr_api.g_zap;

7007: if l_bpl_esd_rec.effective_start_date = p_effective_date and
7008: l_count = 1 then
7009: --
7010: l_ovn := l_bpl_esd_rec.object_version_number;
7011: l_datetrack_mode := hr_api.g_zap;
7012: l_effective_date := p_effective_date;
7013: exit;
7014: --
7015: elsif (p_effective_date-1) between l_bpl_esd_rec.effective_start_date

Line 7019: l_datetrack_mode := hr_api.g_delete;

7015: elsif (p_effective_date-1) between l_bpl_esd_rec.effective_start_date
7016: and l_bpl_esd_rec.effective_end_date then
7017: --
7018: l_ovn := l_bpl_esd_rec.object_version_number;
7019: l_datetrack_mode := hr_api.g_delete;
7020: l_effective_date := p_effective_date - 1;
7021: exit;
7022: --
7023: end if;