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_UTIL_PKG dependencies on MTH_EQUIP_STATUSES

Line 2656: * downtime in the mth_equip_statuses table *

2652:
2653: /* ****************************************************************************
2654: * Procedure :PUT_DOWN_STS_EXPECTED_UPTIME *
2655: * Description :This procedure puts expected_up_time for planned *
2656: * downtime in the mth_equip_statuses table *
2657: * File Name :MTHUTILB.PLS *
2658: * Visibility :Public
2659: * Modification log : *
2660: * Author Date Change: Shanthi Swaroop Donthu 18-Jul-2009 Initial Creation *

Line 2671: last_update_system_id FROM mth_equip_statuses WHERE status=3 AND To_Date IS NOT NULL AND last_update_date>=v_run_date)

2667: BEGIN
2668: SELECT DISTINCT from_date INTO v_run_date FROM mth_run_log WHERE fact_table = 'MTH_EQUIP_DOWN_STS_UPTIME';
2669:
2670: FOR i IN (SELECT equipment_fk_key,shift_workday_fk_key,from_date,To_Date,system_fk_key,creation_date,last_update_date,creation_system_id,
2671: last_update_system_id FROM mth_equip_statuses WHERE status=3 AND To_Date IS NOT NULL AND last_update_date>=v_run_date)
2672: LOOP
2673: v_start_time := i.from_date;
2674: v_end_time := i.To_Date;
2675:

Line 2688: UPDATE mth_equip_statuses SET To_Date = j.from_date WHERE equipment_fk_key = i.equipment_fk_key

2684:
2685: IF (v_start_time < j.from_date) THEN
2686: IF (v_end_time >= j.from_date) THEN
2687: IF (i.from_date = v_start_time) THEN
2688: UPDATE mth_equip_statuses SET To_Date = j.from_date WHERE equipment_fk_key = i.equipment_fk_key
2689: AND shift_workday_fk_key = i.shift_workday_fk_key AND from_date = v_start_time;
2690: /***** NO EXPECTE_DOWN_TIME ******/
2691: --Dbms_Output.PUT_LINE('Third Updated status record with the end date'||'---'||To_Char(j.from_date,'dd-Mon-yyyy hh24:mi:ss'));
2692: ELSE

Line 2693: INSERT INTO mth_equip_statuses(equipment_fk_key,shift_workday_fk_key,from_date,To_Date,status,system_fk_key,

2689: AND shift_workday_fk_key = i.shift_workday_fk_key AND from_date = v_start_time;
2690: /***** NO EXPECTE_DOWN_TIME ******/
2691: --Dbms_Output.PUT_LINE('Third Updated status record with the end date'||'---'||To_Char(j.from_date,'dd-Mon-yyyy hh24:mi:ss'));
2692: ELSE
2693: INSERT INTO mth_equip_statuses(equipment_fk_key,shift_workday_fk_key,from_date,To_Date,status,system_fk_key,
2694: creation_date,last_update_date,creation_system_id,last_update_system_id) VALUES (i.equipment_fk_key,
2695: i.shift_workday_fk_key,v_start_time,j.from_date,3,i.system_fk_key,i.creation_date,sysdate,
2696: i.creation_system_id,i.last_update_system_id);
2697:

Line 2704: INSERT INTO mth_equip_statuses(equipment_fk_key,shift_workday_fk_key,from_date,To_Date,status,system_fk_key,

2700: END IF;
2701:
2702: IF (v_end_time <= j.To_Date) THEN
2703:
2704: INSERT INTO mth_equip_statuses(equipment_fk_key,shift_workday_fk_key,from_date,To_Date,status,system_fk_key,
2705: creation_date,last_update_date,creation_system_id,last_update_system_id,expected_up_time,status_type) VALUES (i.equipment_fk_key,
2706: i.shift_workday_fk_key,j.from_date,v_end_time,3,i.system_fk_key,i.creation_date,sysdate,
2707: i.creation_system_id,i.last_update_system_id,((j.To_Date-j.from_date)*24),'PLANNED DOWNTIME');/*** EXPECTED_UP_TIME = J.TO_DATE - J.FROM_DATE **/
2708: EXIT;

Line 2712: INSERT INTO mth_equip_statuses(equipment_fk_key,shift_workday_fk_key,from_date,To_Date,status,system_fk_key,

2708: EXIT;
2709: --Dbms_Output.PUT_LINE('inserted status record with'||'---'||To_Char(j.from_date,'dd-Mon-yyyy hh24:mi:ss')||'---'||To_Char(v_end_time,'dd-Mon-yyyy hh24:mi:ss'));
2710:
2711: ELSE
2712: INSERT INTO mth_equip_statuses(equipment_fk_key,shift_workday_fk_key,from_date,To_Date,status,system_fk_key,
2713: creation_date,last_update_date,creation_system_id,last_update_system_id,expected_up_time,status_type) VALUES (i.equipment_fk_key,
2714: i.shift_workday_fk_key,j.from_date,j.to_date,3,i.system_fk_key,i.creation_date,sysdate,
2715: i.creation_system_id,i.last_update_system_id,((j.To_Date-j.from_date)*24),'PLANNED DOWNTIME');/*** EXPECTED_UP_TIME = J.TO_DATE - J.FROM_DATE **/
2716:

Line 2732: UPDATE mth_equip_statuses SET expected_up_time = ((j.to_date-v_start_time)*24), status_type = 'PLANNED DOWNTIME', last_update_date = SYSDATE

2728: --Dbms_Output.PUT_LINE('First IF condition');
2729:
2730: IF(v_end_time <= j.to_date) THEN
2731:
2732: UPDATE mth_equip_statuses SET expected_up_time = ((j.to_date-v_start_time)*24), status_type = 'PLANNED DOWNTIME', last_update_date = SYSDATE
2733: WHERE equipment_fk_key = i.equipment_fk_key
2734: AND shift_workday_fk_key = i.shift_workday_fk_key AND from_date = v_start_time AND To_Date=v_end_time;
2735: /***UPDATE THE RECORD WITH *** EXPECTED_UP_TIME = V_END_TIME - V_START_TIMR **/
2736:

Line 2740: UPDATE mth_equip_statuses SET To_Date = j.to_date, last_update_date = SYSDATE,expected_up_time=((j.To_Date - v_start_time)*24), status_type ='PLANNED DOWNTIME' WHERE equipment_fk_key = i.equipment_fk_key

2736:
2737: EXIT ;
2738:
2739: ELSE
2740: UPDATE mth_equip_statuses SET To_Date = j.to_date, last_update_date = SYSDATE,expected_up_time=((j.To_Date - v_start_time)*24), status_type ='PLANNED DOWNTIME' WHERE equipment_fk_key = i.equipment_fk_key
2741: AND shift_workday_fk_key = i.shift_workday_fk_key AND from_date = v_start_time;
2742:
2743: --Dbms_Output.PUT_LINE('Third Updated status record with the end date'||'---'||To_Char(j.to_date,'dd-Mon-yyyy hh24:mi:ss'));
2744:

Line 2745: INSERT INTO mth_equip_statuses(equipment_fk_key,shift_workday_fk_key,from_date,To_Date,status,system_fk_key,

2741: AND shift_workday_fk_key = i.shift_workday_fk_key AND from_date = v_start_time;
2742:
2743: --Dbms_Output.PUT_LINE('Third Updated status record with the end date'||'---'||To_Char(j.to_date,'dd-Mon-yyyy hh24:mi:ss'));
2744:
2745: INSERT INTO mth_equip_statuses(equipment_fk_key,shift_workday_fk_key,from_date,To_Date,status,system_fk_key,
2746: creation_date,last_update_date,creation_system_id,last_update_system_id) VALUES (i.equipment_fk_key,
2747: i.shift_workday_fk_key,j.to_date,v_end_time,3,i.system_fk_key,i.creation_date,sysdate,
2748: i.creation_system_id,i.last_update_system_id);
2749:

Line 2761: DELETE FROM mth_equip_statuses WHERE from_date = To_Date;

2757:
2758: END LOOP;
2759: COMMIT;
2760: END LOOP;
2761: DELETE FROM mth_equip_statuses WHERE from_date = To_Date;
2762: COMMIT;
2763:
2764: END PUT_DOWN_STS_EXPECTED_UPTIME;
2765:

Line 2771: * into hour level and populates into mth_equip_statuses table *

2767:
2768: /*****************************************************************************
2769: * Procedure :MTH_LOAD_HOUR_STATUS *
2770: * Description :This procedure is used to break the shift level status data *
2771: * into hour level and populates into mth_equip_statuses table *
2772: * File Name :MTHUTILB.PLS *
2773: * Visibility :Public
2774: * Modification log : *
2775: * Author Date Change: Shanthi Swaroop Donthu 08-Dec-2009 Initial Creation *

Line 2798: MERGE INTO MTH_EQUIP_STATUSES stat

2794:
2795: BEGIN
2796: IF (p_hour_to_time >= p_to_date)
2797: THEN
2798: MERGE INTO MTH_EQUIP_STATUSES stat
2799: USING (select p_equipment_fk_key p_equipment_fk_key, p_shift_workday_fk_key p_shift_workday_fk_key,
2800: p_hour_fk_key p_hour_fk_key, p_from_date p_from_date, p_to_date p_to_date, p_status p_status,
2801: p_system_fk_key p_system_fk_key,p_user_dim1_fk_key p_user_dim1_fk_key,
2802: p_user_dim2_fk_key p_user_dim2_fk_key, p_user_dim3_fk_key p_user_dim3_fk_key,

Line 2839: MERGE INTO MTH_EQUIP_STATUSES stat

2835: Nvl(p_system_fk_key,v_unassigned_string),NULL,NULL,NULL,NULL,NULL,p_hour_fk_key);
2836:
2837: ELSE
2838:
2839: MERGE INTO MTH_EQUIP_STATUSES stat
2840: USING (select p_equipment_fk_key p_equipment_fk_key, p_shift_workday_fk_key p_shift_workday_fk_key,
2841: p_hour_fk_key p_hour_fk_key, p_from_date p_from_date, p_to_date p_to_date, p_status p_status,
2842: p_system_fk_key p_system_fk_key,p_user_dim1_fk_key p_user_dim1_fk_key,
2843: p_user_dim2_fk_key p_user_dim2_fk_key, p_user_dim3_fk_key p_user_dim3_fk_key,

Line 2890: MERGE INTO MTH_EQUIP_STATUSES stat

2886: WHERE HOUR_PK = p_hour_fk;
2887:
2888: IF (v_next_hour_from_time <= v_least_to_date)
2889: THEN
2890: MERGE INTO MTH_EQUIP_STATUSES stat
2891: USING (select p_equipment_fk_key p_equipment_fk_key, p_shift_workday_fk_key p_shift_workday_fk_key,
2892: p_hour_fk_key p_hour_fk_key, p_from_date p_from_date, p_to_date p_to_date, p_status p_status,
2893: p_system_fk_key p_system_fk_key,p_user_dim1_fk_key p_user_dim1_fk_key,
2894: p_user_dim2_fk_key p_user_dim2_fk_key, p_user_dim3_fk_key p_user_dim3_fk_key,