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.

[Home] [Help]

APPS.ICX_PLUG_UTILITIES dependencies on ICX_SEC

Line 15: where USER_ID = icx_sec.g_user_id;

11: begin
12: select BACKGROUND_COLOR
13: into l_color
14: from ICX_PAGE_COLOR_SCHEME
15: where USER_ID = icx_sec.g_user_id;
16: exception
17: when others then
18: l_color := '##CCCCCC';
19: end;

Line 39: where USER_ID = icx_sec.g_user_id;

35: begin
36: select BACKGROUND_COLOR
37: into l_color
38: from ICX_PAGE_COLOR_SCHEME
39: where USER_ID = icx_sec.g_user_id;
40: exception
41: when others then
42: l_color := '##FFFFFF';
43: end;

Line 62: where USER_ID = icx_sec.g_user_id;

58: begin
59: select HEADING_COLOR
60: into l_color
61: from ICX_PAGE_COLOR_SCHEME
62: where USER_ID = icx_sec.g_user_id;
63: exception
64: when others then
65: l_color := '#99CCFF';
66: end;

Line 82: where USER_ID = icx_sec.g_user_id;

78: begin
79: select HEADING_COLOR
80: into l_color
81: from ICX_PAGE_COLOR_SCHEME
82: where USER_ID = icx_sec.g_user_id;
83: exception
84: when others then
85: l_color := '#99CCFF';
86: end;

Line 104: where USER_ID = icx_sec.g_user_id;

100: begin
101: select BANNER_COLOR
102: into l_color
103: from ICX_PAGE_COLOR_SCHEME
104: where USER_ID = icx_sec.g_user_id;
105: exception
106: when others then
107: l_color := '#99CCFF';
108: end;

Line 124: where USER_ID = icx_sec.g_user_id;

120: begin
121: select COLOR_SCHEME
122: into l_color
123: from ICX_PAGE_COLOR_SCHEME
124: where USER_ID = icx_sec.g_user_id;
125: exception
126: when others then
127: l_color := 'BL';
128: end;

Line 145: where USER_ID = icx_sec.g_user_id;

141: begin
142: select BANNER_COLOR
143: into l_color
144: from ICX_PAGE_COLOR_SCHEME
145: where USER_ID = icx_sec.g_user_id;
146: exception
147: when others then
148: l_color := '#99CCFF';
149: end;

Line 167: where USER_ID = icx_sec.g_user_id;

163: begin
164: select TOOLBAR_COLOR
165: into l_color
166: from ICX_PAGE_COLOR_SCHEME
167: where USER_ID = icx_sec.g_user_id;
168: exception
169: when others then
170: l_color := '#0000CC';
171: end;

Line 189: where USER_ID = icx_sec.g_user_id;

185: begin
186: select COLOR_SCHEME
187: into l_color
188: from ICX_PAGE_COLOR_SCHEME
189: where USER_ID = icx_sec.g_user_id;
190: exception
191: when others then
192: l_color := 'BL';
193: end;

Line 224: if (substr(icx_sec.g_mode_code,1,3) = '115' or

220: index3 := LENGTHB(dad_url)+1;
221:
222: l_agent := substrb(dad_url,index2,index3-index2);
223:
224: if (substr(icx_sec.g_mode_code,1,3) = '115' or
225: icx_sec.g_mode_code = 'SLAVE')
226: then
227: l_agent := ltrim(l_agent,'/');
228: end if;

Line 225: icx_sec.g_mode_code = 'SLAVE')

221:
222: l_agent := substrb(dad_url,index2,index3-index2);
223:
224: if (substr(icx_sec.g_mode_code,1,3) = '115' or
225: icx_sec.g_mode_code = 'SLAVE')
226: then
227: l_agent := ltrim(l_agent,'/');
228: end if;
229:

Line 305: if ( substr(icx_sec.g_mode_code,1,3) = '115' or

301: l_menu varchar2(240);
302:
303: begin
304:
305: if ( substr(icx_sec.g_mode_code,1,3) = '115' or
306: icx_sec.g_mode_code = 'SLAVE')
307: then
308: l_menu := owa_util.get_cgi_env('SCRIPT_NAME')||'/oraclemypage.home';
309: else

Line 306: icx_sec.g_mode_code = 'SLAVE')

