APPS.CSTPUTIL dependencies on DBMS_SQL

Line 67: cursor_id := dbms_sql.open_cursor;

63: -- set sql statement
64: sql_stmt := p_sql_stmt;
65:
66: -- open a cursor
67: cursor_id := dbms_sql.open_cursor;
68:
69: -- parse sql statement
70: dbms_sql.parse(cursor_id, sql_stmt, DBMS_SQL.V7);
71:

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

66: -- open a cursor
67: cursor_id := dbms_sql.open_cursor;
68:
69: -- parse sql statement
70: dbms_sql.parse(cursor_id, sql_stmt, DBMS_SQL.V7);
71:
72: -- execute statement
73: return_val := dbms_sql.execute(cursor_id);
74:

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

69: -- parse sql statement
70: dbms_sql.parse(cursor_id, sql_stmt, DBMS_SQL.V7);
71:
72: -- execute statement
73: return_val := dbms_sql.execute(cursor_id);
74:
75: -- close cursor
76: dbms_sql.close_cursor(cursor_id);
77: end do_sql;

Line 76: dbms_sql.close_cursor(cursor_id);

72: -- execute statement
73: return_val := dbms_sql.execute(cursor_id);
74:
75: -- close cursor
76: dbms_sql.close_cursor(cursor_id);
77: end do_sql;
78:
79:
80: --