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 IRC_ALL_RECRUITING_SITES

Line 698: l_int_site irc_all_recruiting_sites.internal%type;

694: FUNCTION get_int_rec_site
695: ( p_vacancy_id per_all_vacancies.vacancy_id%type )
696: RETURN varchar2
697: IS
698: l_int_site irc_all_recruiting_sites.internal%type;
699: BEGIN
700:
701: SELECT 'Y' INTO l_int_site
702: FROM DUAL

Line 707: irc_all_recruiting_sites site

703: WHERE EXISTS ( SELECT 1
704: FROM per_all_vacancies vac ,
705: per_recruitment_activity_for praf ,
706: per_recruitment_activities pra ,
707: irc_all_recruiting_sites site
708: WHERE
709: vac.vacancy_id = praf.vacancy_id
710: AND praf.recruitment_activity_id = pra.recruitment_activity_id
711: AND trunc(sysdate) between pra.date_start and nvl(pra.date_end,sysdate)

Line 733: l_ext_site irc_all_recruiting_sites.external%type;

729: FUNCTION get_ext_rec_site
730: ( p_vacancy_id per_all_vacancies.vacancy_id%type )
731: RETURN varchar2
732: IS
733: l_ext_site irc_all_recruiting_sites.external%type;
734: BEGIN
735:
736: SELECT 'Y' INTO l_ext_site
737: FROM DUAL

Line 742: irc_all_recruiting_sites site

738: WHERE EXISTS ( SELECT 1
739: FROM per_all_vacancies vac ,
740: per_recruitment_activity_for praf ,
741: per_recruitment_activities pra ,
742: irc_all_recruiting_sites site
743: WHERE
744: vac.vacancy_id = praf.vacancy_id
745: AND praf.recruitment_activity_id = pra.recruitment_activity_id
746: AND trunc(sysdate) between pra.date_start and nvl(pra.date_end,sysdate)

Line 907: , irc_all_recruiting_sites site

903: , irc_posting_contents ipc
904: , irc_posting_contents_tl ipc_tl
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

Line 1553: l_internal_site irc_all_recruiting_sites.internal%type;

1549: l_base_url VARCHAR2(250);
1550: e_no_base_url EXCEPTION;
1551: l_msg_sent NUMBER DEFAULT 0;
1552: l_date_registered date;
1553: l_internal_site irc_all_recruiting_sites.internal%type;
1554: l_external_site irc_all_recruiting_sites.external%type;
1555: l_proc VARCHAR2(30) default ' get_suitable_seekers_for_vac';
1556: BEGIN
1557: hr_utility.set_location('Entering'||l_proc, 10);

Line 1554: l_external_site irc_all_recruiting_sites.external%type;

1550: e_no_base_url EXCEPTION;
1551: l_msg_sent NUMBER DEFAULT 0;
1552: l_date_registered date;
1553: l_internal_site irc_all_recruiting_sites.internal%type;
1554: l_external_site irc_all_recruiting_sites.external%type;
1555: l_proc VARCHAR2(30) default ' get_suitable_seekers_for_vac';
1556: BEGIN
1557: hr_utility.set_location('Entering'||l_proc, 10);
1558: --