302:
303: begin
304:
305: if ( substr(icx_sec.g_mode_code,1,3) = '115' or
306: icx_sec.g_mode_code = 'SLAVE')
307: then
308: l_menu := owa_util.get_cgi_env('SCRIPT_NAME')||'/oraclemypage.home';
309: else
310: l_host_instance := FND_WEB_CONFIG.DATABASE_ID;

Line 348: if ( substr(icx_sec.g_mode_code,1,3) = '115' or

344:
345: begin
346:
347: l_Customize := icx_util.getPrompt(601,'ICX_OBIS_NAVIGATE',178,'ICX_CUSTOMIZE');
348: if ( substr(icx_sec.g_mode_code,1,3) = '115' or
349: icx_sec.g_mode_code = 'SLAVE')
350: then
351: l_color := '#6699CC'; --'#000066';
352: l_text_color := '#ffffff';

Line 349: icx_sec.g_mode_code = 'SLAVE')

345: begin
346:
347: l_Customize := icx_util.getPrompt(601,'ICX_OBIS_NAVIGATE',178,'ICX_CUSTOMIZE');
348: if ( substr(icx_sec.g_mode_code,1,3) = '115' or
349: icx_sec.g_mode_code = 'SLAVE')
350: then
351: l_color := '#6699CC'; --'#000066';
352: l_text_color := '#ffffff';
353: l_text_face := 'Arial';

Line 397: if substr(icx_sec.g_mode_code,1,3) <> '115'

393: htf.anchor(curl => p_edit_URL,
394: ctext => l_Customize,
395: cattributes => 'TARGET="_top" onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_Customize)||''';return true"')||'');
396: end if;
397: if substr(icx_sec.g_mode_code,1,3) <> '115'
398: then
399: htp.p('');
400: end if;
401: htp.p('');

Line 418: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR

414:
415: begin
416:
417: l_Customize := icx_util.getPrompt(601,'ICX_OBIS_NAVIGATE',178,'ICX_CUSTOMIZE');
418: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR
419: icx_sec.g_mode_code = 'SLAVE')
420: then
421: l_color := '#6699CC'; --'#000066';
422: else

Line 419: icx_sec.g_mode_code = 'SLAVE')

415: begin
416:
417: l_Customize := icx_util.getPrompt(601,'ICX_OBIS_NAVIGATE',178,'ICX_CUSTOMIZE');
418: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR
419: icx_sec.g_mode_code = 'SLAVE')
420: then
421: l_color := '#6699CC'; --'#000066';
422: else
423: l_color := icx_plug_utilities.bannercolor;

Line 483: if icx_sec.g_function_type = 'WWK'

479: end if;
480:
481: if p_function
482: then
483: if icx_sec.g_function_type = 'WWK'
484: then
485: htp.p('function windowunload() {
486: parent.opener.parent.main.document.functionwindowfocus.X.value = "FALSE";
487: };');

Line 524: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

520: begin
521:
522: if p_language_code is null
523: then
524: l_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
525: else
526: l_language_code := p_language_code;
527: end if;
528:

Line 551: if icx_sec.g_function_type = 'WWK' then

547:
548: ');
549:
550: if (p_disp_menu = 'Y') then
551: if icx_sec.g_function_type = 'WWK' then
552: l_href := 'javascript:window.close();';
553: else
554:
555: --l_href := 'javascript:top.location.href = ''OracleMyPage.DrawTabContent'||''';';
Line 557: l_href := 'javascript:top.location.href = ''OracleNavigate.Responsibility?P='||icx_sec.g_responsibility_id||''';';

