DBA Data[Home] [Help]

APPS.BEN_DETERMINE_RATES dependencies on BEN_MANAGE_LIFE_EVENTS

Line 2275: ben_manage_life_events.fonm := 'Y';

2271: --
2272: ben_epe_cache.g_currepe_row := l_currepe_row;
2273:
2274: if l_currepe_row.fonm_cvg_strt_dt is not null then
2275: ben_manage_life_events.fonm := 'Y';
2276: -- assign the FONM CVG date before calling rate calcaultion
2277: if ben_manage_life_events.g_fonm_cvg_strt_dt is null or
2278: ben_manage_life_events.g_fonm_cvg_strt_dt <> l_currepe_row.fonm_cvg_strt_dt then
2279: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt ;

Line 2277: if ben_manage_life_events.g_fonm_cvg_strt_dt is null or

2273:
2274: if l_currepe_row.fonm_cvg_strt_dt is not null then
2275: ben_manage_life_events.fonm := 'Y';
2276: -- assign the FONM CVG date before calling rate calcaultion
2277: if ben_manage_life_events.g_fonm_cvg_strt_dt is null or
2278: ben_manage_life_events.g_fonm_cvg_strt_dt <> l_currepe_row.fonm_cvg_strt_dt then
2279: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt ;
2280: end if ;
2281:

Line 2278: ben_manage_life_events.g_fonm_cvg_strt_dt <> l_currepe_row.fonm_cvg_strt_dt then

2274: if l_currepe_row.fonm_cvg_strt_dt is not null then
2275: ben_manage_life_events.fonm := 'Y';
2276: -- assign the FONM CVG date before calling rate calcaultion
2277: if ben_manage_life_events.g_fonm_cvg_strt_dt is null or
2278: ben_manage_life_events.g_fonm_cvg_strt_dt <> l_currepe_row.fonm_cvg_strt_dt then
2279: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt ;
2280: end if ;
2281:
2282: hr_utility.set_location ('fonm cvg '||ben_manage_life_events.g_fonm_cvg_strt_dt ,10);

Line 2279: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt ;

2275: ben_manage_life_events.fonm := 'Y';
2276: -- assign the FONM CVG date before calling rate calcaultion
2277: if ben_manage_life_events.g_fonm_cvg_strt_dt is null or
2278: ben_manage_life_events.g_fonm_cvg_strt_dt <> l_currepe_row.fonm_cvg_strt_dt then
2279: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt ;
2280: end if ;
2281:
2282: hr_utility.set_location ('fonm cvg '||ben_manage_life_events.g_fonm_cvg_strt_dt ,10);
2283: else

Line 2282: hr_utility.set_location ('fonm cvg '||ben_manage_life_events.g_fonm_cvg_strt_dt ,10);

2278: ben_manage_life_events.g_fonm_cvg_strt_dt <> l_currepe_row.fonm_cvg_strt_dt then
2279: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt ;
2280: end if ;
2281:
2282: hr_utility.set_location ('fonm cvg '||ben_manage_life_events.g_fonm_cvg_strt_dt ,10);
2283: else
2284: ben_manage_life_events.fonm := 'N';
2285: ben_manage_life_events.g_fonm_rt_strt_dt := null;
2286: ben_manage_life_events.g_fonm_cvg_strt_dt := null;

Line 2284: ben_manage_life_events.fonm := 'N';

2280: end if ;
2281:
2282: hr_utility.set_location ('fonm cvg '||ben_manage_life_events.g_fonm_cvg_strt_dt ,10);
2283: else
2284: ben_manage_life_events.fonm := 'N';
2285: ben_manage_life_events.g_fonm_rt_strt_dt := null;
2286: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
2287: end if;
2288:

Line 2285: ben_manage_life_events.g_fonm_rt_strt_dt := null;

2281:
2282: hr_utility.set_location ('fonm cvg '||ben_manage_life_events.g_fonm_cvg_strt_dt ,10);
2283: else
2284: ben_manage_life_events.fonm := 'N';
2285: ben_manage_life_events.g_fonm_rt_strt_dt := null;
2286: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
2287: end if;
2288:
2289: hr_utility.set_location ('fonm ?'||ben_manage_life_events.fonm,10);

Line 2286: ben_manage_life_events.g_fonm_cvg_strt_dt := null;

2282: hr_utility.set_location ('fonm cvg '||ben_manage_life_events.g_fonm_cvg_strt_dt ,10);
2283: else
2284: ben_manage_life_events.fonm := 'N';
2285: ben_manage_life_events.g_fonm_rt_strt_dt := null;
2286: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
2287: end if;
2288:
2289: hr_utility.set_location ('fonm ?'||ben_manage_life_events.fonm,10);
2290:

Line 2289: hr_utility.set_location ('fonm ?'||ben_manage_life_events.fonm,10);

2285: ben_manage_life_events.g_fonm_rt_strt_dt := null;
2286: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
2287: end if;
2288:
2289: hr_utility.set_location ('fonm ?'||ben_manage_life_events.fonm,10);
2290:
2291: if ben_manage_life_events.fonm = 'Y' then
2292: hr_utility.set_location ('BDD_RACD '||l_package,10);
2293: hr_utility.set_location ('inside .. '||l_package,10);

Line 2291: if ben_manage_life_events.fonm = 'Y' then

2287: end if;
2288:
2289: hr_utility.set_location ('fonm ?'||ben_manage_life_events.fonm,10);
2290:
2291: if ben_manage_life_events.fonm = 'Y' then
2292: hr_utility.set_location ('BDD_RACD '||l_package,10);
2293: hr_utility.set_location ('inside .. '||l_package,10);
2294: ---Get the Corresponding Rate ID,Bug 8394662
2295: open c_get_rate(l_currepe_row.pgm_id,l_currepe_row.pl_id,l_currepe_row.opt_id,l_currepe_row.business_group_id);

Line 2336: if nvl(ben_manage_life_events.g_fonm_rt_strt_dt, hr_api.g_sot) <>

2332: --
2333: -- If previous rate start date and current date is different then
2334: -- clear the caches.
2335: --
2336: if nvl(ben_manage_life_events.g_fonm_rt_strt_dt, hr_api.g_sot) <>
2337: l_rt_strt_dt
2338: then
2339: --
2340: ben_use_cvg_rt_date.fonm_clear_down_cache;

Line 2341: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;

2337: l_rt_strt_dt
2338: then
2339: --
2340: ben_use_cvg_rt_date.fonm_clear_down_cache;
2341: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
2342: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt;
2343: --
2344: -- Get person info
2345: --

Line 2342: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt;

2338: then
2339: --
2340: ben_use_cvg_rt_date.fonm_clear_down_cache;
2341: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
2342: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt;
2343: --
2344: -- Get person info
2345: --
2346: ben_person_object.get_object(

Line 2367: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;

2363: p_person_id => p_person_id,
2364: p_rec => l_adr_row);
2365: end if;
2366: --
2367: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
2368: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt;
2369: l_effective_date := l_rt_strt_dt;
2370:
2371: end if;

Line 2368: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt;

2364: p_rec => l_adr_row);
2365: end if;
2366: --
2367: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
2368: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt;
2369: l_effective_date := l_rt_strt_dt;
2370:
2371: end if;
2372: