[Home] [Help]
151:
152:
153: BEGIN
154: l_report_format := p_input_1;
155: hr_utility.trace('Begin Function'|| gv_package ||'.print_w2c_record_header ');
156: IF p_format = 'MMREF2' THEN
157:
158: IF p_record_name = 'RCW' THEN
159: hr_utility.trace('Formating RCW Record in'|| gv_package ||'.print_w2c_record_header ');
155: hr_utility.trace('Begin Function'|| gv_package ||'.print_w2c_record_header ');
156: IF p_format = 'MMREF2' THEN
157:
158: IF p_record_name = 'RCW' THEN
159: hr_utility.trace('Formating RCW Record in'|| gv_package ||'.print_w2c_record_header ');
160: header_string :=
161: pay_us_mmrf_print_rec_header.mmrf2_format_rcw_record_header(
162: p_report_type,
163: p_format,
164: p_report_qualifier,
165: p_record_name
166: );
167: ELSIF p_record_name = 'RCO' THEN
168: hr_utility.trace('Formating RCO Record in'|| gv_package ||'.print_w2c_record_header ');
169: header_string:=
170: pay_us_mmrf_print_rec_header.mmrf2_format_rco_record_header(
171: p_report_type,
172: p_format,
174: p_record_name
175: );
176: END IF; /* p_record_name */
177: END IF; /* p_format */
178: hr_utility.trace('splitting the header string ');
179: return_header_string := substr(header_string,1,200);
180: sp_out_1:=substr(header_string,201,250);
181: sp_out_2:=substr(header_string,451,250);
182: sp_out_3:=substr(header_string,701,250);
188: sp_out_9:=substr(header_string,2201,250);
189: sp_out_10:=substr(header_string,2451);
190:
191: p_exclude_from_output:='N';
192: hr_utility.trace('Length of return_header_string := ' || length(return_header_string)) ;
193: hr_utility.trace('return_header_string = '||return_header_string);
194: hr_utility.trace('sp_out_1:='||sp_out_1);
195: hr_utility.trace('sp_out_2:='||sp_out_2);
196: hr_utility.trace('sp_out_3:='||sp_out_3);
189: sp_out_10:=substr(header_string,2451);
190:
191: p_exclude_from_output:='N';
192: hr_utility.trace('Length of return_header_string := ' || length(return_header_string)) ;
193: hr_utility.trace('return_header_string = '||return_header_string);
194: hr_utility.trace('sp_out_1:='||sp_out_1);
195: hr_utility.trace('sp_out_2:='||sp_out_2);
196: hr_utility.trace('sp_out_3:='||sp_out_3);
197: hr_utility.trace('sp_out_4:='||sp_out_4);
190:
191: p_exclude_from_output:='N';
192: hr_utility.trace('Length of return_header_string := ' || length(return_header_string)) ;
193: hr_utility.trace('return_header_string = '||return_header_string);
194: hr_utility.trace('sp_out_1:='||sp_out_1);
195: hr_utility.trace('sp_out_2:='||sp_out_2);
196: hr_utility.trace('sp_out_3:='||sp_out_3);
197: hr_utility.trace('sp_out_4:='||sp_out_4);
198: hr_utility.trace('sp_out_5:='||sp_out_5);
191: p_exclude_from_output:='N';
192: hr_utility.trace('Length of return_header_string := ' || length(return_header_string)) ;
193: hr_utility.trace('return_header_string = '||return_header_string);
194: hr_utility.trace('sp_out_1:='||sp_out_1);
195: hr_utility.trace('sp_out_2:='||sp_out_2);
196: hr_utility.trace('sp_out_3:='||sp_out_3);
197: hr_utility.trace('sp_out_4:='||sp_out_4);
198: hr_utility.trace('sp_out_5:='||sp_out_5);
199: hr_utility.trace('sp_out_6:='||sp_out_6);
192: hr_utility.trace('Length of return_header_string := ' || length(return_header_string)) ;
193: hr_utility.trace('return_header_string = '||return_header_string);
194: hr_utility.trace('sp_out_1:='||sp_out_1);
195: hr_utility.trace('sp_out_2:='||sp_out_2);
196: hr_utility.trace('sp_out_3:='||sp_out_3);
197: hr_utility.trace('sp_out_4:='||sp_out_4);
198: hr_utility.trace('sp_out_5:='||sp_out_5);
199: hr_utility.trace('sp_out_6:='||sp_out_6);
200: hr_utility.trace('sp_out_7:='||sp_out_7);
193: hr_utility.trace('return_header_string = '||return_header_string);
194: hr_utility.trace('sp_out_1:='||sp_out_1);
195: hr_utility.trace('sp_out_2:='||sp_out_2);
196: hr_utility.trace('sp_out_3:='||sp_out_3);
197: hr_utility.trace('sp_out_4:='||sp_out_4);
198: hr_utility.trace('sp_out_5:='||sp_out_5);
199: hr_utility.trace('sp_out_6:='||sp_out_6);
200: hr_utility.trace('sp_out_7:='||sp_out_7);
201: hr_utility.trace('sp_out_8:='||sp_out_8);
194: hr_utility.trace('sp_out_1:='||sp_out_1);
195: hr_utility.trace('sp_out_2:='||sp_out_2);
196: hr_utility.trace('sp_out_3:='||sp_out_3);
197: hr_utility.trace('sp_out_4:='||sp_out_4);
198: hr_utility.trace('sp_out_5:='||sp_out_5);
199: hr_utility.trace('sp_out_6:='||sp_out_6);
200: hr_utility.trace('sp_out_7:='||sp_out_7);
201: hr_utility.trace('sp_out_8:='||sp_out_8);
202: hr_utility.trace('sp_out_9:='||sp_out_9);
195: hr_utility.trace('sp_out_2:='||sp_out_2);
196: hr_utility.trace('sp_out_3:='||sp_out_3);
197: hr_utility.trace('sp_out_4:='||sp_out_4);
198: hr_utility.trace('sp_out_5:='||sp_out_5);
199: hr_utility.trace('sp_out_6:='||sp_out_6);
200: hr_utility.trace('sp_out_7:='||sp_out_7);
201: hr_utility.trace('sp_out_8:='||sp_out_8);
202: hr_utility.trace('sp_out_9:='||sp_out_9);
203: hr_utility.trace('sp_out_10:='||sp_out_10);
196: hr_utility.trace('sp_out_3:='||sp_out_3);
197: hr_utility.trace('sp_out_4:='||sp_out_4);
198: hr_utility.trace('sp_out_5:='||sp_out_5);
199: hr_utility.trace('sp_out_6:='||sp_out_6);
200: hr_utility.trace('sp_out_7:='||sp_out_7);
201: hr_utility.trace('sp_out_8:='||sp_out_8);
202: hr_utility.trace('sp_out_9:='||sp_out_9);
203: hr_utility.trace('sp_out_10:='||sp_out_10);
204: hr_utility.trace('Recod Header Formating completed in'|| gv_package
197: hr_utility.trace('sp_out_4:='||sp_out_4);
198: hr_utility.trace('sp_out_5:='||sp_out_5);
199: hr_utility.trace('sp_out_6:='||sp_out_6);
200: hr_utility.trace('sp_out_7:='||sp_out_7);
201: hr_utility.trace('sp_out_8:='||sp_out_8);
202: hr_utility.trace('sp_out_9:='||sp_out_9);
203: hr_utility.trace('sp_out_10:='||sp_out_10);
204: hr_utility.trace('Recod Header Formating completed in'|| gv_package
205: ||'.print_w2c_record_header ');
198: hr_utility.trace('sp_out_5:='||sp_out_5);
199: hr_utility.trace('sp_out_6:='||sp_out_6);
200: hr_utility.trace('sp_out_7:='||sp_out_7);
201: hr_utility.trace('sp_out_8:='||sp_out_8);
202: hr_utility.trace('sp_out_9:='||sp_out_9);
203: hr_utility.trace('sp_out_10:='||sp_out_10);
204: hr_utility.trace('Recod Header Formating completed in'|| gv_package
205: ||'.print_w2c_record_header ');
206: RETURN return_header_string;
199: hr_utility.trace('sp_out_6:='||sp_out_6);
200: hr_utility.trace('sp_out_7:='||sp_out_7);
201: hr_utility.trace('sp_out_8:='||sp_out_8);
202: hr_utility.trace('sp_out_9:='||sp_out_9);
203: hr_utility.trace('sp_out_10:='||sp_out_10);
204: hr_utility.trace('Recod Header Formating completed in'|| gv_package
205: ||'.print_w2c_record_header ');
206: RETURN return_header_string;
207: END print_w2c_record_header;
200: hr_utility.trace('sp_out_7:='||sp_out_7);
201: hr_utility.trace('sp_out_8:='||sp_out_8);
202: hr_utility.trace('sp_out_9:='||sp_out_9);
203: hr_utility.trace('sp_out_10:='||sp_out_10);
204: hr_utility.trace('Recod Header Formating completed in'|| gv_package
205: ||'.print_w2c_record_header ');
206: RETURN return_header_string;
207: END print_w2c_record_header;
208:
281: l_total_rcw_records number := 0;
282: ln_return_value number := 0;
283: BEGIN
284:
285: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
286: hr_utility.trace(' p_record_name = ' ||p_record_name);
287: hr_utility.trace(' p_input_2 = ' ||p_input_2);
288: hr_utility.trace(' p_input_2 = ' ||p_input_2);
289: hr_utility.trace(' p_input_3 = ' ||p_input_3);
282: ln_return_value number := 0;
283: BEGIN
284:
285: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
286: hr_utility.trace(' p_record_name = ' ||p_record_name);
287: hr_utility.trace(' p_input_2 = ' ||p_input_2);
288: hr_utility.trace(' p_input_2 = ' ||p_input_2);
289: hr_utility.trace(' p_input_3 = ' ||p_input_3);
290: hr_utility.trace(' p_input_4 = ' ||p_input_4);
283: BEGIN
284:
285: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
286: hr_utility.trace(' p_record_name = ' ||p_record_name);
287: hr_utility.trace(' p_input_2 = ' ||p_input_2);
288: hr_utility.trace(' p_input_2 = ' ||p_input_2);
289: hr_utility.trace(' p_input_3 = ' ||p_input_3);
290: hr_utility.trace(' p_input_4 = ' ||p_input_4);
291: hr_utility.trace(' p_input_5 = ' ||p_input_5);
284:
285: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
286: hr_utility.trace(' p_record_name = ' ||p_record_name);
287: hr_utility.trace(' p_input_2 = ' ||p_input_2);
288: hr_utility.trace(' p_input_2 = ' ||p_input_2);
289: hr_utility.trace(' p_input_3 = ' ||p_input_3);
290: hr_utility.trace(' p_input_4 = ' ||p_input_4);
291: hr_utility.trace(' p_input_5 = ' ||p_input_5);
292: hr_utility.trace(' p_input_6 = ' ||p_input_6);
285: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
286: hr_utility.trace(' p_record_name = ' ||p_record_name);
287: hr_utility.trace(' p_input_2 = ' ||p_input_2);
288: hr_utility.trace(' p_input_2 = ' ||p_input_2);
289: hr_utility.trace(' p_input_3 = ' ||p_input_3);
290: hr_utility.trace(' p_input_4 = ' ||p_input_4);
291: hr_utility.trace(' p_input_5 = ' ||p_input_5);
292: hr_utility.trace(' p_input_6 = ' ||p_input_6);
293: hr_utility.trace(' p_input_7 = ' ||p_input_7);
286: hr_utility.trace(' p_record_name = ' ||p_record_name);
287: hr_utility.trace(' p_input_2 = ' ||p_input_2);
288: hr_utility.trace(' p_input_2 = ' ||p_input_2);
289: hr_utility.trace(' p_input_3 = ' ||p_input_3);
290: hr_utility.trace(' p_input_4 = ' ||p_input_4);
291: hr_utility.trace(' p_input_5 = ' ||p_input_5);
292: hr_utility.trace(' p_input_6 = ' ||p_input_6);
293: hr_utility.trace(' p_input_7 = ' ||p_input_7);
294: hr_utility.trace(' p_input_8 = ' ||p_input_8);
287: hr_utility.trace(' p_input_2 = ' ||p_input_2);
288: hr_utility.trace(' p_input_2 = ' ||p_input_2);
289: hr_utility.trace(' p_input_3 = ' ||p_input_3);
290: hr_utility.trace(' p_input_4 = ' ||p_input_4);
291: hr_utility.trace(' p_input_5 = ' ||p_input_5);
292: hr_utility.trace(' p_input_6 = ' ||p_input_6);
293: hr_utility.trace(' p_input_7 = ' ||p_input_7);
294: hr_utility.trace(' p_input_8 = ' ||p_input_8);
295: hr_utility.trace(' p_input_9 = ' ||p_input_9);
288: hr_utility.trace(' p_input_2 = ' ||p_input_2);
289: hr_utility.trace(' p_input_3 = ' ||p_input_3);
290: hr_utility.trace(' p_input_4 = ' ||p_input_4);
291: hr_utility.trace(' p_input_5 = ' ||p_input_5);
292: hr_utility.trace(' p_input_6 = ' ||p_input_6);
293: hr_utility.trace(' p_input_7 = ' ||p_input_7);
294: hr_utility.trace(' p_input_8 = ' ||p_input_8);
295: hr_utility.trace(' p_input_9 = ' ||p_input_9);
296: hr_utility.trace(' p_input_10 = ' ||p_input_10);
289: hr_utility.trace(' p_input_3 = ' ||p_input_3);
290: hr_utility.trace(' p_input_4 = ' ||p_input_4);
291: hr_utility.trace(' p_input_5 = ' ||p_input_5);
292: hr_utility.trace(' p_input_6 = ' ||p_input_6);
293: hr_utility.trace(' p_input_7 = ' ||p_input_7);
294: hr_utility.trace(' p_input_8 = ' ||p_input_8);
295: hr_utility.trace(' p_input_9 = ' ||p_input_9);
296: hr_utility.trace(' p_input_10 = ' ||p_input_10);
297: hr_utility.trace(' p_input_11 = ' ||p_input_11);
290: hr_utility.trace(' p_input_4 = ' ||p_input_4);
291: hr_utility.trace(' p_input_5 = ' ||p_input_5);
292: hr_utility.trace(' p_input_6 = ' ||p_input_6);
293: hr_utility.trace(' p_input_7 = ' ||p_input_7);
294: hr_utility.trace(' p_input_8 = ' ||p_input_8);
295: hr_utility.trace(' p_input_9 = ' ||p_input_9);
296: hr_utility.trace(' p_input_10 = ' ||p_input_10);
297: hr_utility.trace(' p_input_11 = ' ||p_input_11);
298: hr_utility.trace(' p_input_12 = ' ||p_input_12);
291: hr_utility.trace(' p_input_5 = ' ||p_input_5);
292: hr_utility.trace(' p_input_6 = ' ||p_input_6);
293: hr_utility.trace(' p_input_7 = ' ||p_input_7);
294: hr_utility.trace(' p_input_8 = ' ||p_input_8);
295: hr_utility.trace(' p_input_9 = ' ||p_input_9);
296: hr_utility.trace(' p_input_10 = ' ||p_input_10);
297: hr_utility.trace(' p_input_11 = ' ||p_input_11);
298: hr_utility.trace(' p_input_12 = ' ||p_input_12);
299: hr_utility.trace(' p_input_13 = ' ||p_input_13);
292: hr_utility.trace(' p_input_6 = ' ||p_input_6);
293: hr_utility.trace(' p_input_7 = ' ||p_input_7);
294: hr_utility.trace(' p_input_8 = ' ||p_input_8);
295: hr_utility.trace(' p_input_9 = ' ||p_input_9);
296: hr_utility.trace(' p_input_10 = ' ||p_input_10);
297: hr_utility.trace(' p_input_11 = ' ||p_input_11);
298: hr_utility.trace(' p_input_12 = ' ||p_input_12);
299: hr_utility.trace(' p_input_13 = ' ||p_input_13);
300: hr_utility.trace(' p_input_14 = ' ||p_input_14);
293: hr_utility.trace(' p_input_7 = ' ||p_input_7);
294: hr_utility.trace(' p_input_8 = ' ||p_input_8);
295: hr_utility.trace(' p_input_9 = ' ||p_input_9);
296: hr_utility.trace(' p_input_10 = ' ||p_input_10);
297: hr_utility.trace(' p_input_11 = ' ||p_input_11);
298: hr_utility.trace(' p_input_12 = ' ||p_input_12);
299: hr_utility.trace(' p_input_13 = ' ||p_input_13);
300: hr_utility.trace(' p_input_14 = ' ||p_input_14);
301: hr_utility.trace(' p_input_15 = ' ||p_input_15);
294: hr_utility.trace(' p_input_8 = ' ||p_input_8);
295: hr_utility.trace(' p_input_9 = ' ||p_input_9);
296: hr_utility.trace(' p_input_10 = ' ||p_input_10);
297: hr_utility.trace(' p_input_11 = ' ||p_input_11);
298: hr_utility.trace(' p_input_12 = ' ||p_input_12);
299: hr_utility.trace(' p_input_13 = ' ||p_input_13);
300: hr_utility.trace(' p_input_14 = ' ||p_input_14);
301: hr_utility.trace(' p_input_15 = ' ||p_input_15);
302: hr_utility.trace(' p_input_16 = ' ||p_input_16);
295: hr_utility.trace(' p_input_9 = ' ||p_input_9);
296: hr_utility.trace(' p_input_10 = ' ||p_input_10);
297: hr_utility.trace(' p_input_11 = ' ||p_input_11);
298: hr_utility.trace(' p_input_12 = ' ||p_input_12);
299: hr_utility.trace(' p_input_13 = ' ||p_input_13);
300: hr_utility.trace(' p_input_14 = ' ||p_input_14);
301: hr_utility.trace(' p_input_15 = ' ||p_input_15);
302: hr_utility.trace(' p_input_16 = ' ||p_input_16);
303: hr_utility.trace(' p_input_17 = ' ||p_input_17);
296: hr_utility.trace(' p_input_10 = ' ||p_input_10);
297: hr_utility.trace(' p_input_11 = ' ||p_input_11);
298: hr_utility.trace(' p_input_12 = ' ||p_input_12);
299: hr_utility.trace(' p_input_13 = ' ||p_input_13);
300: hr_utility.trace(' p_input_14 = ' ||p_input_14);
301: hr_utility.trace(' p_input_15 = ' ||p_input_15);
302: hr_utility.trace(' p_input_16 = ' ||p_input_16);
303: hr_utility.trace(' p_input_17 = ' ||p_input_17);
304: hr_utility.trace(' p_input_18 = ' ||p_input_18);
297: hr_utility.trace(' p_input_11 = ' ||p_input_11);
298: hr_utility.trace(' p_input_12 = ' ||p_input_12);
299: hr_utility.trace(' p_input_13 = ' ||p_input_13);
300: hr_utility.trace(' p_input_14 = ' ||p_input_14);
301: hr_utility.trace(' p_input_15 = ' ||p_input_15);
302: hr_utility.trace(' p_input_16 = ' ||p_input_16);
303: hr_utility.trace(' p_input_17 = ' ||p_input_17);
304: hr_utility.trace(' p_input_18 = ' ||p_input_18);
305: hr_utility.trace(' p_input_19 = ' ||p_input_19);
298: hr_utility.trace(' p_input_12 = ' ||p_input_12);
299: hr_utility.trace(' p_input_13 = ' ||p_input_13);
300: hr_utility.trace(' p_input_14 = ' ||p_input_14);
301: hr_utility.trace(' p_input_15 = ' ||p_input_15);
302: hr_utility.trace(' p_input_16 = ' ||p_input_16);
303: hr_utility.trace(' p_input_17 = ' ||p_input_17);
304: hr_utility.trace(' p_input_18 = ' ||p_input_18);
305: hr_utility.trace(' p_input_19 = ' ||p_input_19);
306: hr_utility.trace(' p_input_20 = ' ||p_input_20);
299: hr_utility.trace(' p_input_13 = ' ||p_input_13);
300: hr_utility.trace(' p_input_14 = ' ||p_input_14);
301: hr_utility.trace(' p_input_15 = ' ||p_input_15);
302: hr_utility.trace(' p_input_16 = ' ||p_input_16);
303: hr_utility.trace(' p_input_17 = ' ||p_input_17);
304: hr_utility.trace(' p_input_18 = ' ||p_input_18);
305: hr_utility.trace(' p_input_19 = ' ||p_input_19);
306: hr_utility.trace(' p_input_20 = ' ||p_input_20);
307: hr_utility.trace(' p_input_21 = ' ||p_input_21);
300: hr_utility.trace(' p_input_14 = ' ||p_input_14);
301: hr_utility.trace(' p_input_15 = ' ||p_input_15);
302: hr_utility.trace(' p_input_16 = ' ||p_input_16);
303: hr_utility.trace(' p_input_17 = ' ||p_input_17);
304: hr_utility.trace(' p_input_18 = ' ||p_input_18);
305: hr_utility.trace(' p_input_19 = ' ||p_input_19);
306: hr_utility.trace(' p_input_20 = ' ||p_input_20);
307: hr_utility.trace(' p_input_21 = ' ||p_input_21);
308: hr_utility.trace(' p_input_22 = ' ||p_input_22);
301: hr_utility.trace(' p_input_15 = ' ||p_input_15);
302: hr_utility.trace(' p_input_16 = ' ||p_input_16);
303: hr_utility.trace(' p_input_17 = ' ||p_input_17);
304: hr_utility.trace(' p_input_18 = ' ||p_input_18);
305: hr_utility.trace(' p_input_19 = ' ||p_input_19);
306: hr_utility.trace(' p_input_20 = ' ||p_input_20);
307: hr_utility.trace(' p_input_21 = ' ||p_input_21);
308: hr_utility.trace(' p_input_22 = ' ||p_input_22);
309: hr_utility.trace(' p_input_23 = ' ||p_input_23);
302: hr_utility.trace(' p_input_16 = ' ||p_input_16);
303: hr_utility.trace(' p_input_17 = ' ||p_input_17);
304: hr_utility.trace(' p_input_18 = ' ||p_input_18);
305: hr_utility.trace(' p_input_19 = ' ||p_input_19);
306: hr_utility.trace(' p_input_20 = ' ||p_input_20);
307: hr_utility.trace(' p_input_21 = ' ||p_input_21);
308: hr_utility.trace(' p_input_22 = ' ||p_input_22);
309: hr_utility.trace(' p_input_23 = ' ||p_input_23);
310: hr_utility.trace(' p_input_24 = ' ||p_input_24);
303: hr_utility.trace(' p_input_17 = ' ||p_input_17);
304: hr_utility.trace(' p_input_18 = ' ||p_input_18);
305: hr_utility.trace(' p_input_19 = ' ||p_input_19);
306: hr_utility.trace(' p_input_20 = ' ||p_input_20);
307: hr_utility.trace(' p_input_21 = ' ||p_input_21);
308: hr_utility.trace(' p_input_22 = ' ||p_input_22);
309: hr_utility.trace(' p_input_23 = ' ||p_input_23);
310: hr_utility.trace(' p_input_24 = ' ||p_input_24);
311: hr_utility.trace(' p_input_25 = ' ||p_input_25);
304: hr_utility.trace(' p_input_18 = ' ||p_input_18);
305: hr_utility.trace(' p_input_19 = ' ||p_input_19);
306: hr_utility.trace(' p_input_20 = ' ||p_input_20);
307: hr_utility.trace(' p_input_21 = ' ||p_input_21);
308: hr_utility.trace(' p_input_22 = ' ||p_input_22);
309: hr_utility.trace(' p_input_23 = ' ||p_input_23);
310: hr_utility.trace(' p_input_24 = ' ||p_input_24);
311: hr_utility.trace(' p_input_25 = ' ||p_input_25);
312: hr_utility.trace(' p_input_26 = ' ||p_input_26);
305: hr_utility.trace(' p_input_19 = ' ||p_input_19);
306: hr_utility.trace(' p_input_20 = ' ||p_input_20);
307: hr_utility.trace(' p_input_21 = ' ||p_input_21);
308: hr_utility.trace(' p_input_22 = ' ||p_input_22);
309: hr_utility.trace(' p_input_23 = ' ||p_input_23);
310: hr_utility.trace(' p_input_24 = ' ||p_input_24);
311: hr_utility.trace(' p_input_25 = ' ||p_input_25);
312: hr_utility.trace(' p_input_26 = ' ||p_input_26);
313: hr_utility.trace(' p_input_27 = ' ||p_input_27);
306: hr_utility.trace(' p_input_20 = ' ||p_input_20);
307: hr_utility.trace(' p_input_21 = ' ||p_input_21);
308: hr_utility.trace(' p_input_22 = ' ||p_input_22);
309: hr_utility.trace(' p_input_23 = ' ||p_input_23);
310: hr_utility.trace(' p_input_24 = ' ||p_input_24);
311: hr_utility.trace(' p_input_25 = ' ||p_input_25);
312: hr_utility.trace(' p_input_26 = ' ||p_input_26);
313: hr_utility.trace(' p_input_27 = ' ||p_input_27);
314: hr_utility.trace(' p_input_28 = ' ||p_input_28);
307: hr_utility.trace(' p_input_21 = ' ||p_input_21);
308: hr_utility.trace(' p_input_22 = ' ||p_input_22);
309: hr_utility.trace(' p_input_23 = ' ||p_input_23);
310: hr_utility.trace(' p_input_24 = ' ||p_input_24);
311: hr_utility.trace(' p_input_25 = ' ||p_input_25);
312: hr_utility.trace(' p_input_26 = ' ||p_input_26);
313: hr_utility.trace(' p_input_27 = ' ||p_input_27);
314: hr_utility.trace(' p_input_28 = ' ||p_input_28);
315: hr_utility.trace(' p_input_29 = ' ||p_input_29);
308: hr_utility.trace(' p_input_22 = ' ||p_input_22);
309: hr_utility.trace(' p_input_23 = ' ||p_input_23);
310: hr_utility.trace(' p_input_24 = ' ||p_input_24);
311: hr_utility.trace(' p_input_25 = ' ||p_input_25);
312: hr_utility.trace(' p_input_26 = ' ||p_input_26);
313: hr_utility.trace(' p_input_27 = ' ||p_input_27);
314: hr_utility.trace(' p_input_28 = ' ||p_input_28);
315: hr_utility.trace(' p_input_29 = ' ||p_input_29);
316: hr_utility.trace(' p_input_30 = ' ||p_input_30);
309: hr_utility.trace(' p_input_23 = ' ||p_input_23);
310: hr_utility.trace(' p_input_24 = ' ||p_input_24);
311: hr_utility.trace(' p_input_25 = ' ||p_input_25);
312: hr_utility.trace(' p_input_26 = ' ||p_input_26);
313: hr_utility.trace(' p_input_27 = ' ||p_input_27);
314: hr_utility.trace(' p_input_28 = ' ||p_input_28);
315: hr_utility.trace(' p_input_29 = ' ||p_input_29);
316: hr_utility.trace(' p_input_30 = ' ||p_input_30);
317: hr_utility.trace(' p_input_31 = ' ||p_input_31);
310: hr_utility.trace(' p_input_24 = ' ||p_input_24);
311: hr_utility.trace(' p_input_25 = ' ||p_input_25);
312: hr_utility.trace(' p_input_26 = ' ||p_input_26);
313: hr_utility.trace(' p_input_27 = ' ||p_input_27);
314: hr_utility.trace(' p_input_28 = ' ||p_input_28);
315: hr_utility.trace(' p_input_29 = ' ||p_input_29);
316: hr_utility.trace(' p_input_30 = ' ||p_input_30);
317: hr_utility.trace(' p_input_31 = ' ||p_input_31);
318: hr_utility.trace(' p_input_32 = ' ||p_input_32);
311: hr_utility.trace(' p_input_25 = ' ||p_input_25);
312: hr_utility.trace(' p_input_26 = ' ||p_input_26);
313: hr_utility.trace(' p_input_27 = ' ||p_input_27);
314: hr_utility.trace(' p_input_28 = ' ||p_input_28);
315: hr_utility.trace(' p_input_29 = ' ||p_input_29);
316: hr_utility.trace(' p_input_30 = ' ||p_input_30);
317: hr_utility.trace(' p_input_31 = ' ||p_input_31);
318: hr_utility.trace(' p_input_32 = ' ||p_input_32);
319: hr_utility.trace(' p_input_33 = ' ||p_input_33);
312: hr_utility.trace(' p_input_26 = ' ||p_input_26);
313: hr_utility.trace(' p_input_27 = ' ||p_input_27);
314: hr_utility.trace(' p_input_28 = ' ||p_input_28);
315: hr_utility.trace(' p_input_29 = ' ||p_input_29);
316: hr_utility.trace(' p_input_30 = ' ||p_input_30);
317: hr_utility.trace(' p_input_31 = ' ||p_input_31);
318: hr_utility.trace(' p_input_32 = ' ||p_input_32);
319: hr_utility.trace(' p_input_33 = ' ||p_input_33);
320: hr_utility.trace(' p_input_34 = ' ||p_input_34);
313: hr_utility.trace(' p_input_27 = ' ||p_input_27);
314: hr_utility.trace(' p_input_28 = ' ||p_input_28);
315: hr_utility.trace(' p_input_29 = ' ||p_input_29);
316: hr_utility.trace(' p_input_30 = ' ||p_input_30);
317: hr_utility.trace(' p_input_31 = ' ||p_input_31);
318: hr_utility.trace(' p_input_32 = ' ||p_input_32);
319: hr_utility.trace(' p_input_33 = ' ||p_input_33);
320: hr_utility.trace(' p_input_34 = ' ||p_input_34);
321: hr_utility.trace(' p_input_35 = ' ||p_input_35);
314: hr_utility.trace(' p_input_28 = ' ||p_input_28);
315: hr_utility.trace(' p_input_29 = ' ||p_input_29);
316: hr_utility.trace(' p_input_30 = ' ||p_input_30);
317: hr_utility.trace(' p_input_31 = ' ||p_input_31);
318: hr_utility.trace(' p_input_32 = ' ||p_input_32);
319: hr_utility.trace(' p_input_33 = ' ||p_input_33);
320: hr_utility.trace(' p_input_34 = ' ||p_input_34);
321: hr_utility.trace(' p_input_35 = ' ||p_input_35);
322: hr_utility.trace(' p_input_36 = ' ||p_input_36);
315: hr_utility.trace(' p_input_29 = ' ||p_input_29);
316: hr_utility.trace(' p_input_30 = ' ||p_input_30);
317: hr_utility.trace(' p_input_31 = ' ||p_input_31);
318: hr_utility.trace(' p_input_32 = ' ||p_input_32);
319: hr_utility.trace(' p_input_33 = ' ||p_input_33);
320: hr_utility.trace(' p_input_34 = ' ||p_input_34);
321: hr_utility.trace(' p_input_35 = ' ||p_input_35);
322: hr_utility.trace(' p_input_36 = ' ||p_input_36);
323: hr_utility.trace(' p_input_37 = ' ||p_input_37);
316: hr_utility.trace(' p_input_30 = ' ||p_input_30);
317: hr_utility.trace(' p_input_31 = ' ||p_input_31);
318: hr_utility.trace(' p_input_32 = ' ||p_input_32);
319: hr_utility.trace(' p_input_33 = ' ||p_input_33);
320: hr_utility.trace(' p_input_34 = ' ||p_input_34);
321: hr_utility.trace(' p_input_35 = ' ||p_input_35);
322: hr_utility.trace(' p_input_36 = ' ||p_input_36);
323: hr_utility.trace(' p_input_37 = ' ||p_input_37);
324: hr_utility.trace(' p_input_38 = ' ||p_input_38);
317: hr_utility.trace(' p_input_31 = ' ||p_input_31);
318: hr_utility.trace(' p_input_32 = ' ||p_input_32);
319: hr_utility.trace(' p_input_33 = ' ||p_input_33);
320: hr_utility.trace(' p_input_34 = ' ||p_input_34);
321: hr_utility.trace(' p_input_35 = ' ||p_input_35);
322: hr_utility.trace(' p_input_36 = ' ||p_input_36);
323: hr_utility.trace(' p_input_37 = ' ||p_input_37);
324: hr_utility.trace(' p_input_38 = ' ||p_input_38);
325: hr_utility.trace(' p_input_39 = ' ||p_input_39);
318: hr_utility.trace(' p_input_32 = ' ||p_input_32);
319: hr_utility.trace(' p_input_33 = ' ||p_input_33);
320: hr_utility.trace(' p_input_34 = ' ||p_input_34);
321: hr_utility.trace(' p_input_35 = ' ||p_input_35);
322: hr_utility.trace(' p_input_36 = ' ||p_input_36);
323: hr_utility.trace(' p_input_37 = ' ||p_input_37);
324: hr_utility.trace(' p_input_38 = ' ||p_input_38);
325: hr_utility.trace(' p_input_39 = ' ||p_input_39);
326: hr_utility.trace(' p_input_40 = ' ||p_input_40);
319: hr_utility.trace(' p_input_33 = ' ||p_input_33);
320: hr_utility.trace(' p_input_34 = ' ||p_input_34);
321: hr_utility.trace(' p_input_35 = ' ||p_input_35);
322: hr_utility.trace(' p_input_36 = ' ||p_input_36);
323: hr_utility.trace(' p_input_37 = ' ||p_input_37);
324: hr_utility.trace(' p_input_38 = ' ||p_input_38);
325: hr_utility.trace(' p_input_39 = ' ||p_input_39);
326: hr_utility.trace(' p_input_40 = ' ||p_input_40);
327:
320: hr_utility.trace(' p_input_34 = ' ||p_input_34);
321: hr_utility.trace(' p_input_35 = ' ||p_input_35);
322: hr_utility.trace(' p_input_36 = ' ||p_input_36);
323: hr_utility.trace(' p_input_37 = ' ||p_input_37);
324: hr_utility.trace(' p_input_38 = ' ||p_input_38);
325: hr_utility.trace(' p_input_39 = ' ||p_input_39);
326: hr_utility.trace(' p_input_40 = ' ||p_input_40);
327:
328: IF p_format = 'MMREF2' THEN -- p_format
321: hr_utility.trace(' p_input_35 = ' ||p_input_35);
322: hr_utility.trace(' p_input_36 = ' ||p_input_36);
323: hr_utility.trace(' p_input_37 = ' ||p_input_37);
324: hr_utility.trace(' p_input_38 = ' ||p_input_38);
325: hr_utility.trace(' p_input_39 = ' ||p_input_39);
326: hr_utility.trace(' p_input_40 = ' ||p_input_40);
327:
328: IF p_format = 'MMREF2' THEN -- p_format
329: --{
322: hr_utility.trace(' p_input_36 = ' ||p_input_36);
323: hr_utility.trace(' p_input_37 = ' ||p_input_37);
324: hr_utility.trace(' p_input_38 = ' ||p_input_38);
325: hr_utility.trace(' p_input_39 = ' ||p_input_39);
326: hr_utility.trace(' p_input_40 = ' ||p_input_40);
327:
328: IF p_format = 'MMREF2' THEN -- p_format
329: --{
330: IF (p_report_type = 'W2C') THEN
329: --{
330: IF (p_report_type = 'W2C') THEN
331: --{
332: IF p_record_name = 'RCA' THEN -- p_record_name
333: hr_utility.set_location( gv_package || '.format_w2c_record',10);
334: return_value := pay_us_mmrf2_w2c_format_record.format_W2C_RCA_record(
335: p_effective_date,
336: p_report_type,
337: p_format,
386: sp_out_5,
387: ret_str_len,
388: l_exclude_from_output_chk
389: );
390: hr_utility.set_location( gv_package || '.format_w2c_record',20);
391: ELSIF p_record_name = 'RCE' THEN
392: hr_utility.set_location( gv_package || '.format_w2c_record',30);
393: --
394: -- Initialize GRE level Totals globally defined
388: l_exclude_from_output_chk
389: );
390: hr_utility.set_location( gv_package || '.format_w2c_record',20);
391: ELSIF p_record_name = 'RCE' THEN
392: hr_utility.set_location( gv_package || '.format_w2c_record',30);
393: --
394: -- Initialize GRE level Totals globally defined
395: --
396: ln_return_value := Initialize_GRE_Level_total;
393: --
394: -- Initialize GRE level Totals globally defined
395: --
396: ln_return_value := Initialize_GRE_Level_total;
397: hr_utility.set_location( gv_package || '.format_w2c_record',40);
398: --
399: -- Format RCE Record for the GRE
400: --
401: return_value :=
454: sp_out_5,
455: ret_str_len,
456: l_exclude_from_output_chk
457: );
458: hr_utility.set_location( gv_package || '.format_w2c_record',50);
459: ELSIF p_record_name = 'RCF' THEN
460: hr_utility.set_location( gv_package || '.format_w2c_record',60);
461: ln_return_value := Initialize_GRE_Level_total;
462: l_total_rcw_records :=
456: l_exclude_from_output_chk
457: );
458: hr_utility.set_location( gv_package || '.format_w2c_record',50);
459: ELSIF p_record_name = 'RCF' THEN
460: hr_utility.set_location( gv_package || '.format_w2c_record',60);
461: ln_return_value := Initialize_GRE_Level_total;
462: l_total_rcw_records :=
463: NVL(pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf,0);
464: hr_utility.trace('Total No of RCW processed for File Total ' ||to_char(l_total_rcw_records) );
460: hr_utility.set_location( gv_package || '.format_w2c_record',60);
461: ln_return_value := Initialize_GRE_Level_total;
462: l_total_rcw_records :=
463: NVL(pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf,0);
464: hr_utility.trace('Total No of RCW processed for File Total ' ||to_char(l_total_rcw_records) );
465: hr_utility.trace('Formula feed Total No of RCW processed ' ||p_input_2 );
466: return_value :=
467: pay_us_mmrf2_w2c_format_record.format_W2C_RCF_record(
468: p_effective_date,
461: ln_return_value := Initialize_GRE_Level_total;
462: l_total_rcw_records :=
463: NVL(pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf,0);
464: hr_utility.trace('Total No of RCW processed for File Total ' ||to_char(l_total_rcw_records) );
465: hr_utility.trace('Formula feed Total No of RCW processed ' ||p_input_2 );
466: return_value :=
467: pay_us_mmrf2_w2c_format_record.format_W2C_RCF_record(
468: p_effective_date,
469: p_report_type,
479: p_exclude_from_output,
480: ret_str_len,
481: l_exclude_from_output_chk
482: );
483: hr_utility.set_location( gv_package || '.format_w2c_record',70);
484:
485: ELSIF p_record_name = 'RCW' then
486: hr_utility.set_location( gv_package || '.format_w2c_record',80);
487: if p_input_40 = 'FLAT' then
482: );
483: hr_utility.set_location( gv_package || '.format_w2c_record',70);
484:
485: ELSIF p_record_name = 'RCW' then
486: hr_utility.set_location( gv_package || '.format_w2c_record',80);
487: if p_input_40 = 'FLAT' then
488: --{
489: return_value := pay_us_w2c_in_mmref2_format.pay_us_w2c_RCW_record (
490: p_effective_date,
521: sp_out_5,
522: ret_str_len,
523: l_exclude_from_output_chk
524: );
525: hr_utility.set_location( gv_package || '.format_w2c_record',90);
526: elsif p_input_40 = 'CSV' then
527: --
528: -- When RCW record is formatted for FLAT format, it also formats CSV and stores
529: -- the value when required it would use the CSV format record for audit purpose
527: --
528: -- When RCW record is formatted for FLAT format, it also formats CSV and stores
529: -- the value when required it would use the CSV format record for audit purpose
530: --
531: hr_utility.set_location( gv_package || '.format_w2c_record',100);
532: return_value := pay_us_w2c_in_mmref2_format.rcw_csv_record;
533: elsif p_input_40 = 'BLANK' then
534: --
535: -- When RCW record is formatted for FLAT format, it also formats
535: -- When RCW record is formatted for FLAT format, it also formats
536: -- Blank CSV of RCW for audit purpose only. The blank RCW would
537: -- be used for reporting Error on RCO.
538: --
539: hr_utility.set_location( gv_package || '.format_w2c_record',110);
540: return_value := pay_us_w2c_in_mmref2_format.rcw_blank_csv_record;
541: end if;
542: ELSIF p_record_name = 'RCO' then
543: --{
540: return_value := pay_us_w2c_in_mmref2_format.rcw_blank_csv_record;
541: end if;
542: ELSIF p_record_name = 'RCO' then
543: --{
544: hr_utility.set_location( gv_package || '.format_w2c_record',150);
545: if p_input_40 = 'FLAT' then
546: --{
547: hr_utility.trace('Formating RCO for mf file ');
548: hr_utility.trace('RCO Exclude from output Flag '||
543: --{
544: hr_utility.set_location( gv_package || '.format_w2c_record',150);
545: if p_input_40 = 'FLAT' then
546: --{
547: hr_utility.trace('Formating RCO for mf file ');
548: hr_utility.trace('RCO Exclude from output Flag '||
549: pay_us_w2c_in_mmref2_format.rco_exclude_flag);
550: return_value := pay_us_w2c_in_mmref2_format.rco_mf_record;
551: if pay_us_w2c_in_mmref2_format.rco_exclude_flag = 'Y'
544: hr_utility.set_location( gv_package || '.format_w2c_record',150);
545: if p_input_40 = 'FLAT' then
546: --{
547: hr_utility.trace('Formating RCO for mf file ');
548: hr_utility.trace('RCO Exclude from output Flag '||
549: pay_us_w2c_in_mmref2_format.rco_exclude_flag);
550: return_value := pay_us_w2c_in_mmref2_format.rco_mf_record;
551: if pay_us_w2c_in_mmref2_format.rco_exclude_flag = 'Y'
552: then
553: l_exclude_from_output_chk := TRUE;
554: else
555: l_exclude_from_output_chk := FALSE;
556: end if;
557: hr_utility.set_location( gv_package || '.format_w2c_record',160);
558: --}
559: elsif p_input_40 = 'CSV' then
560: --
561: -- When RCW record is formatted for FLAT format, it also formats CSV and stores
560: --
561: -- When RCW record is formatted for FLAT format, it also formats CSV and stores
562: -- the value when required it would use the CSV format record for audit purpose
563: --
564: hr_utility.trace('Formating RCO in CSV format for Audit file ');
565: hr_utility.set_location( gv_package || '.format_w2c_record',170);
566: return_value := pay_us_w2c_in_mmref2_format.rco_csv_record;
567: elsif p_input_40 = 'BLANK' then
568: --
561: -- When RCW record is formatted for FLAT format, it also formats CSV and stores
562: -- the value when required it would use the CSV format record for audit purpose
563: --
564: hr_utility.trace('Formating RCO in CSV format for Audit file ');
565: hr_utility.set_location( gv_package || '.format_w2c_record',170);
566: return_value := pay_us_w2c_in_mmref2_format.rco_csv_record;
567: elsif p_input_40 = 'BLANK' then
568: --
569: -- When RCW record is formatted for FLAT format, it also formats
569: -- When RCW record is formatted for FLAT format, it also formats
570: -- Blank CSV of RCW for audit purpose only. The blank RCW would
571: -- be used for reporting Error on RCO.
572: --
573: hr_utility.trace('Formating BLANK RCO in CSV format for Audit file ');
574: hr_utility.set_location( gv_package || '.format_w2c_record',180);
575: return_value := pay_us_w2c_in_mmref2_format.rco_blank_csv_record;
576: ret_str_len := pay_us_w2c_in_mmref2_format.rco_number_of_correction;
577: hr_utility.trace('No of Correction on RCO record '|| to_char(ret_str_len));
570: -- Blank CSV of RCW for audit purpose only. The blank RCW would
571: -- be used for reporting Error on RCO.
572: --
573: hr_utility.trace('Formating BLANK RCO in CSV format for Audit file ');
574: hr_utility.set_location( gv_package || '.format_w2c_record',180);
575: return_value := pay_us_w2c_in_mmref2_format.rco_blank_csv_record;
576: ret_str_len := pay_us_w2c_in_mmref2_format.rco_number_of_correction;
577: hr_utility.trace('No of Correction on RCO record '|| to_char(ret_str_len));
578: end if;
573: hr_utility.trace('Formating BLANK RCO in CSV format for Audit file ');
574: hr_utility.set_location( gv_package || '.format_w2c_record',180);
575: return_value := pay_us_w2c_in_mmref2_format.rco_blank_csv_record;
576: ret_str_len := pay_us_w2c_in_mmref2_format.rco_number_of_correction;
577: hr_utility.trace('No of Correction on RCO record '|| to_char(ret_str_len));
578: end if;
579: --}
580: END IF; --p_record_name
581: --}
586: --
587: -- As formula function out parameter value can't exceed 200 characters
588: -- multiple out prameters are used to return a long varchar2
589: --
590: hr_utility.set_location( gv_package || '.format_w2_record',190);
591: main_return_string := substr(return_value,1,200);
592: sp_out_1:=substr(return_value,201,200);
593: sp_out_2:=substr(return_value,401,200);
594: sp_out_3:=substr(return_value,601,200);
599: p_exclude_from_output := 'Y';
600: ELSE
601: p_exclude_from_output := 'N';
602: END IF;
603: hr_utility.set_location( gv_package || '.format_w2_record',200);
604: hr_utility.trace('main_return_string = '||main_return_string);
605: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
606: hr_utility.trace('sp_out_1 = '||sp_out_1);
607: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
600: ELSE
601: p_exclude_from_output := 'N';
602: END IF;
603: hr_utility.set_location( gv_package || '.format_w2_record',200);
604: hr_utility.trace('main_return_string = '||main_return_string);
605: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
606: hr_utility.trace('sp_out_1 = '||sp_out_1);
607: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
608: hr_utility.trace('sp_out_2 = '||sp_out_2);
601: p_exclude_from_output := 'N';
602: END IF;
603: hr_utility.set_location( gv_package || '.format_w2_record',200);
604: hr_utility.trace('main_return_string = '||main_return_string);
605: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
606: hr_utility.trace('sp_out_1 = '||sp_out_1);
607: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
608: hr_utility.trace('sp_out_2 = '||sp_out_2);
609: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
602: END IF;
603: hr_utility.set_location( gv_package || '.format_w2_record',200);
604: hr_utility.trace('main_return_string = '||main_return_string);
605: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
606: hr_utility.trace('sp_out_1 = '||sp_out_1);
607: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
608: hr_utility.trace('sp_out_2 = '||sp_out_2);
609: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
610: hr_utility.trace('sp_out_3 = '||sp_out_3);
603: hr_utility.set_location( gv_package || '.format_w2_record',200);
604: hr_utility.trace('main_return_string = '||main_return_string);
605: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
606: hr_utility.trace('sp_out_1 = '||sp_out_1);
607: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
608: hr_utility.trace('sp_out_2 = '||sp_out_2);
609: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
610: hr_utility.trace('sp_out_3 = '||sp_out_3);
611: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
604: hr_utility.trace('main_return_string = '||main_return_string);
605: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
606: hr_utility.trace('sp_out_1 = '||sp_out_1);
607: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
608: hr_utility.trace('sp_out_2 = '||sp_out_2);
609: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
610: hr_utility.trace('sp_out_3 = '||sp_out_3);
611: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
612: hr_utility.trace('sp_out_4 = '||sp_out_4);
605: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
606: hr_utility.trace('sp_out_1 = '||sp_out_1);
607: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
608: hr_utility.trace('sp_out_2 = '||sp_out_2);
609: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
610: hr_utility.trace('sp_out_3 = '||sp_out_3);
611: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
612: hr_utility.trace('sp_out_4 = '||sp_out_4);
613: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
606: hr_utility.trace('sp_out_1 = '||sp_out_1);
607: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
608: hr_utility.trace('sp_out_2 = '||sp_out_2);
609: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
610: hr_utility.trace('sp_out_3 = '||sp_out_3);
611: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
612: hr_utility.trace('sp_out_4 = '||sp_out_4);
613: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
614: hr_utility.trace('sp_out_5 = '||sp_out_5);
607: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
608: hr_utility.trace('sp_out_2 = '||sp_out_2);
609: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
610: hr_utility.trace('sp_out_3 = '||sp_out_3);
611: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
612: hr_utility.trace('sp_out_4 = '||sp_out_4);
613: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
614: hr_utility.trace('sp_out_5 = '||sp_out_5);
615: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
608: hr_utility.trace('sp_out_2 = '||sp_out_2);
609: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
610: hr_utility.trace('sp_out_3 = '||sp_out_3);
611: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
612: hr_utility.trace('sp_out_4 = '||sp_out_4);
613: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
614: hr_utility.trace('sp_out_5 = '||sp_out_5);
615: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
616: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
609: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
610: hr_utility.trace('sp_out_3 = '||sp_out_3);
611: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
612: hr_utility.trace('sp_out_4 = '||sp_out_4);
613: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
614: hr_utility.trace('sp_out_5 = '||sp_out_5);
615: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
616: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
617: hr_utility.set_location( gv_package || '.format_w2_record',210);
610: hr_utility.trace('sp_out_3 = '||sp_out_3);
611: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
612: hr_utility.trace('sp_out_4 = '||sp_out_4);
613: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
614: hr_utility.trace('sp_out_5 = '||sp_out_5);
615: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
616: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
617: hr_utility.set_location( gv_package || '.format_w2_record',210);
618:
611: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
612: hr_utility.trace('sp_out_4 = '||sp_out_4);
613: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
614: hr_utility.trace('sp_out_5 = '||sp_out_5);
615: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
616: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
617: hr_utility.set_location( gv_package || '.format_w2_record',210);
618:
619: RETURN main_return_string;
612: hr_utility.trace('sp_out_4 = '||sp_out_4);
613: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
614: hr_utility.trace('sp_out_5 = '||sp_out_5);
615: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
616: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
617: hr_utility.set_location( gv_package || '.format_w2_record',210);
618:
619: RETURN main_return_string;
620: END Format_W2C_Record;
613: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
614: hr_utility.trace('sp_out_5 = '||sp_out_5);
615: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
616: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
617: hr_utility.set_location( gv_package || '.format_w2_record',210);
618:
619: RETURN main_return_string;
620: END Format_W2C_Record;
621: -- End of formatting record for W2C reporting
726: lb_exclude_from_output_chk boolean := FALSE;
727: lv_wage_value_in_cents varchar2(100) := ' ';
728: BEGIN
729:
730: hr_utility.set_location( gv_package || '.format_w2c_total_record',10);
731: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
732: hr_utility.trace(' p_record_name = ' ||p_record_name);
733:
734: IF p_format = 'MMREF2' THEN -- p_format
727: lv_wage_value_in_cents varchar2(100) := ' ';
728: BEGIN
729:
730: hr_utility.set_location( gv_package || '.format_w2c_total_record',10);
731: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
732: hr_utility.trace(' p_record_name = ' ||p_record_name);
733:
734: IF p_format = 'MMREF2' THEN -- p_format
735: --{
728: BEGIN
729:
730: hr_utility.set_location( gv_package || '.format_w2c_total_record',10);
731: hr_utility.trace(' p_report_qualifier = '||p_report_qualifier);
732: hr_utility.trace(' p_record_name = ' ||p_record_name);
733:
734: IF p_format = 'MMREF2' THEN -- p_format
735: --{
736: IF (p_report_type = 'W2C') THEN
736: IF (p_report_type = 'W2C') THEN
737: --{
738: IF p_record_name = 'RCT' THEN -- p_record_name
739: --{
740: hr_utility.set_location( gv_package || '.format_w2c_total_record',20);
741: parameter_record.delete;
742: parameter_record(1).p_parameter_name := 'Wages,Tips And Other Compensation';
743: parameter_record(2).p_parameter_name := 'Federal Income Tax Withheld';
744: parameter_record(3).p_parameter_name := 'Social Security Wages';
768:
769: ln_no_of_rcw_wages := 25; /* saurabh */
770:
771:
772: hr_utility.set_location( gv_package || '.format_w2c_total_record',30);
773:
774: FOR i IN 1..ln_no_of_rcw_wages
775: LOOP
776: if (NVL(pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old,0) <>
781: /* Negative Value check For Originally Reported Value on RCT */
782: lv_wage_value_in_cents :=
783: to_char(nvl(pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old,0 ));
784:
785: hr_utility.set_location( gv_package || '.format_w2c_total_record',40);
786:
787: pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old_formated :=
788: pay_us_reporting_utils_pkg.data_validation(
789: p_effective_date,
804: IF p_exclude_from_output = 'Y' THEN
805: lb_exclude_from_output_chk := TRUE;
806: END IF;
807:
808: hr_utility.trace(parameter_record(i).p_parameter_name||'(Old) = '
809: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old);
810:
811: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
812:
807:
808: hr_utility.trace(parameter_record(i).p_parameter_name||'(Old) = '
809: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old);
810:
811: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
812:
813: hr_utility.set_location( gv_package || '.format_w2c_total_record',50);
814: /* Negative Value check For Corrected Value to be reported on RCT */
815:
809: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old);
810:
811: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
812:
813: hr_utility.set_location( gv_package || '.format_w2c_total_record',50);
814: /* Negative Value check For Corrected Value to be reported on RCT */
815:
816: lv_wage_value_in_cents :=
817: to_char(nvl(pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new,0));
836: IF p_exclude_from_output = 'Y' THEN
837: lb_exclude_from_output_chk := TRUE;
838: END IF;
839:
840: hr_utility.set_location( gv_package || '.format_w2c_total_record',60);
841: hr_utility.trace(parameter_record(i).p_parameter_name||'(New) = '
842: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new);
843: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
844:
837: lb_exclude_from_output_chk := TRUE;
838: END IF;
839:
840: hr_utility.set_location( gv_package || '.format_w2c_total_record',60);
841: hr_utility.trace(parameter_record(i).p_parameter_name||'(New) = '
842: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new);
843: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
844:
845: /* Set output parameters when RCT Originally reported value and Corrected values
839:
840: hr_utility.set_location( gv_package || '.format_w2c_total_record',60);
841: hr_utility.trace(parameter_record(i).p_parameter_name||'(New) = '
842: ||pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new);
843: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
844:
845: /* Set output parameters when RCT Originally reported value and Corrected values
846: are not identical */
847: --{
921: p_output_52 := nvl(pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old,0);
922: p_output_54 := nvl(pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new,0);
923: end if;
924:
925: hr_utility.set_location( gv_package || '.format_w2c_total_record',70);
926: --}
927: --}
928: else
929: --{
926: --}
927: --}
928: else
929: --{
930: hr_utility.set_location( gv_package || '.format_w2c_total_record',80);
931:
932: pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_identical_flag := 'Y';
933: pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old_formated :=
934: lpad(' ',15);
1014: p_output_54 := '0';
1015: end if;
1016:
1017: --}
1018: hr_utility.set_location( gv_package || '.format_w2c_total_record',90);
1019: --}
1020: end if;
1021:
1022: END LOOP;
1020: end if;
1021:
1022: END LOOP;
1023:
1024: hr_utility.trace('p_output_47 '||p_output_47);
1025: hr_utility.trace('p_output_48 '||p_output_48);
1026:
1027: p_output_41 := lpad(NVL(pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rct,0),7,'0');
1028: p_output_42 := lpad(NVL(pay_us_w2c_in_mmref2_format.number_of_error_rcw_rct,0),7,'0');
1021:
1022: END LOOP;
1023:
1024: hr_utility.trace('p_output_47 '||p_output_47);
1025: hr_utility.trace('p_output_48 '||p_output_48);
1026:
1027: p_output_41 := lpad(NVL(pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rct,0),7,'0');
1028: p_output_42 := lpad(NVL(pay_us_w2c_in_mmref2_format.number_of_error_rcw_rct,0),7,'0');
1029:
1026:
1027: p_output_41 := lpad(NVL(pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rct,0),7,'0');
1028: p_output_42 := lpad(NVL(pay_us_w2c_in_mmref2_format.number_of_error_rcw_rct,0),7,'0');
1029:
1030: hr_utility.set_location( gv_package || '.format_w2c_total_record',100);
1031:
1032: return_value :=
1033: pay_us_mmrf2_w2c_format_record.format_W2C_RCT_record(
1034: p_effective_date,
1046: ret_str_len,
1047: lb_exclude_from_output_chk
1048: );
1049:
1050: hr_utility.set_location( gv_package || '.format_w2c_total_record',110);
1051: -- End of Formating RCT Record
1052: --
1053: --}
1054: ELSIF p_record_name = 'RCU' THEN
1052: --
1053: --}
1054: ELSIF p_record_name = 'RCU' THEN
1055: --{
1056: hr_utility.set_location( gv_package || '.format_w2c_total_record',120);
1057: parameter_record.delete;
1058: ln_no_of_rco_wages := 8;
1059: parameter_record(1).p_parameter_name:= ' Allocated Tips';
1060: parameter_record(2).p_parameter_name:= 'Uncollected employee tax on tips';
1066: parameter_record(8).p_parameter_name:= 'income under 409A';
1067: --
1068: -- Compare RCO Wage total for formatting RCU Total Wage Record
1069: --
1070: hr_utility.set_location( gv_package || '.format_w2c_total_record',130);
1071: FOR i IN 1..ln_no_of_rco_wages
1072: LOOP
1073: if (NVL(pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old,0) <>
1074: NVL(pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new,0)) then
1072: LOOP
1073: if (NVL(pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old,0) <>
1074: NVL(pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new,0)) then
1075: --{
1076: hr_utility.set_location( gv_package || '.format_w2c_total_record',140);
1077: pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_identical_flag := 'N';
1078:
1079: /* Negative Value check For Originally Reported Value on RCT */
1080: lv_wage_value_in_cents :=
1097: sp_out_2);
1098: IF p_exclude_from_output = 'Y' THEN
1099: lb_exclude_from_output_chk := TRUE;
1100: END IF;
1101: hr_utility.set_location( gv_package || '.format_w2c_total_record',150);
1102: hr_utility.trace(parameter_record(i).p_parameter_name||'(Old) = '
1103: ||lv_wage_value_in_cents);
1104: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1105:
1098: IF p_exclude_from_output = 'Y' THEN
1099: lb_exclude_from_output_chk := TRUE;
1100: END IF;
1101: hr_utility.set_location( gv_package || '.format_w2c_total_record',150);
1102: hr_utility.trace(parameter_record(i).p_parameter_name||'(Old) = '
1103: ||lv_wage_value_in_cents);
1104: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1105:
1106: /* Negative Value check For Corrected Value to be reported on RCU */
1100: END IF;
1101: hr_utility.set_location( gv_package || '.format_w2c_total_record',150);
1102: hr_utility.trace(parameter_record(i).p_parameter_name||'(Old) = '
1103: ||lv_wage_value_in_cents);
1104: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1105:
1106: /* Negative Value check For Corrected Value to be reported on RCU */
1107: hr_utility.set_location( gv_package || '.format_w2c_total_record',160);
1108: lv_wage_value_in_cents :=
1103: ||lv_wage_value_in_cents);
1104: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1105:
1106: /* Negative Value check For Corrected Value to be reported on RCU */
1107: hr_utility.set_location( gv_package || '.format_w2c_total_record',160);
1108: lv_wage_value_in_cents :=
1109: to_char(nvl(pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new,0));
1110: pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated :=
1111: pay_us_reporting_utils_pkg.data_validation(
1125: sp_out_2);
1126: IF p_exclude_from_output = 'Y' THEN
1127: lb_exclude_from_output_chk := TRUE;
1128: END IF;
1129: hr_utility.set_location( gv_package || '.format_w2c_total_record',170);
1130: hr_utility.trace(parameter_record(i).p_parameter_name||'(New) = '
1131: ||lv_wage_value_in_cents);
1132: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1133: /* Set output parameters when RCT Originally reported value and Corrected values
1126: IF p_exclude_from_output = 'Y' THEN
1127: lb_exclude_from_output_chk := TRUE;
1128: END IF;
1129: hr_utility.set_location( gv_package || '.format_w2c_total_record',170);
1130: hr_utility.trace(parameter_record(i).p_parameter_name||'(New) = '
1131: ||lv_wage_value_in_cents);
1132: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1133: /* Set output parameters when RCT Originally reported value and Corrected values
1134: are not identical */
1128: END IF;
1129: hr_utility.set_location( gv_package || '.format_w2c_total_record',170);
1130: hr_utility.trace(parameter_record(i).p_parameter_name||'(New) = '
1131: ||lv_wage_value_in_cents);
1132: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1133: /* Set output parameters when RCT Originally reported value and Corrected values
1134: are not identical */
1135: --{
1136: if i = 1 then
1157: elsif i = 8 then
1158: p_output_8 := nvl(pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old,0);
1159: p_output_28 := nvl(pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new,0);
1160: end if;
1161: hr_utility.trace('p_output_8 '||p_output_8);
1162: hr_utility.trace('p_output_28 '||p_output_28);
1163:
1164: hr_utility.set_location( gv_package || '.format_w2c_total_record',180);
1165: --}
1158: p_output_8 := nvl(pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old,0);
1159: p_output_28 := nvl(pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new,0);
1160: end if;
1161: hr_utility.trace('p_output_8 '||p_output_8);
1162: hr_utility.trace('p_output_28 '||p_output_28);
1163:
1164: hr_utility.set_location( gv_package || '.format_w2c_total_record',180);
1165: --}
1166: --}
1160: end if;
1161: hr_utility.trace('p_output_8 '||p_output_8);
1162: hr_utility.trace('p_output_28 '||p_output_28);
1163:
1164: hr_utility.set_location( gv_package || '.format_w2c_total_record',180);
1165: --}
1166: --}
1167: else
1168: --{
1165: --}
1166: --}
1167: else
1168: --{
1169: hr_utility.set_location( gv_package || '.format_w2c_total_record',190);
1170: pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_identical_flag := 'Y';
1171: pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old_formated :=
1172: lpad(' ',15);
1173: pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated :=
1199: end if;
1200: --}
1201: end if;
1202: END LOOP;
1203: hr_utility.set_location( gv_package || '.format_w2c_total_record',200);
1204: p_output_41 := lpad(NVL(pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu,0),7,'0');
1205: p_output_42 := lpad(NVL(pay_us_w2c_in_mmref2_format.number_of_error_rco_rcu,0),7,'0');
1206: return_value :=
1207: pay_us_mmrf2_w2c_format_record.format_W2C_RCU_record(
1219: p_exclude_from_output,
1220: ret_str_len,
1221: lb_exclude_from_output_chk
1222: );
1223: hr_utility.set_location( gv_package || '.format_w2c_total_record',210);
1224: --}
1225: END IF; --p_record_name
1226: --}
1227: END IF; --p_report_type
1243: p_exclude_from_output := 'Y';
1244: ELSE
1245: p_exclude_from_output := 'N';
1246: END IF;
1247: hr_utility.trace('main_return_string = '||main_return_string);
1248: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
1249: hr_utility.trace('sp_out_1 = '||sp_out_1);
1250: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
1251: hr_utility.trace('sp_out_2 = '||sp_out_2);
1244: ELSE
1245: p_exclude_from_output := 'N';
1246: END IF;
1247: hr_utility.trace('main_return_string = '||main_return_string);
1248: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
1249: hr_utility.trace('sp_out_1 = '||sp_out_1);
1250: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
1251: hr_utility.trace('sp_out_2 = '||sp_out_2);
1252: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
1245: p_exclude_from_output := 'N';
1246: END IF;
1247: hr_utility.trace('main_return_string = '||main_return_string);
1248: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
1249: hr_utility.trace('sp_out_1 = '||sp_out_1);
1250: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
1251: hr_utility.trace('sp_out_2 = '||sp_out_2);
1252: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
1253: hr_utility.trace('sp_out_3 = '||sp_out_3);
1246: END IF;
1247: hr_utility.trace('main_return_string = '||main_return_string);
1248: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
1249: hr_utility.trace('sp_out_1 = '||sp_out_1);
1250: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
1251: hr_utility.trace('sp_out_2 = '||sp_out_2);
1252: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
1253: hr_utility.trace('sp_out_3 = '||sp_out_3);
1254: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
1247: hr_utility.trace('main_return_string = '||main_return_string);
1248: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
1249: hr_utility.trace('sp_out_1 = '||sp_out_1);
1250: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
1251: hr_utility.trace('sp_out_2 = '||sp_out_2);
1252: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
1253: hr_utility.trace('sp_out_3 = '||sp_out_3);
1254: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
1255: hr_utility.trace('sp_out_4 = '||sp_out_4);
1248: hr_utility.trace(' length of main_return_string = '||to_char(length(main_return_string)));
1249: hr_utility.trace('sp_out_1 = '||sp_out_1);
1250: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
1251: hr_utility.trace('sp_out_2 = '||sp_out_2);
1252: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
1253: hr_utility.trace('sp_out_3 = '||sp_out_3);
1254: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
1255: hr_utility.trace('sp_out_4 = '||sp_out_4);
1256: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
1249: hr_utility.trace('sp_out_1 = '||sp_out_1);
1250: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
1251: hr_utility.trace('sp_out_2 = '||sp_out_2);
1252: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
1253: hr_utility.trace('sp_out_3 = '||sp_out_3);
1254: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
1255: hr_utility.trace('sp_out_4 = '||sp_out_4);
1256: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
1257: hr_utility.trace('sp_out_5 = '||sp_out_5);
1250: hr_utility.trace(' length of sp_out_1 = '||to_char(length(sp_out_1)));
1251: hr_utility.trace('sp_out_2 = '||sp_out_2);
1252: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
1253: hr_utility.trace('sp_out_3 = '||sp_out_3);
1254: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
1255: hr_utility.trace('sp_out_4 = '||sp_out_4);
1256: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
1257: hr_utility.trace('sp_out_5 = '||sp_out_5);
1258: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
1251: hr_utility.trace('sp_out_2 = '||sp_out_2);
1252: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
1253: hr_utility.trace('sp_out_3 = '||sp_out_3);
1254: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
1255: hr_utility.trace('sp_out_4 = '||sp_out_4);
1256: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
1257: hr_utility.trace('sp_out_5 = '||sp_out_5);
1258: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
1259: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1252: hr_utility.trace(' length of sp_out_2 = '||to_char(length(sp_out_2)));
1253: hr_utility.trace('sp_out_3 = '||sp_out_3);
1254: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
1255: hr_utility.trace('sp_out_4 = '||sp_out_4);
1256: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
1257: hr_utility.trace('sp_out_5 = '||sp_out_5);
1258: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
1259: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1260: hr_utility.set_location( gv_package || '.format_w2c_total_record',220);
1253: hr_utility.trace('sp_out_3 = '||sp_out_3);
1254: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
1255: hr_utility.trace('sp_out_4 = '||sp_out_4);
1256: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
1257: hr_utility.trace('sp_out_5 = '||sp_out_5);
1258: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
1259: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1260: hr_utility.set_location( gv_package || '.format_w2c_total_record',220);
1261:
1254: hr_utility.trace(' length of sp_out_3 = '||to_char(length(sp_out_3)));
1255: hr_utility.trace('sp_out_4 = '||sp_out_4);
1256: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
1257: hr_utility.trace('sp_out_5 = '||sp_out_5);
1258: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
1259: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1260: hr_utility.set_location( gv_package || '.format_w2c_total_record',220);
1261:
1262: RETURN main_return_string;
1255: hr_utility.trace('sp_out_4 = '||sp_out_4);
1256: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
1257: hr_utility.trace('sp_out_5 = '||sp_out_5);
1258: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
1259: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1260: hr_utility.set_location( gv_package || '.format_w2c_total_record',220);
1261:
1262: RETURN main_return_string;
1263: END Format_W2C_total_Record;
1256: hr_utility.trace(' length of sp_out_4 = '||to_char(length(sp_out_4)));
1257: hr_utility.trace('sp_out_5 = '||sp_out_5);
1258: hr_utility.trace(' length of sp_out_5 = '||to_char(length(sp_out_5)));
1259: hr_utility.trace('p_exclude_from_output = '||p_exclude_from_output);
1260: hr_utility.set_location( gv_package || '.format_w2c_total_record',220);
1261:
1262: RETURN main_return_string;
1263: END Format_W2C_total_Record;
1264: /* NEW*/
1272: IS
1273: ln_no_of_rcw_wages number := 25; /* saurabh */
1274: ln_no_of_rco_wages number := 8;
1275: BEGIN
1276: hr_utility.set_location( gv_package || '.Initialize_GRE_Level_total',10);
1277: hr_utility.trace('Entered in pay_us_w2c_in_mmref2_format.Initialize_GRE_Level_total');
1278: hr_utility.trace('Initializing GRE Level Totals');
1279: if pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rct > 0 then
1280: pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf :=
1273: ln_no_of_rcw_wages number := 25; /* saurabh */
1274: ln_no_of_rco_wages number := 8;
1275: BEGIN
1276: hr_utility.set_location( gv_package || '.Initialize_GRE_Level_total',10);
1277: hr_utility.trace('Entered in pay_us_w2c_in_mmref2_format.Initialize_GRE_Level_total');
1278: hr_utility.trace('Initializing GRE Level Totals');
1279: if pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rct > 0 then
1280: pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf :=
1281: pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf +
1274: ln_no_of_rco_wages number := 8;
1275: BEGIN
1276: hr_utility.set_location( gv_package || '.Initialize_GRE_Level_total',10);
1277: hr_utility.trace('Entered in pay_us_w2c_in_mmref2_format.Initialize_GRE_Level_total');
1278: hr_utility.trace('Initializing GRE Level Totals');
1279: if pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rct > 0 then
1280: pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf :=
1281: pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rcf +
1282: pay_us_w2c_in_mmref2_format.number_of_valid_rcw_rct ;
1319: pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_old_formated := ' ';
1320: pay_us_w2c_in_mmref2_format.ltr_rct_info(i).rct_wage_new_formated := ' ';
1321: END LOOP;
1322: -- Initialize all the PL/SQL table defined for RCU Wages
1323: hr_utility.set_location( gv_package || '.Initialize_GRE_Level_total',20);
1324: pay_us_w2c_in_mmref2_format.ltr_rcu_info.delete;
1325: ln_no_of_rco_wages := 8;
1326:
1327: FOR i IN 1..ln_no_of_rco_wages
1330: pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new := 0; --200000;
1331: pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old_formated := ' ';
1332: pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated := ' ';
1333: END LOOP;
1334: hr_utility.set_location( gv_package || '.Initialize_GRE_Level_total',30);
1335: hr_utility.trace('Leaving pay_us_w2c_in_mmref2_format.Initialize_GRE_Level_total');
1336: return(0);
1337: EXCEPTION
1338: when others then
1331: pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_old_formated := ' ';
1332: pay_us_w2c_in_mmref2_format.ltr_rcu_info(i).rcu_wage_new_formated := ' ';
1333: END LOOP;
1334: hr_utility.set_location( gv_package || '.Initialize_GRE_Level_total',30);
1335: hr_utility.trace('Leaving pay_us_w2c_in_mmref2_format.Initialize_GRE_Level_total');
1336: return(0);
1337: EXCEPTION
1338: when others then
1339: return(1);
1370: BEGIN
1371: --
1372: -- In PL/SQL table 1st record would be Originally reported arhived value for an Assignment_Action_Id
1373: -- and 2nd record would be Corrected values
1374: hr_utility.set_location( gv_package || '.GET_ARCHIVED_VALUES',10);
1375: if p_action_type = 'O'
1376: then
1377: i := 1;
1378: elsif p_action_type = 'C' then
1380: end if;
1381:
1382: if p_record_type = 'RCW' then
1383: --{
1384: hr_utility.set_location( gv_package || '.GET_ARCHIVED_VALUES',20);
1385: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).SSN := '';
1386: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).first_name := '';
1387: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).middle_name := '';
1388: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).last_name := '';
1415:
1416: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).statutory_emp_indicator := '';
1417: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).retirement_plan_indicator := '';
1418: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).sick_pay_indicator := '';
1419: hr_utility.set_location( gv_package || '.GET_ARCHIVED_VALUES',30);
1420: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).SSN :=
1421: hr_us_w2_rep.get_per_item(p_assignment_action_id,'A_PER_NATIONAL_IDENTIFIER') ;
1422: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).first_name :=
1423: hr_us_w2_rep.get_per_item(p_assignment_action_id,'A_PER_FIRST_NAME') ;
1459: ,'00-000-0000'
1460: ,0);
1461: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).action_information1 := ln_gross_wages;
1462:
1463: hr_utility.set_location( gv_package || '.GET_ARCHIVED_VALUES',40);
1464: -- FIT withheld
1465: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).action_information2 :=
1466: hr_us_w2_rep.get_w2_arch_bal(p_assignment_action_id
1467: ,'A_FIT_WITHHELD_PER_GRE_YTD'
1574: ,'00-000-0000'
1575: ,0);
1576: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).action_information14 :=
1577: ln_501c_contribution;
1578: hr_utility.set_location( gv_package || '.GET_ARCHIVED_VALUES',50);
1579: -- Deferred compensation contributions
1580: -- This need to be clarified
1581: ln_total_contribution := ln_401k_contribution +
1582: ln_403b_contribution +
1633: ,p_tax_unit_id
1634: ,'00-000-0000'
1635: ,0);
1636: -- Non Combat Pay , for bug 4398606
1637: hr_utility.trace(' Getting Non combat pay ' );
1638: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).action_information22 :=
1639: hr_us_w2_rep.get_w2_arch_bal(p_assignment_action_id
1640: ,'A_W2_NONTAX_COMBAT_PER_GRE_YTD'
1641: ,p_tax_unit_id
1640: ,'A_W2_NONTAX_COMBAT_PER_GRE_YTD'
1641: ,p_tax_unit_id
1642: ,'00-000-0000'
1643: ,0);
1644: hr_utility.trace('Nontax Combat ' || pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).action_information22);
1645:
1646:
1647: -- 409A Deferrals , for bug 4398606
1648: hr_utility.trace(' Getting NonQual Def Comp ' );
1644: hr_utility.trace('Nontax Combat ' || pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).action_information22);
1645:
1646:
1647: -- 409A Deferrals , for bug 4398606
1648: hr_utility.trace(' Getting NonQual Def Comp ' );
1649: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).action_information23 :=
1650: hr_us_w2_rep.get_w2_arch_bal(p_assignment_action_id
1651: ,'A_W2_NONQUAL_DEF_COMP_PER_GRE_YTD'
1652: ,p_tax_unit_id
1651: ,'A_W2_NONQUAL_DEF_COMP_PER_GRE_YTD'
1652: ,p_tax_unit_id
1653: ,'00-000-0000'
1654: ,0);
1655: hr_utility.trace('NonQual Def Comp ' || pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).action_information23);
1656:
1657:
1658: hr_utility.set_location( gv_package || '.GET_ARCHIVED_VALUES',60);
1659: -- Statutory Employee Indicator
1654: ,0);
1655: hr_utility.trace('NonQual Def Comp ' || pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).action_information23);
1656:
1657:
1658: hr_utility.set_location( gv_package || '.GET_ARCHIVED_VALUES',60);
1659: -- Statutory Employee Indicator
1660: lv_statutory_employee :=
1661: hr_us_w2_rep.get_per_item(p_assignment_action_id,'A_W2_ASG_STATUTORY_EMPLOYEE');
1662: if lv_statutory_employee = 'Y' then
1663: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).statutory_emp_indicator := '1';
1664: else
1665: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).statutory_emp_indicator := '0';
1666: end if;
1667: hr_utility.set_location( gv_package || '.GET_ARCHIVED_VALUES',70);
1668: --
1669: -- Retirement Plan Indicator
1670: -- If any of the contribution is > 0 then retirement plan indicator is set to 1
1671: -- otherwise 0
1700: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).sick_pay_indicator := '1';
1701: else
1702: pay_us_w2c_in_mmref2_format.ltr_rcw_info(i).sick_pay_indicator := '0';
1703: end if;
1704: hr_utility.set_location(gv_package || '.GET_ARCHIVED_VALUES',80);
1705: --}
1706: ELSIF p_record_type = 'RCO' then
1707: --{
1708: hr_utility.set_location(gv_package || '.GET_ARCHIVED_VALUES',100);
1704: hr_utility.set_location(gv_package || '.GET_ARCHIVED_VALUES',80);
1705: --}
1706: ELSIF p_record_type = 'RCO' then
1707: --{
1708: hr_utility.set_location(gv_package || '.GET_ARCHIVED_VALUES',100);
1709: pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information1 := 0; -- allocated tips
1710: pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information2 := 0; -- uncollected employee tax on tips
1711: pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information3 := 0; -- Medical Savings Account
1712: pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information4 := 0; -- Simple Retirement Account
1713: pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information5 := 0; -- Qualified adoption expenses
1714: pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information6 := 0; -- uncollected social security or RRTA tax on GTL insurance over $50000
1715: pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information7 := 0; -- uncollected medicare tax on GTL insurance over $50,000
1716: pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information8 := 0; -- uncollected medicare tax on GTL insurance over $50,000
1717: hr_utility.set_location(gv_package || '.GET_ARCHIVED_VALUES',105);
1718:
1719: -- allocated tips
1720: pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information1 :=
1721: hr_us_w2_rep.get_w2_arch_bal(p_assignment_action_id
1722: ,'A_W2_BOX_8_PER_GRE_YTD'
1723: ,p_tax_unit_id
1724: ,'00-000-0000'
1725: ,0);
1726: hr_utility.set_location(gv_package || '.GET_ARCHIVED_VALUES',110);
1727: -- uncollected employee tax on tips
1728: pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information2 :=
1729: hr_us_w2_rep.get_w2_arch_bal(p_assignment_action_id
1730: ,'A_W2_UNCOLL_SS_TAX_TIPS_PER_GRE_YTD'
1735: ,'A_W2_UNCOLL_MED_TIPS_PER_GRE_YTD'
1736: ,p_tax_unit_id
1737: ,'00-000-0000'
1738: ,0);
1739: hr_utility.set_location(gv_package || '.GET_ARCHIVED_VALUES',120);
1740: -- Medical Savings Account
1741: pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information3 :=
1742: hr_us_w2_rep.get_w2_arch_bal(p_assignment_action_id
1743: ,'A_W2_MSA_PER_GRE_YTD'
1743: ,'A_W2_MSA_PER_GRE_YTD'
1744: ,p_tax_unit_id
1745: ,'00-000-0000'
1746: ,0);
1747: hr_utility.set_location(gv_package || '.GET_ARCHIVED_VALUES',130);
1748: -- Simple Retirement Account
1749: pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information4 :=
1750: hr_us_w2_rep.get_w2_arch_bal(p_assignment_action_id
1751: ,'A_W2_408P_PER_GRE_YTD'
1751: ,'A_W2_408P_PER_GRE_YTD'
1752: ,p_tax_unit_id
1753: ,'00-000-0000'
1754: ,0);
1755: hr_utility.set_location(gv_package || '.GET_ARCHIVED_VALUES',140);
1756: -- Qualified adoption expenses
1757: pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information5 :=
1758: hr_us_w2_rep.get_w2_arch_bal(p_assignment_action_id
1759: ,'A_W2_ADOPTION_PER_GRE_YTD'
1759: ,'A_W2_ADOPTION_PER_GRE_YTD'
1760: ,p_tax_unit_id
1761: ,'00-000-0000'
1762: ,0);
1763: hr_utility.set_location(gv_package || '.GET_ARCHIVED_VALUES',150);
1764: -- uncollected social security or RRTA tax on GTL insurance over $50000
1765: pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information6 :=
1766: hr_us_w2_rep.get_w2_arch_bal(p_assignment_action_id
1767: ,'A_W2_UNCOLL_SS_GTL_PER_GRE_YTD'
1767: ,'A_W2_UNCOLL_SS_GTL_PER_GRE_YTD'
1768: ,p_tax_unit_id
1769: ,'00-000-0000'
1770: ,0);
1771: hr_utility.set_location(gv_package || '.GET_ARCHIVED_VALUES',160);
1772: -- uncollected medicare tax on GTL insurance over $50,000
1773: pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information7 :=
1774: hr_us_w2_rep.get_w2_arch_bal(p_assignment_action_id
1775: ,'A_W2_UNCOLL_MED_GTL_PER_GRE_YTD'
1782: ,'A_W2_409A_NONQUAL_INCOME_PER_GRE_YTD'
1783: ,p_tax_unit_id
1784: ,'00-000-0000'
1785: ,0);
1786: hr_utility.trace('getting 409A Income for RCO record ' ||pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information8);
1787:
1788: hr_utility.set_location(gv_package || '.GET_ARCHIVED_VALUES',170);
1789: -- End of fetching Archived values RCO
1790: --}
1784: ,'00-000-0000'
1785: ,0);
1786: hr_utility.trace('getting 409A Income for RCO record ' ||pay_us_w2c_in_mmref2_format.ltr_rco_info(i).action_information8);
1787:
1788: hr_utility.set_location(gv_package || '.GET_ARCHIVED_VALUES',170);
1789: -- End of fetching Archived values RCO
1790: --}
1791: END IF; -- p_record_type check
1792: --
1791: END IF; -- p_record_type check
1792: --
1793: EXCEPTION
1794: WHEN OTHERS then
1795: hr_utility.set_location(gv_package || '.GET_ARCHIVED_VALUES',180);
1796: END GET_ARCHIVED_VALUES;
1797: -- End of Get_Archived_Values function
1798: --
1799:
1876: l_rcw_neg_flag boolean := FALSE;
1877: l_rco_neg_flag boolean := FALSE;
1878:
1879: BEGIN
1880: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 10);
1881: ln_num_corrections_rcw := 0;
1882: ln_num_corrections_rco := 0;
1883: -- Employee Level Global Variables are initialized here
1884:
1899: -- would be stored in 1st row of the Pl/SQL table
1900: lv_action_type := 'O';
1901: lv_record_type := 'RCW';
1902: pay_us_w2c_in_mmref2_format.ltr_rcw_info.delete;
1903: hr_utility.trace('Calling Procedure pay_us_w2c_in_mmref2_format.GET_ARCHIVED_VALUES to set RCW record ');
1904: pay_us_w2c_in_mmref2_format.GET_ARCHIVED_VALUES ( lv_action_type
1905: ,lv_record_type
1906: ,p_orig_assignment_actid
1907: ,p_tax_unit_id
1905: ,lv_record_type
1906: ,p_orig_assignment_actid
1907: ,p_tax_unit_id
1908: );
1909: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 20);
1910: --
1911: -- Set Corrected RCW values in PL/SQL table pay_us_w2c_in_mmref2_format.ltr_rcw_info
1912: -- Corrected value would be stored in 2nd row of the Pl/SQL table
1913: --
1916: ,p_record_name
1917: ,p_correct_assignment_actid
1918: ,p_tax_unit_id
1919: );
1920: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 30);
1921: --
1922: -- Compare Orginally Reported and Corrected values to decide whether RCW record
1923: -- would be written to mf file or moved to .a02.
1924: --
1937: else
1938: lv_ssn_identical_flag := 'Y';
1939: lv_old_ssn := lpad(' ',9);
1940: end if;
1941: hr_utility.trace('SSN Comparision completed ');
1942: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 40);
1943: --
1944: -- Compare Orignally Reported and Corrected
1945: --
1938: lv_ssn_identical_flag := 'Y';
1939: lv_old_ssn := lpad(' ',9);
1940: end if;
1941: hr_utility.trace('SSN Comparision completed ');
1942: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 40);
1943: --
1944: -- Compare Orignally Reported and Corrected
1945: --
1946: lv_first_name_old := ' ';
1957: pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).first_name) then
1958: ln_num_corrections := ln_num_corrections + 1;
1959: lv_first_name_old := pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).first_name;
1960: end if;
1961: hr_utility.trace('First Name Comparision completed ');
1962: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 50);
1963: --
1964: -- Compare Orignally Reported and Corrected
1965: --
1958: ln_num_corrections := ln_num_corrections + 1;
1959: lv_first_name_old := pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).first_name;
1960: end if;
1961: hr_utility.trace('First Name Comparision completed ');
1962: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 50);
1963: --
1964: -- Compare Orignally Reported and Corrected
1965: --
1966: lv_middle_name_old := ' ';
1980: pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).middle_name) then
1981: ln_num_corrections := ln_num_corrections + 1;
1982: lv_middle_name_old := pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).middle_name;
1983: end if;
1984: hr_utility.trace('Middle Name Comparision completed ');
1985: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 60);
1986: --
1987: -- Compare Orignally Reported and Corrected
1988: --
1981: ln_num_corrections := ln_num_corrections + 1;
1982: lv_middle_name_old := pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).middle_name;
1983: end if;
1984: hr_utility.trace('Middle Name Comparision completed ');
1985: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 60);
1986: --
1987: -- Compare Orignally Reported and Corrected
1988: --
1989: lv_last_name_old := ' ';
1999: pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).last_name) then
2000: ln_num_corrections := ln_num_corrections + 1;
2001: lv_last_name_old := pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).last_name;
2002: end if;
2003: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 70);
2004: hr_utility.trace('Last Name Comparision completed ');
2005: --
2006: -- Compare Orignally Reported and Corrected
2007: --
2000: ln_num_corrections := ln_num_corrections + 1;
2001: lv_last_name_old := pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).last_name;
2002: end if;
2003: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 70);
2004: hr_utility.trace('Last Name Comparision completed ');
2005: --
2006: -- Compare Orignally Reported and Corrected
2007: --
2008: if (pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).statutory_emp_indicator = '0' and
2013: --}
2014: elsif (pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).statutory_emp_indicator <>
2015: pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).statutory_emp_indicator) then
2016: --{
2017: hr_utility.trace(' Statutory Employee Indicator Values are not equal ');
2018: ln_num_corrections := ln_num_corrections + 1;
2019: lv_statutory_emp_indicator_old :=
2020: pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).statutory_emp_indicator;
2021: lv_statutory_emp_indicator_new :=
2025: lv_statutory_emp_indicator_old := ' ';
2026: lv_statutory_emp_indicator_new := ' ';
2027: end if;
2028:
2029: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 80);
2030:
2031: -- Compare Orignally Reported and Corrected
2032: if (pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).retirement_plan_indicator ='0' and
2033: pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).retirement_plan_indicator ='0') then
2037: --}
2038: elsif (pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).retirement_plan_indicator <>
2039: pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).retirement_plan_indicator) then
2040: --{
2041: hr_utility.trace(' Retirement Plan Indicator Values are not equal ');
2042: ln_num_corrections := ln_num_corrections + 1;
2043: lv_retire_plan_indicator_old :=
2044: pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).retirement_plan_indicator;
2045: lv_retire_plan_indicator_new :=
2048: else
2049: lv_retire_plan_indicator_old := ' ';
2050: lv_retire_plan_indicator_new := ' ';
2051: end if;
2052: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 90);
2053:
2054: -- Compare Orignally Reported and Corrected < Third Part SickPay Indicator>
2055: if (pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).sick_pay_indicator = '0' and
2056: pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).sick_pay_indicator ='0' ) then
2060: --}
2061: elsif (pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).sick_pay_indicator <>
2062: pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).sick_pay_indicator) then
2063: --{
2064: hr_utility.trace(' Third Party Sick Pay Indicator Values are not equal ');
2065: ln_num_corrections := ln_num_corrections + 1;
2066: lv_sickpay_indicator_old :=
2067: pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).sick_pay_indicator;
2068: lv_sickpay_indicator_new :=
2071: else
2072: lv_sickpay_indicator_old := ' ';
2073: lv_sickpay_indicator_new := ' ';
2074: end if;
2075: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 100);
2076: --
2077: -- Following section is to compare all Wage values of RCW Record
2078: --
2079: parameter_record.delete;
2176:
2177: parameter_record(25).p_parameter_name:= 'Designed Roth Contr. to 403b Plan'; /* saurabh */
2178: parameter_record(25).p_parameter_value_old:=pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information25;
2179: parameter_record(25).p_parameter_value_new:=pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25;
2180: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 110);
2181:
2182: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 110);
2183:
2184: -- Delete all value from PL/SQL table used for storing RCW record wage values
2178: parameter_record(25).p_parameter_value_old:=pay_us_w2c_in_mmref2_format.ltr_rcw_info(1).action_information25;
2179: parameter_record(25).p_parameter_value_new:=pay_us_w2c_in_mmref2_format.ltr_rcw_info(2).action_information25;
2180: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 110);
2181:
2182: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 110);
2183:
2184: -- Delete all value from PL/SQL table used for storing RCW record wage values
2185: -- after comparision. This table normally stores 20 wage values
2186:
2222: elsif parameter_record(k).p_parameter_value_old <>
2223: parameter_record(k).p_parameter_value_new
2224: then
2225: --{
2226: hr_utility.trace(to_char(k)||'. '||parameter_record(k).p_parameter_name ||'Value are not equal ');
2227:
2228: ln_num_corrections := ln_num_corrections + 1;
2229:
2230: if NOT l_rcw_neg_flag then
2268: */
2269:
2270: end if;
2271: END LOOP;
2272: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 120);
2273: ln_num_corrections_rcw := ln_num_corrections;
2274:
2275: --
2276: -- Set Originally Reported RCO values
2282: lv_record_type := 'RCO';
2283:
2284: pay_us_w2c_in_mmref2_format.ltr_rco_info.delete;
2285:
2286: hr_utility.trace('Calling pay_us_w2c_in_mmref2_format.GET_ARCHIVED_VALUES'
2287: || 'to set Originally reported RCO record values');
2288:
2289: pay_us_w2c_in_mmref2_format.GET_ARCHIVED_VALUES ( lv_action_type
2290: ,lv_record_type
2290: ,lv_record_type
2291: ,p_orig_assignment_actid
2292: ,p_tax_unit_id
2293: );
2294: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 130);
2295: -- Set Corrected RCO values in PL/SQL table
2296: -- pay_us_w2c_in_mmref2_format.ltr_rco_info
2297: -- Corrected value would be stored in 2nd row of the Pl/SQL table
2298: --
2297: -- Corrected value would be stored in 2nd row of the Pl/SQL table
2298: --
2299:
2300: lv_action_type := 'C';
2301: hr_utility.trace('Calling pay_us_w2c_in_mmref2_format.GET_ARCHIVED_VALUES'
2302: || 'to set Corrected RCO record values');
2303:
2304: pay_us_w2c_in_mmref2_format.GET_ARCHIVED_VALUES ( lv_action_type
2305: ,lv_record_type
2305: ,lv_record_type
2306: ,p_correct_assignment_actid
2307: ,p_tax_unit_id
2308: );
2309: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 140);
2310:
2311: --
2312: -- Following section is to compare all Wage values of RCO Record
2313: --
2348: parameter_record(8).p_parameter_name:= 'income under 409A';
2349: parameter_record(8).p_parameter_value_old:=pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8;
2350: parameter_record(8).p_parameter_value_new:=pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8;
2351:
2352: hr_utility.trace('Old value of income under 409A '||parameter_record(8).p_parameter_value_old);
2353: hr_utility.trace('New value of income under 409A '||parameter_record(8).p_parameter_value_new);
2354:
2355:
2356: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 150);
2349: parameter_record(8).p_parameter_value_old:=pay_us_w2c_in_mmref2_format.ltr_rco_info(1).action_information8;
2350: parameter_record(8).p_parameter_value_new:=pay_us_w2c_in_mmref2_format.ltr_rco_info(2).action_information8;
2351:
2352: hr_utility.trace('Old value of income under 409A '||parameter_record(8).p_parameter_value_old);
2353: hr_utility.trace('New value of income under 409A '||parameter_record(8).p_parameter_value_new);
2354:
2355:
2356: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 150);
2357:
2352: hr_utility.trace('Old value of income under 409A '||parameter_record(8).p_parameter_value_old);
2353: hr_utility.trace('New value of income under 409A '||parameter_record(8).p_parameter_value_new);
2354:
2355:
2356: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record', 150);
2357:
2358: -- Delete all value from PL/SQL table used for storing RCO record wage values
2359: -- after comparision. This table normally stores 7 wage values
2360:
2376:
2377: --
2378: -- This loop will be used to compare all the wage data associated with RCO
2379: --
2380: hr_utility.trace('Comparing RCO Values of Originally reported and Corrected W2');
2381:
2382: FOR k in 1..8 LOOP
2383:
2384: if (parameter_record(k).p_parameter_value_old =
2393: elsif parameter_record(k).p_parameter_value_old <>
2394: parameter_record(k).p_parameter_value_new
2395: then
2396: --{
2397: hr_utility.trace(to_char(k)||'. '||parameter_record(k).p_parameter_name ||'Value are not equal ');
2398:
2399: ln_num_corrections := ln_num_corrections + 1;
2400:
2401: if NOT l_rco_neg_flag then
2440:
2441: end if;
2442: END LOOP;
2443:
2444: hr_utility.trace('Comparision for RCO values completed ');
2445: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',160);
2446:
2447: ln_num_corrections_rco := ln_num_corrections -ln_num_corrections_rcw;
2448:
2441: end if;
2442: END LOOP;
2443:
2444: hr_utility.trace('Comparision for RCO values completed ');
2445: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',160);
2446:
2447: ln_num_corrections_rco := ln_num_corrections -ln_num_corrections_rcw;
2448:
2449: pay_us_w2c_in_mmref2_format.rcw_number_of_correction := ln_num_corrections_rcw;
2449: pay_us_w2c_in_mmref2_format.rcw_number_of_correction := ln_num_corrections_rcw;
2450:
2451: pay_us_w2c_in_mmref2_format.rco_number_of_correction := ln_num_corrections_rco;
2452:
2453: hr_utility.trace('RCW No of Corrections '||to_char(ln_num_corrections_rcw));
2454: hr_utility.trace('RCO No of Corrections '||to_char(ln_num_corrections_rco));
2455: hr_utility.trace('Before RCW Format and Validation p_exclude_from_output '||p_exclude_from_output);
2456:
2457: pay_us_w2c_in_mmref2_format.rcw_number_of_correction := ln_num_corrections_rcw;
2450:
2451: pay_us_w2c_in_mmref2_format.rco_number_of_correction := ln_num_corrections_rco;
2452:
2453: hr_utility.trace('RCW No of Corrections '||to_char(ln_num_corrections_rcw));
2454: hr_utility.trace('RCO No of Corrections '||to_char(ln_num_corrections_rco));
2455: hr_utility.trace('Before RCW Format and Validation p_exclude_from_output '||p_exclude_from_output);
2456:
2457: pay_us_w2c_in_mmref2_format.rcw_number_of_correction := ln_num_corrections_rcw;
2458:
2451: pay_us_w2c_in_mmref2_format.rco_number_of_correction := ln_num_corrections_rco;
2452:
2453: hr_utility.trace('RCW No of Corrections '||to_char(ln_num_corrections_rcw));
2454: hr_utility.trace('RCO No of Corrections '||to_char(ln_num_corrections_rco));
2455: hr_utility.trace('Before RCW Format and Validation p_exclude_from_output '||p_exclude_from_output);
2456:
2457: pay_us_w2c_in_mmref2_format.rcw_number_of_correction := ln_num_corrections_rcw;
2458:
2459: pay_us_w2c_in_mmref2_format.rco_number_of_correction := ln_num_corrections_rco;
2504: p_exclude_from_output,
2505: ret_str_len,
2506: p_error
2507: );
2508: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',165);
2509:
2510: if p_error then
2511: hr_utility.trace('RCW Format and Validation resulted ERROR with p_exclude_from_output '||p_exclude_from_output);
2512: else
2507: );
2508: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',165);
2509:
2510: if p_error then
2511: hr_utility.trace('RCW Format and Validation resulted ERROR with p_exclude_from_output '||p_exclude_from_output);
2512: else
2513: hr_utility.trace('RCW Format and Validation resulted NO Error with p_exclude_from_output '||p_exclude_from_output);
2514: end if;
2515: hr_utility.trace('Before RCO Format and Validation p_exclude_from_output '||lv_rco_exclude_from_output);
2509:
2510: if p_error then
2511: hr_utility.trace('RCW Format and Validation resulted ERROR with p_exclude_from_output '||p_exclude_from_output);
2512: else
2513: hr_utility.trace('RCW Format and Validation resulted NO Error with p_exclude_from_output '||p_exclude_from_output);
2514: end if;
2515: hr_utility.trace('Before RCO Format and Validation p_exclude_from_output '||lv_rco_exclude_from_output);
2516:
2517: -- This section Validates and Formats RCO Record
2511: hr_utility.trace('RCW Format and Validation resulted ERROR with p_exclude_from_output '||p_exclude_from_output);
2512: else
2513: hr_utility.trace('RCW Format and Validation resulted NO Error with p_exclude_from_output '||p_exclude_from_output);
2514: end if;
2515: hr_utility.trace('Before RCO Format and Validation p_exclude_from_output '||lv_rco_exclude_from_output);
2516:
2517: -- This section Validates and Formats RCO Record
2518: -- Call to format_W2C_RCO_record to set Originally reported formattted values for reporting
2519: if ln_num_corrections_rco > 0 then
2542: );
2543:
2544:
2545: if lb_rco_error then
2546: hr_utility.trace('RCO Format and Validation resulted ERROR with p_exclude_from_output '||lv_rco_exclude_from_output);
2547: else
2548: hr_utility.trace('RCO Format and Validation resulted NO Error with p_exclude_from_output '||lv_rco_exclude_from_output);
2549: end if;
2550: else
2544:
2545: if lb_rco_error then
2546: hr_utility.trace('RCO Format and Validation resulted ERROR with p_exclude_from_output '||lv_rco_exclude_from_output);
2547: else
2548: hr_utility.trace('RCO Format and Validation resulted NO Error with p_exclude_from_output '||lv_rco_exclude_from_output);
2549: end if;
2550: else
2551: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',168);
2552: -- Format Blank RCO record in MMREF-2 format
2547: else
2548: hr_utility.trace('RCO Format and Validation resulted NO Error with p_exclude_from_output '||lv_rco_exclude_from_output);
2549: end if;
2550: else
2551: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',168);
2552: -- Format Blank RCO record in MMREF-2 format
2553: -- This Blank record would be used when RCO record is moved to .a02 for error
2554: --{
2555:
2552: -- Format Blank RCO record in MMREF-2 format
2553: -- This Blank record would be used when RCO record is moved to .a02 for error
2554: --{
2555:
2556: hr_utility.trace('Formatting BLANK RCO Record ');
2557: return_value_blank := ','
2558: ||' '
2559: ||','||lpad(' ',9)
2560: ||','||' '
2578: lv_rco_exclude_from_output := 'Y';
2579: pay_us_w2c_in_mmref2_format.rco_exclude_flag := 'Y';
2580: end if;
2581:
2582: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',170);
2583: if NOT p_error then
2584: --{
2585: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',180);
2586: hr_utility.trace('RCW formating and Validation was successful');
2581:
2582: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',170);
2583: if NOT p_error then
2584: --{
2585: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',180);
2586: hr_utility.trace('RCW formating and Validation was successful');
2587: --
2588: -- This section increments the counter to be reported in RCT record for Valid
2589: -- or Error Record
2582: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',170);
2583: if NOT p_error then
2584: --{
2585: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',180);
2586: hr_utility.trace('RCW formating and Validation was successful');
2587: --
2588: -- This section increments the counter to be reported in RCT record for Valid
2589: -- or Error Record
2590: -- Valid condtion is atleast one value of RCW is corrected for given employee
2611: end if;
2612: --}
2613: else
2614: --{
2615: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',190);
2616: pay_us_w2c_in_mmref2_format.number_of_error_rcw_rct :=
2617: pay_us_w2c_in_mmref2_format.number_of_error_rcw_rct + 1;
2618: pay_us_w2c_in_mmref2_format.rcw_exclude_flag := 'Y';
2619: -- RCF Error Record Total
2623: end if;
2624:
2625: if NOT lb_rco_error and NOT l_rcw_neg_flag then
2626: --{
2627: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',200);
2628: hr_utility.trace('RCO formating and Validation was successful');
2629: --
2630: -- This section increments the counter to be reported in RCU record for Valid
2631: -- or Error Record
2624:
2625: if NOT lb_rco_error and NOT l_rcw_neg_flag then
2626: --{
2627: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',200);
2628: hr_utility.trace('RCO formating and Validation was successful');
2629: --
2630: -- This section increments the counter to be reported in RCU record for Valid
2631: -- or Error Record
2632: -- Valid condtion is atleast one value of RCO is corrected for given employee
2632: -- Valid condtion is atleast one value of RCO is corrected for given employee
2633: -- Error condition is not even a single value is corrected for the employee
2634: --
2635: if ln_num_corrections_rco > 0 then
2636: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',205);
2637: pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu :=
2638: pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu + 1;
2639: pay_us_w2c_in_mmref2_format.rco_exclude_flag := 'N';
2640: else
2637: pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu :=
2638: pay_us_w2c_in_mmref2_format.number_of_valid_rco_rcu + 1;
2639: pay_us_w2c_in_mmref2_format.rco_exclude_flag := 'N';
2640: else
2641: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',206);
2642: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcu :=
2643: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcu + 1;
2644: pay_us_w2c_in_mmref2_format.rco_exclude_flag := 'Y';
2645: end if;
2645: end if;
2646: --}
2647: else
2648: --{
2649: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',210);
2650: hr_utility.trace('RCO formating and Validation ERROR out');
2651: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcu :=
2652: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcu + 1;
2653: pay_us_w2c_in_mmref2_format.rco_exclude_flag := 'Y';
2646: --}
2647: else
2648: --{
2649: hr_utility.set_location(gv_package || '.pay_us_w2c_RCW_record',210);
2650: hr_utility.trace('RCO formating and Validation ERROR out');
2651: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcu :=
2652: pay_us_w2c_in_mmref2_format.number_of_error_rco_rcu + 1;
2653: pay_us_w2c_in_mmref2_format.rco_exclude_flag := 'Y';
2654: --}
2659: else
2660: pay_us_w2c_in_mmref2_format.rco_exclude_flag := 'N';
2661: end if;
2662: -- return Flat format RCW record
2663: hr_utility.trace('RCW Exlcude from output Flag '||pay_us_w2c_in_mmref2_format.rcw_exclude_flag);
2664: hr_utility.trace('RCO Exlcude from output Flag '||pay_us_w2c_in_mmref2_format.rco_exclude_flag);
2665: hr_utility.trace('Number of Values corrected '||to_char(ln_num_corrections));
2666: hr_utility.trace(gv_package || '.pay_us_w2c_RCW_record'||' successfully completed');
2667: return (rcw_return_value);
2660: pay_us_w2c_in_mmref2_format.rco_exclude_flag := 'N';
2661: end if;
2662: -- return Flat format RCW record
2663: hr_utility.trace('RCW Exlcude from output Flag '||pay_us_w2c_in_mmref2_format.rcw_exclude_flag);
2664: hr_utility.trace('RCO Exlcude from output Flag '||pay_us_w2c_in_mmref2_format.rco_exclude_flag);
2665: hr_utility.trace('Number of Values corrected '||to_char(ln_num_corrections));
2666: hr_utility.trace(gv_package || '.pay_us_w2c_RCW_record'||' successfully completed');
2667: return (rcw_return_value);
2668: Exception
2661: end if;
2662: -- return Flat format RCW record
2663: hr_utility.trace('RCW Exlcude from output Flag '||pay_us_w2c_in_mmref2_format.rcw_exclude_flag);
2664: hr_utility.trace('RCO Exlcude from output Flag '||pay_us_w2c_in_mmref2_format.rco_exclude_flag);
2665: hr_utility.trace('Number of Values corrected '||to_char(ln_num_corrections));
2666: hr_utility.trace(gv_package || '.pay_us_w2c_RCW_record'||' successfully completed');
2667: return (rcw_return_value);
2668: Exception
2669: WHEN OTHERS THEN
2662: -- return Flat format RCW record
2663: hr_utility.trace('RCW Exlcude from output Flag '||pay_us_w2c_in_mmref2_format.rcw_exclude_flag);
2664: hr_utility.trace('RCO Exlcude from output Flag '||pay_us_w2c_in_mmref2_format.rco_exclude_flag);
2665: hr_utility.trace('Number of Values corrected '||to_char(ln_num_corrections));
2666: hr_utility.trace(gv_package || '.pay_us_w2c_RCW_record'||' successfully completed');
2667: return (rcw_return_value);
2668: Exception
2669: WHEN OTHERS THEN
2670: hr_utility.trace('Error encountered in '||gv_package || '.pay_us_w2c_RCW_record');
2666: hr_utility.trace(gv_package || '.pay_us_w2c_RCW_record'||' successfully completed');
2667: return (rcw_return_value);
2668: Exception
2669: WHEN OTHERS THEN
2670: hr_utility.trace('Error encountered in '||gv_package || '.pay_us_w2c_RCW_record');
2671: hr_utility.trace('Error: '||sqlerrm);
2672: END pay_us_w2c_RCW_record;
2673:
2674: --
2667: return (rcw_return_value);
2668: Exception
2669: WHEN OTHERS THEN
2670: hr_utility.trace('Error encountered in '||gv_package || '.pay_us_w2c_RCW_record');
2671: hr_utility.trace('Error: '||sqlerrm);
2672: END pay_us_w2c_RCW_record;
2673:
2674: --
2675: -- End of Procedure to get the Archived values of RCW/RCO record
2674: --
2675: -- End of Procedure to get the Archived values of RCW/RCO record
2676: --
2677: --BEGIN
2678: --hr_utility.trace_on(null,'W2CGAV');
2679: END pay_us_w2c_in_mmref2_format;