DBA Data[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;