Search Results ahl_fmp_mr_effectivity_pvt_w




Overview
Explore in AI Chat

Overview

The APPS.AHL_FMP_MR_EFFECTIVITY_PVT_W package is a private PL/SQL API within the Oracle E-Business Suite (EBS) Oracle Complex Maintenance, Repair, and Overhaul (CMRO) / Asset Lifecycle Management (AHL) product family. Its status is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2, and it resides in the APPS schema. The object name and its dependencies indicate that it functions as a wrapper layer (_W suffix) around the core private package AHL_FMP_MR_EFFECTIVITY_PVT, which governs the effectivity logic for maintenance requirements and their associated configurations.

In the CMRO context, "effectivity" defines the date ranges, unit ranges, or serial-number ranges over which a specific maintenance requirement, work order, or configuration change is valid for a given asset or assembly. This wrapper package enables bulk processing of such effectivity records — copying them into and out of PL/SQL collection tables before invoking the core effectivity engine. It is not a public API; it is intended for internal invocation by other AHL packages, concurrent programs, or CMRO processing routines.

Key Procedures and Functions

Three procedures are documented for this package. Parameter lists are not published in the ETRM metadata, so only their role and intent are described.

  • ROSETTA_TABLE_COPY_IN_P1 — A utility used to marshal data from the standard JTF collection types into the internal Rosetta-style table structure consumed by the effectivity engine. It is the inbound migration step that prepares records prior to processing.
  • ROSETTA_TABLE_COPY_OUT_P1 — The symmetric outbound counter­part, which writes processed results from the internal Rosetta table back into the standard JTF collection types so that callers can consume the outcome.
  • PROCESS_EFFECTIVITY — The substantive procedure that drives effectivity evaluation. It invokes the underlying logic in AHL_FMP_MR_EFFECTIVITY_PVT against the populated tables and returns the resulting effectivity outcome.

Tables Accessed

The documented table reference is limited; a single synonym, PLITBLM, is cited. PLITBLM is the standard Oracle-supplied standalone PL/SQL table (index-by-table) used internally by the PL/SQL runtime, not a business table in the AHL schema. This underscores that the package operates primarily on in-memory JTF collection structures rather than directly on CMRO base tables. Business data access is delegated to the underlying AHL_FMP_MR_EFFECTIVITY_PVT package.

The package relies heavily on the JTF collection types — JTF_NUMBER_TABLE, JTF_DATE_TABLE, JTF_VARCHAR2_TABLE_100, JTF_VARCHAR2_TABLE_200, and JTF_VARCHAR2_TABLE_300 — which serve as the transport buffers for effectivity identifiers, dates, and descriptive attributes.

Usage Notes

Because this package is classified as OTHER and is referenced by no other documented packages, it is effectively a leaf-level wrapper invoked only by the CMRO effectivity application layer — typically by concurrent programs, BC4J-based forms, or the CMRO maintenance requirement processing engine. It is not an entry point for customer extensions. Customisations should instead target the public APIs of AHL_FMP_MR_EFFECTIVITY_PVT. Any direct call to this wrapper should be treated as version-sensitive, since its name and dependencies are tied to the internal CMRO effectivity implementation and may change across EBS patch levels.