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

Line 717: -- Gets the DDL by using dbms_metadata and creates in APPS_NE schema

713: end FIX_TYPE;
714:
715: --
716: -- The procedure works as follows:
717: -- Gets the DDL by using dbms_metadata and creates in APPS_NE schema
718: --
719: --
720: procedure COPY_TYPE(X_OWNER in varchar2,
721: X_NAME in varchar2,

Line 744: dm_h := dbms_metadata.open('TYPE');

740: log(l_module, 'STATEMENT', 'Type: '||x_owner||'.'||x_name || ' does not exist - noop');
741: return;
742: end;
743:
744: dm_h := dbms_metadata.open('TYPE');
745: dbms_metadata.set_filter(dm_h, 'SCHEMA', X_OWNER);
746: dbms_metadata.set_filter(dm_h, 'NAME', X_NAME);
747: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', true);
748: dbms_metadata.set_filter(dm_h, 'BODY', false);

Line 745: dbms_metadata.set_filter(dm_h, 'SCHEMA', X_OWNER);

741: return;
742: end;
743:
744: dm_h := dbms_metadata.open('TYPE');
745: dbms_metadata.set_filter(dm_h, 'SCHEMA', X_OWNER);
746: dbms_metadata.set_filter(dm_h, 'NAME', X_NAME);
747: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', true);
748: dbms_metadata.set_filter(dm_h, 'BODY', false);
749: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');

Line 746: dbms_metadata.set_filter(dm_h, 'NAME', X_NAME);

742: end;
743:
744: dm_h := dbms_metadata.open('TYPE');
745: dbms_metadata.set_filter(dm_h, 'SCHEMA', X_OWNER);
746: dbms_metadata.set_filter(dm_h, 'NAME', X_NAME);
747: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', true);
748: dbms_metadata.set_filter(dm_h, 'BODY', false);
749: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');
750: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);

Line 747: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', true);

743:
744: dm_h := dbms_metadata.open('TYPE');
745: dbms_metadata.set_filter(dm_h, 'SCHEMA', X_OWNER);
746: dbms_metadata.set_filter(dm_h, 'NAME', X_NAME);
747: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', true);
748: dbms_metadata.set_filter(dm_h, 'BODY', false);
749: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');
750: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);
751: dm_t := dbms_metadata.add_transform(dm_h, 'DDL');

Line 748: dbms_metadata.set_filter(dm_h, 'BODY', false);

744: dm_h := dbms_metadata.open('TYPE');
745: dbms_metadata.set_filter(dm_h, 'SCHEMA', X_OWNER);
746: dbms_metadata.set_filter(dm_h, 'NAME', X_NAME);
747: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', true);
748: dbms_metadata.set_filter(dm_h, 'BODY', false);
749: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');
750: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);
751: dm_t := dbms_metadata.add_transform(dm_h, 'DDL');
752:

Line 749: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');

745: dbms_metadata.set_filter(dm_h, 'SCHEMA', X_OWNER);
746: dbms_metadata.set_filter(dm_h, 'NAME', X_NAME);
747: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', true);
748: dbms_metadata.set_filter(dm_h, 'BODY', false);
749: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');
750: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);
751: dm_t := dbms_metadata.add_transform(dm_h, 'DDL');
752:
753: l_ddl := dbms_metadata.fetch_clob(dm_h);

Line 750: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);

746: dbms_metadata.set_filter(dm_h, 'NAME', X_NAME);
747: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', true);
748: dbms_metadata.set_filter(dm_h, 'BODY', false);
749: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');
750: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);
751: dm_t := dbms_metadata.add_transform(dm_h, 'DDL');
752:
753: l_ddl := dbms_metadata.fetch_clob(dm_h);
754: dbms_metadata.close(dm_h);

Line 751: dm_t := dbms_metadata.add_transform(dm_h, 'DDL');

747: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', true);
748: dbms_metadata.set_filter(dm_h, 'BODY', false);
749: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');
750: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);
751: dm_t := dbms_metadata.add_transform(dm_h, 'DDL');
752:
753: l_ddl := dbms_metadata.fetch_clob(dm_h);
754: dbms_metadata.close(dm_h);
755:

