Search Results ieu_default_media_enums_pvt

Overview

The APPS.IEU_DEFAULT_MEDIA_ENUMS_PVT package is a private (PVT) PL/SQL API within the Oracle E-Business Suite Interaction Center / Universal Work Queue (UWQ) technology stack. Its name reflects its core responsibility: enumerating (listing and resolving) the default media nodes used by the Interaction Center framework. The IEU schema (Interaction / eBusiness Usage) underpins agent-facing interaction routing, and this package supports the resolution of media channels — such as email, web callback, inbound, and outbound interactions — that an agent or routing engine must consider when building a work queue.

The package is classified as a private API, meaning it is intended for internal consumption by other IEU packages rather than as a public integration point. It is documented as VALID in the APPS schema and appears in both Oracle EBS 12.1.1 and 12.2.2 environments. Its role is to serve as the enumeration and node-creation engine that higher-level packages such as IEU_PVT and IEU_DIAGNOSTICS_PVT call upon when assembling the default set of media nodes available to the Universal Work Queue.

Key Procedures and Functions

ETRM documents eight procedures and functions within this package. Their names indicate the following purposes:

UPDATE_SEL_RT_NODE — Updates a routing selection node, maintaining the persisted definition of a routing entry used during media enumeration.
CREATE_MYWORK_NODE — Creates a node representing the "My Work" view, the agent's personal work queue aggregate.
CREATE_BLENDED_NODE — Creates a blended node, combining multiple media or work sources into a single presentation node.
ENUMERATE_MEDIA_NODES — The primary enumeration routine that returns the set of default media nodes.
ENUMERATE_OUTBOUND_NODES — Enumerates nodes specific to outbound interaction channels.
ENUMERATE_INBOUND_NODES — Enumerates nodes specific to inbound interaction channels.
ENUMERATE_EMAIL_NODES — Enumerates nodes specific to email media.
ENUMERATE_WEB_CALLBACK_NODES — Enumerates nodes specific to web callback media.

No parameter lists are reproduced here, as ETRM does not document them; the names and functional grouping above reflect the documented procedure catalog.

Tables Accessed

The package references several IEU Universal Work Queue tables through APPS synonyms:

IEU_UWQ_SEL_RT_NODES — Stores routing selection nodes; read and written via the update and create routines.
IEU_UWQ_MEDIA_TYPES_B — The base table of media type definitions, used to determine which media are eligible for enumeration.
IEU_UWQ_MEDIA_TYPES_TL — The translation table supplying language-specific media type names.
IEU_UWQ_SEL_RT_NODES_S1 — A sequence supporting node ID generation for IEU_UWQ_SEL_RT_NODES.

Together these tables provide the media type metadata and routing node persistence required to enumerate and create default media nodes.

Usage Notes

As a private package, IEU_DEFAULT_MEDIA_ENUMS_PVT is not intended for direct customer invocation. ETRM indicates it is referenced by two other packages, including IEU_PVT and IEU_DIAGNOSTICS_PVT. This confirms it is invoked indirectly by the Interaction Center runtime when default media nodes must be resolved and presented to agents through the Universal Work Queue UI. Custom code should never call this package directly; developers requiring similar enumeration behavior should use the public IEU_PVT interfaces instead. Its appearance in both 12.1.1 and 12.2.2 indicates stable, long-standing behavior across releases.

