APPS.OKL_PRCTIMEOUT_PVT SQL Statements

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

Line: 23

  SELECT ID, DATE_PROCESSED, ORP_CODE,KHR_ID
  FROM OKL_STREAM_INTERFACES
  WHERE sis_code IN (G_SIS_HDR_INSERTED, G_SIS_DATA_ENTERED, G_SIS_PROCESSING_REQUEST, G_SIS_RET_DATA_RECEIVED);

Line: 72

  	  okl_stream_interfaces_pub.update_stream_interfaces(
	      p_api_version     => l_api_version,
		  p_init_msg_list   => l_init_msg_list  ,
		  x_return_status   => l_return_status,
          x_msg_count  		=> l_msg_count,
          x_msg_data  		=> l_msg_data,
          p_sifv_rec        => lp_sifv_rec,
          x_sifv_rec        => lx_sifv_rec );

Line: 88

OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx(
     p_api_version         => l_api_version,
     p_init_msg_list       => l_init_msg_list,
     x_return_status       => l_return_status,
     x_msg_count           => l_msg_count,
     x_msg_data            => l_msg_data,
     p_khr_id              => l_okl_prctimeout_rec.khr_id,
     p_prog_short_name     => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
     p_progress_status     => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);

Line: 105

      FND_FILE.PUT_LINE(FND_FILE.LOG, 'Record Updated for ID : ' || l_okl_prctimeout_rec.id);

Line: 113

    FND_FILE.PUT_LINE(FND_FILE.LOG, 'Number of Records Updated : ' || l_RecordsProcessed);

Line: 115

    FND_FILE.PUT_LINE(FND_FILE.LOG, 'None of the Records are updated.');