Search Results ahl_prd_mtltxn_pvt




Overview
Explore in AI Chat

Overview

APPS.AHL_PRD_PARTS_CHANGE_PVT is a private (PVT) PL/SQL package within the Oracle E-Business Suite Discrete Manufacturing and Enterprise Asset Management (eAM) product family. In Oracle EBS 12.1.1 and 12.2.2, it belongs to the Oracle Complex Maintenance, Repair and Overhaul (CMRO) / Asset Lifecycle Management (ALM) module, specifically the AHL ("Asset Health / Maintenance") schema prefix used by the Maintenance Management and Production (MRO) application.

The package encapsulates the business logic that governs parts-change transactions on a production or maintenance work order. When a maintenance technician replaces, returns, or relocates a component item instance during a work order operation, this package validates the request, processes the associated material transaction, and updates the work-order and unit-configuration records accordingly. It acts as the transactional core invoked by public wrapper packages and disposition, non-routine, and material-transaction processing streams. Because the object is classified as a private API (PVT), it is not intended to be called directly by external or customer-written code; it is an internal implementation layer supporting the public AHL_PRD_* APIs.

Key Procedures and Functions

The documented package exposes seven program units:

  • PROCESS_PART — The principal entry point for executing a parts-change event. It coordinates validation and invokes downstream material-transaction and unit-configuration handling for the part being processed.
  • GET_UNIT_CONFIG_INFORMATION — Retrieves unit-configuration data associated with the item instance involved in the change, providing the structural context (configuration header and instance relationship) required before a swap can be committed.
  • UPDATE_MATERIAL_RETURN — Handles the return of material to inventory or to the work order, updating the corresponding material-transaction records when a removed part is returned.
  • RETURNTO_WORKORDER_LOCATOR — Determines and applies the target locator when material is being returned to a work order, ensuring the correct subinventory and locator are used.
  • MOVE_INSTANCE_LOCATION — Relocates an installed item instance to a new location as part of the configuration change, reflecting the physical movement of the part.
  • GET_UNITCONFIG_ID — Resolves and returns the unit-configuration identifier for a given instance, used to link the change to the correct configuration hierarchy.
  • UPDATE_PART_CONDITION — Records or updates the condition of a part following removal or installation, supporting the maintenance history and condition-tracking requirements of the eAM process.

Tables Accessed

The package reads and writes a range of AHL, CSI, INV, and FND tables through APPS synonyms:

Usage Notes

Because AHL_PRD_PARTS_CHANGE_PVT is a private package, it is invoked indirectly through public APIs and processing engines. The dependency listing shows it is referenced by eight other packages, including AHL_PRD_DISPOSITION_PVT, AHL_PRD_MTLTXN_PVT, AHL_PRD_NONROUTINE_PVT, and AHL_PRD_UTIL_PKG, and it in turn depends on AHL_PRD_MTLTXN_PVT, AHL_UC_VALIDATION_PUB, and FND_API. In practice it is triggered from the Maintenance Management work-order forms when a technician performs a parts change, from concurrent programs that batch-process maintenance transactions, and from custom extensions that legitimately call the public wrapping APIs. Developers searching for "ahl_prd_mtltxn_pvt" should note that AHL_PRD_MTLTXN_PVT is both a dependency and a dependent of this package, reflecting the tight coupling between material-transaction processing and parts-change handling in the CMRO/eAM data model.