Search Results get_due_by_date

Overview

APPS.AHL_PRD_VISITS_PVT is a private PL/SQL API within the Oracle E-Business Suite product family AHL (Complex Maintenance, Repair and Overhaul, or CMRO). It belongs to the Product/Visit management layer of CMRO and is responsible for managing visit-related procedures that support visit scheduling, task association, and visit detail retrieval. The package body carries the internal package name AHL_PRD_VISIT_PVT and is classified as a Private (PVT) API, meaning it is intended for internal consumption by other EBS packages and forms rather than as a direct extension point for customer code. Its header indicates origination in 2004, and it defines global constants plus local cursors and procedures that operate on visit data. Functions include deriving the due-by date for a visit by taking the least due-by date among all associated visit tasks, determining whether a visit exists, and counting the effective tasks attached to a visit. The user query "get_visit_details" maps to the documented procedure GET_VISIT_DETAILS, one of two publicly documented routines in this package.

Key Procedures and Functions

• GET_VISIT_DETAILS — Retrieves the header and detail information for a given product visit, including visit identification, associated work order and project context, unit configuration, and task-level data. This is the routine surfaced by the search term "get_visit_details" and is the primary entry point for callers that need to populate visit information on a form or in processing logic.
• GET_UNITNAME — Resolves and returns the unit name for a visit's configuration, using the unit configuration header hierarchy to translate a unit identifier into a display or processing name.
• GET_DUE_BY_DATE (internal) — Computes the least due-by date among all non-deleted tasks belonging to a visit, feeding the visit update screen. It relies on local cursors that verify visit existence and count effective tasks where UNIT_EFFECTIVITY_ID is not null.

Tables Accessed

• AHL_VISIT_TASKS_B — Core visit task table; queried to count tasks, filter deleted rows (STATUS_CODE <> 'DELETED'), and derive the earliest due-by date.
• AHL_WORKORDERS — Provides the work order linked to a visit, used to contextualize visit activity and status.
• AHL_UNIT_CONFIG_HEADERS — Supplies unit configuration header data used to resolve unit names and configuration context.
• CSI_II_RELATIONSHIPS — Installed-base relationship data used to validate or resolve the unit/item instance associated with the visit.
• PA_PROJECTS — Provides project context where visits are performed against project-funded maintenance and overhaul work.

Usage Notes

Because AHL_PRD_VISITS_PVT is a PVT-classified package, it is normally invoked indirectly. EBS CMRO forms and other AHL packages (the metadata records one referencing package) call GET_VISIT_DETAILS and GET_UNITNAME to populate visit screens and to build visit summaries. The package is not exposed as a concurrent program interface and is not intended for direct customer extension; customizations should prefer public AHL APIs. The package is present across both 12.1.1 and 12.2.2, with no functional delta documented beyond the standard ETRM metadata; debugging behavior is governed by the global AHL_DEBUG_PUB.is_log_enabled flag and the G_DEBUG constant.