eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AD_MV dependencies on DBMS_SQL

Line 6: ga_stmt dbms_sql.varchar2s;

2: /* $Header: admvb.pls 120.14 2011/09/22 19:12:51 mkumandu ship $*/
3:
4: gs_package_name_c CONSTANT VARCHAR2(30) := 'ad_mv';
5:
6: ga_stmt dbms_sql.varchar2s;
7:
8: ga_c_stmt clob;
9:
10: check_tspace_exist varchar2(100);

Line 83: ln_cursor := dbms_sql.open_cursor;

79: ln_dummy INTEGER;
80: begin
81: IF (ab_long_stmt_i)
82: THEN
83: ln_cursor := dbms_sql.open_cursor;
84: dbms_sql.parse(c => ln_cursor, statement => ga_stmt
85: , lb => 1, ub => ga_stmt.COUNT
86: , lfflg => FALSE, language_flag => dbms_sql.native
87: );

Line 84: dbms_sql.parse(c => ln_cursor, statement => ga_stmt

80: begin
81: IF (ab_long_stmt_i)
82: THEN
83: ln_cursor := dbms_sql.open_cursor;
84: dbms_sql.parse(c => ln_cursor, statement => ga_stmt
85: , lb => 1, ub => ga_stmt.COUNT
86: , lfflg => FALSE, language_flag => dbms_sql.native
87: );
88: ln_dummy := dbms_sql.execute(ln_cursor);

Line 86: , lfflg => FALSE, language_flag => dbms_sql.native

82: THEN
83: ln_cursor := dbms_sql.open_cursor;
84: dbms_sql.parse(c => ln_cursor, statement => ga_stmt
85: , lb => 1, ub => ga_stmt.COUNT
86: , lfflg => FALSE, language_flag => dbms_sql.native
87: );
88: ln_dummy := dbms_sql.execute(ln_cursor);
89: dbms_sql.close_cursor(ln_cursor);
90: ga_stmt.DELETE;

Line 88: ln_dummy := dbms_sql.execute(ln_cursor);

84: dbms_sql.parse(c => ln_cursor, statement => ga_stmt
85: , lb => 1, ub => ga_stmt.COUNT
86: , lfflg => FALSE, language_flag => dbms_sql.native
87: );
88: ln_dummy := dbms_sql.execute(ln_cursor);
89: dbms_sql.close_cursor(ln_cursor);
90: ga_stmt.DELETE;
91: ELSE
92: EXECUTE IMMEDIATE as_stmt_i;

Line 89: dbms_sql.close_cursor(ln_cursor);

85: , lb => 1, ub => ga_stmt.COUNT
86: , lfflg => FALSE, language_flag => dbms_sql.native
87: );
88: ln_dummy := dbms_sql.execute(ln_cursor);
89: dbms_sql.close_cursor(ln_cursor);
90: ga_stmt.DELETE;
91: ELSE
92: EXECUTE IMMEDIATE as_stmt_i;
93: END IF;

Line 99: -- and dbms_sql.parse() is expected to be used, i.e.

95:
96: --
97: -- This procedure should not be called directly from an
98: -- external program when the statement is really long
99: -- and dbms_sql.parse() is expected to be used, i.e.
100: -- ab_long_stmt_i=TRUE. In these cases, the call should
101: -- be made to do_mv_ddl().
102: --
103: PROCEDURE create_mv (

Line 196: -- and dbms_sql.parse() is expected to be used, i.e.

192: -- passing boolean parameters in PL/SQL Stored Procedures.
193: --
194: -- This procedure should not be called directly from an
195: -- external program when the statement is really long
196: -- and dbms_sql.parse() is expected to be used, i.e.
197: -- ab_long_stmt_i=1. In these cases, the call should
198: -- be made to do_mv_ddl2().
199: --
200: PROCEDURE create_mv2 (

Line 217: -- and dbms_sql.parse() is expected to be used, i.e.

213:
214: --
215: -- This procedure should not be called directly from an
216: -- external program when the statement is really long
217: -- and dbms_sql.parse() is expected to be used, i.e.
218: -- ab_long_stmt_i=TRUE. In these cases, the call should
219: -- be made to do_mv_ddl().
220: --
221: PROCEDURE mv_ddl (

Line 237: ln_cursor := dbms_sql.open_cursor;

233:
234: BEGIN
235: IF (ab_long_stmt_i)
236: THEN
237: ln_cursor := dbms_sql.open_cursor;
238: dbms_sql.parse(c => ln_cursor, statement => ga_stmt
239: , lb => 1, ub => ga_stmt.COUNT
240: , lfflg => FALSE, language_flag => dbms_sql.native
241: );

Line 238: dbms_sql.parse(c => ln_cursor, statement => ga_stmt

234: BEGIN
235: IF (ab_long_stmt_i)
236: THEN
237: ln_cursor := dbms_sql.open_cursor;
238: dbms_sql.parse(c => ln_cursor, statement => ga_stmt
239: , lb => 1, ub => ga_stmt.COUNT
240: , lfflg => FALSE, language_flag => dbms_sql.native
241: );
242: ln_dummy := dbms_sql.execute(ln_cursor);

Line 240: , lfflg => FALSE, language_flag => dbms_sql.native

236: THEN
237: ln_cursor := dbms_sql.open_cursor;
238: dbms_sql.parse(c => ln_cursor, statement => ga_stmt
239: , lb => 1, ub => ga_stmt.COUNT
240: , lfflg => FALSE, language_flag => dbms_sql.native
241: );
242: ln_dummy := dbms_sql.execute(ln_cursor);
243: dbms_sql.close_cursor(ln_cursor);
244: ga_stmt.DELETE;

Line 242: ln_dummy := dbms_sql.execute(ln_cursor);

238: dbms_sql.parse(c => ln_cursor, statement => ga_stmt
239: , lb => 1, ub => ga_stmt.COUNT
240: , lfflg => FALSE, language_flag => dbms_sql.native
241: );
242: ln_dummy := dbms_sql.execute(ln_cursor);
243: dbms_sql.close_cursor(ln_cursor);
244: ga_stmt.DELETE;
245: ELSE
246: EXECUTE IMMEDIATE as_stmt_i;

Line 243: dbms_sql.close_cursor(ln_cursor);

239: , lb => 1, ub => ga_stmt.COUNT
240: , lfflg => FALSE, language_flag => dbms_sql.native
241: );
242: ln_dummy := dbms_sql.execute(ln_cursor);
243: dbms_sql.close_cursor(ln_cursor);
244: ga_stmt.DELETE;
245: ELSE
246: EXECUTE IMMEDIATE as_stmt_i;
247: END IF;

Line 295: -- executed by preparing ga_stmt before dbms_sql.parse()

291: END drop_mv;
292:
293: --
294: -- This procedure allows really long statements to be
295: -- executed by preparing ga_stmt before dbms_sql.parse()
296: -- is called in other procedures.
297: --
298: -- If the calling program needs to call this procedure
299: -- several times to pass a single statement, make sure