APPS.MTH_SUSTAIN_ASPECT_PKG dependencies on MTH_ENTITY_SUSTAIN_ASPECT_HOUR

Line 2080: DELETE FROM mth_entity_sustain_aspect_hour;

2076:
2077: BEGIN
2078:
2079: DELETE FROM MTH_ENTITY_SUST_HR_EMISSIONS;
2080: DELETE FROM mth_entity_sustain_aspect_hour;
2081:
2082: INSERT INTO mth_entity_sustain_aspect_hour
2083: (esa_hr_pk_key, plant_fk_key, entity_fk_key, entity_type,
2084: sustain_aspect_fk_key,

Line 2082: INSERT INTO mth_entity_sustain_aspect_hour

2078:
2079: DELETE FROM MTH_ENTITY_SUST_HR_EMISSIONS;
2080: DELETE FROM mth_entity_sustain_aspect_hour;
2081:
2082: INSERT INTO mth_entity_sustain_aspect_hour
2083: (esa_hr_pk_key, plant_fk_key, entity_fk_key, entity_type,
2084: sustain_aspect_fk_key,
2085: sustain_aspect, usage_category, meter_fk_key, meter_category,
2086: from_time, to_time, hour_fk_key, shift_workday_fk_key,

Line 2128: 'Error occurs when inserting MTH_ENTITY_SUSTAIN_ASPECT_HOUR table:'

2124: EXCEPTION
2125: WHEN OTHERS THEN
2126: ROLLBACK;
2127: raise_application_error(-20005,
2128: 'Error occurs when inserting MTH_ENTITY_SUSTAIN_ASPECT_HOUR table:'
2129: ||SQLCODE||' -ERROR- '||SQLERRM);
2130: END load_sustain_aspect_to_hour;
2131:
2132:

Line 2338: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUSTAIN_ASPECT_HOUR');

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');
2339: mth_util_pkg.mth_truncate_table('MTH_EQUIP_PROD_SUSTAIN_F');
2340:
2341: END truncate_entity_sustain_data;
2342: