Results for “get_cont_ctr_expiration_date”

4 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.AHL_UMP_PROCESSUNIT_PVT package body is a private (PVT) PL/SQL unit within the Oracle E-Business Suite Asset Lifecycle Management (AHL) module, specifically belonging to the Unit Maintenance Processing (UMP) subsystem. Its principal business function is to process maintenance units — physical assets tracked against maintenance requirements (MRs) — in order to determine applicable maintenance programs, forecast counter-based usage, evaluate effectivities, and generate unit maintenance work orders or schedules. In this sense it operates as the engine that connects an asset instance to its governing maintenance plan. The package is classified as PVT, meaning it is an internal implementation package not intended to be called directly by external consumers; instead, it is invoked by public APIs and other processing packages. The metadata indicates the package is referenced by eleven other packages, confirming its role as a shared internal worker unit. Because the user's search term was "ahl_master," this object is relevant as part of the broader AHL master data processing chain, working against master-level maintenance and fleet definitions. The header comment references debug logic controlled by AHL_DEBUG_PUB and a PM installation flag sourced from AHL_UTIL_PKG, showing the package is conditionally aware of Preventive Maintenance integration. It also declares local record types for counter rules, applicable MRs, forecast details, and unit effectivity, which frame the data shapes processed throughout its procedures.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions. Their purposes, based on the metadata and the record structures declared, are as follows:

  • PROCESS_UNIT — The primary driver routine that processes a single maintenance unit, assembling applicable MRs and driving downstream forecasting and scheduling logic.
  • PROCESS_MRAFFECTED_UNITS — Processes all units impacted by a change to a maintenance requirement, propagating updates across affected asset instances.
  • PROCESS_ALL_UNITS — Bulk processing entry point that iterates across all eligible units, typically for scheduled or concurrent execution.
  • PROCESS_PM_CONTRACTS — Handles Preventive Maintenance contract data, using the contract-related fields present in the applicable MRs record type such as service line, contract dates, and coverage level.
  • PROCESS_UNIT_RANGE — Processes a defined range of units rather than the full population, supporting partitioned batch runs.
  • GET_DEFERRED_DUE_DATE — Calculates a deferred due date for a maintenance requirement, supporting scheduling flexibility.
  • GET_FORECASTED_COUNTER_VALUES — Produces forecasted counter readings using the forecast details record type (start/end date, UOM, usage per day).
  • GET_LATEST_CTR_READING — Retrieves the most recent counter reading for a unit, feeding forecasting and due-date calculations.
  • GET_CONT_CTR_EXPIRATION_DATE — Determines the continuous counter expiration date.
  • GET_FLEET_FROM_UNIT_ASSO — Resolves the fleet associated with a unit through fleet-unit associations.
  • GET_PRIMARY_PLAN_ID — Identifies the primary maintenance plan identifier for a unit.
  • CALCULATE_INIT_DUEDATE — Computes the initial due date for a maintenance requirement.

Tables Accessed

The package reads and writes a set of APPS-synonymed tables central to maintenance processing:

Usage Notes

As a PVT package, AHL_UMP_PROCESSUNIT_PVT is not invoked directly from forms or external code. It is called internally by public AHL packages and by concurrent programs that process unit maintenance, including bulk runs leveraging PROCESS_ALL_UNITS and range-based jobs using PROCESS_UNIT_RANGE. The G_CONCURRENT_FLAG and debug line number variables indicate explicit support for concurrent worker processing and failure diagnosis. Customizations should call the public wrapper APIs rather than this private package to preserve upgrade safety. In Oracle EBS 12.1.1 and 12.2.2, the object resides under the APPS schema and depends on PM and service contract integration being enabled when applicable.