Search Results oe_delayed_requests_pvt
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.
-
PACKAGE: APPS.OE_DELAYED_REQUESTS_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_DELAYED_REQUESTS_UTIL, status:VALID,
-
PACKAGE: APPS.OE_DELAYED_REQUESTS_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_DELAYED_REQUESTS_UTIL, status:VALID,
-
PACKAGE BODY: APPS.OE_DELAYED_REQUESTS_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_DELAYED_REQUESTS_PVT, status:VALID,
-
PACKAGE BODY: APPS.OE_DELAYED_REQUESTS_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_DELAYED_REQUESTS_PVT, status:VALID,
-
PACKAGE: APPS.OE_DELAYED_REQUESTS_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_DELAYED_REQUESTS_PVT, status:VALID,
-
PACKAGE: APPS.OE_DELAYED_REQUESTS_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_DELAYED_REQUESTS_PVT, status:VALID,
-
PACKAGE: APPS.OE_SHIPPING_WF
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_SHIPPING_WF, status:VALID,
-
PACKAGE: APPS.OE_FTE_INTEGRATION_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_FTE_INTEGRATION_PVT, status:VALID,
-
PACKAGE: APPS.OE_FTE_INTEGRATION_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_FTE_INTEGRATION_PVT, status:VALID,
-
PACKAGE: APPS.OE_BLANKET_PRICING_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_BLANKET_PRICING_UTIL, status:VALID,
-
PACKAGE: APPS.OE_BLANKET_PRICING_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_BLANKET_PRICING_UTIL, status:VALID,
-
PACKAGE: APPS.OE_ACCEPTANCE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_ACCEPTANCE_PVT, status:VALID,
-
PACKAGE: APPS.OE_ACCEPTANCE_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_ACCEPTANCE_PVT, status:VALID,
-
PACKAGE: APPS.OE_PURCHASE_RELEASE_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_PURCHASE_RELEASE_PVT, status:VALID,
-
PACKAGE: APPS.OE_BLANKET_WF_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_BLANKET_WF_UTIL, status:VALID,
-
PACKAGE: APPS.OE_BLANKET_WF_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_BLANKET_WF_UTIL, status:VALID,
-
PACKAGE: APPS.OE_PURCHASE_RELEASE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_PURCHASE_RELEASE_PVT, status:VALID,
-
PACKAGE: APPS.OE_ACCEPTANCE_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_ACCEPTANCE_UTIL, status:VALID,
-
PACKAGE: APPS.OM_TAX_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OM_TAX_UTIL, status:VALID,
-
PACKAGE: APPS.OE_BLKT_RELEASE_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_BLKT_RELEASE_UTIL, status:VALID,
-
PACKAGE: APPS.OE_LINE_ADJ_ASSOCS_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_LINE_ADJ_ASSOCS_UTIL, status:VALID,
-
PACKAGE: APPS.OE_BLKT_RELEASE_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_BLKT_RELEASE_UTIL, status:VALID,
-
PACKAGE: APPS.OE_ACCEPTANCE_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_ACCEPTANCE_UTIL, status:VALID,
-
PACKAGE: APPS.OE_LINE_PATTR_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_LINE_PATTR_UTIL, status:VALID,
-
PACKAGE: APPS.OE_MASS_CHANGE_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_MASS_CHANGE_PVT, status:VALID,
-
PACKAGE: APPS.OE_GROUP_SCH_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_GROUP_SCH_UTIL, status:VALID,
-
PACKAGE: APPS.OE_GROUP_SCH_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_GROUP_SCH_UTIL, status:VALID,
-
PACKAGE: APPS.OE_MASS_CHANGE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_MASS_CHANGE_PVT, status:VALID,
-
PACKAGE: APPS.OE_SALES_CAN_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_SALES_CAN_UTIL, status:VALID,
-
PACKAGE: APPS.OE_CONFIG_SCHEDULE_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_CONFIG_SCHEDULE_PVT, status:VALID,
-
PACKAGE: APPS.OE_CONFIG_SCHEDULE_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_CONFIG_SCHEDULE_PVT, status:VALID,
-
PACKAGE: APPS.OE_LINE_PATTR_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_LINE_PATTR_UTIL, status:VALID,
-
PACKAGE: APPS.OE_MARGIN_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_MARGIN_PVT, status:VALID,
-
PACKAGE BODY: APPS.OE_HEADER_PATTR_UTIL
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_HEADER_PATTR_UTIL, status:VALID,
-
PACKAGE: APPS.OE_BLANKET_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_BLANKET_UTIL, status:VALID,
-
PACKAGE: APPS.OE_MARGIN_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_MARGIN_PVT, status:VALID,
-
PACKAGE: APPS.OE_PREPAYMENT_PVT
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_PREPAYMENT_PVT, status:VALID,
-
PACKAGE BODY: APPS.OE_VALIDATE_HEADER_SCREDIT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_VALIDATE_HEADER_SCREDIT, status:VALID,
-
PACKAGE BODY: APPS.OE_OE_FORM_LINE_PATTR
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_OE_FORM_LINE_PATTR, status:VALID,
-
PACKAGE BODY: APPS.OE_VALIDATE_HEADER_SCREDIT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_VALIDATE_HEADER_SCREDIT, status:VALID,
-
PACKAGE: APPS.OE_BLANKET_UTIL
12.1.1
owner:APPS, object_type:PACKAGE, object_name:OE_BLANKET_UTIL, status:VALID,
-
PACKAGE BODY: APPS.OE_HEADER_PATTR_UTIL
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_HEADER_PATTR_UTIL, status:VALID,
-
PACKAGE BODY: APPS.OE_OE_FORM_HEADER_ADJ
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_OE_FORM_HEADER_ADJ, status:VALID,
-
PACKAGE BODY: APPS.OE_OE_FORM_LINE_PATTR
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_OE_FORM_LINE_PATTR, status:VALID,
-
PACKAGE: APPS.OE_PREPAYMENT_PVT
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_PREPAYMENT_PVT, status:VALID,
-
PACKAGE BODY: APPS.OE_BLANKET_PVT
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OE_BLANKET_PVT, status:VALID,
-
PACKAGE: APPS.OE_SERVICE_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_SERVICE_UTIL, status:VALID,
-
PACKAGE: APPS.OE_SALES_CAN_UTIL
12.2.2
owner:APPS, object_type:PACKAGE, object_name:OE_SALES_CAN_UTIL, status:VALID,
-
PACKAGE BODY: APPS.OE_OE_FORM_HEADER_ADJ
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_OE_FORM_HEADER_ADJ, status:VALID,
-
PACKAGE BODY: APPS.OE_BLANKET_PVT
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OE_BLANKET_PVT, status:VALID,