APPS.OKL_AM_CONSOLIDATED_QTE_PVT SQL Statements

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

Line: 27

      SELECT id,
             qst_code,
             qtp_code,
             qrs_code,
             khr_id,
             accepted_yn,
             consolidated_yn,
             early_termination_yn,
             partial_yn,
             consolidated_qte_id,
             date_effective_from,
             date_effective_to,
             quote_number
      FROM   OKL_TRX_QUOTES_V
      WHERE  id = p_qte_id;

Line: 251

    SELECT sysdate INTO l_sys_date FROM DUAL;

Line: 342

     SELECT   K.pdt_id,
              K.contract_number
     FROM     OKL_K_HEADERS_FULL_V     K
     WHERE    K.id = p_khr_id;

Line: 349

     SELECT   Q.recipient_id
     FROM     OKL_AM_QUOTES_UV     Q
     WHERE    Q.id = p_qte_id
     AND      Q.quote_party_role = 'RECIPIENT';

Line: 957

      SELECT SYSDATE INTO l_sys_date FROM DUAL;

Line: 1020

        OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_QUOTES_PUB.insert_trx_quotes');

Line: 1022

      OKL_TRX_QUOTES_PUB.insert_trx_quotes (
         p_api_version                   =>   p_api_version,
         p_init_msg_list                 =>   OKL_API.G_FALSE,
         x_msg_count                     =>   x_msg_count,
         x_msg_data                      =>   x_msg_data,
         x_return_status                 =>   l_return_status,
         p_qtev_rec                      =>   lp_consolidate_quote_rec,
         x_qtev_rec                      =>   lx_consolidate_quote_rec);

Line: 1031

        OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_QUOTES_PUB.insert_trx_quotes , return status: ' || l_return_status);

Line: 1054

        OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_QUOTES_PUB.update_trx_quotes');

Line: 1057

      OKL_TRX_QUOTES_PUB.update_trx_quotes (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKL_API.G_FALSE,
          x_return_status                => l_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_qtev_tbl                     => lp_quot_tbl,
          x_qtev_tbl                     => lx_quot_tbl);

Line: 1066

        OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_QUOTES_PUB.update_trx_quotes , return status: ' || l_return_status);

Line: 1151

     SELECT   accepted_yn,
              date_effective_from
     FROM     OKL_TRX_QUOTES_V
     WHERE    id = p_qte_id;

Line: 1283

     SELECT   id
     FROM     OKL_TRX_QUOTES_V
     WHERE    consolidated_qte_id = p_qte_id;

Line: 1345

     SELECT   id
     FROM     OKL_TXL_QUOTE_LINES_V
     WHERE    qte_id = p_qte_id;

Line: 1403

  PROCEDURE update_consolidate_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_cons_rec                    IN  qtev_rec_type,
           x_cons_rec                    OUT NOCOPY qtev_rec_type,
           x_qtev_tbl                    OUT NOCOPY qtev_tbl_type) IS

           -- RMUNJULU 04-FEB-03 2783130 Added cursor to get proper qtp_code
           -- get the consolidated quote details
           CURSOR get_qte_details_csr ( p_qte_id IN NUMBER) IS
                SELECT qte.qtp_code
                FROM  OKL_TRX_QUOTES_V qte
                WHERE qte.id = p_qte_id;

Line: 1421

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

Line: 1438

    l_module_name VARCHAR2(500) := G_MODULE_NAME || 'update_consolidate_quote';

Line: 1517

          p_control_flag                 => 'UPDATE',
          p_qtev_tbl                     => lp_qtev_tbl,
          x_qtev_tbl                     => li_qtev_tbl);

Line: 1593

            OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote');

Line: 1596

          OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote(
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_qtev_rec                     => li_qtev_tbl(i),
            p_tqlv_tbl                     => lp_tqlv_tbl,
            x_qtev_rec                     => lx_qtev_tbl(i),
            x_tqlv_tbl                     => lx_tqlv_tbl);

Line: 1607

            OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_REPURCHASE_ASSET_PUB.update_repurchase_quote , return status: ' || l_return_status);

Line: 1621

            OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_AM_RESTRUCTURE_QUOTE_PUB.update_restructure_quote');

Line: 1624

          OKL_AM_RESTRUCTURE_QUOTE_PUB.update_restructure_quote(
            p_api_version                  => p_api_version,
            p_init_msg_list                => OKL_API.G_FALSE,
            x_return_status                => l_return_status,
            x_msg_count                    => x_msg_count,
            x_msg_data                     => x_msg_data,
            p_quot_rec                     => li_qtev_tbl(i),
            x_quot_rec                     => lx_qtev_tbl(i));

Line: 1633

            OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_AM_RESTRUCTURE_QUOTE_PUB.update_restructure_quote , return status: ' || l_return_status);

Line: 1652

    SELECT SYSDATE INTO l_sys_date FROM DUAL;

Line: 1662

      OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_QUOTES_PUB.update_trx_quotes');

Line: 1665

    OKL_TRX_QUOTES_PUB.update_trx_quotes (
          p_api_version                  => p_api_version,
          p_init_msg_list                => OKL_API.G_FALSE,
          x_return_status                => l_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_qtev_rec                     => lp_cons_rec,
          x_qtev_rec                     => lx_cons_rec);

Line: 1674

      OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_QUOTES_PUB.update_trx_quotes , return status: ' || l_return_status);

Line: 1736

  END update_consolidate_quote;