Search Results eval_hold_source

Overview

OE_DELAYED_REQUESTS_UTIL is a utility package in the APPS schema of Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Oracle Order Management (OM) module and is classified under the ETRM (E-Business Suite Technical Reference Manual) as a UTIL-type API. In that taxonomy, utility packages provide low-level helper logic that supports higher-level public APIs, rather than exposing a user-facing or fully validated business interface of their own.

The package supports delayed request processing within Order Management, including service credit (SCREDIT) handling, hold management, and order line credit validation. Its procedures and functions centralize reusable processing that other OM components — particularly OE_DELAYED_REQUESTS_PVT and the order/lines utilities — rely on when an order or order line has been captured but whose dependent processing is deferred.

Key Procedures and Functions

According to the documented ETRM metadata, the package contains 46 procedures and functions. Representative entries include:

• FIRST_PERIOD_BILL_AMT — derives the bill amount for the first billing period, used in service credit and billing-related calculations.
• VALIDATE_LSC_QUOTA_TOTAL and VALIDATE_HSC_QUOTA_TOTAL — validate line-level and header-level service credit quota totals respectively.
• CASCADE_SERVICE_SCREDIT — propagates service credit values down affected order structures.
• DFLT_HSCREDIT_PRIMARY_SREP — defaults the primary sales representative for header-level service credit.
• UPDATE_LINK_TO_LINE_ID — maintains the linkage between related order records.
• CHECK_DUPLICATE, CHECK_FIXED_PRICE, CHECK_PERCENTAGE — validation checks for duplicates, fixed-price pricing, and percentage-based values.
• CREATE_CONFIG_ITEM, INS_INCLUDED_ITEMS — build configuration items and their included components.
• VERIFY_PAYMENT — confirms payment conditions before credit processing proceeds.
• INSERT_RMA_SCREDIT_ADJUSTMENT, INSERT_RMA_OPTIONS_INCLUDED, INSERT_RMA_LOT_SERIAL — insert RMA-related service credit adjustments, included options, and lot/serial detail.
• TAX_LINE — supports tax line creation linked to order processing.
• SPLIT_HOLD, EVAL_HOLD_SOURCE, APPLY_HOLD, RELEASE_HOLD — the package's hold-management set: evaluating hold sources, applying, splitting, and releasing order holds.

Parameter lists are not published in the ETRM excerpt, so signatures should always be confirmed against the live package specification before direct invocation.

Tables Accessed

The package reads and writes through APPS synonyms of the following base tables:

• OE_ORDER_HEADERS / OE_ORDER_HEADERS_ALL and OE_ORDER_LINES / OE_ORDER_LINES_ALL — the core order header and line records the utility updates or queries.
• OE_HOLD_SOURCES_ALL — hold source definitions consumed by EVAL_HOLD_SOURCE, APPLY_HOLD, and RELEASE_HOLD.
• OE_DISCOUNTS and OE_DISCOUNT_LINES — pricing and discount data relevant to credit and pricing checks.
• OE_HEADER_ACKS, OE_LINE_ACKS, OE_LINE_SETS — acknowledgement and line set records produced or maintained during deferred processing.
• MTL_SYSTEM_ITEMS, MTL_LOT_NUMBERS, MTL_MATERIAL_TRANSACTIONS, MTL_TRANSACTION_LOT_NUMBERS — item and lot/serial information used in RMA and inventory-facing inserts.
• FND_USER — user context for responsibility and attribution.

Usage Notes

OE_DELAYED_REQUESTS_UTIL is an internal helper, not a standalone public API. It depends on FND_API, OE_DELAYED_REQUESTS_PVT, OE_HOLD_SOURCES_ALL, and OE_ORDER_PUB, and is itself referenced by OE_DELAYED_REQUESTS_PVT, OE_HEADER_UTIL, OE_LINE_UTIL, OE_VALIDATE_LINE_SCREDIT, and OM_TAX_UTIL — eight referring packages in total. Invocation therefore typically flows indirectly: delayed request processing, order entry forms, hold application flows, and service credit validation routines reach these procedures through the public Order Management APIs (notably OE_ORDER_PUB). Customizations should prefer those supported entry points; direct calls should be limited to extension logic that mirrors an existing internal call path and must be re-tested against both 12.1.1 and 12.2.2, since utility packages are not covered by Oracle's compatibility guarantees.