APPS.IRC_ISC_UPD dependencies on HR_API

Line 194: When hr_api.check_integrity_violated Then

190: --
191: hr_utility.set_location(' Leaving:'||l_proc, 20);
192: --
193: Exception
194: When hr_api.check_integrity_violated Then
195: -- A check constraint has been violated
196: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
197: --
198: irc_isc_shd.constraint_error

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

195: -- A check constraint has been violated
196: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
197: --
198: irc_isc_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.parent_integrity_violated Then
201: -- Parent integrity has been violated
202: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
203: --

Line 200: When hr_api.parent_integrity_violated Then

196: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
197: --
198: irc_isc_shd.constraint_error
199: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
200: When hr_api.parent_integrity_violated Then
201: -- Parent integrity has been violated
202: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
203: --
204: irc_isc_shd.constraint_error

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

201: -- Parent integrity has been violated
202: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
203: --
204: irc_isc_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.unique_integrity_violated Then
207: -- Unique integrity has been violated
208: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
209: --

Line 206: When hr_api.unique_integrity_violated Then

202: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
203: --
204: irc_isc_shd.constraint_error
205: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
206: When hr_api.unique_integrity_violated Then
207: -- Unique integrity has been violated
208: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
209: --
210: irc_isc_shd.constraint_error

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

207: -- Unique integrity has been violated
208: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
209: --
210: irc_isc_shd.constraint_error
211: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
212: When Others Then
213: irc_isc_shd.g_api_dml := false; -- Unset the api dml status
214: --
215: Raise;

Line 693: when hr_api.cannot_find_prog_unit then

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

Line 695: hr_api.cannot_find_prog_unit_error

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

Line 758: If (p_rec.object_id = hr_api.g_number) then

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

Line 762: If (p_rec.object_type = hr_api.g_varchar2) then

758: If (p_rec.object_id = hr_api.g_number) then
759: p_rec.object_id :=
760: irc_isc_shd.g_old_rec.object_id;
761: End If;
762: If (p_rec.object_type = hr_api.g_varchar2) then
763: p_rec.object_type :=
764: irc_isc_shd.g_old_rec.object_type;
765: End If;
766: If (p_rec.search_name = hr_api.g_varchar2) then

Line 766: If (p_rec.search_name = hr_api.g_varchar2) then

762: If (p_rec.object_type = hr_api.g_varchar2) then
763: p_rec.object_type :=
764: irc_isc_shd.g_old_rec.object_type;
765: End If;
766: If (p_rec.search_name = hr_api.g_varchar2) then
767: p_rec.search_name :=
768: irc_isc_shd.g_old_rec.search_name;
769: End If;
770: If (p_rec.search_type = hr_api.g_varchar2) then

Line 770: If (p_rec.search_type = hr_api.g_varchar2) then

766: If (p_rec.search_name = hr_api.g_varchar2) then
767: p_rec.search_name :=
768: irc_isc_shd.g_old_rec.search_name;
769: End If;
770: If (p_rec.search_type = hr_api.g_varchar2) then
771: p_rec.search_type :=
772: irc_isc_shd.g_old_rec.search_type;
773: End If;
774: If (p_rec.location = hr_api.g_varchar2) then

Line 774: If (p_rec.location = hr_api.g_varchar2) then

770: If (p_rec.search_type = hr_api.g_varchar2) then
771: p_rec.search_type :=
772: irc_isc_shd.g_old_rec.search_type;
773: End If;
774: If (p_rec.location = hr_api.g_varchar2) then
775: p_rec.location :=
776: irc_isc_shd.g_old_rec.location;
777: End If;
778: If (p_rec.distance_to_location = hr_api.g_varchar2) then

Line 778: If (p_rec.distance_to_location = hr_api.g_varchar2) then

774: If (p_rec.location = hr_api.g_varchar2) then
775: p_rec.location :=
776: irc_isc_shd.g_old_rec.location;
777: End If;
778: If (p_rec.distance_to_location = hr_api.g_varchar2) then
779: p_rec.distance_to_location :=
780: irc_isc_shd.g_old_rec.distance_to_location;
781: End If;
782: If (p_rec.geocode_location = hr_api.g_varchar2) then

Line 782: If (p_rec.geocode_location = hr_api.g_varchar2) then

778: If (p_rec.distance_to_location = hr_api.g_varchar2) then
779: p_rec.distance_to_location :=
780: irc_isc_shd.g_old_rec.distance_to_location;
781: End If;
782: If (p_rec.geocode_location = hr_api.g_varchar2) then
783: p_rec.geocode_location :=
784: irc_isc_shd.g_old_rec.geocode_location;
785: End If;
786: If (p_rec.geocode_country = hr_api.g_varchar2) then

Line 786: If (p_rec.geocode_country = hr_api.g_varchar2) then

782: If (p_rec.geocode_location = hr_api.g_varchar2) then
783: p_rec.geocode_location :=
784: irc_isc_shd.g_old_rec.geocode_location;
785: End If;
786: If (p_rec.geocode_country = hr_api.g_varchar2) then
787: p_rec.geocode_country :=
788: irc_isc_shd.g_old_rec.geocode_country;
789: End If;
790: If (p_rec.derived_location = hr_api.g_varchar2) then

Line 790: If (p_rec.derived_location = hr_api.g_varchar2) then

786: If (p_rec.geocode_country = hr_api.g_varchar2) then
787: p_rec.geocode_country :=
788: irc_isc_shd.g_old_rec.geocode_country;
789: End If;
790: If (p_rec.derived_location = hr_api.g_varchar2) then
791: p_rec.derived_location :=
792: irc_isc_shd.g_old_rec.derived_location;
793: End If;
794: If (p_rec.location_id = hr_api.g_number) then

Line 794: If (p_rec.location_id = hr_api.g_number) then

790: If (p_rec.derived_location = hr_api.g_varchar2) then
791: p_rec.derived_location :=
792: irc_isc_shd.g_old_rec.derived_location;
793: End If;
794: If (p_rec.location_id = hr_api.g_number) then
795: p_rec.location_id :=
796: irc_isc_shd.g_old_rec.location_id;
797: End If;
798: If (p_rec.longitude = hr_api.g_number) then

Line 798: If (p_rec.longitude = hr_api.g_number) then

794: If (p_rec.location_id = hr_api.g_number) then
795: p_rec.location_id :=
796: irc_isc_shd.g_old_rec.location_id;
797: End If;
798: If (p_rec.longitude = hr_api.g_number) then
799: p_rec.longitude :=
800: irc_isc_shd.g_old_rec.longitude;
801: End If;
802: If (p_rec.latitude = hr_api.g_number) then

Line 802: If (p_rec.latitude = hr_api.g_number) then

798: If (p_rec.longitude = hr_api.g_number) then
799: p_rec.longitude :=
800: irc_isc_shd.g_old_rec.longitude;
801: End If;
802: If (p_rec.latitude = hr_api.g_number) then
803: p_rec.latitude :=
804: irc_isc_shd.g_old_rec.latitude;
805: End If;
806: If (p_rec.employee = hr_api.g_varchar2) then

Line 806: If (p_rec.employee = hr_api.g_varchar2) then

802: If (p_rec.latitude = hr_api.g_number) then
803: p_rec.latitude :=
804: irc_isc_shd.g_old_rec.latitude;
805: End If;
806: If (p_rec.employee = hr_api.g_varchar2) then
807: p_rec.employee :=
808: irc_isc_shd.g_old_rec.employee;
809: End If;
810: If (p_rec.contractor = hr_api.g_varchar2) then

Line 810: If (p_rec.contractor = hr_api.g_varchar2) then

806: If (p_rec.employee = hr_api.g_varchar2) then
807: p_rec.employee :=
808: irc_isc_shd.g_old_rec.employee;
809: End If;
810: If (p_rec.contractor = hr_api.g_varchar2) then
811: p_rec.contractor :=
812: irc_isc_shd.g_old_rec.contractor;
813: End If;
814: If (p_rec.employment_category = hr_api.g_varchar2) then

Line 814: If (p_rec.employment_category = hr_api.g_varchar2) then

810: If (p_rec.contractor = hr_api.g_varchar2) then
811: p_rec.contractor :=
812: irc_isc_shd.g_old_rec.contractor;
813: End If;
814: If (p_rec.employment_category = hr_api.g_varchar2) then
815: p_rec.employment_category :=
816: irc_isc_shd.g_old_rec.employment_category;
817: End If;
818: If (p_rec.keywords = hr_api.g_varchar2) then

Line 818: If (p_rec.keywords = hr_api.g_varchar2) then

814: If (p_rec.employment_category = hr_api.g_varchar2) then
815: p_rec.employment_category :=
816: irc_isc_shd.g_old_rec.employment_category;
817: End If;
818: If (p_rec.keywords = hr_api.g_varchar2) then
819: p_rec.keywords :=
820: irc_isc_shd.g_old_rec.keywords;
821: End If;
822: If (p_rec.travel_percentage = hr_api.g_number) then

Line 822: If (p_rec.travel_percentage = hr_api.g_number) then

818: If (p_rec.keywords = hr_api.g_varchar2) then
819: p_rec.keywords :=
820: irc_isc_shd.g_old_rec.keywords;
821: End If;
822: If (p_rec.travel_percentage = hr_api.g_number) then
823: p_rec.travel_percentage :=
824: irc_isc_shd.g_old_rec.travel_percentage;
825: End If;
826: If (p_rec.min_salary = hr_api.g_number) then

Line 826: If (p_rec.min_salary = hr_api.g_number) then

822: If (p_rec.travel_percentage = hr_api.g_number) then
823: p_rec.travel_percentage :=
824: irc_isc_shd.g_old_rec.travel_percentage;
825: End If;
826: If (p_rec.min_salary = hr_api.g_number) then
827: p_rec.min_salary :=
828: irc_isc_shd.g_old_rec.min_salary;
829: End If;
830: If (p_rec.max_salary = hr_api.g_number) then

Line 830: If (p_rec.max_salary = hr_api.g_number) then

826: If (p_rec.min_salary = hr_api.g_number) then
827: p_rec.min_salary :=
828: irc_isc_shd.g_old_rec.min_salary;
829: End If;
830: If (p_rec.max_salary = hr_api.g_number) then
831: p_rec.max_salary :=
832: irc_isc_shd.g_old_rec.max_salary;
833: End If;
834: If (p_rec.salary_currency = hr_api.g_varchar2) then

Line 834: If (p_rec.salary_currency = hr_api.g_varchar2) then

830: If (p_rec.max_salary = hr_api.g_number) then
831: p_rec.max_salary :=
832: irc_isc_shd.g_old_rec.max_salary;
833: End If;
834: If (p_rec.salary_currency = hr_api.g_varchar2) then
835: p_rec.salary_currency :=
836: irc_isc_shd.g_old_rec.salary_currency;
837: End If;
838: If (p_rec.salary_period = hr_api.g_varchar2) then

Line 838: If (p_rec.salary_period = hr_api.g_varchar2) then

834: If (p_rec.salary_currency = hr_api.g_varchar2) then
835: p_rec.salary_currency :=
836: irc_isc_shd.g_old_rec.salary_currency;
837: End If;
838: If (p_rec.salary_period = hr_api.g_varchar2) then
839: p_rec.salary_period :=
840: irc_isc_shd.g_old_rec.salary_period;
841: End If;
842: If (p_rec.match_competence = hr_api.g_varchar2) then

Line 842: If (p_rec.match_competence = hr_api.g_varchar2) then

838: If (p_rec.salary_period = hr_api.g_varchar2) then
839: p_rec.salary_period :=
840: irc_isc_shd.g_old_rec.salary_period;
841: End If;
842: If (p_rec.match_competence = hr_api.g_varchar2) then
843: p_rec.match_competence :=
844: irc_isc_shd.g_old_rec.match_competence;
845: End If;
846: If (p_rec.match_qualification = hr_api.g_varchar2) then

Line 846: If (p_rec.match_qualification = hr_api.g_varchar2) then

842: If (p_rec.match_competence = hr_api.g_varchar2) then
843: p_rec.match_competence :=
844: irc_isc_shd.g_old_rec.match_competence;
845: End If;
846: If (p_rec.match_qualification = hr_api.g_varchar2) then
847: p_rec.match_qualification :=
848: irc_isc_shd.g_old_rec.match_qualification;
849: End If;
850: If (p_rec.job_title = hr_api.g_varchar2) then

Line 850: If (p_rec.job_title = hr_api.g_varchar2) then

846: If (p_rec.match_qualification = hr_api.g_varchar2) then
847: p_rec.match_qualification :=
848: irc_isc_shd.g_old_rec.match_qualification;
849: End If;
850: If (p_rec.job_title = hr_api.g_varchar2) then
851: p_rec.job_title :=
852: irc_isc_shd.g_old_rec.job_title;
853: End If;
854: If (p_rec.department = hr_api.g_varchar2) then

Line 854: If (p_rec.department = hr_api.g_varchar2) then

850: If (p_rec.job_title = hr_api.g_varchar2) then
851: p_rec.job_title :=
852: irc_isc_shd.g_old_rec.job_title;
853: End If;
854: If (p_rec.department = hr_api.g_varchar2) then
855: p_rec.department :=
856: irc_isc_shd.g_old_rec.department;
857: End If;
858: If (p_rec.professional_area = hr_api.g_varchar2) then

Line 858: If (p_rec.professional_area = hr_api.g_varchar2) then

854: If (p_rec.department = hr_api.g_varchar2) then
855: p_rec.department :=
856: irc_isc_shd.g_old_rec.department;
857: End If;
858: If (p_rec.professional_area = hr_api.g_varchar2) then
859: p_rec.professional_area :=
860: irc_isc_shd.g_old_rec.professional_area;
861: End If;
862: If (p_rec.work_at_home = hr_api.g_varchar2) then

Line 862: If (p_rec.work_at_home = hr_api.g_varchar2) then

858: If (p_rec.professional_area = hr_api.g_varchar2) then
859: p_rec.professional_area :=
860: irc_isc_shd.g_old_rec.professional_area;
861: End If;
862: If (p_rec.work_at_home = hr_api.g_varchar2) then
863: p_rec.work_at_home :=
864: irc_isc_shd.g_old_rec.work_at_home;
865: End If;
866: If (p_rec.min_qual_level = hr_api.g_number) then

Line 866: If (p_rec.min_qual_level = hr_api.g_number) then

862: If (p_rec.work_at_home = hr_api.g_varchar2) then
863: p_rec.work_at_home :=
864: irc_isc_shd.g_old_rec.work_at_home;
865: End If;
866: If (p_rec.min_qual_level = hr_api.g_number) then
867: p_rec.min_qual_level :=
868: irc_isc_shd.g_old_rec.min_qual_level;
869: End If;
870: If (p_rec.max_qual_level = hr_api.g_number) then

Line 870: If (p_rec.max_qual_level = hr_api.g_number) then

866: If (p_rec.min_qual_level = hr_api.g_number) then
867: p_rec.min_qual_level :=
868: irc_isc_shd.g_old_rec.min_qual_level;
869: End If;
870: If (p_rec.max_qual_level = hr_api.g_number) then
871: p_rec.max_qual_level :=
872: irc_isc_shd.g_old_rec.max_qual_level;
873: End If;
874: If (p_rec.use_for_matching = hr_api.g_varchar2) then

Line 874: If (p_rec.use_for_matching = hr_api.g_varchar2) then

870: If (p_rec.max_qual_level = hr_api.g_number) then
871: p_rec.max_qual_level :=
872: irc_isc_shd.g_old_rec.max_qual_level;
873: End If;
874: If (p_rec.use_for_matching = hr_api.g_varchar2) then
875: p_rec.use_for_matching :=
876: irc_isc_shd.g_old_rec.use_for_matching;
877: End If;
878: If (p_rec.description = hr_api.g_varchar2) then

Line 878: If (p_rec.description = hr_api.g_varchar2) then

874: If (p_rec.use_for_matching = hr_api.g_varchar2) then
875: p_rec.use_for_matching :=
876: irc_isc_shd.g_old_rec.use_for_matching;
877: End If;
878: If (p_rec.description = hr_api.g_varchar2) then
879: p_rec.description :=
880: irc_isc_shd.g_old_rec.description;
881: g_description:=false;
882: Else

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

881: g_description:=false;
882: Else
883: g_description:=true;
884: End If;
885: If (p_rec.attribute_category = hr_api.g_varchar2) then
886: p_rec.attribute_category :=
887: irc_isc_shd.g_old_rec.attribute_category;
888: End If;
889: If (p_rec.attribute1 = hr_api.g_varchar2) then

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

885: If (p_rec.attribute_category = hr_api.g_varchar2) then
886: p_rec.attribute_category :=
887: irc_isc_shd.g_old_rec.attribute_category;
888: End If;
889: If (p_rec.attribute1 = hr_api.g_varchar2) then
890: p_rec.attribute1 :=
891: irc_isc_shd.g_old_rec.attribute1;
892: End If;
893: If (p_rec.attribute2 = hr_api.g_varchar2) then

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

889: If (p_rec.attribute1 = hr_api.g_varchar2) then
890: p_rec.attribute1 :=
891: irc_isc_shd.g_old_rec.attribute1;
892: End If;
893: If (p_rec.attribute2 = hr_api.g_varchar2) then
894: p_rec.attribute2 :=
895: irc_isc_shd.g_old_rec.attribute2;
896: End If;
897: If (p_rec.attribute3 = hr_api.g_varchar2) then

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

893: If (p_rec.attribute2 = hr_api.g_varchar2) then
894: p_rec.attribute2 :=
895: irc_isc_shd.g_old_rec.attribute2;
896: End If;
897: If (p_rec.attribute3 = hr_api.g_varchar2) then
898: p_rec.attribute3 :=
899: irc_isc_shd.g_old_rec.attribute3;
900: End If;
901: If (p_rec.attribute4 = hr_api.g_varchar2) then

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

897: If (p_rec.attribute3 = hr_api.g_varchar2) then
898: p_rec.attribute3 :=
899: irc_isc_shd.g_old_rec.attribute3;
900: End If;
901: If (p_rec.attribute4 = hr_api.g_varchar2) then
902: p_rec.attribute4 :=
903: irc_isc_shd.g_old_rec.attribute4;
904: End If;
905: If (p_rec.attribute5 = hr_api.g_varchar2) then

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

901: If (p_rec.attribute4 = hr_api.g_varchar2) then
902: p_rec.attribute4 :=
903: irc_isc_shd.g_old_rec.attribute4;
904: End If;
905: If (p_rec.attribute5 = hr_api.g_varchar2) then
906: p_rec.attribute5 :=
907: irc_isc_shd.g_old_rec.attribute5;
908: End If;
909: If (p_rec.attribute6 = hr_api.g_varchar2) then

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

905: If (p_rec.attribute5 = hr_api.g_varchar2) then
906: p_rec.attribute5 :=
907: irc_isc_shd.g_old_rec.attribute5;
908: End If;
909: If (p_rec.attribute6 = hr_api.g_varchar2) then
910: p_rec.attribute6 :=
911: irc_isc_shd.g_old_rec.attribute6;
912: End If;
913: If (p_rec.attribute7 = hr_api.g_varchar2) then

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

909: If (p_rec.attribute6 = hr_api.g_varchar2) then
910: p_rec.attribute6 :=
911: irc_isc_shd.g_old_rec.attribute6;
912: End If;
913: If (p_rec.attribute7 = hr_api.g_varchar2) then
914: p_rec.attribute7 :=
915: irc_isc_shd.g_old_rec.attribute7;
916: End If;
917: If (p_rec.attribute8 = hr_api.g_varchar2) then

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

913: If (p_rec.attribute7 = hr_api.g_varchar2) then
914: p_rec.attribute7 :=
915: irc_isc_shd.g_old_rec.attribute7;
916: End If;
917: If (p_rec.attribute8 = hr_api.g_varchar2) then
918: p_rec.attribute8 :=
919: irc_isc_shd.g_old_rec.attribute8;
920: End If;
921: If (p_rec.attribute9 = hr_api.g_varchar2) then

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

917: If (p_rec.attribute8 = hr_api.g_varchar2) then
918: p_rec.attribute8 :=
919: irc_isc_shd.g_old_rec.attribute8;
920: End If;
921: If (p_rec.attribute9 = hr_api.g_varchar2) then
922: p_rec.attribute9 :=
923: irc_isc_shd.g_old_rec.attribute9;
924: End If;
925: If (p_rec.attribute10 = hr_api.g_varchar2) then

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

921: If (p_rec.attribute9 = hr_api.g_varchar2) then
922: p_rec.attribute9 :=
923: irc_isc_shd.g_old_rec.attribute9;
924: End If;
925: If (p_rec.attribute10 = hr_api.g_varchar2) then
926: p_rec.attribute10 :=
927: irc_isc_shd.g_old_rec.attribute10;
928: End If;
929: If (p_rec.attribute11 = hr_api.g_varchar2) then

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

925: If (p_rec.attribute10 = hr_api.g_varchar2) then
926: p_rec.attribute10 :=
927: irc_isc_shd.g_old_rec.attribute10;
928: End If;
929: If (p_rec.attribute11 = hr_api.g_varchar2) then
930: p_rec.attribute11 :=
931: irc_isc_shd.g_old_rec.attribute11;
932: End If;
933: If (p_rec.attribute12 = hr_api.g_varchar2) then

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

929: If (p_rec.attribute11 = hr_api.g_varchar2) then
930: p_rec.attribute11 :=
931: irc_isc_shd.g_old_rec.attribute11;
932: End If;
933: If (p_rec.attribute12 = hr_api.g_varchar2) then
934: p_rec.attribute12 :=
935: irc_isc_shd.g_old_rec.attribute12;
936: End If;
937: If (p_rec.attribute13 = hr_api.g_varchar2) then

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

