Search Results validate_last_update_date

Overview

APPS.IBE_ORDER_UTIL_PVT is a private PL/SQL package body that belongs to the Oracle iStore (IBE) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. The package serves as an internal utility layer that aggregates and normalizes order-level data used by the iStore storefront and order capture flows. It sits between the presentation facing iStore APIs and the underlying Oracle Order Management and Trading Community tables, exposing helper routines that query recurring totals, price adjustments, MACD (Multiple Address / Multiple Customer Delivery, i.e., multiple ship-to) action modes, contact channel information, and record freshness validation. The "PVT" suffix in the API classification indicates these are private, non-public procedures intended for internal consumption by other iStore packages rather than a documented integration surface. According to ETRM documentation for 12.2.2, the package is referenced by two other packages, confirming its role as a shared internal dependency in the iStore order utility stack. The source header shows a version milestone dated 2006, indicating the codebase has been stable across the 12.1.1 and 12.2.2 release family.

Key Procedures and Functions

• GET_ORD_RECURRING_TOTALS — Returns the recurring charge breakdown for an order header. It delegates to OE_TOTALS_GRP.GET_RECURRING_TOTALS and returns parallel array collections describing charge periodicity (code, description, meaning) alongside subtotal, tax, charges, and total amounts. It supports detailed debugging through IBE_UTIL.G_DEBUGON.
• GET_ADJUSTMENTS — Retrieves order adjustment information, providing the pricing adjustment context associated with an order or line so the caller can present discount and surcharge detail.
• GET_MACD_ACTION_MODE — Determines the action mode applicable to a multiple ship-to (MACD) order scenario, returning the mode that governs how the calling process should handle multiple delivery and customer records. This is the procedure referenced by the search term "get_macd_action_mode."
• GET_PHONE_EMAIL — Returns telephone and e-mail contact details for a party or contact, sourced from the contact point infrastructure, for display in iStore order and account screens.
• VALIDATE_LAST_UPDATE_DATE — Performs a last-update-date validation, typically used to detect stale or concurrently modified order records before an update is committed.

Tables Accessed

The package accesses its data through APPS synonyms, as documented in ETRM:

• HZ_CONTACT_POINTS — Provides telephone and e-mail contact records consumed by GET_PHONE_EMAIL.
• OE_ORDER_HEADERS_ALL — Supplies order header context used by the totals, adjustment, and MACD routines.
• OE_ORDER_LINES_ALL — Provides line-level detail for adjustments and recurring charge calculations.
• PLITBLM — A PL/SQL index-by table used internally for collection handling and bulk data passing between routines.

Usage Notes

Because IBE_ORDER_UTIL_PVT is classified as a private API, it is not intended for direct external invocation. It is called by iStore forms, business flows, and the two dependent packages identified in the ETRM metadata, chiefly when rendering order review, checkout, and account maintenance pages that display recurring totals, adjustments, contact details, or that must resolve multiple ship-to treatment. Customizations should prefer the public iStore and Order Management APIs; if direct calls are necessary, callers must supply every OUT parameter as a collection and check X_RETURN_STATUS, X_MSG_COUNT, and X_MSG_DATA. The presence of FND_API constants and debug hooks confirms alignment with standard EBS error-handling and diagnostics conventions across 12.1.1 and 12.2.2.