Search Results get_code_level




Overview
Explore in AI Chat

Overview

AD_TRACKABLE_ENTITIES_PKG is an Oracle Applications (APPS) schema PL/SQL package that manages the metadata registry of trackable entities within the Oracle E-Business Suite environment. A trackable entity represents a business or application object whose changes and code levels can be monitored and controlled as part of the Application Object Library (AD) infrastructure — for example, during patching, upgrade, or conforming operations across the EBS technology stack. The package provides a programmatic API to create trackable entities, validate their names and levels, and interrogate or modify the operational state (code level, used status, and load status) of each entity. It is classified as an OTHER API in the ETRM 12.2.2 metadata, meaning it is an internal supporting package rather than a public, end-user-facing API. The registry managed by this package underpins the AD utilities that determine which object versions are installed and active on a given EBS instance. The package operates strictly against the AD_TRACKABLE_ENTITIES table through the APPS synonym.

Key Procedures and Functions

The package exposes eleven documented procedures, organized around validation, creation, and paired getter/setter operations:

  • VALIDATE_NAME — Validates that a supplied trackable entity name conforms to the accepted naming conventions before it is created or referenced.
  • VALIDATE_LEVEL — Validates a supplied code level value to ensure it matches an acceptable format or value set.
  • CREATE_TE — Creates a new trackable entity record, accepting the entity name, description, and type, and returning a status indicator.
  • GET_CODE_LEVEL — Retrieves the current code level and baseline for a named trackable entity, returning both values along with a status. This is the procedure sought by the get_code_level search.
  • SET_CODE_LEVEL — Sets the code level and baseline for a named trackable entity and returns a status.
  • GET_USED_STATUS — Returns the used status of a trackable entity together with its level, baseline, and status.
  • SET_USED_STATUS — Updates the used status of a named trackable entity.
  • GET_LOAD_STATUS — Returns the load status of a trackable entity along with its level, baseline, and status.
  • SET_LOAD_STATUS — Updates the load status of a named trackable entity.
  • GET_TE_INFO — Retrieves descriptive information (such as description and type) for a named trackable entity.
  • SET_TE_INFO — Updates descriptive information for a named trackable entity.

Tables Accessed

The package reads and writes the AD_TRACKABLE_ENTITIES table, referenced through the APPS synonym. This table stores the master list of trackable entities along with their descriptive attributes (name, description, type) and their state attributes (code level, baseline, used status, and load status). All getter procedures query this table, all setter procedures update it, and CREATE_TE inserts new rows. No other tables are documented as being accessed directly by this package.

Usage Notes

AD_TRACKABLE_ENTITIES_PKG is typically invoked by AD patching and upgrade utilities, and by administrative forms or concurrent programs that display or modify trackable entity state. It is also referenced by one other package within the APPS schema, indicating it functions as a lower-level utility supporting higher-level AD logic. Custom code should call the getter procedures (such as GET_CODE_LEVEL) for read-only interrogation and use the setter procedures sparingly, since corrupting code level, load, or used status values can disrupt patching and upgrade operations. Because the package is documented as an OTHER classification and originated from internal AD source (adcodlins.pls), it should be treated as an internal API that may change without the notice afforded to public APIs. Direct DML against AD_TRACKABLE_ENTITIES should be avoided in favor of these procedures to preserve status consistency.