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_DETERMINE_DATE dependencies on BEN_MANAGE_LIFE_EVENTS

Line 1699: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL

1695: if g_debug then
1696: hr_utility.set_location('l_lf_evt_ocrd_dt :'||l_lf_evt_ocrd_dt , 17);
1697: end if;
1698:
1699: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL
1700: and p_date_cd in ('LEMES','LFMEMES','LFPPEMES','LFYEMES') ) then
1701: hr_utility.set_location('l_lf_evt_ocrd_dt bckdt:'||ben_manage_life_events.g_bckdt_per_in_ler_id, 17);
1702: open c_rt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
1703: fetch c_rt_dts_bckdt into l_rt_strt_dt1,

Line 1701: hr_utility.set_location('l_lf_evt_ocrd_dt bckdt:'||ben_manage_life_events.g_bckdt_per_in_ler_id, 17);

1697: end if;
1698:
1699: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL
1700: and p_date_cd in ('LEMES','LFMEMES','LFPPEMES','LFYEMES') ) then
1701: hr_utility.set_location('l_lf_evt_ocrd_dt bckdt:'||ben_manage_life_events.g_bckdt_per_in_ler_id, 17);
1702: open c_rt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
1703: fetch c_rt_dts_bckdt into l_rt_strt_dt1,
1704: l_rt_end_dt1;
1705: close c_rt_dts_bckdt;

Line 1702: open c_rt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);

1698:
1699: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL
1700: and p_date_cd in ('LEMES','LFMEMES','LFPPEMES','LFYEMES') ) then
1701: hr_utility.set_location('l_lf_evt_ocrd_dt bckdt:'||ben_manage_life_events.g_bckdt_per_in_ler_id, 17);
1702: open c_rt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
1703: fetch c_rt_dts_bckdt into l_rt_strt_dt1,
1704: l_rt_end_dt1;
1705: close c_rt_dts_bckdt;
1706:

Line 1834: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL

1830: --
1831: if p_date_cd = 'FDPPCFES' or p_date_cd ='FDPPELD' then
1832: -- First of Pay Period On or After Enrollment
1833: --
1834: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL
1835: and p_date_cd ='FDPPELD') then
1836: hr_utility.set_location('Entering FDPPELD',11);
1837: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
1838: fetch c_prtt_enrt_rslt_dts_bckdt into l_enrt_cvg_end_dt,

Line 1837: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);

1833: --
1834: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL
1835: and p_date_cd ='FDPPELD') then
1836: hr_utility.set_location('Entering FDPPELD',11);
1837: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
1838: fetch c_prtt_enrt_rslt_dts_bckdt into l_enrt_cvg_end_dt,
1839: l_enrt_cvg_strt_dt,
1840: l_enrt_eff_strt_date;
1841: --

Line 5011: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL) then

5007: elsif p_date_cd = 'LELD' then
5008: --
5009: -- hr_utility.set_location('Entering LELD',10);
5010: --
5011: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL) then
5012: hr_utility.set_location('Entering LELD',11);
5013: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
5014: fetch c_prtt_enrt_rslt_dts_bckdt into l_enrt_cvg_end_dt,
5015: l_enrt_cvg_strt_dt,

Line 5013: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);

5009: -- hr_utility.set_location('Entering LELD',10);
5010: --
5011: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL) then
5012: hr_utility.set_location('Entering LELD',11);
5013: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
5014: fetch c_prtt_enrt_rslt_dts_bckdt into l_enrt_cvg_end_dt,
5015: l_enrt_cvg_strt_dt,
5016: l_enrt_eff_strt_date;
5017: --

Line 5076: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL) then

5072: elsif p_date_cd = 'LELDED' then
5073: --
5074: -- hr_utility.set_location('Entering LELDED',10);
5075: --
5076: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL) then
5077: hr_utility.set_location('Entering LELDED',11);
5078: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
5079: fetch c_prtt_enrt_rslt_dts_bckdt into l_enrt_cvg_end_dt,
5080: l_enrt_cvg_strt_dt,

