[Home] [Help]
52: -- Create a batch line for US Emp Fed Tax Rule Information
53:
54: if P_SPREADSHEET_IDENTIFIER = 'PAYRIUSFED' then
55:
56: hr_utility.trace('p_dp_mode :'||p_dp_mode);
57:
58: -- check for valid datatrack update modes
59: Dt_Api.Find_DT_Upd_Modes
60: (p_effective_date => l_effective_date
70:
71: IF l_dt_update THEN
72:
73: l_datetrack_update_mode := 'UPDATE';
74: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
75:
76: ELSIF l_dt_upd_override OR
77: l_upd_chg_ins THEN
78: -- Cannnot update the record because future dated record found
76: ELSIF l_dt_upd_override OR
77: l_upd_chg_ins THEN
78: -- Cannnot update the record because future dated record found
79: -- NULL;
80: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
81: hr_utility.raise_error;
82: ELSE
83: l_datetrack_update_mode := 'CORRECTION';
84: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
77: l_upd_chg_ins THEN
78: -- Cannnot update the record because future dated record found
79: -- NULL;
80: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
81: hr_utility.raise_error;
82: ELSE
83: l_datetrack_update_mode := 'CORRECTION';
84: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
85: END IF;
80: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
81: hr_utility.raise_error;
82: ELSE
83: l_datetrack_update_mode := 'CORRECTION';
84: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
85: END IF;
86:
87:
88: ln_ovn := l_pay_us_fedtax_rule_rec.OBJECT_VERSION_NUMBER;
111: ,p_effective_start_date => ld_eff_start_date
112: ,p_effective_end_date => ld_eff_end_date
113: );
114:
115: hr_utility.trace('call to hrdpp_UPDATE_FED_TAX_RULE.insert_batch_lines done');
116:
117: end if; -- p_spreadsheet_identifier = 'PAYRIUSFED'
118:
119:
121: if P_SPREADSHEET_IDENTIFIER = 'PAYRIUSSTATE' then
122:
123: if p_dp_mode = 'UPDATE' then
124:
125: hr_utility.trace('p_dp_mode :'||p_dp_mode);
126:
127: -- check for valid datatrack update modes
128: Dt_Api.Find_DT_Upd_Modes
129: (p_effective_date => l_effective_date
139:
140: IF l_dt_update THEN
141:
142: l_datetrack_update_mode := 'UPDATE';
143: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
144:
145: ELSIF l_dt_upd_override OR
146: l_upd_chg_ins THEN
147: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
143: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
144:
145: ELSIF l_dt_upd_override OR
146: l_upd_chg_ins THEN
147: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
148: hr_utility.raise_error;
149: ELSE
150: l_datetrack_update_mode := 'CORRECTION';
151: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
144:
145: ELSIF l_dt_upd_override OR
146: l_upd_chg_ins THEN
147: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
148: hr_utility.raise_error;
149: ELSE
150: l_datetrack_update_mode := 'CORRECTION';
151: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
152: END IF;
147: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
148: hr_utility.raise_error;
149: ELSE
150: l_datetrack_update_mode := 'CORRECTION';
151: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
152: END IF;
153:
154:
155: ln_ovn := l_pay_us_statetax_rule_rec.OBJECT_VERSION_NUMBER;
153:
154:
155: ln_ovn := l_pay_us_statetax_rule_rec.OBJECT_VERSION_NUMBER;
156:
157: hr_utility.trace('Calling PAY_STATE_TAX_RULE_API.UPDATE_STATE_TAX_RULE');
158: PAY_STATE_TAX_RULE_API.UPDATE_STATE_TAX_RULE
159: (P_EFFECTIVE_DATE => l_effective_date
160: ,P_DATETRACK_UPDATE_MODE => l_datetrack_update_mode
161: ,P_EMP_STATE_TAX_RULE_ID => l_pay_us_statetax_rule_rec.EMP_STATE_TAX_RULE_ID
210: ,p_effective_start_date => ld_eff_start_date
211: ,p_effective_end_date => ld_eff_end_date
212: );
213:
214: hr_utility.trace('call to hrdpp_UPDATE_STATE_TAX_RULE.insert_batch_lines done');
215:
216: elsif p_dp_mode = 'INSERT' then
217:
218: hr_utility.trace('p_dp_mode :'||p_dp_mode);
214: hr_utility.trace('call to hrdpp_UPDATE_STATE_TAX_RULE.insert_batch_lines done');
215:
216: elsif p_dp_mode = 'INSERT' then
217:
218: hr_utility.trace('p_dp_mode :'||p_dp_mode);
219: hr_utility.trace('calling PAY_STATE_TAX_RULE_API.CREATE_STATE_TAX_RULE ');
220:
221: PAY_STATE_TAX_RULE_API.CREATE_STATE_TAX_RULE
222: (P_EFFECTIVE_DATE => p_effective_date
215:
216: elsif p_dp_mode = 'INSERT' then
217:
218: hr_utility.trace('p_dp_mode :'||p_dp_mode);
219: hr_utility.trace('calling PAY_STATE_TAX_RULE_API.CREATE_STATE_TAX_RULE ');
220:
221: PAY_STATE_TAX_RULE_API.CREATE_STATE_TAX_RULE
222: (P_EFFECTIVE_DATE => p_effective_date
223: ,P_ASSIGNMENT_ID => l_pay_us_statetax_rule_rec.ASSIGNMENT_ID
275: ,p_effective_start_date => ld_eff_start_date
276: ,p_effective_end_date => ld_eff_end_date
277: );
278:
279: hr_utility.trace('emp_state_tax_rule_id : '||to_char(ln_emp_state_tax_rule_id));
280: hr_utility.trace('call to PAY_STATE_TAX_RULE_API.CREATE_STATE_TAX_RULE done');
281: end if; -- end if for p_dp_mode validation for US State Tax
282:
283: end if; -- p_spreadsheet_identifier = 'PAYRIUSSTATE'
276: ,p_effective_end_date => ld_eff_end_date
277: );
278:
279: hr_utility.trace('emp_state_tax_rule_id : '||to_char(ln_emp_state_tax_rule_id));
280: hr_utility.trace('call to PAY_STATE_TAX_RULE_API.CREATE_STATE_TAX_RULE done');
281: end if; -- end if for p_dp_mode validation for US State Tax
282:
283: end if; -- p_spreadsheet_identifier = 'PAYRIUSSTATE'
284:
286: if P_SPREADSHEET_IDENTIFIER = 'PAYRIUSCOUNTY' then
287:
288: if p_dp_mode = 'UPDATE' then
289:
290: hr_utility.trace('p_dp_mode :'||p_dp_mode);
291:
292:
293: -- check for valid datatrack update modes
294: Dt_Api.Find_DT_Upd_Modes
305:
306: IF l_dt_update THEN
307:
308: l_datetrack_update_mode := 'UPDATE';
309: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
310:
311: ELSIF l_dt_upd_override OR
312: l_upd_chg_ins THEN
313: -- Need to check if future datetrack records exist
312: l_upd_chg_ins THEN
313: -- Need to check if future datetrack records exist
314: -- if yes then raise error
315: -- NULL;
316: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
317: hr_utility.raise_error;
318: ELSE
319: l_datetrack_update_mode := 'CORRECTION';
320: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
313: -- Need to check if future datetrack records exist
314: -- if yes then raise error
315: -- NULL;
316: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
317: hr_utility.raise_error;
318: ELSE
319: l_datetrack_update_mode := 'CORRECTION';
320: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
321: END IF;
316: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
317: hr_utility.raise_error;
318: ELSE
319: l_datetrack_update_mode := 'CORRECTION';
320: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
321: END IF;
322:
323: ln_ovn := l_pay_us_countytax_rule_rec.OBJECT_VERSION_NUMBER;
324:
339: ,p_object_version_number => ln_ovn
340: ,p_effective_date => l_effective_date
341: ,p_datetrack_mode => l_datetrack_update_mode
342: );
343: hr_utility.trace('call to pay_county_tax_rule_api.update_county_tax_rule done');
344:
345: elsif p_dp_mode = 'INSERT' then
346:
347: hr_utility.trace('p_dp_mode :'||p_dp_mode);
343: hr_utility.trace('call to pay_county_tax_rule_api.update_county_tax_rule done');
344:
345: elsif p_dp_mode = 'INSERT' then
346:
347: hr_utility.trace('p_dp_mode :'||p_dp_mode);
348:
349: pay_county_tax_rule_api.create_county_tax_rule
350: (p_emp_county_tax_rule_id => ln_emp_county_tax_rule_id
351: ,p_effective_start_date => ld_eff_start_date
367: ,p_effective_date => l_effective_date
368: );
369:
370:
371: hr_utility.trace('call to pay_county_tax_rule_api.create_county_tax_rule done');
372: end if; -- end if for p_dp_mode validation for US County Tax
373:
374: end if; -- P_SPREADSHEET_IDENTIFIER = 'PAYRIUSCOUNTY'
375:
377: if P_SPREADSHEET_IDENTIFIER = 'PAYRIUSCITY' then
378:
379: if p_dp_mode = 'UPDATE' then
380:
381: hr_utility.trace('p_dp_mode :'||p_dp_mode);
382:
383: -- check for valid datatrack update modes
384: Dt_Api.Find_DT_Upd_Modes
385: (p_effective_date => l_effective_date
394:
395: IF l_dt_update THEN
396:
397: l_datetrack_update_mode := 'UPDATE';
398: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
399:
400: ELSIF l_dt_upd_override OR
401: l_upd_chg_ins THEN
402: -- Need to check if future datetrack records exist
401: l_upd_chg_ins THEN
402: -- Need to check if future datetrack records exist
403: -- if yes then raise error
404: -- NULL;
405: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
406: hr_utility.raise_error;
407: ELSE
408: l_datetrack_update_mode := 'CORRECTION';
409: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
402: -- Need to check if future datetrack records exist
403: -- if yes then raise error
404: -- NULL;
405: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
406: hr_utility.raise_error;
407: ELSE
408: l_datetrack_update_mode := 'CORRECTION';
409: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
410: END IF;
405: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
406: hr_utility.raise_error;
407: ELSE
408: l_datetrack_update_mode := 'CORRECTION';
409: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
410: END IF;
411:
412:
413: ln_ovn := l_pay_us_citytax_rule_rec.OBJECT_VERSION_NUMBER;
430: ,p_effective_start_date => ld_eff_start_date
431: ,p_effective_end_date => ld_eff_end_date
432: );
433:
434: hr_utility.trace('call to pay_city_tax_rule_api.update_city_tax_rule done');
435:
436: elsif p_dp_mode = 'INSERT' then
437:
438: hr_utility.trace('p_dp_mode :'||p_dp_mode);
434: hr_utility.trace('call to pay_city_tax_rule_api.update_city_tax_rule done');
435:
436: elsif p_dp_mode = 'INSERT' then
437:
438: hr_utility.trace('p_dp_mode :'||p_dp_mode);
439:
440: pay_city_tax_rule_api.create_city_tax_rule
441: (P_ASSIGNMENT_ID => l_pay_us_citytax_rule_rec.ASSIGNMENT_ID
442: ,P_STATE_CODE => l_pay_us_citytax_rule_rec.state_code
458: ,p_effective_end_date => ld_eff_end_date
459: ,p_object_version_number => ln_ovn
460: );
461:
462: hr_utility.trace('call to pay_city_tax_rule_api.create_city_tax_rule done');
463: end if; -- end if for p_dp_mode validation for US County Tax
464:
465: end if; -- P_SPREADSHEET_IDENTIFIER = 'PAYRIUSCITY'
466:
467: if P_SPREADSHEET_IDENTIFIER = 'PAYRICAFED' then
468:
469: if p_dp_mode = 'UPDATE' then
470:
471: hr_utility.trace('p_dp_mode :'||p_dp_mode);
472:
473: -- check for valid datatrack update modes
474: Dt_Api.Find_DT_Upd_Modes
475: (p_effective_date => l_effective_date
484:
485: IF l_dt_update THEN
486:
487: l_datetrack_update_mode := 'UPDATE';
488: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
489:
490: ELSIF l_dt_upd_override OR
491: l_upd_chg_ins THEN
492: -- Need to check if future dated record exists
491: l_upd_chg_ins THEN
492: -- Need to check if future dated record exists
493: -- if yes then raise error
494: -- NULL;
495: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
496: hr_utility.raise_error;
497: ELSE
498: l_datetrack_update_mode := 'CORRECTION';
499: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
492: -- Need to check if future dated record exists
493: -- if yes then raise error
494: -- NULL;
495: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
496: hr_utility.raise_error;
497: ELSE
498: l_datetrack_update_mode := 'CORRECTION';
499: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
500: END IF;
495: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
496: hr_utility.raise_error;
497: ELSE
498: l_datetrack_update_mode := 'CORRECTION';
499: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
500: END IF;
501:
502: ln_ovn := l_pay_ca_fedtax_rule_rec.OBJECT_VERSION_NUMBER;
503:
556: ,p_effective_start_date => ld_eff_start_date
557: ,p_effective_end_date => ld_eff_end_date
558: ,p_object_version_number => ln_ovn);
559:
560: hr_utility.trace('call to pay_ca_emp_fedtax_inf_api.update_ca_emp_fedtax_inf done');
561:
562: elsif p_dp_mode = 'INSERT' then
563:
564: hr_utility.trace('p_dp_mode :'||p_dp_mode);
560: hr_utility.trace('call to pay_ca_emp_fedtax_inf_api.update_ca_emp_fedtax_inf done');
561:
562: elsif p_dp_mode = 'INSERT' then
563:
564: hr_utility.trace('p_dp_mode :'||p_dp_mode);
565:
566: pay_ca_emp_fedtax_inf_api.create_ca_emp_fedtax_inf
567: (P_ASSIGNMENT_ID => l_pay_ca_fedtax_rule_rec.ASSIGNMENT_ID
568: ,P_LEGISLATION_CODE => l_pay_ca_fedtax_rule_rec.LEGISLATION_CODE
618: ,p_effective_start_date => ld_eff_start_date
619: ,p_effective_end_date => ld_eff_end_date
620: ,p_object_version_number => ln_ovn);
621:
622: hr_utility.trace('call to pay_ca_emp_fedtax_inf_api.create_ca_emp_fedtax_inf done');
623: end if; -- end if for p_dp_mode validation for Canada Federal Tax
624:
625: end if; -- p_spreadsheet_identifier = 'PAYRICAFED'
626:
627: if P_SPREADSHEET_IDENTIFIER = 'PAYRICAPROVINCE' then
628:
629: if p_dp_mode = 'UPDATE' then
630:
631: hr_utility.trace('p_dp_mode :'||p_dp_mode);
632:
633: -- check for valid datatrack update modes
634: Dt_Api.Find_DT_Upd_Modes
635: (p_effective_date => l_effective_date
645:
646: IF l_dt_update THEN
647:
648: l_datetrack_update_mode := 'UPDATE';
649: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
650:
651: ELSIF l_dt_upd_override OR
652: l_upd_chg_ins THEN
653: -- Need to check if future dated record exists
652: l_upd_chg_ins THEN
653: -- Need to check if future dated record exists
654: -- if yes then raise error
655: -- NULL;
656: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
657: hr_utility.raise_error;
658: ELSE
659: l_datetrack_update_mode := 'CORRECTION';
660: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
653: -- Need to check if future dated record exists
654: -- if yes then raise error
655: -- NULL;
656: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
657: hr_utility.raise_error;
658: ELSE
659: l_datetrack_update_mode := 'CORRECTION';
660: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
661: END IF;
656: hr_utility.set_message(801, 'HR_7211_DT_UPD_ROWS_IN_FUTURE');
657: hr_utility.raise_error;
658: ELSE
659: l_datetrack_update_mode := 'CORRECTION';
660: hr_utility.trace('l_datetrack_update_mode :'||l_datetrack_update_mode);
661: END IF;
662:
663: ln_ovn := l_pay_ca_provtax_rule_rec.OBJECT_VERSION_NUMBER;
664:
724: ,p_effective_start_date => ld_eff_start_date
725: ,p_effective_end_date => ld_eff_end_date
726: ,p_object_version_number => ln_ovn);
727:
728: hr_utility.trace('call to PAY_CA_EMP_PRVTAX_INF_API.update_ca_emp_prvtax_inf done');
729:
730: elsif p_dp_mode = 'INSERT' then
731:
732: hr_utility.trace('p_dp_mode :'||p_dp_mode);
728: hr_utility.trace('call to PAY_CA_EMP_PRVTAX_INF_API.update_ca_emp_prvtax_inf done');
729:
730: elsif p_dp_mode = 'INSERT' then
731:
732: hr_utility.trace('p_dp_mode :'||p_dp_mode);
733:
734: hr_utility.trace('Calling PAY_CA_EMP_PRVTAX_INF_API.create_ca_emp_prvtax_inf API ');
735: PAY_CA_EMP_PRVTAX_INF_API.create_ca_emp_prvtax_inf(
736: p_emp_province_tax_inf_id => ln_ca_emp_prov_tax_inf_id
730: elsif p_dp_mode = 'INSERT' then
731:
732: hr_utility.trace('p_dp_mode :'||p_dp_mode);
733:
734: hr_utility.trace('Calling PAY_CA_EMP_PRVTAX_INF_API.create_ca_emp_prvtax_inf API ');
735: PAY_CA_EMP_PRVTAX_INF_API.create_ca_emp_prvtax_inf(
736: p_emp_province_tax_inf_id => ln_ca_emp_prov_tax_inf_id
737: ,P_LEGISLATION_CODE => l_pay_ca_provtax_rule_rec.LEGISLATION_CODE
738: ,p_business_group_id => l_pay_ca_provtax_rule_rec.business_group_id
795: ,p_effective_end_date => ld_eff_end_date
796: ,p_object_version_number => ln_ovn);
797:
798:
799: hr_utility.trace('call to PAY_CA_EMP_PRVTAX_INF_API.create_ca_emp_prvtax_inf done');
800: end if; -- end if for p_dp_mode validation for Canada Provincial Tax
801:
802:
803: end if; -- p_spreadsheet_identifier = 'PAYRICAPROVINCE'
1065: g_employee := p_employee;
1066: g_assignment := p_assignment;
1067:
1068:
1069: /*hr_utility.trace_on(null,'TESTTAX');*/
1070:
1071: hr_utility.trace('p_business_group :'||to_char(p_business_group));
1072: hr_utility.trace('p_effective_date :'||to_char(p_effective_date,'YYYY/MM/DD'));
1073: hr_utility.trace('p_employee :'||to_char(p_employee));
1067:
1068:
1069: /*hr_utility.trace_on(null,'TESTTAX');*/
1070:
1071: hr_utility.trace('p_business_group :'||to_char(p_business_group));
1072: hr_utility.trace('p_effective_date :'||to_char(p_effective_date,'YYYY/MM/DD'));
1073: hr_utility.trace('p_employee :'||to_char(p_employee));
1074: hr_utility.trace('p_assignment :'||to_char(p_assignment));
1075: hr_utility.trace('p_legislation :'||p_legislation);
1068:
1069: /*hr_utility.trace_on(null,'TESTTAX');*/
1070:
1071: hr_utility.trace('p_business_group :'||to_char(p_business_group));
1072: hr_utility.trace('p_effective_date :'||to_char(p_effective_date,'YYYY/MM/DD'));
1073: hr_utility.trace('p_employee :'||to_char(p_employee));
1074: hr_utility.trace('p_assignment :'||to_char(p_assignment));
1075: hr_utility.trace('p_legislation :'||p_legislation);
1076: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1069: /*hr_utility.trace_on(null,'TESTTAX');*/
1070:
1071: hr_utility.trace('p_business_group :'||to_char(p_business_group));
1072: hr_utility.trace('p_effective_date :'||to_char(p_effective_date,'YYYY/MM/DD'));
1073: hr_utility.trace('p_employee :'||to_char(p_employee));
1074: hr_utility.trace('p_assignment :'||to_char(p_assignment));
1075: hr_utility.trace('p_legislation :'||p_legislation);
1076: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1077: hr_utility.trace('p_sui_state :'||p_sui_state);
1070:
1071: hr_utility.trace('p_business_group :'||to_char(p_business_group));
1072: hr_utility.trace('p_effective_date :'||to_char(p_effective_date,'YYYY/MM/DD'));
1073: hr_utility.trace('p_employee :'||to_char(p_employee));
1074: hr_utility.trace('p_assignment :'||to_char(p_assignment));
1075: hr_utility.trace('p_legislation :'||p_legislation);
1076: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1077: hr_utility.trace('p_sui_state :'||p_sui_state);
1078: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1071: hr_utility.trace('p_business_group :'||to_char(p_business_group));
1072: hr_utility.trace('p_effective_date :'||to_char(p_effective_date,'YYYY/MM/DD'));
1073: hr_utility.trace('p_employee :'||to_char(p_employee));
1074: hr_utility.trace('p_assignment :'||to_char(p_assignment));
1075: hr_utility.trace('p_legislation :'||p_legislation);
1076: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1077: hr_utility.trace('p_sui_state :'||p_sui_state);
1078: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1079: hr_utility.trace('p_county :'||p_county);
1072: hr_utility.trace('p_effective_date :'||to_char(p_effective_date,'YYYY/MM/DD'));
1073: hr_utility.trace('p_employee :'||to_char(p_employee));
1074: hr_utility.trace('p_assignment :'||to_char(p_assignment));
1075: hr_utility.trace('p_legislation :'||p_legislation);
1076: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1077: hr_utility.trace('p_sui_state :'||p_sui_state);
1078: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1079: hr_utility.trace('p_county :'||p_county);
1080: hr_utility.trace('p_city :'||p_city);
1073: hr_utility.trace('p_employee :'||to_char(p_employee));
1074: hr_utility.trace('p_assignment :'||to_char(p_assignment));
1075: hr_utility.trace('p_legislation :'||p_legislation);
1076: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1077: hr_utility.trace('p_sui_state :'||p_sui_state);
1078: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1079: hr_utility.trace('p_county :'||p_county);
1080: hr_utility.trace('p_city :'||p_city);
1081: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1074: hr_utility.trace('p_assignment :'||to_char(p_assignment));
1075: hr_utility.trace('p_legislation :'||p_legislation);
1076: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1077: hr_utility.trace('p_sui_state :'||p_sui_state);
1078: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1079: hr_utility.trace('p_county :'||p_county);
1080: hr_utility.trace('p_city :'||p_city);
1081: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1082: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1075: hr_utility.trace('p_legislation :'||p_legislation);
1076: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1077: hr_utility.trace('p_sui_state :'||p_sui_state);
1078: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1079: hr_utility.trace('p_county :'||p_county);
1080: hr_utility.trace('p_city :'||p_city);
1081: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1082: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1083: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1076: hr_utility.trace('p_spreadsheet_identifier :'||p_spreadsheet_identifier);
1077: hr_utility.trace('p_sui_state :'||p_sui_state);
1078: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1079: hr_utility.trace('p_county :'||p_county);
1080: hr_utility.trace('p_city :'||p_city);
1081: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1082: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1083: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1084: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1077: hr_utility.trace('p_sui_state :'||p_sui_state);
1078: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1079: hr_utility.trace('p_county :'||p_county);
1080: hr_utility.trace('p_city :'||p_city);
1081: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1082: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1083: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1084: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1085: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1078: hr_utility.trace('p_state_prov_code :'||p_state_prov_code);
1079: hr_utility.trace('p_county :'||p_county);
1080: hr_utility.trace('p_city :'||p_city);
1081: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1082: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1083: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1084: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1085: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1086: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1079: hr_utility.trace('p_county :'||p_county);
1080: hr_utility.trace('p_city :'||p_city);
1081: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1082: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1083: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1084: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1085: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1086: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1087: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1080: hr_utility.trace('p_city :'||p_city);
1081: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1082: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1083: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1084: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1085: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1086: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1087: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1088: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1081: hr_utility.trace('p_override_prov_of_emplt :'||p_override_prov_of_emplt);
1082: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1083: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1084: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1085: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1086: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1087: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1088: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1089: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1082: hr_utility.trace('p_basic_amt_flag :'||p_basic_amt_flag);
1083: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1084: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1085: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1086: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1087: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1088: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1089: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1090: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1083: hr_utility.trace('p_basic_amt :'||to_char(p_basic_amt));
1084: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1085: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1086: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1087: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1088: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1089: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1090: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1091: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1084: hr_utility.trace('p_tax_credit :'||to_char(p_tax_credit));
1085: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1086: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1087: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1088: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1089: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1090: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1091: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1092: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1085: hr_utility.trace('p_filing_status_code :'||p_filing_status_code);
1086: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1087: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1088: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1089: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1090: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1091: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1092: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1093: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1086: hr_utility.trace('p_allowances :'||to_char(p_allowances));
1087: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1088: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1089: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1090: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1091: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1092: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1093: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1094: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1087: hr_utility.trace('p_additional_tax :'||to_char(p_additional_tax));
1088: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1089: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1090: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1091: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1092: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1093: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1094: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1095: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1088: hr_utility.trace('p_secondary_allowances :'||to_char(p_secondary_allowances));
1089: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1090: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1091: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1092: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1093: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1094: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1095: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1096: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1089: hr_utility.trace('p_exemption_amt :'||to_char(p_exemption_amt));
1090: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1091: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1092: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1093: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1094: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1095: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1096: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1097: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1090: hr_utility.trace('p_sit_optional_calc_ind :'||p_sit_optional_calc_ind);
1091: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1092: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1093: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1094: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1095: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1096: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1097: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1098: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1091: hr_utility.trace('p_addtl_allowance_rate :'||to_char(p_addtl_allowance_rate));
1092: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1093: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1094: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1095: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1096: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1097: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1098: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1099: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1092: hr_utility.trace('p_pres_zone_dedn :'||to_char(p_pres_zone_dedn));
1093: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1094: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1095: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1096: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1097: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1098: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1099: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1100: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1093: hr_utility.trace('p_tax_exempt1 :'||p_tax_exempt1);
1094: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1095: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1096: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1097: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1098: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1099: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1100: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1101: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1094: hr_utility.trace('p_tax_exempt2 :'||p_tax_exempt2);
1095: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1096: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1097: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1098: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1099: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1100: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1101: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1102: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1095: hr_utility.trace('p_tax_exempt3 :'||p_tax_exempt3);
1096: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1097: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1098: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1099: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1100: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1101: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1102: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1103: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1096: hr_utility.trace('p_tax_exempt4 :'||p_tax_exempt4);
1097: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1098: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1099: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1100: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1101: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1102: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1103: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1104: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1097: hr_utility.trace('p_override_rate :'||to_char(p_override_rate));
1098: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1099: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1100: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1101: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1102: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1103: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1104: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1105: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1098: hr_utility.trace('p_override_amount :'||to_char(p_override_amount));
1099: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1100: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1101: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1102: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1103: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1104: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1105: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1106: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1099: hr_utility.trace('p_override_supp_rate :'||to_char(p_override_supp_rate));
1100: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1101: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1102: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1103: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1104: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1105: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1106: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1107: hr_utility.trace('p_non_resident :'||p_non_resident);
1100: hr_utility.trace('p_annual_dedn :'||to_char(p_annual_dedn));
1101: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1102: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1103: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1104: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1105: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1106: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1107: hr_utility.trace('p_non_resident :'||p_non_resident);
1108: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1101: hr_utility.trace('p_labor_fund_contr :'||to_char(p_labor_fund_contr));
1102: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1103: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1104: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1105: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1106: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1107: hr_utility.trace('p_non_resident :'||p_non_resident);
1108: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1109: hr_utility.trace('p_school_district :'||p_school_district);
1102: hr_utility.trace('p_allowance_reject_date :'||to_char(p_allowance_reject_date,'YYYY/MM/DD'));
1103: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1104: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1105: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1106: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1107: hr_utility.trace('p_non_resident :'||p_non_resident);
1108: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1109: hr_utility.trace('p_school_district :'||p_school_district);
1110: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1103: hr_utility.trace('p_eic_filing_status :'||p_eic_filing_status);
1104: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1105: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1106: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1107: hr_utility.trace('p_non_resident :'||p_non_resident);
1108: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1109: hr_utility.trace('p_school_district :'||p_school_district);
1110: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1111: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1104: hr_utility.trace('p_statutory_employee :'||p_statutory_employee);
1105: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1106: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1107: hr_utility.trace('p_non_resident :'||p_non_resident);
1108: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1109: hr_utility.trace('p_school_district :'||p_school_district);
1110: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1111: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1112: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1105: hr_utility.trace('p_statutory_employee :'||to_char(p_annual_dedn));
1106: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1107: hr_utility.trace('p_non_resident :'||p_non_resident);
1108: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1109: hr_utility.trace('p_school_district :'||p_school_district);
1110: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1111: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1112: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1113: hr_utility.trace('p_disability_status :'||p_disability_status);
1106: hr_utility.trace('p_cumulative_taxation :'||p_cumulative_taxation);
1107: hr_utility.trace('p_non_resident :'||p_non_resident);
1108: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1109: hr_utility.trace('p_school_district :'||p_school_district);
1110: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1111: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1112: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1113: hr_utility.trace('p_disability_status :'||p_disability_status);
1114: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1107: hr_utility.trace('p_non_resident :'||p_non_resident);
1108: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1109: hr_utility.trace('p_school_district :'||p_school_district);
1110: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1111: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1112: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1113: hr_utility.trace('p_disability_status :'||p_disability_status);
1114: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1115: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1108: hr_utility.trace('p_sui_base_override_amount :'||to_char(p_sui_base_override_amount));
1109: hr_utility.trace('p_school_district :'||p_school_district);
1110: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1111: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1112: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1113: hr_utility.trace('p_disability_status :'||p_disability_status);
1114: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1115: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1116: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1109: hr_utility.trace('p_school_district :'||p_school_district);
1110: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1111: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1112: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1113: hr_utility.trace('p_disability_status :'||p_disability_status);
1114: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1115: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1116: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1117: hr_utility.trace('sta_information1 :'||p_sta_information1);
1110: hr_utility.trace('p_comm_renumeration :'||to_char(p_comm_renumeration));
1111: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1112: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1113: hr_utility.trace('p_disability_status :'||p_disability_status);
1114: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1115: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1116: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1117: hr_utility.trace('sta_information1 :'||p_sta_information1);
1118: hr_utility.trace('sta_information2 :'||p_sta_information2);
1111: hr_utility.trace('p_comm_expenses :'||to_char(p_comm_expenses));
1112: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1113: hr_utility.trace('p_disability_status :'||p_disability_status);
1114: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1115: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1116: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1117: hr_utility.trace('sta_information1 :'||p_sta_information1);
1118: hr_utility.trace('sta_information2 :'||p_sta_information2);
1119: hr_utility.trace('sta_information3 :'||p_sta_information3);
1112: hr_utility.trace('p_spouse_or_equivalent :'||p_spouse_or_equivalent);
1113: hr_utility.trace('p_disability_status :'||p_disability_status);
1114: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1115: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1116: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1117: hr_utility.trace('sta_information1 :'||p_sta_information1);
1118: hr_utility.trace('sta_information2 :'||p_sta_information2);
1119: hr_utility.trace('sta_information3 :'||p_sta_information3);
1120: hr_utility.trace('sta_information4 :'||p_sta_information4);
1113: hr_utility.trace('p_disability_status :'||p_disability_status);
1114: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1115: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1116: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1117: hr_utility.trace('sta_information1 :'||p_sta_information1);
1118: hr_utility.trace('sta_information2 :'||p_sta_information2);
1119: hr_utility.trace('sta_information3 :'||p_sta_information3);
1120: hr_utility.trace('sta_information4 :'||p_sta_information4);
1121: hr_utility.trace('sta_information5 :'||p_sta_information5);
1114: hr_utility.trace('p_number_of_dependents :'||to_char(p_number_of_dependents));
1115: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1116: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1117: hr_utility.trace('sta_information1 :'||p_sta_information1);
1118: hr_utility.trace('sta_information2 :'||p_sta_information2);
1119: hr_utility.trace('sta_information3 :'||p_sta_information3);
1120: hr_utility.trace('sta_information4 :'||p_sta_information4);
1121: hr_utility.trace('sta_information5 :'||p_sta_information5);
1122: hr_utility.trace('sta_information6 :'||p_sta_information6);
1115: hr_utility.trace('p_number_of_infirm_dependents :'||to_char(p_number_of_infirm_dependents));
1116: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1117: hr_utility.trace('sta_information1 :'||p_sta_information1);
1118: hr_utility.trace('sta_information2 :'||p_sta_information2);
1119: hr_utility.trace('sta_information3 :'||p_sta_information3);
1120: hr_utility.trace('sta_information4 :'||p_sta_information4);
1121: hr_utility.trace('sta_information5 :'||p_sta_information5);
1122: hr_utility.trace('sta_information6 :'||p_sta_information6);
1123: hr_utility.trace('sta_information7 :'||p_sta_information7);
1116: hr_utility.trace('sta_information_category :'||p_sta_information_category);
1117: hr_utility.trace('sta_information1 :'||p_sta_information1);
1118: hr_utility.trace('sta_information2 :'||p_sta_information2);
1119: hr_utility.trace('sta_information3 :'||p_sta_information3);
1120: hr_utility.trace('sta_information4 :'||p_sta_information4);
1121: hr_utility.trace('sta_information5 :'||p_sta_information5);
1122: hr_utility.trace('sta_information6 :'||p_sta_information6);
1123: hr_utility.trace('sta_information7 :'||p_sta_information7);
1124: hr_utility.trace('sta_information8 :'||p_sta_information8);
1117: hr_utility.trace('sta_information1 :'||p_sta_information1);
1118: hr_utility.trace('sta_information2 :'||p_sta_information2);
1119: hr_utility.trace('sta_information3 :'||p_sta_information3);
1120: hr_utility.trace('sta_information4 :'||p_sta_information4);
1121: hr_utility.trace('sta_information5 :'||p_sta_information5);
1122: hr_utility.trace('sta_information6 :'||p_sta_information6);
1123: hr_utility.trace('sta_information7 :'||p_sta_information7);
1124: hr_utility.trace('sta_information8 :'||p_sta_information8);
1125: hr_utility.trace('sta_information9 :'||p_sta_information9);
1118: hr_utility.trace('sta_information2 :'||p_sta_information2);
1119: hr_utility.trace('sta_information3 :'||p_sta_information3);
1120: hr_utility.trace('sta_information4 :'||p_sta_information4);
1121: hr_utility.trace('sta_information5 :'||p_sta_information5);
1122: hr_utility.trace('sta_information6 :'||p_sta_information6);
1123: hr_utility.trace('sta_information7 :'||p_sta_information7);
1124: hr_utility.trace('sta_information8 :'||p_sta_information8);
1125: hr_utility.trace('sta_information9 :'||p_sta_information9);
1126: hr_utility.trace('sta_information10 :'||p_sta_information10);
1119: hr_utility.trace('sta_information3 :'||p_sta_information3);
1120: hr_utility.trace('sta_information4 :'||p_sta_information4);
1121: hr_utility.trace('sta_information5 :'||p_sta_information5);
1122: hr_utility.trace('sta_information6 :'||p_sta_information6);
1123: hr_utility.trace('sta_information7 :'||p_sta_information7);
1124: hr_utility.trace('sta_information8 :'||p_sta_information8);
1125: hr_utility.trace('sta_information9 :'||p_sta_information9);
1126: hr_utility.trace('sta_information10 :'||p_sta_information10);
1127: hr_utility.trace('sta_information11 :'||p_sta_information11);
1120: hr_utility.trace('sta_information4 :'||p_sta_information4);
1121: hr_utility.trace('sta_information5 :'||p_sta_information5);
1122: hr_utility.trace('sta_information6 :'||p_sta_information6);
1123: hr_utility.trace('sta_information7 :'||p_sta_information7);
1124: hr_utility.trace('sta_information8 :'||p_sta_information8);
1125: hr_utility.trace('sta_information9 :'||p_sta_information9);
1126: hr_utility.trace('sta_information10 :'||p_sta_information10);
1127: hr_utility.trace('sta_information11 :'||p_sta_information11);
1128: hr_utility.trace('sta_information12 :'||p_sta_information12);
1121: hr_utility.trace('sta_information5 :'||p_sta_information5);
1122: hr_utility.trace('sta_information6 :'||p_sta_information6);
1123: hr_utility.trace('sta_information7 :'||p_sta_information7);
1124: hr_utility.trace('sta_information8 :'||p_sta_information8);
1125: hr_utility.trace('sta_information9 :'||p_sta_information9);
1126: hr_utility.trace('sta_information10 :'||p_sta_information10);
1127: hr_utility.trace('sta_information11 :'||p_sta_information11);
1128: hr_utility.trace('sta_information12 :'||p_sta_information12);
1129: hr_utility.trace('sta_information13 :'||p_sta_information13);
1122: hr_utility.trace('sta_information6 :'||p_sta_information6);
1123: hr_utility.trace('sta_information7 :'||p_sta_information7);
1124: hr_utility.trace('sta_information8 :'||p_sta_information8);
1125: hr_utility.trace('sta_information9 :'||p_sta_information9);
1126: hr_utility.trace('sta_information10 :'||p_sta_information10);
1127: hr_utility.trace('sta_information11 :'||p_sta_information11);
1128: hr_utility.trace('sta_information12 :'||p_sta_information12);
1129: hr_utility.trace('sta_information13 :'||p_sta_information13);
1130: hr_utility.trace('sta_information14 :'||p_sta_information14);
1123: hr_utility.trace('sta_information7 :'||p_sta_information7);
1124: hr_utility.trace('sta_information8 :'||p_sta_information8);
1125: hr_utility.trace('sta_information9 :'||p_sta_information9);
1126: hr_utility.trace('sta_information10 :'||p_sta_information10);
1127: hr_utility.trace('sta_information11 :'||p_sta_information11);
1128: hr_utility.trace('sta_information12 :'||p_sta_information12);
1129: hr_utility.trace('sta_information13 :'||p_sta_information13);
1130: hr_utility.trace('sta_information14 :'||p_sta_information14);
1131: hr_utility.trace('sta_information15 :'||p_sta_information15);
1124: hr_utility.trace('sta_information8 :'||p_sta_information8);
1125: hr_utility.trace('sta_information9 :'||p_sta_information9);
1126: hr_utility.trace('sta_information10 :'||p_sta_information10);
1127: hr_utility.trace('sta_information11 :'||p_sta_information11);
1128: hr_utility.trace('sta_information12 :'||p_sta_information12);
1129: hr_utility.trace('sta_information13 :'||p_sta_information13);
1130: hr_utility.trace('sta_information14 :'||p_sta_information14);
1131: hr_utility.trace('sta_information15 :'||p_sta_information15);
1132: hr_utility.trace('sta_information16 :'||p_sta_information16);
1125: hr_utility.trace('sta_information9 :'||p_sta_information9);
1126: hr_utility.trace('sta_information10 :'||p_sta_information10);
1127: hr_utility.trace('sta_information11 :'||p_sta_information11);
1128: hr_utility.trace('sta_information12 :'||p_sta_information12);
1129: hr_utility.trace('sta_information13 :'||p_sta_information13);
1130: hr_utility.trace('sta_information14 :'||p_sta_information14);
1131: hr_utility.trace('sta_information15 :'||p_sta_information15);
1132: hr_utility.trace('sta_information16 :'||p_sta_information16);
1133: hr_utility.trace('sta_information17 :'||p_sta_information17);
1126: hr_utility.trace('sta_information10 :'||p_sta_information10);
1127: hr_utility.trace('sta_information11 :'||p_sta_information11);
1128: hr_utility.trace('sta_information12 :'||p_sta_information12);
1129: hr_utility.trace('sta_information13 :'||p_sta_information13);
1130: hr_utility.trace('sta_information14 :'||p_sta_information14);
1131: hr_utility.trace('sta_information15 :'||p_sta_information15);
1132: hr_utility.trace('sta_information16 :'||p_sta_information16);
1133: hr_utility.trace('sta_information17 :'||p_sta_information17);
1134: hr_utility.trace('sta_information18 :'||p_sta_information18);
1127: hr_utility.trace('sta_information11 :'||p_sta_information11);
1128: hr_utility.trace('sta_information12 :'||p_sta_information12);
1129: hr_utility.trace('sta_information13 :'||p_sta_information13);
1130: hr_utility.trace('sta_information14 :'||p_sta_information14);
1131: hr_utility.trace('sta_information15 :'||p_sta_information15);
1132: hr_utility.trace('sta_information16 :'||p_sta_information16);
1133: hr_utility.trace('sta_information17 :'||p_sta_information17);
1134: hr_utility.trace('sta_information18 :'||p_sta_information18);
1135: hr_utility.trace('sta_information19 :'||p_sta_information19);
1128: hr_utility.trace('sta_information12 :'||p_sta_information12);
1129: hr_utility.trace('sta_information13 :'||p_sta_information13);
1130: hr_utility.trace('sta_information14 :'||p_sta_information14);
1131: hr_utility.trace('sta_information15 :'||p_sta_information15);
1132: hr_utility.trace('sta_information16 :'||p_sta_information16);
1133: hr_utility.trace('sta_information17 :'||p_sta_information17);
1134: hr_utility.trace('sta_information18 :'||p_sta_information18);
1135: hr_utility.trace('sta_information19 :'||p_sta_information19);
1136: hr_utility.trace('sta_information20 :'||p_sta_information20);
1129: hr_utility.trace('sta_information13 :'||p_sta_information13);
1130: hr_utility.trace('sta_information14 :'||p_sta_information14);
1131: hr_utility.trace('sta_information15 :'||p_sta_information15);
1132: hr_utility.trace('sta_information16 :'||p_sta_information16);
1133: hr_utility.trace('sta_information17 :'||p_sta_information17);
1134: hr_utility.trace('sta_information18 :'||p_sta_information18);
1135: hr_utility.trace('sta_information19 :'||p_sta_information19);
1136: hr_utility.trace('sta_information20 :'||p_sta_information20);
1137: hr_utility.trace('sta_information21 :'||p_sta_information21);
1130: hr_utility.trace('sta_information14 :'||p_sta_information14);
1131: hr_utility.trace('sta_information15 :'||p_sta_information15);
1132: hr_utility.trace('sta_information16 :'||p_sta_information16);
1133: hr_utility.trace('sta_information17 :'||p_sta_information17);
1134: hr_utility.trace('sta_information18 :'||p_sta_information18);
1135: hr_utility.trace('sta_information19 :'||p_sta_information19);
1136: hr_utility.trace('sta_information20 :'||p_sta_information20);
1137: hr_utility.trace('sta_information21 :'||p_sta_information21);
1138: hr_utility.trace('sta_information22 :'||p_sta_information22);
1131: hr_utility.trace('sta_information15 :'||p_sta_information15);
1132: hr_utility.trace('sta_information16 :'||p_sta_information16);
1133: hr_utility.trace('sta_information17 :'||p_sta_information17);
1134: hr_utility.trace('sta_information18 :'||p_sta_information18);
1135: hr_utility.trace('sta_information19 :'||p_sta_information19);
1136: hr_utility.trace('sta_information20 :'||p_sta_information20);
1137: hr_utility.trace('sta_information21 :'||p_sta_information21);
1138: hr_utility.trace('sta_information22 :'||p_sta_information22);
1139: hr_utility.trace('sta_information23 :'||p_sta_information23);
1132: hr_utility.trace('sta_information16 :'||p_sta_information16);
1133: hr_utility.trace('sta_information17 :'||p_sta_information17);
1134: hr_utility.trace('sta_information18 :'||p_sta_information18);
1135: hr_utility.trace('sta_information19 :'||p_sta_information19);
1136: hr_utility.trace('sta_information20 :'||p_sta_information20);
1137: hr_utility.trace('sta_information21 :'||p_sta_information21);
1138: hr_utility.trace('sta_information22 :'||p_sta_information22);
1139: hr_utility.trace('sta_information23 :'||p_sta_information23);
1140: hr_utility.trace('sta_information24 :'||p_sta_information24);
1133: hr_utility.trace('sta_information17 :'||p_sta_information17);
1134: hr_utility.trace('sta_information18 :'||p_sta_information18);
1135: hr_utility.trace('sta_information19 :'||p_sta_information19);
1136: hr_utility.trace('sta_information20 :'||p_sta_information20);
1137: hr_utility.trace('sta_information21 :'||p_sta_information21);
1138: hr_utility.trace('sta_information22 :'||p_sta_information22);
1139: hr_utility.trace('sta_information23 :'||p_sta_information23);
1140: hr_utility.trace('sta_information24 :'||p_sta_information24);
1141: hr_utility.trace('sta_information25 :'||p_sta_information25);
1134: hr_utility.trace('sta_information18 :'||p_sta_information18);
1135: hr_utility.trace('sta_information19 :'||p_sta_information19);
1136: hr_utility.trace('sta_information20 :'||p_sta_information20);
1137: hr_utility.trace('sta_information21 :'||p_sta_information21);
1138: hr_utility.trace('sta_information22 :'||p_sta_information22);
1139: hr_utility.trace('sta_information23 :'||p_sta_information23);
1140: hr_utility.trace('sta_information24 :'||p_sta_information24);
1141: hr_utility.trace('sta_information25 :'||p_sta_information25);
1142: hr_utility.trace('sta_information26 :'||p_sta_information26);
1135: hr_utility.trace('sta_information19 :'||p_sta_information19);
1136: hr_utility.trace('sta_information20 :'||p_sta_information20);
1137: hr_utility.trace('sta_information21 :'||p_sta_information21);
1138: hr_utility.trace('sta_information22 :'||p_sta_information22);
1139: hr_utility.trace('sta_information23 :'||p_sta_information23);
1140: hr_utility.trace('sta_information24 :'||p_sta_information24);
1141: hr_utility.trace('sta_information25 :'||p_sta_information25);
1142: hr_utility.trace('sta_information26 :'||p_sta_information26);
1143: hr_utility.trace('sta_information27 :'||p_sta_information27);
1136: hr_utility.trace('sta_information20 :'||p_sta_information20);
1137: hr_utility.trace('sta_information21 :'||p_sta_information21);
1138: hr_utility.trace('sta_information22 :'||p_sta_information22);
1139: hr_utility.trace('sta_information23 :'||p_sta_information23);
1140: hr_utility.trace('sta_information24 :'||p_sta_information24);
1141: hr_utility.trace('sta_information25 :'||p_sta_information25);
1142: hr_utility.trace('sta_information26 :'||p_sta_information26);
1143: hr_utility.trace('sta_information27 :'||p_sta_information27);
1144: hr_utility.trace('sta_information28 :'||p_sta_information28);
1137: hr_utility.trace('sta_information21 :'||p_sta_information21);
1138: hr_utility.trace('sta_information22 :'||p_sta_information22);
1139: hr_utility.trace('sta_information23 :'||p_sta_information23);
1140: hr_utility.trace('sta_information24 :'||p_sta_information24);
1141: hr_utility.trace('sta_information25 :'||p_sta_information25);
1142: hr_utility.trace('sta_information26 :'||p_sta_information26);
1143: hr_utility.trace('sta_information27 :'||p_sta_information27);
1144: hr_utility.trace('sta_information28 :'||p_sta_information28);
1145: hr_utility.trace('sta_information29 :'||p_sta_information29);
1138: hr_utility.trace('sta_information22 :'||p_sta_information22);
1139: hr_utility.trace('sta_information23 :'||p_sta_information23);
1140: hr_utility.trace('sta_information24 :'||p_sta_information24);
1141: hr_utility.trace('sta_information25 :'||p_sta_information25);
1142: hr_utility.trace('sta_information26 :'||p_sta_information26);
1143: hr_utility.trace('sta_information27 :'||p_sta_information27);
1144: hr_utility.trace('sta_information28 :'||p_sta_information28);
1145: hr_utility.trace('sta_information29 :'||p_sta_information29);
1146: hr_utility.trace('sta_information30 :'||p_sta_information30);
1139: hr_utility.trace('sta_information23 :'||p_sta_information23);
1140: hr_utility.trace('sta_information24 :'||p_sta_information24);
1141: hr_utility.trace('sta_information25 :'||p_sta_information25);
1142: hr_utility.trace('sta_information26 :'||p_sta_information26);
1143: hr_utility.trace('sta_information27 :'||p_sta_information27);
1144: hr_utility.trace('sta_information28 :'||p_sta_information28);
1145: hr_utility.trace('sta_information29 :'||p_sta_information29);
1146: hr_utility.trace('sta_information30 :'||p_sta_information30);
1147:
1140: hr_utility.trace('sta_information24 :'||p_sta_information24);
1141: hr_utility.trace('sta_information25 :'||p_sta_information25);
1142: hr_utility.trace('sta_information26 :'||p_sta_information26);
1143: hr_utility.trace('sta_information27 :'||p_sta_information27);
1144: hr_utility.trace('sta_information28 :'||p_sta_information28);
1145: hr_utility.trace('sta_information29 :'||p_sta_information29);
1146: hr_utility.trace('sta_information30 :'||p_sta_information30);
1147:
1148: open csr_get_asg_id;
1141: hr_utility.trace('sta_information25 :'||p_sta_information25);
1142: hr_utility.trace('sta_information26 :'||p_sta_information26);
1143: hr_utility.trace('sta_information27 :'||p_sta_information27);
1144: hr_utility.trace('sta_information28 :'||p_sta_information28);
1145: hr_utility.trace('sta_information29 :'||p_sta_information29);
1146: hr_utility.trace('sta_information30 :'||p_sta_information30);
1147:
1148: open csr_get_asg_id;
1149: fetch csr_get_asg_id into ln_assignment_id;
1142: hr_utility.trace('sta_information26 :'||p_sta_information26);
1143: hr_utility.trace('sta_information27 :'||p_sta_information27);
1144: hr_utility.trace('sta_information28 :'||p_sta_information28);
1145: hr_utility.trace('sta_information29 :'||p_sta_information29);
1146: hr_utility.trace('sta_information30 :'||p_sta_information30);
1147:
1148: open csr_get_asg_id;
1149: fetch csr_get_asg_id into ln_assignment_id;
1150: close csr_get_asg_id;
1147:
1148: open csr_get_asg_id;
1149: fetch csr_get_asg_id into ln_assignment_id;
1150: close csr_get_asg_id;
1151: hr_utility.trace('Assignment_id :'||to_char(ln_assignment_id));
1152:
1153:
1154: -- ========================================================================
1155: -- US Federal Tax Rule Information
1174: l_pay_us_fedtax_rule_rec.EXCESSIVE_WA_REJECT_DATE := P_ALLOWANCE_REJECT_DATE;
1175:
1176: open csr_get_fedtax_id(ln_assignment_id);
1177: fetch csr_get_fedtax_id into ln_fedtax_rule_id,ln_ovn2;
1178: hr_utility.trace('emp_fed_tax_rule_id :'||to_char(ln_fedtax_rule_id));
1179: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1180:
1181: if csr_get_fedtax_id%FOUND then
1182: l_pay_us_fedtax_rule_rec.EMP_FED_TAX_RULE_ID := ln_fedtax_rule_id;
1175:
1176: open csr_get_fedtax_id(ln_assignment_id);
1177: fetch csr_get_fedtax_id into ln_fedtax_rule_id,ln_ovn2;
1178: hr_utility.trace('emp_fed_tax_rule_id :'||to_char(ln_fedtax_rule_id));
1179: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1180:
1181: if csr_get_fedtax_id%FOUND then
1182: l_pay_us_fedtax_rule_rec.EMP_FED_TAX_RULE_ID := ln_fedtax_rule_id;
1183: l_pay_us_fedtax_rule_rec.OBJECT_VERSION_NUMBER := ln_ovn2;
1203:
1204: -- Fix for bug#4526310
1205: lv_lookup_code := '0'||lv_lookup_code;
1206:
1207: hr_utility.trace('Filing Status Code :'||lv_lookup_code);
1208: l_pay_us_statetax_rule_rec := null;
1209:
1210: l_pay_us_statetax_rule_rec.state_code := P_STATE_PROV_CODE;
1211: l_pay_us_statetax_rule_rec.FILING_STATUS_CODE := lv_lookup_code;
1259:
1260:
1261: open csr_get_statetax_id(ln_assignment_id);
1262: fetch csr_get_statetax_id into ln_statetax_rule_id,ln_ovn2;
1263: hr_utility.trace('emp_state_tax_rule_id :'||to_char(ln_statetax_rule_id));
1264: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1265:
1266: if csr_get_statetax_id%FOUND then
1267: l_pay_us_statetax_rule_rec.EMP_STATE_TAX_RULE_ID := ln_statetax_rule_id;
1260:
1261: open csr_get_statetax_id(ln_assignment_id);
1262: fetch csr_get_statetax_id into ln_statetax_rule_id,ln_ovn2;
1263: hr_utility.trace('emp_state_tax_rule_id :'||to_char(ln_statetax_rule_id));
1264: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1265:
1266: if csr_get_statetax_id%FOUND then
1267: l_pay_us_statetax_rule_rec.EMP_STATE_TAX_RULE_ID := ln_statetax_rule_id;
1268: l_pay_us_statetax_rule_rec.OBJECT_VERSION_NUMBER := ln_ovn2;
1317: l_pay_us_countytax_rule_rec.county_code := lv_county_code;
1318:
1319: open csr_get_countytax_id(ln_assignment_id,lv_county_code);
1320: fetch csr_get_countytax_id into ln_countytax_rule_id,ln_ovn2;
1321: hr_utility.trace('emp_county_tax_rule_id :'||to_char(ln_countytax_rule_id));
1322: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1323:
1324: if csr_get_countytax_id%FOUND then
1325: l_pay_us_countytax_rule_rec.EMP_COUNTY_TAX_RULE_ID := ln_countytax_rule_id;
1318:
1319: open csr_get_countytax_id(ln_assignment_id,lv_county_code);
1320: fetch csr_get_countytax_id into ln_countytax_rule_id,ln_ovn2;
1321: hr_utility.trace('emp_county_tax_rule_id :'||to_char(ln_countytax_rule_id));
1322: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1323:
1324: if csr_get_countytax_id%FOUND then
1325: l_pay_us_countytax_rule_rec.EMP_COUNTY_TAX_RULE_ID := ln_countytax_rule_id;
1326: l_pay_us_countytax_rule_rec.OBJECT_VERSION_NUMBER := ln_ovn2;
1380: l_pay_us_citytax_rule_rec.SCHOOL_DISTRICT_CODE := lv_city_school_distcode;
1381:
1382: open csr_get_citytax_id(ln_assignment_id,lv_county_code,lv_city_code);
1383: fetch csr_get_citytax_id into ln_citytax_rule_id,ln_ovn2;
1384: hr_utility.trace('emp_city_tax_rule_id :'||to_char(ln_citytax_rule_id));
1385: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1386:
1387: if csr_get_citytax_id%FOUND then
1388: l_pay_us_citytax_rule_rec.EMP_CITY_TAX_RULE_ID := ln_citytax_rule_id;
1381:
1382: open csr_get_citytax_id(ln_assignment_id,lv_county_code,lv_city_code);
1383: fetch csr_get_citytax_id into ln_citytax_rule_id,ln_ovn2;
1384: hr_utility.trace('emp_city_tax_rule_id :'||to_char(ln_citytax_rule_id));
1385: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1386:
1387: if csr_get_citytax_id%FOUND then
1388: l_pay_us_citytax_rule_rec.EMP_CITY_TAX_RULE_ID := ln_citytax_rule_id;
1389: l_pay_us_citytax_rule_rec.OBJECT_VERSION_NUMBER := ln_ovn2;
1409:
1410: elsif P_SPREADSHEET_IDENTIFIER = 'PAYRICAFED' then
1411:
1412: if P_BASIC_AMT_FLAG = 'Y' and P_TAX_CREDIT is NOT NULL then
1413: hr_utility.set_message(800, 'HR_74007_BOTH_NOT_NULL');
1414: hr_utility.raise_error;
1415: elsif (P_BASIC_AMT_FLAG = 'N' and P_TAX_CREDIT is null) then
1416: l_pay_ca_fedtax_rule_rec.TAX_CREDIT_AMOUNT := 0;
1417: elsif (P_BASIC_AMT_FLAG = 'N' and P_TAX_CREDIT is Not null) then
1410: elsif P_SPREADSHEET_IDENTIFIER = 'PAYRICAFED' then
1411:
1412: if P_BASIC_AMT_FLAG = 'Y' and P_TAX_CREDIT is NOT NULL then
1413: hr_utility.set_message(800, 'HR_74007_BOTH_NOT_NULL');
1414: hr_utility.raise_error;
1415: elsif (P_BASIC_AMT_FLAG = 'N' and P_TAX_CREDIT is null) then
1416: l_pay_ca_fedtax_rule_rec.TAX_CREDIT_AMOUNT := 0;
1417: elsif (P_BASIC_AMT_FLAG = 'N' and P_TAX_CREDIT is Not null) then
1418: l_pay_ca_fedtax_rule_rec.TAX_CREDIT_AMOUNT := P_TAX_CREDIT;
1472: l_pay_ca_fedtax_rule_rec.CA_TAX_INFORMATION30 := p_CA_TAX_INFORMATION30;
1473:
1474: open csr_get_cafedtax_id(ln_assignment_id);
1475: fetch csr_get_cafedtax_id into ln_cafedtax_inf_id,ln_ovn2;
1476: hr_utility.trace('emp_cafed_tax_inf_id :'||to_char(ln_cafedtax_inf_id));
1477: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1478:
1479: if csr_get_cafedtax_id%FOUND then
1480: l_pay_ca_fedtax_rule_rec.EMP_FED_TAX_INF_ID := ln_cafedtax_inf_id;
1473:
1474: open csr_get_cafedtax_id(ln_assignment_id);
1475: fetch csr_get_cafedtax_id into ln_cafedtax_inf_id,ln_ovn2;
1476: hr_utility.trace('emp_cafed_tax_inf_id :'||to_char(ln_cafedtax_inf_id));
1477: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1478:
1479: if csr_get_cafedtax_id%FOUND then
1480: l_pay_ca_fedtax_rule_rec.EMP_FED_TAX_INF_ID := ln_cafedtax_inf_id;
1481: l_pay_ca_fedtax_rule_rec.OBJECT_VERSION_NUMBER := ln_ovn2;
1502:
1503: elsif P_SPREADSHEET_IDENTIFIER = 'PAYRICAPROVINCE' then
1504:
1505: if P_BASIC_AMT_FLAG = 'Y' and P_TAX_CREDIT is not NULL then
1506: hr_utility.set_message(800, 'HR_74007_BOTH_NOT_NULL');
1507: hr_utility.raise_error;
1508: elsif (P_BASIC_AMT_FLAG = 'N' and P_TAX_CREDIT is null) then
1509: l_pay_ca_provtax_rule_rec.TAX_CREDIT_AMOUNT := 0;
1510: elsif (P_BASIC_AMT_FLAG = 'N' and P_TAX_CREDIT is Not null) then
1503: elsif P_SPREADSHEET_IDENTIFIER = 'PAYRICAPROVINCE' then
1504:
1505: if P_BASIC_AMT_FLAG = 'Y' and P_TAX_CREDIT is not NULL then
1506: hr_utility.set_message(800, 'HR_74007_BOTH_NOT_NULL');
1507: hr_utility.raise_error;
1508: elsif (P_BASIC_AMT_FLAG = 'N' and P_TAX_CREDIT is null) then
1509: l_pay_ca_provtax_rule_rec.TAX_CREDIT_AMOUNT := 0;
1510: elsif (P_BASIC_AMT_FLAG = 'N' and P_TAX_CREDIT is Not null) then
1511: l_pay_ca_provtax_rule_rec.TAX_CREDIT_AMOUNT := P_TAX_CREDIT;
1536: l_pay_ca_provtax_rule_rec.PROV_OVERRIDE_RATE := 0;
1537: l_pay_ca_provtax_rule_rec.ADDITIONAL_TAX := 0;
1538: end if;
1539:
1540: hr_utility.trace('Assigning parameter values to province record ');
1541: l_pay_ca_provtax_rule_rec.LEGISLATION_CODE := 'CA';
1542: l_pay_ca_provtax_rule_rec.business_group_id := p_business_group;
1543: l_pay_ca_provtax_rule_rec.PROVINCE_CODE := ltrim(rtrim(P_STATE_PROV_CODE));
1544: l_pay_ca_provtax_rule_rec.BASIC_EXEMPTION_FLAG := P_BASIC_AMT_FLAG;
1592: --l_pay_ca_provtax_rule_rec.TAX_CALC_METHOD := ?;
1593:
1594: open csr_get_caprovtax_id(ln_assignment_id);
1595: fetch csr_get_caprovtax_id into ln_caprovtax_inf_id,ln_ovn2;
1596: hr_utility.trace('emp_caprov_tax_inf_id :'||to_char(ln_caprovtax_inf_id));
1597: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1598:
1599:
1600: if csr_get_caprovtax_id%FOUND then
1593:
1594: open csr_get_caprovtax_id(ln_assignment_id);
1595: fetch csr_get_caprovtax_id into ln_caprovtax_inf_id,ln_ovn2;
1596: hr_utility.trace('emp_caprov_tax_inf_id :'||to_char(ln_caprovtax_inf_id));
1597: hr_utility.trace('object_version_number :'||to_char(ln_ovn2));
1598:
1599:
1600: if csr_get_caprovtax_id%FOUND then
1601: l_pay_ca_provtax_rule_rec.EMP_PROVINCE_TAX_INF_ID := ln_caprovtax_inf_id;
1607: ,p_effective_date => p_effective_date
1608: ,p_spreadsheet_identifier => p_spreadsheet_identifier
1609: );
1610: else
1611: hr_utility.trace('province record not found ');
1612: l_pay_ca_provtax_rule_rec.ASSIGNMENT_ID := ln_assignment_id;
1613:
1614: close csr_get_caprovtax_id;
1615: HR_DataPump(