[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
fnd_file.put_line(fnd_file.log, 'Inserting Counter Reading...');
select CSI_COUNTER_READINGS_S.nextval
into l_ctr_rdg_rec.counter_value_id from dual;
CSI_COUNTER_READINGS_PKG.Insert_Row(
px_COUNTER_VALUE_ID => l_ctr_rdg_rec.counter_value_id
,p_COUNTER_ID => l_ctr_rdg_rec.counter_id
,p_VALUE_TIMESTAMP => l_ctr_rdg_rec.value_timestamp
,p_COUNTER_READING => l_ctr_rdg_rec.counter_reading
,p_RESET_MODE => NULL
,p_RESET_REASON => NULL
,p_ADJUSTMENT_TYPE => NULL
,p_ADJUSTMENT_READING => NULL
,p_OBJECT_VERSION_NUMBER => 1
,p_LAST_UPDATE_DATE => SYSDATE
,p_LAST_UPDATED_BY => fnd_global.user_id
,p_CREATION_DATE => SYSDATE
,p_CREATED_BY => fnd_global.user_id
,p_LAST_UPDATE_LOGIN => fnd_global.conc_login_id
,p_ATTRIBUTE1 => NULL
,p_ATTRIBUTE2 => NULL
,p_ATTRIBUTE3 => NULL
,p_ATTRIBUTE4 => NULL
,p_ATTRIBUTE5 => NULL
,p_ATTRIBUTE6 => NULL
,p_ATTRIBUTE7 => NULL
,p_ATTRIBUTE8 => NULL
,p_ATTRIBUTE9 => NULL
,p_ATTRIBUTE10 => NULL
,p_ATTRIBUTE11 => NULL
,p_ATTRIBUTE12 => NULL
,p_ATTRIBUTE13 => NULL
,p_ATTRIBUTE14 => NULL
,p_ATTRIBUTE15 => NULL
,p_ATTRIBUTE16 => NULL
,p_ATTRIBUTE17 => NULL
,p_ATTRIBUTE18 => NULL
,p_ATTRIBUTE19 => NULL
,p_ATTRIBUTE20 => NULL
,p_ATTRIBUTE21 => NULL
,p_ATTRIBUTE22 => NULL
,p_ATTRIBUTE23 => NULL
,p_ATTRIBUTE24 => NULL
,p_ATTRIBUTE25 => NULL
,p_ATTRIBUTE26 => NULL
,p_ATTRIBUTE27 => NULL
,p_ATTRIBUTE28 => NULL
,p_ATTRIBUTE29 => NULL
,p_ATTRIBUTE30 => NULL
,p_ATTRIBUTE_CATEGORY => NULL
,p_MIGRATED_FLAG => 'N'
,p_COMMENTS => NULL
,p_LIFE_TO_DATE_READING => l_ctr_rdg_rec.counter_reading
,p_TRANSACTION_ID => l_txn_rec.transaction_id
,p_AUTOMATIC_ROLLOVER_FLAG => NULL
,p_INCLUDE_TARGET_RESETS => NULL
,p_SOURCE_COUNTER_VALUE_ID => NULL
,p_NET_READING => l_ctr_rdg_rec.counter_reading
,p_DISABLED_FLAG => 'N'
,p_SOURCE_CODE => NULL
,p_SOURCE_LINE_ID => NULL
,p_INITIAL_READING_FLAG => NULL
);
CSI_COUNTER_PVT.update_ctr_val_max_seq_no(
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_counter_id => l_ctr_rdg_rec.counter_id
,px_ctr_val_max_seq_no => l_ctr_rdg_rec.counter_value_id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
);
csi_ctr_gen_utility_pvt.put_line('ERROR FROM CSI_COUNTER_PVT.update_ctr_val_max_seq_no');
SELECT counter_id,creation_date,uom_code
FROM CSI_COUNTERS_B ctr
WHERE counter_type = 'REGULAR'
AND nvl(end_date_active,(sysdate+1)) > sysdate
AND nvl(time_based_manual_entry, 'N') = 'N'
AND exists (select 'x'
from MTL_UNITS_OF_MEASURE_VL uom
where upper(uom.uom_class) = 'TIME'
and uom.uom_code = ctr.uom_code);
SELECT counter_value_id,counter_reading,value_timestamp
FROM CSI_COUNTER_READINGS
WHERE counter_id = p_counter_id
AND nvl(disabled_flag,'N') = 'N'
ORDER BY value_timestamp desc;