1 PACKAGE pay_us_mmrf_print_rec_header AS
2 /* $Header: pyusprhd.pkh 120.0.12000000.1 2007/01/18 02:49:46 appldev noship $ */
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 28-AUG-2004 jgoswami 115.3 3830050 added mmrf_format_rssumm_rec_header
26 10-Nov-03 ppanda 115.2 2587381 Two new function added to format
27 W-2c record headers for audit reporting purpose
28 27-Oct-03 fusman 115.1 3220001 Parameter order was changed.
29 14-Jul-03 ppanda 115.0 Created
30
31 */
32 -- Global Variable
33 g_number NUMBER;
34 l_return varchar2(100);
35 end_date date := to_date('31/12/4712','DD/MM/YYYY');
36 --
37 -- This function format submitter Record (i.e. RA) record header
38 --
39 FUNCTION mmrf_format_ra_record_header(
40 p_report_type IN varchar2,
41 p_format IN varchar2,
42 p_report_qualifier IN varchar2,
43 p_record_name IN varchar2
44 ) RETURN VARCHAR2;
45 --
46 -- This function format Employer Record (i.e. RE) record header
47 --
48 FUNCTION mmrf_format_re_record_header(
49 p_report_type IN varchar2,
50 p_format IN varchar2,
51 p_report_qualifier IN varchar2,
52 p_record_name IN varchar2
53 ) RETURN VARCHAR2;
54 --
55 -- This function formats Wage Record (i.e. RW) record header
56 --
57 FUNCTION mmrf_format_rw_record_header(
58 p_report_type IN varchar2,
59 p_format IN varchar2,
60 p_report_qualifier IN varchar2,
61 p_record_name IN varchar2
62 ) RETURN VARCHAR2;
63 --
64 -- This function formats Puertorico based Wage Record (i.e. RO) record header
65 --
66 FUNCTION mmrf_format_ro_record_header(
67 p_report_type IN varchar2,
68 p_format IN varchar2,
69 p_report_qualifier IN varchar2,
70 p_record_name IN varchar2
71 ) RETURN VARCHAR2;
72 --
73 -- This function formats State Wage Record (i.e. RS) record header
74 --
75 FUNCTION mmrf_format_w2_rs_rec_header(
76 p_report_type IN varchar2,
77 p_format IN varchar2,
78 p_report_qualifier IN varchar2,
79 p_record_name IN varchar2,
80 p_input_1 IN varchar2
81 ) RETURN VARCHAR2;
82 --
83 -- This function formats State Wage Record (i.e. RO) record header
84 --
85 FUNCTION mmrf_format_sqwl_rs_rec_header(
86 p_report_type IN varchar2,
87 p_format IN varchar2,
88 p_report_qualifier IN varchar2,
89 p_record_name IN varchar2,
90 p_input_1 IN varchar2
91 ) RETURN VARCHAR2;
92 --
93 -- This function formats Total Wage Record (i.e. RSSUMM) record header
94 --
95 FUNCTION mmrf_format_rssumm_rec_header(
96 p_report_type IN varchar2,
97 p_format IN varchar2,
98 p_report_qualifier IN varchar2,
99 p_record_name IN varchar2
100 ) RETURN VARCHAR2;
101 --
102 -- This function formats Total Wage Record (i.e. RT) record header
103 --
104 FUNCTION mmrf_format_rt_record_header(
105 p_report_type IN varchar2,
106 p_format IN varchar2,
107 p_report_qualifier IN varchar2,
108 p_record_name IN varchar2
109 ) RETURN VARCHAR2;
110 --
111 -- This function formats Total Puertorico Wage Record (i.e. RU) record header
112 --
113 FUNCTION mmrf_format_ru_record_header(
114 p_report_type IN varchar2,
115 p_format IN varchar2,
116 p_report_qualifier IN varchar2,
117 p_record_name IN varchar2
118 ) RETURN VARCHAR2;
119 --
120 -- This function formats File Total Record (i.e. RF) record header
121 --
122 FUNCTION mmrf_format_rf_record_header(
123 p_report_type IN varchar2,
124 p_format IN varchar2,
125 p_report_qualifier IN varchar2,
126 p_record_name IN varchar2
127 ) RETURN VARCHAR2;
128 --
129 -- This function formats Wage Record (i.e. RCW) record header
130 --
131 FUNCTION mmrf2_format_rcw_record_header(
132 p_report_type IN varchar2,
133 p_format IN varchar2,
134 p_report_qualifier IN varchar2,
135 p_record_name IN varchar2
136 ) RETURN VARCHAR2;
137 --
138 -- This function formats Puertorico based Wage Record (i.e. RCO) record header
139 --
140 FUNCTION mmrf2_format_rco_record_header(
141 p_report_type IN varchar2,
142 p_format IN varchar2,
143 p_report_qualifier IN varchar2,
144 p_record_name IN varchar2
145 ) RETURN VARCHAR2;
146 --
147 --BEGIN
148 --hr_utility.trace_on(null,'PRNHEAD');
149 END pay_us_mmrf_print_rec_header;
150 --End of Package specification