Search Results determine_all_media_types_extn

Overview

APPS.IEU_PVT is a private PL/SQL package within the Oracle E-Business Suite Interaction Center (IEU) module, classified under the PVT (private) API tier. It is not intended for direct invocation by external or customer-developed code; instead it serves as an internal engine layer consumed by public-facing IEU packages such as IEU_PUB. Its central business function is to support the Universal Work Queue (UWQ) and the underlying multimedia routing and server infrastructure. The package encapsulates the logic that determines which client plugins are available to a user, which media types are eligible for routing, how work nodes are enumerated and refreshed across the queue hierarchy, and how agents are bound to and unbound from UWQ servers. In the broader EBS 12.1.1 and 12.2.2 architecture, IEU_PVT is a core dependency for Interaction Center agent desktop behavior, media routing decisions, and work distribution across multiple channels (voice, e-mail, chat, and other configured media). Its status is VALID, and it resides in the APPS schema, consistent with standard EBS deployment.

Key Procedures and Functions

The package exposes approximately 31 documented procedures and functions organized around several functional clusters:

Plugin and media determination: DETERMINE_CLI_PLUGINS, DETERMINE_ELIGIBLE_MEDIA_TYPES, IS_MEDIA_TYPE_ELIGIBLE, and IS_AGENT_ELIGIBLE_FOR_MEDIA resolve which client-side plugins apply and which media types an agent or session may handle, based on login rules and media configuration.
Work node management: ENUMERATE_WORK_NODES, ENUMERATE_WORK_NODES_FOR_SVR, REFRESH_WORK_NODE_COUNTS, REFRESH_NODE, REFRESH_WORK_NODE_FOR_SVR, ADD_UWQ_NODE_DATA, and WALK_TREE_ADD build and maintain the hierarchical work queue structure and its counts.
Agent and server binding: UWQ_CLIENT_LOCATE_UWQ_SERVER, BIND_AGENT, UNBIND_AGENT, CLEAR_ALL_AGENT_BINDINGS, BIND_AGENT_AND_UPDATE_LOAD, UPDATE_SERVER_STARTUP_INFO, FORCE_UPDATE_MRT_DATA, and IS_UWQ_SERVER_REQUIRED manage the association of agents with UWQ servers and maintain load and startup metadata.
Presentation and utility: DETERMINE_WB_STYLE resolves workbench styling information used by the agent UI.

Tables Accessed

The package reads and writes configuration and runtime tables through APPS synonyms. Media and plugin configuration is sourced from IEU_UWQ_CLI_MED_PLUGINS, IEU_UWQ_MEDIA_TYPES_B, IEU_UWQ_MEDIA_TYPE_NST, and IEU_UWQ_LOGIN_RULES_B. Routing and queue structure data reside in IEU_UWQ_SEL_RT_NODES, IEU_UWQ_SEL_MRT_DATA, IEU_UWQ_SEL_MRT_QUEUES_NST, and IEU_UWQ_RTNODE_BIND_VALS. Server-side information is drawn from the IEO_SVR_* family, including IEO_SVR_SERVERS, IEO_SVR_TYPES_B, IEO_SVR_COMPS, IEO_SVR_COMP_DEFS, IEO_SVR_GROUPS, IEO_SVR_PROTOCOL_MAP, and IEO_SVR_RT_INFO. Additionally, AST_GRP_CAMPAIGNS and FND_PROFILE_OPTIONS are referenced, the latter for profile-driven behavior such as site or user-level UWQ configuration.

Usage Notes

IEU_PVT is invoked indirectly during Interaction Center agent login, work queue refresh, and media routing operations. It is referenced by IEU_PUB, IEU_DEFAULT_MEDIA_ENUMS_PVT, IEU_PLGN_FUNC_PVT, IEU_DIAGNOSTICS_PVT, and CCT_PLGN_FUNC_PVT, and it self-references through recursive tree-walking logic. Customizations should not call IEU_PVT directly; developers requiring UWQ functionality should use the corresponding IEU_PUB public APIs. Because its procedures drive live agent binding and load accounting, improper direct invocation can corrupt work distribution state. Diagnostics packages leverage it to validate routing configuration, making it relevant during troubleshooting of media routing or agent eligibility issues in both 12.1.1 and 12.2.2 environments.