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_ZD_MVIEW dependencies on DBMS_SQL

Line 194: | Execute Immediate is more efficient than dbms_sql.parse |

190: /*-----------------------------------------------------------------+
191: | |
192: | EXPAND_QUERY |
193: | Takes the command as input and executes it. |
194: | Execute Immediate is more efficient than dbms_sql.parse |
195: | Refer :- http://download.oracle.com/docs/cd/B28359_01/ |
196: | appdev.111/b28370/dynamic.htm |
197: | |
198: +-----------------------------------------------------------------*/

Line 205: dbms_sql2.expand_sql_text(p_query, l_exp_select_query);

201: is
202: l_exp_select_query clob;
203: begin
204: -- Expand the select query
205: dbms_sql2.expand_sql_text(p_query, l_exp_select_query);
206: return l_exp_select_query;
207: end;
208:
209:

Line 229: l_cur := dbms_sql.open_cursor;

225: PRAGMA EXCEPTION_INIT(e_shape_mismatch, -12060);
226: e_table_already_referenced exception;
227: PRAGMA EXCEPTION_INIT(e_table_already_referenced, -32334);
228: begin
229: l_cur := dbms_sql.open_cursor;
230:
231: if (x_owner is null) then
232: log(x_module, 'STATEMENT', 'SQL: '||substr(x_command, 1, 3900));
233: dbms_sql.parse(l_cur, x_command, dbms_sql.native);

Line 233: dbms_sql.parse(l_cur, x_command, dbms_sql.native);

229: l_cur := dbms_sql.open_cursor;
230:
231: if (x_owner is null) then
232: log(x_module, 'STATEMENT', 'SQL: '||substr(x_command, 1, 3900));
233: dbms_sql.parse(l_cur, x_command, dbms_sql.native);
234: else
235: l_stmt := 'begin '||x_owner||'.apps_ddl.apps_ddl(:stmt); end;';
236: log(x_module, 'STATEMENT', 'SQL['||x_owner||']: '||substr(x_command, 1, 3900));
237: dbms_sql.parse(l_cur, l_stmt, dbms_sql.native);

Line 237: dbms_sql.parse(l_cur, l_stmt, dbms_sql.native);

233: dbms_sql.parse(l_cur, x_command, dbms_sql.native);
234: else
235: l_stmt := 'begin '||x_owner||'.apps_ddl.apps_ddl(:stmt); end;';
236: log(x_module, 'STATEMENT', 'SQL['||x_owner||']: '||substr(x_command, 1, 3900));
237: dbms_sql.parse(l_cur, l_stmt, dbms_sql.native);
238: dbms_sql.bind_variable(l_cur, 'stmt', x_command);
239: end if;
240:
241: rows_processed := dbms_sql.execute(l_cur);

Line 238: dbms_sql.bind_variable(l_cur, 'stmt', x_command);

234: else
235: l_stmt := 'begin '||x_owner||'.apps_ddl.apps_ddl(:stmt); end;';
236: log(x_module, 'STATEMENT', 'SQL['||x_owner||']: '||substr(x_command, 1, 3900));
237: dbms_sql.parse(l_cur, l_stmt, dbms_sql.native);
238: dbms_sql.bind_variable(l_cur, 'stmt', x_command);
239: end if;
240:
241: rows_processed := dbms_sql.execute(l_cur);
242: dbms_sql.close_cursor(l_cur);

Line 241: rows_processed := dbms_sql.execute(l_cur);

237: dbms_sql.parse(l_cur, l_stmt, dbms_sql.native);
238: dbms_sql.bind_variable(l_cur, 'stmt', x_command);
239: end if;
240:
241: rows_processed := dbms_sql.execute(l_cur);
242: dbms_sql.close_cursor(l_cur);
243: EXCEPTION
244: WHEN e_udt_prebuilt or
245: e_rowid_prebuilt or

Line 242: dbms_sql.close_cursor(l_cur);

238: dbms_sql.bind_variable(l_cur, 'stmt', x_command);
239: end if;
240:
241: rows_processed := dbms_sql.execute(l_cur);
242: dbms_sql.close_cursor(l_cur);
243: EXCEPTION
244: WHEN e_udt_prebuilt or
245: e_rowid_prebuilt or
246: e_shape_mismatch or

Line 248: dbms_sql.close_cursor(l_cur);

244: WHEN e_udt_prebuilt or
245: e_rowid_prebuilt or
246: e_shape_mismatch or
247: e_table_already_referenced THEN
248: dbms_sql.close_cursor(l_cur);
249: log(x_module, 'EVENT', SQLERRM||substr(x_command, 1, 3900));
250: raise;
251: WHEN OTHERS THEN
252: dbms_sql.close_cursor(l_cur);

Line 252: dbms_sql.close_cursor(l_cur);

248: dbms_sql.close_cursor(l_cur);
249: log(x_module, 'EVENT', SQLERRM||substr(x_command, 1, 3900));
250: raise;
251: WHEN OTHERS THEN
252: dbms_sql.close_cursor(l_cur);
253: log(x_module, 'ERROR', SQLERRM||substr(x_command, 1, 3900));
254: raise;
255: end;
256:

Line 1717: ** b. Expand mvq's ddl using dbms_sql2.expand_sql_text

1713: ** CUTOVER
1714: **
1715: ** For each mvq actualized in the current edition
1716: ** a. Get the mvq ddl query and its comment
1717: ** b. Expand mvq's ddl using dbms_sql2.expand_sql_text
1718: ** c. Get the corresponding mv ddl sql query
1719: ** d. Compare, if there is any difference then re-install MV
1720: */
1721: procedure CUTOVER(x_execute number default 0)