Search Results ieu_wp_param_defs_b_s1

Overview

APPS.IEU_WORKPANEL_PVT is a private (PVT) PL/SQL package body within the Oracle E-Business Suite Interaction Center / Universal Work Queue (UWQ) technology stack. It implements the server-side business logic that drives the Work Panel, the configurable agent-facing region that presents actions, parameters, and parameter sets associated with a work item, interaction, or node. The package is registered as VALID and belongs to the APPS schema; its private designation indicates it is an implementation package whose callable interface is intended to be exercised through companion public packages and the declarative metadata that configures the Work Panel runtime.

Functionally, IEU_WORKPANEL_PVT provides the plumbing required to define, validate, and maintain the metadata that describes Work Panel actions. This includes the migration of action definitions (termed "mactions" or mapped actions), the management of parameter definitions, parameter properties, and parameter sets, and the ordering and labeling logic used to render those parameters correctly to the agent. Because the package is not referenced by any other database object, it acts as a leaf implementation unit invoked at runtime rather than as a shared utility.

Key Procedures and Functions

The package exposes twenty documented procedures and functions, spanning validation, DML maintenance, and configuration utilities:

• VALIDATE_ACTION and VALIDATE_ACTION_LABEL — verify the integrity and labeling of an action definition before it is persisted or presented.
• VALIDATE_PARAMETER — checks parameter definitions for correctness against the parameter metadata model.
• CREATE_MACTION, CREATE_MACTION2, UPDATE_MACTION, DELETE_MACTION — the lifecycle operations for mapped action definitions.
• CREATE_PARAM_DEFS, UPDATE_PARAM_DEFS, DELETE_PARAMETER — maintain parameter definition records.
• CREATE_PARAM_PROPS, UPDATE_PARAM_PROPS, UPDATE_COLUMN_PROPS — manage properties governing parameter rendering and column behavior.
• CREATE_FROM_ACTION, CREATE_FROM_FILTER — derive Work Panel configuration from an existing action or filter definition.
• MAP_ACTION and DELETE_ACTION_FROM_NODE — associate or disassociate actions with Work Panel nodes.
• UPDATE_DATA_TYPE and UPDATE_MULTI_SELECT_FLAG — adjust the data type and multi-select behavior of parameters.
• PARAM_REORDERING — maintains the display sequence of parameters within a set.

Tables Accessed

The package reads and writes the Work Panel configuration tables through APPS synonyms. Parameter-set data is held in IEU_WP_ACT_PARAM_SETS_B and its translation table IEU_WP_ACT_PARAM_SETS_TL, with the index IEU_WP_ACT_PARAM_SETS_B_S1 supporting lookups (the object referenced in the user's search). Parameter definitions and properties reside in IEU_WP_PARAM_DEFS_B/_TL and IEU_WP_PARAM_PROPS_B/_TL. Action-to-parameter and action-to-node relationships are stored in IEU_WP_ACTION_PARAMS and IEU_WP_ACTION_MAPS, while node-section associations use IEU_WP_NODE_SECTION_MAPS. Mapped action definitions are maintained in IEU_UWQ_MACTION_DEFS_B/_TL, with selection enumerators in IEU_UWQ_SEL_ENUMERATORS and node data sources in IEU_UWQ_NODE_DS. Utility services are provided by FND_API, FND_GLOBAL, FND_MESSAGE, and FND_MSG_PUB.

Usage Notes

IEU_WORKPANEL_PVT is invoked at runtime by the Work Panel infrastructure and by administrative setup forms and concurrent processes that configure agent actions and parameters. It is not referenced by other database objects, confirming its role as an internal engine rather than a public API. Customizations should avoid calling it directly; instead, extend through supported public APIs and metadata. Error handling relies on the FND message stack, so callers should inspect FND_MSG_PUB for messages after invocation.