DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ELIGIBILITY3 dependencies on BEN_MANAGE_LIFE_EVENTS

Line 82: if ben_manage_life_events.fonm = 'Y'

78: hr_utility.set_location('p_pl_id ' || p_pl_id ,99 );
79: hr_utility.set_location('p_opt_id ' || p_opt_id , 99 ) ;
80: -- hr_utility.set_location('Entering ' || l_package,10);
81: --FONM
82: if ben_manage_life_events.fonm = 'Y'
83: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
84: --
85: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
86: --

Line 83: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

79: hr_utility.set_location('p_opt_id ' || p_opt_id , 99 ) ;
80: -- hr_utility.set_location('Entering ' || l_package,10);
81: --FONM
82: if ben_manage_life_events.fonm = 'Y'
83: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
84: --
85: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
86: --
87: end if;

Line 85: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

81: --FONM
82: if ben_manage_life_events.fonm = 'Y'
83: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
84: --
85: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
86: --
87: end if;
88: --END FONM
89: --

Line 208: if ben_manage_life_events.fonm = 'Y'

204: if g_debug then
205: hr_utility.set_location('Entering : ' || l_proc, 10);
206: end if;
207: --
208: if ben_manage_life_events.fonm = 'Y'
209: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
210: --
211: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
212: --

Line 209: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

205: hr_utility.set_location('Entering : ' || l_proc, 10);
206: end if;
207: --
208: if ben_manage_life_events.fonm = 'Y'
209: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
210: --
211: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
212: --
213: end if;

Line 211: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

207: --
208: if ben_manage_life_events.fonm = 'Y'
209: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
210: --
211: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
212: --
213: end if;
214: --
215: if p_plip_id is not null then

Line 292: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),

288: p_pgm_id => nvl(p_pgm_id,l_ptip_rec.pgm_id),
289: p_opt_id => p_opt_id,
290: p_ler_id => l_pil_rec.ler_id,
291: p_param1 => 'BEN_IV_RT_STRT_DT',
292: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
293: p_param2 => 'BEN_IV_CVG_STRT_DT',
294: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
295: p_param3 => 'BEN_IV_PERSON_ID', -- Bug 5331889
296: p_param3_value => to_char(p_person_id),

Line 294: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),

290: p_ler_id => l_pil_rec.ler_id,
291: p_param1 => 'BEN_IV_RT_STRT_DT',
292: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
293: p_param2 => 'BEN_IV_CVG_STRT_DT',
294: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
295: p_param3 => 'BEN_IV_PERSON_ID', -- Bug 5331889
296: p_param3_value => to_char(p_person_id),
297: p_jurisdiction_code => l_jurisdiction_code);
298: --

Line 314: raise ben_manage_life_events.g_record_error;

310: --
311: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
312: fnd_message.set_token('RL','prtn_eff_strt_dt_rl');
313: fnd_message.set_token('PROC',l_proc);
314: raise ben_manage_life_events.g_record_error;
315: --
316: end;
317: --
318: end if;