Search Results csd_bulk_receive_pvt




Overview
Explore in AI Chat

Overview

CSD_BULK_RECEIVE_PVT is a private (PVT classification) PL/SQL package owned by APPS in Oracle E-Business Suite, and it is a core component of the Depot Repair and Field Service bulk receipt process. Its primary business function is to support the mass receipt of repairable items that have been returned from customers, field engineers, or depots. Rather than processing receipts one at a time through a form, the package provides a programmatic and concurrent-program interface for receiving many items in a single operation, which streamlines high-volume return flows and reduces manual data entry.

The header identifies the package as an AUTHID CURRENT_USER package, and the declarative section defines two global variables: g_bulk_rcv_conc (defaulting to 'N') and g_conc_req_id. The variable name suggests the package tracks whether it is executing in a concurrent-program context and, if so, the associated concurrent request ID. These globals appear tied to the 12.1.2 bulk receipt enhancement referenced in the source header.

Key Procedures and Functions

The documented package exposes a single procedure, process_bulk_receive_items, which the source comments describe explicitly as a concurrent program to bulk receive items. The procedure carries standard Oracle concurrent program parameters: errbuf and retcode for error and completion status reporting, plus p_transaction_number, which identifies the bulk receipt transaction to be processed. p_transaction_number is the driving input — it ties the concurrent process to a specific transaction that has been previously created and staged. No other public procedures or functions are documented in the ETRM metadata.

Tables Accessed

The package touches a set of tables that reflect its role as the transaction engine between user-staged receipt data and the underlying service entities:

  • CSD_BULK_RECEIVE_ITEMS_B — the base table that stores the items staged for bulk receipt. This is the primary source of the rows processed; the procedure reads (and updates status on) the lines associated with the transaction number.
  • CSD_PRODUCT_TRANSACTIONS — records the product (service) transaction being processed, linking the bulk receipt to the depot repair transaction context.
  • CSD_REPAIRS — the repair records that the received items will be associated with once receipt completes.
  • CSI_ITEM_INSTANCES — the installed base records that represent the customer's specific item instances being received.
  • CSI_INSTALL_PARAMETERS — configuration/parameter data used by the CSI instance machinery.
  • CS_ESTIMATE_DETAILS, CS_INCIDENTS_ALL_B, HZ_CUST_ACCOUNTS — service estimate, service request/incident, and customer account data used to resolve ownership and service context for the returned items.
  • MTL_SYSTEM_ITEMS_KFV — the item key flexfield view, used to validate and resolve inventory item definitions.
  • PLITBLM — a generic PL/SQL table (index-by) used internally for bulk collections.

Usage Notes

CSD_BULK_RECEIVE_PVT is a PVT package, meaning it is intended for internal use within the CSD (Depot Repair/Field Service) product family rather than as a public extension API. It is documented as referenced by two other packages, confirming that other components rely on its logic. The standard invocation path is as an Oracle Concurrent Program — the procedure's signature (errbuf, retcode, p_transaction_number) is the classic concurrent-program interface. Users typically stage bulk receipt items in the Depot Repair/Field Service UI and then submit the "Bulk Receive Items" concurrent program, passing the relevant transaction number. Custom code could technically call the package, but given its private classification and dependency on staged CSD data, direct invocation outside the supported concurrent path is not recommended. The global flag g_bulk_rcv_conc further indicates context-sensitive behavior between form-initiated and concurrent-program-initiated processing.