APPS.ICX_ADMIN_UTILS dependencies on DBMS_SQL

Line 204: l_call := dbms_sql.open_cursor;

200: l_X := l_X||'*]';
201:
202: l_procedure_call := l_update_proc||'('||icx_call.encrypt2(l_X)||')';
203:
204: l_call := dbms_sql.open_cursor;
205: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);
206: l_dummy := dbms_sql.execute(l_call);
207: dbms_sql.close_cursor(l_call);
208:

Line 205: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);

201:
202: l_procedure_call := l_update_proc||'('||icx_call.encrypt2(l_X)||')';
203:
204: l_call := dbms_sql.open_cursor;
205: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);
206: l_dummy := dbms_sql.execute(l_call);
207: dbms_sql.close_cursor(l_call);
208:
209: else

Line 206: l_dummy := dbms_sql.execute(l_call);

202: l_procedure_call := l_update_proc||'('||icx_call.encrypt2(l_X)||')';
203:
204: l_call := dbms_sql.open_cursor;
205: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);
206: l_dummy := dbms_sql.execute(l_call);
207: dbms_sql.close_cursor(l_call);
208:
209: else
210: htp.htmlOpen;

Line 207: dbms_sql.close_cursor(l_call);

203:
204: l_call := dbms_sql.open_cursor;
205: dbms_sql.parse(l_call,'begin '||l_procedure_call||'; end;',dbms_sql.native);
206: l_dummy := dbms_sql.execute(l_call);
207: dbms_sql.close_cursor(l_call);
208:
209: else
210: htp.htmlOpen;
211: htp.headOpen;