933: If (p_rec.attribute12 = hr_api.g_varchar2) then
934: p_rec.attribute12 :=
935: irc_isc_shd.g_old_rec.attribute12;
936: End If;
937: If (p_rec.attribute13 = hr_api.g_varchar2) then
938: p_rec.attribute13 :=
939: irc_isc_shd.g_old_rec.attribute13;
940: End If;
941: If (p_rec.attribute14 = hr_api.g_varchar2) then

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

937: If (p_rec.attribute13 = hr_api.g_varchar2) then
938: p_rec.attribute13 :=
939: irc_isc_shd.g_old_rec.attribute13;
940: End If;
941: If (p_rec.attribute14 = hr_api.g_varchar2) then
942: p_rec.attribute14 :=
943: irc_isc_shd.g_old_rec.attribute14;
944: End If;
945: If (p_rec.attribute15 = hr_api.g_varchar2) then

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

941: If (p_rec.attribute14 = hr_api.g_varchar2) then
942: p_rec.attribute14 :=
943: irc_isc_shd.g_old_rec.attribute14;
944: End If;
945: If (p_rec.attribute15 = hr_api.g_varchar2) then
946: p_rec.attribute15 :=
947: irc_isc_shd.g_old_rec.attribute15;
948: End If;
949: If (p_rec.attribute16 = hr_api.g_varchar2) then

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

945: If (p_rec.attribute15 = hr_api.g_varchar2) then
946: p_rec.attribute15 :=
947: irc_isc_shd.g_old_rec.attribute15;
948: End If;
949: If (p_rec.attribute16 = hr_api.g_varchar2) then
950: p_rec.attribute16 :=
951: irc_isc_shd.g_old_rec.attribute16;
952: End If;
953: If (p_rec.attribute17 = hr_api.g_varchar2) then

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

949: If (p_rec.attribute16 = hr_api.g_varchar2) then
950: p_rec.attribute16 :=
951: irc_isc_shd.g_old_rec.attribute16;
952: End If;
953: If (p_rec.attribute17 = hr_api.g_varchar2) then
954: p_rec.attribute17 :=
955: irc_isc_shd.g_old_rec.attribute17;
956: End If;
957: If (p_rec.attribute18 = hr_api.g_varchar2) then

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

953: If (p_rec.attribute17 = hr_api.g_varchar2) then
954: p_rec.attribute17 :=
955: irc_isc_shd.g_old_rec.attribute17;
956: End If;
957: If (p_rec.attribute18 = hr_api.g_varchar2) then
958: p_rec.attribute18 :=
959: irc_isc_shd.g_old_rec.attribute18;
960: End If;
961: If (p_rec.attribute19 = hr_api.g_varchar2) then

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

957: If (p_rec.attribute18 = hr_api.g_varchar2) then
958: p_rec.attribute18 :=
959: irc_isc_shd.g_old_rec.attribute18;
960: End If;
961: If (p_rec.attribute19 = hr_api.g_varchar2) then
962: p_rec.attribute19 :=
963: irc_isc_shd.g_old_rec.attribute19;
964: End If;
965: If (p_rec.attribute20 = hr_api.g_varchar2) then

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

961: If (p_rec.attribute19 = hr_api.g_varchar2) then
962: p_rec.attribute19 :=
963: irc_isc_shd.g_old_rec.attribute19;
964: End If;
965: If (p_rec.attribute20 = hr_api.g_varchar2) then
966: p_rec.attribute20 :=
967: irc_isc_shd.g_old_rec.attribute20;
968: End If;
969: If (p_rec.attribute21 = hr_api.g_varchar2) then

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

965: If (p_rec.attribute20 = hr_api.g_varchar2) then
966: p_rec.attribute20 :=
967: irc_isc_shd.g_old_rec.attribute20;
968: End If;
969: If (p_rec.attribute21 = hr_api.g_varchar2) then
970: p_rec.attribute21 :=
971: irc_isc_shd.g_old_rec.attribute21;
972: End If;
973: If (p_rec.attribute22 = hr_api.g_varchar2) then

Line 973: If (p_rec.attribute22 = hr_api.g_varchar2) then

969: If (p_rec.attribute21 = hr_api.g_varchar2) then
970: p_rec.attribute21 :=
971: irc_isc_shd.g_old_rec.attribute21;
972: End If;
973: If (p_rec.attribute22 = hr_api.g_varchar2) then
974: p_rec.attribute22 :=
975: irc_isc_shd.g_old_rec.attribute22;
976: End If;
977: If (p_rec.attribute23 = hr_api.g_varchar2) then

Line 977: If (p_rec.attribute23 = hr_api.g_varchar2) then

973: If (p_rec.attribute22 = hr_api.g_varchar2) then
974: p_rec.attribute22 :=
975: irc_isc_shd.g_old_rec.attribute22;
976: End If;
977: If (p_rec.attribute23 = hr_api.g_varchar2) then
978: p_rec.attribute23 :=
979: irc_isc_shd.g_old_rec.attribute23;
980: End If;
981: If (p_rec.attribute24 = hr_api.g_varchar2) then

Line 981: If (p_rec.attribute24 = hr_api.g_varchar2) then

977: If (p_rec.attribute23 = hr_api.g_varchar2) then
978: p_rec.attribute23 :=
979: irc_isc_shd.g_old_rec.attribute23;
980: End If;
981: If (p_rec.attribute24 = hr_api.g_varchar2) then
982: p_rec.attribute24 :=
983: irc_isc_shd.g_old_rec.attribute24;
984: End If;
985: If (p_rec.attribute25 = hr_api.g_varchar2) then

Line 985: If (p_rec.attribute25 = hr_api.g_varchar2) then

981: If (p_rec.attribute24 = hr_api.g_varchar2) then
982: p_rec.attribute24 :=
983: irc_isc_shd.g_old_rec.attribute24;
984: End If;
985: If (p_rec.attribute25 = hr_api.g_varchar2) then
986: p_rec.attribute25 :=
987: irc_isc_shd.g_old_rec.attribute25;
988: End If;
989: If (p_rec.attribute26 = hr_api.g_varchar2) then

Line 989: If (p_rec.attribute26 = hr_api.g_varchar2) then

985: If (p_rec.attribute25 = hr_api.g_varchar2) then
986: p_rec.attribute25 :=
987: irc_isc_shd.g_old_rec.attribute25;
988: End If;
989: If (p_rec.attribute26 = hr_api.g_varchar2) then
990: p_rec.attribute26 :=
991: irc_isc_shd.g_old_rec.attribute26;
992: End If;
993: If (p_rec.attribute27 = hr_api.g_varchar2) then

Line 993: If (p_rec.attribute27 = hr_api.g_varchar2) then

989: If (p_rec.attribute26 = hr_api.g_varchar2) then
990: p_rec.attribute26 :=
991: irc_isc_shd.g_old_rec.attribute26;
992: End If;
993: If (p_rec.attribute27 = hr_api.g_varchar2) then
994: p_rec.attribute27 :=
995: irc_isc_shd.g_old_rec.attribute27;
996: End If;
997: If (p_rec.attribute28 = hr_api.g_varchar2) then

Line 997: If (p_rec.attribute28 = hr_api.g_varchar2) then

993: If (p_rec.attribute27 = hr_api.g_varchar2) then
994: p_rec.attribute27 :=
995: irc_isc_shd.g_old_rec.attribute27;
996: End If;
997: If (p_rec.attribute28 = hr_api.g_varchar2) then
998: p_rec.attribute28 :=
999: irc_isc_shd.g_old_rec.attribute28;
1000: End If;
1001: If (p_rec.attribute29 = hr_api.g_varchar2) then

Line 1001: If (p_rec.attribute29 = hr_api.g_varchar2) then

997: If (p_rec.attribute28 = hr_api.g_varchar2) then
998: p_rec.attribute28 :=
999: irc_isc_shd.g_old_rec.attribute28;
1000: End If;
1001: If (p_rec.attribute29 = hr_api.g_varchar2) then
1002: p_rec.attribute29 :=
1003: irc_isc_shd.g_old_rec.attribute29;
1004: End If;
1005: If (p_rec.attribute30 = hr_api.g_varchar2) then

Line 1005: If (p_rec.attribute30 = hr_api.g_varchar2) then

1001: If (p_rec.attribute29 = hr_api.g_varchar2) then
1002: p_rec.attribute29 :=
1003: irc_isc_shd.g_old_rec.attribute29;
1004: End If;
1005: If (p_rec.attribute30 = hr_api.g_varchar2) then
1006: p_rec.attribute30 :=
1007: irc_isc_shd.g_old_rec.attribute30;
1008: End If;
1009: If (p_rec.isc_information_category = hr_api.g_varchar2) then

Line 1009: If (p_rec.isc_information_category = hr_api.g_varchar2) then

1005: If (p_rec.attribute30 = hr_api.g_varchar2) then
1006: p_rec.attribute30 :=
1007: irc_isc_shd.g_old_rec.attribute30;
1008: End If;
1009: If (p_rec.isc_information_category = hr_api.g_varchar2) then
1010: p_rec.isc_information_category :=
1011: irc_isc_shd.g_old_rec.isc_information_category;
1012: End If;
1013: If (p_rec.isc_information1 = hr_api.g_varchar2) then

Line 1013: If (p_rec.isc_information1 = hr_api.g_varchar2) then

1009: If (p_rec.isc_information_category = hr_api.g_varchar2) then
1010: p_rec.isc_information_category :=
1011: irc_isc_shd.g_old_rec.isc_information_category;
1012: End If;
1013: If (p_rec.isc_information1 = hr_api.g_varchar2) then
1014: p_rec.isc_information1 :=
1015: irc_isc_shd.g_old_rec.isc_information1;
1016: End If;
1017: If (p_rec.isc_information2 = hr_api.g_varchar2) then

Line 1017: If (p_rec.isc_information2 = hr_api.g_varchar2) then

1013: If (p_rec.isc_information1 = hr_api.g_varchar2) then
1014: p_rec.isc_information1 :=
1015: irc_isc_shd.g_old_rec.isc_information1;
1016: End If;
1017: If (p_rec.isc_information2 = hr_api.g_varchar2) then
1018: p_rec.isc_information2 :=
1019: irc_isc_shd.g_old_rec.isc_information2;
1020: End If;
1021: If (p_rec.isc_information3 = hr_api.g_varchar2) then

Line 1021: If (p_rec.isc_information3 = hr_api.g_varchar2) then

1017: If (p_rec.isc_information2 = hr_api.g_varchar2) then
1018: p_rec.isc_information2 :=
1019: irc_isc_shd.g_old_rec.isc_information2;
1020: End If;
1021: If (p_rec.isc_information3 = hr_api.g_varchar2) then
1022: p_rec.isc_information3 :=
1023: irc_isc_shd.g_old_rec.isc_information3;
1024: End If;
1025: If (p_rec.isc_information4 = hr_api.g_varchar2) then

