Search Results wms_container_pvt




Overview
Explore in AI Chat

Overview

WMS_DATA_TYPE_DEFINITIONS_PUB is a public PL/SQL package in the APPS schema that belongs to the Oracle Warehouse Management (WMS) module of Oracle E-Business Suite. Its role is to centralize and expose the data type definitions used throughout the WMS container and logistics APIs. In Oracle EBS 12.1.1 and 12.2.2, WMS functionality relies on strongly typed PL/SQL records and collections to pass structured container, LPN (License Plate Number), and delivery information between public APIs, private implementation packages, and group-layer utilities. WMS_DATA_TYPE_DEFINITIONS_PUB acts as the shared definition repository that allows these packages to exchange data consistently.

The package is classified as a PUB object, meaning it is part of the supported public API surface exposed to integrators and customizations. Its documented status is VALID, confirming that the compiled package is present and usable in the ETRM 12.2.2 environment. The package is widely referenced across the WMS and shipping stack, which underscores its foundational, cross-cutting nature.

Key Procedures and Functions

The ETRM metadata documents zero stored procedures or functions within WMS_DATA_TYPE_DEFINITIONS_PUB. This indicates that the package is primarily a container for type and record declarations rather than a procedural API. Such packages exist to define shared PL/SQL record structures and collection types that other packages reference in their own parameter lists and internal logic. Because no callable subprograms are documented, the package does not perform transactional business logic itself; its value is realized at compile time by the dependent packages that import its type definitions.

Tables Accessed

The documented metadata does not list any tables referenced via APPS synonyms. This is consistent with a definitions-only package, which typically contains no SQL statements beyond those required for package initialization. As a result, WMS_DATA_TYPE_DEFINITIONS_PUB does not directly read from or write to WMS or WSH base tables. All data access occurs in the packages that depend upon it, such as WMS_CONTAINER_PUB, WMS_CONTAINER_PVT, and WMS_CROSS_DOCK_PVT.

Usage Notes

WMS_DATA_TYPE_DEFINITIONS_PUB is referenced by at least fourteen dependent packages, demonstrating its central position in the WMS architecture. The documented dependents include WMS_CONTAINER_PUB, which is the public container API; WMS_CONTAINER_PVT and WMS_CONTAINER_GRP, which implement private container logic and group-layer processing; WMS_CROSS_DOCK_PVT and WMS_DIRECT_SHIP_PVT, which support cross-docking and direct shipping flows; WMS_PURGE_PVT, which handles container data purging; and WSH packages including WSH_CONTAINER_ACTIONS, WSH_DELIVERY_DETAILS_GRP, WSH_LPN_SYNC_COMM_PKG, WSH_PURGE, and WSH_UTIL_CORE, along with INV_SHIPPING_TRANSACTION_PUB.

A user searching for "wms_container_pvt" will encounter this package because WMS_CONTAINER_PVT is one of its documented dependents. Custom code extending container or LPN functionality should reference these shared types rather than redefining them, ensuring compatibility with Oracle's public APIs. The package is not invoked directly through forms or concurrent programs; instead, it is resolved at compile time whenever dependent packages are compiled or customized. Developers should treat it as read-only infrastructure and avoid modifications, as changes to its type definitions would invalidate the many dependent packages across the WMS and WSH modules.