Search Results apply_attribute_changes

Overview

OE_LINE_PRICE_AATTR_UTIL is a utility PL/SQL package in the Oracle E-Business Suite Order Management (OM) module, owned by the APPS schema. It provides the low-level data-access and record-maintenance routines that support line-level price adjustment attributes — the descriptive attribute rows that qualify or explain a price adjustment applied to an order line. In the Oracle EBS 12.1.1 and 12.2.2 architectures, this package is classified as a UTIL object, meaning it is an internal helper rather than a public, transactional business API. It sits beneath the Order Management public APIs and is invoked by higher-level pricing and order-entry logic to query, insert, update, delete, and lock rows in the price adjustment attribute entity.

Key Procedures and Functions

The documented procedures fall into several functional groups:

• QUERY_ROW — Retrieves a single line price adjustment attribute record, returning it as a typed record.
• QUERY_ROWS — Retrieves a set of attribute records, supporting bulk access for processing.
• INSERT_ROW / UPDATE_ROW / DELETE_ROW — Perform the standard DML operations against the underlying attribute table, preserving record integrity.
• COMPLETE_RECORD — Populates or completes a record by merging with an existing (old) record, ensuring defaulted and derived values are consistent.
• CONVERT_MISS_TO_NULL — Converts the FND_API.G_MISS sentinel values to NULL, a standard EBS pattern that distinguishes "not supplied" from an explicit NULL.
• APPLY_ATTRIBUTE_CHANGES — Reconciles a new attribute record against a prior one, applying the detected changes. This is the procedure users reach when searching "apply_attribute_changes."
• LOCK_ROW / LOCK_ROWS — Acquire row-level locks to enforce optimistic concurrency control.

No parameter lists are reproduced here; callers must reference the package specification for signatures.

Tables Accessed

Through APPS synonyms, the package operates on the core Order Management pricing structures:

• OE_PRICE_ADJUSTMENTS — the price adjustment header/definition records.
• OE_PRICE_ADJ_ASSOCS — associations linking adjustments to lines or qualifiers.
• OE_PRICE_ADJ_ATTRIBS — the adjustment attribute rows maintained by this utility.
• PLITBLM — a PL/SQL index-by table synonym used for in-memory collection support.

Usage Notes

OE_LINE_PRICE_AATTR_UTIL is an internal utility and is not intended for direct customer invocation. It is referenced by four other packages within Order Management, which drive the actual business flows. APPLY_ATTRIBUTE_CHANGES is typically called during order or price-adjustment maintenance, when a record has been modified and the changes must be reconciled with the prior state before persistence. Custom code should avoid calling this utility directly; instead, developers should use the OE_Order_PUB public APIs, which invoke this helper internally. Because the object is documented as UTIL and depends on FND_API sentinel conventions, its behavior is tightly coupled to Order Management internals and may change across point releases.