Search Results set_te_info




Overview
Explore in AI Chat

Overview

AD_TRACKABLE_ENTITIES_PKG is a server-side PL/SQL package in the APPS schema that maintains the AD_TRACKABLE_ENTITIES repository table, the data dictionary structure that records the tracking entities used by Oracle E-Business Suite's patching and code-level validation infrastructure. Trackable entities represent units such as products, files, and code objects whose baseline and code level must be monitored across the application technology stack. The package body exposes a small, coherent set of procedures that together implement a full lifecycle for these entities: name and level validation, creation, retrieval of code-level information, and update of code-level, used, and load status attributes. In EBS 12.1.1 and 12.2.2, the package is classified as a "private" API utility (API classification: OTHER), meaning it is intended primarily for internal use by the patching and AD (Application DBA) utilities rather than as a supported public interface for customer extensions. It is referenced by one other package, and the 120.3 version header indicates that it has remained stable since 2006, confirming its role as a mature infrastructure component.

Key Procedures and Functions

The package body documents eleven procedures, several of which are lightweight validators or accessors. The core procedures are:

  • VALIDATE_NAME — Accepts a trackable entity name and performs name validation/normalization before use in other operations.
  • VALIDATE_LEVEL — Accepts a level value and validates it for use in code-level and baseline operations.
  • CREATE_TE — Inserts a new row into AD_TRACKABLE_ENTITIES, setting abbreviation, description, type, and initializing baseline and codelevel to '0' and the used/load flags to 'F'. It calls VALIDATE_NAME on both the entity name and the type, issues a COMMIT, and returns a status of 'TRUE' on success or 'FALSE' on failure.
  • GET_CODE_LEVEL — Retrieves the baseline and codelevel values for a named trackable entity from AD_TRACKABLE_ENTITIES, returning both through OUT parameters and a status indicator; raises NO_DATA_FOUND handling to set status 'FALSE'.
  • SET_CODE_LEVEL — Updates the codelevel and baseline values for a named entity, validating both the name and level inputs before the update.
  • GET_USED_STATUS / SET_USED_STATUS — Read and write the used_flag attribute, which indicates whether a trackable entity has been used.
  • GET_LOAD_STATUS / SET_LOAD_STATUS — Read and write the load_flag attribute, indicating whether the entity has been loaded.
  • GET_TE_INFO / SET_TE_INFO — General-purpose accessors for retrieving and updating full trackable entity records.

Tables Accessed

The package operates exclusively on AD_TRACKABLE_ENTITIES, accessed through an APPS synonym. This table stores the abbreviation, name, type, baseline, codelevel, used_flag, and load_flag columns referenced by the procedures. CREATE_TE inserts rows; GET_CODE_LEVEL selects baseline and codelevel; SET_CODE_LEVEL, SET_USED_STATUS, SET_LOAD_STATUS, and SET_TE_INFO update rows. No other application tables are touched by the documented code.

Usage Notes

AD_TRACKABLE_ENTITIES_PKG is invoked by the AD patching and code-level validation infrastructure during patch application, upgrade, and AD administration operations. It is not exposed through a standard Oracle Forms UI; instead it is called programmatically by other packages (one documented dependent) and potentially from custom concurrent programs. Because the package is classified as OTHER and its parameters are largely untyped string validators, custom code should call it only when replicating standard patching behavior, and must respect the package's COMMIT semantics (CREATE_TE commits internally) and its status-based error reporting convention, where x_status values of 'TRUE'/'FALSE' accompany raised exceptions rather than replacing them.