Search Results ahl_mc_node_pub




Overview
Explore in AI Chat

Overview

AHL_MC_NODE_PUB is the public PL/SQL package in the Oracle E-Business Suite (EBS) Application Object Library that manages the lifecycle of Master Configuration nodes. Master Configuration is a business entity within the AHL product (Advanced Planning and Scheduling / aerospace and defense configuration management) used to define and maintain hierarchical configuration structures for items and assemblies. The package provides a governed API surface for creating, updating, and deleting these nodes, encapsulating the underlying DML and validation logic so that external callers — forms, concurrent programs, or custom code — do not need to manipulate the base tables directly.

The package header declares standard API constants, including G_PKG_NAME and the DML operation codes G_DML_CREATE ('C'), G_DML_UPDATE ('U'), and G_DML_DELETE ('D'), which indicate the type of operation a caller intends to perform. This design reflects Oracle's standard API pattern, where a single entry point dispatches to the appropriate create, update, or delete logic based on the operation code supplied by the caller.

Key Procedures and Functions

  • PROCESS_NODE — The primary public procedure. It handles the creation, update, and deletion of Master Configuration nodes. It accepts the standard API IN parameters (p_api_version, p_init_msg_list, p_commit, p_validation_level, p_module_type) and returns the standard OUT parameters (x_return_status, x_msg_count, x_msg_data). Its node-specific parameters include a node record (p_x_node_rec) and collections for counter rules (p_x_counter_rules_tbl) and sub-configurations (p_x_subconfig_tbl), allowing the procedure to persist the node together with its associated rules and subordinate configuration data in a single logical transaction.
  • DELETE_NODES — A public procedure dedicated to removing Master Configuration nodes. It provides a focused deletion entry point separate from the general PROCESS_NODE dispatch, allowing callers to remove nodes without invoking the full create/update processing path.

Tables Accessed

The package operates against the following tables through APPS synonyms:

  • AHL_ITEM_GROUPS_B — Stores item group definitions used to associate or constrain Master Configuration nodes to specific item groupings during node processing.
  • AHL_MC_HEADERS_B — The base table for Master Configuration headers; nodes are created, updated, and deleted in relation to their parent configuration header.
  • PLITBLM — A generic PL/SQL index-by table storage mechanism (the standard EBS "PL/SQL Item Table" used for transient collection handling), supporting the collection parameters passed into PROCESS_NODE.

Usage Notes

AHL_MC_NODE_PUB is classified as a PUBLIC API, meaning it is a supported integration point for external callers rather than an internal helper package. It is typically invoked from Oracle Forms-based Master Configuration setup screens, from concurrent programs that bulk-generate or maintain configuration nodes, or from custom PL/SQL code implementing configuration integrations. The package is referenced by at least one other package, indicating that it also serves as a building block within the AHL configuration module's internal call hierarchy.

Callers should always supply a valid p_api_version and inspect x_return_status and the message stack (x_msg_count and x_msg_data) after execution. Because the package defaults p_commit to FND_API.G_FALSE, transaction control remains with the caller unless explicit commit behavior is requested, which is important when Master Configuration nodes, counter rules, and sub-configurations must be committed atomically. The presence of p_module_type defaulting to 'JSP' reflects the package's origin in web-enabled EBS form deployments.