DPP.APPS_DDL dependencies on DBMS_SQL

Line 8: c := dbms_sql.open_cursor;

4: (ddl_text in clob) is
5: c integer;
6: rows_processed integer;
7: begin
8: c := dbms_sql.open_cursor;
9: dbms_sql.parse(c, ddl_text, dbms_sql.native);
10: rows_processed := dbms_sql.execute(c);
11: dbms_sql.close_cursor(c);
12: exception

Line 9: dbms_sql.parse(c, ddl_text, dbms_sql.native);

5: c integer;
6: rows_processed integer;
7: begin
8: c := dbms_sql.open_cursor;
9: dbms_sql.parse(c, ddl_text, dbms_sql.native);
10: rows_processed := dbms_sql.execute(c);
11: dbms_sql.close_cursor(c);
12: exception
13: when others then

Line 10: rows_processed := dbms_sql.execute(c);

6: rows_processed integer;
7: begin
8: c := dbms_sql.open_cursor;
9: dbms_sql.parse(c, ddl_text, dbms_sql.native);
10: rows_processed := dbms_sql.execute(c);
11: dbms_sql.close_cursor(c);
12: exception
13: when others then
14: dbms_sql.close_cursor(c);

Line 11: dbms_sql.close_cursor(c);

7: begin
8: c := dbms_sql.open_cursor;
9: dbms_sql.parse(c, ddl_text, dbms_sql.native);
10: rows_processed := dbms_sql.execute(c);
11: dbms_sql.close_cursor(c);
12: exception
13: when others then
14: dbms_sql.close_cursor(c);
15: raise;

Line 14: dbms_sql.close_cursor(c);

10: rows_processed := dbms_sql.execute(c);
11: dbms_sql.close_cursor(c);
12: exception
13: when others then
14: dbms_sql.close_cursor(c);
15: raise;
16: end apps_ddl;
17: procedure apps_ddl
18: (ddl_text in varchar2) is

Line 22: c := dbms_sql.open_cursor;

18: (ddl_text in varchar2) is
19: c integer;
20: rows_processed integer;
21: begin
22: c := dbms_sql.open_cursor;
23: dbms_sql.parse(c, ddl_text, dbms_sql.native);
24: rows_processed := dbms_sql.execute(c);
25: dbms_sql.close_cursor(c);
26: exception

Line 23: dbms_sql.parse(c, ddl_text, dbms_sql.native);

19: c integer;
20: rows_processed integer;
21: begin
22: c := dbms_sql.open_cursor;
23: dbms_sql.parse(c, ddl_text, dbms_sql.native);
24: rows_processed := dbms_sql.execute(c);
25: dbms_sql.close_cursor(c);
26: exception
27: when others then

Line 24: rows_processed := dbms_sql.execute(c);

20: rows_processed integer;
21: begin
22: c := dbms_sql.open_cursor;
23: dbms_sql.parse(c, ddl_text, dbms_sql.native);
24: rows_processed := dbms_sql.execute(c);
25: dbms_sql.close_cursor(c);
26: exception
27: when others then
28: dbms_sql.close_cursor(c);

Line 25: dbms_sql.close_cursor(c);

21: begin
22: c := dbms_sql.open_cursor;
23: dbms_sql.parse(c, ddl_text, dbms_sql.native);
24: rows_processed := dbms_sql.execute(c);
25: dbms_sql.close_cursor(c);
26: exception
27: when others then
28: dbms_sql.close_cursor(c);
29: raise;

Line 28: dbms_sql.close_cursor(c);

24: rows_processed := dbms_sql.execute(c);
25: dbms_sql.close_cursor(c);
26: exception
27: when others then
28: dbms_sql.close_cursor(c);
29: raise;
30: end apps_ddl;
31: end APPS_DDL;