Search Results oe_default_price_break




Overview
Explore in AI Chat

Overview

The APPS.OE_DEFAULT_PRICE_BREAK package is a pricing utility within the Oracle Order Management (OM) module of Oracle E-Business Suite. Its role is to supply default values for a Price Break record used during order pricing and modifier processing. A Price Break record forms part of the pricing context passed to the pricing engine, carrying the break quantity and related attributes that determine which price or modifier qualifies for a given order line. By centralizing the defaulting logic in a single callable unit, the package allows the pricing engine and its callers to obtain a fully populated Price_Break_Rec_Type structure without duplicating assignment logic across the codebase. The package header carries an AUTHID CURRENT_USER clause, meaning that it executes with the privileges of the invoking schema rather than the defining schema, so dependent PL/SQL callers must have the necessary object privileges granted directly.

Key Procedures and Functions

The documented API surface of this package consists of a single program unit, Attributes. This procedure accepts an inbound Price Break record, an inbound iteration number, and returns an outbound Price Break record. Its purpose is to derive or populate the default attribute values of a Price Break record prior to pricing evaluation. Because the procedure operates against OE_Pricing_Cont_PUB.Price_Break_Rec_Type, its inputs and outputs are strongly typed records belonging to the pricing public API layer.

  • Attributes — Populates or defaults the fields of a Price Break record so that callers can submit a complete pricing context. The inbound record defaults to the package constant OE_Pricing_Cont_PUB.G_MISS_PRICE_BREAK_REC, which signals that no caller-supplied values are passed. The inbound iteration argument defaults to 1, allowing repeat invocations where successive break levels are defaulted. The outbound record returns the resolved Price Break structure.

Tables Accessed

The documented metadata records no direct table references for this package; it does not query or maintain a base table through APPS synonyms within the scope of the ETRM entry. The program unit operates on record structures defined in the OE_Pricing_Cont_PUB specification, so any persistent reads or writes, if they occur, are performed indirectly through that public API or through the pricing engine that consumes the returned record. This design is consistent with a lightweight defaulting helper: it manipulates PL/SQL records rather than re-querying pricing tables, which keeps the call inexpensive when executed repeatedly during price break evaluation.

Usage Notes

This package is typically invoked from within the pricing call stack rather than directly by end users. Practitioners encounter it when tracing how Price Break records acquire their default values before the pricing engine evaluates list prices, discounts, and modifier break levels. The ETRM metadata indicates that one other package references OE_DEFAULT_PRICE_BREAK, establishing it as a subordinate utility rather than an entry-point API. Customizations that extend pricing behavior may call the Attributes procedure to obtain a defaulted Price Break record before invoking the public pricing containers, but such calls should respect the AUTHID CURRENT_USER semantics and the typed record signatures. The package is present and documented across both 12.1.1 and 12.2.2, and its interface is stable across those releases.