SYS.DBMS_OBJECTS_APPS_UTILS dependencies on USER$

Line 54: where o.owner#=(select user# from user$ where name=schema2) and

50: -- query to get relevant type info
51: cursor c1 is
52: select o.name, o.obj#, o.oid$, t.hashcode, t.version#, o.stime
53: from obj$ o, obj$ o1, type$ t
54: where o.owner#=(select user# from user$ where name=schema2) and
55: o1.owner#=(select user# from user$ where name=schema1) and
56: o1.name= o.name and o.type#=13 and o1.type#=13 and o.oid$=t.tvoid
57: and o.subname is NULL;
58:

Line 55: o1.owner#=(select user# from user$ where name=schema1) and

51: cursor c1 is
52: select o.name, o.obj#, o.oid$, t.hashcode, t.version#, o.stime
53: from obj$ o, obj$ o1, type$ t
54: where o.owner#=(select user# from user$ where name=schema2) and
55: o1.owner#=(select user# from user$ where name=schema1) and
56: o1.name= o.name and o.type#=13 and o1.type#=13 and o.oid$=t.tvoid
57: and o.subname is NULL;
58:
59: -- query to get relevant type info if type name is given

Line 63: where o.owner#=(select user# from user$ where name=schema2) and

59: -- query to get relevant type info if type name is given
60: cursor c5 is
61: select o.name, o.obj#, o.oid$, t.hashcode, t.version#, o.stime
62: from obj$ o, obj$ o1, type$ t
63: where o.owner#=(select user# from user$ where name=schema2) and
64: o1.owner#=(select user# from user$ where name=schema1) and
65: o1.name= o.name and o.type#=13 and o1.type#=13 and o.oid$=t.tvoid
66: and o.name = typename and o.subname is NULL;
67:

Line 64: o1.owner#=(select user# from user$ where name=schema1) and

60: cursor c5 is
61: select o.name, o.obj#, o.oid$, t.hashcode, t.version#, o.stime
62: from obj$ o, obj$ o1, type$ t
63: where o.owner#=(select user# from user$ where name=schema2) and
64: o1.owner#=(select user# from user$ where name=schema1) and
65: o1.name= o.name and o.type#=13 and o1.type#=13 and o.oid$=t.tvoid
66: and o.name = typename and o.subname is NULL;
67:
68: cursor c2 is

Line 69: select user# from user$ where name=schema1;

65: o1.name= o.name and o.type#=13 and o1.type#=13 and o.oid$=t.tvoid
66: and o.name = typename and o.subname is NULL;
67:
68: cursor c2 is
69: select user# from user$ where name=schema1;
70:
71: -- hashcode sanity check query
72: cursor c3 (c3name varchar2, c3hashcode raw) is
73: select 1 from obj$ o, type$ t where o.name=c3name and o.owner#=userid and

Line 255: (select user# from user$ where name=tschema)

251: line_no number;
252:
253: cursor c1 is
254: select obj# from obj$ where name= tname and owner#=
255: (select user# from user$ where name=tschema)
256: and type#=13 and subname is null;
257:
258: cursor c2 is
259: select line, source, length(source) from source$ where obj#= obj_id;

Line 366: select 1 from sys.obj$ o,sys.type$ t1 ,sys.user$ u where o.oid$=t1.tvoid and

362: closec boolean := FALSE;
363: typname dbms_objects_utils_tname;
364:
365: cursor c1 is
366: select 1 from sys.obj$ o,sys.type$ t1 ,sys.user$ u where o.oid$=t1.tvoid and
367: o.name=typname.typname and o.subname is NULL and o.OWNER# = USER# and
368: u.name= typname.schema and substr(t1.hashcode,1,1)='2';
369:
370: begin

Line 394: name=typname.typname and owner#=(select user# from user$ where

390: numtypes := numtypes+1;
391: dbms_output.put_line('Invalidating ' || typname.schema || '.' ||
392: typname.typname);
393: update obj$ set status=6 where type#=13 and subname is null and
394: name=typname.typname and owner#=(select user# from user$ where
395: name=typname.schema);
396: end loop;
397: commit;
398: