535: from FND_SECURITY_GROUPS_VL fsg,
536: FND_RESPONSIBILITY_VL a,
537: FND_USER_RESP_GROUPS b,
538: fnd_menus m 539: where b.user_id = icx_sec.g_user_id 540: AND a.menu_id = m.menu_id
541: and b.start_date <= sysdate
542: and (b.end_date is null or b.end_date > sysdate)
543: and b.RESPONSIBILITY_id = a.responsibility_id
Line 556: if icx_sec.validateSession
552: ORDER BY a.RESPONSIBILITY_NAME, fsg.SECURITY_GROUP_NAME;
553:
554: begin
555: 556: if icx_sec.validateSession 557: then
558:
559: -- 2758891 nlbarlow APPLICATIONS_HOME_PAGE
560: if (icx_sec.g_mode_code = '115X') then -- Oracle Portal, nlbarlow
Line 560: if (icx_sec.g_mode_code = '115X') then -- Oracle Portal, nlbarlow
556: if icx_sec.validateSession
557: then
558:
559: -- 2758891 nlbarlow APPLICATIONS_HOME_PAGE 560: if (icx_sec.g_mode_code = '115X') then -- Oracle Portal, nlbarlow 561:
562: fnd_profile.get(name => 'APPS_PORTAL',
563: val => l_url);
564:
Line 582: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
Line 610: elsif (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE') and
606: owa_util.mime_header('text/html', FALSE);
607: owa_util.redirect_url(l_url);
608: owa_util.http_header_close;
609: 610: elsif (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE') and 611: tab_context_flag = 'ON') then
612:
613: OracleMyPage.DrawTabContent;
614:
Line 641: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
637:
638: if P is null
639: then
640: 641: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID); 642: if NVL(l_responsibility_id, -1) = -1
643: then
644: open responsibilities;
645: fetch responsibilities into l_resp_appl_id,
Line 671: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
667: end if;
668:
669: if (D is null) then
670: -- check to see if need to get page for new style or old style page. 671: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then 672:
673: l_session_id := icx_sec.getsessioncookie;
674:
675: select page_id into l_page_id
Line 673: l_session_id := icx_sec.getsessioncookie;
669: if (D is null) then
670: -- check to see if need to get page for new style or old style page.
671: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
672: 673: l_session_id := icx_sec.getsessioncookie; 674:
675: select page_id into l_page_id
676: from icx_sessions
677: where session_id = l_session_id;
Line 685: where b.user_id = icx_sec.g_user_id
681: select display_name
682: into l_name
683: from icx_page_plugs a,
684: icx_pages b 685: where b.user_id = icx_sec.g_user_id 686: and b.page_id = a.page_id
687: and a.page_id = l_page_id
688: and a.responsibility_id = -1
689: and a.menu_id = -1;
Line 728: where b.USER_ID = icx_sec.g_user_id
724: select DISPLAY_NAME
725: into l_name
726: from ICX_PAGE_PLUGS a,
727: ICX_PAGES b 728: where b.USER_ID = icx_sec.g_user_id 729: and b.PAGE_ID = a.PAGE_ID
730: and a.RESPONSIBILITY_ID = -1
731: and a.MENU_ID = -1
732: and b.page_id in (select MIN(page_id)
Line 734: where user_id = icx_sec.g_user_id
730: and a.RESPONSIBILITY_ID = -1
731: and a.MENU_ID = -1
732: and b.page_id in (select MIN(page_id)
733: from ICX_PAGES 734: where user_id = icx_sec.g_user_id 735: and PAGE_TYPE = 'USER');
736: exception
737: when no_data_found then
738: l_name := null;
Line 761: where user_id = icx_sec.g_user_id
757: and fff.function_id = fme.function_id
758: and fff.function_name = 'ICX_NAVIGATE_PLUG'
759: and ipp.page_id in (select MIN(page_id)
760: from ICX_PAGES 761: where user_id = icx_sec.g_user_id 762: and PAGE_TYPE = 'USER');
763: exception
764: when no_data_found then
765: l_name := null;
Line 792: l_security_group_id := icx_sec.g_security_group_id;
788: END IF;
789:
790: if S is null
791: then 792: l_security_group_id := icx_sec.g_security_group_id; 793: else
794: l_security_group_id := S;
795: end if;
796:
Line 815: where b.USER_ID = icx_sec.g_user_id
811: l_security_group_name
812: from FND_SECURITY_GROUPS_VL fsg,
813: FND_RESPONSIBILITY_VL a,
814: FND_USER_RESP_GROUPS b 815: where b.USER_ID = icx_sec.g_user_id 816: and a.APPLICATION_ID = b.RESPONSIBILITY_APPLICATION_ID
817: and a.RESPONSIBILITY_ID = b.RESPONSIBILITY_ID
818: and a.RESPONSIBILITY_ID = l_responsibility_id
819: and b.SECURITY_GROUP_ID = fsg.SECURITY_GROUP_ID
Line 914: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
910: htp.p('');
911:
912: htp.p('');
913: 914: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then 915: htp.p('
');
916: else
917: htp.p('');
918: end if;
Line 928: if ( substr(icx_sec.g_mode_code,1,3) = '115' or
924: cattributes => 'NAME="functionwindowfocus"');
925: htp.formHidden('X','FALSE');
926: htp.formClose;
927: 928: if ( substr(icx_sec.g_mode_code,1,3) = '115' or 929: icx_sec.g_mode_code = 'SLAVE')
930: then
931: l_target := '_self';
932: else
Line 929: icx_sec.g_mode_code = 'SLAVE')
925: htp.formHidden('X','FALSE');
926: htp.formClose;
927:
928: if ( substr(icx_sec.g_mode_code,1,3) = '115' or 929: icx_sec.g_mode_code = 'SLAVE') 930: then
931: l_target := '_self';
932: else
933: l_target := '_top';
Line 936: p_language_code => icx_sec.g_language_code,
Line 1107: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR
1103: htp.p(l_url);
1104: end if;
1105: end if;
1106: /* 1107: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR 1108: icx_sec.g_mode_code = 'SLAVE')
1109: then
1110: IF ((g_list(i).FUNCTION_TYPE = 'WWK') OR (g_list(i).FUNCTION_TYPE = 'FORM')) THEN
1111: l_url := 'javascript:top.main.icx_nav_window('''||g_list(i).FUNCTION_TYPE||''','''||l_url||''', '''||icx_util.replace_quotes(g_list(i).PROMPT)||''')';
Line 1108: icx_sec.g_mode_code = 'SLAVE')
1104: end if;
1105: end if;
1106: /*
1107: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR 1108: icx_sec.g_mode_code = 'SLAVE') 1109: then
1110: IF ((g_list(i).FUNCTION_TYPE = 'WWK') OR (g_list(i).FUNCTION_TYPE = 'FORM')) THEN
1111: l_url := 'javascript:top.main.icx_nav_window('''||g_list(i).FUNCTION_TYPE||''','''||l_url||''', '''||icx_util.replace_quotes(g_list(i).PROMPT)||''')';
1112: END IF;
Line 1172: end if; --icx_sec.validatesession
1168:
1169: htp.p('');
1170:
1171: --htp.p('');--mputman debug 1172: end if; --icx_sec.validatesession 1173:
1174: end if; -- icx_sec.g_mode_code in ('115J', '115P');
1175:
1176: --added end if;
Line 1174: end if; -- icx_sec.g_mode_code in ('115J', '115P');
1170:
1171: --htp.p('');--mputman debug
1172: end if; --icx_sec.validatesession
1173: 1174: end if; -- icx_sec.g_mode_code in ('115J', '115P'); 1175:
1176: --added end if;
1177: end if;
1178:
Line 1226: where b.user_id = icx_sec.g_user_id
1222: fnd_responsibility_vl a,
1223: FND_USER_RESP_GROUPS b,
1224: FND_APPLICATION fa,
1225: FND_MENUS m 1226: where b.user_id = icx_sec.g_user_id 1227: AND m.menu_id = a.menu_id
1228: and version in ('4','W')
1229: and b.start_date <= sysdate
1230: and (b.end_date is null or b.end_date > sysdate)
Line 1247: elsif icx_sec.validatePlugSession(p_plug_id,p_session_id)
1243:
1244: if p_delete = 'Y'
1245: then
1246: l_agent := l_agent; 1247: elsif icx_sec.validatePlugSession(p_plug_id,p_session_id) 1248: then
1249: /*
1250: ** The agent must have the web server in front of it to ensure
1251: ** it works in ie javascript. The problem is if your running the
Line 1287: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR
1283:
1284: htp.p('
');
1285: htp.p('
');
1286: 1287: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR 1288: icx_sec.g_mode_code = 'SLAVE')
1289: then
1290: l_target := '_self';
1291: else
Line 1288: icx_sec.g_mode_code = 'SLAVE')
1284: htp.p('
');
1285: htp.p('
');
1286:
1287: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR 1288: icx_sec.g_mode_code = 'SLAVE') 1289: then
1290: l_target := '_self';
1291: else
1292: l_target := '_top';
Line 1428: where USER_ID = icx_sec.g_user_id
1424: URL,
1425: WEB_HTML_CALL
1426: from FND_FORM_FUNCTIONS_VL b,
1427: ICX_CUSTOM_MENU_ENTRIES a 1428: where USER_ID = icx_sec.g_user_id 1429: and PLUG_ID = p_plug_id
1430: and b.FUNCTION_ID(+) = a.FUNCTION_ID
1431: and ( RESPONSIBILITY_ID in
1432: (select responsibility_id from
Line 1434: where USER_ID=icx_sec.g_user_id
1430: and b.FUNCTION_ID(+) = a.FUNCTION_ID
1431: and ( RESPONSIBILITY_ID in
1432: (select responsibility_id from
1433: icx_custom_menu_entries 1434: where USER_ID=icx_sec.g_user_id 1435: intersect
1436: select RESPONSIBILITY_ID from fnd_user_resp_groups where
1437: USER_ID=icx_sec.g_user_id
1438: and
Line 1437: USER_ID=icx_sec.g_user_id
1433: icx_custom_menu_entries
1434: where USER_ID=icx_sec.g_user_id
1435: intersect
1436: select RESPONSIBILITY_ID from fnd_user_resp_groups where 1437: USER_ID=icx_sec.g_user_id 1438: and
1439: start_date <= sysdate
1440: and
1441: (end_date is null or end_date > sysdate)
Line 1450: where USER_ID = icx_sec.g_user_id
1446: if p_delete = 'Y'
1447: then
1448: begin
1449: delete ICX_CUSTOM_MENU_ENTRIES 1450: where USER_ID = icx_sec.g_user_id 1451: and PLUG_ID = p_plug_id;
1452: exception
1453: when others then
1454: l_agent := l_agent;
Line 1457: elsif icx_sec.validatePlugSession(p_plug_id,p_session_id)
1453: when others then
1454: l_agent := l_agent;
1455: end;
1456: 1457: elsif icx_sec.validatePlugSession(p_plug_id,p_session_id) 1458: then
1459: /*
1460: ** The agent must have the web server in front of it to ensure
1461: ** it works in ie javascript. The problem is if your running the
Line 1532: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR
1528:
1529: htp.p('
');
1530: htp.p('');
1531: htp.p(''); 1532: if ( substr(icx_sec.g_mode_code,1,3) = '115' OR 1533: icx_sec.g_mode_code = 'SLAVE')
1534: then
1535: htp.anchor(curl => 'javascript:top.main.icx_nav_window(''WWK'','''||l_url||''','''||f.PROMPT||''')',
1536: ctext => f.PROMPT,
1796: fsg.SECURITY_GROUP_NAME
1797: from FND_SECURITY_GROUPS_VL fsg,
1798: fnd_responsibility_vl a,
1799: FND_USER_RESP_GROUPS b 1800: where b.user_id = icx_sec.g_user_id 1801: and b.start_date <= sysdate
1802: and (b.end_date is null or b.end_date > sysdate)
1803: and b.RESPONSIBILITY_id = a.responsibility_id
1804: and b.RESPONSIBILITY_application_id = a.application_id
Line 1823: where USER_ID = icx_sec.g_user_id
1819: FUNCTION_ID,
1820: FUNCTION_TYPE,
1821: URL
1822: from ICX_CUSTOM_MENU_ENTRIES 1823: where USER_ID = icx_sec.g_user_id 1824: and PLUG_ID = l_plug_id
1825: order by DISPLAY_SEQUENCE;
1826:
1827: begin
Line 1829: if(icx_sec.validateSession)
1825: order by DISPLAY_SEQUENCE;
1826:
1827: begin
1828: 1829: if(icx_sec.validateSession) 1830: then
1831: l_plug_id := icx_call.decrypt2(X);
1832: icx_util.getprompts(601, 'ICX_OBIS_FAVORITES', l_title, l_prompts);
1833: l_title := icx_plug_utilities.getPlugTitle(l_plug_id);
Line 1854: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
1850: htp.p('
');
1851: htp.p(''||l_title||'');
1852: htp.p('');
1853: 1854: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then 1855: htp.p('');
1856: else
1857: htp.p('');
1858: end if;
Line 2042: p_language_code => icx_sec.g_language_code,