Search Results ahl_wf_notification_pvt




Overview
Explore in AI Chat

Overview

The APPS.AHL_WF_NOTIFICATION_PVT package body is a private (PVT-classified) PL/SQL package within the Oracle E-Business Suite Applications schema. It belongs to the AHL product family, which covers Oracle Complex Maintenance, Repair and Overhaul (CMRO) and related asset lifecycle functionality. The package encapsulates the notification logic used to drive Oracle Workflow and Oracle Alert style approvals and informational messages for AHL business flows. Its principal business role is to assemble and dispatch OA Framework based workflow notifications, most notably approval notifications that must be rendered as OA (Oracle Applications) notification views within the Worklist rather than plain text notifications.

Because the object is classified as PVT, it is not part of the public integration surface of the AHL application. It is designed to be called by other AHL packages — principally AHL_GENERIC_APRV_PVT, its primary client — which handle the broader approval routing logic. The package name itself is an internal one, which is why the object appears in dependency reports and ETRM metadata but is not listed as a supported public API.

Key Procedures and Functions

The packaged metadata documents a single entry point:

  • LAUNCH_OA_NOTIFICATION — The core routine of this package. It constructs and launches an Oracle Workflow notification in OA Framework format. Its responsibilities include resolving the notification recipient context, preparing the OA notification payload (attributes, message content, and action links), and invoking the Workflow engine to dispatch the notification. Because the metadata does not expose its parameter list, the exact signature should be confirmed from the deployed source in the environment. The procedure is intended to be invoked internally by AHL approval infrastructure, not directly by end users or external integrations.

Tables Accessed

The ETRM dependency listing records a reference to DBMS_RANDOM, the Oracle-supplied PL/SQL package used for pseudo-random number generation. Within notification logic this dependency is typically associated with generating unique notification identifiers or correlation tokens. The dependency data also includes AHL_JTF_RS_EMP_V, an AHL resource / employee view that resolves recipient and approver details from the JTF resource model; the package uses this view to determine who should receive the notification and to populate recipient attributes.

No base application tables are recorded directly against this package. All persistent reads and writes are delegated to the underlying workflow and approval packages, keeping this object a thin, focused notification utility.

Usage Notes

AHL_WF_NOTIFICATION_PVT is an internal utility and should not be called directly from custom code. In practice it is invoked when an AHL approval or informational event occurs and the system must raise an OA notification to a responsible party, such as an approver in a maintenance or repair workflow. The documented dependency chain confirms that AHL_GENERIC_APRV_PVT is a caller, meaning the generic approval framework for AHL routes through this package when building OA notifications.

The package relies on standard EBS infrastructure packages: FND_API for the API error-handling and savepoint model, FND_GLOBAL for session context such as user and responsibility identifiers, FND_MSG_PUB for message dictionary access, FND_LOG for diagnostic logging, WF_ENGINE to start workflow activity and deliver notifications, and WF_DIRECTORY to resolve roles and users at notification time. Because it is valid and standard in both Oracle EBS 12.1.1 and 12.2.2, the object is present in the APPS schema in both releases with no publicly documented interface change. Customizations that require AHL approval notifications should extend the calling approval packages rather than modify or invoke this private package directly, and any modification carries the usual risk of invalidating dependent objects such as AHL_GENERIC_APRV_PVT.