Search Results dbms_objects_utils_tsource

Overview

SYS.DBMS_OBJECTS_APPS_UTILS is an Oracle-supplied PL/SQL package body that resides in the SYS schema and carries VALID status in Oracle E-Business Suite 12.1.1 and 12.2.2. It is part of the internal dictionary-management infrastructure rather than an application-facing API. Its business function is to support the maintenance, migration, and recompilation of Oracle object types and their associated metadata within the EBS database. In practical terms, the package provides the utility layer that EBS and database upgrade routines rely on when object type definitions, type source text, and type dependency information must be refreshed after patches, migrations, or structural changes.

The name follows the DBMS_OBJECTS_* family convention, indicating that it wraps and orchestrates lower-level type utilities such as UTL_OBJECTS_LIB and UTL_RECOMP. Because dependency metadata shows the package body references dictionary objects including OBJ$, TYPE$, SOURCE$, DEPENDENCY$, COLTYPE$, and SUBCOLTYPE$, it operates directly against the data dictionary rather than through EBS application synonyms. The package is documented with an API classification of OTHER and is referenced by one other package, confirming its role as an internal helper rather than a publicly composed interface.

Key Procedures and Functions

The ETRM metadata documents five procedures and functions within this package body:

• UPDATE_TYPES — Refreshes object type definitions to bring stored type metadata into alignment with current dictionary state. This is typically used during upgrade and patch cycles where type definitions must be synchronized.
• SPLIT_SOURCE — Processes stored type source text, splitting source lines for structured handling and downstream recompilation. This aligns with the DBMS_OBJECTS_UTILS_TSOURCE type referenced in the dependency list and matches the user's search term dbms_objects_utils_tsource.
• RECOMPILE_TYPES — Recompiles object types determined to be invalid or stale, restoring them to a valid state. This is a core maintenance routine for EBS environments that depend heavily on user-defined types.
• OWNER_MIGRATE_UPDATE_TDO — Updates type descriptor objects (TDOs) during owner migration operations, ensuring descriptor metadata follows the correct owner after schema-level changes.
• OWNER_MIGRATE_UPDATE_HASHCODE — Recomputes and updates hash codes associated with migrated type objects, maintaining integrity checks used by the type system to detect change.

No parameter lists are documented in the ETRM excerpt; therefore parameters are not enumerated here.

Tables Accessed

Consistent with the dependency information, the package reads and writes dictionary base tables including OBJ$, TYPE$, SOURCE$, DEPENDENCY$, COLTYPE$, and SUBCOLTYPE$. These are the underlying tables that store object definitions, type attributes, source text, and dependency relationships. The package also relies on internal types such as DBMS_OBJECTS_UTILS_TINFO, DBMS_OBJECTS_UTILS_TNAME, DBMS_OBJECTS_UTILS_TNAMEARR, DBMS_OBJECTS_UTILS_TSELEM, and DBMS_OBJECTS_UTILS_TSOURCE to structure in-memory processing of type information. No APPS synonyms are documented as referenced tables.

Usage Notes

This package is an internal SYS utility and is not intended for direct invocation by end users or typical customizations. It is normally executed indirectly by database upgrade scripts, EBS patching infrastructure (such as AutoPatch and AD utilities), and recompilation routines that call UTL_RECOMP. It may also be invoked by the one dependent package that references it. Because it manipulates data dictionary tables directly, direct custom calls are strongly discouraged. Administrators should treat DBMS_OBJECTS_APPS_UTILS as part of the EBS dictionary-maintenance layer, invoked automatically during upgrade or recompilation activities rather than from forms or concurrent programs.