APPS.PER_REI_UPD dependencies on HR_API

Line 70: If (p_datetrack_mode = hr_api.g_correction) then

66: --
67: Begin
68: hr_utility.set_location('Entering:'||l_proc, 5);
69: --
70: If (p_datetrack_mode = hr_api.g_correction) then
71: hr_utility.set_location(l_proc, 10);
72: --
73: -- Because we are updating a row we must get the next object
74: -- version number.

Line 163: When hr_api.check_integrity_violated Then

159: End If;
160: --
161: hr_utility.set_location(' Leaving:'||l_proc, 15);
162: Exception
163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated
165: per_rei_shd.g_api_dml := false; -- Unset the api dml status
166: per_rei_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

163: When hr_api.check_integrity_violated Then
164: -- A check constraint has been violated
165: per_rei_shd.g_api_dml := false; -- Unset the api dml status
166: per_rei_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: per_rei_shd.g_api_dml := false; -- Unset the api dml status
171: per_rei_shd.constraint_error

Line 168: When hr_api.unique_integrity_violated Then

164: -- A check constraint has been violated
165: per_rei_shd.g_api_dml := false; -- Unset the api dml status
166: per_rei_shd.constraint_error
167: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: per_rei_shd.g_api_dml := false; -- Unset the api dml status
171: per_rei_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

Line 172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));

168: When hr_api.unique_integrity_violated Then
169: -- Unique integrity has been violated
170: per_rei_shd.g_api_dml := false; -- Unset the api dml status
171: per_rei_shd.constraint_error
172: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
173: When Others Then
174: per_rei_shd.g_api_dml := false; -- Unset the api dml status
175: Raise;
176: End dt_update_dml;

Line 289: If (p_datetrack_mode <> hr_api.g_correction) then

285: l_dummy_version_number number;
286: --
287: Begin
288: hr_utility.set_location('Entering:'||l_proc, 5);
289: If (p_datetrack_mode <> hr_api.g_correction) then
290: --
291: -- Update the current effective end date
292: --
293: per_rei_shd.upd_effective_end_date

Line 302: If (p_datetrack_mode = hr_api.g_update_override) then

298: ,p_validation_end_date => p_validation_end_date
299: ,p_object_version_number => l_dummy_version_number
300: );
301: --
302: If (p_datetrack_mode = hr_api.g_update_override) then
303: --
304: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
305: -- delete any future rows
306: --

Line 692: when hr_api.cannot_find_prog_unit then

688: );
689: --
690: exception
691: --
692: when hr_api.cannot_find_prog_unit then
693: --
694: hr_api.cannot_find_prog_unit_error
695: (p_module_name => 'PER_CONTACT_EXTRA_INFO_F'
696: ,p_hook_type => 'AU');

Line 694: hr_api.cannot_find_prog_unit_error

690: exception
691: --
692: when hr_api.cannot_find_prog_unit then
693: --
694: hr_api.cannot_find_prog_unit_error
695: (p_module_name => 'PER_CONTACT_EXTRA_INFO_F'
696: ,p_hook_type => 'AU');
697: --
698: end;

Line 757: If (p_rec.contact_relationship_id = hr_api.g_number) then

753: -- p_rec plsql record structure
754: -- to see if a system default is being used. If a system default
755: -- is being used then we must set to the 'current' argument value.
756: --
757: If (p_rec.contact_relationship_id = hr_api.g_number) then
758: p_rec.contact_relationship_id :=
759: per_rei_shd.g_old_rec.contact_relationship_id;
760: End If;
761: If (p_rec.information_type = hr_api.g_varchar2) then

Line 761: If (p_rec.information_type = hr_api.g_varchar2) then

757: If (p_rec.contact_relationship_id = hr_api.g_number) then
758: p_rec.contact_relationship_id :=
759: per_rei_shd.g_old_rec.contact_relationship_id;
760: End If;
761: If (p_rec.information_type = hr_api.g_varchar2) then
762: p_rec.information_type :=
763: per_rei_shd.g_old_rec.information_type;
764: End If;
765: If (p_rec.cei_information_category = hr_api.g_varchar2) then

Line 765: If (p_rec.cei_information_category = hr_api.g_varchar2) then

761: If (p_rec.information_type = hr_api.g_varchar2) then
762: p_rec.information_type :=
763: per_rei_shd.g_old_rec.information_type;
764: End If;
765: If (p_rec.cei_information_category = hr_api.g_varchar2) then
766: p_rec.cei_information_category :=
767: per_rei_shd.g_old_rec.cei_information_category;
768: End If;
769: If (p_rec.cei_information1 = hr_api.g_varchar2) then

Line 769: If (p_rec.cei_information1 = hr_api.g_varchar2) then

765: If (p_rec.cei_information_category = hr_api.g_varchar2) then
766: p_rec.cei_information_category :=
767: per_rei_shd.g_old_rec.cei_information_category;
768: End If;
769: If (p_rec.cei_information1 = hr_api.g_varchar2) then
770: p_rec.cei_information1 :=
771: per_rei_shd.g_old_rec.cei_information1;
772: End If;
773: If (p_rec.cei_information2 = hr_api.g_varchar2) then

Line 773: If (p_rec.cei_information2 = hr_api.g_varchar2) then

769: If (p_rec.cei_information1 = hr_api.g_varchar2) then
770: p_rec.cei_information1 :=
771: per_rei_shd.g_old_rec.cei_information1;
772: End If;
773: If (p_rec.cei_information2 = hr_api.g_varchar2) then
774: p_rec.cei_information2 :=
775: per_rei_shd.g_old_rec.cei_information2;
776: End If;
777: If (p_rec.cei_information3 = hr_api.g_varchar2) then

Line 777: If (p_rec.cei_information3 = hr_api.g_varchar2) then

773: If (p_rec.cei_information2 = hr_api.g_varchar2) then
774: p_rec.cei_information2 :=
775: per_rei_shd.g_old_rec.cei_information2;
776: End If;
777: If (p_rec.cei_information3 = hr_api.g_varchar2) then
778: p_rec.cei_information3 :=
779: per_rei_shd.g_old_rec.cei_information3;
780: End If;
781: If (p_rec.cei_information4 = hr_api.g_varchar2) then

Line 781: If (p_rec.cei_information4 = hr_api.g_varchar2) then

777: If (p_rec.cei_information3 = hr_api.g_varchar2) then
778: p_rec.cei_information3 :=
779: per_rei_shd.g_old_rec.cei_information3;
780: End If;
781: If (p_rec.cei_information4 = hr_api.g_varchar2) then
782: p_rec.cei_information4 :=
783: per_rei_shd.g_old_rec.cei_information4;
784: End If;
785: If (p_rec.cei_information5 = hr_api.g_varchar2) then

Line 785: If (p_rec.cei_information5 = hr_api.g_varchar2) then

781: If (p_rec.cei_information4 = hr_api.g_varchar2) then
782: p_rec.cei_information4 :=
783: per_rei_shd.g_old_rec.cei_information4;
784: End If;
785: If (p_rec.cei_information5 = hr_api.g_varchar2) then
786: p_rec.cei_information5 :=
787: per_rei_shd.g_old_rec.cei_information5;
788: End If;
789: If (p_rec.cei_information6 = hr_api.g_varchar2) then

Line 789: If (p_rec.cei_information6 = hr_api.g_varchar2) then

785: If (p_rec.cei_information5 = hr_api.g_varchar2) then
786: p_rec.cei_information5 :=
787: per_rei_shd.g_old_rec.cei_information5;
788: End If;
789: If (p_rec.cei_information6 = hr_api.g_varchar2) then
790: p_rec.cei_information6 :=
791: per_rei_shd.g_old_rec.cei_information6;
792: End If;
793: If (p_rec.cei_information7 = hr_api.g_varchar2) then

Line 793: If (p_rec.cei_information7 = hr_api.g_varchar2) then

789: If (p_rec.cei_information6 = hr_api.g_varchar2) then
790: p_rec.cei_information6 :=
791: per_rei_shd.g_old_rec.cei_information6;
792: End If;
793: If (p_rec.cei_information7 = hr_api.g_varchar2) then
794: p_rec.cei_information7 :=
795: per_rei_shd.g_old_rec.cei_information7;
796: End If;
797: If (p_rec.cei_information8 = hr_api.g_varchar2) then

Line 797: If (p_rec.cei_information8 = hr_api.g_varchar2) then

793: If (p_rec.cei_information7 = hr_api.g_varchar2) then
794: p_rec.cei_information7 :=
795: per_rei_shd.g_old_rec.cei_information7;
796: End If;
797: If (p_rec.cei_information8 = hr_api.g_varchar2) then
798: p_rec.cei_information8 :=
799: per_rei_shd.g_old_rec.cei_information8;
800: End If;
801: If (p_rec.cei_information9 = hr_api.g_varchar2) then

Line 801: If (p_rec.cei_information9 = hr_api.g_varchar2) then

797: If (p_rec.cei_information8 = hr_api.g_varchar2) then
798: p_rec.cei_information8 :=
799: per_rei_shd.g_old_rec.cei_information8;
800: End If;
801: If (p_rec.cei_information9 = hr_api.g_varchar2) then
802: p_rec.cei_information9 :=
803: per_rei_shd.g_old_rec.cei_information9;
804: End If;
805: If (p_rec.cei_information10 = hr_api.g_varchar2) then

Line 805: If (p_rec.cei_information10 = hr_api.g_varchar2) then

801: If (p_rec.cei_information9 = hr_api.g_varchar2) then
802: p_rec.cei_information9 :=
803: per_rei_shd.g_old_rec.cei_information9;
804: End If;
805: If (p_rec.cei_information10 = hr_api.g_varchar2) then
806: p_rec.cei_information10 :=
807: per_rei_shd.g_old_rec.cei_information10;
808: End If;
809: If (p_rec.cei_information11 = hr_api.g_varchar2) then

Line 809: If (p_rec.cei_information11 = hr_api.g_varchar2) then

