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_JPP_GENERATOR dependencies on FND_PROFILE

Line 77: ||' , rtrim(nvl(fnd_profile.value(''IRC_FRAMEWORK_AGENT'')'

73: ||' , vac.attribute20'
74: ||' , vac.attribute_category'
75: ||' , to_char(vac.date_from,''RRRR-MM-DD'') vacancy_start_date'
76: ||' , to_char(vac.date_to,''RRRR-MM-DD'') vacancy_end_date'
77: ||' , rtrim(nvl(fnd_profile.value(''IRC_FRAMEWORK_AGENT'')'
78: ||' ,fnd_profile.value(''APPS_FRAMEWORK_AGENT''))||'
79: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
80: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
81: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'

Line 78: ||' ,fnd_profile.value(''APPS_FRAMEWORK_AGENT''))||'

74: ||' , vac.attribute_category'
75: ||' , to_char(vac.date_from,''RRRR-MM-DD'') vacancy_start_date'
76: ||' , to_char(vac.date_to,''RRRR-MM-DD'') vacancy_end_date'
77: ||' , rtrim(nvl(fnd_profile.value(''IRC_FRAMEWORK_AGENT'')'
78: ||' ,fnd_profile.value(''APPS_FRAMEWORK_AGENT''))||'
79: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
80: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
81: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
82: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||';

Line 79: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'

75: ||' , to_char(vac.date_from,''RRRR-MM-DD'') vacancy_start_date'
76: ||' , to_char(vac.date_to,''RRRR-MM-DD'') vacancy_end_date'
77: ||' , rtrim(nvl(fnd_profile.value(''IRC_FRAMEWORK_AGENT'')'
78: ||' ,fnd_profile.value(''APPS_FRAMEWORK_AGENT''))||'
79: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
80: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
81: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
82: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||';
83: if(HR_MULTI_TENANCY_PKG.is_multi_tenant_system()) then

Line 80: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'

76: ||' , to_char(vac.date_to,''RRRR-MM-DD'') vacancy_end_date'
77: ||' , rtrim(nvl(fnd_profile.value(''IRC_FRAMEWORK_AGENT'')'
78: ||' ,fnd_profile.value(''APPS_FRAMEWORK_AGENT''))||'
79: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
80: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
81: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
82: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||';
83: if(HR_MULTI_TENANCY_PKG.is_multi_tenant_system()) then
84: l_query:=l_query ||' ''&OAMC=''||to_char(''R'')||' ;

Line 88: ||' , rtrim(fnd_profile.value(''APPS_FRAMEWORK_AGENT'')||'

84: l_query:=l_query ||' ''&OAMC=''||to_char(''R'')||' ;
85: end if;
86: l_query := l_query
87: ||' ''&p_site_id=''||to_char(rse.recruiting_site_id) application_url'
88: ||' , rtrim(fnd_profile.value(''APPS_FRAMEWORK_AGENT'')||'
89: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
90: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
91: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
92: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||'

Line 89: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'

85: end if;
86: l_query := l_query
87: ||' ''&p_site_id=''||to_char(rse.recruiting_site_id) application_url'
88: ||' , rtrim(fnd_profile.value(''APPS_FRAMEWORK_AGENT'')||'
89: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
90: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
91: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
92: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||'
93: ||' ''&p_site_id=''||to_char(rse.recruiting_site_id) int_application_url'

Line 90: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'

86: l_query := l_query
87: ||' ''&p_site_id=''||to_char(rse.recruiting_site_id) application_url'
88: ||' , rtrim(fnd_profile.value(''APPS_FRAMEWORK_AGENT'')||'
89: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
90: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
91: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
92: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||'
93: ||' ''&p_site_id=''||to_char(rse.recruiting_site_id) int_application_url'
94: ||' , irc_isc.object_id'

Line 483: l_stylesheet_url:=fnd_profile.value('APPS_FRAMEWORK_AGENT')||'/OA_HTML/'||p_stylesheet;

479: else
480: if(p_stylesheet_content is not null) then
481: lv_stylesheet:=p_stylesheet_content;
482: else
483: l_stylesheet_url:=fnd_profile.value('APPS_FRAMEWORK_AGENT')||'/OA_HTML/'||p_stylesheet;
484: tv_sheet:= irc_xml_util.http_get_pieces(l_stylesheet_url,100);
485: lv_stylesheet:='';
486: for l_index in 1..tv_sheet.count loop
487: lv_stylesheet:=lv_stylesheet||tv_sheet(l_index);

