Search Results ntf_forward_fyi

Overview

APPS.AHL_UC_ACL_WF_APPR_PVT is a private PL/SQL package within the Oracle E-Business Suite Application Object Library schema, belonging to the Oracle Approval Management (AHL) product family. Its header identifies it as AHLVQWFS.pls (version 120.0, dated 2005/06/29), confirming its long-standing role across the 12.1.1 and 12.2.2 releases. The package is classified as PVT (private), meaning it is intended for internal consumption by other Oracle workflow components rather than as a published integration API.

The primary business function of this package is to support the Oracle Workflow approval cycle for AHL Unit Configuration records. It manages the generation of FYI (For Your Information) notification documents, approval and rejection notifications, reminder messages, and the transactional state updates that accompany each approval decision. The metadata explicitly notes its use by Oracle ASO Approval, indicating integration with Oracle Advanced Supply Chain and Order Management approval workflows. By centralizing notification document construction and activity attribute handling, the package ensures consistent, structured communication to approvers and stakeholders throughout the approval lifecycle.

Key Procedures and Functions

The package exposes ten documented procedures. Several of these are notification document generators that produce either text or HTML output buffers for display in Workflow messages:

• SET_ACTIVITY_DETAILS — Sets item attribute details for the workflow activity. This is a standard Workflow callback invoked to populate item type attributes.
• NTF_FORWARD_FYI — Generates the FYI document used when a notification is forwarded to additional recipients.
• NTF_APPROVED_FYI — Generates the FYI document communicating that a record has been approved.
• NTF_FINAL_APPROVAL_FYI — Produces the FYI document for the final approval event in the workflow.
• NTF_REJECTED_FYI — Generates the FYI document communicating rejection of a submission.
• NTF_APPROVAL — Builds the primary approval request notification presented to the approver.
• NTF_APPROVAL_REMINDER — Constructs the reminder notification dispatched when an approval remains pending.
• NTF_ERROR_ACT — Produces an error notification when the approval activity encounters a fault condition.
• UPDATE_STATUS — Applies the status transition to the underlying AHL Unit Configuration record following an approval or rejection action.
• REVERT_STATUS — Restores a record's prior status, typically invoked when an approval process is withdrawn, terminated, or rolled back.

Tables Accessed

The package references a single documented base table through APPS synonyms: AHL_UNIT_CONFIG_HEADERS. This table stores the header records for Unit Configuration definitions within the AHL module. The package reads from it to resolve item key and document context when generating notifications, and the UPDATE_STATUS and REVERT_STATUS procedures write to it to persist the approval outcome (for example, an approval flag or lifecycle status code) after a workflow decision is recorded.

Usage Notes

Because this package is classified PVT and is referenced by zero other packages per the ETRM metadata, it is invoked directly by Oracle Workflow function activities rather than by external PL/SQL callers. In practice, the notification procedures are wired as the function attributes of notification activities in the AHL approval workflow definition, while SET_ACTIVITY_DETAILS serves as the runnable callback for the activity node itself. UPDATE_STATUS and REVERT_STATUS are executed at the terminal and rollback points of the approval process.

Custom implementations should not call this package directly; the supported integration path for AHL approvals is through the workflow process definition. The FYI procedures accept a display type parameter distinguishing text/plain from text/html output, so any diagnostic inspection or extension should preserve both format branches. Given the header's static version and the package's private designation, changes are delivered only through Oracle patches and are not exposed for customer extension.