SYS.VALIDATE_ORDIM dependencies on DBMS_REGISTRY

Line 426: l_sdo_status := dbms_registry.status('SDO');

422:
423: -- Check whether Locator is valid if SDO is not installed or is OPTION OFF
424: -- by checking whether there are invalid objects under MDSYS
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

Line 467: l_status := sys.dbms_registry.status('ORDIM');

463: begin
464: select prv_version into l_prevDbVer
465: from sys.registry$ where cid='ORDIM';
466:
467: l_status := sys.dbms_registry.status('ORDIM');
468:
469: if (l_prevDbVer = '11.1.0') and (l_status = 'UPGRADED') then
470: begin
471: -- Dynamic sql is used for compilation purposes because the

Line 545: b_upgradeMode := sys.dbms_registry.is_in_upgrade_mode();

541:
542: --
543: -- Finally, if in upgrade mode, check if there are errors in registry$error
544: --
545: b_upgradeMode := sys.dbms_registry.is_in_upgrade_mode();
546: if b_upgradeMode then
547: l_num_errors := sys.dbms_registry.count_errors_in_registry('ORDIM');
548: if (l_num_errors > 0) then
549: dbms_output.put_line

Line 547: l_num_errors := sys.dbms_registry.count_errors_in_registry('ORDIM');

543: -- Finally, if in upgrade mode, check if there are errors in registry$error
544: --
545: b_upgradeMode := sys.dbms_registry.is_in_upgrade_mode();
546: if b_upgradeMode then
547: l_num_errors := sys.dbms_registry.count_errors_in_registry('ORDIM');
548: if (l_num_errors > 0) then
549: dbms_output.put_line
550: ('There were ' || l_num_errors ||
551: ' entries in sys.registry$error for ORDIM');

Line 560: sys.dbms_registry.invalid('ORDIM');

556: --
557: -- Set the registry status at the end
558: --
559: if NOT b_valid then
560: sys.dbms_registry.invalid('ORDIM');
561: else
562: sys.dbms_registry.valid('ORDIM');
563: end if;
564:

Line 562: sys.dbms_registry.valid('ORDIM');

558: --
559: if NOT b_valid then
560: sys.dbms_registry.invalid('ORDIM');
561: else
562: sys.dbms_registry.valid('ORDIM');
563: end if;
564:
565: END;