APPS.MTH_SUSTAIN_ASPECT_PKG dependencies on MTH_METER_READINGS_ERR

Line 132: INSERT INTO MTH_METER_READINGS_ERR

128: IS
129: v_reprocess_ready_yn VARCHAR2(1) := 'N';
130: v_meter_reading_err_pk_key NUMBER;
131: BEGIN
132: INSERT INTO MTH_METER_READINGS_ERR
133: (METER_READINGS_ERR_PK_KEY, TO_TIME, USAGE_VALUE, TAG_CODE,
134: REPROCESS_READY_YN, ERR_CODE)
135: VALUES (MTH_METER_READINGS_ERR_S.NEXTVAL, P_READING_TIME,
136: P_TAG_VALUE, P_TAG_CODE, v_reprocess_ready_yn, P_ERROR_CODE);

Line 135: VALUES (MTH_METER_READINGS_ERR_S.NEXTVAL, P_READING_TIME,

131: BEGIN
132: INSERT INTO MTH_METER_READINGS_ERR
133: (METER_READINGS_ERR_PK_KEY, TO_TIME, USAGE_VALUE, TAG_CODE,
134: REPROCESS_READY_YN, ERR_CODE)
135: VALUES (MTH_METER_READINGS_ERR_S.NEXTVAL, P_READING_TIME,
136: P_TAG_VALUE, P_TAG_CODE, v_reprocess_ready_yn, P_ERROR_CODE);
137:
138: EXCEPTION
139: WHEN others THEN

Line 486: INSERT INTO MTH_METER_READINGS_ERR

482:
483: -- 2.3 Insert data into either meter readings or error table
484: IF (v_err_code IS NOT NULL OR Length(v_err_code) > 0) THEN
485: -- 2.3.1 Insert the error row to error table if there is any error
486: INSERT INTO MTH_METER_READINGS_ERR
487: (METER_READINGS_ERR_PK_KEY, TO_TIME, USAGE_VALUE, TAG_CODE,
488: REPROCESS_READY_YN, ERR_CODE)
489: VALUES (MTH_METER_READINGS_ERR_S.NEXTVAL, r_raw_data.READING_TIME,
490: r_raw_data.TAG_VALUE, r_raw_data.TAG_CODE,

Line 489: VALUES (MTH_METER_READINGS_ERR_S.NEXTVAL, r_raw_data.READING_TIME,

485: -- 2.3.1 Insert the error row to error table if there is any error
486: INSERT INTO MTH_METER_READINGS_ERR
487: (METER_READINGS_ERR_PK_KEY, TO_TIME, USAGE_VALUE, TAG_CODE,
488: REPROCESS_READY_YN, ERR_CODE)
489: VALUES (MTH_METER_READINGS_ERR_S.NEXTVAL, r_raw_data.READING_TIME,
490: r_raw_data.TAG_VALUE, r_raw_data.TAG_CODE,
491: v_reprocess_ready_yn, v_err_code);
492: v_num_insert_update := v_num_insert_update + 1;
493: ELSE

Line 1840: INSERT INTO mth_meter_readings_err

1836:
1837: EXCEPTION
1838: WHEN No_Data_Found THEN
1839: IF SQL%NOTFOUND THEN
1840: INSERT INTO mth_meter_readings_err
1841: (meter_readings_err_pk_key, meter_code, from_time, to_time, usage_value, tag_code, reprocess_ready_yn,
1842: err_code, creation_date, last_update_date)
1843: VALUES (MTH_METER_READINGS_ERR_S.NEXTVAL, reading_rec.meter_code, reading_rec.from_time, reading_rec.to_time,
1844: reading_rec.usage_value, NULL, 'N', 'HRNA', SYSDATE, SYSDATE);

Line 1843: VALUES (MTH_METER_READINGS_ERR_S.NEXTVAL, reading_rec.meter_code, reading_rec.from_time, reading_rec.to_time,

1839: IF SQL%NOTFOUND THEN
1840: INSERT INTO mth_meter_readings_err
1841: (meter_readings_err_pk_key, meter_code, from_time, to_time, usage_value, tag_code, reprocess_ready_yn,
1842: err_code, creation_date, last_update_date)
1843: VALUES (MTH_METER_READINGS_ERR_S.NEXTVAL, reading_rec.meter_code, reading_rec.from_time, reading_rec.to_time,
1844: reading_rec.usage_value, NULL, 'N', 'HRNA', SYSDATE, SYSDATE);
1845: END IF;
1846: EXIT;
1847: WHEN OTHERS THEN

Line 2334: mth_util_pkg.mth_truncate_table('MTH_METER_READINGS_ERR');

2330: IS
2331: BEGIN
2332: mth_util_pkg.mth_truncate_table('MTH_TAG_METER_READINGS_LATEST');
2333: mth_util_pkg.mth_truncate_table('MTH_METER_READINGS');
2334: mth_util_pkg.mth_truncate_table('MTH_METER_READINGS_ERR');
2335: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUST_EMISSIONS');
2336: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUSTAIN_ASPECT');
2337: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUST_HR_EMISSIONS');
2338: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUSTAIN_ASPECT_HOUR');