Search Results jtf_ec_references_pvt




Overview
Explore in AI Chat

Overview

APPS.JTF_ESC_WF_EVENTS_PVT is a private (PVT) PL/SQL package belonging to the Oracle E-Business Suite Escalation Management framework, delivered under the CRM/TeleService application family (JTF denotes the common CRM technology layer). The package acts as the workflow event publishing engine for escalation and escalation reference records. Its business function is to convert lifecycle changes on escalation objects into Oracle Workflow business events, allowing downstream subscribers — notification systems, escalation rule engines, and customer-defined workflow processes — to react to escalation creation, modification, and deletion without direct table-level coupling. The package is classified as PVT, which indicates that it is an internal implementation unit not intended to be called directly by external integrations; it is invoked by the public Escalation Management APIs and by its own sibling packages.

Key Procedures and Functions

The documented API surface comprises ten procedures and functions, organized around two object families: escalations (ESC) and escalation references (ESCREF).

  • PUBLISH_CREATE_ESC — Raises the workflow business event corresponding to creation of an escalation record.
  • PUBLISH_UPDATE_ESC — Raises the business event for an update to an existing escalation.
  • PUBLISH_DELETE_ESC — Raises the business event for deletion of an escalation.
  • PUBLISH_CREATE_ESCREF — Publishes the creation event for an escalation reference record.
  • PUBLISH_UPDATE_ESCREF — Publishes the update event for an escalation reference.
  • PUBLISH_DELETE_ESCREF — Publishes the deletion event for an escalation reference.
  • GET_ITEM_KEY — Returns the workflow item key used to uniquely identify the escalation or reference instance within the Oracle Workflow runtime.
  • COMPARE_AND_SET_ATTR_TO_LIST — Utility routine that compares an attribute value and conditionally assigns it into a workflow attribute list, supporting the construction of the parameter payload passed to the event.

The remaining documented units support these operations. The parameter lists are not published and must not be assumed; callers should treat this package as internal.

Tables Accessed

The package operates against a narrow set of objects:

  • WF_PARAMETER_LIST_T — The Oracle Workflow PL/SQL parameter list type, used to assemble the attribute payload carried by each published business event.
  • JTF_EC_WF_EVENTS_S — The escalation workflow events sequence, used to generate unique item keys for event correlation.
  • DUAL — Used for single-row PL/SQL expression evaluation and sequence retrieval.
  • PLITBLM — The PL/SQL integer table type used as an in-memory collection for list handling within the utility routines.

Usage Notes

JTF_ESC_WF_EVENTS_PVT is not exposed on any form, concurrent program, or public API. It is invoked internally by APPS.JTF_EC_PVT and APPS.JTF_EC_REFERENCES_PVT — the packages that own escalation and escalation-reference DML — immediately after their respective insert, update, and delete operations succeed. Because the two packages reference each other and JTF_ESC_WF_EVENTS_PVT itself appears in its own dependency list, care must be taken when recompiling the escalation stack in 12.1.1 and 12.2.2. Custom code must never call these procedures directly; instead, customers should subscribe to the underlying workflow events through Oracle Workflow Business Event System subscriptions. This preserves upgrade safety and ensures event firing remains consistent with the supported Escalation Management API contract.