1 PACKAGE pay_us_mmrf2_w2c_format_record AS
2 /* $Header: payusw2cmagfreco.pkh 120.1.12000000.1 2007/01/17 14:59:16 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_mmrf2_w2c_format_record
12
13 File Name:
14 payusw2cmagfreco.pkh
15
16 Purpose
17 The purpose of this package is to format reacord to support the
18 generation of W-2c magnetic tape for US legilsative requirements.
19
20 Notes
21 Refers By: Package pay_us_reporting_utils_pkg
22
23 History
24
25 14-OCT-03 ppanda 115.0 Created
26
27 */
28
29 --
30 --
31 -- This function is used for formatting RCA Record in MMREF-2 Format
32 --
33 FUNCTION format_W2C_RCA_record(
34 p_effective_date IN varchar2,
35 p_report_type IN varchar2,
36 p_format IN varchar2,
37 p_report_qualifier IN varchar2,
38 p_record_name IN varchar2,
39 p_input_1 IN varchar2,
40 p_input_2 IN varchar2,
41 p_input_3 IN varchar2,
42 p_input_4 IN varchar2,
43 p_input_5 IN varchar2,
44 p_input_6 IN varchar2,
45 p_input_7 IN varchar2,
46 p_input_8 IN varchar2,
47 p_input_9 IN varchar2,
48 p_input_10 IN varchar2,
49 p_input_11 IN varchar2,
50 p_input_12 IN varchar2,
51 p_input_13 IN varchar2,
52 p_input_14 IN varchar2,
53 p_input_15 IN varchar2,
54 p_input_16 IN varchar2,
55 p_input_17 IN varchar2,
56 p_input_18 IN varchar2,
57 p_input_19 IN varchar2,
58 p_input_20 IN varchar2,
59 p_input_21 IN varchar2,
60 p_input_22 IN varchar2,
61 p_input_23 IN varchar2,
62 p_input_24 IN varchar2,
63 p_input_25 IN varchar2,
64 p_input_26 IN varchar2,
65 p_input_27 IN varchar2,
66 p_input_28 IN varchar2,
67 p_input_29 IN varchar2,
68 p_input_30 IN varchar2,
69 p_input_31 IN varchar2,
70 p_input_32 IN varchar2,
71 p_input_33 IN varchar2,
72 p_input_34 IN varchar2,
73 p_input_35 IN varchar2,
74 p_input_36 IN varchar2,
75 p_input_37 IN varchar2,
76 p_input_38 IN varchar2,
77 p_input_39 IN varchar2,
78 p_input_40 IN varchar2,
79 p_validate IN varchar2,
80 p_exclude_from_output OUT nocopy varchar2,
81 sp_out_1 OUT nocopy varchar2,
82 sp_out_2 OUT nocopy varchar2,
83 sp_out_3 OUT nocopy varchar2,
84 sp_out_4 OUT nocopy varchar2,
85 sp_out_5 OUT nocopy varchar2,
86 ret_str_len OUT nocopy number,
87 p_error OUT nocopy boolean
88 ) RETURN VARCHAR2;
89
90 --
91 -- This function is used for formatting RCE Record
92 --
93 FUNCTION format_W2C_RCE_record(
94 p_effective_date IN varchar2,
95 p_report_type IN varchar2,
96 p_format IN varchar2,
97 p_report_qualifier IN varchar2,
98 p_record_name IN varchar2,
99 p_input_1 IN varchar2,
100 p_input_2 IN varchar2,
101 p_input_3 IN varchar2,
102 p_input_4 IN varchar2,
103 p_input_5 IN varchar2,
104 p_input_6 IN varchar2,
105 p_input_7 IN varchar2,
106 p_input_8 IN varchar2,
107 p_input_9 IN varchar2,
108 p_input_10 IN varchar2,
109 p_input_11 IN varchar2,
110 p_input_12 IN varchar2,
111 p_input_13 IN varchar2,
112 p_input_14 IN varchar2,
113 p_input_15 IN varchar2,
114 p_input_16 IN varchar2,
115 p_input_17 IN varchar2,
116 p_input_18 IN varchar2,
117 p_input_19 IN varchar2,
118 p_input_20 IN varchar2,
119 p_input_21 IN varchar2,
120 p_input_22 IN varchar2,
121 p_input_23 IN varchar2,
122 p_input_24 IN varchar2,
123 p_input_25 IN varchar2,
124 p_input_26 IN varchar2,
125 p_input_27 IN varchar2,
126 p_input_28 IN varchar2,
127 p_input_29 IN varchar2,
128 p_input_30 IN varchar2,
129 p_input_31 IN varchar2,
130 p_input_32 IN varchar2,
131 p_input_33 IN varchar2,
132 p_input_34 IN varchar2,
133 p_input_35 IN varchar2,
134 p_input_36 IN varchar2,
135 p_input_37 IN varchar2,
136 p_input_38 IN varchar2,
137 p_input_39 IN varchar2,
138 p_input_40 IN varchar2,
139 p_validate IN varchar2,
140 p_exclude_from_output OUT nocopy varchar2,
141 sp_out_1 OUT nocopy varchar2,
142 sp_out_2 OUT nocopy varchar2,
143 sp_out_3 OUT nocopy varchar2,
144 sp_out_4 OUT nocopy varchar2,
145 sp_out_5 OUT nocopy varchar2,
146 ret_str_len OUT nocopy number,
147 p_error OUT nocopy boolean
148 ) RETURN VARCHAR2;
149 --
150 -- This function is used for formatting RCF Record in MMREF-2 format
151 --
152 FUNCTION format_W2C_RCF_record( p_effective_date IN varchar2,
153 p_report_type IN varchar2,
154 p_format IN varchar2,
155 p_report_qualifier IN varchar2,
156 p_record_name IN varchar2,
157 p_record_identifier IN varchar2,
158 p_total_no_of_record IN varchar2,
159 p_total_wages IN varchar2,
160 p_total_taxes IN varchar2,
161 p_format_mode IN varchar2,
162 p_validate IN varchar2,
163 p_exclude_from_output OUT nocopy varchar2,
164 ret_str_len OUT nocopy number,
165 p_error OUT nocopy boolean
166 ) RETURN VARCHAR2;
167 --
168 -- This function is used for formatting RCT Record in MMREF-2 format
169 --
170
171 FUNCTION format_W2C_RCT_record(
172 p_effective_date IN varchar2,
173 p_report_type IN varchar2,
174 p_format IN varchar2,
175 p_report_qualifier IN varchar2,
176 p_record_name IN varchar2,
177 p_record_identifier IN varchar2,
178 p_total_no_of_record IN varchar2,
179 p_total_wages IN varchar2,
180 p_total_taxes IN varchar2,
181 p_format_mode IN varchar2,
182 p_validate IN varchar2,
183 p_exclude_from_output OUT nocopy varchar2,
184 ret_str_len OUT nocopy number,
185 p_error OUT nocopy boolean
186 ) RETURN VARCHAR2;
187 --
188 -- This function is used for formatting RCU Record in MMREF-2 format
189 --
190
191 FUNCTION format_W2C_RCU_record(
192 p_effective_date IN varchar2,
193 p_report_type IN varchar2,
194 p_format IN varchar2,
195 p_report_qualifier IN varchar2,
196 p_record_name IN varchar2,
197 p_record_identifier IN varchar2,
198 p_total_no_of_record IN varchar2,
199 p_total_wages IN varchar2,
200 p_total_taxes IN varchar2,
201 p_format_mode IN varchar2,
202 p_validate IN varchar2,
203 p_exclude_from_output OUT nocopy varchar2,
204 ret_str_len OUT nocopy number,
205 p_error OUT nocopy boolean
206 ) RETURN VARCHAR2;
207 --
208 -- This function is used for formatting RCW Record in MMREF-2 format
209 --
210
211 FUNCTION format_W2C_RCW_record ( p_effective_date IN varchar2,
212 p_report_type IN varchar2,
213 p_format IN varchar2,
214 p_report_qualifier IN varchar2,
215 p_record_name IN varchar2,
216 p_tax_unit_id IN varchar2,
217 p_record_identifier IN varchar2,
218 p_ssn_old IN varchar2,
219 p_ssn_new IN varchar2,
220 p_first_name_old IN varchar2,
221 p_middle_name_old IN varchar2,
222 p_last_name_old IN varchar2,
223 p_first_name_old_raw IN varchar2,
224 p_middle_name_old_raw IN varchar2,
225 p_last_name_old_raw IN varchar2,
226 p_first_name_new IN varchar2,
227 p_middle_name_new IN varchar2,
228 p_last_name_new IN varchar2,
229 p_location_address IN varchar2,
230 p_delivery_address IN varchar2,
231 p_city IN varchar2,
232 p_state IN varchar2,
233 p_zip IN varchar2,
234 p_zip_extension IN varchar2,
235 p_foreign_state IN varchar2,
236 p_foreign_postal_code IN varchar2,
237 p_country_code IN varchar2,
238 p_statutory_emp_indicator_old IN varchar2,
239 p_statutory_emp_indicator_new IN varchar2,
240 p_retire_plan_indicator_old IN varchar2,
241 p_retire_plan_indicator_new IN varchar2,
242 p_sickpay_indicator_old IN varchar2,
243 p_sickpay_indicator_new IN varchar2,
244 p_orig_assignment_actid IN varchar2,
245 p_correct_assignment_actid IN varchar2,
246 p_employee_number IN varchar2,
247 rcw_wage_rec IN OUT nocopy pay_us_w2c_in_mmref2_format.table_wage_record,
248 p_format_type IN varchar2,
249 p_validate IN varchar2,
250 p_exclude_from_output OUT nocopy varchar2,
251 ret_str_len OUT nocopy varchar2,
252 p_error OUT nocopy boolean
253 ) return varchar2;
254
255 -- This function is used for formatting RCO Record in MMREF-2 format
256 --
257 FUNCTION format_W2C_RCO_record ( p_effective_date IN varchar2,
258 p_report_type IN varchar2,
259 p_format IN varchar2,
260 p_report_qualifier IN varchar2,
261 p_record_name IN varchar2,
262 p_tax_unit_id IN varchar2,
263 p_record_identifier IN varchar2,
264 p_ssn_new IN varchar2,
265 p_first_name_new IN varchar2,
266 p_middle_name_new IN varchar2,
267 p_last_name_new IN varchar2,
268 p_orig_assignment_actid IN varchar2,
269 p_correct_assignment_actid IN varchar2,
270 p_employee_number IN varchar2,
271 rco_wage_rec IN OUT nocopy pay_us_w2c_in_mmref2_format.table_wage_record,
272 p_format_type IN varchar2,
273 p_validate IN varchar2,
274 p_exclude_from_output OUT nocopy varchar2,
275 ret_str_len OUT nocopy varchar2,
276 p_error OUT nocopy boolean
277 )
278 return varchar2;
279
280
281 END pay_us_mmrf2_w2c_format_record; -- End of Package Specification