DBA Data[Home] [Help]

APPS.ICX_ON dependencies on ICX_SEC

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

42: l_Y := icx_call.encrypt2('DQ'||'*'||l_flow_appl_id||'*'||l_flow_code||'*'||l_page_appl_id||'*'||l_page_code||'*****]');
43:
44: l_help_url := 'OracleON.IC?X='||icx_call.encrypt2(l_flow_appl_id||'*'||l_flow_code||'*'||l_page_appl_id||'*'||l_page_code||'*'||'ICX_HLP_QUERY'||'**]');
45:
46: if ( substr(icx_sec.g_mode_code,1,3) = '115' or
47: icx_sec.g_mode_code = 'SLAVE')
48: then
49: if l_type = 'Q1'
50: then

Line 47: icx_sec.g_mode_code = 'SLAVE')

43:
44: l_help_url := 'OracleON.IC?X='||icx_call.encrypt2(l_flow_appl_id||'*'||l_flow_code||'*'||l_page_appl_id||'*'||l_page_code||'*'||'ICX_HLP_QUERY'||'**]');
45:
46: if ( substr(icx_sec.g_mode_code,1,3) = '115' or
47: icx_sec.g_mode_code = 'SLAVE')
48: then
49: if l_type = 'Q1'
50: then
51: icx_on_cabo.findPage(

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

136: end if;
137:
138: if ak_query_pkg.g_regions_table(0).flow_application_id > 0
139: then
140: if ( substr(icx_sec.g_mode_code,1,3) = '115' or
141: icx_sec.g_mode_code = 'SLAVE')
142: then
143: icx_on_cabo.displayPage;
144: else

Line 141: icx_sec.g_mode_code = 'SLAVE')

137:
138: if ak_query_pkg.g_regions_table(0).flow_application_id > 0
139: then
140: if ( substr(icx_sec.g_mode_code,1,3) = '115' or
141: icx_sec.g_mode_code = 'SLAVE')
142: then
143: icx_on_cabo.displayPage;
144: else
145: icx_on_utilities.displayPage;

Line 166: l_web_user_date_format := icx_sec.getID(icx_sec.pv_date_format);

162: select substr(l_message,12,512) into l_err_mesg from dual;
163: if (abs(l_err_num) between 1800 and 1899)
164: then
165: fnd_message.set_name('ICX','ICX_USE_DATE_FORMAT');
166: l_web_user_date_format := icx_sec.getID(icx_sec.pv_date_format);
167: fnd_message.set_token('FORMAT_MASK_TOKEN',nvl(l_web_user_date_format,'DD-MON-YYYY'));
168: l_message := l_err_mesg||'
'||fnd_message.get;
169: icx_util.add_error(l_message) ;
170: icx_admin_sig.error_screen(l_err_mesg);

Line 254: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

250: and PAGE_APPLICATION_ID = l_page_appl_id;
251:
252: l_where := icx_call.decrypt2(l_encrypted_where);
253:
254: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
255: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
256:
257: icx_on_utilities.unpack_whereSegment(l_where,l_where_clause,l_query_binds);
258:

Line 255: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

251:
252: l_where := icx_call.decrypt2(l_encrypted_where);
253:
254: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
255: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
256:
257: icx_on_utilities.unpack_whereSegment(l_where,l_where_clause,l_query_binds);
258:
259: ak_query_pkg.exec_query(

Line 303: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);

299: c_to_page_appl_id,c_to_page_code
300: from AK_FLOW_REGION_RELATIONS
301: where ROWID = c_rowid;
302:
303: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
304: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
305:
306: ak_query_pkg.exec_query(
307: P_FLOW_APPL_ID => l_flow_appl_id,

Line 304: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);

300: from AK_FLOW_REGION_RELATIONS
301: where ROWID = c_rowid;
302:
303: l_responsibility_id := icx_sec.getID(icx_sec.PV_RESPONSIBILITY_ID);
304: l_user_id := icx_sec.getID(icx_sec.PV_WEB_USER_ID);
305:
306: ak_query_pkg.exec_query(
307: P_FLOW_APPL_ID => l_flow_appl_id,
308: P_FLOW_CODE => l_flow_code,

Line 423: l_dbcharset:=icx_sec.getNLS_PARAMETER('NLS_CHARACTERSET');

419:
420:
421: --Start Bug3460155
422:
423: l_dbcharset:=icx_sec.getNLS_PARAMETER('NLS_CHARACTERSET');
424:
425: c_labels1 := convert(c_labels,fnd_profile.value('FND_NATIVE_CLIENT_ENCODING'),l_dbcharset);
426:
427: htp.p(c_labels1);