[Home] [Help]
PACKAGE: APPS.PAY_IN_SOE
Source
1 PACKAGE pay_in_soe AS
2 /* $Header: pyinsoe.pkh 120.0.12010000.1 2008/07/27 22:54:30 appldev ship $ */
3
4 --------------------------------------------------------------------------
5 -- --
6 -- Name : GET_TEMPLATE --
7 -- Type : PROCEDURE --
8 -- Access : Public --
9 -- Description : This procedure gets the payslip template code set at--
10 -- organization level.If no template is set default --
11 -- template code is returned --
12 -- --
13 -- Parameters : --
14 -- IN : p_business_group_id NUMBER --
15 -- OUT : p_template VARCHAR2 --
16 --------------------------------------------------------------------------
17 --
18
19 PROCEDURE get_template (
20 p_business_group_id IN NUMBER
21 ,p_template OUT NOCOPY VARCHAR2
22 );
23
24 --------------------------------------------------------------------------
25 -- --
26 -- Name : FETCH_XML --
27 -- Type : PROCEDURE --
28 -- Access : Public --
29 -- Description : This procedure returns the next CLOB available in --
30 -- global CLOB array --
31 -- --
32 -- Parameters : --
33 -- IN : N/A --
34 -- OUT : p_clob CLOB --
35 --------------------------------------------------------------------------
36 --
37 PROCEDURE fetch_xml (
38 p_clob OUT NOCOPY CLOB
39 );
40
41 --------------------------------------------------------------------------
42 -- --
43 -- Name : LOAD_XML --
44 -- Type : PROCEDURE --
45 -- Access : Public --
46 -- Description : This procedure makes a list of XMLs in a global --
47 -- CLOB array --
48 -- --
49 -- Parameters : --
50 -- IN : p_business_group_id NUMBER --
51 -- p_start_date VARCHAR2 --
52 -- p_end_date VARCHAR2 --
53 -- p_payroll_id NUMBER --
54 -- p_consolidation_set_id NUMBER --
55 -- p_sort_order1 VARCHAR2 --
56 -- p_sort_order2 VARCHAR2 --
57 -- p_sort_order3 VARCHAR2 --
58 -- p_sort_order4 VARCHAR2 --
59 -- OUT : p_clob_cnt NUMBER --
60 --------------------------------------------------------------------------
61 --
62 PROCEDURE load_xml (
63 p_business_group_id IN NUMBER
64 ,p_start_date IN VARCHAR2
65 ,p_end_date IN VARCHAR2
66 ,p_payroll_id IN NUMBER DEFAULT NULL
67 ,p_consolidation_set_id IN NUMBER DEFAULT NULL
68 ,p_sort_order1 IN VARCHAR2 DEFAULT NULL
69 ,p_sort_order2 IN VARCHAR2 DEFAULT NULL
70 ,p_sort_order3 IN VARCHAR2 DEFAULT NULL
71 ,p_sort_order4 IN VARCHAR2 DEFAULT NULL
72 ,p_clob_cnt OUT NOCOPY NUMBER
73 );
74 --
75 END pay_in_soe;