APPS.OKL_VP_CHANGE_REQUEST_PVT SQL Statements

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

Line: 18

  G_NO_ROWS_SELECTED CONSTANT fnd_new_messages.message_name%TYPE DEFAULT 'OKL_LLA_NO_ROW_SELECTED';

Line: 39

    SELECT okl_vp_change_req_num_seq.NEXTVAL
      FROM dual;

Line: 92

    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_ABANDONED_STS_CODE
                                                  ,p_chr_id        => lx_new_agr_id -- this is the id of the backup copy agmnt
                                                   );

Line: 137

    okl_vrr_pvt.insert_row(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_vrrv_rec      => lv_vrrv_rec
                          ,x_vrrv_rec      => x_vrrv_rec
                          );

Line: 154

    okl_khr_pvt.update_row(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_khrv_rec      => lv_khrv_rec
                          ,x_khrv_rec      => x_khrv_rec);

Line: 209

    okl_vcr_pvt.insert_row(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_vcrv_rec      => p_vcrv_rec
                          ,x_vcrv_rec      => x_vcrv_rec
                           );

Line: 221

                              'okl_vcr_pvt.insert_row returned with status '||x_return_status||' x_msg_data '||x_msg_data||' id '||x_vcrv_rec.id
                              );

Line: 265

  PROCEDURE update_change_request_header(p_api_version   IN  NUMBER
                                        ,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_vcrv_rec      IN  vcrv_rec_type
                                        ,x_vcrv_rec      OUT NOCOPY vcrv_rec_type
                                         ) IS

    CURSOR c_get_chr_id (cp_change_request_id okl_vp_change_requests.id%TYPE)IS
    SELECT chr_id
      FROM okl_vp_change_requests
     WHERE id = cp_change_request_id;

Line: 283

    l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPDATE_CHANGE_REQUEST_HDR';

Line: 284

    l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.UPDATE_CHANGE_REQUEST_HEADER';

Line: 293

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call update_change_request_header');

Line: 319

    okl_vcr_pvt.update_row(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_vcrv_rec      => lv_vcrv_rec
                          ,x_vcrv_rec      => x_vcrv_rec
                           );

Line: 331

                              'okl_vcr_pvt.update_row returned with status '||x_return_status||' x_msg_data '||x_msg_data||' id '||x_vcrv_rec.id
                              );

Line: 344

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call update_change_request_header');

Line: 373

  END update_change_request_header;

Line: 415

    okl_vrr_pvt.insert_row(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_vrrv_tbl      => p_vrrv_tbl
                          ,x_vrrv_tbl      => x_vrrv_tbl
                           );

Line: 427

                              'okl_vrr_pvt.insert_row returned with status '||x_return_status||' x_msg_data '||x_msg_data
                              );

Line: 490

  PROCEDURE update_change_request_lines(p_api_version   IN  NUMBER
                                       ,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_vrrv_tbl      IN  vrrv_tbl_type
                                       ,x_vrrv_tbl      OUT NOCOPY vrrv_tbl_type
                                       ,x_request_status OUT NOCOPY okl_vp_change_requests.status_code%TYPE
                                        ) IS
    lv_crs_id okl_vp_change_requests.id%TYPE;

Line: 501

    l_api_name CONSTANT VARCHAR2(30) DEFAULT 'UPDATE_CHANGE_REQUEST_LNS';

Line: 502

    l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.UPDATE_CHANGE_REQUEST_LINES';

Line: 511

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call update_change_request_lines');

Line: 530

    okl_vrr_pvt.update_row(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_vrrv_tbl      => p_vrrv_tbl
                          ,x_vrrv_tbl      => x_vrrv_tbl
                           );

Line: 542

                              'okl_vrr_pvt.update_row returned with status '||x_return_status||' x_msg_data '||x_msg_data
                              );

Line: 574

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call update_change_request_lines');

Line: 603

  END update_change_request_lines;

Line: 605

  PROCEDURE delete_change_request_lines(p_api_version   IN  NUMBER
                                       ,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_vrrv_tbl      IN  vrrv_tbl_type
                                       ,x_request_status OUT NOCOPY okl_vp_change_requests.status_code%TYPE
                                        ) IS
    CURSOR c_get_more_reasons_csr(cp_creq_id okl_vp_change_requests.id%TYPE)IS
    SELECT 'X'
      FROM okl_vp_cr_reasons
     WHERE crs_id = cp_creq_id;

