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_LOAD_TAG_READINGS_PKG dependencies on MTH_EVENT_PKG

Line 1712: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'DOWN',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Equipment is Down');

1708: exit when c_readings%NOTFOUND ;
1709: IF (r_readings.PREV_STATUS IS NULL) THEN
1710: v_previous_tag_reading_data := MTH_UTIL_PKG.get_prev_tag_reading(r_readings.TAG_CODE,r_readings.READING_TIME);
1711: IF (v_previous_tag_reading_data <>'3' OR v_previous_tag_reading_data IS NULL) THEN
1712: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'DOWN',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Equipment is Down');
1713: END IF;
1714: ELSE
1715: IF (r_readings.PREV_STATUS <> '3') THEN
1716: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'DOWN',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Equipment is Down');

Line 1716: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'DOWN',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Equipment is Down');

1712: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'DOWN',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Equipment is Down');
1713: END IF;
1714: ELSE
1715: IF (r_readings.PREV_STATUS <> '3') THEN
1716: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'DOWN',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Equipment is Down');
1717: END IF;
1718: END IF;
1719: end loop;
1720: close c_readings ;

Line 1793: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'OUT_CTL',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),CASE WHEN TO_NUMBER( r_readings.TAG_DATA ) > v_upper_limit THEN

1789: MTH_UTIL_PKG.get_prev_tag_reading_info(r_readings.TAG_CODE,r_readings.READING_TIME,NULL,v_previous_tag_data,v_pre_reading_time,v_pre_eqp_avail);
1790:
1791: IF((TO_NUMBER(r_readings.TAG_DATA) < v_lower_limit AND (TO_NUMBER(v_previous_tag_data) >= v_lower_limit OR v_previous_tag_data IS NULL))
1792: OR (TO_NUMBER(r_readings.TAG_DATA) > v_upper_limit AND ( v_previous_tag_data <= v_upper_limit OR v_previous_tag_data IS NULL)))THEN
1793: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'OUT_CTL',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),CASE WHEN TO_NUMBER( r_readings.TAG_DATA ) > v_upper_limit THEN
1794: 'Equipment Parameter value for "' ||
1795: r_readings.ATTRIBUTE ||
1796: '" parameter is above Upper Control Limit, ' ||
1797: r_readings.TAG_CODE || ' = ' || r_readings.TAG_DATA || ', UCL = ' ||

Line 1873: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'CTL_WG',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),CASE WHEN v_verify_tag_data_trend = 1 THEN

1869: fetch c_readings into r_readings ;
1870: exit when c_readings%NOTFOUND ;
1871: v_verify_tag_data_trend := MTH_UTIL_PKG.verify_tag_data_trend(r_readings.TAG_CODE,r_readings.TAG_DATA,r_readings.READING_TIME,'SPECIFICATIONS','MEAN',v_ctl_limit_threshold,NULL);
1872: IF(v_verify_tag_data_trend >0)THEN
1873: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'CTL_WG',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),CASE WHEN v_verify_tag_data_trend = 1 THEN
1874: v_ctl_limit_threshold || ' consecutive values of Equipment Parameter value for ' ||
1875: r_readings.attribute|| ' parameter is above mean value'
1876: WHEN v_verify_tag_data_trend = 2 THEN
1877: v_ctl_limit_threshold ||' consecutive values of Equipment Parameter value for ' ||

Line 1967: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'UNSTAB',NULL,NULL,CASE WHEN r_readings.READING_TIME1 >= r_readings.READING_TIME2

1963: exit when c_readings%NOTFOUND ;
1964: IF ((v_previous_tag_code1 IS NULL AND v_previous_tag_data1 IS NULL) AND (v_previous_tag_code2 IS NULL AND v_previous_tag_data2 IS NULL)AND (r_readings.TAG_DATA1> v_unstab_threshold1 AND r_readings.TAG_DATA2> v_unstab_threshold2 ) ) THEN
1965: MTH_UTIL_PKG.get_prev_tag_reading_set(r_readings.TAG_CODE1,r_readings.READING_TIME1,r_readings.TAG_CODE2,r_readings.READING_TIME2,NULL,p_pre_tag_data1,p_pre_tag_data2);
1966: IF( ((p_pre_tag_data1 <= v_unstab_threshold1 AND p_pre_tag_data2 <=v_unstab_threshold2) OR (p_pre_tag_data1 IS NULL AND p_pre_tag_data2 IS NULL)) AND(r_readings.TAG_DATA1> v_unstab_threshold1 AND r_readings.TAG_DATA2> v_unstab_threshold2 ))THEN
1967: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'UNSTAB',NULL,NULL,CASE WHEN r_readings.READING_TIME1 >= r_readings.READING_TIME2
1968: THEN r_readings.READING_TIME1 ELSE r_readings.READING_TIME2 END, NULL,NULL,'Equipment is unstable due to combination of parameter readings beyond limits, ' ||
1969: r_readings.TAG_CODE1 || ' = ' || r_readings.TAG_DATA1 || ' ' ||
1970: NVL( r_readings.UOM1 , '') || ', ' ||
1971: r_readings.TAG_CODE2 || ' = ' || r_readings.TAG_DATA2 || ' ' ||

