APPS.OKL_ESG_TRANSPORT_PVT SQL Statements

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

Line: 19

    SELECT p.party_id, tp.tp_header_id, tp.party_site_id, tp.party_type
      FROM ecx_tp_headers tp
         , hz_parties p
     WHERE tp.party_id = p.party_id
       AND p.party_name = 'SuperTrump';

Line: 26

    SELECT t.ext_subtype, t.protocol_address, t.username, t.password,
           t.protocol_type   -- added bug8209104
      FROM ecx_tp_details_v t
         , okl_stream_interfaces si
     WHERE t.transaction_type = 'OKL_ST'
       AND t.transaction_subtype = si.deal_type
       AND si.transaction_number = b_transaction_number;

Line: 134

    select a.transaction_state
      from okl_stream_trx_data a,
           okl_stream_interfaces b
     where a.orig_khr_id = p_contract_id
       and a.last_trx_state = 'Y'
       and a.transaction_number = b.transaction_number
       and nvl(b.purpose_code, 'PRIMARY') = p_purpose_code;

Line: 143

  select gts.deal_type
        ,gts.interest_calc_meth_code
    from okl_sys_acct_opts_all sao
        ,okl_stream_interfaces osi
        ,okc_k_headers_all_b   chr
        ,okl_k_headers         khr
        ,okl_products          pdt
        ,okl_ae_tmpt_sets_all  aes
        ,okl_st_gen_tmpt_sets_all gts
    Where sao.org_id = chr.authoring_org_id
      and chr.id = osi.khr_id
      and osi.transaction_number = p_trx_number
      and chr.id     = khr.id
      and khr.pdt_id = pdt.id
      and pdt.aes_id     = aes.id
      and aes.gts_id     = gts.id;

Line: 160

    select khr_id, nvl(purpose_code, 'PRIMARY') purpose_code
      from okl_stream_interfaces
     where transaction_number = p_trx_num;

Line: 165

    select orig_khr_id, out_xml
      from okl_stream_trx_data
     where transaction_number = p_trx_id
       for update;

Line: 214

          update okl_stream_trx_data
             set out_xml = l_outbound_xml || ''||trans_clob||''|| l_tag_end_xml
           where transaction_number = p_trx_num;

Line: 237

    SELECT rbk_chr.orig_system_id1    original_chr_id
      FROM okc_k_headers_all_b rbk_chr,
           okl_trx_contracts_all trx
     WHERE trx.khr_id_new = rbk_chr.id
       AND trx.tsu_code = 'ENTERED'
       AND trx.tcn_type = 'TRBK'
       AND rbk_chr.id = p_khr_id
       AND rbk_chr.orig_system_source_code = 'OKL_REBOOK'
    UNION
    SELECT orig_chr.id                original_chr_id
      FROM okc_k_headers_all_b orig_chr,
           okl_trx_contracts_all trx
     WHERE  orig_chr.id    =  p_khr_id
      AND  trx.khr_id     =  orig_chr.id
      AND  trx.tsu_code   = 'ENTERED'
      AND  trx.tcn_type   = 'TRBK'
      AND  EXISTS
           (
            SELECT '1'
              FROM okl_rbk_selected_contract rbk_chr
             WHERE rbk_chr.khr_id = orig_chr.id
               AND rbk_chr.status <> 'PROCESSED'
            );

Line: 262

   select NVL(purpose_code, 'PRIMARY') purpose_code
     from okl_stream_interfaces
    where transaction_number = p_transaction_number;

Line: 267

   select a.transaction_number
     from okl_stream_trx_data a, okl_stream_interfaces b
    where a.orig_khr_id = p_khr_id
	  and a.last_trx_state = 'Y'
	  and a.transaction_number = b.transaction_number
	  and NVL(b.purpose_code, 'PRIMARY') = p_purpose_code;

Line: 282

	select khr_id
	  into l_contract_id
	  from okl_stream_interfaces
     where transaction_number = p_transaction_number;

Line: 305

    INSERT INTO OKL_STREAM_TRX_DATA
    (id,
	 transaction_number,
	 out_xml,
	 khr_id,
	 orig_khr_id,
	 last_trx_state,
	 trx_reference)
    VALUES
    (p_transaction_number
    ,p_transaction_number
    ,p_xml
	,l_contract_id
	,l_orig_contract_id
	,NULL
	,l_trx_reference
    );