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.8.12010000.2 2009/02/05 07:26:34 sethanga ship $ */
3: AS
4:
5: -- ----------------------------------------------------------------------------

Line 883: irc_seeker_vac_matching_pkg.convert_vacancy_amount

879: OR (icrit_vac.max_salary is null)
880: OR (:salary_currency
881: <>icrit_vac.salary_currency
882: AND icrit_vac.max_salary >=
883: irc_seeker_vac_matching_pkg.convert_vacancy_amount
884: (:salary_currency
885: ,icrit_vac.salary_currency
886: ,:min_salary
887: ,sysdate

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

915: -- Keyword Match
916: l_sql:= l_sql||' AND (:keywords is null
917: or contains (ipc_tl.name,nvl(:keywords,''321Sys_Def123''),1)>0)';
918: -- Location Keyword Match
919: l_sql:= l_sql||' AND irc_seeker_vac_matching_pkg.get_location_match(:location,vac.location_id) > 0';
920: -- Location Distance Match
921: l_sql:= l_sql||' AND (
922: (:distance_to_location IS NOT NULL
923: AND loc.geometry IS NOT NULL

Line 1443: irc_seeker_vac_matching_pkg.convert_vacancy_amount

1439: OR (icrit.salary_currency is null)
1440: OR (icrit.min_salary is null)
1441: OR (:salary_currency<>icrit.salary_currency
1442: AND icrit.min_salary <=
1443: irc_seeker_vac_matching_pkg.convert_vacancy_amount
1444: (:salary_currency
1445: ,icrit.salary_currency
1446: ,:max_salary
1447: ,sysdate

Line 1916: END irc_seeker_vac_matching_pkg;

1912: hr_utility.set_location('Leaving'||l_proc, 80);
1913: END email_general_notifications;
1914:
1915: --
1916: END irc_seeker_vac_matching_pkg;