Search Results ieu_wp_mact_obj




Overview
Explore in AI Chat

Overview

IEU_WorkPanel_PVT is a private PL/SQL package in the Application Object Library belonging to the Interaction E-Business Update (IEU) product family, which delivers the Universal Work Queue (UWQ) and Universal Work Panel (UWP) infrastructure used by Oracle EBS telephony, interaction center, and customer care deployments. The package encapsulates the business logic required to build and maintain the configurable Work Panel that agents use to display and launch actions, parameters, and filters against queued work items. Its stated purpose, per the embedded header, is "to provide easy to use APIs for UQW Work Panel." The AUTHID CURRENT_USER declaration indicates the package executes with the privileges of the invoking schema, and callers are therefore expected to hold appropriate grants on the IEU tables.

Because the package is classified as PVT (private), it is not part of the public, supported integration surface. It is intended for consumption by the IEU product's own forms, concurrent programs, and internal packages rather than by customer extensions, and its signature is subject to change between releases, as reflected in the source header revision (115.24, dated August 2003).

Key Procedures and Functions

The package exposes twenty documented procedures covering the full lifecycle of Work Panel metadata. They group into four functional areas.

All procedures follow the standard EBS API error-handling convention, returning x_return_status, x_msg_count, and x_msg_data. As the metadata does not expose full parameter lists, callers should treat individual signatures as internal contracts. The source excerpt confirms that VALIDATE_ACTION accepts a SYSTEM.IEU_WP_MACT_OBJ record object, an is_create indicator, and a parameter-set context, reinforcing the object-record pattern used throughout the package.

Tables Accessed

The package reads and writes the IEU Work Panel and UWQ metadata tables through APPS synonyms. Action definition data resides in IEU_UWQ_MACTION_DEFS_B and its translation table IEU_UWQ_MACTION_DEFS_TL, with the _S1 synonym denoting the underlying sequence. Action-to-parameter and action-map relationships are stored in IEU_WP_ACTION_PARAMS, IEU_WP_ACTION_PARAMS_S1, and IEU_WP_ACTION_MAPS. Parameter set definitions are held in IEU_WP_ACT_PARAM_SETS_B, IEU_WP_ACT_PARAM_SETS_B_S1, and IEU_WP_ACT_PARAM_SETS_TL. Parameter and column definitions live in IEU_WP_PARAM_DEFS_B and IEU_WP_PARAM_DEFS_B_S1. Node and section layout information is maintained in IEU_UWQ_NODE_DS, IEU_WP_NODE_SECTION_MAPS, IEU_WP_NODE_SECTION_MAPS_S1, and IEU_UWQ_SEL_ENUMERATORS, which supplies enumerated selection values. Collectively these tables constitute the metamodel that drives how the Work Panel renders actions and parameters to the agent at runtime.

Usage Notes

IEU_WorkPanel_PVT is invoked primarily from the UWQ Work Panel administrative forms and from a single dependent IEU package, per the documented reference count. It is not registered as a public API and carries no documented concurrent program entry point. Customizations that require Work Panel behavior should preferably call supported public IEU APIs or the underlying tables directly, since private package signatures may change across 12.1.1 and 12.2.2 without notice. When custom code must invoke these procedures, it should pass a correctly populated SYSTEM.IEU_WP_MACT_OBJ record, honor the is_create flag to distinguish insert from update paths, and always inspect x_return_status along with the message stack rather than relying on exceptions, as is standard for EBS PVT validation routines.