Search Results raise_ro_status_bevent

Overview

CSD_REPAIRS_PVT is the private PL/SQL API package within the Oracle Depot Repair module of Oracle E-Business Suite. It encapsulates the core business logic for creating, updating, and deleting repair orders, as well as managing the status transitions that govern the repair order lifecycle. The package is declared with AUTHID CURRENT_USER and is explicitly documented as restricted to Oracle Depot Repair internal development use, meaning it is not a public API and should not be called directly by customer extensions or third-party integrations. It serves as the programmatic foundation upon which the public Depot Repair APIs and the associated Oracle Forms user interface are built.

The package header (source version 120.7.12010000.2) carries a history dating to 1999, with the update_ro_status procedure added in version 11.16 (May 2005) specifically for Release 12 development. This procedure, which is the subject of the user's search, is the primary entry point for changing the status of a repair order or repair line and for triggering the associated workflow and business events.

Key Procedures and Functions

The documented interface comprises sixteen procedures and functions:

• CREATE_REPAIR_ORDER, UPDATE_REPAIR_ORDER, DELETE_REPAIR_ORDER — the principal DML procedures for the repair order entity itself, providing the transactional core used by the Depot Repair forms.
• UPDATE_RO_STATUS — updates the repair order line status, enforcing flow status transition rules. This is the procedure the user searched for and the central status-change routine in the package.
• UPDATE_RO_STATUS_WEBSRVC — a variant of the status update exposed for web service invocation, allowing external or service-oriented callers to drive status changes.
• UPDATE_RO_STATUS_WF — the workflow-facing counterpart that performs the status update in the context of a workflow process.
• UPDATE_FLOW_STATUS — manages the underlying flow status value on the repair line.
• IS_RT_UPDATE_ALLOWED and IS_FLWSTS_UPDATE_ALLOWED — validation functions that determine whether a repair type change or a flow status change is permissible for the given repair line.
• UPDATE_REPAIR_TYPE — changes the repair type assigned to a repair line, subject to the preceding validation logic.
• LAUNCH_FLWSTS_WF — initiates the workflow associated with a flow status transition, using the FLWSTS_WF_REC_TYPE record structure defined in the package header.
• RAISE_RO_STATUS_BEVENT — raises the Repair Order Status business event, using the RO_STATUS_BEVENT_REC_TYPE record structure.
• LAUNCH_WFEXCEPTION_BEVENT — raises the workflow exception business event.
• VALIDATE_REPAIRS — performs validation on repair order data prior to persistence.
• COPY_ATTACHMENTS and DELETE_ATTACHMENTS — manage attachments associated with repair orders.

Tables Accessed

The package reads and writes a broad set of Depot Repair and shared tables through APPS synonyms. Core repair data resides in CSD_REPAIRS, with related transaction tables CSD_FLWSTS_TRANS_B, CSD_FLWSTS_TRAN_MILES, CSD_FLWSTS_TRAN_RESPS, CSD_RT_TRANS_B, and CSD_RT_TRAN_RESPS capturing flow status and repair type transitions. Reference data is read from CSD_FLOW_STATUSES_B and CSD_REPAIR_TYPES_B. Organizational grouping is handled via CSD_REPAIR_ORDER_GROUPS. Several sequences support key generation, including CSD_REPAIRS_S1, CSD_REPAIRS_S2, CSD_RO_STATUS_BEVENT_KEY_S1, CSD_WF_ITEM_KEY_S, and CSD_WF_EXCEPTIONS_BEVENT_S1. CSI_INSTALL_PARAMETERS supplies installation-level configuration, and CSD_WF_EXCEPTIONS_BEVENT_S1 supports workflow exception event handling.

Usage Notes

Because the package is classified as a private API (PVT) and is documented as internal to Oracle Depot Repair development, it is not intended for direct invocation from customer-written code. It is invoked predominantly by the Depot Repair Oracle Forms, by the Depot Repair public API layer, and by workflow processes. The presence of UPDATE_RO_STATUS_WF and the LAUNCH_FLWSTS_WF procedure indicates tight integration with Oracle Workflow, where status transitions are propagated through workflow item types such as the FLWSTS_WF_REC_TYPE structure. The RAISE_RO_STATUS_BEVENT procedure and the associated CSD_RO_STATUS_BEVENT_KEY_S1 sequence support the business event system, allowing subscribers to react to repair order status changes. The UPDATE_RO_STATUS_WEBSRVC entry point exists to support service-oriented invocation. The package is referenced by seventeen other packages within the E-Business Suite, confirming its role as a foundational component of the Depot Repair transaction stack. Customizations requiring repair order status changes should be directed at the supported public APIs rather than this private package.