eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DETERMINE_COVERAGE dependencies on BEN_DETERMINE_COVERAGE

Line 1: Package Body BEN_DETERMINE_COVERAGE as

1: Package Body BEN_DETERMINE_COVERAGE as
2: /* $Header: bencvrge.pkb 120.45.12020000.2 2012/07/03 12:18:11 amnaraya ship $ */
3: --------------------------------------------------------------------------------
4: /*
5: +==============================================================================+

Line 324: ben_determine_coverage.chk_bnft_ctfn to perform few more

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.
326: 25-Sep-05 kmahendr 115.141 Bug#4630782 - in unrestricted mode inelig
327: process not called
328: 27-Sep-05 ikasire 115.142 Bug 4627840

Line 331: ben_determine_coverage.chk_bnft_ctfn to return the minimum coverage amount

327: process not called
328: 27-Sep-05 ikasire 115.142 Bug 4627840
329: 04-Oct-05 ikasire 115.143 Bug 4649262 ERL fix regression from 4436573
330: 20-oct-05 rgajula 115.144 Bug 4644489 Added an additional parameter p_rstrn_mn_cvg_rqd_amt
331: ben_determine_coverage.chk_bnft_ctfn to return the minimum coverage amount
332: as calculated by the minium rule in coverage restrictions, the out parameter will
333: will return the amount as calculated by the rule or the min value in the min feild in retrictions.
334: This returned value is used in the write record for Flat Amount Calculation method as
335: max(cvg_rstrn_amount,cvg_calc_mthd_min_amnt).

Line 399: g_package varchar2(80) := 'ben_determine_coverage';

395: present in ben_elctbl_chc_ctfn table.
396: */
397: -------------------------------------------------------------------------------------------------------------------------------------------------
398: --
399: g_package varchar2(80) := 'ben_determine_coverage';
400: g_old_val number;
401: --
402: --
403: FUNCTION round_val

Line 523: ,p_enb_valrow out nocopy ben_determine_coverage.ENBValType

519: ,p_ordr_num in number
520: ,p_ctfn_rqd_flag in varchar2
521: --
522: ,p_enrt_bnft_id out nocopy number
523: ,p_enb_valrow out nocopy ben_determine_coverage.ENBValType
524: --
525: ,p_ultmt_upr_lmt in number default null
526: ,p_ultmt_lwr_lmt in number default null
527: ,p_ultmt_upr_lmt_calc_rl in number default null

Line 1539: ,p_enb_valrow out nocopy ben_determine_coverage.ENBValType

1535: ,p_effective_date IN date
1536: ,p_lf_evt_ocrd_dt IN date
1537: ,p_perform_rounding_flg IN boolean
1538: --
1539: ,p_enb_valrow out nocopy ben_determine_coverage.ENBValType
1540: )
1541: is
1542: --
1543: l_package varchar2(80) := g_package||'.main';

Line 2131: l_proc varchar2(70) :='ben_determine_coverage.write_ctfn';

2127: select ENTR_VAL_AT_ENRT_FLAG
2128: from ben_enrt_bnft
2129: where enrt_bnft_id = l_enrt_bnft_id;
2130:
2131: l_proc varchar2(70) :='ben_determine_coverage.write_ctfn';
2132: l_entr_val_at_enrt_flag varchar2(1):= 'N';
2133:
2134: --Bug 14137476
2135: begin

Line 2955: ben_determine_coverage.combine_with_variable_val

2951: p_state => l_state.region_2);
2952:
2953: hr_utility.set_location (' CMC FLFX ',10);
2954: --
2955: ben_determine_coverage.combine_with_variable_val
2956: (p_vr_val => l_vr_val,
2957: p_val => l_val,
2958: p_vr_trtmt_cd => l_vr_trtmt_cd,
2959: p_combined_val => l_combined_val);

Line 2988: ben_determine_coverage.chk_bnft_ctfn

2984: end if;
2985: --rtagarra
2986: if l_rstrn_found then
2987: --
2988: ben_determine_coverage.chk_bnft_ctfn
2989: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
2990: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
2991: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
2992: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 3166: ben_determine_coverage.write_coverage

3162: hr_utility.set_location('l_combined_val = ' || l_combined_val, 9999);
3163: hr_utility.set_location('l_cvg_amount = ' || l_cvg_amount, 9999);
3164: hr_utility.set_location('l_dflt_elcn_val = ' || l_dflt_elcn_val, 9999);
3165: --
3166: ben_determine_coverage.write_coverage
3167: (p_calculate_only_mode => p_calculate_only_mode,
3168: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
3169: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
3170: p_val => l_combined_val,

Line 3433: ben_determine_coverage.write_coverage

3429: end if;
3430: l_epe.elctbl_flag:='N';
3431: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);
3432: end if;
3433: ben_determine_coverage.write_coverage
3434: (p_calculate_only_mode => p_calculate_only_mode,
3435: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
3436: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
3437: p_val => l_combined_val,

Line 3524: ben_determine_coverage.combine_with_variable_val

3520: p_state => l_state.region_2);
3521:
3522: ---
3523: hr_utility.set_location (' rndg is'||l_val,10);
3524: ben_determine_coverage.combine_with_variable_val
3525: (p_vr_val => l_vr_val,
3526: p_val => l_val,
3527: p_vr_trtmt_cd => l_vr_trtmt_cd,
3528: p_combined_val => l_combined_val);