Line 597: ||' , rtrim(nvl(fnd_profile.value(''IRC_FRAMEWORK_AGENT'')'

593: ||' , vac.budget_measurement_value'
594: ||' , to_char(vac.date_from,''RRRR-MM-DD'') vacancy_start_date'
595: ||' , to_char(vac.date_to,''RRRR-MM-DD'') vacancy_end_date'
596: ||' , (select name from hr_all_organization_units where organization_id=vac.business_group_id) organization_name'
597: ||' , rtrim(nvl(fnd_profile.value(''IRC_FRAMEWORK_AGENT'')'
598: ||' ,fnd_profile.value(''APPS_FRAMEWORK_AGENT''))||'
599: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
600: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
601: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'

Line 598: ||' ,fnd_profile.value(''APPS_FRAMEWORK_AGENT''))||'

594: ||' , to_char(vac.date_from,''RRRR-MM-DD'') vacancy_start_date'
595: ||' , to_char(vac.date_to,''RRRR-MM-DD'') vacancy_end_date'
596: ||' , (select name from hr_all_organization_units where organization_id=vac.business_group_id) organization_name'
597: ||' , rtrim(nvl(fnd_profile.value(''IRC_FRAMEWORK_AGENT'')'
598: ||' ,fnd_profile.value(''APPS_FRAMEWORK_AGENT''))||'
599: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
600: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
601: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
602: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||';

Line 599: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'

595: ||' , to_char(vac.date_to,''RRRR-MM-DD'') vacancy_end_date'
596: ||' , (select name from hr_all_organization_units where organization_id=vac.business_group_id) organization_name'
597: ||' , rtrim(nvl(fnd_profile.value(''IRC_FRAMEWORK_AGENT'')'
598: ||' ,fnd_profile.value(''APPS_FRAMEWORK_AGENT''))||'
599: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
600: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
601: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
602: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||';
603: if(HR_MULTI_TENANCY_PKG.is_multi_tenant_system()) then

Line 600: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'

596: ||' , (select name from hr_all_organization_units where organization_id=vac.business_group_id) organization_name'
597: ||' , rtrim(nvl(fnd_profile.value(''IRC_FRAMEWORK_AGENT'')'
598: ||' ,fnd_profile.value(''APPS_FRAMEWORK_AGENT''))||'
599: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
600: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
601: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
602: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||';
603: if(HR_MULTI_TENANCY_PKG.is_multi_tenant_system()) then
604: l_query:=l_query ||' ''&OAMC=''||to_char(''R'')||' ;

Line 608: ||' , rtrim(fnd_profile.value(''APPS_FRAMEWORK_AGENT'')||'

604: l_query:=l_query ||' ''&OAMC=''||to_char(''R'')||' ;
605: end if;
606: l_query := l_query
607: ||' ''&p_site_id=''||to_char(rse.recruiting_site_id) application_url'
608: ||' , rtrim(fnd_profile.value(''APPS_FRAMEWORK_AGENT'')||'
609: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
610: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
611: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
612: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||'

Line 609: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'

605: end if;
606: l_query := l_query
607: ||' ''&p_site_id=''||to_char(rse.recruiting_site_id) application_url'
608: ||' , rtrim(fnd_profile.value(''APPS_FRAMEWORK_AGENT'')||'
609: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
610: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
611: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
612: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||'
613: ||' ''&p_site_id=''||to_char(rse.recruiting_site_id) int_application_url'

Line 610: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'

606: l_query := l_query
607: ||' ''&p_site_id=''||to_char(rse.recruiting_site_id) application_url'
608: ||' , rtrim(fnd_profile.value(''APPS_FRAMEWORK_AGENT'')||'
609: ||' fnd_profile.value(''ICX_PREFIX''),''/'')||''/OA_HTML/OA.jsp?OAFunc=''||'
610: ||' fnd_profile.value(''IRC_JOB_NOTIFICATION_URL'')||'
611: ||' ''&p_svid=''||to_char(vac.vacancy_id)||'
612: ||' ''&p_spid=''||to_char(ipc.posting_content_id)||'
613: ||' ''&p_site_id=''||to_char(rse.recruiting_site_id) int_application_url'
614: ||' , vac.*'