159: End If;
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 15);
162: Exception
163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated
165: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
166: pay_cpt_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated
165: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
166: pay_cpt_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
171: pay_cpt_shd.constraint_error
164: -- A check constraint has been violated
165: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
166: pay_cpt_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
171: pay_cpt_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
171: pay_cpt_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: pay_cpt_shd.g_api_dml := false; -- Unset the api dml status
175: Raise;
176: End dt_update_dml;
563: );
564: --
565: exception
566: --
567: when hr_api.cannot_find_prog_unit then
568: --
569: hr_api.cannot_find_prog_unit_error
570: (p_module_name => 'pay_ca_emp_prov_tax_info_f'
571: ,p_hook_type => 'AU');
565: exception
566: --
567: when hr_api.cannot_find_prog_unit then
568: --
569: hr_api.cannot_find_prog_unit_error
570: (p_module_name => 'pay_ca_emp_prov_tax_info_f'
571: ,p_hook_type => 'AU');
572: --
573: end;
633: -- p_rec plsql record structure
634: -- to see if a system default is being used. If a system default
635: -- is being used then we must set to the 'current' argument value.
636: --
637: If (p_rec.legislation_code = hr_api.g_varchar2) then
638: p_rec.legislation_code :=
639: pay_cpt_shd.g_old_rec.legislation_code;
640: End If;
641: If (p_rec.assignment_id = hr_api.g_number) then
637: If (p_rec.legislation_code = hr_api.g_varchar2) then
638: p_rec.legislation_code :=
639: pay_cpt_shd.g_old_rec.legislation_code;
640: End If;
641: If (p_rec.assignment_id = hr_api.g_number) then
642: p_rec.assignment_id :=
643: pay_cpt_shd.g_old_rec.assignment_id;
644: End If;
645: If (p_rec.business_group_id = hr_api.g_number) then
641: If (p_rec.assignment_id = hr_api.g_number) then
642: p_rec.assignment_id :=
643: pay_cpt_shd.g_old_rec.assignment_id;
644: End If;
645: If (p_rec.business_group_id = hr_api.g_number) then
646: p_rec.business_group_id :=
647: pay_cpt_shd.g_old_rec.business_group_id;
648: End If;
649: If (p_rec.province_code = hr_api.g_varchar2) then
645: If (p_rec.business_group_id = hr_api.g_number) then
646: p_rec.business_group_id :=
647: pay_cpt_shd.g_old_rec.business_group_id;
648: End If;
649: If (p_rec.province_code = hr_api.g_varchar2) then
650: p_rec.province_code :=
651: pay_cpt_shd.g_old_rec.province_code;
652: End If;
653: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
649: If (p_rec.province_code = hr_api.g_varchar2) then
650: p_rec.province_code :=
651: pay_cpt_shd.g_old_rec.province_code;
652: End If;
653: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
654: p_rec.jurisdiction_code :=
655: pay_cpt_shd.g_old_rec.jurisdiction_code;
656: End If;
657: If (p_rec.tax_credit_amount = hr_api.g_number) then
653: If (p_rec.jurisdiction_code = hr_api.g_varchar2) then
654: p_rec.jurisdiction_code :=
655: pay_cpt_shd.g_old_rec.jurisdiction_code;
656: End If;
657: If (p_rec.tax_credit_amount = hr_api.g_number) then
658: p_rec.tax_credit_amount :=
659: pay_cpt_shd.g_old_rec.tax_credit_amount;
660: End If;
661: If (p_rec.basic_exemption_flag = hr_api.g_varchar2) then
657: If (p_rec.tax_credit_amount = hr_api.g_number) then
658: p_rec.tax_credit_amount :=
659: pay_cpt_shd.g_old_rec.tax_credit_amount;
660: End If;
661: If (p_rec.basic_exemption_flag = hr_api.g_varchar2) then
662: p_rec.basic_exemption_flag :=
663: pay_cpt_shd.g_old_rec.basic_exemption_flag;
664: End If;
665: If (p_rec.deduction_code = hr_api.g_varchar2) then
661: If (p_rec.basic_exemption_flag = hr_api.g_varchar2) then
662: p_rec.basic_exemption_flag :=
663: pay_cpt_shd.g_old_rec.basic_exemption_flag;
664: End If;
665: If (p_rec.deduction_code = hr_api.g_varchar2) then
666: p_rec.deduction_code :=
667: pay_cpt_shd.g_old_rec.deduction_code;
668: End If;
669: If (p_rec.extra_info_not_provided = hr_api.g_varchar2) then
665: If (p_rec.deduction_code = hr_api.g_varchar2) then
666: p_rec.deduction_code :=
667: pay_cpt_shd.g_old_rec.deduction_code;
668: End If;
669: If (p_rec.extra_info_not_provided = hr_api.g_varchar2) then
670: p_rec.extra_info_not_provided :=
671: pay_cpt_shd.g_old_rec.extra_info_not_provided;
672: End If;
673: If (p_rec.marriage_status = hr_api.g_varchar2) then
669: If (p_rec.extra_info_not_provided = hr_api.g_varchar2) then
670: p_rec.extra_info_not_provided :=
671: pay_cpt_shd.g_old_rec.extra_info_not_provided;
672: End If;
673: If (p_rec.marriage_status = hr_api.g_varchar2) then
674: p_rec.marriage_status :=
675: pay_cpt_shd.g_old_rec.marriage_status;
676: End If;
677: If (p_rec.no_of_infirm_dependants = hr_api.g_number) then
673: If (p_rec.marriage_status = hr_api.g_varchar2) then
674: p_rec.marriage_status :=
675: pay_cpt_shd.g_old_rec.marriage_status;
676: End If;
677: If (p_rec.no_of_infirm_dependants = hr_api.g_number) then
678: p_rec.no_of_infirm_dependants :=
679: pay_cpt_shd.g_old_rec.no_of_infirm_dependants;
680: End If;
681: If (p_rec.non_resident_status = hr_api.g_varchar2) then
677: If (p_rec.no_of_infirm_dependants = hr_api.g_number) then
678: p_rec.no_of_infirm_dependants :=
679: pay_cpt_shd.g_old_rec.no_of_infirm_dependants;
680: End If;
681: If (p_rec.non_resident_status = hr_api.g_varchar2) then
682: p_rec.non_resident_status :=
683: pay_cpt_shd.g_old_rec.non_resident_status;
684: End If;
685: If (p_rec.disability_status = hr_api.g_varchar2) then
681: If (p_rec.non_resident_status = hr_api.g_varchar2) then
682: p_rec.non_resident_status :=
683: pay_cpt_shd.g_old_rec.non_resident_status;
684: End If;
685: If (p_rec.disability_status = hr_api.g_varchar2) then
686: p_rec.disability_status :=
687: pay_cpt_shd.g_old_rec.disability_status;
688: End If;
689: If (p_rec.no_of_dependants = hr_api.g_number) then
685: If (p_rec.disability_status = hr_api.g_varchar2) then
686: p_rec.disability_status :=
687: pay_cpt_shd.g_old_rec.disability_status;
688: End If;
689: If (p_rec.no_of_dependants = hr_api.g_number) then
690: p_rec.no_of_dependants :=
691: pay_cpt_shd.g_old_rec.no_of_dependants;
692: End If;
693: If (p_rec.annual_dedn = hr_api.g_number) then
689: If (p_rec.no_of_dependants = hr_api.g_number) then
690: p_rec.no_of_dependants :=
691: pay_cpt_shd.g_old_rec.no_of_dependants;
692: End If;
693: If (p_rec.annual_dedn = hr_api.g_number) then
694: p_rec.annual_dedn :=
695: pay_cpt_shd.g_old_rec.annual_dedn;
696: End If;
697: If (p_rec.total_expense_by_commission = hr_api.g_number) then
693: If (p_rec.annual_dedn = hr_api.g_number) then
694: p_rec.annual_dedn :=
695: pay_cpt_shd.g_old_rec.annual_dedn;
696: End If;
697: If (p_rec.total_expense_by_commission = hr_api.g_number) then
698: p_rec.total_expense_by_commission :=
699: pay_cpt_shd.g_old_rec.total_expense_by_commission;
700: End If;
701: If (p_rec.total_remnrtn_by_commission = hr_api.g_number) then
697: If (p_rec.total_expense_by_commission = hr_api.g_number) then
698: p_rec.total_expense_by_commission :=
699: pay_cpt_shd.g_old_rec.total_expense_by_commission;
700: End If;
701: If (p_rec.total_remnrtn_by_commission = hr_api.g_number) then
702: p_rec.total_remnrtn_by_commission :=
703: pay_cpt_shd.g_old_rec.total_remnrtn_by_commission;
704: End If;
705: If (p_rec.prescribed_zone_dedn_amt = hr_api.g_number) then
701: If (p_rec.total_remnrtn_by_commission = hr_api.g_number) then
702: p_rec.total_remnrtn_by_commission :=
703: pay_cpt_shd.g_old_rec.total_remnrtn_by_commission;
704: End If;
705: If (p_rec.prescribed_zone_dedn_amt = hr_api.g_number) then
706: p_rec.prescribed_zone_dedn_amt :=
707: pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt;
708: End If;
709: If (p_rec.additional_tax = hr_api.g_number) then
705: If (p_rec.prescribed_zone_dedn_amt = hr_api.g_number) then
706: p_rec.prescribed_zone_dedn_amt :=
707: pay_cpt_shd.g_old_rec.prescribed_zone_dedn_amt;
708: End If;
709: If (p_rec.additional_tax = hr_api.g_number) then
710: p_rec.additional_tax :=
711: pay_cpt_shd.g_old_rec.additional_tax;
712: End If;
713: If (p_rec.prov_override_rate = hr_api.g_number) then
709: If (p_rec.additional_tax = hr_api.g_number) then
710: p_rec.additional_tax :=
711: pay_cpt_shd.g_old_rec.additional_tax;
712: End If;
713: If (p_rec.prov_override_rate = hr_api.g_number) then
714: p_rec.prov_override_rate :=
715: pay_cpt_shd.g_old_rec.prov_override_rate;
716: End If;
717: If (p_rec.prov_override_amount = hr_api.g_number) then
713: If (p_rec.prov_override_rate = hr_api.g_number) then
714: p_rec.prov_override_rate :=
715: pay_cpt_shd.g_old_rec.prov_override_rate;
716: End If;
717: If (p_rec.prov_override_amount = hr_api.g_number) then
718: p_rec.prov_override_amount :=
719: pay_cpt_shd.g_old_rec.prov_override_amount;
720: End If;
721: If (p_rec.prov_exempt_flag = hr_api.g_varchar2) then
717: If (p_rec.prov_override_amount = hr_api.g_number) then
718: p_rec.prov_override_amount :=
719: pay_cpt_shd.g_old_rec.prov_override_amount;
720: End If;
721: If (p_rec.prov_exempt_flag = hr_api.g_varchar2) then
722: p_rec.prov_exempt_flag :=
723: pay_cpt_shd.g_old_rec.prov_exempt_flag;
724: End If;
725: If (p_rec.pmed_exempt_flag = hr_api.g_varchar2) then
721: If (p_rec.prov_exempt_flag = hr_api.g_varchar2) then
722: p_rec.prov_exempt_flag :=
723: pay_cpt_shd.g_old_rec.prov_exempt_flag;
724: End If;
725: If (p_rec.pmed_exempt_flag = hr_api.g_varchar2) then
726: p_rec.pmed_exempt_flag :=
727: pay_cpt_shd.g_old_rec.pmed_exempt_flag;
728: End If;
729: If (p_rec.wc_exempt_flag = hr_api.g_varchar2) then
725: If (p_rec.pmed_exempt_flag = hr_api.g_varchar2) then
726: p_rec.pmed_exempt_flag :=
727: pay_cpt_shd.g_old_rec.pmed_exempt_flag;
728: End If;
729: If (p_rec.wc_exempt_flag = hr_api.g_varchar2) then
730: p_rec.wc_exempt_flag :=
731: pay_cpt_shd.g_old_rec.wc_exempt_flag;
732: End If;
733: If (p_rec.qpp_exempt_flag = hr_api.g_varchar2) then
729: If (p_rec.wc_exempt_flag = hr_api.g_varchar2) then
730: p_rec.wc_exempt_flag :=
731: pay_cpt_shd.g_old_rec.wc_exempt_flag;
732: End If;
733: If (p_rec.qpp_exempt_flag = hr_api.g_varchar2) then
734: p_rec.qpp_exempt_flag :=
735: pay_cpt_shd.g_old_rec.qpp_exempt_flag;
736: End If;
737: If (p_rec.tax_calc_method = hr_api.g_varchar2) then
733: If (p_rec.qpp_exempt_flag = hr_api.g_varchar2) then
734: p_rec.qpp_exempt_flag :=
735: pay_cpt_shd.g_old_rec.qpp_exempt_flag;
736: End If;
737: If (p_rec.tax_calc_method = hr_api.g_varchar2) then
738: p_rec.tax_calc_method :=
739: pay_cpt_shd.g_old_rec.tax_calc_method;
740: End If;
741: If (p_rec.other_tax_credit = hr_api.g_number) then
737: If (p_rec.tax_calc_method = hr_api.g_varchar2) then
738: p_rec.tax_calc_method :=
739: pay_cpt_shd.g_old_rec.tax_calc_method;
740: End If;
741: If (p_rec.other_tax_credit = hr_api.g_number) then
742: p_rec.other_tax_credit :=
743: pay_cpt_shd.g_old_rec.other_tax_credit;
744: End If;
745: If (p_rec.ca_tax_information_category = hr_api.g_varchar2) then
741: If (p_rec.other_tax_credit = hr_api.g_number) then
742: p_rec.other_tax_credit :=
743: pay_cpt_shd.g_old_rec.other_tax_credit;
744: End If;
745: If (p_rec.ca_tax_information_category = hr_api.g_varchar2) then
746: p_rec.ca_tax_information_category :=
747: pay_cpt_shd.g_old_rec.ca_tax_information_category;
748: End If;
749: If (p_rec.ca_tax_information1 = hr_api.g_varchar2) then
745: If (p_rec.ca_tax_information_category = hr_api.g_varchar2) then
746: p_rec.ca_tax_information_category :=
747: pay_cpt_shd.g_old_rec.ca_tax_information_category;
748: End If;
749: If (p_rec.ca_tax_information1 = hr_api.g_varchar2) then
750: p_rec.ca_tax_information1 :=
751: pay_cpt_shd.g_old_rec.ca_tax_information1;
752: End If;
753: If (p_rec.ca_tax_information2 = hr_api.g_varchar2) then
749: If (p_rec.ca_tax_information1 = hr_api.g_varchar2) then
750: p_rec.ca_tax_information1 :=
751: pay_cpt_shd.g_old_rec.ca_tax_information1;
752: End If;
753: If (p_rec.ca_tax_information2 = hr_api.g_varchar2) then
754: p_rec.ca_tax_information2 :=
755: pay_cpt_shd.g_old_rec.ca_tax_information2;
756: End If;
757: If (p_rec.ca_tax_information3 = hr_api.g_varchar2) then
753: If (p_rec.ca_tax_information2 = hr_api.g_varchar2) then
754: p_rec.ca_tax_information2 :=
755: pay_cpt_shd.g_old_rec.ca_tax_information2;
756: End If;
757: If (p_rec.ca_tax_information3 = hr_api.g_varchar2) then
758: p_rec.ca_tax_information3 :=
759: pay_cpt_shd.g_old_rec.ca_tax_information3;
760: End If;
761: If (p_rec.ca_tax_information4 = hr_api.g_varchar2) then
757: If (p_rec.ca_tax_information3 = hr_api.g_varchar2) then
758: p_rec.ca_tax_information3 :=
759: pay_cpt_shd.g_old_rec.ca_tax_information3;
760: End If;
761: If (p_rec.ca_tax_information4 = hr_api.g_varchar2) then
762: p_rec.ca_tax_information4 :=
763: pay_cpt_shd.g_old_rec.ca_tax_information4;
764: End If;
765: If (p_rec.ca_tax_information5 = hr_api.g_varchar2) then
761: If (p_rec.ca_tax_information4 = hr_api.g_varchar2) then
762: p_rec.ca_tax_information4 :=
763: pay_cpt_shd.g_old_rec.ca_tax_information4;
764: End If;
765: If (p_rec.ca_tax_information5 = hr_api.g_varchar2) then
766: p_rec.ca_tax_information5 :=
767: pay_cpt_shd.g_old_rec.ca_tax_information5;
768: End If;
769: If (p_rec.ca_tax_information6 = hr_api.g_varchar2) then
765: If (p_rec.ca_tax_information5 = hr_api.g_varchar2) then
766: p_rec.ca_tax_information5 :=
767: pay_cpt_shd.g_old_rec.ca_tax_information5;
768: End If;
769: If (p_rec.ca_tax_information6 = hr_api.g_varchar2) then
770: p_rec.ca_tax_information6 :=
771: pay_cpt_shd.g_old_rec.ca_tax_information6;
772: End If;
773: If (p_rec.ca_tax_information7 = hr_api.g_varchar2) then
769: If (p_rec.ca_tax_information6 = hr_api.g_varchar2) then
770: p_rec.ca_tax_information6 :=
771: pay_cpt_shd.g_old_rec.ca_tax_information6;
772: End If;
773: If (p_rec.ca_tax_information7 = hr_api.g_varchar2) then
774: p_rec.ca_tax_information7 :=
775: pay_cpt_shd.g_old_rec.ca_tax_information7;
776: End If;
777: If (p_rec.ca_tax_information8 = hr_api.g_varchar2) then
773: If (p_rec.ca_tax_information7 = hr_api.g_varchar2) then
774: p_rec.ca_tax_information7 :=
775: pay_cpt_shd.g_old_rec.ca_tax_information7;
776: End If;
777: If (p_rec.ca_tax_information8 = hr_api.g_varchar2) then
778: p_rec.ca_tax_information8 :=
779: pay_cpt_shd.g_old_rec.ca_tax_information8;
780: End If;
781: If (p_rec.ca_tax_information9 = hr_api.g_varchar2) then
777: If (p_rec.ca_tax_information8 = hr_api.g_varchar2) then
778: p_rec.ca_tax_information8 :=
779: pay_cpt_shd.g_old_rec.ca_tax_information8;
780: End If;
781: If (p_rec.ca_tax_information9 = hr_api.g_varchar2) then
782: p_rec.ca_tax_information9 :=
783: pay_cpt_shd.g_old_rec.ca_tax_information9;
784: End If;
785: If (p_rec.ca_tax_information10 = hr_api.g_varchar2) then
781: If (p_rec.ca_tax_information9 = hr_api.g_varchar2) then
782: p_rec.ca_tax_information9 :=
783: pay_cpt_shd.g_old_rec.ca_tax_information9;
784: End If;
785: If (p_rec.ca_tax_information10 = hr_api.g_varchar2) then
786: p_rec.ca_tax_information10 :=
787: pay_cpt_shd.g_old_rec.ca_tax_information10;
788: End If;
789: If (p_rec.ca_tax_information11 = hr_api.g_varchar2) then
785: If (p_rec.ca_tax_information10 = hr_api.g_varchar2) then
786: p_rec.ca_tax_information10 :=
787: pay_cpt_shd.g_old_rec.ca_tax_information10;
788: End If;
789: If (p_rec.ca_tax_information11 = hr_api.g_varchar2) then
790: p_rec.ca_tax_information11 :=
791: pay_cpt_shd.g_old_rec.ca_tax_information11;
792: End If;
793: If (p_rec.ca_tax_information12 = hr_api.g_varchar2) then
789: If (p_rec.ca_tax_information11 = hr_api.g_varchar2) then
790: p_rec.ca_tax_information11 :=
791: pay_cpt_shd.g_old_rec.ca_tax_information11;
792: End If;
793: If (p_rec.ca_tax_information12 = hr_api.g_varchar2) then
794: p_rec.ca_tax_information12 :=
795: pay_cpt_shd.g_old_rec.ca_tax_information12;
796: End If;
797: If (p_rec.ca_tax_information13 = hr_api.g_varchar2) then
793: If (p_rec.ca_tax_information12 = hr_api.g_varchar2) then
794: p_rec.ca_tax_information12 :=
795: pay_cpt_shd.g_old_rec.ca_tax_information12;
796: End If;
797: If (p_rec.ca_tax_information13 = hr_api.g_varchar2) then
798: p_rec.ca_tax_information13 :=
799: pay_cpt_shd.g_old_rec.ca_tax_information13;
800: End If;
801: If (p_rec.ca_tax_information14 = hr_api.g_varchar2) then
797: If (p_rec.ca_tax_information13 = hr_api.g_varchar2) then
798: p_rec.ca_tax_information13 :=
799: pay_cpt_shd.g_old_rec.ca_tax_information13;
800: End If;
801: If (p_rec.ca_tax_information14 = hr_api.g_varchar2) then
802: p_rec.ca_tax_information14 :=
803: pay_cpt_shd.g_old_rec.ca_tax_information14;
804: End If;
805: If (p_rec.ca_tax_information15 = hr_api.g_varchar2) then
801: If (p_rec.ca_tax_information14 = hr_api.g_varchar2) then
802: p_rec.ca_tax_information14 :=
803: pay_cpt_shd.g_old_rec.ca_tax_information14;
804: End If;
805: If (p_rec.ca_tax_information15 = hr_api.g_varchar2) then
806: p_rec.ca_tax_information15 :=
807: pay_cpt_shd.g_old_rec.ca_tax_information15;
808: End If;
809: If (p_rec.ca_tax_information16 = hr_api.g_varchar2) then
805: If (p_rec.ca_tax_information15 = hr_api.g_varchar2) then
806: p_rec.ca_tax_information15 :=
807: pay_cpt_shd.g_old_rec.ca_tax_information15;
808: End If;
809: If (p_rec.ca_tax_information16 = hr_api.g_varchar2) then
810: p_rec.ca_tax_information16 :=
811: pay_cpt_shd.g_old_rec.ca_tax_information16;
812: End If;
813: If (p_rec.ca_tax_information17 = hr_api.g_varchar2) then
809: If (p_rec.ca_tax_information16 = hr_api.g_varchar2) then
810: p_rec.ca_tax_information16 :=
811: pay_cpt_shd.g_old_rec.ca_tax_information16;
812: End If;
813: If (p_rec.ca_tax_information17 = hr_api.g_varchar2) then
814: p_rec.ca_tax_information17 :=
815: pay_cpt_shd.g_old_rec.ca_tax_information17;
816: End If;
817: If (p_rec.ca_tax_information18 = hr_api.g_varchar2) then
813: If (p_rec.ca_tax_information17 = hr_api.g_varchar2) then
814: p_rec.ca_tax_information17 :=
815: pay_cpt_shd.g_old_rec.ca_tax_information17;
816: End If;
817: If (p_rec.ca_tax_information18 = hr_api.g_varchar2) then
818: p_rec.ca_tax_information18 :=
819: pay_cpt_shd.g_old_rec.ca_tax_information18;
820: End If;
821: If (p_rec.ca_tax_information19 = hr_api.g_varchar2) then
817: If (p_rec.ca_tax_information18 = hr_api.g_varchar2) then
818: p_rec.ca_tax_information18 :=
819: pay_cpt_shd.g_old_rec.ca_tax_information18;
820: End If;
821: If (p_rec.ca_tax_information19 = hr_api.g_varchar2) then
822: p_rec.ca_tax_information19 :=
823: pay_cpt_shd.g_old_rec.ca_tax_information19;
824: End If;
825: If (p_rec.ca_tax_information20 = hr_api.g_varchar2) then
821: If (p_rec.ca_tax_information19 = hr_api.g_varchar2) then
822: p_rec.ca_tax_information19 :=
823: pay_cpt_shd.g_old_rec.ca_tax_information19;
824: End If;
825: If (p_rec.ca_tax_information20 = hr_api.g_varchar2) then
826: p_rec.ca_tax_information20 :=
827: pay_cpt_shd.g_old_rec.ca_tax_information20;
828: End If;
829: If (p_rec.ca_tax_information21 = hr_api.g_varchar2) then
825: If (p_rec.ca_tax_information20 = hr_api.g_varchar2) then
826: p_rec.ca_tax_information20 :=
827: pay_cpt_shd.g_old_rec.ca_tax_information20;
828: End If;
829: If (p_rec.ca_tax_information21 = hr_api.g_varchar2) then
830: p_rec.ca_tax_information21 :=
831: pay_cpt_shd.g_old_rec.ca_tax_information21;
832: End If;
833: If (p_rec.ca_tax_information22 = hr_api.g_varchar2) then
829: If (p_rec.ca_tax_information21 = hr_api.g_varchar2) then
830: p_rec.ca_tax_information21 :=
831: pay_cpt_shd.g_old_rec.ca_tax_information21;
832: End If;
833: If (p_rec.ca_tax_information22 = hr_api.g_varchar2) then
834: p_rec.ca_tax_information22 :=
835: pay_cpt_shd.g_old_rec.ca_tax_information22;
836: End If;
837: If (p_rec.ca_tax_information23 = hr_api.g_varchar2) then
833: If (p_rec.ca_tax_information22 = hr_api.g_varchar2) then
834: p_rec.ca_tax_information22 :=
835: pay_cpt_shd.g_old_rec.ca_tax_information22;
836: End If;
837: If (p_rec.ca_tax_information23 = hr_api.g_varchar2) then
838: p_rec.ca_tax_information23 :=
839: pay_cpt_shd.g_old_rec.ca_tax_information23;
840: End If;
841: If (p_rec.ca_tax_information24 = hr_api.g_varchar2) then
837: If (p_rec.ca_tax_information23 = hr_api.g_varchar2) then
838: p_rec.ca_tax_information23 :=
839: pay_cpt_shd.g_old_rec.ca_tax_information23;
840: End If;
841: If (p_rec.ca_tax_information24 = hr_api.g_varchar2) then
842: p_rec.ca_tax_information24 :=
843: pay_cpt_shd.g_old_rec.ca_tax_information24;
844: End If;
845: If (p_rec.ca_tax_information25 = hr_api.g_varchar2) then
841: If (p_rec.ca_tax_information24 = hr_api.g_varchar2) then
842: p_rec.ca_tax_information24 :=
843: pay_cpt_shd.g_old_rec.ca_tax_information24;
844: End If;
845: If (p_rec.ca_tax_information25 = hr_api.g_varchar2) then
846: p_rec.ca_tax_information25 :=
847: pay_cpt_shd.g_old_rec.ca_tax_information25;
848: End If;
849: If (p_rec.ca_tax_information26 = hr_api.g_varchar2) then
845: If (p_rec.ca_tax_information25 = hr_api.g_varchar2) then
846: p_rec.ca_tax_information25 :=
847: pay_cpt_shd.g_old_rec.ca_tax_information25;
848: End If;
849: If (p_rec.ca_tax_information26 = hr_api.g_varchar2) then
850: p_rec.ca_tax_information26 :=
851: pay_cpt_shd.g_old_rec.ca_tax_information26;
852: End If;
853: If (p_rec.ca_tax_information27 = hr_api.g_varchar2) then
849: If (p_rec.ca_tax_information26 = hr_api.g_varchar2) then
850: p_rec.ca_tax_information26 :=
851: pay_cpt_shd.g_old_rec.ca_tax_information26;
852: End If;
853: If (p_rec.ca_tax_information27 = hr_api.g_varchar2) then
854: p_rec.ca_tax_information27 :=
855: pay_cpt_shd.g_old_rec.ca_tax_information27;
856: End If;
857: If (p_rec.ca_tax_information28 = hr_api.g_varchar2) then
853: If (p_rec.ca_tax_information27 = hr_api.g_varchar2) then
854: p_rec.ca_tax_information27 :=
855: pay_cpt_shd.g_old_rec.ca_tax_information27;
856: End If;
857: If (p_rec.ca_tax_information28 = hr_api.g_varchar2) then
858: p_rec.ca_tax_information28 :=
859: pay_cpt_shd.g_old_rec.ca_tax_information28;
860: End If;
861: If (p_rec.ca_tax_information29 = hr_api.g_varchar2) then
857: If (p_rec.ca_tax_information28 = hr_api.g_varchar2) then
858: p_rec.ca_tax_information28 :=
859: pay_cpt_shd.g_old_rec.ca_tax_information28;
860: End If;
861: If (p_rec.ca_tax_information29 = hr_api.g_varchar2) then
862: p_rec.ca_tax_information29 :=
863: pay_cpt_shd.g_old_rec.ca_tax_information29;
864: End If;
865: If (p_rec.ca_tax_information30 = hr_api.g_varchar2) then
861: If (p_rec.ca_tax_information29 = hr_api.g_varchar2) then
862: p_rec.ca_tax_information29 :=
863: pay_cpt_shd.g_old_rec.ca_tax_information29;
864: End If;
865: If (p_rec.ca_tax_information30 = hr_api.g_varchar2) then
866: p_rec.ca_tax_information30 :=
867: pay_cpt_shd.g_old_rec.ca_tax_information30;
868: End If;
869: If (p_rec.prov_lsp_amount = hr_api.g_number) then
865: If (p_rec.ca_tax_information30 = hr_api.g_varchar2) then
866: p_rec.ca_tax_information30 :=
867: pay_cpt_shd.g_old_rec.ca_tax_information30;
868: End If;
869: If (p_rec.prov_lsp_amount = hr_api.g_number) then
870: p_rec.prov_lsp_amount :=
871: pay_cpt_shd.g_old_rec.prov_lsp_amount;
872: End If;
873: If (p_rec.ppip_exempt_flag = hr_api.g_varchar2) then
869: If (p_rec.prov_lsp_amount = hr_api.g_number) then
870: p_rec.prov_lsp_amount :=
871: pay_cpt_shd.g_old_rec.prov_lsp_amount;
872: End If;
873: If (p_rec.ppip_exempt_flag = hr_api.g_varchar2) then
874: p_rec.ppip_exempt_flag :=
875: pay_cpt_shd.g_old_rec.ppip_exempt_flag;
876: End If;
877:
962: (
963: p_emp_province_tax_inf_id in number,
964: p_effective_start_date out nocopy date,
965: p_effective_end_date out nocopy date,
966: p_legislation_code in varchar2 default hr_api.g_varchar2,
967: p_assignment_id in number default hr_api.g_number,
968: p_business_group_id in number default hr_api.g_number,
969: p_province_code in varchar2 default hr_api.g_varchar2,
970: p_jurisdiction_code in varchar2 default hr_api.g_varchar2,
963: p_emp_province_tax_inf_id in number,
964: p_effective_start_date out nocopy date,
965: p_effective_end_date out nocopy date,
966: p_legislation_code in varchar2 default hr_api.g_varchar2,
967: p_assignment_id in number default hr_api.g_number,
968: p_business_group_id in number default hr_api.g_number,
969: p_province_code in varchar2 default hr_api.g_varchar2,
970: p_jurisdiction_code in varchar2 default hr_api.g_varchar2,
971: p_tax_credit_amount in number default hr_api.g_number,
964: p_effective_start_date out nocopy date,
965: p_effective_end_date out nocopy date,
966: p_legislation_code in varchar2 default hr_api.g_varchar2,
967: p_assignment_id in number default hr_api.g_number,
968: p_business_group_id in number default hr_api.g_number,
969: p_province_code in varchar2 default hr_api.g_varchar2,
970: p_jurisdiction_code in varchar2 default hr_api.g_varchar2,
971: p_tax_credit_amount in number default hr_api.g_number,
972: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
965: p_effective_end_date out nocopy date,
966: p_legislation_code in varchar2 default hr_api.g_varchar2,
967: p_assignment_id in number default hr_api.g_number,
968: p_business_group_id in number default hr_api.g_number,
969: p_province_code in varchar2 default hr_api.g_varchar2,
970: p_jurisdiction_code in varchar2 default hr_api.g_varchar2,
971: p_tax_credit_amount in number default hr_api.g_number,
972: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
973: p_deduction_code in varchar2 default hr_api.g_varchar2,
966: p_legislation_code in varchar2 default hr_api.g_varchar2,
967: p_assignment_id in number default hr_api.g_number,
968: p_business_group_id in number default hr_api.g_number,
969: p_province_code in varchar2 default hr_api.g_varchar2,
970: p_jurisdiction_code in varchar2 default hr_api.g_varchar2,
971: p_tax_credit_amount in number default hr_api.g_number,
972: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
973: p_deduction_code in varchar2 default hr_api.g_varchar2,
974: p_extra_info_not_provided in varchar2 default hr_api.g_varchar2,
967: p_assignment_id in number default hr_api.g_number,
968: p_business_group_id in number default hr_api.g_number,
969: p_province_code in varchar2 default hr_api.g_varchar2,
970: p_jurisdiction_code in varchar2 default hr_api.g_varchar2,
971: p_tax_credit_amount in number default hr_api.g_number,
972: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
973: p_deduction_code in varchar2 default hr_api.g_varchar2,
974: p_extra_info_not_provided in varchar2 default hr_api.g_varchar2,
975: p_marriage_status in varchar2 default hr_api.g_varchar2,
968: p_business_group_id in number default hr_api.g_number,
969: p_province_code in varchar2 default hr_api.g_varchar2,
970: p_jurisdiction_code in varchar2 default hr_api.g_varchar2,
971: p_tax_credit_amount in number default hr_api.g_number,
972: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
973: p_deduction_code in varchar2 default hr_api.g_varchar2,
974: p_extra_info_not_provided in varchar2 default hr_api.g_varchar2,
975: p_marriage_status in varchar2 default hr_api.g_varchar2,
976: p_no_of_infirm_dependants in number default hr_api.g_number,
969: p_province_code in varchar2 default hr_api.g_varchar2,
970: p_jurisdiction_code in varchar2 default hr_api.g_varchar2,
971: p_tax_credit_amount in number default hr_api.g_number,
972: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
973: p_deduction_code in varchar2 default hr_api.g_varchar2,
974: p_extra_info_not_provided in varchar2 default hr_api.g_varchar2,
975: p_marriage_status in varchar2 default hr_api.g_varchar2,
976: p_no_of_infirm_dependants in number default hr_api.g_number,
977: p_non_resident_status in varchar2 default hr_api.g_varchar2,
970: p_jurisdiction_code in varchar2 default hr_api.g_varchar2,
971: p_tax_credit_amount in number default hr_api.g_number,
972: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
973: p_deduction_code in varchar2 default hr_api.g_varchar2,
974: p_extra_info_not_provided in varchar2 default hr_api.g_varchar2,
975: p_marriage_status in varchar2 default hr_api.g_varchar2,
976: p_no_of_infirm_dependants in number default hr_api.g_number,
977: p_non_resident_status in varchar2 default hr_api.g_varchar2,
978: p_disability_status in varchar2 default hr_api.g_varchar2,
971: p_tax_credit_amount in number default hr_api.g_number,
972: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
973: p_deduction_code in varchar2 default hr_api.g_varchar2,
974: p_extra_info_not_provided in varchar2 default hr_api.g_varchar2,
975: p_marriage_status in varchar2 default hr_api.g_varchar2,
976: p_no_of_infirm_dependants in number default hr_api.g_number,
977: p_non_resident_status in varchar2 default hr_api.g_varchar2,
978: p_disability_status in varchar2 default hr_api.g_varchar2,
979: p_no_of_dependants in number default hr_api.g_number,
972: p_basic_exemption_flag in varchar2 default hr_api.g_varchar2,
973: p_deduction_code in varchar2 default hr_api.g_varchar2,
974: p_extra_info_not_provided in varchar2 default hr_api.g_varchar2,
975: p_marriage_status in varchar2 default hr_api.g_varchar2,
976: p_no_of_infirm_dependants in number default hr_api.g_number,
977: p_non_resident_status in varchar2 default hr_api.g_varchar2,
978: p_disability_status in varchar2 default hr_api.g_varchar2,
979: p_no_of_dependants in number default hr_api.g_number,
980: p_annual_dedn in number default hr_api.g_number,
973: p_deduction_code in varchar2 default hr_api.g_varchar2,
974: p_extra_info_not_provided in varchar2 default hr_api.g_varchar2,
975: p_marriage_status in varchar2 default hr_api.g_varchar2,
976: p_no_of_infirm_dependants in number default hr_api.g_number,
977: p_non_resident_status in varchar2 default hr_api.g_varchar2,
978: p_disability_status in varchar2 default hr_api.g_varchar2,
979: p_no_of_dependants in number default hr_api.g_number,
980: p_annual_dedn in number default hr_api.g_number,
981: p_total_expense_by_commission in number default hr_api.g_number,
974: p_extra_info_not_provided in varchar2 default hr_api.g_varchar2,
975: p_marriage_status in varchar2 default hr_api.g_varchar2,
976: p_no_of_infirm_dependants in number default hr_api.g_number,
977: p_non_resident_status in varchar2 default hr_api.g_varchar2,
978: p_disability_status in varchar2 default hr_api.g_varchar2,
979: p_no_of_dependants in number default hr_api.g_number,
980: p_annual_dedn in number default hr_api.g_number,
981: p_total_expense_by_commission in number default hr_api.g_number,
982: p_total_remnrtn_by_commission in number default hr_api.g_number,
975: p_marriage_status in varchar2 default hr_api.g_varchar2,
976: p_no_of_infirm_dependants in number default hr_api.g_number,
977: p_non_resident_status in varchar2 default hr_api.g_varchar2,
978: p_disability_status in varchar2 default hr_api.g_varchar2,
979: p_no_of_dependants in number default hr_api.g_number,
980: p_annual_dedn in number default hr_api.g_number,
981: p_total_expense_by_commission in number default hr_api.g_number,
982: p_total_remnrtn_by_commission in number default hr_api.g_number,
983: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
976: p_no_of_infirm_dependants in number default hr_api.g_number,
977: p_non_resident_status in varchar2 default hr_api.g_varchar2,
978: p_disability_status in varchar2 default hr_api.g_varchar2,
979: p_no_of_dependants in number default hr_api.g_number,
980: p_annual_dedn in number default hr_api.g_number,
981: p_total_expense_by_commission in number default hr_api.g_number,
982: p_total_remnrtn_by_commission in number default hr_api.g_number,
983: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
984: p_additional_tax in number default hr_api.g_number,
977: p_non_resident_status in varchar2 default hr_api.g_varchar2,
978: p_disability_status in varchar2 default hr_api.g_varchar2,
979: p_no_of_dependants in number default hr_api.g_number,
980: p_annual_dedn in number default hr_api.g_number,
981: p_total_expense_by_commission in number default hr_api.g_number,
982: p_total_remnrtn_by_commission in number default hr_api.g_number,
983: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
984: p_additional_tax in number default hr_api.g_number,
985: p_prov_override_rate in number default hr_api.g_number,
978: p_disability_status in varchar2 default hr_api.g_varchar2,
979: p_no_of_dependants in number default hr_api.g_number,
980: p_annual_dedn in number default hr_api.g_number,
981: p_total_expense_by_commission in number default hr_api.g_number,
982: p_total_remnrtn_by_commission in number default hr_api.g_number,
983: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
984: p_additional_tax in number default hr_api.g_number,
985: p_prov_override_rate in number default hr_api.g_number,
986: p_prov_override_amount in number default hr_api.g_number,
979: p_no_of_dependants in number default hr_api.g_number,
980: p_annual_dedn in number default hr_api.g_number,
981: p_total_expense_by_commission in number default hr_api.g_number,
982: p_total_remnrtn_by_commission in number default hr_api.g_number,
983: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
984: p_additional_tax in number default hr_api.g_number,
985: p_prov_override_rate in number default hr_api.g_number,
986: p_prov_override_amount in number default hr_api.g_number,
987: p_prov_exempt_flag in varchar2 default hr_api.g_varchar2,
980: p_annual_dedn in number default hr_api.g_number,
981: p_total_expense_by_commission in number default hr_api.g_number,
982: p_total_remnrtn_by_commission in number default hr_api.g_number,
983: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
984: p_additional_tax in number default hr_api.g_number,
985: p_prov_override_rate in number default hr_api.g_number,
986: p_prov_override_amount in number default hr_api.g_number,
987: p_prov_exempt_flag in varchar2 default hr_api.g_varchar2,
988: p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2,
981: p_total_expense_by_commission in number default hr_api.g_number,
982: p_total_remnrtn_by_commission in number default hr_api.g_number,
983: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
984: p_additional_tax in number default hr_api.g_number,
985: p_prov_override_rate in number default hr_api.g_number,
986: p_prov_override_amount in number default hr_api.g_number,
987: p_prov_exempt_flag in varchar2 default hr_api.g_varchar2,
988: p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2,
989: p_wc_exempt_flag in varchar2 default hr_api.g_varchar2,
982: p_total_remnrtn_by_commission in number default hr_api.g_number,
983: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
984: p_additional_tax in number default hr_api.g_number,
985: p_prov_override_rate in number default hr_api.g_number,
986: p_prov_override_amount in number default hr_api.g_number,
987: p_prov_exempt_flag in varchar2 default hr_api.g_varchar2,
988: p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2,
989: p_wc_exempt_flag in varchar2 default hr_api.g_varchar2,
990: p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
983: p_prescribed_zone_dedn_amt in number default hr_api.g_number,
984: p_additional_tax in number default hr_api.g_number,
985: p_prov_override_rate in number default hr_api.g_number,
986: p_prov_override_amount in number default hr_api.g_number,
987: p_prov_exempt_flag in varchar2 default hr_api.g_varchar2,
988: p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2,
989: p_wc_exempt_flag in varchar2 default hr_api.g_varchar2,
990: p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
991: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
984: p_additional_tax in number default hr_api.g_number,
985: p_prov_override_rate in number default hr_api.g_number,
986: p_prov_override_amount in number default hr_api.g_number,
987: p_prov_exempt_flag in varchar2 default hr_api.g_varchar2,
988: p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2,
989: p_wc_exempt_flag in varchar2 default hr_api.g_varchar2,
990: p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
991: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
992: p_other_tax_credit in number default hr_api.g_number,
985: p_prov_override_rate in number default hr_api.g_number,
986: p_prov_override_amount in number default hr_api.g_number,
987: p_prov_exempt_flag in varchar2 default hr_api.g_varchar2,
988: p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2,
989: p_wc_exempt_flag in varchar2 default hr_api.g_varchar2,
990: p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
991: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
992: p_other_tax_credit in number default hr_api.g_number,
993: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
986: p_prov_override_amount in number default hr_api.g_number,
987: p_prov_exempt_flag in varchar2 default hr_api.g_varchar2,
988: p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2,
989: p_wc_exempt_flag in varchar2 default hr_api.g_varchar2,
990: p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
991: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
992: p_other_tax_credit in number default hr_api.g_number,
993: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
994: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
987: p_prov_exempt_flag in varchar2 default hr_api.g_varchar2,
988: p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2,
989: p_wc_exempt_flag in varchar2 default hr_api.g_varchar2,
990: p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
991: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
992: p_other_tax_credit in number default hr_api.g_number,
993: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
994: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
995: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
988: p_pmed_exempt_flag in varchar2 default hr_api.g_varchar2,
989: p_wc_exempt_flag in varchar2 default hr_api.g_varchar2,
990: p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
991: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
992: p_other_tax_credit in number default hr_api.g_number,
993: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
994: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
995: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
996: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
989: p_wc_exempt_flag in varchar2 default hr_api.g_varchar2,
990: p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
991: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
992: p_other_tax_credit in number default hr_api.g_number,
993: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
994: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
995: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
996: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
997: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
990: p_qpp_exempt_flag in varchar2 default hr_api.g_varchar2,
991: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
992: p_other_tax_credit in number default hr_api.g_number,
993: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
994: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
995: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
996: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
997: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
998: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
991: p_tax_calc_method in varchar2 default hr_api.g_varchar2,
992: p_other_tax_credit in number default hr_api.g_number,
993: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
994: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
995: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
996: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
997: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
998: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
999: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
992: p_other_tax_credit in number default hr_api.g_number,
993: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
994: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
995: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
996: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
997: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
998: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
999: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
1000: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
993: p_ca_tax_information_category in varchar2 default hr_api.g_varchar2,
994: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
995: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
996: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
997: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
998: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
999: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
1000: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
1001: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
994: p_ca_tax_information1 in varchar2 default hr_api.g_varchar2,
995: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
996: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
997: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
998: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
999: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
1000: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
1001: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
1002: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
995: p_ca_tax_information2 in varchar2 default hr_api.g_varchar2,
996: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
997: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
998: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
999: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
1000: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
1001: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
1002: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
1003: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
996: p_ca_tax_information3 in varchar2 default hr_api.g_varchar2,
997: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
998: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
999: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
1000: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
1001: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
1002: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
1003: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
1004: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
997: p_ca_tax_information4 in varchar2 default hr_api.g_varchar2,
998: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
999: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
1000: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
1001: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
1002: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
1003: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
1004: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
1005: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
998: p_ca_tax_information5 in varchar2 default hr_api.g_varchar2,
999: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
1000: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
1001: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
1002: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
1003: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
1004: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
1005: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
1006: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
999: p_ca_tax_information6 in varchar2 default hr_api.g_varchar2,
1000: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
1001: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
1002: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
1003: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
1004: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
1005: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
1006: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
1007: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
1000: p_ca_tax_information7 in varchar2 default hr_api.g_varchar2,
1001: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
1002: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
1003: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
1004: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
1005: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
1006: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
1007: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
1008: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
1001: p_ca_tax_information8 in varchar2 default hr_api.g_varchar2,
1002: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
1003: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
1004: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
1005: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
1006: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
1007: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
1008: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
1009: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
1002: p_ca_tax_information9 in varchar2 default hr_api.g_varchar2,
1003: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
1004: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
1005: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
1006: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
1007: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
1008: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
1009: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
1010: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
1003: p_ca_tax_information10 in varchar2 default hr_api.g_varchar2,
1004: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
1005: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
1006: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
1007: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
1008: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
1009: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
1010: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
1011: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
1004: p_ca_tax_information11 in varchar2 default hr_api.g_varchar2,
1005: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
1006: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
1007: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
1008: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
1009: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
1010: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
1011: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
1012: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
1005: p_ca_tax_information12 in varchar2 default hr_api.g_varchar2,
1006: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
1007: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
1008: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
1009: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
1010: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
1011: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
1012: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
1013: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
1006: p_ca_tax_information13 in varchar2 default hr_api.g_varchar2,
1007: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
1008: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
1009: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
1010: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
1011: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
1012: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
1013: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
1014: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
1007: p_ca_tax_information14 in varchar2 default hr_api.g_varchar2,
1008: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
1009: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
1010: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
1011: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
1012: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
1013: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
1014: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
1015: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
1008: p_ca_tax_information15 in varchar2 default hr_api.g_varchar2,
1009: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
1010: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
1011: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
1012: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
1013: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
1014: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
1015: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
1016: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
1009: p_ca_tax_information16 in varchar2 default hr_api.g_varchar2,
1010: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
1011: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
1012: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
1013: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
1014: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
1015: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
1016: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
1017: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
1010: p_ca_tax_information17 in varchar2 default hr_api.g_varchar2,
1011: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
1012: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
1013: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
1014: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
1015: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
1016: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
1017: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
1018: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
1011: p_ca_tax_information18 in varchar2 default hr_api.g_varchar2,
1012: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
1013: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
1014: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
1015: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
1016: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
1017: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
1018: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
1019: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
1012: p_ca_tax_information19 in varchar2 default hr_api.g_varchar2,
1013: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
1014: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
1015: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
1016: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
1017: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
1018: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
1019: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
1020: p_ca_tax_information27 in varchar2 default hr_api.g_varchar2,
1013: p_ca_tax_information20 in varchar2 default hr_api.g_varchar2,
1014: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
1015: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
1016: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
1017: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
1018: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
1019: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
1020: p_ca_tax_information27 in varchar2 default hr_api.g_varchar2,
1021: p_ca_tax_information28 in varchar2 default hr_api.g_varchar2,
1014: p_ca_tax_information21 in varchar2 default hr_api.g_varchar2,
1015: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
1016: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
1017: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
1018: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
1019: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
1020: p_ca_tax_information27 in varchar2 default hr_api.g_varchar2,
1021: p_ca_tax_information28 in varchar2 default hr_api.g_varchar2,
1022: p_ca_tax_information29 in varchar2 default hr_api.g_varchar2,
1015: p_ca_tax_information22 in varchar2 default hr_api.g_varchar2,
1016: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
1017: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
1018: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
1019: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
1020: p_ca_tax_information27 in varchar2 default hr_api.g_varchar2,
1021: p_ca_tax_information28 in varchar2 default hr_api.g_varchar2,
1022: p_ca_tax_information29 in varchar2 default hr_api.g_varchar2,
1023: p_ca_tax_information30 in varchar2 default hr_api.g_varchar2,
1016: p_ca_tax_information23 in varchar2 default hr_api.g_varchar2,
1017: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
1018: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
1019: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
1020: p_ca_tax_information27 in varchar2 default hr_api.g_varchar2,
1021: p_ca_tax_information28 in varchar2 default hr_api.g_varchar2,
1022: p_ca_tax_information29 in varchar2 default hr_api.g_varchar2,
1023: p_ca_tax_information30 in varchar2 default hr_api.g_varchar2,
1024: p_object_version_number in out nocopy number,
1017: p_ca_tax_information24 in varchar2 default hr_api.g_varchar2,
1018: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
1019: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
1020: p_ca_tax_information27 in varchar2 default hr_api.g_varchar2,
1021: p_ca_tax_information28 in varchar2 default hr_api.g_varchar2,
1022: p_ca_tax_information29 in varchar2 default hr_api.g_varchar2,
1023: p_ca_tax_information30 in varchar2 default hr_api.g_varchar2,
1024: p_object_version_number in out nocopy number,
1025: p_prov_lsp_amount in number default hr_api.g_number,
1018: p_ca_tax_information25 in varchar2 default hr_api.g_varchar2,
1019: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
1020: p_ca_tax_information27 in varchar2 default hr_api.g_varchar2,
1021: p_ca_tax_information28 in varchar2 default hr_api.g_varchar2,
1022: p_ca_tax_information29 in varchar2 default hr_api.g_varchar2,
1023: p_ca_tax_information30 in varchar2 default hr_api.g_varchar2,
1024: p_object_version_number in out nocopy number,
1025: p_prov_lsp_amount in number default hr_api.g_number,
1026: p_effective_date in date,
1019: p_ca_tax_information26 in varchar2 default hr_api.g_varchar2,
1020: p_ca_tax_information27 in varchar2 default hr_api.g_varchar2,
1021: p_ca_tax_information28 in varchar2 default hr_api.g_varchar2,
1022: p_ca_tax_information29 in varchar2 default hr_api.g_varchar2,
1023: p_ca_tax_information30 in varchar2 default hr_api.g_varchar2,
1024: p_object_version_number in out nocopy number,
1025: p_prov_lsp_amount in number default hr_api.g_number,
1026: p_effective_date in date,
1027: p_datetrack_mode in varchar2,
1021: p_ca_tax_information28 in varchar2 default hr_api.g_varchar2,
1022: p_ca_tax_information29 in varchar2 default hr_api.g_varchar2,
1023: p_ca_tax_information30 in varchar2 default hr_api.g_varchar2,
1024: p_object_version_number in out nocopy number,
1025: p_prov_lsp_amount in number default hr_api.g_number,
1026: p_effective_date in date,
1027: p_datetrack_mode in varchar2,
1028: p_ppip_exempt_flag in varchar2 default hr_api.g_varchar2
1029: ) is
1024: p_object_version_number in out nocopy number,
1025: p_prov_lsp_amount in number default hr_api.g_number,
1026: p_effective_date in date,
1027: p_datetrack_mode in varchar2,
1028: p_ppip_exempt_flag in varchar2 default hr_api.g_varchar2
1029: ) is
1030: --
1031: l_rec pay_cpt_shd.g_rec_type;
1032: l_proc varchar2(72) := g_package||'upd';