APPS.OKL_LOAN_BAL_UPDATE_PVT SQL Statements

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

Line: 29

    l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_LOAN_BAL_UPDATE_PVT.GET_LOAN_AMOUNTS';

Line: 56

      SELECT
             KHR.ID
       FROM
             OKC_K_HEADERS_B CHR
           , OKL_K_HEADERS KHR
           , OKL_PRODUCT_PARAMETERS_V PPM
           , OKC_STATUSES_V STS
       WHERE chr.id = khr.id
       AND   khr.pdt_id = ppm.id
       AND   chr.sts_code = sts.code
       AND   (sts.code = 'BOOKED'    OR sts.ste_code = 'TERMINATED')
       AND   (ppm.deal_type = 'LOAN' OR ppm.deal_type = 'LOAN-REVOLVING')
       AND   CHR.CONTRACT_NUMBER = p_contract_number;*/

Line: 72

      SELECT assets.id     asset_id
          , assets.name   asset_number
      FROM okc_k_lines_v     assets
          , okc_line_styles_b lse
          ,okc_statuses_v sts
      WHERE assets.dnz_chr_id   = cp_khr_id
      AND lse.id              = assets.lse_id
      AND lse.lty_code        = 'FREE_FORM1'
      AND assets.sts_code = sts.code
      AND sts.ste_code in ('ACTIVE', 'TERMINATED');

Line: 85

      SELECT  id
            , object_version_number
      FROM  okl_contract_balances
      WHERE  khr_id = p_chr_id
      AND kle_id IS NULL ;

Line: 93

      SELECT  id
            , object_version_number
      FROM  okl_contract_balances
      WHERE khr_id = p_chr_id
      AND kle_id = p_kle_id;

Line: 316

      OKL_CONTRACT_BALANCES_PVT.update_contract_balance(
                         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_cblv_tbl         => l_upd_cblv_tbl
                       , x_cblv_tbl         => lx_upd_cblv_tbl);

Line: 325

          FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Unable to update balances for Contract Number: '|| p_khr_rec.contract_number);

Line: 327

          FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Unable to update balances for Contract Number: '|| p_khr_rec.contract_number);

Line: 329

      FND_FILE.PUT_LINE (FND_FILE.OUTPUT,'Successfully updated balances for Contract Number: '|| p_khr_rec.contract_number);

Line: 369

    CURSOR c_khr_csr(cp_contract_number IN VARCHAR2) IS SELECT chr.id khr_id,
        chr.contract_number,
        sts.code status,
        ppm.deal_type,
        ppm.interest_calculation_basis ,
        ppm.revenue_recognition_method
    FROM okc_k_headers_b chr
       , okl_k_headers khr
       , okl_product_parameters_v ppm
       , okc_statuses_v sts
    WHERE chr.contract_number = NVL(cp_contract_number, chr.contract_number)
    AND   chr.id = khr.id
    AND   khr.pdt_id = ppm.id
    AND   chr.sts_code = sts.code
    AND   (sts.code = 'BOOKED'     OR sts.ste_code = 'TERMINATED')
    AND   (ppm.deal_type = 'LOAN' OR ppm.deal_type = 'LOAN-REVOLVING')
    AND   (NOT(ppm.interest_calculation_basis = 'FIXED' AND ppm.revenue_recognition_method = 'STREAMS'))
    ORDER BY chr.contract_number;

Line: 394

    FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Loan Balances Update for Variable Interest');

Line: 398

    FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Success or Error Detailed Messages Each Update');

Line: 430

    FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'OKL Loan Balances Update for Variable Interest Completed Successfully');