Line: 620

    l_api_name CONSTANT VARCHAR2(30) DEFAULT 'DELETE_CHANGE_REQUEST_LNS';

Line: 621

    l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_VP_CHANGE_REQUEST_PVT.DELETE_CHANGE_REQUEST_LINES';

Line: 630

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVCRB.pls call delete_change_request_lines');

Line: 649

      okl_vrr_pvt.delete_row(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_vrrv_tbl      => p_vrrv_tbl
                             );

Line: 660

                                'okl_vrr_pvt.delete_row returned with status '||x_return_status||' x_msg_data '||x_msg_data
                                );

Line: 695

      OKL_API.set_message(G_APP_NAME, G_NO_ROWS_SELECTED);

Line: 701

      okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVCRB.pls call delete_change_request_lines');

Line: 730

  END delete_change_request_lines;

Line: 760

    SELECT 'X'
      FROM okl_vp_change_requests creq
     WHERE creq.chr_id = cp_agreement_id
       AND creq.status_code IN ('NEW','INCOMPELTE','REJECTED','PENDING_APPROVAL','PASSED');

Line: 767

    SELECT contract_number, sts_code
      FROM okc_k_headers_b
     WHERE id = cp_agreement_id;

Line: 774

    SELECT 'X'
      FROM okl_vp_change_requests crq
     WHERE crq.chr_id = cp_agreement_id
--       AND crq.change_type_code <> 'ASSOCIATION'
       AND crq.status_code = G_COMPLETED_STS_CODE;

Line: 959

      okl_khr_pvt.update_row(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_khrv_rec      => lv_khrv_rec
                            ,x_khrv_rec      => x_khrv_rec);

Line: 1182

    SELECT status_code
          ,change_request_number
          ,change_type_code
          ,chr_id -- this chr_id is for only ASSOCIATION type of change request
      FROM okl_vp_change_requests
     WHERE id = cp_change_req_id;

Line: 1193

    SELECT chr.id
      FROM okc_k_headers_b chr
          ,okl_k_headers khr
     WHERE chr.id = khr.id
       AND khr.crs_id = cp_change_req_id;

Line: 1279

      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    => p_status_code
                                                    ,p_chr_id        => lv_creq_chr_id -- this is the id of the backup copy agmnt
                                                     );

Line: 1291

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

Line: 1309

    update_change_request_header(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_vcrv_rec      => lv_vcrv_rec
                                ,x_vcrv_rec      => x_vcrv_rec
                                 );

Line: 1321

                              'update_change_request_header returned with status '||x_return_status||' x_msg_data '||x_msg_data||' id '||x_vcrv_rec.id
                              );

Line: 1375

    SELECT status_code
      FROM okl_vp_change_requests
     WHERE id = cp_change_req_id;

Line: 1493

    SELECT id
      FROM okl_vp_change_requests
     WHERE chr_id = cp_chr_id
       AND status_code = G_PASSED_STS_CODE;

Line: 1500

    SELECT khr.crs_id
      FROM okl_k_headers khr
          ,okc_k_headers_b chr
     WHERE chr.id = khr.id
       AND chr.sts_code = G_PASSED_STS_CODE
       AND chr.id = cp_chr_id;

Line: 1676

    SELECT chr_id
          ,change_type_code
          ,status_code
      FROM okl_vp_change_requests
     WHERE id = cp_ch_req_id;

Line: 1684

    SELECT contract_number
      FROM okc_k_headers_b chr
          ,okl_k_headers khr
     WHERE chr.id = khr.id
       AND khr.crs_id = cp_ch_req_id;

Line: 1691

    SELECT contract_number
      FROM okc_k_headers_b
     WHERE id = cp_chr_id;

Line: 1731

    SELECT chr_id
          ,change_type_code
          ,status_code
      FROM okl_vp_change_requests
     WHERE id = cp_ch_req_id;

Line: 1739

    SELECT chr.id
      FROM okc_k_headers_b chr
          ,okl_k_headers khr
     WHERE chr.id = khr.id
       AND khr.crs_id = cp_ch_req_id;