Search Results discount_line

Overview

OE_LINE_ADJ_CL_DEP_ATTR is a dependent attribute (clearing) package within the Oracle Order Management (OM) module of Oracle E-Business Suite. Its role is to support the Oracle ETRM (Enterprise Territory and Resource Management) and order line adjustment infrastructure by defining a standard, callable interface for clearing dependent attributes on a line price adjustment record. The package operates on records shaped by the OE_AK_LINE_PRCADJS_V view, which represents order line price adjustments, including discount-type adjustments. Each procedure corresponds to a single attribute of that record and delegates the actual clearing work to the shared helper OE_Line_Adj_Util.Clear_Dependent_Attr.

The package is classified as OTHER in the ETRM 12.2.2 metadata, indicating it is a supporting utility package rather than a public, business-facing API. It does not maintain its own persistent logic; instead it acts as a thin, attribute-keyed dispatch layer that centralizes the invalidation of dependent fields when a controlling attribute changes on a price adjustment line. This design pattern is common in Oracle EBS where dependent attributes must be cleared consistently across forms, APIs, and concurrent processes.

Key Procedures and Functions

The package exposes sixteen documented procedures, each mapped to a distinct attribute of the line adjustment record. All share the same behavior: they receive the line adjustment record and invoke the utility routine to clear the dependent attribute value. The relevant procedures include:

• DISCOUNT_LINE — clears the discount line dependent attribute, the specific object referenced in the "discount_line" search. This is the routine that resets fields tied to a discount line context on the adjustment record.
• DISCOUNT — clears the discount attribute, handling discount-related dependent fields.
• PRICE_ADJUSTMENT — clears fields dependent on the price adjustment value.
• PERCENT — clears the percentage-based dependent attribute.
• LINE — clears the order line dependent attribute.
• HEADER — clears header-level dependent attributes.
• AUTOMATIC — clears the automatic (system-generated) attribute flag or value.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — clear the standard WHO-column audit attributes.
• PROGRAM_APPLICATION, PROGRAM, PROGRAM_UPDATE_DATE, REQUEST — clear concurrent program and request audit attributes.

No procedures return values; each mutates the passed record in place.

Tables Accessed

The documented metadata does not list explicitly referenced tables via APPS synonyms, and the package operates primarily through the OE_AK_LINE_PRCADJS_V view and the OE_Line_Adj_Util helper. The underlying persistence belongs to the order line price adjustment tables queried by that view. Because the package exposes only clearing procedures, it does not directly read or write business tables; the actual dependent-attribute update is performed by OE_Line_Adj_Util.Clear_Dependent_Attr against the view-based record.

Usage Notes

This package is typically invoked by Oracle Order Management forms and internal adjustment logic whenever a controlling attribute on a price adjustment line changes and dependent attributes must be cleared. It is not referenced by any other packaged API in the documented metadata, so custom code should call it only in the same context as the standard OM adjustment framework. In EBS 12.1.1 and 12.2.2, it is generally treated as an internal utility; customized integrations should prefer the supported Order Management public APIs and avoid direct invocation unless replicating standard dependent-attribute clearing behavior for line adjustments.