DBA Data[Home] [Help]

APPS.PER_FR_DISC dependencies on DBMS_SQL

Line 9: cursor_name := DBMS_SQL.OPEN_CURSOR;

5: is
6: cursor_name integer;
7: ret integer;
8: begin
9: cursor_name := DBMS_SQL.OPEN_CURSOR;
10: --DDL statements are executed by the parse call, which
11: --performs the implied commit
12: DBMS_SQL.PARSE(cursor_name, string, DBMS_SQL.V7);
13: ret := DBMS_SQL.EXECUTE(cursor_name);

Line 12: DBMS_SQL.PARSE(cursor_name, string, DBMS_SQL.V7);

8: begin
9: cursor_name := DBMS_SQL.OPEN_CURSOR;
10: --DDL statements are executed by the parse call, which
11: --performs the implied commit
12: DBMS_SQL.PARSE(cursor_name, string, DBMS_SQL.V7);
13: ret := DBMS_SQL.EXECUTE(cursor_name);
14: DBMS_SQL.CLOSE_CURSOR(cursor_name);
15: end exec_dyn_sql;
16:

Line 13: ret := DBMS_SQL.EXECUTE(cursor_name);

9: cursor_name := DBMS_SQL.OPEN_CURSOR;
10: --DDL statements are executed by the parse call, which
11: --performs the implied commit
12: DBMS_SQL.PARSE(cursor_name, string, DBMS_SQL.V7);
13: ret := DBMS_SQL.EXECUTE(cursor_name);
14: DBMS_SQL.CLOSE_CURSOR(cursor_name);
15: end exec_dyn_sql;
16:
17: procedure grant_hr_summary (errbuf out nocopy varchar2,

Line 14: DBMS_SQL.CLOSE_CURSOR(cursor_name);

10: --DDL statements are executed by the parse call, which
11: --performs the implied commit
12: DBMS_SQL.PARSE(cursor_name, string, DBMS_SQL.V7);
13: ret := DBMS_SQL.EXECUTE(cursor_name);
14: DBMS_SQL.CLOSE_CURSOR(cursor_name);
15: end exec_dyn_sql;
16:
17: procedure grant_hr_summary (errbuf out nocopy varchar2,
18: retcode out nocopy number,