[Home] [Help]
240: g_ptu_bal_details entity_details_tab;
241: ---------------------------------------------------------------------------------------------------------------------------+
242: --For year end Balances define global variable to store defined_balance_id's and the corresponding balance values for BBR.
243: ---------------------------------------------------------------------------------------------------------------------------+
244: g_ye_balance_value_tab pay_balance_pkg.t_balance_value_tab;
245: ---------------------------------------------------------------------------------------------------------------------------+
246: --For year end Balances define global variable to store defined_balance_id's and the corresponding balance values for BBR.
247: ---------------------------------------------------------------------------------------------------------------------------+
248: g_ptu_balance_value_tab pay_balance_pkg.t_balance_value_tab;
244: g_ye_balance_value_tab pay_balance_pkg.t_balance_value_tab;
245: ---------------------------------------------------------------------------------------------------------------------------+
246: --For year end Balances define global variable to store defined_balance_id's and the corresponding balance values for BBR.
247: ---------------------------------------------------------------------------------------------------------------------------+
248: g_ptu_balance_value_tab pay_balance_pkg.t_balance_value_tab;
249: --------------------------------------------------------------------------
250:
251: -- --
252: -- Name : load_ye_balance --
675: ln_index NUMBER;
676:
677: ltab_entity_det entity_details_tab;
678: ln_count NUMBER;
679: lt_ye_bal_context_tab pay_balance_pkg.t_context_tab;
680: lt_ye_bal_result_tab pay_balance_pkg.t_detailed_bal_out_tab;
681: lt_ptu_bal_result_tab pay_balance_pkg.t_detailed_bal_out_tab;
682:
683: ln_isr_withheld_val VARCHAR2(240);
676:
677: ltab_entity_det entity_details_tab;
678: ln_count NUMBER;
679: lt_ye_bal_context_tab pay_balance_pkg.t_context_tab;
680: lt_ye_bal_result_tab pay_balance_pkg.t_detailed_bal_out_tab;
681: lt_ptu_bal_result_tab pay_balance_pkg.t_detailed_bal_out_tab;
682:
683: ln_isr_withheld_val VARCHAR2(240);
684: ln_tax_to_charge_val VARCHAR2(240);
677: ltab_entity_det entity_details_tab;
678: ln_count NUMBER;
679: lt_ye_bal_context_tab pay_balance_pkg.t_context_tab;
680: lt_ye_bal_result_tab pay_balance_pkg.t_detailed_bal_out_tab;
681: lt_ptu_bal_result_tab pay_balance_pkg.t_detailed_bal_out_tab;
682:
683: ln_isr_withheld_val VARCHAR2(240);
684: ln_tax_to_charge_val VARCHAR2(240);
685: ln_isr_withheld_aid NUMBER;
696: lt_ye_bal_context_tab(1).tax_unit_id := p_tax_unit_id;
697:
698: hr_utility.trace('Entering ' || gv_package || lv_procedure_name);
699: --
700: -- pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
701:
702: -- Create the Archive DBI routes if they don't exist
703: --
704: hr_utility.set_location(gv_package || lv_procedure_name, 10);
707: hr_utility.trace('p_ytd_action_id ' || p_ytd_action_id);
708: /*Modified the code logic, by using BBR for bug 7529502*/
709: IF p_prev_archiver_exists = 'Y' THEN
710:
711: pay_balance_pkg.get_value
712: (p_assignment_action_id => p_ytd_action_id
713: ,p_defined_balance_lst => g_ptu_balance_value_tab
714: ,p_context_lst => lt_ye_bal_context_tab
715: ,p_output_table => lt_ptu_bal_result_tab
734:
735: END LOOP;
736: ELSE
737: --
738: pay_balance_pkg.get_value
739: (p_assignment_action_id => p_ytd_action_id
740: ,p_defined_balance_lst => g_ye_balance_value_tab
741: ,p_context_lst => lt_ye_bal_context_tab
742: ,p_output_table => lt_ye_bal_result_tab
1730: -- Get the creditable and non-creditable subsidy for the person under
1731: -- the current employer
1732: /*CURSOR c_get_subsidy(cp_ytd_action_id NUMBER
1733: ) IS
1734: SELECT pay_balance_pkg.get_value(pdb_cr.defined_balance_id,
1735: cp_ytd_action_id),
1736: pay_balance_pkg.get_value(pdb_ncr.defined_balance_id,
1737: cp_ytd_action_id)
1738: FROM pay_defined_balances pdb_cr,
1732: /*CURSOR c_get_subsidy(cp_ytd_action_id NUMBER
1733: ) IS
1734: SELECT pay_balance_pkg.get_value(pdb_cr.defined_balance_id,
1735: cp_ytd_action_id),
1736: pay_balance_pkg.get_value(pdb_ncr.defined_balance_id,
1737: cp_ytd_action_id)
1738: FROM pay_defined_balances pdb_cr,
1739: pay_defined_balances pdb_ncr,
1740: pay_balance_types pbt_cr,
1754: -- Get the ISR Calculated, creditable and non-creditable subsidy
1755: -- for the person under the current employer
1756: CURSOR c_get_subsidy(cp_ytd_action_id NUMBER
1757: ) IS
1758: SELECT pay_balance_pkg.get_value(pdb_cr.defined_balance_id,
1759: cp_ytd_action_id)
1760: FROM pay_defined_balances pdb_cr,
1761: pay_balance_types pbt_cr,
1762: pay_balance_dimensions pbd
1767: AND pbt_cr.legislation_code = 'MX';
1768:
1769: CURSOR c_get_nonsubsidy(cp_ytd_action_id NUMBER
1770: ) IS
1771: select pay_balance_pkg.get_value(pdb_ncr.defined_balance_id,
1772: cp_ytd_action_id)
1773: FROM pay_defined_balances pdb_ncr,
1774: pay_balance_types pbt_ncr,
1775: pay_balance_dimensions pbd
1781: AND pbd.legislation_code = pbt_ncr.legislation_code;
1782:
1783: CURSOR c_get_calc(cp_ytd_action_id NUMBER
1784: ) IS
1785: select pay_balance_pkg.get_value(pdb_calc.defined_balance_id,
1786: cp_ytd_action_id)
1787: FROM pay_defined_balances pdb_calc,
1788: pay_balance_types pbt_calc,
1789: pay_balance_dimensions pbd
2054: END IF;
2055:
2056: CLOSE c_get_ytd_aaid;
2057:
2058: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
2059:
2060: ln_step := 5;
2061: hr_utility.set_location(gv_package || lv_procedure_name, 80);
2062:
2303:
2304: hr_utility.trace('--Before calling populate_balances--');
2305: hr_utility.trace('--TAX_UNIT_ID--'||ln_tax_unit_id);
2306: hr_utility.trace('--YTD ASSACT ID--'||ln_ytd_aa_id);
2307: pay_balance_pkg.set_context('TAX_UNIT_ID', ln_tax_unit_id);
2308:
2309: populate_balances(p_archive_action_id => p_archive_action_id
2310: ,p_ytd_action_id => ln_ytd_aa_id
2311: ,p_tax_unit_id => ln_tax_unit_id