APPS.OKL_AM_REPURCHASE_ASSET_PVT SQL Statements

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

Line: 55

         SELECT accepted_yn,
                quote_number,
                date_effective_from,
                date_effective_to,
                khr_id,
                qtp_code
           FROM okl_trx_quotes_v qtev
          WHERE qtev.ID = p_id;

Line: 140

         SELECT SYSDATE
           FROM DUAL;

Line: 646

         SELECT chr_id
           FROM okc_k_lines_b
          WHERE ID = p_kle_id;

Line: 652

         SELECT quote_number
           FROM okl_trx_quotes_b
          WHERE art_id = p_art_id;

Line: 662

         SELECT oar.ID ID,
                kle.NAME asset_number,
                oar.repurchase_agmt_yn repurchase_agmt_yn,
                oar.legal_entity_id legal_entity_id
           FROM okl_asset_returns_all_b oar, okl_k_lines_full_v kle
          WHERE oar.ID = p_art_id AND oar.kle_id = kle.ID;

Line: 673

         SELECT k.contract_number
           FROM okl_k_headers_full_v k
          WHERE k.ID = p_khr_id;

Line: 679

         SELECT accepted_yn
           FROM okl_trx_quotes_b
          WHERE ID = p_qte_id;

Line: 685

         SELECT sts_code
           FROM okc_k_lines_b
          WHERE ID = p_kle_id;

Line: 699

      l_control_flag_update   VARCHAR2 (200)           := 'REPUR_QUOTE_UPDATE';

Line: 915

      IF p_call_flag = 'UPDATE' THEN
         OPEN l_acpt_csr (p_qtev_rec.ID);

Line: 1108

         OR (p_call_flag = 'UPDATE' AND db_accepted_yn <> 'Y') THEN
         i := p_tqlv_tbl.FIRST;

Line: 1597

                               'before OKL_TRX_QUOTES_PUB.insert_trx_quotes '
                              );

Line: 1606

      okl_trx_quotes_pub.insert_trx_quotes
            (p_api_version        => p_api_version,
             p_init_msg_list      => p_init_msg_list,
             x_msg_count          => x_msg_count,
             x_msg_data           => x_msg_data,
             p_qtev_rec           => lp_qtev_rec,
                                       --lx_qtev_rec, --code added by akrangan
             x_qtev_rec           => lx_qtev_rec,
             x_return_status      => l_return_status
            );

Line: 1621

                                'after OKL_TRX_QUOTES_PUB.insert_trx_quotes '
                               );

Line: 1681

      ELSE                                     -- No assets selected for quote
         okc_api.set_message (p_app_name          => 'OKC',
                              p_msg_name          => g_required_value,
                              p_token1            => g_col_name_token,
                              p_token1_value      => 'p_tqlv_tbl'
                             );

Line: 1782

   PROCEDURE update_repurchase_quote (
      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_qtev_rec        IN              qtev_rec_type,
      p_tqlv_tbl        IN              tqlv_tbl_type,
      x_qtev_rec        OUT NOCOPY      qtev_rec_type,
      x_tqlv_tbl        OUT NOCOPY      tqlv_tbl_type
   ) AS
      l_db_date                  DATE;

Line: 1809

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

Line: 1820

                                := g_module_name || 'update_repurchase_quote';

Line: 2287

                               'before  OKL_TRX_QUOTES_PUB.update_trx_quotes'
                              );

Line: 2296

      okl_trx_quotes_pub.update_trx_quotes
                                          (p_api_version        => p_api_version,
                                           p_init_msg_list      => p_init_msg_list,
                                           x_return_status      => l_return_status,
                                           x_msg_count          => x_msg_count,
                                           x_msg_data           => x_msg_data,
                                           p_qtev_rec           => lp_qtev_rec,
                                           x_qtev_rec           => lx_qtev_rec
                                          );

Line: 2310

                                'after  OKL_TRX_QUOTES_PUB.update_trx_quotes'
                               );

Line: 2345

                      'before OKL_TXL_QUOTE_LINES_PUB.update_txl_quote_lines'
                     );

Line: 2354

         okl_txl_quote_lines_pub.update_txl_quote_lines
                  (p_api_version        => p_api_version,
                   p_init_msg_list      => p_init_msg_list,
                   x_return_status      => l_return_status,
                   x_msg_count          => x_msg_count,
                   x_msg_data           => x_msg_data,
                   p_tqlv_tbl           => llp_tqlv_tbl,
                                              --rmunjulu Sales_Tax_Enhancement
                   x_tqlv_tbl           => lx_tqlv_tbl
                  );

Line: 2369

                      'after  OKL_TXL_QUOTE_LINES_PUB.update_txl_quote_lines'
                     );

Line: 2388

                                'after  OKL_TRX_QUOTES_PUB.update_trx_quotes'
                               );

Line: 2531

   END update_repurchase_quote;