Search Results okc_async_pvt




Overview
Explore in AI Chat

Overview

OKC_ASYNC_PVT is a private PL/SQL package body owned by the APPS schema within the Oracle E-Business Suite Contracts (OKC) module. The package supports the asynchronous processing layer of the contract lifecycle, specifically the workflow-driven notifications, approvals, and event callbacks that underpin contract authoring flows in Oracle EBS 12.1.1 and 12.2.2. Its API classification of "PVT" indicates it is an internal, non-public package intended to be invoked by other OKC constructs rather than called directly by end users or external integrations.

In practical terms, OKC_ASYNC_PVT manages the runtime side of asynchronous contract events: routing workflow notifications, resolving recipient identities, applying muting preferences to suppress or redirect notification traffic, and reacting to approval actions such as accept, reject, timeout, and periodic escalation. This utility is central to ensuring that long-running contract operations do not block the user session and that contract stakeholders receive the correct notifications at the correct points.

Key Procedures and Functions

The documented interface exposes twenty procedures and functions. Grouped by purpose:

  • Routing and dispatch: WF_CALL, RESOLVER_CALL, SELECTOR, LOOP_CALL, GET_DOC. These handle invocation of workflow APIs, resolution of role or user recipients, selection of notification targets, iteration over workflow callbacks, and retrieval of the originating document context.
  • Notification responses: ACCEPT, REJECT, TIMEOUT, PERIODIC, TIME_OVER. These process the outcome of a notification event — approval, rejection, expiration, periodic re-notification, and timeout handling.
  • Muting controls: NO_EMAIL, SUCCESS_MUTE, ERROR_MUTE, FYI_MUTE, MUTE_NXT_PFMR, MUTE_K_ADMIN, MUTE_SIGNER, UNMUTE. These govern whether and how notification traffic is suppressed for specific performers, contract administrators, or signers, and allow restoration of normal notification behavior.
  • Utility and metadata: GET_VERSION, FUN_GENERIC. These supply package versioning and a generic functional entry point used by internal callers.

Tables Accessed

OKC_ASYNC_PVT reads and writes against the following documented objects, referenced through APPS synonyms:

Usage Notes

OKC_ASYNC_PVT is an internally invoked package. It is called by OKC workflow activities, by the Contracts forms layer when asynchronous notifications must be raised or answered, and by concurrent programs that process pending contract workflow events. Three other database packages reference it, and it in turn depends on OKC_API, OKC_WF, OKC_DEBUG, WF_CORE, WF_ENGINE, FND_API, FND_MSG_PUB, and FND_PROFILE.

Because it is a private package, customizations should avoid direct calls to OKC_ASYNC_PVT; integration points should use the public OKC_API surface instead. The package status is VALID, confirming availability in the documented 12.2.2 instance. Debug output can be captured through the OKC_DEBUG dependency when troubleshooting notification suppression or approval flow behavior.