APPS.OKL_BOOK_CONTROLLER_PVT SQL Statements

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

Line: 119

  SELECT OKL_BKG_CONTL_SEQ.NEXTVAL
  FROM DUAL;

Line: 215

  SELECT *
  FROM okl_book_controller_trx
  WHERE khr_id = p_khr_id
  AND   NVL(active_flag,'N') = 'Y';

Line: 355

    okl_bct_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_bct_tbl       => l_bct_tbl,
                 x_bct_tbl       => lx_bct_tbl);

Line: 426

PROCEDURE update_book_ctrl_trx(
     p_batch_num      IN okl_book_controller_trx.batch_number%TYPE,
     p_srl_num        IN okl_book_controller_trx.processing_srl_number%TYPE,
     p_prog_status    IN okl_book_controller_trx.progress_status%TYPE,
     p_request_id     IN okl_book_controller_trx.conc_req_id%TYPE,
     x_return_status  OUT NOCOPY VARCHAR2) IS

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

Line: 463

    FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:batch number is null in call to update okl_book_controller_trx');

Line: 471

    FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error:processing srl number is null in call to update okl_book_controller_trx');

Line: 488

  okl_bct_pvt.update_row(
                p_api_version   => l_api_version,
                p_init_msg_list => l_init_msg_list,
                x_return_status => l_return_status,
                x_msg_count     => l_msg_count,
                x_msg_data      => l_msg_data,
                p_bct_rec       => l_bct_rec,
                x_bct_rec       => x_bct_rec);

Line: 536

END update_book_ctrl_trx;

Line: 574

  SELECT sts_code
  FROM okc_k_headers_b
  WHERE id = p_khr_id;

Line: 708

  SELECT '1'
  FROM okl_book_controller_trx
  WHERE khr_id = p_khr_id
  AND progress_status = 'PENDING'
  AND prog_short_name = 'OKLBCTBK'
  AND NVL(active_flag,'N') = 'N';

Line: 880

    update_book_controller_trx(
        p_api_version     => l_api_version,
        p_init_msg_list   => l_init_msg_list,
        x_return_status   => l_return_status,
        x_msg_count       => l_msg_count,
        x_msg_data        => l_msg_data,
        p_khr_id          => p_khr_id,
        p_prog_short_name => l_program_name,
        p_conc_req_id     => NULL,
        p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);

Line: 897

    update_book_ctrl_trx(
        p_batch_num     => p_batch_number,
        p_srl_num       => p_serial_num,
        p_prog_status   => 'ERROR',
        p_request_id    => null,
        x_return_status => l_return_status);

Line: 918

    update_book_controller_trx(
        p_api_version     => l_api_version,
        p_init_msg_list   => l_init_msg_list,
        x_return_status   => l_return_status,
        x_msg_count       => l_msg_count,
        x_msg_data        => l_msg_data,
        p_khr_id          => p_khr_id,
        p_prog_short_name => l_program_name,
        p_conc_req_id     => l_request_id,
        p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_RUNNING);

Line: 935

    update_book_ctrl_trx(
        p_batch_num     => p_batch_number,
        p_srl_num       => p_serial_num,
        p_prog_status   => 'RUNNING',
        p_request_id    => l_request_id,
        x_return_status => l_return_status);

Line: 964

      update_book_controller_trx(
          p_api_version     => l_api_version,
          p_init_msg_list   => l_init_msg_list,
          x_return_status   => l_return_status,
          x_msg_count       => l_msg_count,
          x_msg_data        => l_msg_data,
          p_khr_id          => p_khr_id,
          p_prog_short_name => l_program_name,
          p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);

Line: 980

      update_book_ctrl_trx(
          p_batch_num     => p_batch_number,
          p_srl_num       => p_serial_num,
          p_prog_status   => 'ERROR',
          p_request_id    => null,
          x_return_status => l_return_status);

Line: 1000

      update_book_controller_trx(
          p_api_version     => l_api_version,
          p_init_msg_list   => l_init_msg_list,
          x_return_status   => l_return_status,
          x_msg_count       => l_msg_count,
          x_msg_data        => l_msg_data,
          p_khr_id          => p_khr_id,
          p_prog_short_name => l_program_name,
          p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE);

Line: 1016

      update_book_ctrl_trx(
         p_batch_num     => p_batch_number,
         p_srl_num       => p_serial_num,
         p_prog_status   => 'COMPLETE',
         p_request_id    => null,
         x_return_status => l_return_status);

Line: 1121

  SELECT * FROM okl_book_controller_trx
  WHERE khr_id = p_khr_id
  AND progress_status = 'PENDING'
  AND nvl(active_flag,'N') = 'N'
  ORDER BY processing_srl_number;

Line: 1129

  SELECT sts_code
  FROM okc_k_headers_b
  WHERE id = p_khr_id;

Line: 1366

      update_book_ctrl_trx(
         p_batch_num     => l_batch_number,
         p_srl_num       => each_ctrl_trx.processing_srl_number,
         p_prog_status   => 'ABANDONED',
         p_request_id    => null,
         x_return_status => l_return_status);

Line: 1510

  SELECT * FROM okl_book_controller_trx
  WHERE khr_id = p_khr_id
  AND progress_status = 'PENDING'
  AND nvl(active_flag,'N') = 'N'
  ORDER BY processing_srl_number;

Line: 1685

  SELECT NVL(qcl_id,1)
  FROM okc_k_headers_b
  WHERE id = p_khr_id;

Line: 1691

  SELECT meaning
  FROM fnd_lookups
  WHERE lookup_type = 'CP_SET_OUTCOME'
  AND lookup_code = p_sts_code;

Line: 2002

  SELECT sis_code
  FROM okl_stream_interfaces
  WHERE transaction_number = p_trx_num;

