Search Results get_master_container

Overview

WSH_CONT_PKG is a shipping-execution package in the Oracle E-Business Suite WSH (Shipping) module. Its business function is to resolve and maintain the relationship between packed containers and their designated "master" container within a hierarchical packing structure. In Oracle EBS shipping, a container may itself be packed inside another container, producing a multi-level parent/child hierarchy recorded in the WSH_PACKED_CONTAINERS table through the PARENT_CONTAINER_ID column. The package walks that hierarchy — both upward toward the topmost (master) container and downward toward all subordinate (child) containers — so that the master container identifier and master serial number are propagated consistently to every container belonging to the same shipping unit. This enables downstream shipping documents, labels, and manifest reporting to reference a single controlling container rather than an intermediate level of the nest.

Key Procedures and Functions

The documented package exposes five procedures and functions:

• GET_MASTER_CONTAINER — Accepts a container identifier and returns the master container identifier and master serial number. It uses a hierarchical query rooted at the supplied container, restricting the result set to rows where PARENT_CONTAINER_ID IS NULL, thereby locating the top of the packing hierarchy by walking upward with a CONNECT BY PRIOR clause.
• CHECK_CHILD_CONTAINERS — Identifies every child container beneath a given container using a downward hierarchical traversal and updates those rows in WSH_PACKED_CONTAINERS with the master container identifier and master serial number. A status out parameter signals the outcome of the operation.
• VALIDATE_MASTER_SERIAL_NUMBER — Performs validation of a master serial number, confirming that the value is consistent or acceptable for the container structure before it is committed.
• UPDATE_MASTER_SERIAL_NUMBER — Writes or refreshes the master serial number associated with the containers being processed, keeping the stored value synchronized with the resolved master container.
• GET_MASTER_SERIAL_NUMBER — Returns the master serial number, allowing callers to retrieve the value without performing the full container-resolution sequence.

Tables Accessed

The package operates against a single documented table, WSH_PACKED_CONTAINERS, referenced through its APPS synonym. This table stores the packing hierarchy and is the source of truth for both the parent-child linkage (PARENT_CONTAINER_ID) and the master attributes (MASTER_CONTAINER_ID and MASTER_SERIAL_NUMBER). GET_MASTER_CONTAINER reads the table to resolve the topmost container; CHECK_CHILD_CONTAINERS both reads (to enumerate children) and writes (to stamp master values onto each child row). No other tables are documented as referenced.

Usage Notes

WSH_CONT_PKG is an internal shipping utility rather than a public API — the ETRM classification is OTHER, and no other packages are documented as referencing it. It is typically invoked from shipping forms and concurrent programs that process delivery packing, container packing, and manifest generation, and from custom extensions that need to determine which container heads a packing hierarchy. Because the procedures resolve master identifiers by traversing the container tree, callers should invoke them after the hierarchy has been established and before labels or shipping documents are produced. The header comment indicates an original copyright of 1999 (WSHCONTB.pls), reflecting long-standing stability across EBS releases. When customizing, developers should be aware that the resolution logic depends on PARENT_CONTAINER_ID being NULL at the true root; any data condition violating that assumption will cause the master lookup to return an incorrect or empty result.