Search Results is_wcs_enabled

Overview

APPS.WMS_DEVICES_PKG is the primary PL/SQL API governing device definitions in the Oracle E-Business Suite Warehouse Management System (WMS). It encapsulates the data manipulation logic for the WMS_DEVICES base and translation tables, providing a controlled interface through which wireless terminals, barcode scanners, radio-frequency (RF) devices, and other shop-floor hardware are registered, configured, maintained, and retired within a WMS-enabled organization. The package is declared AUTHID CURRENT_USER, meaning its SQL executes with the privileges of the calling schema — typically APPS — rather than as a definer-rights unit.

The package carries a version banner of 120.1 with a 2005 header, indicating that it is a mature, long-lived component that has been carried forward intact into EBS 12.1.1 and 12.2.2. Its procedures operate on the translated (TL) and base (B) table pattern, and they expose configuration attributes that determine how a device connects, authenticates, and behaves during warehouse transactions — including physical output routing, lot/serial handling, batch limits, subinventory restriction, locator restriction, sign-on enforcement, multi-sign-on behavior, and message templates. The ETRM classification is OTHER, reflecting that this is an internal API rather than a fully published public interface.

Key Procedures and Functions

The ETRM metadata documents seven callable units. The principal DML procedures are:

• INSERT_ROW — Creates a new device definition. It accepts a very wide parameter set covering the device identity, type, enabled flag, lot/serial capability, input and output method identifiers, batch limit, physical output directory and file prefix conventions, subinventory and locator scope, organization context, the full descriptive flexfield attribute columns, name and description, device model, notification and force-sign-on flags, multi-sign-on flag, and a message template identifier. It returns the generated ROWID.
• UPDATE_ROW — Modifies an existing device record, applying the same attribute surface as INSERT_ROW against the identified device.
• DELETE_ROW — Removes a device definition from the repository.
• LOCK_ROW — Acquires a pessimistic lock on a device row using the same identifying and version-checking attributes, protecting against concurrent modification during a form-based edit.
• ADD_LANGUAGE — Inserts or maintains the translated NAME and DESCRIPTION rows in the TL table for a given language, supporting multilingual device naming.
• IS_WCS_ENABLED — A function that reports whether Warehouse Control System (WCS) integration is enabled for the applicable context. This is the object the user's keyword search targeted.
• IS_DEVICE_MULTISIGNON — A function that reports whether a given device is configured to permit multiple concurrent sign-ons, allowing callers to branch behavior such as session management and operator authentication.

Tables Accessed

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

• WMS_DEVICES_B — The base table holding the non-translatable device configuration attributes described above.
• WMS_DEVICES_TL — The translation table holding language-specific NAME and DESCRIPTION values, maintained by ADD_LANGUAGE and the DML routines.
• MTL_PARAMETERS — The inventory organization parameters table, consulted for organization-level defaults and validation context during insert, update, and enablement checks.
• FND_LANGUAGES — The installed language registry, used by ADD_LANGUAGE to determine valid language codes and to propagate translations.

Usage Notes

WMS_DEVICES_PKG is historically invoked from the Oracle Warehouse Management device setup forms, where the DML procedures back the block-level insert, update, delete, and lock operations. Because the package is referenced by two other packages, it also serves as a dependency for higher-level WMS runtime components — notably the code paths that evaluate WCS enablement and multi-sign-on status at transaction execution time.

In customizations, the most common direct call is to the IS_WCS_ENABLED and IS_DEVICE_MULTISIGNON functions, which provide a supported way to query configuration without reading the tables directly. Custom integrations that create or maintain device records should prefer INSERT_ROW, UPDATE_ROW, and DELETE_ROW so that audit columns, translations, and validation logic remain consistent. Note the AUTHID CURRENT_USER declaration: any schema granted EXECUTE on this package must also hold the necessary object privileges on the underlying WMS and MTL synonyms.