Search Results get_code_release_level

Overview

QP_CODE_CONTROL is a utility package in the Oracle Advanced Pricing (QP) module of Oracle E-Business Suite. Its documented body is deliberately minimal, consisting of a single public function that returns the release level of the pricing code base in use. The package belongs to the APPS schema and is classified under the generic "OTHER" API category in the ETRM repository. In EBS releases 12.1.1 and 12.2.2 the object persists unchanged; the embedded header comment records a version of 120.0 dated 2005, reflecting the stability of the pricing foundation layer across the 11i-to-R12 upgrade path. Because Advanced Pricing underpins list prices, modifier hierarchies, qualifiers, and pricing engine execution, downstream components occasionally need to confirm which release of the pricing code they are executing against. QP_CODE_CONTROL provides that single authoritative answer without requiring callers to inspect tables or query FND dictionaries directly.

Key Procedures and Functions

• GET_CODE_RELEASE_LEVEL — Returns a VARCHAR2 value representing the release level of the QP code base. The function body simply returns the package-level constant QP_CODE_CONTROL.CODE_RELEASE_LEVEL, so the call is a lightweight in-memory lookup with no database access, no SQL parsing, and no exception handling. It is callable from SQL, PL/SQL, and client-side code, making it a convenient probe for conditional logic that depends on the installed pricing release.

The package exposes no procedures and no other functions. There is no initialization section, no private helper, and no state beyond the constant it returns. Its entire functional surface is the one documented function.

Tables Accessed

No tables are accessed. The ETRM metadata lists no table references through APPS synonyms, and the source confirms that the sole function returns a package constant rather than querying any data. This distinguishes QP_CODE_CONTROL from the bulk of QP packages, which read and write pricing entities such as QP_LIST_HEADERS, QP_LIST_LINES, QP_QUALIFIERS, and QP_PRICING_ATTRIBUTES. The absence of table dependencies means the package cannot fail on missing grants, invalid synonyms, or data-related exceptions; it is effectively a compile-time constant exposed through a callable interface.

Usage Notes

GET_CODE_RELEASE_LEVEL is typically invoked by other PL/SQL programs rather than by end users directly. The ETRM repository records that the package is referenced by ten other packages, indicating that pricing engine components, validation routines, or upgrade scripts call it to determine behavioral branches keyed to the pricing code release. Typical call sites include pricing engine setup validation, diagnostic or health-check routines, and custom extensions that must behave differently across 11i, 12.1.1, and 12.2.2. There is no documented concurrent program or Oracle Forms trigger that calls it as a primary entry point, and it is not intended for direct invocation from the EBS user interface. Customizations should treat the function as read-only and side-effect free: it is safe to call repeatedly, inside loops, or from SQL statements. Because the returned string is a release identifier rather than a business value, developers should not persist it as transaction data, but may log it for support diagnostics or use it to gate version-specific code paths. No formal API documentation, error codes, or parameter contracts accompany the function, so callers should rely solely on the documented return type and the constant semantics described above.