Search Results qp_internal_11510_j

Overview

QP_JPE_CTRL_PVT is a control-level PL/SQL package in the APPS schema belonging to the Oracle Advanced Pricing (QP) module. The suffix _PVT identifies the package as a private, internal API, meaning it is not intended for direct invocation by external or customer code but is instead called by other Oracle E-Business Suite components—most notably the Java Pricing Engine (JPE) integration layer. Its primary purpose is to manage the runtime control of pricing engine behavior, including cache statistics handling and attribute group configuration used during pricing calculations.

The package resides at the boundary between the PL/SQL pricing infrastructure and the JPE (Java Pricing Engine) processing model, introduced to offload pricing computation to the middle tier in Release 12. It is registered as VALID in 12.1.1 and 12.2.2, and its dependency list is deliberately narrow: it references only SYS.STANDARD in the ETRM metadata, indicating a lightweight, low-coupling control package that primarily coordinates state rather than performing heavy business logic.

Key Procedures and Functions

The ETRM metadata documents a single procedure:

• SWITCH — A control procedure that toggles or selects an operational mode within the pricing engine context. Its role is to switch a runtime flag or configuration state, most plausibly enabling or disabling the Java Pricing Engine path or switching between cached and non-cached pricing behavior. Because the package is classified as PVT and referenced by no other APPS packages, SWITCH is invoked internally by the JPE integration rather than through a public API contract.

No function definitions are documented, and no parameter lists are published in the ETRM record. Per Oracle's private API convention, the signature is subject to change between patch levels and should not be relied upon in customizations.

Tables Accessed

Three APPS synonyms are documented as referenced by this package:

• QP_ATTRIBUTE_GROUPS — Stores groupings of pricing attributes used to organize qualifier and modifier contexts. SWITCH likely consults or updates this table to drive which attribute group set the engine uses at runtime.
• QP_CACHE_STATS — Holds pricing cache performance statistics. The control package records or resets counters here, supporting the cache monitoring that the JPE relies on to decide when to refresh cached pricing data.
• QP_PATTERNS — Contains pricing pattern definitions used for pattern-based search and context matching. Access is for reading the active pattern configuration governing engine control flow.

Usage Notes

QP_JPE_CTRL_PVT is not exposed through Oracle Forms or concurrent programs and appears in the ETRM dependency graph with zero referencing packages, confirming it is invoked from outside the PL/SQL package layer—typically from the JPE servlet/JSP tier through the Oracle Pricing Engine integration. Administrators rarely interact with it directly; behavior changes surface through Advanced Pricing diagnostics (for example, cache statistics reports) rather than through this package's own interface.

Custom developers should treat QP_JPE_CTRL_PVT as private. Direct calls risk breakage on patching, since the SWITCH procedure's signature is undocumented and unsupported. Where control of pricing engine behavior is required, supported public APIs and profile options should be used instead. This package should be referenced only for diagnostic or dependency-analysis purposes.