Search Results path_position

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:

• CREATE_POSITION_ID — Creates a new path position identifier, or returns the existing identifier if an equivalent position already exists, ensuring idempotent position creation.
• MAP_INSTANCE_TO_POSITIONS — Establishes associations between a configurable instance and one or more path positions.
• MAP_POSITION_TO_INSTANCES — The inverse mapping, associating a path position with one or more instances.
• MAP_INSTANCE_TO_POS_ID — Maps an instance to a single position identifier.
• GET_POS_INSTANCE — Retrieves the instance associated with a given position.
• COPY_POSITIONS_FOR_MC — Copies all path positions when a model configuration is duplicated or versioned.
• COPY_POSITION — Copies an individual path position, supporting version and revision flows.
• DELETE_POSITIONS_FOR_MC — Removes path positions belonging to a model configuration.
• GET_POSREF_BY_ID, GET_POSREF_BY_PATH, GET_POSREF_FOR_UC — Retrieve position reference information by identifier, by encoded path, or for a unit configuration, respectively.
• GET_ENCODED_PATH and CHECK_POS_REF_PATH — Encode and validate hierarchical position paths (using the "/" node and ":" id separators defined in the package).
• ENCODE — Utility to encode values into the path string format.
• IS_POSITION_SERIAL_CONTROLLED — Determines whether a position requires serial-controlled instance handling.

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.