Search Results g_agreement

Overview

APPS.OE_CONTRACT_UTIL is a utility package in the Oracle Order Management (OM) module of Oracle E-Business Suite, shipped in both 12.1.1 and 12.2.2. Its business function is to encapsulate the low-level data manipulation and attribute-management logic for pricing contracts held in the OE_PRICING_CONTRACTS table. Pricing contracts in Order Management define negotiated price lists, discounts, and pricing agreements that override standard list pricing for a given customer or order context.

The package is classified as a UTIL object within the ETRM (E-Business Suite Technical Reference Manual) taxonomy, meaning it is a supporting internal component rather than a public, externally versioned API. It provides the shared plumbing — attribute change detection, dependency clearing, record completion, and generic CRUD operations — that the higher-level OE_Pricing_Cont_PUB interface relies upon. The package header declares AUTHID CURRENT_USER, so it executes with the privileges of the calling schema rather than the defining (APPS) schema.

Key Procedures and Functions

The ETRM metadata documents eleven procedures and functions within this package. The most significant of these include:

• CLEAR_DEPENDENT_ATTR — Clears interdependent attribute values on a contract record. When one attribute changes, other attributes that depend on it may become invalid and must be reset.
• APPLY_ATTRIBUTE_CHANGES — Applies the net effect of attribute differences between a new contract record and its prior (old) version, producing a reconciled output record.
• COMPLETE_RECORD — A function that fills in defaulted or derived values on a contract record so that it is complete before insert or update.
• CONVERT_MISS_TO_NULL — Normalizes FND_API.G_MISS_* sentinel values to NULL, a standard pattern in EBS PL/SQL APIs.
• UPDATE_ROW, INSERT_ROW, DELETE_ROW — The core DML operations against the underlying contract table.
• QUERY_ROW, LOCK_ROW — Retrieval and pessimistic locking primitives for contract rows.
• GET_VALUES, GET_IDS — Accessor routines that return attribute values or identifier values for a contract.

Tables Accessed

The package reads and writes OE_PRICING_CONTRACTS, exposed to APPS through a synonym. This single table stores the pricing contract header records, including the associated price list, pricing contract type, and the DFF context and attribute columns referenced by the many G_ATTRIBUTE1 … G_ATTRIBUTE15 and G_CONTEXT constants in the package specification. The G_PRICE_LIST constant declared at line 29 corresponds to internal attribute identifier 24, indicating that price list is one of the tracked attributes managed through APPLY_ATTRIBUTE_CHANGES and CLEAR_DEPENDENT_ATTR.

Usage Notes

OE_CONTRACT_UTIL is not intended for direct invocation from Oracle Forms or concurrent programs. It is a subordinate utility: the metadata indicates it is referenced by three other packages, and it operates on the OE_Pricing_Cont_PUB.Contract_Rec_Type record type defined in the public pricing contract API. Custom extensions should interact with OE_Pricing_Cont_PUB rather than this internal package, since the utility layer's attribute-identifier scheme (the G_* constants) is subject to change and is not part of a published interface. When troubleshooting pricing contract behavior, refer to this package for insight into how attribute dependencies and record completion are handled.