APPS.CSI_CTR_INTERFACE_PUB SQL Statements

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

Line: 26

   SELECT counter_interface_id
   FROM CSI_CTR_READINGS_INTERFACE
   WHERE process_status = 'P';

Line: 35

   SELECT
	  COUNTER_INTERFACE_ID
	 ,BATCH_NAME
	 ,SOURCE_TRANSACTION_DATE
	 ,PROCESS_STATUS
	 ,ERROR_TEXT
	 ,COUNTER_VALUE_ID
	 ,COUNTER_ID
	 ,NVL(VALUE_TIMESTAMP,SYSDATE) VALUE_TIMESTAMP
	 ,COUNTER_READING
	 ,RESET_MODE
	 ,RESET_REASON
	 ,ADJUSTMENT_TYPE
	 ,ADJUSTMENT_READING
	 ,LAST_UPDATE_DATE
	 ,LAST_UPDATED_BY
	 ,CREATION_DATE
	 ,CREATED_BY
	 ,LAST_UPDATE_LOGIN
	 ,ATTRIBUTE1
	 ,ATTRIBUTE2
	 ,ATTRIBUTE3
	 ,ATTRIBUTE4
	 ,ATTRIBUTE5
	 ,ATTRIBUTE6
	 ,ATTRIBUTE7
	 ,ATTRIBUTE8
	 ,ATTRIBUTE9
	 ,ATTRIBUTE10
	 ,ATTRIBUTE11
	 ,ATTRIBUTE12
	 ,ATTRIBUTE13
	 ,ATTRIBUTE14
	 ,ATTRIBUTE15
	 ,ATTRIBUTE16
	 ,ATTRIBUTE17
	 ,ATTRIBUTE18
	 ,ATTRIBUTE19
	 ,ATTRIBUTE20
	 ,ATTRIBUTE21
	 ,ATTRIBUTE22
	 ,ATTRIBUTE23
	 ,ATTRIBUTE24
	 ,ATTRIBUTE25
	 ,ATTRIBUTE26
	 ,ATTRIBUTE27
	 ,ATTRIBUTE28
	 ,ATTRIBUTE29
	 ,ATTRIBUTE30
	 ,ATTRIBUTE_CATEGORY
	 ,COMMENTS
	 ,SOURCE_TRANSACTION_TYPE_ID
	 ,SOURCE_TRANSACTION_ID
	 ,SOURCE_CODE
	 ,SOURCE_LINE_ID
	 ,AUTOMATIC_ROLLOVER_FLAG
	 ,INCLUDE_TARGET_RESETS
	 ,RESET_COUNTER_READING
         ,OBJECT_VERSION_NUMBER
         ,DISABLED_FLAG
         ,COUNTER_NAME
   FROM   CSI_CTR_READINGS_INTERFACE
   WHERE batch_name = p_batch_name
   AND   process_Status = 'R'
   AND   source_transaction_date between p_src_txn_from_date and p_src_txn_to_date
   ORDER BY VALUE_TIMESTAMP asc, COUNTER_ID asc;

Line: 126

   l_LAST_UPDATE_DATE_mig             DTabType;

Line: 127

   l_LAST_UPDATED_BY_mig              NTabType;

Line: 130

   l_LAST_UPDATE_LOGIN_mig            NTabType;

Line: 201

   SELECT *
   FROM CSI_CTR_READ_PROP_INTERFACE
   WHERE counter_interface_id = p_ctr_intf_id;

Line: 206

   select ccp.counter_property_id,ccp.default_value
   from CSI_COUNTER_PROPERTIES_B ccp
   where ccp.counter_id = p_counter_id
   and    ((ccp.default_value is not null) or
           (ccp.default_value is null and ccp.is_nullable = 'N'))
   and   nvl(end_date_active,(sysdate+1)) > sysdate
   and   not exists (select 'x' from CSI_CTR_PROPERTY_READINGS cpr
                     Where cpr.counter_value_id = p_value_id
                     and   cpr.counter_property_id = ccp.counter_property_id);

Line: 217

   select counter_value_id,counter_reading,net_reading,value_timestamp,adjustment_reading
         ,reset_mode,adjustment_type,include_target_resets
   from CSI_COUNTER_READINGS
   where counter_id = p_counter_id
   and   nvl(disabled_flag,'N') = 'N'
   and   value_timestamp > p_value_timestamp
   ORDER BY value_timestamp asc, counter_value_id asc;

Line: 234

   IF NVL(p_reprocess_option,'SELECTED') = 'ALL' THEN
      UPDATE CSI_CTR_READINGS_INTERFACE cri
      SET process_status = 'R'
      WHERE cri.batch_name = p_batch_name
      AND   cri.process_Status = 'E'
      AND   cri.source_transaction_date between p_src_txn_from_date and p_src_txn_to_date;

Line: 251

         DELETE FROM CSI_CTR_READINGS_INTERFACE
         WHERE counter_interface_id = counter_intf_id_del(i1);

Line: 255

         DELETE FROM CSI_CTR_READ_PROP_INTERFACE
         WHERE counter_interface_id = counter_intf_id_del(i1);

Line: 265

   UPDATE CSI_CTR_READINGS_INTERFACE cri
   SET cri.counter_id = (select ccv.counter_id from CSI_COUNTERS_VL ccv
                         where ccv.name = cri.counter_name)
   WHERE cri.counter_id IS NULL
   AND   cri.counter_name IS NOT NULL;

Line: 273

   l_src_txn_tbl.DELETE;

Line: 292

     ,l_LAST_UPDATE_DATE_mig
     ,l_LAST_UPDATED_BY_mig
     ,l_CREATION_DATE_mig
     ,l_CREATED_BY_mig
     ,l_LAST_UPDATE_LOGIN_mig
     ,l_ATTRIBUTE1_mig
     ,l_ATTRIBUTE2_mig
     ,l_ATTRIBUTE3_mig
     ,l_ATTRIBUTE4_mig
     ,l_ATTRIBUTE5_mig
     ,l_ATTRIBUTE6_mig
     ,l_ATTRIBUTE7_mig
     ,l_ATTRIBUTE8_mig
     ,l_ATTRIBUTE9_mig
     ,l_ATTRIBUTE10_mig
     ,l_ATTRIBUTE11_mig
     ,l_ATTRIBUTE12_mig
     ,l_ATTRIBUTE13_mig
     ,l_ATTRIBUTE14_mig
     ,l_ATTRIBUTE15_mig
     ,l_ATTRIBUTE16_mig
     ,l_ATTRIBUTE17_mig
     ,l_ATTRIBUTE18_mig
     ,l_ATTRIBUTE19_mig
     ,l_ATTRIBUTE20_mig
     ,l_ATTRIBUTE21_mig
     ,l_ATTRIBUTE22_mig
     ,l_ATTRIBUTE23_mig
     ,l_ATTRIBUTE24_mig
     ,l_ATTRIBUTE25_mig
     ,l_ATTRIBUTE26_mig
     ,l_ATTRIBUTE27_mig
     ,l_ATTRIBUTE28_mig
     ,l_ATTRIBUTE29_mig
     ,l_ATTRIBUTE30_mig
     ,l_ATTRIBUTE_CATEGORY_mig
     ,l_COMMENTS_mig
     ,l_SRC_TRANSACTION_TYPE_ID_mig
     ,l_SRC_TRANSACTION_ID_mig
     ,l_SOURCE_CODE_mig
     ,l_SOURCE_LINE_ID_mig
     ,l_AUTOMATIC_ROLLOVER_FLAG_mig
     ,l_INCLUDE_TARGET_RESETS_mig
     ,l_RESET_COUNTER_READING_mig
     ,l_OBJECT_VERSION_NUMBER_mig
     ,l_DISABLED_FLAG_mig
     ,l_COUNTER_NAME_mig
      LIMIT MAX_OI_BUFFER_SIZE;

Line: 405

	       Csi_Counter_Readings_Pvt.Update_Counter_Reading
		  (
		    p_api_version           => 1.0
		   ,p_commit                => fnd_api.g_false
		   ,p_init_msg_list         => fnd_api.g_true
		   ,p_validation_level      => fnd_api.g_valid_level_full
		   ,p_ctr_rdg_rec           => l_ctr_rdg_rec
		   ,x_return_status         => x_return_status
		   ,x_msg_count             => x_msg_count
		   ,x_msg_data              => x_msg_data
		  );

Line: 668

			 ,p_mode                  => 'UPDATE'
			 ,x_return_status         => x_return_status
			 ,x_msg_count             => x_msg_count
			 ,x_msg_data              => x_msg_data
		       );

Line: 738

         UPDATE CSI_CTR_READINGS_INTERFACE
         SET process_status = l_PROCESS_STATUS_mig(j),
             counter_value_id = l_COUNTER_VALUE_ID_mig(j),
             error_text = l_ERROR_TEXT_mig(j)
         WHERE counter_interface_id = l_counter_interface_id_mig(j);