Search Results ahl_ump_smrinstance_pvt




Overview
Explore in AI Chat

Overview

APPS.AHL_UMP_SMRINSTANCE_PVT is a private PL/SQL package within the Oracle E-Business Suite 12.1.1 / 12.2.2 maintenance management module (AHL). It belongs to the Unit Maintenance Planning (UMP) subsystem and supports the retrieval and construction of search results for maintenance requirement instances. The PVT suffix denotes that the package is an internal, private implementation unit; its procedures are not intended to be called directly by external consumers but rather are exposed through the public wrapper package AHL_UMP_SMRINSTANCE_PVT_W.

The principal business purpose of the package is to enable users to query maintenance requirement instances based on a set of search criteria, build the corresponding SQL query dynamically, and return associated unit-of-measure information. It therefore sits at the query layer of the UMP search functionality, allowing maintenance planners and engineers to locate applicable maintenance requirements, simulation plans, unit configurations, and related counter or deferral data across the organization.

Key Procedures and Functions

  • SEARCH_MR_INSTANCES — The primary search routine. It accepts user-defined filter criteria and returns matching maintenance requirement instances. It serves as the main entry point for the retrieval logic that powers the UMP instance search screens.
  • BUILD_UMP_SEARCH_QUERY — A helper routine that dynamically assembles the SQL statement used by SEARCH_MR_INSTANCES. It constructs the query based on the supplied search parameters, joining the various AHL and CSI tables required to satisfy the criteria.
  • GET_UOM_REMAIN — Retrieves unit-of-measure remain information, typically used to calculate or display remaining quantities in the context of counter readings and maintenance intervals. It supports the presentation layer by supplying computed UOM values.

Tables Accessed

The package reads and writes data through APPS synonyms across a broad set of maintenance, configuration, and counter tables:

Usage Notes

As a private (PVT) package, AHL_UMP_SMRINSTANCE_PVT is not invoked directly. It is referenced by the public wrapper packages AHL_UMP_SMRINSTANCE_PVT_W, which expose the underlying procedures to the Oracle Forms-based UMP search screens and to any concurrent programs or custom extensions that require maintenance requirement instance search capability. The dependency on FND_API indicates use of the standard EBS API conventions, including error handling and message stack management.

Customizations should call the public _W wrapper rather than this private package to preserve upgrade safety. The package depends on CS_INCIDENTS_ALL_B, FND_API, and standard PL/SQL packages, and is referenced by two other packages within the APPS schema.