Search Results determine_eligible_media_types

Overview

APPS.IEU_PVT is the private implementation package body for the Interaction E-Utilities (IEU) Universal Work Queue (UWQ) subsystem in Oracle E-Business Suite. It provides the low-level PL/SQL logic that drives media type eligibility, work node enumeration, work node count refresh, and agent-to-server binding for the UWQ client. Because it is a private (PVT) package, its members are not exposed as public APIs; the corresponding public package, IEU_IMP or the relevant UWQ facade, delegates down to these routines on behalf of the UWQ client forms and runtime components.

The package defines an extensive set of PL/SQL collection globals used as bulk-bind arrays for DML and query processing, including node, resource, bind variable, and security group collections. These collections support the recursive tree walking and set-based updates that characterized UWQ node maintenance.

Key Procedures and Functions

• DETERMINE_ELIGIBLE_MEDIA_TYPES — Determines which UWQ media types are eligible for the current agent or context. This is the routine the user's search targeted.
• DETERMINE_CLI_PLUGINS — Resolves the client plugins applicable to the agent's environment.
• DETERMINE_WB_STYLE — Determines the workbench style/configuration used by the client session.
• IS_MEDIA_TYPE_ELIGIBLE — Predicate that validates whether a specific media type qualifies for eligibility.
• IS_AGENT_ELIGIBLE_FOR_MEDIA — Predicate that validates agent eligibility against a given media type.
• IS_UWQ_SERVER_REQUIRED — Determines whether a UWQ server component is required for the session.
• ENUMERATE_WORK_NODES — Builds the tree of work nodes presented to the agent.
• ENUMERATE_WORK_NODES_FOR_SVR — Server-side variant of work node enumeration.
• REFRESH_WORK_NODE_COUNTS — Refreshes the count values displayed against work nodes.
• REFRESH_WORK_NODE_FOR_SVR — Server-side refresh of a work node.
• REFRESH_NODE — Refreshes an individual work node's data.
• UWQ_CLIENT_LOCATE_UWQ_SERVER — Locates a UWQ server for the client session.
• BIND_AGENT / UNBIND_AGENT — Bind and unbind an agent to a server.
• CLEAR_ALL_AGENT_BINDINGS — Clears all existing agent bindings.
• BIND_AGENT_AND_UPDATE_LOAD — Binds an agent while updating server load.
• UPDATE_SERVER_STARTUP_INFO — Updates server startup metadata.
• FORCE_UPDATE_MRT_DATA — Forces refresh of media routing data.
• ADD_UWQ_NODE_DATA — Inserts work node data into the runtime structures.
• WALK_TREE_ADD — Recursively walks the node tree, adding nodes as encountered.

Tables Accessed

• IEU_UWQ_MEDIA_TYPES_B — Source of media type definitions used by eligibility logic.
• IEU_UWQ_CLI_MED_PLUGINS — Maps client plugins to media types.
• IEU_UWQ_LOGIN_RULES_B — Login rule definitions controlling agent applicability.
• IEU_UWQ_SEL_RT_NODES — Selected runtime work nodes.
• IEU_UWQ_RTNODE_BIND_VALS — Bind values associated with runtime nodes.
• IEU_UWQ_SEL_MRT_DATA — Selected media routing data.
• IEO_SVR_SERVERS, IEO_SVR_TYPES_B, IEO_SVR_GROUPS, IEO_SVR_COMPS, IEO_SVR_COMP_DEFS, IEO_SVR_PROTOCOL_MAP, IEO_SVR_RT_INFO — Server registration, component, protocol, and runtime information used by binding and server-location routines.
• AST_GRP_CAMPAIGNS — Group campaign data.
• FND_PROFILE_OPTIONS — Profile option values influencing behavior.

Usage Notes

IEU_PVT is invoked indirectly through the UWQ client runtime and its public wrapper packages rather than called directly by end-user forms. It is referenced by five other packages, which indicates it functions as a shared private service layer across the UWQ stack. Administrators and developers troubleshooting media type eligibility, missing work nodes, or incorrect node counts should trace execution into DETERMINE_ELIGIBLE_MEDIA_TYPES and ENUMERATE_WORK_NODES respectively. Direct modification of this package body is not supported; customizations should target the public API layer. All table access occurs through APPS synonyms, so the package executes under standard EBS APPS schema privileges.