Search Results enumerate_media_nodes




Overview
Explore in AI Chat

Overview

IEU_DEFAULT_MEDIA_ENUMS_PVT is a private (PVT) PL/SQL package body in the Application Object Library of Oracle E-Business PLM/Interaction Center (IEU module). It belongs to the Interaction Center / Universal Work Queue (UWQ) framework and serves as the internal engine that builds, populates, and maintains the "selection right-tree" node structures used to enumerate the media types available to an agent. In EBS releases 12.1.1 and 12.2.2, the package operates behind the public media enumeration APIs and encapsulates the logic that maps a resource, a selection enumeration, and a media type into the hierarchical node tree displayed in the agent's media toolbar and work queue.

The package is classified as PVT, meaning its procedures are not intended for direct invocation by customer code. The header comment ($Header: IEUENMVB.pls 120.1 2006/02/21) confirms the file is a standard source-controlled EBS package body.

Key Procedures and Functions

  • UPDATE_SEL_RT_NODE — The procedure identified by the user's search term. It updates a single row in the selection right-tree node table with attributes such as node label, data source, view name, media type, node weight, where clause, hide-if-empty flag, refresh view name, and node depth. It validates mandatory parameters (resource ID, selection enum ID, node ID, node type, and node label) and raises a named application error if any are null. It uses a savepoint before performing the update and audits the row via FND_GLOBAL.USER_ID, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN.
  • CREATE_MYWORK_NODE — Creates a personal "My Work" node in the selection right-tree, allowing an agent to see their own assigned work items.
  • CREATE_BLENDED_NODE — Creates a blended node that consolidates work items across multiple media types into a single queue entry.
  • ENUMERATE_MEDIA_NODES — Enumerates the media-type nodes to be presented under a given selection enumeration.
  • ENUMERATE_OUTBOUND_NODES — Enumerates outbound interaction nodes (e.g., outbound calls, campaigns).
  • ENUMERATE_INBOUND_NODES — Enumerates inbound interaction nodes.
  • ENUMERATE_EMAIL_NODES — Enumerates e-mail nodes within the selection tree.
  • ENUMERATE_WEB_CALLBACK_NODES — Enumerates web callback nodes.

Tables Accessed

  • IEU_UWQ_SEL_RT_NODES — The central selection right-tree node table. UPDATE_SEL_RT_NODE and the CREATE/ENUMERATE procedures read and write this table to persist node definitions, weights, labels, and view metadata.
  • IEU_UWQ_MEDIA_TYPES_B — The base table holding media type definitions (e.g., phone, e-mail, web callback) that drive node enumeration.
  • IEU_UWQ_MEDIA_TYPES_TL — The translation table supplying language-specific media type names used in node labels.
  • IEU_UWQ_SEL_RT_NODES_S1 — A sequence used to generate surrogate node identifiers.

Usage Notes

IEU_DEFAULT_MEDIA_ENUMS_PVT is invoked indirectly. It is referenced by two other packages in the IEU/UWQ stack, which in turn are called by the Interaction Center agent dashboard and Universal Work Queue setup forms. Typical invocation paths include the agent login/initialization sequence (where the media toolbar is populated), refresh of an agent's work queue after routing changes, and administration of media type selections. Because it is a PVT package, direct calls from custom code are not supported; customers extending the media enumeration must use the public wrapper APIs. The savepoints, FND_GLOBAL audit columns, and standard raise_application_error(-20000) validation pattern confirm the package participates in the standard EBS transaction and error-handling conventions, making it safe to invoke within a broader form-level transaction.