DBA Data[Home] [Help]

APPS.BEN_DETERMINE_RATES dependencies on BEN_MANAGE_LIFE_EVENTS

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

2255: --
2256: ben_epe_cache.g_currepe_row := l_currepe_row;
2257:
2258: if l_currepe_row.fonm_cvg_strt_dt is not null then
2259: ben_manage_life_events.fonm := 'Y';
2260: -- assign the FONM CVG date before calling rate calcaultion
2261: if ben_manage_life_events.g_fonm_cvg_strt_dt is null or
2262: ben_manage_life_events.g_fonm_cvg_strt_dt <> l_currepe_row.fonm_cvg_strt_dt then
2263: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt ;

Line 2261: if ben_manage_life_events.g_fonm_cvg_strt_dt is null or

2257:
2258: if l_currepe_row.fonm_cvg_strt_dt is not null then
2259: ben_manage_life_events.fonm := 'Y';
2260: -- assign the FONM CVG date before calling rate calcaultion
2261: if ben_manage_life_events.g_fonm_cvg_strt_dt is null or
2262: ben_manage_life_events.g_fonm_cvg_strt_dt <> l_currepe_row.fonm_cvg_strt_dt then
2263: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt ;
2264: end if ;
2265:

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

2258: if l_currepe_row.fonm_cvg_strt_dt is not null then
2259: ben_manage_life_events.fonm := 'Y';
2260: -- assign the FONM CVG date before calling rate calcaultion
2261: if ben_manage_life_events.g_fonm_cvg_strt_dt is null or
2262: ben_manage_life_events.g_fonm_cvg_strt_dt <> l_currepe_row.fonm_cvg_strt_dt then
2263: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt ;
2264: end if ;
2265:
2266: hr_utility.set_location ('fonm cvg '||ben_manage_life_events.g_fonm_cvg_strt_dt ,10);

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

2259: ben_manage_life_events.fonm := 'Y';
2260: -- assign the FONM CVG date before calling rate calcaultion
2261: if ben_manage_life_events.g_fonm_cvg_strt_dt is null or
2262: ben_manage_life_events.g_fonm_cvg_strt_dt <> l_currepe_row.fonm_cvg_strt_dt then
2263: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt ;
2264: end if ;
2265:
2266: hr_utility.set_location ('fonm cvg '||ben_manage_life_events.g_fonm_cvg_strt_dt ,10);
2267: else

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

2262: ben_manage_life_events.g_fonm_cvg_strt_dt <> l_currepe_row.fonm_cvg_strt_dt then
2263: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt ;
2264: end if ;
2265:
2266: hr_utility.set_location ('fonm cvg '||ben_manage_life_events.g_fonm_cvg_strt_dt ,10);
2267: else
2268: ben_manage_life_events.fonm := 'N';
2269: ben_manage_life_events.g_fonm_rt_strt_dt := null;
2270: ben_manage_life_events.g_fonm_cvg_strt_dt := null;

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

2264: end if ;
2265:
2266: hr_utility.set_location ('fonm cvg '||ben_manage_life_events.g_fonm_cvg_strt_dt ,10);
2267: else
2268: ben_manage_life_events.fonm := 'N';
2269: ben_manage_life_events.g_fonm_rt_strt_dt := null;
2270: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
2271: end if;
2272:

Line 2269: ben_manage_life_events.g_fonm_rt_strt_dt := null;

2265:
2266: hr_utility.set_location ('fonm cvg '||ben_manage_life_events.g_fonm_cvg_strt_dt ,10);
2267: else
2268: ben_manage_life_events.fonm := 'N';
2269: ben_manage_life_events.g_fonm_rt_strt_dt := null;
2270: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
2271: end if;
2272:
2273: hr_utility.set_location ('fonm ?'||ben_manage_life_events.fonm,10);

Line 2270: ben_manage_life_events.g_fonm_cvg_strt_dt := null;

2266: hr_utility.set_location ('fonm cvg '||ben_manage_life_events.g_fonm_cvg_strt_dt ,10);
2267: else
2268: ben_manage_life_events.fonm := 'N';
2269: ben_manage_life_events.g_fonm_rt_strt_dt := null;
2270: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
2271: end if;
2272:
2273: hr_utility.set_location ('fonm ?'||ben_manage_life_events.fonm,10);
2274:

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

2269: ben_manage_life_events.g_fonm_rt_strt_dt := null;
2270: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
2271: end if;
2272:
2273: hr_utility.set_location ('fonm ?'||ben_manage_life_events.fonm,10);
2274:
2275: if ben_manage_life_events.fonm = 'Y' then
2276: hr_utility.set_location ('BDD_RACD '||l_package,10);
2277: hr_utility.set_location ('inside .. '||l_package,10);

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

2271: end if;
2272:
2273: hr_utility.set_location ('fonm ?'||ben_manage_life_events.fonm,10);
2274:
2275: if ben_manage_life_events.fonm = 'Y' then
2276: hr_utility.set_location ('BDD_RACD '||l_package,10);
2277: hr_utility.set_location ('inside .. '||l_package,10);
2278: ben_determine_date.rate_and_coverage_dates
2279: (p_cache_mode => TRUE

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

2312: --
2313: -- If previous rate start date and current date is different then
2314: -- clear the caches.
2315: --
2316: if nvl(ben_manage_life_events.g_fonm_rt_strt_dt, hr_api.g_sot) <>
2317: l_rt_strt_dt
2318: then
2319: --
2320: ben_use_cvg_rt_date.fonm_clear_down_cache;

Line 2321: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;

2317: l_rt_strt_dt
2318: then
2319: --
2320: ben_use_cvg_rt_date.fonm_clear_down_cache;
2321: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
2322: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt;
2323: --
2324: -- Get person info
2325: --

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

2318: then
2319: --
2320: ben_use_cvg_rt_date.fonm_clear_down_cache;
2321: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
2322: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt;
2323: --
2324: -- Get person info
2325: --
2326: ben_person_object.get_object(

Line 2347: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;

2343: p_person_id => p_person_id,
2344: p_rec => l_adr_row);
2345: end if;
2346: --
2347: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
2348: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt;
2349: l_effective_date := l_rt_strt_dt;
2350:
2351: end if;

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

2344: p_rec => l_adr_row);
2345: end if;
2346: --
2347: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
2348: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt;
2349: l_effective_date := l_rt_strt_dt;
2350:
2351: end if;
2352: