1 Package MTH_SUSTAIN_ASPECT_PKG AUTHID CURRENT_USER AS
2 /*$Header: mthesats.pls 120.6 2011/03/01 10:04:51 pwaghmar noship $ */
3
4 -- TYPE NUMBER_TABLE IS TABLE OF NUMBER;
5
6 MAX_BULK_COMMIT_SIZE NUMBER := 1000;
7 VIRTUAL_METER_START_DATE DATE := trunc(SYSDATE - 100,'HH24') - 1/(3600 * 24);
8
9 TYPE shift_record IS
10 RECORD (from_date DATE, To_Date DATE, availability_flag VARCHAR2(1));
11 TYPE shift_array_type IS TABLE OF shift_record;
12
13
14 TYPE status_record IS
15 RECORD (from_date DATE, To_Date DATE, run_hours NUMBER,
16 down_hours NUMBER, idle_hours NUMBER, off_hours NUMBER);
17 TYPE status_array_type IS TABLE OF status_record;
18
19 TYPE meter_reading_record IS
20 RECORD (from_date DATE, To_Date DATE, usage_value NUMBER);
21 TYPE readings_array_type IS TABLE OF meter_reading_record;
22
23
24 TYPE component_record IS
25 RECORD (component_pk_key NUMBER,
26 component_type VARCHAR2(30),
27 component_value VARCHAR2(255),
28 comp_time_series_values Dbms_Sql.NUMBER_TABLE);
29 TYPE component_lookup_type IS TABLE OF component_record
30 INDEX BY BINARY_INTEGER;
31
32 TYPE ReadingType IS RECORD (
33 meter_fk_key mth_meter_readings.meter_fk_key%type,
34 from_time mth_meter_readings.from_time%type,
35 to_time mth_meter_readings.to_time%TYPE,
36 hour_pk_key mth_hour_d.hour_pk_key%TYPE,
37 usage_value mth_meter_readings.usage_value%TYPE
38 );
39
40 TYPE EntityShiftType IS RECORD (
41 esa_pk_key mth_entity_sustain_aspect.esa_pk_key%TYPE,
42 meter_fk_key mth_meter_entities.meter_fk_key%type,
43 entity_fk_key mth_meter_entities.entity_fk_key%type,
44 from_time mth_meter_readings.from_time%type,
45 to_time mth_meter_readings.to_time%TYPE,
46 shift_workday_fk_key mth_equipment_shifts_d.shift_workday_fk_key%type,
47 hour_fk_key mth_hour_d.hour_pk_key%TYPE,
48 usage_value mth_meter_readings.usage_value%TYPE
49 );
50
51
52 TYPE MeterReadingTable IS TABLE OF ReadingType;
53 TYPE EntityShiftTable IS TABLE OF EntityShiftType;
54
55
56 /* ****************************************************************************
57 * Procedure :LOAD_RAW_TO_METER_READINGS *
58 * Description :TLoad data from tag meter raw data for energy consumption *
59 * in MTH_TAG_METER_READINGS_RAW into meter readings table MTH_METER_READINGS *
60 **************************************************************************** */
61
62 PROCEDURE LOAD_ACT_METER_RAW_TO_READINGS(p_curr_partition IN NUMBER);
63 PROCEDURE ADD_VRT_MTS_TO_METER_READINGS (p_virtual_meter_start_date IN DATE
64 DEFAULT VIRTUAL_METER_START_DATE);
65 PROCEDURE load_reading_to_sustain_aspect;
66
67 --PROCEDURE LOAD_ACT_METER_RAW_TO_READINGS (p_virtual_meter_start_date IN DATE
68 -- DEFAULT VIRTUAL_METER_START_DATE);
69
70 PROCEDURE process_entity_sustain_aspect
71 (p_err_buff out NOCOPY VARCHAR2,
72 p_retcode out NOCOPY NUMBER,
73 p_process_mode IN VARCHAR2 DEFAULT 'INCR',
74 p_virtual_meter_start_date_str IN varchar2 );
75
76
77 END MTH_SUSTAIN_ASPECT_PKG;