Search Results oe_line_cl_dep_attr




Overview
Explore in AI Chat

Overview

APPS.OE_LINE_CL_DEP_ATTR is a PL/SQL package in the Oracle Order Management (ONT) schema. Its designation as a "CL_DEP_ATTR" package indicates that it governs dependent attributes at the order line level — the cascading of values from header-level or parent-level fields down to order lines, and the enforcement of Defaulting, Dependency, and Attribute (DDA) rules during order capture.

In Oracle EBS 12.1.1 and 12.2.2, Order Management uses this package to resolve values for order line attributes derived from related entities such as the customer, ship-to, bill-to, agreement, and item. The package is registered in the ETRM with an API classification of OTHER and is confirmed VALID in the APPS schema. It depends on the view APPS.OE_AK_ORDER_LINES_V, which supplies the attribute key context for the order line. It is itself referenced by ONT_LINE_DEF_HDLR, the Order Management line defaulting handler, confirming that this package participates directly in the defaulting framework used when lines are created or modified.

Key Procedures and Functions

The ETRM documents 62 procedures and functions. A representative subset is listed below; these procedures correspond to individual order line attributes whose values the package resolves or defaults.

Because the package is invoked during the line defaulting and dependency resolution cycle, each procedure is responsible for returning the appropriate value for its named attribute based on the order context passed by the handler.

Tables Accessed

The ETRM documents APPS.OE_AK_ORDER_LINES_V as the object referenced by this package. This is an Order Management attribute/interface view that presents order line columns in the structure expected by the DDA engine. The package reads the order line attribute context through this view and returns derived values to its caller, ONT_LINE_DEF_HDLR. No direct table writes are documented; the package operates as a resolution provider within the defaulting framework rather than as a persistence routine.

Usage Notes

OE_LINE_CL_DEP_ATTR is not typically called directly by end users or by standalone custom code. It is invoked indirectly whenever order lines are created, copied, or modified through the Order Organizer, Sales Order form, or Order Import, since these flows drive the line defaulting handler that in turn calls this package. The same applies to public APIs such as OE_ORDER_PUB when line records are processed and attribute defaults must be resolved.

Customizations that need to alter defaulting behavior for these specific order line attributes are best implemented by extending or wrapping ONT_LINE_DEF_HDLR rather than by modifying OE_LINE_CL_DEP_ATTR itself. Because 62 procedures are documented, developers should treat the package as a comprehensive attribute resolution library for order lines and should consult the ETRM object page for the full procedure inventory before attempting any extension.