APPS.PAY_IP_PAYROLL_ARCH dependencies on PAY_BALANCE_PKG

Line 506: ln_ytd_amount := NVL(pay_balance_pkg.get_value(

502: IF lv_is_element_archived = 'N' THEN -- if 1
503: ln_step := 6;
504: hr_utility.set_location(gv_package || lv_procedure_name, 40);
505: IF ln_ytd_defined_balance_id IS NOT NULL THEN -- if 2
506: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
507: ln_ytd_defined_balance_id,
508: p_ytd_balcall_aaid),0);
509: ELSE
510: lv_balance_name := pay_ip_utility.get_balance_name(p_primary_balance_id);

Line 524: ln_ytd_hours := NVL(pay_balance_pkg.get_value(

520:
521: IF p_hours_balance_id IS NOT NULL THEN -- if 3
522: hr_utility.set_location(gv_package || lv_procedure_name, 50);
523: IF ln_ytd_hours_def_balance_id IS NOT NULL THEN -- if 4
524: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
525: ln_ytd_hours_def_balance_id,
526: p_ytd_balcall_aaid),0);
527: hr_utility.set_location(gv_package || lv_procedure_name, 60);
528: ELSE

Line 576: ln_payments_amount := NVL(pay_balance_pkg.get_value(

572: Prepayment assignment_action_id will be passed to the balance
573: call to get the sum of the run result values of the all run
574: actions which are locked by the prepayment.
575: ******************************************************************/
576: ln_payments_amount := NVL(pay_balance_pkg.get_value(
577: ln_pymt_defined_balance_id, --p_pymt_balcall_aaid
578: p_pymt_assignment_action_id),0); /*p_pymt_assignment_action_id prepayment assignment action */
579: hr_utility.trace('ln_payments_amount = ' ||ln_payments_amount);
580: hr_utility.set_location(gv_package || lv_procedure_name, 80);

Line 621: ln_current_hours := NVL(pay_balance_pkg.get_value(

617:
618: hr_utility.trace('ln_pymt_hours_balance_id '||ln_pymt_hours_balance_id);
619:
620: IF ln_pymt_hours_balance_id IS NOT NULL THEN --if 12
621: ln_current_hours := NVL(pay_balance_pkg.get_value(
622: ln_pymt_hours_balance_id,
623: p_pymt_assignment_action_id),0); /*p_pymt_assignment_action_id prepayment assignment action */
624: ELSE
625:

Line 897: ln_ytd_amount := NVL(pay_balance_pkg.get_value(

893: gv_ytd_balance_dimension,
894: p_legislation_code);
895: hr_utility.set_location(gv_package || lv_procedure_name, 60);
896: IF ln_ytd_defined_balance_id IS NOT NULL THEN
897: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
898: ln_ytd_defined_balance_id,
899: p_ytd_balcall_aaid),0);
900: hr_utility.set_location(gv_package || lv_procedure_name, 70);
901: ELSE

Line 924: ln_ytd_hours := NVL(pay_balance_pkg.get_value(

920: gv_ytd_balance_dimension,
921: p_legislation_code);
922: hr_utility.set_location(gv_package || lv_procedure_name, 80);
923: IF ln_ytd_hours_balance_id IS NOT NULL THEN
924: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
925: ln_ytd_hours_balance_id,
926: p_ytd_balcall_aaid),0);
927: hr_utility.set_location(gv_package || lv_procedure_name, 90);
928: ELSE

Line 1273: ln_ytd_amount := NVL(pay_balance_pkg.get_value(

1269: gv_ytd_balance_dimension,
1270: p_legislation_code);
1271: hr_utility.set_location(gv_package || lv_procedure_name, 60);
1272: IF ln_ytd_defined_balance_id IS NOT NULL THEN
1273: ln_ytd_amount := NVL(pay_balance_pkg.get_value(
1274: ln_ytd_defined_balance_id,
1275: p_ytd_balcall_aaid),0);
1276: ELSE
1277: hr_utility.trace('YTD Dimension is not set for Primary balance '||ln_ytd_defined_balance_id);

Line 1298: ln_ytd_hours := NVL(pay_balance_pkg.get_value(

1294: gv_ytd_balance_dimension,
1295: p_legislation_code);
1296: hr_utility.set_location(gv_package || lv_procedure_name, 80);
1297: IF ln_ytd_hours_balance_id IS NOT NULL THEN
1298: ln_ytd_hours := NVL(pay_balance_pkg.get_value(
1299: ln_ytd_hours_balance_id,
1300: p_ytd_balcall_aaid),0);
1301: hr_utility.set_location(gv_package || lv_procedure_name, 90);
1302: ELSE

Line 2958: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);

2954: i := 0;
2955: j := 0;
2956:
2957: IF gv_is_tax_unit_enabled = 'Y' THEN
2958: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
2959: END IF;
2960:
2961: hr_utility.set_location(gv_package || lv_procedure_name, 20);
2962: ln_step := 2;

Line 2970: ln_amount := NVL(pay_balance_pkg.get_value(

2966:
2967: ln_amount := 0;
2968:
2969: ln_step := 2;
2970: ln_amount := NVL(pay_balance_pkg.get_value(
2971: dbt(i).def_bal_id,
2972: p_pre_pay_action_id),0); /*pre payment action id*/
2973:
2974: hr_utility.set_location(gv_package || lv_procedure_name, 30);

Line 4577: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);

4573: ln_step := 20;
4574: hr_utility.set_location(gv_package || lv_procedure_name, 90);
4575:
4576: IF gv_is_tax_unit_enabled = 'Y' THEN
4577: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
4578: END IF;
4579: hr_utility.trace('ln_asg_action_id = '||ln_asg_action_id);
4580: ln_earnings := NVL(pay_balance_pkg.get_value(
4581: gn_payments_def_bal_id, /*Total Payment Balance with dimension _PAYMENTS*/

Line 4580: ln_earnings := NVL(pay_balance_pkg.get_value(

4576: IF gv_is_tax_unit_enabled = 'Y' THEN
4577: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
4578: END IF;
4579: hr_utility.trace('ln_asg_action_id = '||ln_asg_action_id);
4580: ln_earnings := NVL(pay_balance_pkg.get_value(
4581: gn_payments_def_bal_id, /*Total Payment Balance with dimension _PAYMENTS*/
4582: ln_asg_action_id),0);
4583: hr_utility.trace('ln_earnings = ' ||ln_earnings);
4584: