Search Results g_stmt_no

Overview

OE_ADV_PRICE_PVT is a private PL/SQL package in the Oracle E-Business Suite Order Management (OE) module, owned by the APPS schema and classified as a PVT (private) API. It is not part of Oracle's public, supported API surface; instead it supports internal pricing logic invoked during order and line pricing. Its principal business function is to process advanced pricing modifiers — promotional and list modifiers, price adjustment associations, and related qualifier context — and to apply or associate the resulting adjustments against order lines during the pricing cycle.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the defining user. The package header, last shipped at version 120.2.12010000.1 (2008), declares a global statement variable (G_STMT_NO), the package name constant (G_PKG_NAME), and two seeded hold identifiers: G_SEEDED_PROM_ORDER_HOLD_ID (30) and G_SEEDED_PROM_LINE_HOLD_ID (31). The latter two constants indicate that promotion processing can place orders and order lines on hold when promotional rules are not satisfied or require review.

Key Procedures and Functions

The documented API exposes three callable units:

• CHECK_NOTIFY_OC — a Boolean function that determines whether Order Capture (OC) notification is required. It returns TRUE when notification conditions are met, and is typically consulted internally before triggering messaging or notification logic tied to pricing events.
• PROCESS_ADV_MODIFIERS — the central procedure of the package. It drives advanced pricing modifier processing for order lines during pricing. It accepts a pricing control record, an any_frozen_line flag, the line and prior-line collections, header and line identifiers, the header record, and a pricing-events string. It returns a status indicator. In practice, this routine evaluates applicable modifiers, applies qualifying adjustments, and updates the in-memory line structures consumed by the pricing engine.
• INSERT_ADJ — a procedure that inserts price adjustment records, taking a header identifier (defaulting to NULL). It is used to persist adjustment rows resulting from modifier processing into the pricing adjustment tables.

Tables Accessed

Through APPS synonyms, the package reads and writes the core Order Management and Advanced Pricing tables:

• OE_ORDER_HEADERS_ALL, OE_ORDER_LINES, OE_ORDER_LINES_ALL — order header and line data to which modifiers apply.
• OE_PRICE_ADJUSTMENTS, OE_PRICE_ADJ_ASSOCS, OE_PRICE_ADJ_ASSOCS_S, OE_PRICE_ADJ_ATTRIBS — storage of price adjustments, their associations to lines, and adjustment attributes.
• QP_LIST_HEADERS, QP_LIST_HEADERS_B, QP_LIST_HEADERS_TL, QP_EVENT_PHASES — modifier list and event-phase definitions used to qualify and sequence pricing events.
• MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_KFV — item validation and key-flex descriptions for qualifiers.
• OE_SETS, OE_MSG_REQUEST_ID_S — set and messaging sequence references.

Usage Notes

OE_ADV_PRICE_PVT is a private package and should not be called directly from custom code where a public API such as OE_ORDER_PUB or QP_* interfaces exists. It is referenced by one other package within the pricing stack. It is most commonly invoked in the Oracle Order Management pricing flow, triggered when order lines are priced through Order Entry forms, the Order Import concurrent program, or pricing-related concurrent requests. Because it operates on the pricing control and line table structures passed by the caller, any custom usage must supply compatible OE_ORDER_PRICE_PVT.Control_rec_type and oe_Order_Pub.Line_Tbl_Type structures and observe the returned status. Modifications to this package are overwritten by Oracle patches.