[Home] [Help]
3536:
3537: /* ****************************************************************************
3538: * Procedure :MTH_LOAD_TAG_RAW_TO_PROCESSED *
3539: * Description :Load data from the table MTH_TAG_READINGS_RAW *
3540: * into meter readings table MTH_TAG_READINGS_RAW_PROCESSED *
3541: * File Name :MTHUTILB.PLS *
3542: * Visibility :Private *
3543: * Parameters :p_curr_partition (value of the partition column *
3544: * :p_from_tz (value for from time zone ) *
3678: r_raw_data.MAX_RESET_VALUE,
3679: v_prev_tag_value);
3680:
3681: -- 2.3.3 Insert the data into the mth_tag_readings_processed table
3682: INSERT INTO MTH_TAG_READINGS_RAW_PROCESSED (GROUP_ID, READING_TIME , TAG_CODE, TAG_DATA, CREATION_DATE, USER_ATTR1, USER_ATTR2, USER_ATTR3, USER_ATTR4, USER_ATTR5, USER_MEASURE1, USER_MEASURE2, USER_MEASURE3, USER_MEASURE4,
3683: USER_MEASURE5, QUALITY_FLAG) VALUES ( r_raw_data.GROUP_ID, r_raw_data.READING_TIME, r_raw_data.TAG_CODE, v_incr_tag_value, r_raw_data.CREATION_DATE, r_raw_data.USER_ATTR1, r_raw_data.USER_ATTR2, r_raw_data.USER_ATTR3,
3684: r_raw_data.USER_ATTR4, r_raw_data.USER_ATTR5, r_raw_data.USER_MEASURE1, r_raw_data.USER_MEASURE2, r_raw_data.USER_MEASURE3, r_raw_data.USER_MEASURE4, r_raw_data.USER_MEASURE5, r_raw_data.QUALITY_FLAG);
3685:
3686: END IF;