Search Results csd_actual_lines_rec_type

Overview

CSD_REPAIR_ACTUAL_LINES_PVT is a private PL/SQL package in the APPS schema that serves as the application programming interface for managing the line-level detail records of repair actuals within Oracle E-Business Suite's Enterprise Asset Management (eAM) and Depot Repair modules. In the Oracle EBS architecture, packages classified with the PVT suffix are private APIs: they encapsulate the core business logic that is invoked internally by public APIs and process utilities rather than being called directly from external custom code. This package provides the transactional foundation for creating, maintaining, and locking the actual repair line entries that record the parts, labor, and charges consumed against a repair order.

Key Procedures and Functions

The ETRM 12.2.2 metadata documents four procedures in this package:

• CREATE_REPAIR_ACTUAL_LINES — Inserts new repair actual line records, establishing the association between a repair actual header and its underlying transaction details.
• UPDATE_REPAIR_ACTUAL_LINES — Modifies existing repair actual line records to reflect changes in quantities, prices, or descriptions.
• DELETE_REPAIR_ACTUAL_LINES — Removes repair actual line records, supporting the reversal or correction of captured repair charges.
• LOCK_REPAIR_ACTUAL_LINES — Acquires a row-level lock on repair actual line records, enforcing concurrency control to prevent conflicting updates during concurrent processing sessions.

These procedures are not documented with parameter lists in the ETRM excerpt, and their private classification means they are intended for internal invocation only.

Tables Accessed

The package references a range of core tables via APPS synonyms, reflecting its role at the intersection of repair, order, and pricing data:

• CSD_REPAIR_ACTUAL_LINES and CSD_REPAIR_ACTUALS — the primary line and header tables for repair actuals, which the procedures create, update, and delete.
• CSD_REPAIRS and CSD_PRODUCT_TRANSACTIONS — source repair order and transaction data that populate the actual lines.
• CS_ESTIMATE_DETAILS, CS_CHARGE_DETAILS_PUB — estimate and charge information used to derive line-level costs and billable amounts.
• CS_INCIDENTS_ALL_B and CS_TRANSACTION_TYPES_B — incident and transaction type reference data.
• OE_ORDER_HEADERS_ALL and OE_PRICE_LISTS — order and price list data used when repair activity generates or references sales order pricing.

Usage Notes

As the dependency metadata confirms, CSD_REPAIR_ACTUAL_LINES_PVT is referenced by CSD_PROCESS_UTIL and CSD_REPAIR_ACTUAL_PROCESS_PVT, meaning it is typically invoked indirectly through these higher-level process utility and processing packages rather than being called from forms or concurrent programs directly. Because it relies on FND_API for standard API error handling and on CSD_GEN_UTILITY_PVT and CS_CHARGE_DETAILS_PUB for supporting business logic, it participates fully in the standard EBS API framework. Developers extending or troubleshooting Depot Repair and eAM repair-actual processing should treat this package as an internal implementation dependency and route changes through the supported public APIs instead of invoking its procedures directly.