APPS.MTH_SUSTAIN_ASPECT_PKG dependencies on MTH_ENTITY_SUST_HR_EMISSIONS

Line 2037: INSERT INTO MTH_ENTITY_SUST_HR_EMISSIONS

2033: IS
2034:
2035: BEGIN
2036:
2037: INSERT INTO MTH_ENTITY_SUST_HR_EMISSIONS
2038: (esa_hr_fk_key, emission_code, emission_name, emission_quantity,
2039: emission_uom)
2040: SELECT Max(esa_pk_key) AS esa_hr_fk_key,
2041: e.emission_code,

Line 2069: 'Error occurs when inserting MTH_ENTITY_SUST_HR_EMISSIONS table:'

2065: EXCEPTION
2066: WHEN OTHERS THEN
2067: ROLLBACK;
2068: raise_application_error(-20005,
2069: 'Error occurs when inserting MTH_ENTITY_SUST_HR_EMISSIONS table:'
2070: ||SQLCODE||' -ERROR- '||SQLERRM);
2071: END load_sustain_emission_to_hour;
2072:
2073:

Line 2079: DELETE FROM MTH_ENTITY_SUST_HR_EMISSIONS;

2075: IS
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,

Line 2337: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUST_HR_EMISSIONS');

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