Line 753: l_ddl := dbms_metadata.fetch_clob(dm_h);

749: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');
750: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);
751: dm_t := dbms_metadata.add_transform(dm_h, 'DDL');
752:
753: l_ddl := dbms_metadata.fetch_clob(dm_h);
754: dbms_metadata.close(dm_h);
755:
756: if (l_ddl is not null ) then
757: l_ddl := remove_schema_qualifiers(l_ddl );

Line 754: dbms_metadata.close(dm_h);

750: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);
751: dm_t := dbms_metadata.add_transform(dm_h, 'DDL');
752:
753: l_ddl := dbms_metadata.fetch_clob(dm_h);
754: dbms_metadata.close(dm_h);
755:
756: if (l_ddl is not null ) then
757: l_ddl := remove_schema_qualifiers(l_ddl );
758: if(is_type_exists(x_new_owner, x_name) = false ) then

Line 763: log(l_module, 'ERROR', 'dbms_metadata returned null for User-Defined-Type Specification: '||x_owner||'.'||x_name );

759: log(l_module, 'EVENT', 'Creating TYPE: '||x_new_owner||'.'||x_name);
760: exec(x_sql => l_ddl, x_log_mod => l_module, x_ignore=>true);
761: end if;
762: else
763: log(l_module, 'ERROR', 'dbms_metadata returned null for User-Defined-Type Specification: '||x_owner||'.'||x_name );
764: -- Shall we raise an error from here?
765: raise_application_error(-20996,
766: 'dbms_metadata returned null for User-Defined-Type Specification: ' ||x_owner||'.'||x_name);
767: end if;

Line 766: 'dbms_metadata returned null for User-Defined-Type Specification: ' ||x_owner||'.'||x_name);

762: else
763: log(l_module, 'ERROR', 'dbms_metadata returned null for User-Defined-Type Specification: '||x_owner||'.'||x_name );
764: -- Shall we raise an error from here?
765: raise_application_error(-20996,
766: 'dbms_metadata returned null for User-Defined-Type Specification: ' ||x_owner||'.'||x_name);
767: end if;
768: if(dbms_lob.istemporary(l_ddl) =1 ) then
769: dbms_lob.freetemporary(l_ddl);
770: end if;

Line 773: dm_h := dbms_metadata.open('TYPE');

769: dbms_lob.freetemporary(l_ddl);
770: end if;
771:
772: -- STEP#2 Follow same steps for OBJECT Body
773: dm_h := dbms_metadata.open('TYPE');
774: dbms_metadata.set_filter(dm_h, 'SCHEMA', X_OWNER);
775: dbms_metadata.set_filter(dm_h, 'NAME', X_NAME);
776: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', FALSE);
777: dbms_metadata.set_filter(dm_h, 'BODY', TRUE);

Line 774: dbms_metadata.set_filter(dm_h, 'SCHEMA', X_OWNER);

770: end if;
771:
772: -- STEP#2 Follow same steps for OBJECT Body
773: dm_h := dbms_metadata.open('TYPE');
774: dbms_metadata.set_filter(dm_h, 'SCHEMA', X_OWNER);
775: dbms_metadata.set_filter(dm_h, 'NAME', X_NAME);
776: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', FALSE);
777: dbms_metadata.set_filter(dm_h, 'BODY', TRUE);
778:

Line 775: dbms_metadata.set_filter(dm_h, 'NAME', X_NAME);

771:
772: -- STEP#2 Follow same steps for OBJECT Body
773: dm_h := dbms_metadata.open('TYPE');
774: dbms_metadata.set_filter(dm_h, 'SCHEMA', X_OWNER);
775: dbms_metadata.set_filter(dm_h, 'NAME', X_NAME);
776: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', FALSE);
777: dbms_metadata.set_filter(dm_h, 'BODY', TRUE);
778:
779: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');

Line 776: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', FALSE);