Line 1025: If (p_rec.isc_information4 = hr_api.g_varchar2) then

1021: If (p_rec.isc_information3 = hr_api.g_varchar2) then
1022: p_rec.isc_information3 :=
1023: irc_isc_shd.g_old_rec.isc_information3;
1024: End If;
1025: If (p_rec.isc_information4 = hr_api.g_varchar2) then
1026: p_rec.isc_information4 :=
1027: irc_isc_shd.g_old_rec.isc_information4;
1028: End If;
1029: If (p_rec.isc_information5 = hr_api.g_varchar2) then

Line 1029: If (p_rec.isc_information5 = hr_api.g_varchar2) then

1025: If (p_rec.isc_information4 = hr_api.g_varchar2) then
1026: p_rec.isc_information4 :=
1027: irc_isc_shd.g_old_rec.isc_information4;
1028: End If;
1029: If (p_rec.isc_information5 = hr_api.g_varchar2) then
1030: p_rec.isc_information5 :=
1031: irc_isc_shd.g_old_rec.isc_information5;
1032: End If;
1033: If (p_rec.isc_information6 = hr_api.g_varchar2) then

Line 1033: If (p_rec.isc_information6 = hr_api.g_varchar2) then

1029: If (p_rec.isc_information5 = hr_api.g_varchar2) then
1030: p_rec.isc_information5 :=
1031: irc_isc_shd.g_old_rec.isc_information5;
1032: End If;
1033: If (p_rec.isc_information6 = hr_api.g_varchar2) then
1034: p_rec.isc_information6 :=
1035: irc_isc_shd.g_old_rec.isc_information6;
1036: End If;
1037: If (p_rec.isc_information7 = hr_api.g_varchar2) then

Line 1037: If (p_rec.isc_information7 = hr_api.g_varchar2) then

1033: If (p_rec.isc_information6 = hr_api.g_varchar2) then
1034: p_rec.isc_information6 :=
1035: irc_isc_shd.g_old_rec.isc_information6;
1036: End If;
1037: If (p_rec.isc_information7 = hr_api.g_varchar2) then
1038: p_rec.isc_information7 :=
1039: irc_isc_shd.g_old_rec.isc_information7;
1040: End If;
1041: If (p_rec.isc_information8 = hr_api.g_varchar2) then

Line 1041: If (p_rec.isc_information8 = hr_api.g_varchar2) then

1037: If (p_rec.isc_information7 = hr_api.g_varchar2) then
1038: p_rec.isc_information7 :=
1039: irc_isc_shd.g_old_rec.isc_information7;
1040: End If;
1041: If (p_rec.isc_information8 = hr_api.g_varchar2) then
1042: p_rec.isc_information8 :=
1043: irc_isc_shd.g_old_rec.isc_information8;
1044: End If;
1045: If (p_rec.isc_information9 = hr_api.g_varchar2) then

Line 1045: If (p_rec.isc_information9 = hr_api.g_varchar2) then

1041: If (p_rec.isc_information8 = hr_api.g_varchar2) then
1042: p_rec.isc_information8 :=
1043: irc_isc_shd.g_old_rec.isc_information8;
1044: End If;
1045: If (p_rec.isc_information9 = hr_api.g_varchar2) then
1046: p_rec.isc_information9 :=
1047: irc_isc_shd.g_old_rec.isc_information9;
1048: End If;
1049: If (p_rec.isc_information10 = hr_api.g_varchar2) then

Line 1049: If (p_rec.isc_information10 = hr_api.g_varchar2) then

1045: If (p_rec.isc_information9 = hr_api.g_varchar2) then
1046: p_rec.isc_information9 :=
1047: irc_isc_shd.g_old_rec.isc_information9;
1048: End If;
1049: If (p_rec.isc_information10 = hr_api.g_varchar2) then
1050: p_rec.isc_information10 :=
1051: irc_isc_shd.g_old_rec.isc_information10;
1052: End If;
1053: If (p_rec.isc_information11 = hr_api.g_varchar2) then

Line 1053: If (p_rec.isc_information11 = hr_api.g_varchar2) then

1049: If (p_rec.isc_information10 = hr_api.g_varchar2) then
1050: p_rec.isc_information10 :=
1051: irc_isc_shd.g_old_rec.isc_information10;
1052: End If;
1053: If (p_rec.isc_information11 = hr_api.g_varchar2) then
1054: p_rec.isc_information11 :=
1055: irc_isc_shd.g_old_rec.isc_information11;
1056: End If;
1057: If (p_rec.isc_information12 = hr_api.g_varchar2) then

Line 1057: If (p_rec.isc_information12 = hr_api.g_varchar2) then

1053: If (p_rec.isc_information11 = hr_api.g_varchar2) then
1054: p_rec.isc_information11 :=
1055: irc_isc_shd.g_old_rec.isc_information11;
1056: End If;
1057: If (p_rec.isc_information12 = hr_api.g_varchar2) then
1058: p_rec.isc_information12 :=
1059: irc_isc_shd.g_old_rec.isc_information12;
1060: End If;
1061: If (p_rec.isc_information13 = hr_api.g_varchar2) then

Line 1061: If (p_rec.isc_information13 = hr_api.g_varchar2) then

1057: If (p_rec.isc_information12 = hr_api.g_varchar2) then
1058: p_rec.isc_information12 :=
1059: irc_isc_shd.g_old_rec.isc_information12;
1060: End If;
1061: If (p_rec.isc_information13 = hr_api.g_varchar2) then
1062: p_rec.isc_information13 :=
1063: irc_isc_shd.g_old_rec.isc_information13;
1064: End If;
1065: If (p_rec.isc_information14 = hr_api.g_varchar2) then

Line 1065: If (p_rec.isc_information14 = hr_api.g_varchar2) then

1061: If (p_rec.isc_information13 = hr_api.g_varchar2) then
1062: p_rec.isc_information13 :=
1063: irc_isc_shd.g_old_rec.isc_information13;
1064: End If;
1065: If (p_rec.isc_information14 = hr_api.g_varchar2) then
1066: p_rec.isc_information14 :=
1067: irc_isc_shd.g_old_rec.isc_information14;
1068: End If;
1069: If (p_rec.isc_information15 = hr_api.g_varchar2) then

Line 1069: If (p_rec.isc_information15 = hr_api.g_varchar2) then

1065: If (p_rec.isc_information14 = hr_api.g_varchar2) then
1066: p_rec.isc_information14 :=
1067: irc_isc_shd.g_old_rec.isc_information14;
1068: End If;
1069: If (p_rec.isc_information15 = hr_api.g_varchar2) then
1070: p_rec.isc_information15 :=
1071: irc_isc_shd.g_old_rec.isc_information15;
1072: End If;
1073: If (p_rec.isc_information16 = hr_api.g_varchar2) then

Line 1073: If (p_rec.isc_information16 = hr_api.g_varchar2) then

1069: If (p_rec.isc_information15 = hr_api.g_varchar2) then
1070: p_rec.isc_information15 :=
1071: irc_isc_shd.g_old_rec.isc_information15;
1072: End If;
1073: If (p_rec.isc_information16 = hr_api.g_varchar2) then
1074: p_rec.isc_information16 :=
1075: irc_isc_shd.g_old_rec.isc_information16;
1076: End If;
1077: If (p_rec.isc_information17 = hr_api.g_varchar2) then

Line 1077: If (p_rec.isc_information17 = hr_api.g_varchar2) then

1073: If (p_rec.isc_information16 = hr_api.g_varchar2) then
1074: p_rec.isc_information16 :=
1075: irc_isc_shd.g_old_rec.isc_information16;
1076: End If;
1077: If (p_rec.isc_information17 = hr_api.g_varchar2) then
1078: p_rec.isc_information17 :=
1079: irc_isc_shd.g_old_rec.isc_information17;
1080: End If;
1081: If (p_rec.isc_information18 = hr_api.g_varchar2) then

Line 1081: If (p_rec.isc_information18 = hr_api.g_varchar2) then

1077: If (p_rec.isc_information17 = hr_api.g_varchar2) then
1078: p_rec.isc_information17 :=
1079: irc_isc_shd.g_old_rec.isc_information17;
1080: End If;
1081: If (p_rec.isc_information18 = hr_api.g_varchar2) then
1082: p_rec.isc_information18 :=
1083: irc_isc_shd.g_old_rec.isc_information18;
1084: End If;
1085: If (p_rec.isc_information19 = hr_api.g_varchar2) then

Line 1085: If (p_rec.isc_information19 = hr_api.g_varchar2) then

1081: If (p_rec.isc_information18 = hr_api.g_varchar2) then
1082: p_rec.isc_information18 :=
1083: irc_isc_shd.g_old_rec.isc_information18;
1084: End If;
1085: If (p_rec.isc_information19 = hr_api.g_varchar2) then
1086: p_rec.isc_information19 :=
1087: irc_isc_shd.g_old_rec.isc_information19;
1088: End If;
1089: If (p_rec.isc_information20 = hr_api.g_varchar2) then

Line 1089: If (p_rec.isc_information20 = hr_api.g_varchar2) then

1085: If (p_rec.isc_information19 = hr_api.g_varchar2) then
1086: p_rec.isc_information19 :=
1087: irc_isc_shd.g_old_rec.isc_information19;
1088: End If;
1089: If (p_rec.isc_information20 = hr_api.g_varchar2) then
1090: p_rec.isc_information20 :=
1091: irc_isc_shd.g_old_rec.isc_information20;
1092: End If;
1093: If (p_rec.isc_information21 = hr_api.g_varchar2) then

Line 1093: If (p_rec.isc_information21 = hr_api.g_varchar2) then

1089: If (p_rec.isc_information20 = hr_api.g_varchar2) then
1090: p_rec.isc_information20 :=
1091: irc_isc_shd.g_old_rec.isc_information20;
1092: End If;
1093: If (p_rec.isc_information21 = hr_api.g_varchar2) then
1094: p_rec.isc_information21 :=
1095: irc_isc_shd.g_old_rec.isc_information21;
1096: End If;
1097: If (p_rec.isc_information22 = hr_api.g_varchar2) then

Line 1097: If (p_rec.isc_information22 = hr_api.g_varchar2) then

1093: If (p_rec.isc_information21 = hr_api.g_varchar2) then
1094: p_rec.isc_information21 :=
1095: irc_isc_shd.g_old_rec.isc_information21;
1096: End If;
1097: If (p_rec.isc_information22 = hr_api.g_varchar2) then
1098: p_rec.isc_information22 :=
1099: irc_isc_shd.g_old_rec.isc_information22;
1100: End If;
1101: If (p_rec.isc_information23 = hr_api.g_varchar2) then

Line 1101: If (p_rec.isc_information23 = hr_api.g_varchar2) then

1097: If (p_rec.isc_information22 = hr_api.g_varchar2) then
1098: p_rec.isc_information22 :=
1099: irc_isc_shd.g_old_rec.isc_information22;
1100: End If;
1101: If (p_rec.isc_information23 = hr_api.g_varchar2) then
1102: p_rec.isc_information23 :=
1103: irc_isc_shd.g_old_rec.isc_information23;
1104: End If;
1105: If (p_rec.isc_information24 = hr_api.g_varchar2) then