805: If (p_rec.cei_information10 = hr_api.g_varchar2) then
806: p_rec.cei_information10 :=
807: per_rei_shd.g_old_rec.cei_information10;
808: End If;
809: If (p_rec.cei_information11 = hr_api.g_varchar2) then
810: p_rec.cei_information11 :=
811: per_rei_shd.g_old_rec.cei_information11;
812: End If;
813: If (p_rec.cei_information12 = hr_api.g_varchar2) then

Line 813: If (p_rec.cei_information12 = hr_api.g_varchar2) then

809: If (p_rec.cei_information11 = hr_api.g_varchar2) then
810: p_rec.cei_information11 :=
811: per_rei_shd.g_old_rec.cei_information11;
812: End If;
813: If (p_rec.cei_information12 = hr_api.g_varchar2) then
814: p_rec.cei_information12 :=
815: per_rei_shd.g_old_rec.cei_information12;
816: End If;
817: If (p_rec.cei_information13 = hr_api.g_varchar2) then

Line 817: If (p_rec.cei_information13 = hr_api.g_varchar2) then

813: If (p_rec.cei_information12 = hr_api.g_varchar2) then
814: p_rec.cei_information12 :=
815: per_rei_shd.g_old_rec.cei_information12;
816: End If;
817: If (p_rec.cei_information13 = hr_api.g_varchar2) then
818: p_rec.cei_information13 :=
819: per_rei_shd.g_old_rec.cei_information13;
820: End If;
821: If (p_rec.cei_information14 = hr_api.g_varchar2) then

Line 821: If (p_rec.cei_information14 = hr_api.g_varchar2) then

817: If (p_rec.cei_information13 = hr_api.g_varchar2) then
818: p_rec.cei_information13 :=
819: per_rei_shd.g_old_rec.cei_information13;
820: End If;
821: If (p_rec.cei_information14 = hr_api.g_varchar2) then
822: p_rec.cei_information14 :=
823: per_rei_shd.g_old_rec.cei_information14;
824: End If;
825: If (p_rec.cei_information15 = hr_api.g_varchar2) then

Line 825: If (p_rec.cei_information15 = hr_api.g_varchar2) then

821: If (p_rec.cei_information14 = hr_api.g_varchar2) then
822: p_rec.cei_information14 :=
823: per_rei_shd.g_old_rec.cei_information14;
824: End If;
825: If (p_rec.cei_information15 = hr_api.g_varchar2) then
826: p_rec.cei_information15 :=
827: per_rei_shd.g_old_rec.cei_information15;
828: End If;
829: If (p_rec.cei_information16 = hr_api.g_varchar2) then

Line 829: If (p_rec.cei_information16 = hr_api.g_varchar2) then

825: If (p_rec.cei_information15 = hr_api.g_varchar2) then
826: p_rec.cei_information15 :=
827: per_rei_shd.g_old_rec.cei_information15;
828: End If;
829: If (p_rec.cei_information16 = hr_api.g_varchar2) then
830: p_rec.cei_information16 :=
831: per_rei_shd.g_old_rec.cei_information16;
832: End If;
833: If (p_rec.cei_information17 = hr_api.g_varchar2) then

Line 833: If (p_rec.cei_information17 = hr_api.g_varchar2) then

829: If (p_rec.cei_information16 = hr_api.g_varchar2) then
830: p_rec.cei_information16 :=
831: per_rei_shd.g_old_rec.cei_information16;
832: End If;
833: If (p_rec.cei_information17 = hr_api.g_varchar2) then
834: p_rec.cei_information17 :=
835: per_rei_shd.g_old_rec.cei_information17;
836: End If;
837: If (p_rec.cei_information18 = hr_api.g_varchar2) then

Line 837: If (p_rec.cei_information18 = hr_api.g_varchar2) then

833: If (p_rec.cei_information17 = hr_api.g_varchar2) then
834: p_rec.cei_information17 :=
835: per_rei_shd.g_old_rec.cei_information17;
836: End If;
837: If (p_rec.cei_information18 = hr_api.g_varchar2) then
838: p_rec.cei_information18 :=
839: per_rei_shd.g_old_rec.cei_information18;
840: End If;
841: If (p_rec.cei_information19 = hr_api.g_varchar2) then

Line 841: If (p_rec.cei_information19 = hr_api.g_varchar2) then

837: If (p_rec.cei_information18 = hr_api.g_varchar2) then
838: p_rec.cei_information18 :=
839: per_rei_shd.g_old_rec.cei_information18;
840: End If;
841: If (p_rec.cei_information19 = hr_api.g_varchar2) then
842: p_rec.cei_information19 :=
843: per_rei_shd.g_old_rec.cei_information19;
844: End If;
845: If (p_rec.cei_information20 = hr_api.g_varchar2) then

Line 845: If (p_rec.cei_information20 = hr_api.g_varchar2) then

841: If (p_rec.cei_information19 = hr_api.g_varchar2) then
842: p_rec.cei_information19 :=
843: per_rei_shd.g_old_rec.cei_information19;
844: End If;
845: If (p_rec.cei_information20 = hr_api.g_varchar2) then
846: p_rec.cei_information20 :=
847: per_rei_shd.g_old_rec.cei_information20;
848: End If;
849: If (p_rec.cei_information21 = hr_api.g_varchar2) then

Line 849: If (p_rec.cei_information21 = hr_api.g_varchar2) then

845: If (p_rec.cei_information20 = hr_api.g_varchar2) then
846: p_rec.cei_information20 :=
847: per_rei_shd.g_old_rec.cei_information20;
848: End If;
849: If (p_rec.cei_information21 = hr_api.g_varchar2) then
850: p_rec.cei_information21 :=
851: per_rei_shd.g_old_rec.cei_information21;
852: End If;
853: If (p_rec.cei_information22 = hr_api.g_varchar2) then

Line 853: If (p_rec.cei_information22 = hr_api.g_varchar2) then

849: If (p_rec.cei_information21 = hr_api.g_varchar2) then
850: p_rec.cei_information21 :=
851: per_rei_shd.g_old_rec.cei_information21;
852: End If;
853: If (p_rec.cei_information22 = hr_api.g_varchar2) then
854: p_rec.cei_information22 :=
855: per_rei_shd.g_old_rec.cei_information22;
856: End If;
857: If (p_rec.cei_information23 = hr_api.g_varchar2) then

Line 857: If (p_rec.cei_information23 = hr_api.g_varchar2) then

853: If (p_rec.cei_information22 = hr_api.g_varchar2) then
854: p_rec.cei_information22 :=
855: per_rei_shd.g_old_rec.cei_information22;
856: End If;
857: If (p_rec.cei_information23 = hr_api.g_varchar2) then
858: p_rec.cei_information23 :=
859: per_rei_shd.g_old_rec.cei_information23;
860: End If;
861: If (p_rec.cei_information24 = hr_api.g_varchar2) then

Line 861: If (p_rec.cei_information24 = hr_api.g_varchar2) then

857: If (p_rec.cei_information23 = hr_api.g_varchar2) then
858: p_rec.cei_information23 :=
859: per_rei_shd.g_old_rec.cei_information23;
860: End If;
861: If (p_rec.cei_information24 = hr_api.g_varchar2) then
862: p_rec.cei_information24 :=
863: per_rei_shd.g_old_rec.cei_information24;
864: End If;
865: If (p_rec.cei_information25 = hr_api.g_varchar2) then

Line 865: If (p_rec.cei_information25 = hr_api.g_varchar2) then

861: If (p_rec.cei_information24 = hr_api.g_varchar2) then
862: p_rec.cei_information24 :=
863: per_rei_shd.g_old_rec.cei_information24;
864: End If;
865: If (p_rec.cei_information25 = hr_api.g_varchar2) then
866: p_rec.cei_information25 :=
867: per_rei_shd.g_old_rec.cei_information25;
868: End If;
869: If (p_rec.cei_information26 = hr_api.g_varchar2) then

Line 869: If (p_rec.cei_information26 = hr_api.g_varchar2) then

865: If (p_rec.cei_information25 = hr_api.g_varchar2) then
866: p_rec.cei_information25 :=
867: per_rei_shd.g_old_rec.cei_information25;
868: End If;
869: If (p_rec.cei_information26 = hr_api.g_varchar2) then
870: p_rec.cei_information26 :=
871: per_rei_shd.g_old_rec.cei_information26;
872: End If;
873: If (p_rec.cei_information27 = hr_api.g_varchar2) then

Line 873: If (p_rec.cei_information27 = hr_api.g_varchar2) then

869: If (p_rec.cei_information26 = hr_api.g_varchar2) then
870: p_rec.cei_information26 :=
871: per_rei_shd.g_old_rec.cei_information26;
872: End If;
873: If (p_rec.cei_information27 = hr_api.g_varchar2) then
874: p_rec.cei_information27 :=
875: per_rei_shd.g_old_rec.cei_information27;
876: End If;
877: If (p_rec.cei_information28 = hr_api.g_varchar2) then

Line 877: If (p_rec.cei_information28 = hr_api.g_varchar2) then

873: If (p_rec.cei_information27 = hr_api.g_varchar2) then
874: p_rec.cei_information27 :=
875: per_rei_shd.g_old_rec.cei_information27;
876: End If;
877: If (p_rec.cei_information28 = hr_api.g_varchar2) then
878: p_rec.cei_information28 :=
879: per_rei_shd.g_old_rec.cei_information28;
880: End If;
881: If (p_rec.cei_information29 = hr_api.g_varchar2) then

Line 881: If (p_rec.cei_information29 = hr_api.g_varchar2) then

877: If (p_rec.cei_information28 = hr_api.g_varchar2) then
878: p_rec.cei_information28 :=
879: per_rei_shd.g_old_rec.cei_information28;
880: End If;
881: If (p_rec.cei_information29 = hr_api.g_varchar2) then
882: p_rec.cei_information29 :=
883: per_rei_shd.g_old_rec.cei_information29;
884: End If;
885: If (p_rec.cei_information30 = hr_api.g_varchar2) then

Line 885: If (p_rec.cei_information30 = hr_api.g_varchar2) then

