Search Results ahl_ctr_update_rules_s

Overview

APPS.AHL_MC_NODE_PVT is a private (PVT) PL/SQL package body in the Oracle E-Business Suite Advanced Healthcare / Asset Lifecycle Management (AHL) module, specifically within the Maintenance Configuration (MC) subsystem. It implements the node-level business logic that governs how maintenance configuration nodes are created, modified, copied, deleted, and linked to item groups and documents within a maintenance program structure. In ETRM 12.1.1 and 12.2.2, the package is registered as VALID under the APPS schema and is classified as a PVT API, meaning it is intended primarily for internal consumption by higher-level public APIs rather than direct invocation by external customizations. It depends on a broad set of AHL configuration and relationship tables as well as shared AHL utility and Oracle Application Object Library (FND) packages.

Key Procedures and Functions

The package exposes seven documented procedures and functions:

• CREATE_NODE — Creates a new maintenance configuration node, persisting header and relationship data across the MC tables.
• MODIFY_NODE — Applies updates to an existing node, including changes propagated through configuration relations and associated documents.
• DELETE_NODE — Removes a node and its dependent configuration relationship records.
• COPY_NODE — Duplicates a single node, replicating its attributes and relationship definitions.
• COPY_MC_NODES — Performs bulk duplication of multiple maintenance configuration nodes, supporting structured reuse of an existing configuration hierarchy.
• PROCESS_DOCUMENTS — Coordinates document generation and association for MC nodes, delegating to AHL_DI_ASSO_DOC_GEN_PUB and AHL_DI_ASSO_DOC_GEN_PVT.
• ASSOCIATE_ITEM_GROUP — Links a maintenance configuration node to an item group, writing to AHL_ITEM_GROUPS_B.

These procedures collectively form the internal engine behind node maintenance operations exposed by AHL public APIs.

Tables Accessed

The package reads and writes the core maintenance configuration tables. AHL_MC_HEADERS_B and its view AHL_MC_HEADERS_V hold the header definition that a node belongs to. AHL_MC_RELATIONSHIPS, AHL_MC_RELATIONSHIPS_S, AHL_MC_RELATIONSHIPS_V, and AHL_MC_REL_POS_KEY_S store the node-to-node relationships and positional keys that define the configuration graph. AHL_MC_CONFIG_RELATIONS and AHL_MC_CONFIG_REL_S capture configuration relations between nodes. AHL_CTR_UPDATE_RULES and AHL_CTR_UPDATE_RULES_S define the counter update rules referenced by nodes. AHL_ITEM_GROUPS_B anchors item group associations. MTL_UNITS_OF_MEASURE supplies unit-of-measure validation, and DUAL and PLITBLM support generic SQL and PL/SQL table operations.

Usage Notes

Because AHL_MC_NODE_PVT is a private API, it is not referenced by any database object and is not designed for direct call from customer extensions. It is invoked internally by AHL public APIs, EBS forms (such as MC node maintenance screens), concurrent programs, and other AHL packages that need node lifecycle processing. The documented table AHL_CTR_UPDATE_RULES_S, which the user searched for, is accessed by this package as part of counter update rule handling. Developers extending maintenance configuration logic should call the corresponding public AHL API rather than this package body, and should rely on FND_API, FND_MSG_PUB, and FND_LOG for error handling and diagnostics as the package itself does.