[Home] [Help]
6:
7:
8: /* ****************************************************************************
9: * Function :IS_RAW_DATA_ROW_VALID *
10: * Description :Check if the raw from MTH_TAG_METER_READINGS_RAW is *
11: * valid or not. If it violates any validation rules, *
12: * return -1; otherwise, return 1 *
13: * File Name :MTHSUSAB.PLS *
14: * Visibility :Private *
343:
344: /* ****************************************************************************
345: * Procedure :LOAD_ACT_METER_RAW_TO_READINGS *
346: * Description :Load data from tag meter raw for energy consumption *
347: * in MTH_TAG_METER_READINGS_RAW into meter readings table MTH_METER_READINGS *
348: * for actual meters *
349: **************************************************************************** */
350:
351: PROCEDURE LOAD_ACT_METER_RAW_TO_READINGS(p_curr_partition IN NUMBER)
365: END AS IS_CUMULATIVE,
366: Decode(T.ORDER_TYPE, 'ASC', 1, 0) IS_ASSENDING,
367: T.INITIAL_VALUE, T.MAX_RESET_VALUE, S.TAG_TYPE,
368: T.FREQUENCY_IN_MINUTES / 1440 as FREQUENCY
369: FROM MTH_TAG_METER_READINGS_RAW R, MTH_TAG_MASTER T,
370: MTH_TAG_DATA_SOURCES S
371: WHERE
372: R.TAG_CODE = T.TAG_CODE (+) AND
373: 'ACTIVE' = T.STATUS (+) AND
388: FROM MTH_TAG_METER_READINGS_LATEST
389: WHERE TAG_CODE = p_tag_code;
390:
391:
392: v_raw_tab_name VARCHAR2(30) := 'MTH_TAG_METER_READINGS_RAW';
393: v_curr_partition NUMBER := p_curr_partition;
394: v_prev_tag_code VARCHAR2(255) := NULL;
395: v_curr_tag_code VARCHAR2(255) := NULL;
396: v_meter_fk_key_array DBMS_SQL.NUMBER_TABLE;
2345: p_retcode out NOCOPY NUMBER,
2346: p_process_mode IN VARCHAR2 DEFAULT 'INCR',
2347: p_virtual_meter_start_date_str IN varchar2 )
2348: IS
2349: v_raw_tab_name VARCHAR2(30) := 'MTH_TAG_METER_READINGS_RAW';
2350: v_curr_partition NUMBER;
2351: v_virtual_meter_start_date date;
2352: v_process_mode VARCHAR2(200);
2353: BEGIN