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_ppm_shd.g_api_dml := false; -- Unset the api dml status
166: pay_ppm_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_ppm_shd.g_api_dml := false; -- Unset the api dml status
166: pay_ppm_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_ppm_shd.g_api_dml := false; -- Unset the api dml status
171: pay_ppm_shd.constraint_error
164: -- A check constraint has been violated
165: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
166: pay_ppm_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_ppm_shd.g_api_dml := false; -- Unset the api dml status
171: pay_ppm_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_ppm_shd.g_api_dml := false; -- Unset the api dml status
171: pay_ppm_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status
175: Raise;
176: End dt_update_dml;
638: ,p_ppm_information30_o
639: => pay_ppm_shd.g_old_rec.ppm_information30
640: );
641: exception
642: when hr_api.cannot_find_prog_unit then
643: hr_api.cannot_find_prog_unit_error
644: (p_module_name => 'PAY_PERSONAL_PAYMENT_METHODS_F'
645: ,p_hook_type => 'AU'
646: );
639: => pay_ppm_shd.g_old_rec.ppm_information30
640: );
641: exception
642: when hr_api.cannot_find_prog_unit then
643: hr_api.cannot_find_prog_unit_error
644: (p_module_name => 'PAY_PERSONAL_PAYMENT_METHODS_F'
645: ,p_hook_type => 'AU'
646: );
647: end;
666: -- p_rec plsql record structure
667: -- to see if a system default is being used. If a system default
668: -- is being used then we must set to the 'current' argument value.
669: --
670: If (p_rec.business_group_id = hr_api.g_number) then
671: p_rec.business_group_id :=
672: pay_ppm_shd.g_old_rec.business_group_id;
673: End If;
674: If (p_rec.external_account_id = hr_api.g_number) then
670: If (p_rec.business_group_id = hr_api.g_number) then
671: p_rec.business_group_id :=
672: pay_ppm_shd.g_old_rec.business_group_id;
673: End If;
674: If (p_rec.external_account_id = hr_api.g_number) then
675: p_rec.external_account_id :=
676: pay_ppm_shd.g_old_rec.external_account_id;
677: End If;
678: If (p_rec.assignment_id = hr_api.g_number) then
674: If (p_rec.external_account_id = hr_api.g_number) then
675: p_rec.external_account_id :=
676: pay_ppm_shd.g_old_rec.external_account_id;
677: End If;
678: If (p_rec.assignment_id = hr_api.g_number) then
679: p_rec.assignment_id :=
680: pay_ppm_shd.g_old_rec.assignment_id;
681: End If;
682: If (p_rec.run_Type_id = hr_api.g_number) then
678: If (p_rec.assignment_id = hr_api.g_number) then
679: p_rec.assignment_id :=
680: pay_ppm_shd.g_old_rec.assignment_id;
681: End If;
682: If (p_rec.run_Type_id = hr_api.g_number) then
683: p_rec.run_Type_id :=
684: pay_ppm_shd.g_old_rec.run_Type_id;
685: End If;
686: If (p_rec.org_payment_method_id = hr_api.g_number) then
682: If (p_rec.run_Type_id = hr_api.g_number) then
683: p_rec.run_Type_id :=
684: pay_ppm_shd.g_old_rec.run_Type_id;
685: End If;
686: If (p_rec.org_payment_method_id = hr_api.g_number) then
687: p_rec.org_payment_method_id :=
688: pay_ppm_shd.g_old_rec.org_payment_method_id;
689: End If;
690: If (p_rec.amount = hr_api.g_number) then
686: If (p_rec.org_payment_method_id = hr_api.g_number) then
687: p_rec.org_payment_method_id :=
688: pay_ppm_shd.g_old_rec.org_payment_method_id;
689: End If;
690: If (p_rec.amount = hr_api.g_number) then
691: p_rec.amount :=
692: pay_ppm_shd.g_old_rec.amount;
693: End If;
694: If (p_rec.comment_id = hr_api.g_number) then
690: If (p_rec.amount = hr_api.g_number) then
691: p_rec.amount :=
692: pay_ppm_shd.g_old_rec.amount;
693: End If;
694: If (p_rec.comment_id = hr_api.g_number) then
695: p_rec.comment_id :=
696: pay_ppm_shd.g_old_rec.comment_id;
697: End If;
698: If (p_rec.comments = hr_api.g_varchar2) then
694: If (p_rec.comment_id = hr_api.g_number) then
695: p_rec.comment_id :=
696: pay_ppm_shd.g_old_rec.comment_id;
697: End If;
698: If (p_rec.comments = hr_api.g_varchar2) then
699: p_rec.comments :=
700: pay_ppm_shd.g_old_rec.comments;
701: End If;
702: If (p_rec.percentage = hr_api.g_number) then
698: If (p_rec.comments = hr_api.g_varchar2) then
699: p_rec.comments :=
700: pay_ppm_shd.g_old_rec.comments;
701: End If;
702: If (p_rec.percentage = hr_api.g_number) then
703: p_rec.percentage :=
704: pay_ppm_shd.g_old_rec.percentage;
705: End If;
706: If (p_rec.priority = hr_api.g_number) then
702: If (p_rec.percentage = hr_api.g_number) then
703: p_rec.percentage :=
704: pay_ppm_shd.g_old_rec.percentage;
705: End If;
706: If (p_rec.priority = hr_api.g_number) then
707: p_rec.priority :=
708: pay_ppm_shd.g_old_rec.priority;
709: End If;
710: If (p_rec.attribute_category = hr_api.g_varchar2) then
706: If (p_rec.priority = hr_api.g_number) then
707: p_rec.priority :=
708: pay_ppm_shd.g_old_rec.priority;
709: End If;
710: If (p_rec.attribute_category = hr_api.g_varchar2) then
711: p_rec.attribute_category :=
712: pay_ppm_shd.g_old_rec.attribute_category;
713: End If;
714: If (p_rec.attribute1 = hr_api.g_varchar2) then
710: If (p_rec.attribute_category = hr_api.g_varchar2) then
711: p_rec.attribute_category :=
712: pay_ppm_shd.g_old_rec.attribute_category;
713: End If;
714: If (p_rec.attribute1 = hr_api.g_varchar2) then
715: p_rec.attribute1 :=
716: pay_ppm_shd.g_old_rec.attribute1;
717: End If;
718: If (p_rec.attribute2 = hr_api.g_varchar2) then
714: If (p_rec.attribute1 = hr_api.g_varchar2) then
715: p_rec.attribute1 :=
716: pay_ppm_shd.g_old_rec.attribute1;
717: End If;
718: If (p_rec.attribute2 = hr_api.g_varchar2) then
719: p_rec.attribute2 :=
720: pay_ppm_shd.g_old_rec.attribute2;
721: End If;
722: If (p_rec.attribute3 = hr_api.g_varchar2) then
718: If (p_rec.attribute2 = hr_api.g_varchar2) then
719: p_rec.attribute2 :=
720: pay_ppm_shd.g_old_rec.attribute2;
721: End If;
722: If (p_rec.attribute3 = hr_api.g_varchar2) then
723: p_rec.attribute3 :=
724: pay_ppm_shd.g_old_rec.attribute3;
725: End If;
726: If (p_rec.attribute4 = hr_api.g_varchar2) then
722: If (p_rec.attribute3 = hr_api.g_varchar2) then
723: p_rec.attribute3 :=
724: pay_ppm_shd.g_old_rec.attribute3;
725: End If;
726: If (p_rec.attribute4 = hr_api.g_varchar2) then
727: p_rec.attribute4 :=
728: pay_ppm_shd.g_old_rec.attribute4;
729: End If;
730: If (p_rec.attribute5 = hr_api.g_varchar2) then
726: If (p_rec.attribute4 = hr_api.g_varchar2) then
727: p_rec.attribute4 :=
728: pay_ppm_shd.g_old_rec.attribute4;
729: End If;
730: If (p_rec.attribute5 = hr_api.g_varchar2) then
731: p_rec.attribute5 :=
732: pay_ppm_shd.g_old_rec.attribute5;
733: End If;
734: If (p_rec.attribute6 = hr_api.g_varchar2) then
730: If (p_rec.attribute5 = hr_api.g_varchar2) then
731: p_rec.attribute5 :=
732: pay_ppm_shd.g_old_rec.attribute5;
733: End If;
734: If (p_rec.attribute6 = hr_api.g_varchar2) then
735: p_rec.attribute6 :=
736: pay_ppm_shd.g_old_rec.attribute6;
737: End If;
738: If (p_rec.attribute7 = hr_api.g_varchar2) then
734: If (p_rec.attribute6 = hr_api.g_varchar2) then
735: p_rec.attribute6 :=
736: pay_ppm_shd.g_old_rec.attribute6;
737: End If;
738: If (p_rec.attribute7 = hr_api.g_varchar2) then
739: p_rec.attribute7 :=
740: pay_ppm_shd.g_old_rec.attribute7;
741: End If;
742: If (p_rec.attribute8 = hr_api.g_varchar2) then
738: If (p_rec.attribute7 = hr_api.g_varchar2) then
739: p_rec.attribute7 :=
740: pay_ppm_shd.g_old_rec.attribute7;
741: End If;
742: If (p_rec.attribute8 = hr_api.g_varchar2) then
743: p_rec.attribute8 :=
744: pay_ppm_shd.g_old_rec.attribute8;
745: End If;
746: If (p_rec.attribute9 = hr_api.g_varchar2) then
742: If (p_rec.attribute8 = hr_api.g_varchar2) then
743: p_rec.attribute8 :=
744: pay_ppm_shd.g_old_rec.attribute8;
745: End If;
746: If (p_rec.attribute9 = hr_api.g_varchar2) then
747: p_rec.attribute9 :=
748: pay_ppm_shd.g_old_rec.attribute9;
749: End If;
750: If (p_rec.attribute10 = hr_api.g_varchar2) then
746: If (p_rec.attribute9 = hr_api.g_varchar2) then
747: p_rec.attribute9 :=
748: pay_ppm_shd.g_old_rec.attribute9;
749: End If;
750: If (p_rec.attribute10 = hr_api.g_varchar2) then
751: p_rec.attribute10 :=
752: pay_ppm_shd.g_old_rec.attribute10;
753: End If;
754: If (p_rec.attribute11 = hr_api.g_varchar2) then
750: If (p_rec.attribute10 = hr_api.g_varchar2) then
751: p_rec.attribute10 :=
752: pay_ppm_shd.g_old_rec.attribute10;
753: End If;
754: If (p_rec.attribute11 = hr_api.g_varchar2) then
755: p_rec.attribute11 :=
756: pay_ppm_shd.g_old_rec.attribute11;
757: End If;
758: If (p_rec.attribute12 = hr_api.g_varchar2) then
754: If (p_rec.attribute11 = hr_api.g_varchar2) then
755: p_rec.attribute11 :=
756: pay_ppm_shd.g_old_rec.attribute11;
757: End If;
758: If (p_rec.attribute12 = hr_api.g_varchar2) then
759: p_rec.attribute12 :=
760: pay_ppm_shd.g_old_rec.attribute12;
761: End If;
762: If (p_rec.attribute13 = hr_api.g_varchar2) then
758: If (p_rec.attribute12 = hr_api.g_varchar2) then
759: p_rec.attribute12 :=
760: pay_ppm_shd.g_old_rec.attribute12;
761: End If;
762: If (p_rec.attribute13 = hr_api.g_varchar2) then
763: p_rec.attribute13 :=
764: pay_ppm_shd.g_old_rec.attribute13;
765: End If;
766: If (p_rec.attribute14 = hr_api.g_varchar2) then
762: If (p_rec.attribute13 = hr_api.g_varchar2) then
763: p_rec.attribute13 :=
764: pay_ppm_shd.g_old_rec.attribute13;
765: End If;
766: If (p_rec.attribute14 = hr_api.g_varchar2) then
767: p_rec.attribute14 :=
768: pay_ppm_shd.g_old_rec.attribute14;
769: End If;
770: If (p_rec.attribute15 = hr_api.g_varchar2) then
766: If (p_rec.attribute14 = hr_api.g_varchar2) then
767: p_rec.attribute14 :=
768: pay_ppm_shd.g_old_rec.attribute14;
769: End If;
770: If (p_rec.attribute15 = hr_api.g_varchar2) then
771: p_rec.attribute15 :=
772: pay_ppm_shd.g_old_rec.attribute15;
773: End If;
774: If (p_rec.attribute16 = hr_api.g_varchar2) then
770: If (p_rec.attribute15 = hr_api.g_varchar2) then
771: p_rec.attribute15 :=
772: pay_ppm_shd.g_old_rec.attribute15;
773: End If;
774: If (p_rec.attribute16 = hr_api.g_varchar2) then
775: p_rec.attribute16 :=
776: pay_ppm_shd.g_old_rec.attribute16;
777: End If;
778: If (p_rec.attribute17 = hr_api.g_varchar2) then
774: If (p_rec.attribute16 = hr_api.g_varchar2) then
775: p_rec.attribute16 :=
776: pay_ppm_shd.g_old_rec.attribute16;
777: End If;
778: If (p_rec.attribute17 = hr_api.g_varchar2) then
779: p_rec.attribute17 :=
780: pay_ppm_shd.g_old_rec.attribute17;
781: End If;
782: If (p_rec.attribute18 = hr_api.g_varchar2) then
778: If (p_rec.attribute17 = hr_api.g_varchar2) then
779: p_rec.attribute17 :=
780: pay_ppm_shd.g_old_rec.attribute17;
781: End If;
782: If (p_rec.attribute18 = hr_api.g_varchar2) then
783: p_rec.attribute18 :=
784: pay_ppm_shd.g_old_rec.attribute18;
785: End If;
786: If (p_rec.attribute19 = hr_api.g_varchar2) then
782: If (p_rec.attribute18 = hr_api.g_varchar2) then
783: p_rec.attribute18 :=
784: pay_ppm_shd.g_old_rec.attribute18;
785: End If;
786: If (p_rec.attribute19 = hr_api.g_varchar2) then
787: p_rec.attribute19 :=
788: pay_ppm_shd.g_old_rec.attribute19;
789: End If;
790: If (p_rec.attribute20 = hr_api.g_varchar2) then
786: If (p_rec.attribute19 = hr_api.g_varchar2) then
787: p_rec.attribute19 :=
788: pay_ppm_shd.g_old_rec.attribute19;
789: End If;
790: If (p_rec.attribute20 = hr_api.g_varchar2) then
791: p_rec.attribute20 :=
792: pay_ppm_shd.g_old_rec.attribute20;
793: End If;
794: If (p_rec.payee_type = hr_api.g_varchar2) then
790: If (p_rec.attribute20 = hr_api.g_varchar2) then
791: p_rec.attribute20 :=
792: pay_ppm_shd.g_old_rec.attribute20;
793: End If;
794: If (p_rec.payee_type = hr_api.g_varchar2) then
795: p_rec.payee_type :=
796: pay_ppm_shd.g_old_rec.payee_type;
797: End If;
798: If (p_rec.payee_id = hr_api.g_number) then
794: If (p_rec.payee_type = hr_api.g_varchar2) then
795: p_rec.payee_type :=
796: pay_ppm_shd.g_old_rec.payee_type;
797: End If;
798: If (p_rec.payee_id = hr_api.g_number) then
799: p_rec.payee_id :=
800: pay_ppm_shd.g_old_rec.payee_id;
801: End If;
802: If (p_rec.ppm_information_category = hr_api.g_varchar2) then
798: If (p_rec.payee_id = hr_api.g_number) then
799: p_rec.payee_id :=
800: pay_ppm_shd.g_old_rec.payee_id;
801: End If;
802: If (p_rec.ppm_information_category = hr_api.g_varchar2) then
803: p_rec.ppm_information_category :=
804: pay_ppm_shd.g_old_rec.ppm_information_category;
805: End If;
806: If (p_rec.ppm_information1 = hr_api.g_varchar2) then
802: If (p_rec.ppm_information_category = hr_api.g_varchar2) then
803: p_rec.ppm_information_category :=
804: pay_ppm_shd.g_old_rec.ppm_information_category;
805: End If;
806: If (p_rec.ppm_information1 = hr_api.g_varchar2) then
807: p_rec.ppm_information1 :=
808: pay_ppm_shd.g_old_rec.ppm_information1;
809: End If;
810: If (p_rec.ppm_information2 = hr_api.g_varchar2) then
806: If (p_rec.ppm_information1 = hr_api.g_varchar2) then
807: p_rec.ppm_information1 :=
808: pay_ppm_shd.g_old_rec.ppm_information1;
809: End If;
810: If (p_rec.ppm_information2 = hr_api.g_varchar2) then
811: p_rec.ppm_information2 :=
812: pay_ppm_shd.g_old_rec.ppm_information2;
813: End If;
814: If (p_rec.ppm_information3 = hr_api.g_varchar2) then
810: If (p_rec.ppm_information2 = hr_api.g_varchar2) then
811: p_rec.ppm_information2 :=
812: pay_ppm_shd.g_old_rec.ppm_information2;
813: End If;
814: If (p_rec.ppm_information3 = hr_api.g_varchar2) then
815: p_rec.ppm_information3 :=
816: pay_ppm_shd.g_old_rec.ppm_information3;
817: End If;
818: If (p_rec.ppm_information4 = hr_api.g_varchar2) then
814: If (p_rec.ppm_information3 = hr_api.g_varchar2) then
815: p_rec.ppm_information3 :=
816: pay_ppm_shd.g_old_rec.ppm_information3;
817: End If;
818: If (p_rec.ppm_information4 = hr_api.g_varchar2) then
819: p_rec.ppm_information4 :=
820: pay_ppm_shd.g_old_rec.ppm_information4;
821: End If;
822: If (p_rec.ppm_information5 = hr_api.g_varchar2) then
818: If (p_rec.ppm_information4 = hr_api.g_varchar2) then
819: p_rec.ppm_information4 :=
820: pay_ppm_shd.g_old_rec.ppm_information4;
821: End If;
822: If (p_rec.ppm_information5 = hr_api.g_varchar2) then
823: p_rec.ppm_information5 :=
824: pay_ppm_shd.g_old_rec.ppm_information5;
825: End If;
826: If (p_rec.ppm_information6 = hr_api.g_varchar2) then
822: If (p_rec.ppm_information5 = hr_api.g_varchar2) then
823: p_rec.ppm_information5 :=
824: pay_ppm_shd.g_old_rec.ppm_information5;
825: End If;
826: If (p_rec.ppm_information6 = hr_api.g_varchar2) then
827: p_rec.ppm_information6 :=
828: pay_ppm_shd.g_old_rec.ppm_information6;
829: End If;
830: If (p_rec.ppm_information7 = hr_api.g_varchar2) then
826: If (p_rec.ppm_information6 = hr_api.g_varchar2) then
827: p_rec.ppm_information6 :=
828: pay_ppm_shd.g_old_rec.ppm_information6;
829: End If;
830: If (p_rec.ppm_information7 = hr_api.g_varchar2) then
831: p_rec.ppm_information7 :=
832: pay_ppm_shd.g_old_rec.ppm_information7;
833: End If;
834: If (p_rec.ppm_information8 = hr_api.g_varchar2) then
830: If (p_rec.ppm_information7 = hr_api.g_varchar2) then
831: p_rec.ppm_information7 :=
832: pay_ppm_shd.g_old_rec.ppm_information7;
833: End If;
834: If (p_rec.ppm_information8 = hr_api.g_varchar2) then
835: p_rec.ppm_information8 :=
836: pay_ppm_shd.g_old_rec.ppm_information8;
837: End If;
838: If (p_rec.ppm_information9 = hr_api.g_varchar2) then
834: If (p_rec.ppm_information8 = hr_api.g_varchar2) then
835: p_rec.ppm_information8 :=
836: pay_ppm_shd.g_old_rec.ppm_information8;
837: End If;
838: If (p_rec.ppm_information9 = hr_api.g_varchar2) then
839: p_rec.ppm_information9 :=
840: pay_ppm_shd.g_old_rec.ppm_information9;
841: End If;
842: If (p_rec.ppm_information10 = hr_api.g_varchar2) then
838: If (p_rec.ppm_information9 = hr_api.g_varchar2) then
839: p_rec.ppm_information9 :=
840: pay_ppm_shd.g_old_rec.ppm_information9;
841: End If;
842: If (p_rec.ppm_information10 = hr_api.g_varchar2) then
843: p_rec.ppm_information10 :=
844: pay_ppm_shd.g_old_rec.ppm_information10;
845: End If;
846: If (p_rec.ppm_information11 = hr_api.g_varchar2) then
842: If (p_rec.ppm_information10 = hr_api.g_varchar2) then
843: p_rec.ppm_information10 :=
844: pay_ppm_shd.g_old_rec.ppm_information10;
845: End If;
846: If (p_rec.ppm_information11 = hr_api.g_varchar2) then
847: p_rec.ppm_information11 :=
848: pay_ppm_shd.g_old_rec.ppm_information11;
849: End If;
850: If (p_rec.ppm_information12 = hr_api.g_varchar2) then
846: If (p_rec.ppm_information11 = hr_api.g_varchar2) then
847: p_rec.ppm_information11 :=
848: pay_ppm_shd.g_old_rec.ppm_information11;
849: End If;
850: If (p_rec.ppm_information12 = hr_api.g_varchar2) then
851: p_rec.ppm_information12 :=
852: pay_ppm_shd.g_old_rec.ppm_information12;
853: End If;
854: If (p_rec.ppm_information13 = hr_api.g_varchar2) then
850: If (p_rec.ppm_information12 = hr_api.g_varchar2) then
851: p_rec.ppm_information12 :=
852: pay_ppm_shd.g_old_rec.ppm_information12;
853: End If;
854: If (p_rec.ppm_information13 = hr_api.g_varchar2) then
855: p_rec.ppm_information13 :=
856: pay_ppm_shd.g_old_rec.ppm_information13;
857: End If;
858: If (p_rec.ppm_information14 = hr_api.g_varchar2) then
854: If (p_rec.ppm_information13 = hr_api.g_varchar2) then
855: p_rec.ppm_information13 :=
856: pay_ppm_shd.g_old_rec.ppm_information13;
857: End If;
858: If (p_rec.ppm_information14 = hr_api.g_varchar2) then
859: p_rec.ppm_information14 :=
860: pay_ppm_shd.g_old_rec.ppm_information14;
861: End If;
862: If (p_rec.ppm_information15 = hr_api.g_varchar2) then
858: If (p_rec.ppm_information14 = hr_api.g_varchar2) then
859: p_rec.ppm_information14 :=
860: pay_ppm_shd.g_old_rec.ppm_information14;
861: End If;
862: If (p_rec.ppm_information15 = hr_api.g_varchar2) then
863: p_rec.ppm_information15 :=
864: pay_ppm_shd.g_old_rec.ppm_information15;
865: End If;
866: If (p_rec.ppm_information16 = hr_api.g_varchar2) then
862: If (p_rec.ppm_information15 = hr_api.g_varchar2) then
863: p_rec.ppm_information15 :=
864: pay_ppm_shd.g_old_rec.ppm_information15;
865: End If;
866: If (p_rec.ppm_information16 = hr_api.g_varchar2) then
867: p_rec.ppm_information16 :=
868: pay_ppm_shd.g_old_rec.ppm_information16;
869: End If;
870: If (p_rec.ppm_information17 = hr_api.g_varchar2) then
866: If (p_rec.ppm_information16 = hr_api.g_varchar2) then
867: p_rec.ppm_information16 :=
868: pay_ppm_shd.g_old_rec.ppm_information16;
869: End If;
870: If (p_rec.ppm_information17 = hr_api.g_varchar2) then
871: p_rec.ppm_information17 :=
872: pay_ppm_shd.g_old_rec.ppm_information17;
873: End If;
874: If (p_rec.ppm_information18 = hr_api.g_varchar2) then
870: If (p_rec.ppm_information17 = hr_api.g_varchar2) then
871: p_rec.ppm_information17 :=
872: pay_ppm_shd.g_old_rec.ppm_information17;
873: End If;
874: If (p_rec.ppm_information18 = hr_api.g_varchar2) then
875: p_rec.ppm_information18 :=
876: pay_ppm_shd.g_old_rec.ppm_information18;
877: End If;
878: If (p_rec.ppm_information19 = hr_api.g_varchar2) then
874: If (p_rec.ppm_information18 = hr_api.g_varchar2) then
875: p_rec.ppm_information18 :=
876: pay_ppm_shd.g_old_rec.ppm_information18;
877: End If;
878: If (p_rec.ppm_information19 = hr_api.g_varchar2) then
879: p_rec.ppm_information19 :=
880: pay_ppm_shd.g_old_rec.ppm_information19;
881: End If;
882: If (p_rec.ppm_information20 = hr_api.g_varchar2) then
878: If (p_rec.ppm_information19 = hr_api.g_varchar2) then
879: p_rec.ppm_information19 :=
880: pay_ppm_shd.g_old_rec.ppm_information19;
881: End If;
882: If (p_rec.ppm_information20 = hr_api.g_varchar2) then
883: p_rec.ppm_information20 :=
884: pay_ppm_shd.g_old_rec.ppm_information20;
885: End If;
886: If (p_rec.ppm_information21 = hr_api.g_varchar2) then
882: If (p_rec.ppm_information20 = hr_api.g_varchar2) then
883: p_rec.ppm_information20 :=
884: pay_ppm_shd.g_old_rec.ppm_information20;
885: End If;
886: If (p_rec.ppm_information21 = hr_api.g_varchar2) then
887: p_rec.ppm_information21 :=
888: pay_ppm_shd.g_old_rec.ppm_information21;
889: End If;
890: If (p_rec.ppm_information22 = hr_api.g_varchar2) then
886: If (p_rec.ppm_information21 = hr_api.g_varchar2) then
887: p_rec.ppm_information21 :=
888: pay_ppm_shd.g_old_rec.ppm_information21;
889: End If;
890: If (p_rec.ppm_information22 = hr_api.g_varchar2) then
891: p_rec.ppm_information22 :=
892: pay_ppm_shd.g_old_rec.ppm_information22;
893: End If;
894: If (p_rec.ppm_information23 = hr_api.g_varchar2) then
890: If (p_rec.ppm_information22 = hr_api.g_varchar2) then
891: p_rec.ppm_information22 :=
892: pay_ppm_shd.g_old_rec.ppm_information22;
893: End If;
894: If (p_rec.ppm_information23 = hr_api.g_varchar2) then
895: p_rec.ppm_information23 :=
896: pay_ppm_shd.g_old_rec.ppm_information23;
897: End If;
898: If (p_rec.ppm_information24 = hr_api.g_varchar2) then
894: If (p_rec.ppm_information23 = hr_api.g_varchar2) then
895: p_rec.ppm_information23 :=
896: pay_ppm_shd.g_old_rec.ppm_information23;
897: End If;
898: If (p_rec.ppm_information24 = hr_api.g_varchar2) then
899: p_rec.ppm_information24 :=
900: pay_ppm_shd.g_old_rec.ppm_information24;
901: End If;
902: If (p_rec.ppm_information25 = hr_api.g_varchar2) then
898: If (p_rec.ppm_information24 = hr_api.g_varchar2) then
899: p_rec.ppm_information24 :=
900: pay_ppm_shd.g_old_rec.ppm_information24;
901: End If;
902: If (p_rec.ppm_information25 = hr_api.g_varchar2) then
903: p_rec.ppm_information25 :=
904: pay_ppm_shd.g_old_rec.ppm_information25;
905: End If;
906: If (p_rec.ppm_information26 = hr_api.g_varchar2) then
902: If (p_rec.ppm_information25 = hr_api.g_varchar2) then
903: p_rec.ppm_information25 :=
904: pay_ppm_shd.g_old_rec.ppm_information25;
905: End If;
906: If (p_rec.ppm_information26 = hr_api.g_varchar2) then
907: p_rec.ppm_information26 :=
908: pay_ppm_shd.g_old_rec.ppm_information26;
909: End If;
910: If (p_rec.ppm_information27 = hr_api.g_varchar2) then
906: If (p_rec.ppm_information26 = hr_api.g_varchar2) then
907: p_rec.ppm_information26 :=
908: pay_ppm_shd.g_old_rec.ppm_information26;
909: End If;
910: If (p_rec.ppm_information27 = hr_api.g_varchar2) then
911: p_rec.ppm_information27 :=
912: pay_ppm_shd.g_old_rec.ppm_information27;
913: End If;
914: If (p_rec.ppm_information28 = hr_api.g_varchar2) then
910: If (p_rec.ppm_information27 = hr_api.g_varchar2) then
911: p_rec.ppm_information27 :=
912: pay_ppm_shd.g_old_rec.ppm_information27;
913: End If;
914: If (p_rec.ppm_information28 = hr_api.g_varchar2) then
915: p_rec.ppm_information28 :=
916: pay_ppm_shd.g_old_rec.ppm_information28;
917: End If;
918: If (p_rec.ppm_information29 = hr_api.g_varchar2) then
914: If (p_rec.ppm_information28 = hr_api.g_varchar2) then
915: p_rec.ppm_information28 :=
916: pay_ppm_shd.g_old_rec.ppm_information28;
917: End If;
918: If (p_rec.ppm_information29 = hr_api.g_varchar2) then
919: p_rec.ppm_information29 :=
920: pay_ppm_shd.g_old_rec.ppm_information29;
921: End If;
922: If (p_rec.ppm_information30 = hr_api.g_varchar2) then
918: If (p_rec.ppm_information29 = hr_api.g_varchar2) then
919: p_rec.ppm_information29 :=
920: pay_ppm_shd.g_old_rec.ppm_information29;
921: End If;
922: If (p_rec.ppm_information30 = hr_api.g_varchar2) then
923: p_rec.ppm_information30 :=
924: pay_ppm_shd.g_old_rec.ppm_information30;
925: End If;
926: --
1021: --
1022: -- If we are validating then raise the Validate_Enabled exception
1023: --
1024: If p_validate then
1025: Raise HR_Api.Validate_Enabled;
1026: End If;
1027: --
1028: hr_utility.set_location(' Leaving:'||l_proc, 10);
1029: Exception
1026: End If;
1027: --
1028: hr_utility.set_location(' Leaving:'||l_proc, 10);
1029: Exception
1030: When HR_Api.Validate_Enabled Then
1031: --
1032: -- As the Validate_Enabled exception has been raised
1033: -- we must rollback to the savepoint
1034: --
1047: (
1048: p_personal_payment_method_id in number,
1049: p_effective_start_date out nocopy date,
1050: p_effective_end_date out nocopy date,
1051: p_external_account_id in number default hr_api.g_number,
1052: p_amount in number default hr_api.g_number,
1053: p_comment_id out nocopy number,
1054: p_comments in varchar2 default hr_api.g_varchar2,
1055: p_percentage in number default hr_api.g_number,
1048: p_personal_payment_method_id in number,
1049: p_effective_start_date out nocopy date,
1050: p_effective_end_date out nocopy date,
1051: p_external_account_id in number default hr_api.g_number,
1052: p_amount in number default hr_api.g_number,
1053: p_comment_id out nocopy number,
1054: p_comments in varchar2 default hr_api.g_varchar2,
1055: p_percentage in number default hr_api.g_number,
1056: p_priority in number default hr_api.g_number,
1050: p_effective_end_date out nocopy date,
1051: p_external_account_id in number default hr_api.g_number,
1052: p_amount in number default hr_api.g_number,
1053: p_comment_id out nocopy number,
1054: p_comments in varchar2 default hr_api.g_varchar2,
1055: p_percentage in number default hr_api.g_number,
1056: p_priority in number default hr_api.g_number,
1057: p_attribute_category in varchar2 default hr_api.g_varchar2,
1058: p_attribute1 in varchar2 default hr_api.g_varchar2,
1051: p_external_account_id in number default hr_api.g_number,
1052: p_amount in number default hr_api.g_number,
1053: p_comment_id out nocopy number,
1054: p_comments in varchar2 default hr_api.g_varchar2,
1055: p_percentage in number default hr_api.g_number,
1056: p_priority in number default hr_api.g_number,
1057: p_attribute_category in varchar2 default hr_api.g_varchar2,
1058: p_attribute1 in varchar2 default hr_api.g_varchar2,
1059: p_attribute2 in varchar2 default hr_api.g_varchar2,
1052: p_amount in number default hr_api.g_number,
1053: p_comment_id out nocopy number,
1054: p_comments in varchar2 default hr_api.g_varchar2,
1055: p_percentage in number default hr_api.g_number,
1056: p_priority in number default hr_api.g_number,
1057: p_attribute_category in varchar2 default hr_api.g_varchar2,
1058: p_attribute1 in varchar2 default hr_api.g_varchar2,
1059: p_attribute2 in varchar2 default hr_api.g_varchar2,
1060: p_attribute3 in varchar2 default hr_api.g_varchar2,
1053: p_comment_id out nocopy number,
1054: p_comments in varchar2 default hr_api.g_varchar2,
1055: p_percentage in number default hr_api.g_number,
1056: p_priority in number default hr_api.g_number,
1057: p_attribute_category in varchar2 default hr_api.g_varchar2,
1058: p_attribute1 in varchar2 default hr_api.g_varchar2,
1059: p_attribute2 in varchar2 default hr_api.g_varchar2,
1060: p_attribute3 in varchar2 default hr_api.g_varchar2,
1061: p_attribute4 in varchar2 default hr_api.g_varchar2,
1054: p_comments in varchar2 default hr_api.g_varchar2,
1055: p_percentage in number default hr_api.g_number,
1056: p_priority in number default hr_api.g_number,
1057: p_attribute_category in varchar2 default hr_api.g_varchar2,
1058: p_attribute1 in varchar2 default hr_api.g_varchar2,
1059: p_attribute2 in varchar2 default hr_api.g_varchar2,
1060: p_attribute3 in varchar2 default hr_api.g_varchar2,
1061: p_attribute4 in varchar2 default hr_api.g_varchar2,
1062: p_attribute5 in varchar2 default hr_api.g_varchar2,
1055: p_percentage in number default hr_api.g_number,
1056: p_priority in number default hr_api.g_number,
1057: p_attribute_category in varchar2 default hr_api.g_varchar2,
1058: p_attribute1 in varchar2 default hr_api.g_varchar2,
1059: p_attribute2 in varchar2 default hr_api.g_varchar2,
1060: p_attribute3 in varchar2 default hr_api.g_varchar2,
1061: p_attribute4 in varchar2 default hr_api.g_varchar2,
1062: p_attribute5 in varchar2 default hr_api.g_varchar2,
1063: p_attribute6 in varchar2 default hr_api.g_varchar2,
1056: p_priority in number default hr_api.g_number,
1057: p_attribute_category in varchar2 default hr_api.g_varchar2,
1058: p_attribute1 in varchar2 default hr_api.g_varchar2,
1059: p_attribute2 in varchar2 default hr_api.g_varchar2,
1060: p_attribute3 in varchar2 default hr_api.g_varchar2,
1061: p_attribute4 in varchar2 default hr_api.g_varchar2,
1062: p_attribute5 in varchar2 default hr_api.g_varchar2,
1063: p_attribute6 in varchar2 default hr_api.g_varchar2,
1064: p_attribute7 in varchar2 default hr_api.g_varchar2,
1057: p_attribute_category in varchar2 default hr_api.g_varchar2,
1058: p_attribute1 in varchar2 default hr_api.g_varchar2,
1059: p_attribute2 in varchar2 default hr_api.g_varchar2,
1060: p_attribute3 in varchar2 default hr_api.g_varchar2,
1061: p_attribute4 in varchar2 default hr_api.g_varchar2,
1062: p_attribute5 in varchar2 default hr_api.g_varchar2,
1063: p_attribute6 in varchar2 default hr_api.g_varchar2,
1064: p_attribute7 in varchar2 default hr_api.g_varchar2,
1065: p_attribute8 in varchar2 default hr_api.g_varchar2,
1058: p_attribute1 in varchar2 default hr_api.g_varchar2,
1059: p_attribute2 in varchar2 default hr_api.g_varchar2,
1060: p_attribute3 in varchar2 default hr_api.g_varchar2,
1061: p_attribute4 in varchar2 default hr_api.g_varchar2,
1062: p_attribute5 in varchar2 default hr_api.g_varchar2,
1063: p_attribute6 in varchar2 default hr_api.g_varchar2,
1064: p_attribute7 in varchar2 default hr_api.g_varchar2,
1065: p_attribute8 in varchar2 default hr_api.g_varchar2,
1066: p_attribute9 in varchar2 default hr_api.g_varchar2,
1059: p_attribute2 in varchar2 default hr_api.g_varchar2,
1060: p_attribute3 in varchar2 default hr_api.g_varchar2,
1061: p_attribute4 in varchar2 default hr_api.g_varchar2,
1062: p_attribute5 in varchar2 default hr_api.g_varchar2,
1063: p_attribute6 in varchar2 default hr_api.g_varchar2,
1064: p_attribute7 in varchar2 default hr_api.g_varchar2,
1065: p_attribute8 in varchar2 default hr_api.g_varchar2,
1066: p_attribute9 in varchar2 default hr_api.g_varchar2,
1067: p_attribute10 in varchar2 default hr_api.g_varchar2,
1060: p_attribute3 in varchar2 default hr_api.g_varchar2,
1061: p_attribute4 in varchar2 default hr_api.g_varchar2,
1062: p_attribute5 in varchar2 default hr_api.g_varchar2,
1063: p_attribute6 in varchar2 default hr_api.g_varchar2,
1064: p_attribute7 in varchar2 default hr_api.g_varchar2,
1065: p_attribute8 in varchar2 default hr_api.g_varchar2,
1066: p_attribute9 in varchar2 default hr_api.g_varchar2,
1067: p_attribute10 in varchar2 default hr_api.g_varchar2,
1068: p_attribute11 in varchar2 default hr_api.g_varchar2,
1061: p_attribute4 in varchar2 default hr_api.g_varchar2,
1062: p_attribute5 in varchar2 default hr_api.g_varchar2,
1063: p_attribute6 in varchar2 default hr_api.g_varchar2,
1064: p_attribute7 in varchar2 default hr_api.g_varchar2,
1065: p_attribute8 in varchar2 default hr_api.g_varchar2,
1066: p_attribute9 in varchar2 default hr_api.g_varchar2,
1067: p_attribute10 in varchar2 default hr_api.g_varchar2,
1068: p_attribute11 in varchar2 default hr_api.g_varchar2,
1069: p_attribute12 in varchar2 default hr_api.g_varchar2,
1062: p_attribute5 in varchar2 default hr_api.g_varchar2,
1063: p_attribute6 in varchar2 default hr_api.g_varchar2,
1064: p_attribute7 in varchar2 default hr_api.g_varchar2,
1065: p_attribute8 in varchar2 default hr_api.g_varchar2,
1066: p_attribute9 in varchar2 default hr_api.g_varchar2,
1067: p_attribute10 in varchar2 default hr_api.g_varchar2,
1068: p_attribute11 in varchar2 default hr_api.g_varchar2,
1069: p_attribute12 in varchar2 default hr_api.g_varchar2,
1070: p_attribute13 in varchar2 default hr_api.g_varchar2,
1063: p_attribute6 in varchar2 default hr_api.g_varchar2,
1064: p_attribute7 in varchar2 default hr_api.g_varchar2,
1065: p_attribute8 in varchar2 default hr_api.g_varchar2,
1066: p_attribute9 in varchar2 default hr_api.g_varchar2,
1067: p_attribute10 in varchar2 default hr_api.g_varchar2,
1068: p_attribute11 in varchar2 default hr_api.g_varchar2,
1069: p_attribute12 in varchar2 default hr_api.g_varchar2,
1070: p_attribute13 in varchar2 default hr_api.g_varchar2,
1071: p_attribute14 in varchar2 default hr_api.g_varchar2,
1064: p_attribute7 in varchar2 default hr_api.g_varchar2,
1065: p_attribute8 in varchar2 default hr_api.g_varchar2,
1066: p_attribute9 in varchar2 default hr_api.g_varchar2,
1067: p_attribute10 in varchar2 default hr_api.g_varchar2,
1068: p_attribute11 in varchar2 default hr_api.g_varchar2,
1069: p_attribute12 in varchar2 default hr_api.g_varchar2,
1070: p_attribute13 in varchar2 default hr_api.g_varchar2,
1071: p_attribute14 in varchar2 default hr_api.g_varchar2,
1072: p_attribute15 in varchar2 default hr_api.g_varchar2,
1065: p_attribute8 in varchar2 default hr_api.g_varchar2,
1066: p_attribute9 in varchar2 default hr_api.g_varchar2,
1067: p_attribute10 in varchar2 default hr_api.g_varchar2,
1068: p_attribute11 in varchar2 default hr_api.g_varchar2,
1069: p_attribute12 in varchar2 default hr_api.g_varchar2,
1070: p_attribute13 in varchar2 default hr_api.g_varchar2,
1071: p_attribute14 in varchar2 default hr_api.g_varchar2,
1072: p_attribute15 in varchar2 default hr_api.g_varchar2,
1073: p_attribute16 in varchar2 default hr_api.g_varchar2,
1066: p_attribute9 in varchar2 default hr_api.g_varchar2,
1067: p_attribute10 in varchar2 default hr_api.g_varchar2,
1068: p_attribute11 in varchar2 default hr_api.g_varchar2,
1069: p_attribute12 in varchar2 default hr_api.g_varchar2,
1070: p_attribute13 in varchar2 default hr_api.g_varchar2,
1071: p_attribute14 in varchar2 default hr_api.g_varchar2,
1072: p_attribute15 in varchar2 default hr_api.g_varchar2,
1073: p_attribute16 in varchar2 default hr_api.g_varchar2,
1074: p_attribute17 in varchar2 default hr_api.g_varchar2,
1067: p_attribute10 in varchar2 default hr_api.g_varchar2,
1068: p_attribute11 in varchar2 default hr_api.g_varchar2,
1069: p_attribute12 in varchar2 default hr_api.g_varchar2,
1070: p_attribute13 in varchar2 default hr_api.g_varchar2,
1071: p_attribute14 in varchar2 default hr_api.g_varchar2,
1072: p_attribute15 in varchar2 default hr_api.g_varchar2,
1073: p_attribute16 in varchar2 default hr_api.g_varchar2,
1074: p_attribute17 in varchar2 default hr_api.g_varchar2,
1075: p_attribute18 in varchar2 default hr_api.g_varchar2,
1068: p_attribute11 in varchar2 default hr_api.g_varchar2,
1069: p_attribute12 in varchar2 default hr_api.g_varchar2,
1070: p_attribute13 in varchar2 default hr_api.g_varchar2,
1071: p_attribute14 in varchar2 default hr_api.g_varchar2,
1072: p_attribute15 in varchar2 default hr_api.g_varchar2,
1073: p_attribute16 in varchar2 default hr_api.g_varchar2,
1074: p_attribute17 in varchar2 default hr_api.g_varchar2,
1075: p_attribute18 in varchar2 default hr_api.g_varchar2,
1076: p_attribute19 in varchar2 default hr_api.g_varchar2,
1069: p_attribute12 in varchar2 default hr_api.g_varchar2,
1070: p_attribute13 in varchar2 default hr_api.g_varchar2,
1071: p_attribute14 in varchar2 default hr_api.g_varchar2,
1072: p_attribute15 in varchar2 default hr_api.g_varchar2,
1073: p_attribute16 in varchar2 default hr_api.g_varchar2,
1074: p_attribute17 in varchar2 default hr_api.g_varchar2,
1075: p_attribute18 in varchar2 default hr_api.g_varchar2,
1076: p_attribute19 in varchar2 default hr_api.g_varchar2,
1077: p_attribute20 in varchar2 default hr_api.g_varchar2,
1070: p_attribute13 in varchar2 default hr_api.g_varchar2,
1071: p_attribute14 in varchar2 default hr_api.g_varchar2,
1072: p_attribute15 in varchar2 default hr_api.g_varchar2,
1073: p_attribute16 in varchar2 default hr_api.g_varchar2,
1074: p_attribute17 in varchar2 default hr_api.g_varchar2,
1075: p_attribute18 in varchar2 default hr_api.g_varchar2,
1076: p_attribute19 in varchar2 default hr_api.g_varchar2,
1077: p_attribute20 in varchar2 default hr_api.g_varchar2,
1078: p_object_version_number in out nocopy number,
1071: p_attribute14 in varchar2 default hr_api.g_varchar2,
1072: p_attribute15 in varchar2 default hr_api.g_varchar2,
1073: p_attribute16 in varchar2 default hr_api.g_varchar2,
1074: p_attribute17 in varchar2 default hr_api.g_varchar2,
1075: p_attribute18 in varchar2 default hr_api.g_varchar2,
1076: p_attribute19 in varchar2 default hr_api.g_varchar2,
1077: p_attribute20 in varchar2 default hr_api.g_varchar2,
1078: p_object_version_number in out nocopy number,
1079: p_payee_type in varchar2 default hr_api.g_varchar2,
1072: p_attribute15 in varchar2 default hr_api.g_varchar2,
1073: p_attribute16 in varchar2 default hr_api.g_varchar2,
1074: p_attribute17 in varchar2 default hr_api.g_varchar2,
1075: p_attribute18 in varchar2 default hr_api.g_varchar2,
1076: p_attribute19 in varchar2 default hr_api.g_varchar2,
1077: p_attribute20 in varchar2 default hr_api.g_varchar2,
1078: p_object_version_number in out nocopy number,
1079: p_payee_type in varchar2 default hr_api.g_varchar2,
1080: p_payee_id in number default hr_api.g_number,
1073: p_attribute16 in varchar2 default hr_api.g_varchar2,
1074: p_attribute17 in varchar2 default hr_api.g_varchar2,
1075: p_attribute18 in varchar2 default hr_api.g_varchar2,
1076: p_attribute19 in varchar2 default hr_api.g_varchar2,
1077: p_attribute20 in varchar2 default hr_api.g_varchar2,
1078: p_object_version_number in out nocopy number,
1079: p_payee_type in varchar2 default hr_api.g_varchar2,
1080: p_payee_id in number default hr_api.g_number,
1081: p_effective_date in date,
1075: p_attribute18 in varchar2 default hr_api.g_varchar2,
1076: p_attribute19 in varchar2 default hr_api.g_varchar2,
1077: p_attribute20 in varchar2 default hr_api.g_varchar2,
1078: p_object_version_number in out nocopy number,
1079: p_payee_type in varchar2 default hr_api.g_varchar2,
1080: p_payee_id in number default hr_api.g_number,
1081: p_effective_date in date,
1082: p_datetrack_mode in varchar2,
1083: p_validate in boolean default false,
1076: p_attribute19 in varchar2 default hr_api.g_varchar2,
1077: p_attribute20 in varchar2 default hr_api.g_varchar2,
1078: p_object_version_number in out nocopy number,
1079: p_payee_type in varchar2 default hr_api.g_varchar2,
1080: p_payee_id in number default hr_api.g_number,
1081: p_effective_date in date,
1082: p_datetrack_mode in varchar2,
1083: p_validate in boolean default false,
1084: p_ppm_information_category in varchar2 default hr_api.g_varchar2,
1080: p_payee_id in number default hr_api.g_number,
1081: p_effective_date in date,
1082: p_datetrack_mode in varchar2,
1083: p_validate in boolean default false,
1084: p_ppm_information_category in varchar2 default hr_api.g_varchar2,
1085: p_ppm_information1 in varchar2 default hr_api.g_varchar2,
1086: p_ppm_information2 in varchar2 default hr_api.g_varchar2,
1087: p_ppm_information3 in varchar2 default hr_api.g_varchar2,
1088: p_ppm_information4 in varchar2 default hr_api.g_varchar2,
1081: p_effective_date in date,
1082: p_datetrack_mode in varchar2,
1083: p_validate in boolean default false,
1084: p_ppm_information_category in varchar2 default hr_api.g_varchar2,
1085: p_ppm_information1 in varchar2 default hr_api.g_varchar2,
1086: p_ppm_information2 in varchar2 default hr_api.g_varchar2,
1087: p_ppm_information3 in varchar2 default hr_api.g_varchar2,
1088: p_ppm_information4 in varchar2 default hr_api.g_varchar2,
1089: p_ppm_information5 in varchar2 default hr_api.g_varchar2,
1082: p_datetrack_mode in varchar2,
1083: p_validate in boolean default false,
1084: p_ppm_information_category in varchar2 default hr_api.g_varchar2,
1085: p_ppm_information1 in varchar2 default hr_api.g_varchar2,
1086: p_ppm_information2 in varchar2 default hr_api.g_varchar2,
1087: p_ppm_information3 in varchar2 default hr_api.g_varchar2,
1088: p_ppm_information4 in varchar2 default hr_api.g_varchar2,
1089: p_ppm_information5 in varchar2 default hr_api.g_varchar2,
1090: p_ppm_information6 in varchar2 default hr_api.g_varchar2,
1083: p_validate in boolean default false,
1084: p_ppm_information_category in varchar2 default hr_api.g_varchar2,
1085: p_ppm_information1 in varchar2 default hr_api.g_varchar2,
1086: p_ppm_information2 in varchar2 default hr_api.g_varchar2,
1087: p_ppm_information3 in varchar2 default hr_api.g_varchar2,
1088: p_ppm_information4 in varchar2 default hr_api.g_varchar2,
1089: p_ppm_information5 in varchar2 default hr_api.g_varchar2,
1090: p_ppm_information6 in varchar2 default hr_api.g_varchar2,
1091: p_ppm_information7 in varchar2 default hr_api.g_varchar2,
1084: p_ppm_information_category in varchar2 default hr_api.g_varchar2,
1085: p_ppm_information1 in varchar2 default hr_api.g_varchar2,
1086: p_ppm_information2 in varchar2 default hr_api.g_varchar2,
1087: p_ppm_information3 in varchar2 default hr_api.g_varchar2,
1088: p_ppm_information4 in varchar2 default hr_api.g_varchar2,
1089: p_ppm_information5 in varchar2 default hr_api.g_varchar2,
1090: p_ppm_information6 in varchar2 default hr_api.g_varchar2,
1091: p_ppm_information7 in varchar2 default hr_api.g_varchar2,
1092: p_ppm_information8 in varchar2 default hr_api.g_varchar2,
1085: p_ppm_information1 in varchar2 default hr_api.g_varchar2,
1086: p_ppm_information2 in varchar2 default hr_api.g_varchar2,
1087: p_ppm_information3 in varchar2 default hr_api.g_varchar2,
1088: p_ppm_information4 in varchar2 default hr_api.g_varchar2,
1089: p_ppm_information5 in varchar2 default hr_api.g_varchar2,
1090: p_ppm_information6 in varchar2 default hr_api.g_varchar2,
1091: p_ppm_information7 in varchar2 default hr_api.g_varchar2,
1092: p_ppm_information8 in varchar2 default hr_api.g_varchar2,
1093: p_ppm_information9 in varchar2 default hr_api.g_varchar2,
1086: p_ppm_information2 in varchar2 default hr_api.g_varchar2,
1087: p_ppm_information3 in varchar2 default hr_api.g_varchar2,
1088: p_ppm_information4 in varchar2 default hr_api.g_varchar2,
1089: p_ppm_information5 in varchar2 default hr_api.g_varchar2,
1090: p_ppm_information6 in varchar2 default hr_api.g_varchar2,
1091: p_ppm_information7 in varchar2 default hr_api.g_varchar2,
1092: p_ppm_information8 in varchar2 default hr_api.g_varchar2,
1093: p_ppm_information9 in varchar2 default hr_api.g_varchar2,
1094: p_ppm_information10 in varchar2 default hr_api.g_varchar2,
1087: p_ppm_information3 in varchar2 default hr_api.g_varchar2,
1088: p_ppm_information4 in varchar2 default hr_api.g_varchar2,
1089: p_ppm_information5 in varchar2 default hr_api.g_varchar2,
1090: p_ppm_information6 in varchar2 default hr_api.g_varchar2,
1091: p_ppm_information7 in varchar2 default hr_api.g_varchar2,
1092: p_ppm_information8 in varchar2 default hr_api.g_varchar2,
1093: p_ppm_information9 in varchar2 default hr_api.g_varchar2,
1094: p_ppm_information10 in varchar2 default hr_api.g_varchar2,
1095: p_ppm_information11 in varchar2 default hr_api.g_varchar2,
1088: p_ppm_information4 in varchar2 default hr_api.g_varchar2,
1089: p_ppm_information5 in varchar2 default hr_api.g_varchar2,
1090: p_ppm_information6 in varchar2 default hr_api.g_varchar2,
1091: p_ppm_information7 in varchar2 default hr_api.g_varchar2,
1092: p_ppm_information8 in varchar2 default hr_api.g_varchar2,
1093: p_ppm_information9 in varchar2 default hr_api.g_varchar2,
1094: p_ppm_information10 in varchar2 default hr_api.g_varchar2,
1095: p_ppm_information11 in varchar2 default hr_api.g_varchar2,
1096: p_ppm_information12 in varchar2 default hr_api.g_varchar2,
1089: p_ppm_information5 in varchar2 default hr_api.g_varchar2,
1090: p_ppm_information6 in varchar2 default hr_api.g_varchar2,
1091: p_ppm_information7 in varchar2 default hr_api.g_varchar2,
1092: p_ppm_information8 in varchar2 default hr_api.g_varchar2,
1093: p_ppm_information9 in varchar2 default hr_api.g_varchar2,
1094: p_ppm_information10 in varchar2 default hr_api.g_varchar2,
1095: p_ppm_information11 in varchar2 default hr_api.g_varchar2,
1096: p_ppm_information12 in varchar2 default hr_api.g_varchar2,
1097: p_ppm_information13 in varchar2 default hr_api.g_varchar2,
1090: p_ppm_information6 in varchar2 default hr_api.g_varchar2,
1091: p_ppm_information7 in varchar2 default hr_api.g_varchar2,
1092: p_ppm_information8 in varchar2 default hr_api.g_varchar2,
1093: p_ppm_information9 in varchar2 default hr_api.g_varchar2,
1094: p_ppm_information10 in varchar2 default hr_api.g_varchar2,
1095: p_ppm_information11 in varchar2 default hr_api.g_varchar2,
1096: p_ppm_information12 in varchar2 default hr_api.g_varchar2,
1097: p_ppm_information13 in varchar2 default hr_api.g_varchar2,
1098: p_ppm_information14 in varchar2 default hr_api.g_varchar2,
1091: p_ppm_information7 in varchar2 default hr_api.g_varchar2,
1092: p_ppm_information8 in varchar2 default hr_api.g_varchar2,
1093: p_ppm_information9 in varchar2 default hr_api.g_varchar2,
1094: p_ppm_information10 in varchar2 default hr_api.g_varchar2,
1095: p_ppm_information11 in varchar2 default hr_api.g_varchar2,
1096: p_ppm_information12 in varchar2 default hr_api.g_varchar2,
1097: p_ppm_information13 in varchar2 default hr_api.g_varchar2,
1098: p_ppm_information14 in varchar2 default hr_api.g_varchar2,
1099: p_ppm_information15 in varchar2 default hr_api.g_varchar2,
1092: p_ppm_information8 in varchar2 default hr_api.g_varchar2,
1093: p_ppm_information9 in varchar2 default hr_api.g_varchar2,
1094: p_ppm_information10 in varchar2 default hr_api.g_varchar2,
1095: p_ppm_information11 in varchar2 default hr_api.g_varchar2,
1096: p_ppm_information12 in varchar2 default hr_api.g_varchar2,
1097: p_ppm_information13 in varchar2 default hr_api.g_varchar2,
1098: p_ppm_information14 in varchar2 default hr_api.g_varchar2,
1099: p_ppm_information15 in varchar2 default hr_api.g_varchar2,
1100: p_ppm_information16 in varchar2 default hr_api.g_varchar2,
1093: p_ppm_information9 in varchar2 default hr_api.g_varchar2,
1094: p_ppm_information10 in varchar2 default hr_api.g_varchar2,
1095: p_ppm_information11 in varchar2 default hr_api.g_varchar2,
1096: p_ppm_information12 in varchar2 default hr_api.g_varchar2,
1097: p_ppm_information13 in varchar2 default hr_api.g_varchar2,
1098: p_ppm_information14 in varchar2 default hr_api.g_varchar2,
1099: p_ppm_information15 in varchar2 default hr_api.g_varchar2,
1100: p_ppm_information16 in varchar2 default hr_api.g_varchar2,
1101: p_ppm_information17 in varchar2 default hr_api.g_varchar2,
1094: p_ppm_information10 in varchar2 default hr_api.g_varchar2,
1095: p_ppm_information11 in varchar2 default hr_api.g_varchar2,
1096: p_ppm_information12 in varchar2 default hr_api.g_varchar2,
1097: p_ppm_information13 in varchar2 default hr_api.g_varchar2,
1098: p_ppm_information14 in varchar2 default hr_api.g_varchar2,
1099: p_ppm_information15 in varchar2 default hr_api.g_varchar2,
1100: p_ppm_information16 in varchar2 default hr_api.g_varchar2,
1101: p_ppm_information17 in varchar2 default hr_api.g_varchar2,
1102: p_ppm_information18 in varchar2 default hr_api.g_varchar2,
1095: p_ppm_information11 in varchar2 default hr_api.g_varchar2,
1096: p_ppm_information12 in varchar2 default hr_api.g_varchar2,
1097: p_ppm_information13 in varchar2 default hr_api.g_varchar2,
1098: p_ppm_information14 in varchar2 default hr_api.g_varchar2,
1099: p_ppm_information15 in varchar2 default hr_api.g_varchar2,
1100: p_ppm_information16 in varchar2 default hr_api.g_varchar2,
1101: p_ppm_information17 in varchar2 default hr_api.g_varchar2,
1102: p_ppm_information18 in varchar2 default hr_api.g_varchar2,
1103: p_ppm_information19 in varchar2 default hr_api.g_varchar2,
1096: p_ppm_information12 in varchar2 default hr_api.g_varchar2,
1097: p_ppm_information13 in varchar2 default hr_api.g_varchar2,
1098: p_ppm_information14 in varchar2 default hr_api.g_varchar2,
1099: p_ppm_information15 in varchar2 default hr_api.g_varchar2,
1100: p_ppm_information16 in varchar2 default hr_api.g_varchar2,
1101: p_ppm_information17 in varchar2 default hr_api.g_varchar2,
1102: p_ppm_information18 in varchar2 default hr_api.g_varchar2,
1103: p_ppm_information19 in varchar2 default hr_api.g_varchar2,
1104: p_ppm_information20 in varchar2 default hr_api.g_varchar2,
1097: p_ppm_information13 in varchar2 default hr_api.g_varchar2,
1098: p_ppm_information14 in varchar2 default hr_api.g_varchar2,
1099: p_ppm_information15 in varchar2 default hr_api.g_varchar2,
1100: p_ppm_information16 in varchar2 default hr_api.g_varchar2,
1101: p_ppm_information17 in varchar2 default hr_api.g_varchar2,
1102: p_ppm_information18 in varchar2 default hr_api.g_varchar2,
1103: p_ppm_information19 in varchar2 default hr_api.g_varchar2,
1104: p_ppm_information20 in varchar2 default hr_api.g_varchar2,
1105: p_ppm_information21 in varchar2 default hr_api.g_varchar2,
1098: p_ppm_information14 in varchar2 default hr_api.g_varchar2,
1099: p_ppm_information15 in varchar2 default hr_api.g_varchar2,
1100: p_ppm_information16 in varchar2 default hr_api.g_varchar2,
1101: p_ppm_information17 in varchar2 default hr_api.g_varchar2,
1102: p_ppm_information18 in varchar2 default hr_api.g_varchar2,
1103: p_ppm_information19 in varchar2 default hr_api.g_varchar2,
1104: p_ppm_information20 in varchar2 default hr_api.g_varchar2,
1105: p_ppm_information21 in varchar2 default hr_api.g_varchar2,
1106: p_ppm_information22 in varchar2 default hr_api.g_varchar2,
1099: p_ppm_information15 in varchar2 default hr_api.g_varchar2,
1100: p_ppm_information16 in varchar2 default hr_api.g_varchar2,
1101: p_ppm_information17 in varchar2 default hr_api.g_varchar2,
1102: p_ppm_information18 in varchar2 default hr_api.g_varchar2,
1103: p_ppm_information19 in varchar2 default hr_api.g_varchar2,
1104: p_ppm_information20 in varchar2 default hr_api.g_varchar2,
1105: p_ppm_information21 in varchar2 default hr_api.g_varchar2,
1106: p_ppm_information22 in varchar2 default hr_api.g_varchar2,
1107: p_ppm_information23 in varchar2 default hr_api.g_varchar2,
1100: p_ppm_information16 in varchar2 default hr_api.g_varchar2,
1101: p_ppm_information17 in varchar2 default hr_api.g_varchar2,
1102: p_ppm_information18 in varchar2 default hr_api.g_varchar2,
1103: p_ppm_information19 in varchar2 default hr_api.g_varchar2,
1104: p_ppm_information20 in varchar2 default hr_api.g_varchar2,
1105: p_ppm_information21 in varchar2 default hr_api.g_varchar2,
1106: p_ppm_information22 in varchar2 default hr_api.g_varchar2,
1107: p_ppm_information23 in varchar2 default hr_api.g_varchar2,
1108: p_ppm_information24 in varchar2 default hr_api.g_varchar2,
1101: p_ppm_information17 in varchar2 default hr_api.g_varchar2,
1102: p_ppm_information18 in varchar2 default hr_api.g_varchar2,
1103: p_ppm_information19 in varchar2 default hr_api.g_varchar2,
1104: p_ppm_information20 in varchar2 default hr_api.g_varchar2,
1105: p_ppm_information21 in varchar2 default hr_api.g_varchar2,
1106: p_ppm_information22 in varchar2 default hr_api.g_varchar2,
1107: p_ppm_information23 in varchar2 default hr_api.g_varchar2,
1108: p_ppm_information24 in varchar2 default hr_api.g_varchar2,
1109: p_ppm_information25 in varchar2 default hr_api.g_varchar2,
1102: p_ppm_information18 in varchar2 default hr_api.g_varchar2,
1103: p_ppm_information19 in varchar2 default hr_api.g_varchar2,
1104: p_ppm_information20 in varchar2 default hr_api.g_varchar2,
1105: p_ppm_information21 in varchar2 default hr_api.g_varchar2,
1106: p_ppm_information22 in varchar2 default hr_api.g_varchar2,
1107: p_ppm_information23 in varchar2 default hr_api.g_varchar2,
1108: p_ppm_information24 in varchar2 default hr_api.g_varchar2,
1109: p_ppm_information25 in varchar2 default hr_api.g_varchar2,
1110: p_ppm_information26 in varchar2 default hr_api.g_varchar2,
1103: p_ppm_information19 in varchar2 default hr_api.g_varchar2,
1104: p_ppm_information20 in varchar2 default hr_api.g_varchar2,
1105: p_ppm_information21 in varchar2 default hr_api.g_varchar2,
1106: p_ppm_information22 in varchar2 default hr_api.g_varchar2,
1107: p_ppm_information23 in varchar2 default hr_api.g_varchar2,
1108: p_ppm_information24 in varchar2 default hr_api.g_varchar2,
1109: p_ppm_information25 in varchar2 default hr_api.g_varchar2,
1110: p_ppm_information26 in varchar2 default hr_api.g_varchar2,
1111: p_ppm_information27 in varchar2 default hr_api.g_varchar2,
1104: p_ppm_information20 in varchar2 default hr_api.g_varchar2,
1105: p_ppm_information21 in varchar2 default hr_api.g_varchar2,
1106: p_ppm_information22 in varchar2 default hr_api.g_varchar2,
1107: p_ppm_information23 in varchar2 default hr_api.g_varchar2,
1108: p_ppm_information24 in varchar2 default hr_api.g_varchar2,
1109: p_ppm_information25 in varchar2 default hr_api.g_varchar2,
1110: p_ppm_information26 in varchar2 default hr_api.g_varchar2,
1111: p_ppm_information27 in varchar2 default hr_api.g_varchar2,
1112: p_ppm_information28 in varchar2 default hr_api.g_varchar2,
1105: p_ppm_information21 in varchar2 default hr_api.g_varchar2,
1106: p_ppm_information22 in varchar2 default hr_api.g_varchar2,
1107: p_ppm_information23 in varchar2 default hr_api.g_varchar2,
1108: p_ppm_information24 in varchar2 default hr_api.g_varchar2,
1109: p_ppm_information25 in varchar2 default hr_api.g_varchar2,
1110: p_ppm_information26 in varchar2 default hr_api.g_varchar2,
1111: p_ppm_information27 in varchar2 default hr_api.g_varchar2,
1112: p_ppm_information28 in varchar2 default hr_api.g_varchar2,
1113: p_ppm_information29 in varchar2 default hr_api.g_varchar2,
1106: p_ppm_information22 in varchar2 default hr_api.g_varchar2,
1107: p_ppm_information23 in varchar2 default hr_api.g_varchar2,
1108: p_ppm_information24 in varchar2 default hr_api.g_varchar2,
1109: p_ppm_information25 in varchar2 default hr_api.g_varchar2,
1110: p_ppm_information26 in varchar2 default hr_api.g_varchar2,
1111: p_ppm_information27 in varchar2 default hr_api.g_varchar2,
1112: p_ppm_information28 in varchar2 default hr_api.g_varchar2,
1113: p_ppm_information29 in varchar2 default hr_api.g_varchar2,
1114: p_ppm_information30 in varchar2 default hr_api.g_varchar2
1107: p_ppm_information23 in varchar2 default hr_api.g_varchar2,
1108: p_ppm_information24 in varchar2 default hr_api.g_varchar2,
1109: p_ppm_information25 in varchar2 default hr_api.g_varchar2,
1110: p_ppm_information26 in varchar2 default hr_api.g_varchar2,
1111: p_ppm_information27 in varchar2 default hr_api.g_varchar2,
1112: p_ppm_information28 in varchar2 default hr_api.g_varchar2,
1113: p_ppm_information29 in varchar2 default hr_api.g_varchar2,
1114: p_ppm_information30 in varchar2 default hr_api.g_varchar2
1115: ) is
1108: p_ppm_information24 in varchar2 default hr_api.g_varchar2,
1109: p_ppm_information25 in varchar2 default hr_api.g_varchar2,
1110: p_ppm_information26 in varchar2 default hr_api.g_varchar2,
1111: p_ppm_information27 in varchar2 default hr_api.g_varchar2,
1112: p_ppm_information28 in varchar2 default hr_api.g_varchar2,
1113: p_ppm_information29 in varchar2 default hr_api.g_varchar2,
1114: p_ppm_information30 in varchar2 default hr_api.g_varchar2
1115: ) is
1116: --
1109: p_ppm_information25 in varchar2 default hr_api.g_varchar2,
1110: p_ppm_information26 in varchar2 default hr_api.g_varchar2,
1111: p_ppm_information27 in varchar2 default hr_api.g_varchar2,
1112: p_ppm_information28 in varchar2 default hr_api.g_varchar2,
1113: p_ppm_information29 in varchar2 default hr_api.g_varchar2,
1114: p_ppm_information30 in varchar2 default hr_api.g_varchar2
1115: ) is
1116: --
1117: l_rec pay_ppm_shd.g_rec_type;
1110: p_ppm_information26 in varchar2 default hr_api.g_varchar2,
1111: p_ppm_information27 in varchar2 default hr_api.g_varchar2,
1112: p_ppm_information28 in varchar2 default hr_api.g_varchar2,
1113: p_ppm_information29 in varchar2 default hr_api.g_varchar2,
1114: p_ppm_information30 in varchar2 default hr_api.g_varchar2
1115: ) is
1116: --
1117: l_rec pay_ppm_shd.g_rec_type;
1118: l_proc varchar2(72) := g_package||'upd';
1128: (
1129: p_personal_payment_method_id,
1130: null,
1131: null,
1132: hr_api.g_number,
1133: p_external_account_id,
1134: hr_api.g_number,
1135: hr_api.g_number,
1136: hr_api.g_number,
1130: null,
1131: null,
1132: hr_api.g_number,
1133: p_external_account_id,
1134: hr_api.g_number,
1135: hr_api.g_number,
1136: hr_api.g_number,
1137: p_amount,
1138: hr_api.g_number,
1131: null,
1132: hr_api.g_number,
1133: p_external_account_id,
1134: hr_api.g_number,
1135: hr_api.g_number,
1136: hr_api.g_number,
1137: p_amount,
1138: hr_api.g_number,
1139: p_comments,
1132: hr_api.g_number,
1133: p_external_account_id,
1134: hr_api.g_number,
1135: hr_api.g_number,
1136: hr_api.g_number,
1137: p_amount,
1138: hr_api.g_number,
1139: p_comments,
1140: p_percentage,
1134: hr_api.g_number,
1135: hr_api.g_number,
1136: hr_api.g_number,
1137: p_amount,
1138: hr_api.g_number,
1139: p_comments,
1140: p_percentage,
1141: p_priority,
1142: p_attribute_category,