Search Results ahl_mc_node_pvt_w




Overview
Explore in AI Chat

Overview

APPS.AHL_MC_NODE_PVT_W is a private PL/SQL package in the Oracle E-Business Suite (EBS) Applications schema that forms part of the Oracle Complex Maintenance, Repair and Overhaul (CMRO), formerly Enterprise Asset Management / Asset Lifecycle Management, module. The AHL prefix identifies the package as belonging to the CMRO application family, and the _MC_ segment denotes Maintenance Configuration, while _NODE_ indicates that the package operates on nodes within a maintenance configuration structure. The _PVT_W suffix identifies the object as a private package whose implementation is exposed through a matching public wrapper, in this case AHL_MC_NODE_PUB_W. In Oracle EBS 12.1.1 and 12.2.2, the package provides the internal programmatic interface for creating, modifying, copying and processing maintenance configuration nodes and their associations with item groups. It is not intended for direct invocation by end users; it is called by the public wrapper and by peer private packages such as AHL_MC_ITEMGROUP_PVT_W.

Key Procedures and Functions

Eleven documented procedures and functions are exposed. The business-oriented procedures include CREATE_NODE, which establishes a new maintenance configuration node; MODIFY_NODE, which updates the attributes of an existing node; COPY_MC_NODES, which duplicates one or more maintenance configuration nodes, typically to support template-based configuration; PROCESS_DOCUMENTS, which handles document associations or attachment processing for nodes; and ASSOCIATE_ITEM_GROUP, which links a node to an item group so that the maintenance configuration applies to a defined set of items. The remaining procedures follow the Oracle Forms Rosetta table-copy convention. ROSETTA_TABLE_COPY_IN_P6, ROSETTA_TABLE_COPY_IN_P8 and ROSETTA_TABLE_COPY_IN_P10 transfer data from the Forms client into PL/SQL collection structures, while ROSETTA_TABLE_COPY_OUT_P6, ROSETTA_TABLE_COPY_OUT_P8 and ROSETTA_TABLE_COPY_OUT_P10 perform the reverse direction. The numeric suffix reflects the number of columns in the corresponding JTF typed table. Parameter lists are not documented in the ETRM metadata and should be confirmed by inspecting the package specification in the database.

Tables Accessed

The dependency information documents only one directly referenced table via an APPS synonym: PLITBLM. This is an Oracle Forms client-side table which, in the Rosetta pattern, carries the collection data marshalled between the form and the PL/SQL layer. Business data manipulation is delegated to AHL_MC_NODE_PVT, on which this package depends and which owns the underlying maintenance configuration node tables. The package additionally depends on the JTF typed collection definitions JTF_DATE_TABLE, JTF_NUMBER_TABLE, JTF_VARCHAR2_TABLE_100, JTF_VARCHAR2_TABLE_200, JTF_VARCHAR2_TABLE_300 and JTF_VARCHAR2_TABLE_2000, which define the structures used by the Rosetta copy procedures. SYS.STANDARD provides the standard PL/SQL environment.

Usage Notes

AHL_MC_NODE_PVT_W is invoked whenever maintenance configuration nodes are manipulated from the CMRO user interface or through integration APIs. The typical call path is AHL_MC_NODE_PUB_W, which validates input and delegates to this private package, which in turn calls AHL_MC_NODE_PVT for the underlying data operations. The package is referenced by AHL_MC_ITEMGROUP_PVT_W and is also self-referential. Because the _W packages are private implementation objects, they are not part of the supported public API surface; custom code should use the corresponding _PUB_W wrapper. Direct calls should be restricted to extensions that must mirror Oracle’s own internal behaviour, and any such usage should be re-verified after applying patches, since private packages may change between 12.1.1 and 12.2.2. Concurrent programs and Oracle Forms remain the primary invocation points.