Search Results map_instance_to_pos_id

Overview

APPS.AHL_MC_PATH_POSITION_PVT is a private (PVT) PL/SQL package within the Oracle E-Business Suite Advanced Product Catalog / Asset Lifecycle (AHL) module family, specifically the Master Configuration (MC) subsystem. It manages the logical "path positions" that describe where a configured instance or item sits within a master configuration structure — the navigable hierarchy that defines how configurable products are organized into positions, sequence numbers, and encoded reference paths.

The package declares the Path_Position_Rec_Type record structure, which carries the full attribute set of a path position: PATH_POSITION_ID, OBJECT_VERSION_NUMBER, standard WHO audit columns, SEQUENCE, MC_ID, MC_NAME, MC_REVISION, VERSION_NUMBER, POSITION_KEY, and the fifteen ATTRIBUTE flex columns. This record is the currency of the package's public API. The companion types — Path_Position_Tbl_Type (an INDEX BY BINARY_INTEGER associative array of that record) and the GET_* reference lookups — allow callers to pass and receive complete position graphs in a single call. The package executes AUTHID CURRENT_USER and is compiled in the APPS schema with synonyms to base tables.

Key Procedures and Functions

ETRM documents sixteen procedures and functions. The central write-side entry point is CREATE_POSITION_ID, a private API that creates a new path position or, when the supplied data matches an existing row, returns the existing PATH_POSITION_ID. It accepts a Path_Position_Tbl_Type collection and a p_position_ref_meaning parameter.

• MAP_INSTANCE_TO_POSITIONS / MAP_POSITION_TO_INSTANCES — Bidirectional resolution between configured instances and the positions they occupy.
• MAP_INSTANCE_TO_POS_ID — Resolves an instance directly to its path position identifier.
• GET_POS_INSTANCE — Retrieves the instance associated with a given position.
• COPY_POSITIONS_FOR_MC / COPY_POSITION — Clone position definitions, individually or in bulk, for an existing or new master configuration.
• DELETE_POSITIONS_FOR_MC — Removes the position set belonging to a master configuration.
• GET_POSREF_BY_ID — The function implicated by the search term get_posref_by_id; it returns the encoded position reference for a supplied position identifier.
• GET_POSREF_BY_PATH — Derives a position reference from a specified path.
• GET_POSREF_FOR_UC — Returns a position reference for a unit configuration context.
• GET_ENCODED_PATH / CHECK_POS_REF_PATH / ENCODE — Generate, validate, and encode hierarchical path strings used as navigational tokens.
• IS_POSITION_SERIAL_CONTROLLED — Boolean test for serial-number control at a position.

Tables Accessed

The package operates primarily on the AHL master configuration position tables: AHL_MC_PATH_POSITIONS and its _S (sequence) counterpart, AHL_MC_PATH_POSITION_NODES and its _S sequence, plus AHL_MC_HEADERS_B, AHL_MC_CONFIG_RELATIONS, AHL_MC_RELATIONSHIPS, and AHL_MC_RULE_STATEMENTS. Instance linkage is resolved against AHL_APPLICABLE_INSTANCES and AHL_UNIT_CONFIG_HEADERS. Item metadata is validated against MTL_SYSTEM_ITEMS_B and configuration relations against AHL_ITEM_ASSOCIATIONS_B; instance hierarchy relationships use CSI_II_RELATIONSHIPS. DBMS_SQL and DUAL appear for dynamic SQL and scalar defaults.

Usage Notes

As a PVT package, it is not intended for direct end-user or custom invocation without a supported wrapper. It is referenced by 24 other packages in the AHL schema and is invoked from Oracle Forms configuration workbenches, concurrent programs that build or copy master configurations, and internal PL/SQL service layers performing path encoding and instance-to-position mapping. Custom code using get_posref_by_id should call it through a public API or the package's documented signature, and should treat position references as opaque, encoded tokens produced and consumed by the GET_POSREF_* and ENCODE routines.