Search Results csd_repairs_util




Overview
Explore in AI Chat

Overview

CSD_REPAIRS_UTIL is a utility package in the APPS schema that provides the shared, low-level services underpinning the Oracle E-Business Suite Depot Repair module. It is classified as a UTIL package, meaning it is not an externally exposed business API but rather an internal helper layer consumed by the public and private repair APIs, concurrent programs, and forms. The package consolidates cross-cutting logic required throughout the repair lifecycle — receipt and return of defective items, repair order status transitions, entitlement and warranty evaluation, requisition creation, and item-instance ownership changes — so that the higher-level repair packages do not duplicate that logic.

The package sits within the CSD (Depot Repair) product family and is tightly coupled to the Service (CSI/CS) and Order Management/Service Fulfillment components. Its dependencies establish the module boundaries: it references CSD_REPAIRS_PUB, FND_API (for the standard Oracle API error-handling framework), OKS_ENTITLEMENTS_PUB (service contracts and entitlement verification), and the SYS.STANDARD library. The package has been validated as VALID against both Oracle EBS 12.1.1 and 12.2.2, and ETRM 12.2.2 documents 21 procedures and functions within it.

Key Procedures and Functions

The documented entry points divide into several functional groupings:

Tables Accessed

The package reads and writes a broad set of tables through APPS synonyms. CSD_REPAIRS, CSD_PRODUCT_TRANSACTIONS, CSD_PRODUCT_TRANSACTIONS_S1, CSD_REPAIR_JOB_XREF, CSD_WIP_TRANSACTION_DETAILS, and CSD_FLOW_STATUSES_B represent the core repair order, transaction, WIP, and workflow-status data. CSI_ITEM_INSTANCES, CSI_I_PARTIES, CSI_IP_ACCOUNTS, and HZ_PARTIES supply installed-base instance, party, and account context. BOM_DEPARTMENTS provides department references for WIP activity, while CS_ESTIMATE_DETAILS supports repair estimating. FND_USER, FND_PROFILE_OPTIONS_TL, and HR_ORGANIZATION_INFORMATION supply user, profile option translation, and organization information.

Usage Notes

CSD_REPAIRS_UTIL is not intended for direct invocation by external integrations. It is referenced by thirteen other packages, including CSD_REPAIRS_GRP, CSD_REPAIRS_PVT, CSD_BULK_RECEIVE_UTIL, CSD_REPAIR_ESTIMATE_PVT, CSD_REPAIR_GROUPS_PVT, CSD_SPLIT_PKG, CSD_UPDATE_PROGRAMS_PVT, and MRP_CL_REFRESH_SNAPSHOT, and it references itself for internal reuse. Typical invocation occurs from Depot Repair forms, concurrent programs, and the public repair APIs that wrap it. Customizations should call the public APIs (such as CSD_REPAIRS_PUB) rather than this utility package, since its signatures are not guaranteed stable across releases.