1 PACKAGE ghr_sf113_a AUTHID CURRENT_USER AS
2 /* $Header: ghsf113a.pkh 120.1 2006/07/14 21:48:02 deenath ship $ */
3 --
4 --
5 Function get_org_info(p_business_group_id IN number)
6 return varchar2 ;
7 -- pragma restrict_references (get_org_info, WNDS);
8 --
9 --
10 Function validate_agcy (p_agcy IN varchar2,
11 p_segment IN varchar2)
12 return boolean;
13 -- pragma restrict_references (validate_agency, WNDS);
14 --
15 --
16 Procedure sf113a_sec1 ( p_rpt_date IN date
17 ,p_empl_as_of_date IN date
18 ,p_agcy IN varchar2
19 ,p_segment IN varchar2
20 ,p_l1a IN OUT NOCOPY number
21 ,p_l1b IN OUT NOCOPY number
22 ,p_l1c IN OUT NOCOPY number
23 ,p_l1d IN OUT NOCOPY number
24 ,p_l1e IN OUT NOCOPY number
25 ,p_l2a IN OUT NOCOPY number
26 ,p_l2b IN OUT NOCOPY number
27 ,p_l2c IN OUT NOCOPY number
28 ,p_l2d IN OUT NOCOPY number
29 ,p_l2e IN OUT NOCOPY number
30 ,p_l3a IN OUT NOCOPY number
31 ,p_l3b IN OUT NOCOPY number
32 ,p_l3c IN OUT NOCOPY number
33 ,p_l3d IN OUT NOCOPY number
34 ,p_l3e IN OUT NOCOPY number
35 ,p_l4a IN OUT NOCOPY number
36 ,p_l4b IN OUT NOCOPY number
37 ,p_l4c IN OUT NOCOPY number
38 ,p_l4d IN OUT NOCOPY number
39 ,p_l4e IN OUT NOCOPY number
40 ,p_l5a IN OUT NOCOPY number
41 ,p_l5b IN OUT NOCOPY number
42 ,p_l5c IN OUT NOCOPY number
43 ,p_l5d IN OUT NOCOPY number
44 ,p_l5e IN OUT NOCOPY number
45 ,p_l6a IN OUT NOCOPY number
46 ,p_l6b IN OUT NOCOPY number
47 ,p_l6c IN OUT NOCOPY number
48 ,p_l6d IN OUT NOCOPY number
49 ,p_l6e IN OUT NOCOPY number
50 ,p_l7a IN OUT NOCOPY number
51 ,p_l7b IN OUT NOCOPY number
52 ,p_l7c IN OUT NOCOPY number
53 ,p_l7d IN OUT NOCOPY number
54 ,p_l7e IN OUT NOCOPY number
55 ,p_l8a IN OUT NOCOPY number
56 ,p_l8b IN OUT NOCOPY number
57 ,p_l8c IN OUT NOCOPY number
58 ,p_l8d IN OUT NOCOPY number
59 ,p_l8e IN OUT NOCOPY number
60 ,p_l9a IN OUT NOCOPY number
61 ,p_l9b IN OUT NOCOPY number
62 ,p_l9c IN OUT NOCOPY number
63 ,p_l9d IN OUT NOCOPY number
64 ,p_l9e IN OUT NOCOPY number
65 ,p_l10a IN OUT NOCOPY number
66 ,p_l10b IN OUT NOCOPY number
67 ,p_l10c IN OUT NOCOPY number
68 ,p_l10d IN OUT NOCOPY number
69 ,p_l10e IN OUT NOCOPY number
70 ,p_l11a IN OUT NOCOPY number
71 ,p_l11b IN OUT NOCOPY number
72 ,p_l11c IN OUT NOCOPY number
73 ,p_l11d IN OUT NOCOPY number
74 ,p_l11e IN OUT NOCOPY number
75 ,p_l12a IN OUT NOCOPY number
76 ,p_l12b IN OUT NOCOPY number
77 ,p_l12c IN OUT NOCOPY number
78 ,p_l12d IN OUT NOCOPY number
79 ,p_l12e IN OUT NOCOPY number
80 ,p_l13a IN OUT NOCOPY number
81 ,p_l13b IN OUT NOCOPY number
82 ,p_l13c IN OUT NOCOPY number
83 ,p_l13d IN OUT NOCOPY number
84 ,p_l13e IN OUT NOCOPY number
85 ,p_l14a IN OUT NOCOPY number
86 ,p_l14b IN OUT NOCOPY number
87 ,p_l14c IN OUT NOCOPY number
88 ,p_l14d IN OUT NOCOPY number
89 ,p_l14e IN OUT NOCOPY number
90 ,p_l15a IN OUT NOCOPY number
91 ,p_l15b IN OUT NOCOPY number
92 ,p_l15c IN OUT NOCOPY number
93 ,p_l15d IN OUT NOCOPY number
94 ,p_l15e IN OUT NOCOPY number
95 ,p_l16a IN OUT NOCOPY number
96 ,p_l16b IN OUT NOCOPY number
97 ,p_l16c IN OUT NOCOPY number
98 ,p_l16d IN OUT NOCOPY number
99 ,p_l16e IN OUT NOCOPY number
100 ,p_l29a IN OUT NOCOPY number
101 ,p_l29b IN OUT NOCOPY number
102 ,p_l29c IN OUT NOCOPY number
103 ,p_l29d IN OUT NOCOPY number
104 ,p_l29e IN OUT NOCOPY number
105 ,p_l30a IN OUT NOCOPY number
106 ,p_l30b IN OUT NOCOPY number
107 ,p_l30c IN OUT NOCOPY number
108 ,p_l30d IN OUT NOCOPY number
109 ,p_l30e IN OUT NOCOPY number);
110 --
111 --
112 --
113 Procedure sf113a_sec2 (p_agcy IN varchar2
114 ,p_rpt_date IN date
115 ,p_empl_as_of_date IN date
116 ,p_pay_from IN date
117 ,p_pay_to IN date
118 ,p_segment IN varchar2
119 ,p_l17a IN OUT NOCOPY number
120 ,p_l17b IN OUT NOCOPY number
121 ,p_l17c IN OUT NOCOPY number
122 ,p_l17d IN OUT NOCOPY number
123 ,p_l17e IN OUT NOCOPY number
124 ,p_l18a IN OUT NOCOPY number
125 ,p_l18b IN OUT NOCOPY number
126 ,p_l18c IN OUT NOCOPY number
127 ,p_l18d IN OUT NOCOPY number
128 ,p_l18e IN OUT NOCOPY number
129 ,p_l31a IN OUT NOCOPY number
130 ,p_l31b IN OUT NOCOPY number
131 ,p_l31c IN OUT NOCOPY number
132 ,p_l31d IN OUT NOCOPY number
133 ,p_l31e IN OUT NOCOPY number);
134 --
135 --
136 --
137 Procedure sf113a_sec3 (p_agcy IN varchar2
138 ,p_rpt_date IN date
139 ,p_empl_as_of_date IN date
140 ,p_last_rpt_date IN date
141 ,p_pay_from IN date
142 ,p_pay_to IN date
143 ,p_segment IN varchar2
144 ,p_l19a IN OUT NOCOPY number
145 ,p_l19b IN OUT NOCOPY number
146 ,p_l19c IN OUT NOCOPY number
147 ,p_l19d IN OUT NOCOPY number
148 ,p_l19e IN OUT NOCOPY number
149 ,p_l20a IN OUT NOCOPY number
150 ,p_l20b IN OUT NOCOPY number
151 ,p_l20c IN OUT NOCOPY number
152 ,p_l20d IN OUT NOCOPY number
153 ,p_l20e IN OUT NOCOPY number
154 ,p_l21a IN OUT NOCOPY number
155 ,p_l21b IN OUT NOCOPY number
156 ,p_l21c IN OUT NOCOPY number
157 ,p_l21d IN OUT NOCOPY number
158 ,p_l21e IN OUT NOCOPY number
159 ,p_l22a IN OUT NOCOPY number
160 ,p_l22b IN OUT NOCOPY number
161 ,p_l22c IN OUT NOCOPY number
162 ,p_l22d IN OUT NOCOPY number
163 ,p_l22e IN OUT NOCOPY number
164 ,p_l23a IN OUT NOCOPY number
165 ,p_l23b IN OUT NOCOPY number
166 ,p_l23c IN OUT NOCOPY number
167 ,p_l23d IN OUT NOCOPY number
168 ,p_l23e IN OUT NOCOPY number
169 ,p_l24a IN OUT NOCOPY number
170 ,p_l24b IN OUT NOCOPY number
171 ,p_l24c IN OUT NOCOPY number
172 ,p_l24d IN OUT NOCOPY number
173 ,p_l24e IN OUT NOCOPY number
174 ,p_l25a IN OUT NOCOPY number
175 ,p_l25b IN OUT NOCOPY number
176 ,p_l25c IN OUT NOCOPY number
177 ,p_l25d IN OUT NOCOPY number
178 ,p_l25e IN OUT NOCOPY number
179 ,p_l26a IN OUT NOCOPY number
180 ,p_l26b IN OUT NOCOPY number
181 ,p_l26c IN OUT NOCOPY number
182 ,p_l26d IN OUT NOCOPY number
183 ,p_l26e IN OUT NOCOPY number
184 ,p_l27a IN OUT NOCOPY number
185 ,p_l27b IN OUT NOCOPY number
186 ,p_l27c IN OUT NOCOPY number
187 ,p_l27d IN OUT NOCOPY number
188 ,p_l27e IN OUT NOCOPY number
189 ,p_l28a IN OUT NOCOPY number
190 ,p_l28b IN OUT NOCOPY number
191 ,p_l28c IN OUT NOCOPY number
192 ,p_l28d IN OUT NOCOPY number
193 ,p_l28e IN OUT NOCOPY number);
194 --
195 --
196 PROCEDURE ghr_sf113_payroll ( p_pay_from IN DATE,
197 p_pay_to IN DATE );
198 --
199 --This is the main procedure that generates the XML file for SF113A report.
200 PROCEDURE ghr_sf113a_out(errbuf OUT NOCOPY VARCHAR2,
201 retcode OUT NOCOPY NUMBER,
202 p_agency_code IN VARCHAR2,
203 p_agency_subelement IN VARCHAR2,
204 p_business_id IN NUMBER,
205 p_employment_as_of_date IN VARCHAR2,
206 p_pay_from IN VARCHAR2,
207 p_pay_to IN VARCHAR2,
208 p_previous_report_date IN VARCHAR2,
209 p_rpt_date IN VARCHAR2);
210 --
211 --This procedure replaces Zeroes with NULL.
212 PROCEDURE repl_zero(p_l1a IN OUT NOCOPY number
213 ,p_l1b IN OUT NOCOPY number
214 ,p_l1c IN OUT NOCOPY number
215 ,p_l1d IN OUT NOCOPY number
216 ,p_l1e IN OUT NOCOPY number
217 ,p_l2a IN OUT NOCOPY number
218 ,p_l2b IN OUT NOCOPY number
219 ,p_l2c IN OUT NOCOPY number
220 ,p_l2d IN OUT NOCOPY number
221 ,p_l2e IN OUT NOCOPY number
222 ,p_l3a IN OUT NOCOPY number
223 ,p_l3b IN OUT NOCOPY number
224 ,p_l3c IN OUT NOCOPY number
225 ,p_l3d IN OUT NOCOPY number
226 ,p_l3e IN OUT NOCOPY number
227 ,p_l4a IN OUT NOCOPY number
228 ,p_l4b IN OUT NOCOPY number
232 ,p_l5a IN OUT NOCOPY number
229 ,p_l4c IN OUT NOCOPY number
230 ,p_l4d IN OUT NOCOPY number
231 ,p_l4e IN OUT NOCOPY number
233 ,p_l5b IN OUT NOCOPY number
234 ,p_l5c IN OUT NOCOPY number
235 ,p_l5d IN OUT NOCOPY number
236 ,p_l5e IN OUT NOCOPY number
237 ,p_l6a IN OUT NOCOPY number
238 ,p_l6b IN OUT NOCOPY number
239 ,p_l6c IN OUT NOCOPY number
240 ,p_l6d IN OUT NOCOPY number
241 ,p_l6e IN OUT NOCOPY number
242 ,p_l7a IN OUT NOCOPY number
243 ,p_l7b IN OUT NOCOPY number
244 ,p_l7c IN OUT NOCOPY number
245 ,p_l7d IN OUT NOCOPY number
246 ,p_l7e IN OUT NOCOPY number
247 ,p_l8a IN OUT NOCOPY number
248 ,p_l8b IN OUT NOCOPY number
249 ,p_l8c IN OUT NOCOPY number
250 ,p_l8d IN OUT NOCOPY number
251 ,p_l8e IN OUT NOCOPY number
252 ,p_l9a IN OUT NOCOPY number
253 ,p_l9b IN OUT NOCOPY number
254 ,p_l9c IN OUT NOCOPY number
255 ,p_l9d IN OUT NOCOPY number
256 ,p_l9e IN OUT NOCOPY number
257 ,p_l10a IN OUT NOCOPY number
258 ,p_l10b IN OUT NOCOPY number
259 ,p_l10c IN OUT NOCOPY number
260 ,p_l10d IN OUT NOCOPY number
261 ,p_l10e IN OUT NOCOPY number
262 ,p_l11a IN OUT NOCOPY number
263 ,p_l11b IN OUT NOCOPY number
264 ,p_l11c IN OUT NOCOPY number
265 ,p_l11d IN OUT NOCOPY number
266 ,p_l11e IN OUT NOCOPY number
267 ,p_l12a IN OUT NOCOPY number
268 ,p_l12b IN OUT NOCOPY number
269 ,p_l12c IN OUT NOCOPY number
270 ,p_l12d IN OUT NOCOPY number
271 ,p_l12e IN OUT NOCOPY number
272 ,p_l13a IN OUT NOCOPY number
273 ,p_l13b IN OUT NOCOPY number
274 ,p_l13c IN OUT NOCOPY number
275 ,p_l13d IN OUT NOCOPY number
276 ,p_l13e IN OUT NOCOPY number
277 ,p_l14a IN OUT NOCOPY number
278 ,p_l14b IN OUT NOCOPY number
279 ,p_l14c IN OUT NOCOPY number
280 ,p_l14d IN OUT NOCOPY number
281 ,p_l14e IN OUT NOCOPY number
282 ,p_l15a IN OUT NOCOPY number
283 ,p_l15b IN OUT NOCOPY number
284 ,p_l15c IN OUT NOCOPY number
285 ,p_l15d IN OUT NOCOPY number
286 ,p_l15e IN OUT NOCOPY number
287 ,p_l16a IN OUT NOCOPY number
288 ,p_l16b IN OUT NOCOPY number
289 ,p_l16c IN OUT NOCOPY number
290 ,p_l16d IN OUT NOCOPY number
291 ,p_l16e IN OUT NOCOPY number
292 ,p_l17a IN OUT NOCOPY number
293 ,p_l17b IN OUT NOCOPY number
294 ,p_l17c IN OUT NOCOPY number
295 ,p_l17d IN OUT NOCOPY number
296 ,p_l17e IN OUT NOCOPY number
297 ,p_l18a IN OUT NOCOPY number
298 ,p_l18b IN OUT NOCOPY number
299 ,p_l18c IN OUT NOCOPY number
300 ,p_l18d IN OUT NOCOPY number
301 ,p_l18e IN OUT NOCOPY number
302 ,p_l19a IN OUT NOCOPY number
303 ,p_l19b IN OUT NOCOPY number
304 ,p_l19c IN OUT NOCOPY number
305 ,p_l19d IN OUT NOCOPY number
306 ,p_l19e IN OUT NOCOPY number
307 ,p_l20a IN OUT NOCOPY number
308 ,p_l20b IN OUT NOCOPY number
309 ,p_l20c IN OUT NOCOPY number
310 ,p_l20d IN OUT NOCOPY number
311 ,p_l20e IN OUT NOCOPY number
312 ,p_l21a IN OUT NOCOPY number
313 ,p_l21b IN OUT NOCOPY number
314 ,p_l21c IN OUT NOCOPY number
315 ,p_l21d IN OUT NOCOPY number
316 ,p_l21e IN OUT NOCOPY number
317 ,p_l22a IN OUT NOCOPY number
318 ,p_l22b IN OUT NOCOPY number
319 ,p_l22c IN OUT NOCOPY number
320 ,p_l22d IN OUT NOCOPY number
321 ,p_l22e IN OUT NOCOPY number
322 ,p_l23a IN OUT NOCOPY number
323 ,p_l23b IN OUT NOCOPY number
324 ,p_l23c IN OUT NOCOPY number
325 ,p_l23d IN OUT NOCOPY number
326 ,p_l23e IN OUT NOCOPY number
327 ,p_l24a IN OUT NOCOPY number
328 ,p_l24b IN OUT NOCOPY number
329 ,p_l24c IN OUT NOCOPY number
330 ,p_l24d IN OUT NOCOPY number
331 ,p_l24e IN OUT NOCOPY number
332 ,p_l25a IN OUT NOCOPY number
333 ,p_l25b IN OUT NOCOPY number
334 ,p_l25c IN OUT NOCOPY number
335 ,p_l25d IN OUT NOCOPY number
336 ,p_l25e IN OUT NOCOPY number
337 ,p_l26a IN OUT NOCOPY number
338 ,p_l26b IN OUT NOCOPY number
339 ,p_l26c IN OUT NOCOPY number
340 ,p_l26d IN OUT NOCOPY number
341 ,p_l26e IN OUT NOCOPY number
342 ,p_l27a IN OUT NOCOPY number
343 ,p_l27b IN OUT NOCOPY number
344 ,p_l27c IN OUT NOCOPY number
345 ,p_l27d IN OUT NOCOPY number
346 ,p_l27e IN OUT NOCOPY number
347 ,p_l28a IN OUT NOCOPY number
348 ,p_l28b IN OUT NOCOPY number
349 ,p_l28c IN OUT NOCOPY number
350 ,p_l28d IN OUT NOCOPY number
351 ,p_l28e IN OUT NOCOPY number
352 ,p_l29a IN OUT NOCOPY number
353 ,p_l29b IN OUT NOCOPY number
354 ,p_l29c IN OUT NOCOPY number
355 ,p_l29d IN OUT NOCOPY number
356 ,p_l29e IN OUT NOCOPY number
357 ,p_l30a IN OUT NOCOPY number
358 ,p_l30b IN OUT NOCOPY number
359 ,p_l30c IN OUT NOCOPY number
360 ,p_l30d IN OUT NOCOPY number
361 ,p_l30e IN OUT NOCOPY number
362 ,p_l31a IN OUT NOCOPY number
363 ,p_l31b IN OUT NOCOPY number
364 ,p_l31c IN OUT NOCOPY number
365 ,p_l31d IN OUT NOCOPY number
366 ,p_l31e IN OUT NOCOPY number);
367 --
368 --
369 END ghr_sf113_a;