Search Results update_manual_modifier_flag

Overview

QP_Globals is a foundational declaration package within the Oracle Advanced Pricing (QP) module of Oracle E-Business Suite. Rather than performing transactional business logic itself, it serves as a centralized repository of constant definitions and shared utility routines used throughout the pricing engine. The package is declared with AUTHID CURRENT_USER, meaning that its unqualified references to database objects resolve through the invoker's schema and privileges rather than the definer's, which is significant for the many generated and dynamic pricing components that call into it.

The dominant purpose of QP_Globals is to publish the product entity constants and operation constants that identify pricing constructs. These constants—such as G_ENTITY_PRICE_LIST, G_ENTITY_MODIFIER_LIST, G_ENTITY_QUALIFIERS, G_ENTITY_FORMULA, G_ENTITY_LIMITS, G_ENTITY_LIMIT_ATTRS, and G_ENTITY_LIMIT_BALANCES—provide a stable, string-based vocabulary that generated code, pricing engine routines, and dependency-resolution logic rely on to avoid duplicating or overriding entity identifiers. Operation constants such as G_OPR_CREATE and G_OPR_UPDATE similarly standardize action verbs. Because these are compiled constants, consumers can reference them without runtime lookup overhead.

Key Procedures and Functions

The documented API surface consists of five procedures and functions:

• GET_ENTITIES_TBL — Populates and exposes the table of entity constants. It exists so that generator utilities and consuming packages can enumerate the valid entity identifiers programmatically, preventing generated code from inadvertently declaring conflicting or duplicate constants. Its declaration carries an explicit "DO NOT MODIFY" instruction, underscoring that it is generator-owned and expected to remain stable.
• INIT_CONTROL_REC — Initializes the package's control record, establishing default state for the shared control structure that governs behavioral flags within pricing routines.
• EQUAL — A comparison utility, presumably used to test equality of entity identifiers or control values in a consistent, null-safe manner.

The remaining structure of the package is comprised of the constant declarations themselves, which form the most heavily consumed portion of the package's public interface. These are grouped into "GEN entities" and operation blocks, with each constant mapped to a specific pricing object type.

Tables Accessed

ETRM metadata identifies a single referenced table via APPS synonyms: PLITBLM. This is a pricing-related table that the package reads in support of its control and entity initialization logic. Given the package's declarative nature, table access is minimal and generally confined to initializing the control record rather than performing transactional database work.

Usage Notes

QP_Globals is referenced by 124 other packages, making it one of the most widely depended-upon objects in the Advanced Pricing schema. It is not typically invoked directly from Oracle Forms or concurrent programs; instead it is consumed by other PL/SQL packages, generated pricing code, and pricing engine routines that require the canonical entity and operation constants. Customizations that extend or interface with Advanced Pricing should reference these constants rather than hard-coding literal strings, ensuring compatibility across patches and releases. Because GET_ENTITIES_TBL is marked "DO NOT MODIFY," developers should treat the entity constant set as read-only and avoid redefining its values in custom code.