Search Results validate_internal_order_header

Overview

RCV_INT_ORDER_PP_VPT is a private PL/SQL package in the APPS schema that supports Oracle E-Business Suite's Receiving Open Interface (ROI) processing, specifically for internal order (intra-organization) receipts and transfers. The suffix _PVT indicates this is a private package, meaning its procedures and functions are not part of the public API surface and are intended to be invoked only by other receiving packages rather than directly by customer extensions. The package encapsulates the defaulting, derivation, and validation logic required to convert inbound ROI records into valid receiving and inventory transaction data for internal requisitions and internal sales orders.

In the context of Oracle EBS 12.1.1 and 12.2.2, this package plays a supporting role within the ROI framework that processes records staged in the RCV_TRANSACTIONS_INTERFACE table. When the RCV_ROI_PREPROCESSOR program runs to validate and enrich incoming interface records, routines in this package are called to populate mandatory internal order attributes before downstream processing. The user search term "rcv_roi_preprocessor" confirms that RCV_INT_ORDER_PP_PVT is a direct dependency of APPS.RCV_ROI_PREPROCESSOR, as documented in the ETRM dependency metadata.

Key Procedures and Functions

The ETRM metadata documents fifteen procedures and functions, grouped by purpose:

• DERIVE_INTERNAL_ORDER_HEADER — Derives header-level internal order attributes from source documents.
• DEFAULT_INTERNAL_ORDER_HEADER — Applies default values to the internal order header record.
• VALIDATE_INTERNAL_ORDER_HEADER — Validates that populated header attributes are consistent and complete.
• DEFAULT_SHIPMENT_INFO — Defaults shipment-level information for the receiving record.
• UPDATE_HEADER — Persists header changes to the appropriate database structures.
• DERIVE_IO_RECEIVE_LINE / DERIVE_IO_TRANS_LINE / DERIVE_IO_CORRECT_LINE — Derive line-level attributes for internal order receive, transfer, and correction transactions respectively.
• DEFAULT_IO_RECEIVE_LINE / DEFAULT_IO_TRANS_LINE / DEFAULT_IO_CORRECT_LINE — Apply line-level defaults for each transaction type.
• VALIDATE_IO_RECEIVE_LINE — Validates receive line data before processing.
• GET_DELIVER_TO_PERSON_FROM_RSL / GET_DELIVER_TO_PERSON_FROM_RT / GET_DELIVER_TO_PERSON_FROM_RTI — Retrieve deliver-to person information from the receiving shipment line, receiving transaction, or transaction interface source, resolving the correct recipient.

Tables Accessed

The package references the following tables via APPS synonyms: RCV_TRANSACTIONS_INTERFACE and RCV_TRANSACTIONS (the staging and transaction tables central to ROI); RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES (shipment defaulting and validation); PO_LINE_LOCATIONS and PO_REQUISITION_LINES_ALL (internal order source document lines); MTL_SYSTEM_ITEMS and MTL_UNITS_OF_MEASURE (item and UOM validation); MTL_INTERORG_PARAMETERS (inter-org transfer control settings); RCV_PARAMETERS (receiving system configuration); and PLITBLM (Oracle's PL/SQL integer table type used for IN-list handling).

Usage Notes

RCV_INT_ORDER_PP_VPT is invoked indirectly through the standard ROI flow rather than called directly from forms or concurrent programs. The Receiving Transactions Interface concurrent programs and the RCV_ROI_PREPROCESSOR trigger its procedures, and it is also referenced by RCV_ROI_HEADER. Because the package is private, customizations should not call it directly; instead, developers should feed properly formatted records into RCV_TRANSACTIONS_INTERFACE and allow the standard preprocessing and receiving process to execute this logic.