Search Results update_pc_header

Overview

APPS.AHL_PC_HEADER_PVT is a private PL/SQL package within the Oracle E-Business Suite Enterprise Asset Management (eAM) and Complex Maintenance, Repair, and Overhaul (CMRO) product family. It belongs to the AHL schema family of APIs associated with the Oracle Complex Maintenance, Repair and Overhaul (formerly Enterprise Asset Management for aerospace and defense) application. The package encapsulates the internal implementation logic for managing production control (PC) headers, which are the top-level records defining production or maintenance work packages executed against configured assets and item instances. As a Private (PVT) API, it is not intended for direct external invocation; instead, the corresponding public package APPS.AHL_PC_HEADER_PUB exposes the supported interfaces and delegates to this private package for the underlying business logic.

The package has a documented status of VALID and is classified as a PVT API within the ETRM (E-Business Suite Technical Reference Manual) for release 12.2.2. In Oracle EBS 12.1.1, the same package implements equivalent functionality under the AHL module.

Key Procedures and Functions

The ETRM metadata documents five procedures/functions within AHL_PC_HEADER_PVT:

• CREATE_PC_HEADER — Creates a new production control header record. It validates and inserts the header definition into the base table and its translations.
• UPDATE_PC_HEADER — Modifies an existing production control header, applying attribute changes and maintaining the associated secondary (translation) records.
• DELETE_PC_HEADER — Removes a production control header, typically subject to referential integrity and status validation before deletion.
• COPY_PC_HEADER — Duplicates an existing PC header and its associated structure, enabling reuse of a defined production control template or prior work package.
• INITIATE_PC_APPROVAL — Initiates the approval workflow for a production control header, transitioning it into an approval-eligible state and invoking downstream approval logic.

These procedures collectively provide the lifecycle operations for PC headers. The package does not document parameter lists in the excerpt, so consumers should rely on APPS.AHL_PC_HEADER_PUB for supported signatures.

Tables Accessed

The package reads and writes several core AHL and CSI tables, accessed through APPS synonyms:

• AHL_PC_HEADERS_B and AHL_PC_HEADERS_B_S — the base and secondary tables holding the production control header definitions.
• AHL_PC_ASSOCIATIONS, AHL_PC_NODES_B — supporting relationships and node structures tied to headers.
• AHL_DOC_TITLE_ASSOS_B and AHL_DOC_TITLE_ASSOS_TL — document title associations, including translated values.
• AHL_MR_HEADERS_B and AHL_MR_EFFECTIVITIES — maintenance requirement headers and their effectivity records, relevant when validating applicability.
• AHL_UNIT_CONFIG_HEADERS — unit configuration headers linking production control to configured assets.
• CSI_ITEM_INSTANCES and MTL_SYSTEM_ITEMS_KFV — item instance and item master views used to resolve asset and item references.
• DUAL and PLITBLM — utility references used for PL/SQL constructs and bulk operations.

Usage Notes

AHL_PC_HEADER_PVT is referenced by APPS.AHL_PC_HEADER_PUB, APPS.AHL_PC_APPROVAL_PVT, and itself, and it references AHL_PC_HEADER_PUB, FND_API, and FND_GLOBAL. It is invoked indirectly whenever a user creates, updates, copies, deletes, or submits a production control header for approval through the CMRO/eAM user interface forms, concurrent programs, or the public API. Custom integrations should call AHL_PC_HEADER_PUB rather than this private package, since the private API is subject to change without notice across EBS releases and patch levels.