Search Results default_int_org_trans_del

Overview

APPS.RCV_INT_ORG_TRANSFER is an internal Oracle E-Business Suite PL/SQL package that supports the derivation, validation, and defaulting of data used during internal requisition and inter-org (intra-org) transfer processing within the Receiving module. It belongs to the family of Receiving Open Interface (ROI) preprocessor routines, and it operates closely with the RCV_ROI_PREPROCESSOR package, whose collection types (such as cascaded_trans_tab_type and header_rec_type) form the data structures passed between its procedures.

Although the user's search term was "project transfer," the documented scope of this package is internal organization transfer — goods moving between inventory organizations — rather than Oracle Projects cost transfers. In the context of Oracle EBS 12.1.1 and 12.2.2, the package serves as a helper layer that pre-populates and validates cascaded transfer records before they are written to the receiving transactions interface. It is classified as an OTHER API, meaning it is not a formally published open interface but an internal component invoked by Receiving's preprocessing logic. It references a cascaded transaction table (a temporary working structure) and iterates over entries using an index variable n, deriving line-level and delivery-level attributes from shipment header and line context. The package is referenced by three other packages, confirming its role as a supporting utility rather than a user-facing entry point.

Key Procedures and Functions

The package exposes eleven documented procedures, which fall into three functional groups.

• Receipt line derivation and defaulting: DERIVE_INT_ORG_RCV_LINE, DERIVE_INT_ORG_RCV_LINE_QTY, and DEFAULT_INT_ORG_RCV_LINE build and populate receiving line records for internal organization transfers, including quantity assignment.
• Delivery derivation and defaulting: DERIVE_INT_ORG_TRANS_DEL, DERIVE_TRANS_DEL_LINE_QUANTITY, and DEFAULT_INT_ORG_TRANS_DEL operate on transfer delivery information and associated line quantities.
• Correction line handling: DERIVE_INT_ORG_COR_LINE, DERIVE_INT_ORG_COR_LINE_QTY, and DEFAULT_INT_ORG_COR_LINE handle correction-type transfer records.
• Validation: VALIDATE_INT_ORG_RCV_LINE and VALIDATE_REF_INTEGRITY verify that derived records are internally consistent and that referenced data (such as unit of measure or source references) is valid before processing continues.

All derivation and defaulting procedures operate on the cascaded transaction collection and use paired header-record and index inputs to locate and update the current working row.

Tables Accessed

The package reads from several Oracle EBS base tables through APPS synonyms:

• RCV_SHIPMENT_HEADERS and RCV_SHIPMENT_LINES — provide shipment context for deriving receipt and delivery attributes.
• RCV_TRANSACTIONS and RCV_TRANSACTIONS_INTERFACE — the transaction and interface tables populated during receiving processing.
• RCV_SUPPLY — supplies internal requisition source data for internal transfers.
• PO_LINE_LOCATIONS — provides purchasing shipment and distribution scheduling detail.
• MTL_UNITS_OF_MEASURE — validates unit of measure values during defaulting and validation.
• PLITBLM — a Receiving/PL/SQL utility table used in parsing and column-level processing.

Usage Notes

RCV_INT_ORG_TRANSFER is an internal package and is not intended to be called directly by end users. It is typically invoked indirectly by the Receiving Open Interface preprocessor when processing internal organization transfer transactions, whether those originate from Purchasing, Inventory, or mobile receiving forms. Customizations should avoid calling the derivation procedures directly, since they depend on the cascaded table structure maintained by RCV_ROI_PREPROCESSOR. Oracle recommends using the supported RCV interfaces for any custom integration rather than this internal package, as its signature is not part of the published API contract in either 12.1.1 or 12.2.2.