Search Results ahl_mc_path_position_pvt




Overview
Explore in AI Chat

Overview

The package body APPS.AHL_MC_PATH_POSITION_PVT belongs to the Oracle E-Business Suite Product Information Management (formerly Advanced Product Catalog / Oracle Configurator) family of modules, specifically within the AHL (Oracle Configurator / Model Configuration) schema. Its private API classification ("PVT") indicates that it is an internal, helper package invoked by other public and private packages rather than being callable directly by end users or external customizations. The package encapsulates the business logic that governs path positions — the logical locations within a configuration model (MC) where configurable instances may be placed. A path position effectively identifies a node on a bill-of-material or model structure against which configurable items, instances, or rules are resolved.

The primary responsibility of this package is to create, validate, copy, map, and query path positions and their relationships to configurable instances. It supports the end-to-end configuration lifecycle: when a sales order line, quote, or configuration session instantiates a model, the runtime configurator must know which instances map to which model positions, and vice versa. This package provides the programmatic bridge between abstract model positions (defined in the model design) and the concrete instances in a specific user configuration.

Key Procedures and Functions

The package exposes sixteen documented routines. Their purposes are as follows:

Tables Accessed

The package reads and writes model configuration and configurator runtime tables. AHL_MC_PATH_POSITIONS, AHL_MC_PATH_POSITIONS_S, AHL_MC_PATH_POSITION_NODES, and AHL_MC_PATH_POSITION_NODES_S hold the position and node definitions. AHL_MC_HEADERS_B, AHL_MC_RELATIONSHIPS, and AHL_MC_CONFIG_RELATIONS provide model header and relationship context. Instance mapping is validated against AHL_APPLICABLE_INSTANCES, AHL_UNIT_CONFIG_HEADERS, and CSI_II_RELATIONSHIPS. Item master data comes from MTL_SYSTEM_ITEMS_B and AHL_ITEM_ASSOCIATIONS_B. AHL_MC_RULE_STATEMENTS links positions to configuration rules. DBMS_SQL indicates dynamic SQL usage, and DUAL is used for scalar checks.

Usage Notes

This private package is referenced by 24 other packages and is invoked indirectly through public configuration APIs, configurator UI (Oracle Configurator Developer runtime), and configuration-related concurrent programs that copy, version, or delete model configurations. It should not be called directly by custom code; instead, developers should use the corresponding public APIs. Because its interface may change across 12.1.1 and 12.2.2 patches, any dependency should be validated against the specific release's version of AHLVPOSB.pls.