Search Results is_order_header_closed

Overview

APPS.AHL_OSP_SHIPMENT_PUB is a public PL/SQL package in the Oracle E-Business Suite application suite of Oracle's AHL (Complex Maintenance, Repair, and Overhaul) product family. Its declared purpose, per the package header annotation, is to contain record types and public procedures used to process shipment headers and shipment lines that are associated with OSP (Outside Processing) orders. The package is declared with AUTHID CURRENT_USER and is classified as a PUB API, meaning it is designed for invocation by external callers, forms, and other packages rather than serving purely as an internal implementation detail. The display name registered for the package is "Process OSP Shipment," and its lifecycle status is active. The current header revision dates from 2008, with a note that the package was extended to fix the OGMA Part Number Change enhancement request (ER). Related content indicates the package supports serial number change processing for OSP lines in addition to general shipment header and line processing. The business entity associated with this API is AHL_OSP_ORDER, confirming the package operates in the domain of outside-processing orders in an MRO environment.

Key Procedures and Functions

The package exposes ten documented procedures and functions. Their documented names and purposes are as follows:

• PROCESS_ORDER — Processes an OSP order shipment, driving the primary shipment handling logic for order headers and lines.
• BOOK_ORDER — Books the OSP order, transitioning it into a booked state.
• DELETE_CANCEL_ORDER — Handles deletion or cancellation of an OSP order.
• IS_ORDER_HEADER_CLOSED — A check function that determines whether the order header is closed.
• CONVERT_SUBTXN_TYPE — Converts a subtransaction type, supporting transactional consistency.
• HANDLE_VENDOR_CHANGE — Processes vendor changes on OSP orders and their associated lines; relevant to the user's search term "handle_vendor_change."
• IS_PART_CHG_VALID_FOR_OSPLINE — Validates whether a part change is permitted for a given OSP line, tied to the OGMA part number change support.
• PROCESS_OSP_SERIALNUM_CHANGE — Processes serial number changes for OSP lines, using the Sernum_Change_Rec_Type record structure.
• CREATE_IB_TRANSACTION — Creates an inter-business (IB) transaction.
• DELETE_IB_TRANSACTION — Deletes an inter-business transaction.

Tables Accessed

The package reads and writes core AHL, inventory, and CSI tables through APPS synonyms. AHL_OSP_ORDERS_B and AHL_OSP_ORDER_LINES hold the OSP order headers and lines being processed. MTL_LOT_NUMBERS supports lot handling for part and serial changes. AHL_INV_SERVICE_ITEM_RELS and AHL_ITEM_VENDOR_RELS define the item-vendor and service-item relationships central to outside processing. AHL_VENDOR_CUSTOMER_RELS, AHL_VISITS_B, AHL_VISIT_TASKS_B, and AHL_WORKORDERS link shipment activity to visits, tasks, and repair work orders. CSI_IEA_VALUES, CSI_II_RELATIONSHIPS, CSI_INSTALL_PARAMETERS, CSI_ITEM_INSTANCES, CSI_I_PARTIES, and CSI_TXN_TYPES support install-base instance, party, transaction-type, and relationship data used during serial or instance changes.

Usage Notes

This package is typically invoked from OSP order and shipment forms, from concurrent programs handling OSP shipment processing, or from custom extensions calling the packaged public APIs. It is referenced by five other packages in the ETRM metadata. Callers requiring vendor change handling should invoke HANDLE_VENDOR_CHANGE, while part and serial changes are handled through IS_PART_CHG_VALID_FOR_OSPLINE and PROCESS_OSP_SERIALNUM_CHANGE. Because the API is AUTHID CURRENT_USER, execute privileges on both the package and its underlying tables must be granted to the calling schema.