Search Results ahl_ua_common_pvt




Overview
Explore in AI Chat

Overview

APPS.AHL_UA_COMMON_PVT is a private PL/SQL package within the Oracle E-Business Suite Asset Lifecycle Management (eAM) module, specifically supporting the Unit Attributes (AHL_UA) scheduling functionality introduced for unit configuration and flight/visit tracking. Its primary business function is to provide shared utility logic for retrieving temporal context — preceding and succeeding events, flights, and visits — relative to a given point in a unit's operational schedule. It acts as a service layer consumed by other private and public packages in the Unit Attributes family, rather than being called directly by end users. The "PVT" classification indicates it is an internal package whose API is not part of the supported public interface, though it is registered as VALID in the APPS schema and documented in ETRM.

Key Procedures and Functions

The package exposes seven documented procedures and functions, all oriented around retrieving schedule and event adjacency information:

  • GET_ALL_EVENTS — Returns the complete set of events associated with a unit's schedule context.
  • GET_PREC_FLIGHT_INFO — Retrieves information about the flight immediately preceding a given reference point in the flight schedule.
  • GET_SUCC_FLIGHT_INFO — Retrieves information about the flight immediately following a given reference point.
  • GET_PREC_VISIT_INFO — Retrieves visit details for the visit preceding a reference point.
  • GET_SUCC_VISIT_INFO — Retrieves visit details for the visit succeeding a reference point.
  • GET_PREC_EVENT_INFO — Returns information about the event immediately preceding a reference point.
  • GET_SUCC_EVENT_INFO — Returns information about the event immediately succeeding a reference point.

Parameter lists are not enumerated in the ETRM metadata and should be treated as private implementation details.

Tables Accessed

The package reads from the following tables via APPS synonyms:

All access is read-oriented, consistent with the package's role as a query utility.

Usage Notes

AHL_UA_COMMON_PVT is referenced by AHL_UA_FLIGHT_SCHEDULES_PUB (a public package), AHL_UA_UNIT_SCHEDULES_PVT, and recursively by itself, confirming it is invoked from within the Unit Attributes scheduling stack rather than from Oracle Forms or concurrent programs directly. It also depends on AHL_UA_FLIGHT_SCHEDULES_PVT and AHL_VWP_VISITS_PVT. Customizations should not call this PVT package directly; instead, use the public AHL_UA_FLIGHT_SCHEDULES_PUB API where equivalent functionality is needed. Because the package is private, Oracle may alter its signatures between patch levels, so any direct dependency carries upgrade risk. The behavior is identical in EBS 12.1.1 and 12.2.2, with no documented differences in this object's metadata between those releases.