Search Results uc_acl

Overview

APPS.AHL_UC_APPROVALS_PVT is a private PL/SQL package body belonging to the Oracle E-Business Suite Advanced Product Catalog (AHL) application, specifically the Unit Configuration (UC) module. Its principal business function is to manage the approval lifecycle of Unit Configurations. A Unit Configuration represents a defined combination of components, features, and options that must be reviewed and authorized before it becomes active for downstream usage. This package encapsulates the private logic that drives approval initiation, approval completion, and the approval workflows associated with quarantine and deactivation scenarios.

As a private (PVT) API, the package is not intended for direct external invocation by customers or integrators. It is invoked internally by the corresponding public APIs and by the Unit Configuration business logic that governs the state transitions of a configuration header. The package supports standard Oracle API conventions, including API version, initialization message list, commit control, and validation level parameters, together with the standard return status, message count, and message data output parameters. It is referenced by two other packages, which confirms its role as a supporting component rather than a standalone entry point.

Key Procedures and Functions

The package exposes five documented procedures that collectively cover the approval and quarantine lifecycle:

• INITIATE_UC_APPROVALS — Initiates the approval process for a Unit Configuration when a user submits it for approval. It operates against a specific configuration header identified by its header identifier and object version number.
• COMPLETE_UC_APPROVAL — Completes the approval cycle for a Unit Configuration, applying the outcome of the approval process to the configuration record.
• INITIATE_QUARANTINE — Starts the quarantine process for a Unit Configuration, placing it under review or restriction pending resolution.
• INITIATE_DEACTIVATE_QUARANTINE — Begins the process of deactivating an existing quarantine, allowing the configuration to move out of the quarantined state.
• COMPLETE_QUARANTINE_APPROVAL — Finalizes the approval associated with the quarantine workflow, completing the deactivation or resolution.

Each procedure follows the standard API parameter pattern documented for INITIATE_UC_APPROVALS, including p_api_version, p_init_msg_list, p_commit, p_validation_level, x_return_status, x_msg_count, and x_msg_data.

Tables Accessed

The package accesses the base table AHL_UNIT_CONFIG_HEADERS through its APPS synonym. This table stores the header-level records for Unit Configurations, including identifying keys, version numbers, and status attributes. The package reads and updates this table to reflect changes in approval status, quarantine status, and deactivation state as users submit configurations for approval or move them through the quarantine lifecycle. The object version number passed into INITIATE_UC_APPROVALS corresponds to the version column maintained on this header record, supporting optimistic locking during concurrent updates.

Usage Notes

AHL_UC_APPROVALS_PVT is invoked internally by the Unit Configuration approval forms and related business logic in Oracle EBS 12.1.1 and 12.2.2. When a user submits a Unit Configuration for approval, the submit action calls INITIATE_UC_APPROVALS. When the approval workflow concludes, COMPLETE_UC_APPROVAL applies the result. Quarantine-related actions similarly route through INITIATE_QUARANTINE, INITIATE_DEACTIVATE_QUARANTINE, and COMPLETE_QUARANTINE_APPROVAL. Because the package is classified as a private API, custom code should not call these procedures directly; instead, developers should use the supported public APIs or the seeded Unit Configuration forms and concurrent programs that wrap this logic. The G_DEBUG flag derived from AHL_DEBUG_PUB.is_log_enabled indicates the package supports the standard AHL debugging framework for diagnostics.