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