881: If (p_rec.cei_information29 = hr_api.g_varchar2) then
882: p_rec.cei_information29 :=
883: per_rei_shd.g_old_rec.cei_information29;
884: End If;
885: If (p_rec.cei_information30 = hr_api.g_varchar2) then
886: p_rec.cei_information30 :=
887: per_rei_shd.g_old_rec.cei_information30;
888: End If;
889: If (p_rec.cei_attribute_category = hr_api.g_varchar2) then

Line 889: If (p_rec.cei_attribute_category = hr_api.g_varchar2) then

885: If (p_rec.cei_information30 = hr_api.g_varchar2) then
886: p_rec.cei_information30 :=
887: per_rei_shd.g_old_rec.cei_information30;
888: End If;
889: If (p_rec.cei_attribute_category = hr_api.g_varchar2) then
890: p_rec.cei_attribute_category :=
891: per_rei_shd.g_old_rec.cei_attribute_category;
892: End If;
893: If (p_rec.cei_attribute1 = hr_api.g_varchar2) then

Line 893: If (p_rec.cei_attribute1 = hr_api.g_varchar2) then

889: If (p_rec.cei_attribute_category = hr_api.g_varchar2) then
890: p_rec.cei_attribute_category :=
891: per_rei_shd.g_old_rec.cei_attribute_category;
892: End If;
893: If (p_rec.cei_attribute1 = hr_api.g_varchar2) then
894: p_rec.cei_attribute1 :=
895: per_rei_shd.g_old_rec.cei_attribute1;
896: End If;
897: If (p_rec.cei_attribute2 = hr_api.g_varchar2) then

Line 897: If (p_rec.cei_attribute2 = hr_api.g_varchar2) then

893: If (p_rec.cei_attribute1 = hr_api.g_varchar2) then
894: p_rec.cei_attribute1 :=
895: per_rei_shd.g_old_rec.cei_attribute1;
896: End If;
897: If (p_rec.cei_attribute2 = hr_api.g_varchar2) then
898: p_rec.cei_attribute2 :=
899: per_rei_shd.g_old_rec.cei_attribute2;
900: End If;
901: If (p_rec.cei_attribute3 = hr_api.g_varchar2) then

Line 901: If (p_rec.cei_attribute3 = hr_api.g_varchar2) then

897: If (p_rec.cei_attribute2 = hr_api.g_varchar2) then
898: p_rec.cei_attribute2 :=
899: per_rei_shd.g_old_rec.cei_attribute2;
900: End If;
901: If (p_rec.cei_attribute3 = hr_api.g_varchar2) then
902: p_rec.cei_attribute3 :=
903: per_rei_shd.g_old_rec.cei_attribute3;
904: End If;
905: If (p_rec.cei_attribute4 = hr_api.g_varchar2) then

Line 905: If (p_rec.cei_attribute4 = hr_api.g_varchar2) then

901: If (p_rec.cei_attribute3 = hr_api.g_varchar2) then
902: p_rec.cei_attribute3 :=
903: per_rei_shd.g_old_rec.cei_attribute3;
904: End If;
905: If (p_rec.cei_attribute4 = hr_api.g_varchar2) then
906: p_rec.cei_attribute4 :=
907: per_rei_shd.g_old_rec.cei_attribute4;
908: End If;
909: If (p_rec.cei_attribute5 = hr_api.g_varchar2) then

Line 909: If (p_rec.cei_attribute5 = hr_api.g_varchar2) then

905: If (p_rec.cei_attribute4 = hr_api.g_varchar2) then
906: p_rec.cei_attribute4 :=
907: per_rei_shd.g_old_rec.cei_attribute4;
908: End If;
909: If (p_rec.cei_attribute5 = hr_api.g_varchar2) then
910: p_rec.cei_attribute5 :=
911: per_rei_shd.g_old_rec.cei_attribute5;
912: End If;
913: If (p_rec.cei_attribute6 = hr_api.g_varchar2) then

Line 913: If (p_rec.cei_attribute6 = hr_api.g_varchar2) then

909: If (p_rec.cei_attribute5 = hr_api.g_varchar2) then
910: p_rec.cei_attribute5 :=
911: per_rei_shd.g_old_rec.cei_attribute5;
912: End If;
913: If (p_rec.cei_attribute6 = hr_api.g_varchar2) then
914: p_rec.cei_attribute6 :=
915: per_rei_shd.g_old_rec.cei_attribute6;
916: End If;
917: If (p_rec.cei_attribute7 = hr_api.g_varchar2) then

Line 917: If (p_rec.cei_attribute7 = hr_api.g_varchar2) then

913: If (p_rec.cei_attribute6 = hr_api.g_varchar2) then
914: p_rec.cei_attribute6 :=
915: per_rei_shd.g_old_rec.cei_attribute6;
916: End If;
917: If (p_rec.cei_attribute7 = hr_api.g_varchar2) then
918: p_rec.cei_attribute7 :=
919: per_rei_shd.g_old_rec.cei_attribute7;
920: End If;
921: If (p_rec.cei_attribute8 = hr_api.g_varchar2) then

Line 921: If (p_rec.cei_attribute8 = hr_api.g_varchar2) then

917: If (p_rec.cei_attribute7 = hr_api.g_varchar2) then
918: p_rec.cei_attribute7 :=
919: per_rei_shd.g_old_rec.cei_attribute7;
920: End If;
921: If (p_rec.cei_attribute8 = hr_api.g_varchar2) then
922: p_rec.cei_attribute8 :=
923: per_rei_shd.g_old_rec.cei_attribute8;
924: End If;
925: If (p_rec.cei_attribute9 = hr_api.g_varchar2) then

Line 925: If (p_rec.cei_attribute9 = hr_api.g_varchar2) then

921: If (p_rec.cei_attribute8 = hr_api.g_varchar2) then
922: p_rec.cei_attribute8 :=
923: per_rei_shd.g_old_rec.cei_attribute8;
924: End If;
925: If (p_rec.cei_attribute9 = hr_api.g_varchar2) then
926: p_rec.cei_attribute9 :=
927: per_rei_shd.g_old_rec.cei_attribute9;
928: End If;
929: If (p_rec.cei_attribute10 = hr_api.g_varchar2) then

Line 929: If (p_rec.cei_attribute10 = hr_api.g_varchar2) then

925: If (p_rec.cei_attribute9 = hr_api.g_varchar2) then
926: p_rec.cei_attribute9 :=
927: per_rei_shd.g_old_rec.cei_attribute9;
928: End If;
929: If (p_rec.cei_attribute10 = hr_api.g_varchar2) then
930: p_rec.cei_attribute10 :=
931: per_rei_shd.g_old_rec.cei_attribute10;
932: End If;
933: If (p_rec.cei_attribute11 = hr_api.g_varchar2) then

Line 933: If (p_rec.cei_attribute11 = hr_api.g_varchar2) then

929: If (p_rec.cei_attribute10 = hr_api.g_varchar2) then
930: p_rec.cei_attribute10 :=
931: per_rei_shd.g_old_rec.cei_attribute10;
932: End If;
933: If (p_rec.cei_attribute11 = hr_api.g_varchar2) then
934: p_rec.cei_attribute11 :=
935: per_rei_shd.g_old_rec.cei_attribute11;
936: End If;
937: If (p_rec.cei_attribute12 = hr_api.g_varchar2) then

Line 937: If (p_rec.cei_attribute12 = hr_api.g_varchar2) then

933: If (p_rec.cei_attribute11 = hr_api.g_varchar2) then
934: p_rec.cei_attribute11 :=
935: per_rei_shd.g_old_rec.cei_attribute11;
936: End If;
937: If (p_rec.cei_attribute12 = hr_api.g_varchar2) then
938: p_rec.cei_attribute12 :=
939: per_rei_shd.g_old_rec.cei_attribute12;
940: End If;
941: If (p_rec.cei_attribute13 = hr_api.g_varchar2) then

Line 941: If (p_rec.cei_attribute13 = hr_api.g_varchar2) then

937: If (p_rec.cei_attribute12 = hr_api.g_varchar2) then
938: p_rec.cei_attribute12 :=
939: per_rei_shd.g_old_rec.cei_attribute12;
940: End If;
941: If (p_rec.cei_attribute13 = hr_api.g_varchar2) then
942: p_rec.cei_attribute13 :=
943: per_rei_shd.g_old_rec.cei_attribute13;
944: End If;
945: If (p_rec.cei_attribute14 = hr_api.g_varchar2) then

Line 945: If (p_rec.cei_attribute14 = hr_api.g_varchar2) then

941: If (p_rec.cei_attribute13 = hr_api.g_varchar2) then
942: p_rec.cei_attribute13 :=
943: per_rei_shd.g_old_rec.cei_attribute13;
944: End If;
945: If (p_rec.cei_attribute14 = hr_api.g_varchar2) then
946: p_rec.cei_attribute14 :=
947: per_rei_shd.g_old_rec.cei_attribute14;
948: End If;
949: If (p_rec.cei_attribute15 = hr_api.g_varchar2) then

Line 949: If (p_rec.cei_attribute15 = hr_api.g_varchar2) then

945: If (p_rec.cei_attribute14 = hr_api.g_varchar2) then
946: p_rec.cei_attribute14 :=
947: per_rei_shd.g_old_rec.cei_attribute14;
948: End If;
949: If (p_rec.cei_attribute15 = hr_api.g_varchar2) then
950: p_rec.cei_attribute15 :=
951: per_rei_shd.g_old_rec.cei_attribute15;
952: End If;
953: If (p_rec.cei_attribute16 = hr_api.g_varchar2) then

Line 953: If (p_rec.cei_attribute16 = hr_api.g_varchar2) then

949: If (p_rec.cei_attribute15 = hr_api.g_varchar2) then
950: p_rec.cei_attribute15 :=
951: per_rei_shd.g_old_rec.cei_attribute15;
952: End If;
953: If (p_rec.cei_attribute16 = hr_api.g_varchar2) then
954: p_rec.cei_attribute16 :=
955: per_rei_shd.g_old_rec.cei_attribute16;
956: End If;
957: If (p_rec.cei_attribute17 = hr_api.g_varchar2) then

