1 PACKAGE CSI_COUNTER_TEMPLATE_PVT AS
2 /* $Header: csivctts.pls 120.7.12010000.1 2008/07/25 08:15:32 appldev ship $ */
3
4 -- --------------------------------------------------------
5 -- Define global variables
6 -- --------------------------------------------------------
7
8 -- G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_COUNTER_TEMPLATE_PVT';
9 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csivctts.pls';
10
11 PROCEDURE validate_counter_group
12 (
13 p_name VARCHAR2,
14 p_template_flag VARCHAR2
15 );
16
17 PROCEDURE validate_start_date
18 (
19 p_start_date DATE
20 );
21
22 PROCEDURE validate_inventory_item
23 (
24 p_inventory_item_id NUMBER
25 );
26
27 PROCEDURE validate_lookups
28 (
29 p_lookup_type VARCHAR2
30 ,p_lookup_code VARCHAR2
31 );
32
33 PROCEDURE Validate_Data_Type
34 (
35 p_property_data_type IN VARCHAR2,
36 p_default_value IN VARCHAR2,
37 p_minimum_value IN VARCHAR2,
38 p_maximum_value IN VARCHAR2
39 );
40
41 PROCEDURE validate_uom
42 (
43 p_uom_code varchar2
44 );
45
46 PROCEDURE validate_ctr_relationship
47 (
48 p_counter_id IN NUMBER,
49 x_direction OUT NOCOPY VARCHAR2,
50 x_start_date OUT NOCOPY DATE,
51 x_end_date OUT NOCOPY DATE
52 );
53
54 PROCEDURE Validate_Counter
55 (
56 p_group_id NUMBER
57 ,p_name VARCHAR2
58 ,p_counter_type VARCHAR2
59 ,p_uom_code VARCHAR2
60 ,p_usage_item_id NUMBER
61 ,p_reading_type NUMBER
62 ,p_direction VARCHAR2
63 ,p_estimation_id NUMBER
64 ,p_derive_function VARCHAR2
65 ,p_formula_text VARCHAR2
66 ,p_derive_counter_id NUMBER
67 ,p_filter_type VARCHAR2
68 ,p_filter_reading_count NUMBER
69 ,p_filter_time_uom VARCHAR2
70 ,p_automatic_rollover VARCHAR2
71 ,p_rollover_last_reading NUMBER
72 ,p_rollover_first_reading NUMBER
73 ,p_tolerance_plus NUMBER
74 ,p_tolerance_minus NUMBER
75 ,p_used_in_scheduling VARCHAR2
76 ,p_initial_reading NUMBER
77 ,p_default_usage_rate NUMBER
78 ,p_use_past_reading NUMBER
79 ,p_counter_id NUMBER
80 ,p_start_date_active DATE
81 ,p_end_date_active DATE
82 ,p_update_flag VARCHAR2
83 );
84
85
86 --|---------------------------------------------------
87 --| procedure name: create_counter_group
88 --| description : procedure used to
89 --| create counter group
90 --|---------------------------------------------------
91
92 PROCEDURE create_counter_group
93 (
94 p_api_version IN NUMBER
95 ,p_commit IN VARCHAR2
96 ,p_init_msg_list IN VARCHAR2
97 ,p_validation_level IN NUMBER
98 ,p_counter_groups_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec
99 ,x_return_status OUT NOCOPY VARCHAR2
100 ,x_msg_count OUT NOCOPY NUMBER
101 ,x_msg_data OUT NOCOPY VARCHAR2
102 );
103
104
105 --|---------------------------------------------------
106 --| procedure name: create_item_association
107 --| description : procedure used to
108 --| create item association to
109 --| counter group or counters
110 --|---------------------------------------------------
111
112 PROCEDURE create_item_association
113 (
114 p_api_version IN NUMBER
115 ,p_commit IN VARCHAR2
116 ,p_init_msg_list IN VARCHAR2
117 ,p_validation_level IN NUMBER
118 ,p_ctr_item_associations_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec
119 ,x_return_status OUT NOCOPY VARCHAR2
120 ,x_msg_count OUT NOCOPY NUMBER
121 ,x_msg_data OUT NOCOPY VARCHAR2
122 );
123
124 --|---------------------------------------------------
125 --| procedure name: create_counter_template
126 --| description : procedure used to
127 --| create counter template
128 --|---------------------------------------------------
129
130 PROCEDURE create_counter_template
131 (
132 p_api_version IN NUMBER
133 ,p_commit IN VARCHAR2
134 ,p_init_msg_list IN VARCHAR2
135 ,p_validation_level IN NUMBER
136 ,p_counter_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec
137 ,x_return_status OUT NOCOPY VARCHAR2
138 ,x_msg_count OUT NOCOPY NUMBER
139 ,x_msg_data OUT NOCOPY VARCHAR2
140 );
141
142 --|---------------------------------------------------
143 --| procedure name: create_ctr_property_template
144 --| description : procedure used to
145 --| create counter properties
146 --|---------------------------------------------------
147
148 PROCEDURE create_ctr_property_template
149 (
150 p_api_version IN NUMBER
151 ,p_commit IN VARCHAR2
152 ,p_init_msg_list IN VARCHAR2
153 ,p_validation_level IN NUMBER
154 ,p_ctr_property_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec
155 ,x_return_status OUT NOCOPY VARCHAR2
156 ,x_msg_count OUT NOCOPY NUMBER
157 ,x_msg_data OUT NOCOPY VARCHAR2
158 );
159
160
161 --|---------------------------------------------------
162 --| procedure name: create_counter_relationship
163 --| description : procedure used to
164 --| create counter relationship
165 --|---------------------------------------------------
166
167 PROCEDURE create_counter_relationship
168 (
169 p_api_version IN NUMBER
170 ,p_commit IN VARCHAR2
171 ,p_init_msg_list IN VARCHAR2
172 ,p_validation_level IN NUMBER
173 ,p_counter_relationships_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec
174 ,x_return_status OUT NOCOPY VARCHAR2
175 ,x_msg_count OUT NOCOPY NUMBER
176 ,x_msg_data OUT NOCOPY VARCHAR2
177 );
178
179 --|---------------------------------------------------
180 --| procedure name: create_derived_filters
181 --| description : procedure used to
182 --| create derived filters
183 --|---------------------------------------------------
184
185 PROCEDURE create_derived_filters
186 (
187 p_api_version IN NUMBER
188 ,p_commit IN VARCHAR2
189 ,p_init_msg_list IN VARCHAR2
190 ,p_validation_level IN NUMBER
191 ,p_ctr_derived_filters_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
192 ,x_return_status OUT NOCOPY VARCHAR2
193 ,x_msg_count OUT NOCOPY NUMBER
194 ,x_msg_data OUT NOCOPY VARCHAR2
195 );
196
197 --|---------------------------------------------------
198 --| procedure name: update_counter_group
199 --| description : procedure used to
200 --| update counter group
201 --|---------------------------------------------------
202
203 PROCEDURE update_counter_group
204 (
205 p_api_version IN NUMBER
206 ,p_commit IN VARCHAR2
207 ,p_init_msg_list IN VARCHAR2
208 ,p_validation_level IN NUMBER
209 ,p_counter_groups_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec
210 ,x_return_status OUT NOCOPY VARCHAR2
211 ,x_msg_count OUT NOCOPY NUMBER
212 ,x_msg_data OUT NOCOPY VARCHAR2
213 );
214
215 --|---------------------------------------------------
216 --| procedure name: update_item_association
217 --| description : procedure used to
218 --| update item association to
219 --| counter group or counters
220 --|---------------------------------------------------
221
222 PROCEDURE update_item_association
223 (
224 p_api_version IN NUMBER
225 ,p_commit IN VARCHAR2
226 ,p_init_msg_list IN VARCHAR2
227 ,p_validation_level IN NUMBER
228 ,p_ctr_item_associations_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec
229 ,x_return_status OUT NOCOPY VARCHAR2
230 ,x_msg_count OUT NOCOPY NUMBER
231 ,x_msg_data OUT NOCOPY VARCHAR2
232 );
233
234 --|---------------------------------------------------
235 --| procedure name: update_counter_template
236 --| description : procedure used to
237 --| update counter template
238 --|---------------------------------------------------
239
240 PROCEDURE update_counter_template
241 (
242 p_api_version IN NUMBER
243 ,p_commit IN VARCHAR2
244 ,p_init_msg_list IN VARCHAR2
245 ,p_validation_level IN NUMBER
246 ,p_counter_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec
247 ,x_return_status OUT NOCOPY VARCHAR2
248 ,x_msg_count OUT NOCOPY NUMBER
249 ,x_msg_data OUT NOCOPY VARCHAR2
250 );
251
252 --|---------------------------------------------------
253 --| procedure name: update_ctr_property_template
254 --| description : procedure used to
255 --| create counter properties
256 --|---------------------------------------------------
257
258 PROCEDURE update_ctr_property_template
259 (
260 p_api_version IN NUMBER
261 ,p_commit IN VARCHAR2
262 ,p_init_msg_list IN VARCHAR2
263 ,p_validation_level IN NUMBER
264 ,p_ctr_property_template_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec
265 ,x_return_status OUT NOCOPY VARCHAR2
266 ,x_msg_count OUT NOCOPY NUMBER
267 ,x_msg_data OUT NOCOPY VARCHAR2
268 );
269
270 --|---------------------------------------------------
271 --| procedure name: update_counter_relationship
272 --| description : procedure used to
273 --| update counter relationship
274 --|---------------------------------------------------
275
276 PROCEDURE update_counter_relationship
277 (
278 p_api_version IN NUMBER
279 ,p_commit IN VARCHAR2
280 ,p_init_msg_list IN VARCHAR2
281 ,p_validation_level IN NUMBER
282 ,p_counter_relationships_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec
283 ,x_return_status OUT NOCOPY VARCHAR2
284 ,x_msg_count OUT NOCOPY NUMBER
285 ,x_msg_data OUT NOCOPY VARCHAR2
286 );
287
288 --|---------------------------------------------------
289 --| procedure name: update_derived_filters
290 --| description : procedure used to
291 --| update derived filters
292 --|---------------------------------------------------
293
294 PROCEDURE update_derived_filters
295 (
296 p_api_version IN NUMBER
297 ,p_commit IN VARCHAR2
298 ,p_init_msg_list IN VARCHAR2
299 ,p_validation_level IN NUMBER
300 ,p_ctr_derived_filters_tbl IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
301 ,x_return_status OUT NOCOPY VARCHAR2
302 ,x_msg_count OUT NOCOPY NUMBER
303 ,x_msg_data OUT NOCOPY VARCHAR2
304 );
305
306
307 PROCEDURE Create_Estimation_Method
308 (
309 p_api_version IN NUMBER
310 ,p_init_msg_list IN VARCHAR2
311 ,p_commit IN VARCHAR2
312 ,p_validation_level IN NUMBER
313 ,x_return_status OUT NOCOPY VARCHAR2
314 ,x_msg_count OUT NOCOPY NUMBER
315 ,x_msg_data OUT NOCOPY VARCHAR2
316 ,p_ctr_estimation_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec
317 );
318
319 PROCEDURE Update_Estimation_Method
320 (
321 p_api_version IN NUMBER
322 ,p_init_msg_list IN VARCHAR2
323 ,p_commit IN VARCHAR2
324 ,p_validation_level IN NUMBER
325 ,x_return_status OUT NOCOPY VARCHAR2
326 ,x_msg_count OUT NOCOPY NUMBER
327 ,x_msg_data OUT NOCOPY VARCHAR2
328 ,p_ctr_estimation_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec
329 );
330
331 PROCEDURE Instantiate_Counters
332 (
333 p_api_version IN NUMBER
334 ,p_init_msg_list IN VARCHAR2
335 ,p_commit IN VARCHAR2
336 ,x_return_status OUT NOCOPY VARCHAR2
337 ,x_msg_count OUT NOCOPY NUMBER
338 ,x_msg_data OUT NOCOPY VARCHAR2
342 ,x_ctr_id_template OUT NOCOPY NUMBER
339 ,p_counter_id_template IN NUMBER
340 ,p_source_object_code_instance IN VARCHAR2
341 ,p_source_object_id_instance IN NUMBER
343 ,x_ctr_id_instance OUT NOCOPY NUMBER
344 ,p_maint_org_id IN NUMBER
345 ,p_primary_failure_flag IN VARCHAR2
346 );
347
348 PROCEDURE Instantiate_Grp_Counters
349 (
350 p_api_version IN NUMBER
351 ,p_init_msg_list IN VARCHAR2
352 ,p_commit IN VARCHAR2
353 ,x_return_status OUT NOCOPY VARCHAR2
354 ,x_msg_count OUT NOCOPY NUMBER
355 ,x_msg_data OUT NOCOPY VARCHAR2
356 ,p_group_id_template IN NUMBER
357 ,p_source_object_code_instance IN VARCHAR2
358 ,p_source_object_id_instance IN NUMBER
359 ,x_ctr_grp_id_instance OUT NOCOPY NUMBER
360 ,p_maint_org_id IN NUMBER
361 ,p_primary_failure_flag IN VARCHAR2
362 );
363
364 PROCEDURE delete_item_association
365 (
366 p_api_version IN NUMBER
367 ,p_commit IN VARCHAR2
368 ,p_init_msg_list IN VARCHAR2
369 ,p_validation_level IN NUMBER
370 ,p_ctr_associations_id IN NUMBER
371 ,x_return_status OUT NOCOPY VARCHAR2
372 ,x_msg_count OUT NOCOPY NUMBER
373 ,x_msg_data OUT NOCOPY VARCHAR2
374 );
375
376 END CSI_COUNTER_TEMPLATE_PVT;