Search Results ahl_rm_route_pvt




Overview
Explore in AI Chat

Overview

APPS.AHL_RM_ROUTE_PVT is a private PL/SQL package within the Oracle E-Business Suite Oracle Manufacturing Execution System (MES) / Enigma Routing module, classified under the Application Object Library as a "PVT" (private) API. Its role is to encapsulate the core business logic for managing routings — the ordered sequence of operations, resources, materials, panels, and documents that define how a manufactured item is built. Routing records underpin shop-floor execution, work-order generation, and revision control within the AHL (Advanced Manufacturing / Enigma) schema family, and this package centralises the validation and persistence routines that public APIs and concurrent processes rely upon.

The package is a foundational internal component. Rather than being called directly by end users or external integrations, it is invoked by the higher-level public layer (notably AHL_RM_ROUTE_PUB) and by sibling private packages that handle associated documents, materials, operations, panels, and resources. It depends on FND_API for the standard Oracle EBS API framework conventions (return-status, message handling), confirming it follows the documented AOL API programming standards.

Key Procedures and Functions

The documented interface exposes three procedures:

  • PROCESS_ROUTE — The primary driver for persisting a complete routing definition. It coordinates the insert, update, or delete of the routing and its dependent operations, alternates, materials, panels, and associated documents, applying cross-table validation before committing changes.
  • DELETE_ROUTE — Removes a routing and its related child records, enforcing referential integrity across the routing header, operations, dependencies, and association tables before the deletion is finalised.
  • CREATE_ROUTE_REVISION — Creates a new controlled revision of an existing routing, copying and re-versioning the routing header and its associated structures so that effectivity and change control can be maintained.

No parameter signatures are documented in the available metadata; callers should reference the package specification in the APPS schema for exact argument lists. All three procedures follow the FND_API return-status convention.

Tables Accessed

The package reads and writes the AHL routing base and translation tables and their children via APPS synonyms. The principal entities are:

These tables collectively hold the routing structure and its related manufacturing data, which PROCESS_ROUTE and CREATE_ROUTE_REVISION maintain as a coordinated set.

Usage Notes

AHL_RM_ROUTE_PVT is an internal (PVT) package and is not intended for direct invocation by custom code or concurrent programs. It is referenced by eight documented packages, including AHL_RM_ROUTE_PUB, AHL_ENIGMA_ROUTE_OP_PUB, AHL_RM_OP_ROUTE_AS_PVT, AHL_RM_MATERIAL_AS_PVT, AHL_RM_RT_OPER_PANEL_PVT, AHL_RM_RT_OPER_RESOURCE_PVT, AHL_RM_ASSO_DOCASO_PVT, and the AHL_RM_ROUTE_PVT_W wrapper. The routing maintenance forms in Oracle MES / Enigma Routing ultimately drive this logic through the public PUB layer; integrators should target the public API rather than this private package. The "_W" companion package suggests a thin wrapper used where an AOL-standard entry point is required. Because behaviour can change between 12.1.1 and 12.2.2, customisations should not call AHL_RM_ROUTE_PVT directly.