Results for “wma_inv_wrappers”

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

Overview

The APPS.WMA_INV_WRAPPERS package is an Oracle E-Business Suite PL/SQL wrapper package that bridges the Oracle Warehouse Management (WMS) and Work in Process (WIP) subsystems with core Oracle Inventory functionality. Its primary business function is to encapsulate low-level inventory and lot-handling operations behind a stable application programming interface, allowing warehouse management components to create lots, manage LPN (License Plate Number) containers, perform backflush transactions, and synchronize WIP completion data without directly calling the underlying Inventory APIs. The package holds a status of VALID in the ETRM registry for release 12.1.1 and 12.2.2, and is classified as an OTHER API. It is referenced by both itself and the WMS_WIP_INTEGRATION package, and in turn depends on the SYS STANDARD package, confirming its role as a thin integration wrapper rather than a full business-logic engine.

Key Procedures and Functions

ETRM documents twelve callable objects within the package. Their intended purposes are:

• VALIDATELOT — Performs validation of lot number data prior to insertion or update, ensuring consistency with Inventory lot rules.
• INSERTLOT — Creates a new lot record in the Inventory lot repository.
• UPDATELSATTRIBUTES — Updates lot/serial attribute values associated with an existing lot.
• BACKFLUSH — Executes backflush component issue logic, consuming component inventory against a WIP job or schedule.
• CREATELPN — Creates a new License Plate Number, establishing the LPN container record used in warehouse operations.
• PACKLPNCONTAINER — Packs contents into an existing LPN container, building the containment hierarchy.
• PACKSERIALS — Assigns and packs serial numbers into the appropriate LPN or completion records.
• CREATEMO — Creates the manufacturing/WIP move order or job record that drives production flow.
• OKMOLINES — Confirms or processes the lines of a move order, completing the associated transaction steps.
• UPDATELPNCONTEXT — Updates the contextual attributes or status of an LPN after packing or movement.
• TRANSFERRESERVATION — Moves an existing inventory reservation from one demand or location context to another.
• CLEARQTYTREES — Clears quantity tree (on-hand quantity aggregation) records to keep inventory balances consistent after the wrapper operations.

Tables Accessed

The package reads and writes the following tables, resolved through APPS synonyms:

• MTL_LOT_NUMBERS — Stores lot number definitions; populated by INSERTLOT and validated by VALIDATELOT.
• WIP_LPN_COMPLETIONS — Holds LPN completion records for WIP jobs; written during LPN creation and packing.
• WIP_LPN_COMPLETIONS_LOTS — Associates lots with WIP LPN completions; maintained by lot packing operations.
• WIP_LPN_COMPLETIONS_SERIALS — Associates serial numbers with WIP LPN completions; used by PACKSERIALS.
• WMS_LICENSE_PLATE_NUMBERS — The master LPN repository in WMS; the target of CREATELPN and UPDATELPNCONTEXT.

Usage Notes

WMA_INV_WRAPPERS is intended to be invoked indirectly rather than interactively by end users. Its principal documented caller is WMS_WIP_INTEGRATION, which drives WMS-to-WIP completion and packing flows; because the package is also self-referencing, some procedures call one another internally to sequence lot, LPN, and reservation steps. It is typically reached from Oracle Warehouse Management mobile and desktop forms, WIP completion concurrent programs, and integration routines that need atomic lot/LPN creation with consistent quantity tree maintenance. Custom code should call these wrappers rather than the underlying Inventory or WMS APIs directly, since the wrappers enforce the sequencing and validation required by the WIP/LPN data model. No explicit parameter lists are published in the ETRM metadata, so callers should inspect the package specification in the APPS schema before coding direct invocations.