Search Results ahl_ltp_simul_plan_pub_w




Overview
Explore in AI Chat

Overview

APPS.AHL_LTP_SIMUL_PLAN_PUB_W is a public PL/SQL package in the Oracle E-Business Suite Applications (APPS) schema. It belongs to the Oracle Complex Maintenance, Repair, and Overhaul (CMRO) product family, as indicated by the AHL prefix used by the Maintenance application modules. The package supports simulation processing for maintenance plans and visits managed through the Asset Lifecycle / Maintenance Planning functionality. It provides a public wrapper interface (denoted by the _PUB_W suffix) around the AHL_LTP_SIMUL_PLAN_PUB package, exposing its logic to external callers while maintaining a separation between the public contract and the underlying implementation. The package is documented as VALID in the ETRM repository with an API classification of OTHER, indicating it is not part of a formally published open interface but is still exposed for internal or controlled use.

Key Procedures and Functions

The package exposes six documented procedures and functions. Their documented roles are as follows:

  • ROSETTA_TABLE_COPY_IN_P1 — An input table copy routine that transfers data from standard EBS collection types into the package's internal working structures, associated with a first parameter group or processing phase.
  • ROSETTA_TABLE_COPY_OUT_P1 — The corresponding output table copy routine for the first phase, returning processed results back to the caller's PL/SQL collection types.
  • ROSETTA_TABLE_COPY_IN_P3 — An input table copy routine for a third parameter group or phase, following the same pattern as the P1 variant.
  • ROSETTA_TABLE_COPY_OUT_P3 — The matching output routine for the third phase.
  • PROCESS_SIMULATION_PLAN — The core routine that drives processing of a maintenance simulation plan, likely evaluating plan criteria and producing simulated results.
  • PROCESS_SIMULATION_VISIT — Drives processing of simulation visits associated with a plan, handling visit-level evaluation and output.

The ROSETTA_* naming convention reflects bulk data marshalling between Java or external callers and PL/SQL, a common pattern in EBS public wrappers. Parameter lists are intentionally not reproduced here and should be confirmed against the object source before use.

Tables Accessed

The documented table reference is PLITBLM, accessed through an APPS synonym. PLITBLM is the standard EBS temporary/collection storage table (PL/SQL Index-by Table storage) used to pass bulk data between PL/SQL and external interfaces. In this package it likely holds the plan and visit simulation data being marshalled in and out of the ROSETTA copy routines, and possibly intermediate results generated by PROCESS_SIMULATION_PLAN and PROCESS_SIMULATION_VISIT. No other base tables are documented as directly referenced in the ETRM metadata.

Usage Notes

Because AHL_LTP_SIMUL_PLAN_PUB_W is a public wrapper, it is typically invoked programmatically rather than interactively. It is referenced by no other packages according to the documented metadata, which suggests it is called directly by external code, concurrent programs, or Java-based interfaces within the CMRO solution. Callers are expected to populate PL/SQL collection types (consistent with the JTF_DATE_TABLE, JTF_NUMBER_TABLE, and JTF_VARCHAR2_TABLE_* types used by the base package AHL_LTP_SIMUL_PLAN_PUB), invoke the ROSETTA copy-in routines, call the PROCESS_SIMULATION_* procedures, and then invoke the copy-out routines to retrieve results. The package depends on APPS.AHL_LTP_SIMUL_PLAN_PUB and the JTF collection types, and on the SYS.STANDARD package. As with any EBS public API wrapper, the formal parameter signatures should be verified against the installed source in the target environment (12.1.1 or 12.2.2) prior to integration, since ETRM documentation does not enumerate them.