Line 957: If (p_rec.cei_attribute17 = hr_api.g_varchar2) then

953: If (p_rec.cei_attribute16 = hr_api.g_varchar2) then
954: p_rec.cei_attribute16 :=
955: per_rei_shd.g_old_rec.cei_attribute16;
956: End If;
957: If (p_rec.cei_attribute17 = hr_api.g_varchar2) then
958: p_rec.cei_attribute17 :=
959: per_rei_shd.g_old_rec.cei_attribute17;
960: End If;
961: If (p_rec.cei_attribute18 = hr_api.g_varchar2) then

Line 961: If (p_rec.cei_attribute18 = hr_api.g_varchar2) then

957: If (p_rec.cei_attribute17 = hr_api.g_varchar2) then
958: p_rec.cei_attribute17 :=
959: per_rei_shd.g_old_rec.cei_attribute17;
960: End If;
961: If (p_rec.cei_attribute18 = hr_api.g_varchar2) then
962: p_rec.cei_attribute18 :=
963: per_rei_shd.g_old_rec.cei_attribute18;
964: End If;
965: If (p_rec.cei_attribute19 = hr_api.g_varchar2) then

Line 965: If (p_rec.cei_attribute19 = hr_api.g_varchar2) then

961: If (p_rec.cei_attribute18 = hr_api.g_varchar2) then
962: p_rec.cei_attribute18 :=
963: per_rei_shd.g_old_rec.cei_attribute18;
964: End If;
965: If (p_rec.cei_attribute19 = hr_api.g_varchar2) then
966: p_rec.cei_attribute19 :=
967: per_rei_shd.g_old_rec.cei_attribute19;
968: End If;
969: If (p_rec.cei_attribute20 = hr_api.g_varchar2) then

Line 969: If (p_rec.cei_attribute20 = hr_api.g_varchar2) then

965: If (p_rec.cei_attribute19 = hr_api.g_varchar2) then
966: p_rec.cei_attribute19 :=
967: per_rei_shd.g_old_rec.cei_attribute19;
968: End If;
969: If (p_rec.cei_attribute20 = hr_api.g_varchar2) then
970: p_rec.cei_attribute20 :=
971: per_rei_shd.g_old_rec.cei_attribute20;
972: End If;
973: If (p_rec.request_id = hr_api.g_number) then

Line 973: If (p_rec.request_id = hr_api.g_number) then

969: If (p_rec.cei_attribute20 = hr_api.g_varchar2) then
970: p_rec.cei_attribute20 :=
971: per_rei_shd.g_old_rec.cei_attribute20;
972: End If;
973: If (p_rec.request_id = hr_api.g_number) then
974: p_rec.request_id :=
975: per_rei_shd.g_old_rec.request_id;
976: End If;
977: If (p_rec.program_application_id = hr_api.g_number) then

Line 977: If (p_rec.program_application_id = hr_api.g_number) then

973: If (p_rec.request_id = hr_api.g_number) then
974: p_rec.request_id :=
975: per_rei_shd.g_old_rec.request_id;
976: End If;
977: If (p_rec.program_application_id = hr_api.g_number) then
978: p_rec.program_application_id :=
979: per_rei_shd.g_old_rec.program_application_id;
980: End If;
981: If (p_rec.program_id = hr_api.g_number) then

Line 981: If (p_rec.program_id = hr_api.g_number) then

977: If (p_rec.program_application_id = hr_api.g_number) then
978: p_rec.program_application_id :=
979: per_rei_shd.g_old_rec.program_application_id;
980: End If;
981: If (p_rec.program_id = hr_api.g_number) then
982: p_rec.program_id :=
983: per_rei_shd.g_old_rec.program_id;
984: End If;
985: If (p_rec.program_update_date = hr_api.g_date) then

Line 985: If (p_rec.program_update_date = hr_api.g_date) then

981: If (p_rec.program_id = hr_api.g_number) then
982: p_rec.program_id :=
983: per_rei_shd.g_old_rec.program_id;
984: End If;
985: If (p_rec.program_update_date = hr_api.g_date) then
986: p_rec.program_update_date :=
987: per_rei_shd.g_old_rec.program_update_date;
988: End If;
989: --

Line 1084: ,p_contact_relationship_id in number default hr_api.g_number