PACKAGE: APPS.IEU_DEFAULT_MEDIA_ENUMS_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IEU_DEFAULT_MEDIA_ENUMS_PVT, status:VALID,
SYNONYM: APPS.IEU_UWQ_SEL_RT_NODES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IEU_UWQ_SEL_RT_NODES, status:VALID,
SYNONYM: APPS.IEU_UWQ_SEL_RT_NODES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:IEU_UWQ_SEL_RT_NODES, status:VALID,
PACKAGE: APPS.IEU_DEFAULT_MEDIA_ENUMS_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:IEU_DEFAULT_MEDIA_ENUMS_PVT, status:VALID,
PACKAGE BODY: APPS.IEU_DEFAULT_MEDIA_ENUMS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IEU_DEFAULT_MEDIA_ENUMS_PVT, status:VALID,
PACKAGE BODY: APPS.IEU_DEFAULT_MEDIA_ENUMS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IEU_DEFAULT_MEDIA_ENUMS_PVT, status:VALID,
SYNONYM: APPS.IEU_UWQ_SEL_RT_NODES_S1 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IEU_UWQ_SEL_RT_NODES_S1, status:VALID,
SYNONYM: APPS.IEU_UWQ_MEDIA_TYPES_TL 12.2.2
owner:APPS, object_type:SYNONYM, object_name:IEU_UWQ_MEDIA_TYPES_TL, status:VALID,
12.2.2 DBA Data 12.2.2
SYNONYM: APPS.IEU_UWQ_MEDIA_TYPES_B 12.2.2
owner:APPS, object_type:SYNONYM, object_name:IEU_UWQ_MEDIA_TYPES_B, status:VALID,
SYNONYM: APPS.IEU_UWQ_MEDIA_TYPES_B 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IEU_UWQ_MEDIA_TYPES_B, status:VALID,
SYNONYM: APPS.IEU_UWQ_SEL_RT_NODES_S1 12.2.2
owner:APPS, object_type:SYNONYM, object_name:IEU_UWQ_SEL_RT_NODES_S1, status:VALID,
PACKAGE: APPS.IEU_UWQ_UTIL_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IEU_UWQ_UTIL_PUB, status:VALID,
PACKAGE: APPS.IEU_UWQ_UTIL_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:IEU_UWQ_UTIL_PUB, status:VALID,
SYNONYM: APPS.IEU_UWQ_MEDIA_TYPES_TL 12.1.1
owner:APPS, object_type:SYNONYM, object_name:IEU_UWQ_MEDIA_TYPES_TL, status:VALID,
PACKAGE: APPS.IEU_DEFAULT_MEDIA_ENUMS_PVT 12.1.1
PACKAGE: APPS.IEU_DEFAULT_MEDIA_ENUMS_PVT 12.2.2
PACKAGE: APPS.IEU_CONSTS_PUB 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IEU_CONSTS_PUB, status:VALID,
PACKAGE: APPS.IEU_CONSTS_PUB 12.2.2
owner:APPS, object_type:PACKAGE, object_name:IEU_CONSTS_PUB, status:VALID,
PACKAGE: APPS.IEU_PVT 12.2.2
owner:APPS, object_type:PACKAGE, object_name:IEU_PVT, status:VALID,
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
PACKAGE: APPS.IEU_PVT 12.1.1
owner:APPS, object_type:PACKAGE, object_name:IEU_PVT, status:VALID,
12.1.1 DBA Data 12.1.1
PACKAGE BODY: APPS.IEU_DIAGNOSTICS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IEU_DIAGNOSTICS_PVT, status:VALID,
PACKAGE BODY: APPS.IEU_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IEU_PVT, status:VALID,
PACKAGE BODY: APPS.IEU_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:IEU_PVT, status:VALID,
PACKAGE BODY: APPS.IEU_DIAGNOSTICS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:IEU_DIAGNOSTICS_PVT, status:VALID,
PACKAGE BODY: APPS.IEU_DEFAULT_MEDIA_ENUMS_PVT 12.2.2
PACKAGE BODY: APPS.IEU_DEFAULT_MEDIA_ENUMS_PVT 12.1.1
APPS.IEU_DEFAULT_MEDIA_ENUMS_PVT dependencies on IEU_DEFAULT_MEDIA_ENUMS_PVT 12.1.1
APPS.IEU_DIAGNOSTICS_PVT dependencies on IEU_DEFAULT_MEDIA_ENUMS_PVT 12.2.2
APPS.IEU_DIAGNOSTICS_PVT dependencies on IEU_DEFAULT_MEDIA_ENUMS_PVT 12.1.1
APPS.IEU_PVT dependencies on IEU_DEFAULT_MEDIA_ENUMS_PVT 12.2.2
APPS.IEU_DEFAULT_MEDIA_ENUMS_PVT dependencies on IEU_DEFAULT_MEDIA_ENUMS_PVT 12.2.2
APPS.IEU_PVT dependencies on IEU_DEFAULT_MEDIA_ENUMS_PVT 12.1.1
VIEW: APPS.FND_LOOKUP_VALUES_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:FND.FND_LOOKUP_VALUES_VL, object_name:FND_LOOKUP_VALUES_VL, status:VALID,
VIEW: APPS.FND_LOOKUP_VALUES_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:FND.FND_LOOKUP_VALUES_VL, object_name:FND_LOOKUP_VALUES_VL, status:VALID,
PACKAGE: SYS.DBMS_STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
PACKAGE: SYS.DBMS_STANDARD 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
PACKAGE: APPS.FND_PROFILE 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_PROFILE, status:VALID,
PACKAGE: APPS.FND_PROFILE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_PROFILE, status:VALID,
PACKAGE: APPS.FND_GLOBAL 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_GLOBAL, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
12.1.1 DBA Data 12.1.1
PACKAGE: APPS.FND_GLOBAL 12.1.1
owner:APPS, object_type:PACKAGE, object_name:FND_GLOBAL, status:VALID,
12.1.1 DBA Data 12.1.1
eTRM - FND Tables and Views 12.1.1
description: No longer used ,
PACKAGE: SYS.STANDARD 12.1.1
owner:SYS, object_type:PACKAGE, object_name:STANDARD, status:VALID,