Search Results cs_charges

Overview

The APPS.CSD_BULK_RECEIVE_PVT package body is a private (PVT) PL/SQL API within the Oracle E-Business Suite Depot Repair (CSD) module. Its principal business function is to support the Bulk Receive Items concurrent program, which processes multiple returned or received items in a single transactional batch rather than individually. The package reconciles inbound item records against repair lines, service requests, ownership assignments, and installation parameters, determining for each staged line whether a service request must be created, an ownership change must be executed, or a receiving party must be validated.

The package operates against the transactional staging table CSD_BULK_RECEIVE_ITEMS_B, which holds rows keyed by transaction_number. Each row carries control flags such as internal_sr_flag, change_owner_flag, status, and identifiers including incident_id, repair_line_id, and party_id. These flags drive conditional processing branches inside the package.

Key Procedures and Functions

• PROCESS_BULK_RECEIVE_ITEMS — The sole documented procedure and the package's public entry point. It accepts standard concurrent program OUT parameters (errbuf, retcode) plus an input transaction number identifying the batch to process. Internally it declares several explicit cursors that segment the staged rows by processing intent: a validation cursor for IB owner and bulk receive party determination, a change-owner cursor for rows flagged change_owner_flag = 'Y' with no party assigned, a cursor for creating internal service requests, a cursor retrieving the internal party from installation parameters, and a cursor for service request creation based on distinct party and customer account combinations. Rows are selected where incident_id and repair_line_id are null and status is NEW or ERRORED, confirming the procedure is both an initial processor and a retry handler for previously failed lines.

No additional documented procedures or functions exist in the ETRM metadata; all other logic is contained within this single driver procedure.

Tables Accessed

• CSD_BULK_RECEIVE_ITEMS_B — Primary staging and control table; source of all row selection and status updates.
• CSD_REPAIRS — Links staged items to repair lines for depot repair processing.
• CSD_PRODUCT_TRANSACTIONS — Records the resulting product movement or receipt transaction.
• CS_INCIDENTS_ALL_B — Source for service request (incident) creation.
• CSI_ITEM_INSTANCES — Identifies the installed base instance being received.
• CSI_INSTALL_PARAMETERS — Supplies the internal party identifier used when creating internal service requests.
• CS_ESTIMATE_DETAILS — Provides estimate line context associated with repair activity.
• HZ_CUST_ACCOUNTS — Resolves party to customer account mapping, filtered on active status.
• MTL_SYSTEM_ITEMS_KFV — Item validation and descriptive flexfield key view access.
• PLITBLM — Standard EBS PL/SQL table for bulk DML operations.

Usage Notes

This package is designed for invocation from the Bulk Receive Items concurrent program in Oracle EBS 12.1.1 and 12.2.2, submitted through the standard concurrent manager framework with the transaction number as a parameter. It is referenced by two other packages, indicating it may also be called programmatically as part of a larger depot repair or receiving flow. Because it is a PVT API, Oracle does not guarantee its signature across releases; customizations or extensions that reference CSD_BULK_RECEIVE_PVT, or that query related charge and estimate data such as cs_charges, should treat it as non-public and validate behavior after any patch or upgrade. The ERRORED status handling means the procedure may be safely re-run against a batch to reprocess failed lines.