SYSTEM.AD_CLONE_UTILS dependencies on DBA_OBJECTS

Line 508: FROM DBA_OBJECTS spec

504:
505: begin
506: SELECT spec.timestamp, temporary
507: INTO l_spec_table_timestamp, l_temporary
508: FROM DBA_OBJECTS spec
509: WHERE spec.OWNER = X_to_schema
510: AND spec.OBJECT_NAME = X_table_name
511: AND spec.OBJECT_TYPE = 'TABLE';
512:

Line 527: FROM DBA_OBJECTS src

523:
524: begin
525: SELECT src.timestamp, nvl(l_temporary, temporary)
526: INTO l_source_table_timestamp, l_temporary
527: FROM DBA_OBJECTS src
528: WHERE src.OWNER = X_from_schema
529: AND src.OBJECT_NAME = X_table_name
530: AND src.OBJECT_TYPE = 'TABLE';
531:

Line 882: from dba_objects

878: begin
879:
880: select object_type, object_name
881: bulk collect into spec_obj_type_tab, spec_obj_name_tab
882: from dba_objects
883: where owner = X_spec_schema
884: and object_name not in ('APPS_DDL', 'APPS_ARRAY_DDL')
885: and object_type not in ('INDEX', 'LOB INDEX', 'LOB');
886:

Line 988: from dba_objects

984: begin
985:
986: select object_type, object_name
987: bulk collect into clone_obj_type_tab, clone_obj_name_tab
988: from dba_objects
989: where owner = X_clone_schema
990: and object_type not in ('INDEX', 'LOB INDEX', 'LOB')
991: and object_name not in ('APPS_DDL', 'APPS_ARRAY_DDL')
992: order by decode(object_type, 'PACKAGE', 1, 'VIEW', 2,

Line 1044: from dba_objects

1040: end loop;
1041:
1042: select count(*)
1043: into l_obj_count
1044: from dba_objects
1045: where owner = X_clone_schema
1046: and object_name not in ('APPS_DDL', 'APPS_ARRAY_DDL');
1047:
1048: println('Number of objects remaining after the cleanup operation : '||