Search Results ump_visit_info

Overview

APPS.AHL_VWP_VISITS_PVT is a private PL/SQL API package within the Oracle Enterprise Asset Management (eAM) and Enterprise Asset Management for Aerospace and Defense (AHL) product family in Oracle E-Business Suite. It belongs to the Visit Workbench (VWP) module, which governs visit scheduling, execution, and closure for unit maintenance and service operations. The package's classification as a Private (PVT) API confirms its role as an internal implementation layer: it encapsulates the core business logic for manipulating visit records and is consumed primarily by the corresponding public API, AHL_VWP_VISITS_PUB, along with a wide set of sibling packages in the AHL schema.

In Oracle EBS 12.1.1 and 12.2.2, this package is not intended for direct invocation by external or customer-written code. It performs low-level validation, persistence, and status transitions against visit data, applying the standard Oracle Application Object Library conventions (for example, the FND_API dependency, indicating use of the common API error-handling and message stack utilities, and use of SYS.STANDARD). The package exists to separate the public contract of the visit business object from its procedural internals, allowing Oracle to evolve the implementation without breaking callers that rely on AHL_VWP_VISITS_PUB.

Key Procedures and Functions

The 12.2.2 ETRM metadata documents thirteen callable subprograms in AHL_VWP_VISITS_PVT:

• CREATE_VISIT, UPDATE_VISIT, DELETE_VISIT — the standard CRUD trio for the visit entity, handling insert, modification, and removal of visit records including their translation rows.
• PROCESS_VISIT — applies the business workflow logic that drives a visit through its lifecycle states after creation or update.
• CLOSE_VISIT and CANCEL_VISIT — terminal state transitions for a visit, closing a completed visit or canceling one that will not proceed.
• GET_VISIT_DETAILS — retrieves the full attribute set for a visit for display or downstream processing.
• GET_UNITNAME — resolves the descriptive name of the unit associated with a visit, supporting user-facing output.
• GET_DUE_BY_DATE — calculates or returns the due-by date used in scheduling and prioritization logic.
• UMP_VISIT_INFO — returns visit information in the format required for unit maintenance processing.
• VALIDATE_COMPONENT_VISIT — checks the validity of a component-level visit relationship before persistence.
• IS_OLD_VISIT — boolean-style predicate determining whether a visit qualifies as historical, typically used to block updates to closed or archived visits.
• DELETE_FLIGHT_ASSOC — removes the association between a visit and a flight schedule, used when visits are rescheduled or decoupled.

Tables Accessed

The package reads and writes through APPS synonyms across the AHL visit, task, unit, and scheduling data model. Core transactional tables include AHL_VISITS_B, AHL_VISITS_B_S, and AHL_VISITS_TL, which hold the base visit rows, the primary-key sequence surrogate, and translated visit names and descriptions. AHL_VISIT_TASKS_B, AHL_VISIT_TYPES_B, and AHL_TASK_LINKS (with AHL_TASK_LINKS_S) define the visit-to-task relationships and task linkage structure, while AHL_UNIT_SCHEDULES, AHL_UNIT_CONFIG_HEADERS, and AHL_UNIT_EFFECTIVITIES_B supply the unit configuration and effectivity context used in validation. Scheduling and simulation references include AHL_SCHEDULE_MATERIALS, AHL_SIMULATION_PLANS_B, AHL_SIMULATION_PLANS_TL, and AHL_VWP_STAGES_B, and AHL_DEPARTMENT_SHIFTS supports resource and shift timing logic.

Usage Notes

AHL_VWP_VISITS_PVT is invoked indirectly through the Visit Workbench forms and through the public API AHL_VWP_VISITS_PUB rather than by direct call. Within the AHL schema it is referenced by nineteen other packages, including AHL_VWP_TASKS_PVT and its wrapper AHL_VWP_TASKS_PVT_W, AHL_VWP_VISITS_PVT_W, AHL_COMPLETIONS_PVT, AHL_UA_COMMON_PVT, AHL_UA_FLIGHT_SCHEDULES_PUB/PVT, AHL_UA_UNIT_SCHEDULES_PVT and its wrapper, and the long-term planning packages AHL_LTP_SIMUL_PLAN_PVT and AHL_LTP_SPACE_ASSIGN_PVT. This dependency profile confirms the package acts as a shared visit-service layer for maintenance execution, unit administration, and simulation planning. Because it is a private API, customization efforts should target AHL_VWP_VISITS_PUB; modifications to this package are not supported and are vulnerable to being overwritten during patching or upgrade from 12.1.1 to 12.2.2.