Search Results unit_deferral




Overview
Explore in AI Chat

Overview

APPS.AHL_UMP_NONROUTINES_PVT is a private PL/SQL package body within the Oracle E-Business Suite Advanced Service (AHL) module, specifically belonging to the Unit Maintenance Planning (UMP) subsystem. In Oracle EBS 12.1.1 and 12.2.2, this package encapsulates business logic supporting the treatment of non-routine maintenance tasks performed against a unit configuration. Non-routine work arises when inspection or execution of routine maintenance uncovers additional defects or service requirements that must be captured, deferred, approved, and eventually executed. The package acts as the procedural engine behind these flows, creating and updating service requests, managing unit effectivity and unit deferral records, driving MEL/CDL (Maintenance Effectivity Level / Configuration Deviation List) approval cycles, and generating the Maintenance Order procedures associated with approved deferrals. It is classified as PVT, meaning it is intended for internal invocation by other AHL packages and public APIs rather than direct call by end-user forms.

Key Procedures and Functions

The package exposes seven documented program units, several of which are declared in the body ahead of the specification. The header excerpt reveals private helpers such as Is_MEL_CDL_Approved, Validate_SR_Details, Validate_UE_Details, and Get_Ata_Sequence, which support the public routines.

  • CREATE_SR — Creates the service request that represents a non-routine maintenance requirement, accepting standard API versioning parameters and initializing the non-routine record prior to validation and persistence.
  • UPDATE_SR — Modifies an existing service request associated with non-routine work, reapplying validation rules against the current record state.
  • INITIATE_MEL_CDL_APPROVAL — Launches the MEL/CDL approval workflow for a deferral, transitioning the associated MEL/CDL header into an approval-pending state.
  • GET_MEL_CDL_HEADER_ID — Resolves the MEL/CDL header identifier for a given deferral or unit effectivity context, used to link approval artifacts.
  • GET_MEL_CDL_STATUS — Returns the current approval status of the MEL/CDL record, allowing callers to branch on whether deferral has been authorized.
  • CHECK_OPEN_NRS — Determines whether open non-routine service requests exist for a unit, preventing conflicting or duplicate deferral processing.
  • PROCESS_MO_PROCEDURES — Generates the maintenance order procedures deriving from an approved MEL/CDL, iterating across ATA sequence and unit deferral identifiers.

Tables Accessed

The package reads and writes a broad set of AHL synonyms. Service-request and repair context is drawn from AHL_MR_HEADERS_B and AHL_REPAIR_CATEGORIES, while unit configuration data comes from AHL_UNIT_CONFIG_HEADERS and AHL_APPLICABLE_INSTANCES. Deferral state is stored in AHL_UNIT_DEFERRALS_B and its translation table AHL_UNIT_DEFERRALS_TL. MEL/CDL approval structures span AHL_MEL_CDL_HEADERS, AHL_MEL_CDL_RELATIONSHIPS, AHL_MEL_CDL_ATA_SEQUENCES, and AHL_MEL_CDL_MO_PROCEDURES. Effectivity and relationship mapping use AHL_UE_RELATIONSHIPS and AHL_MC_RELATIONSHIPS, while parts and configuration node information is obtained through AHL_PC_HEADERS_B, AHL_PC_NODES_B, and AHL_PC_ASSOCIATIONS.

Usage Notes

AHL_UMP_NONROUTINES_PVT is not invoked directly by users. It is referenced by ten other packages, which call its procedures to orchestrate non-routine maintenance from UMP forms, concurrent programs, and higher-level public APIs. Typical invocation occurs when a technician raises a non-routine service request against a unit, when a deferral is submitted for MEL/CDL approval, or when an approved deferral is released for execution and maintenance order procedures must be instantiated. Customizations should favor the corresponding public AHL APIs; direct calls to this private package risk incompatibility across 12.1.1 and 12.2.2 patch levels.