Results for “update_contnr_int_assignments”

10 results




Overview
Explore in AI Chat

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

Overview

WSH_INTERFACE_COMMON_ACTIONS is an internal PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It provides the shared processing logic that converts rows staged in the Shipping open interface tables into confirmed Oracle Shipping execution data. The package is the common engine behind the delivery interface, driving the transformation of interface records into delivery headers, delivery details, delivery assignments, delivery legs, and freight cost records. The module header ($Header: WSHINCAB.pls 120.1, dated 2006/10/18) confirms its long-standing role within the WSH (Shipping) product family and its availability across both the 12.1.1 and 12.2.2 releases.

Because the delivery interface supports multiple submission paths — splits, non-splits, cancellations, packing, and trip creation — the package was designed to centralize the shared actions (locking, status updates, interface row processing, and conditional branching) rather than duplicating them across each concurrent program. This is why the ETRM classifies it as OTHER rather than as a public API: it is a supporting implementation package, not a supported external entry point.

Key Procedures and Functions

The twelve documented program units divide into four functional groups. The following list describes each by purpose; parameter lists are intentionally omitted.

  • PROCESS_INTERFACED_DELIVERIES — Processes delivery-level interface rows and creates or updates the corresponding delivery header records.
  • PROCESS_INTERFACED_DEL_DETAILS — Processes delivery detail interface rows, driving the creation of WSH_DELIVERY_DETAILS records and their assignment to deliveries.
  • PROCESS_SPLITS — Handles the split-mode path of the interface, where incoming lines must be distributed across multiple deliveries.
  • PROCESS_NON_SPLITS — Handles the non-split path, where lines consolidate onto a single delivery per interface grouping. The two split-related cursors declared in the package body feed both procedures.
  • PROCESS_CANCEL — Executes cancellation logic against deliveries and details identified in the interface, supporting the CANCEL interface action code.
  • PACK_LINES — Applies packing behavior to interface lines, including LPN and container-related processing.
  • UPDATE_CONTNR_INT_ASSIGNMENTS — Updates container assignment information held in the interface, reconciling container-to-detail relationships.
  • DELIVERY_INTERFACE_WRAPPER — Provides a wrapper entry point that orchestrates the interface processing sequence.
  • PROCESS_INT_FREIGHT_COSTS — Processes freight cost interface rows into the shipping freight cost tables.
  • CREATE_UPDATE_TRIP_FOR_DLVY — Creates or updates a trip record associated with the delivery being processed.
  • INT_TRIP_STOP_INFO — Derives and populates trip stop information from the interface data.
  • LOCK_DELIVERY_AND_DETAILS — Acquires locks on delivery and delivery detail rows to serialize concurrent interface processing and prevent update conflicts.

Tables Accessed

The package reads and writes the Shipping interface and execution tables that constitute the delivery interface data model. Interface tables include WSH_DEL_DETAILS_INTERFACE, WSH_DEL_ASSGN_INTERFACE, WSH_DEL_LEGS_INTERFACE, WSH_DEL_LEGS_INTERFACE_S, and WSH_FREIGHT_COSTS_INTERFACE. Execution tables include WSH_DELIVERY_DETAILS, WSH_DELIVERY_ASSIGNMENTS, WSH_DELIVERY_LEGS, and WSH_FREIGHT_COST_TYPES. Supporting lookups include WSH_CARRIER_SERVICES for carrier and service validation. Setup and reference data are drawn from HR_ORGANIZATION_INFORMATION (inventory organization attributes), MTL_SYSTEM_ITEMS (item validation), OE_ORDER_LINES_ALL (order line linkage), and PO_REQUISITION_HEADERS_ALL with PO_REQUISITION_LINES_ALL (requisition-sourced demand). All references resolve through APPS synonyms.

Usage Notes

WSH_INTERFACE_COMMON_ACTIONS is normally invoked indirectly. A user or process populates the WSH interface tables, then submits the Oracle Shipping delivery interface concurrent programs, which call this package to perform the actual update. It can also be reached through the Shipping Transactions form when interface actions are requested from the user interface, and it is referenced by six other packages in the WSH and shipping-adjacent codebase. The search term "update_delivery_details" reflects the update operations this package performs against WSH_DELIVERY_DETAILS during interface processing. Because the package is not a documented public API, direct custom invocation is discouraged; integrators should populate the interface tables and let the standard concurrent programs invoke this logic. Its cursors and lock procedure make it sensitive to concurrent execution, so custom callers must avoid running interface processing in parallel for the same delivery.