Search Results io_ship_update

Overview

CSD_UPDATE_PROGRAMS_PVT is an internal PL/SQL package in the APPS schema of Oracle E-Business Suite, belonging to the Enterprise Asset Management (eAM) and Depot Repair family of modules (CSD prefix). It carries an API classification of "PVT," indicating it is a private package intended for internal consumption by Oracle's own application code rather than by external or customer-developed integrations. Its principal business function is to centralize the status and program updates that occur as repair, return, receipt, shipment, and work-in-process transactions are processed through Depot Repair and logistics flows. Rather than allowing each calling module to write directly against the underlying repair and inventory tables, Oracle routes those updates through this package, which keeps the logic for converting units of measure, logging activity, and synchronizing transaction statuses in one place. The package is documented with a VALID status in ETRM 12.2.2, and its dependency footprint confirms that it is a shared utility at the center of the CSD transaction-processing chain.

Key Procedures and Functions

The package exposes eighteen documented procedures and functions. Several relate to material receipt and return handling, including RECEIPTS_UPDATE, RMA_RCV_UPDATE, IO_RCV_UPDATE, and IO_RCV_UPDATE_MOVE_OUT, which update repair and inventory records when goods are received against returns, RMAs, or internal orders, including the internal-order move-out case. A corresponding shipment group covers SHIP_UPDATE, SO_SHIP_UPDATE, and IO_SHIP_UPDATE for outbound movement against sales orders and internal orders. Job-related updates are handled by JOB_CREATION_UPDATE and JOB_COMPLETION_UPDATE, while WIP_UPDATE and PROD_TXN_STATUS_UPD address work-in-process and product transaction status maintenance. CONVERT_TO_RO_UOM performs unit-of-measure conversion to the repair-order UOM, and LOG_ACTIVITY records activity history for auditing and tracking. UPDATE_LOGISTIC_STATUS_WF drives logistics status changes through workflow. A set of concurrent-program entry points — RECEIPTS_UPDATE_CONC_PROG, WIP_UPDATE_CONC_PROG, SHIP_UPDATE_CONC_PROG, and TASK_UPDATE_CONC_PROG — provide schedulable wrappers around the corresponding update logic.

Tables Accessed

The package reads and writes a consistent set of eAM and inventory tables through APPS synonyms. CSD_REPAIR_HISTORY and CSD_REPAIRS hold the core repair records, while CSD_PRODUCT_TRANSACTIONS and CSD_REPAIR_JOB_XREF link repairs to transactions and jobs. CSD_REPAIR_TYPES_B supplies repair type definitions. CSI_ITEM_INSTANCES provides instance-level item data for tracked items. CS_ESTIMATE_DETAILS and CS_INCIDENTS_ALL_B connect the repair to service estimates and incidents, and HR_ALL_ORGANIZATION_UNITS resolves organizational context. On the inventory side, MTL_MATERIAL_TRANSACTIONS, MTL_SYSTEM_ITEMS, MTL_SERIAL_NUMBERS, MTL_LOT_NUMBERS, MTL_TRANSACTION_LOT_NUMBERS, and MTL_TXN_REQUEST_LINES support receipt, shipment, serial, lot, and move-order processing. Together these accesses explain why the package is invoked during nearly every repair-related transaction.

Usage Notes

CSD_UPDATE_PROGRAMS_PVT is not intended for direct customer invocation. It is referenced by six other packages — CSD_BULK_RECEIVE_UTIL, CSD_LOGISTICS_UTIL, CSD_PROCESS_PVT, CSD_REPAIRS_UTIL, CSD_SOO_PVT, and CSD_WIP_JOB_PVT — which call it as part of the standard Depot Repair and logistics processing flows. Its concurrent-program procedures may be scheduled through Oracle's concurrent manager, and its logic can be triggered indirectly through the Depot Repair and shipping forms that drive the calling utilities. Customizations should avoid calling the package directly and instead invoke the higher-level public APIs, since the PVT designation signals an unstable internal interface whose signatures and behavior may change between releases.