DBA Data[Home] [Help]

APPS.CSI_TIME_BASED_CTR_ENGINE_PKG dependencies on CSI_COUNTER_READINGS

Line 40: Csi_Counter_Readings_Pvt.Create_Reading_Transaction

36: l_ctr_rdg_rec.counter_id := p_ctr_id;
37: l_ctr_rdg_rec.value_timestamp := p_capture_date;
38: l_ctr_rdg_rec.counter_reading := p_ctr_rdg;
39: --
40: Csi_Counter_Readings_Pvt.Create_Reading_Transaction
41: ( p_api_version => 1.0
42: ,p_commit => fnd_api.g_false
43: ,p_init_msg_list => fnd_api.g_true
44: ,p_validation_level => fnd_api.g_valid_level_full

Line 69: select CSI_COUNTER_READINGS_S.nextval

65: END LOOP;
66: RAISE FND_API.G_EXC_ERROR;
67: END IF;
68: fnd_file.put_line(fnd_file.log, 'Inserting Counter Reading...');
69: select CSI_COUNTER_READINGS_S.nextval
70: into l_ctr_rdg_rec.counter_value_id from dual;
71: --
72: CSI_COUNTER_READINGS_PKG.Insert_Row(
73: px_COUNTER_VALUE_ID => l_ctr_rdg_rec.counter_value_id

Line 72: CSI_COUNTER_READINGS_PKG.Insert_Row(

68: fnd_file.put_line(fnd_file.log, 'Inserting Counter Reading...');
69: select CSI_COUNTER_READINGS_S.nextval
70: into l_ctr_rdg_rec.counter_value_id from dual;
71: --
72: CSI_COUNTER_READINGS_PKG.Insert_Row(
73: px_COUNTER_VALUE_ID => l_ctr_rdg_rec.counter_value_id
74: ,p_COUNTER_ID => l_ctr_rdg_rec.counter_id
75: ,p_VALUE_TIMESTAMP => l_ctr_rdg_rec.value_timestamp
76: ,p_COUNTER_READING => l_ctr_rdg_rec.counter_reading

Line 231: FROM CSI_COUNTER_READINGS

227: and uom.uom_code = ctr.uom_code);
228: --
229: CURSOR RDG_CUR(p_counter_id IN NUMBER) IS
230: SELECT counter_value_id,counter_reading,value_timestamp
231: FROM CSI_COUNTER_READINGS
232: WHERE counter_id = p_counter_id
233: AND nvl(disabled_flag,'N') = 'N'
234: ORDER BY value_timestamp desc;
235: BEGIN