1: PACKAGE BODY pay_ip_employee_balances AS
2: /* $Header: payipempbalance.pkb 120.6.12020000.1 2012/08/29 05:51:05 sjawid noship $ */
3:
4: /*******************************************************************************************
5: ******************************************************************
17: * 500 Oracle Parkway, Redwood City, CA, 94065. *
18: * *
19: ******************************************************************
20:
21: Name : pay_ip_employee_balances
22:
23: Description : The package is used by the Employee Balances SS Page
24: to fetch the earnings and deduction balances.
25:
217: This data in pay_us_rpt_totals is later queried by the SS Page and
218: displayed in the Results Region.
219: ********************************************************************************************/
220:
221: l_package VARCHAR2(30) := 'pay_ip_employee_balances.';
222: t_eb_bal_context_tab pay_balance_pkg.t_context_tab;
223: t_eb_bal_result_tab pay_balance_pkg.t_detailed_bal_out_tab;
224: t_eb_balance_value_tab pay_balance_pkg.t_balance_value_tab;
225:
1813: hr_utility.set_location(l_package||l_procedure, 320);
1814: raise_application_error(-20101, 'Error in '||l_package||l_procedure || ' - ' || sqlerrm);
1815: END;
1816:
1817: END pay_ip_employee_balances;
1818: