DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DATE dependencies on BEN_MANAGE_LIFE_EVENTS

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

5448: ,p_param1 => p_param1
5449: ,p_param1_value => p_param1_value
5450: -- FONM
5451: ,p_param2 => 'BEN_IV_RT_STRT_DT'
5452: ,p_param2_value => fnd_date.date_to_canonical(nvl(p_fonm_rt_strt_dt,ben_manage_life_events.g_fonm_rt_strt_dt))
5453: ,p_param3 => 'BEN_IV_CVG_STRT_DT'
5454: ,p_param3_value => fnd_date.date_to_canonical(nvl(p_fonm_cvg_strt_dt,ben_manage_life_events.g_fonm_cvg_strt_dt))
5455: ,p_param4 => 'BEN_IV_PERSON_ID' -- Bug 5331889
5456: ,p_param4_value => to_char(p_person_id)

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

5450: -- FONM
5451: ,p_param2 => 'BEN_IV_RT_STRT_DT'
5452: ,p_param2_value => fnd_date.date_to_canonical(nvl(p_fonm_rt_strt_dt,ben_manage_life_events.g_fonm_rt_strt_dt))
5453: ,p_param3 => 'BEN_IV_CVG_STRT_DT'
5454: ,p_param3_value => fnd_date.date_to_canonical(nvl(p_fonm_cvg_strt_dt,ben_manage_life_events.g_fonm_cvg_strt_dt))
5455: ,p_param4 => 'BEN_IV_PERSON_ID' -- Bug 5331889
5456: ,p_param4_value => to_char(p_person_id)
5457: ,p_jurisdiction_code => l_jurisdiction_code);
5458: --

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

7400: l_oipl_id := p_oipl_id;
7401: l_enrt_perd_id := p_enrt_perd_id;
7402: l_lee_rsn_id := p_lee_rsn_id;
7403: l_enrt_perd_for_pl_id := p_enrt_perd_for_pl_id;
7404: --l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
7405: --
7406: elsif p_elig_per_elctbl_chc_id is not null then
7407: --
7408: if g_debug then

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

7459: end if;
7460: --
7461: if g_debug then
7462: hr_utility.set_location(l_proc , 60);
7463: hr_utility.set_location('FONM FLAG ' || ben_manage_life_events.fonm , 60);
7464: hr_utility.set_location('FONM gc date ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 60);
7465: hr_utility.set_location('FONM gr date ' || ben_manage_life_events.g_fonm_rt_strt_dt , 60);
7466: hr_utility.set_location('FONM epe date ' || l_fonm_cvg_strt_dt , 60);
7467: hr_utility.set_location('which date code ' || p_which_dates_cd , 60);

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

7460: --
7461: if g_debug then
7462: hr_utility.set_location(l_proc , 60);
7463: hr_utility.set_location('FONM FLAG ' || ben_manage_life_events.fonm , 60);
7464: hr_utility.set_location('FONM gc date ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 60);
7465: hr_utility.set_location('FONM gr date ' || ben_manage_life_events.g_fonm_rt_strt_dt , 60);
7466: hr_utility.set_location('FONM epe date ' || l_fonm_cvg_strt_dt , 60);
7467: hr_utility.set_location('which date code ' || p_which_dates_cd , 60);
7468: hr_utility.set_location('plan ' || p_pl_id , 60);

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

7461: if g_debug then
7462: hr_utility.set_location(l_proc , 60);
7463: hr_utility.set_location('FONM FLAG ' || ben_manage_life_events.fonm , 60);
7464: hr_utility.set_location('FONM gc date ' || ben_manage_life_events.g_fonm_cvg_strt_dt , 60);
7465: hr_utility.set_location('FONM gr date ' || ben_manage_life_events.g_fonm_rt_strt_dt , 60);
7466: hr_utility.set_location('FONM epe date ' || l_fonm_cvg_strt_dt , 60);
7467: hr_utility.set_location('which date code ' || p_which_dates_cd , 60);
7468: hr_utility.set_location('plan ' || p_pl_id , 60);
7469:

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

8199: if g_debug then
8200: hr_utility.set_location(' Dn SDC DETDT_MN '||l_proc , 670);
8201: end if;
8202: --- assign the fonm rat from the rate so the end date rule can use the fonm value
8203: if ben_manage_life_events.fonm = 'Y' or l_fonm_cvg_strt_dt is not null then
8204: if ben_manage_life_events.g_fonm_rt_strt_dt is null or
8205: ben_manage_life_events.g_fonm_rt_strt_dt <> l_rt_strt_dt then
8206: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt ;
8207: end if ;

Line 8204: if ben_manage_life_events.g_fonm_rt_strt_dt is null or

8200: hr_utility.set_location(' Dn SDC DETDT_MN '||l_proc , 670);
8201: end if;
8202: --- assign the fonm rat from the rate so the end date rule can use the fonm value
8203: if ben_manage_life_events.fonm = 'Y' or l_fonm_cvg_strt_dt is not null then
8204: if ben_manage_life_events.g_fonm_rt_strt_dt is null or
8205: ben_manage_life_events.g_fonm_rt_strt_dt <> l_rt_strt_dt then
8206: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt ;
8207: end if ;
8208: hr_utility.set_location('FONM gr date ' || ben_manage_life_events.g_fonm_rt_strt_dt , 60);

Line 8205: ben_manage_life_events.g_fonm_rt_strt_dt <> l_rt_strt_dt then

8201: end if;
8202: --- assign the fonm rat from the rate so the end date rule can use the fonm value
8203: if ben_manage_life_events.fonm = 'Y' or l_fonm_cvg_strt_dt is not null then
8204: if ben_manage_life_events.g_fonm_rt_strt_dt is null or
8205: ben_manage_life_events.g_fonm_rt_strt_dt <> l_rt_strt_dt then
8206: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt ;
8207: end if ;
8208: hr_utility.set_location('FONM gr date ' || ben_manage_life_events.g_fonm_rt_strt_dt , 60);
8209: end if ;

Line 8206: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt ;

8202: --- assign the fonm rat from the rate so the end date rule can use the fonm value
8203: if ben_manage_life_events.fonm = 'Y' or l_fonm_cvg_strt_dt is not null then
8204: if ben_manage_life_events.g_fonm_rt_strt_dt is null or
8205: ben_manage_life_events.g_fonm_rt_strt_dt <> l_rt_strt_dt then
8206: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt ;
8207: end if ;
8208: hr_utility.set_location('FONM gr date ' || ben_manage_life_events.g_fonm_rt_strt_dt , 60);
8209: end if ;
8210:

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

8204: if ben_manage_life_events.g_fonm_rt_strt_dt is null or
8205: ben_manage_life_events.g_fonm_rt_strt_dt <> l_rt_strt_dt then
8206: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt ;
8207: end if ;
8208: hr_utility.set_location('FONM gr date ' || ben_manage_life_events.g_fonm_rt_strt_dt , 60);
8209: end if ;
8210:
8211: end if;
8212: