Search Results get_agreement

Overview

OE_DEFAULT_CONTRACT is an Oracle E-Business Suite Order Management (OM) pricing package body owned by the APPS schema. In EBS 12.1.1 and 12.2.2, it participates in the pricing and contracts layer that supplies default contract, agreement, discount, and price list identifiers to Oracle Order Management transaction flows. The package exposes a small set of getter functions that the pricing engine calls when it needs a defaulting value and no user-specified value has been supplied. Where the underlying source sequence is enabled, the package derives a fresh identifier from the relevant sequence; where the source feature is not implemented, the function returns NULL so that the calling pricing API can apply its own fallback behavior.

The package is classified as OTHER in the ETRM repository, indicating it is not a published public API intended for direct customer invocation. It is an internal helper that supports the pricing contracts public API (OE_Pricing_Cont_PUB), a relationship visible in the package body itself, where a global variable of type OE_Pricing_Cont_PUB.Contract_Rec_Type is declared.

Key Procedures and Functions

The ETRM documentation for this object lists a single documented entry, ATTRIBUTES, representing the package-level declarations and accessor functions. The package body defines the following getter functions, none of which take parameters:

• Get_Agreement — Returns an agreement identifier. The sequence-based implementation is commented out in the source, so the function currently returns NULL. It includes debug tracing via OE_DEBUG_PUB and exception handling through OE_MSG_PUB.
• Get_Discount — Returns a discount identifier. As with Get_Agreement, the sequence lookup is commented out and the function returns NULL, with debug entry and exit messages.
• Get_Last_Updated_By — Returns a NUMBER that the pricing layer uses to stamp or compare the last-updated-by value on defaulted contract records. The implementation returns NULL; there is no sequence or query backing it.
• Get_Price_List — Returns a price list identifier. The function body returns NULL.
• Get_Pricing_Contract — Returns a pricing contract identifier by selecting OE_PRICING_CONTRACTS_S.NEXTVAL into a local variable, making this the only getter that produces a real value.

The exception blocks in Get_Agreement and Get_Discount use OE_MSG_PUB.Check_Msg_Level with G_MSG_LVL_UNEXP_ERROR and re-raise FND_API.G_EXC_UNEXPECTED_ERROR, following standard OM API error-handling conventions.

Tables Accessed

The package references two objects through APPS synonyms. OE_PRICING_CONTRACTS_S is the sequence that supplies the next pricing contract identifier in Get_Pricing_Contract. DUAL is used as the single-row source for that sequence selection and for the commented-out agreement and discount sequence lookups. No base tables are read or written directly by the package; any persistence of the returned values is performed by the calling pricing API rather than by OE_DEFAULT_CONTRACT itself.

Usage Notes

OE_DEFAULT_CONTRACT is an internal defaulting utility rather than a user-facing API. It is expected to be invoked by Order Management pricing forms, pricing engine calls, and internal OM PL/SQL flows that need default contract, discount, agreement, price list, or pricing contract values during order entry and pricing. Customers implementing extensions should not call this package directly; the supported entry point is the pricing contracts public API. When reviewing or debugging a search for get_last_updated_by, note that the function returns NULL by design and therefore cannot supply a meaningful last-updated-by value — any code depending on it for auditing purposes must obtain that value from the underlying contract record instead. The package is referenced by zero other packages according to the ETRM metadata, confirming its limited and internal role.