Search Results lock_limits

Overview

QP_LIMITS_PVT is a private PL/SQL package in the APPS schema that supports Oracle Advanced Pricing limit functionality within Oracle E-Business Suite releases 12.1.1 and 12.2.2. The package operates as an internal implementation layer behind the public API QP_LIMITS_PUB, which is the documented interface that external callers are expected to use. In Oracle's API architecture, the PVT (private) designation indicates that the package contains business logic intended for consumption by the corresponding public wrapper rather than by custom code directly.

The business purpose of the package is the enforcement and management of pricing limits — controls that constrain the quantities, amounts, or values that can be applied or accrued against pricing entities, and that are tracked as balances over time. These limits form part of the pricing and promotion governance framework, ensuring that contractual or promotional boundaries are respected during order capture and pricing evaluation.

Key Procedures and Functions

The ETRM metadata documents three program units within QP_LIMITS_PVT:

• PROCESS_LIMITS — Performs the core logic for evaluating and applying limits. It is the central routine through which limit checks and limit balance updates are executed on behalf of the public API layer.
• LOCK_LIMITS — Manages locking semantics for limit records, ensuring that concurrent pricing activity does not corrupt limit balances. Locking is essential where multiple pricing sessions may otherwise update the same limit concurrently in a multi-user environment.
• GET_LIMITS — Retrieves limit definitions or limit-related data for a given pricing context, returning the information required for evaluation and display.

The metadata does not publish formal parameter lists, and specific arguments should not be assumed. The package depends on FND_API (the standard Oracle Application Object Library API utility package), QP_GLOBALS (shared pricing globals), and QP_LIMITS_PUB.

Tables Accessed

The documented table reference via APPS synonyms is PLITBLM. This is the pricing limits balance table used to store and maintain limit balances associated with pricing entities. QP_LIMITS_PVT reads from and writes to this table when limits are evaluated and consumed; PROCESS_LIMITS and LOCK_LIMITS are the routines most directly associated with modifying limit balance records, while GET_LIMITS supports retrieval of limit data.

Usage Notes

QP_LIMITS_PVT should not be invoked directly from custom code. It is referenced by QP_LIMITS_PUB, which is the supported public entry point, and by the Oracle Forms objects QP_QP_FORM_LIMITS, QP_QP_FORM_LIMIT_ATTRS, and QP_QP_FORM_LIMIT_BALANCES through which limit setup and limit balance maintenance are performed in the Pricing Manager responsibility.

Because the package is a private implementation unit, its signature may change between releases without notice, and it is not part of Oracle's documented extension API. Developers requiring limit processing in customizations or concurrent programs should call QP_LIMITS_PUB instead of QP_LIMITS_PVT. The dependency on FND_API further indicates that the package follows standard EBS API conventions, including consistent error handling and message propagation, which callers should observe through the public wrapper.