Search Results ahl_mel_cdl_ata_sequences_s

Overview

APPS.AHL_MEL_CDL_ATA_SEQS_PVT is a private PL/SQL package body within the Oracle E-Business Suite Maintenance (eAM/AHL) product family. It provides the implementation logic for the MEL/CDL (Minimum Equipment List / Configuration Deviation List) solution used to track dispatch-critical aircraft and equipment conditions in airline and complex maintenance operations. The package encapsulates the validation, denormalization, and persistence routines that support ATA (Air Transport Association) chapter sequence records associated with MEL/CDL header definitions.

As indicated by the _PVT suffix, this is an internal implementation package. It is not intended to be called directly by external integration code; instead, it is consumed by public API or processing packages that expose the supported interface. The header comment ($Header: AHLVATAB.pls 120.10 ...) confirms the package line and identifies it as part of the AHL value-added table processing layer.

Key Procedures and Functions

• PROCESS_ATA_SEQUENCES — The primary entry point for creating or updating MEL/CDL ATA sequence records. It accepts the standard Oracle API parameters (API version, initialization message list) and orchestrates the common validations and write logic against the underlying ATA sequence tables.
• PROCESS_MO_PROCEDURES — Persists and validates maintenance operation procedures tied to MEL/CDL definitions. It reuses the shared validation cursors defined at package scope.
• PROCESS_ATA_RELATIONS — Handles the relationship records that link MEL/CDL entries and their associated ATA sequence objects, validating the referenced relationships before commit.
• COPY_MO_PROC_REVISION — Replicates maintenance operation procedure revision data, supporting the revision management behavior typical of MEL/CDL maintenance records.

These procedures are supported by non-specification helper routines, including Check_Ata_Seq_Exists, Convert_Value_To_Id, Check_Mel_Cdl_Status, Check_MO_Proc_Exists, and Check_Inter_Reln_Exists. Two private cursors, validate_ata_seq and val_mel_cdl_status, enforce referential existence and status restrictions. Notably, the status validation rejects records whose MEL/CDL header is in Draft or Approve Rejected status, ensuring only approved content flows downstream.

Tables Accessed

• AHL_MEL_CDL_ATA_SEQUENCES and AHL_MEL_CDL_ATA_SEQUENCES_S — the primary ATA sequence base table and its MLS/interfaces shadow table.
• AHL_MEL_CDL_HEADERS — read to evaluate header status via val_mel_cdl_status.
• AHL_MEL_CDL_MO_PROCEDURES and _S — maintenance operation procedures written by PROCESS_MO_PROCEDURES.
• AHL_MEL_CDL_RELATIONSHIPS and _S — relationship records handled by PROCESS_ATA_RELATIONS.
• AHL_MR_HEADERS_B, AHL_REPAIR_CATEGORIES, DUAL, and PLITBLM — supporting lookups, dual-table references, and the PL/SQL table-of-numbers index-by structure used for bulk identifier handling.

Usage Notes

This package is invoked indirectly through the MEL/CDL public APIs and the Oracle Forms-based MEL/CDL maintenance user interface rather than by direct calls from custom code. Per the documented metadata, it is referenced by two other packages, consistent with its role as a shared private utility layer. Customers extending MEL/CDL functionality should call the supported public API (AHL_MEL_CDL_ATA_SEQS_PUB) instead of this private body, since method signatures and internal cursors are subject to change across patch levels (12.1.1 and 12.2.2 respectively). No concurrent program directly executes this package; all execution occurs within an authenticated form or API session under the APPS schema.