APPS.WIP_UTILITIES dependencies on DBMS_SQL

Line 13: cursor_id := dbms_sql.open_cursor;

9: -- set sql statement
10: sql_stmt := p_sql_stmt;
11:
12: -- open a cursor
13: cursor_id := dbms_sql.open_cursor;
14:
15: -- parse sql statement
16: dbms_sql.parse(cursor_id, sql_stmt, DBMS_SQL.V7);
17:

Line 16: dbms_sql.parse(cursor_id, sql_stmt, DBMS_SQL.V7);

12: -- open a cursor
13: cursor_id := dbms_sql.open_cursor;
14:
15: -- parse sql statement
16: dbms_sql.parse(cursor_id, sql_stmt, DBMS_SQL.V7);
17:
18: -- execute statement
19: return_val := dbms_sql.execute(cursor_id);
20:

Line 19: return_val := dbms_sql.execute(cursor_id);

15: -- parse sql statement
16: dbms_sql.parse(cursor_id, sql_stmt, DBMS_SQL.V7);
17:
18: -- execute statement
19: return_val := dbms_sql.execute(cursor_id);
20:
21: -- close cursor
22: dbms_sql.close_cursor(cursor_id);
23: end do_sql;

Line 22: dbms_sql.close_cursor(cursor_id);

18: -- execute statement
19: return_val := dbms_sql.execute(cursor_id);
20:
21: -- close cursor
22: dbms_sql.close_cursor(cursor_id);
23: end do_sql;
24:
25: Function is_status_applicable(p_trx_status_enabled IN NUMBER :=NULL,
26: p_trx_type_id IN NUMBER :=NULL,