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_DERIVE_PART_AND_RATE_FACTS dependencies on BENUTILS

Line 187: 20-JUL-1999 Gperry 115.41 genutils -> benutils package

183: genutils.min_max_breach to
184: check the same.
185: 09-Jul-1999 jcarpent 115.40 Added per_in_ler_restriction to
186: elig_per(_opt) queries.
187: 20-JUL-1999 Gperry 115.41 genutils -> benutils package
188: rename.
189: 22-JUL-1999 mhoyes 115.42 - Added new trace messages.
190: - Replaced +0s.
191: 12-AUG-1999 tguy 115.43 Sync of version numbers

Line 564: g_rec benutils.g_batch_ler_rec;

560: --
561: --
562: g_package VARCHAR2(80) := 'ben_derive_part_and_rate_facts';
563: g_debug boolean := hr_utility.debug_enabled;
564: g_rec benutils.g_batch_ler_rec;
565: g_lf_evt_exists boolean;
566: --
567: --FONM
568: g_fonm_cvg_strt_dt DATE ;

Line 864: benutils.formula(p_formula_id=> p_formula_id

860: --
861: END IF;
862: --
863: l_outputs :=
864: benutils.formula(p_formula_id=> p_formula_id
865: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
866: ,p_effective_date)
867: ,p_assignment_id => l_ass_rec.assignment_id
868: ,p_organization_id => l_ass_rec.organization_id

Line 1922: benutils.write(p_text=> fnd_message.get);

1918: fnd_message.set_name('BEN'
1919: ,'BEN_91340_CREATE_PTNL_LER');
1920: fnd_message.set_token('LF_EVT'
1921: ,l_ler_name);
1922: benutils.write(p_text=> fnd_message.get);
1923: --
1924: if not p_calculate_only_mode then
1925: --
1926: ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per_perf(p_validate=> FALSE

Line 1964: benutils.write(p_rec=> g_rec);

1960: g_rec.business_group_id := p_business_group_id;
1961: g_rec.per_in_ler_id := NULL;
1962: g_rec.effective_date := p_effective_date;
1963: --
1964: benutils.write(p_rec=> g_rec);
1965: --
1966: -- hr_utility.set_location('Leaving ' || l_package,10);
1967: --
1968: END create_ptl_ler;

Line 2090: IF benutils.min_max_breach(p_min_value=> NVL(p_min_value

2086: --
2087: end if;
2088: /* End Bug 5478918 */
2089: --
2090: IF benutils.min_max_breach(p_min_value=> NVL(p_min_value
2091: ,-1)
2092: ,p_max_value => NVL(p_max_value
2093: ,99999999)
2094: ,p_new_value => p_new_value

Line 2108: benutils.derive_date(p_date=> p_subtract_date

2104: --
2105: END IF;
2106: --
2107: l_lf_evt_ocrd_dt :=
2108: benutils.derive_date(p_date=> p_subtract_date
2109: ,p_uom => p_uom
2110: ,p_min => p_min_value
2111: ,p_max => p_max_value
2112: ,p_value => l_break);

Line 2551: benutils.do_uom(p_date1=> l_start_date

2547: --
2548: IF p_rec.los_uom IS NOT NULL THEN
2549: --
2550: l_result :=
2551: benutils.do_uom(p_date1=> l_start_date
2552: ,p_date2 => l_subtract_date
2553: ,p_uom => p_rec.los_uom);
2554: --
2555: ELSE

Line 2566: benutils.do_rounding(p_rounding_cd=> p_rec.rndg_cd

2562: IF p_rec.rndg_cd IS NOT NULL
2563: OR p_rec.rndg_rl IS NOT NULL THEN
2564: -- dont use fonm date , the date only used for formula
2565: l_result :=
2566: benutils.do_rounding(p_rounding_cd=> p_rec.rndg_cd
2567: ,p_rounding_rl => p_rec.rndg_rl
2568: ,p_value => l_result
2569: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
2570: ,p_effective_date) );

Line 2997: benutils.do_uom(p_date1=> l_start_date

2993: --
2994: IF p_rec.age_uom IS NOT NULL THEN
2995: --
2996: l_result :=
2997: benutils.do_uom(p_date1=> l_start_date
2998: ,p_date2 => l_subtract_date
2999: ,p_uom => p_rec.age_uom);
3000: --
3001: ELSE

Line 3015: benutils.do_rounding(p_rounding_cd=> p_rec.rndg_cd

3011: IF p_rec.rndg_cd IS NOT NULL
3012: OR p_rec.rndg_rl IS NOT NULL THEN
3013: --
3014: l_result :=
3015: benutils.do_rounding(p_rounding_cd=> p_rec.rndg_cd
3016: ,p_rounding_rl => p_rec.rndg_rl
3017: ,p_value => l_result
3018: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
3019: ,p_effective_date));

Line 3184: benutils.write(p_text=> fnd_message.get);

3180: fnd_message.set_token('NAME'
3181: ,l_bnb_rec.name);
3182: fnd_message.set_token('DATE'
3183: ,l_start_date);
3184: benutils.write(p_text=> fnd_message.get);
3185: --
3186: ben_person_object.get_object(p_person_id=> p_person_id
3187: ,p_effective_date => nvl(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt
3188: ,p_effective_date))

Line 3206: benutils.write(p_text=> fnd_message.get);

3202: ,l_bnb_rec.name);
3203: fnd_message.set_token('DATE'
3204: ,NVL(p_lf_evt_ocrd_dt
3205: ,p_effective_date));
3206: benutils.write(p_text=> fnd_message.get);
3207: RETURN NULL;
3208: --
3209: END IF;
3210: --

Line 3270: benutils.write(p_text=> fnd_message.get);

3266: end if;
3267: if l_result is null then
3268: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');
3269: fnd_message.set_token('DATE' ,l_start_date);
3270: benutils.write(p_text=> fnd_message.get);
3271: return null;
3272: end if;
3273:
3274: --

Line 3316: benutils.write(p_text=> fnd_message.get);

3312: fnd_message.set_name('BEN'
3313: ,'BEN_92318_BEN_BALANCE_NULL');
3314: fnd_message.set_token('DATE'
3315: ,l_start_date);
3316: benutils.write(p_text=> fnd_message.get);
3317: --
3318: l_result :=
3319: pay_balance_pkg.get_value(p_rec.defined_balance_id
3320: ,l_ass_rec.assignment_id

Line 3331: benutils.write(p_text=> fnd_message.get);

3327: ,'BEN_92318_BEN_BALANCE_NULL');
3328: fnd_message.set_token('DATE'
3329: ,NVL(p_lf_evt_ocrd_dt
3330: ,p_effective_date));
3331: benutils.write(p_text=> fnd_message.get);
3332: RETURN NULL;
3333: --
3334: END IF;
3335: --

Line 3346: benutils.do_rounding(p_rounding_cd=> p_rec.rndg_cd

3342: IF p_rec.rndg_cd IS NOT NULL
3343: OR p_rec.rndg_rl IS NOT NULL THEN
3344: --
3345: l_result :=
3346: benutils.do_rounding(p_rounding_cd=> p_rec.rndg_cd
3347: ,p_rounding_rl => p_rec.rndg_rl
3348: ,p_value => l_result
3349: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
3350: ,p_effective_date));

Line 3486: benutils.write(p_text=> fnd_message.get);

3482: fnd_message.set_name('BEN'
3483: ,'BEN_92319_SAL_BALANCE_NULL');
3484: fnd_message.set_token('DATE'
3485: ,l_start_date);
3486: benutils.write(p_text=> fnd_message.get);
3487: ---if date code is
3488: -- first of year,half year,quarter,month,semi month,previos oct 1
3489: -- then take the firstist salary
3490: if p_rec.comp_lvl_det_cd in

Line 3529: benutils.write(p_text=> fnd_message.get);

3525: ,'BEN_92319_SAL_BALANCE_NULL');
3526: fnd_message.set_token('DATE'
3527: ,NVL(p_lf_evt_ocrd_dt
3528: ,p_effective_date));
3529: benutils.write(p_text=> fnd_message.get);
3530: RETURN NULL;
3531: --
3532: END IF;
3533: --

Line 3595: benutils.write(p_text=> fnd_message.get);

3591: fnd_message.set_token('NAME'
3592: ,l_bnb_rec.name);
3593: fnd_message.set_token('DATE'
3594: ,l_start_date);
3595: benutils.write(p_text=> fnd_message.get);
3596: --
3597: ben_person_object.get_object(p_person_id=> p_person_id
3598: ,p_effective_date => p_effective_date
3599: ,p_bnfts_bal_id => p_rec.bnfts_bal_id

Line 3613: benutils.write(p_text=> fnd_message.get);

3609: ,l_bnb_rec.name);
3610: fnd_message.set_token('DATE'
3611: ,NVL(p_lf_evt_ocrd_dt
3612: ,p_effective_date));
3613: benutils.write(p_text=> fnd_message.get);
3614: RETURN NULL;
3615: --
3616: END IF;
3617: --

Line 3679: benutils.write(p_text=> fnd_message.get);

3675:
3676: if l_result is null then
3677: fnd_message.set_name('BEN' ,'BEN_92318_BEN_BALANCE_NULL');
3678: fnd_message.set_token('DATE' ,l_start_date);
3679: benutils.write(p_text=> fnd_message.get);
3680: return null;
3681: end if;
3682: --
3683: --

Line 3723: benutils.write(p_text=> fnd_message.get);

3719: fnd_message.set_name('BEN'
3720: ,'BEN_92318_BEN_BALANCE_NULL');
3721: fnd_message.set_token('DATE'
3722: ,l_start_date);
3723: benutils.write(p_text=> fnd_message.get);
3724: l_result :=
3725: pay_balance_pkg.get_value(p_rec.defined_balance_id
3726: ,l_ass_rec.assignment_id
3727: ,NVL(p_lf_evt_ocrd_dt

Line 3737: benutils.write(p_text=> fnd_message.get);

3733: ,'BEN_92318_BEN_BALANCE_NULL');
3734: fnd_message.set_token('DATE'
3735: ,NVL(p_lf_evt_ocrd_dt
3736: ,p_effective_date));
3737: benutils.write(p_text=> fnd_message.get);
3738: RETURN NULL;
3739: --
3740: END IF;
3741: --

Line 3753: benutils.do_rounding(p_rounding_cd=> p_rec.rndg_cd

3749: IF p_rec.rndg_cd IS NOT NULL
3750: OR p_rec.rndg_rl IS NOT NULL THEN
3751: --
3752: l_result :=
3753: benutils.do_rounding(p_rounding_cd=> p_rec.rndg_cd
3754: ,p_rounding_rl => p_rec.rndg_rl
3755: ,p_value => l_result
3756: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
3757: ,p_effective_date));

Line 3910: benutils.do_rounding(p_rounding_cd=> l_elig_rec.rndg_cd

3906: IF l_elig_rec.rndg_cd IS NOT NULL
3907: OR l_elig_rec.rndg_rl IS NOT NULL THEN
3908: --
3909: l_elig_result :=
3910: benutils.do_rounding(p_rounding_cd=> l_elig_rec.rndg_cd
3911: ,p_rounding_rl => l_elig_rec.rndg_rl
3912: ,p_value => l_elig_result
3913: ,p_effective_date => NVL(g_fonm_cvg_strt_dt,
3914: NVL(p_lf_evt_ocrd_dt ,p_effective_date))

Line 4112: benutils.do_rounding(p_rounding_cd=> l_rate_rec.rndg_cd

4108: IF l_rate_rec.rndg_cd IS NOT NULL
4109: OR l_rate_rec.rndg_rl IS NOT NULL THEN
4110: --
4111: l_rate_result :=
4112: benutils.do_rounding(p_rounding_cd=> l_rate_rec.rndg_cd
4113: ,p_rounding_rl => l_rate_rec.rndg_rl
4114: ,p_value => l_rate_result
4115: ,p_effective_date => NVL(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt
4116: ,p_effective_date)));

Line 4249: benutils.do_rounding(p_rounding_cd=> l_rate_cvg_rec.rndg_cd

4245: IF l_rate_cvg_rec.rndg_cd IS NOT NULL
4246: OR l_rate_cvg_rec.rndg_rl IS NOT NULL THEN
4247: --
4248: l_rate_cvg_result :=
4249: benutils.do_rounding(p_rounding_cd=> l_rate_cvg_rec.rndg_cd
4250: ,p_rounding_rl => l_rate_cvg_rec.rndg_rl
4251: ,p_value => l_rate_cvg_result
4252: ,p_effective_date => NVL(g_fonm_cvg_strt_dt,
4253: NVL(p_lf_evt_ocrd_dt,p_effective_date)));

Line 4381: benutils.do_rounding(p_rounding_cd=> l_rate_prem_rec.rndg_cd

4377: IF l_rate_prem_rec.rndg_cd IS NOT NULL
4378: OR l_rate_prem_rec.rndg_rl IS NOT NULL THEN
4379: --
4380: l_rate_prem_result :=
4381: benutils.do_rounding(p_rounding_cd=> l_rate_prem_rec.rndg_cd
4382: ,p_rounding_rl => l_rate_prem_rec.rndg_rl
4383: ,p_value => l_rate_prem_result
4384: ,p_effective_date => NVL(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt
4385: ,p_effective_date)));

Line 5180: IF benutils.min_max_breach(p_min_value=> NVL(p_min_value

5176: if g_debug then
5177: hr_utility.set_location('p_old_value '||p_old_value,10);
5178: end if;
5179: --
5180: IF benutils.min_max_breach(p_min_value=> NVL(p_min_value
5181: ,-1)
5182: ,p_max_value => NVL(p_max_value
5183: ,99999999)
5184: ,p_new_value => p_new_value

Line 5710: benutils.do_rounding(p_rounding_cd=> l_elig_rec.rndg_cd

5706: IF l_elig_rec.rndg_cd IS NOT NULL
5707: OR l_elig_rec.rndg_rl IS NOT NULL THEN
5708: --
5709: l_elig_result :=
5710: benutils.do_rounding(p_rounding_cd=> l_elig_rec.rndg_cd
5711: ,p_rounding_rl => l_elig_rec.rndg_rl
5712: ,p_value => l_elig_result
5713: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
5714: ,p_effective_date));

Line 5807: IF benutils.min_max_breach(p_min_value=> NVL(l_elig_rec.mn_comp_val

5803: ,p_effective_date => NVL(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt
5804: ,p_effective_date))
5805: ,p_rec => l_elig_rec);
5806: --
5807: IF benutils.min_max_breach(p_min_value=> NVL(l_elig_rec.mn_comp_val
5808: ,-1)
5809: ,p_max_value => NVL(l_elig_rec.mx_comp_val
5810: ,99999999)
5811: ,p_new_value => l_elig_result

Line 6163: benutils.do_rounding(p_rounding_cd=> l_rate_rec.rndg_cd

6159: hr_utility.set_location('in the comp_calc_rl rndg_cd ' ,35 );
6160: end if;
6161: --
6162: l_rate_result :=
6163: benutils.do_rounding(p_rounding_cd=> l_rate_rec.rndg_cd
6164: ,p_rounding_rl => l_rate_rec.rndg_rl
6165: ,p_value => l_rate_result
6166: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
6167: ,p_effective_date));

Line 6361: benutils.do_rounding(p_rounding_cd=> l_rate_cvg_rec.rndg_cd

6357: IF l_rate_cvg_rec.rndg_cd IS NOT NULL
6358: OR l_rate_cvg_rec.rndg_rl IS NOT NULL THEN
6359: --
6360: l_rate_cvg_result :=
6361: benutils.do_rounding(p_rounding_cd=> l_rate_cvg_rec.rndg_cd
6362: ,p_rounding_rl => l_rate_cvg_rec.rndg_rl
6363: ,p_value => l_rate_cvg_result
6364: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
6365: ,p_effective_date));

Line 6552: benutils.do_rounding(p_rounding_cd=> l_rate_prem_rec.rndg_cd

6548: IF l_rate_prem_rec.rndg_cd IS NOT NULL
6549: OR l_rate_prem_rec.rndg_rl IS NOT NULL THEN
6550: --
6551: l_rate_prem_result :=
6552: benutils.do_rounding(p_rounding_cd=> l_rate_prem_rec.rndg_cd
6553: ,p_rounding_rl => l_rate_prem_rec.rndg_rl
6554: ,p_value => l_rate_prem_result
6555: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
6556: ,p_effective_date));

Line 6929: IF benutils.min_max_breach(p_min_value=> NVL(l_elig_rec.cmbnd_min_val

6925: ,p_effective_date => NVL(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt
6926: ,p_effective_date))
6927: ,p_rec => l_elig_rec);
6928: --
6929: IF benutils.min_max_breach(p_min_value=> NVL(l_elig_rec.cmbnd_min_val
6930: ,-1)
6931: ,p_max_value => NVL(l_elig_rec.cmbnd_max_val
6932: ,99999999)
6933: ,p_new_value => l_elig_result

Line 7101: IF benutils.min_max_breach(p_min_value=> NVL(l_rate_rec.cmbnd_min_val

7097: null;
7098: --
7099: else
7100: --
7101: IF benutils.min_max_breach(p_min_value=> NVL(l_rate_rec.cmbnd_min_val
7102: ,-1)
7103: ,p_max_value => NVL(l_rate_rec.cmbnd_max_val
7104: ,99999999)
7105: ,p_new_value => l_rate_result

Line 7242: IF benutils.min_max_breach(p_min_value=> NVL(l_rate_cvg_rec.cmbnd_min_val

7238: null;
7239: --
7240: else
7241: --
7242: IF benutils.min_max_breach(p_min_value=> NVL(l_rate_cvg_rec.cmbnd_min_val
7243: ,-1)
7244: ,p_max_value => NVL(l_rate_cvg_rec.cmbnd_max_val
7245: ,99999999)
7246: ,p_new_value => l_rate_cvg_result

Line 7382: IF benutils.min_max_breach(p_min_value=> NVL(l_rate_prem_rec.cmbnd_min_val

7378: null;
7379: --
7380: else
7381: --
7382: IF benutils.min_max_breach(p_min_value=> NVL(l_rate_prem_rec.cmbnd_min_val
7383: ,-1)
7384: ,p_max_value => NVL(l_rate_prem_rec.cmbnd_max_val
7385: ,99999999)
7386: ,p_new_value => l_rate_prem_result

Line 7525: IF benutils.min_max_breach(p_min_value=> NVL( p_min_value

7521: if g_debug then
7522: hr_utility.set_location('p_old_value '||p_old_value,10);
7523: end if;
7524: --
7525: IF benutils.min_max_breach(p_min_value=> NVL( p_min_value
7526: ,-1)
7527: ,p_max_value => NVL( p_max_value
7528: ,99999999)
7529: ,p_new_value => p_new_value

Line 7711: benutils.do_rounding(p_rounding_cd=> l_elig_rec.rndg_cd

7707: IF l_elig_rec.rndg_cd IS NOT NULL
7708: OR l_elig_rec.rndg_rl IS NOT NULL THEN
7709: --
7710: l_elig_result :=
7711: benutils.do_rounding(p_rounding_cd=> l_elig_rec.rndg_cd
7712: ,p_rounding_rl => l_elig_rec.rndg_rl
7713: ,p_value => l_elig_result
7714: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
7715: ,p_effective_date));

Line 7745: IF benutils.min_max_breach(p_min_value=> NVL(l_elig_rec.mn_pct_val

7741: ,p_effective_date => nvl(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt
7742: ,p_effective_date))
7743: ,p_rec => l_elig_rec);
7744: --
7745: IF benutils.min_max_breach(p_min_value=> NVL(l_elig_rec.mn_pct_val
7746: ,-1)
7747: ,p_max_value => NVL(l_elig_rec.mx_pct_val
7748: ,99999999)
7749: ,p_new_value => l_elig_result

Line 7876: benutils.do_rounding(p_rounding_cd=> l_rate_rec.rndg_cd

7872: IF l_rate_rec.rndg_cd IS NOT NULL
7873: OR l_rate_rec.rndg_rl IS NOT NULL THEN
7874: --
7875: l_rate_result :=
7876: benutils.do_rounding(p_rounding_cd=> l_rate_rec.rndg_cd
7877: ,p_rounding_rl => l_rate_rec.rndg_rl
7878: ,p_value => l_rate_result
7879: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
7880: ,p_effective_date));

Line 7978: benutils.do_rounding(p_rounding_cd=> l_rate_cvg_rec.rndg_cd

7974: IF l_rate_cvg_rec.rndg_cd IS NOT NULL
7975: OR l_rate_cvg_rec.rndg_rl IS NOT NULL THEN
7976: --
7977: l_rate_cvg_result :=
7978: benutils.do_rounding(p_rounding_cd=> l_rate_cvg_rec.rndg_cd
7979: ,p_rounding_rl => l_rate_cvg_rec.rndg_rl
7980: ,p_value => l_rate_cvg_result
7981: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
7982: ,p_effective_date));

Line 8092: benutils.do_rounding(p_rounding_cd=> l_rate_prem_rec.rndg_cd

8088: IF l_rate_prem_rec.rndg_cd IS NOT NULL
8089: OR l_rate_prem_rec.rndg_rl IS NOT NULL THEN
8090: --
8091: l_rate_prem_result :=
8092: benutils.do_rounding(p_rounding_cd=> l_rate_prem_rec.rndg_cd
8093: ,p_rounding_rl => l_rate_prem_rec.rndg_rl
8094: ,p_value => l_rate_prem_result
8095: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
8096: ,p_effective_date));

Line 8242: IF benutils.min_max_breach(p_min_value=> NVL(p_min_value

8238: hr_utility.set_location('p_min_value '||p_min_value,10);
8239: hr_utility.set_location('p_new_value '||p_new_value,10);
8240: hr_utility.set_location('p_old_value '||p_old_value,10);
8241: --
8242: IF benutils.min_max_breach(p_min_value=> NVL(p_min_value
8243: ,-1)
8244: ,p_max_value => NVL(p_max_value
8245: ,99999999)
8246: ,p_new_value => p_new_value

Line 8390: END IF; -- benutils.min_max_breach

8386: END IF; -- no_life_event
8387: --
8388: END IF; -- l_lf_evt_ocrd_dt >= l_rec.min_ass_effective_start_date
8389: --
8390: END IF; -- benutils.min_max_breach
8391: --
8392: END hours_worked_min_max ;
8393: --
8394: PROCEDURE calculate_hours_worked

Line 8556: benutils.do_rounding(p_rounding_cd=> l_elig_rec.rndg_cd

8552: IF l_elig_rec.rndg_cd IS NOT NULL
8553: OR l_elig_rec.rndg_rl IS NOT NULL THEN
8554: --
8555: l_elig_result :=
8556: benutils.do_rounding(p_rounding_cd=> l_elig_rec.rndg_cd
8557: ,p_rounding_rl => l_elig_rec.rndg_rl
8558: ,p_value => l_elig_result
8559: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
8560: ,p_effective_date));

Line 8621: IF benutils.min_max_breach(p_min_value=> NVL(l_elig_rec.mn_hrs_num

8617: ,p_effective_date => nvl(g_fonm_cvg_strt_dt,NVL(p_lf_evt_ocrd_dt
8618: ,p_effective_date))
8619: ,p_rec => l_elig_rec);
8620: --
8621: IF benutils.min_max_breach(p_min_value=> NVL(l_elig_rec.mn_hrs_num
8622: ,-1)
8623: ,p_max_value => NVL(l_elig_rec.mx_hrs_num
8624: ,99999999)
8625: ,p_new_value => l_elig_result

Line 8905: benutils.do_rounding(p_rounding_cd=> l_rate_rec.rndg_cd

8901: IF l_rate_rec.rndg_cd IS NOT NULL
8902: OR l_rate_rec.rndg_rl IS NOT NULL THEN
8903: --
8904: l_rate_result :=
8905: benutils.do_rounding(p_rounding_cd=> l_rate_rec.rndg_cd
8906: ,p_rounding_rl => l_rate_rec.rndg_rl
8907: ,p_value => l_rate_result
8908: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
8909: ,p_effective_date));

Line 9083: benutils.do_rounding(p_rounding_cd=> l_rate_cvg_rec.rndg_cd

9079: IF l_rate_cvg_rec.rndg_cd IS NOT NULL
9080: OR l_rate_cvg_rec.rndg_rl IS NOT NULL THEN
9081: --
9082: l_rate_cvg_result :=
9083: benutils.do_rounding(p_rounding_cd=> l_rate_cvg_rec.rndg_cd
9084: ,p_rounding_rl => l_rate_cvg_rec.rndg_rl
9085: ,p_value => l_rate_cvg_result
9086: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
9087: ,p_effective_date));

Line 9248: benutils.do_rounding(p_rounding_cd=> l_rate_prem_rec.rndg_cd

9244: IF l_rate_prem_rec.rndg_cd IS NOT NULL
9245: OR l_rate_prem_rec.rndg_rl IS NOT NULL THEN
9246: --
9247: l_rate_prem_result :=
9248: benutils.do_rounding(p_rounding_cd=> l_rate_prem_rec.rndg_cd
9249: ,p_rounding_rl => l_rate_prem_rec.rndg_rl
9250: ,p_value => l_rate_prem_result
9251: ,p_effective_date => NVL(p_lf_evt_ocrd_dt
9252: ,p_effective_date));