[Home] [Help]
2513: l_reading_date DATE;
2514:
2515: CURSOR c1(p_counter_id IN NUMBER) IS
2516: SELECT max(value_timestamp)
2517: FROM csi_counter_readings
2518: WHERE counter_id = p_counter_id;
2519: BEGIN
2520: -- Standard Start of API savepoint
2521: SAVEPOINT create_ctr_relationship_pvt;
4126: AND relationship_type_code = 'CONFIGURATION';
4127:
4128: CURSOR counter_readings_cur(p_counter_id NUMBER) IS
4129: SELECT counter_value_id
4130: FROM csi_counter_readings
4131: WHERE counter_id = p_counter_id;
4132:
4133:
4134: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_COUNTER_TEMPLATE';
5318: l_reading_date DATE;
5319:
5320: CURSOR c1(p_counter_id IN NUMBER) IS
5321: SELECT max(value_timestamp)
5322: FROM csi_counter_readings
5323: WHERE counter_id = p_counter_id;
5324:
5325: BEGIN
5326: -- Standard Start of API savepoint
7397: l_c_ind_prop := l_c_ind_prop + 1;
7398: END LOOP;
7399:
7400: csi_ctr_gen_utility_pvt.put_line('Calling the capture counter reading...');
7401: csi_counter_readings_pub.capture_counter_reading(
7402: p_api_version => 1.0,
7403: p_commit => p_commit,
7404: p_init_msg_list => p_init_msg_list,
7405: p_validation_level => l_validation_level,