Search Results jtf_escwfactivity_pvt




Overview
Explore in AI Chat

Overview

JTF_ESCWFACTIVITY_PVT is a private PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM metadata as an "API classification: PVT" package. The "PVT" suffix indicates that this is a private (internal) package, intended to be invoked by other packages within the same module rather than directly by external or customer-facing code. The package belongs to the Oracle CRM/TeleService foundation layer (the JTF_ prefix denotes "Java/Task Foundation," the shared infrastructure underlying Oracle TeleService, Oracle Field Service, and Oracle CRM applications).

The package supports the escalation workflow activity framework. In Oracle EBS, "escalation" refers to the automated routing of service requests, tasks, or notification activities to appropriate personnel when a threshold, timer, or business rule is triggered. JTF_ESCWFACTIVITY_PVT encapsulates the low-level logic for creating notification tasks, creating escalation tasks, and identifying the appropriate notification recipient. It therefore acts as the internal engine behind higher-level escalation APIs and the Task Manager framework. The package status is recorded as VALID across the 12.1.1 and 12.2.2 releases documented in the ETRM repository.

Key Procedures and Functions

The ETRM metadata documents three procedures/functions within this package. Parameter lists are intentionally omitted here to avoid speculation; only names and purposes are given.

  • CREATE_NOTIFTASK — Creates a notification task. This routine instantiates a task record that represents a notification to be delivered to a user or resource, typically as part of an escalation event. It leverages the JTF task tables and workflow notification mechanisms.
  • CREATE_ESCTASK — Creates an escalation task. This routine generates the task object that embodies the escalation action itself — the work item that must be performed once an escalation rule fires. It is distinct from CREATE_NOTIFTASK in that its purpose is to create a work item rather than merely notify a recipient.
  • GET_NOTIFPERSON — Retrieves the notification person, i.e., the individual or resource that should receive the notification. This function resolves the recipient identity from role, resource, or user assignments so that CREATE_NOTIFTASK can target the correct party.

Tables Accessed

Although the ETRM excerpt lists only SYS.STANDARD as a referenced object at the SQL level, the documented table references (via APPS synonyms) reveal the data this package touches:

  • FND_NEW_MESSAGES — the Workflow notification message store; read/written when a notification task is created.
  • FND_USER — Oracle Applications user definitions; used to resolve the notification person.
  • JTF_BRM_PROCESSES — Business Rule Management process definitions; supplies escalation context.
  • JTF_RS_RESOURCE_EXTNS — resource extension data; used to resolve the resource (person) to be notified.
  • JTF_TASK_TEMP_GROUPS_TL — translated task template group definitions; provides task templates for escalation/notification tasks.
  • WF_LOCAL_ROLES — Workflow local role definitions; used together with FND_USER and resource extensions to identify the notifperson.
  • PLITBLM — a PL/SQL table (index-by table) type used internally by the PL/SQL toolkit, commonly for bulk operations.

Usage Notes

Because JTF_ESCWFACTIVITY_PVT is a private package, it is normally invoked indirectly — from within the Task Manager / escalation workflow modules, or from sibling packages in the JTF_ESC% family. The ETRM metadata states the package is referenced by zero other packages, which suggests it is the innermost caller in the escalation call chain, terminating the dependency graph at the level of these private routines. In practice, escalation rules configured via the CRM Administrator or TeleService setup drive business events; those events reach this package's routines, which in turn create the underlying tasks and notifications. Custom code should not call JTF_ESCWFACTIVITY_PVT directly; developers seeking similar functionality should use the public Task Manager or notification APIs documented for Oracle EBS 12.1.1 and 12.2.2.