Search Results object_ver

Overview

APPS.AHL_MC_APPROVALS_PVT is a private PL/SQL package body within the Oracle E-Business Suite Product Lifecycle Management (PLM) module, specifically belonging to the AHL (Approvals and Lifecycle Management) schema family. Its primary business function is to support the workflow-driven approval lifecycle of Master Configuration (MC) records stored in AHL_MC_HEADERS_B. The package integrates PLM approval processes with the Oracle Workflow engine, providing the activity callbacks, notification handlers, and status transition logic required to route MC concept records through an approval hierarchy. Because it is classified as a PVT (private) API, it is not exposed as a public integration point; instead it is consumed internally by the Oracle Workflow item type definition governing MC approvals.

The header comment references version control metadata (AHLVMWFB.pls, 120.0), confirming the package is a workflow callback implementation rather than a general-purpose business API. Its central role is callable activity logic bound to workflow activity functions such as SET_ACTIVITY_DETAILS, together with a set of notification helper procedures.

Key Procedures and Functions

The package defines ten documented procedures that fall into three functional groups.

• SET_ACTIVITY_DETAILS — the core workflow activity function. It resolves the workflow item key into a Master Configuration header identifier, opens the internal check_mc_exists cursor to validate the record against object_version_number, populates an AHL_GENERIC_APRV_PVT.OBJRECTYP structure, and initializes approval context before dispatching to the appropriate mode of work.
• NTF_APPROVAL, NTF_APPROVAL_REMINDER, NTF_FORWARD_FYI, NTF_APPROVED_FYI, NTF_FINAL_APPROVAL_FYI, NTF_REJECTED_FYI, NTF_ERROR_ACT — notification handlers covering the full approval communication lifecycle. These generate and dispatch FYI, reminder, rejection, approval, and error notifications to the appropriate participants.
• UPDATE_STATUS and REVERT_STATUS — status transition procedures that commit or roll back the approval state of the MC record, supporting workflow compensation and rejection paths.

Tables Accessed

The only documented table accessed is AHL_MC_HEADERS_B, referenced through an APPS synonym. It is queried by the check_mc_exists cursor, which selects mc_header_id and name filtered by mc_header_id and object_version_number. The nvl() on the version parameter means validation degrades gracefully when no version is supplied. Because AHL_MC_HEADERS_B is the base (non-translated) table for Master Configuration headers, this access drives both record validation and identity resolution for downstream status updates.

Usage Notes

This package is invoked exclusively by the Oracle Workflow engine as part of the MC approval item type. It is not called from Oracle Forms or concurrent programs directly, and the metadata confirms zero other package references, reinforcing its role as a terminal workflow handler. The header comment references "object_ver" via the p_object_version_number parameter and the object_version_number column, indicating the package relies on Oracle EBS optimistic locking. Installations on 12.1.1 and 12.2.2 may need to verify that the package body was recompiled after any online patching cycle, since workflow callbacks that remain invalid will stall approval routing. Debugging is supported through FND_LOG calls that write to level_procedure and level_statement, which administrators can enable via the standard FND logging profile options when diagnosing stalled MC approvals.