DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTUAL_PREMIUM dependencies on BEN_MANAGE_LIFE_EVENTS

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

293: fetch c_epe into l_fonm_cvg_strt_dt1;
294: close c_epe;
295: hr_utility.set_location ('l_fonm_cvg_strt_dt1 -> '|| l_fonm_cvg_strt_dt1,10);
296: if l_fonm_cvg_strt_dt1 is not null then
297: ben_manage_life_events.fonm := 'Y';
298: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt1;
299: ben_manage_life_events.g_fonm_rt_strt_dt := p_fonm_rt_strt_dt;
300: end if;
301: hr_utility.set_location ('ben_manage_life_events.fonm -> '||ben_manage_life_events.fonm,10);

Line 298: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt1;

294: close c_epe;
295: hr_utility.set_location ('l_fonm_cvg_strt_dt1 -> '|| l_fonm_cvg_strt_dt1,10);
296: if l_fonm_cvg_strt_dt1 is not null then
297: ben_manage_life_events.fonm := 'Y';
298: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt1;
299: ben_manage_life_events.g_fonm_rt_strt_dt := p_fonm_rt_strt_dt;
300: end if;
301: hr_utility.set_location ('ben_manage_life_events.fonm -> '||ben_manage_life_events.fonm,10);
302: ------Bug 9135034

Line 299: ben_manage_life_events.g_fonm_rt_strt_dt := p_fonm_rt_strt_dt;

295: hr_utility.set_location ('l_fonm_cvg_strt_dt1 -> '|| l_fonm_cvg_strt_dt1,10);
296: if l_fonm_cvg_strt_dt1 is not null then
297: ben_manage_life_events.fonm := 'Y';
298: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt1;
299: ben_manage_life_events.g_fonm_rt_strt_dt := p_fonm_rt_strt_dt;
300: end if;
301: hr_utility.set_location ('ben_manage_life_events.fonm -> '||ben_manage_life_events.fonm,10);
302: ------Bug 9135034
303: if ben_manage_life_events.fonm = 'Y' then

Line 301: hr_utility.set_location ('ben_manage_life_events.fonm -> '||ben_manage_life_events.fonm,10);

297: ben_manage_life_events.fonm := 'Y';
298: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt1;
299: ben_manage_life_events.g_fonm_rt_strt_dt := p_fonm_rt_strt_dt;
300: end if;
301: hr_utility.set_location ('ben_manage_life_events.fonm -> '||ben_manage_life_events.fonm,10);
302: ------Bug 9135034
303: if ben_manage_life_events.fonm = 'Y' then
304: l_fonm_date := nvl(p_fonm_cvg_strt_dt, l_fonm_date ) ;
305: end if ;

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

299: ben_manage_life_events.g_fonm_rt_strt_dt := p_fonm_rt_strt_dt;
300: end if;
301: hr_utility.set_location ('ben_manage_life_events.fonm -> '||ben_manage_life_events.fonm,10);
302: ------Bug 9135034
303: if ben_manage_life_events.fonm = 'Y' then
304: l_fonm_date := nvl(p_fonm_cvg_strt_dt, l_fonm_date ) ;
305: end if ;
306: --eof FONM
307: /* -- 4031733 - cursor used to populate l_state.region_2

Line 763: l_fonm_flag varchar2(1) := ben_manage_life_events.fonm ;

759:
760: l_epr_elenum pls_integer;
761: -- Bof FONM
762: l_fonm_date date ;
763: l_fonm_flag varchar2(1) := ben_manage_life_events.fonm ;
764: l_fonm_cvg_strt_dt date ;
765: l_fonm_rt_strt_dt date ;
766: l_dummy_d date ;
767: l_fonm_per_rec per_all_people_f%rowtype;

Line 900: ben_manage_life_events.g_fonm_cvg_strt_dt := null ;

896: l_FONM_flag := 'Y' ;
897: else
898: l_FONM_flag := 'N' ;
899: l_FONM_date := nvl(p_lf_evt_ocrd_dt, p_effective_date) ;
900: ben_manage_life_events.g_fonm_cvg_strt_dt := null ;
901: ben_manage_life_events.fonm := 'N' ;
902: end if ;
903: hr_utility.set_location ('premium fonm -> '||l_FONM_flag,50);
904:

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

897: else
898: l_FONM_flag := 'N' ;
899: l_FONM_date := nvl(p_lf_evt_ocrd_dt, p_effective_date) ;
900: ben_manage_life_events.g_fonm_cvg_strt_dt := null ;
901: ben_manage_life_events.fonm := 'N' ;
902: end if ;
903: hr_utility.set_location ('premium fonm -> '||l_FONM_flag,50);
904:
905: if l_FONM_flag = 'Y' then

Line 910: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt ;

906:
907: if l_currepe_set(epe_elenum).fonm_cvg_strt_dt is not null then
908: l_FONM_date := l_currepe_set(epe_elenum).fonm_cvg_strt_dt ;
909: l_fonm_cvg_strt_dt:= l_currepe_set(epe_elenum).fonm_cvg_strt_dt ;
910: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt ;
911: ben_manage_life_events.fonm := 'Y' ;
912: end if ;
913:
914: /* -- for future

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

907: if l_currepe_set(epe_elenum).fonm_cvg_strt_dt is not null then
908: l_FONM_date := l_currepe_set(epe_elenum).fonm_cvg_strt_dt ;
909: l_fonm_cvg_strt_dt:= l_currepe_set(epe_elenum).fonm_cvg_strt_dt ;
910: ben_manage_life_events.g_fonm_cvg_strt_dt := l_fonm_cvg_strt_dt ;
911: ben_manage_life_events.fonm := 'Y' ;
912: end if ;
913:
914: /* -- for future
915: --- calcualte the rate start date

Line 930: hr_utility.set_location ('g_fonm_cvg_strt_dt '||ben_manage_life_events.g_fonm_cvg_strt_dt,50);

926: end if ;
927: */
928:
929: end if ;
930: hr_utility.set_location ('g_fonm_cvg_strt_dt '||ben_manage_life_events.g_fonm_cvg_strt_dt,50);
931: -- EOF FONM
932:
933: -- l_enrt_bnft_id := l_currepe_set(epe_elenum).enrt_bnft_id;
934: -- l_coverage_value := null;