SYS.DBMS_OBJECTS_APPS_UTILS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 30

procedure update_types (schema1 varchar2, schema2 varchar2,
typename varchar2, check_update boolean) is

userid number;

Line: 52

select o.name, o.obj#, o.oid$, t.hashcode, t.version#, o.stime
from obj$ o, obj$ o1, type$ t
where o.owner#=(select user# from user$ where name=schema2) and
o1.owner#=(select user# from user$ where name=schema1) and
o1.name= o.name and o.type#=13 and o1.type#=13 and o.oid$=t.tvoid
and o.subname is NULL;

Line: 61

select o.name, o.obj#, o.oid$, t.hashcode, t.version#, o.stime
from obj$ o, obj$ o1, type$ t
where o.owner#=(select user# from user$ where name=schema2) and
o1.owner#=(select user# from user$ where name=schema1) and
o1.name= o.name and o.type#=13 and o1.type#=13 and o.oid$=t.tvoid
and o.name = typename and o.subname is NULL;

Line: 69

select user# from user$ where name=schema1;

Line: 73

select 1 from obj$ o, type$ t where o.name=c3name and o.owner#=userid and
t.tvoid=o.oid$ and t.hashcode = c3hashcode and o.subname is NULL;

Line: 78

select 1 from obj$ o, type$ t where o.name=c3name and o.owner#=userid and
t.tvoid=o.oid$ and t.version# = c3version and o.subname is NULL;

Line: 84

select 1 from dependency$ d, obj$ o where o.type#=2 and o.obj#=d.d_obj# and
d.p_obj# in (select obj# from obj$ where type#=13 and subname is null and
owner#=userid);

Line: 155

  update coltype$ set toid=ltinfo.toid where toid=(select oid$ from
  obj$ where name=ltinfo.name and owner#=userid and type#=13 and subname is NULL);

Line: 158

  update subcoltype$ set toid=ltinfo.toid where toid=(select oid$ from
  obj$ where name=ltinfo.name and owner#=userid and type#=13 and subname is NULL);

Line: 161

  update dependency$ set p_obj#=ltinfo.objid, p_timestamp=ltinfo.stime
  where p_obj#=(select obj# from obj$ where name=ltinfo.name and
        owner#=userid and type#=13 and subname is NULL)
  and d_obj# in (select obj# from obj$ where type#=2);

Line: 169

if (check_update = TRUE) then
  open c6;

Line: 208

  schema1 || ' updated');

Line: 218

end; /* end of procedure update types */

Line: 254

select obj# from obj$ where name= tname and owner#=
(select user# from user$ where name=tschema)
and type#=13 and subname is null;

Line: 259

select line, source, length(source) from source$ where obj#= obj_id;

Line: 262

select obj# from obj$ o, type$ t where t.version#=i and o.name=tname and
o.oid$=t.tvoid and o.type#=13;

Line: 277

  select count(*) into total_lines 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
o.name=typname.typname and o.subname is NULL and o.OWNER# = USER# and
u.name= typname.schema and substr(t1.hashcode,1,1)='2';

Line: 393

  update obj$ set status=6 where type#=13 and subname is null and
  name=typname.typname and owner#=(select user# from user$ where
  name=typname.schema);

Line: 424

PROCEDURE owner_migrate_update_tdo
 (toid raw, new_owner varchar2) IS
LANGUAGE C
NAME "OWNER_MIGRATE_TDO"
LIBRARY UTL_OBJECTS_LIB
parameters(toid OCIRaw, new_owner String);

Line: 432

FUNCTION owner_migrate_update_hashcode
(toid raw)
return raw IS
LANGUAGE C
NAME "OWNER_MIGRATE_HC"
LIBRARY UTL_OBJECTS_LIB
parameters(toid OCIRaw,
return OCIRaw);