Line 2019: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'FAULT',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Equipment fault. ' || r_readings.TAG_CODE || ' = ' || r_readings.TAG_DATA);

2015: exit when c_readings%NOTFOUND ;
2016: IF (r_readings.PREV_TAG_DATA IS NULL) THEN
2017: v_previous_tag_reading_data := MTH_UTIL_PKG.get_prev_tag_reading(r_readings.TAG_CODE,r_readings.READING_TIME);
2018: IF (v_previous_tag_reading_data <> v_EQP_FAULT_THRESHOLD OR v_previous_tag_reading_data IS NULL) THEN
2019: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'FAULT',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Equipment fault. ' || r_readings.TAG_CODE || ' = ' || r_readings.TAG_DATA);
2020: END IF;
2021: ELSE
2022: IF (r_readings.PREV_TAG_DATA <> v_EQP_FAULT_THRESHOLD) THEN
2023: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'FAULT',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Equipment fault. ' || r_readings.TAG_CODE || ' = ' || r_readings.TAG_DATA);END IF;

Line 2023: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'FAULT',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Equipment fault. ' || r_readings.TAG_CODE || ' = ' || r_readings.TAG_DATA);END IF;

2019: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'FAULT',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Equipment fault. ' || r_readings.TAG_CODE || ' = ' || r_readings.TAG_DATA);
2020: END IF;
2021: ELSE
2022: IF (r_readings.PREV_TAG_DATA <> v_EQP_FAULT_THRESHOLD) THEN
2023: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'FAULT',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Equipment fault. ' || r_readings.TAG_CODE || ' = ' || r_readings.TAG_DATA);END IF;
2024: END IF;
2025: end loop;
2026: close c_readings ;
2027: END ;

Line 2057: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'SCRP',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Scrap Quantity = ' || r_readings.tag_data);

2053: open c_readings;
2054: loop
2055: fetch c_readings into r_readings ;
2056: exit when c_readings%NOTFOUND ;
2057: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'SCRP',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Scrap Quantity = ' || r_readings.tag_data);
2058: end loop;
2059: close c_readings ;
2060: END ;
2061:

Line 2100: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'RECAL',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Equipment ready for recalibration. ' || r_readings.TAG_CODE ||

2096: exit when c_readings%NOTFOUND ;
2097: IF (r_readings.TAG_DATA >= v_recal_threshold)THEN
2098: v_previous_tag_reading_data := MTH_UTIL_PKG.get_prev_tag_reading(r_readings.TAG_CODE,r_readings.READING_TIME);
2099: IF (v_previous_tag_reading_data < v_recal_threshold OR v_previous_tag_reading_data IS NULL ) THEN
2100: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'RECAL',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Equipment ready for recalibration. ' || r_readings.TAG_CODE ||
2101: ' = ' || r_readings.TAG_DATA);
2102: END IF;
2103: END IF;
2104: --IF (r_readings.TAG_DATA = v_recal_threshold) THEN

Line 2105: --MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'RECAL',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Equipment ready for recalibration. ' || r_readings.TAG_CODE ||

2101: ' = ' || r_readings.TAG_DATA);
2102: END IF;
2103: END IF;
2104: --IF (r_readings.TAG_DATA = v_recal_threshold) THEN
2105: --MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'RECAL',NULL,NULL,r_readings.READING_TIME,NULL,TO_NUMBER(r_readings.tag_data),'Equipment ready for recalibration. ' || r_readings.TAG_CODE ||
2106: -- ' = ' || r_readings.TAG_DATA);
2107: end loop;
2108: close c_readings ;
2109: END ;