DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COVERAGE dependencies on BEN_MANAGE_LIFE_EVENTS

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

776: --
777: hr_utility.set_location ('Entering '||l_package,10);
778: --
779: -- FONM
780: if ben_manage_life_events.fonm = 'Y' then
781: --
782: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;
783: --
784: end if;

Line 782: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;

778: --
779: -- FONM
780: if ben_manage_life_events.fonm = 'Y' then
781: --
782: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;
783: --
784: end if;
785: --
786: l_val := p_val;

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

1320: p_ler_id => p_ler_id,
1321: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1322: -- FONM
1323: p_param1 => 'BEN_IV_RT_STRT_DT',
1324: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1325: p_param2 => 'BEN_IV_CVG_STRT_DT',
1326: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
1327: p_param3 => 'BEN_IV_PERSON_ID', -- Bug 5331889
1328: p_param3_value => to_char(l_person_id),

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

1322: -- FONM
1323: p_param1 => 'BEN_IV_RT_STRT_DT',
1324: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1325: p_param2 => 'BEN_IV_CVG_STRT_DT',
1326: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
1327: p_param3 => 'BEN_IV_PERSON_ID', -- Bug 5331889
1328: p_param3_value => to_char(l_person_id),
1329: p_jurisdiction_code => p_jurisdiction_code);
1330: --

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

1355: p_ler_id => p_ler_id,
1356: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1357: -- FONM
1358: p_param1 => 'BEN_IV_RT_STRT_DT',
1359: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1360: p_param2 => 'BEN_IV_CVG_STRT_DT',
1361: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
1362: p_param3 => 'BEN_IV_PERSON_ID', -- Bug 5331889
1363: p_param3_value => to_char(l_person_id),

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

1357: -- FONM
1358: p_param1 => 'BEN_IV_RT_STRT_DT',
1359: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1360: p_param2 => 'BEN_IV_CVG_STRT_DT',
1361: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
1362: p_param3 => 'BEN_IV_PERSON_ID', -- Bug 5331889
1363: p_param3_value => to_char(l_person_id),
1364: p_jurisdiction_code => p_jurisdiction_code);
1365: --

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

2354: l_effective_date := p_effective_date;
2355: --
2356: end if;
2357: -- FONM
2358: if ben_manage_life_events.fonm = 'Y' then
2359: --
2360: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;
2361: --
2362: end if;

Line 2360: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;

2356: end if;
2357: -- FONM
2358: if ben_manage_life_events.fonm = 'Y' then
2359: --
2360: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;
2361: --
2362: end if;
2363: --
2364: -- put a row into fnd_sessions

Line 2585: raise ben_manage_life_events.g_record_error;

2581: );
2582:
2583: fnd_message.set_token('COMP_CODE',l_clf.name);
2584: fnd_message.set_token('PACKAGE',l_package);
2585: raise ben_manage_life_events.g_record_error;
2586: --
2587: end if;
2588: --
2589: end if;

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

3092: p_opt_id => l_opt.opt_id,
3093: p_ler_id => l_epe.ler_id,
3094: -- FONM
3095: p_param1 => 'BEN_IV_RT_STRT_DT',
3096: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
3097: p_param2 => 'BEN_IV_CVG_STRT_DT',
3098: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
3099: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id);
3100: --

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

3094: -- FONM
3095: p_param1 => 'BEN_IV_RT_STRT_DT',
3096: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
3097: p_param2 => 'BEN_IV_CVG_STRT_DT',
3098: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
3099: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id);
3100: --
3101: if l_upr_outputs(l_upr_outputs.first).value is not null then
3102: --

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

3130: p_opt_id => l_opt.opt_id,
3131: p_ler_id => l_epe.ler_id,
3132: -- FONM
3133: p_param1 => 'BEN_IV_RT_STRT_DT',
3134: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
3135: p_param2 => 'BEN_IV_CVG_STRT_DT',
3136: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
3137: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id);
3138: --

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

3132: -- FONM
3133: p_param1 => 'BEN_IV_RT_STRT_DT',
3134: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
3135: p_param2 => 'BEN_IV_CVG_STRT_DT',
3136: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
3137: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id);
3138: --
3139: if l_ult_lwr_outputs(l_ult_lwr_outputs.first).value is not null then
3140: --

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

3735: p_opt_id => l_opt.opt_id,
3736: p_ler_id => l_epe.ler_id,
3737: -- FONM
3738: p_param1 => 'BEN_IV_RT_STRT_DT',
3739: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
3740: p_param2 => 'BEN_IV_CVG_STRT_DT',
3741: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
3742: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id);
3743: l_lwr_val := fnd_number.canonical_to_number(l_lwr_outputs(l_lwr_outputs.first).value);

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

3737: -- FONM
3738: p_param1 => 'BEN_IV_RT_STRT_DT',
3739: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
3740: p_param2 => 'BEN_IV_CVG_STRT_DT',
3741: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
3742: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id);
3743: l_lwr_val := fnd_number.canonical_to_number(l_lwr_outputs(l_lwr_outputs.first).value);
3744: --
3745: elsif l_cvg(0).lwr_lmt_val is not null then

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

3760: p_opt_id => l_opt.opt_id,
3761: p_ler_id => l_epe.ler_id,
3762: -- FONM
3763: p_param1 => 'BEN_IV_RT_STRT_DT',
3764: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
3765: p_param2 => 'BEN_IV_CVG_STRT_DT',
3766: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
3767: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id);
3768: l_upr_val := fnd_number.canonical_to_number(l_upr_outputs(l_upr_outputs.first).value);

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

3762: -- FONM
3763: p_param1 => 'BEN_IV_RT_STRT_DT',
3764: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
3765: p_param2 => 'BEN_IV_CVG_STRT_DT',
3766: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
3767: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id);
3768: l_upr_val := fnd_number.canonical_to_number(l_upr_outputs(l_upr_outputs.first).value);
3769: --
3770: elsif l_cvg(0).upr_lmt_val is not null then

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

5328: p_ler_id => l_epe.ler_id,
5329: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
5330: -- FONM
5331: p_param1 => 'BEN_IV_RT_STRT_DT',
5332: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
5333: p_param2 => 'BEN_IV_CVG_STRT_DT',
5334: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
5335: p_jurisdiction_code => l_jurisdiction_code);
5336: --

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

5330: -- FONM
5331: p_param1 => 'BEN_IV_RT_STRT_DT',
5332: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
5333: p_param2 => 'BEN_IV_CVG_STRT_DT',
5334: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
5335: p_jurisdiction_code => l_jurisdiction_code);
5336: --
5337: l_value := fnd_number.canonical_to_number(l_outputs(l_outputs.first).value);
5338: --