SYS.VALIDATE_ODM dependencies on ALL_OBJECTS

Line 7: select count(*) into v_count from all_objects where owner = 'DMSYS' and status = 'INVALID';

3: v_count NUMBER;
4: v_schema varchar2(30);
5: BEGIN
6: select username into v_schema from all_users where username = 'DMSYS';
7: select count(*) into v_count from all_objects where owner = 'DMSYS' and status = 'INVALID';
8: IF v_schema = 'DMSYS' and v_count = 0
9: THEN
10: sys.dbms_registry.valid('ODM');
11: ELSE