APPS.ICX_ON dependencies on ICX_CALL

Line 42: l_Y := icx_call.encrypt2('DQ'||'*'||l_flow_appl_id||'*'||l_flow_code||'*'||l_page_appl_id||'*'||l_page_code||'*****]');

38: l_flow_code := icx_on_utilities.g_on_parameters(3);
39: l_page_appl_id := icx_on_utilities.g_on_parameters(4);
40: l_page_code := icx_on_utilities.g_on_parameters(5);
41:
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

Line 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'||'**]');

40: l_page_code := icx_on_utilities.g_on_parameters(5);
41:
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

Line 82: l_encrypted_where := icx_call.encrypt2(l_where);

78:
79: if l_encrypted_where is null
80: then
81: l_where := icx_on_utilities.whereSegment(p_attributes,p_conditions,p_inputs,p_match,p_and_or);
82: l_encrypted_where := icx_call.encrypt2(l_where);
83: else
84: l_where := icx_call.decrypt2(l_encrypted_where);
85: end if;
86:

Line 84: l_where := icx_call.decrypt2(l_encrypted_where);

80: then
81: l_where := icx_on_utilities.whereSegment(p_attributes,p_conditions,p_inputs,p_match,p_and_or);
82: l_encrypted_where := icx_call.encrypt2(l_where);
83: else
84: l_where := icx_call.decrypt2(l_encrypted_where);
85: end if;
86:
87: -- htp.p('DEBUG where => '||l_where);htp.nl;
88:

Line 107: l_encrypted_where := icx_call.encrypt2(l_where);

103: and PARENT_REGION_CODE is null;
104:
105: -- The parameters(6) is a funny used to pass in a direct where
106: l_where := replace(icx_on_utilities.g_on_parameters(6),'~','=')||'**]';
107: l_encrypted_where := icx_call.encrypt2(l_where);
108:
109: -- 2093780 nlbarlow, multiple region first page
110: select count(*)
111: into l_count

Line 228: icx_on_utilities.unpack_parameters(icx_call.decrypt2(S),c_parameters);

224:
225:
226: begin
227:
228: icx_on_utilities.unpack_parameters(icx_call.decrypt2(S),c_parameters);
229:
230: l_type := c_parameters(1);
231:
232: if l_type = 'DQ' or l_type = 'W'

Line 252: l_where := icx_call.decrypt2(l_encrypted_where);

248: and FLOW_APPLICATION_ID = l_flow_appl_id
249: and PAGE_CODE = l_page_code
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: