APPS.OKL_TRANSACTION_PVT SQL Statements

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

Line: 41

  SELECT  contract_number
  FROM OKC_K_HEADERS_B
  WHERE id = p_ctr_id1;

Line: 95

  SELECT 'X'
  FROM   FND_LOOKUPS
  WHERE  lookup_type = 'OKL_REBOOK_REASON'
  AND    lookup_code = p_rebook_reason_code;

Line: 159

   SELECT currency_code,
          authoring_org_id
   FROM   okl_k_headers_full_v
   WHERE  id = p_chr_id;

Line: 165

   SELECT id
   FROM   okl_trx_types_tl
   WHERE  LANGUAGE = 'US'
   AND    name = DECODE(p_trx_type,'REBOOK','Rebook',
                                   'SPLIT', 'Split Contract',
                                            'Error');

Line: 201

     SELECT okl_txn_number_s.nextval
     INTO   l_id
     FROM   dual;

Line: 294

  PROCEDURE update_trx_status(
                              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_chr_id             IN  OKC_K_HEADERS_V.ID%TYPE,
                              p_status             IN  VARCHAR2,
                              x_tcnv_rec           OUT NOCOPY tcnv_rec_type
                             ) IS

  l_api_name    VARCHAR2(35)    := 'update_trx_status';

Line: 306

  l_proc_name   VARCHAR2(35)    := 'UPDATE_TRX_STATUS';

Line: 312

  SELECT trx.id, trx.representation_type --sechawla 01-oct-09 8967918 : added representation type
  FROM   okl_trx_contracts trx,
         okl_trx_types_tl try
  WHERE  trx.khr_id_new = p_chr_id_new
  AND    try.id = trx.try_id
  AND    try.language = 'US'
  AND    try.name in ('Rebook','Release')
  --rkuttiya added for 12.1.1 Multi GAAP
  --AND    representation_type = 'PRIMARY'; --sechawla 01-oct-09 8967918

Line: 368

       Okl_Trx_Contracts_Pub.update_trx_contracts(
                                               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_tcnv_rec      => l_tcnv_rec,
                                               x_tcnv_rec      => lx_tcnv_rec
                                              );

Line: 422

  END update_trx_status;

Line: 604

  SELECT start_date,
         end_date
  FROM   okc_k_headers_b
  WHERE  id = p_chr_id;

Line: 612

  SELECT 'Y'
  FROM   DUAL
  WHERE  p_trx_date BETWEEN p_start_date AND p_end_date;

Line: 625

  SELECT 'N'
  FROM   okc_k_lines_b  okc ,
	     okc_line_styles_b ols,
	     okl_trx_assets trx ,
	     okl_txl_itm_insts itm
  WHERE  okc.dnz_chr_id = p_chr_id
	AND  okc.id = itm.kle_id
	AND  okc.lse_id = ols.id
	AND  ols.lty_code =  'INST_ITEM'
	AND  trx.tsu_code = 'ENTERED'
	AND  trx.tas_type = 'ALG'
	AND  trx.id =  itm.tas_id ;

Line: 1018

      update_trx_status(
                        p_api_version    => l_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_chr_id         => l_rev_tbl(i).chr_id,
                        p_status         => p_tsu_code,
                        x_tcnv_rec       => x_tcnv_rec --record for the primary rep
                       );

Line: 1030

              OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER Trx UPDATE status: '|| x_return_status);

Line: 1061

           Okl_Trx_Contracts_Pub.update_trx_contracts(
             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_tcnv_rec      => l_prbk_tcnv_rec,
             x_tcnv_rec      => x_prbk_tcnv_rec
            );

Line: 1109

      okl_okc_migration_pvt.update_contract_header(
                        p_api_version          => l_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_restricted_update    => 'F',
                        p_chrv_rec             => l_chrv_rec,
                        x_chrv_rec             => x_chrv_rec
                       );

Line: 1120

              OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER Contract Header UPDATE status: '|| x_return_status);

Line: 1136

              OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'AFTER Contract Line UPDATE status: '|| x_return_status);

Line: 1211

  SELECT id
  FROM   okl_trx_types_tl
  WHERE  LANGUAGE = 'US'
  AND    name     = 'Service Integration';

Line: 1217

  SELECT currency_code,
         authoring_org_id
  FROM   okl_k_headers_full_v
  WHERE  id = p_chr_id;

Line: 1416

  SELECT id
  FROM   okl_trx_types_tl
  WHERE  LANGUAGE = 'US'
  AND    name     = 'Principal Paydown';

Line: 1422

  SELECT currency_code,
         authoring_org_id
  FROM   okl_k_headers_full_v
  WHERE  id = p_chr_id;