Search Results ahl_ump_sr_pvt




Overview
Explore in AI Chat

Overview

APPS.AHL_UMP_SR_PVT is a private PL/SQL package within the Oracle Enterprise Asset Management (eAM) and Asset Lifecycle Management (ALM) module family, residing in the APPS schema. The "AHL" prefix designates the Asset Lifecycle Management (formerly Enterprise Asset Management) product suite, "UMP" denotes the Unit Maintenance Program subsystem, and "SR" identifies Service Requests. The "_PVT" suffix follows the standard Oracle Application Object Library naming convention for private packages, indicating that the contained logic is intended for internal consumption by other AHL packages rather than as a public, standalone API. The package serves as the working engine that translates unit maintenance program definitions into executable service request records, maintaining the relationships between maintenance requirements (MRs) and the service requests generated against item instances and units. It encapsulates the core business rules for applying maintenance programs to installed base items, propagating revisits and task structures, and reconciling service request updates against work order and visit records. In Oracle EBS 12.1.1 and 12.2.2, this package is a key component of the maintenance forecasting and non-routine maintenance flows within eAM.

Key Procedures and Functions

  • CREATE_SR_UNIT_EFFECTIVITY — Creates unit effectivity records that link service requests to the effective date ranges and unit applicability defined by the maintenance program. This procedure ensures that a generated service request carries the correct effectivity context so downstream visit and work order generation respects the unit's maintenance timeline.
  • PROCESS_SR_UPDATES — Handles updates to existing service request records that originate from maintenance program processing. It reconciles changes such as updated maintenance requirements, revised scheduling, and status transitions, keeping the service request data consistent with the originating unit maintenance program definitions.
  • PROCESS_SR_MR_ASSOCIATIONS — Establishes and maintains the associations between service requests and maintenance requirements. This procedure writes the relationship data that records which MRs apply to a given SR, enabling downstream processes to determine applicable maintenance requirements and relationships for each unit.

Tables Accessed

The package reads and writes through APPS synonyms to the following documented tables:

Usage Notes

As a private package, AHL_UMP_SR_PVT is not intended for direct invocation by external or custom code. It is referenced by five other AHL packages, including AHL_FLEET_FORECAST_PVT, AHL_PRD_NONROUTINE_PVT, AHL_UMP_NONROUTINES_PVT, AHL_UMP_SR_GRP, and AHL_UMP_SR_PVT_W (its wrapper). These callers drive the package during fleet forecasting, non-routine maintenance processing, and unit maintenance program service request generation. The package itself depends on FND_API for standard Oracle Application Object Library API error handling and message conventions. Typical invocation occurs through eAM maintenance program concurrent programs and the associated OAF or Forms-based maintenance workbench flows, where maintenance requirements are expanded into service requests and their visit, task, and work order structures. Because the package manipulates CS incident records and AHL effectivity data within a single logical transaction, callers are expected to manage commit and rollback boundaries appropriately.