51: ||' , vac.budget_measurement_type'
52: ||' , vac.budget_measurement_value'
53: ||' , to_char(vac.date_from,''RRRR-MM-DD'') vacancy_start_date'
54: ||' , to_char(vac.date_to,''RRRR-MM-DD'') vacancy_end_date'
55: ||' , rtrim(nvl(fnd_profile.value(''IRC_FRAMEWORK_AGENT'')'
56: ||' ,fnd_profile.value(''APPS_FRAMEWORK_AGENT''))||'
57: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
58: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
59: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
52: ||' , vac.budget_measurement_value'
53: ||' , to_char(vac.date_from,''RRRR-MM-DD'') vacancy_start_date'
54: ||' , to_char(vac.date_to,''RRRR-MM-DD'') vacancy_end_date'
55: ||' , rtrim(nvl(fnd_profile.value(''IRC_FRAMEWORK_AGENT'')'
56: ||' ,fnd_profile.value(''APPS_FRAMEWORK_AGENT''))||'
57: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
58: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
59: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
60: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||';
53: ||' , to_char(vac.date_from,''RRRR-MM-DD'') vacancy_start_date'
54: ||' , to_char(vac.date_to,''RRRR-MM-DD'') vacancy_end_date'
55: ||' , rtrim(nvl(fnd_profile.value(''IRC_FRAMEWORK_AGENT'')'
56: ||' ,fnd_profile.value(''APPS_FRAMEWORK_AGENT''))||'
57: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
58: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
59: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
60: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||';
61: if(HR_MULTI_TENANCY_PKG.is_multi_tenant_system()) then
54: ||' , to_char(vac.date_to,''RRRR-MM-DD'') vacancy_end_date'
55: ||' , rtrim(nvl(fnd_profile.value(''IRC_FRAMEWORK_AGENT'')'
56: ||' ,fnd_profile.value(''APPS_FRAMEWORK_AGENT''))||'
57: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
58: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
59: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
60: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||';
61: if(HR_MULTI_TENANCY_PKG.is_multi_tenant_system()) then
62: l_query:=l_query ||' ''&OAMC=''||to_char(''R'')||' ;
62: l_query:=l_query ||' ''&OAMC=''||to_char(''R'')||' ;
63: end if;
64: l_query := l_query
65: ||' ''&p_site_id=''||to_char(rse.recruiting_site_id) application_url'
66: ||' , rtrim(fnd_profile.value(''APPS_FRAMEWORK_AGENT'')||'
67: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
68: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
69: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
70: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||'
63: end if;
64: l_query := l_query
65: ||' ''&p_site_id=''||to_char(rse.recruiting_site_id) application_url'
66: ||' , rtrim(fnd_profile.value(''APPS_FRAMEWORK_AGENT'')||'
67: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
68: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
69: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
70: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||'
71: ||' ''&p_site_id=''||to_char(rse.recruiting_site_id) int_application_url'
64: l_query := l_query
65: ||' ''&p_site_id=''||to_char(rse.recruiting_site_id) application_url'
66: ||' , rtrim(fnd_profile.value(''APPS_FRAMEWORK_AGENT'')||'
67: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
68: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
69: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
70: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||'
71: ||' ''&p_site_id=''||to_char(rse.recruiting_site_id) int_application_url'
72: ||' , irc_isc.object_id'
423: ''||
424: ''||
425: '';
426: else
427: l_stylesheet_url:=fnd_profile.value('APPS_FRAMEWORK_AGENT')||'/OA_HTML/'||p_stylesheet;
428: tv_sheet:= irc_xml_util.http_get_pieces(l_stylesheet_url,100);
429: lv_stylesheet:='';
430: for l_index in 1..tv_sheet.count loop
431: lv_stylesheet:=lv_stylesheet||tv_sheet(l_index);