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.31.12010000.2 2008/08/05 14:36:35 ubhat 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 375: g_package varchar2(80) := 'ben_determine_coverage';

371: Multiple of compensation
372: */
373: -------------------------------------------------------------------------------------------------------------------------------------------------
374: --
375: g_package varchar2(80) := 'ben_determine_coverage';
376: g_old_val number;
377: --
378: --
379: FUNCTION round_val

Line 499: ,p_enb_valrow out nocopy ben_determine_coverage.ENBValType

495: ,p_ordr_num in number
496: ,p_ctfn_rqd_flag in varchar2
497: --
498: ,p_enrt_bnft_id out nocopy number
499: ,p_enb_valrow out nocopy ben_determine_coverage.ENBValType
500: --
501: ,p_ultmt_upr_lmt in number default null
502: ,p_ultmt_lwr_lmt in number default null
503: ,p_ultmt_upr_lmt_calc_rl in number default null

Line 1500: ,p_enb_valrow out nocopy ben_determine_coverage.ENBValType

1496: ,p_effective_date IN date
1497: ,p_lf_evt_ocrd_dt IN date
1498: ,p_perform_rounding_flg IN boolean
1499: --
1500: ,p_enb_valrow out nocopy ben_determine_coverage.ENBValType
1501: )
1502: is
1503: --
1504: l_package varchar2(80) := g_package||'.main';

Line 2636: ben_determine_coverage.combine_with_variable_val

2632: p_state => l_state.region_2);
2633:
2634: hr_utility.set_location (' CMC FLFX ',10);
2635: --
2636: ben_determine_coverage.combine_with_variable_val
2637: (p_vr_val => l_vr_val,
2638: p_val => l_val,
2639: p_vr_trtmt_cd => l_vr_trtmt_cd,
2640: p_combined_val => l_combined_val);

Line 2669: ben_determine_coverage.chk_bnft_ctfn

2665: end if;
2666: --rtagarra
2667: if l_rstrn_found then
2668: --
2669: ben_determine_coverage.chk_bnft_ctfn
2670: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
2671: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
2672: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
2673: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 2846: ben_determine_coverage.write_coverage

2842: hr_utility.set_location('l_combined_val = ' || l_combined_val, 9999);
2843: hr_utility.set_location('l_cvg_amount = ' || l_cvg_amount, 9999);
2844: hr_utility.set_location('l_dflt_elcn_val = ' || l_dflt_elcn_val, 9999);
2845: --
2846: ben_determine_coverage.write_coverage
2847: (p_calculate_only_mode => p_calculate_only_mode,
2848: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
2849: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
2850: p_val => l_combined_val,

Line 3113: ben_determine_coverage.write_coverage

3109: end if;
3110: l_epe.elctbl_flag:='N';
3111: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);
3112: end if;
3113: ben_determine_coverage.write_coverage
3114: (p_calculate_only_mode => p_calculate_only_mode,
3115: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
3116: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
3117: p_val => l_combined_val,

Line 3204: ben_determine_coverage.combine_with_variable_val

3200: p_state => l_state.region_2);
3201:
3202: ---
3203: hr_utility.set_location (' rndg is'||l_val,10);
3204: ben_determine_coverage.combine_with_variable_val
3205: (p_vr_val => l_vr_val,
3206: p_val => l_val,
3207: p_vr_trtmt_cd => l_vr_trtmt_cd,
3208: p_combined_val => l_combined_val);

Line 3214: ben_determine_coverage.chk_bnft_ctfn

3210: hr_utility.set_location (' varb is'||l_combined_val,10);
3211: --
3212: if l_rstrn_found then
3213: --
3214: ben_determine_coverage.chk_bnft_ctfn
3215: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
3216: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
3217: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
3218: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 3258: ben_determine_coverage.write_coverage

3254: end if;
3255: --
3256: if l_write_rec then
3257: --
3258: ben_determine_coverage.write_coverage
3259: (p_calculate_only_mode => p_calculate_only_mode,
3260: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
3261: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
3262: p_val => l_combined_val,

Line 3349: ben_determine_coverage.write_coverage

3345: --
3346: l_epe.elctbl_flag:='N';
3347: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);
3348: end if;
3349: ben_determine_coverage.write_coverage
3350: (p_calculate_only_mode => p_calculate_only_mode,
3351: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
3352: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
3353: p_val => l_combined_val,

Line 3511: ben_determine_coverage.combine_with_variable_val

3507: p_val => l_val,
3508: p_state => l_state.region_2);
3509:
3510: --
3511: ben_determine_coverage.combine_with_variable_val
3512: (p_vr_val => l_vr_val,
3513: p_val => l_val,
3514: p_vr_trtmt_cd => l_vr_trtmt_cd,
3515: p_combined_val => l_combined_val);

