DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COVERAGE dependencies on FND_NUMBER

Line 321: 06-jun-05 nhunur 115.138 4383988 - apply fnd_number on what FF returns in numeric variable.

317: 30-Mar-05 kmahendr 115.136 Bug#4256191 - rule evaluated before
318: determining the least amount
319: 18-Apr-05 ssarkar 115.137 Bug# 4275929 : max_witout_cert is passed to max_with_cert ,
320: when null, while calling get_least_value proc.
321: 06-jun-05 nhunur 115.138 4383988 - apply fnd_number on what FF returns in numeric variable.
322: 30-Jun-05 ikasire 115.139 BUG 4449437 always setting the default flag to N for FLFXPCL
323: 19-jul-05 rgajula 115.140 Bug 4436573 Added a new parameter p_cvg_mlt_cd to the
324: ben_determine_coverage.chk_bnft_ctfn to perform few more
325: validations to set the certification required flag of ben_enrt_bnft.

Line 1333: l_mn_amt := fnd_number.canonical_to_number(l_mn_outputs(l_mn_outputs.first).value);

1329: p_jurisdiction_code => p_jurisdiction_code);
1330: --
1331: if l_mn_outputs(l_mn_outputs.first).value is not null then
1332: --
1333: l_mn_amt := fnd_number.canonical_to_number(l_mn_outputs(l_mn_outputs.first).value);
1334: --
1335: --Bug 4644489
1336: p_rstrn_mn_cvg_rqd_amt := l_mn_amt;
1337: -- Returing the mn_cvg_rqd_amt as defined by the rule

Line 1368: l_mx_amt := fnd_number.canonical_to_number(l_mx_outputs(l_mx_outputs.first).value);

1364: p_jurisdiction_code => p_jurisdiction_code);
1365: --
1366: if l_mx_outputs(l_mx_outputs.first).value is not null then
1367: --
1368: l_mx_amt := fnd_number.canonical_to_number(l_mx_outputs(l_mx_outputs.first).value);
1369: --
1370: /* Start of Changes for WWBUG: 2054078: added */
1371: p_mx_cvg_wout_ctfn_val := l_mx_amt;
1372: /* Ended of Changes for WWBUG: 2054078: added */

Line 3103: l_ultmt_upr_lmt := fnd_number.canonical_to_number(l_upr_outputs(l_upr_outputs.first).value);

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: --
3103: l_ultmt_upr_lmt := fnd_number.canonical_to_number(l_upr_outputs(l_upr_outputs.first).value);
3104: --
3105: end if;
3106: --
3107:

Line 3141: l_ultmt_lwr_lmt := fnd_number.canonical_to_number(l_ult_lwr_outputs(l_ult_lwr_outputs.first).value);

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: --
3141: l_ultmt_lwr_lmt := fnd_number.canonical_to_number(l_ult_lwr_outputs(l_ult_lwr_outputs.first).value);
3142: --
3143: end if;
3144: --
3145: end if;

Line 3743: l_lwr_val := fnd_number.canonical_to_number(l_lwr_outputs(l_lwr_outputs.first).value);

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
3746: l_lwr_val := l_cvg(0).lwr_lmt_val;
3747: end if;

Line 3768: l_upr_val := fnd_number.canonical_to_number(l_upr_outputs(l_upr_outputs.first).value);

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
3771: l_upr_val := l_cvg(0).upr_lmt_val;
3772: end if;

Line 5337: l_value := fnd_number.canonical_to_number(l_outputs(l_outputs.first).value);

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: --
5339: l_val := round_val(
5340: p_val => l_value,
5341: p_effective_date => p_effective_date,