Line 1105: If (p_rec.isc_information24 = hr_api.g_varchar2) then

1101: If (p_rec.isc_information23 = hr_api.g_varchar2) then
1102: p_rec.isc_information23 :=
1103: irc_isc_shd.g_old_rec.isc_information23;
1104: End If;
1105: If (p_rec.isc_information24 = hr_api.g_varchar2) then
1106: p_rec.isc_information24 :=
1107: irc_isc_shd.g_old_rec.isc_information24;
1108: End If;
1109: If (p_rec.isc_information25 = hr_api.g_varchar2) then

Line 1109: If (p_rec.isc_information25 = hr_api.g_varchar2) then

1105: If (p_rec.isc_information24 = hr_api.g_varchar2) then
1106: p_rec.isc_information24 :=
1107: irc_isc_shd.g_old_rec.isc_information24;
1108: End If;
1109: If (p_rec.isc_information25 = hr_api.g_varchar2) then
1110: p_rec.isc_information25 :=
1111: irc_isc_shd.g_old_rec.isc_information25;
1112: End If;
1113: If (p_rec.isc_information26 = hr_api.g_varchar2) then

Line 1113: If (p_rec.isc_information26 = hr_api.g_varchar2) then

1109: If (p_rec.isc_information25 = hr_api.g_varchar2) then
1110: p_rec.isc_information25 :=
1111: irc_isc_shd.g_old_rec.isc_information25;
1112: End If;
1113: If (p_rec.isc_information26 = hr_api.g_varchar2) then
1114: p_rec.isc_information26 :=
1115: irc_isc_shd.g_old_rec.isc_information26;
1116: End If;
1117: If (p_rec.isc_information27 = hr_api.g_varchar2) then

Line 1117: If (p_rec.isc_information27 = hr_api.g_varchar2) then

1113: If (p_rec.isc_information26 = hr_api.g_varchar2) then
1114: p_rec.isc_information26 :=
1115: irc_isc_shd.g_old_rec.isc_information26;
1116: End If;
1117: If (p_rec.isc_information27 = hr_api.g_varchar2) then
1118: p_rec.isc_information27 :=
1119: irc_isc_shd.g_old_rec.isc_information27;
1120: End If;
1121: If (p_rec.isc_information28 = hr_api.g_varchar2) then

Line 1121: If (p_rec.isc_information28 = hr_api.g_varchar2) then

1117: If (p_rec.isc_information27 = hr_api.g_varchar2) then
1118: p_rec.isc_information27 :=
1119: irc_isc_shd.g_old_rec.isc_information27;
1120: End If;
1121: If (p_rec.isc_information28 = hr_api.g_varchar2) then
1122: p_rec.isc_information28 :=
1123: irc_isc_shd.g_old_rec.isc_information28;
1124: End If;
1125: If (p_rec.isc_information29 = hr_api.g_varchar2) then

Line 1125: If (p_rec.isc_information29 = hr_api.g_varchar2) then

1121: If (p_rec.isc_information28 = hr_api.g_varchar2) then
1122: p_rec.isc_information28 :=
1123: irc_isc_shd.g_old_rec.isc_information28;
1124: End If;
1125: If (p_rec.isc_information29 = hr_api.g_varchar2) then
1126: p_rec.isc_information29 :=
1127: irc_isc_shd.g_old_rec.isc_information29;
1128: End If;
1129: If (p_rec.isc_information30 = hr_api.g_varchar2) then

Line 1129: If (p_rec.isc_information30 = hr_api.g_varchar2) then

1125: If (p_rec.isc_information29 = hr_api.g_varchar2) then
1126: p_rec.isc_information29 :=
1127: irc_isc_shd.g_old_rec.isc_information29;
1128: End If;
1129: If (p_rec.isc_information30 = hr_api.g_varchar2) then
1130: p_rec.isc_information30 :=
1131: irc_isc_shd.g_old_rec.isc_information30;
1132: End If;
1133: If (p_rec.date_posted = hr_api.g_varchar2) then

Line 1133: If (p_rec.date_posted = hr_api.g_varchar2) then

1129: If (p_rec.isc_information30 = hr_api.g_varchar2) then
1130: p_rec.isc_information30 :=
1131: irc_isc_shd.g_old_rec.isc_information30;
1132: End If;
1133: If (p_rec.date_posted = hr_api.g_varchar2) then
1134: p_rec.date_posted :=
1135: irc_isc_shd.g_old_rec.date_posted;
1136: End If;
1137: --

Line 1201: ,p_object_id in number default hr_api.g_number

