Search Results get_type_dist

Overview

WMS_CONTROL_BOARD is an Oracle Warehouse Management (WMS) PL/SQL package owned by the APPS schema and declared with AUTHID CURRENT_USER. It provides the server-side data retrieval and task manipulation logic that underpins the Warehouse Management Control Board, the central supervisory console used by warehouse supervisors and distribution personnel in Oracle E-Business Suite 12.1.1 and 12.2.2. The package is classified as OTHER, indicating a supporting library rather than a fully published public API.

The Control Board presents real-time visibility into dispatched warehouse tasks and exceptions, and WMS_CONTROL_BOARD supplies the aggregated query results that populate its performance charts and task views. The package header carries the revision marker $Header: WMSCBCPS.pls 120.1 2005/06/17, reflecting its long-standing role in the product. Within the package, PL/SQL record and table types such as cb_chart_status_rec_type, cb_chart_status_tbl_type, cb_chart_type_rec_type, and cb_chart_type_tbl_type are declared to carry task status and task type distribution data to the charting layer. Constants ln_null and lc_null support null-value handling in those result sets. The package header notes that the Control Board form was later split into separate task and exception views, after which the performance chart reuses the same form-level WHERE clause set through the query find window or by node selection in the trees.

Key Procedures and Functions

• GET_STATUS_DIST — Returns task status distribution data for the performance chart, along with a count of the returned data rows and a standard return status and message count. A header note records that a new input parameter was added under Bug #1800521 so the SQL would apply the same WHERE clause as the Control Board find window; a separate comment for Bug #2483984 documents performance tuning through separate FROM and WHERE clauses for active, pending, and completed tasks.
• GET_TYPE_DIST — Returns task type distribution data for the performance chart, complementing GET_STATUS_DIST.
• IS_STATUS_VALID — Validates whether a given task status value is recognized by the Control Board logic.
• LOCK_ROW — Applies row-level locking, supporting concurrent-safe updates during task manipulation.
• TASK_MANIPULATOR — Performs task-level manipulation operations against dispatched tasks, the core write path exposed by the package.

Tables Accessed

The package works against WMS_DISPATCHED_TASKS and WMS_DISPATCHED_TASKS_S, the dispatched-task entity and its synonym, which hold the warehouse tasks and exceptions displayed and manipulated on the Control Board. MTL_MATERIAL_TRANSACTIONS_TEMP and MTL_CYCLE_COUNT_ENTRIES are referenced for pending material transactions and cycle count activity associated with those tasks. DBMS_LOCK is used for locking, DBMS_SQL and PLITBLM support dynamic SQL and index-by-table handling, and DUAL is referenced for scalar evaluations.

Usage Notes

WMS_CONTROL_BOARD is invoked principally from the Warehouse Management Control Board form, which calls its chart distribution routines to render performance charts and its task manipulation routines to act on dispatched tasks. The behavior of the chart queries depends directly on the form-level WHERE clause derived from the find window or tree selection, so results are context-sensitive to the operator's current filter. The package is not documented as being referenced by other packages, and its procedures are intended for use by the shipped Control Board UI rather than as a general-purpose integration API. The header comment cited by a user searching for "shuttering boards distributor" appears in the $Header line of WMSCBCPS.pls and refers only to the source file revision history; it does not denote a distributor or board-related business function. Custom code should not depend on this package without regression testing across releases, given its internal classification.