Search Results ahl_pc_approval_pvt




Overview
Explore in AI Chat

Overview

APPS.AHL_PC_APPROVAL_PVT is a private PL/SQL package within the Oracle E-Business Suite Application Object Library (AHL) schema. The "PVT" suffix denotes a private API classification, indicating that the package is intended for internal use by Oracle's own approval-processing infrastructure rather than as a published integration point for customer extensions. Its business function centers on the approval lifecycle of Product Change (PC) records managed by the AHL Product Change module, encompassing the notification, routing, status transition, and reversion logic that governs how change requests move through the approvals chain. The package is VALID in the APPS schema and, per the documented metadata, is referenced by no other packages, confirming its role as a terminal internal component rather than a shared library component.

Key Procedures and Functions

The documented metadata identifies ten procedures and functions, each addressing a discrete element of the approval workflow:

  • SET_ACTIVITY_DETAILS — Establishes or updates the activity-level detail associated with an approval action, providing the contextual record that downstream notification and status routines rely upon.
  • NTF_APPROVAL — Generates the primary approval notification, alerting the designated approver that an approval action is pending.
  • NTF_FORWARD_FYI — Issues a courtesy (For Your Information) notification when an approval item is forwarded to another party.
  • NTF_APPROVED_FYI — Emits the informational notification confirming that an item has been approved.
  • NTF_REJECTED_FYI — Emits the informational notification confirming that an item has been rejected.
  • NTF_FINAL_APPROVAL_FYI — Sends the informational notification marking the completion of final approval in the chain.
  • NTF_APPROVAL_REMINDER — Produces reminder notifications for approvals that remain outstanding.
  • NTF_ERROR_ACT — Handles notification of an error condition encountered during approval processing, supporting exception awareness.
  • UPDATE_STATUS — Advances the approval status of the associated Product Change record in accordance with the action taken.
  • REVERT_STATUS — Rolls back the approval status to a prior state, supporting undo or resubmission scenarios.

Tables Accessed

The package operates against the AHL_PC_HEADERS_B table, accessed through its APPS synonym. This table stores the Product Change header records that drive the approval workflow; the UPDATE_STATUS and REVERT_STATUS routines derive their status column writes from this entity, while the notification procedures read header context to populate message content and routing. No other base tables are documented as direct dependencies, which is consistent with the package's narrow, focused scope.

Usage Notes

Because AHL_PC_APPROVAL_PVT is a private API, it is not intended for direct invocation by customer-developed code. Oracle EBS applications—most notably the Product Change approval forms and the associated workflow and notification concurrent processing—call this package internally to drive status transitions and to dispatch the approval notification family. The absence of external package references reinforces that the supported integration path for Product Change approvals lies through seeded forms, workflow definitions, and Oracle Workflow notification mailers rather than through this package. Developers extending Product Change approval behavior should treat AHL_PC_APPROVAL_PVT as an internal implementation detail and avoid binding custom logic to it, since private APIs may change between point releases such as 12.1.1 and 12.2.2 without a public compatibility guarantee.