Search Results ieu_uwqm_task_priority_obj

Overview

APPS.IEU_UWQM_TASK_WL_MIG is a PL/SQL package body shipped with Oracle E-Business Suite as part of the Interaction Center / Universal Work Queue (UWQ) technology stack. Its designation and the "MIG" suffix associate it with the task workload migration and aggregation layer used by the Universal Work Queue Manager, which supplies interaction-center agents with prioritized lists of open tasks. The package serves a single, narrowly scoped business function: it produces a consolidated, priority-banded count of open tasks so that the work queue can display or distribute workload by importance level.

The package operates over the JTF (CRM Foundation) task tables rather than any ETRM-specific transaction tables, which is consistent with its role as a queue-feeding utility rather than a migration of financial or treasury data.

Key Procedures and Functions

• GET_TASKS_BY_PRIORITY — The only documented program unit in the package. It returns a nested-table collection of type SYSTEM.IEU_UWQM_TASK_PRIORITY_NST, where each element pairs an importance level with a task count. The function queries open, undeleted tasks of entity type 'TASK' whose source object type is not 'SR', groups them by importance level, and counts the associated task IDs. Importance levels of four or below are stored individually; any level greater than four is collapsed into level four. A separate count of tasks that have no priority ID assigned at all is then added into the level-four bucket, ensuring that unprioritized work is not lost from the queue totals. The populated local list is finally converted into the returned nested table using the object type SYSTEM.IEU_UWQM_TASK_PRIORITY_OBJ.

This design directly explains the "task_count" field referenced in the underlying object type: it is the per-priority tally returned to the caller.

Tables Accessed

• JTF_TASKS_B — The base task table. The package reads TASK_ID, TASK_PRIORITY_ID, DELETED_FLAG, OPEN_FLAG, ENTITY, and SOURCE_OBJECT_TYPE_CODE from it. It is the primary source of both the grouped counts and the null-priority count.
• JTF_TASK_PRIORITIES_VL — The priority lookup view joined on TASK_PRIORITY_ID to obtain IMPORTANCE_LEVEL. Although not listed among the APPS synonym references, it appears explicitly in the cursor definition and is essential to the priority banding logic.
• PLITBLM — A PL/SQL table/index-by table helper referenced in the metadata, consistent with the package's use of associative-array structures (l_pty_list, l_priority_list) to accumulate counts before conversion to the SQL nested-table return type.

Usage Notes

Because the function returns a strongly typed nested table consumed by Universal Work Queue aggregation logic, it is invoked programmatically — typically from UWQ queue-building code, agent dashboard rendering paths, or concurrent processes that refresh work-queue metrics — rather than being exposed directly to an end user. The documented metadata records no inbound references from other packages, which suggests invocation occurs from forms, JSP/HTML UI layers, or Java business components that call the package directly.

The package is marked "noship" in its version header, indicating it is an internal, non-shipped support object. It should not be called from custom code as a supported interface. Note also that the cursor and the null-priority query share the same filters — deleted_flag 'N', entity 'TASK', open_flag 'Y' — so any change to one must be mirrored in the other to keep the level-four total internally consistent.