APPS.OKL_AM_RECYCLE_TRMNT_PVT SQL Statements

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

Line: 29

      SELECT  id,
              khr_id,
              tmt_status_code,--akrangan changed for sla tmt_status_code cr
              tmt_recycle_yn,
              date_transaction_occurred
      FROM    OKL_TRX_CONTRACTS
      WHERE   id = p_rcy_id;

Line: 39

      SELECT  id,
              contract_number,
              sts_code
      FROM    OKL_K_HEADERS_FULL_V
      WHERE   id = p_khr_id;

Line: 230

      SELECT K.contract_number
      FROM   OKL_TRX_CONTRACTS   T,
             OKL_K_HEADERS_FULL_V  K
      WHERE  T.id     = p_tcn_id
      AND    T.khr_id = K.id;

Line: 303

      OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'calling OKL_TRX_CONTRACTS_PUB.update_trx_contracts');

Line: 306

    OKL_TRX_CONTRACTS_PUB.update_trx_contracts(
              p_api_version                  => p_api_version,
              p_init_msg_list                => OKL_API.G_FALSE,
              x_return_status                => l_return_status,
              x_msg_count                    => x_msg_count,
              x_msg_data                     => x_msg_data,
              p_tcnv_rec                     => lp_tcnv_rec,
              x_tcnv_rec                     => lx_tcnv_rec);

Line: 315

      OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,l_module_name,'called OKL_TRX_CONTRACTS_PUB.update_trx_contracts , return status: ' || l_return_status);