APPS.MTH_EVENT_GEN_PKG dependencies on MTH_EVENT_PKG

Line 33: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'DOWN',NULL ,NULL ,r_readings.from_date,r_readings.reason_code,3 ,'Equipment is down due to reason "' || r_readings.meaning || '"');

29: open c_readings;
30: loop
31: fetch c_readings into r_readings ;
32: exit when c_readings%NOTFOUND ;
33: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'DOWN',NULL ,NULL ,r_readings.from_date,r_readings.reason_code,3 ,'Equipment is down due to reason "' || r_readings.meaning || '"');
34: end loop;
35: close c_readings ;
36: END MTH_GEN_EQP_DOWN_W_RZ_EVENT;
37: /* ****************************************************************************

Line 130: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'IDLE',NULL,NULL,r_readings.from_date ,NULL,To_Number(r_readings.status) ,'Equipment is idle for more than ' || v_dur_idle_limit_in_minutes || ' minutes');

126: open c_readings;
127: loop
128: fetch c_readings into r_readings ;
129: exit when c_readings%NOTFOUND ;
130: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'IDLE',NULL,NULL,r_readings.from_date ,NULL,To_Number(r_readings.status) ,'Equipment is idle for more than ' || v_dur_idle_limit_in_minutes || ' minutes');
131: end loop;
132: close c_readings ;
133: END ;
134:

Line 245: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'DOW_PD',NULL,NULL,r_readings.from_date ,NULL,To_Number(r_readings.status) ,'Equipment is down for more than ' ||v_dur_down_limit_in_minutes || ' minutes');

241: open c_readings;
242: loop
243: fetch c_readings into r_readings ;
244: exit when c_readings%NOTFOUND ;
245: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'DOW_PD',NULL,NULL,r_readings.from_date ,NULL,To_Number(r_readings.status) ,'Equipment is down for more than ' ||v_dur_down_limit_in_minutes || ' minutes');
246: end loop;
247: close c_readings ;
248: END ;
249: /* ****************************************************************************

Line 302: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'HI_SCRP',r_readings.shift_workday_fk_key,r_readings.workorder_fk_key,NULL ,NULL,NULL ,'Scrap % is greater than ' || v_hi_scrap_threshold || '%');

298: open c_readings;
299: loop
300: fetch c_readings into r_readings ;
301: exit when c_readings%NOTFOUND ;
302: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'HI_SCRP',r_readings.shift_workday_fk_key,r_readings.workorder_fk_key,NULL ,NULL,NULL ,'Scrap % is greater than ' || v_hi_scrap_threshold || '%');
303: end loop;
304: close c_readings ;
305: END ;
306: /* ****************************************************************************

Line 360: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'HI_RWRK',r_readings.shift_workday_fk_key,r_readings.workorder_fk_key,NULL ,NULL,NULL ,'Rework % is greater than ' || v_hi_rework_threshold || '%');

356: open c_readings;
357: loop
358: fetch c_readings into r_readings ;
359: exit when c_readings%NOTFOUND ;
360: MTH_EVENT_PKG.HANDLE_EVENT (r_readings.equipment_fk_key,'HI_RWRK',r_readings.shift_workday_fk_key,r_readings.workorder_fk_key,NULL ,NULL,NULL ,'Rework % is greater than ' || v_hi_rework_threshold || '%');
361: end loop;
362: close c_readings ;
363: END ;
364: