APPS.AD_ZD_PREP dependencies on OBJ$

Line 131: from sys.obj$ o

127: l_obj_cnt pls_integer :=0;
128: begin
129:
130: select count(obj#) into l_obj_cnt
131: from sys.obj$ o
132: where owner# =(select user# from sys.user$ where name = x_owner)
133: and o.NAME = x_name
134: and o.type# = 13 --13 = TYPE,
135: and o.subname is not null; --only for evloved type

Line 176: from sys.obj$ o

172: l_obj_cnt pls_integer :=0;
173: begin
174:
175: select count(obj#) into l_obj_cnt
176: from sys.obj$ o
177: where owner# =(select user# from sys.user$ where name = x_owner)
178: and o.NAME = x_name
179: and o.type# = 13;
180:

Line 200: from sys.obj$ o

196: l_obj_cnt pls_integer :=0;
197: begin
198:
199: select count(obj#) into l_obj_cnt
200: from sys.obj$ o
201: where owner# =(select user# from sys.user$ where name = x_owner)
202: and o.NAME = x_name
203: and o.type# = 14; -- 14: TYPE BODY
204:

Line 1108: from sys.obj$ o

1104: -- Only take care evolved types i.e. exclude normal UDT
1105: --
1106: and exists
1107: ( select 1
1108: from sys.obj$ o
1109: where owner# =(select user# from sys.user$ where name = referenced_owner)
1110: and o.NAME = referenced_name
1111: and o.type# = 13
1112: and o.subname is not null

Line 1138: from sys.obj$ o

1134: where read_only_flag in ('A','B', 'E', 'U', 'C')
1135: )
1136: and exists
1137: ( select 1
1138: from sys.obj$ o
1139: where owner# =(select user# from sys.user$ where name = d.referenced_owner)
1140: and o.name = d.referenced_name
1141: and o.type# = 13 --13 = TYPE,
1142: and o.subname is not null -- sstomar:

Line 1223: from sys.obj$ o

1219: )
1220: )
1221: and exists
1222: ( select 1
1223: from sys.obj$ o
1224: where owner# =(select user# from sys.user$ where name = referenced_owner)
1225: and o.NAME = referenced_name
1226: and o.type# = 13
1227: and o.subname is not null

Line 1813: sys.obj$ do,

1809: cursor C_INVALIDATED_OBJECTS(P_USER varchar2) is
1810: select dep.d_obj# d_obj, do.name d_name, do.type# d_type,
1811: dep.p_obj# p_obj, po.name p_name, po.type# p_type
1812: from sys.dependency$ dep,
1813: sys.obj$ do,
1814: sys.obj$ po
1815: where do.obj# = dep.d_obj#
1816: and po.obj# = dep.p_obj#
1817: -- Only Non-Editionable objects

Line 1814: sys.obj$ po

1810: select dep.d_obj# d_obj, do.name d_name, do.type# d_type,
1811: dep.p_obj# p_obj, po.name p_name, po.type# p_type
1812: from sys.dependency$ dep,
1813: sys.obj$ do,
1814: sys.obj$ po
1815: where do.obj# = dep.d_obj#
1816: and po.obj# = dep.p_obj#
1817: -- Only Non-Editionable objects
1818: and do.type# not in (4,5,7,8,9,10,11,12,13,14,22,55,87)

Line 1820: from sys.obj$ o,

1816: and po.obj# = dep.p_obj#
1817: -- Only Non-Editionable objects
1818: and do.type# not in (4,5,7,8,9,10,11,12,13,14,22,55,87)
1819: start with dep.p_obj# in (select o.obj#
1820: from sys.obj$ o,
1821: sys.user$ u
1822: where u.name = P_USER
1823: and u.user# = o.owner#
1824: and o.type# in (4,5,7,8,9,10,11,12,13,14,22,55,87) )