');
Line 404: 'agent='||icx_plug_utilities.getPLSQLagent||'&'||
400: l_url := l_url||'&'||'arg'||to_char(i)||'='||l_plug_tab(i);
401: end if;
402: end loop;
403: l_url := l_url||'&'||'session_id='||to_char(session_id)||'&'||
404: 'agent='||icx_plug_utilities.getPLSQLagent||'&'||
405: 'page_id='||to_char(l_page_id);
406: return l_url;
407:
408: end getRegionURL;
Line 442: l_agent := icx_plug_utilities.getPLSQLagent;
438: --insert into icx_testing values ('session id in getnewregionurl ' || to_char(session_id));
439:
440: if icx_sec.g_mode_code = '115J' then
441:
442: l_agent := icx_plug_utilities.getPLSQLagent;
443: -- OAS approach
444: -- l_url:= '/OA_JAVA_SERV/oracle.apps.icx.myPage.renderPage';
445: -- Below is for Servlet approach
446: l_url := fnd_profile.value('APPS_SERVLET_AGENT')||'oracle.apps.icx.myPage.renderPage';
Line 457: l_agent := FND_WEB_CONFIG.WEB_SERVER || icx_plug_utilities.getPLSQLagent;
453: '&'||'server_name='||l_server_name||'&'||'port='||l_server_port;
454:
455:
456: elsif icx_sec.g_mode_code in ('115P', 'SLAVE') then
457: l_agent := FND_WEB_CONFIG.WEB_SERVER || icx_plug_utilities.getPLSQLagent;
458: l_url := l_agent || 'OracleConfigure.render?p_page_id='||page_id||
459: '&'||'p_region_id='||main_region_id||
460: '&'||'p_mode=0';
461: end if;
Line 464: l_agent := FND_WEB_CONFIG.WEB_SERVER || icx_plug_utilities.getPLSQLagent;
460: '&'||'p_mode=0';
461: end if;
462: */
463:
464: l_agent := FND_WEB_CONFIG.WEB_SERVER || icx_plug_utilities.getPLSQLagent;
465: l_url := l_agent || 'OracleConfigure.render?p_page_id='||page_id||
466: '&'||'p_region_id='||main_region_id||
467: '&'||'p_mode=0';
468:
Line 899: if (substr(icx_plug_utilities.getPLSQLagent, 1, 1) = '/') then
895:
896:
897: THEN
898: p_toggle:='Y'; -- will use different call to cabo container
899: if (substr(icx_plug_utilities.getPLSQLagent, 1, 1) = '/') then
900:
901: l_agent := FND_WEB_CONFIG.WEB_SERVER||
902: substr(icx_plug_utilities.getPLSQLagent,2);
903:
Line 902: substr(icx_plug_utilities.getPLSQLagent,2);
898: p_toggle:='Y'; -- will use different call to cabo container
899: if (substr(icx_plug_utilities.getPLSQLagent, 1, 1) = '/') then
900:
901: l_agent := FND_WEB_CONFIG.WEB_SERVER||
902: substr(icx_plug_utilities.getPLSQLagent,2);
903:
904: else
905: l_agent := FND_WEB_CONFIG.WEB_SERVER||icx_plug_utilities.getPLSQLagent;
906:
Line 905: l_agent := FND_WEB_CONFIG.WEB_SERVER||icx_plug_utilities.getPLSQLagent;
901: l_agent := FND_WEB_CONFIG.WEB_SERVER||
902: substr(icx_plug_utilities.getPLSQLagent,2);
903:
904: else
905: l_agent := FND_WEB_CONFIG.WEB_SERVER||icx_plug_utilities.getPLSQLagent;
906:
907: end if;
908: select a.version INTO l_resp_type
909: from FND_SECURITY_GROUPS_VL fsg,
Line 1042: l_agent := icx_plug_utilities.getPLSQLagent;
1038:
1039: --insert into icx_testing values ('session id in Home ' || to_char(l_session_id));
1040: --insert into icx_testing values ('g_mode_code in Home *' || icx_sec.g_mode_code);
1041:
1042: l_agent := icx_plug_utilities.getPLSQLagent;
1043:
1044: if home_url is not null then
1045: l_home_url := home_url;
1046: update ICX_SESSIONS
Line 1237: l_agent := icx_plug_utilities.getPLSQLagent;
1233:
1234: --insert into icx_testing values ('session id in Home ' || to_char(l_session_id));
1235: --insert into icx_testing values ('g_mode_code in Home *' || icx_sec.g_mode_code);
1236:
1237: l_agent := icx_plug_utilities.getPLSQLagent;
1238:
1239: select substr(nvl(DESCRIPTION,USER_NAME),1,70)
1240: into l_known_as
1241: from FND_USER
|