SYS.VALIDATE_ORDIM dependencies on DBA_INVALID_OBJECTS

Line 175: SELECT NULL INTO l_null FROM sys.dba_invalid_objects

171:
172:
173: -- Now check whether there are invalid objects
174: BEGIN
175: SELECT NULL INTO l_null FROM sys.dba_invalid_objects
176: WHERE
177: (owner = 'ORDSYS'
178: OR owner = 'ORDPLUGINS'
179: OR owner = 'SI_INFORMTN_SCHEMA'

Line 187: FROM sys.dba_invalid_objects o

183: -- invalid objects found
184: b_valid := FALSE;
185:
186: FOR ob IN (SELECT o.object_name, o.status, o.object_type
187: FROM sys.dba_invalid_objects o
188: WHERE
189: (o.owner = 'ORDSYS'
190: OR o.owner = 'ORDPLUGINS'
191: OR o.owner = 'SI_INFORMTN_SCHEMA'

Line 429: SELECT NULL INTO l_null FROM sys.dba_invalid_objects

425: BEGIN
426: l_sdo_status := dbms_registry.status('SDO');
427: if (l_sdo_status is NULL or l_sdo_status = 'OPTION OFF' or
428: l_sdo_status = 'REMOVED') then
429: SELECT NULL INTO l_null FROM sys.dba_invalid_objects
430: WHERE
431: owner = 'MDSYS'
432: AND rownum <= 1;
433:

Line 438: FROM sys.dba_invalid_objects o

434: -- invalid objects found
435: b_valid := FALSE;
436:
437: FOR ob IN (SELECT o.object_name, o.status, o.object_type
438: FROM sys.dba_invalid_objects o
439: WHERE
440: o.owner = 'MDSYS'
441: AND rownum < 20) LOOP
442: dbms_output.put_line ('Locator INVALID OBJECTS: ' || ob.object_name || ' - ' || ob.status || ' - ' || ob.object_type);