Search Results set_activity_details

Overview

APPS.AHL_UC_ACL_WF_APPR_PVT is a private PL/SQL package body within the Oracle E-Business Suite Application Object Library (AHL) module. Its name reflects its purpose: it supports the Workflow approval lifecycle for "UC" (Unit Configuration) entities of the ACL (Approval Checklist) type. In the Oracle EBS 12.1.1 and 12.2.2 environments, packages ending in _PVT are implementation-level constructs; they carry the actual procedural logic that public APIs and Workflow activity handlers defer to. This package is therefore not intended for direct invocation by external callers but is instead wired into Oracle Workflow as the backing implementation for activities in the Unit Configuration ACL approval process.

The package header source confirms an internal package name AHL_UC_ACL_WF_APPR_PVT and references a private cursor, get_uc_header_det, which resolves the active Unit Configuration header record (name, object version number, unit configuration status code, and active UC status code) using effective-date filtering on active_start_date and active_end_date. This establishes the package's central role: driving approval workflow state transitions against the Unit Configuration header.

Key Procedures and Functions

The ETRM metadata documents ten procedures and functions, all focused on the approval workflow cycle:

• SET_ACTIVITY_DETAILS — The procedure referenced by the user's search. It is the standard Workflow activity callback signature (itemtype, itemkey, actid, funcmode, resultout). The source excerpt shows it retrieves OBJECT_ID and OBJECT_VER item attributes via wf_engine.getitemattrnumber, initializes the FND message list, and defaults the object and approval type constants (UC_ACL and CONCEPT) used to build the approval subject and rule context.
• NTF_FORWARD_FYI, NTF_APPROVED_FYI, NTF_FINAL_APPROVAL_FYI, NTF_REJECTED_FYI — Notification procedures that generate FYI (for-your-information) messages to the relevant participants when an ACL approval is forwarded, approved, reaches final approval, or is rejected, respectively.
• NTF_APPROVAL — Builds and sends the primary approval notification requesting an approver's action on the Unit Configuration ACL.
• NTF_APPROVAL_REMINDER — Issues a reminder notification to approvers who have not yet responded within the defined timeout.
• NTF_ERROR_ACT — Handles error conditions arising during the workflow, producing an error notification path.
• UPDATE_STATUS — Advances the Unit Configuration header's status and approval state upon successful approval.
• REVERT_STATUS — Reverses a previously applied status change, typically when an approval is rejected, withdrawn, or an error rolls the transaction back.

Tables Accessed

The documented table reference is AHL_UNIT_CONFIG_HEADERS, accessed through the APPS synonym. This table stores the header-level Unit Configuration record, including the status codes and effective dates used by get_uc_header_det. The package reads it to resolve the approval subject and version context, and UPDATE_STATUS / REVERT_STATUS logically write status code changes back to this table (or through the public API that owns it). No other tables are documented in the ETRM metadata.

Usage Notes

Because this is a _PVT package with zero inbound package references (per the ETRM "Referenced by 0 other packages" metadata), it should not be called directly from custom code. It is invoked exclusively by the Oracle Workflow engine when executing activities in the Unit Configuration ACL approval workflow definition. In 12.1.1 and 12.2.2, the standard invocation path is: a user submits a Unit Configuration for approval from the relevant AHL module form or concurrent process; the workflow item type is created; and each activity node calls the corresponding procedure here via its SET_ACTIVITY_DETAILS or notification callback entries. Customizations should target the public API layer instead of this private package to remain upgrade-safe.