APPS.OKC_P_UTIL dependencies on DBMS_SQL

Line 48: v_cursor := dbms_sql.open_cursor;

44: -- create savepoint
45: savepoint execute_sql_savept;
46:
47: -- create cursor
48: v_cursor := dbms_sql.open_cursor;
49:
50: -- parse statement
51: dbms_sql.parse(v_cursor, p_sql, DBMS_SQL.NATIVE);
52:

Line 51: dbms_sql.parse(v_cursor, p_sql, DBMS_SQL.NATIVE);

47: -- create cursor
48: v_cursor := dbms_sql.open_cursor;
49:
50: -- parse statement
51: dbms_sql.parse(v_cursor, p_sql, DBMS_SQL.NATIVE);
52:
53: -- execute
54: v_num_rows := dbms_sql.execute(v_cursor);
55:

Line 54: v_num_rows := dbms_sql.execute(v_cursor);

50: -- parse statement
51: dbms_sql.parse(v_cursor, p_sql, DBMS_SQL.NATIVE);
52:
53: -- execute
54: v_num_rows := dbms_sql.execute(v_cursor);
55:
56: -- close cursor
57: dbms_sql.close_cursor(v_cursor);
58:

Line 57: dbms_sql.close_cursor(v_cursor);

53: -- execute
54: v_num_rows := dbms_sql.execute(v_cursor);
55:
56: -- close cursor
57: dbms_sql.close_cursor(v_cursor);
58:
59: -- return success
60: return v_num_rows;
61:

Line 71: dbms_sql.close_cursor(v_cursor);

67: -- rollback to before statement
68: rollback to execute_sql_savept;
69:
70: -- close cursor
71: dbms_sql.close_cursor(v_cursor);
72:
73: -- take care of error
74: -- do something here
75: