APPS.IRC_SEEKER_VAC_MATCHING_PKG dependencies on IRC_ALL_RECRUITING_SITES

Line 629: l_int_site irc_all_recruiting_sites.internal%type;

625: FUNCTION get_int_rec_site
626: ( p_vacancy_id per_all_vacancies.vacancy_id%type )
627: RETURN varchar2
628: IS
629: l_int_site irc_all_recruiting_sites.internal%type;
630: BEGIN
631:
632: SELECT 'Y' INTO l_int_site
633: FROM DUAL

Line 638: irc_all_recruiting_sites site

634: WHERE EXISTS ( SELECT 1
635: FROM per_all_vacancies vac ,
636: per_recruitment_activity_for praf ,
637: per_recruitment_activities pra ,
638: irc_all_recruiting_sites site
639: WHERE
640: vac.vacancy_id = praf.vacancy_id
641: AND praf.recruitment_activity_id = pra.recruitment_activity_id
642: AND trunc(sysdate) between pra.date_start and nvl(pra.date_end,sysdate)

Line 664: l_ext_site irc_all_recruiting_sites.external%type;

660: FUNCTION get_ext_rec_site
661: ( p_vacancy_id per_all_vacancies.vacancy_id%type )
662: RETURN varchar2
663: IS
664: l_ext_site irc_all_recruiting_sites.external%type;
665: BEGIN
666:
667: SELECT 'Y' INTO l_ext_site
668: FROM DUAL

Line 673: irc_all_recruiting_sites site

669: WHERE EXISTS ( SELECT 1
670: FROM per_all_vacancies vac ,
671: per_recruitment_activity_for praf ,
672: per_recruitment_activities pra ,
673: irc_all_recruiting_sites site
674: WHERE
675: vac.vacancy_id = praf.vacancy_id
676: AND praf.recruitment_activity_id = pra.recruitment_activity_id
677: AND trunc(sysdate) between pra.date_start and nvl(pra.date_end,sysdate)

Line 833: , irc_all_recruiting_sites site

829: , irc_posting_contents ipc
830: , irc_posting_contents_tl ipc_tl
831: , per_recruitment_activity_for praf
832: , per_recruitment_activities pra
833: , irc_all_recruiting_sites site
834: , per_all_vacancies vac
835: , hr_locations_all loc
836: WHERE
837: icrit_vac.object_type = ''VACANCY''

Line 1372: l_internal_site irc_all_recruiting_sites.internal%type;

1368: l_base_url VARCHAR2(250);
1369: e_no_base_url EXCEPTION;
1370: l_msg_sent NUMBER DEFAULT 0;
1371: l_date_registered date;
1372: l_internal_site irc_all_recruiting_sites.internal%type;
1373: l_external_site irc_all_recruiting_sites.external%type;
1374: l_proc VARCHAR2(30) default ' get_suitable_seekers_for_vac';
1375: BEGIN
1376: hr_utility.set_location('Entering'||l_proc, 10);

Line 1373: l_external_site irc_all_recruiting_sites.external%type;

1369: e_no_base_url EXCEPTION;
1370: l_msg_sent NUMBER DEFAULT 0;
1371: l_date_registered date;
1372: l_internal_site irc_all_recruiting_sites.internal%type;
1373: l_external_site irc_all_recruiting_sites.external%type;
1374: l_proc VARCHAR2(30) default ' get_suitable_seekers_for_vac';
1375: BEGIN
1376: hr_utility.set_location('Entering'||l_proc, 10);
1377: --