[Home] [Help]
PACKAGE BODY: APPS.PAY_US_MMRF_PRINT_REC_HEADER
Source
1 PACKAGE BODY pay_us_mmrf_print_rec_header AS
2 /* $Header: pyusprhd.pkb 120.13.12020000.7 2013/03/11 12:06:48 schowl 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_print_rec_header_pkg
12
13 Purpose
14 The purpose of this package is to format reacord header
15 to support the generation of magnetic tape W2 / SQWL reports
16 for US legilsative requirements. These record headers are
17 mainly used for CSV
18
19 Notes
20 Referenced By: Package pay_us_reporting_utils_pkg
21
22 Notes
23
24 History
25 11-Mar-13 schowl 115.33 14345202 Modified 'mmrf_format_sqwl_rs_rec_header' Function.
26 Modified Header for Q1 2013 CA_SQWL changes.
27
28 27-dec-12 pracagra 115.32 16013916 Modified the header for 'IN'.
29 29-Oct-12 sjawid 115.31 14802774 Modified the function mmrf_format_sqwl_rs_rec_header.
30 Modified the header to support old format
31 'State Format' for the state 'NM'.
32 26-Sep-12 ybudamal 115.30 14356614 Modified the function mmrf_format_sqwl_rs_rec_header.
33 Modified the header by adding more columns for Q3 2012
34 NM SQWL changes.
35 23-Sep-12 ybudamal 115.29 14356614 Modified the function mmrf_format_sqwl_rs_rec_header.
36 Modified the header for Q3 2012 NM SQWL changes.
37 04-Jun-12 nvelaga 115.28 14099390 Modified the function mmrf_format_sqwl_rs_rec_header.
38 Added 'Educational Wages' to Florida SQWL record header.
39 06-Jan-12 sgotlasw 115.25 13449377 Added header for Supplemental Data for PuertoRico
40 30-Dec-11 sgotlasw 115.25 13449377 Modified code to report 2 new balances for PuertoRico
41 'PR W2 Charitable Contributions', 'PR W2 Contr To Save and Double Money'.
42 27-Dec-11 skchalla 115.24 13255427 Modified to report two new balances, W2 Health Coverage
43 and W2 Roth 457b
44 12-Nov-10 asgugupt 115.23 10287523 Modified the function mmrf2_format_ro_record_header
45 12-Nov-10 skchalla 115.22 9783383 Modified the function mmrf2_format_rco_record_header
46 to add a new field hire exempt eages.
47 25-Mar-2010 emunisek 115.21 9356178 Added new column "Actual State Quarterly
48 Unemployment Total Taxable Wages" for Florida
49 SQWL Audit Reports a02 and a03
50 10-Jan-2007 sausingh 115.20 5358272 Added Headers for Roth 401k/403b
51 sudedas Changed mmrf2_format_rcw_record_header
52 22-Nov-2006 sudedas 115.19 5640748 Modified mmrf_format_re_record_header
53 for State of Maryland.
54 17-Aug-2006 sudedas 115.18 5256745 Header Changed for RW and RT
55 Records due to MMREF-1 spec change.
56 30-May-2006 sackumar 115.17 (5089997, 4554387) Changed header for CUSTOM H and D Records.
57 03-Dec-2005 sodhingr 115.16 4398606 Changed header for RCO and RCW
58 05-Nov-2005 sudedas 115.15 4391218 Header Changed for RA, RW, RO, RT, RO
59 Records due to MMREF-1 spec change.
60 25-NOV-2004 rsethupa 115.14 4014356 RS Record header for NJ
61 Added 'MIF'
62 25-NOV-2004 rsethupa 115.13 4022086 RS Record header for MS
63 Added 'Federal ER Account Number',
64 '1099 Income' and 'Payment Yeat'
65 05-NOV-2004 rsethupa 115.12 3680056 RW and RT records header for
66 ER Contrib to Health Savings Acct
67 02-NOV-2004 rsethupa 115.11 3180532 RS Record header for IN
68 Replaced columns 'Country Code',
69 'Optional Code' and 'Reporting Period'
70 with 'Federal Advanced EIC'.
71 Added 'State Advanced EIC' and
72 'State Advanced EIC ID'
73 27-OCT-2004 rsethupa 115.10 3936924 RS record header for AL
74 Added 'Federal Employer Account Number',
75 'Payment Year'
76 26-OCT-2004 meshah 115.9 3650105 changed mmrf2_format_rcw_record_header
77 to add ER contribution to HSA Account.
78 28-AUG-2004 jgoswami 115.8 3830050 added mmrf_format_rssumm_rec_header
79 01-MAR-2004 jgoswami 115.7 3334497 Added Columns for AK_SQWL header string.
80 19-DEC-03 jgoswami 115.6 3319454 Added EIN for WA_SQWL header string.
81 08-DEC-03 ppanda 115.4 3300354 Column heading on a02 and a03 corrected
82 02-Dec-03 ppanda 115.3 3277954 Column heading changed for RCW and RCO record
83 10-Nov-03 ppanda 115.2 2587381 RCW and RCO record header formating function
84 added
85 14-Oct-03 fusman 115.1 2682247 Separate header for NY in RS record.
86 3220001 Parameter order was changed.
87 14-Jul-03 ppanda 115.0 Created
88 */
89 -- Global Variable
90 g_number NUMBER;
91 l_return varchar2(100);
92 end_date date := to_date('31/12/4712','DD/MM/YYYY');
93
94 --
95 -- This function format submitter Record (i.e. RA) record header
96 --
97 FUNCTION mmrf_format_ra_record_header(
98 p_report_type IN varchar2,
99 p_format IN varchar2,
100 p_report_qualifier IN varchar2,
101 p_record_name IN varchar2
102 ) RETURN VARCHAR2
103 IS
104 -- Local Variables
105 header_string varchar2(3000);
106 BEGIN
107 hr_utility.trace('Formatting RA record header');
108 -- This is fix for bug # 2510920
109 -- Column heading which used to be 'Resub TLCN' now its going to be 'Resub WFID'
110 --
111 header_string := 'Record Identifier'
112 ||','||'Submitters Employer Identification Number (EIN)'
113 ||','||'Personal Identification Number (PIN)'
114 ||','||'Blank' -- Bug# 4391218
115 ||','||'Resub Indicator'
116 ||','||'Resub WFID'
117 ||','||'Software Code'
118 ||','||'Company Name'
122 ||','||'State Abbreviation'
119 ||','||'Location Address'
120 ||','||'Delivery Address'
121 ||','||'City'
123 ||','||'Zip Code'
124 ||','||'Zip Code Extension'
125 ||','||'Blank'
126 ||','||'Foreign State / Province'
127 ||','||'Foreign Postal Code'
128 ||','||'Country Code'
129 ||','||'Submitter Name'
130 ||','||'Location Address'
131 ||','||'Delivery Address'
132 ||','||'City'
133 ||','||'State Abbreviation'
134 ||','||'Zip Code'
135 ||','||'Zip Code Extension'
136 ||','||'Blank'
137 ||','||'Foreign State / Province'
138 ||','||'Foreing Postal Code'
139 ||','||'Country Code'
140 ||','||'Contact Name'
141 ||','||'Contact Phone Number'
142 ||','||'Contact Phone Extension'
143 ||','||'Blank'
144 ||','||'Contact E-Mail'
145 ||','||'Blank'
146 ||','||'Contact FAX'
147 ||','||'Preferred Method Of Problem Notification Code'
148 ||','||'Preparer Code'
149 ||','||'Blank';
150 hr_utility.trace('value of header string = '||header_string);
151 return header_String;
152 END mmrf_format_ra_record_header;
153
154 --
155 -- This function format Employer Record (i.e. RE) record header
156 --
157 FUNCTION mmrf_format_re_record_header(
158 p_report_type IN varchar2,
159 p_format IN varchar2,
160 p_report_qualifier IN varchar2,
161 p_record_name IN varchar2
162 ) RETURN VARCHAR2
163 IS
164 -- Local Variables
165 header_string varchar2(6000);
166 l_header_9 varchar2(3000);
167 BEGIN
168 hr_utility.trace('Formatting RE record header');
169 If ((p_report_qualifier = 'PA') OR
170 (p_report_qualifier = 'PA_PHILA')) THEN
171 l_header_9 := 'Third Party Sick Pay Indicator'
172 ||','||'PA 8-digit Account Number';
173 Elsif (p_report_qualifier = 'MD') Then
174 l_header_9 := 'Third Party Sick Pay Indicator'
175 || ',' || 'MW508 ER - Tax Year'
176 || ',' || 'MW508 ER ID'
177 || ',' || 'MW508 Central Registration Number'
178 || ',' || 'MW508 - ER Name'
179 || ',' || 'MW508 ER St Address'
180 || ',' || 'MW508 City'
181 || ',' || 'MW508 State'
182 || ',' || 'MW508 Zipcode'
183 || ',' || 'MW508 Zip Extension'
184 || ',' || 'MW508 ER Number of W2s'
185 || ',' || 'MW508 Total amt of taxes w/h'
186 || ',' || 'MW508 ER Total Tax w/h'
187 || ',' || 'MW508 ER Credits'
188 || ',' || 'MW508 ER Amt Tax Due'
189 || ',' || 'MW508 ER Amt Balance Due'
190 || ',' || 'MW508 ER Amt Overpayment'
191 || ',' || 'MW508 ER Amt Credit'
192 || ',' || 'MW508 ER Amt Refunded'
193 || ',' || 'MW508 Gross Payroll'
194 || ',' || 'ER State Pickup Amt'
195 || ',' || 'ER Rep Name'
196 || ',' || 'ER Rep Title'
197 || ',' || 'ER Rep Date'
198 || ',' || 'ER Rep Phone Number'
199 || ',' || 'ER Total File Indicator' ;
203 End if;
200 Else
201 l_header_9 := 'Third Party Sick Pay Indicator'
202 ||','||'Blank';
204 header_string :=
205 'Record Identifier'
206 ||','||'Tax Year'
207 ||','||'Agent Indicator Code'
208 ||','||'Employer / Agent Employer Identification Number (EIN)'
209 ||','||'Agent For EIN'
210 ||','||'Terminating Business Indicator'
211 ||','||'Establishment Number'
212 ||','||'Other EIN'
213 ||','||'Employer Name'
214 ||','||'Location Address'
215 ||','||'Delivery Address'
216 ||','||'City'
217 ||','||'State Abbreviation'
218 ||','||'Zip Code'
219 ||','||'Zip Code Extension'
220 ||','||'Kind of Employer' --Bug 13255564
221 ||','||'Blank'
222 ||','||'Foreign State / Province'
223 ||','||'Foreign Postal Code'
224 ||','||'Country Code'
225 ||','||'Employment Code'
226 ||','||'Tax Jurisdiction Code'
227 ||','||l_header_9;
228 hr_utility.trace('value of header string = '||header_string);
229 return header_string;
230 END mmrf_format_re_record_header;
231
232 --
233 -- This function formats Wage Record (i.e. RW) record header
234 --
235 FUNCTION mmrf_format_rw_record_header(
236 p_report_type IN varchar2,
237 p_format IN varchar2,
238 p_report_qualifier IN varchar2,
239 p_record_name IN varchar2
240 ) RETURN VARCHAR2
241 IS
242 -- Local Variables
243 header_string varchar2(3000);
244 BEGIN
245 hr_utility.trace('Formatting RW record header');
246 header_string :=
247 'Record Identifier'
248 ||','||'Social Security Number'
249 ||','||'Employee First Name'
250 ||','||'Employee Middle Name or Initial'
251 ||','||'Employee Last Name'
252 ||','||'Suffix'
253 ||','||'Location Address'
254 ||','||'Delivery Address'
255 ||','||'City'
256 ||','||'State Abbreviation'
257 ||','||'Zip Code'
258 ||','||'Zip Code Extension'
259 ||','||'Blank'
260 ||','||'Foreign State / Province'
264 ||','||'Federal Income Tax Withheld'
261 ||','||'Foreign Postal Code'
262 ||','||'Country Code'
263 ||','||'Wages Tips And Other Compensation'
265 ||','||'Social Security Wages'
266 ||','||'Social Security Tax Withheld'
267 ||','||'Medicare Wages And Tips'
268 ||','||'Medicare Tax Withheld'
269 ||','||'Social Security Tips'
270 ||','||'Advance Earned Income Credit'
271 ||','||'Dependent Care Benefits'
272 ||','||'Deferred Compensation Contributions to Section 401(k)'
273 ||','||'Deferred Compensation Contributions to Section 403(b)'
274 ||','||'Deferred Compensation Contributions to Section 408(k)(6)'
275 ||','||'Deferred Compensation Contributions to Section 457(b)'
276 ||','||'Deferred Compensation Contributions to Section 501(c)(18)(D)'
277 --||','||'Military EE''s Basic Quarters Subsistence and Combat Pay'
278 ||','||'Blank'
279 ||','||'Non-Qual. plan Sec.457 Distributions or Contributions'
280 -- Bug 3680056 - New field
281 ||','||'Employer Contributions to Health Savings Account'
282 ||','||'Non-Qual. plan NOT Section 457 Distributions or Contributions'
283 -- Bug 4391218
284 ||','||'Non-Taxable Combat Pay'
285 ||','||'Blank'
286 ||','||'Employer Cost of Premiums for GTL> $50k'
287 ||','||'Income From Exercise of Nonqualified Stock Options'
288 -- Bug 4391218
289 ||','||'Deferrals Under a Section 409A Non-Qualified Deferred Comp Plan'
290 -- Bug 5256745
291 ||','||'Designated Roth Contrib. To Sec. 401(k) Plan'
292 ||','||'Designated Roth Contrib. Und Sec. 403(b) Salary Reduction Agreement'
293 ||','||'Cost of Employer-sponsored Health Coverage'
294 ||','||'Blank'
295 ||','||'Statutory Employee Indicator'
296 ||','||'Blank'
297 ||','||'Retirement Plan Indicator'
298 ||','||'Third-Party Sick Pay Indicator'
299 ||','||'Blank';
300 hr_utility.trace('value of formatted header string = '||header_string);
301 return header_string;
305 -- This function formats Puertorico based Wage Record (i.e. RO) record header
302 END mmrf_format_rw_record_header;
303
304 --
306 --
307 FUNCTION mmrf_format_ro_record_header(
308 p_report_type IN varchar2,
309 p_format IN varchar2,
310 p_report_qualifier IN varchar2,
311 p_record_name IN varchar2
312 ) RETURN VARCHAR2
313 IS
314 -- Local Variables
315 header_string varchar2(3000);
316 BEGIN
317 hr_utility.trace('Formatting RO record header');
318 header_string :=
319 'Record Identifier'
320 ||','||'Blank'
321 ||','||'Allocated Tips'
322 ||','||'Uncollected Employee Tax on Tips'
323 ||','||'Medical Savings Account'
324 ||','||'Simple Retirement Account'
325 ||','||'Qualified Adoption Expenses'
326 ||','||'Uncollected Social Security or RRTA Tax on GTL'
327 ||','||'Uncollected Medicare Tax on GTL'
328 -- Bug 4391218
329 ||','||'Income Under Section 409A on a Non-Qualified Deferred Comp Plan'
330 ||','||'HIRE Exempt Wages and Tips'
331 ||','||'Designated Roth Contributions Under a Governmental Section 457(b) Plan'
332 ||','||'Blank'
333 ||','||'Civil Status'
334 ||','||'Spouse''s Social Security Number (SSN)'
335 ||','||'Wages Subject to Puerto Rico Tax'
336 ||','||'Commissions Subject to Puerto Rico Tax'
337 ||','||'Allowances Subject to Puerto Rico Tax'
338 ||','||'Tips Subject to Puerto Rico Tax'
339 ||','||'Total Wages Commissions Tips and Allowances Subject to Puerto Rico Tax'
340 ||','||'Puerto Rico Tax Withheld'
341 ||','||'Retirement Fund Annual Contributions'
342 ||','||'Blank'
343 ||','||'Total Wages Tips and other Compensation Subject to Virgin Islands or Guam or American Samoa or Northern Mariana Islands Income Tax'
344 ||','||'Virgin Islands or Guam or American Samoa or Northern Mariana Islands Income Tax Withheld'
345 ||','||'Blank';
346 hr_utility.trace('value of formatted header string = '||header_string);
347 return header_string;
348 END mmrf_format_ro_record_header;
349
350 --
351 -- This function formats State Wage Record (i.e. RS) record header
352 --
353 FUNCTION mmrf_format_w2_rs_rec_header(
354 p_report_type IN varchar2,
355 p_format IN varchar2,
356 p_report_qualifier IN varchar2,
357 p_record_name IN varchar2,
358 p_input_1 IN varchar2
359 ) RETURN VARCHAR2
360 IS
361 -- Local Variables
362 header_string varchar2(3000);
363
364 l_header_20 varchar2(900);
365 l_header_21 varchar2(900);
366 -- Bug 3936924
367 l_header_25 varchar2(900);
368 l_report_format varchar2(15);
369 l_header_29 varchar2(900);
370 -- Bug 4014356
371 l_header_30 varchar2(900);
372 l_header_34 varchar2(900);
373 l_name_header varchar2(900);
374 --Bug 3180532
375 l_header_17 varchar2(900);
376
377 BEGIN
378 hr_utility.trace('Formatting W2 RS record header');
379 l_report_format := p_input_1;
380 l_name_header := 'Employee First Name'
381 ||','||'Employee Middle Name or Initial'
382 ||','||'Employee Last Name';
383 l_header_20 := 'State Quarterly Unemployment Insurance Total Wages';
384 l_header_21 := 'State Quarterly Unemployment Total Taxable Wages';
385 l_header_25 := 'State Employer Account Number';
386
387 /* Bug 3180532
388 l_header_17
389 For Indiana, only 'Federal Advanced EIC' is reqd
390 'Country Code', 'Optional Code' and 'Reporting Period' not reqd
391 For other states these 3 strings are combined in l_header_17 */
392 IF p_report_qualifier = 'IN' THEN
393 l_header_17 := 'Federal Advanced EIC';
394 /* Following ELSIF block added for 'PR' as part of the bug 13449377 */
395 ELSIF p_report_qualifier = 'PR' THEN
396 l_header_17 := 'Country Code'
397 ||','||'PR W2 Charitable Contributions';
398 l_header_20 := 'PR W2 Contr To Save and Double Money';
399 ELSE
400 l_header_17 := 'Country Code'
401 ||','||'Optional Code'
402 ||','||'Reporting Period';
403 END IF;
404
405 IF p_report_qualifier = 'AL' THEN
406 l_header_29 := 'FIT withheld';
407 -- Bug 3936924 - New columns headers
408 l_header_25 := l_header_25 || ',' ||
409 'Federal Employer Account Number';
410 ELSIF p_report_qualifier = 'MD' THEN
411 l_header_29 := 'Maryland state pickup for MD state retirement system';
412 ELSIF p_report_qualifier = 'OH' THEN
413 l_header_29 := 'Total Wages Tips and Other Compenstaion';
414 ELSE
415 l_header_29 := 'Other State Data';
416 END IF;
417
418 IF p_report_qualifier = 'MS' THEN
419 l_header_25 := l_header_25 || ',' ||
420 'Federal Employer Account Number';
421 END IF;
422
423 -- Bug 4014356
424 IF p_report_qualifier = 'NJ' THEN
425 l_header_30 := 'MIF';
426 ELSIF p_report_qualifier = 'IN' THEN /*Added for Bug 16013916*/
427 l_header_30 := 'County Code'
428 ||','||'Tax Type Code';
429 ELSE
430 l_header_30 := 'Tax Type Code';
431 END IF;
432
433 IF p_report_qualifier = 'KY' THEN
434 l_header_34 :=
435 'Amount of tax credit for KY rural economic dev. asst.'
439 ||','||'Amount of tax credit for KY industrial devep. authority'
436 ||','||'Amount of tax credit for KY jobs dev. act'
437 ||','||
438 'Amount of tax credit for KY industrial revitalization authority'
440 ||','||'Blank';
441 ELSIF p_report_qualifier = 'NJ' THEN
442 l_header_34 := 'Disability Plan Type Code'
443 ||','||'Private Disability Plan'
444 ||','||'Unemployment Insurance Tax'
445 ||','||'SDI Withheld'
446 ||','||'Pension Plan Indicator'
447 ||','||'Deferred Comp. Indicator '
448 ||','||'Deferred Compensation'
449 ||','||'Blank';
450 ELSIF p_report_qualifier = 'MD' THEN
451 l_header_34 := 'MD Central Registration Number'
452 ||','||'Wages Tips and Other Compensation'
453 ||','||'FIT w/h'
454 ||','||'Blank';
455 ELSIF p_report_qualifier = 'ME' THEN
456 l_header_34 := 'State Withheld a/c Number'
457 ||','||'Blank';
458 ELSIF p_report_qualifier = 'MA' THEN
459 l_header_34 := 'FICA + MCR w/h '
460 ||','||'Blank';
461 -- Bug 3936924
462 ELSIF p_report_qualifier = 'AL' THEN
463 l_header_34 := 'Payment Year'
464 ||','||'Blank';
465 -- Bug 3180532 : For Indiana 'State Advanced EIC' and 'State Advanced EIC ID'
466 ELSIF p_report_qualifier = 'IN' THEN
467 l_header_34 := 'State Advanced EIC'
468 ||','||'State Advanced EIC ID';
469 ELSIF p_report_qualifier = 'MS' THEN
470 l_header_34 := '1099 Income'
471 ||','||'Payment Year';
472 /* Added for 13449377 */
473 ELSIF p_report_qualifier = 'PR' THEN
474 l_header_34 := 'Supplemental Data'
475 ||','||'Blank';
476 END IF;
477
478 header_string:=
479 'Record Identifier'
480 ||','||'State Code'
481 ||','||'Taxing Entity Code'
482 ||','||'Social Security Number (SSN)'
483 ||','||l_name_header
484 ||','||'Suffix'
485 ||','||'Location Address'
486 ||','||'Delivery Address'
487 ||','||'City'
488 ||','||'State Abbreviation'
489 ||','||'Zip Code'
490 ||','||'Zip Code Extension'
491 ||','||'Blank'
492 ||','||'Foreign State / Province'
493 ||','||'Foreign Postal Code'
494 ||','|| l_header_17
495 ||','|| l_header_20
496 ||','|| l_header_21
497 ||','||'Number of Weeks Worked'
498 ||','||'Date First Employed'
499 ||','||'Date of Separation'
500 ||','||'Blank'
501 ||','|| l_header_25
502 ||','||'Blank'
503 ||','||'State Code'
504 ||','||'State Taxable Wages'
505 ||','||'SIT Withheld'
506 ||','||l_header_29
507 ||','||l_header_30
508 ||','||'Local Taxable Wages'
509 ||','||'Local Income Tax Withheld'
510 ||','||'State Control Number'
511 ||','||l_header_34;
512 hr_utility.trace('value of formatted W2 RS Record header string = '||header_string);
513 return header_string;
514 END mmrf_format_w2_rs_rec_header;
515
516 --
517 -- This function formats State Wage Record (i.e. RO) record header
518 --
519 FUNCTION mmrf_format_sqwl_rs_rec_header(
520 p_report_type IN varchar2,
521 p_format IN varchar2,
522 p_report_qualifier IN varchar2,
523 p_record_name IN varchar2,
524 p_input_1 IN varchar2
525 ) RETURN VARCHAR2
526 IS
527 -- Local Variables
528 header_string varchar2(3000);
529 l_report_format varchar2(15);
530 l_header_20 varchar2(900);
531 l_header_21 varchar2(900);
532 l_header_28 varchar2(900);
533 l_header_29 varchar2(900);
534 l_header_34 varchar2(900);
535 l_name_header varchar2(900);
536
537 BEGIN
538 hr_utility.trace('Formatting SQWL RS record header');
539 hr_utility.trace('p_report_qualifier = '|| p_report_qualifier);
540 l_report_format := p_input_1;
541 IF p_report_qualifier in ( 'LA_SQWL','AK_SQWL') THEN /*Bug:2337613 */
542 l_name_header := 'Employee Last Name'||','||'Employee First Name'
543 ||','||'Employee Middle Name or Initial';
544 ELSE
545 l_name_header := 'Employee First Name'
546 ||','||'Employee Middle Name or Initial'
547 ||','||'Employee Last Name';
548 END IF;
549
550 If p_report_qualifier ='CA_SQWL' Then
551 If l_report_format is not null and
552 l_report_format in ('RTM','ST') Then /* Modified for Bug 14345202 */
553 l_header_20 := 'SDI/SUI Total Wages';
554 l_header_21 := 'SUI Total Taxable Wages';
555 Else
556 l_header_20 := 'State Quarterly Unemployment Insurance Total Wages';
557 l_header_21 := 'State Quarterly Unemployment Total Taxable Wages';
558 End If;
559 Else
560 l_header_20 := 'State Quarterly Unemployment Insurance Total Wages';
561 l_header_21 := 'State Quarterly Unemployment Total Taxable Wages';
562 End If;
563
564 l_header_29 := 'Other State Data';
565
566 l_header_34 := 'Supplemental Data 1'
570 IF p_report_qualifier = 'NY_SQWL' THEN /*2682247*/
567 ||','||'Supplemental Data 2'
568 ||','||'Blank';
569
571
572 l_header_28 := 'Q4 only YTD FIT Wages'
573 ||','||'Q4 only YTD SIT and CIT';
574 ELSE
575
576 l_header_28 := 'State Taxable Wages'
577 ||','||'SIT Withheld';
578
579 END IF;
580
581 hr_utility.trace('l_header_28 = '|| l_header_28);
582
583 IF p_report_qualifier = 'WA_SQWL' THEN
584 header_string:=
585 'Employer Identification Number(EIN)'
586 ||','||'Social Security Number (SSN)'
587 ||','||'Name'
588 ||','||'Quarterly Hours'
589 ||','||'Quarterly Gross Wages';
590 hr_utility.trace(header_string);
591 ELSIF p_report_qualifier = 'AK_SQWL' THEN
592 header_string:=
593 'Transaction Code'
594 ||','||'Employer Account Number'
595 ||','||'Year'
596 ||','||'Quarter'
597 ||','||'Social Security Number (SSN)'
598 ||','||l_name_header
599 ||','||l_header_20
600 ||','||'Project Code'
601 ||','||'Hourly Rate'
602 ||','||'Occupational Code or Title'
603 ||','||'Area Code' ;
604 /* Bug # 4554387
605 ||','||'Batch Number'
606 ||','||'Batch Item';
607 */
608 hr_utility.trace(header_string);
609
610 ELSIF p_report_qualifier = 'NM_SQWL' AND p_format = 'CUSTOM' THEN /*bug 14802774 */
611 header_string:=
612 'Social Security Number (SSN)'
613 ||','||'Quater Gross Wages'
614 ||','||'Quarter Excess Wages'
615 ||','||'Withholding'
616 ||','||'WorkersComp' ;
617
618 ELSIF p_report_qualifier = 'NM_SQWL' AND p_format = 'MMREF' THEN -- Bug# 14356614
619 header_string:=
620 'Record Identifier'
621 ||','||'State Code'
622 ||','||'Taxing Entity Code'
623 ||','||'Social Security Number (SSN)'
624 ||','||l_name_header
625 ||','||'Suffix'
626 ||','||'Location Address'
627 ||','||'Delivery Address'
628 ||','||'City'
629 ||','||'State Abbreviation'
630 ||','||'Zip Code'
631 ||','||'Zip Code Extension'
632 ||','||'Blank'
633 ||','||'Foreign State / Province'
634 ||','||'Foreign Postal Code'
635 ||','||'Country Code'
636 ||','||'Optional Code'
637 ||','||'Reporting Period'
638 ||','||l_header_20
639 ||','||l_header_21
640 ||','||'Number of Weeks Worked'
641 ||','||'Date First Employed'
642 ||','||'Date of Separation'
643 ||','||'Unit Number'
644 ||','||'State Employer Account Number'
645 ||','||'Blank'
646 ||','||'Month1 Employment Data'
647 ||','||'Month2 Employment Data'
648 ||','||'Month3 Employment Data'
649 ||','||'Adjustment Reason'
650 ||','||'Blank'
651 ||','||'State Code'
652 ||','||'State Taxable Wages'
653 ||','||'WC Fees Due'
654 ||','||l_header_29
655 ||','||'Tax Type Code'
656 ||','||'Local Taxable Wages'
657 ||','||'NM Income Tax Withheld'
658 ||','||'State Control Number'
659 ||','||'Hours Worked'
660 ||','||'Officer Code'
661 ||','||'Blank';
662
663 hr_utility.trace(header_string);
664 ELSIF p_report_qualifier = 'FL_SQWL' THEN --Added for Bug#9356178
665 header_string:=
666 'Record Identifier'
667 ||','||'State Code'
668 ||','||'Taxing Entity Code'
669 ||','||'Social Security Number (SSN)'
670 ||','||l_name_header
671 ||','||'Suffix'
672 ||','||'Location Address'
673 ||','||'Delivery Address'
674 ||','||'City'
675 ||','||'State Abbreviation'
676 ||','||'Zip Code'
677 ||','||'Zip Code Extension'
678 ||','||'Blank'
679 ||','||'Foreign State / Province'
680 ||','||'Foreign Postal Code'
681 ||','||'Country Code'
682 ||','||'Optional Code'
683 ||','||'Reporting Period'
684 ||','|| l_header_20
685 ||','|| l_header_21
686 ||','||'Number of Weeks Worked'
687 ||','||'Date First Employed'
688 ||','||'Date of Separation'
689 ||','||'Blank'
690 ||','||'State Employer Account Number'
691 ||','||'Blank'
692 ||','||'State Code'
693 ||','|| l_header_28
694 ||','||l_header_29
695 ||','||'Tax Type Code'
699 ||','||l_header_34
696 ||','||'Local Taxable Wages'
697 ||','||'Local Income Tax Withheld'
698 ||','||'State Control Number'
700 ||','||'Actual State Quarterly Unemployment Total Taxable Wages'
701 ||','||'Educational Wages'; /* Bug#14099390 */
702 ELSE
703 header_string:=
704 'Record Identifier'
705 ||','||'State Code'
706 ||','||'Taxing Entity Code'
707 ||','||'Social Security Number (SSN)'
708 ||','||l_name_header
709 ||','||'Suffix'
710 ||','||'Location Address'
711 ||','||'Delivery Address'
712 ||','||'City'
713 ||','||'State Abbreviation'
714 ||','||'Zip Code'
715 ||','||'Zip Code Extension'
716 ||','||'Blank'
717 ||','||'Foreign State / Province'
718 ||','||'Foreign Postal Code'
719 ||','||'Country Code'
720 ||','||'Optional Code'
721 ||','||'Reporting Period'
722 ||','|| l_header_20
723 ||','|| l_header_21
724 ||','||'Number of Weeks Worked'
725 ||','||'Date First Employed'
726 ||','||'Date of Separation'
727 ||','||'Blank'
728 ||','||'State Employer Account Number'
729 ||','||'Blank'
730 ||','||'State Code'
731 ||','|| l_header_28
732 ||','||l_header_29
733 ||','||'Tax Type Code'
734 ||','||'Local Taxable Wages'
735 ||','||'Local Income Tax Withheld'
736 ||','||'State Control Number'
737 ||','||l_header_34;
738 END IF;
742
739 hr_utility.trace('value of formatted SQWL RS Record header string = '||header_string);
740 return header_string;
741 END mmrf_format_sqwl_rs_rec_header;
743
744 --
745 -- This function formats Total Wage Record (i.e. RSSSUM) record header
746 --
747 FUNCTION mmrf_format_rssumm_rec_header(
748 p_report_type IN varchar2,
749 p_format IN varchar2,
750 p_report_qualifier IN varchar2,
751 p_record_name IN varchar2
752 ) RETURN VARCHAR2
753 IS
754 -- Local Variables
755 header_string varchar2(3000);
756 l_report_format varchar2(15);
757 l_header_3 varchar2(900);
758 l_header_4 varchar2(900);
759 l_header_5 varchar2(900);
760 l_header_8 varchar2(900);
761 l_header_9 varchar2(900);
762 l_records varchar2(900);
763 l_name_header varchar2(900);
764
765 BEGIN
766 hr_utility.trace('Formatting RSSSUMM record header');
767
768 IF (p_report_qualifier = 'NV') THEN
769 l_records := 'Number of RS Records';
770 l_header_3 := 'State Taxable Wages';
771 l_header_4 := 'State Income Tax Withheld';
772 ELSE
773 l_records := 'Number of RW Records';
774 l_header_3 := 'Wages Tips and other Compensation';
775 l_header_4 := 'Federal Income Tax Withheld';
776 END IF;
777
778 IF p_report_qualifier = 'RI' THEN
779 l_records:= 'Number of RS Records';
780 l_header_5 := 'State Taxable Wages';
781 l_header_9 := 'State Income Tax Withheld';
782 ELSE
783 l_header_5 := 'Social Security Wages';
784 l_header_9 := 'Social Security Tips';
785 END IF;
786
787 IF p_report_qualifier = 'MA' THEN
788 l_header_8 := 'Total FICA + MRC withheld';
789 ELSE
790 l_header_8 := 'Medicare Tax Withheld';
791 END IF;
792
793 header_string:=
794 'Record Identifier'
795 ||','||'State Code'
796 ||','||'Taxing Entity Code/State Rec Type'
797 ||','||'Blank'
798 ||','||'Federal Tax ID Number'
799 ||','||'Blank'
800 ||','||'State Employer Acct Number'
801 ||','||'Blank'
802 ||','||'Reporting Period'
803 ||','||'Blank'
804 ||','||'Total Number of Workers on Report'
805 ||','||'Blank'
806 ||','||'Total Wages Paid This Quarter (Including Tips)'
807 ||','||'Blank'
808 ||','||'Nontaxable Wages'
809 ||','||'Blank'
810 ||','||'Taxable Wages Paid This Quarter'
811 ||','||'Blank'
812 ||','||'Blank'
813 ||','||'Month(1) employment for employer'
814 ||','||'Blank'
815 ||','||'Month(2) employment for employer'
816 ||','||'Blank'
817 ||','||'Month(3) employment for employer'
818 ||','||'Blank'
819 ||','||'No Workers/No Wages Indicator'
820 ||','||'Blank';
824
821 return header_String;
822 hr_utility.trace('value of header string = '||header_string);
823 END mmrf_format_rssumm_rec_header;
825 --
826 -- This function formats Total Wage Record (i.e. RT) record header
827 --
828 FUNCTION mmrf_format_rt_record_header(
829 p_report_type IN varchar2,
830 p_format IN varchar2,
831 p_report_qualifier IN varchar2,
832 p_record_name IN varchar2
833 ) RETURN VARCHAR2
834 IS
835 -- Local Variables
836 header_string varchar2(3000);
837 l_report_format varchar2(15);
838 l_header_3 varchar2(900);
839 l_header_4 varchar2(900);
840 l_header_5 varchar2(900);
841 l_header_8 varchar2(900);
842 l_header_9 varchar2(900);
843 l_records varchar2(900);
844 l_name_header varchar2(900);
845
846 BEGIN
847 hr_utility.trace('Formatting RT record header');
848
849 IF ( (p_report_qualifier = 'CT') OR
850 (p_report_qualifier = 'MA') ) THEN
851 l_records := 'Number of RS Records';
852 l_header_3 := 'State Taxable Wages';
853 l_header_4 := 'State Income Tax Withheld';
854 ELSE
855 l_records := 'Number of RW Records';
856 l_header_3 := 'Wages Tips and other Compensation';
857 l_header_4 := 'Federal Income Tax Withheld';
858 END IF;
859
860 IF p_report_qualifier = 'RI' THEN
861 l_records:= 'Number of RS Records';
862 l_header_5 := 'State Taxable Wages';
863 l_header_9 := 'State Income Tax Withheld';
864 ELSE
865 l_header_5 := 'Social Security Wages';
866 l_header_9 := 'Social Security Tips';
867 END IF;
868
869 IF p_report_qualifier = 'MA' THEN
870 l_header_8 := 'Total FICA + MRC withheld';
871 ELSE
872 l_header_8 := 'Medicare Tax Withheld';
873 END IF;
874
875 header_string:=
876 'Record Identifier'
877 ||','||l_records
878 ||','||l_header_3
879 ||','||l_header_4
880 ||','||l_header_5
881 ||','||'Social Security Tax Withheld'
882 ||','||'Medicare Wages And Tips'
883 ||','||l_header_8
884 ||','||l_header_9
885 ||','||'Advance Earned Income Credit'
886 ||','||'Dependent Care Benefits'
887 ||','||'Deferred Compensation Contributions to Section 401(k)'
888 ||','||'Deferred Compensation Contributions to Section 403(b)'
889 ||','||'Deferred Compensation Contributions to Section 408(k)(6)'
890 ||','||'Deferred Compensation Contributions to Section 457(b)'
891 ||','||'Deferred Compensation Contributions to Section 501(c)(18)(D)'
892 --||','||'Military EE''s Basic Quarters Subsistence And Combat Pay'
893 ||','||'Blank'
894 ||','||'Non-Qual. Plan Sec.457 Distributions or Contributions'
895 -- Bug 3680056 - New field
896 ||','||'Employer Contributions to Health Savings Account'
897 ||','||'Non-Qual. Plan NOT Section 457 Distributions or Contributions'
898 -- Bug 4391218
899 ||','||'Non-Taxable Combat Pay'
900 ||','||'Cost of Employer-sponsored Health Coverage'
901 -- ||','||'Blank'
902 ||','||'Employer Cost of Premiums for GTL> $50k'
903 ||','||'Income Tax Withheld by Third-Party Payer'
904 ||','||'Income from the Exercise of Nonqualified Stock Options'
905 -- Bug 4391218
906 ||','||'Deferrals Under a Section 409A Non-Qualified Deferred Plan Comp'
907 -- Bug 5256745
911 return header_String;
908 ||','||'Designated Roth Contrib. To Sec. 401(k) Plan'
909 ||','||'Designated Roth Contrib. Und Sec. 403(b) Salary Reduction Agreement'
910 ||','||'Blank';
912 hr_utility.trace('value of header string = '||header_string);
913 END mmrf_format_rt_record_header;
914
915 --
916 -- This function formats Total Puertorico Wage Record (i.e. RU) record header
917 --
918 FUNCTION mmrf_format_ru_record_header(
919 p_report_type IN varchar2,
920 p_format IN varchar2,
921 p_report_qualifier IN varchar2,
922 p_record_name IN varchar2
923 ) RETURN VARCHAR2
924 IS
925 -- Local Variables
926 header_string varchar2(3000);
927
928 BEGIN
929 hr_utility.trace('Formatting RU record header');
930 header_string:=
931 'Record Identifier'
932 ||','||'Number of RO Records'
933 ||','||'Allocated Tips'
934 ||','||'Uncollected Employee Tax on Tips'
938 ||','||'Uncollected Social Security Tax on GTL'
935 ||','||'Medical Savings Account'
936 ||','||'Simple Retirement Account'
937 ||','||'Qualified Adoption Expenses'
939 ||','||'Uncollected Medicare Tax On GTL'
940 -- Bug 4391218
941 ||','||'Income Under Section 409A on a Non-Qualified Deferred Comp Plan'
942 ||','||'Blank'
943 ||','||'Wages Subject to Puerto Rico Tax'
944 ||','||'Commissions Subject to Puerto Rico Tax'
945 ||','||'Allowances Subject to Puerto Rico Tax'
946 ||','||'Tips Subject to Puerto Rico Tax'
947 ||','||'Total Wages Commissions Tips And Allowances Subject to Puerto Rico Tax'
948 ||','||'Puerto Rico Tax Withheld'
949 ||','||'Retirement Fund Annual Contributions'
950 ||','||'Total Wages Tips And Other Compensation Subject to Virgin Islands or Guam or American Samoa or Northern Mariana Islands Income Tax'
951 ||','||'Virgin Islands or Guam Or American Samoa or Northern Mariana Islands Income Tax Withheld'
952 ||','||'Blank';
953 hr_utility.trace('value of formatted header string = '||header_string);
954 return header_string;
955 END mmrf_format_ru_record_header;
956
957 --
958 -- This function formats File Total Record (i.e. RF) record header
959 --
960 FUNCTION mmrf_format_rf_record_header(
961 p_report_type IN varchar2,
962 p_format IN varchar2,
963 p_report_qualifier IN varchar2,
964 p_record_name IN varchar2
965 ) RETURN VARCHAR2
966 IS
967 -- Local Variables
968 l_records varchar2(900);
969 header_string varchar2(3000);
970
971 BEGIN
972 hr_utility.trace('Formatting RF record header');
973 IF p_report_qualifier = 'PA' THEN
974 l_records := 'Blank'
975 ||','||'Number of RS Records'
976 ||','||'PA Taxable Wages'
977 ||','||'PA tax withheld';
978
979 ELSIF p_report_qualifier = 'CT' THEN
980 l_records := 'Number of RS Records'
981 ||','||'Blank'
982 ||','||'State Taxable Wages'
983 ||','||'Blank'
984 ||','||'SIT withheld'
985 ||','||'Blank';
986 ELSIF ((p_report_qualifier = 'IN') OR
987 (p_report_qualifier = 'MA') OR
988 (p_report_qualifier = 'RI') OR
989 (p_report_qualifier = 'VA')) THEN
990 l_records := 'Blank'
991 ||','||'Number of RS Records'
992 ||','||'Blank';
993 ELSE
994 l_records := 'Blank'
995 ||','||'Number of RW Records'
996 ||','||'Blank';
997 END IF;
998 header_string:= 'Record Identifier'
999 ||','||l_records;
1000
1001 hr_utility.trace('value of header string = '||header_string);
1002 return header_string;
1003 END mmrf_format_rf_record_header;
1004
1005 --
1006 -- This function formats Wage Record (i.e. RCW) record header
1007 --
1008 FUNCTION mmrf2_format_rcw_record_header(
1009 p_report_type IN varchar2,
1010 p_format IN varchar2,
1011 p_report_qualifier IN varchar2,
1012 p_record_name IN varchar2
1013 ) RETURN VARCHAR2
1014 IS
1015 -- Local Variables
1016 header_string varchar2(3500); --Bug 13255427
1017 BEGIN
1018
1019 hr_utility.trace('Formatting RCW record header');
1020 header_string :=
1021 'Record Identifier'
1022 ||','||'(Orig) SSN'
1023 ||','||'(Correct) SSN'
1024 ||','||'(Orig) First Name'
1025 ||','||'(Orig) Middle Name or Initial'
1026 ||','||'(Orig) Last Name'
1027 ||','||'(Correct) First Name'
1028 ||','||'(Correct) Middle Name or Initial'
1029 ||','||'(Correct) Last Name'
1030 ||','||'Location Address'
1031 ||','||'Delivery Address'
1032 ||','||'City'
1033 ||','||'State Abbreviation'
1034 ||','||'Zip Code'
1035 ||','||'Zip Code Extension'
1036 ||','||'Blank'
1037 ||','||'Foreign State / Province'
1038 ||','||'Foreign Postal Code'
1039 ||','||'Country Code'
1040 ||','||'(Orig) Wages Tips And Other Compensation'
1041 ||','||'(Correct) Wages Tips And Other Compensation'
1042 ||','||'(Orig) FIT Withheld'
1043 ||','||'(Correct) FIT Withheld'
1044 ||','||'(Orig) SS Wages'
1045 ||','||'(Correct) SS Wages'
1046 ||','||'(Orig) SS Tax Withheld'
1047 ||','||'(Correct) SS Tax Withheld'
1048 ||','||'(Orig) Medicare Wages And Tips'
1049 ||','||'(Correct) Medicare Wages And Tips'
1050 ||','||'(Orig) Medicare Tax Withheld'
1051 ||','||'(Correct) Medicare Tax Withheld'
1052 ||','||'(Orig) SS Tips'
1053 ||','||'(Correct) SS Tips'
1054 ||','||'(Orig) Advance EIC'
1055 ||','||'(Correct) Advance EIC'
1056 ||','||'(Orig) Dependent Care Benefits'
1057 ||','||'(Correct) Dependent Care Benefits'
1058 ||','||'(Orig) Def. CompContrib to Sec 401(k)'
1059 ||','||'(Correct) Def. CompContrib to Sec 401(k)'
1060 ||','||'(Orig) Def. CompContrib to Sec 403(b)'
1061 ||','||'(Correct) Def. CompContrib to Sec 403(b)'
1062 ||','||'(Orig) Def. CompContrib to Sec 408(k)(6)'
1063 ||','||'(Correct) Def. CompContrib to Sec 408(k)(6)'
1067 ||','||'(Correct) Def. CompContrib to Sec (501)(c)(18)(D)'
1064 ||','||'(Orig) Def. CompContrib to Sec 457(b)'
1065 ||','||'(Correct) Def. CompContrib to Sec 457(b)'
1066 ||','||'(Orig) Def. CompContrib to Sec (501)(c)(18)(D)'
1068 ||','||'(Orig) Total Def. CompContrib '
1069 ||','||'(Correct) Total Def. CompContrib '
1070 ||','||'(Orig) Military EE''s Basic Qtrs Subsistence and Combat Pay'
1071 ||','||'(Correct) Military EE''s Basic Qtrs Subsistence and Combat Pay'
1072 ||','||'(Orig) Non-Qual. plan Sec.457 Dist or Contrib'
1073 ||','||'(Correct) Non-Qual. plan Sec.457 Dist or Contrib'
1074 ||','||'(Orig) ER Contribution to HSA'
1075 ||','||'(Correct) ER Contribution to HSA'
1076 ||','||'(Orig) Non-Qual. plan NOT Section 457 Dist or Contrib'
1077 ||','||'(Correct) Non-Qual. plan NOT Section 457 Dist or Contrib'
1078 ||','||'(Orig) Nontaxable Combat Pay'
1079 ||','||'(Correct) Nontaxable Combat Pay'
1080 ||','||'Blank'
1081 ||','||'(Orig) Employer Cost of Premiums for GTL> $50k'
1082 ||','||'(Correct) Employer Cost of Premiums for GTL> $50k'
1083 ||','||'(Orig) Income From Exercise of Nonqual Stock Options'
1084 ||','||'(Correct) Income From Exercise of Nonqual Stock Options'
1085 ||','||'(Orig) Deferrals Under Section 409A'
1086 ||','||'(Correct) Deferrals Under Section 409A'
1087 ||','||'(Orig) Designated Roth Contr. to 401k Plan' /* 5358272 */
1088 ||','||'(Correct) Designated Roth Contr. to 401k Plan'
1089 ||','||'(Orig) Designated Roth Contr. to 403b Plan'
1090 ||','||'(Correct) Designated Roth Contr. to 403b Plan'
1091 ||','||'(Orig) Cost of Employer Sponsored Health Coverage' --13255427
1092 ||','||'(Correct) Cost of Employer Sponsored Health Coverage'
1093 ||','||'Blank'
1094 ||','||'(Orig) Statutory Employee Indicator'
1095 ||','||'(Correct) Statutory Employee Indicator'
1096 ||','||'(Orig) Retirement Plan Indicator'
1097 ||','||'(Correct) Retirement Plan Indicator'
1098 ||','||'(Orig) Third-Party Sick Pay Indicator'
1099 ||','||'(Correct) Third-Party Sick Pay Indicator'
1100 ||','||'Blank';
1101 hr_utility.trace('length of formatted header string = '|| to_char(length(header_string)) );
1102 --hr_utility.trace('value of formatted header string = '||header_string);
1103 return header_string;
1104 END mmrf2_format_rcw_record_header;
1105
1106
1107 --
1108 -- This function formats Puertorico based Wage Record (i.e. RCO) record header
1109 --
1110 FUNCTION mmrf2_format_rco_record_header(
1111 p_report_type IN varchar2,
1112 p_format IN varchar2,
1113 p_report_qualifier IN varchar2,
1114 p_record_name IN varchar2
1115 ) RETURN VARCHAR2
1116 IS
1117 -- Local Variables
1118 header_string varchar2(3000);
1119 BEGIN
1120 hr_utility.trace('Formatting RCO record header');
1121 header_string :=
1122 'Record Identifier'
1123 ||','||'Blank'
1124 ||','||'(Orig) Allocated Tips'
1125 ||','||'(Correct) Allocated Tips'
1126 ||','||'(Orig) Uncollected Employee Tax on Tips'
1127 ||','||'(Correct) Uncollected Employee Tax on Tips'
1128 ||','||'(Orig) Medical Savings Account'
1129 ||','||'(Correct) Medical Savings Account'
1130 ||','||'(Orig) Simple Retirement Account'
1131 ||','||'(Correct) Simple Retirement Account'
1132 ||','||'(Orig) Qualified Adoption Expenses'
1133 ||','||'(Correct) Qualified Adoption Expenses'
1134 ||','||'(Orig) Uncollected Social Security or RRTA Tax on GTL > $50k'
1135 ||','||'(Correct) Uncollected Social Security or RRTA Tax on GTL > $50k'
1136 ||','||'(Orig) Uncollected Medicare Tax on GTL > $50k'
1137 ||','||'(Correct) Uncollected Medicare Tax on GTL > $50k'
1138 ||','||'(Orig) Income Under 409A'
1139 ||','||'(Correct) Income Under 409A'
1140 ||','||'(Orig) Hire Exempt Wages and Tips'
1141 ||','||'(Correct) Hire Exempt Wages and Tips' --9483383
1142 ||','||'(Orig) Desig. Roth Contributions Under Roth 457b Plan' -- Bug 13255427
1143 ||','||'(Correct) Desig. Roth Contributions Under Roth 457b Plan';
1144 -- ||','||'Blank';
1145 --hr_utility.trace('value of formatted header string = '||header_string);
1146 return header_string;
1147 END mmrf2_format_rco_record_header;
1148
1149 --
1150 --BEGIN
1151 --hr_utility.trace_on(null,'PRINTHEADER');
1152 END pay_us_mmrf_print_rec_header;
1153 --End of Package Body