APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on IRC_SEEKER_VAC_MATCHING_PKG

Line 1: PACKAGE BODY irc_seeker_vac_matching_pkg

1: PACKAGE BODY irc_seeker_vac_matching_pkg
2: /* $Header: irjsmtch.pkb 120.18.12020000.2 2013/01/02 13:16:46 nitnaras ship $ */
3: AS
4:
5: -- ----------------------------------------------------------------------------

Line 955: irc_seeker_vac_matching_pkg.convert_vacancy_amount

951: OR (icrit_vac.salary_currency is null)
952: OR (icrit_vac.max_salary is null)
953: OR ( :salary_currency <> icrit_vac.salary_currency
954: AND icrit_vac.max_salary >=
955: irc_seeker_vac_matching_pkg.convert_vacancy_amount
956: (:salary_currency
957: ,icrit_vac.salary_currency
958: ,:min_salary
959: ,sysdate

Line 991: l_sql := l_sql || ' AND ( irc_seeker_vac_matching_pkg.get_location_match(:location,vac.location_id) > 0

987: l_sql := l_sql || ' AND ( :keywords is null
988: OR contains (ipc_tl.name,nvl(:keywords,''321Sys_Def123''),1)>0
989: )';
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''

Line 1621: AND icrit.min_salary <= irc_seeker_vac_matching_pkg.convert_vacancy_amount

1617: OR (:max_salary is null)
1618: OR (icrit.salary_currency is null)
1619: OR (icrit.min_salary is null)
1620: OR ( :salary_currency <> icrit.salary_currency
1621: AND icrit.min_salary <= irc_seeker_vac_matching_pkg.convert_vacancy_amount
1622: (:salary_currency
1623: ,icrit.salary_currency
1624: ,:max_salary
1625: ,sysdate

Line 2238: END irc_seeker_vac_matching_pkg;

2234: l_url := replace(p_message_text,'&IRC_HYPERLINK',l_url);
2235: --
2236: return l_url;
2237: END get_conclusion_msg;
2238: END irc_seeker_vac_matching_pkg;