Search Results compare_and_set_attr_to_list

Overview

The APPS.JTF_TASK_WF_EVENTS_PVT package body is a private (PVT-classified) PL/SQL API within the Oracle E-Business Suite 12.1.1 and 12.2.2 releases. It belongs to the CRM/Task Management foundation layer (the JTF schema prefix) and serves as the workflow event publishing bridge for the Task Management application. Its core business function is to translate changes made to task and assignment records into Oracle Workflow business events, so that subscribers — such as notification agents, escalation processes, or downstream integrations — can react to task lifecycle activities in near real time.

The package encapsulates the logic for raising four distinct business events: task creation, task update, task deletion, and the corresponding assignment create/update/delete events. By centralising event publication, the package isolates Task Management application code from the mechanics of WF_EVENT.RAISE3 calls and the construction of workflow parameter lists.

Key Procedures and Functions

The documented package exposes ten procedures and functions, of which eight are public-facing event handlers and two are internal utility routines:

• PUBLISH_CREATE_TASK — Raises the oracle.apps.jtf.cac.task.createTask workflow event when a new task record is created.
• PUBLISH_UPDATE_TASK — Raises the oracle.apps.jtf.cac.task.updateTask event, capturing both old and new task record states so subscribers can detect attribute changes.
• PUBLISH_DELETE_TASK — Raises the corresponding deletion event for a task.
• PUBLISH_CREATE_ASSIGNMENT — Raises the assignment creation event.
• PUBLISH_UPDATE_ASSIGNMENT — Raises the assignment update event, passing prior and revised assignment attributes.
• PUBLISH_DELETE_ASSIGNMENT — Raises the assignment deletion event.
• GET_ITEM_KEY — Internal function that derives the workflow event key (item key) for a given event name, ensuring each event instance is uniquely identifiable within the Workflow engine.
• COMPARE_AND_SET_ATTR_TO_LIST — Internal helper that populates a WF_PARAMETER_LIST_T collection with name/value pairs. As the term searched by the user suggests, it "compares and sets" an attribute onto the parameter list, typically guarding against nulls and supporting old/new value comparison for update events.

Tables Accessed

The package operates primarily against in-memory PL/SQL collections rather than persistent base tables. The documented references are:

• WF_PARAMETER_LIST_T — The Workflow parameter list collection type, populated by COMPARE_AND_SET_ATTR_TO_LIST and passed to WF_EVENT.RAISE3.
• JTF_TASK_WF_EVENTS_S — A sequence used to generate unique item keys for workflow events.
• DUAL — Used for simple scalar retrievals, including sequence value selection.
• PLITBLM — An Oracle-supplied PL/SQL table utility package (referenced generically as a table/code dependency).

Usage Notes

Because this is a private package, it is not intended for direct invocation by custom code. It is instead called by the public Task Management APIs and by two other documented packages within the JTF namespace — typically JTF_TASKS_PVT and its assignment counterpart — at the point where a task or assignment DML operation completes successfully. Forms-based task entry and concurrent programs that process bulk task updates are the primary runtime triggers. The return status from each event is captured through WF_EVENT.GETVALUEFORPARAMETER, allowing the calling API to surface workflow errors back to the user. Custom developers seeking to subscribe to task lifecycle changes should configure Workflow subscriptions against the published event names rather than attempting to call this package directly.