1197: Procedure upd
1198: (p_effective_date in date
1199: ,p_search_criteria_id in number
1200: ,p_object_version_number in out nocopy number
1201: ,p_object_id in number default hr_api.g_number
1202: ,p_object_type in varchar2 default hr_api.g_varchar2
1203: ,p_search_name in varchar2 default hr_api.g_varchar2
1204: ,p_search_type in varchar2 default hr_api.g_varchar2
1205: ,p_location in varchar2 default hr_api.g_varchar2

Line 1202: ,p_object_type in varchar2 default hr_api.g_varchar2

1198: (p_effective_date in date
1199: ,p_search_criteria_id in number
1200: ,p_object_version_number in out nocopy number
1201: ,p_object_id in number default hr_api.g_number
1202: ,p_object_type in varchar2 default hr_api.g_varchar2
1203: ,p_search_name in varchar2 default hr_api.g_varchar2
1204: ,p_search_type in varchar2 default hr_api.g_varchar2
1205: ,p_location in varchar2 default hr_api.g_varchar2
1206: ,p_distance_to_location in varchar2 default hr_api.g_varchar2

Line 1203: ,p_search_name in varchar2 default hr_api.g_varchar2

1199: ,p_search_criteria_id in number
1200: ,p_object_version_number in out nocopy number
1201: ,p_object_id in number default hr_api.g_number
1202: ,p_object_type in varchar2 default hr_api.g_varchar2
1203: ,p_search_name in varchar2 default hr_api.g_varchar2
1204: ,p_search_type in varchar2 default hr_api.g_varchar2
1205: ,p_location in varchar2 default hr_api.g_varchar2
1206: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1207: ,p_geocode_location in varchar2 default hr_api.g_varchar2

Line 1204: ,p_search_type in varchar2 default hr_api.g_varchar2

1200: ,p_object_version_number in out nocopy number
1201: ,p_object_id in number default hr_api.g_number
1202: ,p_object_type in varchar2 default hr_api.g_varchar2
1203: ,p_search_name in varchar2 default hr_api.g_varchar2
1204: ,p_search_type in varchar2 default hr_api.g_varchar2
1205: ,p_location in varchar2 default hr_api.g_varchar2
1206: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1207: ,p_geocode_location in varchar2 default hr_api.g_varchar2
1208: ,p_geocode_country in varchar2 default hr_api.g_varchar2

Line 1205: ,p_location in varchar2 default hr_api.g_varchar2

1201: ,p_object_id in number default hr_api.g_number
1202: ,p_object_type in varchar2 default hr_api.g_varchar2
1203: ,p_search_name in varchar2 default hr_api.g_varchar2
1204: ,p_search_type in varchar2 default hr_api.g_varchar2
1205: ,p_location in varchar2 default hr_api.g_varchar2
1206: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1207: ,p_geocode_location in varchar2 default hr_api.g_varchar2
1208: ,p_geocode_country in varchar2 default hr_api.g_varchar2
1209: ,p_derived_location in varchar2 default hr_api.g_varchar2

Line 1206: ,p_distance_to_location in varchar2 default hr_api.g_varchar2

1202: ,p_object_type in varchar2 default hr_api.g_varchar2
1203: ,p_search_name in varchar2 default hr_api.g_varchar2
1204: ,p_search_type in varchar2 default hr_api.g_varchar2
1205: ,p_location in varchar2 default hr_api.g_varchar2
1206: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1207: ,p_geocode_location in varchar2 default hr_api.g_varchar2
1208: ,p_geocode_country in varchar2 default hr_api.g_varchar2
1209: ,p_derived_location in varchar2 default hr_api.g_varchar2
1210: ,p_location_id in number default hr_api.g_number

Line 1207: ,p_geocode_location in varchar2 default hr_api.g_varchar2

1203: ,p_search_name in varchar2 default hr_api.g_varchar2
1204: ,p_search_type in varchar2 default hr_api.g_varchar2
1205: ,p_location in varchar2 default hr_api.g_varchar2
1206: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1207: ,p_geocode_location in varchar2 default hr_api.g_varchar2
1208: ,p_geocode_country in varchar2 default hr_api.g_varchar2
1209: ,p_derived_location in varchar2 default hr_api.g_varchar2
1210: ,p_location_id in number default hr_api.g_number
1211: ,p_longitude in number default hr_api.g_number

Line 1208: ,p_geocode_country in varchar2 default hr_api.g_varchar2

1204: ,p_search_type in varchar2 default hr_api.g_varchar2
1205: ,p_location in varchar2 default hr_api.g_varchar2
1206: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1207: ,p_geocode_location in varchar2 default hr_api.g_varchar2
1208: ,p_geocode_country in varchar2 default hr_api.g_varchar2
1209: ,p_derived_location in varchar2 default hr_api.g_varchar2
1210: ,p_location_id in number default hr_api.g_number
1211: ,p_longitude in number default hr_api.g_number
1212: ,p_latitude in number default hr_api.g_number

Line 1209: ,p_derived_location in varchar2 default hr_api.g_varchar2

1205: ,p_location in varchar2 default hr_api.g_varchar2
1206: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1207: ,p_geocode_location in varchar2 default hr_api.g_varchar2
1208: ,p_geocode_country in varchar2 default hr_api.g_varchar2
1209: ,p_derived_location in varchar2 default hr_api.g_varchar2
1210: ,p_location_id in number default hr_api.g_number
1211: ,p_longitude in number default hr_api.g_number
1212: ,p_latitude in number default hr_api.g_number
1213: ,p_employee in varchar2 default hr_api.g_varchar2

Line 1210: ,p_location_id in number default hr_api.g_number

1206: ,p_distance_to_location in varchar2 default hr_api.g_varchar2
1207: ,p_geocode_location in varchar2 default hr_api.g_varchar2
1208: ,p_geocode_country in varchar2 default hr_api.g_varchar2
1209: ,p_derived_location in varchar2 default hr_api.g_varchar2
1210: ,p_location_id in number default hr_api.g_number
1211: ,p_longitude in number default hr_api.g_number
1212: ,p_latitude in number default hr_api.g_number
1213: ,p_employee in varchar2 default hr_api.g_varchar2
1214: ,p_contractor in varchar2 default hr_api.g_varchar2

Line 1211: ,p_longitude in number default hr_api.g_number

1207: ,p_geocode_location in varchar2 default hr_api.g_varchar2
1208: ,p_geocode_country in varchar2 default hr_api.g_varchar2
1209: ,p_derived_location in varchar2 default hr_api.g_varchar2
1210: ,p_location_id in number default hr_api.g_number
1211: ,p_longitude in number default hr_api.g_number
1212: ,p_latitude in number default hr_api.g_number
1213: ,p_employee in varchar2 default hr_api.g_varchar2
1214: ,p_contractor in varchar2 default hr_api.g_varchar2
1215: ,p_employment_category in varchar2 default hr_api.g_varchar2

Line 1212: ,p_latitude in number default hr_api.g_number

1208: ,p_geocode_country in varchar2 default hr_api.g_varchar2
1209: ,p_derived_location in varchar2 default hr_api.g_varchar2
1210: ,p_location_id in number default hr_api.g_number
1211: ,p_longitude in number default hr_api.g_number
1212: ,p_latitude in number default hr_api.g_number
1213: ,p_employee in varchar2 default hr_api.g_varchar2
1214: ,p_contractor in varchar2 default hr_api.g_varchar2
1215: ,p_employment_category in varchar2 default hr_api.g_varchar2
1216: ,p_keywords in varchar2 default hr_api.g_varchar2

Line 1213: ,p_employee in varchar2 default hr_api.g_varchar2

1209: ,p_derived_location in varchar2 default hr_api.g_varchar2
1210: ,p_location_id in number default hr_api.g_number
1211: ,p_longitude in number default hr_api.g_number
1212: ,p_latitude in number default hr_api.g_number
1213: ,p_employee in varchar2 default hr_api.g_varchar2
1214: ,p_contractor in varchar2 default hr_api.g_varchar2
1215: ,p_employment_category in varchar2 default hr_api.g_varchar2
1216: ,p_keywords in varchar2 default hr_api.g_varchar2
1217: ,p_travel_percentage in number default hr_api.g_number

Line 1214: ,p_contractor in varchar2 default hr_api.g_varchar2

1210: ,p_location_id in number default hr_api.g_number
1211: ,p_longitude in number default hr_api.g_number
1212: ,p_latitude in number default hr_api.g_number
1213: ,p_employee in varchar2 default hr_api.g_varchar2
1214: ,p_contractor in varchar2 default hr_api.g_varchar2
1215: ,p_employment_category in varchar2 default hr_api.g_varchar2
1216: ,p_keywords in varchar2 default hr_api.g_varchar2
1217: ,p_travel_percentage in number default hr_api.g_number
1218: ,p_min_salary in number default hr_api.g_number

Line 1215: ,p_employment_category in varchar2 default hr_api.g_varchar2

1211: ,p_longitude in number default hr_api.g_number
1212: ,p_latitude in number default hr_api.g_number
1213: ,p_employee in varchar2 default hr_api.g_varchar2
1214: ,p_contractor in varchar2 default hr_api.g_varchar2
1215: ,p_employment_category in varchar2 default hr_api.g_varchar2
1216: ,p_keywords in varchar2 default hr_api.g_varchar2
1217: ,p_travel_percentage in number default hr_api.g_number
1218: ,p_min_salary in number default hr_api.g_number
1219: ,p_max_salary in number default hr_api.g_number

Line 1216: ,p_keywords in varchar2 default hr_api.g_varchar2

1212: ,p_latitude in number default hr_api.g_number
1213: ,p_employee in varchar2 default hr_api.g_varchar2
1214: ,p_contractor in varchar2 default hr_api.g_varchar2
1215: ,p_employment_category in varchar2 default hr_api.g_varchar2
1216: ,p_keywords in varchar2 default hr_api.g_varchar2
1217: ,p_travel_percentage in number default hr_api.g_number
1218: ,p_min_salary in number default hr_api.g_number
1219: ,p_max_salary in number default hr_api.g_number
1220: ,p_salary_currency in varchar2 default hr_api.g_varchar2

Line 1217: ,p_travel_percentage in number default hr_api.g_number

1213: ,p_employee in varchar2 default hr_api.g_varchar2
1214: ,p_contractor in varchar2 default hr_api.g_varchar2
1215: ,p_employment_category in varchar2 default hr_api.g_varchar2
1216: ,p_keywords in varchar2 default hr_api.g_varchar2
1217: ,p_travel_percentage in number default hr_api.g_number
1218: ,p_min_salary in number default hr_api.g_number
1219: ,p_max_salary in number default hr_api.g_number
1220: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1221: ,p_salary_period in varchar2 default hr_api.g_varchar2

Line 1218: ,p_min_salary in number default hr_api.g_number

1214: ,p_contractor in varchar2 default hr_api.g_varchar2
1215: ,p_employment_category in varchar2 default hr_api.g_varchar2
1216: ,p_keywords in varchar2 default hr_api.g_varchar2
1217: ,p_travel_percentage in number default hr_api.g_number
1218: ,p_min_salary in number default hr_api.g_number
1219: ,p_max_salary in number default hr_api.g_number
1220: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1221: ,p_salary_period in varchar2 default hr_api.g_varchar2
1222: ,p_match_competence in varchar2 default hr_api.g_varchar2

Line 1219: ,p_max_salary in number default hr_api.g_number

1215: ,p_employment_category in varchar2 default hr_api.g_varchar2
1216: ,p_keywords in varchar2 default hr_api.g_varchar2
1217: ,p_travel_percentage in number default hr_api.g_number
1218: ,p_min_salary in number default hr_api.g_number
1219: ,p_max_salary in number default hr_api.g_number
1220: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1221: ,p_salary_period in varchar2 default hr_api.g_varchar2
1222: ,p_match_competence in varchar2 default hr_api.g_varchar2
1223: ,p_match_qualification in varchar2 default hr_api.g_varchar2

Line 1220: ,p_salary_currency in varchar2 default hr_api.g_varchar2

1216: ,p_keywords in varchar2 default hr_api.g_varchar2
1217: ,p_travel_percentage in number default hr_api.g_number
1218: ,p_min_salary in number default hr_api.g_number
1219: ,p_max_salary in number default hr_api.g_number
1220: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1221: ,p_salary_period in varchar2 default hr_api.g_varchar2
1222: ,p_match_competence in varchar2 default hr_api.g_varchar2
1223: ,p_match_qualification in varchar2 default hr_api.g_varchar2
1224: ,p_job_title in varchar2 default hr_api.g_varchar2

Line 1221: ,p_salary_period in varchar2 default hr_api.g_varchar2

1217: ,p_travel_percentage in number default hr_api.g_number
1218: ,p_min_salary in number default hr_api.g_number
1219: ,p_max_salary in number default hr_api.g_number
1220: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1221: ,p_salary_period in varchar2 default hr_api.g_varchar2
1222: ,p_match_competence in varchar2 default hr_api.g_varchar2
1223: ,p_match_qualification in varchar2 default hr_api.g_varchar2
1224: ,p_job_title in varchar2 default hr_api.g_varchar2
1225: ,p_department in varchar2 default hr_api.g_varchar2

Line 1222: ,p_match_competence in varchar2 default hr_api.g_varchar2

1218: ,p_min_salary in number default hr_api.g_number
1219: ,p_max_salary in number default hr_api.g_number
1220: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1221: ,p_salary_period in varchar2 default hr_api.g_varchar2
1222: ,p_match_competence in varchar2 default hr_api.g_varchar2
1223: ,p_match_qualification in varchar2 default hr_api.g_varchar2
1224: ,p_job_title in varchar2 default hr_api.g_varchar2
1225: ,p_department in varchar2 default hr_api.g_varchar2
1226: ,p_professional_area in varchar2 default hr_api.g_varchar2

Line 1223: ,p_match_qualification in varchar2 default hr_api.g_varchar2

1219: ,p_max_salary in number default hr_api.g_number
1220: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1221: ,p_salary_period in varchar2 default hr_api.g_varchar2
1222: ,p_match_competence in varchar2 default hr_api.g_varchar2
1223: ,p_match_qualification in varchar2 default hr_api.g_varchar2
1224: ,p_job_title in varchar2 default hr_api.g_varchar2
1225: ,p_department in varchar2 default hr_api.g_varchar2
1226: ,p_professional_area in varchar2 default hr_api.g_varchar2
1227: ,p_work_at_home in varchar2 default hr_api.g_varchar2

Line 1224: ,p_job_title in varchar2 default hr_api.g_varchar2

1220: ,p_salary_currency in varchar2 default hr_api.g_varchar2
1221: ,p_salary_period in varchar2 default hr_api.g_varchar2
1222: ,p_match_competence in varchar2 default hr_api.g_varchar2
1223: ,p_match_qualification in varchar2 default hr_api.g_varchar2
1224: ,p_job_title in varchar2 default hr_api.g_varchar2
1225: ,p_department in varchar2 default hr_api.g_varchar2
1226: ,p_professional_area in varchar2 default hr_api.g_varchar2
1227: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1228: ,p_min_qual_level in number default hr_api.g_number

Line 1225: ,p_department in varchar2 default hr_api.g_varchar2

1221: ,p_salary_period in varchar2 default hr_api.g_varchar2
1222: ,p_match_competence in varchar2 default hr_api.g_varchar2
1223: ,p_match_qualification in varchar2 default hr_api.g_varchar2
1224: ,p_job_title in varchar2 default hr_api.g_varchar2
1225: ,p_department in varchar2 default hr_api.g_varchar2
1226: ,p_professional_area in varchar2 default hr_api.g_varchar2
1227: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1228: ,p_min_qual_level in number default hr_api.g_number
1229: ,p_max_qual_level in number default hr_api.g_number

Line 1226: ,p_professional_area in varchar2 default hr_api.g_varchar2

1222: ,p_match_competence in varchar2 default hr_api.g_varchar2
1223: ,p_match_qualification in varchar2 default hr_api.g_varchar2
1224: ,p_job_title in varchar2 default hr_api.g_varchar2
1225: ,p_department in varchar2 default hr_api.g_varchar2
1226: ,p_professional_area in varchar2 default hr_api.g_varchar2
1227: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1228: ,p_min_qual_level in number default hr_api.g_number
1229: ,p_max_qual_level in number default hr_api.g_number
1230: ,p_use_for_matching in varchar2 default hr_api.g_varchar2

Line 1227: ,p_work_at_home in varchar2 default hr_api.g_varchar2

1223: ,p_match_qualification in varchar2 default hr_api.g_varchar2
1224: ,p_job_title in varchar2 default hr_api.g_varchar2
1225: ,p_department in varchar2 default hr_api.g_varchar2
1226: ,p_professional_area in varchar2 default hr_api.g_varchar2
1227: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1228: ,p_min_qual_level in number default hr_api.g_number
1229: ,p_max_qual_level in number default hr_api.g_number
1230: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
1231: ,p_description in varchar2 default hr_api.g_varchar2

Line 1228: ,p_min_qual_level in number default hr_api.g_number

1224: ,p_job_title in varchar2 default hr_api.g_varchar2
1225: ,p_department in varchar2 default hr_api.g_varchar2
1226: ,p_professional_area in varchar2 default hr_api.g_varchar2
1227: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1228: ,p_min_qual_level in number default hr_api.g_number
1229: ,p_max_qual_level in number default hr_api.g_number
1230: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
1231: ,p_description in varchar2 default hr_api.g_varchar2
1232: ,p_attribute_category in varchar2 default hr_api.g_varchar2

Line 1229: ,p_max_qual_level in number default hr_api.g_number

1225: ,p_department in varchar2 default hr_api.g_varchar2
1226: ,p_professional_area in varchar2 default hr_api.g_varchar2
1227: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1228: ,p_min_qual_level in number default hr_api.g_number
1229: ,p_max_qual_level in number default hr_api.g_number
1230: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
1231: ,p_description in varchar2 default hr_api.g_varchar2
1232: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1233: ,p_attribute1 in varchar2 default hr_api.g_varchar2

Line 1230: ,p_use_for_matching in varchar2 default hr_api.g_varchar2

1226: ,p_professional_area in varchar2 default hr_api.g_varchar2
1227: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1228: ,p_min_qual_level in number default hr_api.g_number
1229: ,p_max_qual_level in number default hr_api.g_number
1230: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
1231: ,p_description in varchar2 default hr_api.g_varchar2
1232: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1233: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1234: ,p_attribute2 in varchar2 default hr_api.g_varchar2

Line 1231: ,p_description in varchar2 default hr_api.g_varchar2

1227: ,p_work_at_home in varchar2 default hr_api.g_varchar2
1228: ,p_min_qual_level in number default hr_api.g_number
1229: ,p_max_qual_level in number default hr_api.g_number
1230: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
1231: ,p_description in varchar2 default hr_api.g_varchar2
1232: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1233: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1234: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1235: ,p_attribute3 in varchar2 default hr_api.g_varchar2

Line 1232: ,p_attribute_category in varchar2 default hr_api.g_varchar2

1228: ,p_min_qual_level in number default hr_api.g_number
1229: ,p_max_qual_level in number default hr_api.g_number
1230: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
1231: ,p_description in varchar2 default hr_api.g_varchar2
1232: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1233: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1234: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1235: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1236: ,p_attribute4 in varchar2 default hr_api.g_varchar2

Line 1233: ,p_attribute1 in varchar2 default hr_api.g_varchar2

1229: ,p_max_qual_level in number default hr_api.g_number
1230: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
1231: ,p_description in varchar2 default hr_api.g_varchar2
1232: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1233: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1234: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1235: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1236: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1237: ,p_attribute5 in varchar2 default hr_api.g_varchar2

Line 1234: ,p_attribute2 in varchar2 default hr_api.g_varchar2

1230: ,p_use_for_matching in varchar2 default hr_api.g_varchar2
1231: ,p_description in varchar2 default hr_api.g_varchar2
1232: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1233: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1234: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1235: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1236: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1237: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1238: ,p_attribute6 in varchar2 default hr_api.g_varchar2

Line 1235: ,p_attribute3 in varchar2 default hr_api.g_varchar2

1231: ,p_description in varchar2 default hr_api.g_varchar2
1232: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1233: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1234: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1235: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1236: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1237: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1238: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1239: ,p_attribute7 in varchar2 default hr_api.g_varchar2

Line 1236: ,p_attribute4 in varchar2 default hr_api.g_varchar2

1232: ,p_attribute_category in varchar2 default hr_api.g_varchar2
1233: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1234: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1235: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1236: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1237: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1238: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1239: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1240: ,p_attribute8 in varchar2 default hr_api.g_varchar2

Line 1237: ,p_attribute5 in varchar2 default hr_api.g_varchar2

1233: ,p_attribute1 in varchar2 default hr_api.g_varchar2
1234: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1235: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1236: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1237: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1238: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1239: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1240: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1241: ,p_attribute9 in varchar2 default hr_api.g_varchar2

Line 1238: ,p_attribute6 in varchar2 default hr_api.g_varchar2

1234: ,p_attribute2 in varchar2 default hr_api.g_varchar2
1235: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1236: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1237: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1238: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1239: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1240: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1241: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1242: ,p_attribute10 in varchar2 default hr_api.g_varchar2

Line 1239: ,p_attribute7 in varchar2 default hr_api.g_varchar2

1235: ,p_attribute3 in varchar2 default hr_api.g_varchar2
1236: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1237: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1238: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1239: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1240: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1241: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1242: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1243: ,p_attribute11 in varchar2 default hr_api.g_varchar2

Line 1240: ,p_attribute8 in varchar2 default hr_api.g_varchar2

1236: ,p_attribute4 in varchar2 default hr_api.g_varchar2
1237: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1238: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1239: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1240: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1241: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1242: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1243: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1244: ,p_attribute12 in varchar2 default hr_api.g_varchar2

Line 1241: ,p_attribute9 in varchar2 default hr_api.g_varchar2

1237: ,p_attribute5 in varchar2 default hr_api.g_varchar2
1238: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1239: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1240: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1241: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1242: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1243: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1244: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1245: ,p_attribute13 in varchar2 default hr_api.g_varchar2

Line 1242: ,p_attribute10 in varchar2 default hr_api.g_varchar2

1238: ,p_attribute6 in varchar2 default hr_api.g_varchar2
1239: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1240: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1241: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1242: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1243: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1244: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1245: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1246: ,p_attribute14 in varchar2 default hr_api.g_varchar2

Line 1243: ,p_attribute11 in varchar2 default hr_api.g_varchar2

1239: ,p_attribute7 in varchar2 default hr_api.g_varchar2
1240: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1241: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1242: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1243: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1244: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1245: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1246: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1247: ,p_attribute15 in varchar2 default hr_api.g_varchar2

Line 1244: ,p_attribute12 in varchar2 default hr_api.g_varchar2

1240: ,p_attribute8 in varchar2 default hr_api.g_varchar2
1241: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1242: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1243: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1244: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1245: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1246: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1247: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1248: ,p_attribute16 in varchar2 default hr_api.g_varchar2

Line 1245: ,p_attribute13 in varchar2 default hr_api.g_varchar2

1241: ,p_attribute9 in varchar2 default hr_api.g_varchar2
1242: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1243: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1244: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1245: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1246: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1247: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1248: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1249: ,p_attribute17 in varchar2 default hr_api.g_varchar2

Line 1246: ,p_attribute14 in varchar2 default hr_api.g_varchar2

1242: ,p_attribute10 in varchar2 default hr_api.g_varchar2
1243: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1244: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1245: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1246: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1247: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1248: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1249: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1250: ,p_attribute18 in varchar2 default hr_api.g_varchar2

Line 1247: ,p_attribute15 in varchar2 default hr_api.g_varchar2

1243: ,p_attribute11 in varchar2 default hr_api.g_varchar2
1244: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1245: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1246: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1247: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1248: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1249: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1250: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1251: ,p_attribute19 in varchar2 default hr_api.g_varchar2

Line 1248: ,p_attribute16 in varchar2 default hr_api.g_varchar2

1244: ,p_attribute12 in varchar2 default hr_api.g_varchar2
1245: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1246: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1247: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1248: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1249: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1250: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1251: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1252: ,p_attribute20 in varchar2 default hr_api.g_varchar2

Line 1249: ,p_attribute17 in varchar2 default hr_api.g_varchar2

1245: ,p_attribute13 in varchar2 default hr_api.g_varchar2
1246: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1247: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1248: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1249: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1250: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1251: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1252: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1253: ,p_attribute21 in varchar2 default hr_api.g_varchar2

Line 1250: ,p_attribute18 in varchar2 default hr_api.g_varchar2

1246: ,p_attribute14 in varchar2 default hr_api.g_varchar2
1247: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1248: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1249: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1250: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1251: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1252: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1253: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1254: ,p_attribute22 in varchar2 default hr_api.g_varchar2

Line 1251: ,p_attribute19 in varchar2 default hr_api.g_varchar2

1247: ,p_attribute15 in varchar2 default hr_api.g_varchar2
1248: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1249: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1250: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1251: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1252: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1253: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1254: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1255: ,p_attribute23 in varchar2 default hr_api.g_varchar2

Line 1252: ,p_attribute20 in varchar2 default hr_api.g_varchar2

1248: ,p_attribute16 in varchar2 default hr_api.g_varchar2
1249: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1250: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1251: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1252: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1253: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1254: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1255: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1256: ,p_attribute24 in varchar2 default hr_api.g_varchar2

Line 1253: ,p_attribute21 in varchar2 default hr_api.g_varchar2

1249: ,p_attribute17 in varchar2 default hr_api.g_varchar2
1250: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1251: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1252: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1253: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1254: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1255: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1256: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1257: ,p_attribute25 in varchar2 default hr_api.g_varchar2

Line 1254: ,p_attribute22 in varchar2 default hr_api.g_varchar2

1250: ,p_attribute18 in varchar2 default hr_api.g_varchar2
1251: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1252: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1253: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1254: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1255: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1256: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1257: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1258: ,p_attribute26 in varchar2 default hr_api.g_varchar2

Line 1255: ,p_attribute23 in varchar2 default hr_api.g_varchar2

1251: ,p_attribute19 in varchar2 default hr_api.g_varchar2
1252: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1253: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1254: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1255: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1256: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1257: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1258: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1259: ,p_attribute27 in varchar2 default hr_api.g_varchar2

Line 1256: ,p_attribute24 in varchar2 default hr_api.g_varchar2

1252: ,p_attribute20 in varchar2 default hr_api.g_varchar2
1253: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1254: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1255: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1256: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1257: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1258: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1259: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1260: ,p_attribute28 in varchar2 default hr_api.g_varchar2

Line 1257: ,p_attribute25 in varchar2 default hr_api.g_varchar2

1253: ,p_attribute21 in varchar2 default hr_api.g_varchar2
1254: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1255: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1256: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1257: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1258: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1259: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1260: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1261: ,p_attribute29 in varchar2 default hr_api.g_varchar2

Line 1258: ,p_attribute26 in varchar2 default hr_api.g_varchar2

1254: ,p_attribute22 in varchar2 default hr_api.g_varchar2
1255: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1256: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1257: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1258: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1259: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1260: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1261: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1262: ,p_attribute30 in varchar2 default hr_api.g_varchar2

Line 1259: ,p_attribute27 in varchar2 default hr_api.g_varchar2

1255: ,p_attribute23 in varchar2 default hr_api.g_varchar2
1256: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1257: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1258: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1259: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1260: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1261: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1262: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1263: ,p_isc_information_category in varchar2 default hr_api.g_varchar2

Line 1260: ,p_attribute28 in varchar2 default hr_api.g_varchar2

1256: ,p_attribute24 in varchar2 default hr_api.g_varchar2
1257: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1258: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1259: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1260: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1261: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1262: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1263: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1264: ,p_isc_information1 in varchar2 default hr_api.g_varchar2

Line 1261: ,p_attribute29 in varchar2 default hr_api.g_varchar2

1257: ,p_attribute25 in varchar2 default hr_api.g_varchar2
1258: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1259: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1260: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1261: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1262: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1263: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1264: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1265: ,p_isc_information2 in varchar2 default hr_api.g_varchar2

Line 1262: ,p_attribute30 in varchar2 default hr_api.g_varchar2

1258: ,p_attribute26 in varchar2 default hr_api.g_varchar2
1259: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1260: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1261: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1262: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1263: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1264: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1265: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1266: ,p_isc_information3 in varchar2 default hr_api.g_varchar2

Line 1263: ,p_isc_information_category in varchar2 default hr_api.g_varchar2

1259: ,p_attribute27 in varchar2 default hr_api.g_varchar2
1260: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1261: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1262: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1263: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1264: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1265: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1266: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1267: ,p_isc_information4 in varchar2 default hr_api.g_varchar2

Line 1264: ,p_isc_information1 in varchar2 default hr_api.g_varchar2

1260: ,p_attribute28 in varchar2 default hr_api.g_varchar2
1261: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1262: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1263: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1264: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1265: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1266: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1267: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1268: ,p_isc_information5 in varchar2 default hr_api.g_varchar2

Line 1265: ,p_isc_information2 in varchar2 default hr_api.g_varchar2

1261: ,p_attribute29 in varchar2 default hr_api.g_varchar2
1262: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1263: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1264: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1265: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1266: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1267: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1268: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1269: ,p_isc_information6 in varchar2 default hr_api.g_varchar2

Line 1266: ,p_isc_information3 in varchar2 default hr_api.g_varchar2

1262: ,p_attribute30 in varchar2 default hr_api.g_varchar2
1263: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1264: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1265: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1266: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1267: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1268: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1269: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1270: ,p_isc_information7 in varchar2 default hr_api.g_varchar2

Line 1267: ,p_isc_information4 in varchar2 default hr_api.g_varchar2

1263: ,p_isc_information_category in varchar2 default hr_api.g_varchar2
1264: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1265: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1266: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1267: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1268: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1269: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1270: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1271: ,p_isc_information8 in varchar2 default hr_api.g_varchar2

Line 1268: ,p_isc_information5 in varchar2 default hr_api.g_varchar2

1264: ,p_isc_information1 in varchar2 default hr_api.g_varchar2
1265: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1266: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1267: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1268: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1269: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1270: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1271: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1272: ,p_isc_information9 in varchar2 default hr_api.g_varchar2

Line 1269: ,p_isc_information6 in varchar2 default hr_api.g_varchar2

1265: ,p_isc_information2 in varchar2 default hr_api.g_varchar2
1266: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1267: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1268: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1269: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1270: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1271: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1272: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1273: ,p_isc_information10 in varchar2 default hr_api.g_varchar2

Line 1270: ,p_isc_information7 in varchar2 default hr_api.g_varchar2

1266: ,p_isc_information3 in varchar2 default hr_api.g_varchar2
1267: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1268: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1269: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1270: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1271: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1272: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1273: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1274: ,p_isc_information11 in varchar2 default hr_api.g_varchar2

Line 1271: ,p_isc_information8 in varchar2 default hr_api.g_varchar2

1267: ,p_isc_information4 in varchar2 default hr_api.g_varchar2
1268: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1269: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1270: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1271: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1272: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1273: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1274: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1275: ,p_isc_information12 in varchar2 default hr_api.g_varchar2

Line 1272: ,p_isc_information9 in varchar2 default hr_api.g_varchar2

1268: ,p_isc_information5 in varchar2 default hr_api.g_varchar2
1269: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1270: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1271: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1272: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1273: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1274: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1275: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1276: ,p_isc_information13 in varchar2 default hr_api.g_varchar2

Line 1273: ,p_isc_information10 in varchar2 default hr_api.g_varchar2

1269: ,p_isc_information6 in varchar2 default hr_api.g_varchar2
1270: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1271: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1272: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1273: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1274: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1275: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1276: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1277: ,p_isc_information14 in varchar2 default hr_api.g_varchar2

Line 1274: ,p_isc_information11 in varchar2 default hr_api.g_varchar2

1270: ,p_isc_information7 in varchar2 default hr_api.g_varchar2
1271: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1272: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1273: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1274: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1275: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1276: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1277: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1278: ,p_isc_information15 in varchar2 default hr_api.g_varchar2

Line 1275: ,p_isc_information12 in varchar2 default hr_api.g_varchar2

1271: ,p_isc_information8 in varchar2 default hr_api.g_varchar2
1272: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1273: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1274: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1275: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1276: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1277: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1278: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1279: ,p_isc_information16 in varchar2 default hr_api.g_varchar2

Line 1276: ,p_isc_information13 in varchar2 default hr_api.g_varchar2

1272: ,p_isc_information9 in varchar2 default hr_api.g_varchar2
1273: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1274: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1275: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1276: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1277: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1278: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1279: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1280: ,p_isc_information17 in varchar2 default hr_api.g_varchar2

Line 1277: ,p_isc_information14 in varchar2 default hr_api.g_varchar2

1273: ,p_isc_information10 in varchar2 default hr_api.g_varchar2
1274: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1275: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1276: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1277: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1278: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1279: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1280: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1281: ,p_isc_information18 in varchar2 default hr_api.g_varchar2

Line 1278: ,p_isc_information15 in varchar2 default hr_api.g_varchar2

1274: ,p_isc_information11 in varchar2 default hr_api.g_varchar2
1275: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1276: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1277: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1278: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1279: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1280: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1281: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1282: ,p_isc_information19 in varchar2 default hr_api.g_varchar2

Line 1279: ,p_isc_information16 in varchar2 default hr_api.g_varchar2

1275: ,p_isc_information12 in varchar2 default hr_api.g_varchar2
1276: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1277: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1278: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1279: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1280: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1281: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1282: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1283: ,p_isc_information20 in varchar2 default hr_api.g_varchar2

Line 1280: ,p_isc_information17 in varchar2 default hr_api.g_varchar2

1276: ,p_isc_information13 in varchar2 default hr_api.g_varchar2
1277: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1278: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1279: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1280: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1281: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1282: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1283: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1284: ,p_isc_information21 in varchar2 default hr_api.g_varchar2

Line 1281: ,p_isc_information18 in varchar2 default hr_api.g_varchar2

1277: ,p_isc_information14 in varchar2 default hr_api.g_varchar2
1278: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1279: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1280: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1281: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1282: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1283: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1284: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1285: ,p_isc_information22 in varchar2 default hr_api.g_varchar2

Line 1282: ,p_isc_information19 in varchar2 default hr_api.g_varchar2

1278: ,p_isc_information15 in varchar2 default hr_api.g_varchar2
1279: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1280: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1281: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1282: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1283: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1284: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1285: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1286: ,p_isc_information23 in varchar2 default hr_api.g_varchar2

Line 1283: ,p_isc_information20 in varchar2 default hr_api.g_varchar2

1279: ,p_isc_information16 in varchar2 default hr_api.g_varchar2
1280: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1281: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1282: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1283: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1284: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1285: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1286: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1287: ,p_isc_information24 in varchar2 default hr_api.g_varchar2

Line 1284: ,p_isc_information21 in varchar2 default hr_api.g_varchar2

1280: ,p_isc_information17 in varchar2 default hr_api.g_varchar2
1281: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1282: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1283: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1284: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1285: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1286: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1287: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1288: ,p_isc_information25 in varchar2 default hr_api.g_varchar2

Line 1285: ,p_isc_information22 in varchar2 default hr_api.g_varchar2

1281: ,p_isc_information18 in varchar2 default hr_api.g_varchar2
1282: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1283: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1284: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1285: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1286: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1287: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1288: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1289: ,p_isc_information26 in varchar2 default hr_api.g_varchar2

Line 1286: ,p_isc_information23 in varchar2 default hr_api.g_varchar2

1282: ,p_isc_information19 in varchar2 default hr_api.g_varchar2
1283: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1284: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1285: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1286: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1287: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1288: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1289: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1290: ,p_isc_information27 in varchar2 default hr_api.g_varchar2

Line 1287: ,p_isc_information24 in varchar2 default hr_api.g_varchar2

1283: ,p_isc_information20 in varchar2 default hr_api.g_varchar2
1284: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1285: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1286: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1287: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1288: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1289: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1290: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1291: ,p_isc_information28 in varchar2 default hr_api.g_varchar2

Line 1288: ,p_isc_information25 in varchar2 default hr_api.g_varchar2

1284: ,p_isc_information21 in varchar2 default hr_api.g_varchar2
1285: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1286: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1287: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1288: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1289: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1290: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1291: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1292: ,p_isc_information29 in varchar2 default hr_api.g_varchar2

Line 1289: ,p_isc_information26 in varchar2 default hr_api.g_varchar2

1285: ,p_isc_information22 in varchar2 default hr_api.g_varchar2
1286: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1287: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1288: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1289: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1290: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1291: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1292: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1293: ,p_isc_information30 in varchar2 default hr_api.g_varchar2

Line 1290: ,p_isc_information27 in varchar2 default hr_api.g_varchar2

1286: ,p_isc_information23 in varchar2 default hr_api.g_varchar2
1287: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1288: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1289: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1290: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1291: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1292: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1293: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1294: ,p_date_posted in varchar2 default hr_api.g_varchar2

Line 1291: ,p_isc_information28 in varchar2 default hr_api.g_varchar2

1287: ,p_isc_information24 in varchar2 default hr_api.g_varchar2
1288: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1289: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1290: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1291: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1292: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1293: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1294: ,p_date_posted in varchar2 default hr_api.g_varchar2
1295: ) is

Line 1292: ,p_isc_information29 in varchar2 default hr_api.g_varchar2

1288: ,p_isc_information25 in varchar2 default hr_api.g_varchar2
1289: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1290: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1291: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1292: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1293: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1294: ,p_date_posted in varchar2 default hr_api.g_varchar2
1295: ) is
1296: --

Line 1293: ,p_isc_information30 in varchar2 default hr_api.g_varchar2

1289: ,p_isc_information26 in varchar2 default hr_api.g_varchar2
1290: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1291: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1292: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1293: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1294: ,p_date_posted in varchar2 default hr_api.g_varchar2
1295: ) is
1296: --
1297: l_rec irc_isc_shd.g_rec_type;

Line 1294: ,p_date_posted in varchar2 default hr_api.g_varchar2

1290: ,p_isc_information27 in varchar2 default hr_api.g_varchar2
1291: ,p_isc_information28 in varchar2 default hr_api.g_varchar2
1292: ,p_isc_information29 in varchar2 default hr_api.g_varchar2
1293: ,p_isc_information30 in varchar2 default hr_api.g_varchar2
1294: ,p_date_posted in varchar2 default hr_api.g_varchar2
1295: ) is
1296: --
1297: l_rec irc_isc_shd.g_rec_type;
1298: l_proc varchar2(72) := g_package||'upd';