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_METADATA

Line 278: l_mvlogddl := dbms_metadata.get_ddl('MATERIALIZED_VIEW_LOG',

274: FROM dba_mview_logs
275: WHERE master=p_mview_name
276: AND log_owner=p_owner;
277:
278: l_mvlogddl := dbms_metadata.get_ddl('MATERIALIZED_VIEW_LOG',
279: l_ctblname,
280: p_owner);
281:
282: -- The max length of comment can be 4000

Line 387: l_open_handle := dbms_metadata.open(p_type);

383:
384: begin
385: log(c_module, 'PROCEDURE', 'begin: '||p_type||'.'||p_owner||'.'||p_object_name);
386:
387: l_open_handle := dbms_metadata.open(p_type);
388: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', p_owner);
389: dbms_metadata.set_filter(l_open_handle, 'NAME', p_object_name);
390: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
391: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);

Line 388: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', p_owner);

384: begin
385: log(c_module, 'PROCEDURE', 'begin: '||p_type||'.'||p_owner||'.'||p_object_name);
386:
387: l_open_handle := dbms_metadata.open(p_type);
388: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', p_owner);
389: dbms_metadata.set_filter(l_open_handle, 'NAME', p_object_name);
390: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
391: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
392: l_ddls := dbms_metadata.fetch_ddl(l_open_handle);

Line 389: dbms_metadata.set_filter(l_open_handle, 'NAME', p_object_name);

385: log(c_module, 'PROCEDURE', 'begin: '||p_type||'.'||p_owner||'.'||p_object_name);
386:
387: l_open_handle := dbms_metadata.open(p_type);
388: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', p_owner);
389: dbms_metadata.set_filter(l_open_handle, 'NAME', p_object_name);
390: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
391: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
392: l_ddls := dbms_metadata.fetch_ddl(l_open_handle);
393: dbms_metadata.close(l_open_handle);

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

386:
387: l_open_handle := dbms_metadata.open(p_type);
388: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', p_owner);
389: dbms_metadata.set_filter(l_open_handle, 'NAME', p_object_name);
390: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
391: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
392: l_ddls := dbms_metadata.fetch_ddl(l_open_handle);
393: dbms_metadata.close(l_open_handle);
394:

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

387: l_open_handle := dbms_metadata.open(p_type);
388: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', p_owner);
389: dbms_metadata.set_filter(l_open_handle, 'NAME', p_object_name);
390: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
391: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
392: l_ddls := dbms_metadata.fetch_ddl(l_open_handle);
393: dbms_metadata.close(l_open_handle);
394:
395: if (l_ddls.count > 0) then

Line 392: l_ddls := dbms_metadata.fetch_ddl(l_open_handle);

388: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', p_owner);
389: dbms_metadata.set_filter(l_open_handle, 'NAME', p_object_name);
390: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
391: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
392: l_ddls := dbms_metadata.fetch_ddl(l_open_handle);
393: dbms_metadata.close(l_open_handle);
394:
395: if (l_ddls.count > 0) then
396: l_ddl := dbms_lob.substr(l_ddls(1).ddltext);

Line 393: dbms_metadata.close(l_open_handle);

389: dbms_metadata.set_filter(l_open_handle, 'NAME', p_object_name);
390: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
391: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
392: l_ddls := dbms_metadata.fetch_ddl(l_open_handle);
393: dbms_metadata.close(l_open_handle);
394:
395: if (l_ddls.count > 0) then
396: l_ddl := dbms_lob.substr(l_ddls(1).ddltext);
397: end if;

Line 617: SELECT dbms_metadata.get_ddl('VIEW', p_mvqname, p_owner)

613: BEGIN
614: log(c_module, 'STATEMENT', 'Getting Logical Definition from '||p_owner||'.'||p_mvqname);
615:
616: begin
617: SELECT dbms_metadata.get_ddl('VIEW', p_mvqname, p_owner)
618: INTO p_mvqdef
619: FROM dual;
620: exception
621: when others then

Line 629: SELECT dbms_metadata.get_dependent_ddl('COMMENT', p_mvqname, p_owner)

625: raise;
626: end;
627:
628: begin
629: SELECT dbms_metadata.get_dependent_ddl('COMMENT', p_mvqname, p_owner)
630: INTO p_comment
631: FROM dual;
632: exception
633: when others then

Line 638: dbms_metadata.get_dependent_ddl to get the comment'||SQLCODE);

634: if (SQLCODE = -31608) then
635: p_comment := null;
636: else
637: log(c_module, 'ERROR', 'Exception while calling
638: dbms_metadata.get_dependent_ddl to get the comment'||SQLCODE);
639: raise;
640: end if;
641: end;
642: end get_mvq_definition;

Line 1488: -- TODO: Try to use the dbms_metadata to convert the ddl into xml format

1484: | All the Mview attributes will be added as |
1485: | comments to MVQ |
1486: | |
1487: +-----------------------------------------------------------------*/
1488: -- TODO: Try to use the dbms_metadata to convert the ddl into xml format
1489: -- always do execute immediate. Because it installs only MVQ
1490: procedure PATCH(p_mvdef CLOB)
1491: is
1492: c_module varchar2(25) := 'patch';

Line 1584: l_tmpmvdef := dbms_metadata.get_ddl('MATERIALIZED_VIEW', p_mvname, p_owner);

1580:
1581: if (l_mvq_exist > 0) then
1582: get_mvq_definition(p_owner, l_mvq_name, l_mvqdef, l_mvqcomment);
1583: else
1584: l_tmpmvdef := dbms_metadata.get_ddl('MATERIALIZED_VIEW', p_mvname, p_owner);
1585: generate_mvqdef(l_tmpmvdef, l_dummy1, l_dummy2, l_mvqdef, l_mvqcomment);
1586: end if;
1587:
1588: -- Check for Prebuilt table

Line 1838: l_mvdef := dbms_metadata.get_ddl('MATERIALIZED_VIEW', p_mview_name, p_owner);

1834: if (l_mvq_exist = 0) then
1835: -- Dont get the query directly from data dictionary. Because
1836: -- from ad_mv if the mv is new then the api cannot get the sql query
1837: -- from data dictionary. It has to parse query only.
1838: l_mvdef := dbms_metadata.get_ddl('MATERIALIZED_VIEW', p_mview_name, p_owner);
1839: install_mvq(l_mvdef, l_dummy1, l_dummy2);
1840: end if;
1841:
1842: -- Create MV Implementation from Logical Definition