DBA Data[Home] [Help]

APPS.ORACLENAVIGATE dependencies on ICX_SEC

Line 130: fnd_global.apps_initialize(icx_sec.g_user_id,

126: end if;
127:
128:
129:
130: fnd_global.apps_initialize(icx_sec.g_user_id,
131: p_object.responsibility_id,
132: p_object.resp_appl_id,
133: p_object.security_group_id);
134:

Line 469: p_language_code => icx_sec.g_language_code,

465: htp.formHidden('X','FALSE');
466: htp.formClose;
467:
468: icx_plug_utilities.toolbar(p_text => l_title,
469: p_language_code => icx_sec.g_language_code,
470: p_disp_help => 'Y',
471: p_disp_exit => 'Y',
472: p_disp_menu => 'N');
473:

Line 539: where b.user_id = icx_sec.g_user_id

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'),

578: from FND_FORM_FUNCTIONS
579: where FUNCTION_NAME = 'OAHOMEPAGE';
580:
581: l_url := icx_portlet.createExecLink
582: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
583: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
584: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
585: p_function_id => l_function_id,
586: p_url_only => 'Y');

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

579: where FUNCTION_NAME = 'OAHOMEPAGE';
580:
581: l_url := icx_portlet.createExecLink
582: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
583: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
584: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
585: p_function_id => l_function_id,
586: p_url_only => 'Y');
587:

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

580:
581: l_url := icx_portlet.createExecLink
582: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
583: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
584: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
585: p_function_id => l_function_id,
586: p_url_only => 'Y');
587:
588: owa_util.mime_header('text/html', FALSE);

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

596: from FND_FORM_FUNCTIONS
597: where FUNCTION_NAME = 'FND_NAVIGATE_PAGE';
598:
599: l_url := icx_portlet.createExecLink
600: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
601: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
602: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
603: p_function_id => l_function_id,
604: p_url_only => 'Y');

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

597: where FUNCTION_NAME = 'FND_NAVIGATE_PAGE';
598:
599: l_url := icx_portlet.createExecLink
600: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
601: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
602: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
603: p_function_id => l_function_id,
604: p_url_only => 'Y');
605:

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

598:
599: l_url := icx_portlet.createExecLink
600: (p_application_id => nvl(icx_sec.g_resp_appl_id,'-1'),
601: p_responsibility_id => nvl(icx_sec.g_responsibility_id,'-1'),
602: p_security_group_id => nvl(icx_sec.g_security_group_id,'0'),
603: p_function_id => l_function_id,
604: p_url_only => 'Y');
605:
606: owa_util.mime_header('text/html', FALSE);

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('

Web Analytics Made Easy -StatCounter
');
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,

932: else
933: l_target := '_top';
934:
935: icx_plug_utilities.toolbar(p_text => l_title,
936: p_language_code => icx_sec.g_language_code,
937: p_disp_help => 'Y',
938: p_disp_exit => 'Y',
939: p_disp_menu => 'N');
940: end if;

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(''||f.prompt||'');
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,

Line 1533: icx_sec.g_mode_code = 'SLAVE')

