Search Results csp_receive_pvt




Overview
Explore in AI Chat

Overview

APPS.CSP_RECEIVE_PVT is a private (PVT) PL/SQL package belonging to the CSP product code, which governs the Oracle E-Business Suite services procurement and receiving flows associated with supplier and customer shipment processing. In EBS 12.1.1 and 12.2.2, this package acts as the internal engine that receives shipment data into the receiving open interface and ultimately drives the receipts into the inventory and purchasing tables. It converts inbound shipment information into the header, transaction, lot, and serial interface records consumed by the standard Receiving Open Interface (ROI) programs, and it appends receiving execution logic such as online request submission and vendor derivation.

The package declares two record types, rcv_hdr_rec_type and rcv_rec_type, that carry header-level and transaction-level attributes such as receipt source code, shipment numbers, purchase order identifiers, item identifiers, and organization identifiers. These structures define the public data contract used by callers passing shipment data into the receiving pipeline.

Key Procedures and Functions

  • RECEIVE_SHIPMENTS — The primary entry point. It accepts shipment header and detail data and orchestrates insertion of the corresponding receiving interface records.
  • INSERT_RCV_HDR_INTERFACE — Populates the receiving header interface with header-level shipment attributes, establishing the parent record for downstream transaction processing.
  • INSERT_RCV_TXN_INTERFACE — Inserts receiving transaction interface rows for each shipment line, including item, quantity, and source reference data.
  • INSERT_LOTS_INTERFACE — Writes lot-controlled item information into the lot interface so that lot numbers are validated and created during receipt processing.
  • INSERT_SERIAL_INTERFACE — Writes serial number records into the serial interface for serial-controlled items.
  • RCV_ONLINE_REQUEST — Submits or triggers the online receiving request that processes the staged interface data.
  • USER_INPUT_REQUIRED — Determines whether mandatory input is missing for the shipment and signals the caller that user intervention is needed.
  • VENDOR — Derives or returns vendor-related information required to validate and complete the receiving transaction.

Tables Accessed

The package reads and writes through APPS synonyms. Item validation and sourcing draw on MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_B, and MTL_SUPPLY. Inventory setup and receipt targets reference MTL_PARAMETERS, MTL_SECONDARY_INVENTORIES, and CSP_INV_LOC_ASSIGNMENTS. Transaction and control-number generation use MTL_MATERIAL_TRANSACTIONS_S. Lot and serial handling use MTL_LOT_NUMBERS, MTL_SERIAL_NUMBERS, MTL_SERIAL_NUMBERS_INTERFACE, and MTL_TRANSACTION_LOTS_INTERFACE. Organization and location context is resolved through HR_ORGANIZATION_INFORMATION and HR_LOCATIONS_ALL, user identity through FND_USER, and ledger/currency defaults through FINANCIALS_SYSTEM_PARAMETERS.

Usage Notes

Because CSP_RECEIVE_PVT is classified as a private package, it is not intended as a public API. It is referenced by four other packages and is typically invoked indirectly from CSP receiving forms, concurrent programs, or integration code that stages supplier shipment data for the Receiving Open Interface. The update_msn search term relates to shipment number updates handled when RECEIVE_SHIPMENTS and the header/txn interface procedures stamp or refresh shipment numbers (rcv_shipment_num, rcv_shipment_number) on the staged records. Customizations should not call private procedures directly; instead, supported receiving APIs or the standard ROI concurrent programs should be used, with the understanding that signature behavior may change between 12.1.1 and 12.2.2.