Results for “wms_packing_workbench_pvt”

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

Overview

WMS_PACKING_WORKBENCH_PVT is a private (PVT-classified) PL/SQL package owned by the APPS schema in Oracle E-Business Suite, shipped under the Warehouse Management System (WMS) module. It underpins the Packing Workbench, the user interface through which warehouse operators perform pack, split, and unpack operations against inbound move order lines and outbound delivery detail lines. The package's header comment explicitly states its central purpose: it queries eligible material for these transactions and, once results are found, populates the global temporary table WMS_PACKING_MATERIAL_GTEMP for display in the workbench UI. Because the package is classified PVT, it is an internal implementation layer — invoked by the workbench forms and related internal callers rather than invoked directly as a public API. The header additionally records a 2012 revision (120.3.12020000.1) carrying "INVCONV" (inventory unit-of-measure conversion) enhancements, reflected in secondary UOM and secondary quantity attributes on its record types.

Key Procedures and Functions

The documented interface comprises eleven programs. Their purpose, drawn from the package's transactional role, is as follows:

• CREATE_TXN — Creates a packing (or split/unpack) transaction record, using the type definitions and global temp structures to stage the transaction for processing.
• DELETE_TXN — Removes a staged or erroneously created transaction, supporting correction of workbench entries.
• PROCESS_TXN — Drives the actual processing of a staged transaction, transforming workbench activity into the underlying inventory/delivery transaction records.
• FIRM_DELIVERY — Firms an outbound delivery as part of the packing flow, committing packed contents to the delivery for shipping.
• GET_KITTING_INFO — Retrieves kit (top model / component) information so the workbench can present and manage kits being packed.
• IS_KIT_IDENTIFIED — Determines whether a kit has already been identified, used to control kit handling logic during packing.
• IS_ITEM_UNIQUE_EXISTING_KIT — Checks whether an item corresponds to a unique existing kit, supporting kit validation before pack operations.
• ISSUE_SAVEPOINT / ISSUE_ROLLBACK / ISSUE_COMMIT — Transactional control programs that establish a savepoint, roll back to it on failure, or commit on success, ensuring atomicity of the packing transaction. The pairing of rollback and commit confirms error-handling design within the package.
• TO — A utility name recorded in the metadata, reflecting the package's record-to-table conversion helper functions.

Tables Accessed

Through APPS synonyms, the package reads and writes across several functional areas. Inventory and transaction tables include MTL_MATERIAL_TRANSACTIONS_S and MTL_MATERIAL_TRANSACTIONS_TEMP (staging the created transactions), MTL_TXN_REQUEST_LINES (inbound move order lines queried for pack eligibility), MT L_SERIAL_NUMBERS and MTL_SERIAL_NUMBERS_TEMP, MTL_LOT_NUMBERS, and MTL_TRANSACTION_LOTS_TEMP (serial and lot control), plus MTL_SYSTEM_ITEMS_KFV for item validation and OE_SETS for kit/order-set context. Outbound flows draw on OE_ORDER_HEADERS_ALL, OE_ORDER_LINES_ALL, and PA_PROJECTS for delivery and project-referenced packing. Location data is resolved via HR_LOCATIONS_ALL, HZ_LOCATIONS, and HZ_PARTIES.

Usage Notes

This package is invoked indirectly by the Packing Workbench forms during pack, split, unpack, and delivery-firming operations; it is not a documented standalone public API and, per the metadata, is referenced by zero other packages. Customizations or diagnostics should therefore not call it directly without recognizing the PVT designation and its transactional dependencies. The search phrase "workbench with sepos 202" points to Oracle support behavior during workbench packing; because no other package references this unit, integration issues surface through workbench forms or related WMS internal callers rather than external package dependencies.