Search Results create_esc_notif_subs

Overview

JTF_EC_WORKFLOW_PKG is the private PL/SQL interface for the Oracle E-Business Suite Escalation Management module, delivered under the JTF (CRM Foundation) product. It handles Oracle Workflow notifications for the Escalation Management feature, which drives reactive escalation of tasks, service requests, and other business objects when defined events, such as changes in owner, level, status, or target date, occur.

The package is declared AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the owner. The header carries the version identifier 120.1.12010000.2, dated January 29, 2009, confirming its presence across Release 12.1.1 and 12.2.2 application tiers. Its ETRM classification is OTHER, and its scope is private, indicating that it is an internal implementation unit rather than a supported public API; Oracle does not guarantee backward compatibility on its internal signatures.

The package is explicitly documented as the private interface used from the JTFEC workflow item and is responsible for sending notifications within the Reactive Escalation module. A single EBS object is documented as referencing this package.

Key Procedures and Functions

ETRM documents ten program units in this package. They divide broadly into workflow launch and notification helpers, event handling routines, and subscription maintenance routines.

• START_RESC_WORKFLOW — Initiates the reactive escalation workflow for a task or escalated document, launching the process that performs notification activities.
• CHECK_EVENT — Validates event conditions raised by the caller and determines whether escalation processing should proceed.
• SET_NOTIF_MESSAGE — Constructs the notification message text delivered to the recipient through the workflow notification.
• SET_NOTIF_PERFORMER — Determines the performer, i.e., the recipient or designated responder, of the escalation notification.
• GET_DOC_DETAILS — Retrieves the attributes of the underlying document being escalated, supplying context used by other routines.
• RAISE_ESC_CREATE_EVENT — Raises the Workflow Business Event associated with escalation creation.
• RAISE_ESC_UPDATE_EVENT — Raises the Workflow Business Event associated with escalation updates, such as owner, level, status, or target date changes.
• CREATE_ESC_NOTIF_SUBS — Creates notification subscriptions for escalation events.
• UPDATE_ESC_NOTIF_SUBS — Updates existing notification subscriptions, the routine surfaced by the search term update_esc_notif_subs. It refreshes subscription records so that the correct parties continue to receive escalation notifications after configuration or assignment changes.

The package header also exposes parameters for the public entry points, including p_task_id, change flags such as p_owner_changed, p_level_changed, p_status_changed, and p_target_date_changed, and the prior-value parameters p_old_owner_id, p_old_level, p_old_status_id, and p_old_target_date, along with the standard FND_API messaging parameters.

Tables Accessed

The package reads and writes the following objects through APPS synonyms:

• JTF_EC_WF_EVENTS_S — stores workflow event definitions used when raising escalation events and resolving subscriptions.
• JTF_TASKS_B and JTF_TASK_CONTACTS — supply the task record and its associated contacts or resource assignments that determine escalation notification recipients.
• JTF_TASK_WORKFLOW_PROCESS_S — links tasks to their active workflow processes, used by START_RESC_WORKFLOW.
• WF_EVENT_T, WF_ITEM_ACTIVITY_STATUSES, WF_PARAMETER_LIST_T — Workflow runtime objects used to raise events, query activity status, and pass parameter lists into workflow APIs.
• FND_USER and PER_ALL_PEOPLE_F — resolve recipient identities and e-mail or user information for notifications.
• HZ_PARTIES — provides party information for customer-facing escalation subscribers.
• JTF_OBJECTS_B — supplies metadata about the object type being escalated.
• DUAL and PLITBLM — used for singleton queries and PL/SQL index-by table handling.

Usage Notes

JTF_EC_WORKFLOW_PKG is not intended for direct customer invocation. It is called internally from the JTFEC Workflow item type, which Oracle Workflow executes when an escalation process activity fires. The package may also be referenced by concurrent programs or by the Escalation Management setup and administration flows maintained through the CRM Foundation responsibility.

Because the package is defined as private and AUTHID CURRENT_USER, implementers who call it from custom code must ensure the executing schema holds direct privileges on the underlying JTF, WF, FND, HZ, and PER objects, since definer's rights to the APPS schema do not apply. Custom integration should prefer the supported escalation setup interfaces and Business Events rather than calling these routines directly, as internal signatures are subject to change between patch levels and releases such as 12.1.1 and 12.2.2.