APPS.WSH_SC_DEL_UTIL dependencies on DBMS_SQL

Line 17: cursor_name := DBMS_SQL.OPEN_CURSOR;

13: PROCEDURE EXEC_MASS_CHANGE(statement varchar2, records_updated in out number) AS
14: cursor_name INTEGER;
15: rows_processed number;
16: BEGIN
17: cursor_name := DBMS_SQL.OPEN_CURSOR;
18: DBMS_SQL.PARSE(cursor_name, statement, DBMS_SQL.v7);
19:
20: rows_processed := DBMS_SQL.EXECUTE(cursor_name);
21: records_updated := rows_processed;

Line 18: DBMS_SQL.PARSE(cursor_name, statement, DBMS_SQL.v7);

14: cursor_name INTEGER;
15: rows_processed number;
16: BEGIN
17: cursor_name := DBMS_SQL.OPEN_CURSOR;
18: DBMS_SQL.PARSE(cursor_name, statement, DBMS_SQL.v7);
19:
20: rows_processed := DBMS_SQL.EXECUTE(cursor_name);
21: records_updated := rows_processed;
22:

Line 20: rows_processed := DBMS_SQL.EXECUTE(cursor_name);

16: BEGIN
17: cursor_name := DBMS_SQL.OPEN_CURSOR;
18: DBMS_SQL.PARSE(cursor_name, statement, DBMS_SQL.v7);
19:
20: rows_processed := DBMS_SQL.EXECUTE(cursor_name);
21: records_updated := rows_processed;
22:
23: DBMS_SQL.CLOSE_CURSOR(cursor_name);
24: EXCEPTION

Line 23: DBMS_SQL.CLOSE_CURSOR(cursor_name);

19:
20: rows_processed := DBMS_SQL.EXECUTE(cursor_name);
21: records_updated := rows_processed;
22:
23: DBMS_SQL.CLOSE_CURSOR(cursor_name);
24: EXCEPTION
25: when others then
26: dbms_sql.close_cursor(cursor_name);
27: END;

Line 26: dbms_sql.close_cursor(cursor_name);

22:
23: DBMS_SQL.CLOSE_CURSOR(cursor_name);
24: EXCEPTION
25: when others then
26: dbms_sql.close_cursor(cursor_name);
27: END;
28:
29:
30: FUNCTION Request_Id return NUMBER