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.ORACLEMYPAGE dependencies on ICX_SEC

Line 17: if icx_sec.g_language_code in ('F')

13:
14: l_HTML_tag varchar2(240);
15: begin
16:
17: if icx_sec.g_language_code in ('F')
18: then
19: l_HTML_tag := '';
20: OracleMyPage.g_start := 'RIGHT';
21: OracleMyPage.g_end := 'LEFT';

Line 76: and d.user_id = icx_sec.g_user_id

72: and b.ENTRY_SEQUENCE = c.ENTRY_SEQUENCE
73: and c.FUNCTION_ID = a.FUNCTION_ID
74: and a.type in ('WWL','WWLG')
75: and b.RESPONSIBILITY_ID = d.RESPONSIBILITY_ID
76: and d.user_id = icx_sec.g_user_id
77: and d.start_date <= sysdate
78: and (d.end_date is null or d.end_date > sysdate)
79: and b.RESPONSIBILITY_ID = e.RESPONSIBILITY_ID
80: and e.start_date <= sysdate

Line 112: and d.user_id = icx_sec.g_user_id

108: and b.ENTRY_SEQUENCE = c.ENTRY_SEQUENCE
109: and c.FUNCTION_ID = a.FUNCTION_ID
110: and a.type in ('WWR','WWRG')
111: and b.RESPONSIBILITY_ID = d.RESPONSIBILITY_ID
112: and d.user_id = icx_sec.g_user_id
113: and d.start_date <= sysdate
114: and (d.end_date is null or d.end_date > sysdate)
115: and b.RESPONSIBILITY_ID = e.RESPONSIBILITY_ID
116: and e.start_date <= sysdate

Line 125: if (icx_sec.validateSession)

121:
122: select HSECS into l_start from V$TIMER;
123: l_hsecs := l_start;
124:
125: if (icx_sec.validateSession)
126: then
127: begin
128: select PAGE_ID,REFRESH_RATE
129: into l_page_id,l_refresh_rate

Line 131: where USER_ID = icx_sec.g_user_id;

127: begin
128: select PAGE_ID,REFRESH_RATE
129: into l_page_id,l_refresh_rate
130: from ICX_PAGES
131: where USER_ID = icx_sec.g_user_id;
132: exception
133: when NO_DATA_FOUND then
134: htp.p('Add page creation code here');
135: end;

Line 139: l_date := to_char(sysdate,icx_sec.g_date_format);

135: end;
136:
137: fnd_message.set_name('ICX','ICX_LOGIN_CUSTOMIZE');
138: l_customize_page := fnd_message.get;
139: l_date := to_char(sysdate,icx_sec.g_date_format);
140:
141: htp.p('');
142: htp.p(''||l_title||'');
143: if l_refresh_rate > 0

Line 231: '(p_session_id => '||icx_sec.g_session_id||

227:
228: select HSECS into l_hsecs from V$TIMER;
229:
230: l_stmt_str := 'begin '||l.web_html_call||
231: '(p_session_id => '||icx_sec.g_session_id||
232: ',p_plug_id => '||l.plug_id||
233: ',p_display_name => '''||replace(l.prompt,'''','''''')||''');'||
234: ' end;';
235: execute immediate l_stmt_str;

Line 254: '(p_session_id => '||icx_sec.g_session_id||

250:
251: select HSECS into l_hsecs from V$TIMER;
252:
253: l_stmt_str := 'begin '||r.web_html_call||
254: '(p_session_id => '||icx_sec.g_session_id||
255: ',p_plug_id => '||r.plug_id||
256: ',p_display_name => '''||replace(r.prompt,'''','''''')||''');'||
257: ' end;';
258: execute immediate l_stmt_str;

Line 437: --insert into icx_testing values ('g_rendering_mode ' || icx_sec.g_mode_code);

433:
434: /* Only support 115P
435: l_dbhost := FND_WEB_CONFIG.DATABASE_ID;
436:
437: --insert into icx_testing values ('g_rendering_mode ' || icx_sec.g_mode_code);
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:

Line 440: if icx_sec.g_mode_code = '115J' then

436:
437: --insert into icx_testing values ('g_rendering_mode ' || icx_sec.g_mode_code);
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';

Line 456: elsif icx_sec.g_mode_code in ('115P', 'SLAVE') then

452: '&'||'session_id='||to_char(session_id)||'&'||'agent='||l_agent||
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';

Line 567: icx_sec.g_security_group_id := l_sgid;

563:
564: END;
565:
566: END IF;
567: icx_sec.g_security_group_id := l_sgid;
568:
569:
570: if i_1 is not null then
571: l_message := icx_sec.validatePassword(c_user_name => i_1,

Line 571: l_message := icx_sec.validatePassword(c_user_name => i_1,

567: icx_sec.g_security_group_id := l_sgid;
568:
569:
570: if i_1 is not null then
571: l_message := icx_sec.validatePassword(c_user_name => i_1,
572: c_user_password => i_2,
573: n_session_id => l_session_id,
574: c_validate_only => 'Y',
575: c_mode_code => l_mode_code);

Line 576: icx_sec.g_session_id:=l_session_id;--MPUTMAN ADDED 2456610

572: c_user_password => i_2,
573: n_session_id => l_session_id,
574: c_validate_only => 'Y',
575: c_mode_code => l_mode_code);
576: icx_sec.g_session_id:=l_session_id;--MPUTMAN ADDED 2456610
577: if home_url is not null
578: then
579: l_url := home_url;
580: update ICX_SESSIONS

Line 585: l_session_id := icx_sec.getsessioncookie;

581: set HOME_URL = l_url
582: where SESSION_ID = l_session_id;
583: end if;
584: else
585: l_session_id := icx_sec.getsessioncookie;
586: end if;
587:
588: if (l_session_id > 0
589: and icx_sec.validateSessionPrivate(c_session_id => l_session_id,

Line 589: and icx_sec.validateSessionPrivate(c_session_id => l_session_id,

585: l_session_id := icx_sec.getsessioncookie;
586: end if;
587:
588: if (l_session_id > 0
589: and icx_sec.validateSessionPrivate(c_session_id => l_session_id,
590: c_validate_only => 'Y'))
591: then
592:
593: -- 1588724 nlbarlow added flags

Line 594: icx_sec.g_validateSession_flag := false;

590: c_validate_only => 'Y'))
591: then
592:
593: -- 1588724 nlbarlow added flags
594: icx_sec.g_validateSession_flag := false;
595:
596: -- 2758891 nlbarlow APPLICATIONS_HOME_PAGE
597: if fnd_profile.value('APPLICATIONS_HOME_PAGE') = 'FWK'
598: then

Line 605: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),

601: from FND_FORM_FUNCTIONS
602: where FUNCTION_NAME = 'OAHOMEPAGE';
603:
604: l_url := icx_portlet.createExecLink
605: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
606: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
607: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
608: p_function_id => l_function_id,
609: p_url_only => 'Y');

Line 606: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),

602: where FUNCTION_NAME = 'OAHOMEPAGE';
603:
604: l_url := icx_portlet.createExecLink
605: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
606: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
607: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
608: p_function_id => l_function_id,
609: p_url_only => 'Y');
610:

Line 607: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),

603:
604: l_url := icx_portlet.createExecLink
605: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
606: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
607: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
608: p_function_id => l_function_id,
609: p_url_only => 'Y');
610:
611: htp.p('');
622: END IF; -- FWK
623:
624: icx_sec.g_validateSession_flag := true;
625:
626: else -- session fails
627:
628: begin

Line 669: icx_sec.g_validateSession_flag := true;

665: p_home_url => home_url);
666: --
667: NULL;
668: when others then
669: icx_sec.g_validateSession_flag := true;
670: htp.p(SQLERRM);
671:
672: end;
673:

Line 699: where b.user_id = icx_sec.g_user_id

695: from FND_SECURITY_GROUPS_VL fsg,
696: fnd_responsibility_vl a,
697: FND_USER_RESP_GROUPS b,
698: FND_APPLICATION fa
699: where b.user_id = icx_sec.g_user_id
700: and b.start_date <= sysdate
701: and (b.end_date is null or b.end_date > sysdate)
702: and b.RESPONSIBILITY_id = a.responsibility_id
703: and b.RESPONSIBILITY_application_id = a.application_id

Line 728: where b.user_id = icx_sec.g_user_id

724: from FND_SECURITY_GROUPS_VL fsg,
725: fnd_responsibility_vl a,
726: FND_USER_RESP_GROUPS b,
727: FND_APPLICATION fa
728: where b.user_id = icx_sec.g_user_id
729: and b.start_date <= sysdate
730: and (b.end_date is null or b.end_date > sysdate)
731: and b.RESPONSIBILITY_id = a.responsibility_id
732: and b.RESPONSIBILITY_application_id = a.application_id

Line 806: l_session_id := icx_sec.getsessioncookie;

802:
803: BEGIN
804:
805: -- nlbarlow null out ids on return to home
806: l_session_id := icx_sec.getsessioncookie;
807:
808: icx_sec.updateSessionContext(p_application_id => '',
809: p_responsibility_id => '',
810: p_security_group_id => '',

Line 808: icx_sec.updateSessionContext(p_application_id => '',

804:
805: -- nlbarlow null out ids on return to home
806: l_session_id := icx_sec.getsessioncookie;
807:
808: icx_sec.updateSessionContext(p_application_id => '',
809: p_responsibility_id => '',
810: p_security_group_id => '',
811: p_session_id => l_session_id);
812:

Line 813: if (icx_sec.validatesession) THEN --1503616 mputman

809: p_responsibility_id => '',
810: p_security_group_id => '',
811: p_session_id => l_session_id);
812:
813: if (icx_sec.validatesession) THEN --1503616 mputman
814: -- 2758891 nlbarlow APPLICATIONS_HOME_PAGE
815: if (icx_sec.g_mode_code = '115X') then -- Oracle Portal, nlbarlow
816:
817: fnd_profile.get(name => 'APPS_PORTAL',

Line 815: if (icx_sec.g_mode_code = '115X') then -- Oracle Portal, nlbarlow

811: p_session_id => l_session_id);
812:
813: if (icx_sec.validatesession) THEN --1503616 mputman
814: -- 2758891 nlbarlow APPLICATIONS_HOME_PAGE
815: if (icx_sec.g_mode_code = '115X') then -- Oracle Portal, nlbarlow
816:
817: fnd_profile.get(name => 'APPS_PORTAL',
818: val => l_url);
819:

Line 837: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),

833: from FND_FORM_FUNCTIONS
834: where FUNCTION_NAME = 'OAHOMEPAGE';
835:
836: l_url := icx_portlet.createExecLink
837: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
838: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
839: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
840: p_function_id => l_function_id,
841: p_url_only => 'Y');

Line 838: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),

834: where FUNCTION_NAME = 'OAHOMEPAGE';
835:
836: l_url := icx_portlet.createExecLink
837: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
838: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
839: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
840: p_function_id => l_function_id,
841: p_url_only => 'Y');
842:

Line 839: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),

835:
836: l_url := icx_portlet.createExecLink
837: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
838: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
839: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
840: p_function_id => l_function_id,
841: p_url_only => 'Y');
842:
843: owa_util.mime_header('text/html', FALSE);

Line 856: l_user_id:=icx_sec.g_user_id;

852: l_target:='_top';
853: icx_util.getprompts(601, 'ICX_OBIS_NAVIGATE', l_title, l_prompts);
854:
855: p_display_name:=l_prompts(1);
856: l_user_id:=icx_sec.g_user_id;
857:
858: select count(*) into l_page_count
859: from icx_pages
860: where user_id = l_user_id;

Line 1008: p_target_url:=l_agent||'OracleNavigate.Responsibility?P='||icx_call.encrypt2(r.responsibility_id,icx_sec.g_session_id)||'&'

1004: ||r.security_group_id||'*'
1005: ||l_agent||'**]')||'&p_mode=W';
1006: ELSE
1007:
1008: p_target_url:=l_agent||'OracleNavigate.Responsibility?P='||icx_call.encrypt2(r.responsibility_id,icx_sec.g_session_id)||'&'
1009: ||'D='||wfa_html.conv_special_url_chars(p_display_name)||'&'
1010: ||'S='||r.security_group_id||'&'
1011: ||'tab_context_flag=OFF'||'&'
1012: ||'M=9999';

Line 1030: if (icx_sec.validatesession) then

1026: select HSECS into l_start from V$TIMER;
1027: l_hsecs := l_start;
1028:
1029: if validate_flag = 'Y' then
1030: if (icx_sec.validatesession) then
1031: l_session_id := icx_sec.g_session_id;
1032: end if;
1033: else
1034: l_session_id := icx_sec.g_session_id;

Line 1031: l_session_id := icx_sec.g_session_id;

1027: l_hsecs := l_start;
1028:
1029: if validate_flag = 'Y' then
1030: if (icx_sec.validatesession) then
1031: l_session_id := icx_sec.g_session_id;
1032: end if;
1033: else
1034: l_session_id := icx_sec.g_session_id;
1035: end if;

Line 1034: l_session_id := icx_sec.g_session_id;

1030: if (icx_sec.validatesession) then
1031: l_session_id := icx_sec.g_session_id;
1032: end if;
1033: else
1034: l_session_id := icx_sec.g_session_id;
1035: end if;
1036:
1037: if (l_session_id > 0) then
1038:

Line 1040: --insert into icx_testing values ('g_mode_code in Home *' || icx_sec.g_mode_code);

1036:
1037: if (l_session_id > 0) then
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

Line 1056: where USER_ID = icx_sec.g_user_id;

1052:
1053: select substr(nvl(DESCRIPTION,USER_NAME),1,70)
1054: into l_known_as
1055: from FND_USER
1056: where USER_ID = icx_sec.g_user_id;
1057:
1058: -- get active page_id
1059: select page_id into l_active_page_id
1060: from icx_sessions

Line 1081: where user_id = icx_sec.g_user_id

1077: l_helptitle := '';
1078:
1079: select count(*) into l_page_count
1080: from icx_pages
1081: where user_id = icx_sec.g_user_id
1082: and page_type = 'MAIN';
1083:
1084: if ( l_page_count = 0 ) then
1085: -- user has no MAIN page, create a page for user

Line 1096: for thisPage in getPages(icx_sec.g_user_id) loop

1092: RAISE no_nls_exception;
1093: END IF;
1094: end if;
1095: l_page_index := 0;
1096: for thisPage in getPages(icx_sec.g_user_id) loop
1097: l_page_id := thisPage.page_id;
1098: l_page_name := thisPage.page_name;
1099: l_main_region_id := thisPage.main_region_id;
1100: --htp.p(l_page_id);

Line 1132: --l_url := getRegionURL(icx_sec.g_user_id, l_session_id, l_page_id);

1128: l_tabs(l_page_index).text := l_page_name;
1129: l_tabs(l_page_index).hint := l_page_name;
1130: l_tabs(l_page_index).visible := 'true';
1131: l_tabs(l_page_index).enabled := 'true';
1132: --l_url := getRegionURL(icx_sec.g_user_id, l_session_id, l_page_id);
1133: l_url := getNewRegionURL(l_main_region_id, l_page_id, icx_sec.g_user_id, l_session_id);
1134: l_tabs(l_page_index).url := l_url;
1135:
1136:

Line 1133: l_url := getNewRegionURL(l_main_region_id, l_page_id, icx_sec.g_user_id, l_session_id);

1129: l_tabs(l_page_index).hint := l_page_name;
1130: l_tabs(l_page_index).visible := 'true';
1131: l_tabs(l_page_index).enabled := 'true';
1132: --l_url := getRegionURL(icx_sec.g_user_id, l_session_id, l_page_id);
1133: l_url := getNewRegionURL(l_main_region_id, l_page_id, icx_sec.g_user_id, l_session_id);
1134: l_tabs(l_page_index).url := l_url;
1135:
1136:
1137: l_page_index := l_page_index + 1;

Line 1180: END IF; --icx_sec.validatesession mputman 1503616

1176:
1177:
1178: end if; --l_session_id
1179: end if; -- PHP vs Portal
1180: END IF; --icx_sec.validatesession mputman 1503616
1181:
1182: EXCEPTION
1183: -- added 1378862 mputman
1184: WHEN no_nls_exception THEN

Line 1232: if (icx_sec.validatesession) then

1228:
1229: begin
1230:
1231:
1232: if (icx_sec.validatesession) then
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:

Line 1235: --insert into icx_testing values ('g_mode_code in Home *' || icx_sec.g_mode_code);

1231:
1232: if (icx_sec.validatesession) then
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)

Line 1242: where USER_ID = icx_sec.g_user_id;

1238:
1239: select substr(nvl(DESCRIPTION,USER_NAME),1,70)
1240: into l_known_as
1241: from FND_USER
1242: where USER_ID = icx_sec.g_user_id;
1243:
1244: -- get active page_id
1245: select page_id into l_active_page_id
1246: from icx_sessions

Line 1247: where session_id = icx_sec.g_session_id;

1243:
1244: -- get active page_id
1245: select page_id into l_active_page_id
1246: from icx_sessions
1247: where session_id = icx_sec.g_session_id;
1248:
1249: fnd_message.set_name('ICX','ICX_LOGIN_WELCOME');
1250: fnd_message.set_token('USER',l_known_as);
1251: l_toolbar.title := icx_util.replace_quotes(fnd_message.get); --added call to replace quotes 2637147

Line 1269: for thisPage in getPages(icx_sec.g_user_id) loop

1265: l_helpmsg := '';
1266: l_helptitle := '';
1267:
1268: l_page_index := 0;
1269: for thisPage in getPages(icx_sec.g_user_id) loop
1270: l_page_id := thisPage.page_id;
1271: l_page_name := thisPage.page_name;
1272: l_main_region_id := thisPage.main_region_id;
1273:

Line 1304: l_url := getNewRegionURL(l_main_region_id, l_page_id, icx_sec.g_user_id, l_session_id);

1300: l_tabs(l_page_index).hint := l_page_name;
1301: l_tabs(l_page_index).visible := 'true';
1302: l_tabs(l_page_index).enabled := 'true';
1303:
1304: l_url := getNewRegionURL(l_main_region_id, l_page_id, icx_sec.g_user_id, l_session_id);
1305:
1306: l_tabs(l_page_index).url := l_url;
1307:
1308: l_page_index := l_page_index + 1;

Line 1330: p_url => l_agent || 'OracleNavigate.Responsibility?tab_context_flag=OFF?P='|| icx_call.encrypt2(icx_sec.g_responsibility_id));

1326: p_helptitle => l_helptitle,
1327: p_tabicons => l_tabicons,
1328: p_currenttab => l_active_tab_index,
1329: p_tabs => l_tabs,
1330: p_url => l_agent || 'OracleNavigate.Responsibility?tab_context_flag=OFF?P='|| icx_call.encrypt2(icx_sec.g_responsibility_id));
1331:
1332: end if; --icx_sec.validatesession
1333:
1334: end;

Line 1332: end if; --icx_sec.validatesession

1328: p_currenttab => l_active_tab_index,
1329: p_tabs => l_tabs,
1330: p_url => l_agent || 'OracleNavigate.Responsibility?tab_context_flag=OFF?P='|| icx_call.encrypt2(icx_sec.g_responsibility_id));
1331:
1332: end if; --icx_sec.validatesession
1333:
1334: end;
1335:
1336: