APPS.OKL_CONTRACT_STATUS_PUB SQL Statements

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

Line: 111

  Procedure update_contract_status(
            p_api_version     IN  NUMBER,
            p_init_msg_list   IN  VARCHAR2 DEFAULT OKC_API.G_FALSE,
            x_return_status   OUT NOCOPY VARCHAR2,
            x_msg_count       OUT NOCOPY NUMBER,
            x_msg_data        OUT NOCOPY VARCHAR2,
            p_khr_status      IN VARCHAR2,
            p_chr_id          IN  VARCHAR2)  IS

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

Line: 144

        OKL_CONTRACT_STATUS_PVT.update_contract_status(
                                          p_api_version,
                                          p_init_msg_list,
                                          x_return_status,
                                          x_msg_count,
                                          x_msg_data,
                                          p_khr_status,
                                          p_chr_id);

Line: 184

  END update_contract_status;