APPS.AD_ZD_PREP dependencies on DBA_DEPENDENCIES

Line 333: from dba_dependencies dep,

329: --TODO: Waiting for George's reply on it.
330: --
331: -- adding DISTINCT as two tabls might refer same xml schema
332: select distinct xmls.owner, xmls.schema_url
333: from dba_dependencies dep,
334: dba_xml_schemas xmls
335: where dep.type='TABLE'
336: and dep.owner in
337: (select oracle_username

Line 509: from dba_dependencies d

505: cursor C_TYPES is
506: with p(referenced_owner, referenced_name) as
507: (
508: select referenced_owner, referenced_name
509: from dba_dependencies d
510: where d.type = 'TABLE'
511: and d.name = upper (name)
512: and d.referenced_type = 'TYPE'
513: and d.referenced_name = upper(d.referenced_name)

Line 524: from dba_dependencies

520: )
521: or
522: exists
523: ( select 1
524: from dba_dependencies
525: where owner = d.referenced_owner
526: and name = d.referenced_name
527: and type = d.referenced_type
528: and referenced_type = 'TYPE'

Line 547: from dba_dependencies d,

543: where e.xmldata.property.sqlcolltype = d.referenced_name)
544: union all
545: select d.referenced_owner referenced_owner,
546: d.referenced_name referenced_name
547: from dba_dependencies d,
548: p
549: where d.referenced_type = 'TYPE'
550: and d.referenced_name = upper (d.referenced_name )
551: and d.name = p.referenced_name

Line 614: from dba_dependencies dep

610:
611: -- tables that reference the specified type
612: cursor C_TABLE_REFS(TYPE_OWNER varchar2, TYPE_NAME varchar2) is
613: select dep.owner, dep.name
614: from dba_dependencies dep
615: where dep.type = 'TABLE'
616: and dep.referenced_owner= type_owner
617: and dep.referenced_name = type_name
618: and dep.referenced_type = 'TYPE';

Line 623: from dba_dependencies ot,

619:
620: -- types that reference the specified type and have a replacement in APPS_NE
621: cursor C_TYPE_REFS(XX_TYPE_OWNER varchar2, XX_TYPE_NAME varchar2) is
622: select ot.owner, ot.name
623: from dba_dependencies ot,
624: dba_types nt
625: where ot.type = 'TYPE'
626: and ot.referenced_owner= xx_type_owner
627: and ot.referenced_name = xx_type_name

Line 635: from dba_dependencies dep

631:
632: -- tables that references the specific type or its dependent type
633: cursor C_TABLE_REFS2(TYPE_OWNER varchar2, TYPE_NAME varchar2) is
634: select dep.owner, dep.name
635: from dba_dependencies dep
636: where dep.type = 'TABLE'
637: and dep.referenced_owner <> g_apps_ne_schema
638: start with
639: dep.referenced_owner = type_owner

Line 819: from dba_dependencies d

815: cursor all_types is
816: with p(referenced_owner, referenced_name) as
817: (
818: select referenced_owner, referenced_name
819: from dba_dependencies d
820: where d.type = 'TABLE'
821: and d.name = upper (name)
822: and d.referenced_type = 'TYPE'
823: and d.referenced_name = upper(d.referenced_name)

Line 834: from dba_dependencies

830: )
831: OR
832: exists
833: ( select 1
834: from dba_dependencies
835: where owner = d.referenced_owner
836: and name = d.referenced_name
837: and type = d.referenced_type
838: and referenced_type = 'TYPE'

Line 858: from dba_dependencies d,

854:
855: union all
856: select d.referenced_owner referenced_owner,
857: d.referenced_name referenced_name
858: from dba_dependencies d,
859: p
860: where d.referenced_type = 'TYPE'
861: and d.referenced_name = upper (d.referenced_name )
862: and d.name = p.referenced_name

Line 1076: from dba_dependencies d

1072: cursor all_evolved_types is
1073: with p(referenced_owner, referenced_name) as
1074: (
1075: select referenced_owner, referenced_name
1076: from dba_dependencies d
1077: where type = 'TABLE'
1078: and name = upper ( name )
1079: and referenced_type = 'TYPE'
1080: and referenced_name = upper (referenced_name)

Line 1091: from dba_dependencies

1087: )
1088: or
1089: exists
1090: ( select 1
1091: from dba_dependencies
1092: where owner = d.referenced_owner
1093: and name = d.referenced_name
1094: and type = d.referenced_type
1095: and referenced_type = 'TYPE'

Line 1125: from dba_dependencies d,

1121:
1122: union all
1123: select d.referenced_owner referenced_owner,
1124: d.referenced_name referenced_name
1125: from dba_dependencies d,
1126: p
1127: where d.referenced_type = 'TYPE'
1128: and d.referenced_name = upper(d.referenced_name )
1129: and d.name = p.referenced_name

Line 1194: from dba_dependencies d

1190: begin
1191: log(l_module, 'PROCEDURE', 'begin');
1192:
1193: select count(1) into l_count
1194: from dba_dependencies d
1195: where d.type = 'TABLE'
1196: and d.name = upper(name)
1197: and d.referenced_type = 'TYPE'
1198: and d.referenced_name = upper(d.referenced_name)

Line 1208: from dba_dependencies

1204: )
1205: OR
1206: exists
1207: ( select 1
1208: from dba_dependencies
1209: where owner = d.referenced_owner
1210: and name = d.referenced_name
1211: and type = d.referenced_type
1212: and referenced_type = 'TYPE'

Line 1513: from dba_dependencies dep

1509: and acol.data_type_owner='SYSTEM'
1510: and exists
1511: (
1512: select 1
1513: from dba_dependencies dep
1514: where dep.type = 'TYPE'
1515: start with dep.owner = acol.data_type_owner
1516: and dep.name = acol.DATA_TYPE
1517: and dep.type = 'TYPE'

Line 1648: from dba_dependencies

1644: L_OBJECT_TYPE varchar2(30);
1645:
1646: cursor C_DEPNDENT_USERS is
1647: select distinct owner
1648: from dba_dependencies
1649: where referenced_owner = 'PUBLIC'
1650: and referenced_type = 'SYNONYM'
1651: and referenced_name = x_synonym_name
1652: and owner in ( select oracle_username

Line 1753: from dba_dependencies

1749: is
1750: l_module varchar2(80) := c_package || 'fix_ctxsys';
1751: cursor ctxpkg is
1752: select distinct name
1753: from dba_dependencies
1754: where owner='CTXSYS'
1755: and TYPE='PACKAGE BODY'
1756: and referenced_owner in
1757: ( select oracle_username