Search Results g_line_adj_rec

Overview

OE_DEFAULT_LINE_ADJ is an Oracle Order Management package body in the APPS schema that supplies defaulting logic for order line price adjustments. Its principal role is to populate attribute values on the line adjustment record structure (OE_Order_PUB.Line_Adj_Rec_Type) before a price adjustment is written to the order. This ensures that mandatory or context-dependent columns carry valid values when a caller does not supply them explicitly.

The package is classified under the ETRM API classification "OTHER," indicating it is an internal utility rather than a public, customer-facing API. It was last modified under header revision 120.1 (2005/06/14), which places it within the common code line shared by EBS 12.1.1 and 12.2.2. The package name itself, and the naming of its documented procedure Attributes, follow the standard Order Management defaulting convention in which an Attributes procedure applies defaults to a record passed in by reference.

Key Procedures and Functions

• Attributes — The single documented procedure. It accepts an in/out line adjustment record, an "old" (pre-change) line adjustment record, and an iteration number, then applies defaulting rules to the working record. Defaulting is conditional: for records in create mode (OE_GLOBALS.G_OPR_CREATE) whose list line type code is FREIGHT_CHARGE, the procedure sets estimated_flag to 'Y', invoiced_flag to 'N', and credit_or_charge_flag to 'D' when those attributes are null or carry FND_API.G_MISS_CHAR. Debug tracing is emitted at entry via oe_debug_pub.add. Earlier logic that converted the API record to a rowtype based on OE_AK_LINE_PRCADJS_V was commented out under Bug 2155582 due to record-type incompatibilities.
• Get_Price_Adjustment — A get function that returns a new adjustment identifier by selecting the next value from the OE_PRICE_ADJUSTMENTS_S sequence. Although not listed in the documented ETRM procedure inventory, it appears in the package body and is part of the source excerpt provided.

The package-level variable g_line_adj_rec, declared as OE_Order_PUB.Line_Adj_Rec_Type, is the record referenced by the search term "g_line_adj_rec". A prior declaration based on OE_AK_LINE_PRCADJS_V%ROWTYPE was commented out under Bug 2155582, reflecting the migration from the older view-based rowtype to the public API record type.

Tables Accessed

The documented objects referenced by this package are limited. OE_PRICE_ADJUSTMENTS_S is an APPS synonym for the sequence that supplies primary keys for price adjustment records, accessed in Get_Price_Adjustment. DUAL is used as the single-row source for that sequence selection. No base tables are documented as directly read or written by this package; persistence of the adjustment record is handled by the calling Order Management API layer.

Usage Notes

OE_DEFAULT_LINE_ADJ is invoked internally by Oracle Order Management during price adjustment processing, within the standard defaulting flow that precedes validation and insertion of line-level adjustments. It is most relevant when freight charge adjustments are created, because the documented defaulting logic branches specifically on list_line_type_code = 'FREIGHT_CHARGE'. The package is referenced by one other package in the ETRM dependency inventory and is not intended to be called directly by customers. Custom code should rely on the public OE_ORDER_PUB APIs; the behavior implemented here is applied automatically on those calls. Debug output is controlled through the standard Order Management debugging facility, oe_debug_pub. Because the record structures differ between releases at the view level, any custom extension of defaulting logic should use OE_Order_PUB.Line_Adj_Rec_Type rather than the legacy OE_AK_LINE_PRCADJS_V rowtype.