APPS.OKL_VP_AGRMNT_APPROVAL_PVT SQL Statements

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

Line: 20

    SELECT sts_code
          ,contract_number
      FROM okc_k_headers_b
     WHERE id = cp_chr_id;

Line: 70

      okl_contract_status_pub.update_contract_status(p_api_version   => p_api_version
                                                    ,p_init_msg_list => p_init_msg_list
                                                    ,x_return_status => x_return_status
                                                    ,x_msg_count     => x_msg_count
                                                    ,x_msg_data      => x_msg_data
                                                    ,p_khr_status    => G_ACTIVE_STS_CODE
                                                    ,p_chr_id        => p_chr_id
                                                     );

Line: 82

                                'okl_contract_status_pub.update_contract_status G_ACTIVE_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
                                );

Line: 96

      okl_contract_status_pub.update_contract_status(p_api_version   => p_api_version
                                                    ,p_init_msg_list => p_init_msg_list
                                                    ,x_return_status => x_return_status
                                                    ,x_msg_count     => x_msg_count
                                                    ,x_msg_data      => x_msg_data
                                                    ,p_khr_status    => G_PENDING_STS_CODE
                                                    ,p_chr_id        => p_chr_id
                                                     );

Line: 108

                                'okl_contract_status_pub.update_contract_status G_PENDING_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
                                );

Line: 180

    SELECT sts_code
          ,contract_number
      FROM okc_k_headers_b
     WHERE id = cp_chr_id;

Line: 230

      okl_contract_status_pub.update_contract_status(p_api_version   => p_api_version
                                                    ,p_init_msg_list => p_init_msg_list
                                                    ,x_return_status => x_return_status
                                                    ,x_msg_count     => x_msg_count
                                                    ,x_msg_data      => x_msg_data
                                                    ,p_khr_status    => G_ACTIVE_STS_CODE
                                                    ,p_chr_id        => p_chr_id
                                                     );

Line: 242

                                'okl_contract_status_pub.update_contract_status returned with status '||x_return_status||' x_msg_data '||x_msg_data
                                );

Line: 256

      okl_contract_status_pub.update_contract_status(p_api_version   => p_api_version
                                                    ,p_init_msg_list => p_init_msg_list
                                                    ,x_return_status => x_return_status
                                                    ,x_msg_count     => x_msg_count
                                                    ,x_msg_data      => x_msg_data
                                                    ,p_khr_status    => G_PENDING_STS_CODE
                                                    ,p_chr_id        => p_chr_id
                                                     );

Line: 268

                                'okl_contract_status_pub.update_contract_status G_PENDING_STS_CODE returned with status '||x_return_status||' x_msg_data '||x_msg_data
                                );