APPS.OKL_BTCH_CASH_APPLIC SQL Statements

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

Line: 47

      SELECT irm_id,
             batch_total,
             date_gl_requested
      FROM   okl_trx_csh_batch_v a
      WHERE  a.id = cp_btc_id;

Line: 55

      SELECT authoring_org_id
      FROM   okc_k_headers_b
      WHERE  contract_number = cp_contract_num;

Line: 61

      SELECT date_gl_requested,
             a.irm_id,
             'x',
             trx_status_code
      FROM   okl_trx_csh_batch_v   a,
             okl_trx_csh_receipt_v b
      WHERE  a.id = cp_btc_id
      AND    a.id = b.btc_id
      AND    rownum = 1;

Line: 73

      SELECT check_number
      FROM   okl_trx_csh_receipt_v a
      WHERE  a.check_number = cp_check_number
      AND    a.amount = cp_amount
      AND    a.ile_id = cp_customer_id
      AND    a.date_effective = trunc(cp_receipt_date);

Line: 82

      SELECT currency_code FROM okl_k_headers_full_v WHERE id = cp_khr_id;

Line: 85

      SELECT currency_code
      FROM   okl_cnsld_ar_hdrs_b
      WHERE  id = cp_consolidated_invoice_id;

Line: 93

      SELECT invoice_currency_code
      FROM   ra_customer_trx_all
      WHERE  customer_trx_id = cp_invoice_id;

Line: 288

  PROCEDURE update_batch_lines(p_api_version   IN NUMBER,
                               p_init_msg_list IN VARCHAR2,
                               p_batch_exists  IN VARCHAR2,
                               p_batch_tbl     IN okl_btch_dtls_tbl_type,
                               x_return_status OUT NOCOPY VARCHAR2,
                               x_msg_count     OUT NOCOPY NUMBER,
                               x_msg_data      OUT NOCOPY VARCHAR2) IS
    --local variables declaration
    l_api_name    CONSTANT VARCHAR2(30) := 'update_batch_lines';

Line: 318

      SELECT date_gl_requested,
             a.irm_id
      FROM   okl_trx_csh_batch_v   a,
             okl_trx_csh_receipt_v b
      WHERE  a.id = cp_btc_id
      AND    a.id = b.btc_id
      AND    rownum = 1;

Line: 327

    SELECT id
    FROM OKL_TXL_RCPT_APPS_B
    WHERE rct_id_details = p_receipt_id;

Line: 434

                                  'Begin Debug OKLRBAPB.pls call Okl_Rct_Pub.update_internal_trans ');

Line: 441

      okl_rct_pub.update_internal_trans(l_api_version,
                                        l_init_msg_list,
                                        l_return_status,
                                        l_msg_count,
                                        l_msg_data,
                                        l_rctv_rec,
                                        l_rcav_tbl,
                                        lx_rctv_rec,
                                        lx_rcav_tbl);

Line: 491

                          p_token1_value => 'update_batch_lines',
                          p_token2       => 'SQLCODE',
                          p_token2_value => SQLCODE,
                          p_token3       => 'SQLERRM',
                          p_token3_value => SQLERRM);

Line: 498

  END update_batch_lines;

Line: 512

  PROCEDURE insert_batch_lines(p_api_version   IN NUMBER,
                               p_init_msg_list IN VARCHAR2,
                               p_batch_exists  IN VARCHAR2,
                               p_batch_tbl     IN okl_btch_dtls_tbl_type,
                               x_return_status OUT NOCOPY VARCHAR2,
                               x_msg_count     OUT NOCOPY NUMBER,
                               x_msg_data      OUT NOCOPY VARCHAR2) IS
    --local variables declaration
    l_api_name    CONSTANT VARCHAR2(30) := 'insert_batch_lines';

Line: 543

      SELECT date_gl_requested,
             a.irm_id
      FROM   okl_trx_csh_batch_v   a,
             okl_trx_csh_receipt_v b
      WHERE  a.id = cp_btc_id
      AND    a.id = b.btc_id
      AND    rownum = 1;

Line: 650

                                  'Begin Debug OKLRBAPB.pls call Okl_Rct_Pub.update_internal_trans ');

Line: 707

                          p_token1_value => 'insert_batch_lines',
                          p_token2       => 'SQLCODE',
                          p_token2_value => SQLCODE,
                          p_token3       => 'SQLERRM',
                          p_token3_value => SQLERRM);

Line: 714

  END insert_batch_lines;

Line: 738

      SELECT rct.id
      FROM   okl_trx_csh_receipt_b rct
      WHERE  rct.btc_id = cp_btc_id
      AND    rct.id = cp_receipt_id;

Line: 745

      SELECT rca.id
      FROM   okl_txl_rcpt_apps_b rca
      WHERE  rca.rct_id_details = cp_rct_id;

Line: 833

      update_batch_lines(p_api_version   => l_api_version,
                         p_init_msg_list => p_init_msg_list,
                         p_batch_exists   => p_batch_exists,
                         p_batch_tbl     => l_upd_batch_tbl,
                         x_return_status => l_return_status,
                         x_msg_count     => l_msg_count,
                         x_msg_data      => l_msg_data);

Line: 856

      insert_batch_lines(p_api_version   => l_api_version,
                         p_init_msg_list => p_init_msg_list,
                         p_batch_exists   => p_batch_exists,
                         p_batch_tbl     => l_ins_batch_tbl,
                         x_return_status => l_return_status,
                         x_msg_count     => l_msg_count,
                         x_msg_data      => l_msg_data);

Line: 977

      SELECT irm_id,
             batch_total,
             date_gl_requested
      FROM   okl_trx_csh_batch_v a
      WHERE  a.id = cp_btc_id;

Line: 987

      SELECT authoring_org_id
      FROM   okc_k_headers_b
      WHERE  contract_number = cp_contract_num;

Line: 995

      SELECT 'x'
      FROM   okl_trx_csh_batch_v   a,
             okl_trx_csh_receipt_v b
      WHERE  a.id = cp_btc_id
      AND    a.id = b.btc_id
      AND    rownum = 1;

Line: 1006

      SELECT check_number
      FROM   okl_trx_csh_receipt_v a
      WHERE  a.check_number = cp_check_number
      AND    a.amount = cp_amount
      AND    a.ile_id = cp_customer_id
      AND    a.date_effective = trunc(cp_receipt_date);

Line: 1017

      SELECT rct.id
      FROM   okl_trx_csh_receipt_b rct
      WHERE  rct.btc_id = cp_btc_id;

Line: 1027

      SELECT rca.id
      FROM   okl_txl_rcpt_apps_b rca
      WHERE  rca.rct_id_details = cp_rct_id;

Line: 1037

      SELECT currency_code FROM okl_k_headers_full_v WHERE id = cp_khr_id;

Line: 1040

      SELECT currency_code
      FROM   okl_cnsld_ar_hdrs_b
      WHERE  id = cp_consolidated_invoice_id;

Line: 1048

      SELECT invoice_currency_code
      FROM   ra_customer_trx_all
      WHERE  customer_trx_id = cp_invoice_id;