[Home] [Help]
PACKAGE: APPS.PAY_IE_ARCHIVE_DETAIL_PKG
Source
1 PACKAGE PAY_IE_ARCHIVE_DETAIL_PKG as
2 /* $Header: pyieelin.pkh 120.1 2006/12/11 13:39:45 sgajula noship $ */
3 --
4 /*
5 MODIFIED (DD-MON-YYYY)
6 ILeath 08-NOV-2001 - Initial Version
7 aashokan 17-DEC-2004 - Bug 4069789
8 aashokan 23-DEC-2004 - Bug 40683856
9 sgajula 11-DEC-2006 - Bug 5696117
10 */
11 -- Bug 5696117 added global variables to enable caching in get_paypathid to
12 -- improve the performance
13 g_payroll_id pay_payrolls_f.payroll_id%TYPE;
14 g_consolidation_set_id pay_consolidation_sets.consolidation_set_id%TYPE;
15 g_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
16 g_paypathid varchar2(150);
17 FUNCTION get_tax_details(p_run_assignment_action_id number,
18 p_input_value_id number,
19 p_date_earned varchar2)
20 return varchar2;
21
22 FUNCTION get_parameter(p_payroll_action_id NUMBER,
23 p_token_name VARCHAR2) RETURN VARCHAR2;
24 /*Bug 40683856*/
25 PROCEDURE get_parameters(p_payroll_action_id IN NUMBER,
26 p_token_name IN VARCHAR2,
27 p_token_value OUT NOCOPY VARCHAR2);
28 FUNCTION GET_PAYPATHID return varchar2; -- Bug No 3060464
29
30 END PAY_IE_ARCHIVE_DETAIL_PKG;