Search Results get_ws_where_clause

Overview

IEU_UWQ_GET_NEXT_WORK_PVT is an internal (private) PL/SQL package within the Oracle E-Business Suite Universal Work Queue (UWQ) framework, part of the Interaction Enabler/Telephony Manager (IEU) product family. Its primary business function is to retrieve the next eligible work item for a resource — an agent, a group, or a queue — based on configured work sources, selection enumerators, priority rules, and distribution logic. In the context of a user searching for "how to get to the last work with pi," this package is the backend engine that drives the "Get Next Work" and worklist navigation behavior exposed in UWQ-enabled forms and the iSupport/Agent Dashboard. Although classified as PVT (private), meaning it is not a supported public API, it is heavily referenced by other packages and is central to how work items move from a queue to an agent's active work list. The package is defined with AUTHID CURRENT_USER, so it executes with the privileges of the calling schema, typically APPS.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions that together implement the UWQ work-retrieval and distribution lifecycle:

• GET_NEXT_WORKITEM — Core routine that returns the next work item matching the caller's queue and selection criteria.
• GET_NEXT_WORK_ITEM_CONT — Continuation variant that returns the next item after the current one, supporting "next work" navigation.
• GET_WORKITEM_ACTION_FUNC_DATA — Returns action and function metadata associated with a work item so the UI can render available actions.
• GET_WORKLIST_QUEUE — Populates the worklist queue (a ref cursor based on the l_get_work type) for display in the agent's queue.
• GET_WORKLIST_QUEUE_COUNT — Returns a count of items in the worklist queue, commonly used for queue badges and workload display.
• GET_WS_WHERE_CLAUSE — Dynamically builds the WHERE clause for a work source using its associated properties, enabling flexible filtering.
• DISTRIBUTE_WR_ITEMS and DISTRIBUTE_AND_DELIVER_WR_ITEM — Push work items to eligible resources according to distribution rules.
• GET_DIST_WR_ITEMS — Retrieves items eligible for distribution.
• SET_WR_ITEM_DATA_REC and SET_DIST_AND_DEL_ITEM_DATA_REC — Populate the work item data record structures (IEU_WR_ITEM_DATA_REC, IEU_UWQM_ITEM_DATA_REC) used throughout.
• CLEANUP_DISTRIBUTING_STATUS — Resets items left in a distributing state, preventing orphaned locks.

Tables Accessed

The package reads and writes several UWQ and shared EBS tables via APPS synonyms. IEU_UWQM_ITEMS is the central work item store; IEU_UWQM_WORK_SOURCES_B defines work sources and their queries; IEU_UWQM_PRIORITIES_B and IEU_UWQM_PRIORITIES_TL supply priority levels and translated priority text; IEU_UWQM_WS_ASSCT_PROPS holds work-source property associations used to build the dynamic WHERE clause; IEU_UWQ_SEL_ENUMERATORS defines selection enumerators; JTF_RS_GROUP_MEMBERS resolves group membership for distribution; and JTF_OBJECTS_B stores object metadata. DBMS_SQL, DBMS_UTILITY, and PLITBLM are used for dynamic SQL execution and PL/SQL table manipulation.

Usage Notes

IEU_UWQ_GET_NEXT_WORK_PVT is invoked indirectly through UWQ UI components — the Universal Work Queue forms, the Agent Dashboard, and iSupport — rather than called directly. It is referenced by four other packages, which chain it into the broader work management flow. Customers attempting to reach "the last work with pi" should not call this PVT package directly; the supported path is through the UWQ user interface, where queue selection, priority, and enumerator options determine which item is returned. Direct custom invocation is possible but unsupported, since the AUTHID CURRENT_USER model and internal record types may change between 12.1.1 and 12.2.2.