152: End If;
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 15);
155: Exception
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
159: pay_cft_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
156: When hr_api.check_integrity_violated Then
157: -- A check constraint has been violated
158: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
159: pay_cft_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
164: pay_cft_shd.constraint_error
157: -- A check constraint has been violated
158: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
159: pay_cft_shd.constraint_error
160: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
164: pay_cft_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
161: When hr_api.unique_integrity_violated Then
162: -- Unique integrity has been violated
163: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
164: pay_cft_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When Others Then
167: pay_cft_shd.g_api_dml := false; -- Unset the api dml status
168: Raise;
169: End dt_update_dml;
544: );
545: --
546: exception
547: --
548: when hr_api.cannot_find_prog_unit then
549: --
550: hr_api.cannot_find_prog_unit_error
551: (p_module_name => 'pay_ca_emp_fed_tax_info_f'
552: ,p_hook_type => 'AU');
546: exception
547: --
548: when hr_api.cannot_find_prog_unit then
549: --
550: hr_api.cannot_find_prog_unit_error
551: (p_module_name => 'pay_ca_emp_fed_tax_info_f'
552: ,p_hook_type => 'AU');
553: --
554: end;
615: -- p_rec plsql record structure
616: -- to see if a system default is being used. If a system default
617: -- is being used then we must set to the 'current' argument value.
618: --
619: If (p_rec.legislation_code = hr_api.g_varchar2) then
620: p_rec.legislation_code :=
621: pay_cft_shd.g_old_rec.legislation_code;
622: End If;
623: If (p_rec.assignment_id = hr_api.g_number) then
619: If (p_rec.legislation_code = hr_api.g_varchar2) then
620: p_rec.legislation_code :=
621: pay_cft_shd.g_old_rec.legislation_code;
622: End If;
623: If (p_rec.assignment_id = hr_api.g_number) then
624: p_rec.assignment_id :=
625: pay_cft_shd.g_old_rec.assignment_id;
626: End If;
627: If (p_rec.business_group_id = hr_api.g_number) then
623: If (p_rec.assignment_id = hr_api.g_number) then
624: p_rec.assignment_id :=
625: pay_cft_shd.g_old_rec.assignment_id;
626: End If;
627: If (p_rec.business_group_id = hr_api.g_number) then
628: p_rec.business_group_id :=
629: pay_cft_shd.g_old_rec.business_group_id;
630: End If;
631: If (p_rec.employment_province = hr_api.g_varchar2) then
627: If (p_rec.business_group_id = hr_api.g_number) then
628: p_rec.business_group_id :=
629: pay_cft_shd.g_old_rec.business_group_id;
630: End If;
631: If (p_rec.employment_province = hr_api.g_varchar2) then
632: p_rec.employment_province :=
633: pay_cft_shd.g_old_rec.employment_province;
634: End If;
635: If (p_rec.tax_credit_amount = hr_api.g_number) then
631: If (p_rec.employment_province = hr_api.g_varchar2) then
632: p_rec.employment_province :=
633: pay_cft_shd.g_old_rec.employment_province;
634: End If;
635: If (p_rec.tax_credit_amount = hr_api.g_number) then
636: p_rec.tax_credit_amount :=
637: pay_cft_shd.g_old_rec.tax_credit_amount;
638: End If;
639: If (p_rec.claim_code = hr_api.g_varchar2) then
635: If (p_rec.tax_credit_amount = hr_api.g_number) then
636: p_rec.tax_credit_amount :=
637: pay_cft_shd.g_old_rec.tax_credit_amount;
638: End If;
639: If (p_rec.claim_code = hr_api.g_varchar2) then
640: p_rec.claim_code :=
641: pay_cft_shd.g_old_rec.claim_code;
642: End If;
643: If (p_rec.basic_exemption_flag = hr_api.g_varchar2) then
639: If (p_rec.claim_code = hr_api.g_varchar2) then
640: p_rec.claim_code :=
641: pay_cft_shd.g_old_rec.claim_code;
642: End If;
643: If (p_rec.basic_exemption_flag = hr_api.g_varchar2) then
644: p_rec.basic_exemption_flag :=
645: pay_cft_shd.g_old_rec.basic_exemption_flag;
646: End If;
647: If (p_rec.additional_tax = hr_api.g_number) then
643: If (p_rec.basic_exemption_flag = hr_api.g_varchar2) then
644: p_rec.basic_exemption_flag :=
645: pay_cft_shd.g_old_rec.basic_exemption_flag;
646: End If;
647: If (p_rec.additional_tax = hr_api.g_number) then
648: p_rec.additional_tax :=
649: pay_cft_shd.g_old_rec.additional_tax;
650: End If;
651: If (p_rec.annual_dedn = hr_api.g_number) then
647: If (p_rec.additional_tax = hr_api.g_number) then
648: p_rec.additional_tax :=
649: pay_cft_shd.g_old_rec.additional_tax;
650: End If;
651: If (p_rec.annual_dedn = hr_api.g_number) then
652: p_rec.annual_dedn :=
653: pay_cft_shd.g_old_rec.annual_dedn;
654: End If;
655: If (p_rec.total_expense_by_commission = hr_api.g_number) then
651: If (p_rec.annual_dedn = hr_api.g_number) then
652: p_rec.annual_dedn :=
653: pay_cft_shd.g_old_rec.annual_dedn;
654: End If;
655: If (p_rec.total_expense_by_commission = hr_api.g_number) then
656: p_rec.total_expense_by_commission :=
657: pay_cft_shd.g_old_rec.total_expense_by_commission;
658: End If;
659: If (p_rec.total_remnrtn_by_commission = hr_api.g_number) then
655: If (p_rec.total_expense_by_commission = hr_api.g_number) then
656: p_rec.total_expense_by_commission :=
657: pay_cft_shd.g_old_rec.total_expense_by_commission;
658: End If;
659: If (p_rec.total_remnrtn_by_commission = hr_api.g_number) then
660: p_rec.total_remnrtn_by_commission :=
661: pay_cft_shd.g_old_rec.total_remnrtn_by_commission;
662: End If;
663: If (p_rec.prescribed_zone_dedn_amt = hr_api.g_number) then
659: If (p_rec.total_remnrtn_by_commission = hr_api.g_number) then
660: p_rec.total_remnrtn_by_commission :=
661: pay_cft_shd.g_old_rec.total_remnrtn_by_commission;
662: End If;
663: If (p_rec.prescribed_zone_dedn_amt = hr_api.g_number) then
664: p_rec.prescribed_zone_dedn_amt :=
665: pay_cft_shd.g_old_rec.prescribed_zone_dedn_amt;
666: End If;
667: If (p_rec.other_fedtax_credits = hr_api.g_varchar2) then
663: If (p_rec.prescribed_zone_dedn_amt = hr_api.g_number) then
664: p_rec.prescribed_zone_dedn_amt :=
665: pay_cft_shd.g_old_rec.prescribed_zone_dedn_amt;
666: End If;
667: If (p_rec.other_fedtax_credits = hr_api.g_varchar2) then
668: p_rec.other_fedtax_credits :=
669: pay_cft_shd.g_old_rec.other_fedtax_credits;
670: End If;
671: If (p_rec.cpp_qpp_exempt_flag = hr_api.g_varchar2) then
667: If (p_rec.other_fedtax_credits = hr_api.g_varchar2) then
668: p_rec.other_fedtax_credits :=
669: pay_cft_shd.g_old_rec.other_fedtax_credits;
670: End If;
671: If (p_rec.cpp_qpp_exempt_flag = hr_api.g_varchar2) then
672: p_rec.cpp_qpp_exempt_flag :=
673: pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag;
674: End If;
675: If (p_rec.fed_exempt_flag = hr_api.g_varchar2) then
671: If (p_rec.cpp_qpp_exempt_flag = hr_api.g_varchar2) then
672: p_rec.cpp_qpp_exempt_flag :=
673: pay_cft_shd.g_old_rec.cpp_qpp_exempt_flag;
674: End If;
675: If (p_rec.fed_exempt_flag = hr_api.g_varchar2) then
676: p_rec.fed_exempt_flag :=
677: pay_cft_shd.g_old_rec.fed_exempt_flag;
678: End If;
679: If (p_rec.ei_exempt_flag = hr_api.g_varchar2) then
675: If (p_rec.fed_exempt_flag = hr_api.g_varchar2) then
676: p_rec.fed_exempt_flag :=
677: pay_cft_shd.g_old_rec.fed_exempt_flag;
678: End If;
679: If (p_rec.ei_exempt_flag = hr_api.g_varchar2) then
680: p_rec.ei_exempt_flag :=
681: pay_cft_shd.g_old_rec.ei_exempt_flag;
682: End If;
683: If (p_rec.tax_calc_method = hr_api.g_varchar2) then
679: If (p_rec.ei_exempt_flag = hr_api.g_varchar2) then
680: p_rec.ei_exempt_flag :=
681: pay_cft_shd.g_old_rec.ei_exempt_flag;
682: End If;
683: If (p_rec.tax_calc_method = hr_api.g_varchar2) then
684: p_rec.tax_calc_method :=
685: pay_cft_shd.g_old_rec.tax_calc_method;
686: End If;
687: If (p_rec.fed_override_amount = hr_api.g_number) then
683: If (p_rec.tax_calc_method = hr_api.g_varchar2) then
684: p_rec.tax_calc_method :=
685: pay_cft_shd.g_old_rec.tax_calc_method;
686: End If;
687: If (p_rec.fed_override_amount = hr_api.g_number) then
688: p_rec.fed_override_amount :=
689: pay_cft_shd.g_old_rec.fed_override_amount;
690: End If;
691: If (p_rec.fed_override_rate = hr_api.g_number) then
687: If (p_rec.fed_override_amount = hr_api.g_number) then
688: p_rec.fed_override_amount :=
689: pay_cft_shd.g_old_rec.fed_override_amount;
690: End If;
691: If (p_rec.fed_override_rate = hr_api.g_number) then
692: p_rec.fed_override_rate :=
693: pay_cft_shd.g_old_rec.fed_override_rate;
694: End If;
695: If (p_rec.ca_tax_information_category = hr_api.g_varchar2) then
691: If (p_rec.fed_override_rate = hr_api.g_number) then
692: p_rec.fed_override_rate :=
693: pay_cft_shd.g_old_rec.fed_override_rate;
694: End If;
695: If (p_rec.ca_tax_information_category = hr_api.g_varchar2) then
696: p_rec.ca_tax_information_category :=
697: pay_cft_shd.g_old_rec.ca_tax_information_category;
698: End If;
699: If (p_rec.ca_tax_information1 = hr_api.g_varchar2) then
695: If (p_rec.ca_tax_information_category = hr_api.g_varchar2) then
696: p_rec.ca_tax_information_category :=
697: pay_cft_shd.g_old_rec.ca_tax_information_category;
698: End If;
699: If (p_rec.ca_tax_information1 = hr_api.g_varchar2) then
700: p_rec.ca_tax_information1 :=
701: pay_cft_shd.g_old_rec.ca_tax_information1;
702: End If;
703: If (p_rec.ca_tax_information2 = hr_api.g_varchar2) then
699: If (p_rec.ca_tax_information1 = hr_api.g_varchar2) then
700: p_rec.ca_tax_information1 :=
701: pay_cft_shd.g_old_rec.ca_tax_information1;
702: End If;
703: If (p_rec.ca_tax_information2 = hr_api.g_varchar2) then
704: p_rec.ca_tax_information2 :=
705: pay_cft_shd.g_old_rec.ca_tax_information2;
706: End If;
707: If (p_rec.ca_tax_information3 = hr_api.g_varchar2) then
703: If (p_rec.ca_tax_information2 = hr_api.g_varchar2) then
704: p_rec.ca_tax_information2 :=
705: pay_cft_shd.g_old_rec.ca_tax_information2;
706: End If;
707: If (p_rec.ca_tax_information3 = hr_api.g_varchar2) then
708: p_rec.ca_tax_information3 :=
709: pay_cft_shd.g_old_rec.ca_tax_information3;
710: End If;
711: If (p_rec.ca_tax_information4 = hr_api.g_varchar2) then
707: If (p_rec.ca_tax_information3 = hr_api.g_varchar2) then
708: p_rec.ca_tax_information3 :=
709: pay_cft_shd.g_old_rec.ca_tax_information3;
710: End If;
711: If (p_rec.ca_tax_information4 = hr_api.g_varchar2) then
712: p_rec.ca_tax_information4 :=
713: pay_cft_shd.g_old_rec.ca_tax_information4;
714: End If;
715: If (p_rec.ca_tax_information5 = hr_api.g_varchar2) then
711: If (p_rec.ca_tax_information4 = hr_api.g_varchar2) then
712: p_rec.ca_tax_information4 :=
713: pay_cft_shd.g_old_rec.ca_tax_information4;
714: End If;
715: If (p_rec.ca_tax_information5 = hr_api.g_varchar2) then
716: p_rec.ca_tax_information5 :=
717: pay_cft_shd.g_old_rec.ca_tax_information5;
718: End If;
719: If (p_rec.ca_tax_information6 = hr_api.g_varchar2) then
715: If (p_rec.ca_tax_information5 = hr_api.g_varchar2) then
716: p_rec.ca_tax_information5 :=
717: pay_cft_shd.g_old_rec.ca_tax_information5;
718: End If;
719: If (p_rec.ca_tax_information6 = hr_api.g_varchar2) then
720: p_rec.ca_tax_information6 :=
721: pay_cft_shd.g_old_rec.ca_tax_information6;
722: End If;
723: If (p_rec.ca_tax_information7 = hr_api.g_varchar2) then
719: If (p_rec.ca_tax_information6 = hr_api.g_varchar2) then
720: p_rec.ca_tax_information6 :=
721: pay_cft_shd.g_old_rec.ca_tax_information6;
722: End If;
723: If (p_rec.ca_tax_information7 = hr_api.g_varchar2) then
724: p_rec.ca_tax_information7 :=
725: pay_cft_shd.g_old_rec.ca_tax_information7;
726: End If;
727: If (p_rec.ca_tax_information8 = hr_api.g_varchar2) then
723: If (p_rec.ca_tax_information7 = hr_api.g_varchar2) then
724: p_rec.ca_tax_information7 :=
725: pay_cft_shd.g_old_rec.ca_tax_information7;
726: End If;
727: If (p_rec.ca_tax_information8 = hr_api.g_varchar2) then
728: p_rec.ca_tax_information8 :=
729: pay_cft_shd.g_old_rec.ca_tax_information8;
730: End If;
731: If (p_rec.ca_tax_information9 = hr_api.g_varchar2) then
727: If (p_rec.ca_tax_information8 = hr_api.g_varchar2) then
728: p_rec.ca_tax_information8 :=
729: pay_cft_shd.g_old_rec.ca_tax_information8;
730: End If;
731: If (p_rec.ca_tax_information9 = hr_api.g_varchar2) then
732: p_rec.ca_tax_information9 :=
733: pay_cft_shd.g_old_rec.ca_tax_information9;
734: End If;
735: If (p_rec.ca_tax_information10 = hr_api.g_varchar2) then
731: If (p_rec.ca_tax_information9 = hr_api.g_varchar2) then
732: p_rec.ca_tax_information9 :=
733: pay_cft_shd.g_old_rec.ca_tax_information9;
734: End If;
735: If (p_rec.ca_tax_information10 = hr_api.g_varchar2) then
736: p_rec.ca_tax_information10 :=
737: pay_cft_shd.g_old_rec.ca_tax_information10;
738: End If;
739: If (p_rec.ca_tax_information11 = hr_api.g_varchar2) then
735: If (p_rec.ca_tax_information10 = hr_api.g_varchar2) then
736: p_rec.ca_tax_information10 :=
737: pay_cft_shd.g_old_rec.ca_tax_information10;
738: End If;
739: If (p_rec.ca_tax_information11 = hr_api.g_varchar2) then
740: p_rec.ca_tax_information11 :=
741: pay_cft_shd.g_old_rec.ca_tax_information11;
742: End If;
743: If (p_rec.ca_tax_information12 = hr_api.g_varchar2) then
739: If (p_rec.ca_tax_information11 = hr_api.g_varchar2) then
740: p_rec.ca_tax_information11 :=
741: pay_cft_shd.g_old_rec.ca_tax_information11;
742: End If;
743: If (p_rec.ca_tax_information12 = hr_api.g_varchar2) then
744: p_rec.ca_tax_information12 :=
745: pay_cft_shd.g_old_rec.ca_tax_information12;
746: End If;
747: If (p_rec.ca_tax_information13 = hr_api.g_varchar2) then
743: If (p_rec.ca_tax_information12 = hr_api.g_varchar2) then
744: p_rec.ca_tax_information12 :=
745: pay_cft_shd.g_old_rec.ca_tax_information12;
746: End If;
747: If (p_rec.ca_tax_information13 = hr_api.g_varchar2) then
748: p_rec.ca_tax_information13 :=
749: pay_cft_shd.g_old_rec.ca_tax_information13;
750: End If;
751: If (p_rec.ca_tax_information14 = hr_api.g_varchar2) then
747: If (p_rec.ca_tax_information13 = hr_api.g_varchar2) then
748: p_rec.ca_tax_information13 :=
749: pay_cft_shd.g_old_rec.ca_tax_information13;
750: End If;
751: If (p_rec.ca_tax_information14 = hr_api.g_varchar2) then
752: p_rec.ca_tax_information14 :=
753: pay_cft_shd.g_old_rec.ca_tax_information14;
754: End If;
755: If (p_rec.ca_tax_information15 = hr_api.g_varchar2) then
751: If (p_rec.ca_tax_information14 = hr_api.g_varchar2) then
752: p_rec.ca_tax_information14 :=
753: pay_cft_shd.g_old_rec.ca_tax_information14;
754: End If;
755: If (p_rec.ca_tax_information15 = hr_api.g_varchar2) then
756: p_rec.ca_tax_information15 :=
757: pay_cft_shd.g_old_rec.ca_tax_information15;
758: End If;
759: If (p_rec.ca_tax_information16 = hr_api.g_varchar2) then
755: If (p_rec.ca_tax_information15 = hr_api.g_varchar2) then
756: p_rec.ca_tax_information15 :=
757: pay_cft_shd.g_old_rec.ca_tax_information15;
758: End If;
759: If (p_rec.ca_tax_information16 = hr_api.g_varchar2) then
760: p_rec.ca_tax_information16 :=
761: pay_cft_shd.g_old_rec.ca_tax_information16;
762: End If;
763: If (p_rec.ca_tax_information17 = hr_api.g_varchar2) then
759: If (p_rec.ca_tax_information16 = hr_api.g_varchar2) then
760: p_rec.ca_tax_information16 :=
761: pay_cft_shd.g_old_rec.ca_tax_information16;
762: End If;
763: If (p_rec.ca_tax_information17 = hr_api.g_varchar2) then
764: p_rec.ca_tax_information17 :=
765: pay_cft_shd.g_old_rec.ca_tax_information17;
766: End If;
767: If (p_rec.ca_tax_information18 = hr_api.g_varchar2) then
763: If (p_rec.ca_tax_information17 = hr_api.g_varchar2) then
764: p_rec.ca_tax_information17 :=
765: pay_cft_shd.g_old_rec.ca_tax_information17;
766: End If;
767: If (p_rec.ca_tax_information18 = hr_api.g_varchar2) then
768: p_rec.ca_tax_information18 :=
769: pay_cft_shd.g_old_rec.ca_tax_information18;
770: End If;
771: If (p_rec.ca_tax_information19 = hr_api.g_varchar2) then
767: If (p_rec.ca_tax_information18 = hr_api.g_varchar2) then
768: p_rec.ca_tax_information18 :=
769: pay_cft_shd.g_old_rec.ca_tax_information18;
770: End If;
771: If (p_rec.ca_tax_information19 = hr_api.g_varchar2) then
772: p_rec.ca_tax_information19 :=
773: pay_cft_shd.g_old_rec.ca_tax_information19;
774: End If;
775: If (p_rec.ca_tax_information20 = hr_api.g_varchar2) then
771: If (p_rec.ca_tax_information19 = hr_api.g_varchar2) then
772: p_rec.ca_tax_information19 :=
773: pay_cft_shd.g_old_rec.ca_tax_information19;
774: End If;
775: If (p_rec.ca_tax_information20 = hr_api.g_varchar2) then
776: p_rec.ca_tax_information20 :=
777: pay_cft_shd.g_old_rec.ca_tax_information20;
778: End If;
779: If (p_rec.ca_tax_information21 = hr_api.g_varchar2) then
775: If (p_rec.ca_tax_information20 = hr_api.g_varchar2) then
776: p_rec.ca_tax_information20 :=
777: pay_cft_shd.g_old_rec.ca_tax_information20;
778: End If;
779: If (p_rec.ca_tax_information21 = hr_api.g_varchar2) then
780: p_rec.ca_tax_information21 :=
781: pay_cft_shd.g_old_rec.ca_tax_information21;
782: End If;
783: If (p_rec.ca_tax_information22 = hr_api.g_varchar2) then
779: If (p_rec.ca_tax_information21 = hr_api.g_varchar2) then
780: p_rec.ca_tax_information21 :=
781: pay_cft_shd.g_old_rec.ca_tax_information21;
782: End If;
783: If (p_rec.ca_tax_information22 = hr_api.g_varchar2) then
784: p_rec.ca_tax_information22 :=
785: pay_cft_shd.g_old_rec.ca_tax_information22;
786: End If;
787: If (p_rec.ca_tax_information23 = hr_api.g_varchar2) then
783: If (p_rec.ca_tax_information22 = hr_api.g_varchar2) then
784: p_rec.ca_tax_information22 :=
785: pay_cft_shd.g_old_rec.ca_tax_information22;
786: End If;
787: If (p_rec.ca_tax_information23 = hr_api.g_varchar2) then
788: p_rec.ca_tax_information23 :=
789: pay_cft_shd.g_old_rec.ca_tax_information23;
790: End If;
791: If (p_rec.ca_tax_information24 = hr_api.g_varchar2) then
787: If (p_rec.ca_tax_information23 = hr_api.g_varchar2) then
788: p_rec.ca_tax_information23 :=
789: pay_cft_shd.g_old_rec.ca_tax_information23;
790: End If;
791: If (p_rec.ca_tax_information24 = hr_api.g_varchar2) then
792: p_rec.ca_tax_information24 :=
793: pay_cft_shd.g_old_rec.ca_tax_information24;
794: End If;
795: If (p_rec.ca_tax_information25 = hr_api.g_varchar2) then
791: If (p_rec.ca_tax_information24 = hr_api.g_varchar2) then
792: p_rec.ca_tax_information24 :=
793: pay_cft_shd.g_old_rec.ca_tax_information24;
794: End If;
795: If (p_rec.ca_tax_information25 = hr_api.g_varchar2) then
796: p_rec.ca_tax_information25 :=
797: pay_cft_shd.g_old_rec.ca_tax_information25;
798: End If;
799: If (p_rec.ca_tax_information26 = hr_api.g_varchar2) then
795: If (p_rec.ca_tax_information25 = hr_api.g_varchar2) then
796: p_rec.ca_tax_information25 :=
797: pay_cft_shd.g_old_rec.ca_tax_information25;
798: End If;
799: If (p_rec.ca_tax_information26 = hr_api.g_varchar2) then
800: p_rec.ca_tax_information26 :=
801: pay_cft_shd.g_old_rec.ca_tax_information26;
802: End If;
803: If (p_rec.ca_tax_information27 = hr_api.g_varchar2) then
799: If (p_rec.ca_tax_information26 = hr_api.g_varchar2) then
800: p_rec.ca_tax_information26 :=
801: pay_cft_shd.g_old_rec.ca_tax_information26;
802: End If;
803: If (p_rec.ca_tax_information27 = hr_api.g_varchar2) then
804: p_rec.ca_tax_information27 :=
805: pay_cft_shd.g_old_rec.ca_tax_information27;
806: End If;
807: If (p_rec.ca_tax_information28 = hr_api.g_varchar2) then
803: If (p_rec.ca_tax_information27 = hr_api.g_varchar2) then
804: p_rec.ca_tax_information27 :=
805: pay_cft_shd.g_old_rec.ca_tax_information27;
806: End If;
807: If (p_rec.ca_tax_information28 = hr_api.g_varchar2) then
808: p_rec.ca_tax_information28 :=
809: pay_cft_shd.g_old_rec.ca_tax_information28;
810: End If;
811: If (p_rec.ca_tax_information29 = hr_api.g_varchar2) then
807: If (p_rec.ca_tax_information28 = hr_api.g_varchar2) then
808: p_rec.ca_tax_information28 :=
809: pay_cft_shd.g_old_rec.ca_tax_information28;
810: End If;
811: If (p_rec.ca_tax_information29 = hr_api.g_varchar2) then
812: p_rec.ca_tax_information29 :=
813: pay_cft_shd.g_old_rec.ca_tax_information29;
814: End If;
815: If (p_rec.ca_tax_information30 = hr_api.g_varchar2) then
811: If (p_rec.ca_tax_information29 = hr_api.g_varchar2) then
812: p_rec.ca_tax_information29 :=
813: pay_cft_shd.g_old_rec.ca_tax_information29;
814: End If;
815: If (p_rec.ca_tax_information30 = hr_api.g_varchar2) then
816: p_rec.ca_tax_information30 :=
817: pay_cft_shd.g_old_rec.ca_tax_information30;
818: End If;
819: If (p_rec.fed_lsf_amount = hr_api.g_number) then
815: If (p_rec.ca_tax_information30 = hr_api.g_varchar2) then
816: p_rec.ca_tax_information30 :=
817: pay_cft_shd.g_old_rec.ca_tax_information30;
818: End If;
819: If (p_rec.fed_lsf_amount = hr_api.g_number) then
820: p_rec.fed_lsf_amount :=
821: pay_cft_shd.g_old_rec.fed_lsf_amount;
822: End If;
823:
909: (
910: p_emp_fed_tax_inf_id in number,
911: p_effective_start_date out nocopy date,
912: p_effective_end_date out nocopy date,
913: p_legislation_code in varchar2 default hr_api.g_varchar2,
914: p_assignment_id in number default hr_api.g_number,
915: p_business_group_id in number default hr_api.g_number,
916: p_employment_province in varchar2 default hr_api.g_varchar2,
917: p_tax_credit_amount in number default hr_api.g_number,
910: p_emp_fed_tax_inf_id in number,
911: p_effective_start_date out nocopy date,
912: p_effective_end_date out nocopy date,
913: p_legislation_code in varchar2 default hr_api.g_varchar2,
914: p_assignment_id in number default hr_api.g_number,
915: p_business_group_id in number default hr_api.g_number,
916: p_employment_province in varchar2 default hr_api.g_varchar2,
917: p_tax_credit_amount in number default hr_api.g_number,
918: p_claim_code in varchar2 default hr_api.g_varchar2,
911: p_effective_start_date out nocopy date,
912: p_effective_end_date out nocopy date,
913: p_legislation_code in varchar2 default hr_api.g_varchar2,
914: p_assignment_id in number default hr_api.g_number,
915: p_business_group_id in number default hr_api.g_number,
916: p_employment_province in varchar2 default hr_api.g_varchar2,
917: p_tax_credit_amount in number default hr_api.g_number,
918: p_claim_code in varchar2 default hr_api.g_varchar2,
919: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
912: p_effective_end_date out nocopy date,
913: p_legislation_code in varchar2 default hr_api.g_varchar2,
914: p_assignment_id in number default hr_api.g_number,
915: p_business_group_id in number default hr_api.g_number,
916: p_employment_province in varchar2 default hr_api.g_varchar2,
917: p_tax_credit_amount in number default hr_api.g_number,
918: p_claim_code in varchar2 default hr_api.g_varchar2,
919: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
920: p_additional_tax in number default hr_api.g_number,
913: p_legislation_code in varchar2 default hr_api.g_varchar2,
914: p_assignment_id in number default hr_api.g_number,
915: p_business_group_id in number default hr_api.g_number,
916: p_employment_province in varchar2 default hr_api.g_varchar2,
917: p_tax_credit_amount in number default hr_api.g_number,
918: p_claim_code in varchar2 default hr_api.g_varchar2,
919: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
920: p_additional_tax in number default hr_api.g_number,
921: p_annual_dedn in number default hr_api.g_number,
914: p_assignment_id in number default hr_api.g_number,
915: p_business_group_id in number default hr_api.g_number,
916: p_employment_province in varchar2 default hr_api.g_varchar2,
917: p_tax_credit_amount in number default hr_api.g_number,
918: p_claim_code in varchar2 default hr_api.g_varchar2,
919: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
920: p_additional_tax in number default hr_api.g_number,
921: p_annual_dedn in number default hr_api.g_number,
922: p_total_expense_by_commission in number default hr_api.g_number,
915: p_business_group_id in number default hr_api.g_number,
916: p_employment_province in varchar2 default hr_api.g_varchar2,
917: p_tax_credit_amount in number default hr_api.g_number,
918: p_claim_code in varchar2 default hr_api.g_varchar2,
919: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
920: p_additional_tax in number default hr_api.g_number,
921: p_annual_dedn in number default hr_api.g_number,
922: p_total_expense_by_commission in number default hr_api.g_number,
923: p_total_remnrtn_by_commission in number default hr_api.g_number,
916: p_employment_province in varchar2 default hr_api.g_varchar2,
917: p_tax_credit_amount in number default hr_api.g_number,
918: p_claim_code in varchar2 default hr_api.g_varchar2,
919: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
920: p_additional_tax in number default hr_api.g_number,
921: p_annual_dedn in number default hr_api.g_number,
922: p_total_expense_by_commission in number default hr_api.g_number,
923: p_total_remnrtn_by_commission in number default hr_api.g_number,
924: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
917: p_tax_credit_amount in number default hr_api.g_number,
918: p_claim_code in varchar2 default hr_api.g_varchar2,
919: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
920: p_additional_tax in number default hr_api.g_number,
921: p_annual_dedn in number default hr_api.g_number,
922: p_total_expense_by_commission in number default hr_api.g_number,
923: p_total_remnrtn_by_commission in number default hr_api.g_number,
924: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
925: p_other_fedtax_credits in varchar2 default hr_api.g_varchar2,
918: p_claim_code in varchar2 default hr_api.g_varchar2,
919: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
920: p_additional_tax in number default hr_api.g_number,
921: p_annual_dedn in number default hr_api.g_number,
922: p_total_expense_by_commission in number default hr_api.g_number,
923: p_total_remnrtn_by_commission in number default hr_api.g_number,
924: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
925: p_other_fedtax_credits in varchar2 default hr_api.g_varchar2,
926: p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
919: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
920: p_additional_tax in number default hr_api.g_number,
921: p_annual_dedn in number default hr_api.g_number,
922: p_total_expense_by_commission in number default hr_api.g_number,
923: p_total_remnrtn_by_commission in number default hr_api.g_number,
924: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
925: p_other_fedtax_credits in varchar2 default hr_api.g_varchar2,
926: p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
927: p_fed_exempt_flag in varchar2 default hr_api.g_varchar2,
920: p_additional_tax in number default hr_api.g_number,
921: p_annual_dedn in number default hr_api.g_number,
922: p_total_expense_by_commission in number default hr_api.g_number,
923: p_total_remnrtn_by_commission in number default hr_api.g_number,
924: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
925: p_other_fedtax_credits in varchar2 default hr_api.g_varchar2,
926: p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
927: p_fed_exempt_flag in varchar2 default hr_api.g_varchar2,
928: p_ei_exempt_flag in varchar2 default hr_api.g_varchar2,
921: p_annual_dedn in number default hr_api.g_number,
922: p_total_expense_by_commission in number default hr_api.g_number,
923: p_total_remnrtn_by_commission in number default hr_api.g_number,
924: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
925: p_other_fedtax_credits in varchar2 default hr_api.g_varchar2,
926: p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
927: p_fed_exempt_flag in varchar2 default hr_api.g_varchar2,
928: p_ei_exempt_flag in varchar2 default hr_api.g_varchar2,
929: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
922: p_total_expense_by_commission in number default hr_api.g_number,
923: p_total_remnrtn_by_commission in number default hr_api.g_number,
924: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
925: p_other_fedtax_credits in varchar2 default hr_api.g_varchar2,
926: p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
927: p_fed_exempt_flag in varchar2 default hr_api.g_varchar2,
928: p_ei_exempt_flag in varchar2 default hr_api.g_varchar2,
929: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
930: p_fed_override_amount in number default hr_api.g_number,
923: p_total_remnrtn_by_commission in number default hr_api.g_number,
924: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
925: p_other_fedtax_credits in varchar2 default hr_api.g_varchar2,
926: p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
927: p_fed_exempt_flag in varchar2 default hr_api.g_varchar2,
928: p_ei_exempt_flag in varchar2 default hr_api.g_varchar2,
929: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
930: p_fed_override_amount in number default hr_api.g_number,
931: p_fed_override_rate in number default hr_api.g_number,
924: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
925: p_other_fedtax_credits in varchar2 default hr_api.g_varchar2,
926: p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
927: p_fed_exempt_flag in varchar2 default hr_api.g_varchar2,
928: p_ei_exempt_flag in varchar2 default hr_api.g_varchar2,
929: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
930: p_fed_override_amount in number default hr_api.g_number,
931: p_fed_override_rate in number default hr_api.g_number,
932: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
925: p_other_fedtax_credits in varchar2 default hr_api.g_varchar2,
926: p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
927: p_fed_exempt_flag in varchar2 default hr_api.g_varchar2,
928: p_ei_exempt_flag in varchar2 default hr_api.g_varchar2,
929: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
930: p_fed_override_amount in number default hr_api.g_number,
931: p_fed_override_rate in number default hr_api.g_number,
932: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
933: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
926: p_cpp_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
927: p_fed_exempt_flag in varchar2 default hr_api.g_varchar2,
928: p_ei_exempt_flag in varchar2 default hr_api.g_varchar2,
929: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
930: p_fed_override_amount in number default hr_api.g_number,
931: p_fed_override_rate in number default hr_api.g_number,
932: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
933: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
934: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
927: p_fed_exempt_flag in varchar2 default hr_api.g_varchar2,
928: p_ei_exempt_flag in varchar2 default hr_api.g_varchar2,
929: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
930: p_fed_override_amount in number default hr_api.g_number,
931: p_fed_override_rate in number default hr_api.g_number,
932: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
933: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
934: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
935: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
928: p_ei_exempt_flag in varchar2 default hr_api.g_varchar2,
929: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
930: p_fed_override_amount in number default hr_api.g_number,
931: p_fed_override_rate in number default hr_api.g_number,
932: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
933: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
934: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
935: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
936: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
929: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
930: p_fed_override_amount in number default hr_api.g_number,
931: p_fed_override_rate in number default hr_api.g_number,
932: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
933: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
934: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
935: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
936: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
937: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
930: p_fed_override_amount in number default hr_api.g_number,
931: p_fed_override_rate in number default hr_api.g_number,
932: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
933: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
934: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
935: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
936: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
937: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
938: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
931: p_fed_override_rate in number default hr_api.g_number,
932: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
933: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
934: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
935: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
936: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
937: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
938: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
939: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
932: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
933: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
934: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
935: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
936: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
937: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
938: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
939: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
940: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
933: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
934: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
935: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
936: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
937: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
938: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
939: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
940: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
941: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
934: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
935: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
936: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
937: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
938: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
939: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
940: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
941: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
942: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
935: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
936: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
937: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
938: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
939: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
940: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
941: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
942: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
943: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
936: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
937: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
938: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
939: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
940: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
941: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
942: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
943: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
944: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
937: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
938: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
939: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
940: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
941: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
942: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
943: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
944: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
945: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
938: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
939: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
940: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
941: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
942: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
943: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
944: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
945: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
946: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
939: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
940: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
941: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
942: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
943: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
944: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
945: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
946: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
947: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
940: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
941: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
942: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
943: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
944: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
945: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
946: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
947: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
948: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
941: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
942: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
943: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
944: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
945: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
946: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
947: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
948: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
949: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
942: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
943: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
944: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
945: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
946: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
947: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
948: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
949: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
950: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
943: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
944: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
945: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
946: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
947: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
948: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
949: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
950: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
951: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
944: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
945: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
946: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
947: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
948: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
949: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
950: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
951: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
952: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
945: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
946: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
947: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
948: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
949: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
950: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
951: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
952: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
953: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
946: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
947: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
948: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
949: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
950: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
951: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
952: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
953: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
954: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
947: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
948: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
949: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
950: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
951: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
952: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
953: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
954: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
955: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
948: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
949: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
950: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
951: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
952: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
953: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
954: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
955: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
956: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
949: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
950: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
951: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
952: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
953: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
954: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
955: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
956: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
957: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
950: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
951: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
952: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
953: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
954: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
955: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
956: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
957: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
958: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
951: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
952: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
953: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
954: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
955: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
956: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
957: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
958: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
959: p_ca_tax_information27 in varchar2 default hr_api.g_varchar2,
952: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
953: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
954: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
955: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
956: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
957: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
958: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
959: p_ca_tax_information27 in varchar2 default hr_api.g_varchar2,
960: p_ca_tax_information28 in varchar2 default hr_api.g_varchar2,
953: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
954: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
955: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
956: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
957: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
958: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
959: p_ca_tax_information27 in varchar2 default hr_api.g_varchar2,
960: p_ca_tax_information28 in varchar2 default hr_api.g_varchar2,
961: p_ca_tax_information29 in varchar2 default hr_api.g_varchar2,
954: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
955: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
956: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
957: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
958: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
959: p_ca_tax_information27 in varchar2 default hr_api.g_varchar2,
960: p_ca_tax_information28 in varchar2 default hr_api.g_varchar2,
961: p_ca_tax_information29 in varchar2 default hr_api.g_varchar2,
962: p_ca_tax_information30 in varchar2 default hr_api.g_varchar2,
955: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
956: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
957: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
958: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
959: p_ca_tax_information27 in varchar2 default hr_api.g_varchar2,
960: p_ca_tax_information28 in varchar2 default hr_api.g_varchar2,
961: p_ca_tax_information29 in varchar2 default hr_api.g_varchar2,
962: p_ca_tax_information30 in varchar2 default hr_api.g_varchar2,
963: p_object_version_number in out nocopy number,
956: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
957: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
958: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
959: p_ca_tax_information27 in varchar2 default hr_api.g_varchar2,
960: p_ca_tax_information28 in varchar2 default hr_api.g_varchar2,
961: p_ca_tax_information29 in varchar2 default hr_api.g_varchar2,
962: p_ca_tax_information30 in varchar2 default hr_api.g_varchar2,
963: p_object_version_number in out nocopy number,
964: p_fed_lsf_amount in number default hr_api.g_number,
957: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
958: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
959: p_ca_tax_information27 in varchar2 default hr_api.g_varchar2,
960: p_ca_tax_information28 in varchar2 default hr_api.g_varchar2,
961: p_ca_tax_information29 in varchar2 default hr_api.g_varchar2,
962: p_ca_tax_information30 in varchar2 default hr_api.g_varchar2,
963: p_object_version_number in out nocopy number,
964: p_fed_lsf_amount in number default hr_api.g_number,
965: p_cpp_election_date in date, --For Bug Number 13258136
958: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
959: p_ca_tax_information27 in varchar2 default hr_api.g_varchar2,
960: p_ca_tax_information28 in varchar2 default hr_api.g_varchar2,
961: p_ca_tax_information29 in varchar2 default hr_api.g_varchar2,
962: p_ca_tax_information30 in varchar2 default hr_api.g_varchar2,
963: p_object_version_number in out nocopy number,
964: p_fed_lsf_amount in number default hr_api.g_number,
965: p_cpp_election_date in date, --For Bug Number 13258136
966: p_cpp_revocation_date in date, --For Bug Number 13258136
960: p_ca_tax_information28 in varchar2 default hr_api.g_varchar2,
961: p_ca_tax_information29 in varchar2 default hr_api.g_varchar2,
962: p_ca_tax_information30 in varchar2 default hr_api.g_varchar2,
963: p_object_version_number in out nocopy number,
964: p_fed_lsf_amount in number default hr_api.g_number,
965: p_cpp_election_date in date, --For Bug Number 13258136
966: p_cpp_revocation_date in date, --For Bug Number 13258136
967: p_effective_date in date,
968: p_datetrack_mode in varchar2