APPS.OKS_RENEW_CONTRACT_PUB SQL Statements

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

Line: 329

        p_chr_id    : id of the contract whose lines need to be updated
    */
    PROCEDURE UPDATE_INVOICE_TEXT
    (
     p_api_version IN NUMBER DEFAULT 1,
     p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
     p_commit   IN VARCHAR2 DEFAULT FND_API.G_FALSE,
     x_return_status OUT NOCOPY VARCHAR2,
     x_msg_count OUT NOCOPY NUMBER,
     x_msg_data OUT NOCOPY VARCHAR2,
     p_chr_id IN NUMBER
     )
    IS
    l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INVOICE_TEXT';

Line: 354

        SAVEPOINT update_invoice_text_PUB;

Line: 363

        OKS_RENEW_CONTRACT_PVT.update_invoice_text(
            p_api_version => 1,
            p_init_msg_list => FND_API.G_FALSE,
            p_commit => FND_API.G_FALSE,
            x_return_status => x_return_status,
            x_msg_count => x_msg_count,
            x_msg_data => x_msg_data,
            p_chr_id  => p_chr_id);

Line: 390

            ROLLBACK TO update_invoice_text_PUB;

Line: 399

            ROLLBACK TO update_invoice_text_PUB;

Line: 408

            ROLLBACK TO update_invoice_text_PUB;

Line: 420

    END UPDATE_INVOICE_TEXT;