Search Results ahl_osp_order

Overview

The APPS.AHL_OSP_SERV_ITEM_RELS_PVT package is a private (PVT-classified) PL/SQL API within the Oracle E-Business Suite Discrete Manufacturing and Enterprise Asset Management (eAM) product family, specifically associated with the AHL (Advanced Service) application module. In the context of Oracle EBS 12.1.1 and 12.2.2, this package supports the Oracle Spares Management (OSP) business flow, which governs the procurement, shipment, and replenishment of spare parts used in field service and depot repair operations. The package encapsulates the business logic required to create and maintain the relationship between an inventory item and a service item — a critical association that links replenishable stock items to the services they are intended to fulfill.

The package declares the AUTHID CURRENT_USER directive, meaning it executes with the privileges of the calling user rather than the definer, which is a common convention for private APIs that are invoked only by other trusted packages within the same schema. Its lifecycle is marked as active, and its documented business entity is AHL_OSP_ORDER, which aligns directly with the user's search term "ahl_osp_order." The package header denotes a @rep:scope public classification for repository purposes despite the PVT naming, indicating that its procedures are documented for reference even though they are not intended for direct external invocation.

Key Procedures and Functions

The ETRM metadata documents a single procedure exposed by this package:

• PROCESS_SERV_ITM_RELS — This is the core public procedure responsible for creating or updating the relationship between an inventory item and a service item. Its declared function is to process the association records passed to it, using the standard Oracle API framework conventions (API version, initialization message list, commit flag, and validation level as standard IN parameters, with return status, message count, and message data as standard OUT parameters). The procedure operates on a record of type Inv_Serv_Item_Rels_Rec_Type, which is passed as an IN OUT NOCOPY parameter. The operation flag embedded in that record (C, U, or D) determines whether the relationship is created, updated, or deleted, enabling the procedure to serve as a single entry point for all maintenance operations on the inventory item to service item mapping.

The package additionally defines the record type Inv_Serv_Item_Rels_Rec_Type, which carries the full attribute set for a relationship row: the relationship identifier, object version number, inventory item and organization identifiers and names, service item identifier and name, rank, active start and end dates, an all-organizations flag, and the operation flag. This record type underpins the interface contract of the procedure.

Tables Accessed

According to the documented metadata, the package reads and writes the following tables through APPS synonyms:

• AHL_INV_SERVICE_ITEM_RELS — The principal base table holding the inventory-to-service item relationship records that the procedure creates, updates, or deletes.
• AHL_INV_SERVICE_ITEM_RELS_S — The corresponding sequence or secondary support table used to generate unique relationship identifiers.
• AHL_ITEM_VENDOR_RELS — Consulted to reconcile item-to-vendor relationships that may be affected by the service item mapping.
• HR_ALL_ORGANIZATION_UNITS — Used to resolve and validate inventory organization identifiers and their descriptive names.
• MTL_SYSTEM_ITEMS_B and MTL_SYSTEM_ITEMS_KFV — The inventory item master base table and its key flexfield view, used to validate inventory and service item identifiers and to populate item name attributes.

Usage Notes

As a private API, AHL_OSP_SERV_ITEM_RELS_PVT is not intended to be called directly by end users, forms, or external applications. The metadata confirms that it is referenced by one other package, which acts as the public-facing wrapper or orchestration layer that performs the bulk of cross-entity validation before delegating relationship maintenance to this procedure. Typical invocation therefore occurs from within the Oracle Spares Management setup and order-processing flows, particularly when configuring which service items can be fulfilled by which inventory items during OSP order creation and shipment processing.

Customizations in Oracle EBS 12.1.1 and 12.2.2 should avoid direct calls to this package wherever possible. Where extension is required, the recommended approach is to invoke the public wrapper package or to use supported personalization and extension points, thereby preserving the integrity of the relationship tables and the validation logic embedded in PROCESS_SERV_ITM_RELS.