Search Results oe_default_price_list




Overview
Explore in AI Chat

Overview

OE_DEFAULT_PRICE_LIST is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its business purpose is to supply defaulting logic for price list attributes used within the Order Management (OE) module. Price lists in Oracle EBS are maintained through the Oracle Advanced Pricing (QP) schema objects, and the Order Management application references those price lists when pricing order lines, validating customer agreements, and determining applicable price list qualifiers.

The package is declared with AUTHID CURRENT_USER and exposes a single documented program unit named Attributes. Because it accepts and returns records defined by the public pricing API record type OE_Price_List_PUB.Price_List_Rec_Type, the package operates as a defaulting helper that populates or derives attribute values for a price list record structure used elsewhere in the OE_Price_List_PUB API layer. It does not function as a standalone transaction API, but rather as a dependent defaulting routine that the higher-level public pricing interface invokes during record initialization.

Key Procedures and Functions

The package documents a single program unit:

  • Attributes — A procedure that accepts a price list record as input and returns a populated price list record as output. The input record defaults to the reserved missing value constant OE_Price_List_PUB.G_MISS_PRICE_LIST_REC, and an iteration parameter controls repeated or re-entrant defaulting passes. The procedure applies defaulting rules to the price list record attributes, ensuring that unspecified columns receive an appropriate system or business default before the record is persisted through the pricing API. No additional parameters should be assumed beyond those documented; the signature references the shared public record type rather than discrete scalar arguments, which is characteristic of Oracle's public API defaulting conventions.

Tables Accessed

ETRM metadata identifies two referenced tables accessed through APPS synonyms:

  • QP_LIST_HEADERS_B_S — The base table storing price list header definitions in Oracle Advanced Pricing. The package reads this table to obtain existing header attribute values that serve as the source for defaulting logic.
  • DUAL — Used for single-row expression evaluation, consistent with PL/SQL defaulting routines that compute values without requiring a physical table lookup.

The package is documented as referenced by two other packages, confirming that it participates in a dependency chain within the pricing and order management call stack rather than being invoked directly by end users.

Usage Notes

OE_DEFAULT_PRICE_LIST is an internal defaulting utility. It is not exposed through a standalone form or concurrent program; instead, it is invoked by calling code within the Order Management and Advanced Pricing modules whenever a price list record requires default attribute resolution prior to insert or update operations against QP_LIST_HEADERS_B_S.

Custom code should not call this package directly where a public API is available. When extending price list defaulting behavior, developers should prefer the documented public interfaces in OE_Price_List_PUB and treat OE_DEFAULT_PRICE_LIST as a subordinate implementation detail. Because the header comment reference dates to an early release and the package remains present in ETRM for 12.2.2, its logic is stable but considered legacy; any customization should verify compatibility with the current QP_LIST_HEADERS_B_S structure and the iteration semantics used by the Attributes procedure.