Line 3559: ben_determine_coverage.chk_bnft_ctfn

3555: end if;
3556:
3557: if l_rstrn_found then
3558:
3559: ben_determine_coverage.chk_bnft_ctfn
3560: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
3561: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
3562: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
3563: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 3605: ben_determine_coverage.write_coverage

3601: if l_write_rec then
3602: --
3603: hr_utility.set_location('Writing coverage ',35);
3604: --
3605: ben_determine_coverage.write_coverage
3606: (p_calculate_only_mode => p_calculate_only_mode,
3607: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
3608: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
3609: p_val => l_combined_val,

Line 3732: ben_determine_coverage.combine_with_variable_val

3728: p_ler_id => l_epe.ler_id,
3729: p_val => l_val,
3730: p_state => l_state.region_2);
3731:
3732: ben_determine_coverage.combine_with_variable_val
3733: (p_vr_val => l_vr_val,
3734: p_val => l_val,
3735: p_vr_trtmt_cd => l_vr_trtmt_cd,
3736: p_combined_val => l_combined_val);

Line 3765: ben_determine_coverage.chk_bnft_ctfn

3761: end if;
3762:
3763: if l_rstrn_found then
3764: --
3765: ben_determine_coverage.chk_bnft_ctfn
3766: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
3767: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
3768: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
3769: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 3819: ben_determine_coverage.write_coverage

3815: close c_opt;
3816: --
3817: end if;
3818: --
3819: ben_determine_coverage.write_coverage
3820: (p_calculate_only_mode => p_calculate_only_mode,
3821: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
3822: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
3823: p_val => l_combined_val,

Line 3934: ben_determine_coverage.combine_with_variable_val

3930: p_ler_id => l_epe.ler_id,
3931: p_val => l_tot_val, -- 3095224,
3932: p_state => l_state.region_2);
3933:
3934: ben_determine_coverage.combine_with_variable_val
3935: (p_vr_val => l_vr_val,
3936: p_val => l_tot_val, -- 3095224 l_val+l_cvg(0).val,
3937: p_vr_trtmt_cd => l_vr_trtmt_cd,
3938: p_combined_val => l_combined_val);

Line 3942: ben_determine_coverage.chk_bnft_ctfn

3938: p_combined_val => l_combined_val);
3939: --
3940: if l_rstrn_found then
3941: --
3942: ben_determine_coverage.chk_bnft_ctfn
3943: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
3944: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
3945: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
3946: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 3986: ben_determine_coverage.write_coverage

3982: end if;
3983: --
3984: if l_write_rec then
3985: --
3986: ben_determine_coverage.write_coverage
3987: (p_calculate_only_mode => p_calculate_only_mode,
3988: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
3989: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
3990: p_val => l_combined_val,

Line 4075: ben_determine_coverage.write_coverage

4071: end if;
4072: l_epe.elctbl_flag:='N';
4073: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);
4074: end if;
4075: ben_determine_coverage.write_coverage
4076: (p_calculate_only_mode => p_calculate_only_mode,
4077: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
4078: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
4079: p_val => l_combined_val,

Line 4183: ben_determine_coverage.combine_with_variable_val

4179: p_state => l_state.region_2);
4180:
4181:
4182:
4183: ben_determine_coverage.combine_with_variable_val
4184: (p_vr_val => l_vr_val,
4185: p_val => l_tot_val, -- 3095224 l_val+l_cvg(0).val,
4186: p_vr_trtmt_cd => l_vr_trtmt_cd,
4187: p_combined_val => l_combined_val);

Line 4217: ben_determine_coverage.chk_bnft_ctfn

4213: end if;
4214:
4215: if l_rstrn_found then
4216: --
4217: ben_determine_coverage.chk_bnft_ctfn
4218: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
4219: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
4220: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
4221: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 4271: ben_determine_coverage.write_coverage

4267: close c_opt;
4268: --
4269: end if;
4270: --
4271: ben_determine_coverage.write_coverage
4272: (p_calculate_only_mode => p_calculate_only_mode,
4273: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
4274: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
4275: p_val => l_combined_val,

Line 4414: ben_determine_coverage.combine_with_variable_val

4410: p_state => l_state.region_2);
4411:
4412:
4413:
4414: ben_determine_coverage.combine_with_variable_val
4415: (p_vr_val => l_vr_val,
4416: p_val => l_tot_val, --l_val+i,
4417: p_vr_trtmt_cd => l_vr_trtmt_cd,
4418: p_combined_val => l_combined_val);

