eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IRC_ISC_BUS dependencies on IRC_SEARCH_CRITERIA

Line 184: ,p_descflex_name => 'IRC_SEARCH_CRITERIA_DDF'

180: -- b) During insert.
181: --
182: hr_dflex_utility.ins_or_upd_descflex_attribs
183: (p_appl_short_name => 'PER'
184: ,p_descflex_name => 'IRC_SEARCH_CRITERIA_DDF'
185: ,p_attribute_category => p_rec.isc_information_category
186: ,p_attribute1_name => 'ISC_INFORMATION1'
187: ,p_attribute1_value => p_rec.isc_information1
188: ,p_attribute2_name => 'ISC_INFORMATION2'

Line 361: ,p_descflex_name => 'IRC_SEARCH_CRITERIA'

357: -- b) During insert.
358: --
359: hr_dflex_utility.ins_or_upd_descflex_attribs
360: (p_appl_short_name => 'PER'
361: ,p_descflex_name => 'IRC_SEARCH_CRITERIA'
362: ,p_attribute_category => p_rec.attribute_category
363: ,p_attribute1_name => 'ATTRIBUTE1'
364: ,p_attribute1_value => p_rec.attribute1
365: ,p_attribute2_name => 'ATTRIBUTE2'

Line 531: (p_person_id in irc_search_criteria.object_id%TYPE

527: --
528: -- {End Of Comments}
529: -- ----------------------------------------------------------------------------
530: Procedure chk_person_id
531: (p_person_id in irc_search_criteria.object_id%TYPE
532: ,p_effective_date in Date
533: ) IS
534: --
535: l_proc varchar2(72) := g_package || 'chk_person_id';

Line 569: 'IRC_SEARCH_CRITERIA.OBJECT_ID'

565: exception
566: when app_exception.application_exception then
567: if hr_multi_message.exception_add
568: (p_associated_column1 =>
569: 'IRC_SEARCH_CRITERIA.OBJECT_ID'
570: ) then
571: hr_utility.set_location(' Leaving:'||l_proc,50);
572: raise;
573: end if;

Line 600: (p_object_id in irc_search_criteria.object_id%TYPE

596: --
597: -- {End Of Comments}
598: -- ----------------------------------------------------------------------------
599: Procedure chk_unique_work
600: (p_object_id in irc_search_criteria.object_id%TYPE
601: ) IS
602: --
603: l_proc varchar2(72) := g_package || 'chk_unique_work';
604: --

Line 607: from irc_search_criteria isc

603: l_proc varchar2(72) := g_package || 'chk_unique_work';
604: --
605: cursor csr_work_choices is
606: select 1
607: from irc_search_criteria isc
608: where isc.object_id = p_object_id
609: and isc.object_type = 'WPREF';
610: l_dummy number;
611: --

Line 629: 'IRC_SEARCH_CRITERIA.OBJECT_ID'

625: exception
626: when app_exception.application_exception then
627: if hr_multi_message.exception_add
628: (p_associated_column1 =>
629: 'IRC_SEARCH_CRITERIA.OBJECT_ID'
630: ) then
631: hr_utility.set_location(' Leaving:'||l_proc,50);
632: raise;
633: end if;

Line 664: (p_search_name in irc_search_criteria.search_name%TYPE

660: --
661: -- {End Of Comments}
662: -- ----------------------------------------------------------------------------
663: Procedure chk_search_name
664: (p_search_name in irc_search_criteria.search_name%TYPE
665: ,p_person_id in irc_search_criteria.object_id%TYPE
666: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
667: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
668: ) IS

Line 665: ,p_person_id in irc_search_criteria.object_id%TYPE

661: -- {End Of Comments}
662: -- ----------------------------------------------------------------------------
663: Procedure chk_search_name
664: (p_search_name in irc_search_criteria.search_name%TYPE
665: ,p_person_id in irc_search_criteria.object_id%TYPE
666: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
667: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
668: ) IS
669: --

Line 666: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

662: -- ----------------------------------------------------------------------------
663: Procedure chk_search_name
664: (p_search_name in irc_search_criteria.search_name%TYPE
665: ,p_person_id in irc_search_criteria.object_id%TYPE
666: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
667: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
668: ) IS
669: --
670: l_proc varchar2(72) := g_package || 'chk_search_name';

Line 667: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

663: Procedure chk_search_name
664: (p_search_name in irc_search_criteria.search_name%TYPE
665: ,p_person_id in irc_search_criteria.object_id%TYPE
666: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
667: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
668: ) IS
669: --
670: l_proc varchar2(72) := g_package || 'chk_search_name';
671: l_search_name varchar2(1);

Line 675: select null from irc_search_criteria isc

671: l_search_name varchar2(1);
672: l_api_updating boolean;
673: --
674: cursor csr_search_name is
675: select null from irc_search_criteria isc
676: where isc.search_name = p_search_name
677: and isc.object_id = p_person_id ;
678: --
679: begin

Line 711: 'IRC_SEARCH_CRITERIA.SEARCH_NAME'

707: exception
708: when app_exception.application_exception then
709: if hr_multi_message.exception_add
710: (p_associated_column1 =>
711: 'IRC_SEARCH_CRITERIA.SEARCH_NAME'
712: ) then
713: hr_utility.set_location(' Leaving:'||l_proc,70);
714: raise;
715: end if;

Line 749: (p_distance_to_location in irc_search_criteria.distance_to_location%TYPE

745: --
746: -- {End Of Comments}
747: -- ----------------------------------------------------------------------------
748: Procedure chk_distance_to_location
749: (p_distance_to_location in irc_search_criteria.distance_to_location%TYPE
750: ,p_geocode_location in irc_search_criteria.geocode_location%TYPE
751: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
752: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
753: ) IS

Line 750: ,p_geocode_location in irc_search_criteria.geocode_location%TYPE

746: -- {End Of Comments}
747: -- ----------------------------------------------------------------------------
748: Procedure chk_distance_to_location
749: (p_distance_to_location in irc_search_criteria.distance_to_location%TYPE
750: ,p_geocode_location in irc_search_criteria.geocode_location%TYPE
751: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
752: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
753: ) IS
754: --

Line 751: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

747: -- ----------------------------------------------------------------------------
748: Procedure chk_distance_to_location
749: (p_distance_to_location in irc_search_criteria.distance_to_location%TYPE
750: ,p_geocode_location in irc_search_criteria.geocode_location%TYPE
751: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
752: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
753: ) IS
754: --
755: l_proc varchar2(72) := g_package || 'chk_distance_to_location';

Line 752: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

748: Procedure chk_distance_to_location
749: (p_distance_to_location in irc_search_criteria.distance_to_location%TYPE
750: ,p_geocode_location in irc_search_criteria.geocode_location%TYPE
751: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
752: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
753: ) IS
754: --
755: l_proc varchar2(72) := g_package || 'chk_distance_to_location';
756: l_api_updating boolean;

Line 778: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.DISTANCE_TO_LOCATION'

774: hr_utility.set_location(l_proc,40);
775: if p_distance_to_location < 0 then
776: fnd_message.set_name('PER','IRC_412010_BAD_DISTANCE_TO_LOC');
777: hr_multi_message.add
778: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.DISTANCE_TO_LOCATION'
779: );
780: else
781: -- Check that location is a valid.
782: hr_utility.set_location(l_proc,50);

Line 786: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.GEOCODE_LOCATION'

782: hr_utility.set_location(l_proc,50);
783: if p_geocode_location is null then
784: fnd_message.set_name('PER','IRC_412011_BAD_LOCATION');
785: hr_multi_message.add
786: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.GEOCODE_LOCATION'
787: );
788: end if;
789: end if;
790: end if;

Line 797: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.DISTANCE_TO_LOCATION'

793: hr_utility.set_location(l_proc,60);
794: if p_geocode_location is not null then
795: fnd_message.set_name('PER','IRC_412164_NO_DISTANCE');
796: hr_multi_message.add
797: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.DISTANCE_TO_LOCATION'
798: );
799: end if;
800: end if;
801: hr_utility.set_location(' Leaving:'||l_proc,60);

Line 830: (p_location_id in irc_search_criteria.location_id%TYPE

826: --
827: -- {End Of Comments}
828: -- ----------------------------------------------------------------------------
829: Procedure chk_location_id
830: (p_location_id in irc_search_criteria.location_id%TYPE
831: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
832: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
833: ) IS
834: --

Line 831: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

827: -- {End Of Comments}
828: -- ----------------------------------------------------------------------------
829: Procedure chk_location_id
830: (p_location_id in irc_search_criteria.location_id%TYPE
831: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
832: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
833: ) IS
834: --
835: l_proc varchar2(72) := g_package || 'chk_location_id';

Line 832: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

828: -- ----------------------------------------------------------------------------
829: Procedure chk_location_id
830: (p_location_id in irc_search_criteria.location_id%TYPE
831: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
832: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
833: ) IS
834: --
835: l_proc varchar2(72) := g_package || 'chk_location_id';
836: l_api_updating boolean;

Line 867: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.LOCATION_ID'

863: if chk_loc%notfound then
864: close chk_loc;
865: fnd_message.set_name('PER','IRC_412165_BAD_LOCATION_ID');
866: hr_multi_message.add
867: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.LOCATION_ID'
868: );
869: else
870: close chk_loc;
871: end if;

Line 908: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

904: -- ----------------------------------------------------------------------------
905: Procedure chk_longitude_latitude
906: (p_longitude in number
907: ,p_latitude in number
908: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
909: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
910: ) IS
911: --
912: l_proc varchar2(72) := g_package || 'chk_longitude_latitude';

Line 909: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

905: Procedure chk_longitude_latitude
906: (p_longitude in number
907: ,p_latitude in number
908: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
909: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
910: ) IS
911: --
912: l_proc varchar2(72) := g_package || 'chk_longitude_latitude';
913: --

Line 922: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.GEOMETRY'

918: --
919: hr_utility.set_location(l_proc,20);
920: fnd_message.set_name('PER','IRC_412166_LONG_LAT');
921: hr_multi_message.add
922: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.GEOMETRY'
923: );
924: end if;
925: hr_utility.set_location(' Leaving:'||l_proc,60);
926: end chk_longitude_latitude;

Line 955: (p_use_for_matching in irc_search_criteria.use_for_matching%TYPE

951: --
952: -- {End Of Comments}
953: -- ----------------------------------------------------------------------------
954: Procedure chk_use_for_matching
955: (p_use_for_matching in irc_search_criteria.use_for_matching%TYPE
956: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
957: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
958: ) IS
959: --

Line 956: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

952: -- {End Of Comments}
953: -- ----------------------------------------------------------------------------
954: Procedure chk_use_for_matching
955: (p_use_for_matching in irc_search_criteria.use_for_matching%TYPE
956: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
957: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
958: ) IS
959: --
960: l_proc varchar2(72) := g_package || 'chk_use_for_matching';

Line 957: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

953: -- ----------------------------------------------------------------------------
954: Procedure chk_use_for_matching
955: (p_use_for_matching in irc_search_criteria.use_for_matching%TYPE
956: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
957: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
958: ) IS
959: --
960: l_proc varchar2(72) := g_package || 'chk_use_for_matching';
961: l_api_updating boolean;

Line 991: 'IRC_SEARCH_CRITERIA.USE_FOR_MATCHING'

987: exception
988: when app_exception.application_exception then
989: if hr_multi_message.exception_add
990: (p_associated_column1 =>
991: 'IRC_SEARCH_CRITERIA.USE_FOR_MATCHING'
992: ) then
993: hr_utility.set_location(' Leaving:'||l_proc,60);
994: raise;
995: end if;

Line 1026: (p_match_competence in irc_search_criteria.match_competence%TYPE

1022: --
1023: -- {End Of Comments}
1024: -- ----------------------------------------------------------------------------
1025: Procedure chk_match_competence
1026: (p_match_competence in irc_search_criteria.match_competence%TYPE
1027: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1028: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1029: ) IS
1030: --

Line 1027: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

1023: -- {End Of Comments}
1024: -- ----------------------------------------------------------------------------
1025: Procedure chk_match_competence
1026: (p_match_competence in irc_search_criteria.match_competence%TYPE
1027: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1028: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1029: ) IS
1030: --
1031: l_proc varchar2(72) := g_package || 'chk_match_competence';

Line 1028: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

1024: -- ----------------------------------------------------------------------------
1025: Procedure chk_match_competence
1026: (p_match_competence in irc_search_criteria.match_competence%TYPE
1027: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1028: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1029: ) IS
1030: --
1031: l_proc varchar2(72) := g_package || 'chk_match_competence';
1032: l_api_updating boolean;

Line 1061: 'IRC_SEARCH_CRITERIA.MATCH_COMPETENCE'

1057: exception
1058: when app_exception.application_exception then
1059: if hr_multi_message.exception_add
1060: (p_associated_column1 =>
1061: 'IRC_SEARCH_CRITERIA.MATCH_COMPETENCE'
1062: ) then
1063: hr_utility.set_location(' Leaving:'||l_proc,60);
1064: raise;
1065: end if;

Line 1096: (p_match_qualification in irc_search_criteria.match_qualification%TYPE

1092: --
1093: -- {End Of Comments}
1094: -- ----------------------------------------------------------------------------
1095: Procedure chk_match_qualification
1096: (p_match_qualification in irc_search_criteria.match_qualification%TYPE
1097: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1098: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1099: ) IS
1100: --

Line 1097: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

1093: -- {End Of Comments}
1094: -- ----------------------------------------------------------------------------
1095: Procedure chk_match_qualification
1096: (p_match_qualification in irc_search_criteria.match_qualification%TYPE
1097: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1098: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1099: ) IS
1100: --
1101: l_proc varchar2(72) := g_package || 'chk_match_qualification';

Line 1098: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

1094: -- ----------------------------------------------------------------------------
1095: Procedure chk_match_qualification
1096: (p_match_qualification in irc_search_criteria.match_qualification%TYPE
1097: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1098: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1099: ) IS
1100: --
1101: l_proc varchar2(72) := g_package || 'chk_match_qualification';
1102: l_api_updating boolean;

Line 1132: 'IRC_SEARCH_CRITERIA.MATCH_QUALIFICATION'

1128: exception
1129: when app_exception.application_exception then
1130: if hr_multi_message.exception_add
1131: (p_associated_column1 =>
1132: 'IRC_SEARCH_CRITERIA.MATCH_QUALIFICATION'
1133: ) then
1134: hr_utility.set_location(' Leaving:'||l_proc,60);
1135: raise;
1136: end if;

Line 1165: (p_vacancy_id in irc_search_criteria.object_id%TYPE

1161: --
1162: -- {End Of Comments}
1163: -- ----------------------------------------------------------------------------
1164: Procedure chk_vacancy_id
1165: (p_vacancy_id in irc_search_criteria.object_id%TYPE
1166: ,p_effective_date in date
1167: ) IS
1168: --
1169: l_proc varchar2(72) := g_package || 'chk_vacancy_id';

Line 1200: 'IRC_SEARCH_CRITERIA.OBJECT_ID'

1196: exception
1197: when app_exception.application_exception then
1198: if hr_multi_message.exception_add
1199: (p_associated_column1 =>
1200: 'IRC_SEARCH_CRITERIA.OBJECT_ID'
1201: ) then
1202: hr_utility.set_location(' Leaving:'||l_proc,50);
1203: raise;
1204: end if;

Line 1235: (p_min_qual_level in irc_search_criteria.min_qual_level%TYPE

1231: --
1232: -- {End Of Comments}
1233: -- ----------------------------------------------------------------------------
1234: Procedure chk_min_qual_level
1235: (p_min_qual_level in irc_search_criteria.min_qual_level%TYPE
1236: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1237: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1238: ) IS
1239: --

Line 1236: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

1232: -- {End Of Comments}
1233: -- ----------------------------------------------------------------------------
1234: Procedure chk_min_qual_level
1235: (p_min_qual_level in irc_search_criteria.min_qual_level%TYPE
1236: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1237: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1238: ) IS
1239: --
1240: l_proc varchar2(72) := g_package || 'chk_min_qual_level';

Line 1237: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

1233: -- ----------------------------------------------------------------------------
1234: Procedure chk_min_qual_level
1235: (p_min_qual_level in irc_search_criteria.min_qual_level%TYPE
1236: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1237: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1238: ) IS
1239: --
1240: l_proc varchar2(72) := g_package || 'chk_min_qual_level';
1241: l_min_qual_level varchar2(1);

Line 1281: 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'

1277: exception
1278: when app_exception.application_exception then
1279: if hr_multi_message.exception_add
1280: (p_associated_column1 =>
1281: 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'
1282: ) then
1283: hr_utility.set_location(' Leaving:'||l_proc,70);
1284: raise;
1285: end if;

Line 1314: ( p_min_qual_level in irc_search_criteria.min_qual_level%TYPE

1310: --
1311: -- {End Of Comments}
1312: -- ----------------------------------------------------------------------------
1313: Procedure chk_qual_rank
1314: ( p_min_qual_level in irc_search_criteria.min_qual_level%TYPE
1315: , p_max_qual_level in irc_search_criteria.max_qual_level%TYPE
1316: ) IS
1317: --
1318: l_proc varchar2(72):= g_package|| 'chk_qual_rank';

Line 1315: , p_max_qual_level in irc_search_criteria.max_qual_level%TYPE

1311: -- {End Of Comments}
1312: -- ----------------------------------------------------------------------------
1313: Procedure chk_qual_rank
1314: ( p_min_qual_level in irc_search_criteria.min_qual_level%TYPE
1315: , p_max_qual_level in irc_search_criteria.max_qual_level%TYPE
1316: ) IS
1317: --
1318: l_proc varchar2(72):= g_package|| 'chk_qual_rank';
1319: l_min_qual_rank per_qualification_types.rank%TYPE;

Line 1332: ( p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'

1328: -- already contain an error associated with the min_qual_level or max_qual_level
1329: -- columns.
1330: hr_utility.set_location(l_proc,15);
1331: if hr_multi_message.no_all_inclusive_error
1332: ( p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'
1333: ,p_check_column2 => 'IRC_SEARCH_CRITERIA.MAX_QUAL_LEVEL'
1334: ) then
1335: --
1336: hr_utility.set_location(l_proc,20);

Line 1333: ,p_check_column2 => 'IRC_SEARCH_CRITERIA.MAX_QUAL_LEVEL'

1329: -- columns.
1330: hr_utility.set_location(l_proc,15);
1331: if hr_multi_message.no_all_inclusive_error
1332: ( p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'
1333: ,p_check_column2 => 'IRC_SEARCH_CRITERIA.MAX_QUAL_LEVEL'
1334: ) then
1335: --
1336: hr_utility.set_location(l_proc,20);
1337: if ( p_min_qual_level is not null) AND (p_max_qual_level is not null) then

Line 1356: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'

1352: hr_utility.set_location('Leaving:'||l_proc,40);
1353: exception
1354: when app_exception.application_exception then
1355: if hr_multi_message.exception_add
1356: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'
1357: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_QUAL_LEVEL'
1358: ) then
1359: hr_utility.set_location(' Leaving:'||l_proc,50);
1360: raise;

Line 1357: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_QUAL_LEVEL'

1353: exception
1354: when app_exception.application_exception then
1355: if hr_multi_message.exception_add
1356: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_QUAL_LEVEL'
1357: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_QUAL_LEVEL'
1358: ) then
1359: hr_utility.set_location(' Leaving:'||l_proc,50);
1360: raise;
1361: end if;

Line 1394: (p_min_salary in irc_search_criteria.min_salary%TYPE

1390: --
1391: -- {End Of Comments}
1392: -- ----------------------------------------------------------------------------
1393: Procedure chk_min_salary
1394: (p_min_salary in irc_search_criteria.min_salary%TYPE
1395: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1396: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1397: ) IS
1398: --

Line 1395: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

1391: -- {End Of Comments}
1392: -- ----------------------------------------------------------------------------
1393: Procedure chk_min_salary
1394: (p_min_salary in irc_search_criteria.min_salary%TYPE
1395: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1396: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1397: ) IS
1398: --
1399: l_proc varchar2(72) := g_package || 'chk_min_salary';

Line 1396: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

1392: -- ----------------------------------------------------------------------------
1393: Procedure chk_min_salary
1394: (p_min_salary in irc_search_criteria.min_salary%TYPE
1395: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1396: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1397: ) IS
1398: --
1399: l_proc varchar2(72) := g_package || 'chk_min_salary';
1400: l_min_salary varchar2(1);

Line 1430: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'

1426: hr_utility.set_location(' Leaving:'||l_proc,50);
1427: exception
1428: when app_exception.application_exception then
1429: if hr_multi_message.exception_add
1430: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
1431: ) then
1432: hr_utility.set_location(' Leaving:'||l_proc,60);
1433: raise;
1434: end if;

Line 1469: (p_max_salary in irc_search_criteria.max_salary%TYPE

1465: --
1466: -- {End Of Comments}
1467: -- ----------------------------------------------------------------------------
1468: Procedure chk_max_salary
1469: (p_max_salary in irc_search_criteria.max_salary%TYPE
1470: ,p_min_salary in irc_search_criteria.min_salary%TYPE
1471: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1472: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1473: ) IS

Line 1470: ,p_min_salary in irc_search_criteria.min_salary%TYPE

1466: -- {End Of Comments}
1467: -- ----------------------------------------------------------------------------
1468: Procedure chk_max_salary
1469: (p_max_salary in irc_search_criteria.max_salary%TYPE
1470: ,p_min_salary in irc_search_criteria.min_salary%TYPE
1471: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1472: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1473: ) IS
1474: --

Line 1471: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

1467: -- ----------------------------------------------------------------------------
1468: Procedure chk_max_salary
1469: (p_max_salary in irc_search_criteria.max_salary%TYPE
1470: ,p_min_salary in irc_search_criteria.min_salary%TYPE
1471: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1472: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1473: ) IS
1474: --
1475: l_proc varchar2(72) := g_package || 'chk_max_salary';

Line 1472: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

1468: Procedure chk_max_salary
1469: (p_max_salary in irc_search_criteria.max_salary%TYPE
1470: ,p_min_salary in irc_search_criteria.min_salary%TYPE
1471: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1472: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1473: ) IS
1474: --
1475: l_proc varchar2(72) := g_package || 'chk_max_salary';
1476: l_min_salary varchar2(1);

Line 1486: p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'

1482: -- Only proceed with max_salary validation when multiple message list does not
1483: -- already contain an error associated with the min_salary columns.
1484: hr_utility.set_location(l_proc,15);
1485: if hr_multi_message.no_exclusive_error(
1486: p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
1487: ) then
1488: if p_max_salary is not null then
1489: --
1490: hr_utility.set_location(l_proc,20);

Line 1520: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'

1516: -- Multiple message list and associate the error with max_salary and
1517: -- min_salary
1518: when app_exception.application_exception then
1519: if hr_multi_message.exception_add
1520: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
1521: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'
1522: ) then
1523: hr_utility.set_location(' Leaving:'||l_proc,60);
1524: raise;

Line 1521: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'

1517: -- min_salary
1518: when app_exception.application_exception then
1519: if hr_multi_message.exception_add
1520: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
1521: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'
1522: ) then
1523: hr_utility.set_location(' Leaving:'||l_proc,60);
1524: raise;
1525: end if;

Line 1556: (p_employee in irc_search_criteria.employee%TYPE

1552: --
1553: -- {End Of Comments}
1554: -- ----------------------------------------------------------------------------
1555: Procedure chk_employee
1556: (p_employee in irc_search_criteria.employee%TYPE
1557: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1558: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1559: ) IS
1560: --

Line 1557: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

1553: -- {End Of Comments}
1554: -- ----------------------------------------------------------------------------
1555: Procedure chk_employee
1556: (p_employee in irc_search_criteria.employee%TYPE
1557: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1558: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1559: ) IS
1560: --
1561: l_proc varchar2(72) := g_package || 'chk_employee';

Line 1558: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

1554: -- ----------------------------------------------------------------------------
1555: Procedure chk_employee
1556: (p_employee in irc_search_criteria.employee%TYPE
1557: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1558: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1559: ) IS
1560: --
1561: l_proc varchar2(72) := g_package || 'chk_employee';
1562: l_api_updating boolean;

Line 1585: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.EMPLOYEE'

1581: hr_utility.set_location(' Leaving:'||l_proc,40);
1582: exception
1583: when app_exception.application_exception then
1584: if hr_multi_message.exception_add
1585: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.EMPLOYEE'
1586: ) then
1587: hr_utility.set_location(' Leaving:'||l_proc,50);
1588: raise;
1589: end if;

Line 1619: (p_contractor in irc_search_criteria.contractor%TYPE

1615: --
1616: -- {End Of Comments}
1617: -- ----------------------------------------------------------------------------
1618: Procedure chk_contractor
1619: (p_contractor in irc_search_criteria.contractor%TYPE
1620: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1621: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1622: ) IS
1623: --

Line 1620: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

1616: -- {End Of Comments}
1617: -- ----------------------------------------------------------------------------
1618: Procedure chk_contractor
1619: (p_contractor in irc_search_criteria.contractor%TYPE
1620: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1621: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1622: ) IS
1623: --
1624: l_proc varchar2(72) := g_package || 'chk_contractor';

Line 1621: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

1617: -- ----------------------------------------------------------------------------
1618: Procedure chk_contractor
1619: (p_contractor in irc_search_criteria.contractor%TYPE
1620: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1621: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1622: ) IS
1623: --
1624: l_proc varchar2(72) := g_package || 'chk_contractor';
1625: l_api_updating boolean;

Line 1647: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.CONTRACTOR'

1643: hr_utility.set_location(' Leaving:'||l_proc,40);
1644: exception
1645: when app_exception.application_exception then
1646: if hr_multi_message.exception_add
1647: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.CONTRACTOR'
1648: ) then
1649: hr_utility.set_location(' Leaving:'||l_proc,50);
1650: raise;
1651: end if;

Line 1682: (p_professional_area in irc_search_criteria.professional_area%TYPE

1678: --
1679: -- {End Of Comments}
1680: -- ----------------------------------------------------------------------------
1681: Procedure chk_professional_area
1682: (p_professional_area in irc_search_criteria.professional_area%TYPE
1683: ,p_effective_date in date
1684: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1685: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1686: ) IS

Line 1684: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

1680: -- ----------------------------------------------------------------------------
1681: Procedure chk_professional_area
1682: (p_professional_area in irc_search_criteria.professional_area%TYPE
1683: ,p_effective_date in date
1684: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1685: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1686: ) IS
1687: --
1688: l_proc varchar2(72) := g_package || 'chk_professional_area';

Line 1685: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

1681: Procedure chk_professional_area
1682: (p_professional_area in irc_search_criteria.professional_area%TYPE
1683: ,p_effective_date in date
1684: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1685: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1686: ) IS
1687: --
1688: l_proc varchar2(72) := g_package || 'chk_professional_area';
1689: l_api_updating boolean;

Line 1721: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.PROFESSIONAL_AREA'

1717: hr_utility.set_location(' Leaving:'||l_proc,50);
1718: exception
1719: when app_exception.application_exception then
1720: if hr_multi_message.exception_add
1721: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.PROFESSIONAL_AREA'
1722: ) then
1723: hr_utility.set_location(' Leaving:'||l_proc,60);
1724: raise;
1725: end if;

Line 1757: (p_employment_category in irc_search_criteria.employment_category%TYPE

1753: --
1754: -- {End Of Comments}
1755: -- ----------------------------------------------------------------------------
1756: Procedure chk_employment_category
1757: (p_employment_category in irc_search_criteria.employment_category%TYPE
1758: ,p_effective_date in date
1759: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1760: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1761: ) IS

Line 1759: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

1755: -- ----------------------------------------------------------------------------
1756: Procedure chk_employment_category
1757: (p_employment_category in irc_search_criteria.employment_category%TYPE
1758: ,p_effective_date in date
1759: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1760: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1761: ) IS
1762: --
1763: l_proc varchar2(72) := g_package || 'chk_employment_category';

Line 1760: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

1756: Procedure chk_employment_category
1757: (p_employment_category in irc_search_criteria.employment_category%TYPE
1758: ,p_effective_date in date
1759: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1760: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1761: ) IS
1762: --
1763: l_proc varchar2(72) := g_package || 'chk_employment_category';
1764: l_api_updating boolean;

Line 1798: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.EMPLOYMENT_CATEGORY'

1794: hr_utility.set_location(' Leaving:'||l_proc,50);
1795: exception
1796: when app_exception.application_exception then
1797: if hr_multi_message.exception_add
1798: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.EMPLOYMENT_CATEGORY'
1799: ) then
1800: hr_utility.set_location(' Leaving:'||l_proc,60);
1801: raise;
1802: end if;

Line 1834: (p_work_at_home in irc_search_criteria.work_at_home%TYPE

1830: --
1831: -- {End Of Comments}
1832: -- ----------------------------------------------------------------------------
1833: Procedure chk_work_at_home
1834: (p_work_at_home in irc_search_criteria.work_at_home%TYPE
1835: ,p_effective_date in date
1836: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1837: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1838: ) IS

Line 1836: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

1832: -- ----------------------------------------------------------------------------
1833: Procedure chk_work_at_home
1834: (p_work_at_home in irc_search_criteria.work_at_home%TYPE
1835: ,p_effective_date in date
1836: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1837: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1838: ) IS
1839: --
1840: l_proc varchar2(72) := g_package || 'chk_work_at_home';

Line 1837: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

1833: Procedure chk_work_at_home
1834: (p_work_at_home in irc_search_criteria.work_at_home%TYPE
1835: ,p_effective_date in date
1836: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1837: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1838: ) IS
1839: --
1840: l_proc varchar2(72) := g_package || 'chk_work_at_home';
1841: l_api_updating boolean;

Line 1875: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.WORK_AT_HOME'

1871: hr_utility.set_location(' Leaving:'||l_proc,50);
1872: exception
1873: when app_exception.application_exception then
1874: if hr_multi_message.exception_add
1875: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.WORK_AT_HOME'
1876: ) then
1877: hr_utility.set_location(' Leaving:'||l_proc,60);
1878: raise;
1879: end if;

Line 1911: (p_travel_percentage in irc_search_criteria.travel_percentage%TYPE

1907: --
1908: -- {End Of Comments}
1909: -- ----------------------------------------------------------------------------
1910: Procedure chk_travel_percentage
1911: (p_travel_percentage in irc_search_criteria.travel_percentage%TYPE
1912: ,p_effective_date in date
1913: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1914: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1915: ) IS

Line 1913: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

1909: -- ----------------------------------------------------------------------------
1910: Procedure chk_travel_percentage
1911: (p_travel_percentage in irc_search_criteria.travel_percentage%TYPE
1912: ,p_effective_date in date
1913: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1914: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1915: ) IS
1916: --
1917: l_proc varchar2(72) := g_package || 'chk_travel_percentage';

Line 1914: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

1910: Procedure chk_travel_percentage
1911: (p_travel_percentage in irc_search_criteria.travel_percentage%TYPE
1912: ,p_effective_date in date
1913: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1914: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1915: ) IS
1916: --
1917: l_proc varchar2(72) := g_package || 'chk_travel_percentage';
1918: l_api_updating boolean;

Line 1952: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.TRAVEL_PERCENTAGE'

1948: hr_utility.set_location(' Leaving:'||l_proc,50);
1949: exception
1950: when app_exception.application_exception then
1951: if hr_multi_message.exception_add
1952: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.TRAVEL_PERCENTAGE'
1953: ) then
1954: hr_utility.set_location(' Leaving:'||l_proc,60);
1955: raise;
1956: end if;

Line 1988: (p_salary_period in irc_search_criteria.salary_period%TYPE

1984: --
1985: -- {End Of Comments}
1986: -- ----------------------------------------------------------------------------
1987: Procedure chk_salary_period
1988: (p_salary_period in irc_search_criteria.salary_period%TYPE
1989: ,p_min_salary in irc_search_criteria.min_salary%TYPE
1990: ,p_max_salary in irc_search_criteria.max_salary%TYPE
1991: ,p_effective_date in date
1992: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

Line 1989: ,p_min_salary in irc_search_criteria.min_salary%TYPE

1985: -- {End Of Comments}
1986: -- ----------------------------------------------------------------------------
1987: Procedure chk_salary_period
1988: (p_salary_period in irc_search_criteria.salary_period%TYPE
1989: ,p_min_salary in irc_search_criteria.min_salary%TYPE
1990: ,p_max_salary in irc_search_criteria.max_salary%TYPE
1991: ,p_effective_date in date
1992: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1993: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

Line 1990: ,p_max_salary in irc_search_criteria.max_salary%TYPE

1986: -- ----------------------------------------------------------------------------
1987: Procedure chk_salary_period
1988: (p_salary_period in irc_search_criteria.salary_period%TYPE
1989: ,p_min_salary in irc_search_criteria.min_salary%TYPE
1990: ,p_max_salary in irc_search_criteria.max_salary%TYPE
1991: ,p_effective_date in date
1992: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1993: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1994: ) IS

Line 1992: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

1988: (p_salary_period in irc_search_criteria.salary_period%TYPE
1989: ,p_min_salary in irc_search_criteria.min_salary%TYPE
1990: ,p_max_salary in irc_search_criteria.max_salary%TYPE
1991: ,p_effective_date in date
1992: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1993: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1994: ) IS
1995: --
1996: l_proc varchar2(72) := g_package || 'chk_salary_period';

Line 1993: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

1989: ,p_min_salary in irc_search_criteria.min_salary%TYPE
1990: ,p_max_salary in irc_search_criteria.max_salary%TYPE
1991: ,p_effective_date in date
1992: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
1993: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
1994: ) IS
1995: --
1996: l_proc varchar2(72) := g_package || 'chk_salary_period';
1997: l_api_updating boolean;

Line 1998: l_max_salary irc_search_criteria.min_salary%type;

1994: ) IS
1995: --
1996: l_proc varchar2(72) := g_package || 'chk_salary_period';
1997: l_api_updating boolean;
1998: l_max_salary irc_search_criteria.min_salary%type;
1999: l_min_salary irc_search_criteria.max_salary%type;
2000: l_ret boolean;
2001: --
2002: begin

Line 1999: l_min_salary irc_search_criteria.max_salary%type;

1995: --
1996: l_proc varchar2(72) := g_package || 'chk_salary_period';
1997: l_api_updating boolean;
1998: l_max_salary irc_search_criteria.min_salary%type;
1999: l_min_salary irc_search_criteria.max_salary%type;
2000: l_ret boolean;
2001: --
2002: begin
2003: hr_utility.set_location('Entering:'||l_proc,10);

Line 2049: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.SALARY_PERIOD'

2045: hr_utility.set_location(' Leaving:'||l_proc,50);
2046: exception
2047: when app_exception.application_exception then
2048: if hr_multi_message.exception_add
2049: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.SALARY_PERIOD'
2050: ) then
2051: hr_utility.set_location(' Leaving:'||l_proc,60);
2052: raise;
2053: end if;

Line 2087: (p_salary_currency in irc_search_criteria.salary_currency%TYPE

2083: --
2084: -- {End Of Comments}
2085: -- ----------------------------------------------------------------------------
2086: Procedure chk_salary_currency
2087: (p_salary_currency in irc_search_criteria.salary_currency%TYPE
2088: ,p_min_salary in irc_search_criteria.min_salary%TYPE
2089: ,p_max_salary in irc_search_criteria.max_salary%TYPE
2090: ,p_effective_date in date
2091: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

Line 2088: ,p_min_salary in irc_search_criteria.min_salary%TYPE

2084: -- {End Of Comments}
2085: -- ----------------------------------------------------------------------------
2086: Procedure chk_salary_currency
2087: (p_salary_currency in irc_search_criteria.salary_currency%TYPE
2088: ,p_min_salary in irc_search_criteria.min_salary%TYPE
2089: ,p_max_salary in irc_search_criteria.max_salary%TYPE
2090: ,p_effective_date in date
2091: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
2092: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

Line 2089: ,p_max_salary in irc_search_criteria.max_salary%TYPE

2085: -- ----------------------------------------------------------------------------
2086: Procedure chk_salary_currency
2087: (p_salary_currency in irc_search_criteria.salary_currency%TYPE
2088: ,p_min_salary in irc_search_criteria.min_salary%TYPE
2089: ,p_max_salary in irc_search_criteria.max_salary%TYPE
2090: ,p_effective_date in date
2091: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
2092: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
2093: ) IS

Line 2091: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

2087: (p_salary_currency in irc_search_criteria.salary_currency%TYPE
2088: ,p_min_salary in irc_search_criteria.min_salary%TYPE
2089: ,p_max_salary in irc_search_criteria.max_salary%TYPE
2090: ,p_effective_date in date
2091: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
2092: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
2093: ) IS
2094: --
2095: l_proc varchar2(72) := g_package || 'chk_salary_currency';

Line 2092: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

2088: ,p_min_salary in irc_search_criteria.min_salary%TYPE
2089: ,p_max_salary in irc_search_criteria.max_salary%TYPE
2090: ,p_effective_date in date
2091: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
2092: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
2093: ) IS
2094: --
2095: l_proc varchar2(72) := g_package || 'chk_salary_currency';
2096: l_salary_currency varchar2(1);

Line 2113: ( p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'

2109: -- already contain an error associated with the min_salary or max_salary
2110: -- columns.
2111: hr_utility.set_location(l_proc,15);
2112: if hr_multi_message.no_all_inclusive_error
2113: ( p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
2114: ,p_check_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'
2115: ) then
2116: --
2117: l_api_updating := irc_isc_shd.api_updating

Line 2114: ,p_check_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'

2110: -- columns.
2111: hr_utility.set_location(l_proc,15);
2112: if hr_multi_message.no_all_inclusive_error
2113: ( p_check_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
2114: ,p_check_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'
2115: ) then
2116: --
2117: l_api_updating := irc_isc_shd.api_updating
2118: (p_search_criteria_id => p_search_criteria_id

Line 2170: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'

2166: -- Multiple message list and associate the error with max_salary,
2167: -- min_salary and salary_currency columns.
2168: when app_exception.application_exception then
2169: if hr_multi_message.exception_add
2170: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
2171: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'
2172: ,p_associated_column3 => 'IRC_SEARCH_CRITERIA.SALARY_CURRENCY'
2173: ) then
2174: hr_utility.set_location(' Leaving:'||l_proc,70);

Line 2171: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'

2167: -- min_salary and salary_currency columns.
2168: when app_exception.application_exception then
2169: if hr_multi_message.exception_add
2170: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
2171: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'
2172: ,p_associated_column3 => 'IRC_SEARCH_CRITERIA.SALARY_CURRENCY'
2173: ) then
2174: hr_utility.set_location(' Leaving:'||l_proc,70);
2175: raise;

Line 2172: ,p_associated_column3 => 'IRC_SEARCH_CRITERIA.SALARY_CURRENCY'

2168: when app_exception.application_exception then
2169: if hr_multi_message.exception_add
2170: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.MIN_SALARY'
2171: ,p_associated_column2 => 'IRC_SEARCH_CRITERIA.MAX_SALARY'
2172: ,p_associated_column3 => 'IRC_SEARCH_CRITERIA.SALARY_CURRENCY'
2173: ) then
2174: hr_utility.set_location(' Leaving:'||l_proc,70);
2175: raise;
2176: end if;

Line 2208: (p_date_posted in irc_search_criteria.date_posted%TYPE

2204: --
2205: -- {End Of Comments}
2206: -- ----------------------------------------------------------------------------
2207: Procedure chk_date_posted
2208: (p_date_posted in irc_search_criteria.date_posted%TYPE
2209: ,p_effective_date in date
2210: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
2211: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
2212: ) IS

Line 2210: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

2206: -- ----------------------------------------------------------------------------
2207: Procedure chk_date_posted
2208: (p_date_posted in irc_search_criteria.date_posted%TYPE
2209: ,p_effective_date in date
2210: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
2211: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
2212: ) IS
2213: --
2214: l_proc varchar2(72) := g_package || 'chk_date_posted';

Line 2211: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

2207: Procedure chk_date_posted
2208: (p_date_posted in irc_search_criteria.date_posted%TYPE
2209: ,p_effective_date in date
2210: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
2211: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
2212: ) IS
2213: --
2214: l_proc varchar2(72) := g_package || 'chk_date_posted';
2215: l_api_updating boolean;

Line 2249: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.DATE_POSTED'

2245: hr_utility.set_location(' Leaving:'||l_proc,50);
2246: exception
2247: when app_exception.application_exception then
2248: if hr_multi_message.exception_add
2249: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.DATE_POSTED'
2250: ) then
2251: hr_utility.set_location(' Leaving:'||l_proc,60);
2252: raise;
2253: end if;

Line 2285: (p_employee in irc_search_criteria.employee%TYPE

2281: --
2282: -- {End Of Comments}
2283: -- ----------------------------------------------------------------------------
2284: Procedure chk_employee_contractor
2285: (p_employee in irc_search_criteria.employee%TYPE
2286: ,p_contractor in irc_search_criteria.contractor%TYPE
2287: ) IS
2288: --
2289: l_proc varchar2(72) := g_package || 'chk_employee_contractor';

Line 2286: ,p_contractor in irc_search_criteria.contractor%TYPE

2282: -- {End Of Comments}
2283: -- ----------------------------------------------------------------------------
2284: Procedure chk_employee_contractor
2285: (p_employee in irc_search_criteria.employee%TYPE
2286: ,p_contractor in irc_search_criteria.contractor%TYPE
2287: ) IS
2288: --
2289: l_proc varchar2(72) := g_package || 'chk_employee_contractor';
2290: l_api_updating boolean;

Line 2307: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.EMPLOYEE'

2303: --
2304: exception
2305: when app_exception.application_exception then
2306: if hr_multi_message.exception_add
2307: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.EMPLOYEE'
2308: ) then
2309: hr_utility.set_location(' Leaving:'||l_proc,60);
2310: raise;
2311: end if;

Line 2340: (p_keywords in irc_search_criteria.keywords%TYPE

2336: --
2337: -- {End Of Comments}
2338: -- ----------------------------------------------------------------------------
2339: Procedure chk_keywords
2340: (p_keywords in irc_search_criteria.keywords%TYPE
2341: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
2342: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
2343: ) IS
2344: --

Line 2341: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE

2337: -- {End Of Comments}
2338: -- ----------------------------------------------------------------------------
2339: Procedure chk_keywords
2340: (p_keywords in irc_search_criteria.keywords%TYPE
2341: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
2342: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
2343: ) IS
2344: --
2345: l_proc varchar2(72) := g_package || 'chk_keywords';

Line 2342: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE

2338: -- ----------------------------------------------------------------------------
2339: Procedure chk_keywords
2340: (p_keywords in irc_search_criteria.keywords%TYPE
2341: ,p_search_criteria_id in irc_search_criteria.search_criteria_id%TYPE
2342: ,p_object_version_number in irc_search_criteria.object_version_number%TYPE
2343: ) IS
2344: --
2345: l_proc varchar2(72) := g_package || 'chk_keywords';
2346: l_api_updating boolean;

Line 2382: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.KEYWORDS'

2378: hr_utility.set_location(' Leaving:'||l_proc,50);
2379: exception
2380: when app_exception.application_exception then
2381: if hr_multi_message.exception_add
2382: (p_associated_column1 => 'IRC_SEARCH_CRITERIA.KEYWORDS'
2383: ) then
2384: hr_utility.set_location(' Leaving:'||l_proc,60);
2385: raise;
2386: end if;