1 PACKAGE MTH_LOAD_TAG_READINGS_PKG AUTHID CURRENT_USER AS
2 /*$Header: mthtags.pls 120.3.12020000.1 2012/07/24 16:13:17 sasuren noship $*/
3
4 /*******************************************************************************
5 * Procedure :PROCESS_READINGS *
6 * Description :This procedure is the main procedure for readings *
7 * File Name :MTHTAGS.PLS *
8 * Visibility :Public *
9 * Parameters : p_mode : INIT,INCR,RECAL *
10 * p_recal_from_date : Recalculation from date *
11 * p_recal_to_date : Recalculation to date *
12 * p_equipment_pk_key : Equipment to recalculate *
13 p_from_tz *
14 p_to_tz *
15 p_ret_code *
16 *******************************************************************************/
17
18 PROCEDURE PROCESS_READINGS( p_mode IN VARCHAR2, --INIT, INCR, RECAL
19 p_recal_from_date IN DATE DEFAULT NULL, --Recalculation from date
20 p_recal_to_date IN DATE DEFAULT NULL, --Recalculation to date
21 p_equipment_pk_key IN NUMBER DEFAULT NULL, --Equipment to recalculate
22 p_from_tz IN VARCHAR2 DEFAULT NULL,
23 p_to_tz IN VARCHAR2 DEFAULT NULL ,
24 p_ret_code OUT NOCOPY NUMBER
25 );
26
27 v_ctl_limit_threshold NUMBER :=8; /* Threshold value for ctl_limit_warning event*/
28 v_EQP_FAULT_THRESHOLD Number :=1; /* Threshold value for Equipment Fault event*/
29 v_recal_threshold number:=1000; /* Threshold value for Recalibration event*/
30 v_unstab_threshold1 NUMBER:=100; /* Threshold value for 1st Attribute i.e. v_attr1*/
31 v_unstab_threshold2 NUMBER:=100; /* Threshold value for2nd Attribute i.e. v_attr2*/
32 v_attr1 VARCHAR2(100):='TEMPERATURE'; /*1st Attribute name for which unstable equipment event needs to be monitored*/
33 v_attr2 VARCHAR2(100):='PRESSURE'; /*2nd Attribute name for which unstable equipment event needs to be monitored*/
34
35
36
37
38 END MTH_LOAD_TAG_READINGS_PKG;