Search Results calculate_adjustments

Overview

OE_ORDER_ADJ_PVT is a private PL/SQL package in the APPS schema that encapsulates the pricing and adjustment logic used by Oracle Order Management. Its name reflects its role as a "private" API: it is not intended for direct invocation by external or customer-developed code, but is called internally by public APIs, pricing utilities, and the Order Management forms. The package is responsible for building, calculating, and persisting price adjustment records against order headers and lines, applying list prices, modifiers, promotions, and manual adjustments during the order pricing cycle. In the context of the search term "oe_line_adj_util," OE_ORDER_ADJ_PVT is significant because OE_LINE_ADJ_UTIL is one of the package's documented callers, meaning the line-level adjustment utility relies on OE_ORDER_ADJ_PVT to perform the actual adjustment work.

Key Procedures and Functions

The documented interface exposes twenty-five procedures and functions organized around retrieval, calculation, and persistence of adjustments and their associated attributes.

• HEADER_ADJS, LINE_ADJS — Retrieve the set of price adjustments applicable at the order header and order line level respectively.
• HEADER_PRICE_ATTS, LINE_PRICE_ATTS — Return the pricing attributes (qualifiers such as item, customer, or promotion context) used to evaluate header-level and line-level adjustments.
• HEADER_ADJ_ATTS, LINE_ADJ_ATTS — Provide the attribute values associated with adjustments at the header and line levels.
• HEADER_ADJ_ASSOCS, LINE_ADJ_ASSOCS — Return the association records that link price adjustments to specific headers or lines.
• CALCULATE_ADJUSTMENTS, PROCESS_ADJUSTMENTS — Perform the core logic: determining which adjustments apply and computing their effect on order pricing.
• PRICE_LINE, PRICE_ADJUSTMENTS, PRICE_ACTION — Drive the pricing engine for a line, applying adjustments and orchestrating pricing actions.
• GET_QUOTE — Retrieves quotation-related pricing information.
• CREATE_MANUAL_ADJUSTMENTS, GET_MANUAL_ADJUSTMENTS — Handle user-entered or manual price adjustments and retrieve them for display or reprocessing.
• PROMOTION_PUT_HOLD — Applies holds associated with promotions, writing to hold tables.
• INSERT_ADJ_ASSOCS, INSERT_ADJ_ATTS — Persist adjustment association and attribute records.
• COPY_HEADER_TO_REQUEST — Copies header data into the pricing request structures for evaluation.

Tables Accessed

The package reads and writes the principal Order Management pricing tables. OE_ORDER_HEADERS, OE_ORDER_HEADERS_ALL, OE_ORDER_LINES, and OE_ORDER_LINES_ALL hold the header and line records against which adjustments are applied. OE_PRICE_ADJUSTMENTS and OE_PRICE_ADJUSTMENTS_S store the adjustment definitions and their translated values, while OE_PRICE_ADJ_ASSOCS links adjustments to the entities they qualify. OE_ORDER_PRICE_ATTRIBS and OE_ORDER_PRICE_ATTRIBS_S hold the pricing attribute context for the order. OE_HOLD_SOURCES, OE_ORDER_HOLDS, and OE_HOLD_RELEASES support promotion-driven holds. MTL_SYSTEM_ITEMS_KFV is consulted for item descriptive information, and OE_BLANKET_LINES_EXT and OE_MSG_REQUEST_ID_S support blanket pricing and request identification.

Usage Notes

OE_ORDER_ADJ_PVT is referenced by nineteen other packages, including OE_LINE_ADJ_UTIL, OE_ADV_PRICE_PVT, OE_BATCH_PRICING, OE_BULK_PRICE_PVT, OE_ORDER_PRICE_PVT, OE_RETROBILL_PVT, and the Order Management forms interfaces such as OE_OE_FORM_LINE_ADJ and OE_OE_FORM_HEADER_ADJ. It depends on FND_API, FND_PROFILE, OE_GLOBALS, OE_ORDER_PUB, and QP_ATTR_MAPPING_PUB, indicating that it participates in the standard API error-handling and attribute-mapping frameworks. Custom code should not call this private package directly; instead it should invoke the corresponding public APIs (for example OE_ORDER_PUB or the pricing public APIs) or the line adjustment utility, which in turn delegate to OE_ORDER_ADJ_PVT.