APPS.CSI_COUNTER_PVT dependencies on CSI_COUNTER_READINGS

Line 2017: from CSI_COUNTER_READINGS

2013: l_source_dist_ref_id2 NUMBER;
2014:
2015: CURSOR LAST_CTR_READING_CUR(p_counter_id IN NUMBER,p_reading_lock_date IN DATE) IS
2016: select value_timestamp
2017: from CSI_COUNTER_READINGS
2018: where counter_id = p_counter_id
2019: and nvl(disabled_flag,'N') = 'N'
2020: and value_timestamp <= p_reading_lock_date
2021: ORDER BY value_timestamp desc;

Line 2505: FROM csi_counter_readings

2501: WHERE source_counter_id = p_counter_id and relationship_type_code = 'CONFIGURATION';
2502: l_target_ctr_exist NUMBER;
2503: CURSOR counter_readings_cur(p_counter_id NUMBER) IS
2504: SELECT counter_value_id
2505: FROM csi_counter_readings
2506: WHERE counter_id = p_counter_id;
2507: l_rdg_exists NUMBER;
2508:
2509: -- for counter name check

Line 4179: FROM csi_counter_readings

4175: (px_ctr_val_max_seq_no <> FND_API.G_MISS_NUM) THEN
4176: BEGIN
4177: SELECT 'Y', value_timestamp
4178: INTO l_ctr_val_id_exist, l_new_value_timestamp
4179: FROM csi_counter_readings
4180: WHERE counter_id = p_counter_id
4181: AND counter_value_id = px_ctr_val_max_seq_no
4182: AND NVL(disabled_flag, 'N') = 'N';
4183: EXCEPTION

Line 4196: FROM csi_counter_readings

4192: ELSE --l_old_ctr_val_max_seq_no > 0
4193: BEGIN
4194: SELECT 'Y'
4195: INTO l_new_reading_is_latest
4196: FROM csi_counter_readings
4197: WHERE counter_id = p_counter_id
4198: AND counter_value_id = l_old_ctr_val_max_seq_no
4199: AND NVL(disabled_flag, 'N') = 'N'
4200: AND value_timestamp < l_new_value_timestamp;

Line 4217: SELECT COUNTER_VALUE_ID, VALUE_TIMESTAMP FROM CSI_COUNTER_READINGS WHERE COUNTER_ID = p_counter_id AND

4213: -- Bug 9283089
4214: SELECT COUNTER_VALUE_ID, VALUE_TIMESTAMP, 'Y', 'Y'
4215: INTO px_ctr_val_max_seq_no, l_new_value_timestamp,
4216: l_ctr_val_id_exist, l_new_reading_is_latest FROM (
4217: SELECT COUNTER_VALUE_ID, VALUE_TIMESTAMP FROM CSI_COUNTER_READINGS WHERE COUNTER_ID = p_counter_id AND
4218: NVL(DISABLED_FLAG, 'N') = 'N' ORDER BY VALUE_TIMESTAMP DESC) WHERE ROWNUM = 1;
4219:
4220:
4221: /* SELECT counter_value_id, value_timestamp, 'Y', 'Y'

Line 4224: FROM csi_counter_readings

4220:
4221: /* SELECT counter_value_id, value_timestamp, 'Y', 'Y'
4222: INTO px_ctr_val_max_seq_no, l_new_value_timestamp,
4223: l_ctr_val_id_exist, l_new_reading_is_latest
4224: FROM csi_counter_readings
4225: WHERE counter_id = p_counter_id
4226: AND value_timestamp =
4227: (SELECT MAX(value_timestamp) FROM csi_counter_readings
4228: WHERE counter_id = p_counter_id AND NVL(disabled_flag, 'N') = 'N');*/

Line 4227: (SELECT MAX(value_timestamp) FROM csi_counter_readings

4223: l_ctr_val_id_exist, l_new_reading_is_latest
4224: FROM csi_counter_readings
4225: WHERE counter_id = p_counter_id
4226: AND value_timestamp =
4227: (SELECT MAX(value_timestamp) FROM csi_counter_readings
4228: WHERE counter_id = p_counter_id AND NVL(disabled_flag, 'N') = 'N');*/
4229:
4230: EXCEPTION
4231: WHEN NO_DATA_FOUND THEN