Search Results qp_globals




Overview
Explore in AI Chat

Overview

QP_GLOBALS is a foundational PL/SQL package body owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. Its purpose is to centralize shared state, utility logic, and control-record management for the Oracle Advanced Pricing (QP) module. Rather than duplicating common declarations and helper routines across the pricing engine, modifier processing, qualifier evaluation, and list-line APIs, the QP suite depends on QP_GLOBALS as a single point of reference. The package body is documented with a status of VALID and is classified under the ETRM as API classification OTHER, indicating it is an internal utility rather than a published integration interface. Its broad footprint within the pricing architecture is evidenced by the fact that it is referenced by 124 other database objects, making it one of the more heavily reused components in the QP schema family.

Key Procedures and Functions

The documented interface comprises five procedures and functions. Their names indicate the following responsibilities:

  • GET_ENTITIES_TBL — Returns a collection of entity definitions used during pricing processing, allowing callers to obtain the set of entities that QP routines iterate over.
  • INIT_CONTROL_REC — Initializes the control record structure that governs execution context and state for pricing operations.
  • EQUAL — Provides a comparison routine, most likely used to evaluate equality between control-record or entity values.

Though the excerpt names five documented members in total, the three above are the explicitly listed ones. These routines are internal helpers; they are not intended to be called by external integrators without understanding the surrounding QP execution model.

Tables Accessed

The only documented table referenced through APPS synonyms is PLITBLM, an Oracle Applications internal table used for PL/SQL index table or temporary storage purposes. QP_GLOBALS reads and writes PLITBLM indirectly as part of its shared-state management, rather than for storing business pricing data such as price lists or modifiers. Core pricing business tables are accessed by higher-level QP packages that in turn depend on QP_GLOBALS for their utility and control logic.

Usage Notes

QP_GLOBALS is an internal dependency, not a public API. It references FND_API, OE_MSG_PUB, and STANDARD, which places it at the intersection of the Applications framework, order-management messaging, and standard PL/SQL support routines. The ETRM notes that QP_GLOBALS is not referenced by any database object externally, yet it is referenced by 124 other packages, confirming that its consumers are all within the Oracle pricing and order-capture stack. It is typically invoked during form-based price list maintenance, order entry pricing calls, modifier qualification, and concurrent pricing programs that require shared control state. Custom code should avoid direct invocation and instead use supported public QP APIs, since internal signatures and behavior may change across patches and point releases.