Search Results wms_wp_parameters_lov_pkg

Overview

WMS_WP_PARAMETERS_LOV_PKG is an Oracle Application Object Library package owned by the APPS schema in Oracle E-Business Suite. The suffix "LOV" indicates that it supports a List of Values mechanism, while the "WP" prefix associates it with Warehouse Management work planning functionality. The package provides the data-loading and maintenance interface for the WMS_WP_PARAMETERS_LOV table, which stores the object and parameter definitions presented to users when selecting work plan parameters. Its source header comment ($Header: WMSPLTHS.pls 120.1.12010000.1 2009/03/25) confirms that it is a seed-data loader script rather than a transactional API. The package is declared AUTHID CURRENT_USER, so it executes with the privilege set of the calling user rather than the definer. Documented procedures total three: INSERT_ROW, UPDATE_ROW, and LOAD_ROW.

Key Procedures and Functions

• INSERT_ROW — Inserts a single row into the WMS_WP_PARAMETERS_LOV table. It accepts both object-level attributes (object identifier, name, and description) and parameter-level attributes (parameter identifier, name, and description), allowing one combination of object and parameter to be registered as an LOV entry.
• UPDATE_ROW — Updates an existing row in the same table. It mirrors the INSERT_ROW signature, taking object identifier, object name, object description, parameter identifier, parameter name, and parameter description, and applies the supplied values to the matching record.
• LOAD_ROW — Performs the standard Oracle seed-data load operation. It accepts the identical set of six arguments as the other two procedures and is designed to insert the row when it does not exist or update it when it does, providing idempotent behavior suitable for repeated patch and upgrade runs.

All three procedures share the same parameter profile; no additional parameters are documented, and none should be assumed.

Tables Accessed

The only documented table referenced by this package is WMS_WP_PARAMETERS_LOV, accessed through an APPS synonym. The package writes to this table through its insert and update procedures and reads from it during LOAD_ROW's existence check. The table stores the object/parameter pairings that populate the parameter LOV used in the Warehouse Management work planning configuration. Because the package exists solely to maintain seed rows in this single table, it does not participate in broader WMS transactional processing or integration flows.

Usage Notes

Packages of this pattern are invoked almost exclusively during installation, patching, and upgrade events. Oracle's seed-data loader framework calls LOAD_ROW repeatedly to establish or refresh the baseline LOV contents, while INSERT_ROW and UPDATE_ROW serve as the underlying primitives that the loader or a targeted fix script can call directly. The package is not exposed through a standard concurrent program and is not referenced by other documented packages, so it has no downstream callers within the ETRM inventory. Customizations that add or modify work plan parameter LOV entries should emulate the same idempotent approach, preferring LOAD_ROW over direct INSERT_ROW/UPDATE_ROW calls, and should be re-validated against the 12.1.1 and 12.2.2 file system and database editions since the object is delivered as an APPS-owned seed loader rather than a supported public API.