Search Results update_sr

Overview

APPS.AHL_UMP_NONROUTINES_PVT is a private PL/SQL package within the Oracle E-Business Suite Advanced Service (AHL) application, specifically belonging to the Unit Maintenance Planning (UMP) module. Its principal responsibility is to manage the lifecycle of non-routine service requests — the incidents, defects, and unscheduled maintenance events that arise outside of planned maintenance routines. The package encapsulates the business logic required to create and update service requests, to handle Minimum Equipment List (MEL) and Configuration Deviation List (CDL) approval workflows, and to evaluate whether open non-routine tasks exist for a given unit. Because the package is classified as PVT (private), it is not intended to be called directly from external code; it is invoked by other AHL packages, forms, and concurrent programs as part of the broader Advanced Service transaction flow.

Key Procedures and Functions

Seven procedures and functions are documented for this package, each addressing a discrete piece of the non-routine workflow:

• CREATE_SR — Inserts a new service request (non-routine) record, populating the header and associated attributes for the incident being reported.
• UPDATE_SR — Modifies an existing service request. The reader's search term, "update_sr," corresponds directly to this procedure, which is the standard entry point for changing SR status, resolution details, or other SR attributes after creation.
• INITIATE_MEL_CDL_APPROVAL — Commences the approval process for a MEL/CDL deferral, driving the workflow that authorizes an aircraft or asset to operate with a known defect under controlled conditions.
• GET_MEL_CDL_HEADER_ID — Returns the identifier of the MEL/CDL header associated with a given deferral, enabling downstream logic to locate the correct approval record.
• GET_MEL_CDL_STATUS — Retrieves the current status of a MEL/CDL deferral, allowing callers to branch behavior based on whether the deferral is pending, approved, or rejected.
• CHECK_OPEN_NRS — Determines whether open non-routine service requests exist for a unit, typically used to block or warn against conflicting maintenance actions.
• PROCESS_MO_PROCEDURES — Processes the maintenance organization procedures attached to a MEL/CDL, likely driving the steps required to clear or resolve the deferral.

Tables Accessed

The package operates against a broad set of AHL base and transactional tables, accessed through APPS synonyms. Core service request and incident data is held in AHL_MR_HEADERS_B. MEL/CDL logic touches AHL_MEL_CDL_HEADERS, AHL_MEL_CDL_ATA_SEQUENCES, AHL_MEL_CDL_MO_PROCEDURES, and AHL_MEL_CDL_RELATIONSHIPS. Unit and configuration context is drawn from AHL_UNIT_CONFIG_HEADERS, AHL_UNIT_DEFERRALS_B, AHL_UNIT_DEFERRALS_TL, AHL_APPLICABLE_INSTANCES, AHL_UE_RELATIONSHIPS, and AHL_MC_RELATIONSHIPS. Repair and problem code associations come from AHL_REPAIR_CATEGORIES, AHL_PC_HEADERS_B, AHL_PC_NODES_B, and AHL_PC_ASSOCIATIONS. Together these tables supply the header, instance, and deferral details needed to create, validate, and update non-routine service requests.

Usage Notes

As a PVT package, AHL_UMP_NONROUTINES_PVT is referenced by approximately ten other packages and is normally invoked indirectly through the UMP service request forms, the MEL/CDL approval flow, or AHL public APIs that wrap these private routines. Customers extending the application should call the corresponding public API rather than this package directly. When tuning or debugging, note the package header references FND_MESSAGE and FND_API utilities, indicating standard EBS error-handling and message-stack conventions apply. The header also carries an object version number for the service request, so callers must maintain optimistic locking discipline. Support for 12.1.1 and 12.2.2 is consistent; the source header suggests the package has been stable since the 12.0-era file revision.