772: -- STEP#2 Follow same steps for OBJECT Body
773: dm_h := dbms_metadata.open('TYPE');
774: dbms_metadata.set_filter(dm_h, 'SCHEMA', X_OWNER);
775: dbms_metadata.set_filter(dm_h, 'NAME', X_NAME);
776: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', FALSE);
777: dbms_metadata.set_filter(dm_h, 'BODY', TRUE);
778:
779: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');
780: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);

Line 777: dbms_metadata.set_filter(dm_h, 'BODY', TRUE);

773: dm_h := dbms_metadata.open('TYPE');
774: dbms_metadata.set_filter(dm_h, 'SCHEMA', X_OWNER);
775: dbms_metadata.set_filter(dm_h, 'NAME', X_NAME);
776: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', FALSE);
777: dbms_metadata.set_filter(dm_h, 'BODY', TRUE);
778:
779: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');
780: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);
781: dm_t := dbms_metadata.add_transform(dm_h, 'DDL');

Line 779: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');

775: dbms_metadata.set_filter(dm_h, 'NAME', X_NAME);
776: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', FALSE);
777: dbms_metadata.set_filter(dm_h, 'BODY', TRUE);
778:
779: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');
780: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);
781: dm_t := dbms_metadata.add_transform(dm_h, 'DDL');
782:
783: l_ddl := dbms_metadata.fetch_clob(dm_h);

Line 780: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);

776: dbms_metadata.set_filter(dm_h, 'SPECIFICATION', FALSE);
777: dbms_metadata.set_filter(dm_h, 'BODY', TRUE);
778:
779: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');
780: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);
781: dm_t := dbms_metadata.add_transform(dm_h, 'DDL');
782:
783: l_ddl := dbms_metadata.fetch_clob(dm_h);
784: dbms_metadata.close(dm_h);

Line 781: dm_t := dbms_metadata.add_transform(dm_h, 'DDL');

777: dbms_metadata.set_filter(dm_h, 'BODY', TRUE);
778:
779: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');
780: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);
781: dm_t := dbms_metadata.add_transform(dm_h, 'DDL');
782:
783: l_ddl := dbms_metadata.fetch_clob(dm_h);
784: dbms_metadata.close(dm_h);
785:

Line 783: l_ddl := dbms_metadata.fetch_clob(dm_h);

779: dm_t := dbms_metadata.add_transform(dm_h, 'MODIFY');
780: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);
781: dm_t := dbms_metadata.add_transform(dm_h, 'DDL');
782:
783: l_ddl := dbms_metadata.fetch_clob(dm_h);
784: dbms_metadata.close(dm_h);
785:
786: if (l_ddl is not null ) then
787: l_ddl := remove_schema_qualifiers(l_ddl);

Line 784: dbms_metadata.close(dm_h);

780: dbms_metadata.set_remap_param(dm_t, 'REMAP_SCHEMA', X_OWNER, X_NEW_OWNER);
781: dm_t := dbms_metadata.add_transform(dm_h, 'DDL');
782:
783: l_ddl := dbms_metadata.fetch_clob(dm_h);
784: dbms_metadata.close(dm_h);
785:
786: if (l_ddl is not null ) then
787: l_ddl := remove_schema_qualifiers(l_ddl);
788: if(is_type_body_exists(x_new_owner, x_name) = false ) then

Line 793: log(l_module, 'STATEMENT', 'dbms_metadata returned null for User-Defined-Type Body: '||x_owner||'.'||x_name );

789: log(l_module, 'EVENT', 'Creating TYPE BODY: '||x_new_owner||'.'||x_name);
790: exec(x_sql => l_ddl, x_log_mod => l_module, x_ignore=>true);
791: end if;
792: else
793: log(l_module, 'STATEMENT', 'dbms_metadata returned null for User-Defined-Type Body: '||x_owner||'.'||x_name );
794: end if;
795:
796: if(dbms_lob.istemporary(l_ddl) =1 ) then
797: dbms_lob.freetemporary(l_ddl);