158: End If;
159: --
160: hr_utility.set_location(' Leaving:'||l_proc, 15);
161: Exception
162: When hr_api.check_integrity_violated Then
163: -- A check constraint has been violated
164: per_ctc_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
161: Exception
162: When hr_api.check_integrity_violated Then
163: -- A check constraint has been violated
164: per_ctc_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: per_ctc_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
162: When hr_api.check_integrity_violated Then
163: -- A check constraint has been violated
164: per_ctc_shd.constraint_error
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: per_ctc_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When Others Then
165: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
166: When hr_api.unique_integrity_violated Then
167: -- Unique integrity has been violated
168: per_ctc_shd.constraint_error
169: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
170: When Others Then
171: Raise;
172: End dt_update_dml;
173: --
562: );
563: --
564: exception
565: --
566: when hr_api.cannot_find_prog_unit then
567: --
568: hr_api.cannot_find_prog_unit_error
569: (p_module_name => 'per_contracts_f'
570: ,p_hook_type => 'AU');
564: exception
565: --
566: when hr_api.cannot_find_prog_unit then
567: --
568: hr_api.cannot_find_prog_unit_error
569: (p_module_name => 'per_contracts_f'
570: ,p_hook_type => 'AU');
571: --
572: end;
632: -- p_rec plsql record structure
633: -- to see if a system default is being used. If a system default
634: -- is being used then we must set to the 'current' argument value.
635: --
636: If (p_rec.business_group_id = hr_api.g_number) then
637: p_rec.business_group_id :=
638: per_ctc_shd.g_old_rec.business_group_id;
639: End If;
640: If (p_rec.person_id = hr_api.g_number) then
636: If (p_rec.business_group_id = hr_api.g_number) then
637: p_rec.business_group_id :=
638: per_ctc_shd.g_old_rec.business_group_id;
639: End If;
640: If (p_rec.person_id = hr_api.g_number) then
641: p_rec.person_id :=
642: per_ctc_shd.g_old_rec.person_id;
643: End If;
644: If (p_rec.reference = hr_api.g_varchar2) then
640: If (p_rec.person_id = hr_api.g_number) then
641: p_rec.person_id :=
642: per_ctc_shd.g_old_rec.person_id;
643: End If;
644: If (p_rec.reference = hr_api.g_varchar2) then
645: p_rec.reference :=
646: per_ctc_shd.g_old_rec.reference;
647: End If;
648: If (p_rec.type = hr_api.g_varchar2) then
644: If (p_rec.reference = hr_api.g_varchar2) then
645: p_rec.reference :=
646: per_ctc_shd.g_old_rec.reference;
647: End If;
648: If (p_rec.type = hr_api.g_varchar2) then
649: p_rec.type :=
650: per_ctc_shd.g_old_rec.type;
651: End If;
652: If (p_rec.status = hr_api.g_varchar2) then
648: If (p_rec.type = hr_api.g_varchar2) then
649: p_rec.type :=
650: per_ctc_shd.g_old_rec.type;
651: End If;
652: If (p_rec.status = hr_api.g_varchar2) then
653: p_rec.status :=
654: per_ctc_shd.g_old_rec.status;
655: End If;
656: If (p_rec.status_reason = hr_api.g_varchar2) then
652: If (p_rec.status = hr_api.g_varchar2) then
653: p_rec.status :=
654: per_ctc_shd.g_old_rec.status;
655: End If;
656: If (p_rec.status_reason = hr_api.g_varchar2) then
657: p_rec.status_reason :=
658: per_ctc_shd.g_old_rec.status_reason;
659: End if;
660: If (p_rec.doc_status = hr_api.g_varchar2) then
656: If (p_rec.status_reason = hr_api.g_varchar2) then
657: p_rec.status_reason :=
658: per_ctc_shd.g_old_rec.status_reason;
659: End if;
660: If (p_rec.doc_status = hr_api.g_varchar2) then
661: p_rec.doc_status :=
662: per_ctc_shd.g_old_rec.doc_status;
663: End If;
664: If (p_rec.doc_status_change_date = hr_api.g_date) then
660: If (p_rec.doc_status = hr_api.g_varchar2) then
661: p_rec.doc_status :=
662: per_ctc_shd.g_old_rec.doc_status;
663: End If;
664: If (p_rec.doc_status_change_date = hr_api.g_date) then
665: p_rec.doc_status_change_date :=
666: per_ctc_shd.g_old_rec.doc_status_change_date;
667: End If;
668: If (p_rec.description = hr_api.g_varchar2) then
664: If (p_rec.doc_status_change_date = hr_api.g_date) then
665: p_rec.doc_status_change_date :=
666: per_ctc_shd.g_old_rec.doc_status_change_date;
667: End If;
668: If (p_rec.description = hr_api.g_varchar2) then
669: p_rec.description :=
670: per_ctc_shd.g_old_rec.description;
671: End If;
672: If (p_rec.duration = hr_api.g_number) then
668: If (p_rec.description = hr_api.g_varchar2) then
669: p_rec.description :=
670: per_ctc_shd.g_old_rec.description;
671: End If;
672: If (p_rec.duration = hr_api.g_number) then
673: p_rec.duration :=
674: per_ctc_shd.g_old_rec.duration;
675: End If;
676: If (p_rec.duration_units = hr_api.g_varchar2) then
672: If (p_rec.duration = hr_api.g_number) then
673: p_rec.duration :=
674: per_ctc_shd.g_old_rec.duration;
675: End If;
676: If (p_rec.duration_units = hr_api.g_varchar2) then
677: p_rec.duration_units :=
678: per_ctc_shd.g_old_rec.duration_units;
679: End If;
680: If (p_rec.contractual_job_title = hr_api.g_varchar2) then
676: If (p_rec.duration_units = hr_api.g_varchar2) then
677: p_rec.duration_units :=
678: per_ctc_shd.g_old_rec.duration_units;
679: End If;
680: If (p_rec.contractual_job_title = hr_api.g_varchar2) then
681: p_rec.contractual_job_title :=
682: per_ctc_shd.g_old_rec.contractual_job_title;
683: End If;
684: If (p_rec.parties = hr_api.g_varchar2) then
680: If (p_rec.contractual_job_title = hr_api.g_varchar2) then
681: p_rec.contractual_job_title :=
682: per_ctc_shd.g_old_rec.contractual_job_title;
683: End If;
684: If (p_rec.parties = hr_api.g_varchar2) then
685: p_rec.parties :=
686: per_ctc_shd.g_old_rec.parties;
687: End If;
688: If (p_rec.start_reason = hr_api.g_varchar2) then
684: If (p_rec.parties = hr_api.g_varchar2) then
685: p_rec.parties :=
686: per_ctc_shd.g_old_rec.parties;
687: End If;
688: If (p_rec.start_reason = hr_api.g_varchar2) then
689: p_rec.start_reason :=
690: per_ctc_shd.g_old_rec.start_reason;
691: End If;
692: If (p_rec.end_reason = hr_api.g_varchar2) then
688: If (p_rec.start_reason = hr_api.g_varchar2) then
689: p_rec.start_reason :=
690: per_ctc_shd.g_old_rec.start_reason;
691: End If;
692: If (p_rec.end_reason = hr_api.g_varchar2) then
693: p_rec.end_reason :=
694: per_ctc_shd.g_old_rec.end_reason;
695: End If;
696: If (p_rec.number_of_extensions = hr_api.g_number) then
692: If (p_rec.end_reason = hr_api.g_varchar2) then
693: p_rec.end_reason :=
694: per_ctc_shd.g_old_rec.end_reason;
695: End If;
696: If (p_rec.number_of_extensions = hr_api.g_number) then
697: p_rec.number_of_extensions :=
698: per_ctc_shd.g_old_rec.number_of_extensions;
699: End If;
700: If (p_rec.extension_reason = hr_api.g_varchar2) then
696: If (p_rec.number_of_extensions = hr_api.g_number) then
697: p_rec.number_of_extensions :=
698: per_ctc_shd.g_old_rec.number_of_extensions;
699: End If;
700: If (p_rec.extension_reason = hr_api.g_varchar2) then
701: p_rec.extension_reason :=
702: per_ctc_shd.g_old_rec.extension_reason;
703: End If;
704: If (p_rec.extension_period = hr_api.g_number) then
700: If (p_rec.extension_reason = hr_api.g_varchar2) then
701: p_rec.extension_reason :=
702: per_ctc_shd.g_old_rec.extension_reason;
703: End If;
704: If (p_rec.extension_period = hr_api.g_number) then
705: p_rec.extension_period :=
706: per_ctc_shd.g_old_rec.extension_period;
707: End If;
708: If (p_rec.extension_period_units = hr_api.g_varchar2) then
704: If (p_rec.extension_period = hr_api.g_number) then
705: p_rec.extension_period :=
706: per_ctc_shd.g_old_rec.extension_period;
707: End If;
708: If (p_rec.extension_period_units = hr_api.g_varchar2) then
709: p_rec.extension_period_units :=
710: per_ctc_shd.g_old_rec.extension_period_units;
711: End If;
712: If (p_rec.ctr_information_category = hr_api.g_varchar2) then
708: If (p_rec.extension_period_units = hr_api.g_varchar2) then
709: p_rec.extension_period_units :=
710: per_ctc_shd.g_old_rec.extension_period_units;
711: End If;
712: If (p_rec.ctr_information_category = hr_api.g_varchar2) then
713: p_rec.ctr_information_category :=
714: per_ctc_shd.g_old_rec.ctr_information_category;
715: End If;
716: If (p_rec.ctr_information1 = hr_api.g_varchar2) then
712: If (p_rec.ctr_information_category = hr_api.g_varchar2) then
713: p_rec.ctr_information_category :=
714: per_ctc_shd.g_old_rec.ctr_information_category;
715: End If;
716: If (p_rec.ctr_information1 = hr_api.g_varchar2) then
717: p_rec.ctr_information1 :=
718: per_ctc_shd.g_old_rec.ctr_information1;
719: End If;
720: If (p_rec.ctr_information2 = hr_api.g_varchar2) then
716: If (p_rec.ctr_information1 = hr_api.g_varchar2) then
717: p_rec.ctr_information1 :=
718: per_ctc_shd.g_old_rec.ctr_information1;
719: End If;
720: If (p_rec.ctr_information2 = hr_api.g_varchar2) then
721: p_rec.ctr_information2 :=
722: per_ctc_shd.g_old_rec.ctr_information2;
723: End If;
724: If (p_rec.ctr_information3 = hr_api.g_varchar2) then
720: If (p_rec.ctr_information2 = hr_api.g_varchar2) then
721: p_rec.ctr_information2 :=
722: per_ctc_shd.g_old_rec.ctr_information2;
723: End If;
724: If (p_rec.ctr_information3 = hr_api.g_varchar2) then
725: p_rec.ctr_information3 :=
726: per_ctc_shd.g_old_rec.ctr_information3;
727: End If;
728: If (p_rec.ctr_information4 = hr_api.g_varchar2) then
724: If (p_rec.ctr_information3 = hr_api.g_varchar2) then
725: p_rec.ctr_information3 :=
726: per_ctc_shd.g_old_rec.ctr_information3;
727: End If;
728: If (p_rec.ctr_information4 = hr_api.g_varchar2) then
729: p_rec.ctr_information4 :=
730: per_ctc_shd.g_old_rec.ctr_information4;
731: End If;
732: If (p_rec.ctr_information5 = hr_api.g_varchar2) then
728: If (p_rec.ctr_information4 = hr_api.g_varchar2) then
729: p_rec.ctr_information4 :=
730: per_ctc_shd.g_old_rec.ctr_information4;
731: End If;
732: If (p_rec.ctr_information5 = hr_api.g_varchar2) then
733: p_rec.ctr_information5 :=
734: per_ctc_shd.g_old_rec.ctr_information5;
735: End If;
736: If (p_rec.ctr_information6 = hr_api.g_varchar2) then
732: If (p_rec.ctr_information5 = hr_api.g_varchar2) then
733: p_rec.ctr_information5 :=
734: per_ctc_shd.g_old_rec.ctr_information5;
735: End If;
736: If (p_rec.ctr_information6 = hr_api.g_varchar2) then
737: p_rec.ctr_information6 :=
738: per_ctc_shd.g_old_rec.ctr_information6;
739: End If;
740: If (p_rec.ctr_information7 = hr_api.g_varchar2) then
736: If (p_rec.ctr_information6 = hr_api.g_varchar2) then
737: p_rec.ctr_information6 :=
738: per_ctc_shd.g_old_rec.ctr_information6;
739: End If;
740: If (p_rec.ctr_information7 = hr_api.g_varchar2) then
741: p_rec.ctr_information7 :=
742: per_ctc_shd.g_old_rec.ctr_information7;
743: End If;
744: If (p_rec.ctr_information8 = hr_api.g_varchar2) then
740: If (p_rec.ctr_information7 = hr_api.g_varchar2) then
741: p_rec.ctr_information7 :=
742: per_ctc_shd.g_old_rec.ctr_information7;
743: End If;
744: If (p_rec.ctr_information8 = hr_api.g_varchar2) then
745: p_rec.ctr_information8 :=
746: per_ctc_shd.g_old_rec.ctr_information8;
747: End If;
748: If (p_rec.ctr_information9 = hr_api.g_varchar2) then
744: If (p_rec.ctr_information8 = hr_api.g_varchar2) then
745: p_rec.ctr_information8 :=
746: per_ctc_shd.g_old_rec.ctr_information8;
747: End If;
748: If (p_rec.ctr_information9 = hr_api.g_varchar2) then
749: p_rec.ctr_information9 :=
750: per_ctc_shd.g_old_rec.ctr_information9;
751: End If;
752: If (p_rec.ctr_information10 = hr_api.g_varchar2) then
748: If (p_rec.ctr_information9 = hr_api.g_varchar2) then
749: p_rec.ctr_information9 :=
750: per_ctc_shd.g_old_rec.ctr_information9;
751: End If;
752: If (p_rec.ctr_information10 = hr_api.g_varchar2) then
753: p_rec.ctr_information10 :=
754: per_ctc_shd.g_old_rec.ctr_information10;
755: End If;
756: If (p_rec.ctr_information11 = hr_api.g_varchar2) then
752: If (p_rec.ctr_information10 = hr_api.g_varchar2) then
753: p_rec.ctr_information10 :=
754: per_ctc_shd.g_old_rec.ctr_information10;
755: End If;
756: If (p_rec.ctr_information11 = hr_api.g_varchar2) then
757: p_rec.ctr_information11 :=
758: per_ctc_shd.g_old_rec.ctr_information11;
759: End If;
760: If (p_rec.ctr_information12 = hr_api.g_varchar2) then
756: If (p_rec.ctr_information11 = hr_api.g_varchar2) then
757: p_rec.ctr_information11 :=
758: per_ctc_shd.g_old_rec.ctr_information11;
759: End If;
760: If (p_rec.ctr_information12 = hr_api.g_varchar2) then
761: p_rec.ctr_information12 :=
762: per_ctc_shd.g_old_rec.ctr_information12;
763: End If;
764: If (p_rec.ctr_information13 = hr_api.g_varchar2) then
760: If (p_rec.ctr_information12 = hr_api.g_varchar2) then
761: p_rec.ctr_information12 :=
762: per_ctc_shd.g_old_rec.ctr_information12;
763: End If;
764: If (p_rec.ctr_information13 = hr_api.g_varchar2) then
765: p_rec.ctr_information13 :=
766: per_ctc_shd.g_old_rec.ctr_information13;
767: End If;
768: If (p_rec.ctr_information14 = hr_api.g_varchar2) then
764: If (p_rec.ctr_information13 = hr_api.g_varchar2) then
765: p_rec.ctr_information13 :=
766: per_ctc_shd.g_old_rec.ctr_information13;
767: End If;
768: If (p_rec.ctr_information14 = hr_api.g_varchar2) then
769: p_rec.ctr_information14 :=
770: per_ctc_shd.g_old_rec.ctr_information14;
771: End If;
772: If (p_rec.ctr_information15 = hr_api.g_varchar2) then
768: If (p_rec.ctr_information14 = hr_api.g_varchar2) then
769: p_rec.ctr_information14 :=
770: per_ctc_shd.g_old_rec.ctr_information14;
771: End If;
772: If (p_rec.ctr_information15 = hr_api.g_varchar2) then
773: p_rec.ctr_information15 :=
774: per_ctc_shd.g_old_rec.ctr_information15;
775: End If;
776: If (p_rec.ctr_information16 = hr_api.g_varchar2) then
772: If (p_rec.ctr_information15 = hr_api.g_varchar2) then
773: p_rec.ctr_information15 :=
774: per_ctc_shd.g_old_rec.ctr_information15;
775: End If;
776: If (p_rec.ctr_information16 = hr_api.g_varchar2) then
777: p_rec.ctr_information16 :=
778: per_ctc_shd.g_old_rec.ctr_information16;
779: End If;
780: If (p_rec.ctr_information17 = hr_api.g_varchar2) then
776: If (p_rec.ctr_information16 = hr_api.g_varchar2) then
777: p_rec.ctr_information16 :=
778: per_ctc_shd.g_old_rec.ctr_information16;
779: End If;
780: If (p_rec.ctr_information17 = hr_api.g_varchar2) then
781: p_rec.ctr_information17 :=
782: per_ctc_shd.g_old_rec.ctr_information17;
783: End If;
784: If (p_rec.ctr_information18 = hr_api.g_varchar2) then
780: If (p_rec.ctr_information17 = hr_api.g_varchar2) then
781: p_rec.ctr_information17 :=
782: per_ctc_shd.g_old_rec.ctr_information17;
783: End If;
784: If (p_rec.ctr_information18 = hr_api.g_varchar2) then
785: p_rec.ctr_information18 :=
786: per_ctc_shd.g_old_rec.ctr_information18;
787: End If;
788: If (p_rec.ctr_information19 = hr_api.g_varchar2) then
784: If (p_rec.ctr_information18 = hr_api.g_varchar2) then
785: p_rec.ctr_information18 :=
786: per_ctc_shd.g_old_rec.ctr_information18;
787: End If;
788: If (p_rec.ctr_information19 = hr_api.g_varchar2) then
789: p_rec.ctr_information19 :=
790: per_ctc_shd.g_old_rec.ctr_information19;
791: End If;
792: If (p_rec.ctr_information20 = hr_api.g_varchar2) then
788: If (p_rec.ctr_information19 = hr_api.g_varchar2) then
789: p_rec.ctr_information19 :=
790: per_ctc_shd.g_old_rec.ctr_information19;
791: End If;
792: If (p_rec.ctr_information20 = hr_api.g_varchar2) then
793: p_rec.ctr_information20 :=
794: per_ctc_shd.g_old_rec.ctr_information20;
795: End If;
796: If (p_rec.attribute_category = hr_api.g_varchar2) then
792: If (p_rec.ctr_information20 = hr_api.g_varchar2) then
793: p_rec.ctr_information20 :=
794: per_ctc_shd.g_old_rec.ctr_information20;
795: End If;
796: If (p_rec.attribute_category = hr_api.g_varchar2) then
797: p_rec.attribute_category :=
798: per_ctc_shd.g_old_rec.attribute_category;
799: End If;
800: If (p_rec.attribute1 = hr_api.g_varchar2) then
796: If (p_rec.attribute_category = hr_api.g_varchar2) then
797: p_rec.attribute_category :=
798: per_ctc_shd.g_old_rec.attribute_category;
799: End If;
800: If (p_rec.attribute1 = hr_api.g_varchar2) then
801: p_rec.attribute1 :=
802: per_ctc_shd.g_old_rec.attribute1;
803: End If;
804: If (p_rec.attribute2 = hr_api.g_varchar2) then
800: If (p_rec.attribute1 = hr_api.g_varchar2) then
801: p_rec.attribute1 :=
802: per_ctc_shd.g_old_rec.attribute1;
803: End If;
804: If (p_rec.attribute2 = hr_api.g_varchar2) then
805: p_rec.attribute2 :=
806: per_ctc_shd.g_old_rec.attribute2;
807: End If;
808: If (p_rec.attribute3 = hr_api.g_varchar2) then
804: If (p_rec.attribute2 = hr_api.g_varchar2) then
805: p_rec.attribute2 :=
806: per_ctc_shd.g_old_rec.attribute2;
807: End If;
808: If (p_rec.attribute3 = hr_api.g_varchar2) then
809: p_rec.attribute3 :=
810: per_ctc_shd.g_old_rec.attribute3;
811: End If;
812: If (p_rec.attribute4 = hr_api.g_varchar2) then
808: If (p_rec.attribute3 = hr_api.g_varchar2) then
809: p_rec.attribute3 :=
810: per_ctc_shd.g_old_rec.attribute3;
811: End If;
812: If (p_rec.attribute4 = hr_api.g_varchar2) then
813: p_rec.attribute4 :=
814: per_ctc_shd.g_old_rec.attribute4;
815: End If;
816: If (p_rec.attribute5 = hr_api.g_varchar2) then
812: If (p_rec.attribute4 = hr_api.g_varchar2) then
813: p_rec.attribute4 :=
814: per_ctc_shd.g_old_rec.attribute4;
815: End If;
816: If (p_rec.attribute5 = hr_api.g_varchar2) then
817: p_rec.attribute5 :=
818: per_ctc_shd.g_old_rec.attribute5;
819: End If;
820: If (p_rec.attribute6 = hr_api.g_varchar2) then
816: If (p_rec.attribute5 = hr_api.g_varchar2) then
817: p_rec.attribute5 :=
818: per_ctc_shd.g_old_rec.attribute5;
819: End If;
820: If (p_rec.attribute6 = hr_api.g_varchar2) then
821: p_rec.attribute6 :=
822: per_ctc_shd.g_old_rec.attribute6;
823: End If;
824: If (p_rec.attribute7 = hr_api.g_varchar2) then
820: If (p_rec.attribute6 = hr_api.g_varchar2) then
821: p_rec.attribute6 :=
822: per_ctc_shd.g_old_rec.attribute6;
823: End If;
824: If (p_rec.attribute7 = hr_api.g_varchar2) then
825: p_rec.attribute7 :=
826: per_ctc_shd.g_old_rec.attribute7;
827: End If;
828: If (p_rec.attribute8 = hr_api.g_varchar2) then
824: If (p_rec.attribute7 = hr_api.g_varchar2) then
825: p_rec.attribute7 :=
826: per_ctc_shd.g_old_rec.attribute7;
827: End If;
828: If (p_rec.attribute8 = hr_api.g_varchar2) then
829: p_rec.attribute8 :=
830: per_ctc_shd.g_old_rec.attribute8;
831: End If;
832: If (p_rec.attribute9 = hr_api.g_varchar2) then
828: If (p_rec.attribute8 = hr_api.g_varchar2) then
829: p_rec.attribute8 :=
830: per_ctc_shd.g_old_rec.attribute8;
831: End If;
832: If (p_rec.attribute9 = hr_api.g_varchar2) then
833: p_rec.attribute9 :=
834: per_ctc_shd.g_old_rec.attribute9;
835: End If;
836: If (p_rec.attribute10 = hr_api.g_varchar2) then
832: If (p_rec.attribute9 = hr_api.g_varchar2) then
833: p_rec.attribute9 :=
834: per_ctc_shd.g_old_rec.attribute9;
835: End If;
836: If (p_rec.attribute10 = hr_api.g_varchar2) then
837: p_rec.attribute10 :=
838: per_ctc_shd.g_old_rec.attribute10;
839: End If;
840: If (p_rec.attribute11 = hr_api.g_varchar2) then
836: If (p_rec.attribute10 = hr_api.g_varchar2) then
837: p_rec.attribute10 :=
838: per_ctc_shd.g_old_rec.attribute10;
839: End If;
840: If (p_rec.attribute11 = hr_api.g_varchar2) then
841: p_rec.attribute11 :=
842: per_ctc_shd.g_old_rec.attribute11;
843: End If;
844: If (p_rec.attribute12 = hr_api.g_varchar2) then
840: If (p_rec.attribute11 = hr_api.g_varchar2) then
841: p_rec.attribute11 :=
842: per_ctc_shd.g_old_rec.attribute11;
843: End If;
844: If (p_rec.attribute12 = hr_api.g_varchar2) then
845: p_rec.attribute12 :=
846: per_ctc_shd.g_old_rec.attribute12;
847: End If;
848: If (p_rec.attribute13 = hr_api.g_varchar2) then
844: If (p_rec.attribute12 = hr_api.g_varchar2) then
845: p_rec.attribute12 :=
846: per_ctc_shd.g_old_rec.attribute12;
847: End If;
848: If (p_rec.attribute13 = hr_api.g_varchar2) then
849: p_rec.attribute13 :=
850: per_ctc_shd.g_old_rec.attribute13;
851: End If;
852: If (p_rec.attribute14 = hr_api.g_varchar2) then
848: If (p_rec.attribute13 = hr_api.g_varchar2) then
849: p_rec.attribute13 :=
850: per_ctc_shd.g_old_rec.attribute13;
851: End If;
852: If (p_rec.attribute14 = hr_api.g_varchar2) then
853: p_rec.attribute14 :=
854: per_ctc_shd.g_old_rec.attribute14;
855: End If;
856: If (p_rec.attribute15 = hr_api.g_varchar2) then
852: If (p_rec.attribute14 = hr_api.g_varchar2) then
853: p_rec.attribute14 :=
854: per_ctc_shd.g_old_rec.attribute14;
855: End If;
856: If (p_rec.attribute15 = hr_api.g_varchar2) then
857:
858: p_rec.attribute15 :=
859: per_ctc_shd.g_old_rec.attribute15;
860: End If;
857:
858: p_rec.attribute15 :=
859: per_ctc_shd.g_old_rec.attribute15;
860: End If;
861: If (p_rec.attribute16 = hr_api.g_varchar2) then
862: p_rec.attribute16 :=
863: per_ctc_shd.g_old_rec.attribute16;
864: End If;
865: If (p_rec.attribute17 = hr_api.g_varchar2) then
861: If (p_rec.attribute16 = hr_api.g_varchar2) then
862: p_rec.attribute16 :=
863: per_ctc_shd.g_old_rec.attribute16;
864: End If;
865: If (p_rec.attribute17 = hr_api.g_varchar2) then
866: p_rec.attribute17 :=
867: per_ctc_shd.g_old_rec.attribute17;
868: End If;
869: If (p_rec.attribute18 = hr_api.g_varchar2) then
865: If (p_rec.attribute17 = hr_api.g_varchar2) then
866: p_rec.attribute17 :=
867: per_ctc_shd.g_old_rec.attribute17;
868: End If;
869: If (p_rec.attribute18 = hr_api.g_varchar2) then
870: p_rec.attribute18 :=
871: per_ctc_shd.g_old_rec.attribute18;
872: End If;
873: If (p_rec.attribute19 = hr_api.g_varchar2) then
869: If (p_rec.attribute18 = hr_api.g_varchar2) then
870: p_rec.attribute18 :=
871: per_ctc_shd.g_old_rec.attribute18;
872: End If;
873: If (p_rec.attribute19 = hr_api.g_varchar2) then
874: p_rec.attribute19 :=
875: per_ctc_shd.g_old_rec.attribute19;
876: End If;
877: If (p_rec.attribute20 = hr_api.g_varchar2) then
873: If (p_rec.attribute19 = hr_api.g_varchar2) then
874: p_rec.attribute19 :=
875: per_ctc_shd.g_old_rec.attribute19;
876: End If;
877: If (p_rec.attribute20 = hr_api.g_varchar2) then
878: p_rec.attribute20 :=
879: per_ctc_shd.g_old_rec.attribute20;
880: End If;
881: --
965: p_contract_id in number,
966: p_effective_start_date out nocopy date,
967: p_effective_end_date out nocopy date,
968: p_object_version_number in out nocopy number,
969: p_reference in varchar2 default hr_api.g_varchar2,
970: p_type in varchar2 default hr_api.g_varchar2,
971: p_status in varchar2 default hr_api.g_varchar2,
972: p_status_reason in varchar2 default hr_api.g_varchar2,
973: p_doc_status in varchar2 default hr_api.g_varchar2,
966: p_effective_start_date out nocopy date,
967: p_effective_end_date out nocopy date,
968: p_object_version_number in out nocopy number,
969: p_reference in varchar2 default hr_api.g_varchar2,
970: p_type in varchar2 default hr_api.g_varchar2,
971: p_status in varchar2 default hr_api.g_varchar2,
972: p_status_reason in varchar2 default hr_api.g_varchar2,
973: p_doc_status in varchar2 default hr_api.g_varchar2,
974: p_doc_status_change_date in date default hr_api.g_date,
967: p_effective_end_date out nocopy date,
968: p_object_version_number in out nocopy number,
969: p_reference in varchar2 default hr_api.g_varchar2,
970: p_type in varchar2 default hr_api.g_varchar2,
971: p_status in varchar2 default hr_api.g_varchar2,
972: p_status_reason in varchar2 default hr_api.g_varchar2,
973: p_doc_status in varchar2 default hr_api.g_varchar2,
974: p_doc_status_change_date in date default hr_api.g_date,
975: p_description in varchar2 default hr_api.g_varchar2,
968: p_object_version_number in out nocopy number,
969: p_reference in varchar2 default hr_api.g_varchar2,
970: p_type in varchar2 default hr_api.g_varchar2,
971: p_status in varchar2 default hr_api.g_varchar2,
972: p_status_reason in varchar2 default hr_api.g_varchar2,
973: p_doc_status in varchar2 default hr_api.g_varchar2,
974: p_doc_status_change_date in date default hr_api.g_date,
975: p_description in varchar2 default hr_api.g_varchar2,
976: p_duration in number default hr_api.g_number,
969: p_reference in varchar2 default hr_api.g_varchar2,
970: p_type in varchar2 default hr_api.g_varchar2,
971: p_status in varchar2 default hr_api.g_varchar2,
972: p_status_reason in varchar2 default hr_api.g_varchar2,
973: p_doc_status in varchar2 default hr_api.g_varchar2,
974: p_doc_status_change_date in date default hr_api.g_date,
975: p_description in varchar2 default hr_api.g_varchar2,
976: p_duration in number default hr_api.g_number,
977: p_duration_units in varchar2 default hr_api.g_varchar2,
970: p_type in varchar2 default hr_api.g_varchar2,
971: p_status in varchar2 default hr_api.g_varchar2,
972: p_status_reason in varchar2 default hr_api.g_varchar2,
973: p_doc_status in varchar2 default hr_api.g_varchar2,
974: p_doc_status_change_date in date default hr_api.g_date,
975: p_description in varchar2 default hr_api.g_varchar2,
976: p_duration in number default hr_api.g_number,
977: p_duration_units in varchar2 default hr_api.g_varchar2,
978: p_contractual_job_title in varchar2 default hr_api.g_varchar2,
971: p_status in varchar2 default hr_api.g_varchar2,
972: p_status_reason in varchar2 default hr_api.g_varchar2,
973: p_doc_status in varchar2 default hr_api.g_varchar2,
974: p_doc_status_change_date in date default hr_api.g_date,
975: p_description in varchar2 default hr_api.g_varchar2,
976: p_duration in number default hr_api.g_number,
977: p_duration_units in varchar2 default hr_api.g_varchar2,
978: p_contractual_job_title in varchar2 default hr_api.g_varchar2,
979: p_parties in varchar2 default hr_api.g_varchar2,
972: p_status_reason in varchar2 default hr_api.g_varchar2,
973: p_doc_status in varchar2 default hr_api.g_varchar2,
974: p_doc_status_change_date in date default hr_api.g_date,
975: p_description in varchar2 default hr_api.g_varchar2,
976: p_duration in number default hr_api.g_number,
977: p_duration_units in varchar2 default hr_api.g_varchar2,
978: p_contractual_job_title in varchar2 default hr_api.g_varchar2,
979: p_parties in varchar2 default hr_api.g_varchar2,
980: p_start_reason in varchar2 default hr_api.g_varchar2,
973: p_doc_status in varchar2 default hr_api.g_varchar2,
974: p_doc_status_change_date in date default hr_api.g_date,
975: p_description in varchar2 default hr_api.g_varchar2,
976: p_duration in number default hr_api.g_number,
977: p_duration_units in varchar2 default hr_api.g_varchar2,
978: p_contractual_job_title in varchar2 default hr_api.g_varchar2,
979: p_parties in varchar2 default hr_api.g_varchar2,
980: p_start_reason in varchar2 default hr_api.g_varchar2,
981: p_end_reason in varchar2 default hr_api.g_varchar2,
974: p_doc_status_change_date in date default hr_api.g_date,
975: p_description in varchar2 default hr_api.g_varchar2,
976: p_duration in number default hr_api.g_number,
977: p_duration_units in varchar2 default hr_api.g_varchar2,
978: p_contractual_job_title in varchar2 default hr_api.g_varchar2,
979: p_parties in varchar2 default hr_api.g_varchar2,
980: p_start_reason in varchar2 default hr_api.g_varchar2,
981: p_end_reason in varchar2 default hr_api.g_varchar2,
982: p_number_of_extensions in number default hr_api.g_number,
975: p_description in varchar2 default hr_api.g_varchar2,
976: p_duration in number default hr_api.g_number,
977: p_duration_units in varchar2 default hr_api.g_varchar2,
978: p_contractual_job_title in varchar2 default hr_api.g_varchar2,
979: p_parties in varchar2 default hr_api.g_varchar2,
980: p_start_reason in varchar2 default hr_api.g_varchar2,
981: p_end_reason in varchar2 default hr_api.g_varchar2,
982: p_number_of_extensions in number default hr_api.g_number,
983: p_extension_reason in varchar2 default hr_api.g_varchar2,
976: p_duration in number default hr_api.g_number,
977: p_duration_units in varchar2 default hr_api.g_varchar2,
978: p_contractual_job_title in varchar2 default hr_api.g_varchar2,
979: p_parties in varchar2 default hr_api.g_varchar2,
980: p_start_reason in varchar2 default hr_api.g_varchar2,
981: p_end_reason in varchar2 default hr_api.g_varchar2,
982: p_number_of_extensions in number default hr_api.g_number,
983: p_extension_reason in varchar2 default hr_api.g_varchar2,
984: p_extension_period in number default hr_api.g_number,
977: p_duration_units in varchar2 default hr_api.g_varchar2,
978: p_contractual_job_title in varchar2 default hr_api.g_varchar2,
979: p_parties in varchar2 default hr_api.g_varchar2,
980: p_start_reason in varchar2 default hr_api.g_varchar2,
981: p_end_reason in varchar2 default hr_api.g_varchar2,
982: p_number_of_extensions in number default hr_api.g_number,
983: p_extension_reason in varchar2 default hr_api.g_varchar2,
984: p_extension_period in number default hr_api.g_number,
985: p_extension_period_units in varchar2 default hr_api.g_varchar2,
978: p_contractual_job_title in varchar2 default hr_api.g_varchar2,
979: p_parties in varchar2 default hr_api.g_varchar2,
980: p_start_reason in varchar2 default hr_api.g_varchar2,
981: p_end_reason in varchar2 default hr_api.g_varchar2,
982: p_number_of_extensions in number default hr_api.g_number,
983: p_extension_reason in varchar2 default hr_api.g_varchar2,
984: p_extension_period in number default hr_api.g_number,
985: p_extension_period_units in varchar2 default hr_api.g_varchar2,
986: p_ctr_information_category in varchar2 default hr_api.g_varchar2,
979: p_parties in varchar2 default hr_api.g_varchar2,
980: p_start_reason in varchar2 default hr_api.g_varchar2,
981: p_end_reason in varchar2 default hr_api.g_varchar2,
982: p_number_of_extensions in number default hr_api.g_number,
983: p_extension_reason in varchar2 default hr_api.g_varchar2,
984: p_extension_period in number default hr_api.g_number,
985: p_extension_period_units in varchar2 default hr_api.g_varchar2,
986: p_ctr_information_category in varchar2 default hr_api.g_varchar2,
987: p_ctr_information1 in varchar2 default hr_api.g_varchar2,
980: p_start_reason in varchar2 default hr_api.g_varchar2,
981: p_end_reason in varchar2 default hr_api.g_varchar2,
982: p_number_of_extensions in number default hr_api.g_number,
983: p_extension_reason in varchar2 default hr_api.g_varchar2,
984: p_extension_period in number default hr_api.g_number,
985: p_extension_period_units in varchar2 default hr_api.g_varchar2,
986: p_ctr_information_category in varchar2 default hr_api.g_varchar2,
987: p_ctr_information1 in varchar2 default hr_api.g_varchar2,
988: p_ctr_information2 in varchar2 default hr_api.g_varchar2,
981: p_end_reason in varchar2 default hr_api.g_varchar2,
982: p_number_of_extensions in number default hr_api.g_number,
983: p_extension_reason in varchar2 default hr_api.g_varchar2,
984: p_extension_period in number default hr_api.g_number,
985: p_extension_period_units in varchar2 default hr_api.g_varchar2,
986: p_ctr_information_category in varchar2 default hr_api.g_varchar2,
987: p_ctr_information1 in varchar2 default hr_api.g_varchar2,
988: p_ctr_information2 in varchar2 default hr_api.g_varchar2,
989: p_ctr_information3 in varchar2 default hr_api.g_varchar2,
982: p_number_of_extensions in number default hr_api.g_number,
983: p_extension_reason in varchar2 default hr_api.g_varchar2,
984: p_extension_period in number default hr_api.g_number,
985: p_extension_period_units in varchar2 default hr_api.g_varchar2,
986: p_ctr_information_category in varchar2 default hr_api.g_varchar2,
987: p_ctr_information1 in varchar2 default hr_api.g_varchar2,
988: p_ctr_information2 in varchar2 default hr_api.g_varchar2,
989: p_ctr_information3 in varchar2 default hr_api.g_varchar2,
990: p_ctr_information4 in varchar2 default hr_api.g_varchar2,
983: p_extension_reason in varchar2 default hr_api.g_varchar2,
984: p_extension_period in number default hr_api.g_number,
985: p_extension_period_units in varchar2 default hr_api.g_varchar2,
986: p_ctr_information_category in varchar2 default hr_api.g_varchar2,
987: p_ctr_information1 in varchar2 default hr_api.g_varchar2,
988: p_ctr_information2 in varchar2 default hr_api.g_varchar2,
989: p_ctr_information3 in varchar2 default hr_api.g_varchar2,
990: p_ctr_information4 in varchar2 default hr_api.g_varchar2,
991: p_ctr_information5 in varchar2 default hr_api.g_varchar2,
984: p_extension_period in number default hr_api.g_number,
985: p_extension_period_units in varchar2 default hr_api.g_varchar2,
986: p_ctr_information_category in varchar2 default hr_api.g_varchar2,
987: p_ctr_information1 in varchar2 default hr_api.g_varchar2,
988: p_ctr_information2 in varchar2 default hr_api.g_varchar2,
989: p_ctr_information3 in varchar2 default hr_api.g_varchar2,
990: p_ctr_information4 in varchar2 default hr_api.g_varchar2,
991: p_ctr_information5 in varchar2 default hr_api.g_varchar2,
992: p_ctr_information6 in varchar2 default hr_api.g_varchar2,
985: p_extension_period_units in varchar2 default hr_api.g_varchar2,
986: p_ctr_information_category in varchar2 default hr_api.g_varchar2,
987: p_ctr_information1 in varchar2 default hr_api.g_varchar2,
988: p_ctr_information2 in varchar2 default hr_api.g_varchar2,
989: p_ctr_information3 in varchar2 default hr_api.g_varchar2,
990: p_ctr_information4 in varchar2 default hr_api.g_varchar2,
991: p_ctr_information5 in varchar2 default hr_api.g_varchar2,
992: p_ctr_information6 in varchar2 default hr_api.g_varchar2,
993: p_ctr_information7 in varchar2 default hr_api.g_varchar2,
986: p_ctr_information_category in varchar2 default hr_api.g_varchar2,
987: p_ctr_information1 in varchar2 default hr_api.g_varchar2,
988: p_ctr_information2 in varchar2 default hr_api.g_varchar2,
989: p_ctr_information3 in varchar2 default hr_api.g_varchar2,
990: p_ctr_information4 in varchar2 default hr_api.g_varchar2,
991: p_ctr_information5 in varchar2 default hr_api.g_varchar2,
992: p_ctr_information6 in varchar2 default hr_api.g_varchar2,
993: p_ctr_information7 in varchar2 default hr_api.g_varchar2,
994: p_ctr_information8 in varchar2 default hr_api.g_varchar2,
987: p_ctr_information1 in varchar2 default hr_api.g_varchar2,
988: p_ctr_information2 in varchar2 default hr_api.g_varchar2,
989: p_ctr_information3 in varchar2 default hr_api.g_varchar2,
990: p_ctr_information4 in varchar2 default hr_api.g_varchar2,
991: p_ctr_information5 in varchar2 default hr_api.g_varchar2,
992: p_ctr_information6 in varchar2 default hr_api.g_varchar2,
993: p_ctr_information7 in varchar2 default hr_api.g_varchar2,
994: p_ctr_information8 in varchar2 default hr_api.g_varchar2,
995: p_ctr_information9 in varchar2 default hr_api.g_varchar2,
988: p_ctr_information2 in varchar2 default hr_api.g_varchar2,
989: p_ctr_information3 in varchar2 default hr_api.g_varchar2,
990: p_ctr_information4 in varchar2 default hr_api.g_varchar2,
991: p_ctr_information5 in varchar2 default hr_api.g_varchar2,
992: p_ctr_information6 in varchar2 default hr_api.g_varchar2,
993: p_ctr_information7 in varchar2 default hr_api.g_varchar2,
994: p_ctr_information8 in varchar2 default hr_api.g_varchar2,
995: p_ctr_information9 in varchar2 default hr_api.g_varchar2,
996: p_ctr_information10 in varchar2 default hr_api.g_varchar2,
989: p_ctr_information3 in varchar2 default hr_api.g_varchar2,
990: p_ctr_information4 in varchar2 default hr_api.g_varchar2,
991: p_ctr_information5 in varchar2 default hr_api.g_varchar2,
992: p_ctr_information6 in varchar2 default hr_api.g_varchar2,
993: p_ctr_information7 in varchar2 default hr_api.g_varchar2,
994: p_ctr_information8 in varchar2 default hr_api.g_varchar2,
995: p_ctr_information9 in varchar2 default hr_api.g_varchar2,
996: p_ctr_information10 in varchar2 default hr_api.g_varchar2,
997: p_ctr_information11 in varchar2 default hr_api.g_varchar2,
990: p_ctr_information4 in varchar2 default hr_api.g_varchar2,
991: p_ctr_information5 in varchar2 default hr_api.g_varchar2,
992: p_ctr_information6 in varchar2 default hr_api.g_varchar2,
993: p_ctr_information7 in varchar2 default hr_api.g_varchar2,
994: p_ctr_information8 in varchar2 default hr_api.g_varchar2,
995: p_ctr_information9 in varchar2 default hr_api.g_varchar2,
996: p_ctr_information10 in varchar2 default hr_api.g_varchar2,
997: p_ctr_information11 in varchar2 default hr_api.g_varchar2,
998: p_ctr_information12 in varchar2 default hr_api.g_varchar2,
991: p_ctr_information5 in varchar2 default hr_api.g_varchar2,
992: p_ctr_information6 in varchar2 default hr_api.g_varchar2,
993: p_ctr_information7 in varchar2 default hr_api.g_varchar2,
994: p_ctr_information8 in varchar2 default hr_api.g_varchar2,
995: p_ctr_information9 in varchar2 default hr_api.g_varchar2,
996: p_ctr_information10 in varchar2 default hr_api.g_varchar2,
997: p_ctr_information11 in varchar2 default hr_api.g_varchar2,
998: p_ctr_information12 in varchar2 default hr_api.g_varchar2,
999: p_ctr_information13 in varchar2 default hr_api.g_varchar2,
992: p_ctr_information6 in varchar2 default hr_api.g_varchar2,
993: p_ctr_information7 in varchar2 default hr_api.g_varchar2,
994: p_ctr_information8 in varchar2 default hr_api.g_varchar2,
995: p_ctr_information9 in varchar2 default hr_api.g_varchar2,
996: p_ctr_information10 in varchar2 default hr_api.g_varchar2,
997: p_ctr_information11 in varchar2 default hr_api.g_varchar2,
998: p_ctr_information12 in varchar2 default hr_api.g_varchar2,
999: p_ctr_information13 in varchar2 default hr_api.g_varchar2,
1000: p_ctr_information14 in varchar2 default hr_api.g_varchar2,
993: p_ctr_information7 in varchar2 default hr_api.g_varchar2,
994: p_ctr_information8 in varchar2 default hr_api.g_varchar2,
995: p_ctr_information9 in varchar2 default hr_api.g_varchar2,
996: p_ctr_information10 in varchar2 default hr_api.g_varchar2,
997: p_ctr_information11 in varchar2 default hr_api.g_varchar2,
998: p_ctr_information12 in varchar2 default hr_api.g_varchar2,
999: p_ctr_information13 in varchar2 default hr_api.g_varchar2,
1000: p_ctr_information14 in varchar2 default hr_api.g_varchar2,
1001: p_ctr_information15 in varchar2 default hr_api.g_varchar2,
994: p_ctr_information8 in varchar2 default hr_api.g_varchar2,
995: p_ctr_information9 in varchar2 default hr_api.g_varchar2,
996: p_ctr_information10 in varchar2 default hr_api.g_varchar2,
997: p_ctr_information11 in varchar2 default hr_api.g_varchar2,
998: p_ctr_information12 in varchar2 default hr_api.g_varchar2,
999: p_ctr_information13 in varchar2 default hr_api.g_varchar2,
1000: p_ctr_information14 in varchar2 default hr_api.g_varchar2,
1001: p_ctr_information15 in varchar2 default hr_api.g_varchar2,
1002: p_ctr_information16 in varchar2 default hr_api.g_varchar2,
995: p_ctr_information9 in varchar2 default hr_api.g_varchar2,
996: p_ctr_information10 in varchar2 default hr_api.g_varchar2,
997: p_ctr_information11 in varchar2 default hr_api.g_varchar2,
998: p_ctr_information12 in varchar2 default hr_api.g_varchar2,
999: p_ctr_information13 in varchar2 default hr_api.g_varchar2,
1000: p_ctr_information14 in varchar2 default hr_api.g_varchar2,
1001: p_ctr_information15 in varchar2 default hr_api.g_varchar2,
1002: p_ctr_information16 in varchar2 default hr_api.g_varchar2,
1003: p_ctr_information17 in varchar2 default hr_api.g_varchar2,
996: p_ctr_information10 in varchar2 default hr_api.g_varchar2,
997: p_ctr_information11 in varchar2 default hr_api.g_varchar2,
998: p_ctr_information12 in varchar2 default hr_api.g_varchar2,
999: p_ctr_information13 in varchar2 default hr_api.g_varchar2,
1000: p_ctr_information14 in varchar2 default hr_api.g_varchar2,
1001: p_ctr_information15 in varchar2 default hr_api.g_varchar2,
1002: p_ctr_information16 in varchar2 default hr_api.g_varchar2,
1003: p_ctr_information17 in varchar2 default hr_api.g_varchar2,
1004: p_ctr_information18 in varchar2 default hr_api.g_varchar2,
997: p_ctr_information11 in varchar2 default hr_api.g_varchar2,
998: p_ctr_information12 in varchar2 default hr_api.g_varchar2,
999: p_ctr_information13 in varchar2 default hr_api.g_varchar2,
1000: p_ctr_information14 in varchar2 default hr_api.g_varchar2,
1001: p_ctr_information15 in varchar2 default hr_api.g_varchar2,
1002: p_ctr_information16 in varchar2 default hr_api.g_varchar2,
1003: p_ctr_information17 in varchar2 default hr_api.g_varchar2,
1004: p_ctr_information18 in varchar2 default hr_api.g_varchar2,
1005: p_ctr_information19 in varchar2 default hr_api.g_varchar2,
998: p_ctr_information12 in varchar2 default hr_api.g_varchar2,
999: p_ctr_information13 in varchar2 default hr_api.g_varchar2,
1000: p_ctr_information14 in varchar2 default hr_api.g_varchar2,
1001: p_ctr_information15 in varchar2 default hr_api.g_varchar2,
1002: p_ctr_information16 in varchar2 default hr_api.g_varchar2,
1003: p_ctr_information17 in varchar2 default hr_api.g_varchar2,
1004: p_ctr_information18 in varchar2 default hr_api.g_varchar2,
1005: p_ctr_information19 in varchar2 default hr_api.g_varchar2,
1006: p_ctr_information20 in varchar2 default hr_api.g_varchar2,
999: p_ctr_information13 in varchar2 default hr_api.g_varchar2,
1000: p_ctr_information14 in varchar2 default hr_api.g_varchar2,
1001: p_ctr_information15 in varchar2 default hr_api.g_varchar2,
1002: p_ctr_information16 in varchar2 default hr_api.g_varchar2,
1003: p_ctr_information17 in varchar2 default hr_api.g_varchar2,
1004: p_ctr_information18 in varchar2 default hr_api.g_varchar2,
1005: p_ctr_information19 in varchar2 default hr_api.g_varchar2,
1006: p_ctr_information20 in varchar2 default hr_api.g_varchar2,
1007: p_attribute_category in varchar2 default hr_api.g_varchar2,
1000: p_ctr_information14 in varchar2 default hr_api.g_varchar2,
1001: p_ctr_information15 in varchar2 default hr_api.g_varchar2,
1002: p_ctr_information16 in varchar2 default hr_api.g_varchar2,
1003: p_ctr_information17 in varchar2 default hr_api.g_varchar2,
1004: p_ctr_information18 in varchar2 default hr_api.g_varchar2,
1005: p_ctr_information19 in varchar2 default hr_api.g_varchar2,
1006: p_ctr_information20 in varchar2 default hr_api.g_varchar2,
1007: p_attribute_category in varchar2 default hr_api.g_varchar2,
1008: p_attribute1 in varchar2 default hr_api.g_varchar2,
1001: p_ctr_information15 in varchar2 default hr_api.g_varchar2,
1002: p_ctr_information16 in varchar2 default hr_api.g_varchar2,
1003: p_ctr_information17 in varchar2 default hr_api.g_varchar2,
1004: p_ctr_information18 in varchar2 default hr_api.g_varchar2,
1005: p_ctr_information19 in varchar2 default hr_api.g_varchar2,
1006: p_ctr_information20 in varchar2 default hr_api.g_varchar2,
1007: p_attribute_category in varchar2 default hr_api.g_varchar2,
1008: p_attribute1 in varchar2 default hr_api.g_varchar2,
1009: p_attribute2 in varchar2 default hr_api.g_varchar2,
1002: p_ctr_information16 in varchar2 default hr_api.g_varchar2,
1003: p_ctr_information17 in varchar2 default hr_api.g_varchar2,
1004: p_ctr_information18 in varchar2 default hr_api.g_varchar2,
1005: p_ctr_information19 in varchar2 default hr_api.g_varchar2,
1006: p_ctr_information20 in varchar2 default hr_api.g_varchar2,
1007: p_attribute_category in varchar2 default hr_api.g_varchar2,
1008: p_attribute1 in varchar2 default hr_api.g_varchar2,
1009: p_attribute2 in varchar2 default hr_api.g_varchar2,
1010: p_attribute3 in varchar2 default hr_api.g_varchar2,
1003: p_ctr_information17 in varchar2 default hr_api.g_varchar2,
1004: p_ctr_information18 in varchar2 default hr_api.g_varchar2,
1005: p_ctr_information19 in varchar2 default hr_api.g_varchar2,
1006: p_ctr_information20 in varchar2 default hr_api.g_varchar2,
1007: p_attribute_category in varchar2 default hr_api.g_varchar2,
1008: p_attribute1 in varchar2 default hr_api.g_varchar2,
1009: p_attribute2 in varchar2 default hr_api.g_varchar2,
1010: p_attribute3 in varchar2 default hr_api.g_varchar2,
1011: p_attribute4 in varchar2 default hr_api.g_varchar2,
1004: p_ctr_information18 in varchar2 default hr_api.g_varchar2,
1005: p_ctr_information19 in varchar2 default hr_api.g_varchar2,
1006: p_ctr_information20 in varchar2 default hr_api.g_varchar2,
1007: p_attribute_category in varchar2 default hr_api.g_varchar2,
1008: p_attribute1 in varchar2 default hr_api.g_varchar2,
1009: p_attribute2 in varchar2 default hr_api.g_varchar2,
1010: p_attribute3 in varchar2 default hr_api.g_varchar2,
1011: p_attribute4 in varchar2 default hr_api.g_varchar2,
1012: p_attribute5 in varchar2 default hr_api.g_varchar2,
1005: p_ctr_information19 in varchar2 default hr_api.g_varchar2,
1006: p_ctr_information20 in varchar2 default hr_api.g_varchar2,
1007: p_attribute_category in varchar2 default hr_api.g_varchar2,
1008: p_attribute1 in varchar2 default hr_api.g_varchar2,
1009: p_attribute2 in varchar2 default hr_api.g_varchar2,
1010: p_attribute3 in varchar2 default hr_api.g_varchar2,
1011: p_attribute4 in varchar2 default hr_api.g_varchar2,
1012: p_attribute5 in varchar2 default hr_api.g_varchar2,
1013: p_attribute6 in varchar2 default hr_api.g_varchar2,
1006: p_ctr_information20 in varchar2 default hr_api.g_varchar2,
1007: p_attribute_category in varchar2 default hr_api.g_varchar2,
1008: p_attribute1 in varchar2 default hr_api.g_varchar2,
1009: p_attribute2 in varchar2 default hr_api.g_varchar2,
1010: p_attribute3 in varchar2 default hr_api.g_varchar2,
1011: p_attribute4 in varchar2 default hr_api.g_varchar2,
1012: p_attribute5 in varchar2 default hr_api.g_varchar2,
1013: p_attribute6 in varchar2 default hr_api.g_varchar2,
1014: p_attribute7 in varchar2 default hr_api.g_varchar2,
1007: p_attribute_category in varchar2 default hr_api.g_varchar2,
1008: p_attribute1 in varchar2 default hr_api.g_varchar2,
1009: p_attribute2 in varchar2 default hr_api.g_varchar2,
1010: p_attribute3 in varchar2 default hr_api.g_varchar2,
1011: p_attribute4 in varchar2 default hr_api.g_varchar2,
1012: p_attribute5 in varchar2 default hr_api.g_varchar2,
1013: p_attribute6 in varchar2 default hr_api.g_varchar2,
1014: p_attribute7 in varchar2 default hr_api.g_varchar2,
1015: p_attribute8 in varchar2 default hr_api.g_varchar2,
1008: p_attribute1 in varchar2 default hr_api.g_varchar2,
1009: p_attribute2 in varchar2 default hr_api.g_varchar2,
1010: p_attribute3 in varchar2 default hr_api.g_varchar2,
1011: p_attribute4 in varchar2 default hr_api.g_varchar2,
1012: p_attribute5 in varchar2 default hr_api.g_varchar2,
1013: p_attribute6 in varchar2 default hr_api.g_varchar2,
1014: p_attribute7 in varchar2 default hr_api.g_varchar2,
1015: p_attribute8 in varchar2 default hr_api.g_varchar2,
1016: p_attribute9 in varchar2 default hr_api.g_varchar2,
1009: p_attribute2 in varchar2 default hr_api.g_varchar2,
1010: p_attribute3 in varchar2 default hr_api.g_varchar2,
1011: p_attribute4 in varchar2 default hr_api.g_varchar2,
1012: p_attribute5 in varchar2 default hr_api.g_varchar2,
1013: p_attribute6 in varchar2 default hr_api.g_varchar2,
1014: p_attribute7 in varchar2 default hr_api.g_varchar2,
1015: p_attribute8 in varchar2 default hr_api.g_varchar2,
1016: p_attribute9 in varchar2 default hr_api.g_varchar2,
1017: p_attribute10 in varchar2 default hr_api.g_varchar2,
1010: p_attribute3 in varchar2 default hr_api.g_varchar2,
1011: p_attribute4 in varchar2 default hr_api.g_varchar2,
1012: p_attribute5 in varchar2 default hr_api.g_varchar2,
1013: p_attribute6 in varchar2 default hr_api.g_varchar2,
1014: p_attribute7 in varchar2 default hr_api.g_varchar2,
1015: p_attribute8 in varchar2 default hr_api.g_varchar2,
1016: p_attribute9 in varchar2 default hr_api.g_varchar2,
1017: p_attribute10 in varchar2 default hr_api.g_varchar2,
1018: p_attribute11 in varchar2 default hr_api.g_varchar2,
1011: p_attribute4 in varchar2 default hr_api.g_varchar2,
1012: p_attribute5 in varchar2 default hr_api.g_varchar2,
1013: p_attribute6 in varchar2 default hr_api.g_varchar2,
1014: p_attribute7 in varchar2 default hr_api.g_varchar2,
1015: p_attribute8 in varchar2 default hr_api.g_varchar2,
1016: p_attribute9 in varchar2 default hr_api.g_varchar2,
1017: p_attribute10 in varchar2 default hr_api.g_varchar2,
1018: p_attribute11 in varchar2 default hr_api.g_varchar2,
1019: p_attribute12 in varchar2 default hr_api.g_varchar2,
1012: p_attribute5 in varchar2 default hr_api.g_varchar2,
1013: p_attribute6 in varchar2 default hr_api.g_varchar2,
1014: p_attribute7 in varchar2 default hr_api.g_varchar2,
1015: p_attribute8 in varchar2 default hr_api.g_varchar2,
1016: p_attribute9 in varchar2 default hr_api.g_varchar2,
1017: p_attribute10 in varchar2 default hr_api.g_varchar2,
1018: p_attribute11 in varchar2 default hr_api.g_varchar2,
1019: p_attribute12 in varchar2 default hr_api.g_varchar2,
1020: p_attribute13 in varchar2 default hr_api.g_varchar2,
1013: p_attribute6 in varchar2 default hr_api.g_varchar2,
1014: p_attribute7 in varchar2 default hr_api.g_varchar2,
1015: p_attribute8 in varchar2 default hr_api.g_varchar2,
1016: p_attribute9 in varchar2 default hr_api.g_varchar2,
1017: p_attribute10 in varchar2 default hr_api.g_varchar2,
1018: p_attribute11 in varchar2 default hr_api.g_varchar2,
1019: p_attribute12 in varchar2 default hr_api.g_varchar2,
1020: p_attribute13 in varchar2 default hr_api.g_varchar2,
1021: p_attribute14 in varchar2 default hr_api.g_varchar2,
1014: p_attribute7 in varchar2 default hr_api.g_varchar2,
1015: p_attribute8 in varchar2 default hr_api.g_varchar2,
1016: p_attribute9 in varchar2 default hr_api.g_varchar2,
1017: p_attribute10 in varchar2 default hr_api.g_varchar2,
1018: p_attribute11 in varchar2 default hr_api.g_varchar2,
1019: p_attribute12 in varchar2 default hr_api.g_varchar2,
1020: p_attribute13 in varchar2 default hr_api.g_varchar2,
1021: p_attribute14 in varchar2 default hr_api.g_varchar2,
1022: p_attribute15 in varchar2 default hr_api.g_varchar2,
1015: p_attribute8 in varchar2 default hr_api.g_varchar2,
1016: p_attribute9 in varchar2 default hr_api.g_varchar2,
1017: p_attribute10 in varchar2 default hr_api.g_varchar2,
1018: p_attribute11 in varchar2 default hr_api.g_varchar2,
1019: p_attribute12 in varchar2 default hr_api.g_varchar2,
1020: p_attribute13 in varchar2 default hr_api.g_varchar2,
1021: p_attribute14 in varchar2 default hr_api.g_varchar2,
1022: p_attribute15 in varchar2 default hr_api.g_varchar2,
1023: p_attribute16 in varchar2 default hr_api.g_varchar2,
1016: p_attribute9 in varchar2 default hr_api.g_varchar2,
1017: p_attribute10 in varchar2 default hr_api.g_varchar2,
1018: p_attribute11 in varchar2 default hr_api.g_varchar2,
1019: p_attribute12 in varchar2 default hr_api.g_varchar2,
1020: p_attribute13 in varchar2 default hr_api.g_varchar2,
1021: p_attribute14 in varchar2 default hr_api.g_varchar2,
1022: p_attribute15 in varchar2 default hr_api.g_varchar2,
1023: p_attribute16 in varchar2 default hr_api.g_varchar2,
1024: p_attribute17 in varchar2 default hr_api.g_varchar2,
1017: p_attribute10 in varchar2 default hr_api.g_varchar2,
1018: p_attribute11 in varchar2 default hr_api.g_varchar2,
1019: p_attribute12 in varchar2 default hr_api.g_varchar2,
1020: p_attribute13 in varchar2 default hr_api.g_varchar2,
1021: p_attribute14 in varchar2 default hr_api.g_varchar2,
1022: p_attribute15 in varchar2 default hr_api.g_varchar2,
1023: p_attribute16 in varchar2 default hr_api.g_varchar2,
1024: p_attribute17 in varchar2 default hr_api.g_varchar2,
1025: p_attribute18 in varchar2 default hr_api.g_varchar2,
1018: p_attribute11 in varchar2 default hr_api.g_varchar2,
1019: p_attribute12 in varchar2 default hr_api.g_varchar2,
1020: p_attribute13 in varchar2 default hr_api.g_varchar2,
1021: p_attribute14 in varchar2 default hr_api.g_varchar2,
1022: p_attribute15 in varchar2 default hr_api.g_varchar2,
1023: p_attribute16 in varchar2 default hr_api.g_varchar2,
1024: p_attribute17 in varchar2 default hr_api.g_varchar2,
1025: p_attribute18 in varchar2 default hr_api.g_varchar2,
1026: p_attribute19 in varchar2 default hr_api.g_varchar2,
1019: p_attribute12 in varchar2 default hr_api.g_varchar2,
1020: p_attribute13 in varchar2 default hr_api.g_varchar2,
1021: p_attribute14 in varchar2 default hr_api.g_varchar2,
1022: p_attribute15 in varchar2 default hr_api.g_varchar2,
1023: p_attribute16 in varchar2 default hr_api.g_varchar2,
1024: p_attribute17 in varchar2 default hr_api.g_varchar2,
1025: p_attribute18 in varchar2 default hr_api.g_varchar2,
1026: p_attribute19 in varchar2 default hr_api.g_varchar2,
1027: p_attribute20 in varchar2 default hr_api.g_varchar2,
1020: p_attribute13 in varchar2 default hr_api.g_varchar2,
1021: p_attribute14 in varchar2 default hr_api.g_varchar2,
1022: p_attribute15 in varchar2 default hr_api.g_varchar2,
1023: p_attribute16 in varchar2 default hr_api.g_varchar2,
1024: p_attribute17 in varchar2 default hr_api.g_varchar2,
1025: p_attribute18 in varchar2 default hr_api.g_varchar2,
1026: p_attribute19 in varchar2 default hr_api.g_varchar2,
1027: p_attribute20 in varchar2 default hr_api.g_varchar2,
1028: p_effective_date in date,
1021: p_attribute14 in varchar2 default hr_api.g_varchar2,
1022: p_attribute15 in varchar2 default hr_api.g_varchar2,
1023: p_attribute16 in varchar2 default hr_api.g_varchar2,
1024: p_attribute17 in varchar2 default hr_api.g_varchar2,
1025: p_attribute18 in varchar2 default hr_api.g_varchar2,
1026: p_attribute19 in varchar2 default hr_api.g_varchar2,
1027: p_attribute20 in varchar2 default hr_api.g_varchar2,
1028: p_effective_date in date,
1029: p_datetrack_mode in varchar2
1022: p_attribute15 in varchar2 default hr_api.g_varchar2,
1023: p_attribute16 in varchar2 default hr_api.g_varchar2,
1024: p_attribute17 in varchar2 default hr_api.g_varchar2,
1025: p_attribute18 in varchar2 default hr_api.g_varchar2,
1026: p_attribute19 in varchar2 default hr_api.g_varchar2,
1027: p_attribute20 in varchar2 default hr_api.g_varchar2,
1028: p_effective_date in date,
1029: p_datetrack_mode in varchar2
1030: ) is
1023: p_attribute16 in varchar2 default hr_api.g_varchar2,
1024: p_attribute17 in varchar2 default hr_api.g_varchar2,
1025: p_attribute18 in varchar2 default hr_api.g_varchar2,
1026: p_attribute19 in varchar2 default hr_api.g_varchar2,
1027: p_attribute20 in varchar2 default hr_api.g_varchar2,
1028: p_effective_date in date,
1029: p_datetrack_mode in varchar2
1030: ) is
1031: --
1043: (
1044: p_contract_id,
1045: null,
1046: null,
1047: hr_api.g_number,
1048: p_object_version_number,
1049: hr_api.g_number,
1050: p_reference,
1051: p_type,
1045: null,
1046: null,
1047: hr_api.g_number,
1048: p_object_version_number,
1049: hr_api.g_number,
1050: p_reference,
1051: p_type,
1052: p_status,
1053: p_status_reason,
1141: begin
1142: --
1143: hr_utility.set_location('Entering:'||l_proc, 5);
1144: --
1145: hr_api.mandatory_arg_error
1146: (p_api_name => l_proc,
1147: p_argument => 'contract_id',
1148: p_argument_value => p_contract_id);
1149: --
1146: (p_api_name => l_proc,
1147: p_argument => 'contract_id',
1148: p_argument_value => p_contract_id);
1149: --
1150: hr_api.mandatory_arg_error
1151: (p_api_name => l_proc,
1152: p_argument => 'p_effective_date',
1153: p_argument_value => p_effective_date);
1154: --
1151: (p_api_name => l_proc,
1152: p_argument => 'p_effective_date',
1153: p_argument_value => p_effective_date);
1154: --
1155: hr_api.mandatory_arg_error
1156: (p_api_name => l_proc,
1157: p_argument => 'p_new_start_date',
1158: p_argument_value => p_new_start_date);
1159: --
1156: (p_api_name => l_proc,
1157: p_argument => 'p_new_start_date',
1158: p_argument_value => p_new_start_date);
1159: --
1160: hr_api.mandatory_arg_error
1161: (p_api_name => l_proc,
1162: p_argument => 'object_version_number',
1163: p_argument_value => p_object_version_number);
1164: --