APPS.MTH_SUSTAIN_ASPECT_PKG dependencies on MTH_ENTITY_SUST_EMISSIONS

Line 2046: MTH_ENTITY_SUST_EMISSIONS e

2042: e.emission_name,
2043: sum(e.emission_quantity) AS emission_quantity,
2044: e.emission_uom
2045: FROM mth_entity_sustain_aspect a, mth_hour_d h,
2046: MTH_ENTITY_SUST_EMISSIONS e
2047: WHERE a.hour_fk_key = h.hour_pk_key AND e.esa_fk_key = a.esa_pk_key
2048: GROUP BY a.plant_fk_key, a.entity_fk_key, a.entity_type,
2049: a.sustain_aspect, a.usage_category, a.meter_fk_key,
2050: a.meter_category, h.from_time, h.to_time, a.hour_fk_key,

Line 2136: * Description :Load data into the child table MTH_ENTITY_SUST_EMISSIONS *

2132:
2133:
2134: /* ****************************************************************************
2135: * Procedure :load_data_to_sustain_emissions *
2136: * Description :Load data into the child table MTH_ENTITY_SUST_EMISSIONS *
2137: * File Name :MTHSUSAB.PLS *
2138: * Visibility :Private *
2139: * Parameters :None *
2140: * Return Value :None *

Line 2153: INSERT INTO MTH_ENTITY_SUST_EMISSIONS

2149:
2150: BEGIN
2151:
2152: FOR i IN p_shift.FIRST..p_shift.LAST LOOP
2153: INSERT INTO MTH_ENTITY_SUST_EMISSIONS
2154: (esa_fk_key, emission_code, emission_name, emission_quantity,
2155: emission_uom)
2156: SELECT p_shift(i).esa_pk_key,
2157: y.emission_code,

Line 2211: 'Error occurs when inserting data into MTH_ENTITY_SUST_EMISSIONS table:'

2207: EXCEPTION
2208: WHEN OTHERS THEN
2209: ROLLBACK;
2210: raise_application_error(-20004,
2211: 'Error occurs when inserting data into MTH_ENTITY_SUST_EMISSIONS table:'
2212: || SQLCODE||' -ERROR- '||SQLERRM);
2213:
2214: END load_data_to_sustain_emissions;
2215:

Line 2304: -- Load emission data into MTH_ENTITY_SUST_EMISSIONS child table

2300: AND x.meter_fk_key = p_shift(i).meter_fk_key
2301: AND x.entity_fk_key = p_shift(i).entity_fk_key;
2302: end loop;
2303:
2304: -- Load emission data into MTH_ENTITY_SUST_EMISSIONS child table
2305: load_data_to_sustain_emissions;
2306:
2307: load_sustain_aspect_to_hour;
2308:

Line 2335: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUST_EMISSIONS');

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