DBA Data[Home] [Help]

SYS.DBMS_OBJECTS_APPS_UTILS dependencies on DBMS_OBJECTS_UTILS_TINFO

Line 42: ltinfo dbms_objects_utils_tinfo;

38: lversion number;
39: lstime date;
40: i number;
41: numtypes number;
42: ltinfo dbms_objects_utils_tinfo;
43: j number;
44: allgood int := 0;
45:
46: type tabtinfo is table of dbms_objects_utils_tinfo index by binary_integer;

Line 46: type tabtinfo is table of dbms_objects_utils_tinfo index by binary_integer;

42: ltinfo dbms_objects_utils_tinfo;
43: j number;
44: allgood int := 0;
45:
46: type tabtinfo is table of dbms_objects_utils_tinfo index by binary_integer;
47:
48: vtabtinfo tabtinfo;
49:
50: -- query to get relevant type info

Line 98: vtabtinfo(i) := dbms_objects_utils_tinfo(lname, lobjid, ltoid, lhashcode, lversion, lstime);

94: open c1;
95: loop
96: fetch c1 into lname, lobjid, ltoid, lhashcode, lversion, lstime;
97: exit when c1%notfound;
98: vtabtinfo(i) := dbms_objects_utils_tinfo(lname, lobjid, ltoid, lhashcode, lversion, lstime);
99: i := i + 1;
100: end loop;
101: close c1;
102: numtypes := i-1;

Line 108: vtabtinfo(i) := dbms_objects_utils_tinfo(lname, lobjid, ltoid, lhashcode, lversion, lstime);

104: open c5;
105: loop
106: fetch c5 into lname, lobjid, ltoid, lhashcode, lversion, lstime;
107: exit when c5%notfound;
108: vtabtinfo(i) := dbms_objects_utils_tinfo(lname, lobjid, ltoid, lhashcode, lversion, lstime);
109: i := i + 1;
110: end loop;
111: close c5;
112: numtypes := i-1;