Search Results pc_node_tbl




Overview
Explore in AI Chat

Overview

APPS.AHL_PC_NODE_PUB is the public PL/SQL interface for maintaining Product Classification Nodes within Oracle E-Business Suite. In the Oracle EBS 12.1.1 and 12.2.2 releases, the package falls under the AHL product (Oracle Enterprise Asset Management / Asset Lifecycle Management), and the ETRM classification marks it as a Public API (PUB) with an active lifecycle. The package supports the business entity AHL_PROD_CLASS, indicating that it is the sanctioned entry point for programmatic maintenance of the classification hierarchy that structures assets, items, and related entities into categorized groups.

The header documentation states that the package is "the public interface to Create /Modify and Delete Product Classification Nodes depending on the flag that is being passed." This confirms that callers do not manipulate classification results directly; instead they invoke a single dispatching routine and indicate their intended action via a DML flag.

Key Procedures and Functions

The ETRM metadata documents one procedure for this package:

  • PROCESS_NODES — The single public entry point for Product Classification Node maintenance. Based on the declaration constants in the package specification, the procedure accepts a flag that selects the operation to be performed. The documented flags are C (create), U (update), D (delete), X (copy), A (assign), and L (link). A caller therefore uses one routine to perform any of the supported lifecycle actions on nodes.

The package specification defines a record type, PC_NODE_REC, that carries the node payload. The fields describe the node identifier, object version number, name, description, owning header, parent node, child count, operation status flag, draft flag, link-to-node reference, and a flexible attribute category plus fifteen attribute columns. The presence of the LINK_TO_NODE_ID field and the L flag indicates support for linking a node to another node in the hierarchy, while the copy and assign flags support duplicating and assigning nodes respectively. Because the ETRM metadata does not provide a full parameter list for PROCESS_NODES, callers should consult the package specification in the appropriate EBS release to confirm exact argument signatures before coding against the API.

Tables Accessed

The ETRM metadata identifies the referenced table as PLITBLM, accessed through an APPS synonym. This is the standard Oracle EBS mechanism by which public APIs avoid hard-coding schema-qualified names and instead read or write through APPS-owned synonyms. PLITBLM is the underlying storage that the package touches when persisting or retrieving classification node information. The row-level detail for nodes, including name, description, parent-child relationships, and the descriptive flexfield attribute columns described in PC_NODE_REC, is handled through this table access layer.

Usage Notes

AHL_PC_NODE_PUB is a public API intended to be called from forms, concurrent programs, or custom code, and the ETRM records indicate it is referenced by three other packages, meaning downstream EBS logic depends on it directly. The typical invocation pattern is to populate a PC_NODE_REC record with the desired node values, pass the appropriate DML flag (C, U, D, X, A, or L) to PROCESS_NODES, and let the package manage the persistence and any dependent relationship handling.

Because the package validates and dispatches based on the flag, custom integrations should not insert into or update the classification tables directly. All maintenance should flow through this API to preserve hierarchy integrity, draft handling, and the object version number used for concurrency control. The user search term "pc_node_tbl" likely reflects the table behind this API; callers should prefer PROCESS_NODES over direct DML against that table.