Search Results delete_visit

Overview

The APPS.AHL_AVF_PRIM_VSTS_PVT package body is a private (PVT classification) PL/SQL unit within the Oracle Enterprise Asset Management (eAM) and Enterprise Asset Management/Asset Tracking (AHL) application family. AHL is the schema prefix associated with the Asset Tracking and maintenance visit functionality delivered with Oracle E-Business Suite Release 12.1.1 and 12.2.2. The package encapsulates the server-side logic that governs the creation, processing, and cancellation of primary maintenance visits generated by automatic visit forecasting (AVF). It is designated private, meaning it is intended to be called only by other AHL packages or internal framework code rather than directly by end users or external integrations. Its principal business responsibility is to translate maintenance planning records — MR headers, fleet headers, and unit effectivities — into concrete visit records that technicians execute, and to reconcile or cancel those visits when the underlying plan changes.

Key Procedures and Functions

• ADD_PLANNED_MRS — Adds maintenance requirement records into the visit planning pipeline so that planned maintenance can be reflected as visit candidates.
• CANCEL_VISITS — Reverses or cancels previously created primary visits, typically when a maintenance plan, unit configuration, or fleet assignment is voided or superseded.
• CREATE_PRIMARY_VISITS — Inserts the primary visit header and associated visit task rows that represent the actual work to be scheduled and performed.
• PROCESS_PRIMARY_VISITS — Orchestrates the validation, hierarchy resolution, and commit logic that ties planned maintenance requirements to generated visit records.

The private procedure Validate_MR_Operating_Org is also present in the source, validating the MR operating organization and returning the corresponding maintenance organization. Standard p_api_version, p_init_msg_list, p_commit, and validation-level parameters, together with the x_return_status, x_msg_count, and x_msg_data outputs, follow the EBS PL/SQL API convention.

Tables Accessed

• AHL_VISITS_B and AHL_VISIT_TASKS_B — the base visit and visit-task tables written by CREATE_PRIMARY_VISITS and reversed by CANCEL_VISITS.
• AHL_VISIT_TYPES_B — supplies the valid visit type definitions used when building primary visits.
• AHL_MR_HEADERS_B and AHL_MR_ORGANIZATIONS — maintenance requirement headers and their operating organization mappings, fed via ADD_PLANNED_MRS.
• AHL_FLEET_HEADERS_B, AHL_UNIT_CONFIG_HEADERS, and AHL_UNIT_EFFECTIVITIES_B — define which units and configurations the visits apply to.
• AHL_AUTOVISIT_HIERARCHY and AHL_AUTOVST_SNPSHT_HDR — drive the automatic visit forecasting hierarchy and snapshot context.
• AHL_MC_HEADERS_B and AHL_UE_RELATIONSHIPS — support maintenance contract and unit effectivity relationship resolution.

Usage Notes

Because AHL_AVF_PRIM_VSTS_PVT is classified PVT and is referenced by zero other packages per the documented metadata, it is an internal implementation unit invoked by the public AHL visit-generation APIs and by the concurrent programs that run automatic visit forecasting. The user search term delete_visit reflects a common operational need: removing or cancelling a primary visit. That action is handled through CANCEL_VISITS rather than a dedicated delete API, so developers extending AHL should call the supported public wrapper rather than issuing direct DML against AHL_VISITS_B. The package enforces organization validation, message-stack handling, and logging via FND_LOG, making it suitable for use within standard concurrent manager and form-driven flows in both 12.1.1 and 12.2.2.