eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.MTH_SUSTAIN_ASPECT_PKG dependencies on MTH_UTIL_PKG

Line 418: --mth_util_pkg.switch_column_default_value(v_raw_tab_name, v_curr_partition);

414: v_last_tag_value NUMBER := NULL;
415:
416: BEGIN
417: -- 1. First switch the partition for the meter readings raw table
418: --mth_util_pkg.switch_column_default_value(v_raw_tab_name, v_curr_partition);
419: IF (v_curr_partition = 0) THEN
420: -- No data available in the table to be processed
421: RETURN;
422: END IF;

Line 2332: mth_util_pkg.mth_truncate_table('MTH_TAG_METER_READINGS_LATEST');

2328: **************************************************************************** */
2329: PROCEDURE truncate_entity_sustain_data
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');

Line 2333: mth_util_pkg.mth_truncate_table('MTH_METER_READINGS');

2329: PROCEDURE truncate_entity_sustain_data
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');

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');

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');

Line 2336: mth_util_pkg.mth_truncate_table('MTH_ENTITY_SUSTAIN_ASPECT');

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');
2340:

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;

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:

Line 2339: mth_util_pkg.mth_truncate_table('MTH_EQUIP_PROD_SUSTAIN_F');

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:
2343: PROCEDURE process_entity_sustain_aspect

Line 2370: mth_util_pkg.switch_column_default_value(v_raw_tab_name, v_curr_partition);

2366: v_virtual_meter_start_date :=
2367: NVL(fnd_date.canonical_to_date(p_virtual_meter_start_date_str),trunc(sysdate));
2368:
2369:
2370: mth_util_pkg.switch_column_default_value(v_raw_tab_name, v_curr_partition);
2371:
2372: IF (v_curr_partition = 1 OR v_curr_partition = 2) THEN
2373: LOAD_ACT_METER_RAW_TO_READINGS( v_curr_partition );
2374:

Line 2375: mth_util_pkg.truncate_table_partition (v_raw_tab_name, v_curr_partition);

2371:
2372: IF (v_curr_partition = 1 OR v_curr_partition = 2) THEN
2373: LOAD_ACT_METER_RAW_TO_READINGS( v_curr_partition );
2374:
2375: mth_util_pkg.truncate_table_partition (v_raw_tab_name, v_curr_partition);
2376: END IF;
2377:
2378:
2379: ADD_VRT_MTS_TO_METER_READINGS (v_virtual_meter_start_date);