Search Results ieu_wr_item_data




Overview
Explore in AI Chat

Overview

The APPS.IEU_NEXT_WORK_IEUSCPOP package is a component of the Oracle E-Business Suite Interaction Center / Advanced Scheduler infrastructure, specifically belonging to the IEU (Interaction / Universal Work Queue) module family. Its primary business function is to support the "Next Work" retrieval logic used by the Universal Work Queue (UWQ), a framework that presents work items to agents based on assignment rules, priority, and source. The package exposes a strongly typed PL/SQL record and collection structure (IEU_WR_ITEM_DATA_REC and IEU_WR_ITEM_DATA) that encapsulates the attributes of a work item — including identifiers, priority, due dates, ownership, assignment, and distribution status — and a documented procedure that populates that collection with the next set of work items available to a given resource. A companion procedure checks whether a named work-source profile option is enabled for a given user and responsibility, allowing the calling logic to determine whether a particular work source should be surfaced. The package is compiled with AUTHID CURRENT_USER, meaning its unqualified references resolve under the privileges of the invoking user rather than as the defining APPS schema.

Key Procedures and Functions

Two documented procedures are exposed by the package specification:

  • EXECUTE_NEXT_WORK_PROC — The core retrieval routine. It takes a resource identifier, a work-source identifier string, and a display count, and returns an IN OUT NOCOPY collection of IEU_WR_ITEM_DATA records. It is the entry point used to fetch the "next N" work items for an agent, populating each record with the work item ID, object code, primary-key ID, priority, due date, owner and assignee details, source object type, reschedule time, work-source ID, distribution status, and work item number.
  • WORK_SOURCE_PROFILE_ENABLED — A profile-checking utility that accepts a profile name plus user ID, responsibility ID, and application ID, and returns an enabled flag via an OUT NOCOPY parameter. This supports conditional behavior: a work source is presented to the user only if the corresponding profile is enabled for that user/responsibility/application context.

Tables Accessed

The ETRM 12.2.2 metadata does not enumerate specific base tables referenced through APPS synonyms for this package. The IEU_WR_ITEM_DATA_REC record structure indicates the package processes work-item data consistent with the Universal Work Queue data model — attributes such as WORK_ITEM_ID, WORKITEM_OBJ_CODE, PRIORITY_LEVEL, DUE_DATE, OWNER_ID, ASSIGNEE_ID, DISTRIBUTION_STATUS_ID, and RESCHEDULE_TIME map to the UWQ work-item and work-source configuration tables. Profile lookups for WORK_SOURCE_PROFILE_ENABLED are resolved through the standard FND profile option mechanism. Because the package is defined AUTHID CURRENT_USER, table resolution depends on the invoking schema's synonym grants.

Usage Notes

This package is internal infrastructure rather than an end-user-facing API. It is typically invoked by the Universal Work Queue engine and its associated forms or concurrent processes when an agent requests the next batch of work, or when the queue needs to refresh the visible work list. WORK_SOURCE_PROFILE_ENABLED is generally called first to determine which work sources are active for the user's context, after which EXECUTE_NEXT_WORK_PROC is called to fetch and return matching items into the typed collection. The NOCOPY hints on both the collection and the flag parameter indicate performance-sensitive, potentially high-volume calls. The source header string (IEUGNWDS.pls 115.3, dated 2003) shows it is a long-standing component carried forward into 12.1.1 and 12.2.2. Custom code invoking this package should not rely on undocumented behavior, as it is not a published public interface, and the caller must account for the AUTHID CURRENT_USER resolution semantics and appropriate grants when executing under a non-APPS schema. The l_get_work REF CURSOR type declared in the specification indicates internal dynamic SQL usage for retrieval.