APPS.CSD_REPAIR_ESTIMATE_PUB SQL Statements

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

Line: 147

    /* procedure name: update_estimate_header           */
    /* description   : procedure used to update         */
    /*                 repair estimate header           */
    /*                                                  */
    /*--------------------------------------------------*/
    /*#
    * Updates a given estimate header record.
    * @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_estimate_hdr_rec estimate header record
    * @param X_object_version_number Object version number of the updated estimate header record.
    * @rep:scope public
    * @rep:lifecycle active
    * @rep:displayname Update Estimate Header
    */
    PROCEDURE UPDATE_ESTIMATE_HEADER(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_estimate_hdr_rec      IN Csd_Repair_Estimate_Pub.ESTIMATE_HDR_REC,
                                     x_object_version_number OUT NOCOPY NUMBER) IS
        l_api_name    CONSTANT VARCHAR2(30) := 'UPDATE_ESTIMATE_HEADER';

Line: 179

        SAVEPOINT UPDATE_ESTIMATE_HEADER_PUB;

Line: 198

        Csd_Repair_Estimate_Pvt.Update_estimate_header(p_api_version           => 1.0,
                                                             p_init_msg_list         => p_init_msg_list,
                                                             p_commit                => Fnd_Api.G_FALSE,
                                                             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_estimate_hdr_rec      => p_estimate_hdr_rec,
                                                             x_object_version_number => x_object_version_number);

Line: 212

            ROLLBACK TO UPDATE_ESTIMATE_HEADER_PUB;

Line: 230

            ROLLBACK TO UPDATE_ESTIMATE_HEADER_PUB;

Line: 237

                               'csd.plsql.csd_repair_estimate_pub.update_estimate_header',
                               'EXC_ERROR[' || x_msg_data || ']');

Line: 242

            ROLLBACK TO UPDATE_ESTIMATE_HEADER_PUB;

Line: 249

                               'csd.plsql.csd_repair_estimate_pub.update_estimate_header',
                               'EXC_UNEXP_ERROR[' || x_msg_data || ']');

Line: 254

            ROLLBACK TO UPDATE_ESTIMATE_HEADER_PUB;

Line: 267

                               'csd.plsql.csd_repair_estimate_pub.update_estimate_header',
                               'SQL MEssage[' || SQLERRM || ']');

Line: 270

    END update_estimate_header;

Line: 401

    /* procedure name: update_estimate_line             */
    /* description   : procedure used to update         */
    /*                 repair estimate lines            */
    /*                                                  */
    /*--------------------------------------------------*/
    /*#
    * Updates a given estimate Line record.
    * @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_estimate_line_rec estimate line record
    * @param X_object_version_number Object version number of the updated estimate line record.
    * @rep:scope public
    * @rep:lifecycle active
    * @rep:displayname Update Estimate Line
    */
    PROCEDURE UPDATE_ESTIMATE_LINE(p_api_version           IN NUMBER,
                                   p_init_msg_list         IN VARCHAR2,
                                   p_commit                IN VARCHAR2,
                                   x_return_status         OUT NOCOPY VARCHAR2,
                                   x_msg_count             OUT NOCOPY NUMBER,
                                   x_msg_data              OUT NOCOPY VARCHAR2,
                                   p_estimate_line_rec     IN Csd_Repair_Estimate_Pub.ESTIMATE_LINE_REC,
                                   x_object_version_number OUT NOCOPY NUMBER)

     IS

        l_api_name    CONSTANT VARCHAR2(30) := 'UPDATE_ESTIMATE_LINE';

Line: 436

        SAVEPOINT UPDATE_ESTIMATE_LINE_PUB;

Line: 455

        Csd_Repair_Estimate_Pvt.Update_estimate_Line(P_Api_Version           => 1.0,
                                                           P_Init_Msg_List         => p_init_msg_list,
                                                           P_Commit                => Fnd_Api.G_FALSE,
                                                           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_estimate_line_rec     => p_estimate_line_rec,
                                                           x_object_version_number => x_object_version_number);

Line: 468

            ROLLBACK TO UPDATE_ESTIMATE_LINE_PUB;

Line: 486

            ROLLBACK TO UPDATE_ESTIMATE_LINE_PUB;

Line: 493

                               'csd.plsql.csd_repair_estimate_pub.update_estimate_line',
                               'EXC_ERROR[' || x_msg_data || ']');

Line: 498

            ROLLBACK TO UPDATE_ESTIMATE_LINE_PUB;

Line: 505

                               'csd.plsql.csd_repair_estimate_pub.update_estimate_line',
                               'EXC_UNEXP_ERROR[' || x_msg_data || ']');

Line: 510

            ROLLBACK TO UPDATE_ESTIMATE_LINE_PUB;

Line: 523

                               'csd.plsql.csd_repair_estimate_pub.update_estimate_line',
                               'SQL MEssage[' || SQLERRM || ']');

Line: 526

    END update_estimate_line;