APPS.OKL_MULTIGAAP_ENGINE_PVT SQL Statements

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

Line: 38

  SELECT a.start_date, a.contract_number, b.pdt_id
  FROM   okc_k_headers_b a, okl_k_headers b
  WHERE  a.id = b.id
  AND    a.id = cp_khr_id;

Line: 121

  SELECT 'Y'
  FROM OKL_SYS_ACCT_OPTS
  WHERE secondary_rep_method IN ('AUTOMATED');

Line: 150

  SELECT NVL(KHR.MULTI_GAAP_YN,'N')
  FROM OKL_K_HEADERS KHR
  WHERE ID = p_khr_id;

Line: 191

  select representation_code
  from okl_representations_v
  where representation_type = G_SECONDARY;

Line: 210

    select nvl(typ.FORMULA_YN,'N')
    from okl_trx_contracts khr,
         okl_trx_types_b typ
    where  khr.try_id=typ.id
    and khr.id = p_id;

Line: 236

  select trx_type_class
  from okl_trx_contracts khr,
       okl_trx_types_b typ
  where  khr.try_id=typ.id
  and khr.id = p_id;

Line: 295

    select representation_code,representation_name
    from okl_representations_v
    where representation_type = G_SECONDARY;

Line: 477

  SELECT name
  FROM okl_products
  WHERE id = l_pdt_id ;

Line: 482

  SELECT name
  FROM okl_trx_types_tl
  WHERE id = l_trx_type_id ;

Line: 487

  SELECT name
  FROM okl_strm_type_tl
  WHERE id = l_sty_type_id ;

Line: 492

  select distinct lns.kle_id
  from okl_trx_contracts khr,
       OKL_TXL_CNTRCT_LNS lns
  where khr.id = l_id
  and khr.id = lns.tcn_id;

Line: 524

     SELECT  currency_code,
             currency_conversion_rate,
             currency_conversion_type,
             currency_conversion_date
     FROM    okl_k_headers_full_v
     WHERE   id = l_pri_trx_tclv_rec.khr_id ;

Line: 540

  SELECT start_date
  FROM   okl_k_headers_full_v
  WHERE id = p_khr_id;

Line: 548

  SELECT PRIMARY_STY_ID
  FROM   OKL_STRM_TMPT_LINES_UV STL
  WHERE STL.PRIMARY_YN = 'Y'
  AND STL.PDT_ID = p_pdt_id
  AND    (STL.START_DATE <= p_contract_start_date)
  AND    (STL.END_DATE >= p_contract_start_date OR STL.END_DATE IS NULL)
  AND	 PRIMARY_STY_PURPOSE =   p_strm_purpose;

Line: 692

    IF(l_formula_yn) THEN        -- get the amount from acc engine and update the secondary trx hdr and lines

   IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
        OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to is_formula_based TRUE');

Line: 906

          l_amount_tbl.delete;

Line: 927

        OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines');

Line: 930

         OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines
                        (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_tclv_tbl        => x_sec_trx_tclv_tbl,
                         x_tclv_tbl        => l_sec_trx_tclv_tbl);

Line: 940

          OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines :'||x_return_status);

Line: 954

        OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts');

Line: 957

         OKL_TRX_CONTRACTS_PUB.update_trx_contracts(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_tcnv_rec      => x_sec_trx_tcnv_tbl(1),
                                              x_tcnv_rec      => x_sec_trx_tcnv_tbl(1));

Line: 967

          OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts :'||x_return_status);

Line: 1037

          OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to OKL_TRX_CONTRACTS_PUB.update_trx_cntrct_lines :'||x_return_status);

Line: 1123

        OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to OKL_TRX_CONTRACTS_PUB.update_trx_contracts');

Line: 1128

         OKL_TRX_CONTRACTS_PUB.update_trx_contracts(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_tcnv_rec      => x_sec_trx_tcnv_tbl(1),
                                              x_tcnv_rec      => x_sec_trx_tcnv_tbl(1));

Line: 1138

          OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to  OKL_TRX_CONTRACTS_PUB.update_trx_contracts :'||x_return_status);

Line: 1216

  SELECT id, date_transaction_occurred, transaction_date
  FROM OKL_TRX_CONTRACTS trx
  WHERE trx.primary_rep_trx_id = p_id
  AND trx.tsu_code = 'PROCESSED'
  AND trx.representation_type = G_SECONDARY;

Line: 1224

  SELECT txl.id, txl.amount, txl.currency_code
  FROM OKL_TXL_CNTRCT_LNS txl,
       OKL_TRX_CONTRACTS trx
  WHERE txl.tcn_id = trx.id
  AND txl.tcn_id = p_tcn_id
  AND trx.tsu_code = 'PROCESSED'
  AND trx.representation_type = G_SECONDARY;

Line: 1315

        OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Prior to the call to Okl_Trx_Contracts_Pub.update_trx_contracts');

Line: 1318

       Okl_Trx_Contracts_Pub.update_trx_contracts
                         (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_tcnv_tbl => l_tcnv_tbl,
                          x_tcnv_tbl => x_tcnv_tbl);

Line: 1328

          OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After the call to  Okl_Trx_Contracts_Pub.update_trx_contracts :'||l_return_status);