132: FUNCTION get_current_counter_val(
133: p_counter_id IN NUMBER)
134: RETURN NUMBER
135: IS
136: l_counter_value CSI_COUNTER_READINGS.counter_reading%TYPE ;
137: CURSOR cv_cur
138: IS
139: select net_reading counter_reading
140: from csi_counter_readings
136: l_counter_value CSI_COUNTER_READINGS.counter_reading%TYPE ;
137: CURSOR cv_cur
138: IS
139: select net_reading counter_reading
140: from csi_counter_readings
141: where counter_id = p_counter_id
142: and nvl(disabled_flag,'N') = 'N'
143: order by value_timestamp desc;
144: /*SELECT cv.counter_reading
517: RETURN VARCHAR2
518: IS
519: CURSOR counter_cur IS
520: select net_reading counter_reading
521: from csi_counter_readings
522: where counter_id = p_counter_id
523: and nvl(disabled_flag,'N') = 'N'
524: order by value_timestamp desc;
525: /*SELECT c.counter_id counter_id,
571: -- This function evaluates the counter condition line and returns
572: -- a string of 'T = F/T' to be evaluated by condition lines procedure
573: FUNCTION evaluate_counter_condition (
574: p_cnl_id IN okc_condition_lines_b.id%TYPE
575: ,p_previous_counter_value IN csi_counter_readings.counter_reading%TYPE
576: ,p_current_counter_value IN csi_counter_readings.counter_reading%TYPE
577: )
578: RETURN VARCHAR2
579: IS
572: -- a string of 'T = F/T' to be evaluated by condition lines procedure
573: FUNCTION evaluate_counter_condition (
574: p_cnl_id IN okc_condition_lines_b.id%TYPE
575: ,p_previous_counter_value IN csi_counter_readings.counter_reading%TYPE
576: ,p_current_counter_value IN csi_counter_readings.counter_reading%TYPE
577: )
578: RETURN VARCHAR2
579: IS
580: CURSOR cnl_cur