SYS.DBMS_OBJECTS_APPS_UTILS dependencies on SUBCOLTYPE$

Line 148: -- 2. update the toid value in subcoltype$

144: end loop;
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

Line 157: -- subcoltype$ update

153: ltinfo := vtabtinfo(i);
154: -- coltype$ update
155: update coltype$ set toid=ltinfo.toid where toid=(select oid$ from
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

Line 158: update subcoltype$ set toid=ltinfo.toid where toid=(select oid$ from

154: -- coltype$ update
155: update coltype$ set toid=ltinfo.toid where toid=(select oid$ from
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