Line 3534: ben_determine_coverage.chk_bnft_ctfn

3530: hr_utility.set_location (' varb is'||l_combined_val,10);
3531: --
3532: if l_rstrn_found then
3533: --
3534: ben_determine_coverage.chk_bnft_ctfn
3535: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
3536: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
3537: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
3538: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 3578: ben_determine_coverage.write_coverage

3574: end if;
3575: --
3576: if l_write_rec then
3577: --
3578: ben_determine_coverage.write_coverage
3579: (p_calculate_only_mode => p_calculate_only_mode,
3580: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
3581: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
3582: p_val => l_combined_val,

Line 3669: ben_determine_coverage.write_coverage

3665: --
3666: l_epe.elctbl_flag:='N';
3667: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);
3668: end if;
3669: ben_determine_coverage.write_coverage
3670: (p_calculate_only_mode => p_calculate_only_mode,
3671: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
3672: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
3673: p_val => l_combined_val,

Line 3831: ben_determine_coverage.combine_with_variable_val

3827: p_val => l_val,
3828: p_state => l_state.region_2);
3829:
3830: --
3831: ben_determine_coverage.combine_with_variable_val
3832: (p_vr_val => l_vr_val,
3833: p_val => l_val,
3834: p_vr_trtmt_cd => l_vr_trtmt_cd,
3835: p_combined_val => l_combined_val);

Line 3880: ben_determine_coverage.chk_bnft_ctfn

3876: end if;
3877:
3878: if l_rstrn_found then
3879:
3880: ben_determine_coverage.chk_bnft_ctfn
3881: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
3882: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
3883: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
3884: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 3926: ben_determine_coverage.write_coverage

3922: if l_write_rec then
3923: --
3924: hr_utility.set_location('Writing coverage ',35);
3925: --
3926: ben_determine_coverage.write_coverage
3927: (p_calculate_only_mode => p_calculate_only_mode,
3928: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
3929: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
3930: p_val => l_combined_val,

Line 4142: ben_determine_coverage.combine_with_variable_val

4138: p_ler_id => l_epe.ler_id,
4139: p_val => l_val,
4140: p_state => l_state.region_2);
4141:
4142: ben_determine_coverage.combine_with_variable_val
4143: (p_vr_val => l_vr_val,
4144: p_val => l_val,
4145: p_vr_trtmt_cd => l_vr_trtmt_cd,
4146: p_combined_val => l_combined_val);

Line 4176: ben_determine_coverage.chk_bnft_ctfn

4172: end if;
4173:
4174: if l_rstrn_found then
4175: --
4176: ben_determine_coverage.chk_bnft_ctfn
4177: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
4178: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
4179: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
4180: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 4230: ben_determine_coverage.write_coverage

4226: close c_opt;
4227: --
4228: end if;
4229: --
4230: ben_determine_coverage.write_coverage
4231: (p_calculate_only_mode => p_calculate_only_mode,
4232: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
4233: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
4234: p_val => l_combined_val,

Line 4427: ben_determine_coverage.combine_with_variable_val

4423: p_ler_id => l_epe.ler_id,
4424: p_val => l_tot_val, -- 3095224,
4425: p_state => l_state.region_2);
4426:
4427: ben_determine_coverage.combine_with_variable_val
4428: (p_vr_val => l_vr_val,
4429: p_val => l_tot_val, -- 3095224 l_val+l_cvg(0).val,
4430: p_vr_trtmt_cd => l_vr_trtmt_cd,
4431: p_combined_val => l_combined_val);

Line 4435: ben_determine_coverage.chk_bnft_ctfn

4431: p_combined_val => l_combined_val);
4432: --
4433: if l_rstrn_found then
4434: --
4435: ben_determine_coverage.chk_bnft_ctfn
4436: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
4437: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
4438: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
4439: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 4479: ben_determine_coverage.write_coverage

4475: end if;
4476: --
4477: if l_write_rec then
4478: --
4479: ben_determine_coverage.write_coverage
4480: (p_calculate_only_mode => p_calculate_only_mode,
4481: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
4482: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
4483: p_val => l_combined_val,

Line 4568: ben_determine_coverage.write_coverage

4564: end if;
4565: l_epe.elctbl_flag:='N';
4566: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);
4567: end if;
4568: ben_determine_coverage.write_coverage
4569: (p_calculate_only_mode => p_calculate_only_mode,
4570: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
4571: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
4572: p_val => l_combined_val,

Line 4676: ben_determine_coverage.combine_with_variable_val

4672: p_state => l_state.region_2);
4673:
4674:
4675:
4676: ben_determine_coverage.combine_with_variable_val
4677: (p_vr_val => l_vr_val,
4678: p_val => l_tot_val, -- 3095224 l_val+l_cvg(0).val,
4679: p_vr_trtmt_cd => l_vr_trtmt_cd,
4680: p_combined_val => l_combined_val);