1529: htp.p('

');
1530: htp.p(''||f.prompt||'');
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,
1537: cattributes => ' onMouseOver="window.status='''||l_url||''';return true"');

Line 1571: if(icx_sec.validateSession)

1567: c_error_msg varchar2(240);
1568:
1569: begin
1570:
1571: if(icx_sec.validateSession)
1572: then
1573: icx_util.getprompts(601, 'ICX_OBIS_FAVORITE_CREATE', l_title, l_prompts);
1574:
1575: htp.p('');

Line 1580: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then

1576: htp.p('');
1577: htp.p(''||l_title||'');
1578: htp.p('

Web Analytics Made Easy -StatCounter
');
1579:
1580: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
1581: htp.p('');
1582: else
1583: htp.p('');
1584: end if;

Line 1668: if(icx_sec.validateSession)

1664: c_error_msg varchar2(240);
1665:
1666: begin
1667:
1668: if(icx_sec.validateSession)
1669: then
1670: icx_util.getprompts(601, 'ICX_OBIS_FAVORITE_RENAME', l_title, l_prompts);
1671:
1672:

Line 1677: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then

1673: htp.p('');
1674: htp.p('');
1675: htp.p(''||l_title||'');
1676: htp.p('

Web Analytics Made Easy -StatCounter
');
1677: if (icx_sec.g_mode_code in ('115J', '115P', 'SLAVE')) then
1678: htp.p('');
1679: else
1680: htp.p('');
1681: end if;

Line 1779: l_responsibilities icx_sec.g_char_tbl_type;

1775: l_title varchar2(80);
1776: l_favorite varchar2(2000); --changed from 80 to 2000 bug#1333631, mputman
1777: l_prompts icx_util.g_prompts_table;
1778: l_message varchar2(2000);
1779: l_responsibilities icx_sec.g_char_tbl_type;
1780: l_resp_appl_ids icx_sec.g_num_tbl_type;
1781: l_responsibility_ids icx_sec.g_num_tbl_type;
1782: l_security_group_ids icx_sec.g_num_tbl_type;
1783: l_initialize varchar2(80);

Line 1780: l_resp_appl_ids icx_sec.g_num_tbl_type;

1776: l_favorite varchar2(2000); --changed from 80 to 2000 bug#1333631, mputman
1777: l_prompts icx_util.g_prompts_table;
1778: l_message varchar2(2000);
1779: l_responsibilities icx_sec.g_char_tbl_type;
1780: l_resp_appl_ids icx_sec.g_num_tbl_type;
1781: l_responsibility_ids icx_sec.g_num_tbl_type;
1782: l_security_group_ids icx_sec.g_num_tbl_type;
1783: l_initialize varchar2(80);
1784: r_initialize varchar2(80);

Line 1781: l_responsibility_ids icx_sec.g_num_tbl_type;

1777: l_prompts icx_util.g_prompts_table;
1778: l_message varchar2(2000);
1779: l_responsibilities icx_sec.g_char_tbl_type;
1780: l_resp_appl_ids icx_sec.g_num_tbl_type;
1781: l_responsibility_ids icx_sec.g_num_tbl_type;
1782: l_security_group_ids icx_sec.g_num_tbl_type;
1783: l_initialize varchar2(80);
1784: r_initialize varchar2(80);
1785: l_nbsp varchar2(240);

Line 1782: l_security_group_ids icx_sec.g_num_tbl_type;

1778: l_message varchar2(2000);
1779: l_responsibilities icx_sec.g_char_tbl_type;
1780: l_resp_appl_ids icx_sec.g_num_tbl_type;
1781: l_responsibility_ids icx_sec.g_num_tbl_type;
1782: l_security_group_ids icx_sec.g_num_tbl_type;
1783: l_initialize varchar2(80);
1784: r_initialize varchar2(80);
1785: l_nbsp varchar2(240);
1786: l_history varchar2(240);

Line 1800: where b.user_id = icx_sec.g_user_id

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('

Web Analytics Made Easy -StatCounter
');
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,

2038:
2039: htp.p('');
2040:
2041: icx_plug_utilities.toolbar(p_text => l_title,
2042: p_language_code => icx_sec.g_language_code,
2043: p_disp_help => 'Y',
2044: p_disp_mainmenu => 'N',
2045: p_disp_menu => 'N');
2046:

Line 2196: if icx_sec.validateSession

2192: c_error_msg varchar2(240);
2193:
2194: begin
2195:
2196: if icx_sec.validateSession
2197: then
2198: l_plug_id := icx_call.decrypt2(Y);
2199: l_length := length(X);
2200: l_index := 0;

Line 2205: where USER_ID = icx_sec.g_user_id

2201: l_occurence := 1;
2202: l_lastcount := 1;
2203:
2204: delete ICX_CUSTOM_MENU_ENTRIES
2205: where USER_ID = icx_sec.g_user_id
2206: and PLUG_ID = l_plug_id;
2207:
2208: while l_lastcount <= l_length loop
2209: l_nextcount := instr(X,'+',1,l_occurence);

Line 2250: (icx_sec.g_user_id,

2246: FUNCTION_ID,
2247: FUNCTION_TYPE,
2248: URL)
2249: values
2250: (icx_sec.g_user_id,
2251: l_plug_id,
2252: l_index,
2253: l_prompt,
2254: l_resp_appl_id,

Line 2301: IF icx_sec.ValidateSession THEN

2297: l_web_call VARCHAR2(2000);
2298: l_url VARCHAR2(2000);
2299:
2300: BEGIN
2301: IF icx_sec.ValidateSession THEN
2302:
2303: icx_on_utilities.unpack_parameters(icx_call.decrypt(p_token),l_parameters);
2304:
2305: p_app_id := nvl(l_parameters(1),178);

Line 2359: IF icx_sec.ValidateSession THEN

2355: l_encrypted_session_id VARCHAR2(240);
2356:
2357: BEGIN
2358:
2359: IF icx_sec.ValidateSession THEN
2360:
2361: icx_on_utilities.unpack_parameters(icx_call.decrypt(p_token),l_parameters);
2362: p_app_short_name := l_parameters(1);
2363: p_resp_key := l_parameters(2);

Line 2367: -- l_encrypted_session_id := icx_call.encrypt3(icx_sec.getsessioncookie); removed mputman

2363: p_resp_key := l_parameters(2);
2364: p_sec_grp_key := l_parameters(3);
2365: p_agent := l_parameters(4);
2366:
2367: -- l_encrypted_session_id := icx_call.encrypt3(icx_sec.getsessioncookie); removed mputman
2368:
2369: -- bug 1728149 - removed l_encrypted_session_id from icx_ticket
2370: -- l_url:=p_agent||'fnd_icx_launch.runforms?ICX_TICKET='||'&';
2371: -- l_url:=l_url||'RESP_APP='||wfa_html.conv_special_url_chars(p_app_short_name)||'&'||'RESP_KEY='||wfa_html.conv_special_url_chars(p_resp_key)||'&'; -- mputman added wfa call 1690141