SYS.DBMS_OBJECTS_APPS_UTILS dependencies on DEPENDENCY$

Line 84: select 1 from dependency$ d, obj$ o where o.type#=2 and o.obj#=d.d_obj# and

80:
81: -- sanity check to make sure that none of the tables are now dependent on
82: -- schema1
83: cursor c6 is
84: select 1 from dependency$ d, obj$ o where o.type#=2 and o.obj#=d.d_obj# and
85: d.p_obj# in (select obj# from obj$ where type#=13 and subname is null and
86: owner#=userid);
87:
88: begin

Line 149: -- 3. update the p_obj# and p_timestamp in dependency$ for the type,

145:
146: -- ok, we are ready to update the metadata. We do 3 updates
147: -- 1. update the toid value in coltype$
148: -- 2. update the toid value in subcoltype$
149: -- 3. update the p_obj# and p_timestamp in dependency$ for the type,
150: -- for all table dependents
151: allgood := 1;
152: for i in 1..numtypes loop
153: ltinfo := vtabtinfo(i);

Line 160: -- dependency$ update

156: obj$ where name=ltinfo.name and owner#=userid and type#=13 and subname is NULL);
157: -- subcoltype$ update
158: update subcoltype$ set toid=ltinfo.toid where toid=(select oid$ from
159: obj$ where name=ltinfo.name and owner#=userid and type#=13 and subname is NULL);
160: -- dependency$ update
161: update dependency$ set p_obj#=ltinfo.objid, p_timestamp=ltinfo.stime
162: where p_obj#=(select obj# from obj$ where name=ltinfo.name and
163: owner#=userid and type#=13 and subname is NULL)
164: and d_obj# in (select obj# from obj$ where type#=2);

Line 161: update dependency$ set p_obj#=ltinfo.objid, p_timestamp=ltinfo.stime

157: -- subcoltype$ update
158: update subcoltype$ set toid=ltinfo.toid where toid=(select oid$ from
159: obj$ where name=ltinfo.name and owner#=userid and type#=13 and subname is NULL);
160: -- dependency$ update
161: update dependency$ set p_obj#=ltinfo.objid, p_timestamp=ltinfo.stime
162: where p_obj#=(select obj# from obj$ where name=ltinfo.name and
163: owner#=userid and type#=13 and subname is NULL)
164: and d_obj# in (select obj# from obj$ where type#=2);
165: end loop;