DBA Data[Home] [Help]

APPS.PAY_FR_SICKNESS_CALC dependencies on PAY_BALANCE_PKG

Line 456: pay_balance_pkg.get_value(l_defined_balance_id

452: --
453: -- Fetch the value using core balance user exit in date mode:
454: BEGIN
455: l_balance_value :=
456: pay_balance_pkg.get_value(l_defined_balance_id
457: ,p_assignment_id
458: ,p_period_end_date);
459:
460: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 482: pay_balance_pkg.get_value(g_map_refsal_defbal_id

478: --
479: -- Fetch the value using core balance user exit in date mode:
480: BEGIN
481: l_balance_value :=
482: pay_balance_pkg.get_value(g_map_refsal_defbal_id
483: ,p_assignment_id
484: ,p_period_end_date);
485:
486: hr_utility.set_location(' Leaving:'||l_proc, 72);

Line 673: pay_balance_pkg.set_context('ASSIGNMENT_ID'

669: /* set context value before calling fast formula */
670:
671: --hr_utility.set_location('set context value before calling fast formula', 100);
672:
673: pay_balance_pkg.set_context('ASSIGNMENT_ID'
674: , p_asg.assignment_id);
675: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID'
676: , p_asg.assignment_action_id);
677: pay_balance_pkg.set_context('DATE_EARNED'

Line 675: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID'

671: --hr_utility.set_location('set context value before calling fast formula', 100);
672:
673: pay_balance_pkg.set_context('ASSIGNMENT_ID'
674: , p_asg.assignment_id);
675: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID'
676: , p_asg.assignment_action_id);
677: pay_balance_pkg.set_context('DATE_EARNED'
678: , fnd_date.date_to_canonical(p_absence_arch.date_earned));
679: pay_balance_pkg.set_context('BUSINESS_GROUP_ID'

Line 677: pay_balance_pkg.set_context('DATE_EARNED'

673: pay_balance_pkg.set_context('ASSIGNMENT_ID'
674: , p_asg.assignment_id);
675: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID'
676: , p_asg.assignment_action_id);
677: pay_balance_pkg.set_context('DATE_EARNED'
678: , fnd_date.date_to_canonical(p_absence_arch.date_earned));
679: pay_balance_pkg.set_context('BUSINESS_GROUP_ID'
680: , p_asg.business_group_id);
681: pay_balance_pkg.set_context('PAYROLL_ID'

Line 679: pay_balance_pkg.set_context('BUSINESS_GROUP_ID'

675: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID'
676: , p_asg.assignment_action_id);
677: pay_balance_pkg.set_context('DATE_EARNED'
678: , fnd_date.date_to_canonical(p_absence_arch.date_earned));
679: pay_balance_pkg.set_context('BUSINESS_GROUP_ID'
680: , p_asg.business_group_id);
681: pay_balance_pkg.set_context('PAYROLL_ID'
682: , p_asg.payroll_id);
683: pay_balance_pkg.set_context('ELEMENT_ENTRY_ID'

Line 681: pay_balance_pkg.set_context('PAYROLL_ID'

677: pay_balance_pkg.set_context('DATE_EARNED'
678: , fnd_date.date_to_canonical(p_absence_arch.date_earned));
679: pay_balance_pkg.set_context('BUSINESS_GROUP_ID'
680: , p_asg.business_group_id);
681: pay_balance_pkg.set_context('PAYROLL_ID'
682: , p_asg.payroll_id);
683: pay_balance_pkg.set_context('ELEMENT_ENTRY_ID'
684: , p_absence_arch.element_entry_id);
685:

Line 683: pay_balance_pkg.set_context('ELEMENT_ENTRY_ID'

679: pay_balance_pkg.set_context('BUSINESS_GROUP_ID'
680: , p_asg.business_group_id);
681: pay_balance_pkg.set_context('PAYROLL_ID'
682: , p_asg.payroll_id);
683: pay_balance_pkg.set_context('ELEMENT_ENTRY_ID'
684: , p_absence_arch.element_entry_id);
685:
686: /* Get input paramaters for fast formula */
687:

Line 1080: l_period_ref_sal :=pay_balance_pkg.get_value(l_ref_sal_bal_id,

1076: CLOSE csr_assignment_actions;
1077: -- find the balance value for each period
1078: hr_utility.set_location(' REF SAL BAL id :'||l_ref_sal_bal_id,40);
1079: hr_utility.set_location(' REF SAL ASAC id :'||l_assignment_action_id,40);
1080: l_period_ref_sal :=pay_balance_pkg.get_value(l_ref_sal_bal_id,
1081: l_assignment_action_id);
1082: */
1083: -- limit the total balance value to SS ceiling
1084: OPEN csr_global_value('FR_MONTHLY_SS_CEILING',l_date_earned);

Line 1247: l_total_ref_sal_bal := pay_balance_pkg.get_value(l_ref_sal_bal_id,

1243: -- find the balance value for this period
1244: hr_utility.set_location(' OCCUP ',40);
1245: hr_utility.set_location(' REF SAL BAL id :'||l_ref_sal_bal_id,40);
1246: hr_utility.set_location(' REF SAL ASAC id :'||l_assignment_action_id,40);
1247: l_total_ref_sal_bal := pay_balance_pkg.get_value(l_ref_sal_bal_id,
1248: l_assignment_action_id);
1249: */
1250: -- Check for new hires
1251: IF l_orig_hiredate > l_ref_start_dt THEN

Line 2522: pay_balance_pkg.get_value

2518: --
2519: while add_months(p_balance_start_date,i) <= p_balance_end_date loop
2520: BEGIN
2521: l_value := l_value +
2522: pay_balance_pkg.get_value
2523: (l_defined_balance_id
2524: ,p_assignment_id
2525: ,add_months(p_balance_start_date,i+1)-1);
2526:

Line 3552: l_value := pay_balance_pkg.get_value

3548: --
3549: hr_utility.set_location(' Entering:'|| l_proc,30);
3550: -- Added condition for CPAM processing
3551: IF g_absence_calc.initiator = 'CPAM' THEN
3552: l_value := pay_balance_pkg.get_value
3553: (l_defined_balance_id
3554: ,p_asg.assignment_id
3555: ,g_absence_calc.abs_ptd_end_date);
3556: ELSE

Line 3557: l_value := pay_balance_pkg.get_value

3553: (l_defined_balance_id
3554: ,p_asg.assignment_id
3555: ,g_absence_calc.abs_ptd_end_date);
3556: ELSE
3557: l_value := pay_balance_pkg.get_value
3558: (l_defined_balance_id
3559: ,p_asg.assignment_action_id);
3560: END IF;
3561: --

Line 4267: P_Absence_arch.ded_ref_salary := Nvl(pay_balance_pkg.get_value(

4263: open c_get_defined_balance('FR_SICKNESS_DEDUCTION_REFERENCE_SALARY');
4264: fetch c_get_defined_balance into l_defined_balance_id;
4265: close c_get_defined_balance;
4266: --
4267: P_Absence_arch.ded_ref_salary := Nvl(pay_balance_pkg.get_value(
4268: P_DEFINED_BALANCE_ID => l_defined_balance_id
4269: ,P_ASSIGNMENT_ID => p_assignment_id
4270: ,P_VIRTUAL_DATE => g_absence_calc.abs_ptd_end_date),0);
4271: open c_get_defined_balance('FR_SICKNESS_LEGAL_GUARANTEE_REFERENCE_SALARY');

Line 4275: P_Absence_arch.lg_ref_salary := Nvl(pay_balance_pkg.get_value(

4271: open c_get_defined_balance('FR_SICKNESS_LEGAL_GUARANTEE_REFERENCE_SALARY');
4272: fetch c_get_defined_balance into l_defined_balance_id;
4273: close c_get_defined_balance;
4274: --
4275: P_Absence_arch.lg_ref_salary := Nvl(pay_balance_pkg.get_value(
4276: P_DEFINED_BALANCE_ID => l_defined_balance_id
4277: ,P_ASSIGNMENT_ID => p_assignment_id
4278: ,P_VIRTUAL_DATE => g_absence_calc.abs_ptd_end_date),0);
4279: --