[Home] [Help]
47: 27 May 99 maagrawa 115.22 Added new procedures to re-calculate
48: flex credits when choice may not be present.
49: 25-Jun-99 jcarpent 115.23 Added per_in_ler_id to bpl.
50: 09-Jul-99 jcarpent 115.24 Added checks for backed out nocopy pil
51: 20-JUL-99 Gperry 115.25 genutils -> benutils package
52: rename.
53: 12-AUG-99 maagrawa 115.26 Corrected cursor c_cash_abr
54: to fetch values into correct
55: variables.
140: 17-May-01 maagrawa 115.57 Modified call to ben_global_enrt procedures.
141: 10-Jul-01 mhoyes 115.58 - Converted compute_excess, create_credit_ledger_entry and
142: create_debit_ledger_entry for EFC.
143: 27-aug-01 tilak 115.59 bug:1949361 jurisdiction code is
144: derived inside benutils.formula.
145: 23-Oct-01 kmahendr 115.60 bug#2065445-cursor c_bnft_prvdd_ldgr and c_bnft_prvdd_ldgr_2
146: modified to select row based on p_effective_date
147: 26-Oct-01 kmahendr 115.61 bug#2077743-in cursor c_prv order by rt_strt_dt desc added to
148: fetch the last rate row.
385: -- (p_state => l_person_rule_info.region_2);
386: -- end if;
387:
388: if p_dflt_excs_trtmt_rl is not null then
389: l_outputs := benutils.formula
390: (p_formula_id => p_dflt_excs_trtmt_rl,
391: p_assignment_id => l_person_rule_info.assignment_id,
392: p_organization_id => l_person_rule_info.organization_id,
393: p_business_group_id => p_business_group_id,
402:
403: p_dflt_excs_trtmt_cd := l_outputs(l_outputs.first).value;
404: p_mx_val := null;
405: elsif p_rlovr_val_rl is not null then
406: l_outputs := benutils.formula
407: (p_formula_id => p_rlovr_val_rl,
408: p_assignment_id => l_person_rule_info.assignment_id,
409: p_organization_id => l_person_rule_info.organization_id,
410: p_business_group_id => p_business_group_id,
3195: l_acty_base_rt_id := p_acty_base_rt_id;
3196: --
3197: hr_utility.set_location('['||p_val_rndg_cd||']',55);
3198: if p_val_rndg_cd is not null then
3199: l_balance:=benutils.do_rounding(
3200: p_rounding_cd => p_val_rndg_cd,
3201: p_rounding_rl => p_val_rndg_rl,
3202: p_value => l_balance,
3203: p_effective_date => p_effective_date);
3222: if p_mn_dstrbl_pct_num is not null then
3223: hr_utility.set_location(l_proc,90 );
3224: l_mn_dstrbl_val:=(p_mn_dstrbl_pct_num/100)*(p_prvdd_val+p_rlld_up_val-p_used_val);
3225: if p_pct_rndg_cd is not null then
3226: l_mn_dstrbl_val:=benutils.do_rounding(
3227: p_rounding_cd => p_pct_rndg_cd,
3228: p_rounding_rl => p_pct_rndg_rl,
3229: p_value => l_mn_dstrbl_val,
3230: p_effective_date => p_effective_date);
3257: if p_mx_pct is not null then
3258: hr_utility.set_location(l_proc,150 );
3259: l_mx_dstrbl_val:=(p_mx_pct/100)*(p_prvdd_val+p_rlld_up_val-p_used_val);
3260: if p_pct_rndg_cd is not null then
3261: l_mx_dstrbl_val:=benutils.do_rounding(
3262: p_rounding_cd => p_pct_rndg_cd,
3263: p_rounding_rl => p_pct_rndg_rl,
3264: p_value => l_mx_dstrbl_val,
3265: p_effective_date => p_effective_date);
3752: -- (p_state => l_rollover.region_2);
3753:
3754: -- end if;
3755:
3756: l_outputs := benutils.formula
3757: (p_formula_id => l_rollover.prtt_elig_rlovr_rl,
3758: p_assignment_id => l_rollover.assignment_id,
3759: p_organization_id => l_rollover.organization_id,
3760: p_business_group_id => p_business_group_id,
3802: --
3803: -- round the balance
3804: --
3805: if l_rollover.val_rndg_cd is not null then
3806: l_balance:=benutils.do_rounding(
3807: p_rounding_cd => l_rollover.val_rndg_cd,
3808: p_rounding_rl => l_rollover.val_rndg_rl,
3809: p_value => l_balance,
3810: p_effective_date => p_effective_date);
3827: --
3828: if l_rollover.mx_rlovr_pct_num is not null then
3829: l_mx_dstrbl_pct_num:=(l_prvdd_val-l_used_val)*l_rollover.mx_rlovr_pct_num/100;
3830: if p_pct_rndg_cd is not null then
3831: l_mx_dstrbl_pct_num:=benutils.do_rounding(
3832: p_rounding_cd => p_pct_rndg_cd,
3833: p_rounding_rl => p_pct_rndg_rl,
3834: p_value => l_mx_dstrbl_pct_num,
3835: p_effective_date => p_effective_date);
3893: -- compute the min pct value
3894: --
3895: l_mn_dstrbl_pct_num:=(l_prvdd_val-l_used_val)*l_rollover.mn_rlovr_pct_num/100;
3896: if p_pct_rndg_cd is not null then
3897: l_mn_dstrbl_pct_num:=benutils.do_rounding(
3898: p_rounding_cd => p_pct_rndg_cd,
3899: p_rounding_rl => p_pct_rndg_rl,
3900: p_value => l_mn_dstrbl_pct_num,
3901: p_effective_date => p_effective_date);
5801: -- pay_mag_utils.lookup_jurisdiction_code
5802: -- (p_state => l_rollover.region_2);
5803: -- end if;
5804:
5805: l_outputs := benutils.formula
5806: (p_formula_id => l_rollover.prtt_elig_rlovr_rl,
5807: p_assignment_id => l_rollover.assignment_id,
5808: p_organization_id => l_rollover.organization_id,
5809: p_business_group_id => p_business_group_id,
5851: --
5852: -- round the balance
5853: --
5854: if l_rollover.val_rndg_cd is not null then
5855: l_balance:=benutils.do_rounding(
5856: p_rounding_cd => l_rollover.val_rndg_cd,
5857: p_rounding_rl => l_rollover.val_rndg_rl,
5858: p_value => l_balance,
5859: p_effective_date => p_effective_date);
5866: --
5867: if l_rollover.mx_rlovr_pct_num is not null then
5868: l_mx_dstrbl_pct_num:=(l_prvdd_val-l_used_val)*l_rollover.mx_rlovr_pct_num/100;
5869: if p_pct_rndg_cd is not null then
5870: l_mx_dstrbl_pct_num:=benutils.do_rounding(
5871: p_rounding_cd => p_pct_rndg_cd,
5872: p_rounding_rl => p_pct_rndg_rl,
5873: p_value => l_mx_dstrbl_pct_num,
5874: p_effective_date => p_effective_date);
5907: -- compute the min pct value
5908: --
5909: l_mn_dstrbl_pct_num:=(l_prvdd_val-l_used_val)*l_rollover.mn_rlovr_pct_num/100;
5910: if p_pct_rndg_cd is not null then
5911: l_mn_dstrbl_pct_num:=benutils.do_rounding(
5912: p_rounding_cd => p_pct_rndg_cd,
5913: p_rounding_rl => p_pct_rndg_rl,
5914: p_value => l_mn_dstrbl_pct_num,
5915: p_effective_date => p_effective_date);