1 PACKAGE CSI_COUNTER_READINGS_PVT as
2 /* $Header: csivcrds.pls 120.1.12010000.1 2008/07/25 08:15:27 appldev ship $ */
3
4 PROCEDURE Create_Reading_Transaction
5 ( p_api_version IN NUMBER
6 ,p_commit IN VARCHAR2
7 ,p_init_msg_list IN VARCHAR2
8 ,p_validation_level IN NUMBER
9 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
10 ,x_return_status OUT NOCOPY VARCHAR2
11 ,x_msg_count OUT NOCOPY NUMBER
12 ,x_msg_data OUT NOCOPY VARCHAR2
13 );
14 --
15 /*----------------------------------------------------*/
16 /* procedure name: Capture_Counter_Reading */
17 /* description : procedure used to */
18 /* capture counter readings */
19 /*----------------------------------------------------*/
20
21 PROCEDURE Capture_Counter_Reading
22 (
23 p_api_version IN NUMBER
24 ,p_commit IN VARCHAR2
25 ,p_init_msg_list IN VARCHAR2
26 ,p_validation_level IN NUMBER
27 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
28 ,p_ctr_rdg_rec IN OUT NOCOPY csi_ctr_datastructures_pub.counter_readings_rec
29 ,x_return_status OUT NOCOPY VARCHAR2
30 ,x_msg_count OUT NOCOPY NUMBER
31 ,x_msg_data OUT NOCOPY VARCHAR2
32 );
33 --
34 /*----------------------------------------------------*/
35 /* procedure name: Compute_Formula_Counters */
36 /* description : procedure used to */
37 /* compute formula counter readings */
38 /*----------------------------------------------------*/
39
40 PROCEDURE Compute_Formula_Counters
41 (
42 p_api_version IN NUMBER
43 ,p_commit IN VARCHAR2
44 ,p_init_msg_list IN VARCHAR2
45 ,p_validation_level IN NUMBER
46 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
47 ,p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec
48 ,x_return_status OUT NOCOPY VARCHAR2
49 ,x_msg_count OUT NOCOPY NUMBER
50 ,x_msg_data OUT NOCOPY VARCHAR2
51 );
52 --
53 /*----------------------------------------------------*/
54 /* procedure name: Compute_Target_Counters */
55 /* description : procedure used to */
56 /* compute Target counter readings */
57 /*----------------------------------------------------*/
58
59 PROCEDURE Compute_Target_Counters
60 (
61 p_api_version IN NUMBER
62 ,p_commit IN VARCHAR2
63 ,p_init_msg_list IN VARCHAR2
64 ,p_validation_level IN NUMBER
65 ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
66 ,p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec
67 ,p_mode IN VARCHAR2
68 ,x_return_status OUT NOCOPY VARCHAR2
69 ,x_msg_count OUT NOCOPY NUMBER
70 ,x_msg_data OUT NOCOPY VARCHAR2
71 );
72 --
73 PROCEDURE Compute_Derive_Counters(
74 P_Api_Version IN NUMBER,
75 P_Init_Msg_List IN VARCHAR2,
76 P_Commit IN VARCHAR2,
77 p_validation_level IN NUMBER,
78 p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
79 p_ctr_rdg_rec IN csi_ctr_datastructures_pub.counter_readings_rec,
80 p_mode IN VARCHAR2,
81 X_Return_Status OUT NOCOPY VARCHAR2,
82 X_Msg_Count OUT NOCOPY NUMBER,
83 X_Msg_Data OUT NOCOPY VARCHAR2
84 );
85 --
86 PROCEDURE Update_Counter_Reading
87 (
88 p_api_version IN NUMBER
89 ,p_commit IN VARCHAR2
90 ,p_init_msg_list IN VARCHAR2
91 ,p_validation_level IN NUMBER
92 ,p_ctr_rdg_rec IN OUT NOCOPY csi_ctr_datastructures_pub.counter_readings_rec
93 ,x_return_status OUT NOCOPY VARCHAR2
94 ,x_msg_count OUT NOCOPY NUMBER
95 ,x_msg_data OUT NOCOPY VARCHAR2
96 );
97 --
98 PROCEDURE Capture_Ctr_Property_Reading
99 (
100 p_api_version IN NUMBER
101 ,p_commit IN VARCHAR2
102 ,p_init_msg_list IN VARCHAR2
103 ,p_validation_level IN NUMBER
104 ,p_ctr_prop_rdg_rec IN OUT NOCOPY csi_ctr_datastructures_pub.ctr_property_readings_rec
105 ,x_return_status OUT NOCOPY VARCHAR2
106 ,x_msg_count OUT NOCOPY NUMBER
107 ,x_msg_data OUT NOCOPY VARCHAR2
108 );
109 --
110 FUNCTION Est_daily_avg(
111 p_start_date IN DATE,
112 p_start_reading IN NUMBER,
113 p_end_date IN DATE,
114 p_end_reading IN NUMBER
115 ) RETURN NUMBER;
116 --
117 PROCEDURE ESTIMATE_START_READINGS(
118 P_api_version IN NUMBER,
119 P_Init_Msg_List IN VARCHAR2,
120 P_Commit IN VARCHAR2,
121 p_validation_level IN NUMBER,
122 p_counter_id IN NUMBER,
123 p_default_value IN NUMBER,
124 p_calculation_start_date IN DATE,
125 x_calc_start_reading OUT NOCOPY NUMBER,
126 X_Return_Status OUT NOCOPY VARCHAR2,
127 X_Msg_Count OUT NOCOPY NUMBER,
128 X_Msg_Data OUT NOCOPY VARCHAR2
129 );
130 --
131 PROCEDURE EST_PERIOD_START_READINGS(
132 P_api_version IN NUMBER,
133 P_Init_Msg_List IN VARCHAR2,
134 P_Commit IN VARCHAR2,
135 p_validation_level IN NUMBER,
136 p_counter_id IN NUMBER,
137 p_default_value IN NUMBER,
138 p_avg_calculation_start_date IN DATE,
139 p_calculation_start_date IN DATE,
140 x_calc_start_reading OUT NOCOPY NUMBER,
141 X_Return_Status OUT NOCOPY VARCHAR2,
142 X_Msg_Count OUT NOCOPY NUMBER,
143 X_Msg_Data OUT NOCOPY VARCHAR2
144 );
145 --
146 PROCEDURE ESTIMATE_USAGE(
147 P_api_version IN NUMBER,
148 P_Init_Msg_List IN VARCHAR2,
149 P_Commit IN VARCHAR2,
150 p_validation_level IN NUMBER,
151 p_counter_id IN NUMBER,
152 p_usage_markup IN NUMBER,
153 p_default_value IN NUMBER,
154 p_estimation_avg_type IN VARCHAR2,
155 p_estimation_period_start_date IN DATE,
156 p_estimation_period_end_date IN DATE,
157 p_avg_calculation_start_date IN DATE,
158 p_number_of_readings IN NUMBER,
159 x_estimated_usage_qty OUT NOCOPY NUMBER,
160 x_estimated_meter_reading OUT NOCOPY NUMBER,
161 x_estimated_period_start_rdg OUT NOCOPY NUMBER,
162 X_Return_Status OUT NOCOPY VARCHAR2,
163 X_Msg_Count OUT NOCOPY NUMBER,
164 X_Msg_Data OUT NOCOPY VARCHAR2
165 );
166 --
167 PROCEDURE ESTIMATE_COUNTER_READING(
168 P_api_version IN NUMBER,
169 P_Init_Msg_List IN VARCHAR2,
170 P_Commit IN VARCHAR2,
171 p_validation_level IN NUMBER,
172 p_counter_id IN NUMBER,
173 p_estimation_period_start_date IN DATE,
174 p_estimation_period_end_date IN DATE,
175 p_avg_calculation_start_date IN DATE,
176 p_number_of_readings IN NUMBER,
177 x_estimated_usage_qty OUT NOCOPY NUMBER,
178 x_estimated_meter_reading OUT NOCOPY NUMBER,
179 x_estimated_period_start_rdg OUT NOCOPY NUMBER,
180 X_Return_Status OUT NOCOPY VARCHAR2,
181 X_Msg_Count OUT NOCOPY NUMBER,
182 X_Msg_Data OUT NOCOPY VARCHAR2
183 );
184 --
185 PROCEDURE ESTIMATE_FIXED_VALUES(
186 P_api_version IN NUMBER,
187 P_Init_Msg_List IN VARCHAR2,
188 P_Commit IN VARCHAR2,
189 p_validation_level IN NUMBER,
190 p_counter_id IN NUMBER,
191 p_fixed_value IN NUMBER,
192 p_default_value IN NUMBER,
193 p_estimation_period_start_date IN DATE,
194 p_estimation_period_end_date IN DATE,
195 x_estimated_meter_reading OUT NOCOPY NUMBER,
196 x_estimated_usage_qty OUT NOCOPY NUMBER,
197 x_estimated_period_start_rdg OUT NOCOPY NUMBER,
198 X_Return_Status OUT NOCOPY VARCHAR2,
199 X_Msg_Count OUT NOCOPY NUMBER,
200 X_Msg_Data OUT NOCOPY VARCHAR2
201 );
202 --
203 FUNCTION Transaction_ID_Exists
204 (p_transaction_id IN NUMBER)
205 RETURN BOOLEAN;
206 --
207 FUNCTION get_reading_before_reset(p_counter_id NUMBER,
208 p_value_timestamp DATE)
209 RETURN NUMBER;
210 --
211 FUNCTION get_previous_net_reading(p_counter_id NUMBER,
212 p_value_timestamp DATE)
213 RETURN NUMBER;
214 --
215 FUNCTION get_latest_reading(p_counter_id NUMBER)
216 RETURN NUMBER;
217 --
218 END CSI_COUNTER_READINGS_PVT;