The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT maintenance_object_id into x_maintenance_object_id
FROM wip_discrete_jobs
WHERE wip_entity_id = p_wip_entity_id
AND maintenance_object_type = 3;
SELECT COUNT(1) into l_count
FROM csi_counter_associations csa,csi_counter_relationships ccr
WHERE
csa.source_object_id = x_maintenance_object_id
AND csa.counter_id = ccr.OBJECT_COUNTER_ID (+)
AND nvl(ccr.source_counter_id (+),csa.counter_id) = p_meter_id
and CCR.ACTIVE_END_DATE (+) >= sysdate ;
l_ctr_property_readings_tbl.DELETE;
l_ctr_rdg_tbl.DELETE;
l_csi_txn_tbl.DELETE;
l_ctr_property_readings_tbl.DELETE;
l_ctr_rdg_tbl.DELETE;
SELECT object_version_number
INTO l_object_version_number
FROM csi_counter_readings
WHERE counter_value_id = p_meter_reading_id;
'==================== Calling Csi_Counter_Readings_PUB.Update_Counter_Reading ===================='
||'x_return_status:'||x_return_status
||' x_msg_count:'||x_msg_count
||'x_msg_data:'||x_msg_data);
Csi_Counter_Readings_PUB.Update_Counter_Reading (p_api_version => p_api_version,
p_commit => p_commit,
p_init_msg_list => p_init_msg_list,
p_validation_level => FND_API.G_VALID_LEVEL_FULL,
p_ctr_rdg_tbl => l_ctr_rdg_tbl,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
'==================== Exiting from Csi_Counter_Readings_PUB.Update_Counter_Reading ===================='
||'x_return_status:'||x_return_status
||' x_msg_count:'||x_msg_count
||'x_msg_data:'||x_msg_data);