Search Results get_price_break_low

Overview

The APPS.OE_DEFAULT_PRICE_BREAK package body is a supporting component of the Oracle Order Management pricing infrastructure in Oracle E-Business Suite 12.1.1 and 12.2.2. Its business function is to provide a defaulting layer for price break records used by the pricing engine and the Order Management integration APIs, principally OE_Pricing_Cont_PUB and the pricing container structures that underlie order line pricing. A price break defines the quantity or price range over which a particular price, discount, or modifier applies, and the package exists to supply default values for the individual attributes of a price break record — such as amount, percent, unit, method type, and the low and high bounds of the break — before those records are passed to the pricing engine or persisted.

The package is classified in ETRM as an "OTHER" API, meaning it is neither a fully exposed public API nor a private internal utility, but a technical helper intended for controlled consumption by other Order Management packages. Its design follows the common EBS pattern of exposing a set of typed Get functions that return attribute values, plus an initialization routine that normalizes a working record held in package global state.

Key Procedures and Functions

The documented package body contains a set of Get functions, each of which returns a single attribute of the price break record, together with the Get_Flex_Price_Break procedure. The most relevant function in the context of the search term "get_price_break_low" is:

• Get_Price_Break_Low — returns the lower boundary value of a price break. In the shipping source this function is a stub that returns NULL, indicating the defaulting responsibility rests on the caller or on a replaced/customized implementation.
• Get_Price_Break_High — returns the upper boundary value of a price break, also a NULL-returning stub.
• Get_Amount, Get_Percent, Get_Price — return the monetary or percentage value associated with the break.
• Get_Discount_Line — returns the discount line identifier, if any.
• Get_Method_Type, Get_Unit — return the method (for example price or discount) and the unit of measure for the break.
• Get_Start_Date_Active, Get_End_Date_Active — return the effective date range of the price break.
• Get_Flex_Price_Break — a procedure that normalizes the descriptive flexfield attributes (attribute1 through attribute15) of the package global g_Price_Break_rec, converting the FND_API.G_MISS_CHAR sentinel into NULL. The comment embedded in the source notes that flex API defaulting was reserved for future enhancement.

Tables Accessed

The ETRM metadata for this package lists no directly referenced tables accessed via APPS synonyms. The package operates on in-memory PL/SQL record structures — notably the package global g_Price_Break_rec, declared as OE_Pricing_Cont_PUB.Price_Break_Rec_Type — rather than issuing DML against pricing tables. Persistence of price break data is handled by the calling packages, such as OE_Pricing_Cont_PUB, which manages the pricing container and ultimately writes to the Order Management pricing entities. The absence of table references is consistent with the package's role as a defaulting and normalization helper rather than a data access layer.

Usage Notes

The package is typically invoked indirectly. It is referenced by one other documented package, which supplies the price break container and drives the defaulting sequence before a record is submitted to the pricing engine. In standard 12.2.2 configurations, the Get functions return NULL and are effectively placeholders; this indicates that the shipped behavior relies on the caller to populate the break bounds, and that Get_Price_Break_Low is a hook available for customers or integrators to override through a supported or custom copy of the package.

Because the package depends on FND_API for the G_MISS_CHAR sentinel used in Get_Flex_Price_Break, and because it manipulates attribute columns reserved for descriptive flexfields, customizations should preserve the G_MISS-to-NULL conversion semantics to avoid storing the sentinel value in the underlying flexfield columns. Any extension of Get_Price_Break_Low or its sibling functions should be performed in a custom package layered over the standard one rather than by direct modification, in keeping with Oracle's recommendations for upgrading between 12.1.1 and 12.2.2.