Search Results create_containers

Overview

WSH_CONTAINER_GRP is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified as a Group (GRP) API within Oracle's Warehouse Management and Shipping execution module. Its principal business function is the creation, maintenance, and packing of containers (also referred to as License Plate Numbers, or LPNs) associated with outbound delivery transactions. Containers represent the physical handling units — pallets, cartons, totes, and similar packaging — into which delivery lines are packed prior to shipment. The package provides the programmatic surface through which Oracle Shipping and Oracle Warehouse Management create container records, update existing containers, automatically pack delivery details into containers, and perform discrete container actions such as packing, unpacking, and closing. Because it is a GRP-type API, it is intended to be called by other Oracle application packages and public APIs rather than being directly bound to a form's user interface.

Key Procedures and Functions

The ETRM metadata documents four procedures or functions within this package:

• CREATE_CONTAINERS — Creates one or more container records. It is the primary entry point for establishing the container (LPN) definition that will subsequently be associated with delivery details and items.
• UPDATE_CONTAINER — Modifies attributes of an existing container, allowing changes to be applied to a container record after its initial creation.
• AUTO_PACK — Performs automated packing of delivery details into containers according to the packing rules and item relationships configured in the system, eliminating the need for manual packing of individual lines.
• CONTAINER_ACTIONS — Executes discrete actions against a container, supporting operations such as packing, unpacking, and status transitions that change the container's handling state.

No parameter lists are documented in the ETRM metadata; callers should consult the package specification in the target instance for exact signatures.

Tables Accessed

The package accesses the following tables through APPS synonyms:

• WSH_DELIVERY_ASSIGNMENTS — Associates delivery details with deliveries, providing the assignment context required when packing or auto-packing container contents.
• WSH_DELIVERY_DETAILS — Holds the individual delivery lines and items that are packed into containers; this is the primary source of packable content.
• WSH_NEW_DELIVERIES — Stores delivery header information, linking containers to the outbound delivery they support.
• PLITBLM — A PL/SQL index-by table used for bulk processing of container and delivery detail identifiers.

Usage Notes

WSH_CONTAINER_GRP is typically invoked indirectly through higher-level Oracle APIs rather than called directly by end users. The ETRM dependency report shows it is referenced by six packages, including INV_LPN_TRX_PUB and INV_TRANSFER_ORDER_PVT in Oracle Inventory, WMS_CONTAINER_PUB and WMS_DIRECT_SHIP_PVT in Oracle Warehouse Management, and WSH_DELIVERIES_GRP and WSH_DELIVERY_DETAILS_GRP within Oracle Shipping. It in turn depends on FND_API and FND_FLEX_EXT for the standard API framework and descriptive flexfield handling, and on WSH_INTERFACE and WSH_UTIL_CORE for shipping interface and utility routines. Custom code that must create, update, or pack containers should generally call these higher-level public APIs (for example, WMS_CONTAINER_PUB) rather than this GRP package directly, to preserve validation and standard API behavior. Because it is an internal shipping group API, the package is supported in both EBS 12.1.1 and 12.2.2, and its behavior is consistent with the Oracle Shipping execution model across those releases.