APPS.OKL_VR_DOCUMENT_PVT SQL Statements

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

Line: 35

  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: 218

     SELECT stm.id
     FROM   okl_streams stm
     WHERE  stm.khr_id = p_khr_id
     AND    nvl(stm.kle_id, -9999) = NVL(p_kle_id, -9999)
     AND    stm.say_code = 'CURR'
     AND    stm.active_yn = 'Y'
     AND    stm.sty_id = p_sty_id;

Line: 228

     SELECT stm.id
     FROM   okl_streams stm
     WHERE  stm.khr_id = p_khr_id
     AND    nvl(stm.kle_id, -9999) = NVL(p_kle_id, -9999)
     AND    stm.say_code = 'CURR'
     AND    stm.active_yn = 'N'
     AND    stm.purpose_code = 'REPORT'
     AND    stm.sty_id = p_rep_sty_id;

Line: 238

     SELECT  okl_sif_seq.nextval
     FROM    dual;

Line: 242

     SELECT SE_LINE_NUMBER
     FROM   OKL_STRM_ELEMENTS_V
     WHERE  stm_id = c_stm_id
     ORDER BY SE_LINE_NUMBER DESC;

Line: 249

     SELECT set_of_books_id
     FROM   OKL_SYS_ACCT_OPTS;

Line: 254

     SELECT id, try_id, description
     FROM   okl_trx_types_v
     WHERE  name = p_trx_name;

Line: 260

     SELECT lookup_code, meaning, description
     FROM   fnd_lookups
     WHERE  lookup_code = p_lookup_code
     AND    lookup_type = p_lookup_type;

Line: 267

SELECT CONTRACT_NUMBER
FROM OKC_K_HEADERS_B
WHERE ID = p_khr_id ;

Line: 274

SELECT ATTRIBUTE_CATEGORY,
              ATTRIBUTE1,
              ATTRIBUTE2,
              ATTRIBUTE3,
              ATTRIBUTE4,
              ATTRIBUTE5,
              ATTRIBUTE6,
              ATTRIBUTE7,
              ATTRIBUTE8,
              ATTRIBUTE9,
              ATTRIBUTE10,
              ATTRIBUTE11,
              ATTRIBUTE12,
              ATTRIBUTE13,
              ATTRIBUTE14,
              ATTRIBUTE15
FROM OKL_K_HEADERS
WHERE ID = p_khr_id ;

Line: 298

SELECT secondary_rep_method
FROM   okl_sys_acct_opts;

Line: 723

       OKL_VARIABLE_INTEREST_PVT.print_debug('Executing procedure OKL_TRX_AR_INVOICES_PUB.INSERT_TRX_AR_INVOICES');

Line: 976

  	      -- Derive and Insert Distribution Line
	      ------------------------------------------------------------

          OKL_VARIABLE_INTEREST_PVT.print_debug('      -- Creating Distributions. Supplied parameters:');

Line: 1118

          OKL_STREAMS_PUB.delete_stream_elements(
              p_api_version   => 1.0,
              p_init_msg_list => OKC_API.G_FALSE,
              x_return_status => x_return_status,
              x_msg_count     => x_msg_count,
              x_msg_data      => x_msg_data,
              p_selv_rec      => lx_selv_rec);

Line: 1127

          OKL_STREAMS_PUB.delete_streams(
              p_api_version   => 1.0,
              p_init_msg_list => OKC_API.G_FALSE,
              x_return_status => x_return_status,
              x_msg_count     => x_msg_count,
              x_msg_data      => x_msg_data,
              p_stmv_rec      => lx_stmv_rec);

Line: 1137

          OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(
              p_api_version   => 1.0,
              p_init_msg_list => OKC_API.G_FALSE,
              x_return_status => x_return_status,
              x_msg_count     => x_msg_count,
              x_msg_data      => x_msg_data,
              p_tcnv_rec      => l_trxH_out_rec);

Line: 1173

          OKL_STREAMS_PUB.delete_stream_elements(
              p_api_version   => 1.0,
              p_init_msg_list => OKC_API.G_FALSE,
              x_return_status => x_return_status,
              x_msg_count     => x_msg_count,
              x_msg_data      => x_msg_data,
              p_selv_rec      => lx_selv_rec);

Line: 1182

          OKL_STREAMS_PUB.delete_streams(
              p_api_version   => 1.0,
              p_init_msg_list => OKC_API.G_FALSE,
              x_return_status => x_return_status,
              x_msg_count     => x_msg_count,
              x_msg_data      => x_msg_data,
              p_stmv_rec      => lx_stmv_rec);

Line: 1192

          OKL_TRX_CONTRACTS_PUB.delete_trx_contracts(
              p_api_version   => 1.0,
              p_init_msg_list => OKC_API.G_FALSE,
              x_return_status => x_return_status,
              x_msg_count     => x_msg_count,
              x_msg_data      => x_msg_data,
              p_tcnv_rec      => l_trxH_out_rec);