Search Results is_wf_item_type_enabled




Overview
Explore in AI Chat

Overview

APPS.CSM_HA_SERVICE_PUB is a public PL/SQL package in Oracle E-Business Suite that supports High Availability (HA) configuration management for Oracle Workflow components within the CSM (Customer Service / Service) module. The package exposes a set of utility functions that allow callers to determine whether specific Workflow objects—item types, events, and Business Event System (BES) subscriptions—are currently enabled or active in the environment. By centralizing these checks in a single published API, the package provides a consistent and reusable mechanism for external programs to query HA-related status without directly accessing underlying configuration tables.

The package is declared with AUTHID CURRENT_USER, meaning that its executable privileges are evaluated against the invoking schema rather than the defining schema. This design allows the package to respect the security context of the calling session while still operating against APPS-owned data. The header comment indicates a last revision date of April 2010, consistent with the 12.1.1 and 12.2.2 release lineage.

Key Procedures and Functions

The package defines four public functions, each returning a VARCHAR2 value that typically represents a status indicator (for example, Y/N or an equivalent flag).

  • GET_HA_STATUS — Returns the overall High Availability status for the Workflow configuration managed by this package. It serves as the primary entry point for determining whether the HA-related Workflow infrastructure is active.
  • IS_WF_ITEM_TYPE_ENABLED — Accepts a Workflow item type identifier and reports whether that item type is enabled. This is the function most directly associated with the search term is_wf_item_type_enabled.
  • IS_WF_EVENT_ENABLED — Accepts a Workflow event name and reports whether the specified event is enabled.
  • IS_WF_BES_ENABLED — Accepts a subscription GUID (RAW) and reports whether the corresponding Business Event System subscription is enabled.

Together these functions provide a granular view of which item types, events, and subscriptions participate in the HA configuration. No parameter lists beyond those shown in the metadata should be assumed.

Tables Accessed

The package references a single documented table through APPS synonyms: CSM_HA_ACTIVE_WF_COMPONENTS. This table stores the set of Workflow components that are active in the HA context. Each function queries this table to determine the enabled status of the requested item type, event, or subscription GUID. Because access is through APPS synonyms, the package reads the canonical EBS definition of active HA Workflow components, ensuring that all callers see a consistent configuration view.

Usage Notes

CSM_HA_SERVICE_PUB is classified as a PUB (public) API, indicating it is intended for use by external callers rather than being restricted to internal package logic. In practice it is invoked from custom PL/SQL code, from other EBS packages, and potentially from Forms-based or concurrent-program logic that must conditionally process Workflow components based on their HA enablement state. The metadata notes that the package is referenced by one other package, confirming it is integrated into the broader CSM package dependency chain.

Typical use cases include gating business processing on whether a specific Workflow item type is enabled, validating event and subscription availability before raising or subscribing to Business Events, and performing diagnostic checks on HA status. Developers should treat the returned status values as authoritative for the current session and avoid duplicating the underlying query logic against CSM_HA_ACTIVE_WF_COMPONENTS, since the package encapsulates that access and its associated security semantics.