1080: (p_effective_date in date
1081: ,p_datetrack_mode in varchar2
1082: ,p_contact_extra_info_id in number
1083: ,p_object_version_number in out nocopy number
1084: ,p_contact_relationship_id in number default hr_api.g_number
1085: ,p_information_type in varchar2 default hr_api.g_varchar2
1086: ,p_cei_information_category in varchar2 default hr_api.g_varchar2
1087: ,p_cei_information1 in varchar2 default hr_api.g_varchar2
1088: ,p_cei_information2 in varchar2 default hr_api.g_varchar2

Line 1085: ,p_information_type in varchar2 default hr_api.g_varchar2

1081: ,p_datetrack_mode in varchar2
1082: ,p_contact_extra_info_id in number
1083: ,p_object_version_number in out nocopy number
1084: ,p_contact_relationship_id in number default hr_api.g_number
1085: ,p_information_type in varchar2 default hr_api.g_varchar2
1086: ,p_cei_information_category in varchar2 default hr_api.g_varchar2
1087: ,p_cei_information1 in varchar2 default hr_api.g_varchar2
1088: ,p_cei_information2 in varchar2 default hr_api.g_varchar2
1089: ,p_cei_information3 in varchar2 default hr_api.g_varchar2

Line 1086: ,p_cei_information_category in varchar2 default hr_api.g_varchar2

1082: ,p_contact_extra_info_id in number
1083: ,p_object_version_number in out nocopy number
1084: ,p_contact_relationship_id in number default hr_api.g_number
1085: ,p_information_type in varchar2 default hr_api.g_varchar2
1086: ,p_cei_information_category in varchar2 default hr_api.g_varchar2
1087: ,p_cei_information1 in varchar2 default hr_api.g_varchar2
1088: ,p_cei_information2 in varchar2 default hr_api.g_varchar2
1089: ,p_cei_information3 in varchar2 default hr_api.g_varchar2
1090: ,p_cei_information4 in varchar2 default hr_api.g_varchar2

Line 1087: ,p_cei_information1 in varchar2 default hr_api.g_varchar2

1083: ,p_object_version_number in out nocopy number
1084: ,p_contact_relationship_id in number default hr_api.g_number
1085: ,p_information_type in varchar2 default hr_api.g_varchar2
1086: ,p_cei_information_category in varchar2 default hr_api.g_varchar2
1087: ,p_cei_information1 in varchar2 default hr_api.g_varchar2
1088: ,p_cei_information2 in varchar2 default hr_api.g_varchar2
1089: ,p_cei_information3 in varchar2 default hr_api.g_varchar2
1090: ,p_cei_information4 in varchar2 default hr_api.g_varchar2
1091: ,p_cei_information5 in varchar2 default hr_api.g_varchar2

Line 1088: ,p_cei_information2 in varchar2 default hr_api.g_varchar2

1084: ,p_contact_relationship_id in number default hr_api.g_number
1085: ,p_information_type in varchar2 default hr_api.g_varchar2
1086: ,p_cei_information_category in varchar2 default hr_api.g_varchar2
1087: ,p_cei_information1 in varchar2 default hr_api.g_varchar2
1088: ,p_cei_information2 in varchar2 default hr_api.g_varchar2
1089: ,p_cei_information3 in varchar2 default hr_api.g_varchar2
1090: ,p_cei_information4 in varchar2 default hr_api.g_varchar2
1091: ,p_cei_information5 in varchar2 default hr_api.g_varchar2
1092: ,p_cei_information6 in varchar2 default hr_api.g_varchar2

Line 1089: ,p_cei_information3 in varchar2 default hr_api.g_varchar2

1085: ,p_information_type in varchar2 default hr_api.g_varchar2
1086: ,p_cei_information_category in varchar2 default hr_api.g_varchar2
1087: ,p_cei_information1 in varchar2 default hr_api.g_varchar2
1088: ,p_cei_information2 in varchar2 default hr_api.g_varchar2
1089: ,p_cei_information3 in varchar2 default hr_api.g_varchar2
1090: ,p_cei_information4 in varchar2 default hr_api.g_varchar2
1091: ,p_cei_information5 in varchar2 default hr_api.g_varchar2
1092: ,p_cei_information6 in varchar2 default hr_api.g_varchar2
1093: ,p_cei_information7 in varchar2 default hr_api.g_varchar2

Line 1090: ,p_cei_information4 in varchar2 default hr_api.g_varchar2

1086: ,p_cei_information_category in varchar2 default hr_api.g_varchar2
1087: ,p_cei_information1 in varchar2 default hr_api.g_varchar2
1088: ,p_cei_information2 in varchar2 default hr_api.g_varchar2
1089: ,p_cei_information3 in varchar2 default hr_api.g_varchar2
1090: ,p_cei_information4 in varchar2 default hr_api.g_varchar2
1091: ,p_cei_information5 in varchar2 default hr_api.g_varchar2
1092: ,p_cei_information6 in varchar2 default hr_api.g_varchar2
1093: ,p_cei_information7 in varchar2 default hr_api.g_varchar2
1094: ,p_cei_information8 in varchar2 default hr_api.g_varchar2

Line 1091: ,p_cei_information5 in varchar2 default hr_api.g_varchar2

1087: ,p_cei_information1 in varchar2 default hr_api.g_varchar2
1088: ,p_cei_information2 in varchar2 default hr_api.g_varchar2
1089: ,p_cei_information3 in varchar2 default hr_api.g_varchar2
1090: ,p_cei_information4 in varchar2 default hr_api.g_varchar2
1091: ,p_cei_information5 in varchar2 default hr_api.g_varchar2
1092: ,p_cei_information6 in varchar2 default hr_api.g_varchar2
1093: ,p_cei_information7 in varchar2 default hr_api.g_varchar2
1094: ,p_cei_information8 in varchar2 default hr_api.g_varchar2
1095: ,p_cei_information9 in varchar2 default hr_api.g_varchar2

Line 1092: ,p_cei_information6 in varchar2 default hr_api.g_varchar2

1088: ,p_cei_information2 in varchar2 default hr_api.g_varchar2
1089: ,p_cei_information3 in varchar2 default hr_api.g_varchar2
1090: ,p_cei_information4 in varchar2 default hr_api.g_varchar2
1091: ,p_cei_information5 in varchar2 default hr_api.g_varchar2
1092: ,p_cei_information6 in varchar2 default hr_api.g_varchar2
1093: ,p_cei_information7 in varchar2 default hr_api.g_varchar2
1094: ,p_cei_information8 in varchar2 default hr_api.g_varchar2
1095: ,p_cei_information9 in varchar2 default hr_api.g_varchar2
1096: ,p_cei_information10 in varchar2 default hr_api.g_varchar2

Line 1093: ,p_cei_information7 in varchar2 default hr_api.g_varchar2

1089: ,p_cei_information3 in varchar2 default hr_api.g_varchar2
1090: ,p_cei_information4 in varchar2 default hr_api.g_varchar2
1091: ,p_cei_information5 in varchar2 default hr_api.g_varchar2
1092: ,p_cei_information6 in varchar2 default hr_api.g_varchar2
1093: ,p_cei_information7 in varchar2 default hr_api.g_varchar2
1094: ,p_cei_information8 in varchar2 default hr_api.g_varchar2
1095: ,p_cei_information9 in varchar2 default hr_api.g_varchar2
1096: ,p_cei_information10 in varchar2 default hr_api.g_varchar2
1097: ,p_cei_information11 in varchar2 default hr_api.g_varchar2

Line 1094: ,p_cei_information8 in varchar2 default hr_api.g_varchar2

1090: ,p_cei_information4 in varchar2 default hr_api.g_varchar2
1091: ,p_cei_information5 in varchar2 default hr_api.g_varchar2
1092: ,p_cei_information6 in varchar2 default hr_api.g_varchar2
1093: ,p_cei_information7 in varchar2 default hr_api.g_varchar2
1094: ,p_cei_information8 in varchar2 default hr_api.g_varchar2
1095: ,p_cei_information9 in varchar2 default hr_api.g_varchar2
1096: ,p_cei_information10 in varchar2 default hr_api.g_varchar2
1097: ,p_cei_information11 in varchar2 default hr_api.g_varchar2
1098: ,p_cei_information12 in varchar2 default hr_api.g_varchar2

Line 1095: ,p_cei_information9 in varchar2 default hr_api.g_varchar2

1091: ,p_cei_information5 in varchar2 default hr_api.g_varchar2
1092: ,p_cei_information6 in varchar2 default hr_api.g_varchar2
1093: ,p_cei_information7 in varchar2 default hr_api.g_varchar2
1094: ,p_cei_information8 in varchar2 default hr_api.g_varchar2
1095: ,p_cei_information9 in varchar2 default hr_api.g_varchar2
1096: ,p_cei_information10 in varchar2 default hr_api.g_varchar2
1097: ,p_cei_information11 in varchar2 default hr_api.g_varchar2
1098: ,p_cei_information12 in varchar2 default hr_api.g_varchar2
1099: ,p_cei_information13 in varchar2 default hr_api.g_varchar2

Line 1096: ,p_cei_information10 in varchar2 default hr_api.g_varchar2

1092: ,p_cei_information6 in varchar2 default hr_api.g_varchar2
1093: ,p_cei_information7 in varchar2 default hr_api.g_varchar2
1094: ,p_cei_information8 in varchar2 default hr_api.g_varchar2
1095: ,p_cei_information9 in varchar2 default hr_api.g_varchar2
1096: ,p_cei_information10 in varchar2 default hr_api.g_varchar2
1097: ,p_cei_information11 in varchar2 default hr_api.g_varchar2
1098: ,p_cei_information12 in varchar2 default hr_api.g_varchar2
1099: ,p_cei_information13 in varchar2 default hr_api.g_varchar2
1100: ,p_cei_information14 in varchar2 default hr_api.g_varchar2

Line 1097: ,p_cei_information11 in varchar2 default hr_api.g_varchar2

1093: ,p_cei_information7 in varchar2 default hr_api.g_varchar2
1094: ,p_cei_information8 in varchar2 default hr_api.g_varchar2
1095: ,p_cei_information9 in varchar2 default hr_api.g_varchar2
1096: ,p_cei_information10 in varchar2 default hr_api.g_varchar2
1097: ,p_cei_information11 in varchar2 default hr_api.g_varchar2
1098: ,p_cei_information12 in varchar2 default hr_api.g_varchar2
1099: ,p_cei_information13 in varchar2 default hr_api.g_varchar2
1100: ,p_cei_information14 in varchar2 default hr_api.g_varchar2
1101: ,p_cei_information15 in varchar2 default hr_api.g_varchar2

Line 1098: ,p_cei_information12 in varchar2 default hr_api.g_varchar2

1094: ,p_cei_information8 in varchar2 default hr_api.g_varchar2
1095: ,p_cei_information9 in varchar2 default hr_api.g_varchar2
1096: ,p_cei_information10 in varchar2 default hr_api.g_varchar2
1097: ,p_cei_information11 in varchar2 default hr_api.g_varchar2
1098: ,p_cei_information12 in varchar2 default hr_api.g_varchar2
1099: ,p_cei_information13 in varchar2 default hr_api.g_varchar2
1100: ,p_cei_information14 in varchar2 default hr_api.g_varchar2
1101: ,p_cei_information15 in varchar2 default hr_api.g_varchar2
1102: ,p_cei_information16 in varchar2 default hr_api.g_varchar2

Line 1099: ,p_cei_information13 in varchar2 default hr_api.g_varchar2

1095: ,p_cei_information9 in varchar2 default hr_api.g_varchar2
1096: ,p_cei_information10 in varchar2 default hr_api.g_varchar2
1097: ,p_cei_information11 in varchar2 default hr_api.g_varchar2
1098: ,p_cei_information12 in varchar2 default hr_api.g_varchar2
1099: ,p_cei_information13 in varchar2 default hr_api.g_varchar2
1100: ,p_cei_information14 in varchar2 default hr_api.g_varchar2
1101: ,p_cei_information15 in varchar2 default hr_api.g_varchar2
1102: ,p_cei_information16 in varchar2 default hr_api.g_varchar2
1103: ,p_cei_information17 in varchar2 default hr_api.g_varchar2

Line 1100: ,p_cei_information14 in varchar2 default hr_api.g_varchar2

1096: ,p_cei_information10 in varchar2 default hr_api.g_varchar2
1097: ,p_cei_information11 in varchar2 default hr_api.g_varchar2
1098: ,p_cei_information12 in varchar2 default hr_api.g_varchar2
1099: ,p_cei_information13 in varchar2 default hr_api.g_varchar2
1100: ,p_cei_information14 in varchar2 default hr_api.g_varchar2
1101: ,p_cei_information15 in varchar2 default hr_api.g_varchar2
1102: ,p_cei_information16 in varchar2 default hr_api.g_varchar2
1103: ,p_cei_information17 in varchar2 default hr_api.g_varchar2
1104: ,p_cei_information18 in varchar2 default hr_api.g_varchar2

Line 1101: ,p_cei_information15 in varchar2 default hr_api.g_varchar2

1097: ,p_cei_information11 in varchar2 default hr_api.g_varchar2
1098: ,p_cei_information12 in varchar2 default hr_api.g_varchar2
1099: ,p_cei_information13 in varchar2 default hr_api.g_varchar2
1100: ,p_cei_information14 in varchar2 default hr_api.g_varchar2
1101: ,p_cei_information15 in varchar2 default hr_api.g_varchar2
1102: ,p_cei_information16 in varchar2 default hr_api.g_varchar2
1103: ,p_cei_information17 in varchar2 default hr_api.g_varchar2
1104: ,p_cei_information18 in varchar2 default hr_api.g_varchar2
1105: ,p_cei_information19 in varchar2 default hr_api.g_varchar2

Line 1102: ,p_cei_information16 in varchar2 default hr_api.g_varchar2

1098: ,p_cei_information12 in varchar2 default hr_api.g_varchar2
1099: ,p_cei_information13 in varchar2 default hr_api.g_varchar2
1100: ,p_cei_information14 in varchar2 default hr_api.g_varchar2
1101: ,p_cei_information15 in varchar2 default hr_api.g_varchar2
1102: ,p_cei_information16 in varchar2 default hr_api.g_varchar2
1103: ,p_cei_information17 in varchar2 default hr_api.g_varchar2
1104: ,p_cei_information18 in varchar2 default hr_api.g_varchar2
1105: ,p_cei_information19 in varchar2 default hr_api.g_varchar2
1106: ,p_cei_information20 in varchar2 default hr_api.g_varchar2

Line 1103: ,p_cei_information17 in varchar2 default hr_api.g_varchar2

1099: ,p_cei_information13 in varchar2 default hr_api.g_varchar2
1100: ,p_cei_information14 in varchar2 default hr_api.g_varchar2
1101: ,p_cei_information15 in varchar2 default hr_api.g_varchar2
1102: ,p_cei_information16 in varchar2 default hr_api.g_varchar2
1103: ,p_cei_information17 in varchar2 default hr_api.g_varchar2
1104: ,p_cei_information18 in varchar2 default hr_api.g_varchar2
1105: ,p_cei_information19 in varchar2 default hr_api.g_varchar2
1106: ,p_cei_information20 in varchar2 default hr_api.g_varchar2
1107: ,p_cei_information21 in varchar2 default hr_api.g_varchar2

Line 1104: ,p_cei_information18 in varchar2 default hr_api.g_varchar2

1100: ,p_cei_information14 in varchar2 default hr_api.g_varchar2
1101: ,p_cei_information15 in varchar2 default hr_api.g_varchar2
1102: ,p_cei_information16 in varchar2 default hr_api.g_varchar2
1103: ,p_cei_information17 in varchar2 default hr_api.g_varchar2
1104: ,p_cei_information18 in varchar2 default hr_api.g_varchar2
1105: ,p_cei_information19 in varchar2 default hr_api.g_varchar2
1106: ,p_cei_information20 in varchar2 default hr_api.g_varchar2
1107: ,p_cei_information21 in varchar2 default hr_api.g_varchar2
1108: ,p_cei_information22 in varchar2 default hr_api.g_varchar2

Line 1105: ,p_cei_information19 in varchar2 default hr_api.g_varchar2

1101: ,p_cei_information15 in varchar2 default hr_api.g_varchar2
1102: ,p_cei_information16 in varchar2 default hr_api.g_varchar2
1103: ,p_cei_information17 in varchar2 default hr_api.g_varchar2
1104: ,p_cei_information18 in varchar2 default hr_api.g_varchar2
1105: ,p_cei_information19 in varchar2 default hr_api.g_varchar2
1106: ,p_cei_information20 in varchar2 default hr_api.g_varchar2
1107: ,p_cei_information21 in varchar2 default hr_api.g_varchar2
1108: ,p_cei_information22 in varchar2 default hr_api.g_varchar2
1109: ,p_cei_information23 in varchar2 default hr_api.g_varchar2

Line 1106: ,p_cei_information20 in varchar2 default hr_api.g_varchar2

1102: ,p_cei_information16 in varchar2 default hr_api.g_varchar2
1103: ,p_cei_information17 in varchar2 default hr_api.g_varchar2
1104: ,p_cei_information18 in varchar2 default hr_api.g_varchar2
1105: ,p_cei_information19 in varchar2 default hr_api.g_varchar2
1106: ,p_cei_information20 in varchar2 default hr_api.g_varchar2
1107: ,p_cei_information21 in varchar2 default hr_api.g_varchar2
1108: ,p_cei_information22 in varchar2 default hr_api.g_varchar2
1109: ,p_cei_information23 in varchar2 default hr_api.g_varchar2
1110: ,p_cei_information24 in varchar2 default hr_api.g_varchar2

Line 1107: ,p_cei_information21 in varchar2 default hr_api.g_varchar2

1103: ,p_cei_information17 in varchar2 default hr_api.g_varchar2
1104: ,p_cei_information18 in varchar2 default hr_api.g_varchar2
1105: ,p_cei_information19 in varchar2 default hr_api.g_varchar2
1106: ,p_cei_information20 in varchar2 default hr_api.g_varchar2
1107: ,p_cei_information21 in varchar2 default hr_api.g_varchar2
1108: ,p_cei_information22 in varchar2 default hr_api.g_varchar2
1109: ,p_cei_information23 in varchar2 default hr_api.g_varchar2
1110: ,p_cei_information24 in varchar2 default hr_api.g_varchar2
1111: ,p_cei_information25 in varchar2 default hr_api.g_varchar2

Line 1108: ,p_cei_information22 in varchar2 default hr_api.g_varchar2

1104: ,p_cei_information18 in varchar2 default hr_api.g_varchar2
1105: ,p_cei_information19 in varchar2 default hr_api.g_varchar2
1106: ,p_cei_information20 in varchar2 default hr_api.g_varchar2
1107: ,p_cei_information21 in varchar2 default hr_api.g_varchar2
1108: ,p_cei_information22 in varchar2 default hr_api.g_varchar2
1109: ,p_cei_information23 in varchar2 default hr_api.g_varchar2
1110: ,p_cei_information24 in varchar2 default hr_api.g_varchar2
1111: ,p_cei_information25 in varchar2 default hr_api.g_varchar2
1112: ,p_cei_information26 in varchar2 default hr_api.g_varchar2

Line 1109: ,p_cei_information23 in varchar2 default hr_api.g_varchar2

1105: ,p_cei_information19 in varchar2 default hr_api.g_varchar2
1106: ,p_cei_information20 in varchar2 default hr_api.g_varchar2
1107: ,p_cei_information21 in varchar2 default hr_api.g_varchar2
1108: ,p_cei_information22 in varchar2 default hr_api.g_varchar2
1109: ,p_cei_information23 in varchar2 default hr_api.g_varchar2
1110: ,p_cei_information24 in varchar2 default hr_api.g_varchar2
1111: ,p_cei_information25 in varchar2 default hr_api.g_varchar2
1112: ,p_cei_information26 in varchar2 default hr_api.g_varchar2
1113: ,p_cei_information27 in varchar2 default hr_api.g_varchar2

Line 1110: ,p_cei_information24 in varchar2 default hr_api.g_varchar2

1106: ,p_cei_information20 in varchar2 default hr_api.g_varchar2
1107: ,p_cei_information21 in varchar2 default hr_api.g_varchar2
1108: ,p_cei_information22 in varchar2 default hr_api.g_varchar2
1109: ,p_cei_information23 in varchar2 default hr_api.g_varchar2
1110: ,p_cei_information24 in varchar2 default hr_api.g_varchar2
1111: ,p_cei_information25 in varchar2 default hr_api.g_varchar2
1112: ,p_cei_information26 in varchar2 default hr_api.g_varchar2
1113: ,p_cei_information27 in varchar2 default hr_api.g_varchar2
1114: ,p_cei_information28 in varchar2 default hr_api.g_varchar2

Line 1111: ,p_cei_information25 in varchar2 default hr_api.g_varchar2

1107: ,p_cei_information21 in varchar2 default hr_api.g_varchar2
1108: ,p_cei_information22 in varchar2 default hr_api.g_varchar2
1109: ,p_cei_information23 in varchar2 default hr_api.g_varchar2
1110: ,p_cei_information24 in varchar2 default hr_api.g_varchar2
1111: ,p_cei_information25 in varchar2 default hr_api.g_varchar2
1112: ,p_cei_information26 in varchar2 default hr_api.g_varchar2
1113: ,p_cei_information27 in varchar2 default hr_api.g_varchar2
1114: ,p_cei_information28 in varchar2 default hr_api.g_varchar2
1115: ,p_cei_information29 in varchar2 default hr_api.g_varchar2

Line 1112: ,p_cei_information26 in varchar2 default hr_api.g_varchar2

1108: ,p_cei_information22 in varchar2 default hr_api.g_varchar2
1109: ,p_cei_information23 in varchar2 default hr_api.g_varchar2
1110: ,p_cei_information24 in varchar2 default hr_api.g_varchar2
1111: ,p_cei_information25 in varchar2 default hr_api.g_varchar2
1112: ,p_cei_information26 in varchar2 default hr_api.g_varchar2
1113: ,p_cei_information27 in varchar2 default hr_api.g_varchar2
1114: ,p_cei_information28 in varchar2 default hr_api.g_varchar2
1115: ,p_cei_information29 in varchar2 default hr_api.g_varchar2
1116: ,p_cei_information30 in varchar2 default hr_api.g_varchar2

Line 1113: ,p_cei_information27 in varchar2 default hr_api.g_varchar2

1109: ,p_cei_information23 in varchar2 default hr_api.g_varchar2
1110: ,p_cei_information24 in varchar2 default hr_api.g_varchar2
1111: ,p_cei_information25 in varchar2 default hr_api.g_varchar2
1112: ,p_cei_information26 in varchar2 default hr_api.g_varchar2
1113: ,p_cei_information27 in varchar2 default hr_api.g_varchar2
1114: ,p_cei_information28 in varchar2 default hr_api.g_varchar2
1115: ,p_cei_information29 in varchar2 default hr_api.g_varchar2
1116: ,p_cei_information30 in varchar2 default hr_api.g_varchar2
1117: ,p_cei_attribute_category in varchar2 default hr_api.g_varchar2

Line 1114: ,p_cei_information28 in varchar2 default hr_api.g_varchar2

1110: ,p_cei_information24 in varchar2 default hr_api.g_varchar2
1111: ,p_cei_information25 in varchar2 default hr_api.g_varchar2
1112: ,p_cei_information26 in varchar2 default hr_api.g_varchar2
1113: ,p_cei_information27 in varchar2 default hr_api.g_varchar2
1114: ,p_cei_information28 in varchar2 default hr_api.g_varchar2
1115: ,p_cei_information29 in varchar2 default hr_api.g_varchar2
1116: ,p_cei_information30 in varchar2 default hr_api.g_varchar2
1117: ,p_cei_attribute_category in varchar2 default hr_api.g_varchar2
1118: ,p_cei_attribute1 in varchar2 default hr_api.g_varchar2

Line 1115: ,p_cei_information29 in varchar2 default hr_api.g_varchar2

1111: ,p_cei_information25 in varchar2 default hr_api.g_varchar2
1112: ,p_cei_information26 in varchar2 default hr_api.g_varchar2
1113: ,p_cei_information27 in varchar2 default hr_api.g_varchar2
1114: ,p_cei_information28 in varchar2 default hr_api.g_varchar2
1115: ,p_cei_information29 in varchar2 default hr_api.g_varchar2
1116: ,p_cei_information30 in varchar2 default hr_api.g_varchar2
1117: ,p_cei_attribute_category in varchar2 default hr_api.g_varchar2
1118: ,p_cei_attribute1 in varchar2 default hr_api.g_varchar2
1119: ,p_cei_attribute2 in varchar2 default hr_api.g_varchar2

Line 1116: ,p_cei_information30 in varchar2 default hr_api.g_varchar2

1112: ,p_cei_information26 in varchar2 default hr_api.g_varchar2
1113: ,p_cei_information27 in varchar2 default hr_api.g_varchar2
1114: ,p_cei_information28 in varchar2 default hr_api.g_varchar2
1115: ,p_cei_information29 in varchar2 default hr_api.g_varchar2
1116: ,p_cei_information30 in varchar2 default hr_api.g_varchar2
1117: ,p_cei_attribute_category in varchar2 default hr_api.g_varchar2
1118: ,p_cei_attribute1 in varchar2 default hr_api.g_varchar2
1119: ,p_cei_attribute2 in varchar2 default hr_api.g_varchar2
1120: ,p_cei_attribute3 in varchar2 default hr_api.g_varchar2

Line 1117: ,p_cei_attribute_category in varchar2 default hr_api.g_varchar2

1113: ,p_cei_information27 in varchar2 default hr_api.g_varchar2
1114: ,p_cei_information28 in varchar2 default hr_api.g_varchar2
1115: ,p_cei_information29 in varchar2 default hr_api.g_varchar2
1116: ,p_cei_information30 in varchar2 default hr_api.g_varchar2
1117: ,p_cei_attribute_category in varchar2 default hr_api.g_varchar2
1118: ,p_cei_attribute1 in varchar2 default hr_api.g_varchar2
1119: ,p_cei_attribute2 in varchar2 default hr_api.g_varchar2
1120: ,p_cei_attribute3 in varchar2 default hr_api.g_varchar2
1121: ,p_cei_attribute4 in varchar2 default hr_api.g_varchar2

Line 1118: ,p_cei_attribute1 in varchar2 default hr_api.g_varchar2

1114: ,p_cei_information28 in varchar2 default hr_api.g_varchar2
1115: ,p_cei_information29 in varchar2 default hr_api.g_varchar2
1116: ,p_cei_information30 in varchar2 default hr_api.g_varchar2
1117: ,p_cei_attribute_category in varchar2 default hr_api.g_varchar2
1118: ,p_cei_attribute1 in varchar2 default hr_api.g_varchar2
1119: ,p_cei_attribute2 in varchar2 default hr_api.g_varchar2
1120: ,p_cei_attribute3 in varchar2 default hr_api.g_varchar2
1121: ,p_cei_attribute4 in varchar2 default hr_api.g_varchar2
1122: ,p_cei_attribute5 in varchar2 default hr_api.g_varchar2

Line 1119: ,p_cei_attribute2 in varchar2 default hr_api.g_varchar2

1115: ,p_cei_information29 in varchar2 default hr_api.g_varchar2
1116: ,p_cei_information30 in varchar2 default hr_api.g_varchar2
1117: ,p_cei_attribute_category in varchar2 default hr_api.g_varchar2
1118: ,p_cei_attribute1 in varchar2 default hr_api.g_varchar2
1119: ,p_cei_attribute2 in varchar2 default hr_api.g_varchar2
1120: ,p_cei_attribute3 in varchar2 default hr_api.g_varchar2
1121: ,p_cei_attribute4 in varchar2 default hr_api.g_varchar2
1122: ,p_cei_attribute5 in varchar2 default hr_api.g_varchar2
1123: ,p_cei_attribute6 in varchar2 default hr_api.g_varchar2

Line 1120: ,p_cei_attribute3 in varchar2 default hr_api.g_varchar2

1116: ,p_cei_information30 in varchar2 default hr_api.g_varchar2
1117: ,p_cei_attribute_category in varchar2 default hr_api.g_varchar2
1118: ,p_cei_attribute1 in varchar2 default hr_api.g_varchar2
1119: ,p_cei_attribute2 in varchar2 default hr_api.g_varchar2
1120: ,p_cei_attribute3 in varchar2 default hr_api.g_varchar2
1121: ,p_cei_attribute4 in varchar2 default hr_api.g_varchar2
1122: ,p_cei_attribute5 in varchar2 default hr_api.g_varchar2
1123: ,p_cei_attribute6 in varchar2 default hr_api.g_varchar2
1124: ,p_cei_attribute7 in varchar2 default hr_api.g_varchar2

Line 1121: ,p_cei_attribute4 in varchar2 default hr_api.g_varchar2

1117: ,p_cei_attribute_category in varchar2 default hr_api.g_varchar2
1118: ,p_cei_attribute1 in varchar2 default hr_api.g_varchar2
1119: ,p_cei_attribute2 in varchar2 default hr_api.g_varchar2
1120: ,p_cei_attribute3 in varchar2 default hr_api.g_varchar2
1121: ,p_cei_attribute4 in varchar2 default hr_api.g_varchar2
1122: ,p_cei_attribute5 in varchar2 default hr_api.g_varchar2
1123: ,p_cei_attribute6 in varchar2 default hr_api.g_varchar2
1124: ,p_cei_attribute7 in varchar2 default hr_api.g_varchar2
1125: ,p_cei_attribute8 in varchar2 default hr_api.g_varchar2

Line 1122: ,p_cei_attribute5 in varchar2 default hr_api.g_varchar2

1118: ,p_cei_attribute1 in varchar2 default hr_api.g_varchar2
1119: ,p_cei_attribute2 in varchar2 default hr_api.g_varchar2
1120: ,p_cei_attribute3 in varchar2 default hr_api.g_varchar2
1121: ,p_cei_attribute4 in varchar2 default hr_api.g_varchar2
1122: ,p_cei_attribute5 in varchar2 default hr_api.g_varchar2
1123: ,p_cei_attribute6 in varchar2 default hr_api.g_varchar2
1124: ,p_cei_attribute7 in varchar2 default hr_api.g_varchar2
1125: ,p_cei_attribute8 in varchar2 default hr_api.g_varchar2
1126: ,p_cei_attribute9 in varchar2 default hr_api.g_varchar2

Line 1123: ,p_cei_attribute6 in varchar2 default hr_api.g_varchar2

1119: ,p_cei_attribute2 in varchar2 default hr_api.g_varchar2
1120: ,p_cei_attribute3 in varchar2 default hr_api.g_varchar2
1121: ,p_cei_attribute4 in varchar2 default hr_api.g_varchar2
1122: ,p_cei_attribute5 in varchar2 default hr_api.g_varchar2
1123: ,p_cei_attribute6 in varchar2 default hr_api.g_varchar2
1124: ,p_cei_attribute7 in varchar2 default hr_api.g_varchar2
1125: ,p_cei_attribute8 in varchar2 default hr_api.g_varchar2
1126: ,p_cei_attribute9 in varchar2 default hr_api.g_varchar2
1127: ,p_cei_attribute10 in varchar2 default hr_api.g_varchar2

Line 1124: ,p_cei_attribute7 in varchar2 default hr_api.g_varchar2

1120: ,p_cei_attribute3 in varchar2 default hr_api.g_varchar2
1121: ,p_cei_attribute4 in varchar2 default hr_api.g_varchar2
1122: ,p_cei_attribute5 in varchar2 default hr_api.g_varchar2
1123: ,p_cei_attribute6 in varchar2 default hr_api.g_varchar2
1124: ,p_cei_attribute7 in varchar2 default hr_api.g_varchar2
1125: ,p_cei_attribute8 in varchar2 default hr_api.g_varchar2
1126: ,p_cei_attribute9 in varchar2 default hr_api.g_varchar2
1127: ,p_cei_attribute10 in varchar2 default hr_api.g_varchar2
1128: ,p_cei_attribute11 in varchar2 default hr_api.g_varchar2

Line 1125: ,p_cei_attribute8 in varchar2 default hr_api.g_varchar2

1121: ,p_cei_attribute4 in varchar2 default hr_api.g_varchar2
1122: ,p_cei_attribute5 in varchar2 default hr_api.g_varchar2
1123: ,p_cei_attribute6 in varchar2 default hr_api.g_varchar2
1124: ,p_cei_attribute7 in varchar2 default hr_api.g_varchar2
1125: ,p_cei_attribute8 in varchar2 default hr_api.g_varchar2
1126: ,p_cei_attribute9 in varchar2 default hr_api.g_varchar2
1127: ,p_cei_attribute10 in varchar2 default hr_api.g_varchar2
1128: ,p_cei_attribute11 in varchar2 default hr_api.g_varchar2
1129: ,p_cei_attribute12 in varchar2 default hr_api.g_varchar2

Line 1126: ,p_cei_attribute9 in varchar2 default hr_api.g_varchar2

1122: ,p_cei_attribute5 in varchar2 default hr_api.g_varchar2
1123: ,p_cei_attribute6 in varchar2 default hr_api.g_varchar2
1124: ,p_cei_attribute7 in varchar2 default hr_api.g_varchar2
1125: ,p_cei_attribute8 in varchar2 default hr_api.g_varchar2
1126: ,p_cei_attribute9 in varchar2 default hr_api.g_varchar2
1127: ,p_cei_attribute10 in varchar2 default hr_api.g_varchar2
1128: ,p_cei_attribute11 in varchar2 default hr_api.g_varchar2
1129: ,p_cei_attribute12 in varchar2 default hr_api.g_varchar2
1130: ,p_cei_attribute13 in varchar2 default hr_api.g_varchar2

Line 1127: ,p_cei_attribute10 in varchar2 default hr_api.g_varchar2

1123: ,p_cei_attribute6 in varchar2 default hr_api.g_varchar2
1124: ,p_cei_attribute7 in varchar2 default hr_api.g_varchar2
1125: ,p_cei_attribute8 in varchar2 default hr_api.g_varchar2
1126: ,p_cei_attribute9 in varchar2 default hr_api.g_varchar2
1127: ,p_cei_attribute10 in varchar2 default hr_api.g_varchar2
1128: ,p_cei_attribute11 in varchar2 default hr_api.g_varchar2
1129: ,p_cei_attribute12 in varchar2 default hr_api.g_varchar2
1130: ,p_cei_attribute13 in varchar2 default hr_api.g_varchar2
1131: ,p_cei_attribute14 in varchar2 default hr_api.g_varchar2

Line 1128: ,p_cei_attribute11 in varchar2 default hr_api.g_varchar2

1124: ,p_cei_attribute7 in varchar2 default hr_api.g_varchar2
1125: ,p_cei_attribute8 in varchar2 default hr_api.g_varchar2
1126: ,p_cei_attribute9 in varchar2 default hr_api.g_varchar2
1127: ,p_cei_attribute10 in varchar2 default hr_api.g_varchar2
1128: ,p_cei_attribute11 in varchar2 default hr_api.g_varchar2
1129: ,p_cei_attribute12 in varchar2 default hr_api.g_varchar2
1130: ,p_cei_attribute13 in varchar2 default hr_api.g_varchar2
1131: ,p_cei_attribute14 in varchar2 default hr_api.g_varchar2
1132: ,p_cei_attribute15 in varchar2 default hr_api.g_varchar2

Line 1129: ,p_cei_attribute12 in varchar2 default hr_api.g_varchar2

1125: ,p_cei_attribute8 in varchar2 default hr_api.g_varchar2
1126: ,p_cei_attribute9 in varchar2 default hr_api.g_varchar2
1127: ,p_cei_attribute10 in varchar2 default hr_api.g_varchar2
1128: ,p_cei_attribute11 in varchar2 default hr_api.g_varchar2
1129: ,p_cei_attribute12 in varchar2 default hr_api.g_varchar2
1130: ,p_cei_attribute13 in varchar2 default hr_api.g_varchar2
1131: ,p_cei_attribute14 in varchar2 default hr_api.g_varchar2
1132: ,p_cei_attribute15 in varchar2 default hr_api.g_varchar2
1133: ,p_cei_attribute16 in varchar2 default hr_api.g_varchar2

Line 1130: ,p_cei_attribute13 in varchar2 default hr_api.g_varchar2

1126: ,p_cei_attribute9 in varchar2 default hr_api.g_varchar2
1127: ,p_cei_attribute10 in varchar2 default hr_api.g_varchar2
1128: ,p_cei_attribute11 in varchar2 default hr_api.g_varchar2
1129: ,p_cei_attribute12 in varchar2 default hr_api.g_varchar2
1130: ,p_cei_attribute13 in varchar2 default hr_api.g_varchar2
1131: ,p_cei_attribute14 in varchar2 default hr_api.g_varchar2
1132: ,p_cei_attribute15 in varchar2 default hr_api.g_varchar2
1133: ,p_cei_attribute16 in varchar2 default hr_api.g_varchar2
1134: ,p_cei_attribute17 in varchar2 default hr_api.g_varchar2

Line 1131: ,p_cei_attribute14 in varchar2 default hr_api.g_varchar2

1127: ,p_cei_attribute10 in varchar2 default hr_api.g_varchar2
1128: ,p_cei_attribute11 in varchar2 default hr_api.g_varchar2
1129: ,p_cei_attribute12 in varchar2 default hr_api.g_varchar2
1130: ,p_cei_attribute13 in varchar2 default hr_api.g_varchar2
1131: ,p_cei_attribute14 in varchar2 default hr_api.g_varchar2
1132: ,p_cei_attribute15 in varchar2 default hr_api.g_varchar2
1133: ,p_cei_attribute16 in varchar2 default hr_api.g_varchar2
1134: ,p_cei_attribute17 in varchar2 default hr_api.g_varchar2
1135: ,p_cei_attribute18 in varchar2 default hr_api.g_varchar2

Line 1132: ,p_cei_attribute15 in varchar2 default hr_api.g_varchar2

1128: ,p_cei_attribute11 in varchar2 default hr_api.g_varchar2
1129: ,p_cei_attribute12 in varchar2 default hr_api.g_varchar2
1130: ,p_cei_attribute13 in varchar2 default hr_api.g_varchar2
1131: ,p_cei_attribute14 in varchar2 default hr_api.g_varchar2
1132: ,p_cei_attribute15 in varchar2 default hr_api.g_varchar2
1133: ,p_cei_attribute16 in varchar2 default hr_api.g_varchar2
1134: ,p_cei_attribute17 in varchar2 default hr_api.g_varchar2
1135: ,p_cei_attribute18 in varchar2 default hr_api.g_varchar2
1136: ,p_cei_attribute19 in varchar2 default hr_api.g_varchar2

Line 1133: ,p_cei_attribute16 in varchar2 default hr_api.g_varchar2

1129: ,p_cei_attribute12 in varchar2 default hr_api.g_varchar2
1130: ,p_cei_attribute13 in varchar2 default hr_api.g_varchar2
1131: ,p_cei_attribute14 in varchar2 default hr_api.g_varchar2
1132: ,p_cei_attribute15 in varchar2 default hr_api.g_varchar2
1133: ,p_cei_attribute16 in varchar2 default hr_api.g_varchar2
1134: ,p_cei_attribute17 in varchar2 default hr_api.g_varchar2
1135: ,p_cei_attribute18 in varchar2 default hr_api.g_varchar2
1136: ,p_cei_attribute19 in varchar2 default hr_api.g_varchar2
1137: ,p_cei_attribute20 in varchar2 default hr_api.g_varchar2

Line 1134: ,p_cei_attribute17 in varchar2 default hr_api.g_varchar2

1130: ,p_cei_attribute13 in varchar2 default hr_api.g_varchar2
1131: ,p_cei_attribute14 in varchar2 default hr_api.g_varchar2
1132: ,p_cei_attribute15 in varchar2 default hr_api.g_varchar2
1133: ,p_cei_attribute16 in varchar2 default hr_api.g_varchar2
1134: ,p_cei_attribute17 in varchar2 default hr_api.g_varchar2
1135: ,p_cei_attribute18 in varchar2 default hr_api.g_varchar2
1136: ,p_cei_attribute19 in varchar2 default hr_api.g_varchar2
1137: ,p_cei_attribute20 in varchar2 default hr_api.g_varchar2
1138: ,p_request_id in number default hr_api.g_number

Line 1135: ,p_cei_attribute18 in varchar2 default hr_api.g_varchar2

1131: ,p_cei_attribute14 in varchar2 default hr_api.g_varchar2
1132: ,p_cei_attribute15 in varchar2 default hr_api.g_varchar2
1133: ,p_cei_attribute16 in varchar2 default hr_api.g_varchar2
1134: ,p_cei_attribute17 in varchar2 default hr_api.g_varchar2
1135: ,p_cei_attribute18 in varchar2 default hr_api.g_varchar2
1136: ,p_cei_attribute19 in varchar2 default hr_api.g_varchar2
1137: ,p_cei_attribute20 in varchar2 default hr_api.g_varchar2
1138: ,p_request_id in number default hr_api.g_number
1139: ,p_program_application_id in number default hr_api.g_number

Line 1136: ,p_cei_attribute19 in varchar2 default hr_api.g_varchar2

1132: ,p_cei_attribute15 in varchar2 default hr_api.g_varchar2
1133: ,p_cei_attribute16 in varchar2 default hr_api.g_varchar2
1134: ,p_cei_attribute17 in varchar2 default hr_api.g_varchar2
1135: ,p_cei_attribute18 in varchar2 default hr_api.g_varchar2
1136: ,p_cei_attribute19 in varchar2 default hr_api.g_varchar2
1137: ,p_cei_attribute20 in varchar2 default hr_api.g_varchar2
1138: ,p_request_id in number default hr_api.g_number
1139: ,p_program_application_id in number default hr_api.g_number
1140: ,p_program_id in number default hr_api.g_number

Line 1137: ,p_cei_attribute20 in varchar2 default hr_api.g_varchar2

1133: ,p_cei_attribute16 in varchar2 default hr_api.g_varchar2
1134: ,p_cei_attribute17 in varchar2 default hr_api.g_varchar2
1135: ,p_cei_attribute18 in varchar2 default hr_api.g_varchar2
1136: ,p_cei_attribute19 in varchar2 default hr_api.g_varchar2
1137: ,p_cei_attribute20 in varchar2 default hr_api.g_varchar2
1138: ,p_request_id in number default hr_api.g_number
1139: ,p_program_application_id in number default hr_api.g_number
1140: ,p_program_id in number default hr_api.g_number
1141: ,p_program_update_date in date default hr_api.g_date

Line 1138: ,p_request_id in number default hr_api.g_number

1134: ,p_cei_attribute17 in varchar2 default hr_api.g_varchar2
1135: ,p_cei_attribute18 in varchar2 default hr_api.g_varchar2
1136: ,p_cei_attribute19 in varchar2 default hr_api.g_varchar2
1137: ,p_cei_attribute20 in varchar2 default hr_api.g_varchar2
1138: ,p_request_id in number default hr_api.g_number
1139: ,p_program_application_id in number default hr_api.g_number
1140: ,p_program_id in number default hr_api.g_number
1141: ,p_program_update_date in date default hr_api.g_date
1142: ,p_effective_start_date out nocopy date

Line 1139: ,p_program_application_id in number default hr_api.g_number

1135: ,p_cei_attribute18 in varchar2 default hr_api.g_varchar2
1136: ,p_cei_attribute19 in varchar2 default hr_api.g_varchar2
1137: ,p_cei_attribute20 in varchar2 default hr_api.g_varchar2
1138: ,p_request_id in number default hr_api.g_number
1139: ,p_program_application_id in number default hr_api.g_number
1140: ,p_program_id in number default hr_api.g_number
1141: ,p_program_update_date in date default hr_api.g_date
1142: ,p_effective_start_date out nocopy date
1143: ,p_effective_end_date out nocopy date

Line 1140: ,p_program_id in number default hr_api.g_number

1136: ,p_cei_attribute19 in varchar2 default hr_api.g_varchar2
1137: ,p_cei_attribute20 in varchar2 default hr_api.g_varchar2
1138: ,p_request_id in number default hr_api.g_number
1139: ,p_program_application_id in number default hr_api.g_number
1140: ,p_program_id in number default hr_api.g_number
1141: ,p_program_update_date in date default hr_api.g_date
1142: ,p_effective_start_date out nocopy date
1143: ,p_effective_end_date out nocopy date
1144: ) is

Line 1141: ,p_program_update_date in date default hr_api.g_date

1137: ,p_cei_attribute20 in varchar2 default hr_api.g_varchar2
1138: ,p_request_id in number default hr_api.g_number
1139: ,p_program_application_id in number default hr_api.g_number
1140: ,p_program_id in number default hr_api.g_number
1141: ,p_program_update_date in date default hr_api.g_date
1142: ,p_effective_start_date out nocopy date
1143: ,p_effective_end_date out nocopy date
1144: ) is
1145: --