Search Results cs_wf_event_subscriptions_pkg




Overview
Explore in AI Chat

Overview

The APPS.CS_WF_EVENT_SUBSCRIPTIONS_PKG package is a service-related PL/SQL package in Oracle E-Business Suite, owned by the APPS schema and classified as an OTHER API in the ETRM repository. Its name indicates that it manages workflow event subscriptions within the Service (CS) module, defining and processing the associations between business events raised in the Service application and the workflow subscriptions that respond to those events. In EBS 12.1.1 and 12.2.2, workflow event subscriptions are the mechanism by which the Oracle Workflow Business Event System routes event messages to subscribing functions, and this package encapsulates that registration and handling logic for Service events.

The object is reported with a VALID status and exposes both a package specification and a package body. Its dependency footprint is narrow: it references WF_EVENT_T, the standard Oracle Workflow event message type, and the SYS STANDARD package. The documented API classification is OTHER, meaning Oracle does not publish this as a supported public interface; it is an internal implementation package.

Key Procedures and Functions

Two documented procedures constitute the entry points of this package:

  • CS_SR_VERIFY_ALL — The procedure is associated with verification logic for Service Request processing. Based on its name and the package context, it drives validation checks that must be satisfied before Service Request workflow notifications or event-driven actions are dispatched.
  • CS_SR_SENDNTF_TO_NONFS_TASK — The procedure dispatches a notification relating to a Service Request to a non-field-service task. It is the routine that bridges Service Request activity with the task records maintained in the JTF task tables, ensuring that notification content is delivered to the appropriate task recipients.

No parameter lists are documented in the ETRM metadata, and none are reproduced here. The ETRM record lists only these two program units as the documented procedures and functions within the package.

Tables Accessed

The package reads and writes the following tables, referenced through APPS synonyms:

  • WF_EVENT_T — The Oracle Workflow event message type, used to construct, raise, or interpret business event payloads that flow through the subscription mechanism.
  • JTF_RS_RESOURCE_EXTNS — Resource extension information, used to identify and validate the resource associated with a Service Request or task.
  • JTF_TASKS_B — The base task table, holding the task records to which Service Request notifications are targeted.
  • JTF_TASK_ASSIGNMENTS — Task assignment records, used to determine the owner or assignee of the non-field-service task receiving the notification.
  • JTF_TASK_AUDITS_B — The task audit base table, written to capture an audit trail as notification or task state changes occur.
  • JTF_TASK_TYPES_B — Task type definitions, used to classify the task and confirm that the notification is directed to a non-field-service task type.

Together these tables support the full notification path: event payload in, resource and task identification, task type qualification, assignment resolution, and audit logging.

Usage Notes

The package is not referenced by any other documented package, and it is not exposed as a supported public API. It is invoked internally by the Service Request workflow and by the Oracle Workflow Business Event System when the subscriptions it manages are triggered. In practice, customizations should avoid calling it directly; instead, Service Request workflow configuration, subscription definitions, and task notification setup should be maintained through the supported Service and Workflow configuration tools. Because the ETRM metadata documents no parameters and no formal API classification, any custom invocation carries upgrade risk across 12.1.1 and 12.2.2 and should be validated against the actual package specification in the target instance.