Search Results ieu_uwq_form_obj




Overview
Explore in AI Chat

Overview

IEU_UWQ_FORM_ROUTE is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. Its name associates it with the Interaction Center / Universal Work Queue (UWQ) family of components, whose internal prefix "IEU" identifies objects belonging to the iSupport and interaction-management modules. The package provides routing logic that connects a form-based user interface to the Universal Work Queue framework, allowing an active form to communicate with the queuing and media-handling infrastructure that distributes work items to agents.

The package header carries the version marker "$Header: IEUFOOS.pls 120.0 2005/06/02," indicating that the specification has been stable since the early 12.x code line and is carried forward unchanged into EBS 12.1.1 and 12.2.2. The ETRM classification for this package is OTHER, meaning Oracle does not publish it as a supported public API. It is an internal implementation object that supports the UWQ form integration rather than a documented integration point for customer extensions.

Key Procedures and Functions

The ETRM metadata documents a single entry point in the package specification:

  • ieu_uwq_form_obj — The only documented procedure in IEU_UWQ_FORM_ROUTE. It accepts a UWQ media data record as input and returns three out parameters describing the routing decision: an action type, an action name, and an action parameter. In effect, the procedure evaluates the media data supplied by the calling form and determines what the Universal Work Queue should do next with the associated work item.

The input parameter is typed against SYSTEM.IEU_UWQ_MEDIA_DATA_NST, an object type that encapsulates the media attributes of a UWQ item. Because the parameter defaults to null, callers may invoke the procedure without supplying media data when only a default routing decision is required. The three OUT parameters use NOCOPY semantics, which is consistent with a lightweight call-and-return pattern from a form trigger. No other procedures or functions are exposed in the package specification.

Tables Accessed

ETRM records a single table referenced through an APPS synonym:

  • PLITBLM — The standard Oracle Forms PL/SQL table storage table used by the Forms runtime to persist PL/SQL table (index-by table) data held in a form session. The package references it to read or materialize the collection data associated with the UWQ media record passed in by the calling form.

No application data tables are documented as being read or written directly by IEU_UWQ_FORM_ROUTE. This is consistent with its role as a routing helper: it interprets form-supplied data and delegates any persistence to the surrounding UWQ infrastructure rather than performing DML itself.

Usage Notes

IEU_UWQ_FORM_ROUTE is invoked from Oracle Forms code within the UWQ-enabled interaction center forms. A form trigger passes the current media data object to ieu_uwq_form_obj, and the procedure returns the action type, action name, and action parameter that the form uses to navigate to the correct destination — for example, opening a specific window or invoking a specific function in response to the routed work item.

Because the package is classified as OTHER and is not a published API, it should be treated as internal to the UWQ framework. The "Referenced by 0 other packages" entry in the metadata indicates that no other PL/SQL package in the EBS schema depends on it; its callers are form-level, not package-level. Customizations should not call this package directly. Implementers who need to influence UWQ routing should use the supported Universal Work Queue configuration and routing rule setups, and should rely on Oracle Support before extending or replacing the default behavior delivered by IEU_UWQ_FORM_ROUTE.