1 PACKAGE pay_us_mmrf_w2_format_record AUTHID CURRENT_USER AS
2 /* $Header: pyusw2fr.pkh 120.5 2011/11/10 18:05:59 sgotlasw ship $ */
3
4 /*===========================================================================+
5 | Copyright (c) 2001 Oracle Corporation |
6 | Redwood Shores, California, USA |
7 | All rights reserved. |
8 +============================================================================+
9
10 Name
11 pay_us_mmrf_w2_format_record
12
13 Purpose
14 The purpose of this package is to format reacord to support the
15 generation of W2 magnetic tape for US legilsative requirements.
16
17 Notes
18 Referenced By: Package pay_us_reporting_utils_pkg
19
20 History
21
22 14-Jul-03 ppanda 115.0 Created
23 07-Nov-05 sudedas 115.2 4391218 Definition of format_W2_RW_record
24 changed. 2 new (optional) input parameters
25 added at the end.
26 17-Aug-06 sudedas 115.3 5256745 Definition of format_W2_RW_record
27 modified with 2 optional input parameters
28 p_input_43 and p_input_44.
29 07-Dec-07 vmkulkar 115.4 6644795 Added function format_W2_RV_record
30 6648007
31 19-Mar-2010 emunisek 115.5 9356178 Overloaded function format_mmref_address
32 to accommodate the phone number requirement
33 of Florida SQWL
34 10-Nov-2011 sgotlasw 115.6 13351713 Definition of format_W2_RW_record and
35 format_W2_RT_record are modified with an
36 optional input parameter p_input_45, p_input_41.
37
38 */
39
40 -- This function determines the required length for fields
41 -- in various data record. Derived lengh is then validated for various
42 -- records. This function is being referenced from DAT_VALIDATION f
43 -- unction in package pay_us_reporting_utils_pkg
44 --
45 FUNCTION set_req_field_length (p_report_type IN varchar2,
46 p_format IN varchar2,
47 p_report_qualifier IN varchar2,
48 p_record_name IN varchar2,
49 p_input_1 IN varchar2,
50 p_input_2 IN varchar2,
51 p_input_3 IN varchar2,
52 p_input_4 IN varchar2,
53 p_input_5 IN varchar2
54 ) return NUMBER;
55
56 -- End of Package Body pay_us_mmrf_data_validation
57
58 --
59 -- This procedure formats contact person information for W2 reporting
60 --
61 PROCEDURE format_w2_contact_prsn_info (
62 p_report_qualifier IN varchar2,
63 p_record_name IN varchar2,
64 p_validate IN varchar2,
65 p_exclude_from_output IN OUT nocopy varchar2,
66 p_contact_prsn_name IN OUT nocopy varchar2,
67 p_contact_prsn_phone IN OUT nocopy varchar2,
68 p_contact_prsn_extension IN OUT nocopy varchar2,
69 p_contact_prsn_email IN OUT nocopy varchar2,
70 p_contact_prsn_fax IN OUT nocopy varchar2,
71 p_contact_prsn_first_name IN OUT nocopy varchar2,
72 p_contact_prsn_middle_name IN OUT nocopy varchar2,
73 p_contact_prsn_last_name IN OUT nocopy varchar2);
74
75 --
76 -- Procedure to Format Employee and Employer Address
77 -- This procedure is being called from function GET_EE_ADDRESS
78 -- and GET_ER_ADDRESS
79 --
80 PROCEDURE format_mmref_address(
81 p_name IN varchar2,
82 p_locality_company_id IN varchar2,
83 p_emp_number IN varchar2,
84 p_address_line_1 IN varchar2,
85 p_address_line_2 IN varchar2,
86 p_address_line_3 IN varchar2,
87 p_town_or_city IN varchar2,
88 p_state IN varchar2,
89 p_postal_code IN varchar2,
90 p_country IN varchar2,
91 p_region_1 IN varchar2,
92 p_region_2 IN varchar2,
93 p_valid_address IN varchar2,
94 p_item_name IN varchar2,
95 p_report_type IN varchar2,
96 p_record_name IN varchar2,
97 p_validate IN varchar2,
98 p_local_code IN varchar2,
99 p_exclude_from_output OUT nocopy varchar2,
100 sp_out_1 IN OUT nocopy varchar2,
101 sp_out_2 IN OUT nocopy varchar2,
102 sp_out_3 IN OUT nocopy varchar2,
103 sp_out_4 IN OUT nocopy varchar2,
104 sp_out_5 IN OUT nocopy varchar2,
105 sp_out_6 IN OUT nocopy varchar2,
106 sp_out_7 IN OUT nocopy varchar2,
107 sp_out_8 IN OUT nocopy varchar2,
108 sp_out_9 IN OUT nocopy varchar2,
109 sp_out_10 IN OUT nocopy varchar2 );
110 --
111 --
112 --This function is created to overload the existing function format_mmref_address for Bug9356178
113
114 PROCEDURE format_mmref_address(
115 p_name IN varchar2,
116 p_locality_company_id IN varchar2,
117 p_emp_number IN varchar2,
118 p_address_line_1 IN varchar2,
119 p_address_line_2 IN varchar2,
120 p_address_line_3 IN varchar2,
121 p_town_or_city IN varchar2,
122 p_state IN varchar2,
123 p_postal_code IN varchar2,
124 p_country IN varchar2,
125 p_region_1 IN varchar2,
126 p_region_2 IN varchar2,
127 p_phone_number IN varchar2,
128 p_valid_address IN varchar2,
129 p_item_name IN varchar2,
130 p_report_type IN varchar2,
131 p_record_name IN varchar2,
132 p_validate IN varchar2,
133 p_local_code IN varchar2,
134 p_exclude_from_output OUT nocopy varchar2,
135 sp_out_1 IN OUT nocopy varchar2,
136 sp_out_2 IN OUT nocopy varchar2,
137 sp_out_3 IN OUT nocopy varchar2,
138 sp_out_4 IN OUT nocopy varchar2,
139 sp_out_5 IN OUT nocopy varchar2,
140 sp_out_6 IN OUT nocopy varchar2,
141 sp_out_7 IN OUT nocopy varchar2,
142 sp_out_8 IN OUT nocopy varchar2,
143 sp_out_9 IN OUT nocopy varchar2,
144 sp_out_10 IN OUT nocopy varchar2 );
145
146 -- This function is used for formatting RA Record
147 --
148 FUNCTION format_W2_RA_record(
149 p_effective_date IN varchar2,
150 p_report_type IN varchar2,
151 p_format IN varchar2,
152 p_report_qualifier IN varchar2,
153 p_record_name IN varchar2,
154 p_input_1 IN varchar2,
155 p_input_2 IN varchar2,
156 p_input_3 IN varchar2,
157 p_input_4 IN varchar2,
158 p_input_5 IN varchar2,
159 p_input_6 IN varchar2,
160 p_input_7 IN varchar2,
161 p_input_8 IN varchar2,
162 p_input_9 IN varchar2,
163 p_input_10 IN varchar2,
164 p_input_11 IN varchar2,
165 p_input_12 IN varchar2,
166 p_input_13 IN varchar2,
167 p_input_14 IN varchar2,
168 p_input_15 IN varchar2,
169 p_input_16 IN varchar2,
170 p_input_17 IN varchar2,
171 p_input_18 IN varchar2,
172 p_input_19 IN varchar2,
173 p_input_20 IN varchar2,
174 p_input_21 IN varchar2,
175 p_input_22 IN varchar2,
176 p_input_23 IN varchar2,
177 p_input_24 IN varchar2,
178 p_input_25 IN varchar2,
179 p_input_26 IN varchar2,
180 p_input_27 IN varchar2,
181 p_input_28 IN varchar2,
182 p_input_29 IN varchar2,
183 p_input_30 IN varchar2,
184 p_input_31 IN varchar2,
185 p_input_32 IN varchar2,
186 p_input_33 IN varchar2,
187 p_input_34 IN varchar2,
188 p_input_35 IN varchar2,
189 p_input_36 IN varchar2,
190 p_input_37 IN varchar2,
191 p_input_38 IN varchar2,
192 p_input_39 IN varchar2,
193 p_input_40 IN varchar2,
194 p_validate IN varchar2,
195 p_exclude_from_output OUT nocopy varchar2,
196 sp_out_1 OUT nocopy varchar2,
197 sp_out_2 OUT nocopy varchar2,
198 sp_out_3 OUT nocopy varchar2,
199 sp_out_4 OUT nocopy varchar2,
200 sp_out_5 OUT nocopy varchar2,
201 ret_str_len OUT nocopy number,
202 p_error OUT nocopy boolean
203 ) RETURN VARCHAR2;
204
205 --
206 -- This function is used for formatting RV Record (PR)
207 --
208 FUNCTION format_W2_RV_record(
209 p_effective_date IN varchar2,
210 p_report_type IN varchar2,
211 p_format IN varchar2,
212 p_report_qualifier IN varchar2,
213 p_record_name IN varchar2,
214 p_input_1 IN varchar2,
215 p_input_2 IN varchar2,
216 p_input_3 IN varchar2,
217 p_input_4 IN varchar2,
218 p_input_5 IN varchar2,
219 p_input_6 IN varchar2,
220 p_input_7 IN varchar2,
221 p_input_8 IN varchar2,
222 p_input_9 IN varchar2,
223 p_input_10 IN varchar2,
224 p_input_11 IN varchar2,
225 p_input_12 IN varchar2,
226 p_input_13 IN varchar2,
227 p_input_14 IN varchar2,
228 p_input_15 IN varchar2,
229 p_input_16 IN varchar2,
230 p_input_17 IN varchar2,
231 p_input_18 IN varchar2,
232 p_input_19 IN varchar2,
233 p_input_20 IN varchar2,
234 p_input_21 IN varchar2,
235 p_input_22 IN varchar2,
236 p_input_23 IN varchar2,
237 p_input_24 IN varchar2,
238 p_input_25 IN varchar2,
239 p_input_26 IN varchar2,
240 p_input_27 IN varchar2,
241 p_input_28 IN varchar2,
242 p_input_29 IN varchar2,
243 p_input_30 IN varchar2,
244 p_input_31 IN varchar2,
245 p_input_32 IN varchar2,
246 p_input_33 IN varchar2,
247 p_input_34 IN varchar2,
248 p_input_35 IN varchar2,
249 p_input_36 IN varchar2,
250 p_input_37 IN varchar2,
251 p_input_38 IN varchar2,
252 p_input_39 IN varchar2,
253 p_input_40 IN varchar2,
254 p_validate IN varchar2,
255 p_exclude_from_output OUT nocopy varchar2,
256 sp_out_1 OUT nocopy varchar2,
257 sp_out_2 OUT nocopy varchar2,
258 sp_out_3 OUT nocopy varchar2,
259 sp_out_4 OUT nocopy varchar2,
260 sp_out_5 OUT nocopy varchar2,
261 ret_str_len OUT nocopy number,
262 p_error OUT nocopy boolean
263 ) RETURN VARCHAR2;
264
265
266 --
267 -- This function is used for formatting RE Record
268 --
269 FUNCTION format_W2_RE_record(
270 p_effective_date IN varchar2,
271 p_report_type IN varchar2,
272 p_format IN varchar2,
273 p_report_qualifier IN varchar2,
274 p_record_name IN varchar2,
275 p_input_1 IN varchar2,
276 p_input_2 IN varchar2,
277 p_input_3 IN varchar2,
278 p_input_4 IN varchar2,
279 p_input_5 IN varchar2,
280 p_input_6 IN varchar2,
281 p_input_7 IN varchar2,
282 p_input_8 IN varchar2,
283 p_input_9 IN varchar2,
284 p_input_10 IN varchar2,
285 p_input_11 IN varchar2,
286 p_input_12 IN varchar2,
287 p_input_13 IN varchar2,
288 p_input_14 IN varchar2,
289 p_input_15 IN varchar2,
290 p_input_16 IN varchar2,
291 p_input_17 IN varchar2,
292 p_input_18 IN varchar2,
293 p_input_19 IN varchar2,
294 p_input_20 IN varchar2,
295 p_input_21 IN varchar2,
296 p_input_22 IN varchar2,
297 p_input_23 IN varchar2,
298 p_input_24 IN varchar2,
299 p_input_25 IN varchar2,
300 p_input_26 IN varchar2,
301 p_input_27 IN varchar2,
302 p_input_28 IN varchar2,
303 p_input_29 IN varchar2,
307 p_input_33 IN varchar2,
304 p_input_30 IN varchar2,
305 p_input_31 IN varchar2,
306 p_input_32 IN varchar2,
308 p_input_34 IN varchar2,
309 p_input_35 IN varchar2,
310 p_input_36 IN varchar2,
311 p_input_37 IN varchar2,
312 p_input_38 IN varchar2,
313 p_input_39 IN varchar2,
314 p_input_40 IN varchar2,
315 p_validate IN varchar2,
316 p_exclude_from_output OUT nocopy varchar2,
317 sp_out_1 OUT nocopy varchar2,
318 sp_out_2 OUT nocopy varchar2,
319 sp_out_3 OUT nocopy varchar2,
320 sp_out_4 OUT nocopy varchar2,
321 sp_out_5 OUT nocopy varchar2,
322 ret_str_len OUT nocopy number,
323 p_error OUT nocopy boolean
324 ) RETURN VARCHAR2;
325 --
326 -- This function is used for formatting RW Record
327 --
328 -- Allowing additional two parameters
329
330 FUNCTION format_W2_RW_record(
331 p_effective_date IN varchar2,
332 p_report_type IN varchar2,
333 p_format IN varchar2,
334 p_report_qualifier IN varchar2,
335 p_record_name IN varchar2,
336 p_input_1 IN varchar2,
337 p_input_2 IN varchar2,
338 p_input_3 IN varchar2,
339 p_input_4 IN varchar2,
340 p_input_5 IN varchar2,
341 p_input_6 IN varchar2,
342 p_input_7 IN varchar2,
343 p_input_8 IN varchar2,
344 p_input_9 IN varchar2,
345 p_input_10 IN varchar2,
346 p_input_11 IN varchar2,
347 p_input_12 IN varchar2,
348 p_input_13 IN varchar2,
349 p_input_14 IN varchar2,
350 p_input_15 IN varchar2,
351 p_input_16 IN varchar2,
352 p_input_17 IN varchar2,
353 p_input_18 IN varchar2,
354 p_input_19 IN varchar2,
355 p_input_20 IN varchar2,
356 p_input_21 IN varchar2,
357 p_input_22 IN varchar2,
358 p_input_23 IN varchar2,
359 p_input_24 IN varchar2,
360 p_input_25 IN varchar2,
361 p_input_26 IN varchar2,
362 p_input_27 IN varchar2,
363 p_input_28 IN varchar2,
364 p_input_29 IN varchar2,
365 p_input_30 IN varchar2,
366 p_input_31 IN varchar2,
367 p_input_32 IN varchar2,
368 p_input_33 IN varchar2,
369 p_input_34 IN varchar2,
370 p_input_35 IN varchar2,
371 p_input_36 IN varchar2,
372 p_input_37 IN varchar2,
373 p_input_38 IN varchar2,
374 p_input_39 IN varchar2,
375 p_input_40 IN varchar2,
376 p_validate IN varchar2,
377 p_exclude_from_output OUT nocopy varchar2,
378 sp_out_1 OUT nocopy varchar2,
379 sp_out_2 OUT nocopy varchar2,
380 sp_out_3 OUT nocopy varchar2,
381 sp_out_4 OUT nocopy varchar2,
382 sp_out_5 OUT nocopy varchar2,
383 ret_str_len OUT nocopy number,
384 p_error OUT nocopy boolean,
385 p_input_41 IN varchar2 default null,
386 p_input_42 IN varchar2 default null,
387 p_input_43 IN varchar2 default null,
388 p_input_44 IN varchar2 default null, /* Bug 5256745 */
389 p_input_45 IN varchar2 default null /* Bug 13351713 */
390 ) RETURN VARCHAR2;
391
392 -- End of function format_W2_RW_record
393 --
394 -- This function is used for formatting RO Record
395 --
396 FUNCTION format_W2_RO_record(
397 p_effective_date IN varchar2,
398 p_report_type IN varchar2,
399 p_format IN varchar2,
400 p_report_qualifier IN varchar2,
401 p_record_name IN varchar2,
402 p_input_1 IN varchar2,
403 p_input_2 IN varchar2,
407 p_input_6 IN varchar2,
404 p_input_3 IN varchar2,
405 p_input_4 IN varchar2,
406 p_input_5 IN varchar2,
408 p_input_7 IN varchar2,
409 p_input_8 IN varchar2,
410 p_input_9 IN varchar2,
411 p_input_10 IN varchar2,
412 p_input_11 IN varchar2,
413 p_input_12 IN varchar2,
414 p_input_13 IN varchar2,
415 p_input_14 IN varchar2,
416 p_input_15 IN varchar2,
417 p_input_16 IN varchar2,
418 p_input_17 IN varchar2,
419 p_input_18 IN varchar2,
420 p_input_19 IN varchar2,
421 p_input_20 IN varchar2,
422 p_input_21 IN varchar2,
423 p_input_22 IN varchar2,
424 p_input_23 IN varchar2,
425 p_input_24 IN varchar2,
426 p_input_25 IN varchar2,
427 p_input_26 IN varchar2,
428 p_input_27 IN varchar2,
429 p_input_28 IN varchar2,
430 p_input_29 IN varchar2,
431 p_input_30 IN varchar2,
432 p_input_31 IN varchar2,
433 p_input_32 IN varchar2,
434 p_input_33 IN varchar2,
435 p_input_34 IN varchar2,
436 p_input_35 IN varchar2,
437 p_input_36 IN varchar2,
438 p_input_37 IN varchar2,
439 p_input_38 IN varchar2,
440 p_input_39 IN varchar2,
441 p_input_40 IN varchar2,
442 p_validate IN varchar2,
443 p_exclude_from_output OUT nocopy varchar2,
444 sp_out_1 OUT nocopy varchar2,
445 sp_out_2 OUT nocopy varchar2,
446 sp_out_3 OUT nocopy varchar2,
447 sp_out_4 OUT nocopy varchar2,
448 sp_out_5 OUT nocopy varchar2,
449 ret_str_len OUT nocopy number,
450 p_error OUT nocopy boolean
451 ) RETURN VARCHAR2;
452
453 --
454 -- This function is used for formatting RS Record
455 --
456 FUNCTION format_W2_RS_record(
457 p_effective_date IN varchar2,
458 p_report_type IN varchar2,
459 p_format IN varchar2,
460 p_report_qualifier IN varchar2,
461 p_record_name IN varchar2,
462 p_input_1 IN varchar2,
463 p_input_2 IN varchar2,
464 p_input_3 IN varchar2,
465 p_input_4 IN varchar2,
466 p_input_5 IN varchar2,
467 p_input_6 IN varchar2,
468 p_input_7 IN varchar2,
469 p_input_8 IN varchar2,
470 p_input_9 IN varchar2,
471 p_input_10 IN varchar2,
472 p_input_11 IN varchar2,
473 p_input_12 IN varchar2,
474 p_input_13 IN varchar2,
475 p_input_14 IN varchar2,
476 p_input_15 IN varchar2,
477 p_input_16 IN varchar2,
478 p_input_17 IN varchar2,
479 p_input_18 IN varchar2,
480 p_input_19 IN varchar2,
481 p_input_20 IN varchar2,
482 p_input_21 IN varchar2,
483 p_input_22 IN varchar2,
484 p_input_23 IN varchar2,
485 p_input_24 IN varchar2,
486 p_input_25 IN varchar2,
487 p_input_26 IN varchar2,
488 p_input_27 IN varchar2,
489 p_input_28 IN varchar2,
490 p_input_29 IN varchar2,
491 p_input_30 IN varchar2,
492 p_input_31 IN varchar2,
493 p_input_32 IN varchar2,
494 p_input_33 IN varchar2,
495 p_input_34 IN varchar2,
496 p_input_35 IN varchar2,
497 p_input_36 IN varchar2,
498 p_input_37 IN varchar2,
499 p_input_38 IN varchar2,
500 p_input_39 IN varchar2,
501 p_input_40 IN varchar2,
502 p_validate IN varchar2,
506 sp_out_3 OUT nocopy varchar2,
503 p_exclude_from_output OUT nocopy varchar2,
504 sp_out_1 OUT nocopy varchar2,
505 sp_out_2 OUT nocopy varchar2,
507 sp_out_4 OUT nocopy varchar2,
508 sp_out_5 OUT nocopy varchar2,
509 ret_str_len OUT nocopy number,
510 p_error OUT nocopy boolean
511 ) RETURN VARCHAR2;
512
513 --
514 -- This function is used for formatting RT Record
515 --
516 FUNCTION format_W2_RT_record(
517 p_effective_date IN varchar2,
518 p_report_type IN varchar2,
519 p_format IN varchar2,
520 p_report_qualifier IN varchar2,
521 p_record_name IN varchar2,
522 p_input_1 IN varchar2,
523 p_input_2 IN varchar2,
524 p_input_3 IN varchar2,
525 p_input_4 IN varchar2,
526 p_input_5 IN varchar2,
527 p_input_6 IN varchar2,
528 p_input_7 IN varchar2,
529 p_input_8 IN varchar2,
530 p_input_9 IN varchar2,
531 p_input_10 IN varchar2,
532 p_input_11 IN varchar2,
533 p_input_12 IN varchar2,
534 p_input_13 IN varchar2,
535 p_input_14 IN varchar2,
536 p_input_15 IN varchar2,
537 p_input_16 IN varchar2,
538 p_input_17 IN varchar2,
539 p_input_18 IN varchar2,
540 p_input_19 IN varchar2,
541 p_input_20 IN varchar2,
542 p_input_21 IN varchar2,
543 p_input_22 IN varchar2,
544 p_input_23 IN varchar2,
545 p_input_24 IN varchar2,
546 p_input_25 IN varchar2,
547 p_input_26 IN varchar2,
548 p_input_27 IN varchar2,
549 p_input_28 IN varchar2,
550 p_input_29 IN varchar2,
551 p_input_30 IN varchar2,
552 p_input_31 IN varchar2,
553 p_input_32 IN varchar2,
554 p_input_33 IN varchar2,
555 p_input_34 IN varchar2,
556 p_input_35 IN varchar2,
557 p_input_36 IN varchar2,
558 p_input_37 IN varchar2,
559 p_input_38 IN varchar2,
560 p_input_39 IN varchar2,
561 p_input_40 IN varchar2,
562 p_validate IN varchar2,
563 p_exclude_from_output OUT nocopy varchar2,
564 sp_out_1 OUT nocopy varchar2,
565 sp_out_2 OUT nocopy varchar2,
566 sp_out_3 OUT nocopy varchar2,
567 sp_out_4 OUT nocopy varchar2,
568 sp_out_5 OUT nocopy varchar2,
569 ret_str_len OUT nocopy number,
570 p_error OUT nocopy boolean,
571 p_input_41 IN varchar2 default null /* Bug# 13351713 */
572 ) RETURN VARCHAR2;
573 --
574 -- This function is used for formatting RU Record
575 --
576 FUNCTION format_W2_RU_record(
577 p_effective_date IN varchar2,
578 p_report_type IN varchar2,
579 p_format IN varchar2,
580 p_report_qualifier IN varchar2,
581 p_record_name IN varchar2,
582 p_input_1 IN varchar2,
583 p_input_2 IN varchar2,
584 p_input_3 IN varchar2,
585 p_input_4 IN varchar2,
586 p_input_5 IN varchar2,
587 p_input_6 IN varchar2,
588 p_input_7 IN varchar2,
589 p_input_8 IN varchar2,
590 p_input_9 IN varchar2,
591 p_input_10 IN varchar2,
592 p_input_11 IN varchar2,
593 p_input_12 IN varchar2,
594 p_input_13 IN varchar2,
595 p_input_14 IN varchar2,
596 p_input_15 IN varchar2,
597 p_input_16 IN varchar2,
598 p_input_17 IN varchar2,
599 p_input_18 IN varchar2,
600 p_input_19 IN varchar2,
601 p_input_20 IN varchar2,
605 p_input_24 IN varchar2,
602 p_input_21 IN varchar2,
603 p_input_22 IN varchar2,
604 p_input_23 IN varchar2,
606 p_input_25 IN varchar2,
607 p_input_26 IN varchar2,
608 p_input_27 IN varchar2,
609 p_input_28 IN varchar2,
610 p_input_29 IN varchar2,
611 p_input_30 IN varchar2,
612 p_input_31 IN varchar2,
613 p_input_32 IN varchar2,
614 p_input_33 IN varchar2,
615 p_input_34 IN varchar2,
616 p_input_35 IN varchar2,
617 p_input_36 IN varchar2,
618 p_input_37 IN varchar2,
619 p_input_38 IN varchar2,
620 p_input_39 IN varchar2,
621 p_input_40 IN varchar2,
622 p_validate IN varchar2,
623 p_exclude_from_output OUT nocopy varchar2,
624 sp_out_1 OUT nocopy varchar2,
625 sp_out_2 OUT nocopy varchar2,
626 sp_out_3 OUT nocopy varchar2,
627 sp_out_4 OUT nocopy varchar2,
628 sp_out_5 OUT nocopy varchar2,
629 ret_str_len OUT nocopy number,
630 p_error OUT nocopy boolean
631 ) RETURN VARCHAR2;
632 --
633 -- This function is used for formatting RF Record
634 --
635 FUNCTION format_W2_RF_record(
636 p_effective_date IN varchar2,
637 p_report_type IN varchar2,
638 p_format IN varchar2,
639 p_report_qualifier IN varchar2,
640 p_record_name IN varchar2,
641 p_record_identifier IN varchar2,
642 p_total_no_of_record IN varchar2,
643 p_total_wages IN varchar2,
644 p_total_taxes IN varchar2,
645 p_format_mode IN varchar2,
646 p_validate IN varchar2,
647 p_exclude_from_output OUT nocopy varchar2,
648 ret_str_len OUT nocopy number,
649 p_error OUT nocopy boolean
650 ) RETURN VARCHAR2;
651 --
652 --
653 END pay_us_mmrf_w2_format_record; -- End of Package Specification