The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT counter_interface_id
FROM CSI_CTR_READINGS_INTERFACE
WHERE process_status = 'P';
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 l_src_txn_from_date and l_src_txn_to_date
ORDER BY VALUE_TIMESTAMP asc, COUNTER_ID asc;
l_LAST_UPDATE_DATE_mig DTabType;
l_LAST_UPDATED_BY_mig NTabType;
l_LAST_UPDATE_LOGIN_mig NTabType;
SELECT *
FROM CSI_CTR_READ_PROP_INTERFACE
WHERE counter_interface_id = p_ctr_intf_id;
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);
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;
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 l_src_txn_from_date and l_src_txn_to_date; --Changed for Bug 13262205
DELETE FROM CSI_CTR_READINGS_INTERFACE
WHERE counter_interface_id = counter_intf_id_del(i1);
DELETE FROM CSI_CTR_READ_PROP_INTERFACE
WHERE counter_interface_id = counter_intf_id_del(i1);
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;
l_src_txn_tbl.DELETE;
,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;
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
);
,p_mode => 'UPDATE'
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
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);