Line 5078: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);

5074: -- hr_utility.set_location('Entering LELDED',10);
5075: --
5076: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL) then
5077: hr_utility.set_location('Entering LELDED',11);
5078: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
5079: fetch c_prtt_enrt_rslt_dts_bckdt into l_enrt_cvg_end_dt,
5080: l_enrt_cvg_strt_dt,
5081: l_enrt_eff_strt_date;
5082: --

Line 5132: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL) then

5128: --
5129: -- hr_utility.set_location('Entering ODEWM',10);
5130: --
5131: /*Added for Bug 12351605. get the old coverage from backed out pen result. Added if condition */
5132: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL) then
5133: hr_utility.set_location('Entering ODEWM',11);
5134: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
5135: fetch c_prtt_enrt_rslt_dts_bckdt into l_enrt_cvg_end_dt,
5136: l_enrt_cvg_strt_dt,

Line 5134: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);

5130: --
5131: /*Added for Bug 12351605. get the old coverage from backed out pen result. Added if condition */
5132: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL) then
5133: hr_utility.set_location('Entering ODEWM',11);
5134: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
5135: fetch c_prtt_enrt_rslt_dts_bckdt into l_enrt_cvg_end_dt,
5136: l_enrt_cvg_strt_dt,
5137: l_enrt_eff_strt_date;
5138: --

Line 5174: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL) then

5170: -- time of enrollment.
5171: --
5172: hr_utility.set_location('Entering AFDELD',10);
5173: --
5174: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL) then
5175: hr_utility.set_location('Entering AFDELD',11);
5176: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
5177: fetch c_prtt_enrt_rslt_dts_bckdt into l_enrt_cvg_end_dt,
5178: l_enrt_cvg_strt_dt,

Line 5176: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);

5172: hr_utility.set_location('Entering AFDELD',10);
5173: --
5174: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL) then
5175: hr_utility.set_location('Entering AFDELD',11);
5176: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
5177: fetch c_prtt_enrt_rslt_dts_bckdt into l_enrt_cvg_end_dt,
5178: l_enrt_cvg_strt_dt,
5179: l_enrt_eff_strt_date;
5180: --

Line 5215: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL) then

5211: -- time of enrollment.
5212: --
5213: hr_utility.set_location('Entering FDMELD',10);
5214: --
5215: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL) then
5216: hr_utility.set_location('Entering FDMELD',11);
5217: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
5218: fetch c_prtt_enrt_rslt_dts_bckdt into l_enrt_cvg_end_dt,
5219: l_enrt_cvg_strt_dt,

Line 5217: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);

5213: hr_utility.set_location('Entering FDMELD',10);
5214: --
5215: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL) then
5216: hr_utility.set_location('Entering FDMELD',11);
5217: open c_prtt_enrt_rslt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
5218: fetch c_prtt_enrt_rslt_dts_bckdt into l_enrt_cvg_end_dt,
5219: l_enrt_cvg_strt_dt,
5220: l_enrt_eff_strt_date;
5221: --

Line 5631: ,p_param2_value => fnd_date.date_to_canonical(nvl(p_fonm_rt_strt_dt,ben_manage_life_events.g_fonm_rt_strt_dt))

5627: ,p_param1 => p_param1
5628: ,p_param1_value => p_param1_value
5629: -- FONM
5630: ,p_param2 => 'BEN_IV_RT_STRT_DT'
5631: ,p_param2_value => fnd_date.date_to_canonical(nvl(p_fonm_rt_strt_dt,ben_manage_life_events.g_fonm_rt_strt_dt))
5632: ,p_param3 => 'BEN_IV_CVG_STRT_DT'
5633: ,p_param3_value => fnd_date.date_to_canonical(nvl(p_fonm_cvg_strt_dt,ben_manage_life_events.g_fonm_cvg_strt_dt))
5634: ,p_param4 => 'BEN_IV_PERSON_ID' -- Bug 5331889
5635: ,p_param4_value => to_char(p_person_id)

Line 5633: ,p_param3_value => fnd_date.date_to_canonical(nvl(p_fonm_cvg_strt_dt,ben_manage_life_events.g_fonm_cvg_strt_dt))

5629: -- FONM
5630: ,p_param2 => 'BEN_IV_RT_STRT_DT'
5631: ,p_param2_value => fnd_date.date_to_canonical(nvl(p_fonm_rt_strt_dt,ben_manage_life_events.g_fonm_rt_strt_dt))
5632: ,p_param3 => 'BEN_IV_CVG_STRT_DT'
5633: ,p_param3_value => fnd_date.date_to_canonical(nvl(p_fonm_cvg_strt_dt,ben_manage_life_events.g_fonm_cvg_strt_dt))
5634: ,p_param4 => 'BEN_IV_PERSON_ID' -- Bug 5331889
5635: ,p_param4_value => to_char(p_person_id)
5636: ,p_jurisdiction_code => l_jurisdiction_code);
5637: --

Line 7605: --l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

7601: l_oipl_id := p_oipl_id;
7602: l_enrt_perd_id := p_enrt_perd_id;
7603: l_lee_rsn_id := p_lee_rsn_id;
7604: l_enrt_perd_for_pl_id := p_enrt_perd_for_pl_id;
7605: --l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
7606: --
7607: elsif p_elig_per_elctbl_chc_id is not null then
7608: --
7609: if g_debug then

Line 7664: hr_utility.set_location('FONM FLAG ' || ben_manage_life_events.fonm , 60);

