DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COVERAGE dependencies on BEN_MANAGE_LIFE_EVENTS

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

737: --
738: hr_utility.set_location ('Entering '||l_package,10);
739: --
740: -- FONM
741: if ben_manage_life_events.fonm = 'Y' then
742: --
743: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;
744: --
745: end if;

Line 743: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;

739: --
740: -- FONM
741: if ben_manage_life_events.fonm = 'Y' then
742: --
743: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;
744: --
745: end if;
746: --
747: l_val := p_val;

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

1281: p_ler_id => p_ler_id,
1282: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1283: -- FONM
1284: p_param1 => 'BEN_IV_RT_STRT_DT',
1285: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1286: p_param2 => 'BEN_IV_CVG_STRT_DT',
1287: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
1288: p_param3 => 'BEN_IV_PERSON_ID', -- Bug 5331889
1289: p_param3_value => to_char(l_person_id),

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

1283: -- FONM
1284: p_param1 => 'BEN_IV_RT_STRT_DT',
1285: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
1286: p_param2 => 'BEN_IV_CVG_STRT_DT',
1287: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
1288: p_param3 => 'BEN_IV_PERSON_ID', -- Bug 5331889
1289: p_param3_value => to_char(l_person_id),
1290: p_jurisdiction_code => p_jurisdiction_code);
1291: --

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

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

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

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

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

2090: l_effective_date := p_effective_date;
2091: --
2092: end if;
2093: -- FONM
2094: if ben_manage_life_events.fonm = 'Y' then
2095: --
2096: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;
2097: --
2098: end if;

Line 2096: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;

2092: end if;
2093: -- FONM
2094: if ben_manage_life_events.fonm = 'Y' then
2095: --
2096: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt;
2097: --
2098: end if;
2099: --
2100: -- put a row into fnd_sessions

Line 2321: raise ben_manage_life_events.g_record_error;

2317: );
2318:
2319: fnd_message.set_token('COMP_CODE',l_clf.name);
2320: fnd_message.set_token('PACKAGE',l_package);
2321: raise ben_manage_life_events.g_record_error;
2322: --
2323: end if;
2324: --
2325: end if;

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

2772: p_opt_id => l_opt.opt_id,
2773: p_ler_id => l_epe.ler_id,
2774: -- FONM
2775: p_param1 => 'BEN_IV_RT_STRT_DT',
2776: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
2777: p_param2 => 'BEN_IV_CVG_STRT_DT',
2778: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
2779: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id);
2780: --

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

2774: -- FONM
2775: p_param1 => 'BEN_IV_RT_STRT_DT',
2776: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
2777: p_param2 => 'BEN_IV_CVG_STRT_DT',
2778: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
2779: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id);
2780: --
2781: if l_upr_outputs(l_upr_outputs.first).value is not null then
2782: --

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

2810: p_opt_id => l_opt.opt_id,
2811: p_ler_id => l_epe.ler_id,
2812: -- FONM
2813: p_param1 => 'BEN_IV_RT_STRT_DT',
2814: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
2815: p_param2 => 'BEN_IV_CVG_STRT_DT',
2816: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
2817: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id);
2818: --

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

2812: -- FONM
2813: p_param1 => 'BEN_IV_RT_STRT_DT',
2814: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
2815: p_param2 => 'BEN_IV_CVG_STRT_DT',
2816: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
2817: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id);
2818: --
2819: if l_ult_lwr_outputs(l_ult_lwr_outputs.first).value is not null then
2820: --

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

3415: p_opt_id => l_opt.opt_id,
3416: p_ler_id => l_epe.ler_id,
3417: -- FONM
3418: p_param1 => 'BEN_IV_RT_STRT_DT',
3419: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
3420: p_param2 => 'BEN_IV_CVG_STRT_DT',
3421: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
3422: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id);
3423: l_lwr_val := fnd_number.canonical_to_number(l_lwr_outputs(l_lwr_outputs.first).value);

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

3417: -- FONM
3418: p_param1 => 'BEN_IV_RT_STRT_DT',
3419: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
3420: p_param2 => 'BEN_IV_CVG_STRT_DT',
3421: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
3422: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id);
3423: l_lwr_val := fnd_number.canonical_to_number(l_lwr_outputs(l_lwr_outputs.first).value);
3424: --
3425: elsif l_cvg(0).lwr_lmt_val is not null then

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

3440: p_opt_id => l_opt.opt_id,
3441: p_ler_id => l_epe.ler_id,
3442: -- FONM
3443: p_param1 => 'BEN_IV_RT_STRT_DT',
3444: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
3445: p_param2 => 'BEN_IV_CVG_STRT_DT',
3446: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
3447: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id);
3448: l_upr_val := fnd_number.canonical_to_number(l_upr_outputs(l_upr_outputs.first).value);

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

3442: -- FONM
3443: p_param1 => 'BEN_IV_RT_STRT_DT',
3444: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
3445: p_param2 => 'BEN_IV_CVG_STRT_DT',
3446: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
3447: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id);
3448: l_upr_val := fnd_number.canonical_to_number(l_upr_outputs(l_upr_outputs.first).value);
3449: --
3450: elsif l_cvg(0).upr_lmt_val is not null then

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

4835: p_ler_id => l_epe.ler_id,
4836: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
4837: -- FONM
4838: p_param1 => 'BEN_IV_RT_STRT_DT',
4839: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
4840: p_param2 => 'BEN_IV_CVG_STRT_DT',
4841: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
4842: p_jurisdiction_code => l_jurisdiction_code);
4843: --

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

4837: -- FONM
4838: p_param1 => 'BEN_IV_RT_STRT_DT',
4839: p_param1_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_rt_strt_dt),
4840: p_param2 => 'BEN_IV_CVG_STRT_DT',
4841: p_param2_value => fnd_date.date_to_canonical(ben_manage_life_events.g_fonm_cvg_strt_dt),
4842: p_jurisdiction_code => l_jurisdiction_code);
4843: --
4844: l_value := fnd_number.canonical_to_number(l_outputs(l_outputs.first).value);
4845: --