139: --
140: hr_utility.set_location(' Leaving:'||l_proc, 10);
141: --
142: Exception
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: per_pps_shd.g_api_dml := false; -- Unset the api dml status
146: per_pps_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
143: When hr_api.check_integrity_violated Then
144: -- A check constraint has been violated
145: per_pps_shd.g_api_dml := false; -- Unset the api dml status
146: per_pps_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: per_pps_shd.g_api_dml := false; -- Unset the api dml status
151: per_pps_shd.constraint_error
144: -- A check constraint has been violated
145: per_pps_shd.g_api_dml := false; -- Unset the api dml status
146: per_pps_shd.constraint_error
147: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: per_pps_shd.g_api_dml := false; -- Unset the api dml status
151: per_pps_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
148: When hr_api.parent_integrity_violated Then
149: -- Parent integrity has been violated
150: per_pps_shd.g_api_dml := false; -- Unset the api dml status
151: per_pps_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: per_pps_shd.g_api_dml := false; -- Unset the api dml status
156: per_pps_shd.constraint_error
149: -- Parent integrity has been violated
150: per_pps_shd.g_api_dml := false; -- Unset the api dml status
151: per_pps_shd.constraint_error
152: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: per_pps_shd.g_api_dml := false; -- Unset the api dml status
156: per_pps_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
153: When hr_api.unique_integrity_violated Then
154: -- Unique integrity has been violated
155: per_pps_shd.g_api_dml := false; -- Unset the api dml status
156: per_pps_shd.constraint_error
157: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
158: When Others Then
159: per_pps_shd.g_api_dml := false; -- Unset the api dml status
160: Raise;
161: End update_dml;
506: );
507: --
508: exception
509: --
510: when hr_api.cannot_find_prog_unit then
511: --
512: hr_api.cannot_find_prog_unit_error
513: (p_module_name => 'PER_PARENT_SPINES'
514: ,p_hook_type => 'AU');
508: exception
509: --
510: when hr_api.cannot_find_prog_unit then
511: --
512: hr_api.cannot_find_prog_unit_error
513: (p_module_name => 'PER_PARENT_SPINES'
514: ,p_hook_type => 'AU');
515: --
516: end;
571: -- p_rec plsql record structure
572: -- to see if a system default is being used. If a system default
573: -- is being used then we must set to the 'current' argument value.
574: --
575: If (p_rec.business_group_id = hr_api.g_number) then
576: p_rec.business_group_id :=
577: per_pps_shd.g_old_rec.business_group_id;
578: End If;
579: If (p_rec.name = hr_api.g_varchar2) then
575: If (p_rec.business_group_id = hr_api.g_number) then
576: p_rec.business_group_id :=
577: per_pps_shd.g_old_rec.business_group_id;
578: End If;
579: If (p_rec.name = hr_api.g_varchar2) then
580: p_rec.name :=
581: per_pps_shd.g_old_rec.name;
582: End If;
583: If (p_rec.comments = hr_api.g_varchar2) then
579: If (p_rec.name = hr_api.g_varchar2) then
580: p_rec.name :=
581: per_pps_shd.g_old_rec.name;
582: End If;
583: If (p_rec.comments = hr_api.g_varchar2) then
584: p_rec.comments :=
585: per_pps_shd.g_old_rec.comments;
586: End If;
587: If (p_rec.increment_frequency = hr_api.g_number) then
583: If (p_rec.comments = hr_api.g_varchar2) then
584: p_rec.comments :=
585: per_pps_shd.g_old_rec.comments;
586: End If;
587: If (p_rec.increment_frequency = hr_api.g_number) then
588: p_rec.increment_frequency :=
589: per_pps_shd.g_old_rec.increment_frequency;
590: End If;
591: If (p_rec.increment_period = hr_api.g_varchar2) then
587: If (p_rec.increment_frequency = hr_api.g_number) then
588: p_rec.increment_frequency :=
589: per_pps_shd.g_old_rec.increment_frequency;
590: End If;
591: If (p_rec.increment_period = hr_api.g_varchar2) then
592: p_rec.increment_period :=
593: per_pps_shd.g_old_rec.increment_period;
594: End If;
595: If (p_rec.last_automatic_increment_date = hr_api.g_date) then
591: If (p_rec.increment_period = hr_api.g_varchar2) then
592: p_rec.increment_period :=
593: per_pps_shd.g_old_rec.increment_period;
594: End If;
595: If (p_rec.last_automatic_increment_date = hr_api.g_date) then
596: p_rec.last_automatic_increment_date :=
597: per_pps_shd.g_old_rec.last_automatic_increment_date;
598: End If;
599: If (p_rec.request_id = hr_api.g_number) then
595: If (p_rec.last_automatic_increment_date = hr_api.g_date) then
596: p_rec.last_automatic_increment_date :=
597: per_pps_shd.g_old_rec.last_automatic_increment_date;
598: End If;
599: If (p_rec.request_id = hr_api.g_number) then
600: p_rec.request_id :=
601: per_pps_shd.g_old_rec.request_id;
602: End If;
603: If (p_rec.program_application_id = hr_api.g_number) then
599: If (p_rec.request_id = hr_api.g_number) then
600: p_rec.request_id :=
601: per_pps_shd.g_old_rec.request_id;
602: End If;
603: If (p_rec.program_application_id = hr_api.g_number) then
604: p_rec.program_application_id :=
605: per_pps_shd.g_old_rec.program_application_id;
606: End If;
607: If (p_rec.program_id = hr_api.g_number) then
603: If (p_rec.program_application_id = hr_api.g_number) then
604: p_rec.program_application_id :=
605: per_pps_shd.g_old_rec.program_application_id;
606: End If;
607: If (p_rec.program_id = hr_api.g_number) then
608: p_rec.program_id :=
609: per_pps_shd.g_old_rec.program_id;
610: End If;
611: If (p_rec.program_update_date = hr_api.g_date) then
607: If (p_rec.program_id = hr_api.g_number) then
608: p_rec.program_id :=
609: per_pps_shd.g_old_rec.program_id;
610: End If;
611: If (p_rec.program_update_date = hr_api.g_date) then
612: p_rec.program_update_date :=
613: per_pps_shd.g_old_rec.program_update_date;
614: End If;
615: If (p_rec.attribute_category = hr_api.g_varchar2) then
611: If (p_rec.program_update_date = hr_api.g_date) then
612: p_rec.program_update_date :=
613: per_pps_shd.g_old_rec.program_update_date;
614: End If;
615: If (p_rec.attribute_category = hr_api.g_varchar2) then
616: p_rec.attribute_category :=
617: per_pps_shd.g_old_rec.attribute_category;
618: End If;
619: If (p_rec.attribute1 = hr_api.g_varchar2) then
615: If (p_rec.attribute_category = hr_api.g_varchar2) then
616: p_rec.attribute_category :=
617: per_pps_shd.g_old_rec.attribute_category;
618: End If;
619: If (p_rec.attribute1 = hr_api.g_varchar2) then
620: p_rec.attribute1 :=
621: per_pps_shd.g_old_rec.attribute1;
622: End If;
623: If (p_rec.attribute2 = hr_api.g_varchar2) then
619: If (p_rec.attribute1 = hr_api.g_varchar2) then
620: p_rec.attribute1 :=
621: per_pps_shd.g_old_rec.attribute1;
622: End If;
623: If (p_rec.attribute2 = hr_api.g_varchar2) then
624: p_rec.attribute2 :=
625: per_pps_shd.g_old_rec.attribute2;
626: End If;
627: If (p_rec.attribute3 = hr_api.g_varchar2) then
623: If (p_rec.attribute2 = hr_api.g_varchar2) then
624: p_rec.attribute2 :=
625: per_pps_shd.g_old_rec.attribute2;
626: End If;
627: If (p_rec.attribute3 = hr_api.g_varchar2) then
628: p_rec.attribute3 :=
629: per_pps_shd.g_old_rec.attribute3;
630: End If;
631: If (p_rec.attribute4 = hr_api.g_varchar2) then
627: If (p_rec.attribute3 = hr_api.g_varchar2) then
628: p_rec.attribute3 :=
629: per_pps_shd.g_old_rec.attribute3;
630: End If;
631: If (p_rec.attribute4 = hr_api.g_varchar2) then
632: p_rec.attribute4 :=
633: per_pps_shd.g_old_rec.attribute4;
634: End If;
635: If (p_rec.attribute5 = hr_api.g_varchar2) then
631: If (p_rec.attribute4 = hr_api.g_varchar2) then
632: p_rec.attribute4 :=
633: per_pps_shd.g_old_rec.attribute4;
634: End If;
635: If (p_rec.attribute5 = hr_api.g_varchar2) then
636: p_rec.attribute5 :=
637: per_pps_shd.g_old_rec.attribute5;
638: End If;
639: If (p_rec.attribute6 = hr_api.g_varchar2) then
635: If (p_rec.attribute5 = hr_api.g_varchar2) then
636: p_rec.attribute5 :=
637: per_pps_shd.g_old_rec.attribute5;
638: End If;
639: If (p_rec.attribute6 = hr_api.g_varchar2) then
640: p_rec.attribute6 :=
641: per_pps_shd.g_old_rec.attribute6;
642: End If;
643: If (p_rec.attribute7 = hr_api.g_varchar2) then
639: If (p_rec.attribute6 = hr_api.g_varchar2) then
640: p_rec.attribute6 :=
641: per_pps_shd.g_old_rec.attribute6;
642: End If;
643: If (p_rec.attribute7 = hr_api.g_varchar2) then
644: p_rec.attribute7 :=
645: per_pps_shd.g_old_rec.attribute7;
646: End If;
647: If (p_rec.attribute8 = hr_api.g_varchar2) then
643: If (p_rec.attribute7 = hr_api.g_varchar2) then
644: p_rec.attribute7 :=
645: per_pps_shd.g_old_rec.attribute7;
646: End If;
647: If (p_rec.attribute8 = hr_api.g_varchar2) then
648: p_rec.attribute8 :=
649: per_pps_shd.g_old_rec.attribute8;
650: End If;
651: If (p_rec.attribute9 = hr_api.g_varchar2) then
647: If (p_rec.attribute8 = hr_api.g_varchar2) then
648: p_rec.attribute8 :=
649: per_pps_shd.g_old_rec.attribute8;
650: End If;
651: If (p_rec.attribute9 = hr_api.g_varchar2) then
652: p_rec.attribute9 :=
653: per_pps_shd.g_old_rec.attribute9;
654: End If;
655: If (p_rec.attribute10 = hr_api.g_varchar2) then
651: If (p_rec.attribute9 = hr_api.g_varchar2) then
652: p_rec.attribute9 :=
653: per_pps_shd.g_old_rec.attribute9;
654: End If;
655: If (p_rec.attribute10 = hr_api.g_varchar2) then
656: p_rec.attribute10 :=
657: per_pps_shd.g_old_rec.attribute10;
658: End If;
659: If (p_rec.attribute11 = hr_api.g_varchar2) then
655: If (p_rec.attribute10 = hr_api.g_varchar2) then
656: p_rec.attribute10 :=
657: per_pps_shd.g_old_rec.attribute10;
658: End If;
659: If (p_rec.attribute11 = hr_api.g_varchar2) then
660: p_rec.attribute11 :=
661: per_pps_shd.g_old_rec.attribute11;
662: End If;
663: If (p_rec.attribute12 = hr_api.g_varchar2) then
659: If (p_rec.attribute11 = hr_api.g_varchar2) then
660: p_rec.attribute11 :=
661: per_pps_shd.g_old_rec.attribute11;
662: End If;
663: If (p_rec.attribute12 = hr_api.g_varchar2) then
664: p_rec.attribute12 :=
665: per_pps_shd.g_old_rec.attribute12;
666: End If;
667: If (p_rec.attribute13 = hr_api.g_varchar2) then
663: If (p_rec.attribute12 = hr_api.g_varchar2) then
664: p_rec.attribute12 :=
665: per_pps_shd.g_old_rec.attribute12;
666: End If;
667: If (p_rec.attribute13 = hr_api.g_varchar2) then
668: p_rec.attribute13 :=
669: per_pps_shd.g_old_rec.attribute13;
670: End If;
671: If (p_rec.attribute14 = hr_api.g_varchar2) then
667: If (p_rec.attribute13 = hr_api.g_varchar2) then
668: p_rec.attribute13 :=
669: per_pps_shd.g_old_rec.attribute13;
670: End If;
671: If (p_rec.attribute14 = hr_api.g_varchar2) then
672: p_rec.attribute14 :=
673: per_pps_shd.g_old_rec.attribute14;
674: End If;
675: If (p_rec.attribute15 = hr_api.g_varchar2) then
671: If (p_rec.attribute14 = hr_api.g_varchar2) then
672: p_rec.attribute14 :=
673: per_pps_shd.g_old_rec.attribute14;
674: End If;
675: If (p_rec.attribute15 = hr_api.g_varchar2) then
676: p_rec.attribute15 :=
677: per_pps_shd.g_old_rec.attribute15;
678: End If;
679: If (p_rec.attribute16 = hr_api.g_varchar2) then
675: If (p_rec.attribute15 = hr_api.g_varchar2) then
676: p_rec.attribute15 :=
677: per_pps_shd.g_old_rec.attribute15;
678: End If;
679: If (p_rec.attribute16 = hr_api.g_varchar2) then
680: p_rec.attribute16 :=
681: per_pps_shd.g_old_rec.attribute16;
682: End If;
683: If (p_rec.attribute17 = hr_api.g_varchar2) then
679: If (p_rec.attribute16 = hr_api.g_varchar2) then
680: p_rec.attribute16 :=
681: per_pps_shd.g_old_rec.attribute16;
682: End If;
683: If (p_rec.attribute17 = hr_api.g_varchar2) then
684: p_rec.attribute17 :=
685: per_pps_shd.g_old_rec.attribute17;
686: End If;
687: If (p_rec.attribute18 = hr_api.g_varchar2) then
683: If (p_rec.attribute17 = hr_api.g_varchar2) then
684: p_rec.attribute17 :=
685: per_pps_shd.g_old_rec.attribute17;
686: End If;
687: If (p_rec.attribute18 = hr_api.g_varchar2) then
688: p_rec.attribute18 :=
689: per_pps_shd.g_old_rec.attribute18;
690: End If;
691: If (p_rec.attribute19 = hr_api.g_varchar2) then
687: If (p_rec.attribute18 = hr_api.g_varchar2) then
688: p_rec.attribute18 :=
689: per_pps_shd.g_old_rec.attribute18;
690: End If;
691: If (p_rec.attribute19 = hr_api.g_varchar2) then
692: p_rec.attribute19 :=
693: per_pps_shd.g_old_rec.attribute19;
694: End If;
695: If (p_rec.attribute20 = hr_api.g_varchar2) then
691: If (p_rec.attribute19 = hr_api.g_varchar2) then
692: p_rec.attribute19 :=
693: per_pps_shd.g_old_rec.attribute19;
694: End If;
695: If (p_rec.attribute20 = hr_api.g_varchar2) then
696: p_rec.attribute20 :=
697: per_pps_shd.g_old_rec.attribute20;
698: End If;
699: --
696: p_rec.attribute20 :=
697: per_pps_shd.g_old_rec.attribute20;
698: End If;
699: --
700: If (p_rec.information_category = hr_api.g_varchar2) then
701: p_rec.information_category :=
702: per_pps_shd.g_old_rec.information_category;
703: End If;
704: If (p_rec.information1 = hr_api.g_varchar2) then
700: If (p_rec.information_category = hr_api.g_varchar2) then
701: p_rec.information_category :=
702: per_pps_shd.g_old_rec.information_category;
703: End If;
704: If (p_rec.information1 = hr_api.g_varchar2) then
705: p_rec.information1 :=
706: per_pps_shd.g_old_rec.information1;
707: End If;
708: If (p_rec.information2 = hr_api.g_varchar2) then
704: If (p_rec.information1 = hr_api.g_varchar2) then
705: p_rec.information1 :=
706: per_pps_shd.g_old_rec.information1;
707: End If;
708: If (p_rec.information2 = hr_api.g_varchar2) then
709: p_rec.information2 :=
710: per_pps_shd.g_old_rec.information2;
711: End If;
712: If (p_rec.information3 = hr_api.g_varchar2) then
708: If (p_rec.information2 = hr_api.g_varchar2) then
709: p_rec.information2 :=
710: per_pps_shd.g_old_rec.information2;
711: End If;
712: If (p_rec.information3 = hr_api.g_varchar2) then
713: p_rec.information3 :=
714: per_pps_shd.g_old_rec.information3;
715: End If;
716: If (p_rec.information4 = hr_api.g_varchar2) then
712: If (p_rec.information3 = hr_api.g_varchar2) then
713: p_rec.information3 :=
714: per_pps_shd.g_old_rec.information3;
715: End If;
716: If (p_rec.information4 = hr_api.g_varchar2) then
717: p_rec.information4 :=
718: per_pps_shd.g_old_rec.information4;
719: End If;
720: If (p_rec.information5 = hr_api.g_varchar2) then
716: If (p_rec.information4 = hr_api.g_varchar2) then
717: p_rec.information4 :=
718: per_pps_shd.g_old_rec.information4;
719: End If;
720: If (p_rec.information5 = hr_api.g_varchar2) then
721: p_rec.information5 :=
722: per_pps_shd.g_old_rec.information5;
723: End If;
724: If (p_rec.information6 = hr_api.g_varchar2) then
720: If (p_rec.information5 = hr_api.g_varchar2) then
721: p_rec.information5 :=
722: per_pps_shd.g_old_rec.information5;
723: End If;
724: If (p_rec.information6 = hr_api.g_varchar2) then
725: p_rec.information6 :=
726: per_pps_shd.g_old_rec.information6;
727: End If;
728: If (p_rec.information7 = hr_api.g_varchar2) then
724: If (p_rec.information6 = hr_api.g_varchar2) then
725: p_rec.information6 :=
726: per_pps_shd.g_old_rec.information6;
727: End If;
728: If (p_rec.information7 = hr_api.g_varchar2) then
729: p_rec.information7 :=
730: per_pps_shd.g_old_rec.information7;
731: End If;
732: If (p_rec.information8 = hr_api.g_varchar2) then
728: If (p_rec.information7 = hr_api.g_varchar2) then
729: p_rec.information7 :=
730: per_pps_shd.g_old_rec.information7;
731: End If;
732: If (p_rec.information8 = hr_api.g_varchar2) then
733: p_rec.information8 :=
734: per_pps_shd.g_old_rec.information8;
735: End If;
736: If (p_rec.information9 = hr_api.g_varchar2) then
732: If (p_rec.information8 = hr_api.g_varchar2) then
733: p_rec.information8 :=
734: per_pps_shd.g_old_rec.information8;
735: End If;
736: If (p_rec.information9 = hr_api.g_varchar2) then
737: p_rec.information9 :=
738: per_pps_shd.g_old_rec.information9;
739: End If;
740: If (p_rec.information10 = hr_api.g_varchar2) then
736: If (p_rec.information9 = hr_api.g_varchar2) then
737: p_rec.information9 :=
738: per_pps_shd.g_old_rec.information9;
739: End If;
740: If (p_rec.information10 = hr_api.g_varchar2) then
741: p_rec.information10 :=
742: per_pps_shd.g_old_rec.information10;
743: End If;
744: If (p_rec.information11 = hr_api.g_varchar2) then
740: If (p_rec.information10 = hr_api.g_varchar2) then
741: p_rec.information10 :=
742: per_pps_shd.g_old_rec.information10;
743: End If;
744: If (p_rec.information11 = hr_api.g_varchar2) then
745: p_rec.information11 :=
746: per_pps_shd.g_old_rec.information11;
747: End If;
748: If (p_rec.information12 = hr_api.g_varchar2) then
744: If (p_rec.information11 = hr_api.g_varchar2) then
745: p_rec.information11 :=
746: per_pps_shd.g_old_rec.information11;
747: End If;
748: If (p_rec.information12 = hr_api.g_varchar2) then
749: p_rec.information12 :=
750: per_pps_shd.g_old_rec.information12;
751: End If;
752: If (p_rec.information13 = hr_api.g_varchar2) then
748: If (p_rec.information12 = hr_api.g_varchar2) then
749: p_rec.information12 :=
750: per_pps_shd.g_old_rec.information12;
751: End If;
752: If (p_rec.information13 = hr_api.g_varchar2) then
753: p_rec.information13 :=
754: per_pps_shd.g_old_rec.information13;
755: End If;
756: If (p_rec.information14 = hr_api.g_varchar2) then
752: If (p_rec.information13 = hr_api.g_varchar2) then
753: p_rec.information13 :=
754: per_pps_shd.g_old_rec.information13;
755: End If;
756: If (p_rec.information14 = hr_api.g_varchar2) then
757: p_rec.information14 :=
758: per_pps_shd.g_old_rec.information14;
759: End If;
760: If (p_rec.information15 = hr_api.g_varchar2) then
756: If (p_rec.information14 = hr_api.g_varchar2) then
757: p_rec.information14 :=
758: per_pps_shd.g_old_rec.information14;
759: End If;
760: If (p_rec.information15 = hr_api.g_varchar2) then
761: p_rec.information15 :=
762: per_pps_shd.g_old_rec.information15;
763: End If;
764: If (p_rec.information16 = hr_api.g_varchar2) then
760: If (p_rec.information15 = hr_api.g_varchar2) then
761: p_rec.information15 :=
762: per_pps_shd.g_old_rec.information15;
763: End If;
764: If (p_rec.information16 = hr_api.g_varchar2) then
765: p_rec.information16 :=
766: per_pps_shd.g_old_rec.information16;
767: End If;
768: If (p_rec.information17 = hr_api.g_varchar2) then
764: If (p_rec.information16 = hr_api.g_varchar2) then
765: p_rec.information16 :=
766: per_pps_shd.g_old_rec.information16;
767: End If;
768: If (p_rec.information17 = hr_api.g_varchar2) then
769: p_rec.information17 :=
770: per_pps_shd.g_old_rec.information17;
771: End If;
772: If (p_rec.information18 = hr_api.g_varchar2) then
768: If (p_rec.information17 = hr_api.g_varchar2) then
769: p_rec.information17 :=
770: per_pps_shd.g_old_rec.information17;
771: End If;
772: If (p_rec.information18 = hr_api.g_varchar2) then
773: p_rec.information18 :=
774: per_pps_shd.g_old_rec.information18;
775: End If;
776: If (p_rec.information19 = hr_api.g_varchar2) then
772: If (p_rec.information18 = hr_api.g_varchar2) then
773: p_rec.information18 :=
774: per_pps_shd.g_old_rec.information18;
775: End If;
776: If (p_rec.information19 = hr_api.g_varchar2) then
777: p_rec.information19 :=
778: per_pps_shd.g_old_rec.information19;
779: End If;
780: If (p_rec.information20 = hr_api.g_varchar2) then
776: If (p_rec.information19 = hr_api.g_varchar2) then
777: p_rec.information19 :=
778: per_pps_shd.g_old_rec.information19;
779: End If;
780: If (p_rec.information20 = hr_api.g_varchar2) then
781: p_rec.information20 :=
782: per_pps_shd.g_old_rec.information20;
783: End If;
784: If (p_rec.information21 = hr_api.g_varchar2) then
780: If (p_rec.information20 = hr_api.g_varchar2) then
781: p_rec.information20 :=
782: per_pps_shd.g_old_rec.information20;
783: End If;
784: If (p_rec.information21 = hr_api.g_varchar2) then
785: p_rec.information21 :=
786: per_pps_shd.g_old_rec.information21;
787: End If;
788: If (p_rec.information22 = hr_api.g_varchar2) then
784: If (p_rec.information21 = hr_api.g_varchar2) then
785: p_rec.information21 :=
786: per_pps_shd.g_old_rec.information21;
787: End If;
788: If (p_rec.information22 = hr_api.g_varchar2) then
789: p_rec.information22 :=
790: per_pps_shd.g_old_rec.information22;
791: End If;
792: If (p_rec.information23 = hr_api.g_varchar2) then
788: If (p_rec.information22 = hr_api.g_varchar2) then
789: p_rec.information22 :=
790: per_pps_shd.g_old_rec.information22;
791: End If;
792: If (p_rec.information23 = hr_api.g_varchar2) then
793: p_rec.information23 :=
794: per_pps_shd.g_old_rec.information23;
795: End If;
796: If (p_rec.information24 = hr_api.g_varchar2) then
792: If (p_rec.information23 = hr_api.g_varchar2) then
793: p_rec.information23 :=
794: per_pps_shd.g_old_rec.information23;
795: End If;
796: If (p_rec.information24 = hr_api.g_varchar2) then
797: p_rec.information24 :=
798: per_pps_shd.g_old_rec.information24;
799: End If;
800: If (p_rec.information25 = hr_api.g_varchar2) then
796: If (p_rec.information24 = hr_api.g_varchar2) then
797: p_rec.information24 :=
798: per_pps_shd.g_old_rec.information24;
799: End If;
800: If (p_rec.information25 = hr_api.g_varchar2) then
801: p_rec.information25 :=
802: per_pps_shd.g_old_rec.information25;
803: End If;
804: If (p_rec.information26 = hr_api.g_varchar2) then
800: If (p_rec.information25 = hr_api.g_varchar2) then
801: p_rec.information25 :=
802: per_pps_shd.g_old_rec.information25;
803: End If;
804: If (p_rec.information26 = hr_api.g_varchar2) then
805: p_rec.information26 :=
806: per_pps_shd.g_old_rec.information26;
807: End If;
808: If (p_rec.information27 = hr_api.g_varchar2) then
804: If (p_rec.information26 = hr_api.g_varchar2) then
805: p_rec.information26 :=
806: per_pps_shd.g_old_rec.information26;
807: End If;
808: If (p_rec.information27 = hr_api.g_varchar2) then
809: p_rec.information27 :=
810: per_pps_shd.g_old_rec.information27;
811: End If;
812: If (p_rec.information28 = hr_api.g_varchar2) then
808: If (p_rec.information27 = hr_api.g_varchar2) then
809: p_rec.information27 :=
810: per_pps_shd.g_old_rec.information27;
811: End If;
812: If (p_rec.information28 = hr_api.g_varchar2) then
813: p_rec.information28 :=
814: per_pps_shd.g_old_rec.information28;
815: End If;
816: If (p_rec.information29 = hr_api.g_varchar2) then
812: If (p_rec.information28 = hr_api.g_varchar2) then
813: p_rec.information28 :=
814: per_pps_shd.g_old_rec.information28;
815: End If;
816: If (p_rec.information29 = hr_api.g_varchar2) then
817: p_rec.information29 :=
818: per_pps_shd.g_old_rec.information29;
819: End If;
820: If (p_rec.information30 = hr_api.g_varchar2) then
816: If (p_rec.information29 = hr_api.g_varchar2) then
817: p_rec.information29 :=
818: per_pps_shd.g_old_rec.information29;
819: End If;
820: If (p_rec.information30 = hr_api.g_varchar2) then
821: p_rec.information30 :=
822: per_pps_shd.g_old_rec.information30;
823: End If;
824: --
884: Procedure upd
885: (p_effective_date in date
886: ,p_parent_spine_id in number
887: ,p_object_version_number in out nocopy number
888: ,p_business_group_id in number default hr_api.g_number
889: ,p_name in varchar2 default hr_api.g_varchar2
890: ,p_comments in varchar2 default hr_api.g_varchar2
891: ,p_increment_frequency in number default hr_api.g_number
892: ,p_increment_period in varchar2 default hr_api.g_varchar2
885: (p_effective_date in date
886: ,p_parent_spine_id in number
887: ,p_object_version_number in out nocopy number
888: ,p_business_group_id in number default hr_api.g_number
889: ,p_name in varchar2 default hr_api.g_varchar2
890: ,p_comments in varchar2 default hr_api.g_varchar2
891: ,p_increment_frequency in number default hr_api.g_number
892: ,p_increment_period in varchar2 default hr_api.g_varchar2
893: ,p_last_automatic_increment_dat in date default hr_api.g_date
886: ,p_parent_spine_id in number
887: ,p_object_version_number in out nocopy number
888: ,p_business_group_id in number default hr_api.g_number
889: ,p_name in varchar2 default hr_api.g_varchar2
890: ,p_comments in varchar2 default hr_api.g_varchar2
891: ,p_increment_frequency in number default hr_api.g_number
892: ,p_increment_period in varchar2 default hr_api.g_varchar2
893: ,p_last_automatic_increment_dat in date default hr_api.g_date
894: ,p_request_id in number default hr_api.g_number
887: ,p_object_version_number in out nocopy number
888: ,p_business_group_id in number default hr_api.g_number
889: ,p_name in varchar2 default hr_api.g_varchar2
890: ,p_comments in varchar2 default hr_api.g_varchar2
891: ,p_increment_frequency in number default hr_api.g_number
892: ,p_increment_period in varchar2 default hr_api.g_varchar2
893: ,p_last_automatic_increment_dat in date default hr_api.g_date
894: ,p_request_id in number default hr_api.g_number
895: ,p_program_application_id in number default hr_api.g_number
888: ,p_business_group_id in number default hr_api.g_number
889: ,p_name in varchar2 default hr_api.g_varchar2
890: ,p_comments in varchar2 default hr_api.g_varchar2
891: ,p_increment_frequency in number default hr_api.g_number
892: ,p_increment_period in varchar2 default hr_api.g_varchar2
893: ,p_last_automatic_increment_dat in date default hr_api.g_date
894: ,p_request_id in number default hr_api.g_number
895: ,p_program_application_id in number default hr_api.g_number
896: ,p_program_id in number default hr_api.g_number
889: ,p_name in varchar2 default hr_api.g_varchar2
890: ,p_comments in varchar2 default hr_api.g_varchar2
891: ,p_increment_frequency in number default hr_api.g_number
892: ,p_increment_period in varchar2 default hr_api.g_varchar2
893: ,p_last_automatic_increment_dat in date default hr_api.g_date
894: ,p_request_id in number default hr_api.g_number
895: ,p_program_application_id in number default hr_api.g_number
896: ,p_program_id in number default hr_api.g_number
897: ,p_program_update_date in date default hr_api.g_date
890: ,p_comments in varchar2 default hr_api.g_varchar2
891: ,p_increment_frequency in number default hr_api.g_number
892: ,p_increment_period in varchar2 default hr_api.g_varchar2
893: ,p_last_automatic_increment_dat in date default hr_api.g_date
894: ,p_request_id in number default hr_api.g_number
895: ,p_program_application_id in number default hr_api.g_number
896: ,p_program_id in number default hr_api.g_number
897: ,p_program_update_date in date default hr_api.g_date
898: ,p_attribute_category in varchar2 default hr_api.g_varchar2
891: ,p_increment_frequency in number default hr_api.g_number
892: ,p_increment_period in varchar2 default hr_api.g_varchar2
893: ,p_last_automatic_increment_dat in date default hr_api.g_date
894: ,p_request_id in number default hr_api.g_number
895: ,p_program_application_id in number default hr_api.g_number
896: ,p_program_id in number default hr_api.g_number
897: ,p_program_update_date in date default hr_api.g_date
898: ,p_attribute_category in varchar2 default hr_api.g_varchar2
899: ,p_attribute1 in varchar2 default hr_api.g_varchar2
892: ,p_increment_period in varchar2 default hr_api.g_varchar2
893: ,p_last_automatic_increment_dat in date default hr_api.g_date
894: ,p_request_id in number default hr_api.g_number
895: ,p_program_application_id in number default hr_api.g_number
896: ,p_program_id in number default hr_api.g_number
897: ,p_program_update_date in date default hr_api.g_date
898: ,p_attribute_category in varchar2 default hr_api.g_varchar2
899: ,p_attribute1 in varchar2 default hr_api.g_varchar2
900: ,p_attribute2 in varchar2 default hr_api.g_varchar2
893: ,p_last_automatic_increment_dat in date default hr_api.g_date
894: ,p_request_id in number default hr_api.g_number
895: ,p_program_application_id in number default hr_api.g_number
896: ,p_program_id in number default hr_api.g_number
897: ,p_program_update_date in date default hr_api.g_date
898: ,p_attribute_category in varchar2 default hr_api.g_varchar2
899: ,p_attribute1 in varchar2 default hr_api.g_varchar2
900: ,p_attribute2 in varchar2 default hr_api.g_varchar2
901: ,p_attribute3 in varchar2 default hr_api.g_varchar2
894: ,p_request_id in number default hr_api.g_number
895: ,p_program_application_id in number default hr_api.g_number
896: ,p_program_id in number default hr_api.g_number
897: ,p_program_update_date in date default hr_api.g_date
898: ,p_attribute_category in varchar2 default hr_api.g_varchar2
899: ,p_attribute1 in varchar2 default hr_api.g_varchar2
900: ,p_attribute2 in varchar2 default hr_api.g_varchar2
901: ,p_attribute3 in varchar2 default hr_api.g_varchar2
902: ,p_attribute4 in varchar2 default hr_api.g_varchar2
895: ,p_program_application_id in number default hr_api.g_number
896: ,p_program_id in number default hr_api.g_number
897: ,p_program_update_date in date default hr_api.g_date
898: ,p_attribute_category in varchar2 default hr_api.g_varchar2
899: ,p_attribute1 in varchar2 default hr_api.g_varchar2
900: ,p_attribute2 in varchar2 default hr_api.g_varchar2
901: ,p_attribute3 in varchar2 default hr_api.g_varchar2
902: ,p_attribute4 in varchar2 default hr_api.g_varchar2
903: ,p_attribute5 in varchar2 default hr_api.g_varchar2
896: ,p_program_id in number default hr_api.g_number
897: ,p_program_update_date in date default hr_api.g_date
898: ,p_attribute_category in varchar2 default hr_api.g_varchar2
899: ,p_attribute1 in varchar2 default hr_api.g_varchar2
900: ,p_attribute2 in varchar2 default hr_api.g_varchar2
901: ,p_attribute3 in varchar2 default hr_api.g_varchar2
902: ,p_attribute4 in varchar2 default hr_api.g_varchar2
903: ,p_attribute5 in varchar2 default hr_api.g_varchar2
904: ,p_attribute6 in varchar2 default hr_api.g_varchar2
897: ,p_program_update_date in date default hr_api.g_date
898: ,p_attribute_category in varchar2 default hr_api.g_varchar2
899: ,p_attribute1 in varchar2 default hr_api.g_varchar2
900: ,p_attribute2 in varchar2 default hr_api.g_varchar2
901: ,p_attribute3 in varchar2 default hr_api.g_varchar2
902: ,p_attribute4 in varchar2 default hr_api.g_varchar2
903: ,p_attribute5 in varchar2 default hr_api.g_varchar2
904: ,p_attribute6 in varchar2 default hr_api.g_varchar2
905: ,p_attribute7 in varchar2 default hr_api.g_varchar2
898: ,p_attribute_category in varchar2 default hr_api.g_varchar2
899: ,p_attribute1 in varchar2 default hr_api.g_varchar2
900: ,p_attribute2 in varchar2 default hr_api.g_varchar2
901: ,p_attribute3 in varchar2 default hr_api.g_varchar2
902: ,p_attribute4 in varchar2 default hr_api.g_varchar2
903: ,p_attribute5 in varchar2 default hr_api.g_varchar2
904: ,p_attribute6 in varchar2 default hr_api.g_varchar2
905: ,p_attribute7 in varchar2 default hr_api.g_varchar2
906: ,p_attribute8 in varchar2 default hr_api.g_varchar2
899: ,p_attribute1 in varchar2 default hr_api.g_varchar2
900: ,p_attribute2 in varchar2 default hr_api.g_varchar2
901: ,p_attribute3 in varchar2 default hr_api.g_varchar2
902: ,p_attribute4 in varchar2 default hr_api.g_varchar2
903: ,p_attribute5 in varchar2 default hr_api.g_varchar2
904: ,p_attribute6 in varchar2 default hr_api.g_varchar2
905: ,p_attribute7 in varchar2 default hr_api.g_varchar2
906: ,p_attribute8 in varchar2 default hr_api.g_varchar2
907: ,p_attribute9 in varchar2 default hr_api.g_varchar2
900: ,p_attribute2 in varchar2 default hr_api.g_varchar2
901: ,p_attribute3 in varchar2 default hr_api.g_varchar2
902: ,p_attribute4 in varchar2 default hr_api.g_varchar2
903: ,p_attribute5 in varchar2 default hr_api.g_varchar2
904: ,p_attribute6 in varchar2 default hr_api.g_varchar2
905: ,p_attribute7 in varchar2 default hr_api.g_varchar2
906: ,p_attribute8 in varchar2 default hr_api.g_varchar2
907: ,p_attribute9 in varchar2 default hr_api.g_varchar2
908: ,p_attribute10 in varchar2 default hr_api.g_varchar2
901: ,p_attribute3 in varchar2 default hr_api.g_varchar2
902: ,p_attribute4 in varchar2 default hr_api.g_varchar2
903: ,p_attribute5 in varchar2 default hr_api.g_varchar2
904: ,p_attribute6 in varchar2 default hr_api.g_varchar2
905: ,p_attribute7 in varchar2 default hr_api.g_varchar2
906: ,p_attribute8 in varchar2 default hr_api.g_varchar2
907: ,p_attribute9 in varchar2 default hr_api.g_varchar2
908: ,p_attribute10 in varchar2 default hr_api.g_varchar2
909: ,p_attribute11 in varchar2 default hr_api.g_varchar2
902: ,p_attribute4 in varchar2 default hr_api.g_varchar2
903: ,p_attribute5 in varchar2 default hr_api.g_varchar2
904: ,p_attribute6 in varchar2 default hr_api.g_varchar2
905: ,p_attribute7 in varchar2 default hr_api.g_varchar2
906: ,p_attribute8 in varchar2 default hr_api.g_varchar2
907: ,p_attribute9 in varchar2 default hr_api.g_varchar2
908: ,p_attribute10 in varchar2 default hr_api.g_varchar2
909: ,p_attribute11 in varchar2 default hr_api.g_varchar2
910: ,p_attribute12 in varchar2 default hr_api.g_varchar2
903: ,p_attribute5 in varchar2 default hr_api.g_varchar2
904: ,p_attribute6 in varchar2 default hr_api.g_varchar2
905: ,p_attribute7 in varchar2 default hr_api.g_varchar2
906: ,p_attribute8 in varchar2 default hr_api.g_varchar2
907: ,p_attribute9 in varchar2 default hr_api.g_varchar2
908: ,p_attribute10 in varchar2 default hr_api.g_varchar2
909: ,p_attribute11 in varchar2 default hr_api.g_varchar2
910: ,p_attribute12 in varchar2 default hr_api.g_varchar2
911: ,p_attribute13 in varchar2 default hr_api.g_varchar2
904: ,p_attribute6 in varchar2 default hr_api.g_varchar2
905: ,p_attribute7 in varchar2 default hr_api.g_varchar2
906: ,p_attribute8 in varchar2 default hr_api.g_varchar2
907: ,p_attribute9 in varchar2 default hr_api.g_varchar2
908: ,p_attribute10 in varchar2 default hr_api.g_varchar2
909: ,p_attribute11 in varchar2 default hr_api.g_varchar2
910: ,p_attribute12 in varchar2 default hr_api.g_varchar2
911: ,p_attribute13 in varchar2 default hr_api.g_varchar2
912: ,p_attribute14 in varchar2 default hr_api.g_varchar2
905: ,p_attribute7 in varchar2 default hr_api.g_varchar2
906: ,p_attribute8 in varchar2 default hr_api.g_varchar2
907: ,p_attribute9 in varchar2 default hr_api.g_varchar2
908: ,p_attribute10 in varchar2 default hr_api.g_varchar2
909: ,p_attribute11 in varchar2 default hr_api.g_varchar2
910: ,p_attribute12 in varchar2 default hr_api.g_varchar2
911: ,p_attribute13 in varchar2 default hr_api.g_varchar2
912: ,p_attribute14 in varchar2 default hr_api.g_varchar2
913: ,p_attribute15 in varchar2 default hr_api.g_varchar2
906: ,p_attribute8 in varchar2 default hr_api.g_varchar2
907: ,p_attribute9 in varchar2 default hr_api.g_varchar2
908: ,p_attribute10 in varchar2 default hr_api.g_varchar2
909: ,p_attribute11 in varchar2 default hr_api.g_varchar2
910: ,p_attribute12 in varchar2 default hr_api.g_varchar2
911: ,p_attribute13 in varchar2 default hr_api.g_varchar2
912: ,p_attribute14 in varchar2 default hr_api.g_varchar2
913: ,p_attribute15 in varchar2 default hr_api.g_varchar2
914: ,p_attribute16 in varchar2 default hr_api.g_varchar2
907: ,p_attribute9 in varchar2 default hr_api.g_varchar2
908: ,p_attribute10 in varchar2 default hr_api.g_varchar2
909: ,p_attribute11 in varchar2 default hr_api.g_varchar2
910: ,p_attribute12 in varchar2 default hr_api.g_varchar2
911: ,p_attribute13 in varchar2 default hr_api.g_varchar2
912: ,p_attribute14 in varchar2 default hr_api.g_varchar2
913: ,p_attribute15 in varchar2 default hr_api.g_varchar2
914: ,p_attribute16 in varchar2 default hr_api.g_varchar2
915: ,p_attribute17 in varchar2 default hr_api.g_varchar2
908: ,p_attribute10 in varchar2 default hr_api.g_varchar2
909: ,p_attribute11 in varchar2 default hr_api.g_varchar2
910: ,p_attribute12 in varchar2 default hr_api.g_varchar2
911: ,p_attribute13 in varchar2 default hr_api.g_varchar2
912: ,p_attribute14 in varchar2 default hr_api.g_varchar2
913: ,p_attribute15 in varchar2 default hr_api.g_varchar2
914: ,p_attribute16 in varchar2 default hr_api.g_varchar2
915: ,p_attribute17 in varchar2 default hr_api.g_varchar2
916: ,p_attribute18 in varchar2 default hr_api.g_varchar2
909: ,p_attribute11 in varchar2 default hr_api.g_varchar2
910: ,p_attribute12 in varchar2 default hr_api.g_varchar2
911: ,p_attribute13 in varchar2 default hr_api.g_varchar2
912: ,p_attribute14 in varchar2 default hr_api.g_varchar2
913: ,p_attribute15 in varchar2 default hr_api.g_varchar2
914: ,p_attribute16 in varchar2 default hr_api.g_varchar2
915: ,p_attribute17 in varchar2 default hr_api.g_varchar2
916: ,p_attribute18 in varchar2 default hr_api.g_varchar2
917: ,p_attribute19 in varchar2 default hr_api.g_varchar2
910: ,p_attribute12 in varchar2 default hr_api.g_varchar2
911: ,p_attribute13 in varchar2 default hr_api.g_varchar2
912: ,p_attribute14 in varchar2 default hr_api.g_varchar2
913: ,p_attribute15 in varchar2 default hr_api.g_varchar2
914: ,p_attribute16 in varchar2 default hr_api.g_varchar2
915: ,p_attribute17 in varchar2 default hr_api.g_varchar2
916: ,p_attribute18 in varchar2 default hr_api.g_varchar2
917: ,p_attribute19 in varchar2 default hr_api.g_varchar2
918: ,p_attribute20 in varchar2 default hr_api.g_varchar2
911: ,p_attribute13 in varchar2 default hr_api.g_varchar2
912: ,p_attribute14 in varchar2 default hr_api.g_varchar2
913: ,p_attribute15 in varchar2 default hr_api.g_varchar2
914: ,p_attribute16 in varchar2 default hr_api.g_varchar2
915: ,p_attribute17 in varchar2 default hr_api.g_varchar2
916: ,p_attribute18 in varchar2 default hr_api.g_varchar2
917: ,p_attribute19 in varchar2 default hr_api.g_varchar2
918: ,p_attribute20 in varchar2 default hr_api.g_varchar2
919: ,p_information_category in varchar2 default hr_api.g_varchar2
912: ,p_attribute14 in varchar2 default hr_api.g_varchar2
913: ,p_attribute15 in varchar2 default hr_api.g_varchar2
914: ,p_attribute16 in varchar2 default hr_api.g_varchar2
915: ,p_attribute17 in varchar2 default hr_api.g_varchar2
916: ,p_attribute18 in varchar2 default hr_api.g_varchar2
917: ,p_attribute19 in varchar2 default hr_api.g_varchar2
918: ,p_attribute20 in varchar2 default hr_api.g_varchar2
919: ,p_information_category in varchar2 default hr_api.g_varchar2
920: ,p_information1 in varchar2 default hr_api.g_varchar2
913: ,p_attribute15 in varchar2 default hr_api.g_varchar2
914: ,p_attribute16 in varchar2 default hr_api.g_varchar2
915: ,p_attribute17 in varchar2 default hr_api.g_varchar2
916: ,p_attribute18 in varchar2 default hr_api.g_varchar2
917: ,p_attribute19 in varchar2 default hr_api.g_varchar2
918: ,p_attribute20 in varchar2 default hr_api.g_varchar2
919: ,p_information_category in varchar2 default hr_api.g_varchar2
920: ,p_information1 in varchar2 default hr_api.g_varchar2
921: ,p_information2 in varchar2 default hr_api.g_varchar2
914: ,p_attribute16 in varchar2 default hr_api.g_varchar2
915: ,p_attribute17 in varchar2 default hr_api.g_varchar2
916: ,p_attribute18 in varchar2 default hr_api.g_varchar2
917: ,p_attribute19 in varchar2 default hr_api.g_varchar2
918: ,p_attribute20 in varchar2 default hr_api.g_varchar2
919: ,p_information_category in varchar2 default hr_api.g_varchar2
920: ,p_information1 in varchar2 default hr_api.g_varchar2
921: ,p_information2 in varchar2 default hr_api.g_varchar2
922: ,p_information3 in varchar2 default hr_api.g_varchar2
915: ,p_attribute17 in varchar2 default hr_api.g_varchar2
916: ,p_attribute18 in varchar2 default hr_api.g_varchar2
917: ,p_attribute19 in varchar2 default hr_api.g_varchar2
918: ,p_attribute20 in varchar2 default hr_api.g_varchar2
919: ,p_information_category in varchar2 default hr_api.g_varchar2
920: ,p_information1 in varchar2 default hr_api.g_varchar2
921: ,p_information2 in varchar2 default hr_api.g_varchar2
922: ,p_information3 in varchar2 default hr_api.g_varchar2
923: ,p_information4 in varchar2 default hr_api.g_varchar2
916: ,p_attribute18 in varchar2 default hr_api.g_varchar2
917: ,p_attribute19 in varchar2 default hr_api.g_varchar2
918: ,p_attribute20 in varchar2 default hr_api.g_varchar2
919: ,p_information_category in varchar2 default hr_api.g_varchar2
920: ,p_information1 in varchar2 default hr_api.g_varchar2
921: ,p_information2 in varchar2 default hr_api.g_varchar2
922: ,p_information3 in varchar2 default hr_api.g_varchar2
923: ,p_information4 in varchar2 default hr_api.g_varchar2
924: ,p_information5 in varchar2 default hr_api.g_varchar2
917: ,p_attribute19 in varchar2 default hr_api.g_varchar2
918: ,p_attribute20 in varchar2 default hr_api.g_varchar2
919: ,p_information_category in varchar2 default hr_api.g_varchar2
920: ,p_information1 in varchar2 default hr_api.g_varchar2
921: ,p_information2 in varchar2 default hr_api.g_varchar2
922: ,p_information3 in varchar2 default hr_api.g_varchar2
923: ,p_information4 in varchar2 default hr_api.g_varchar2
924: ,p_information5 in varchar2 default hr_api.g_varchar2
925: ,p_information6 in varchar2 default hr_api.g_varchar2
918: ,p_attribute20 in varchar2 default hr_api.g_varchar2
919: ,p_information_category in varchar2 default hr_api.g_varchar2
920: ,p_information1 in varchar2 default hr_api.g_varchar2
921: ,p_information2 in varchar2 default hr_api.g_varchar2
922: ,p_information3 in varchar2 default hr_api.g_varchar2
923: ,p_information4 in varchar2 default hr_api.g_varchar2
924: ,p_information5 in varchar2 default hr_api.g_varchar2
925: ,p_information6 in varchar2 default hr_api.g_varchar2
926: ,p_information7 in varchar2 default hr_api.g_varchar2
919: ,p_information_category in varchar2 default hr_api.g_varchar2
920: ,p_information1 in varchar2 default hr_api.g_varchar2
921: ,p_information2 in varchar2 default hr_api.g_varchar2
922: ,p_information3 in varchar2 default hr_api.g_varchar2
923: ,p_information4 in varchar2 default hr_api.g_varchar2
924: ,p_information5 in varchar2 default hr_api.g_varchar2
925: ,p_information6 in varchar2 default hr_api.g_varchar2
926: ,p_information7 in varchar2 default hr_api.g_varchar2
927: ,p_information8 in varchar2 default hr_api.g_varchar2
920: ,p_information1 in varchar2 default hr_api.g_varchar2
921: ,p_information2 in varchar2 default hr_api.g_varchar2
922: ,p_information3 in varchar2 default hr_api.g_varchar2
923: ,p_information4 in varchar2 default hr_api.g_varchar2
924: ,p_information5 in varchar2 default hr_api.g_varchar2
925: ,p_information6 in varchar2 default hr_api.g_varchar2
926: ,p_information7 in varchar2 default hr_api.g_varchar2
927: ,p_information8 in varchar2 default hr_api.g_varchar2
928: ,p_information9 in varchar2 default hr_api.g_varchar2
921: ,p_information2 in varchar2 default hr_api.g_varchar2
922: ,p_information3 in varchar2 default hr_api.g_varchar2
923: ,p_information4 in varchar2 default hr_api.g_varchar2
924: ,p_information5 in varchar2 default hr_api.g_varchar2
925: ,p_information6 in varchar2 default hr_api.g_varchar2
926: ,p_information7 in varchar2 default hr_api.g_varchar2
927: ,p_information8 in varchar2 default hr_api.g_varchar2
928: ,p_information9 in varchar2 default hr_api.g_varchar2
929: ,p_information10 in varchar2 default hr_api.g_varchar2
922: ,p_information3 in varchar2 default hr_api.g_varchar2
923: ,p_information4 in varchar2 default hr_api.g_varchar2
924: ,p_information5 in varchar2 default hr_api.g_varchar2
925: ,p_information6 in varchar2 default hr_api.g_varchar2
926: ,p_information7 in varchar2 default hr_api.g_varchar2
927: ,p_information8 in varchar2 default hr_api.g_varchar2
928: ,p_information9 in varchar2 default hr_api.g_varchar2
929: ,p_information10 in varchar2 default hr_api.g_varchar2
930: ,p_information11 in varchar2 default hr_api.g_varchar2
923: ,p_information4 in varchar2 default hr_api.g_varchar2
924: ,p_information5 in varchar2 default hr_api.g_varchar2
925: ,p_information6 in varchar2 default hr_api.g_varchar2
926: ,p_information7 in varchar2 default hr_api.g_varchar2
927: ,p_information8 in varchar2 default hr_api.g_varchar2
928: ,p_information9 in varchar2 default hr_api.g_varchar2
929: ,p_information10 in varchar2 default hr_api.g_varchar2
930: ,p_information11 in varchar2 default hr_api.g_varchar2
931: ,p_information12 in varchar2 default hr_api.g_varchar2
924: ,p_information5 in varchar2 default hr_api.g_varchar2
925: ,p_information6 in varchar2 default hr_api.g_varchar2
926: ,p_information7 in varchar2 default hr_api.g_varchar2
927: ,p_information8 in varchar2 default hr_api.g_varchar2
928: ,p_information9 in varchar2 default hr_api.g_varchar2
929: ,p_information10 in varchar2 default hr_api.g_varchar2
930: ,p_information11 in varchar2 default hr_api.g_varchar2
931: ,p_information12 in varchar2 default hr_api.g_varchar2
932: ,p_information13 in varchar2 default hr_api.g_varchar2
925: ,p_information6 in varchar2 default hr_api.g_varchar2
926: ,p_information7 in varchar2 default hr_api.g_varchar2
927: ,p_information8 in varchar2 default hr_api.g_varchar2
928: ,p_information9 in varchar2 default hr_api.g_varchar2
929: ,p_information10 in varchar2 default hr_api.g_varchar2
930: ,p_information11 in varchar2 default hr_api.g_varchar2
931: ,p_information12 in varchar2 default hr_api.g_varchar2
932: ,p_information13 in varchar2 default hr_api.g_varchar2
933: ,p_information14 in varchar2 default hr_api.g_varchar2
926: ,p_information7 in varchar2 default hr_api.g_varchar2
927: ,p_information8 in varchar2 default hr_api.g_varchar2
928: ,p_information9 in varchar2 default hr_api.g_varchar2
929: ,p_information10 in varchar2 default hr_api.g_varchar2
930: ,p_information11 in varchar2 default hr_api.g_varchar2
931: ,p_information12 in varchar2 default hr_api.g_varchar2
932: ,p_information13 in varchar2 default hr_api.g_varchar2
933: ,p_information14 in varchar2 default hr_api.g_varchar2
934: ,p_information15 in varchar2 default hr_api.g_varchar2
927: ,p_information8 in varchar2 default hr_api.g_varchar2
928: ,p_information9 in varchar2 default hr_api.g_varchar2
929: ,p_information10 in varchar2 default hr_api.g_varchar2
930: ,p_information11 in varchar2 default hr_api.g_varchar2
931: ,p_information12 in varchar2 default hr_api.g_varchar2
932: ,p_information13 in varchar2 default hr_api.g_varchar2
933: ,p_information14 in varchar2 default hr_api.g_varchar2
934: ,p_information15 in varchar2 default hr_api.g_varchar2
935: ,p_information16 in varchar2 default hr_api.g_varchar2
928: ,p_information9 in varchar2 default hr_api.g_varchar2
929: ,p_information10 in varchar2 default hr_api.g_varchar2
930: ,p_information11 in varchar2 default hr_api.g_varchar2
931: ,p_information12 in varchar2 default hr_api.g_varchar2
932: ,p_information13 in varchar2 default hr_api.g_varchar2
933: ,p_information14 in varchar2 default hr_api.g_varchar2
934: ,p_information15 in varchar2 default hr_api.g_varchar2
935: ,p_information16 in varchar2 default hr_api.g_varchar2
936: ,p_information17 in varchar2 default hr_api.g_varchar2
929: ,p_information10 in varchar2 default hr_api.g_varchar2
930: ,p_information11 in varchar2 default hr_api.g_varchar2
931: ,p_information12 in varchar2 default hr_api.g_varchar2
932: ,p_information13 in varchar2 default hr_api.g_varchar2
933: ,p_information14 in varchar2 default hr_api.g_varchar2
934: ,p_information15 in varchar2 default hr_api.g_varchar2
935: ,p_information16 in varchar2 default hr_api.g_varchar2
936: ,p_information17 in varchar2 default hr_api.g_varchar2
937: ,p_information18 in varchar2 default hr_api.g_varchar2
930: ,p_information11 in varchar2 default hr_api.g_varchar2
931: ,p_information12 in varchar2 default hr_api.g_varchar2
932: ,p_information13 in varchar2 default hr_api.g_varchar2
933: ,p_information14 in varchar2 default hr_api.g_varchar2
934: ,p_information15 in varchar2 default hr_api.g_varchar2
935: ,p_information16 in varchar2 default hr_api.g_varchar2
936: ,p_information17 in varchar2 default hr_api.g_varchar2
937: ,p_information18 in varchar2 default hr_api.g_varchar2
938: ,p_information19 in varchar2 default hr_api.g_varchar2
931: ,p_information12 in varchar2 default hr_api.g_varchar2
932: ,p_information13 in varchar2 default hr_api.g_varchar2
933: ,p_information14 in varchar2 default hr_api.g_varchar2
934: ,p_information15 in varchar2 default hr_api.g_varchar2
935: ,p_information16 in varchar2 default hr_api.g_varchar2
936: ,p_information17 in varchar2 default hr_api.g_varchar2
937: ,p_information18 in varchar2 default hr_api.g_varchar2
938: ,p_information19 in varchar2 default hr_api.g_varchar2
939: ,p_information20 in varchar2 default hr_api.g_varchar2
932: ,p_information13 in varchar2 default hr_api.g_varchar2
933: ,p_information14 in varchar2 default hr_api.g_varchar2
934: ,p_information15 in varchar2 default hr_api.g_varchar2
935: ,p_information16 in varchar2 default hr_api.g_varchar2
936: ,p_information17 in varchar2 default hr_api.g_varchar2
937: ,p_information18 in varchar2 default hr_api.g_varchar2
938: ,p_information19 in varchar2 default hr_api.g_varchar2
939: ,p_information20 in varchar2 default hr_api.g_varchar2
940: ,p_information21 in varchar2 default hr_api.g_varchar2
933: ,p_information14 in varchar2 default hr_api.g_varchar2
934: ,p_information15 in varchar2 default hr_api.g_varchar2
935: ,p_information16 in varchar2 default hr_api.g_varchar2
936: ,p_information17 in varchar2 default hr_api.g_varchar2
937: ,p_information18 in varchar2 default hr_api.g_varchar2
938: ,p_information19 in varchar2 default hr_api.g_varchar2
939: ,p_information20 in varchar2 default hr_api.g_varchar2
940: ,p_information21 in varchar2 default hr_api.g_varchar2
941: ,p_information22 in varchar2 default hr_api.g_varchar2
934: ,p_information15 in varchar2 default hr_api.g_varchar2
935: ,p_information16 in varchar2 default hr_api.g_varchar2
936: ,p_information17 in varchar2 default hr_api.g_varchar2
937: ,p_information18 in varchar2 default hr_api.g_varchar2
938: ,p_information19 in varchar2 default hr_api.g_varchar2
939: ,p_information20 in varchar2 default hr_api.g_varchar2
940: ,p_information21 in varchar2 default hr_api.g_varchar2
941: ,p_information22 in varchar2 default hr_api.g_varchar2
942: ,p_information23 in varchar2 default hr_api.g_varchar2
935: ,p_information16 in varchar2 default hr_api.g_varchar2
936: ,p_information17 in varchar2 default hr_api.g_varchar2
937: ,p_information18 in varchar2 default hr_api.g_varchar2
938: ,p_information19 in varchar2 default hr_api.g_varchar2
939: ,p_information20 in varchar2 default hr_api.g_varchar2
940: ,p_information21 in varchar2 default hr_api.g_varchar2
941: ,p_information22 in varchar2 default hr_api.g_varchar2
942: ,p_information23 in varchar2 default hr_api.g_varchar2
943: ,p_information24 in varchar2 default hr_api.g_varchar2
936: ,p_information17 in varchar2 default hr_api.g_varchar2
937: ,p_information18 in varchar2 default hr_api.g_varchar2
938: ,p_information19 in varchar2 default hr_api.g_varchar2
939: ,p_information20 in varchar2 default hr_api.g_varchar2
940: ,p_information21 in varchar2 default hr_api.g_varchar2
941: ,p_information22 in varchar2 default hr_api.g_varchar2
942: ,p_information23 in varchar2 default hr_api.g_varchar2
943: ,p_information24 in varchar2 default hr_api.g_varchar2
944: ,p_information25 in varchar2 default hr_api.g_varchar2
937: ,p_information18 in varchar2 default hr_api.g_varchar2
938: ,p_information19 in varchar2 default hr_api.g_varchar2
939: ,p_information20 in varchar2 default hr_api.g_varchar2
940: ,p_information21 in varchar2 default hr_api.g_varchar2
941: ,p_information22 in varchar2 default hr_api.g_varchar2
942: ,p_information23 in varchar2 default hr_api.g_varchar2
943: ,p_information24 in varchar2 default hr_api.g_varchar2
944: ,p_information25 in varchar2 default hr_api.g_varchar2
945: ,p_information26 in varchar2 default hr_api.g_varchar2
938: ,p_information19 in varchar2 default hr_api.g_varchar2
939: ,p_information20 in varchar2 default hr_api.g_varchar2
940: ,p_information21 in varchar2 default hr_api.g_varchar2
941: ,p_information22 in varchar2 default hr_api.g_varchar2
942: ,p_information23 in varchar2 default hr_api.g_varchar2
943: ,p_information24 in varchar2 default hr_api.g_varchar2
944: ,p_information25 in varchar2 default hr_api.g_varchar2
945: ,p_information26 in varchar2 default hr_api.g_varchar2
946: ,p_information27 in varchar2 default hr_api.g_varchar2
939: ,p_information20 in varchar2 default hr_api.g_varchar2
940: ,p_information21 in varchar2 default hr_api.g_varchar2
941: ,p_information22 in varchar2 default hr_api.g_varchar2
942: ,p_information23 in varchar2 default hr_api.g_varchar2
943: ,p_information24 in varchar2 default hr_api.g_varchar2
944: ,p_information25 in varchar2 default hr_api.g_varchar2
945: ,p_information26 in varchar2 default hr_api.g_varchar2
946: ,p_information27 in varchar2 default hr_api.g_varchar2
947: ,p_information28 in varchar2 default hr_api.g_varchar2
940: ,p_information21 in varchar2 default hr_api.g_varchar2
941: ,p_information22 in varchar2 default hr_api.g_varchar2
942: ,p_information23 in varchar2 default hr_api.g_varchar2
943: ,p_information24 in varchar2 default hr_api.g_varchar2
944: ,p_information25 in varchar2 default hr_api.g_varchar2
945: ,p_information26 in varchar2 default hr_api.g_varchar2
946: ,p_information27 in varchar2 default hr_api.g_varchar2
947: ,p_information28 in varchar2 default hr_api.g_varchar2
948: ,p_information29 in varchar2 default hr_api.g_varchar2
941: ,p_information22 in varchar2 default hr_api.g_varchar2
942: ,p_information23 in varchar2 default hr_api.g_varchar2
943: ,p_information24 in varchar2 default hr_api.g_varchar2
944: ,p_information25 in varchar2 default hr_api.g_varchar2
945: ,p_information26 in varchar2 default hr_api.g_varchar2
946: ,p_information27 in varchar2 default hr_api.g_varchar2
947: ,p_information28 in varchar2 default hr_api.g_varchar2
948: ,p_information29 in varchar2 default hr_api.g_varchar2
949: ,p_information30 in varchar2 default hr_api.g_varchar2
942: ,p_information23 in varchar2 default hr_api.g_varchar2
943: ,p_information24 in varchar2 default hr_api.g_varchar2
944: ,p_information25 in varchar2 default hr_api.g_varchar2
945: ,p_information26 in varchar2 default hr_api.g_varchar2
946: ,p_information27 in varchar2 default hr_api.g_varchar2
947: ,p_information28 in varchar2 default hr_api.g_varchar2
948: ,p_information29 in varchar2 default hr_api.g_varchar2
949: ,p_information30 in varchar2 default hr_api.g_varchar2
950: ) is
943: ,p_information24 in varchar2 default hr_api.g_varchar2
944: ,p_information25 in varchar2 default hr_api.g_varchar2
945: ,p_information26 in varchar2 default hr_api.g_varchar2
946: ,p_information27 in varchar2 default hr_api.g_varchar2
947: ,p_information28 in varchar2 default hr_api.g_varchar2
948: ,p_information29 in varchar2 default hr_api.g_varchar2
949: ,p_information30 in varchar2 default hr_api.g_varchar2
950: ) is
951: --
944: ,p_information25 in varchar2 default hr_api.g_varchar2
945: ,p_information26 in varchar2 default hr_api.g_varchar2
946: ,p_information27 in varchar2 default hr_api.g_varchar2
947: ,p_information28 in varchar2 default hr_api.g_varchar2
948: ,p_information29 in varchar2 default hr_api.g_varchar2
949: ,p_information30 in varchar2 default hr_api.g_varchar2
950: ) is
951: --
952: l_rec per_pps_shd.g_rec_type;
945: ,p_information26 in varchar2 default hr_api.g_varchar2
946: ,p_information27 in varchar2 default hr_api.g_varchar2
947: ,p_information28 in varchar2 default hr_api.g_varchar2
948: ,p_information29 in varchar2 default hr_api.g_varchar2
949: ,p_information30 in varchar2 default hr_api.g_varchar2
950: ) is
951: --
952: l_rec per_pps_shd.g_rec_type;
953: l_proc varchar2(72) := g_package||'upd';