Search Results csd_repair_groups_pvt




Overview
Explore in AI Chat

Overview

CSD_REPAIR_GROUPS_PVT is a private PL/SQL package in the APPS schema that supports the repair group functionality within Oracle Depot Repair, part of the Enterprise Asset Management (EAM) and Service family of applications in Oracle E-Business Suite 12.1.1 and 12.2.2. Repair groups provide a mechanism to organize related repair orders into logical groupings, allowing service organizations to process multiple repairs together — for example, grouping repairs that share a common customer, asset, or service request, or bundling repairs into a single estimate-and-approval cycle. This package encapsulates the low-level database operations required to create, maintain, lock, and delete those groupings, and to apply group membership to individual repair orders.

Because it is classified as a PVT (private) API, CSD_REPAIR_GROUPS_PVT is not intended to be called directly by external or customer-developed code. Instead, it acts as a shared internal utility layer invoked by higher-level Depot Repair packages and by the Repair Groups form (CSD_REPAIRS_GRP). The package is a core dependency in the repair processing stack, referenced by several sibling packages within the CSD module.

Key Procedures and Functions

ETRM documents five entry points in this package. Each is described here at the level of purpose; parameter signatures are not published.

  • CREATE_REPAIR_GROUPS — Inserts new repair group records, establishing the group header and its association with the underlying repair order data.
  • UPDATE_REPAIR_GROUPS — Modifies attributes of an existing repair group, such as its descriptive or association information.
  • DELETE_REPAIR_GROUPS — Removes a repair group and its membership associations, reversing the creation logic.
  • LOCK_REPAIR_GROUPS — Applies concurrency control and/or a logical lock state to a repair group, preventing conflicting concurrent modifications during processing.
  • APPLY_TO_GROUP — Assigns a repair order or repair line to an existing repair group, forming the membership link that makes grouping functionally meaningful.

Tables Accessed

The package operates against four documented tables (referenced through APPS synonyms):

  • CSD_REPAIRS — The primary repair order table; group application alters or reads repair records to link them to a group.
  • CSD_REPAIR_ORDER_GROUPS — The group header table holding repair group definitions created, updated, and deleted by this package.
  • CSD_REPAIR_ORDER_GROUPS_S1 — A sequence used to generate unique group identifiers during creation.
  • JTF_RS_RESOURCE_EXTNS — The resource extension table, used to resolve resource/personnel information associated with the group, such as the owning or responsible resource.

Usage Notes

CSD_REPAIR_GROUPS_PVT is invoked indirectly. The Depot Repair Repair Groups form (backed by CSD_REPAIRS_GRP) calls it for user-driven group create, update, and delete actions. It is also referenced by CSD_GEN_UTILITY_PVT, CSD_PROCESS_PVT, and CSD_REPAIR_ESTIMATE_PVT — indicating it participates in repair generation, repair processing workflows, and estimate handling for grouped repairs. Customizations and integrations should not call this PVT package directly; instead, use the public Depot Repair APIs or the supported forms and concurrent programs. Direct calls risk bypassing validation, locking, and multi-org security logic enforced through the calling stack.