Line 4448: ben_determine_coverage.chk_bnft_ctfn

4444: end if;
4445:
4446: if l_rstrn_found then
4447: --
4448: ben_determine_coverage.chk_bnft_ctfn
4449: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
4450: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
4451: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
4452: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 4496: ben_determine_coverage.write_coverage

4492: fetch c_opt into l_opt;
4493: close c_opt;
4494: end if;
4495:
4496: ben_determine_coverage.write_coverage
4497: (p_calculate_only_mode => p_calculate_only_mode,
4498: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
4499: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
4500: p_val => l_combined_val,

Line 4561: ben_determine_coverage.write_coverage

4557: hr_utility.set_location (' CMC SAAEAR ',10);
4558: l_ctfn_rqd := 'N';
4559: l_write_rec := true;
4560:
4561: ben_determine_coverage.write_coverage
4562: (p_calculate_only_mode => p_calculate_only_mode,
4563: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
4564: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
4565: p_val => null,

Line 4618: ben_determine_coverage.combine_with_variable_val

4614: --Bug 6054310
4615: l_vr_val := nvl(l_vr_val, l_dflt_elcn_val);
4616: --
4617: --Bug 6054310
4618: ben_determine_coverage.combine_with_variable_val
4619: (p_vr_val => l_vr_val,
4620: p_val => l_cvg(0).val, -- 5933576 Removed l_calculated_val from here
4621: p_vr_trtmt_cd => l_vr_trtmt_cd,
4622: p_combined_val => l_combined_val);

Line 4644: ben_determine_coverage.chk_bnft_ctfn

4640: --Bug 5933576 Adding chk_bnft_ctfn for NSVU as well
4641: --
4642: if l_rstrn_found then
4643: --
4644: ben_determine_coverage.chk_bnft_ctfn
4645: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
4646: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
4647: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
4648: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 4683: ben_determine_coverage.write_coverage

4679: end if;
4680: --
4681: if l_write_rec then
4682: --
4683: ben_determine_coverage.write_coverage
4684: (p_calculate_only_mode => p_calculate_only_mode,
4685: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
4686: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
4687: p_val => l_combined_val,

Line 4766: ben_determine_coverage.write_coverage

4762: --
4763: l_epe.elctbl_flag:='N';
4764: hr_utility.set_location('Electable choice was made not electable by bencvrge',29);
4765: end if;
4766: ben_determine_coverage.write_coverage
4767: (p_calculate_only_mode => p_calculate_only_mode,
4768: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
4769: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
4770: p_val => l_combined_val,

Line 4877: ben_determine_coverage.combine_with_variable_val

4873:
4874:
4875:
4876:
4877: ben_determine_coverage.combine_with_variable_val
4878: (p_vr_val => l_vr_val,
4879: p_val => l_val,
4880: p_vr_trtmt_cd => l_vr_trtmt_cd,
4881: p_combined_val => l_combined_val);

Line 4886: ben_determine_coverage.chk_bnft_ctfn

4882: --
4883:
4884: if l_rstrn_found then
4885: --
4886: ben_determine_coverage.chk_bnft_ctfn
4887: (p_mx_cvg_wcfn_amt => l_rstrn.mx_cvg_wcfn_amt,
4888: p_mx_cvg_wcfn_mlt_num => l_rstrn.mx_cvg_wcfn_mlt_num,
4889: p_mx_cvg_mlt_incr_num => l_rstrn.mx_cvg_mlt_incr_num,
4890: p_mx_cvg_mlt_incr_wcf_num => l_rstrn.mx_cvg_mlt_incr_wcf_num,

Line 4926: ben_determine_coverage.write_coverage

4922: --End Bug 4644489
4923: --
4924: end if;
4925: --
4926: ben_determine_coverage.write_coverage
4927: (p_calculate_only_mode => p_calculate_only_mode,
4928: p_bndry_perd_cd => l_cvg(0).bndry_perd_cd,
4929: p_bnft_typ_cd => l_cvg(0).bnft_typ_cd,
4930: p_val => l_combined_val,

Line 5113: end ben_determine_coverage;

5109: hr_utility.set_location ('Leaving '||l_package,10);
5110: --
5111: end main;
5112: --
5113: end ben_determine_coverage;