APPS.CSD_REPAIRS_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 198

    PROCEDURE Update_Repair_Order(P_Api_Version_Number IN NUMBER,
                                  P_Init_Msg_List      IN VARCHAR2 := FND_API.G_FALSE,
                                  P_Commit             IN VARCHAR2 := FND_API.G_FALSE,
                                  p_validation_level   IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
                                  p_REPAIR_LINE_ID     IN NUMBER,
                                  P_REPLN_Rec          IN OUT NOCOPY CSD_REPAIRS_PUB.REPLN_Rec_Type,
                                  X_Return_Status      OUT NOCOPY VARCHAR2,
                                  X_Msg_Count          OUT NOCOPY NUMBER,
                                  X_Msg_Data           OUT NOCOPY VARCHAR2) IS
        --
        l_api_name           CONSTANT VARCHAR2(30) := 'Update_Repair_Order';

Line: 214

        SAVEPOINT UPDATE_REPAIR_ORDER_PUB;

Line: 233

        CSD_repairs_PVT.Update_Repair_Order(P_Api_Version_Number => 1.0,
                                            P_Init_Msg_List      => p_init_msg_list,
                                            P_Commit             => p_commit,
                                            P_Validation_Level   => p_validation_level,
                                            p_REPAIR_LINE_ID     => p_repair_line_id,
                                            P_REPLN_Rec          => p_REPLN_Rec,
                                            X_Return_Status      => x_return_status,
                                            X_Msg_Count          => x_msg_count,
                                            X_Msg_Data           => x_msg_data);

Line: 246

            ROLLBACK TO UPDATE_REPAIR_ORDER_PUB;

Line: 291

    End Update_Repair_Order;

Line: 295

    * Update Repair Order Status
    * @param P_Api_Version api version number
    * @param P_Commit to decide whether to commit the transaction or not, default to false
    * @param P_Init_Msg_List initial the message stack, default to false
    * @param X_Return_Status return status
    * @param X_Msg_Count return message count
    * @param X_Msg_Data return message data
    * @param P_Repair_status_rec repair status attributes record.
    * @param P_status_upd_control_rec repair status record control flags.
    * @param X_OBJECT_VERSION_NUMBER
    * @rep:scope public
    * @rep:lifecycle active
    * @rep:displayname Update Repair Order Status
    */
    PROCEDURE Update_Ro_Status(P_Api_Version            IN NUMBER,
                               P_Commit                 IN VARCHAR2,
                               P_Init_Msg_List          IN VARCHAR2,
                               X_Return_Status          OUT NOCOPY VARCHAR2,
                               X_Msg_Count              OUT NOCOPY NUMBER,
                               X_Msg_Data               OUT NOCOPY VARCHAR2,
                               P_REPAIR_STATUS_Rec      IN REPAIR_STATUS_REC_TYPE,
                               P_STATUS_UPD_CONTROL_REC IN STATUS_UPD_CONTROL_REC_TYPE,
                               X_OBJECT_VERSION_NUMBER  OUT NOCOPY NUMBER) IS
        --
        l_api_name           CONSTANT VARCHAR2(30) := 'Update_Ro_Status';

Line: 325

        SAVEPOINT UPDATE_RO_STATUS_PUB;

Line: 344

        CSD_REPAIRS_PVT.UPDATE_RO_STATUS(P_Api_Version           => p_api_version,
                                         P_Commit                => p_commit,
                                         P_Init_Msg_List         => p_init_msg_list,
                                         P_Validation_Level      => FND_API.G_VALID_LEVEL_FULL,
                                         X_Return_Status         => x_return_status,
                                         X_Msg_Count             => x_msg_count,
                                         X_Msg_Data              => x_msg_data,
                                         P_REPAIR_STATUS_REC     => p_repair_status_rec,
                                         P_STATUS_CONTROL_REC    => p_status_upd_control_rec,
                                         X_OBJECT_VERSION_NUMBER => x_object_Version_number);

Line: 358

            ROLLBACK TO UPDATE_RO_STATUS_PUB;

Line: 376

            ROLLBACK TO UPDATE_RO_STATUS_PUB;

Line: 382

                               'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
                               'EXC_ERROR[' || x_msg_data || ']');

Line: 388

            ROLLBACK TO UPDATE_RO_STATUS_PUB;

Line: 394

                               'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
                               'EXC_UNEXP_ERROR[' || x_msg_data || ']');

Line: 399

            Rollback TO UPDATE_RO_STATUS_PUB;

Line: 409

                               'csd.plsql.CSD_REPAIRS_PUB.Update_ro_status',
                               'SQL MEssage[' || SQLERRM || ']');

Line: 413

    End Update_ro_status;