219: and FLOW_CODE = 'ICX_INQUIRIES'
220: and FLOW_APPLICATION_ID = 178;
221:
222:
223: l_param := icx_on_utilities.buildOracleONstring
224: (p_rowid => c_rowid,
225: p_primary_key => 'ICX_RQS_HISTORY_PK',
226: p1 => icx_call.decrypt(p1));
227:
226: p1 => icx_call.decrypt(p1));
227:
228: if l_session_id is null
229: then
230: OracleOn.IC(Y=>icx_call.encrypt2(l_param,-999));
231: else
232: OracleOn.IC(Y=>icx_call.encrypt2(l_param,l_session_id));
233: end if;
234:
228: if l_session_id is null
229: then
230: OracleOn.IC(Y=>icx_call.encrypt2(l_param,-999));
231: else
232: OracleOn.IC(Y=>icx_call.encrypt2(l_param,l_session_id));
233: end if;
234:
235: end if;
236: