Search Results ahl_prd_visits_pvt




Overview
Explore in AI Chat

Overview

The APPS.AHL_PRD_VISITS_PVT package is a private PL/SQL API belonging to the Oracle E-Business Suite product family AHL (Advanced Product Catalog / Product Lifecycle and Visit Management). It operates within the APPS schema and carries an object type classification of PACKAGE with the API classification suffix PVT, signifying that it is a private, internal API not intended for direct external invocation. In Oracle EBS 12.1.1 and 12.2.2 the package encapsulates the business logic governing field service visits associated with product and work order management. A visit represents a scheduled service or inspection activity linked to a work order, unit configuration, or project. The package mediates the retrieval and assembly of visit-related data, bridging work order structures, asset unit configurations, customer relationships, and project attributions. Its status is VALID in the ETRM repository, confirming it is compiled and operational in the documented environment.

Key Procedures and Functions

The documented metadata identifies two callable program units within this package:

  • GET_UNITNAME — Resolves and returns the display name of the unit (asset or configuration instance) associated with a visit. This supports presentation layers that must display the customer-facing asset identity rather than an internal identifier.
  • GET_VISIT_DETAILS — Assembles and returns the full detail record for a given visit, drawing together task, work order, and relationship data required by the calling process.

Both units are consistent with the package's role as a data-retrieval service for the visit domain. No parameter signatures are documented in the ETRM metadata, and none are asserted here.

Tables Accessed

Through APPS synonyms, the package references the following base objects:

  • AHL_VISIT_TASKS_B — the base table of visit tasks, supplying the core visit scheduling records.
  • AHL_WORKORDERS — the work order header, linking each visit to the maintenance or service job that authorizes it.
  • AHL_UNIT_CONFIG_HEADERS — the unit configuration header, used to resolve asset identity and support GET_UNITNAME.
  • CSI_II_RELATIONSHIPS — the installed-instance relationship table, providing the customer asset hierarchy context for the unit and visit.
  • PA_PROJECTS — the projects table, enabling association of visits with project accounting contexts where applicable.

Usage Notes

Because AHL_PRD_VISITS_PVT is a private API, it is not documented for customer or partner direct invocation. It is instead called by other AHL components, notably the public wrapper AHL_PRD_VISITS_PVT_W, which exposes supported entry points, and self-referentially within the package body. In practice it is invoked from Oracle Forms-based Visit and Work Order interfaces, from concurrent programs that process or report on visit data, and from custom extensions that follow Oracle's supported pattern of calling the public wrapper rather than the private package directly. It also depends on FND_API, the standard Oracle Application Object Library API foundation used for consistent error handling and message propagation. Developers should treat this package as internal and rely on the corresponding _W wrapper for any integration requirements.