Search Results ont_d2_ordered_quantity_uom




Overview
Explore in AI Chat

Overview

The APPS.ONT_D2_ORDERED_QUANTITY_UOM package is a defaulting-handler package within the Oracle Order Management (ONT) module of Oracle E-Business Suite. Its role is to supply a default value for the ordered quantity unit of measure (UOM) on the order line entity during order capture and processing. As part of the broader Order Management defaulting framework, this package encapsulates the logic that determines which unit of measure should be proposed for the "ordered quantity" attribute when a user enters or modifies an order line and no explicit value has been supplied.

The package is defined with AUTHID CURRENT_USER, indicating that its SQL statements execute under the privileges of the invoking user rather than its owner (APPS). The header comment traces the source to OEXDFWKB.pls and dates its creation to 13-AUG-13. In the ETRM classification for 12.2.2, the package is categorized with an API classification of OTHER, reflecting that it is an internal defaulting utility rather than a public business API such as those under the ONT_ order capture interface family.

Key Procedures and Functions

The package spec exposes a single documented function:

  • GET_DEFAULT_VALUE — Returns a VARCHAR2 value representing the default unit of measure for the ordered quantity attribute. It accepts a single input parameter, p_line_rec, declared as OE_AK_ORDER_LINES_V%ROWTYPE, which passes the current order line record context into the function so that the defaulting logic can evaluate existing line attributes. Because of the %ROWTYPE anchoring, the parameter mirrors the structure of the Order Lines view, allowing the handler to inspect any line-level column when deriving the default. No other procedures or functions are documented in the package specification.

Consistent with the Order Management defaulting framework, GET_DEFAULT_VALUE is invoked by the defaulting engine rather than called directly by end-user flows. The engine passes the seeded line record and consumes the returned UOM code as the proposed default.

Tables Accessed

The documented metadata does not enumerate any base tables referenced by this package via APPS synonyms. As a defaulting handler, it is expected to operate primarily against the in-memory record passed in through p_line_rec, deriving its return value from that context rather than performing direct reads or writes. Any lookups for valid unit-of-measure codes would conventionally resolve through Order Management's standard UOM validation rather than through explicit table access declared in the package spec.

Usage Notes

This package is registered as a defaulting rule source in Order Management's defaulting setup for the ordered quantity UOM attribute on order lines. It is exercised automatically whenever the defaulting framework runs for that attribute—typically during order entry via the Sales Orders form, during order import, and through order capture APIs such as those in the OE_ORDER_PUB family. The metadata records that the package is referenced by one other package, which is the mechanism through which the defaulting engine dispatches to this handler. Customizations involving ordered-quantity UOM defaults should be applied by extending or replacing the registered defaulting handler rather than modifying this seeded package directly, since Oracle ships it under standard support and it is subject to patching.