Search Results ad_releases_s

Overview

AD_RELEASES_PVT is a private PL/SQL package body in the APPS schema that supports Oracle E-Business Suite release management metadata. Its name associates it with the AD_RELEASES and AD_RELEASES_S objects used by the Applications DBA (AD) product to register and describe application releases — the version identifiers such as 12.1.1 or 12.2.2 that are stamped against a run file system. The suffix _PVT marks the package as an internal implementation layer rather than a published API. In ETRM terms it is classified as a PVT API, meaning it is intended for consumption by other AD-owned code and not for direct customer invocation. The package provides a controlled, wrapper-style entry point for inserting or registering a release definition, shielding callers from the underlying table and sequence mechanics.

Key Procedures and Functions

• CREATERELEASE — The single documented program unit in this package body. Its purpose is to create (register) a release record within the AD release metadata, encapsulating the logic required to produce a valid row in the releases table and to obtain any sequence-derived identifier needed. Because the package is private, CREATERELEASE is expected to be called from AD-internal processing rather than from external integration code. The ETRM metadata does not publish a parameter list; parameters and their exact semantics should therefore be confirmed from the live source in the instance under review, not assumed.

Tables Accessed

• AD_RELEASES — The primary release definition table. CREATERELEASE writes to and maintains rows here, forming the authoritative list of releases known to the EBS installation.
• AD_RELEASES_S — The sequence object associated with AD_RELEASES, accessed via its APPS synonym. It supplies the surrogate key assigned to newly created release rows. Searches for "ad_releases_s" resolve to this sequence, which is why the dependency list surfaces it alongside the table.
• DUAL — Referenced through the PUBLIC synonym for the standard Oracle single-row utility, typically used to evaluate expressions or fetch sequence values within PL/SQL rather than for persistent storage.

The package also depends on the STANDARD and DBMS_STANDARD built-in packages, which is normal for any compiled PL/SQL unit. No other application tables are documented as dependencies.

Usage Notes

AD_RELEASES_PVT sits inside the AD patch and AD Utilities execution stack. It is not exposed to Oracle Forms or to standard concurrent program parameters; instead it is invoked indirectly by AD processing that needs to record release information. The ETRM metadata records that the package is referenced by two other database objects, confirming its role as a supporting module consumed by higher-level AD code. Because it is classified as a private (PVT) package, direct calls from custom code are discouraged: supported integration should prefer the documented public AD APIs, and any reliance on CREATERELEASE should be treated as unsupported and subject to change between releases. The cited behaviour applies to Oracle EBS 12.1.1 and 12.2.2; the package remains VALID in both.