Search Results update_master_serial_number




Overview
Explore in AI Chat

Overview

WSH_CONT_PKG is a PL/SQL package in the Oracle E-Business Suite Shipping (WSH) module, owned by the APPS schema and declared with AUTHID CURRENT_USER, which means its procedures execute with the privileges of the calling schema rather than the package owner. The package supports container and master serial number management within the shipping and delivery process. Its documented purpose centers on retrieving master container identifiers, validating and updating master serial numbers for containers associated with a delivery, and traversing child container hierarchies to propagate the correct master container and master serial number upward. The header comment ($Header: WSHCONTS.pls 115.5) indicates the file was originally ported and has been part of the shipping code line for many releases, consistent with its presence in both EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

  • GET_MASTER_CONTAINER — Returns the master container identifier and the associated master serial number for a given container. It accepts a container identifier and returns the master container ID and master serial number as output values.
  • CHECK_CHILD_CONTAINERS — Identifies all child containers belonging to a delivery and updates the master container ID and master serial number accordingly. It accepts a delivery ID, container ID, master container ID, and master serial number, and returns a status indicator.
  • VALIDATE_MASTER_SERIAL_NUMBER — A customizable API intended for validating the master serial number. Per the source comments, the default implementation always returns true (success); customers may customize it to enforce their own business validation rules. It accepts a delivery ID and container sequence number and returns a status.
  • UPDATE_MASTER_SERIAL_NUMBER — Updates the master serial number for a container within a delivery. It accepts the master serial number, container ID, and delivery ID, and returns a status indicating the outcome of the update.
  • GET_MASTER_SERIAL_NUMBER — Retrieves the master serial number associated with a given container sequence number and delivery ID, returning the value through an output parameter.

Tables Accessed

The package operates against WSH_PACKED_CONTAINERS (referenced through an APPS synonym). This table stores container and packed-item information for deliveries, including container identifiers, sequence numbers, and serial number attributes. The procedures read from this table to resolve master container relationships and serial numbers, and the update routines write the master serial number back to the appropriate container record.

Usage Notes

WSH_CONT_PKG is typically invoked from the Oracle Shipping forms (such as delivery and container maintenance windows) and from shipping-related concurrent programs or workflow activities that need to establish or refresh master container and serial number information. Because the package is not referenced by any other documented packages, it functions as a lower-level utility rather than a shared integration point. Custom code may call it directly when building shipping extensions, particularly the VALIDATE_MASTER_SERIAL_NUMBER hook, which is explicitly designed as a customization point for customer-specific serial number validation. Callers should supply the status output parameter and interpret non-zero values as failures in accordance with standard EBS API conventions.