[Home] [Help]
PACKAGE: APPS.MTH_EVENT_GEN_PKG
Source
1 PACKAGE MTH_EVENT_GEN_PKG AUTHID CURRENT_USER AS
2 /*$Header: mthevgs.pls 120.1.12020000.1 2012/07/24 16:11:21 sasuren noship $*/
3
4 v_hi_rework_threshold NUMBER := 10;
5 v_dur_idle_limit_in_minutes NUMBER :=15;
6 v_dur_down_limit_in_minutes NUMBER :=15;
7 v_hi_scrap_threshold NUMBER :=10;
8
9 /* ****************************************************************************
10 * Procedure : MTH_GEN_HDL_EVTS_FROM_STS_OUT *
11 * Description :The new procedure MTH_GEN_HDL_EVTS_FROM_STS_OUT *
12 generates and handles events from MTH_EQUIP_STATUSES, MTH_TAG_REASON_READINGS, and MTH_EQUIP_OUTPUT_SUMMARY*
13 * File Name :MTHEVGS.PLS *
14 * Visibility :Private *
15 * Parameters : *
16 **************************************************************************** */
17
18 PROCEDURE MTH_GEN_HDL_EVTS_FROM_STS_OUT(p_mode IN VARCHAR2,
19 p_ret_code OUT NOCOPY NUMBER) ;
20
21 /* ****************************************************************************
22 * Procedure : MTH_GEN_EQP_DOWN_W_RZ_EVENT *
23 * Description :The new procedure MTH_GEN_EQP_DOWN_W_RZ_EVENT *
24 generates and handles Equipment down with reason code events from MTH_TAG_REASON_READINGS table.*
25 * File Name :MTHEVGS.PLS *
26 * Visibility :Private *
27 * Parameters : *
28 **************************************************************************** */
29
30 PROCEDURE MTH_GEN_EQP_DOWN_W_RZ_EVENT (v_log_from_date IN DATE);
31
32 /* ****************************************************************************
33 * Procedure : MTH_GEN_EQP_IDLE_PRD_EVENT *
34 * Description :The new procedure MTH_GEN_EQP_IDLE_PRD_EVENT *
35 generates and handles Equipment idle over a period events*
36 * File Name :MTHEVGS.PLS *
37 * Visibility :Private *
38 * Parameters : *
39 **************************************************************************** */
40
41 PROCEDURE MTH_GEN_EQP_IDLE_PRD_EVENT (v_log_from_date IN DATE) ;
42
43 /* ****************************************************************************
44 * Procedure : MTH_GEN_EQP_DWN_PRD_EVENT *
45 * Description :The new procedure MTH_GEN_EQP_DWN_PRD_EVENT *
46 generates and handles Equipment down over a period events*
47 * File Name :MTHEVGS.PLS *
48 * Visibility :Private *
49 * Parameters : *
50 **************************************************************************** */
51
52
53 PROCEDURE MTH_GEN_EQP_DWN_PRD_EVENT (v_log_from_date IN DATE);
54
55 /* ****************************************************************************
56 * Procedure : MTH_GEN_HIGH_SCRAP_EVENT *
57 * Description :The new procedure MTH_GEN_HIGH_SCRAP_EVENT *
58 generates and handles High Scrap events.*
59 * File Name MTHEVGS.PLS *
60 * Visibility :Private *
61 * Parameters : *
62 **************************************************************************** */
63
64 PROCEDURE MTH_GEN_HIGH_SCRAP_EVENT (v_log_from_date IN DATE) ;
65
66 /* ****************************************************************************
67 * Procedure : MTH_GEN_HIGH_REWORK_EVENT *
68 * Description :The new procedure MTH_GEN_HIGH_REWORK_EVENT *
69 generates and handles High Rework events*
70 * File Name :MTHEVGS.PLS *
71 * Visibility :Private *
72 * Parameters : *
73 **************************************************************************** */
74
75 PROCEDURE MTH_GEN_HIGH_REWORK_EVENT (v_log_from_date IN DATE);
76
77
78
79 END MTH_EVENT_GEN_PKG;