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_SEEKER_VAC_MATCHING_PKG dependencies on HR_LOCATIONS_ALL

Line 226: , hr_locations_all loc

222: , vac.recruiter_id
223: , vac.primary_posting_id
224: FROM irc_search_criteria isc
225: , per_all_vacancies vac
226: , hr_locations_all loc
227: WHERE isc.object_type = 'VACANCY'
228: AND isc.object_id = vac.vacancy_id
229: AND vac.location_id = loc.location_id (+)
230: AND vac.status = 'APPROVED'

Line 264: p_location_id IN hr_locations_all.LOCATION_ID%TYPE)

260: is not */
261:
262: FUNCTION get_location_match
263: ( p_location_to_match IN varchar2,
264: p_location_id IN hr_locations_all.LOCATION_ID%TYPE)
265: RETURN number
266: IS
267: l_location_to_match VARCHAR2(240);
268: l_return NUMBER;

Line 276: select count(*) into l_return from hr_locations_all loc

272: if p_location_to_match IS NULL
273: THEN
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: --

Line 909: , hr_locations_all loc

905: , per_recruitment_activity_for praf
906: , per_recruitment_activities pra
907: , irc_all_recruiting_sites site
908: , per_all_vacancies vac
909: , hr_locations_all loc
910: WHERE icrit_vac.object_type = ''VACANCY''
911: AND icrit_vac.object_id = vac.vacancy_id
912: AND vac.location_id = loc.location_id(+)
913: AND vac.vacancy_id = praf.vacancy_id

Line 994: hr_locations_all loc_pref

990: -- Location Keyword Match
991: l_sql := l_sql || ' AND ( irc_seeker_vac_matching_pkg.get_location_match(:location,vac.location_id) > 0
992: OR exists( select ilp.location_id
993: from irc_location_preferences ilp,
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

Line 1007: hr_locations_all loc_pref

1003: ( :distance_to_location IS NOT NULL
1004: AND ( loc.geometry IS NOT NULL
1005: OR exists ( select 1
1006: from irc_location_preferences ilp,
1007: hr_locations_all loc_pref
1008: where ilp.object_type (+) = ''VACANCY''
1009: and vac.vacancy_id = ilp.object_id(+)
1010: and ilp.location_id = loc_pref.location_id
1011: and loc_pref.geometry IS NOT NULL

Line 1024: hr_locations_all loc_pref

1020: ||'' units=MILE''
1021: ) = ''TRUE''
1022: OR exists ( select 1
1023: from irc_location_preferences ilp,
1024: hr_locations_all loc_pref
1025: where ilp.object_type (+) = ''VACANCY''
1026: and vac.vacancy_id = ilp.object_id(+)
1027: and ilp.location_id = loc_pref.location_id
1028: and locator_within_distance (loc_pref.geometry

Line 1044: hr_locations_all loc_pref

1040: ( :geocode_country IS NOT NULL
1041: AND ( loc.country = :geocode_country
1042: OR exists ( select 1
1043: from irc_location_preferences ilp,
1044: hr_locations_all loc_pref
1045: where ilp.object_type (+) = ''VACANCY''
1046: and vac.vacancy_id = ilp.object_id(+)
1047: and ilp.location_id = loc_pref.location_id
1048: and loc_pref.country = :geocode_country

Line 1064: hr_locations_all loc_pref

1060: l_sql := l_sql || ' AND ( ( :location_id is not null
1061: AND ( vac.location_id = :location_id
1062: OR exists( select ilp.location_id
1063: from irc_location_preferences ilp,
1064: hr_locations_all loc_pref
1065: where ilp.object_type (+) = ''VACANCY''
1066: and vac.vacancy_id = ilp.object_id(+)
1067: and ilp.location_id = loc_pref.location_id
1068: and ilp.location_id = :location_id

Line 1079: hr_locations_all loc_pref

1075: l_sql := l_sql || ' AND ( ( exists (select 1 from irc_location_criteria_values irc_lcv
1076: where ( loc.derived_locale = irc_lcv.derived_locale
1077: OR exists ( select ilp.location_id
1078: from irc_location_preferences ilp,
1079: hr_locations_all loc_pref
1080: where ilp.object_type (+) = ''VACANCY''
1081: and vac.vacancy_id = ilp.object_id(+)
1082: and ilp.location_id = loc_pref.location_id
1083: and loc_pref.derived_locale = irc_lcv.derived_locale

Line 1579: --, hr_locations_all loc

1575: , ppf.person_id
1576: FROM irc_search_criteria icrit
1577: , per_all_people_f ppf
1578: , irc_posting_contents_tl ipc_tl
1579: --, hr_locations_all loc
1580: , irc_notification_preferences inp
1581: WHERE icrit.object_type = ''WPREF''
1582: AND icrit.object_id = ppf.person_id
1583: AND ipc_tl.posting_content_id = :posting_content_id

Line 1655: from hr_locations_all loc

1651: -- Location Keyword Match
1652: l_sql := l_sql || ' AND ( icrit.location is null
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

Line 1661: , hr_locations_all loc_pref

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
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

Line 1672: from hr_locations_all loc2

1668: )
1669: ) ';
1670: -- Location Distance Match
1671: l_sql := l_sql||' AND ( ( exists(select 1
1672: from hr_locations_all loc2
1673: where loc2.location_id = :location_id
1674: and icrit.geometry.sdo_point.x is not null
1675: and loc2.geometry is not null
1676: and locator_within_distance

Line 1686: , hr_locations_all loc_pref

1682: )= ''TRUE''
1683: )
1684: OR exists (select 1
1685: from irc_location_preferences ilp
1686: , hr_locations_all loc_pref
1687: where ilp.object_type = ''VACANCY''
1688: and ilp.object_id = :vacancy_id
1689: and ilp.location_id = loc_pref.location_id
1690: and icrit.geometry.sdo_point.x is not null

Line 1708: , hr_locations_all loc_pref

1704: OR ( icrit.geocode_country IS NOT NULL
1705: AND ( icrit.geocode_country = :country
1706: OR exists ( select 1
1707: from irc_location_preferences ilp
1708: , hr_locations_all loc_pref
1709: where ilp.object_type = ''VACANCY''
1710: and ilp.object_id = :vacancy_id
1711: and ilp.location_id = loc_pref.location_id
1712: and loc_pref.country = icrit.geocode_country

Line 1724: , hr_locations_all loc_pref

1720: l_sql := l_sql || ' AND ( ( icrit.location_id is not null
1721: AND ( icrit.location_id = :location_id
1722: OR exists ( select 1
1723: from irc_location_preferences ilp
1724: , hr_locations_all loc_pref
1725: where ilp.object_type = ''VACANCY''
1726: and ilp.object_id = :vacancy_id
1727: and ilp.location_id = loc_pref.location_id
1728: and loc_pref.location_id = icrit.location_id

Line 1742: ,hr_locations_all loc_pref

1738: )
1739: )
1740: OR (exists (select 1 from irc_location_criteria_values irc_lcv
1741: ,irc_location_preferences ilp
1742: ,hr_locations_all loc_pref
1743: where irc_lcv.search_criteria_id = icrit.search_criteria_id
1744: and ilp.object_type = ''VACANCY''
1745: and ilp.object_id = :vacancy_id
1746: and ilp.location_id = loc_pref.location_id