553: else
554:
555: --l_href := 'javascript:top.location.href = ''OracleMyPage.DrawTabContent'||''';';
556:
557: l_href := 'javascript:top.location.href = ''OracleNavigate.Responsibility?P='||icx_sec.g_responsibility_id||''';';
558: end if;
559:
560: -- toolbar_icon_menu_active.gif and toolbar_icon_menu.gif
561: htp.p('
');
812:
813: if (p_disp_menu = 'Y' and l_session_mode <> 'SLAVE') then
814: if icx_sec.g_function_type = 'WWK' then
815: l_menu := 'javascript:window.close();';
816: else
817: l_menu := 'javascript:top.location.href = ''OracleNavigate.Responsibility?P='||icx_sec.g_responsibility_id||''';';
818: end if;
Line 817: l_menu := 'javascript:top.location.href = ''OracleNavigate.Responsibility?P='||icx_sec.g_responsibility_id||''';';

813: if (p_disp_menu = 'Y' and l_session_mode <> 'SLAVE') then
814: if icx_sec.g_function_type = 'WWK' then
815: l_menu := 'javascript:window.close();';
816: else
817: l_menu := 'javascript:top.location.href = ''OracleNavigate.Responsibility?P='||icx_sec.g_responsibility_id||''';';
818: end if;
819: htp.tableData(htf.anchor(l_menu,
820: htf.img('/OA_MEDIA/FNDMENU.gif',
821: 'CENTER',

Line 830: if icx_sec.g_function_type = 'WWK' then

826: ||''';return true" TARGET="_top"'));
827: end if;
828:
829: if (p_disp_mainmenu = 'Y' and l_session_mode <> 'SLAVE') then
830: if icx_sec.g_function_type = 'WWK' then
831: l_menu := 'javascript:parent.opener.location.href = ''/OA_JAVA_SERV/oracle.apps.icx.myPage.MainMenu?dbHost='||l_host_instance||'&'||'agent='||l_agent||''';window.close();';
832: else
833: l_menu := 'javascript:top.location.href = ''/OA_JAVA_SERV/oracle.apps.icx.myPage.MainMenu?dbHost='||l_host_instance||'&'||'agent='||l_agent||''';';
834: end if;

Line 570: if icx_sec.g_function_type = 'WWK' then

566: if (p_disp_mainmenu = 'Y') then
567: l_host_instance := FND_WEB_CONFIG.DATABASE_ID;
568: l_agent := icx_plug_utilities.getPLSQLagent;
569:
570: if icx_sec.g_function_type = 'WWK' then
571: l_href := 'javascript:parent.opener.location.href = '''||owa_util.get_cgi_env('SCRIPT_NAME')||'/oraclemypage.home'';window.close();';
572: else
573: l_href := 'javascript:top.location.href = '''||owa_util.get_cgi_env('SCRIPT_NAME')||'/oraclemypage.home'';';
574: end if;

Line 676: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR

672: l_menu_id number;
673:
674: begin
675:
676: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR
677: icx_sec.g_mode_code = 'SLAVE')
678: then
679:
680: begin

Line 677: icx_sec.g_mode_code = 'SLAVE')

673:
674: begin
675:
676: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR
677: icx_sec.g_mode_code = 'SLAVE')
678: then
679:
680: begin
681: select menu_id

Line 684: where session_id = icx_sec.g_session_id;

680: begin
681: select menu_id
682: into l_menu_id
683: from icx_sessions
684: where session_id = icx_sec.g_session_id;
685: exception
686: when no_data_found then
687: l_menu_id := null;
688: end;

Line 725: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);

721: l_text := p_text;
722: end if;
723:
724: if p_language_code is null then
725: v_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
726: else
727: v_language_code := p_language_code;
728: end if;
729:

Line 730: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);

726: else
727: v_language_code := p_language_code;
728: end if;
729:
730: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
731: l_session_mode := icx_sec.getID(icx_sec.PV_SESSION_MODE);
732: if l_session_mode is null
733: then
734: l_session_mode := 'OBIS';

Line 731: l_session_mode := icx_sec.getID(icx_sec.PV_SESSION_MODE);

727: v_language_code := p_language_code;
728: end if;
729:
730: l_session_id := icx_sec.getID(icx_sec.PV_SESSION_ID);
731: l_session_mode := icx_sec.getID(icx_sec.PV_SESSION_MODE);
732: if l_session_mode is null
733: then
734: l_session_mode := 'OBIS';
735: end if;

Line 814: if icx_sec.g_function_type = 'WWK' then

810:
811: htp.p('