Search Results get_default_value

Overview

APP.ONT_D2_ORDERED_QUANTITY_UOM is a Defaulting Extension package (the "D2" naming convention places it within the Oracle Order Management extensibility framework used by the Order Management Defaulting Engine) shipped with Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its role is to supply a default value for the ORDERED_QUANTITY_UOM2 attribute of an order line when no default value can be derived from the standard, seeded defaulting rules configured against that attribute.

The package is part of the Order Management Defaulting Framework package family (prefixed ONT_). Each package in this family is bound to a specific attribute or attribute group and exposes a single, standardized entry point, GET_DEFAULT_VALUE, which the defaulting engine invokes whenever the corresponding attribute is resolved against a rule set that references a customized or "D2" defaulting source. The business purpose is to allow Oracle EBS implementations to supply site-specific logic for deriving the secondary ordered quantity unit of measure on an order line without modifying seeded Oracle code.

Key Procedures and Functions

• GET_DEFAULT_VALUE — The package's sole documented program unit. It accepts the order line context (passed as a record based on the OE_AK_ORDER_LINES_V view row type) and returns a VARCHAR2 value representing the computed default for the ORDERED_QUANTITY_UOM2 attribute. The function body is deliberately not fully shipped: the source excerpt shows a placeholder token where the customer- or implementation-specific logic is inserted. On any unexpected error the exception handler calls ONT_Def_Util.Add_Invalid_Rule_Message, recording an invalid-rule message against the attribute code 'ORDERED_QUANTITY_UOM2' and the rule identifier, then returns NULL so the defaulting engine can continue gracefully. No other procedures or functions are documented for this package.

Tables Accessed

The ETRM metadata for this package lists no tables referenced through APPS synonyms. Because the function's formal parameter is based on OE_AK_ORDER_LINES_V, the caller supplies the entire order line context to the function; the implementation logic inserted into the placeholder may therefore read from that record rather than performing its own SQL. Any direct table access would be implementation-supplied and is not part of the documented interface.

Usage Notes

This package is not intended to be called directly from forms, concurrent programs, or custom code. It is invoked indirectly by the Oracle Order Management Defaulting Engine when the defaulting rule assigned to ORDERED_QUANTITY_UOM2 selects this extension package as its defaulting source. The engine passes the current order line record and substitutes the returned value into the attribute.

The package is referenced by one other package, consistent with its position as a leaf-node defaulting extension called by the framework driver. Customizations should populate the <<RETURN_VALUE>> placeholder with business logic and redeploy the package body; the wrapper, signature, and exception handling should be preserved to maintain compatibility with the defaulting framework. Because the placeholder token appears in the shipped source, a fresh installation or patch application can overwrite the customization, so change control procedures should treat this object as an extension point rather than a seeded object.