Search Results ieu_pub




Overview
Explore in AI Chat

Overview

APPS.IEU_PUB is the public application programming interface (API) package body for the Interaction & Universal Work Queue (UWQ) subsystem within Oracle E-Business Suite. In the ETRM classification scheme, the "PUB" suffix identifies this package as a public-facing API layer intended for invocation by forms, concurrent programs, workflows, and custom extensions, rather than as an internal implementation utility. In Oracle EBS 12.1.1 and 12.2.2, the IEU module governs Universal Work Queue functionality, which routes and presents work items—such as service requests, tasks, and customer interactions—to agents across channels including the telephony and media toolbars.

The package body is documented as VALID and is owned by the APPS schema. It is not referenced by any other database object, confirming its role as a top-level entry point rather than a shared internal dependency. Conversely, it is referenced by 25 other packages, indicating that it serves as a stable contract consumed broadly across the EBS codebase.

Key Procedures and Functions

The ETRM metadata documents seven procedures and functions within IEU_PUB. Each performs a distinct role in work queue configuration and agent eligibility determination.

  • SET_BIND_VAR_DATA — Establishes bind variable data used by work queue routing and node processing logic.
  • GET_ENUM_RES_CAT — Retrieves an enumerated resource category, supporting classification of agents or resources for routing decisions.
  • IS_AGENT_ELIGIBLE_FOR_MEDIA — Returns eligibility status indicating whether a given agent may handle a specified media channel.
  • IS_UWQ_SERVER_REQUIRED — Determines whether a Universal Work Queue server process is required in the current configuration or runtime context.
  • ADD_UWQ_NODE_DATA — Inserts or registers node data into the work queue structure.
  • GET_UWQ_NODE_DETAILS — Retrieves the detailed attributes of a work queue node for presentation or processing.

Parameter lists are not enumerated in the source metadata and must be confirmed against the live package specification in the target environment.

Tables Accessed

IEU_PUB reads from and writes to several UWQ configuration tables through APPS synonyms. The dependency list identifies IEU_UWQ_SEL_RT_NODES and IEU_UWQ_SEL_ENUMERATORS, which store routing node selection definitions and enumerator values respectively. IEU_UWQ_RTNODE_BIND_VALS holds bind variable values assigned to routing nodes, directly supporting SET_BIND_VAR_DATA. IEU_UWQ_RES_CATS_B is the base table for resource categories, underpinning GET_ENUM_RES_CAT. DUAL and PLITBLM appear as standard PL/SQL infrastructure dependencies, the latter typically used for bulk PL/SQL table operations.

Usage Notes

IEU_PUB is typically invoked from the Universal Work Queue and Interaction Center forms, from concurrent programs that provision or refresh work queue configuration, and from custom code extending media routing. Its internal implementation delegates to IEU_PVT and IEU_CONSTS_PUB for private logic and constant definitions. Because 25 packages depend on IEU_PUB, its public signatures should be treated as stable; any modification must be validated against all dependent packages before deployment in either 12.1.1 or 12.2.2.