7660: end if;
7661: --
7662: if g_debug then
7663: hr_utility.set_location(l_proc , 60);
7664: hr_utility.set_location('FONM FLAG ' || ben_manage_life_events.fonm , 60);
7665: hr_utility.set_location('FONM gc date ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 60);
7666: hr_utility.set_location('FONM gr date ' || ben_manage_life_events.g_fonm_rt_strt_dt , 60);
7667: hr_utility.set_location('FONM epe date ' || l_fonm_cvg_strt_dt , 60);
7668: hr_utility.set_location('which date code ' || p_which_dates_cd , 60);

Line 7665: hr_utility.set_location('FONM gc date ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 60);

7661: --
7662: if g_debug then
7663: hr_utility.set_location(l_proc , 60);
7664: hr_utility.set_location('FONM FLAG ' || ben_manage_life_events.fonm , 60);
7665: hr_utility.set_location('FONM gc date ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 60);
7666: hr_utility.set_location('FONM gr date ' || ben_manage_life_events.g_fonm_rt_strt_dt , 60);
7667: hr_utility.set_location('FONM epe date ' || l_fonm_cvg_strt_dt , 60);
7668: hr_utility.set_location('which date code ' || p_which_dates_cd , 60);
7669: hr_utility.set_location('plan ' || p_pl_id , 60);

Line 7666: hr_utility.set_location('FONM gr date ' || ben_manage_life_events.g_fonm_rt_strt_dt , 60);

7662: if g_debug then
7663: hr_utility.set_location(l_proc , 60);
7664: hr_utility.set_location('FONM FLAG ' || ben_manage_life_events.fonm , 60);
7665: hr_utility.set_location('FONM gc date ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 60);
7666: hr_utility.set_location('FONM gr date ' || ben_manage_life_events.g_fonm_rt_strt_dt , 60);
7667: hr_utility.set_location('FONM epe date ' || l_fonm_cvg_strt_dt , 60);
7668: hr_utility.set_location('which date code ' || p_which_dates_cd , 60);
7669: hr_utility.set_location('plan ' || p_pl_id , 60);
7670:

Line 8404: if ben_manage_life_events.fonm = 'Y' or l_fonm_cvg_strt_dt is not null then

8400: if g_debug then
8401: hr_utility.set_location(' Dn SDC DETDT_MN '||l_proc , 670);
8402: end if;
8403: --- assign the fonm rat from the rate so the end date rule can use the fonm value
8404: if ben_manage_life_events.fonm = 'Y' or l_fonm_cvg_strt_dt is not null then
8405: if ben_manage_life_events.g_fonm_rt_strt_dt is null or
8406: ben_manage_life_events.g_fonm_rt_strt_dt <> l_rt_strt_dt then
8407: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt ;
8408: end if ;

Line 8405: if ben_manage_life_events.g_fonm_rt_strt_dt is null or

8401: hr_utility.set_location(' Dn SDC DETDT_MN '||l_proc , 670);
8402: end if;
8403: --- assign the fonm rat from the rate so the end date rule can use the fonm value
8404: if ben_manage_life_events.fonm = 'Y' or l_fonm_cvg_strt_dt is not null then
8405: if ben_manage_life_events.g_fonm_rt_strt_dt is null or
8406: ben_manage_life_events.g_fonm_rt_strt_dt <> l_rt_strt_dt then
8407: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt ;
8408: end if ;
8409: hr_utility.set_location('FONM gr date ' || ben_manage_life_events.g_fonm_rt_strt_dt , 60);

Line 8406: ben_manage_life_events.g_fonm_rt_strt_dt <> l_rt_strt_dt then

8402: end if;
8403: --- assign the fonm rat from the rate so the end date rule can use the fonm value
8404: if ben_manage_life_events.fonm = 'Y' or l_fonm_cvg_strt_dt is not null then
8405: if ben_manage_life_events.g_fonm_rt_strt_dt is null or
8406: ben_manage_life_events.g_fonm_rt_strt_dt <> l_rt_strt_dt then
8407: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt ;
8408: end if ;
8409: hr_utility.set_location('FONM gr date ' || ben_manage_life_events.g_fonm_rt_strt_dt , 60);
8410: end if ;

Line 8407: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt ;

8403: --- assign the fonm rat from the rate so the end date rule can use the fonm value
8404: if ben_manage_life_events.fonm = 'Y' or l_fonm_cvg_strt_dt is not null then
8405: if ben_manage_life_events.g_fonm_rt_strt_dt is null or
8406: ben_manage_life_events.g_fonm_rt_strt_dt <> l_rt_strt_dt then
8407: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt ;
8408: end if ;
8409: hr_utility.set_location('FONM gr date ' || ben_manage_life_events.g_fonm_rt_strt_dt , 60);
8410: end if ;
8411:

Line 8409: hr_utility.set_location('FONM gr date ' || ben_manage_life_events.g_fonm_rt_strt_dt , 60);

8405: if ben_manage_life_events.g_fonm_rt_strt_dt is null or
8406: ben_manage_life_events.g_fonm_rt_strt_dt <> l_rt_strt_dt then
8407: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt ;
8408: end if ;
8409: hr_utility.set_location('FONM gr date ' || ben_manage_life_events.g_fonm_rt_strt_dt , 60);
8410: end if ;
8411:
8412: end if;
8413:

Line 8490: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL

8486: if l_rt_strt_dt_cd in ( 'FDSMCFES' , 'FDSMFES' , 'LFMESMES' )
8487: and l_rt_strt_dt is NULL
8488: then
8489: --
8490: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL
8491: and l_rt_strt_dt_cd in ('LFMESMES') ) then
8492: open c_rt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
8493: fetch c_rt_dts_bckdt into l_rt_strt_dt,
8494: l_rt_end_dt;

Line 8492: open c_rt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);

8488: then
8489: --
8490: if(ben_manage_life_events.g_bckdt_per_in_ler_id is not NULL
8491: and l_rt_strt_dt_cd in ('LFMESMES') ) then
8492: open c_rt_dts_bckdt(ben_manage_life_events.g_bckdt_per_in_ler_id);
8493: fetch c_rt_dts_bckdt into l_rt_strt_dt,
8494: l_rt_end_dt;
8495: --
8496: close c_rt_dts_bckdt;