Search Results get_terms

Overview

APPS.OE_DEFAULT_PRICE_LIST is a PL/SQL package body in Oracle E-Business Suite that supports the Order Management pricing defaulting mechanism. Its role is to supply default attribute values for a price list record when Order Management (OE) creates or seeds a price list entity that has not been fully populated by user input or by the calling process. The package name reflects its function: it provides defaulted values for the price list attributes defined in the OE_Price_List_PUB record structure, specifically the global record g_PRICE_LIST_rec OE_Price_List_PUB.Price_List_Rec_Type.

The package is classified as a non-API (OTHER) object, meaning it is an internal support utility rather than a public integration interface. It is referenced by two other packages, indicating it is embedded in a wider defaulting chain used by Order Management during price list initialization. In EBS 12.1.1 and 12.2.2 the package retains its legacy structure, including the original CVS header reference to OEXDPRHB.pls, reflecting its long-standing role in the order pricing foundation.

Most getter functions in this package are deliberately stubbed, returning NULL. This is significant: only the Get_Price_List function performs real work, while the remaining attributes are intentionally left for downstream defaulting logic. The package therefore acts primarily as a placeholder and partial defaulting provider rather than a comprehensive defaulting engine.

Key Procedures and Functions

The ETRM metadata documents the package as exposing a single relevant entry, ATTRIBUTES, which in practice corresponds to the family of getter functions in the package body. The documented getters are:

• Get_Price_List — returns a NUMBER. This is the only functional getter; it selects the next value from the QP_LIST_HEADERS_B_S sequence into a local variable and returns it, thereby supplying a fresh price_list_id for a new price list record.
• Get_Comments — returns VARCHAR2, currently returning NULL as a default.
• Get_Currency — returns VARCHAR2, returning NULL.
• Get_Description — returns VARCHAR2, returning NULL.
• Get_End_Date_Active — returns DATE, returning NULL.
• Get_Freight_Terms — returns VARCHAR2, returning NULL.
• Get_Name — returns VARCHAR2, returning NULL.
• Get_Rounding_Factor — returns NUMBER, returning NULL.
• Get_Secondary_Price_List — returns NUMBER, returning NULL.
• Get_Ship_Method — returns VARCHAR2, returning NULL.
• Get_Start_Date_Active — returns DATE, returning NULL.

Get_Price_List includes standard EBS error handling: it calls OE_DEBUG_PUB to log entry and exit, and on exception it invokes OE_MSG_PUB to record the message and raises FND_API.G_EXC_UNEXPECTED_ERROR. Because the metadata does not document parameter signatures, no parameter lists are asserted here.

Tables Accessed

• QP_LIST_HEADERS_B_S — accessed via the APPS synonym. The sequence is queried in Get_Price_List to obtain the next primary key for a price list header, ensuring a unique price_list_id for the new record.
• DUAL — used as the source for the sequence selection, consistent with standard Oracle EBS primary-key generation patterns.

No other tables are referenced. All other getters return static NULL values and do not touch the database.

Usage Notes

OE_DEFAULT_PRICE_LIST is invoked through the Order Management defaulting framework rather than directly by end users. It is typically called when a price list record is created or defaulted — for example, from Order Management forms or from internal packages that compose the OE_Price_List_PUB record. The two packages that reference this object call it as part of that defaulting chain.

Because most getters return NULL, callers relying on this package should expect that only a price list identifier is defaulted; all other attributes must be supplied by alternative defaulting sources or by user entry. The get_terms search that led to this object reflects the broader pattern of retrieving defaulted terms, but note that the package does not expose a documented Get_Terms function; Freight_Terms is the closest named attribute and is stubbed to NULL.

Customizations should avoid modifying this package body in production, as it is an internal Order Management object. Instead, extensions should use supported APIs and personalization, leaving the null-returning stubs intact to preserve default behavior.