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 1294: l_mn_amt := fnd_number.canonical_to_number(l_mn_outputs(l_mn_outputs.first).value);

1290: p_jurisdiction_code => p_jurisdiction_code);
1291: --
1292: if l_mn_outputs(l_mn_outputs.first).value is not null then
1293: --
1294: l_mn_amt := fnd_number.canonical_to_number(l_mn_outputs(l_mn_outputs.first).value);
1295: --
1296: --Bug 4644489
1297: p_rstrn_mn_cvg_rqd_amt := l_mn_amt;
1298: -- Returing the mn_cvg_rqd_amt as defined by the rule

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

1325: p_jurisdiction_code => p_jurisdiction_code);
1326: --
1327: if l_mx_outputs(l_mx_outputs.first).value is not null then
1328: --
1329: l_mx_amt := fnd_number.canonical_to_number(l_mx_outputs(l_mx_outputs.first).value);
1330: --
1331: /* Start of Changes for WWBUG: 2054078: added */
1332: p_mx_cvg_wout_ctfn_val := l_mx_amt;
1333: /* Ended of Changes for WWBUG: 2054078: added */

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

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: --
2783: l_ultmt_upr_lmt := fnd_number.canonical_to_number(l_upr_outputs(l_upr_outputs.first).value);
2784: --
2785: end if;
2786: --
2787:

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

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: --
2821: l_ultmt_lwr_lmt := fnd_number.canonical_to_number(l_ult_lwr_outputs(l_ult_lwr_outputs.first).value);
2822: --
2823: end if;
2824: --
2825: end if;

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

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

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

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

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

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: --
4846: l_val := round_val(
4847: p_val => l_value,
4848: p_effective_date => p_effective_date,