Search Results adjust_parent_wv

Overview

The APPS.WSH_WV_UTILS package body is a core weight-and-volume calculation utility within the Oracle E-Business Suite Shipping Execution (WSH) module. Its principal business function is to compute, store, and maintain the weight and volume attributes associated with deliveries, delivery details, containers (LICs/LPNs), and trips. These calculations drive carrier selection, freight rating, load planning, and regulatory compliance across outbound logistics. The package is classified as an "OTHER" API and holds a VALID status in the APPS schema in both 12.1.1 and 12.2.2.

The package is heavily integrated: it references foundational APIs such as FND_API, FND_GLOBAL, FND_MESSAGE, and FND_PROFILE, unit conversion through INV_CONVERT, and multiple Shipping Execution internals including WSH_UTIL_CORE, WSH_UTIL_VALIDATE, WSH_TPA_CONTAINER_PKG, and WSH_LPN_SYNC_COMM_PKG. It is referenced by 61 other database objects, indicating it is a widely consumed utility rather than a standalone entry point.

Key Procedures and Functions

The documented API surface comprises 20 procedures and functions. Their purposes are as follows:

• CONVERT_UOM / CONVERT_UOM_CORE — Convert weight and volume values between units of measure, with the core routine providing the underlying conversion logic.
• GET_DEFAULT_UOMS — Retrieve the default unit-of-measure values applicable to weight and volume processing.
• DETAIL_WEIGHT_VOLUME — Calculate weight and volume at the delivery detail line level.
• ADD_CONTAINER_WT_VOL / UPDATE_CONTAINER_WT_VOL — Add or update the weight and volume contributions of a container.
• CONTAINER_WEIGHT_VOLUME — Compute total weight and volume of a container, including contents.
• CONTAINER_TARE_WEIGHT_SELF — Determine the tare (empty) weight of a container itself.
• CALC_CONT_FILL_PC / CHECK_FILL_PC — Calculate and validate the container fill percentage against thresholds.
• DELIVERY_WEIGHT_VOLUME — Aggregate weight and volume for an entire delivery.
• DD_WV_POST_PROCESS / DEL_WV_POST_PROCESS — Post-process routines for delivery-detail and delivery-level weight/volume updates.
• ADJUST_PARENT_WV — Recalculate and adjust parent container or delivery weight/volume after child changes.
• WITHIN_DEVIATION — Test whether a computed value falls within an acceptable tolerance/deviation band.
• PRORATE_WEIGHT — Distribute weight proportionally across lines or containers.

Tables Accessed

The package reads and writes several core Shipping and Inventory tables via APPS synonyms. Item master and UOM data are sourced from MTL_SYSTEM_ITEMS and MTL_UNITS_OF_MEASURE to determine item weights and valid conversions. Delivery structure and content are read from WSH_DELIVERY_DETAILS, WSH_DELIVERY_ASSIGNMENTS, WSH_NEW_DELIVERIES, and WSH_DELIVERY_LEGS. Trip information is obtained from WSH_TRIP_STOPS, and configuration defaults from WSH_SHIPPING_PARAMETERS. The PLITBLM table (a PL/SQL table global) is referenced for internal collection handling.

Usage Notes

WSH_WV_UTILS is typically invoked indirectly by Shipping Execution forms, actions, and concurrent programs rather than called directly by end users. The container and delivery actions (WSH_DELIVERY_LEGS_ACTIONS, WSH_NEW_DELIVERY_ACTIONS, WSH_TRIPS_ACTIONS) trigger weight/volume recomputation through its routines. The DD_WV_POST_PROCESS and DEL_WV_POST_PROCESS procedures are the standard hooks for propagating weight and volume changes after delivery updates. Because it is referenced by 61 objects and exposes no public API classification, customizations should call it only through documented higher-level Shipping Execution APIs; direct modification is unsupported and may be overwritten during patching. All profiling and debugging leverage WSH_DEBUG_SV and WSH_DEBUG_INTERFACE, enabling trace output when diagnosing weight/volume discrepancies.