DBA Data[Home] [Help]

APPS.ORACLEAPPS dependencies on ICX_CALL

Line 786: l_text := icx_call.decrypt(recreate);

782: ELSE -- not in maintenance mode
783:
784: --begin 2214212 mputman -- try to get lang from icx_sessions when session_id is avail via recreate and set nls context.
785: IF recreate IS NOT NULL THEN
786: l_text := icx_call.decrypt(recreate);
787: icx_on_utilities.unpack_parameters(l_text,l_parameters);
788: l_user_name:=l_parameters(2);
789: l_session_id:=l_parameters(1);
790: BEGIN

Line 871: -- l_text := icx_call.decrypt(recreate);

867: fnd_message.set_name('ICX','ICX_SIGNIN_AGAIN');
868: c_login_msg := fnd_message.get;
869:
870: --mputman moved up for 2214212
871: -- l_text := icx_call.decrypt(recreate);
872: -- icx_on_utilities.unpack_parameters(l_text,l_parameters);
873: -- l_user_name:=l_parameters(2);
874: -- l_session_id:=l_parameters(1);
875: ELSE

Line 1012: htp.formHidden('p_enc_session',icx_call.encrypt3(l_session_id));

1008: IF recreate IS NOT NULL THEN
1009: htp.p('

');
1010: htp.formHidden('i_1','');
1011: htp.formHidden('i_2','');
1012: htp.formHidden('p_enc_session',icx_call.encrypt3(l_session_id));
1013: --htp.formHidden('p_mode',i_mode);
1014: htp.formClose;
1015: END IF;
1016:

Line 1206: l_resp_appl_id := icx_call.decrypt3(A);

1202: if A is null
1203: then
1204: l_resp_appl_id := '';
1205: else
1206: l_resp_appl_id := icx_call.decrypt3(A);
1207: end if;
1208:
1209: if R is null
1210: then

Line 1213: l_responsibility_id := icx_call.decrypt3(R);

1209: if R is null
1210: then
1211: l_responsibility_id := '';
1212: else
1213: l_responsibility_id := icx_call.decrypt3(R);
1214: end if;
1215:
1216: if S is null
1217: then

Line 1220: l_security_group_id := icx_call.decrypt3(S);

1216: if S is null
1217: then
1218: l_security_group_id := '';
1219: else
1220: l_security_group_id := icx_call.decrypt3(S);
1221: end if;
1222:
1223: end if;
1224:

Line 1244: l_encrypted_session_id := icx_call.encrypt3(l_session_id);

1240: then
1241: l_dbc := FND_WEB_CONFIG.DATABASE_ID;
1242: end if;
1243:
1244: l_encrypted_session_id := icx_call.encrypt3(l_session_id);
1245:
1246: l_transaction_id :=
1247: icx_sec.createTransaction(
1248: l_session_id,l_resp_appl_id,l_responsibility_id,l_security_group_id,

Line 1250: l_encrypted_transaction_id := icx_call.encrypt3(l_transaction_id);

1246: l_transaction_id :=
1247: icx_sec.createTransaction(
1248: l_session_id,l_resp_appl_id,l_responsibility_id,l_security_group_id,
1249: '','','','');
1250: l_encrypted_transaction_id := icx_call.encrypt3(l_transaction_id);
1251:
1252: icx_sec.updateSessionContext(p_function_name => l_function_name,
1253: p_function_id => l_function_id,
1254: p_application_id => l_resp_appl_id,

Line 1316: l_resp_appl_id := icx_call.decrypt3(A);

1312: if A is null
1313: then
1314: l_resp_appl_id := '';
1315: else
1316: l_resp_appl_id := icx_call.decrypt3(A);
1317: end if;
1318:
1319: if R is null
1320: then

Line 1323: l_responsibility_id := icx_call.decrypt3(R);

1319: if R is null
1320: then
1321: l_responsibility_id := '';
1322: else
1323: l_responsibility_id := icx_call.decrypt3(R);
1324: end if;
1325:
1326: if S is null
1327: then

Line 1330: l_security_group_id := icx_call.decrypt3(S);

1326: if S is null
1327: then
1328: l_security_group_id := '';
1329: else
1330: l_security_group_id := icx_call.decrypt3(S);
1331: end if;
1332:
1333: l_username := upper(i_1);
1334:

Line 1361: l_encrypted_session_id := icx_call.encrypt3(l_session_id);

1357: then
1358: l_dbc := FND_WEB_CONFIG.DATABASE_ID;
1359: end if;
1360:
1361: l_encrypted_session_id := icx_call.encrypt3(l_session_id);
1362: l_encrypted_transaction_id :=
1363: icx_call.encrypt3(icx_sec.createTransaction(
1364: l_session_id,l_resp_appl_id,l_responsibility_id,l_security_group_id,
1365: '','','',''));

Line 1363: icx_call.encrypt3(icx_sec.createTransaction(

1359: end if;
1360:
1361: l_encrypted_session_id := icx_call.encrypt3(l_session_id);
1362: l_encrypted_transaction_id :=
1363: icx_call.encrypt3(icx_sec.createTransaction(
1364: l_session_id,l_resp_appl_id,l_responsibility_id,l_security_group_id,
1365: '','','',''));
1366:
1367: l_anchor := l_anchor||

Line 1642: --htf.anchor('OracleApps.RF?F='||icx_call.encrypt2(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||l_function_id||'**]',n_session_id),

1638:
1639: htp.tableRowOpen;
1640: htp.tableData(''||
1641: --mputman convert to execute effort
1642: --htf.anchor('OracleApps.RF?F='||icx_call.encrypt2(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||l_function_id||'**]',n_session_id),
1643: htf.anchor('OracleSSWA.Execute?E='||wfa_html.conv_special_url_chars(icx_call.encrypt(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||l_function_id||'**]')),
1644: r.responsibility_name,'','TARGET="_top", onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(r.description)||''';return true"')||
1645: '
','','','','','4','');
1646: htp.tableRowClose;

Line 1643: htf.anchor('OracleSSWA.Execute?E='||wfa_html.conv_special_url_chars(icx_call.encrypt(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||l_function_id||'**]')),

1639: htp.tableRowOpen;
1640: htp.tableData(''||
1641: --mputman convert to execute effort
1642: --htf.anchor('OracleApps.RF?F='||icx_call.encrypt2(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||l_function_id||'**]',n_session_id),
1643: htf.anchor('OracleSSWA.Execute?E='||wfa_html.conv_special_url_chars(icx_call.encrypt(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||l_function_id||'**]')),
1644: r.responsibility_name,'','TARGET="_top", onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(r.description)||''';return true"')||
1645: '
','','','','','4','');
1646: htp.tableRowClose;
1647: htp.tableRowOpen;

Line 1698: --l_url := 'OracleApps.RF?F='||icx_call.encrypt2(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||mi.function_id||'***]', n_session_id);

1694: l_url := replace(mi.web_html_call,'"','''');
1695: l_url := replace(l_url,'[RESPONSIBILITY_ID]',r.responsibility_id);
1696: else
1697: --mputman convert to execute effort
1698: --l_url := 'OracleApps.RF?F='||icx_call.encrypt2(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||mi.function_id||'***]', n_session_id);
1699: l_url := 'OracleApps.RF?F='||icx_call.encrypt2(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||mi.function_id||'***]', n_session_id);
1700: end if;
1701: else
1702: l_level := 1;

Line 1699: l_url := 'OracleApps.RF?F='||icx_call.encrypt2(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||mi.function_id||'***]', n_session_id);

1695: l_url := replace(l_url,'[RESPONSIBILITY_ID]',r.responsibility_id);
1696: else
1697: --mputman convert to execute effort
1698: --l_url := 'OracleApps.RF?F='||icx_call.encrypt2(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||mi.function_id||'***]', n_session_id);
1699: l_url := 'OracleApps.RF?F='||icx_call.encrypt2(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||mi.function_id||'***]', n_session_id);
1700: end if;
1701: else
1702: l_level := 1;
1703: l_url := 'OracleApps.DSM?Q='||icx_call.encrypt2(l_level+1||'*'||v_color||'*'||v_color_image||'*'||v_bullet_image||'*'

Line 1703: l_url := 'OracleApps.DSM?Q='||icx_call.encrypt2(l_level+1||'*'||v_color||'*'||v_color_image||'*'||v_bullet_image||'*'

1699: l_url := 'OracleApps.RF?F='||icx_call.encrypt2(r.responsibility_application_id||'*'||r.responsibility_id||'*'||r.security_group_id||'*'||mi.function_id||'***]', n_session_id);
1700: end if;
1701: else
1702: l_level := 1;
1703: l_url := 'OracleApps.DSM?Q='||icx_call.encrypt2(l_level+1||'*'||v_color||'*'||v_color_image||'*'||v_bullet_image||'*'
1704: ||r.responsibility_id||'*'||mi.menu_id||'*'||'OracleApps.DRM'||'*'||mi.sub_menu_id||'*'||'OracleApps.DSM'||'**]', n_session_id);
1705: end if;
1706:
1707: if mi.web_icon is not null

Line 1748: l_encrypt_menu := icx_call.encrypt2(l_level+1||'*'||v_color||'*'||v_color_image||'*'||v_bullet_image||'*'||r.responsibility_id||'*'||mi.menu_id||'*'||'OracleApps.DRM'||'*'||mi.sub_menu_id||'*'||'OracleApps.DSM'||'**]', n_session_id);

1744:
1745: f_counter := f_counter+1;
1746:
1747: l_level := 1;
1748: l_encrypt_menu := icx_call.encrypt2(l_level+1||'*'||v_color||'*'||v_color_image||'*'||v_bullet_image||'*'||r.responsibility_id||'*'||mi.menu_id||'*'||'OracleApps.DRM'||'*'||mi.sub_menu_id||'*'||'OracleApps.DSM'||'**]', n_session_id);
1749: p_funcTable(f_counter) := htf.anchor('OracleApps.DSM?Q='||l_encrypt_menu, l_prompt, '','TARGET="_top", onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_description)||''';return true"');
1750:
1751: else
1752: raise e_data_error;

Line 1917: Y:=icx_call.decrypt2(Q);

1913: if Q is not null
1914: then
1915: c_language_code := icx_sec.getID(icx_sec.PV_LANGUAGE_CODE);
1916:
1917: Y:=icx_call.decrypt2(Q);
1918: icx_on_utilities.unpack_parameters(Y, params);
1919:
1920: -- DEBUG --
1921: -- htp.p('Length of params = '||params.count);

Line 1995: pass_ons := icx_call.encrypt2(l_encrypt_string||'**]');

1991: end if;
1992:
1993: l_encrypt_string := i||'*'||v_color||'*'||v_color_image||'*'||v_bullet_image||'*'||l_resp_appl_id||'*'||l_responsibility_id||'*'||l_security_group_id||'*'||l_temp_string;
1994: n_encryption_passed := 0;
1995: pass_ons := icx_call.encrypt2(l_encrypt_string||'**]');
1996: n_encryption_passed := 1;
1997: -- at most three levels of menu on one line
1998: if ((i <> 1) and (MOD(i,3) = 1)) then
1999: l_temp_name := l_temp_name||'
';

Line 2061: c_encrypted_func := icx_call.encrypt2(l_resp_appl_id||'*'||l_responsibility_id||'*'||l_security_group_id||'*'||mi.function_id||'*'||Q||'**]');

2057: if ((mi.sub_menu_id is NULL) AND (mi.function_id is not NULL)) then
2058:
2059: n_encryption_passed := 0;
2060:
2061: c_encrypted_func := icx_call.encrypt2(l_resp_appl_id||'*'||l_responsibility_id||'*'||l_security_group_id||'*'||mi.function_id||'*'||Q||'**]');
2062:
2063: n_encryption_passed := 1;
2064:
2065: if mi.web_icon is not null

Line 2111: l_encrypt_menu := icx_call.encrypt2(l_level+1||'*'||v_color||'*'||v_color_image||'*'||v_bullet_image||'*'||l_resp_appl_id||'*'||l_responsibility_id||'*'||l_security_group_id||'*'||l_temp_string||'*'||mi.sub_menu_id||'*'||'OracleApps.DSM'||'**]');

2107:
2108: f_counter := f_counter+1;
2109:
2110: n_encryption_passed := 0;
2111: l_encrypt_menu := icx_call.encrypt2(l_level+1||'*'||v_color||'*'||v_color_image||'*'||v_bullet_image||'*'||l_resp_appl_id||'*'||l_responsibility_id||'*'||l_security_group_id||'*'||l_temp_string||'*'||mi.sub_menu_id||'*'||'OracleApps.DSM'||'**]');
2112: n_encryption_passed := 1;
2113:
2114: p_funcTable(f_counter) := htf.anchor('OracleApps.DSM?Q='||l_encrypt_menu, l_prompt, '','TARGET="_top", onMouseOver="window.status='''||icx_util.replace_onMouseOver_quotes(l_description)||''';return true"');
2115:

Line 2122: l_encrypt_menu := icx_call.encrypt2(l_level+1||'*'||v_color||'*'||v_color_image||'*'||v_bullet_image||'*'||l_resp_appl_id||'*'||

2118:
2119: -- menu info. for next level
2120:
2121: n_encryption_passed := 0;
2122: l_encrypt_menu := icx_call.encrypt2(l_level+1||'*'||v_color||'*'||v_color_image||'*'||v_bullet_image||'*'||l_resp_appl_id||'*'||
2123: l_responsibility_id||'*'||l_security_group_id||'*'||l_temp_string||'*'||mi.sub_menu_id||'*'||'OracleApps.DSM'||'**]');
2124: n_encryption_passed := 1;
2125:
2126: if mi.web_icon is not null

Line 2254: l_text := icx_call.decrypt2(E,-99);

2250: IF E IS NOT NULL THEN
2251: -- mputman 1545083
2252: -- new call from forms using decrypt2
2253: -- session_id of -99 must be used from forms for decrypt2 to work
2254: l_text := icx_call.decrypt2(E,-99);
2255: delete from icx_text where text_id=E;commit; --mputman added 1545083
2256: ELSE
2257: l_text := icx_call.decrypt(F);
2258:

Line 2257: l_text := icx_call.decrypt(F);

2253: -- session_id of -99 must be used from forms for decrypt2 to work
2254: l_text := icx_call.decrypt2(E,-99);
2255: delete from icx_text where text_id=E;commit; --mputman added 1545083
2256: ELSE
2257: l_text := icx_call.decrypt(F);
2258:
2259: END IF;
2260:
2261: icx_on_utilities.unpack_parameters(l_text,l_parameters);

Line 2273: --l_encrypted_function := icx_call.encrypt2(l_resp_appl_id||'*'||l_responsibility_id||'*'||

2269: IF icx_sec.validatesession THEN
2270:
2271: l_session_id := icx_sec.getsessioncookie;
2272: --mputman convert to execute effort
2273: --l_encrypted_function := icx_call.encrypt2(l_resp_appl_id||'*'||l_responsibility_id||'*'||
2274: -- l_security_group_id||'*'||l_function_id||'***]',l_session_id);
2275:
2276: l_encrypted_function := wfa_html.conv_special_url_chars(icx_call.encrypt(l_resp_appl_id||'*'||l_responsibility_id||'*'||
2277: l_security_group_id||'*'||l_function_id||'***]'));

Line 2276: l_encrypted_function := wfa_html.conv_special_url_chars(icx_call.encrypt(l_resp_appl_id||'*'||l_responsibility_id||'*'||

2272: --mputman convert to execute effort
2273: --l_encrypted_function := icx_call.encrypt2(l_resp_appl_id||'*'||l_responsibility_id||'*'||
2274: -- l_security_group_id||'*'||l_function_id||'***]',l_session_id);
2275:
2276: l_encrypted_function := wfa_html.conv_special_url_chars(icx_call.encrypt(l_resp_appl_id||'*'||l_responsibility_id||'*'||
2277: l_security_group_id||'*'||l_function_id||'***]'));
2278: --mputman convert to execute effort
2279: --l_URL := 'OracleApps.RF?F='||l_encrypted_function;
2280: l_URL := 'OracleSSWA.Execute?E='||l_encrypted_function;

Line 2283: -- l_URL := l_URL||'&'||'P='||icx_call.encrypt2(icx_call.decrypt(P),l_session_id);

2279: --l_URL := 'OracleApps.RF?F='||l_encrypted_function;
2280: l_URL := 'OracleSSWA.Execute?E='||l_encrypted_function;
2281: if P is not null
2282: then
2283: -- l_URL := l_URL||'&'||'P='||icx_call.encrypt2(icx_call.decrypt(P),l_session_id);
2284: l_URL := l_URL||'&'||'P='||P;
2285: end if;
2286: htp.bodyOpen(cattributes => 'onLoad="top.location='''||l_URL||'''"');
2287: htp.bodyClose;

Line 2297: l_encrypted_function := icx_call.encrypt2(l_resp_appl_id||'*'||l_responsibility_id||'*'||

2293:
2294: --to re-enable pseudo sessions, uncomment the following block of code
2295: /*
2296: l_session_id := icx_sec.createSession(l_user_id);
2297: l_encrypted_function := icx_call.encrypt2(l_resp_appl_id||'*'||l_responsibility_id||'*'||
2298: l_security_group_id||'*'||l_function_id||'***]',l_session_id);
2299: owa_util.mime_header('text/html', FALSE);
2300: icx_sec.sendsessioncookie(l_session_id);
2301: owa_util.http_header_close;

Line 2305: l_URL := l_URL||'&'||'P='||icx_call.encrypt2(icx_call.decrypt(P),l_session_id);

2301: owa_util.http_header_close;
2302: l_URL := 'OracleApps.RF?F='||l_encrypted_function;
2303: if P is not null
2304: then
2305: l_URL := l_URL||'&'||'P='||icx_call.encrypt2(icx_call.decrypt(P),l_session_id);
2306: end if;
2307: htp.bodyOpen(cattributes => 'onLoad="top.location='''||l_URL||'''"');
2308: htp.bodyClose;
2309: */

Line 2402: l_text := icx_call.decrypt2(F,l_session_id);

2398: begin
2399:
2400: l_session_id := icx_sec.getID(icx_sec.pv_session_id);
2401:
2402: l_text := icx_call.decrypt2(F,l_session_id);
2403:
2404: icx_on_utilities.unpack_parameters(l_text,l_parameters);
2405: l_resp_appl_id := nvl(l_parameters(1),178);
2406: l_responsibility_id := l_parameters(2);

Line 2414: l_text := icx_call.decrypt2(P,l_session_id);

2410: if P is null
2411: then
2412: l_text := null;
2413: else
2414: l_text := icx_call.decrypt2(P,l_session_id);
2415: end if;
2416:
2417: -- 2802333 nlbarlow
2418: l_url := icx_portlet.createExecLink(p_application_id => l_resp_appl_id,

Line 2705: c_anchor := c_anchor||l_names(i)||'='||icx_call.encrypt2(l_values(i), n_session_id);

2701: if i > 1
2702: then
2703: c_anchor := c_anchor||',';
2704: end if;
2705: c_anchor := c_anchor||l_names(i)||'='||icx_call.encrypt2(l_values(i), n_session_id);
2706: end loop;
2707: else
2708: c_anchor := c_anchor||l_parameters;
2709: end if;

Line 2716: l_encrypted_session_id := icx_call.encrypt3(n_session_id);

2712: owa_util.redirect_url(c_anchor);
2713:
2714: elsif f.type = 'SERVLET' then
2715:
2716: l_encrypted_session_id := icx_call.encrypt3(n_session_id);
2717:
2718: fnd_profile.get(name => 'APPS_SERVLET_AGENT',
2719: val => c_anchor);
2720:

Line 2733: l_encrypted_session_id := icx_call.encrypt3(n_session_id);

2729: owa_util.redirect_url(c_anchor);
2730:
2731: elsif f.type = 'JSP' or f.type = 'INTEROPJSP' then
2732:
2733: l_encrypted_session_id := icx_call.encrypt3(n_session_id);
2734:
2735: l_web_html_call := replace(f.WEB_HTML_CALL,'apps.jsp','OA.jsp');
2736:
2737: if (instr(l_web_html_call,'OA.jsp') > 0)

Line 2766: icx_call.encrypt3(icx_sec.createTransaction(

2762: c_anchor := '';
2763: end if;
2764:
2765: l_encrypted_transaction_id :=
2766: icx_call.encrypt3(icx_sec.createTransaction(
2767: n_session_id,p_resp_appl_id,p_responsibility_id,p_security_group_id,
2768: p_menu_id,c_function_id,p_function_type,p_page_id));
2769:
2770: c_anchor := FND_WEB_CONFIG.trail_slash(c_anchor)||

Line 2844: c_procedure_call := c_procedure_call||l_names(i)||' => '||icx_call.encrypt2(l_values(i), n_session_id);

2840: c_procedure_call := c_procedure_call||',';
2841: end if;
2842: if f.web_ENCRYPT_PARAMETERS = 'Y'
2843: then
2844: c_procedure_call := c_procedure_call||l_names(i)||' => '||icx_call.encrypt2(l_values(i), n_session_id);
2845: else
2846: c_procedure_call := c_procedure_call||l_names(i)||' => '''||l_values(i)||'''';
2847: end if;
2848: end loop;

Line 4279: v_encrypted_upper_psswd := to_char(icx_call.crchash(l_username,UPPER(c_PASSWORD1)));

4275: if c_PASSWORD2 = c_PASSWORD3
4276: then
4277:
4278: l_username := UPPER(c_username);
4279: v_encrypted_upper_psswd := to_char(icx_call.crchash(l_username,UPPER(c_PASSWORD1)));
4280:
4281: v_encrypted_psswd := to_char(icx_call.crchash(l_username,c_PASSWORD1));
4282:
4283: select user_id,web_password

Line 4281: v_encrypted_psswd := to_char(icx_call.crchash(l_username,c_PASSWORD1));

4277:
4278: l_username := UPPER(c_username);
4279: v_encrypted_upper_psswd := to_char(icx_call.crchash(l_username,UPPER(c_PASSWORD1)));
4280:
4281: v_encrypted_psswd := to_char(icx_call.crchash(l_username,c_PASSWORD1));
4282:
4283: select user_id,web_password
4284: into l_user_id,l_web_password
4285: from fnd_user

Line 4403: encrypted_ids := icx_call.encrypt2( c_string, c_session_id);

4399: encrypted_ids varchar2(512);
4400:
4401: begin
4402:
4403: encrypted_ids := icx_call.encrypt2( c_string, c_session_id);
4404: commit;
4405: return encrypted_ids;
4406:
4407: end; -- FormsLF_prep

Line 4721: l_text := icx_call.decrypt(c_token);

4717: IF (upper(l_hosted_profile)='HOSTED') THEN
4718: b_hosted:=TRUE;
4719: END IF;
4720: --this is not a portal instance, let ICX code do it's magic!
4721: l_text := icx_call.decrypt(c_token);
4722:
4723: icx_on_utilities.unpack_parameters(l_text,l_parameters);
4724: l_session_id := l_parameters(1);
4725: l_resp_appl_id := nvl(l_parameters(2),178);

Line 4844: c_parameters => icx_call.decrypt(l_enc_params));

4840: p_responsibility_id => l_responsibility_id,
4841: p_security_group_id => nvl(l_security_group_id,'0'),
4842: c_function_id => l_function_id,
4843: n_session_id => l_session_id,
4844: c_parameters => icx_call.decrypt(l_enc_params));
4845:
4846: ELSE
4847: OracleApps.runFunction(p_resp_appl_id => l_resp_appl_id,
4848: p_responsibility_id => l_responsibility_id,