Search Results publish_delete_esc

Overview

APPS.JTF_ESC_WF_EVENTS_PVT is a private PL/SQL package body within the Oracle E-Business Suite CRM/eService (TeleService) escalation framework. Its purpose is to bridge escalation business events and the Oracle Workflow Business Event System by publishing escalation-related events onto the Workflow event queue. The package raises the canonical escalation business events — create, update, and delete — for both escalation definitions and escalation references, so that any subscribed workflow process, agent, or program can react to escalation lifecycle changes without direct coupling to the escalation tables.

The package was created to support the eService escalation business event enhancement (internal enhancement 2660883), and it operates as a private API (classification PVT) consumed by the escalation engine rather than by end users directly. It encapsulates the event naming conventions, item-key generation, and parameter-list construction required by WF_EVENT.RAISE.

Key Procedures and Functions

The ETRM metadata documents ten procedures and functions. The primary public-facing entry points are the publishers:

• PUBLISH_CREATE_ESC — Raises the business event oracle.apps.jtf.cac.escalation.createEscalation when a new escalation is created. It derives an item key, packages the escalation identifier as a task parameter, and raises the Workflow event.
• PUBLISH_UPDATE_ESC — Raises oracle.apps.jtf.cac.escalation.updateEscalation when an escalation is modified. It includes both the escalation identifier and the audit identifier in the parameter list.
• PUBLISH_DELETE_ESC — Raises the corresponding delete-escalation business event when an escalation is removed.
• PUBLISH_CREATE_ESCREF, PUBLISH_UPDATE_ESCREF, PUBLISH_DELETE_ESCREF — The parallel trio of publishers for escalation references, allowing subscribers to track create, update, and delete operations on escalation reference records independently of the parent escalation events.
• GET_ITEM_KEY — Internal helper that generates the unique Workflow item key for a given event name, ensuring each raised event instance is uniquely identifiable.
• COMPARE_AND_SET_ATTR_TO_LIST — Internal helper that conditionally adds a named attribute to the Workflow parameter list, supporting the 'C' (create) and 'U' (update) modes used by the publishers.

Tables Accessed

The package interacts with the Workflow infrastructure rather than with escalation data tables directly:

• WF_PARAMETER_LIST_T — The Workflow parameter-list collection type used to assemble, populate, and clear the event payload passed to WF_EVENT.RAISE.
• JTF_EC_WF_EVENTS_S — The escalation workflow events sequence, used to generate unique event or item identifiers.
• DUAL — Used for single-row evaluations, such as sequence value retrieval.
• PLITBLM — The PL/SQL table management package used for collection list operations.

Usage Notes

This package is invoked internally by the eService escalation engine at the point where escalation records and escalation references are created, modified, or deleted. It is not intended for direct calls from Oracle Forms, concurrent programs, or custom code; subscribers consume its output by registering subscriptions against the published business events. The publish_delete_escref procedure, in particular, is the entry point that triggers the delete-escalation-reference business event. Because it is a private package, customizations should subscribe to the raised business events rather than calling the publishers directly, and any use must account for the savepoint/rollback logic that ensures event publication does not leave partial state in the calling transaction.