Search Results wms_parameter_ext




Overview
Explore in AI Chat

Overview

The package body APPS.WMS_PARAMETER_EXT is a customization and extension utility within the Oracle Warehouse Management (WMS) module of Oracle E-Business Suite. Its documented status is VALID and it is owned by the APPS schema, with an API classification of OTHER. The package is designed to provide extended parameter and query capabilities that are not delivered by the standard Warehouse Management parameter packaging. It complements the seeded package APPS.WMS_PARAMETER_PVT, on which it depends, by exposing additional helper routines that resolve header, line, item, and License Plate Number (LPN) related values for use by WMS transactional and inquiry flows.

In practice, WMS_PARAMETER_EXT acts as a supporting layer for LPN handling, on-hand quantity retrieval, and lot/version resolution, which are core requirements of warehouse execution screens, label printing, shipping, and receiving. Because it is an extension package, it is typically present alongside customer or Oracle-supplied customizations that call into WMS transactional APIs.

Key Procedures and Functions

The ETRM metadata documents ten procedures and functions within this package body:

  • GETPOHEADERLINEIDWRAP — Resolves or wraps the purchase order header and line identifier, allowing WMS logic to reference the originating PO context.
  • GETSOHEADERLINEIDWRAP — Returns the corresponding sales order header and line identifier, supporting outbound and shipping transactions that must link back to the sales order.
  • GETITEMONHANDWRAP — Retrieves the on-hand quantity for an item, typically used to validate availability during picking, put-away, or inventory inquiry.
  • TRACE — Provides a diagnostic or logging utility used to record execution flow and aid troubleshooting within WMS extension logic.
  • GETNUMOTHERLOTSWRAP — Returns the count of other lots associated with an item or LPN context, useful in lot control and allocation decisions.
  • GETLPNQUANTITYREVLOT — Returns LPN quantity per revision and lot, supporting revision-controlled and lot-controlled inventory.
  • GETLPNTOTALQUANTITY — Returns the total quantity contained within an LPN.
  • GETLPNNUMOFITEMS — Returns the number of distinct items within an LPN.
  • GETLPNNUMOFREVS — Returns the number of revisions represented within an LPN.
  • GETLPNNUMOFLOTS — Returns the number of lots contained within an LPN.

Together these routines form a query toolkit for interrogating LPN contents and order references without directly querying base tables from calling code.

Tables Accessed

The package references several Oracle base tables through APPS synonyms:

It also depends on standard utilities including FND_API, FND_MESSAGE, FND_MSG_PUB, FND_PROFILE, INV_CONVERT, and INV_LOG_UTIL, indicating message handling, profile lookup, UOM conversion, and logging support.

Usage Notes

WMS_PARAMETER_EXT is not referenced by any other database object, confirming its role as a leaf-level extension utility rather than a shared dependency. It is typically invoked from custom WMS forms, concurrent programs, label/report logic, or tailored transactional flows that require LPN content counts, on-hand checks, or order line mappings. It is not called by Oracle-seeded packages; therefore it functions as a customer-side or supplemental helper library. Because the object resides in the APPS schema and is VALID in both 12.1.1 and 12.2.2, standard patching and editioning considerations apply, and any customization referencing it should treat it as an extension point rather than core Warehouse Management functionality.