1 PACKAGE PSP_ARCHIVE_RETRIEVE AUTHID CURRENT_USER as
2 /* $Header: PSPARRTS.pls 120.0.12020000.3 2012/07/04 09:06:19 amnaraya ship $ */
3 PROCEDURE archive_distribution( errbuf OUT NOCOPY VARCHAR2,
4 retcode OUT NOCOPY VARCHAR2,
5 p_payroll_id IN NUMBER,
6 p_begin_period IN NUMBER,
7 p_end_period IN NUMBER,
8 p_business_group_id IN NUMBER,
9 p_set_of_books_id IN NUMBER);
10
11 PROCEDURE retrieve_distribution(errbuf OUT NOCOPY VARCHAR2,
12 retcode OUT NOCOPY VARCHAR2,
13 p_payroll_id IN NUMBER,
14 p_begin_period IN NUMBER,
15 p_end_period IN NUMBER,
16 p_business_group_id IN NUMBER,
17 p_set_of_books_id IN NUMBER);
18
19 PROCEDURE archive_encumbrance( errbuf OUT NOCOPY VARCHAR2,
20 retcode OUT NOCOPY VARCHAR2,
21 p_payroll_id IN NUMBER,
22 p_begin_period IN NUMBER,
23 p_end_period IN NUMBER,
24 p_business_group_id IN NUMBER,
25 p_set_of_books_id IN NUMBER);
26
27 PROCEDURE retrieve_encumbrance(errbuf OUT NOCOPY VARCHAR2,
28 retcode OUT NOCOPY VARCHAR2,
29 p_payroll_id IN NUMBER,
30 p_begin_period IN NUMBER,
31 p_end_period IN NUMBER,
32 p_business_group_id IN NUMBER,
33 p_set_of_books_id IN NUMBER);
34
35 PROCEDURE archive_distribution_int (errbuf OUT NOCOPY VARCHAR2,
36 retcode OUT NOCOPY VARCHAR2,
37 p_archival_code IN VARCHAR2, -- for user to remember the request easily, map this to request_id internally
38 p_begin_date IN VARCHAR2,
39 p_end_date IN VARCHAR2);
40
41
42
43 PROCEDURE retrieve_distribution_int (errbuf OUT NOCOPY VARCHAR2,
44 retcode OUT NOCOPY VARCHAR2,
45 p_arch_request_id IN NUMBER);
46
47
48 /* Following variable is added for bug 2482603 */
49 g_error_api_path VARCHAR2(1000) := '';
50 g_debug_enabled BOOLEAN := FALSE;
51 END PSP_ARCHIVE_RETRIEVE;