Line 4710: ben_determine_coverage.chk_bnft_ctfn

4706: end if;
4707:
4708: if l_rstrn_found then
4709: --
4710: ben_determine_coverage.chk_bnft_ctfn
4711: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
4712: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
4713: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
4714: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 4764: ben_determine_coverage.write_coverage

4760: close c_opt;
4761: --
4762: end if;
4763: --
4764: ben_determine_coverage.write_coverage
4765: (p_calculate_only_mode => p_calculate_only_mode,
4766: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
4767: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
4768: p_val => l_combined_val,

Line 4907: ben_determine_coverage.combine_with_variable_val

4903: p_state => l_state.region_2);
4904:
4905:
4906:
4907: ben_determine_coverage.combine_with_variable_val
4908: (p_vr_val => l_vr_val,
4909: p_val => l_tot_val, --l_val+i,
4910: p_vr_trtmt_cd => l_vr_trtmt_cd,
4911: p_combined_val => l_combined_val);

Line 4941: ben_determine_coverage.chk_bnft_ctfn

4937: end if;
4938:
4939: if l_rstrn_found then
4940: --
4941: ben_determine_coverage.chk_bnft_ctfn
4942: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
4943: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
4944: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
4945: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 4989: ben_determine_coverage.write_coverage

4985: fetch c_opt into l_opt;
4986: close c_opt;
4987: end if;
4988:
4989: ben_determine_coverage.write_coverage
4990: (p_calculate_only_mode => p_calculate_only_mode,
4991: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
4992: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
4993: p_val => l_combined_val,

Line 5054: ben_determine_coverage.write_coverage

5050: hr_utility.set_location (' CMC SAAEAR ',10);
5051: l_ctfn_rqd := 'N';
5052: l_write_rec := true;
5053:
5054: ben_determine_coverage.write_coverage
5055: (p_calculate_only_mode => p_calculate_only_mode,
5056: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
5057: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
5058: p_val => null,

Line 5111: ben_determine_coverage.combine_with_variable_val

5107: --Bug 6054310
5108: l_vr_val := nvl(l_vr_val, l_dflt_elcn_val);
5109: --
5110: --Bug 6054310
5111: ben_determine_coverage.combine_with_variable_val
5112: (p_vr_val => l_vr_val,
5113: p_val => l_cvg(0).val, -- 5933576 Removed l_calculated_val from here
5114: p_vr_trtmt_cd => l_vr_trtmt_cd,
5115: p_combined_val => l_combined_val);

Line 5137: ben_determine_coverage.chk_bnft_ctfn

5133: --Bug 5933576 Adding chk_bnft_ctfn for NSVU as well
5134: --
5135: if l_rstrn_found then
5136: --
5137: ben_determine_coverage.chk_bnft_ctfn
5138: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
5139: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
5140: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
5141: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 5176: ben_determine_coverage.write_coverage

5172: end if;
5173: --
5174: if l_write_rec then
5175: --
5176: ben_determine_coverage.write_coverage
5177: (p_calculate_only_mode => p_calculate_only_mode,
5178: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
5179: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
5180: p_val => l_combined_val,

Line 5259: ben_determine_coverage.write_coverage

5255: --
5256: l_epe.elctbl_flag:='N';
5257: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);
5258: end if;
5259: ben_determine_coverage.write_coverage
5260: (p_calculate_only_mode => p_calculate_only_mode,
5261: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
5262: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
5263: p_val => l_combined_val,

Line 5370: ben_determine_coverage.combine_with_variable_val

5366:
5367:
5368:
5369:
5370: ben_determine_coverage.combine_with_variable_val
5371: (p_vr_val => l_vr_val,
5372: p_val => l_val,
5373: p_vr_trtmt_cd => l_vr_trtmt_cd,
5374: p_combined_val => l_combined_val);

Line 5379: ben_determine_coverage.chk_bnft_ctfn

5375: --
5376:
5377: if l_rstrn_found then
5378: --
5379: ben_determine_coverage.chk_bnft_ctfn
5380: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
5381: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
5382: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
5383: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 5419: ben_determine_coverage.write_coverage

5415: --End Bug 4644489
5416: --
5417: end if;
5418: --
5419: ben_determine_coverage.write_coverage
5420: (p_calculate_only_mode => p_calculate_only_mode,
5421: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
5422: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
5423: p_val => l_combined_val,

Line 5607: end ben_determine_coverage;

5603: hr_utility.set_location ('Leaving '||l_package,10);
5604: --
5605: end main;
5606: --
5607: end ben_determine_coverage;