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_TABLE dependencies on DBMS_METADATA

Line 263: l_open_handle := dbms_metadata.open(x_object_type);

259: begin
260: log(c_module, 'STATEMENT',
261: 'Getting DDLs for '||x_object_owner||'.'||x_object_name||', '|| x_object_type);
262:
263: l_open_handle := dbms_metadata.open(x_object_type);
264: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', x_object_owner);
265: dbms_metadata.set_filter(l_open_handle, 'NAME', x_object_name);
266: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
267: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);

Line 264: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', x_object_owner);

260: log(c_module, 'STATEMENT',
261: 'Getting DDLs for '||x_object_owner||'.'||x_object_name||', '|| x_object_type);
262:
263: l_open_handle := dbms_metadata.open(x_object_type);
264: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', x_object_owner);
265: dbms_metadata.set_filter(l_open_handle, 'NAME', x_object_name);
266: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
267: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
268:

Line 265: dbms_metadata.set_filter(l_open_handle, 'NAME', x_object_name);

261: 'Getting DDLs for '||x_object_owner||'.'||x_object_name||', '|| x_object_type);
262:
263: l_open_handle := dbms_metadata.open(x_object_type);
264: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', x_object_owner);
265: dbms_metadata.set_filter(l_open_handle, 'NAME', x_object_name);
266: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
267: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
268:
269: l_ddl_stmts := dbms_metadata.fetch_ddl(l_open_handle);

Line 266: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');

262:
263: l_open_handle := dbms_metadata.open(x_object_type);
264: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', x_object_owner);
265: dbms_metadata.set_filter(l_open_handle, 'NAME', x_object_name);
266: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
267: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
268:
269: l_ddl_stmts := dbms_metadata.fetch_ddl(l_open_handle);
270: dbms_metadata.close(l_open_handle);

Line 267: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);

263: l_open_handle := dbms_metadata.open(x_object_type);
264: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', x_object_owner);
265: dbms_metadata.set_filter(l_open_handle, 'NAME', x_object_name);
266: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
267: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
268:
269: l_ddl_stmts := dbms_metadata.fetch_ddl(l_open_handle);
270: dbms_metadata.close(l_open_handle);
271:

Line 269: l_ddl_stmts := dbms_metadata.fetch_ddl(l_open_handle);

265: dbms_metadata.set_filter(l_open_handle, 'NAME', x_object_name);
266: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
267: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
268:
269: l_ddl_stmts := dbms_metadata.fetch_ddl(l_open_handle);
270: dbms_metadata.close(l_open_handle);
271:
272: return l_ddl_stmts;
273: end FETCH_MULTIPLE_DDLS;

Line 270: dbms_metadata.close(l_open_handle);

266: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
267: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
268:
269: l_ddl_stmts := dbms_metadata.fetch_ddl(l_open_handle);
270: dbms_metadata.close(l_open_handle);
271:
272: return l_ddl_stmts;
273: end FETCH_MULTIPLE_DDLS;
274:

Line 404: -- It has been found if synonym points to EV then DBMS_METADATA returns

400: '"?)[.]?"?'|| ev_view(X_TABLE_NAME) ||'"?[[:space:]]';
401:
402: -- Match#2_1 : trg-owner.EV
403: -- SSTOMAR:
404: -- It has been found if synonym points to EV then DBMS_METADATA returns
405: -- [... ON "trg-owner"."EV-name"] , NOT [ ... ON "ev-owner"."ev-name" ]
406: L_REG_EXP_PATTERN_2_1 varchar2(127) := '[[:space:]]ON[[:space:]]*("?' || X_TRIGGER_OWNER ||
407: '"?)[.]?"?'|| ev_view(X_TABLE_NAME) ||'"?[[:space:]]';
408:

Line 1852: -- TODO: use DBMS_METADATA

1848: null;
1849: end;
1850:
1851: -- generate pre/post statement
1852: -- TODO: use DBMS_METADATA
1853: select table_owner, table_name,
1854: 'create '||
1855: decode(index_type,
1856: 'NORMAL', decode(uniqueness, 'UNIQUE', 'UNIQUE', ''),