Search Results cln_ch_event_subscription_pkg




Overview
Explore in AI Chat

Overview

CLN_CH_EVENT_SUBSCRIPTION_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. Its documented classification is OTHER, reflecting a utility role rather than a formal public API. The package supports the Collaboration and Negotiation (CLN) product family by managing event subscriptions within the Oracle Workflow event system. In EBS 12.1.1 and 12.2.2, business events raised during sourcing, negotiation, and collaboration flows must be mapped to workflow subscriptions that trigger downstream processing. CLN_CH_EVENT_SUBSCRIPTION_PKG encapsulates the creation, maintenance, and propagation of those subscriptions. The package is validated and depends on several CLN and Workflow components, including CLN_CH_COLLABORATION_PKG, CLN_NP_PROCESSOR_PKG, ECX_CLN_DEBUG_PUB, FND_API, FND_PROFILE, WF_ENGINE, and WF_EVENT. It is referenced by one other package but does not itself reference any application tables outside the Workflow event and parameter structures.

Key Procedures and Functions

The package exposes five documented routines, each addressing a distinct aspect of subscription lifecycle management:

  • CREATE_EVENT_SUB — Establishes a new event subscription record, registering an event and its associated agent or handler within the Workflow event framework.
  • UPDATE_EVENT_SUB — Modifies the attributes of an existing subscription, such as enabling, disabling, or altering the event-to-handler mapping.
  • ADD_MESSAGES_EVENT_SUB — Associates message-related event content with a subscription, supporting messaging or notification scenarios driven by collaboration activity.
  • ADD_COLLABORATION_EVENT_SUB — Binds collaboration events from the CLN layer to workflow subscriptions, ensuring collaboration actions raise the correct business events.
  • NOTIFICATION_EVENT_SUB — Configures subscriptions that generate workflow notifications when the subscribed event fires.

All five routines follow the standard EBS API convention of returning a status and accepting a standard parameter list, consistent with reliance on FND_API. No parameter-level detail is documented here, and none should be assumed beyond the standard EBS API pattern.

Tables Accessed

The package accesses three documented structures, all Workflow-oriented:

  • WF_EVENT_T — The Workflow object type representing an event, used to populate or interrogate event context when creating or updating subscriptions.
  • WF_PARAMETER_LIST_T — The Workflow parameter list type, used to assemble the parameter payloads passed into Workflow event and subscription calls.
  • DUAL — The standard single-row utility used for scalar lookups or function-call side effects.

No application data tables are documented as direct dependencies, confirming that persistence for subscriptions is delegated to the Workflow engine rather than to CLN-owned tables.

Usage Notes

CLN_CH_EVENT_SUBSCRIPTION_PKG is typically invoked during setup and configuration, or programmatically when the CLN collaboration and negotiation flows raise or subscribe to business events. It may be called from custom code, from other CLN packages such as CLN_CH_COLLABORATION_PKG and CLN_NP_PROCESSOR_PKG, or during subscription seeding for a deployment. Because the package wraps WF_ENGINE and WF_EVENT, invocation prompts the Workflow engine to raise, register, or alter event subscriptions. Standard FND_API conventions apply: callers should check the returned status and handle error messages accordingly. FND_PROFILE access indicates behavior may be driven by profile options, and ECX_CLN_DEBUG_PUB dependency provides debugging support. The package should be treated as an internal utility rather than a supported public API, and direct modification of Workflow subscription data should be avoided in favor of these routines.