APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on CATSEARCH

Line 278: AND catsearch(loc.derived_locale, p_location_to_match, null) > 0;

274: l_return := 1;
275: ELSE
276: select count(*) into l_return from hr_locations_all loc
277: where LOC.location_id = p_location_id
278: AND catsearch(loc.derived_locale, p_location_to_match, null) > 0;
279: END IF;
280: --
281: RETURN l_return;
282: EXCEPTION

Line 998: and catsearch(loc_pref.derived_locale, :location, null ) > 0

994: hr_locations_all loc_pref
995: where ilp.object_type (+) = ''VACANCY''
996: and vac.vacancy_id = ilp.object_id(+)
997: and ilp.location_id = loc_pref.location_id
998: and catsearch(loc_pref.derived_locale, :location, null ) > 0
999: )
1000: )';
1001: -- Location Distance Match
1002: l_sql := l_sql || ' AND (

Line 1657: and catsearch(loc.derived_locale, icrit.location, null) > 0

1653: OR( icrit.location is not null
1654: AND ( exists ( select 1
1655: from hr_locations_all loc
1656: where loc.location_id = :location_id
1657: and catsearch(loc.derived_locale, icrit.location, null) > 0
1658: )
1659: OR exists ( select 1
1660: from irc_location_preferences ilp
1661: , hr_locations_all loc_pref

Line 1665: and catsearch(loc_pref.derived_locale, icrit.location, null) > 0

1661: , hr_locations_all loc_pref
1662: where ilp.object_type = ''VACANCY''
1663: and ilp.object_id = :vacancy_id
1664: and ilp.location_id = loc_pref.location_id
1665: and catsearch(loc_pref.derived_locale, icrit.location, null) > 0
1666: )
1667: )
1668: )
1669: ) ';