183: End If;
184: --
185: hr_utility.set_location(' Leaving:'||l_proc, 15);
186: Exception
187: When hr_api.check_integrity_violated Then
188: -- A check constraint has been violated
189: pay_sta_shd.g_api_dml := false; -- Unset the api dml status
190: pay_sta_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
187: When hr_api.check_integrity_violated Then
188: -- A check constraint has been violated
189: pay_sta_shd.g_api_dml := false; -- Unset the api dml status
190: pay_sta_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: pay_sta_shd.g_api_dml := false; -- Unset the api dml status
195: pay_sta_shd.constraint_error
188: -- A check constraint has been violated
189: pay_sta_shd.g_api_dml := false; -- Unset the api dml status
190: pay_sta_shd.constraint_error
191: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: pay_sta_shd.g_api_dml := false; -- Unset the api dml status
195: pay_sta_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
192: When hr_api.unique_integrity_violated Then
193: -- Unique integrity has been violated
194: pay_sta_shd.g_api_dml := false; -- Unset the api dml status
195: pay_sta_shd.constraint_error
196: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
197: When Others Then
198: pay_sta_shd.g_api_dml := false; -- Unset the api dml status
199: Raise;
200: End dt_update_dml;
509: );
510: --
511: exception
512: --
513: when hr_api.cannot_find_prog_unit then
514: --
515: hr_api.cannot_find_prog_unit_error
516: (p_module_name => 'PAY_US_EMP_STATE_TAX_RULES_F
517: ,p_hook_type => 'AU');
511: exception
512: --
513: when hr_api.cannot_find_prog_unit then
514: --
515: hr_api.cannot_find_prog_unit_error
516: (p_module_name => 'PAY_US_EMP_STATE_TAX_RULES_F
517: ,p_hook_type => 'AU');
518: --
519: */
582: -- p_rec plsql record structure
583: -- to see if a system default is being used. If a system default
584: -- is being used then we must set to the 'current' argument value.
585: --
586: If (p_rec.assignment_id = hr_api.g_number) then
587: p_rec.assignment_id :=
588: pay_sta_shd.g_old_rec.assignment_id;
589: End If;
590: If (p_rec.state_code = hr_api.g_varchar2) then
586: If (p_rec.assignment_id = hr_api.g_number) then
587: p_rec.assignment_id :=
588: pay_sta_shd.g_old_rec.assignment_id;
589: End If;
590: If (p_rec.state_code = hr_api.g_varchar2) then
591: p_rec.state_code :=
592: pay_sta_shd.g_old_rec.state_code;
593: End If;
594: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
590: If (p_rec.state_code = hr_api.g_varchar2) then
591: p_rec.state_code :=
592: pay_sta_shd.g_old_rec.state_code;
593: End If;
594: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
595: p_rec.jurisdiction_code :=
596: pay_sta_shd.g_old_rec.jurisdiction_code;
597: End If;
598: If (p_rec.business_group_id = hr_api.g_number) then
594: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
595: p_rec.jurisdiction_code :=
596: pay_sta_shd.g_old_rec.jurisdiction_code;
597: End If;
598: If (p_rec.business_group_id = hr_api.g_number) then
599: p_rec.business_group_id :=
600: pay_sta_shd.g_old_rec.business_group_id;
601: End If;
602: If (p_rec.additional_wa_amount = hr_api.g_number) then
598: If (p_rec.business_group_id = hr_api.g_number) then
599: p_rec.business_group_id :=
600: pay_sta_shd.g_old_rec.business_group_id;
601: End If;
602: If (p_rec.additional_wa_amount = hr_api.g_number) then
603: p_rec.additional_wa_amount :=
604: pay_sta_shd.g_old_rec.additional_wa_amount;
605: End If;
606: If (p_rec.filing_status_code = hr_api.g_varchar2) then
602: If (p_rec.additional_wa_amount = hr_api.g_number) then
603: p_rec.additional_wa_amount :=
604: pay_sta_shd.g_old_rec.additional_wa_amount;
605: End If;
606: If (p_rec.filing_status_code = hr_api.g_varchar2) then
607: p_rec.filing_status_code :=
608: pay_sta_shd.g_old_rec.filing_status_code;
609: End If;
610: If (p_rec.remainder_percent = hr_api.g_number) then
606: If (p_rec.filing_status_code = hr_api.g_varchar2) then
607: p_rec.filing_status_code :=
608: pay_sta_shd.g_old_rec.filing_status_code;
609: End If;
610: If (p_rec.remainder_percent = hr_api.g_number) then
611: p_rec.remainder_percent :=
612: pay_sta_shd.g_old_rec.remainder_percent;
613: End If;
614: If (p_rec.secondary_wa = hr_api.g_number) then
610: If (p_rec.remainder_percent = hr_api.g_number) then
611: p_rec.remainder_percent :=
612: pay_sta_shd.g_old_rec.remainder_percent;
613: End If;
614: If (p_rec.secondary_wa = hr_api.g_number) then
615: p_rec.secondary_wa :=
616: pay_sta_shd.g_old_rec.secondary_wa;
617: End If;
618: If (p_rec.sit_additional_tax = hr_api.g_number) then
614: If (p_rec.secondary_wa = hr_api.g_number) then
615: p_rec.secondary_wa :=
616: pay_sta_shd.g_old_rec.secondary_wa;
617: End If;
618: If (p_rec.sit_additional_tax = hr_api.g_number) then
619: p_rec.sit_additional_tax :=
620: pay_sta_shd.g_old_rec.sit_additional_tax;
621: End If;
622: If (p_rec.sit_override_amount = hr_api.g_number) then
618: If (p_rec.sit_additional_tax = hr_api.g_number) then
619: p_rec.sit_additional_tax :=
620: pay_sta_shd.g_old_rec.sit_additional_tax;
621: End If;
622: If (p_rec.sit_override_amount = hr_api.g_number) then
623: p_rec.sit_override_amount :=
624: pay_sta_shd.g_old_rec.sit_override_amount;
625: End If;
626: If (p_rec.sit_override_rate = hr_api.g_number) then
622: If (p_rec.sit_override_amount = hr_api.g_number) then
623: p_rec.sit_override_amount :=
624: pay_sta_shd.g_old_rec.sit_override_amount;
625: End If;
626: If (p_rec.sit_override_rate = hr_api.g_number) then
627: p_rec.sit_override_rate :=
628: pay_sta_shd.g_old_rec.sit_override_rate;
629: End If;
630: If (p_rec.withholding_allowances = hr_api.g_number) then
626: If (p_rec.sit_override_rate = hr_api.g_number) then
627: p_rec.sit_override_rate :=
628: pay_sta_shd.g_old_rec.sit_override_rate;
629: End If;
630: If (p_rec.withholding_allowances = hr_api.g_number) then
631: p_rec.withholding_allowances :=
632: pay_sta_shd.g_old_rec.withholding_allowances;
633: End If;
634: If (p_rec.excessive_wa_reject_date = hr_api.g_date) then
630: If (p_rec.withholding_allowances = hr_api.g_number) then
631: p_rec.withholding_allowances :=
632: pay_sta_shd.g_old_rec.withholding_allowances;
633: End If;
634: If (p_rec.excessive_wa_reject_date = hr_api.g_date) then
635: p_rec.excessive_wa_reject_date :=
636: pay_sta_shd.g_old_rec.excessive_wa_reject_date;
637: End If;
638: If (p_rec.sdi_exempt = hr_api.g_varchar2) then
634: If (p_rec.excessive_wa_reject_date = hr_api.g_date) then
635: p_rec.excessive_wa_reject_date :=
636: pay_sta_shd.g_old_rec.excessive_wa_reject_date;
637: End If;
638: If (p_rec.sdi_exempt = hr_api.g_varchar2) then
639: p_rec.sdi_exempt :=
640: pay_sta_shd.g_old_rec.sdi_exempt;
641: End If;
642: If (p_rec.sit_exempt = hr_api.g_varchar2) then
638: If (p_rec.sdi_exempt = hr_api.g_varchar2) then
639: p_rec.sdi_exempt :=
640: pay_sta_shd.g_old_rec.sdi_exempt;
641: End If;
642: If (p_rec.sit_exempt = hr_api.g_varchar2) then
643: p_rec.sit_exempt :=
644: pay_sta_shd.g_old_rec.sit_exempt;
645: End If;
646: If (p_rec.sit_optional_calc_ind = hr_api.g_varchar2) then
642: If (p_rec.sit_exempt = hr_api.g_varchar2) then
643: p_rec.sit_exempt :=
644: pay_sta_shd.g_old_rec.sit_exempt;
645: End If;
646: If (p_rec.sit_optional_calc_ind = hr_api.g_varchar2) then
647: p_rec.sit_optional_calc_ind :=
648: pay_sta_shd.g_old_rec.sit_optional_calc_ind;
649: End If;
650: If (p_rec.state_non_resident_cert = hr_api.g_varchar2) then
646: If (p_rec.sit_optional_calc_ind = hr_api.g_varchar2) then
647: p_rec.sit_optional_calc_ind :=
648: pay_sta_shd.g_old_rec.sit_optional_calc_ind;
649: End If;
650: If (p_rec.state_non_resident_cert = hr_api.g_varchar2) then
651: p_rec.state_non_resident_cert :=
652: pay_sta_shd.g_old_rec.state_non_resident_cert;
653: End If;
654: If (p_rec.sui_exempt = hr_api.g_varchar2) then
650: If (p_rec.state_non_resident_cert = hr_api.g_varchar2) then
651: p_rec.state_non_resident_cert :=
652: pay_sta_shd.g_old_rec.state_non_resident_cert;
653: End If;
654: If (p_rec.sui_exempt = hr_api.g_varchar2) then
655: p_rec.sui_exempt :=
656: pay_sta_shd.g_old_rec.sui_exempt;
657: End If;
658: If (p_rec.wc_exempt = hr_api.g_varchar2) then
654: If (p_rec.sui_exempt = hr_api.g_varchar2) then
655: p_rec.sui_exempt :=
656: pay_sta_shd.g_old_rec.sui_exempt;
657: End If;
658: If (p_rec.wc_exempt = hr_api.g_varchar2) then
659: p_rec.wc_exempt :=
660: pay_sta_shd.g_old_rec.wc_exempt;
661: End If;
662: If (p_rec.wage_exempt = hr_api.g_varchar2) then
658: If (p_rec.wc_exempt = hr_api.g_varchar2) then
659: p_rec.wc_exempt :=
660: pay_sta_shd.g_old_rec.wc_exempt;
661: End If;
662: If (p_rec.wage_exempt = hr_api.g_varchar2) then
663: p_rec.wage_exempt :=
664: pay_sta_shd.g_old_rec.wage_exempt;
665: End If;
666: If (p_rec.sui_wage_base_override_amount = hr_api.g_number) then
662: If (p_rec.wage_exempt = hr_api.g_varchar2) then
663: p_rec.wage_exempt :=
664: pay_sta_shd.g_old_rec.wage_exempt;
665: End If;
666: If (p_rec.sui_wage_base_override_amount = hr_api.g_number) then
667: p_rec.sui_wage_base_override_amount :=
668: pay_sta_shd.g_old_rec.sui_wage_base_override_amount;
669: End If;
670: If (p_rec.supp_tax_override_rate = hr_api.g_number) then
666: If (p_rec.sui_wage_base_override_amount = hr_api.g_number) then
667: p_rec.sui_wage_base_override_amount :=
668: pay_sta_shd.g_old_rec.sui_wage_base_override_amount;
669: End If;
670: If (p_rec.supp_tax_override_rate = hr_api.g_number) then
671: p_rec.supp_tax_override_rate :=
672: pay_sta_shd.g_old_rec.supp_tax_override_rate;
673: End If;
674: If (p_rec.attribute_category = hr_api.g_varchar2) then
670: If (p_rec.supp_tax_override_rate = hr_api.g_number) then
671: p_rec.supp_tax_override_rate :=
672: pay_sta_shd.g_old_rec.supp_tax_override_rate;
673: End If;
674: If (p_rec.attribute_category = hr_api.g_varchar2) then
675: p_rec.attribute_category :=
676: pay_sta_shd.g_old_rec.attribute_category;
677: End If;
678: If (p_rec.attribute1 = hr_api.g_varchar2) then
674: If (p_rec.attribute_category = hr_api.g_varchar2) then
675: p_rec.attribute_category :=
676: pay_sta_shd.g_old_rec.attribute_category;
677: End If;
678: If (p_rec.attribute1 = hr_api.g_varchar2) then
679: p_rec.attribute1 :=
680: pay_sta_shd.g_old_rec.attribute1;
681: End If;
682: If (p_rec.attribute2 = hr_api.g_varchar2) then
678: If (p_rec.attribute1 = hr_api.g_varchar2) then
679: p_rec.attribute1 :=
680: pay_sta_shd.g_old_rec.attribute1;
681: End If;
682: If (p_rec.attribute2 = hr_api.g_varchar2) then
683: p_rec.attribute2 :=
684: pay_sta_shd.g_old_rec.attribute2;
685: End If;
686: If (p_rec.attribute3 = hr_api.g_varchar2) then
682: If (p_rec.attribute2 = hr_api.g_varchar2) then
683: p_rec.attribute2 :=
684: pay_sta_shd.g_old_rec.attribute2;
685: End If;
686: If (p_rec.attribute3 = hr_api.g_varchar2) then
687: p_rec.attribute3 :=
688: pay_sta_shd.g_old_rec.attribute3;
689: End If;
690: If (p_rec.attribute4 = hr_api.g_varchar2) then
686: If (p_rec.attribute3 = hr_api.g_varchar2) then
687: p_rec.attribute3 :=
688: pay_sta_shd.g_old_rec.attribute3;
689: End If;
690: If (p_rec.attribute4 = hr_api.g_varchar2) then
691: p_rec.attribute4 :=
692: pay_sta_shd.g_old_rec.attribute4;
693: End If;
694: If (p_rec.attribute5 = hr_api.g_varchar2) then
690: If (p_rec.attribute4 = hr_api.g_varchar2) then
691: p_rec.attribute4 :=
692: pay_sta_shd.g_old_rec.attribute4;
693: End If;
694: If (p_rec.attribute5 = hr_api.g_varchar2) then
695: p_rec.attribute5 :=
696: pay_sta_shd.g_old_rec.attribute5;
697: End If;
698: If (p_rec.attribute6 = hr_api.g_varchar2) then
694: If (p_rec.attribute5 = hr_api.g_varchar2) then
695: p_rec.attribute5 :=
696: pay_sta_shd.g_old_rec.attribute5;
697: End If;
698: If (p_rec.attribute6 = hr_api.g_varchar2) then
699: p_rec.attribute6 :=
700: pay_sta_shd.g_old_rec.attribute6;
701: End If;
702: If (p_rec.attribute7 = hr_api.g_varchar2) then
698: If (p_rec.attribute6 = hr_api.g_varchar2) then
699: p_rec.attribute6 :=
700: pay_sta_shd.g_old_rec.attribute6;
701: End If;
702: If (p_rec.attribute7 = hr_api.g_varchar2) then
703: p_rec.attribute7 :=
704: pay_sta_shd.g_old_rec.attribute7;
705: End If;
706: If (p_rec.attribute8 = hr_api.g_varchar2) then
702: If (p_rec.attribute7 = hr_api.g_varchar2) then
703: p_rec.attribute7 :=
704: pay_sta_shd.g_old_rec.attribute7;
705: End If;
706: If (p_rec.attribute8 = hr_api.g_varchar2) then
707: p_rec.attribute8 :=
708: pay_sta_shd.g_old_rec.attribute8;
709: End If;
710: If (p_rec.attribute9 = hr_api.g_varchar2) then
706: If (p_rec.attribute8 = hr_api.g_varchar2) then
707: p_rec.attribute8 :=
708: pay_sta_shd.g_old_rec.attribute8;
709: End If;
710: If (p_rec.attribute9 = hr_api.g_varchar2) then
711: p_rec.attribute9 :=
712: pay_sta_shd.g_old_rec.attribute9;
713: End If;
714: If (p_rec.attribute10 = hr_api.g_varchar2) then
710: If (p_rec.attribute9 = hr_api.g_varchar2) then
711: p_rec.attribute9 :=
712: pay_sta_shd.g_old_rec.attribute9;
713: End If;
714: If (p_rec.attribute10 = hr_api.g_varchar2) then
715: p_rec.attribute10 :=
716: pay_sta_shd.g_old_rec.attribute10;
717: End If;
718: If (p_rec.attribute11 = hr_api.g_varchar2) then
714: If (p_rec.attribute10 = hr_api.g_varchar2) then
715: p_rec.attribute10 :=
716: pay_sta_shd.g_old_rec.attribute10;
717: End If;
718: If (p_rec.attribute11 = hr_api.g_varchar2) then
719: p_rec.attribute11 :=
720: pay_sta_shd.g_old_rec.attribute11;
721: End If;
722: If (p_rec.attribute12 = hr_api.g_varchar2) then
718: If (p_rec.attribute11 = hr_api.g_varchar2) then
719: p_rec.attribute11 :=
720: pay_sta_shd.g_old_rec.attribute11;
721: End If;
722: If (p_rec.attribute12 = hr_api.g_varchar2) then
723: p_rec.attribute12 :=
724: pay_sta_shd.g_old_rec.attribute12;
725: End If;
726: If (p_rec.attribute13 = hr_api.g_varchar2) then
722: If (p_rec.attribute12 = hr_api.g_varchar2) then
723: p_rec.attribute12 :=
724: pay_sta_shd.g_old_rec.attribute12;
725: End If;
726: If (p_rec.attribute13 = hr_api.g_varchar2) then
727: p_rec.attribute13 :=
728: pay_sta_shd.g_old_rec.attribute13;
729: End If;
730: If (p_rec.attribute14 = hr_api.g_varchar2) then
726: If (p_rec.attribute13 = hr_api.g_varchar2) then
727: p_rec.attribute13 :=
728: pay_sta_shd.g_old_rec.attribute13;
729: End If;
730: If (p_rec.attribute14 = hr_api.g_varchar2) then
731: p_rec.attribute14 :=
732: pay_sta_shd.g_old_rec.attribute14;
733: End If;
734: If (p_rec.attribute15 = hr_api.g_varchar2) then
730: If (p_rec.attribute14 = hr_api.g_varchar2) then
731: p_rec.attribute14 :=
732: pay_sta_shd.g_old_rec.attribute14;
733: End If;
734: If (p_rec.attribute15 = hr_api.g_varchar2) then
735: p_rec.attribute15 :=
736: pay_sta_shd.g_old_rec.attribute15;
737: End If;
738: If (p_rec.attribute16 = hr_api.g_varchar2) then
734: If (p_rec.attribute15 = hr_api.g_varchar2) then
735: p_rec.attribute15 :=
736: pay_sta_shd.g_old_rec.attribute15;
737: End If;
738: If (p_rec.attribute16 = hr_api.g_varchar2) then
739: p_rec.attribute16 :=
740: pay_sta_shd.g_old_rec.attribute16;
741: End If;
742: If (p_rec.attribute17 = hr_api.g_varchar2) then
738: If (p_rec.attribute16 = hr_api.g_varchar2) then
739: p_rec.attribute16 :=
740: pay_sta_shd.g_old_rec.attribute16;
741: End If;
742: If (p_rec.attribute17 = hr_api.g_varchar2) then
743: p_rec.attribute17 :=
744: pay_sta_shd.g_old_rec.attribute17;
745: End If;
746: If (p_rec.attribute18 = hr_api.g_varchar2) then
742: If (p_rec.attribute17 = hr_api.g_varchar2) then
743: p_rec.attribute17 :=
744: pay_sta_shd.g_old_rec.attribute17;
745: End If;
746: If (p_rec.attribute18 = hr_api.g_varchar2) then
747: p_rec.attribute18 :=
748: pay_sta_shd.g_old_rec.attribute18;
749: End If;
750: If (p_rec.attribute19 = hr_api.g_varchar2) then
746: If (p_rec.attribute18 = hr_api.g_varchar2) then
747: p_rec.attribute18 :=
748: pay_sta_shd.g_old_rec.attribute18;
749: End If;
750: If (p_rec.attribute19 = hr_api.g_varchar2) then
751: p_rec.attribute19 :=
752: pay_sta_shd.g_old_rec.attribute19;
753: End If;
754: If (p_rec.attribute20 = hr_api.g_varchar2) then
750: If (p_rec.attribute19 = hr_api.g_varchar2) then
751: p_rec.attribute19 :=
752: pay_sta_shd.g_old_rec.attribute19;
753: End If;
754: If (p_rec.attribute20 = hr_api.g_varchar2) then
755: p_rec.attribute20 :=
756: pay_sta_shd.g_old_rec.attribute20;
757: End If;
758: If (p_rec.attribute21 = hr_api.g_varchar2) then
754: If (p_rec.attribute20 = hr_api.g_varchar2) then
755: p_rec.attribute20 :=
756: pay_sta_shd.g_old_rec.attribute20;
757: End If;
758: If (p_rec.attribute21 = hr_api.g_varchar2) then
759: p_rec.attribute21 :=
760: pay_sta_shd.g_old_rec.attribute21;
761: End If;
762: If (p_rec.attribute22 = hr_api.g_varchar2) then
758: If (p_rec.attribute21 = hr_api.g_varchar2) then
759: p_rec.attribute21 :=
760: pay_sta_shd.g_old_rec.attribute21;
761: End If;
762: If (p_rec.attribute22 = hr_api.g_varchar2) then
763: p_rec.attribute22 :=
764: pay_sta_shd.g_old_rec.attribute22;
765: End If;
766: If (p_rec.attribute23 = hr_api.g_varchar2) then
762: If (p_rec.attribute22 = hr_api.g_varchar2) then
763: p_rec.attribute22 :=
764: pay_sta_shd.g_old_rec.attribute22;
765: End If;
766: If (p_rec.attribute23 = hr_api.g_varchar2) then
767: p_rec.attribute23 :=
768: pay_sta_shd.g_old_rec.attribute23;
769: End If;
770: If (p_rec.attribute24 = hr_api.g_varchar2) then
766: If (p_rec.attribute23 = hr_api.g_varchar2) then
767: p_rec.attribute23 :=
768: pay_sta_shd.g_old_rec.attribute23;
769: End If;
770: If (p_rec.attribute24 = hr_api.g_varchar2) then
771: p_rec.attribute24 :=
772: pay_sta_shd.g_old_rec.attribute24;
773: End If;
774: If (p_rec.attribute25 = hr_api.g_varchar2) then
770: If (p_rec.attribute24 = hr_api.g_varchar2) then
771: p_rec.attribute24 :=
772: pay_sta_shd.g_old_rec.attribute24;
773: End If;
774: If (p_rec.attribute25 = hr_api.g_varchar2) then
775: p_rec.attribute25 :=
776: pay_sta_shd.g_old_rec.attribute25;
777: End If;
778: If (p_rec.attribute26 = hr_api.g_varchar2) then
774: If (p_rec.attribute25 = hr_api.g_varchar2) then
775: p_rec.attribute25 :=
776: pay_sta_shd.g_old_rec.attribute25;
777: End If;
778: If (p_rec.attribute26 = hr_api.g_varchar2) then
779: p_rec.attribute26 :=
780: pay_sta_shd.g_old_rec.attribute26;
781: End If;
782: If (p_rec.attribute27 = hr_api.g_varchar2) then
778: If (p_rec.attribute26 = hr_api.g_varchar2) then
779: p_rec.attribute26 :=
780: pay_sta_shd.g_old_rec.attribute26;
781: End If;
782: If (p_rec.attribute27 = hr_api.g_varchar2) then
783: p_rec.attribute27 :=
784: pay_sta_shd.g_old_rec.attribute27;
785: End If;
786: If (p_rec.attribute28 = hr_api.g_varchar2) then
782: If (p_rec.attribute27 = hr_api.g_varchar2) then
783: p_rec.attribute27 :=
784: pay_sta_shd.g_old_rec.attribute27;
785: End If;
786: If (p_rec.attribute28 = hr_api.g_varchar2) then
787: p_rec.attribute28 :=
788: pay_sta_shd.g_old_rec.attribute28;
789: End If;
790: If (p_rec.attribute29 = hr_api.g_varchar2) then
786: If (p_rec.attribute28 = hr_api.g_varchar2) then
787: p_rec.attribute28 :=
788: pay_sta_shd.g_old_rec.attribute28;
789: End If;
790: If (p_rec.attribute29 = hr_api.g_varchar2) then
791: p_rec.attribute29 :=
792: pay_sta_shd.g_old_rec.attribute29;
793: End If;
794: If (p_rec.attribute30 = hr_api.g_varchar2) then
790: If (p_rec.attribute29 = hr_api.g_varchar2) then
791: p_rec.attribute29 :=
792: pay_sta_shd.g_old_rec.attribute29;
793: End If;
794: If (p_rec.attribute30 = hr_api.g_varchar2) then
795: p_rec.attribute30 :=
796: pay_sta_shd.g_old_rec.attribute30;
797: End If;
798: If (p_rec.sta_information_category = hr_api.g_varchar2) then
794: If (p_rec.attribute30 = hr_api.g_varchar2) then
795: p_rec.attribute30 :=
796: pay_sta_shd.g_old_rec.attribute30;
797: End If;
798: If (p_rec.sta_information_category = hr_api.g_varchar2) then
799: p_rec.sta_information_category :=
800: pay_sta_shd.g_old_rec.sta_information_category;
801: End If;
802: If (p_rec.sta_information1 = hr_api.g_varchar2) then
798: If (p_rec.sta_information_category = hr_api.g_varchar2) then
799: p_rec.sta_information_category :=
800: pay_sta_shd.g_old_rec.sta_information_category;
801: End If;
802: If (p_rec.sta_information1 = hr_api.g_varchar2) then
803: p_rec.sta_information1 :=
804: pay_sta_shd.g_old_rec.sta_information1;
805: End If;
806: If (p_rec.sta_information2 = hr_api.g_varchar2) then
802: If (p_rec.sta_information1 = hr_api.g_varchar2) then
803: p_rec.sta_information1 :=
804: pay_sta_shd.g_old_rec.sta_information1;
805: End If;
806: If (p_rec.sta_information2 = hr_api.g_varchar2) then
807: p_rec.sta_information2 :=
808: pay_sta_shd.g_old_rec.sta_information2;
809: End If;
810: If (p_rec.sta_information3 = hr_api.g_varchar2) then
806: If (p_rec.sta_information2 = hr_api.g_varchar2) then
807: p_rec.sta_information2 :=
808: pay_sta_shd.g_old_rec.sta_information2;
809: End If;
810: If (p_rec.sta_information3 = hr_api.g_varchar2) then
811: p_rec.sta_information3 :=
812: pay_sta_shd.g_old_rec.sta_information3;
813: End If;
814: If (p_rec.sta_information4 = hr_api.g_varchar2) then
810: If (p_rec.sta_information3 = hr_api.g_varchar2) then
811: p_rec.sta_information3 :=
812: pay_sta_shd.g_old_rec.sta_information3;
813: End If;
814: If (p_rec.sta_information4 = hr_api.g_varchar2) then
815: p_rec.sta_information4 :=
816: pay_sta_shd.g_old_rec.sta_information4;
817: End If;
818: If (p_rec.sta_information5 = hr_api.g_varchar2) then
814: If (p_rec.sta_information4 = hr_api.g_varchar2) then
815: p_rec.sta_information4 :=
816: pay_sta_shd.g_old_rec.sta_information4;
817: End If;
818: If (p_rec.sta_information5 = hr_api.g_varchar2) then
819: p_rec.sta_information5 :=
820: pay_sta_shd.g_old_rec.sta_information5;
821: End If;
822: If (p_rec.sta_information6 = hr_api.g_varchar2) then
818: If (p_rec.sta_information5 = hr_api.g_varchar2) then
819: p_rec.sta_information5 :=
820: pay_sta_shd.g_old_rec.sta_information5;
821: End If;
822: If (p_rec.sta_information6 = hr_api.g_varchar2) then
823: p_rec.sta_information6 :=
824: pay_sta_shd.g_old_rec.sta_information6;
825: End If;
826: If (p_rec.sta_information7 = hr_api.g_varchar2) then
822: If (p_rec.sta_information6 = hr_api.g_varchar2) then
823: p_rec.sta_information6 :=
824: pay_sta_shd.g_old_rec.sta_information6;
825: End If;
826: If (p_rec.sta_information7 = hr_api.g_varchar2) then
827: p_rec.sta_information7 :=
828: pay_sta_shd.g_old_rec.sta_information7;
829: End If;
830: If (p_rec.sta_information8 = hr_api.g_varchar2) then
826: If (p_rec.sta_information7 = hr_api.g_varchar2) then
827: p_rec.sta_information7 :=
828: pay_sta_shd.g_old_rec.sta_information7;
829: End If;
830: If (p_rec.sta_information8 = hr_api.g_varchar2) then
831: p_rec.sta_information8 :=
832: pay_sta_shd.g_old_rec.sta_information8;
833: End If;
834: If (p_rec.sta_information9 = hr_api.g_varchar2) then
830: If (p_rec.sta_information8 = hr_api.g_varchar2) then
831: p_rec.sta_information8 :=
832: pay_sta_shd.g_old_rec.sta_information8;
833: End If;
834: If (p_rec.sta_information9 = hr_api.g_varchar2) then
835: p_rec.sta_information9 :=
836: pay_sta_shd.g_old_rec.sta_information9;
837: End If;
838: If (p_rec.sta_information10 = hr_api.g_varchar2) then
834: If (p_rec.sta_information9 = hr_api.g_varchar2) then
835: p_rec.sta_information9 :=
836: pay_sta_shd.g_old_rec.sta_information9;
837: End If;
838: If (p_rec.sta_information10 = hr_api.g_varchar2) then
839: p_rec.sta_information10 :=
840: pay_sta_shd.g_old_rec.sta_information10;
841: End If;
842: If (p_rec.sta_information11 = hr_api.g_varchar2) then
838: If (p_rec.sta_information10 = hr_api.g_varchar2) then
839: p_rec.sta_information10 :=
840: pay_sta_shd.g_old_rec.sta_information10;
841: End If;
842: If (p_rec.sta_information11 = hr_api.g_varchar2) then
843: p_rec.sta_information11 :=
844: pay_sta_shd.g_old_rec.sta_information11;
845: End If;
846: If (p_rec.sta_information12 = hr_api.g_varchar2) then
842: If (p_rec.sta_information11 = hr_api.g_varchar2) then
843: p_rec.sta_information11 :=
844: pay_sta_shd.g_old_rec.sta_information11;
845: End If;
846: If (p_rec.sta_information12 = hr_api.g_varchar2) then
847: p_rec.sta_information12 :=
848: pay_sta_shd.g_old_rec.sta_information12;
849: End If;
850: If (p_rec.sta_information13 = hr_api.g_varchar2) then
846: If (p_rec.sta_information12 = hr_api.g_varchar2) then
847: p_rec.sta_information12 :=
848: pay_sta_shd.g_old_rec.sta_information12;
849: End If;
850: If (p_rec.sta_information13 = hr_api.g_varchar2) then
851: p_rec.sta_information13 :=
852: pay_sta_shd.g_old_rec.sta_information13;
853: End If;
854: If (p_rec.sta_information14 = hr_api.g_varchar2) then
850: If (p_rec.sta_information13 = hr_api.g_varchar2) then
851: p_rec.sta_information13 :=
852: pay_sta_shd.g_old_rec.sta_information13;
853: End If;
854: If (p_rec.sta_information14 = hr_api.g_varchar2) then
855: p_rec.sta_information14 :=
856: pay_sta_shd.g_old_rec.sta_information14;
857: End If;
858: If (p_rec.sta_information15 = hr_api.g_varchar2) then
854: If (p_rec.sta_information14 = hr_api.g_varchar2) then
855: p_rec.sta_information14 :=
856: pay_sta_shd.g_old_rec.sta_information14;
857: End If;
858: If (p_rec.sta_information15 = hr_api.g_varchar2) then
859: p_rec.sta_information15 :=
860: pay_sta_shd.g_old_rec.sta_information15;
861: End If;
862: If (p_rec.sta_information16 = hr_api.g_varchar2) then
858: If (p_rec.sta_information15 = hr_api.g_varchar2) then
859: p_rec.sta_information15 :=
860: pay_sta_shd.g_old_rec.sta_information15;
861: End If;
862: If (p_rec.sta_information16 = hr_api.g_varchar2) then
863: p_rec.sta_information16 :=
864: pay_sta_shd.g_old_rec.sta_information16;
865: End If;
866: If (p_rec.sta_information17 = hr_api.g_varchar2) then
862: If (p_rec.sta_information16 = hr_api.g_varchar2) then
863: p_rec.sta_information16 :=
864: pay_sta_shd.g_old_rec.sta_information16;
865: End If;
866: If (p_rec.sta_information17 = hr_api.g_varchar2) then
867: p_rec.sta_information17 :=
868: pay_sta_shd.g_old_rec.sta_information17;
869: End If;
870: If (p_rec.sta_information18 = hr_api.g_varchar2) then
866: If (p_rec.sta_information17 = hr_api.g_varchar2) then
867: p_rec.sta_information17 :=
868: pay_sta_shd.g_old_rec.sta_information17;
869: End If;
870: If (p_rec.sta_information18 = hr_api.g_varchar2) then
871: p_rec.sta_information18 :=
872: pay_sta_shd.g_old_rec.sta_information18;
873: End If;
874: If (p_rec.sta_information19 = hr_api.g_varchar2) then
870: If (p_rec.sta_information18 = hr_api.g_varchar2) then
871: p_rec.sta_information18 :=
872: pay_sta_shd.g_old_rec.sta_information18;
873: End If;
874: If (p_rec.sta_information19 = hr_api.g_varchar2) then
875: p_rec.sta_information19 :=
876: pay_sta_shd.g_old_rec.sta_information19;
877: End If;
878: If (p_rec.sta_information20 = hr_api.g_varchar2) then
874: If (p_rec.sta_information19 = hr_api.g_varchar2) then
875: p_rec.sta_information19 :=
876: pay_sta_shd.g_old_rec.sta_information19;
877: End If;
878: If (p_rec.sta_information20 = hr_api.g_varchar2) then
879: p_rec.sta_information20 :=
880: pay_sta_shd.g_old_rec.sta_information20;
881: End If;
882: If (p_rec.sta_information21 = hr_api.g_varchar2) then
878: If (p_rec.sta_information20 = hr_api.g_varchar2) then
879: p_rec.sta_information20 :=
880: pay_sta_shd.g_old_rec.sta_information20;
881: End If;
882: If (p_rec.sta_information21 = hr_api.g_varchar2) then
883: p_rec.sta_information21 :=
884: pay_sta_shd.g_old_rec.sta_information21;
885: End If;
886: If (p_rec.sta_information22 = hr_api.g_varchar2) then
882: If (p_rec.sta_information21 = hr_api.g_varchar2) then
883: p_rec.sta_information21 :=
884: pay_sta_shd.g_old_rec.sta_information21;
885: End If;
886: If (p_rec.sta_information22 = hr_api.g_varchar2) then
887: p_rec.sta_information22 :=
888: pay_sta_shd.g_old_rec.sta_information22;
889: End If;
890: If (p_rec.sta_information23 = hr_api.g_varchar2) then
886: If (p_rec.sta_information22 = hr_api.g_varchar2) then
887: p_rec.sta_information22 :=
888: pay_sta_shd.g_old_rec.sta_information22;
889: End If;
890: If (p_rec.sta_information23 = hr_api.g_varchar2) then
891: p_rec.sta_information23 :=
892: pay_sta_shd.g_old_rec.sta_information23;
893: End If;
894: If (p_rec.sta_information24 = hr_api.g_varchar2) then
890: If (p_rec.sta_information23 = hr_api.g_varchar2) then
891: p_rec.sta_information23 :=
892: pay_sta_shd.g_old_rec.sta_information23;
893: End If;
894: If (p_rec.sta_information24 = hr_api.g_varchar2) then
895: p_rec.sta_information24 :=
896: pay_sta_shd.g_old_rec.sta_information24;
897: End If;
898: If (p_rec.sta_information25 = hr_api.g_varchar2) then
894: If (p_rec.sta_information24 = hr_api.g_varchar2) then
895: p_rec.sta_information24 :=
896: pay_sta_shd.g_old_rec.sta_information24;
897: End If;
898: If (p_rec.sta_information25 = hr_api.g_varchar2) then
899: p_rec.sta_information25 :=
900: pay_sta_shd.g_old_rec.sta_information25;
901: End If;
902: If (p_rec.sta_information26 = hr_api.g_varchar2) then
898: If (p_rec.sta_information25 = hr_api.g_varchar2) then
899: p_rec.sta_information25 :=
900: pay_sta_shd.g_old_rec.sta_information25;
901: End If;
902: If (p_rec.sta_information26 = hr_api.g_varchar2) then
903: p_rec.sta_information26 :=
904: pay_sta_shd.g_old_rec.sta_information26;
905: End If;
906: If (p_rec.sta_information27 = hr_api.g_varchar2) then
902: If (p_rec.sta_information26 = hr_api.g_varchar2) then
903: p_rec.sta_information26 :=
904: pay_sta_shd.g_old_rec.sta_information26;
905: End If;
906: If (p_rec.sta_information27 = hr_api.g_varchar2) then
907: p_rec.sta_information27 :=
908: pay_sta_shd.g_old_rec.sta_information27;
909: End If;
910: If (p_rec.sta_information28 = hr_api.g_varchar2) then
906: If (p_rec.sta_information27 = hr_api.g_varchar2) then
907: p_rec.sta_information27 :=
908: pay_sta_shd.g_old_rec.sta_information27;
909: End If;
910: If (p_rec.sta_information28 = hr_api.g_varchar2) then
911: p_rec.sta_information28 :=
912: pay_sta_shd.g_old_rec.sta_information28;
913: End If;
914: If (p_rec.sta_information29 = hr_api.g_varchar2) then
910: If (p_rec.sta_information28 = hr_api.g_varchar2) then
911: p_rec.sta_information28 :=
912: pay_sta_shd.g_old_rec.sta_information28;
913: End If;
914: If (p_rec.sta_information29 = hr_api.g_varchar2) then
915: p_rec.sta_information29 :=
916: pay_sta_shd.g_old_rec.sta_information29;
917: End If;
918: If (p_rec.sta_information30 = hr_api.g_varchar2) then
914: If (p_rec.sta_information29 = hr_api.g_varchar2) then
915: p_rec.sta_information29 :=
916: pay_sta_shd.g_old_rec.sta_information29;
917: End If;
918: If (p_rec.sta_information30 = hr_api.g_varchar2) then
919: p_rec.sta_information30 :=
920: pay_sta_shd.g_old_rec.sta_information30;
921: End If;
922:
1005: (
1006: p_emp_state_tax_rule_id in number,
1007: p_effective_start_date out nocopy date,
1008: p_effective_end_date out nocopy date,
1009: p_additional_wa_amount in number default hr_api.g_number,
1010: p_filing_status_code in varchar2 default hr_api.g_varchar2,
1011: p_remainder_percent in number default hr_api.g_number,
1012: p_secondary_wa in number default hr_api.g_number,
1013: p_sit_additional_tax in number default hr_api.g_number,
1006: p_emp_state_tax_rule_id in number,
1007: p_effective_start_date out nocopy date,
1008: p_effective_end_date out nocopy date,
1009: p_additional_wa_amount in number default hr_api.g_number,
1010: p_filing_status_code in varchar2 default hr_api.g_varchar2,
1011: p_remainder_percent in number default hr_api.g_number,
1012: p_secondary_wa in number default hr_api.g_number,
1013: p_sit_additional_tax in number default hr_api.g_number,
1014: p_sit_override_amount in number default hr_api.g_number,
1007: p_effective_start_date out nocopy date,
1008: p_effective_end_date out nocopy date,
1009: p_additional_wa_amount in number default hr_api.g_number,
1010: p_filing_status_code in varchar2 default hr_api.g_varchar2,
1011: p_remainder_percent in number default hr_api.g_number,
1012: p_secondary_wa in number default hr_api.g_number,
1013: p_sit_additional_tax in number default hr_api.g_number,
1014: p_sit_override_amount in number default hr_api.g_number,
1015: p_sit_override_rate in number default hr_api.g_number,
1008: p_effective_end_date out nocopy date,
1009: p_additional_wa_amount in number default hr_api.g_number,
1010: p_filing_status_code in varchar2 default hr_api.g_varchar2,
1011: p_remainder_percent in number default hr_api.g_number,
1012: p_secondary_wa in number default hr_api.g_number,
1013: p_sit_additional_tax in number default hr_api.g_number,
1014: p_sit_override_amount in number default hr_api.g_number,
1015: p_sit_override_rate in number default hr_api.g_number,
1016: p_withholding_allowances in number default hr_api.g_number,
1009: p_additional_wa_amount in number default hr_api.g_number,
1010: p_filing_status_code in varchar2 default hr_api.g_varchar2,
1011: p_remainder_percent in number default hr_api.g_number,
1012: p_secondary_wa in number default hr_api.g_number,
1013: p_sit_additional_tax in number default hr_api.g_number,
1014: p_sit_override_amount in number default hr_api.g_number,
1015: p_sit_override_rate in number default hr_api.g_number,
1016: p_withholding_allowances in number default hr_api.g_number,
1017: p_excessive_wa_reject_date in date default hr_api.g_date,
1010: p_filing_status_code in varchar2 default hr_api.g_varchar2,
1011: p_remainder_percent in number default hr_api.g_number,
1012: p_secondary_wa in number default hr_api.g_number,
1013: p_sit_additional_tax in number default hr_api.g_number,
1014: p_sit_override_amount in number default hr_api.g_number,
1015: p_sit_override_rate in number default hr_api.g_number,
1016: p_withholding_allowances in number default hr_api.g_number,
1017: p_excessive_wa_reject_date in date default hr_api.g_date,
1018: p_sdi_exempt in varchar2 default hr_api.g_varchar2,
1011: p_remainder_percent in number default hr_api.g_number,
1012: p_secondary_wa in number default hr_api.g_number,
1013: p_sit_additional_tax in number default hr_api.g_number,
1014: p_sit_override_amount in number default hr_api.g_number,
1015: p_sit_override_rate in number default hr_api.g_number,
1016: p_withholding_allowances in number default hr_api.g_number,
1017: p_excessive_wa_reject_date in date default hr_api.g_date,
1018: p_sdi_exempt in varchar2 default hr_api.g_varchar2,
1019: p_sit_exempt in varchar2 default hr_api.g_varchar2,
1012: p_secondary_wa in number default hr_api.g_number,
1013: p_sit_additional_tax in number default hr_api.g_number,
1014: p_sit_override_amount in number default hr_api.g_number,
1015: p_sit_override_rate in number default hr_api.g_number,
1016: p_withholding_allowances in number default hr_api.g_number,
1017: p_excessive_wa_reject_date in date default hr_api.g_date,
1018: p_sdi_exempt in varchar2 default hr_api.g_varchar2,
1019: p_sit_exempt in varchar2 default hr_api.g_varchar2,
1020: p_sit_optional_calc_ind in varchar2 default hr_api.g_varchar2,
1013: p_sit_additional_tax in number default hr_api.g_number,
1014: p_sit_override_amount in number default hr_api.g_number,
1015: p_sit_override_rate in number default hr_api.g_number,
1016: p_withholding_allowances in number default hr_api.g_number,
1017: p_excessive_wa_reject_date in date default hr_api.g_date,
1018: p_sdi_exempt in varchar2 default hr_api.g_varchar2,
1019: p_sit_exempt in varchar2 default hr_api.g_varchar2,
1020: p_sit_optional_calc_ind in varchar2 default hr_api.g_varchar2,
1021: p_state_non_resident_cert in varchar2 default hr_api.g_varchar2,
1014: p_sit_override_amount in number default hr_api.g_number,
1015: p_sit_override_rate in number default hr_api.g_number,
1016: p_withholding_allowances in number default hr_api.g_number,
1017: p_excessive_wa_reject_date in date default hr_api.g_date,
1018: p_sdi_exempt in varchar2 default hr_api.g_varchar2,
1019: p_sit_exempt in varchar2 default hr_api.g_varchar2,
1020: p_sit_optional_calc_ind in varchar2 default hr_api.g_varchar2,
1021: p_state_non_resident_cert in varchar2 default hr_api.g_varchar2,
1022: p_sui_exempt in varchar2 default hr_api.g_varchar2,
1015: p_sit_override_rate in number default hr_api.g_number,
1016: p_withholding_allowances in number default hr_api.g_number,
1017: p_excessive_wa_reject_date in date default hr_api.g_date,
1018: p_sdi_exempt in varchar2 default hr_api.g_varchar2,
1019: p_sit_exempt in varchar2 default hr_api.g_varchar2,
1020: p_sit_optional_calc_ind in varchar2 default hr_api.g_varchar2,
1021: p_state_non_resident_cert in varchar2 default hr_api.g_varchar2,
1022: p_sui_exempt in varchar2 default hr_api.g_varchar2,
1023: p_wc_exempt in varchar2 default hr_api.g_varchar2,
1016: p_withholding_allowances in number default hr_api.g_number,
1017: p_excessive_wa_reject_date in date default hr_api.g_date,
1018: p_sdi_exempt in varchar2 default hr_api.g_varchar2,
1019: p_sit_exempt in varchar2 default hr_api.g_varchar2,
1020: p_sit_optional_calc_ind in varchar2 default hr_api.g_varchar2,
1021: p_state_non_resident_cert in varchar2 default hr_api.g_varchar2,
1022: p_sui_exempt in varchar2 default hr_api.g_varchar2,
1023: p_wc_exempt in varchar2 default hr_api.g_varchar2,
1024: p_wage_exempt in varchar2 default hr_api.g_varchar2,
1017: p_excessive_wa_reject_date in date default hr_api.g_date,
1018: p_sdi_exempt in varchar2 default hr_api.g_varchar2,
1019: p_sit_exempt in varchar2 default hr_api.g_varchar2,
1020: p_sit_optional_calc_ind in varchar2 default hr_api.g_varchar2,
1021: p_state_non_resident_cert in varchar2 default hr_api.g_varchar2,
1022: p_sui_exempt in varchar2 default hr_api.g_varchar2,
1023: p_wc_exempt in varchar2 default hr_api.g_varchar2,
1024: p_wage_exempt in varchar2 default hr_api.g_varchar2,
1025: p_sui_wage_base_override_amoun in number default hr_api.g_number,
1018: p_sdi_exempt in varchar2 default hr_api.g_varchar2,
1019: p_sit_exempt in varchar2 default hr_api.g_varchar2,
1020: p_sit_optional_calc_ind in varchar2 default hr_api.g_varchar2,
1021: p_state_non_resident_cert in varchar2 default hr_api.g_varchar2,
1022: p_sui_exempt in varchar2 default hr_api.g_varchar2,
1023: p_wc_exempt in varchar2 default hr_api.g_varchar2,
1024: p_wage_exempt in varchar2 default hr_api.g_varchar2,
1025: p_sui_wage_base_override_amoun in number default hr_api.g_number,
1026: p_supp_tax_override_rate in number default hr_api.g_number,
1019: p_sit_exempt in varchar2 default hr_api.g_varchar2,
1020: p_sit_optional_calc_ind in varchar2 default hr_api.g_varchar2,
1021: p_state_non_resident_cert in varchar2 default hr_api.g_varchar2,
1022: p_sui_exempt in varchar2 default hr_api.g_varchar2,
1023: p_wc_exempt in varchar2 default hr_api.g_varchar2,
1024: p_wage_exempt in varchar2 default hr_api.g_varchar2,
1025: p_sui_wage_base_override_amoun in number default hr_api.g_number,
1026: p_supp_tax_override_rate in number default hr_api.g_number,
1027: p_object_version_number in out nocopy number,
1020: p_sit_optional_calc_ind in varchar2 default hr_api.g_varchar2,
1021: p_state_non_resident_cert in varchar2 default hr_api.g_varchar2,
1022: p_sui_exempt in varchar2 default hr_api.g_varchar2,
1023: p_wc_exempt in varchar2 default hr_api.g_varchar2,
1024: p_wage_exempt in varchar2 default hr_api.g_varchar2,
1025: p_sui_wage_base_override_amoun in number default hr_api.g_number,
1026: p_supp_tax_override_rate in number default hr_api.g_number,
1027: p_object_version_number in out nocopy number,
1028: p_effective_date in date,
1021: p_state_non_resident_cert in varchar2 default hr_api.g_varchar2,
1022: p_sui_exempt in varchar2 default hr_api.g_varchar2,
1023: p_wc_exempt in varchar2 default hr_api.g_varchar2,
1024: p_wage_exempt in varchar2 default hr_api.g_varchar2,
1025: p_sui_wage_base_override_amoun in number default hr_api.g_number,
1026: p_supp_tax_override_rate in number default hr_api.g_number,
1027: p_object_version_number in out nocopy number,
1028: p_effective_date in date,
1029: p_datetrack_mode in varchar2,
1022: p_sui_exempt in varchar2 default hr_api.g_varchar2,
1023: p_wc_exempt in varchar2 default hr_api.g_varchar2,
1024: p_wage_exempt in varchar2 default hr_api.g_varchar2,
1025: p_sui_wage_base_override_amoun in number default hr_api.g_number,
1026: p_supp_tax_override_rate in number default hr_api.g_number,
1027: p_object_version_number in out nocopy number,
1028: p_effective_date in date,
1029: p_datetrack_mode in varchar2,
1030: p_attribute_category in varchar2 default hr_api.g_varchar2,
1026: p_supp_tax_override_rate in number default hr_api.g_number,
1027: p_object_version_number in out nocopy number,
1028: p_effective_date in date,
1029: p_datetrack_mode in varchar2,
1030: p_attribute_category in varchar2 default hr_api.g_varchar2,
1031: p_attribute1 in varchar2 default hr_api.g_varchar2,
1032: p_attribute2 in varchar2 default hr_api.g_varchar2,
1033: p_attribute3 in varchar2 default hr_api.g_varchar2,
1034: p_attribute4 in varchar2 default hr_api.g_varchar2,
1027: p_object_version_number in out nocopy number,
1028: p_effective_date in date,
1029: p_datetrack_mode in varchar2,
1030: p_attribute_category in varchar2 default hr_api.g_varchar2,
1031: p_attribute1 in varchar2 default hr_api.g_varchar2,
1032: p_attribute2 in varchar2 default hr_api.g_varchar2,
1033: p_attribute3 in varchar2 default hr_api.g_varchar2,
1034: p_attribute4 in varchar2 default hr_api.g_varchar2,
1035: p_attribute5 in varchar2 default hr_api.g_varchar2,
1028: p_effective_date in date,
1029: p_datetrack_mode in varchar2,
1030: p_attribute_category in varchar2 default hr_api.g_varchar2,
1031: p_attribute1 in varchar2 default hr_api.g_varchar2,
1032: p_attribute2 in varchar2 default hr_api.g_varchar2,
1033: p_attribute3 in varchar2 default hr_api.g_varchar2,
1034: p_attribute4 in varchar2 default hr_api.g_varchar2,
1035: p_attribute5 in varchar2 default hr_api.g_varchar2,
1036: p_attribute6 in varchar2 default hr_api.g_varchar2,
1029: p_datetrack_mode in varchar2,
1030: p_attribute_category in varchar2 default hr_api.g_varchar2,
1031: p_attribute1 in varchar2 default hr_api.g_varchar2,
1032: p_attribute2 in varchar2 default hr_api.g_varchar2,
1033: p_attribute3 in varchar2 default hr_api.g_varchar2,
1034: p_attribute4 in varchar2 default hr_api.g_varchar2,
1035: p_attribute5 in varchar2 default hr_api.g_varchar2,
1036: p_attribute6 in varchar2 default hr_api.g_varchar2,
1037: p_attribute7 in varchar2 default hr_api.g_varchar2,
1030: p_attribute_category in varchar2 default hr_api.g_varchar2,
1031: p_attribute1 in varchar2 default hr_api.g_varchar2,
1032: p_attribute2 in varchar2 default hr_api.g_varchar2,
1033: p_attribute3 in varchar2 default hr_api.g_varchar2,
1034: p_attribute4 in varchar2 default hr_api.g_varchar2,
1035: p_attribute5 in varchar2 default hr_api.g_varchar2,
1036: p_attribute6 in varchar2 default hr_api.g_varchar2,
1037: p_attribute7 in varchar2 default hr_api.g_varchar2,
1038: p_attribute8 in varchar2 default hr_api.g_varchar2,
1031: p_attribute1 in varchar2 default hr_api.g_varchar2,
1032: p_attribute2 in varchar2 default hr_api.g_varchar2,
1033: p_attribute3 in varchar2 default hr_api.g_varchar2,
1034: p_attribute4 in varchar2 default hr_api.g_varchar2,
1035: p_attribute5 in varchar2 default hr_api.g_varchar2,
1036: p_attribute6 in varchar2 default hr_api.g_varchar2,
1037: p_attribute7 in varchar2 default hr_api.g_varchar2,
1038: p_attribute8 in varchar2 default hr_api.g_varchar2,
1039: p_attribute9 in varchar2 default hr_api.g_varchar2,
1032: p_attribute2 in varchar2 default hr_api.g_varchar2,
1033: p_attribute3 in varchar2 default hr_api.g_varchar2,
1034: p_attribute4 in varchar2 default hr_api.g_varchar2,
1035: p_attribute5 in varchar2 default hr_api.g_varchar2,
1036: p_attribute6 in varchar2 default hr_api.g_varchar2,
1037: p_attribute7 in varchar2 default hr_api.g_varchar2,
1038: p_attribute8 in varchar2 default hr_api.g_varchar2,
1039: p_attribute9 in varchar2 default hr_api.g_varchar2,
1040: p_attribute10 in varchar2 default hr_api.g_varchar2,
1033: p_attribute3 in varchar2 default hr_api.g_varchar2,
1034: p_attribute4 in varchar2 default hr_api.g_varchar2,
1035: p_attribute5 in varchar2 default hr_api.g_varchar2,
1036: p_attribute6 in varchar2 default hr_api.g_varchar2,
1037: p_attribute7 in varchar2 default hr_api.g_varchar2,
1038: p_attribute8 in varchar2 default hr_api.g_varchar2,
1039: p_attribute9 in varchar2 default hr_api.g_varchar2,
1040: p_attribute10 in varchar2 default hr_api.g_varchar2,
1041: p_attribute11 in varchar2 default hr_api.g_varchar2,
1034: p_attribute4 in varchar2 default hr_api.g_varchar2,
1035: p_attribute5 in varchar2 default hr_api.g_varchar2,
1036: p_attribute6 in varchar2 default hr_api.g_varchar2,
1037: p_attribute7 in varchar2 default hr_api.g_varchar2,
1038: p_attribute8 in varchar2 default hr_api.g_varchar2,
1039: p_attribute9 in varchar2 default hr_api.g_varchar2,
1040: p_attribute10 in varchar2 default hr_api.g_varchar2,
1041: p_attribute11 in varchar2 default hr_api.g_varchar2,
1042: p_attribute12 in varchar2 default hr_api.g_varchar2,
1035: p_attribute5 in varchar2 default hr_api.g_varchar2,
1036: p_attribute6 in varchar2 default hr_api.g_varchar2,
1037: p_attribute7 in varchar2 default hr_api.g_varchar2,
1038: p_attribute8 in varchar2 default hr_api.g_varchar2,
1039: p_attribute9 in varchar2 default hr_api.g_varchar2,
1040: p_attribute10 in varchar2 default hr_api.g_varchar2,
1041: p_attribute11 in varchar2 default hr_api.g_varchar2,
1042: p_attribute12 in varchar2 default hr_api.g_varchar2,
1043: p_attribute13 in varchar2 default hr_api.g_varchar2,
1036: p_attribute6 in varchar2 default hr_api.g_varchar2,
1037: p_attribute7 in varchar2 default hr_api.g_varchar2,
1038: p_attribute8 in varchar2 default hr_api.g_varchar2,
1039: p_attribute9 in varchar2 default hr_api.g_varchar2,
1040: p_attribute10 in varchar2 default hr_api.g_varchar2,
1041: p_attribute11 in varchar2 default hr_api.g_varchar2,
1042: p_attribute12 in varchar2 default hr_api.g_varchar2,
1043: p_attribute13 in varchar2 default hr_api.g_varchar2,
1044: p_attribute14 in varchar2 default hr_api.g_varchar2,
1037: p_attribute7 in varchar2 default hr_api.g_varchar2,
1038: p_attribute8 in varchar2 default hr_api.g_varchar2,
1039: p_attribute9 in varchar2 default hr_api.g_varchar2,
1040: p_attribute10 in varchar2 default hr_api.g_varchar2,
1041: p_attribute11 in varchar2 default hr_api.g_varchar2,
1042: p_attribute12 in varchar2 default hr_api.g_varchar2,
1043: p_attribute13 in varchar2 default hr_api.g_varchar2,
1044: p_attribute14 in varchar2 default hr_api.g_varchar2,
1045: p_attribute15 in varchar2 default hr_api.g_varchar2,
1038: p_attribute8 in varchar2 default hr_api.g_varchar2,
1039: p_attribute9 in varchar2 default hr_api.g_varchar2,
1040: p_attribute10 in varchar2 default hr_api.g_varchar2,
1041: p_attribute11 in varchar2 default hr_api.g_varchar2,
1042: p_attribute12 in varchar2 default hr_api.g_varchar2,
1043: p_attribute13 in varchar2 default hr_api.g_varchar2,
1044: p_attribute14 in varchar2 default hr_api.g_varchar2,
1045: p_attribute15 in varchar2 default hr_api.g_varchar2,
1046: p_attribute16 in varchar2 default hr_api.g_varchar2,
1039: p_attribute9 in varchar2 default hr_api.g_varchar2,
1040: p_attribute10 in varchar2 default hr_api.g_varchar2,
1041: p_attribute11 in varchar2 default hr_api.g_varchar2,
1042: p_attribute12 in varchar2 default hr_api.g_varchar2,
1043: p_attribute13 in varchar2 default hr_api.g_varchar2,
1044: p_attribute14 in varchar2 default hr_api.g_varchar2,
1045: p_attribute15 in varchar2 default hr_api.g_varchar2,
1046: p_attribute16 in varchar2 default hr_api.g_varchar2,
1047: p_attribute17 in varchar2 default hr_api.g_varchar2,
1040: p_attribute10 in varchar2 default hr_api.g_varchar2,
1041: p_attribute11 in varchar2 default hr_api.g_varchar2,
1042: p_attribute12 in varchar2 default hr_api.g_varchar2,
1043: p_attribute13 in varchar2 default hr_api.g_varchar2,
1044: p_attribute14 in varchar2 default hr_api.g_varchar2,
1045: p_attribute15 in varchar2 default hr_api.g_varchar2,
1046: p_attribute16 in varchar2 default hr_api.g_varchar2,
1047: p_attribute17 in varchar2 default hr_api.g_varchar2,
1048: p_attribute18 in varchar2 default hr_api.g_varchar2,
1041: p_attribute11 in varchar2 default hr_api.g_varchar2,
1042: p_attribute12 in varchar2 default hr_api.g_varchar2,
1043: p_attribute13 in varchar2 default hr_api.g_varchar2,
1044: p_attribute14 in varchar2 default hr_api.g_varchar2,
1045: p_attribute15 in varchar2 default hr_api.g_varchar2,
1046: p_attribute16 in varchar2 default hr_api.g_varchar2,
1047: p_attribute17 in varchar2 default hr_api.g_varchar2,
1048: p_attribute18 in varchar2 default hr_api.g_varchar2,
1049: p_attribute19 in varchar2 default hr_api.g_varchar2,
1042: p_attribute12 in varchar2 default hr_api.g_varchar2,
1043: p_attribute13 in varchar2 default hr_api.g_varchar2,
1044: p_attribute14 in varchar2 default hr_api.g_varchar2,
1045: p_attribute15 in varchar2 default hr_api.g_varchar2,
1046: p_attribute16 in varchar2 default hr_api.g_varchar2,
1047: p_attribute17 in varchar2 default hr_api.g_varchar2,
1048: p_attribute18 in varchar2 default hr_api.g_varchar2,
1049: p_attribute19 in varchar2 default hr_api.g_varchar2,
1050: p_attribute20 in varchar2 default hr_api.g_varchar2,
1043: p_attribute13 in varchar2 default hr_api.g_varchar2,
1044: p_attribute14 in varchar2 default hr_api.g_varchar2,
1045: p_attribute15 in varchar2 default hr_api.g_varchar2,
1046: p_attribute16 in varchar2 default hr_api.g_varchar2,
1047: p_attribute17 in varchar2 default hr_api.g_varchar2,
1048: p_attribute18 in varchar2 default hr_api.g_varchar2,
1049: p_attribute19 in varchar2 default hr_api.g_varchar2,
1050: p_attribute20 in varchar2 default hr_api.g_varchar2,
1051: p_attribute21 in varchar2 default hr_api.g_varchar2,
1044: p_attribute14 in varchar2 default hr_api.g_varchar2,
1045: p_attribute15 in varchar2 default hr_api.g_varchar2,
1046: p_attribute16 in varchar2 default hr_api.g_varchar2,
1047: p_attribute17 in varchar2 default hr_api.g_varchar2,
1048: p_attribute18 in varchar2 default hr_api.g_varchar2,
1049: p_attribute19 in varchar2 default hr_api.g_varchar2,
1050: p_attribute20 in varchar2 default hr_api.g_varchar2,
1051: p_attribute21 in varchar2 default hr_api.g_varchar2,
1052: p_attribute22 in varchar2 default hr_api.g_varchar2,
1045: p_attribute15 in varchar2 default hr_api.g_varchar2,
1046: p_attribute16 in varchar2 default hr_api.g_varchar2,
1047: p_attribute17 in varchar2 default hr_api.g_varchar2,
1048: p_attribute18 in varchar2 default hr_api.g_varchar2,
1049: p_attribute19 in varchar2 default hr_api.g_varchar2,
1050: p_attribute20 in varchar2 default hr_api.g_varchar2,
1051: p_attribute21 in varchar2 default hr_api.g_varchar2,
1052: p_attribute22 in varchar2 default hr_api.g_varchar2,
1053: p_attribute23 in varchar2 default hr_api.g_varchar2,
1046: p_attribute16 in varchar2 default hr_api.g_varchar2,
1047: p_attribute17 in varchar2 default hr_api.g_varchar2,
1048: p_attribute18 in varchar2 default hr_api.g_varchar2,
1049: p_attribute19 in varchar2 default hr_api.g_varchar2,
1050: p_attribute20 in varchar2 default hr_api.g_varchar2,
1051: p_attribute21 in varchar2 default hr_api.g_varchar2,
1052: p_attribute22 in varchar2 default hr_api.g_varchar2,
1053: p_attribute23 in varchar2 default hr_api.g_varchar2,
1054: p_attribute24 in varchar2 default hr_api.g_varchar2,
1047: p_attribute17 in varchar2 default hr_api.g_varchar2,
1048: p_attribute18 in varchar2 default hr_api.g_varchar2,
1049: p_attribute19 in varchar2 default hr_api.g_varchar2,
1050: p_attribute20 in varchar2 default hr_api.g_varchar2,
1051: p_attribute21 in varchar2 default hr_api.g_varchar2,
1052: p_attribute22 in varchar2 default hr_api.g_varchar2,
1053: p_attribute23 in varchar2 default hr_api.g_varchar2,
1054: p_attribute24 in varchar2 default hr_api.g_varchar2,
1055: p_attribute25 in varchar2 default hr_api.g_varchar2,
1048: p_attribute18 in varchar2 default hr_api.g_varchar2,
1049: p_attribute19 in varchar2 default hr_api.g_varchar2,
1050: p_attribute20 in varchar2 default hr_api.g_varchar2,
1051: p_attribute21 in varchar2 default hr_api.g_varchar2,
1052: p_attribute22 in varchar2 default hr_api.g_varchar2,
1053: p_attribute23 in varchar2 default hr_api.g_varchar2,
1054: p_attribute24 in varchar2 default hr_api.g_varchar2,
1055: p_attribute25 in varchar2 default hr_api.g_varchar2,
1056: p_attribute26 in varchar2 default hr_api.g_varchar2,
1049: p_attribute19 in varchar2 default hr_api.g_varchar2,
1050: p_attribute20 in varchar2 default hr_api.g_varchar2,
1051: p_attribute21 in varchar2 default hr_api.g_varchar2,
1052: p_attribute22 in varchar2 default hr_api.g_varchar2,
1053: p_attribute23 in varchar2 default hr_api.g_varchar2,
1054: p_attribute24 in varchar2 default hr_api.g_varchar2,
1055: p_attribute25 in varchar2 default hr_api.g_varchar2,
1056: p_attribute26 in varchar2 default hr_api.g_varchar2,
1057: p_attribute27 in varchar2 default hr_api.g_varchar2,
1050: p_attribute20 in varchar2 default hr_api.g_varchar2,
1051: p_attribute21 in varchar2 default hr_api.g_varchar2,
1052: p_attribute22 in varchar2 default hr_api.g_varchar2,
1053: p_attribute23 in varchar2 default hr_api.g_varchar2,
1054: p_attribute24 in varchar2 default hr_api.g_varchar2,
1055: p_attribute25 in varchar2 default hr_api.g_varchar2,
1056: p_attribute26 in varchar2 default hr_api.g_varchar2,
1057: p_attribute27 in varchar2 default hr_api.g_varchar2,
1058: p_attribute28 in varchar2 default hr_api.g_varchar2,
1051: p_attribute21 in varchar2 default hr_api.g_varchar2,
1052: p_attribute22 in varchar2 default hr_api.g_varchar2,
1053: p_attribute23 in varchar2 default hr_api.g_varchar2,
1054: p_attribute24 in varchar2 default hr_api.g_varchar2,
1055: p_attribute25 in varchar2 default hr_api.g_varchar2,
1056: p_attribute26 in varchar2 default hr_api.g_varchar2,
1057: p_attribute27 in varchar2 default hr_api.g_varchar2,
1058: p_attribute28 in varchar2 default hr_api.g_varchar2,
1059: p_attribute29 in varchar2 default hr_api.g_varchar2,
1052: p_attribute22 in varchar2 default hr_api.g_varchar2,
1053: p_attribute23 in varchar2 default hr_api.g_varchar2,
1054: p_attribute24 in varchar2 default hr_api.g_varchar2,
1055: p_attribute25 in varchar2 default hr_api.g_varchar2,
1056: p_attribute26 in varchar2 default hr_api.g_varchar2,
1057: p_attribute27 in varchar2 default hr_api.g_varchar2,
1058: p_attribute28 in varchar2 default hr_api.g_varchar2,
1059: p_attribute29 in varchar2 default hr_api.g_varchar2,
1060: p_attribute30 in varchar2 default hr_api.g_varchar2,
1053: p_attribute23 in varchar2 default hr_api.g_varchar2,
1054: p_attribute24 in varchar2 default hr_api.g_varchar2,
1055: p_attribute25 in varchar2 default hr_api.g_varchar2,
1056: p_attribute26 in varchar2 default hr_api.g_varchar2,
1057: p_attribute27 in varchar2 default hr_api.g_varchar2,
1058: p_attribute28 in varchar2 default hr_api.g_varchar2,
1059: p_attribute29 in varchar2 default hr_api.g_varchar2,
1060: p_attribute30 in varchar2 default hr_api.g_varchar2,
1061: p_sta_information_category in varchar2 default hr_api.g_varchar2,
1054: p_attribute24 in varchar2 default hr_api.g_varchar2,
1055: p_attribute25 in varchar2 default hr_api.g_varchar2,
1056: p_attribute26 in varchar2 default hr_api.g_varchar2,
1057: p_attribute27 in varchar2 default hr_api.g_varchar2,
1058: p_attribute28 in varchar2 default hr_api.g_varchar2,
1059: p_attribute29 in varchar2 default hr_api.g_varchar2,
1060: p_attribute30 in varchar2 default hr_api.g_varchar2,
1061: p_sta_information_category in varchar2 default hr_api.g_varchar2,
1062: p_sta_information1 in varchar2 default hr_api.g_varchar2,
1055: p_attribute25 in varchar2 default hr_api.g_varchar2,
1056: p_attribute26 in varchar2 default hr_api.g_varchar2,
1057: p_attribute27 in varchar2 default hr_api.g_varchar2,
1058: p_attribute28 in varchar2 default hr_api.g_varchar2,
1059: p_attribute29 in varchar2 default hr_api.g_varchar2,
1060: p_attribute30 in varchar2 default hr_api.g_varchar2,
1061: p_sta_information_category in varchar2 default hr_api.g_varchar2,
1062: p_sta_information1 in varchar2 default hr_api.g_varchar2,
1063: p_sta_information2 in varchar2 default hr_api.g_varchar2,
1056: p_attribute26 in varchar2 default hr_api.g_varchar2,
1057: p_attribute27 in varchar2 default hr_api.g_varchar2,
1058: p_attribute28 in varchar2 default hr_api.g_varchar2,
1059: p_attribute29 in varchar2 default hr_api.g_varchar2,
1060: p_attribute30 in varchar2 default hr_api.g_varchar2,
1061: p_sta_information_category in varchar2 default hr_api.g_varchar2,
1062: p_sta_information1 in varchar2 default hr_api.g_varchar2,
1063: p_sta_information2 in varchar2 default hr_api.g_varchar2,
1064: p_sta_information3 in varchar2 default hr_api.g_varchar2,
1057: p_attribute27 in varchar2 default hr_api.g_varchar2,
1058: p_attribute28 in varchar2 default hr_api.g_varchar2,
1059: p_attribute29 in varchar2 default hr_api.g_varchar2,
1060: p_attribute30 in varchar2 default hr_api.g_varchar2,
1061: p_sta_information_category in varchar2 default hr_api.g_varchar2,
1062: p_sta_information1 in varchar2 default hr_api.g_varchar2,
1063: p_sta_information2 in varchar2 default hr_api.g_varchar2,
1064: p_sta_information3 in varchar2 default hr_api.g_varchar2,
1065: p_sta_information4 in varchar2 default hr_api.g_varchar2,
1058: p_attribute28 in varchar2 default hr_api.g_varchar2,
1059: p_attribute29 in varchar2 default hr_api.g_varchar2,
1060: p_attribute30 in varchar2 default hr_api.g_varchar2,
1061: p_sta_information_category in varchar2 default hr_api.g_varchar2,
1062: p_sta_information1 in varchar2 default hr_api.g_varchar2,
1063: p_sta_information2 in varchar2 default hr_api.g_varchar2,
1064: p_sta_information3 in varchar2 default hr_api.g_varchar2,
1065: p_sta_information4 in varchar2 default hr_api.g_varchar2,
1066: p_sta_information5 in varchar2 default hr_api.g_varchar2,
1059: p_attribute29 in varchar2 default hr_api.g_varchar2,
1060: p_attribute30 in varchar2 default hr_api.g_varchar2,
1061: p_sta_information_category in varchar2 default hr_api.g_varchar2,
1062: p_sta_information1 in varchar2 default hr_api.g_varchar2,
1063: p_sta_information2 in varchar2 default hr_api.g_varchar2,
1064: p_sta_information3 in varchar2 default hr_api.g_varchar2,
1065: p_sta_information4 in varchar2 default hr_api.g_varchar2,
1066: p_sta_information5 in varchar2 default hr_api.g_varchar2,
1067: p_sta_information6 in varchar2 default hr_api.g_varchar2,
1060: p_attribute30 in varchar2 default hr_api.g_varchar2,
1061: p_sta_information_category in varchar2 default hr_api.g_varchar2,
1062: p_sta_information1 in varchar2 default hr_api.g_varchar2,
1063: p_sta_information2 in varchar2 default hr_api.g_varchar2,
1064: p_sta_information3 in varchar2 default hr_api.g_varchar2,
1065: p_sta_information4 in varchar2 default hr_api.g_varchar2,
1066: p_sta_information5 in varchar2 default hr_api.g_varchar2,
1067: p_sta_information6 in varchar2 default hr_api.g_varchar2,
1068: p_sta_information7 in varchar2 default hr_api.g_varchar2,
1061: p_sta_information_category in varchar2 default hr_api.g_varchar2,
1062: p_sta_information1 in varchar2 default hr_api.g_varchar2,
1063: p_sta_information2 in varchar2 default hr_api.g_varchar2,
1064: p_sta_information3 in varchar2 default hr_api.g_varchar2,
1065: p_sta_information4 in varchar2 default hr_api.g_varchar2,
1066: p_sta_information5 in varchar2 default hr_api.g_varchar2,
1067: p_sta_information6 in varchar2 default hr_api.g_varchar2,
1068: p_sta_information7 in varchar2 default hr_api.g_varchar2,
1069: p_sta_information8 in varchar2 default hr_api.g_varchar2,
1062: p_sta_information1 in varchar2 default hr_api.g_varchar2,
1063: p_sta_information2 in varchar2 default hr_api.g_varchar2,
1064: p_sta_information3 in varchar2 default hr_api.g_varchar2,
1065: p_sta_information4 in varchar2 default hr_api.g_varchar2,
1066: p_sta_information5 in varchar2 default hr_api.g_varchar2,
1067: p_sta_information6 in varchar2 default hr_api.g_varchar2,
1068: p_sta_information7 in varchar2 default hr_api.g_varchar2,
1069: p_sta_information8 in varchar2 default hr_api.g_varchar2,
1070: p_sta_information9 in varchar2 default hr_api.g_varchar2,
1063: p_sta_information2 in varchar2 default hr_api.g_varchar2,
1064: p_sta_information3 in varchar2 default hr_api.g_varchar2,
1065: p_sta_information4 in varchar2 default hr_api.g_varchar2,
1066: p_sta_information5 in varchar2 default hr_api.g_varchar2,
1067: p_sta_information6 in varchar2 default hr_api.g_varchar2,
1068: p_sta_information7 in varchar2 default hr_api.g_varchar2,
1069: p_sta_information8 in varchar2 default hr_api.g_varchar2,
1070: p_sta_information9 in varchar2 default hr_api.g_varchar2,
1071: p_sta_information10 in varchar2 default hr_api.g_varchar2,
1064: p_sta_information3 in varchar2 default hr_api.g_varchar2,
1065: p_sta_information4 in varchar2 default hr_api.g_varchar2,
1066: p_sta_information5 in varchar2 default hr_api.g_varchar2,
1067: p_sta_information6 in varchar2 default hr_api.g_varchar2,
1068: p_sta_information7 in varchar2 default hr_api.g_varchar2,
1069: p_sta_information8 in varchar2 default hr_api.g_varchar2,
1070: p_sta_information9 in varchar2 default hr_api.g_varchar2,
1071: p_sta_information10 in varchar2 default hr_api.g_varchar2,
1072: p_sta_information11 in varchar2 default hr_api.g_varchar2,
1065: p_sta_information4 in varchar2 default hr_api.g_varchar2,
1066: p_sta_information5 in varchar2 default hr_api.g_varchar2,
1067: p_sta_information6 in varchar2 default hr_api.g_varchar2,
1068: p_sta_information7 in varchar2 default hr_api.g_varchar2,
1069: p_sta_information8 in varchar2 default hr_api.g_varchar2,
1070: p_sta_information9 in varchar2 default hr_api.g_varchar2,
1071: p_sta_information10 in varchar2 default hr_api.g_varchar2,
1072: p_sta_information11 in varchar2 default hr_api.g_varchar2,
1073: p_sta_information12 in varchar2 default hr_api.g_varchar2,
1066: p_sta_information5 in varchar2 default hr_api.g_varchar2,
1067: p_sta_information6 in varchar2 default hr_api.g_varchar2,
1068: p_sta_information7 in varchar2 default hr_api.g_varchar2,
1069: p_sta_information8 in varchar2 default hr_api.g_varchar2,
1070: p_sta_information9 in varchar2 default hr_api.g_varchar2,
1071: p_sta_information10 in varchar2 default hr_api.g_varchar2,
1072: p_sta_information11 in varchar2 default hr_api.g_varchar2,
1073: p_sta_information12 in varchar2 default hr_api.g_varchar2,
1074: p_sta_information13 in varchar2 default hr_api.g_varchar2,
1067: p_sta_information6 in varchar2 default hr_api.g_varchar2,
1068: p_sta_information7 in varchar2 default hr_api.g_varchar2,
1069: p_sta_information8 in varchar2 default hr_api.g_varchar2,
1070: p_sta_information9 in varchar2 default hr_api.g_varchar2,
1071: p_sta_information10 in varchar2 default hr_api.g_varchar2,
1072: p_sta_information11 in varchar2 default hr_api.g_varchar2,
1073: p_sta_information12 in varchar2 default hr_api.g_varchar2,
1074: p_sta_information13 in varchar2 default hr_api.g_varchar2,
1075: p_sta_information14 in varchar2 default hr_api.g_varchar2,
1068: p_sta_information7 in varchar2 default hr_api.g_varchar2,
1069: p_sta_information8 in varchar2 default hr_api.g_varchar2,
1070: p_sta_information9 in varchar2 default hr_api.g_varchar2,
1071: p_sta_information10 in varchar2 default hr_api.g_varchar2,
1072: p_sta_information11 in varchar2 default hr_api.g_varchar2,
1073: p_sta_information12 in varchar2 default hr_api.g_varchar2,
1074: p_sta_information13 in varchar2 default hr_api.g_varchar2,
1075: p_sta_information14 in varchar2 default hr_api.g_varchar2,
1076: p_sta_information15 in varchar2 default hr_api.g_varchar2,
1069: p_sta_information8 in varchar2 default hr_api.g_varchar2,
1070: p_sta_information9 in varchar2 default hr_api.g_varchar2,
1071: p_sta_information10 in varchar2 default hr_api.g_varchar2,
1072: p_sta_information11 in varchar2 default hr_api.g_varchar2,
1073: p_sta_information12 in varchar2 default hr_api.g_varchar2,
1074: p_sta_information13 in varchar2 default hr_api.g_varchar2,
1075: p_sta_information14 in varchar2 default hr_api.g_varchar2,
1076: p_sta_information15 in varchar2 default hr_api.g_varchar2,
1077: p_sta_information16 in varchar2 default hr_api.g_varchar2,
1070: p_sta_information9 in varchar2 default hr_api.g_varchar2,
1071: p_sta_information10 in varchar2 default hr_api.g_varchar2,
1072: p_sta_information11 in varchar2 default hr_api.g_varchar2,
1073: p_sta_information12 in varchar2 default hr_api.g_varchar2,
1074: p_sta_information13 in varchar2 default hr_api.g_varchar2,
1075: p_sta_information14 in varchar2 default hr_api.g_varchar2,
1076: p_sta_information15 in varchar2 default hr_api.g_varchar2,
1077: p_sta_information16 in varchar2 default hr_api.g_varchar2,
1078: p_sta_information17 in varchar2 default hr_api.g_varchar2,
1071: p_sta_information10 in varchar2 default hr_api.g_varchar2,
1072: p_sta_information11 in varchar2 default hr_api.g_varchar2,
1073: p_sta_information12 in varchar2 default hr_api.g_varchar2,
1074: p_sta_information13 in varchar2 default hr_api.g_varchar2,
1075: p_sta_information14 in varchar2 default hr_api.g_varchar2,
1076: p_sta_information15 in varchar2 default hr_api.g_varchar2,
1077: p_sta_information16 in varchar2 default hr_api.g_varchar2,
1078: p_sta_information17 in varchar2 default hr_api.g_varchar2,
1079: p_sta_information18 in varchar2 default hr_api.g_varchar2,
1072: p_sta_information11 in varchar2 default hr_api.g_varchar2,
1073: p_sta_information12 in varchar2 default hr_api.g_varchar2,
1074: p_sta_information13 in varchar2 default hr_api.g_varchar2,
1075: p_sta_information14 in varchar2 default hr_api.g_varchar2,
1076: p_sta_information15 in varchar2 default hr_api.g_varchar2,
1077: p_sta_information16 in varchar2 default hr_api.g_varchar2,
1078: p_sta_information17 in varchar2 default hr_api.g_varchar2,
1079: p_sta_information18 in varchar2 default hr_api.g_varchar2,
1080: p_sta_information19 in varchar2 default hr_api.g_varchar2,
1073: p_sta_information12 in varchar2 default hr_api.g_varchar2,
1074: p_sta_information13 in varchar2 default hr_api.g_varchar2,
1075: p_sta_information14 in varchar2 default hr_api.g_varchar2,
1076: p_sta_information15 in varchar2 default hr_api.g_varchar2,
1077: p_sta_information16 in varchar2 default hr_api.g_varchar2,
1078: p_sta_information17 in varchar2 default hr_api.g_varchar2,
1079: p_sta_information18 in varchar2 default hr_api.g_varchar2,
1080: p_sta_information19 in varchar2 default hr_api.g_varchar2,
1081: p_sta_information20 in varchar2 default hr_api.g_varchar2,
1074: p_sta_information13 in varchar2 default hr_api.g_varchar2,
1075: p_sta_information14 in varchar2 default hr_api.g_varchar2,
1076: p_sta_information15 in varchar2 default hr_api.g_varchar2,
1077: p_sta_information16 in varchar2 default hr_api.g_varchar2,
1078: p_sta_information17 in varchar2 default hr_api.g_varchar2,
1079: p_sta_information18 in varchar2 default hr_api.g_varchar2,
1080: p_sta_information19 in varchar2 default hr_api.g_varchar2,
1081: p_sta_information20 in varchar2 default hr_api.g_varchar2,
1082: p_sta_information21 in varchar2 default hr_api.g_varchar2,
1075: p_sta_information14 in varchar2 default hr_api.g_varchar2,
1076: p_sta_information15 in varchar2 default hr_api.g_varchar2,
1077: p_sta_information16 in varchar2 default hr_api.g_varchar2,
1078: p_sta_information17 in varchar2 default hr_api.g_varchar2,
1079: p_sta_information18 in varchar2 default hr_api.g_varchar2,
1080: p_sta_information19 in varchar2 default hr_api.g_varchar2,
1081: p_sta_information20 in varchar2 default hr_api.g_varchar2,
1082: p_sta_information21 in varchar2 default hr_api.g_varchar2,
1083: p_sta_information22 in varchar2 default hr_api.g_varchar2,
1076: p_sta_information15 in varchar2 default hr_api.g_varchar2,
1077: p_sta_information16 in varchar2 default hr_api.g_varchar2,
1078: p_sta_information17 in varchar2 default hr_api.g_varchar2,
1079: p_sta_information18 in varchar2 default hr_api.g_varchar2,
1080: p_sta_information19 in varchar2 default hr_api.g_varchar2,
1081: p_sta_information20 in varchar2 default hr_api.g_varchar2,
1082: p_sta_information21 in varchar2 default hr_api.g_varchar2,
1083: p_sta_information22 in varchar2 default hr_api.g_varchar2,
1084: p_sta_information23 in varchar2 default hr_api.g_varchar2,
1077: p_sta_information16 in varchar2 default hr_api.g_varchar2,
1078: p_sta_information17 in varchar2 default hr_api.g_varchar2,
1079: p_sta_information18 in varchar2 default hr_api.g_varchar2,
1080: p_sta_information19 in varchar2 default hr_api.g_varchar2,
1081: p_sta_information20 in varchar2 default hr_api.g_varchar2,
1082: p_sta_information21 in varchar2 default hr_api.g_varchar2,
1083: p_sta_information22 in varchar2 default hr_api.g_varchar2,
1084: p_sta_information23 in varchar2 default hr_api.g_varchar2,
1085: p_sta_information24 in varchar2 default hr_api.g_varchar2,
1078: p_sta_information17 in varchar2 default hr_api.g_varchar2,
1079: p_sta_information18 in varchar2 default hr_api.g_varchar2,
1080: p_sta_information19 in varchar2 default hr_api.g_varchar2,
1081: p_sta_information20 in varchar2 default hr_api.g_varchar2,
1082: p_sta_information21 in varchar2 default hr_api.g_varchar2,
1083: p_sta_information22 in varchar2 default hr_api.g_varchar2,
1084: p_sta_information23 in varchar2 default hr_api.g_varchar2,
1085: p_sta_information24 in varchar2 default hr_api.g_varchar2,
1086: p_sta_information25 in varchar2 default hr_api.g_varchar2,
1079: p_sta_information18 in varchar2 default hr_api.g_varchar2,
1080: p_sta_information19 in varchar2 default hr_api.g_varchar2,
1081: p_sta_information20 in varchar2 default hr_api.g_varchar2,
1082: p_sta_information21 in varchar2 default hr_api.g_varchar2,
1083: p_sta_information22 in varchar2 default hr_api.g_varchar2,
1084: p_sta_information23 in varchar2 default hr_api.g_varchar2,
1085: p_sta_information24 in varchar2 default hr_api.g_varchar2,
1086: p_sta_information25 in varchar2 default hr_api.g_varchar2,
1087: p_sta_information26 in varchar2 default hr_api.g_varchar2,
1080: p_sta_information19 in varchar2 default hr_api.g_varchar2,
1081: p_sta_information20 in varchar2 default hr_api.g_varchar2,
1082: p_sta_information21 in varchar2 default hr_api.g_varchar2,
1083: p_sta_information22 in varchar2 default hr_api.g_varchar2,
1084: p_sta_information23 in varchar2 default hr_api.g_varchar2,
1085: p_sta_information24 in varchar2 default hr_api.g_varchar2,
1086: p_sta_information25 in varchar2 default hr_api.g_varchar2,
1087: p_sta_information26 in varchar2 default hr_api.g_varchar2,
1088: p_sta_information27 in varchar2 default hr_api.g_varchar2,
1081: p_sta_information20 in varchar2 default hr_api.g_varchar2,
1082: p_sta_information21 in varchar2 default hr_api.g_varchar2,
1083: p_sta_information22 in varchar2 default hr_api.g_varchar2,
1084: p_sta_information23 in varchar2 default hr_api.g_varchar2,
1085: p_sta_information24 in varchar2 default hr_api.g_varchar2,
1086: p_sta_information25 in varchar2 default hr_api.g_varchar2,
1087: p_sta_information26 in varchar2 default hr_api.g_varchar2,
1088: p_sta_information27 in varchar2 default hr_api.g_varchar2,
1089: p_sta_information28 in varchar2 default hr_api.g_varchar2,
1082: p_sta_information21 in varchar2 default hr_api.g_varchar2,
1083: p_sta_information22 in varchar2 default hr_api.g_varchar2,
1084: p_sta_information23 in varchar2 default hr_api.g_varchar2,
1085: p_sta_information24 in varchar2 default hr_api.g_varchar2,
1086: p_sta_information25 in varchar2 default hr_api.g_varchar2,
1087: p_sta_information26 in varchar2 default hr_api.g_varchar2,
1088: p_sta_information27 in varchar2 default hr_api.g_varchar2,
1089: p_sta_information28 in varchar2 default hr_api.g_varchar2,
1090: p_sta_information29 in varchar2 default hr_api.g_varchar2,
1083: p_sta_information22 in varchar2 default hr_api.g_varchar2,
1084: p_sta_information23 in varchar2 default hr_api.g_varchar2,
1085: p_sta_information24 in varchar2 default hr_api.g_varchar2,
1086: p_sta_information25 in varchar2 default hr_api.g_varchar2,
1087: p_sta_information26 in varchar2 default hr_api.g_varchar2,
1088: p_sta_information27 in varchar2 default hr_api.g_varchar2,
1089: p_sta_information28 in varchar2 default hr_api.g_varchar2,
1090: p_sta_information29 in varchar2 default hr_api.g_varchar2,
1091: p_sta_information30 in varchar2 default hr_api.g_varchar2
1084: p_sta_information23 in varchar2 default hr_api.g_varchar2,
1085: p_sta_information24 in varchar2 default hr_api.g_varchar2,
1086: p_sta_information25 in varchar2 default hr_api.g_varchar2,
1087: p_sta_information26 in varchar2 default hr_api.g_varchar2,
1088: p_sta_information27 in varchar2 default hr_api.g_varchar2,
1089: p_sta_information28 in varchar2 default hr_api.g_varchar2,
1090: p_sta_information29 in varchar2 default hr_api.g_varchar2,
1091: p_sta_information30 in varchar2 default hr_api.g_varchar2
1092: ) is
1085: p_sta_information24 in varchar2 default hr_api.g_varchar2,
1086: p_sta_information25 in varchar2 default hr_api.g_varchar2,
1087: p_sta_information26 in varchar2 default hr_api.g_varchar2,
1088: p_sta_information27 in varchar2 default hr_api.g_varchar2,
1089: p_sta_information28 in varchar2 default hr_api.g_varchar2,
1090: p_sta_information29 in varchar2 default hr_api.g_varchar2,
1091: p_sta_information30 in varchar2 default hr_api.g_varchar2
1092: ) is
1093: --
1086: p_sta_information25 in varchar2 default hr_api.g_varchar2,
1087: p_sta_information26 in varchar2 default hr_api.g_varchar2,
1088: p_sta_information27 in varchar2 default hr_api.g_varchar2,
1089: p_sta_information28 in varchar2 default hr_api.g_varchar2,
1090: p_sta_information29 in varchar2 default hr_api.g_varchar2,
1091: p_sta_information30 in varchar2 default hr_api.g_varchar2
1092: ) is
1093: --
1094: l_rec pay_sta_shd.g_rec_type;
1087: p_sta_information26 in varchar2 default hr_api.g_varchar2,
1088: p_sta_information27 in varchar2 default hr_api.g_varchar2,
1089: p_sta_information28 in varchar2 default hr_api.g_varchar2,
1090: p_sta_information29 in varchar2 default hr_api.g_varchar2,
1091: p_sta_information30 in varchar2 default hr_api.g_varchar2
1092: ) is
1093: --
1094: l_rec pay_sta_shd.g_rec_type;
1095: l_proc varchar2(72) := g_package||'upd';
1105: (
1106: p_emp_state_tax_rule_id,
1107: null,
1108: null,
1109: hr_api.g_number,
1110: hr_api.g_varchar2,
1111: hr_api.g_varchar2,
1112: hr_api.g_number,
1113: p_additional_wa_amount,
1106: p_emp_state_tax_rule_id,
1107: null,
1108: null,
1109: hr_api.g_number,
1110: hr_api.g_varchar2,
1111: hr_api.g_varchar2,
1112: hr_api.g_number,
1113: p_additional_wa_amount,
1114: p_filing_status_code,
1107: null,
1108: null,
1109: hr_api.g_number,
1110: hr_api.g_varchar2,
1111: hr_api.g_varchar2,
1112: hr_api.g_number,
1113: p_additional_wa_amount,
1114: p_filing_status_code,
1115: p_remainder_percent,
1108: null,
1109: hr_api.g_number,
1110: hr_api.g_varchar2,
1111: hr_api.g_varchar2,
1112: hr_api.g_number,
1113: p_additional_wa_amount,
1114: p_filing_status_code,
1115: p_remainder_percent,
1116: p_secondary_wa,