Results for “wsh_container_utilities”

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

Overview

WSH_CONTAINER_UTILITIES is a container-management utility package in the Oracle E-Business Suite Shipping (WSH) module. It belongs to the Applications (APPS) schema and carries an API classification of "OTHER", meaning it is an internal utility rather than a formally published open interface. The package centralizes reusable logic for Oracle Warehouse Management and Shipping container operations: identifying master containers within packing hierarchies, retrieving container names and serial numbers, estimating container requirements, validating hazard and hold information, and computing container utilization through the GET_FILL_PERCENT function. Its packaging under APPS allows it to be referenced directly by Oracle's seeded forms and concurrent programs without public synonyms or grants to individual users.

Key Procedures and Functions

The package exposes sixteen documented program units. Container identity handling is served by GET_MASTER_CONT_ID, which walks the delivery assignment hierarchy to derive a container's master container instance identifier, and GET_CONT_NAME, which returns the descriptive name of a container instance. GET_MASTER_CONT_SERIAL and GET_MASTER_SERIAL_NUMBER retrieve serial numbers for master containers, with VALIDATE_MASTER_SERIAL_NUMBER confirming the validity of a suggested serial before assignment. Capacity planning is handled by ESTIMATE_DETAIL_CONTAINERS and ESTIMATE_MASTER_CONTAINERS, which calculate container requirements at detail and master levels respectively. UPDATE_CHILD_CONTAINERS propagates changes through the child container tree. GET_FILL_PERCENT computes the utilization percentage of a container, the value most commonly sought by developers searching for this package. GET_DELIVERY_STATUS reports current delivery state for a container. Validation routines VALIDATE_HOLD_CODE, VALIDATE_HAZARD_CLASS, and VALIDATE_CONTAINER enforce data-integrity rules at the point of entry. IS_EMPTY determines whether a container currently holds any contents.

Tables Accessed

The package reads and writes through APPS synonyms for MTL_SYSTEM_ITEMS, WSH_CONTAINER_ITEMS, WSH_DELIVERY_ASSIGNMENTS, WSH_DELIVERY_DETAILS, WSH_NEW_DELIVERIES, and WSH_SHIPPING_PARAMETERS. WSH_DELIVERY_ASSIGNMENTS and WSH_DELIVERY_DETAILS form the packing hierarchy that GET_MASTER_CONT_ID traverses with a hierarchical CONNECT BY query; the documented header confirms this query starts at a delivery detail where the parent is null and type is 'S' or 'C'. WSH_CONTAINER_ITEMS stores item-level contents driving IS_EMPTY and fill-percentage calculations. MTL_SYSTEM_ITEMS supplies item attributes such as hazard information, while WSH_NEW_DELIVERIES and WSH_SHIPPING_PARAMETERS provide delivery state and shipping configuration data.

Usage Notes

Because the package is documented as referenced by ten other packages, it functions as a shared service layer invoked from Oracle's seeded shipping forms, packing and container concurrent programs, and custom PL/SQL extensions to the shipping flow. During the packing process, forms call the validation functions as users scan or assign containers, while estimation and fill-percent functions populate container capacity displays. In Oracle EBS 12.1.1 and 12.2.2, the implementation remains largely unchanged; the header comment indicates a last revision of 120.5 (2006). Custom code may call documented functions such as GET_FILL_PERCENT or GET_MASTER_CONT_ID directly, but because the package is classified as OTHER rather than a public API, Oracle does not guarantee backward compatibility, and exception handling should be defensive given that GET_MASTER_CONT_ID returns NULL when no master container exists above the given instance.