Results for “wsh_integration”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.WSH_INTEGRATION is a valid PL/SQL package body in the Oracle E-Business Suite Shipping Execution (WSH) schema. It functions as an internal integration and utility layer that supports the creation, validation, and maintenance of delivery records and their associated shipment lines within Oracle Shipping Execution. The package bridges Oracle Order Management, Purchasing, Inventory, and the Warehouse Management execution flows by mediating data between delivery details, delivery assignments, trip stops, and delivery legs, while enforcing user-defined shipping parameters and profile-driven tolerances.

Consistent with its classification as an OTHER API, WSH_INTEGRATION is not intended as a public, customer-callable interface in the same sense as an open PL/SQL API (for example, WSH_DELIVERY_PUB or the Order Management public APIs). Rather, it provides reusable internal subprograms invoked by other WSH packages and by concurrent program logic. Its dependency footprint confirms this role: it references foundational EBS infrastructure packages such as FND_API, FND_GLOBAL, FND_MESSAGE, FND_MSG_PUB, and FND_PROFILE, shipping-specific packages including WSH_DELIVERY_AUTOCREATE, WSH_DETAILS_VALIDATIONS, WSH_SHIPPING_PARAMS_PVT, WSH_UTIL_CORE, WSH_WV_UTILS, and WSH_DEBUG_SV, and optional distributed business intelligence hooks through ISC_DBI_CHANGE_LOG_PKG.

Key Procedures and Functions

The documented package exposes fifteen subprograms spanning tolerance calculation, unshipped-quantity interrogation, backorder record insertion, printer assignment maintenance, inventory attribute management, DBI (Daily Business Intelligence) logging, group matching, and delivery/order attribute validation.

• GET_MIN_MAX_TOLERANCE_QUANTITY — Derives the minimum and maximum tolerance quantities applicable to shipping, typically sourced from shipping parameters or profile options.
• GET_UNTRXD_SHPG_LINES_COUNT — Returns a count of shipping lines that have not yet been transacted, supporting exception and reconciliation reporting.
• GET_NONINTF_SHPG_LINE_QTY — Retrieves the quantity of shipping lines that remain un-interfaced, used to determine what still requires processing.
• INS_BACKORDER_SS_SMC_REC — Inserts backorder records associated with the shipping/order-supply model context.
• UPDATE_PRINTER_ASSIGNMENT — Maintains the assignment of report printers used for shipping documents; references WSH_REPORT_PRINTERS.
• SET_INV_PC_ATTRIBUTES / GET_INV_PC_ATTRIBUTES — Write and read Inventory context attributes, supporting profile/client parameter-driven behavior during shipping processing.
• DBI_INSTALLED — Determines whether the Daily Business Intelligence change-log infrastructure is present so that DBI logging calls are conditionally executed.
• DBI_UPDATE_DETAIL_LOG / DBI_UPDATE_TRIP_STOP_LOG — Post change-log entries to the DBI repository for delivery detail and trip stop modifications respectively, via ISC_DBI_CHANGE_LOG_PKG.
• FIND_MATCHING_GROUPS — Identifies matching grouping values used when consolidating or assigning delivery content.
• GET_CANCEL_QTY_ALLOWED — Determines the permitted cancellation quantity for a shipment line, honoring shipping rules.
• GET_DELIVERY_DETAIL_ATTRIBUTES / UPDATE_DELIVERY_DETAILS — Read and update delivery detail records, including the attributes applied to each line.
• VALIDATE_OE_ATTRIBUTES — Validates Order Management sourced attributes before accepting them into the shipping execution flow.

Tables Accessed

The package operates against core Shipping Execution, Order Management, Purchasing, Inventory, and Receivables party tables through APPS synonyms:

• WSH_DELIVERY_DETAILS — Primary table for shippable line detail; read and updated by detail attribute and cancellation logic.
• WSH_DELIVERY_ASSIGNMENTS and WSH_DELIVERY_ASSIGNMENTS_V — Link delivery details to deliveries; used when resolving assignments and groupings.
• WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS, WSH_TRIP_STOPS, WSH_TRIPS — Support delivery and trip stop maintenance, including trip stop change logging.
• WSH_REPORT_PRINTERS — Backs printer assignment updates for shipping documentation.
• WSH_CARRIER_SERVICES — Supplies carrier service context for shipping validation.
• OE_ORDER_LINES_ALL and OE_ORDER_SOURCES — Provide order line and order source data used in OE attribute validation and backorder processing.
• PO_REQUISITION_LINES_ALL — Supports inbound/internal requisition-related shipping flows.
• MTL_INTERORG_PARAMETERS and MTL_CLIENT_PARAMETERS — Supply inter-organization and client-level parameters that influence tolerances, interfaces, and context attributes.
• HZ_PARTIES — Provides party/address context for shipment processing.
• DUAL — Used for scalar utility computations.

Usage Notes

WSH_INTEGRATION is an internal package invoked from other shipping constructs rather than from a dedicated Oracle Forms block or seeded concurrent program. It is referenced by approximately forty-seven other database objects, indicating it is called by WSH delivery creation logic, concurrent programs that process shipping lines, and related validation routines. Its DBI subprograms are guarded by DBI_INSTALLED so that change-log updates occur only when the DBI repository is configured. Because it is an OTHER-classified API, customizations should prefer documented public Shipping APIs; direct invocation of WSH_INTEGRATION procedures should be limited to extensions that require the exact internal behavior it provides. All calls execute with standard APPS schema privileges and rely on FND_API error handling and FND_MSG_PUB message stacking for consistent error propagation.