Search Results validate_stage_rules

Overview

The APPS.AHL_VWP_VISITS_STAGES_PVT_W package is a private PL/SQL API belonging to the Oracle E-Business Suite Asset Lifecycle Management (AHL) product family, specifically within the Visit Workbench (VWP) module. It is owned by the APPS schema and is classified under the ETRM documentation as an "OTHER" API type, indicating that it is an internal implementation package rather than a formally published public API. The package provides the server-side logic for managing the stages that comprise a customer visit or field service activity, including the creation, update, deletion, and validation of those stage records. The trailing "_W" convention identifies this package as the workbench-facing wrapper that bridges the Java/HTML-based Visit Workbench user interface with the underlying business logic layer. Its source header record ($Header: AHLWSTGS.pls 120.0.12020000.2 2012/12/14) confirms that it has been shipped across the 12.1.1 and 12.2.2 release lines with the same functional footprint.

Key Procedures and Functions

The documented package exposes sixteen procedures that fall into three functional groupings. The bulk of the interface consists of the Rosetta-style table conversion routines: ROSETTA_TABLE_COPY_IN_P5 through ROSETTA_TABLE_COPY_IN_P9 and their mirror ROSETTA_TABLE_COPY_OUT_P5 through ROSETTA_TABLE_COPY_OUT_P9. These routines marshal data between the JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE, and JTF_DATE_TABLE collection types used by the JTT/HTML framework and the strongly typed visit_stages_tbl_type record type defined in AHL_VWP_VISITS_STAGES_PVT. The COPY_IN variants move rows from framework collections into the PL/SQL table type, while COPY_OUT variants perform the reverse direction for returning results to the UI layer.

The business-function procedures comprise CREATE_STAGES, UPDATE_STAGES, DELETE_STAGES, and GET_STAGES_DETAILS, which together implement the standard insert, update, delete, and query operations on visit stage records. PROCESS_STAGETYP_ASSOC manages the association between stages and their stage type definitions. The VALIDATE_STAGE_RULES procedure — the object most frequently sought by users — enforces the business rules that govern stage sequencing, dependency, and mandatory value checks before a stage transition is persisted.

Tables Accessed

ETRM documents only a single referenced table, PLITBLM, accessed through an APPS synonym. This is the standard PL/SQL inter-language table used by Oracle Forms and the JTT framework for passing bulk collection data between client and server tiers. The actual persistent stage data is manipulated through the visit_stages_tbl_type structure defined in the companion base package AHL_VWP_VISITS_STAGES_PVT, which in turn resolves to the AHL visit-stage base tables.

Usage Notes

This package is not intended for direct customer invocation. It is referenced by one other package in the ETRM dependency map and is normally called from the Visit Workbench OA Framework pages and from the associated AHL concurrent programs that rebuild or reconcile visit stage data. Customizations that need to extend stage validation logic should ideally wrap VALIDATE_STAGE_RULES rather than modify the package body, since the _W wrapper is regenerated by Oracle patches. Because the package is compiled with AUTHID CURRENT_USER, callers must ensure that the invoking schema has execute privileges on the package and select privileges on the underlying AHL objects through APPS synonyms. Any direct call should respect the collection parameter types (JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100/200, JTF_DATE_TABLE) used by the Rosetta conversion routines.