Search Results receive_item

Overview

CSD_RECEIVE_PVT is a private PL/SQL package in the APPS schema that supports receiving functionality within Oracle E-Business Suite. Its principal business role is to populate the Receiving open interface tables and then invoke the standard Receiving processor to complete material receipts. Because it orchestrates the population of the interface tables and delegates final processing to the seeded receiving engine, it serves as the integration point between replenishment and receiving operations rather than as a standalone receiving engine.

The package is classified as a PVT (private) API, indicating it is intended for internal use by Oracle's own applications and supporting components rather than as a published, customer-facing interface. In release 12.2.2 it exposes four documented procedures. Its primary documented caller is CSDREPLN.pld, which invokes it from the Logistics tab, meaning the package is exercised as part of replenishment-driven receipt creation.

Key Procedures and Functions

• RECEIVE_ITEM — Populates the Receive open interface tables and calls the Receive processor. According to the source header, it handles all types of receives, including Direct and Standard receipts. It is documented as being called from CSDREPLN.pld on the logistics tab. The header documents an API-standard parameter signature covering API version, message list initialization, commit control, validation level, a required receive record of type CSD_RECEIVE_UTIL.RCV_REC_TYPE, and output parameters for return status, message count, message data, and a receive error message table, together with a receive table of type CSD_RECEIVE_UTIL.RCV_TBL_TYPE.
• POPULATE_RCV_INTF_TBLS — The interface-population procedure matching the search term. It writes the receipt data into the Receiving open interface tables in preparation for processing. This is the core routine that converts application-level receive data into the rows expected by the Receiving open interface.
• RCV_REQ_ONLINE — Supports online requisition-related receiving activity, operating within the same interface-population and processing flow used by the package.
• DELETE_INTF_TBLS — Removes rows from the Receiving interface tables. This cleanup routine is used to purge interface records after processing or to reset interface state before a new population attempt.

Tables Accessed

The package reads from and writes to the Receiving open interface tables that form the backbone of the integration: RCV_HEADERS_INTERFACE, RCV_HEADERS_INTERFACE_S, RCV_TRANSACTIONS_INTERFACE, RCV_TRANSACTIONS_INTERFACE_S, and RCV_INTERFACE_GROUPS_S. These hold the receipt header, transaction, and interface group records that the Receiving processor consumes. MTL_SERIAL_NUMBERS_INTERFACE and MTL_TRANSACTION_LOTS_INTERFACE carry serial number and lot information for the receipts being created. MTL_MATERIAL_TRANSACTIONS_S is referenced in connection with material transaction processing.

OE_ORDER_LINES_ALL and PO_INTERFACE_ERRORS provide order line and interface error context. FND_NEW_MESSAGES is used for message handling, consistent with the API message stack parameters, while DUAL and PLITBLM are referenced for utility purposes. The tables are reached through APPS synonyms.

Usage Notes

CSD_RECEIVE_PVT is invoked programmatically, most notably from the replenishment logic in CSDREPLN.pld, and it is referenced by two other packages within the application. It is not designed as a direct-entry point for end users or for ad hoc custom development; as a PVT API it may change without notice across releases. Custom code should avoid calling it directly and should instead use the public Receiving interfaces, allowing the standard processor to handle validation and transaction creation.