Results for “oe_line_adj_cl_dep_attr”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.OE_LINE_ADJ_CL_DEP_ATTR is a PL/SQL package in the Oracle E-Business Suite Order Management (OE) schema whose name reflects its role as a dependency attribute container for line-level price adjustment logic. In the context of Oracle EBS 12.1.1 and 12.2.2, the package sits alongside the pricing and adjustment APIs used by Order Management to resolve, store, and validate the attribute values that qualify or drive price adjustments applied to order lines. Its naming convention—OE_LINE_ADJ (Order Entry, Line Adjustment) followed by CL_DEP_ATTR (child/dependent attributes)—indicates that the package encapsulates the set of dependent attributes associated with a line-level price adjustment, including those generated automatically versus those entered manually, and those tied to a header versus a line context.

Per the ETRM metadata, the package is owned by APPS and is VALID in the documented environment, and it is classified as an OTHER API rather than a standard public interface. It therefore functions as an internal supporting package for the price adjustment framework rather than as a callable business API for customer extension.

Key Procedures and Functions

The ETRM documentation lists sixteen documented procedures and functions. These names map directly to the attribute-holding and audit responsibilities of the package:

• AUTOMATIC – Represents the indicator for whether an adjustment or its attributes were applied automatically by the pricing engine.
• DISCOUNT and DISCOUNT_LINE – Represent discount-related adjustment values, with the line suffix distinguishing line-level discount context from header-level.
• PRICE_ADJUSTMENT – The core attribute representing the price adjustment itself.
• PERCENT – Represents the percentage value associated with a price adjustment or discount.
• HEADER and LINE – Represent the context identifiers distinguishing header-level versus line-level adjustment attributes.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard EBS audit columns carried as attributes for who created and last modified the adjustment record.
• PROGRAM_APPLICATION, PROGRAM, PROGRAM_UPDATE_DATE, REQUEST – Concurrent program context columns identifying the program and request that last processed the adjustment attributes.

The metadata does not publish parameter lists; these procedures and functions are documented by name and purpose only and should not be invoked with assumed signatures.

Tables Accessed

The documented dependency list shows that APPS.OE_LINE_ADJ_CL_DEP_ATTR references the view APPS.OE_AK_LINE_PRCADJS_V. This view is the Order Management line price adjustment view built on the Oracle Application Framework/Application Kit (AK) attribute model. The package reads from this view to obtain the dependent attribute definitions and values associated with line price adjustments. The metadata does not document additional base tables, synonym-resolved tables, or write targets beyond this view. The package is referenced by no other packages, confirming it is a leaf-level dependency rather than a shared utility.

Usage Notes

OE_LINE_ADJ_CL_DEP_ATTR is an internal dependency attribute package. It is typically invoked indirectly by Order Management pricing and adjustment processing, including the price adjustment resolution logic executed when an order is entered, repriced, or applied through the pricing engine in the Order Management transaction flow. It is not intended as a customer-facing extension point. Because the ETRM classification is OTHER and no dependent packages reference it, customization should avoid direct calls; the supported approach for attribute extension is through the OA Framework attribute model and the OE_AK_LINE_PRCADJS_V view. The audit and concurrent program columns confirm that any persisted adjustment attribute record carries standard EBS who-columns and request context, consistent with the concurrent program that derived it.