Line: 2008

  SELECT sts_code
  FROM okc_k_headers_b
  WHERE id = p_khr_id;

Line: 2014

  SELECT transaction_number, sis_code
  FROM okl_stream_interfaces
  WHERE khr_id = p_khr_id
  AND date_processed =
         (SELECT MAX(date_processed)
          FROM okl_stream_interfaces
          WHERE khr_id = p_khr_id
          AND sis_code NOT IN ('PROCESS_COMPLETE','PROCESS_COMPLETE_ERRORS',
              'PROCESSING_FAILED','TIME_OUT','PROCESS_ABORTED', 'SERVER_NA')
         );

Line: 2326

  SELECT orig_system_source_code,
         orig_system_id1
  FROM okc_k_headers_v
  WHERE id = p_khr_id;

Line: 2990

  SELECT 'Y'
  FROM   OKL_BOOK_CONTROLLER_TRX
  WHERE  khr_id = p_khr_id
  AND    NVL(active_flag,'N') = 'Y';

Line: 2997

  SELECT sts_code
  FROM okc_k_headers_b
  WHERE id = p_khr_id;

Line: 3125

      okl_bct_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_bct_tbl       => l_bct_tbl,
                   x_bct_tbl       => lx_bct_tbl);

Line: 3210

PROCEDURE update_book_controller_trx(
     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_khr_id              IN  okc_k_headers_b.id%TYPE,
     p_prog_short_name     IN  okl_book_controller_trx.prog_short_name%TYPE,
     p_conc_req_id         IN  okl_book_controller_trx.conc_req_id%TYPE DEFAULT OKL_API.G_MISS_NUM,
     p_progress_status     IN  okl_book_controller_trx.progress_status%TYPE) IS

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

Line: 3227

  SELECT *
  FROM okl_book_controller_trx
  WHERE khr_id = p_khr_id
  AND   prog_short_name = nvl(p_prog_short_name, prog_short_name)
  AND   NVL(active_flag,'N') = 'Y';

Line: 3237

      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'Begin(+)');

Line: 3283

      okl_bct_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_bct_rec       => l_bct_rec,
                    x_bct_rec       => x_bct_rec);

Line: 3304

      FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'End(-)');

Line: 3321

         FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - ERROR');

Line: 3337

         FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - UNEXCP ERROR');

Line: 3353

         FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx.', 'EXP - OTHERS');

Line: 3355

END update_book_controller_trx;

Line: 3404

  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    => 'INCOMPLETE',
                                           p_chr_id        => p_khr_id);

Line: 3444

      okl_book_controller_pvt.update_book_controller_trx(
                                           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_id          => p_khr_id,
                                           p_prog_short_name => l_prog_short_name,
                                           p_conc_req_id     => NULL,
                                           p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_PENDING);

Line: 3537

  SELECT progress_status
  FROM okl_book_controller_trx
  WHERE khr_id = p_khr_id
  AND   prog_short_name = p_prog_short_name
  AND   NVL(active_flag,'N') = 'Y';

Line: 3672

  SELECT progress_status
  FROM okl_book_controller_trx
  WHERE khr_id = p_khr_id
  AND   prog_short_name = p_prog_short_name
  AND   NVL(active_flag,'N') = 'Y';

Line: 4008

  SELECT chrb.orig_system_id1 orig_chr_id
  FROM   okc_k_headers_b chrb,
         okl_trx_contracts trx
  WHERE  chrb.id = p_khr_id
  AND    chrb.orig_system_source_code = 'OKL_REBOOK'
  AND    trx.khr_id_new = p_khr_id
  AND    trx.tcn_type = 'TRBK'
  AND    trx.tsu_code = 'ENTERED'
  AND    trx.representation_type = 'PRIMARY';

Line: 4019

  SELECT gts.pricing_engine
  FROM   okl_k_headers khr,
         okl_products pdt,
         okl_ae_tmpt_sets aes,
         okl_st_gen_tmpt_sets gts
  WHERE  khr.pdt_id = pdt.id
  AND    pdt.aes_id = aes.id
  AND    aes.gts_id = gts.id
  AND    khr.id     = p_khr_id;

Line: 4030

  SELECT amort_inc_adj_rev_dt_yn
  FROM okl_sys_acct_opts;

Line: 4034

  SELECT 'Y' chr_upgraded_yn
  FROM okl_stream_trx_data
  WHERE orig_khr_id = p_khr_id
  AND last_trx_state = 'Y';

Line: 4111

  SELECT 'Y' upg_req_exists_yn
  FROM okl_stream_interfaces
  WHERE khr_id = p_khr_id
  AND orp_code = 'UPGRADE'
  AND sis_code IN ('PROCESSING_REQUEST','PROCESS_COMPLETE_ERRORS','PROCESS_COMPLETE','RET_DATA_RECEIVED');

Line: 4118

  SELECT chrb_orig.id orig_chr_id,
         chrb_orig.contract_number
  FROM   okc_k_headers_b chrb_rbk,
         okc_k_headers_b chrb_orig,
         okl_trx_contracts trx
  WHERE  chrb_rbk.id = p_khr_id
  AND    chrb_rbk.orig_system_source_code = 'OKL_REBOOK'
  AND    chrb_orig.id = chrb_rbk.orig_system_id1
  AND    trx.khr_id = chrb_orig.id
  AND    trx.khr_id_new = p_khr_id
  AND    trx.tcn_type = 'TRBK'
  AND    trx.tsu_code = 'ENTERED'
  AND    trx.representation_type = 'PRIMARY';

Line: 4184

      OKL_LLA_UTIL_PVT.update_external_id(p_chr_id => l_chr_rec.orig_chr_id,
                                          x_return_status => x_return_status);