Search Results add_collaboration_event_sub




Overview
Explore in AI Chat

Overview

CLN_CH_EVENT_SUBSCRIPTION_PKG is an Oracle E-Business Suite PL/SQL subscription package owned by the APPS schema and classified under the ETRM as an "OTHER" API type. Its business purpose is to bridge the Oracle Workflow Business Event System with the Oracle Collaboration (CLN) product family, allowing collaborations and collaboration messages to be created, updated, or appended automatically in response to events raised or updated within a workflow. As stated in the package header comments, the package "is called to create or update collaboration based on events raised/updated by calling this package." It was originally authored by Rahul Krishan in July 2002 and is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer. In 12.1.1 and 12.2.2 the package remains a standard subscription handler that can be registered against Workflow event subscriptions, providing a declarative, event-driven integration point between workflow activity and collaborative objects.

Key Procedures and Functions

The package exposes five documented callable units, each designed to be invoked as a Workflow event subscription handler. All are functions returning VARCHAR2, consistent with the standard Oracle Workflow subscription function signature.

  • CREATE_EVENT_SUB — Public subscription function attached to an event raised from a workflow item; used to create a new collaboration.
  • UPDATE_EVENT_SUB — Public subscription function attached to a workflow event; used to update an existing collaboration.
  • ADD_MESSAGES_EVENT_SUB — Public subscription function used to add messages to an existing detail collaboration row.
  • ADD_COLLABORATION_EVENT_SUB — Public function that obtains the parameters for the update/create collaboration event and, based on those parameters, calls either the CREATE_COLLABORATION or UPDATE_COLLABORATION API.
  • NOTIFICATION_EVENT_SUB — Public subscription function documented in the ETRM metadata, intended to handle notification-related workflow events for the collaboration subscription flow.

Tables Accessed

The documented objects referenced through APPS synonyms are limited to Workflow infrastructure structures rather than collaboration base tables. WF_EVENT_T is the Oracle Workflow event message type, passed into and out of each subscription function so the workflow engine can carry event payload data. WF_PARAMETER_LIST_T is the Workflow parameter list type used to read and pass the parameter values (such as collaboration identifiers and message content) required to build or update a collaboration. DUAL is referenced for trivial single-row calculations and sequencing. Because the package is declared AUTHID CURRENT_USER and delegates the actual persistence work to CREATE_COLLABORATION and UPDATE_COLLABORATION, the underlying collaboration tables are written indirectly via those APIs rather than being named directly in this package.

Usage Notes

CLN_CH_EVENT_SUBSCRIPTION_PKG is invoked by the Oracle Workflow Business Event System whenever a registered event subscription fires, not by end-user forms or concurrent programs directly. Administrators associate CREATE_EVENT_SUB, UPDATE_EVENT_SUB, ADD_MESSAGES_EVENT_SUB, ADD_COLLABORATION_EVENT_SUB, or NOTIFICATION_EVENT_SUB with an event or workflow activity through the Workflow Administrator responsibility, and the Workflow engine then calls the mapped function at runtime, passing the subscription GUID and the event object. Custom code should not call these functions outside of the subscription framework, since the WF_EVENT_T and parameter-list structures must be constructed correctly. The ETRM records that this package is referenced by one other package, confirming its role as a dependent integration component. Because it is AUTHID CURRENT_USER, the invoking user requires the appropriate collaboration and workflow execution privileges.