Search Results jtf_task_assignments_pvt




Overview
Explore in AI Chat

Overview

APPS.JTF_TASK_WF_EVENTS_PVT is a private (PVT) PL/SQL package within the Oracle E-Business Suite Resource Manager (JTF) schema. Its principal business function is to serve as the integration bridge between the Task Management application tables owned by JTF_TASKS_PVT and JTF_TASK_ASSIGNMENTS_PVT, and the Oracle Workflow event infrastructure. The package encapsulates the logic required to publish business events whenever task and task assignment records are created, updated, or deleted, allowing subscribing workflows and external integration points to react to changes in the Task Management data model without directly querying the base tables.

Because it is designated as a private API (PVT classification), the package is not intended for direct invocation by customer extensions. It is instead called internally by the public task and assignment APIs, which orchestrate validation, DML, and event publication as a single unit of work. This design enforces consistent event semantics and keeps the public task interfaces decoupled from the underlying Workflow event subscription mechanism.

Key Procedures and Functions

The package exposes ten documented procedures and functions that fall into three functional categories: event publication for tasks, event publication for assignments, and internal utility helpers.

  • PUBLISH_CREATE_TASK — Publishes the workflow event corresponding to the creation of a task record. It builds the event payload from the task attributes and raises the event through the Workflow engine.
  • PUBLISH_UPDATE_TASK — Publishes the workflow event for modifications to an existing task, supplying the changed attribute context so subscribers can evaluate the update.
  • PUBLISH_DELETE_TASK — Publishes the workflow event signalling that a task record has been removed.
  • PUBLISH_CREATE_ASSIGNMENT — Publishes the event raised when a new task assignment (the association of a resource to a task) is created.
  • PUBLISH_UPDATE_ASSIGNMENT — Publishes the event raised when an existing task assignment is modified.
  • PUBLISH_DELETE_ASSIGNMENT — Publishes the event raised when a task assignment is deleted.
  • GET_ITEM_KEY — Derives and returns the unique workflow item key that identifies the task or assignment instance within the event delivery framework, ensuring that correlated events resolve to the same workflow item.
  • COMPARE_AND_SET_ATTR_TO_LIST — A helper routine that compares an attribute value and, when appropriate, appends or sets it into the workflow parameter list structure. This supports building the parameter list that accompanies each published event.

Tables Accessed

The package references the following objects, reached through APPS synonyms:

  • WF_PARAMETER_LIST_T — The Oracle Workflow parameter list type used to assemble the name/value pairs transmitted with each event. This is the central data structure consumed by the publication routines.
  • JTF_TASK_WF_EVENTS_S — The sequence that supplies unique identifiers used in event key generation and item key resolution.
  • DUAL — The standard single-row utility table, used for scalar evaluation such as sequence retrieval.
  • PLITBLM — The PL/SQL integer table type used internally for list handling and array processing within the helper routines.

Usage Notes

JTF_TASK_WF_EVENTS_PVT is invoked indirectly by the public Task Management APIs. Specifically, it is referenced by APPS.JTF_TASKS_PVT and APPS.JTF_TASK_ASSIGNMENTS_PVT (and by itself for recursive utility calls), meaning that any standard create, update, or delete operation performed through those public packages will trigger the corresponding event publication without additional coding on the part of the caller. Typical entry points include Task Management forms in the EBS application, concurrent programs that mass-maintain tasks, and custom integrations that legitimately call JTF_TASKS_PVT. Direct calls to this private package by customer code are discouraged because its signatures and event key semantics are internal and may change between releases; supported integration paths should use the public JTF_TASKS_PVT and JTF_TASK_ASSIGNMENTS_PVT interfaces to ensure consistent workflow event behaviour across EBS 12.1.1 and 12.2.2.