Search Results ahl_prd_disposition_pvt




Overview
Explore in AI Chat

Overview

The APPS.AHL_PRD_DISPOSITION_PVT package is a private (PVT) PL/SQL API belonging to the Oracle E-Business Suite Product Development (AHL) application family. It is part of the Oracle Enterprise Asset Management and Complex Maintenance, Repair and Overhaul (cMRO) module stack, and it operates within the Product Development schema owned by APPS. Its primary business purpose is to manage the disposition of product units, materials, and associated configurations during the disposition phase of a maintenance, repair, overhaul, or production work order lifecycle. Disposition in this context refers to the decision and execution path applied to returned, nonroutine, or repairable parts — for example, whether a unit is to be repaired, scrapped, returned to stock, or routed through a materials transaction.

The package is classified as a private API, meaning it is intended for internal use by other AHL packages, wrapper APIs, and concurrent processes rather than being directly invoked by external customizations. It follows the standard Oracle EBS PL/SQL API conventions, depending on FND_API and STANDARD for error handling and message propagation, which indicates conformance to the validation and exception-wrapping model used throughout EBS.

Key Procedures and Functions

Two documented procedures constitute the public surface of this package:

  • CREATE_JOB_DISPOSITIONS — Establishes disposition records for the jobs and units associated with a product development or maintenance activity. This procedure is responsible for seeding the disposition entities that subsequent processing steps act upon, effectively creating the linkage between a job and its disposition outcomes.
  • PROCESS_DISPOSITION — Executes the actual disposition processing logic against previously created disposition records. This is the operational core of the package, driving the state transitions, material movements, and downstream updates required to complete a disposition decision.

Other private procedures and helper logic exist within the package body but are not exposed in the documented metadata. The two procedures above represent the documented entry points relevant to integrators and support personnel.

Tables Accessed

The package reads and writes a substantial set of AHL and MTL tables through APPS synonyms. Key tables include:

Usage Notes

AHL_PRD_DISPOSITION_PVT is invoked indirectly by a network of AHL packages, including AHL_PRD_DISPOSITION_PVT_W (public wrapper), AHL_PRD_DISP_MTL_TXN_PVT, AHL_PRD_DISP_UTIL_PVT, AHL_PRD_BLK_PARTS_CHANGE_PVT, and AHL_PRD_WORKORDER_PVT. It is referenced by six packages in total and references AHL_PRD_NONROUTINE_PVT. Because it is a private API, it should not be called directly from custom code; instead, integrators should use the corresponding public wrapper or the documented disposition concurrent programs and forms. Typical invocation occurs during work order completion, nonroutine part disposition, and cMRO disposition flows, where the calling package first creates disposition records and then processes them. The package is valid and standard in both EBS 12.1.1 and 12.2.2; behavior and interface are consistent across those releases. Privileges are granted to APPS and the AHL application schema, and any customization should respect the FND_API error-handling contract, checking the returned x_return_status and associated message data rather than relying on database exceptions.