Search Results x_object_id

Overview

WMS_WP_PARAMETERS_LOV_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM repository as an "OTHER" API type. Its business function is to maintain the list-of-values (LOV) reference data that drives the Warehouse Management System (WMS) Work Plan parameter selection interface. Specifically, it manages the mapping between an object (such as a work plan object or business entity) and the parameters that can be associated with it, exposing object identifiers, object names, object descriptions, parameter identifiers, parameter names, and parameter descriptions. This metadata supports the runtime LOV pickers presented to users configuring WMS work plan parameters, ensuring that the underlying WMS_WP_PARAMETERS_LOV table remains consistent and queryable. The header comment ($Header: WMSPLTHB.pls 120.1.12010000.1 2009/03/25 ...) indicates the file was last revised in 2009 and is marked noship, meaning it is not shipped as a standalone patch object but is delivered as part of the broader WMS product family.

Key Procedures and Functions

The package exposes three documented procedures:

• INSERT_ROW — Inserts a new row into the LOV table, capturing the object identifier, object name, object description, parameter identifier, parameter name, and parameter description. It is the primary creation routine for new LOV entries.
• UPDATE_ROW — Modifies an existing row matched by parameter identifier. It overwrites object and parameter attributes. A NO_DATA_FOUND exception is raised if no row matches the supplied parameter identifier, guarding against silent no-op updates.
• LOAD_ROW — A higher-level seed/upsert routine. It first attempts to select the parameter identifier from the LOV table; if found, it delegates to UPDATE_ROW; if not found, the exception handler falls through to an insert path. This makes LOAD_ROW the appropriate entry point for data-loading or patching scenarios where the row may or may not already exist.

Tables Accessed

The package reads from and writes to a single documented table:

• WMS_WP_PARAMETERS_LOV (accessed through an APPS synonym) — the persistent store for the object-to-parameter LOV definitions. INSERT_ROW performs an insert; UPDATE_ROW performs an update keyed on parameter_id; LOAD_ROW performs a SELECT ... WHERE parameter_id = x_parameter_id to determine existence before branching to update or insert. The columns referenced are object_id, object_name, object_description, parameter_id, parameter_name, and parameter_description.

Usage Notes

Because LOAD_ROW provides upsert semantics, it is the procedure most likely invoked by concurrent programs, data-fix scripts, or product seed data loaders during implementation and patching. INSERT_ROW and UPDATE_ROW are lower-level routines that may be called directly by custom extensions or by internal WMS setup forms where the caller already knows whether the row exists. The package is referenced by zero other PL/SQL packages per the ETRM metadata, so its callers are external to the PL/SQL dependency graph — typically Oracle Forms LOV triggers, concurrent program definitions, or ad hoc SQL*Plus/ETRM correction scripts. The ETRM search term "x_object_id" corresponds directly to the first parameter of all three procedures, reflecting the object-centric key used to organize these LOV entries. When invoking UPDATE_ROW or LOAD_ROW, callers must ensure the parameter identifier matches an existing row; otherwise a NO_DATA_FOUND condition will propagate unless handled by the LOAD_ROW exception block. As the header date is 2009 and the file is noship, the object should be treated as legacy reference-data maintenance code that remains stable across EBS 12.1.1 and 12.2.2 unless Oracle has issued a superseding patch.