Search Results delete_ro_service_code




Overview
Explore in AI Chat

Overview

CSD_RO_SERVICE_CODES_PVT is a private PL/SQL API package in the Oracle E-Business Suite Deposits, Repair Orders, and Service (CSD) module, owned by the APPS schema and declared with AUTHID CURRENT_USER. It provides the low-level, programmatic maintenance layer for Repair Order (RO) service code assignments—the records that associate a specific service code and source solution with a repair line so that the service can be applied to an estimate or to work. The package is classified as PVT, meaning it is an internal implementation package not intended for direct customer invocation; a public wrapper package normally exposes the same capabilities with validation and security handling. It was last revised under header csdvrscs.pls 120.1 (2006/09/19), and remains current through EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented API surface consists of four procedures:

  • CREATE_RO_SERVICE_CODE — Inserts a new repair order service code record. It accepts a standard API parameter set (API version, commit flag, initialization of the message list, validation level, and the OUT return status, message count, and message data), plus a record of type RO_SERVICE_CODE_REC_TYPE carrying the service code data. It returns the newly generated ro_service_code_id.
  • UPDATE_RO_SERVICE_CODE — Modifies an existing repair order service code record, applying the same standard API and record parameters so that changes such as applicable flags or descriptive attributes can be persisted.
  • DELETE_RO_SERVICE_CODE — Removes an existing repair order service code assignment.
  • LOCK_RO_SERVICE_CODE — Acquires the row-level lock required before an update or delete, supporting optimistic concurrency through the object_version_number column held in the record type.

The package also declares RO_SERVICE_CODE_REC_TYPE, whose fields include ro_service_code_id, object_version_number, repair_line_id, service_code_id, source_type_code, source_solution_id, applicable_flag, applied_to_est_flag, applied_to_work_flag, the DFF attribute columns, and, as added under bug 4666403, service_item_id.

Tables Accessed

All persistence is directed at the single base table CSD_RO_SERVICE_CODES, accessed through its APPS synonym. Create, update, delete, and lock operations map directly to INSERT, UPDATE, DELETE, and SELECT FOR UPDATE statements against this table, and the record type mirrors its columns. Repair line and service code identifiers are stored as foreign key references rather than denormalized data.

Usage Notes

Because the package is private, it should not be called directly from customer extensions. In normal EBS operation it is invoked by the Repair Order user interface—the service code assignment regions of the repair order forms—and by the public CSD service code API that wraps it, which supplies validation and message handling. The ETRM metadata records that the package is referenced by four other packages, consistent with this layered design, and it is also reached from concurrent or batch processing that programs service code application. For the 12.1.1 and 12.2.2 releases the signature and behavior are unchanged; custom code requiring this functionality should target the corresponding public API.