[Home] [Help]
PACKAGE: APPS.PAY_IN_SOE
Source
1 PACKAGE pay_in_soe AUTHID CURRENT_USER AS
2 /* $Header: pyinsoe.pkh 120.5.12020000.1 2012/06/28 18:15:32 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 -- Name : GET_EMP_ADDRESS --
43 -- Type : FUNCTION --
44 -- Access : Public --
45 -- Description : This function returns Emp Address --
46 -- --
47 -- Parameters : --
48 -- IN : p_person_id NUMBER --
49 -- IN : p_date DATE --
50 --------------------------------------------------------------------------
51 --
52 FUNCTION get_emp_address(p_person_id NUMBER
53 ,p_date DATE )
54 RETURN VARCHAR2;
55
56 --------------------------------------------------------------------------
57 -- --
58 -- Name : GET_EMP_EMAIL --
59 -- Type : FUNCTION --
60 -- Access : Public --
61 -- Description : This function returns Employee Email ID --
62 -- --
63 -- Parameters : --
64 -- IN : p_assign_action_id NUMBER --
65 --------------------------------------------------------------------------
66 --
67 FUNCTION get_emp_email(p_assign_action_id NUMBER)
68 RETURN VARCHAR2 ;
69
70 --------------------------------------------------------------------------
71 -- --
72 -- Name : SUBMIT_REQ_XML_BURST --
73 -- Type : PROCEDURE --
74 -- Access : Public --
75 -- Description : This function submits the CP XDOBURSTREP to burst --
76 -- XML --
77 -- --
78 -- Parameters : --
79 -- IN : p_request_id NUMBER --
80 --------------------------------------------------------------------------
81 --
82 PROCEDURE submit_req_xml_burst(p_request_id IN NUMBER);
83
84 --------------------------------------------------------------------------
85 -- --
86 -- Name : LOAD_XML --
87 -- Type : PROCEDURE --
88 -- Access : Public --
89 -- Description : This procedure makes a list of XMLs in a global --
90 -- CLOB array --
91 -- --
92 -- Parameters : --
93 -- IN : p_business_group_id NUMBER --
94 -- p_start_date VARCHAR2 --
95 -- p_end_date VARCHAR2 --
96 -- p_payroll_id NUMBER --
97 -- p_consolidation_set_id NUMBER --
98 -- p_assignment_set_id NUMBER --
99 -- p_employee_number NUMBER --
100 -- p_sort_order1 VARCHAR2 --
101 -- p_sort_order2 VARCHAR2 --
102 -- p_sort_order3 VARCHAR2 --
103 -- p_sort_order4 VARCHAR2 --
104 -- OUT : p_clob_cnt NUMBER --
105 --------------------------------------------------------------------------
106 --
107 PROCEDURE load_xml (
108 p_business_group_id IN NUMBER
109 ,p_start_date IN VARCHAR2
110 ,p_end_date IN VARCHAR2
111 ,p_payroll_id IN NUMBER DEFAULT NULL
112 ,p_consolidation_set_id IN NUMBER DEFAULT NULL
113 ,p_assignment_set_id IN NUMBER DEFAULT NULL
114 ,p_employee_number IN NUMBER DEFAULT NULL
115 ,p_sort_order1 IN VARCHAR2 DEFAULT NULL
116 ,p_sort_order2 IN VARCHAR2 DEFAULT NULL
117 ,p_sort_order3 IN VARCHAR2 DEFAULT NULL
118 ,p_sort_order4 IN VARCHAR2 DEFAULT NULL
119 ,p_clob_cnt OUT NOCOPY NUMBER
120 );
121
122 --------------------------------------------------------------------------
123 -- --
124 -- Name : LOAD_XML_BURST --
125 -- Type : PROCEDURE --
126 -- Access : Public --
127 -- Description : This procedure makes a list of XMLs in a global --
128 -- CLOB for xml burst --
129 -- --
130 -- Parameters : --
131 -- IN : p_business_group_id NUMBER --
132 -- p_start_date VARCHAR2 --
133 -- p_end_date VARCHAR2 --
134 -- p_payroll_id NUMBER --
135 -- p_consolidation_set_id NUMBER --
136 -- p_assignment_set_id NUMBER --
137 -- p_employee_number NUMBER --
138 -- p_sort_order1 VARCHAR2 --
139 -- p_sort_order2 VARCHAR2 --
140 -- p_sort_order3 VARCHAR2 --
141 -- p_sort_order4 VARCHAR2 --
142 -- OUT : p_xml CLOB --
143 --------------------------------------------------------------------------
144
145 PROCEDURE load_xml_burst (
146 p_business_group_id IN NUMBER
147 ,p_start_date IN VARCHAR2
148 ,p_end_date IN VARCHAR2
149 ,p_payroll_id IN NUMBER DEFAULT NULL
150 ,p_consolidation_set_id IN NUMBER DEFAULT NULL
151 ,p_assignment_set_id IN NUMBER DEFAULT NULL
152 ,p_employee_number IN NUMBER DEFAULT NULL
153 ,p_sort_order1 IN VARCHAR2 DEFAULT NULL
154 ,p_sort_order2 IN VARCHAR2 DEFAULT NULL
155 ,p_sort_order3 IN VARCHAR2 DEFAULT NULL
156 ,p_sort_order4 IN VARCHAR2 DEFAULT NULL
157 ,p_xml OUT NOCOPY CLOB
158 );
159 --
160 END pay_in_soe;