Search Results mc_name




Overview
Explore in AI Chat

Overview

APPS.AHL_MC_PATH_POSITION_PUB is a public PL/SQL package in the Oracle E-Business Suite Application Object Library (AHL) schema family, part of the Oracle Complex Maintenance, Repair and Overhaul (CMRO) module. Its overall purpose is to manage the identification and validation of "path positions" — the structural or logical positions along a maintenance path used by CMRO maintenance-configuration (MC) records. The package exposes a public API surface whose primary responsibility is to take user-supplied path-position data, validate it, resolve coded reference values into their internal identifiers, and persist or return the resulting position identifier.

The package follows the standard EBS PL/SQL API architecture: a public (PUB) wrapper layer that performs validation and message-stack management, delegating actual work to a private (PVT) package, AHL_MC_PATH_POSITION_PVT. This separation allows the public interface to remain stable while internal implementation details stay encapsulated in the private package.

Key Procedures and Functions

  • CREATE_POSITION_ID — The sole documented public procedure. It is the primary entry point for creating a path-position identifier. According to the package comments, it "does user input validation and calls private API Create_Position_ID." It accepts a path-position table (of type AHL_MC_PATH_POSITION_PVT.Path_Position_Tbl_Type), a position reference meaning, and a position reference code, and returns the generated position identifier together with the standard EBS API return status and message-stack variables. It follows the conventional EBS API parameter conventions, including p_api_version, p_init_msg_list, p_commit, and p_validation_level.
  • Convert_Path_Pos_Values_to_Id — Declared as a local (private) procedure within the package body, not part of the public API. It converts path-position values to identifiers, operating on an IN OUT NOCOPY path-position table.

Tables Accessed

  • AHL_MC_HEADERS_B — The base table for CMRO maintenance-configuration headers. The package references this table (via the APPS synonym) to associate a path position with its parent maintenance configuration header record.
  • PLITBLM — A PL/SQL internal/utility table used for message handling and error/return-status processing, consistent with the standard FND message-stack pattern.

Note that the mc_name search term relates to the maintenance-configuration header name stored in AHL_MC_HEADERS_B; path positions are structured under these named maintenance configurations.

Usage Notes

  • The package is classified as a PUB API, meaning it is intended for direct invocation by Oracle EBS forms, concurrent programs, or custom application code — not merely internal use.
  • It is the standard integration point for creating path-position identifiers programmatically; callers should invoke CREATE_POSITION_ID rather than manipulating AHL_MC_HEADERS_B or path tables directly.
  • Because it delegates to a private package and uses the FND message stack, callers should inspect x_return_status and the message count/data outputs for error handling.
  • The metadata indicates the package is referenced by zero other packages, so it is a top-level API rather than a dependency of other PL/SQL units.
  • Typical invocation contexts include CMRO configuration setup screens and any custom code that needs to define or resolve maintenance path positions tied to a named maintenance configuration.