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 ;
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:
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);
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
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;
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:
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);
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:
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);
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
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;
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: --
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(
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;
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: