[Home] [Help]
PACKAGE: APPS.CSI_CTR_DATASTRUCTURES_PUB
Source
1 PACKAGE CSI_CTR_DATASTRUCTURES_PUB AUTHID CURRENT_USER as
2 /* $Header: csitcdds.pls 120.8 2008/04/01 21:26:21 devijay ship $*/
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_CTR_DATASTRUCTURES_PUB';
5 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitctds.pls';
6
7 TYPE dff_rec_Type IS RECORD
8 (attribute_category VARCHAR2(30)
9 ,attribute1 VARCHAR2(150)
10 ,attribute2 VARCHAR2(150)
11 ,attribute3 VARCHAR2(150)
12 ,attribute4 VARCHAR2(150)
13 ,attribute5 VARCHAR2(150)
14 ,attribute6 VARCHAR2(150)
15 ,attribute7 VARCHAR2(150)
16 ,attribute8 VARCHAR2(150)
17 ,attribute9 VARCHAR2(150)
18 ,attribute10 VARCHAR2(150)
19 ,attribute11 VARCHAR2(150)
20 ,attribute12 VARCHAR2(150)
21 ,attribute13 VARCHAR2(150)
22 ,attribute14 VARCHAR2(150)
23 ,attribute15 VARCHAR2(150)
24 ,attribute16 VARCHAR2(150)
25 ,attribute17 VARCHAR2(150)
26 ,attribute18 VARCHAR2(150)
27 ,attribute19 VARCHAR2(150)
28 ,attribute20 VARCHAR2(150)
29 ,attribute21 VARCHAR2(150)
30 ,attribute22 VARCHAR2(150)
31 ,attribute23 VARCHAR2(150)
32 ,attribute24 VARCHAR2(150)
33 ,attribute25 VARCHAR2(150)
34 ,attribute26 VARCHAR2(150)
35 ,attribute27 VARCHAR2(150)
36 ,attribute28 VARCHAR2(150)
37 ,attribute29 VARCHAR2(150)
38 ,attribute30 VARCHAR2(150)
39 );
40
41 TYPE counter_groups_rec IS RECORD
42 (COUNTER_GROUP_ID NUMBER
43 ,NAME VARCHAR2(100)
44 ,DESCRIPTION VARCHAR2(240)
45 ,TEMPLATE_FLAG VARCHAR2(1)
46 -- ,CP_SERVICE_ID NUMBER(15)
47 -- ,CUSTOMER_PRODUCT_ID NUMBER(15)
48 ,LAST_UPDATE_DATE DATE
49 ,LAST_UPDATED_BY NUMBER
50 ,CREATION_DATE DATE
51 ,CREATED_BY NUMBER
52 ,LAST_UPDATE_LOGIN NUMBER
53 ,START_DATE_ACTIVE DATE
54 ,END_DATE_ACTIVE DATE
55 ,ATTRIBUTE1 VARCHAR2(150)
56 ,ATTRIBUTE2 VARCHAR2(150)
57 ,ATTRIBUTE3 VARCHAR2(150)
58 ,ATTRIBUTE4 VARCHAR2(150)
59 ,ATTRIBUTE5 VARCHAR2(150)
60 ,ATTRIBUTE6 VARCHAR2(150)
61 ,ATTRIBUTE7 VARCHAR2(150)
62 ,ATTRIBUTE8 VARCHAR2(150)
63 ,ATTRIBUTE9 VARCHAR2(150)
64 ,ATTRIBUTE10 VARCHAR2(150)
65 ,ATTRIBUTE11 VARCHAR2(150)
66 ,ATTRIBUTE12 VARCHAR2(150)
67 ,ATTRIBUTE13 VARCHAR2(150)
68 ,ATTRIBUTE14 VARCHAR2(150)
69 ,ATTRIBUTE15 VARCHAR2(150)
70 ,CONTEXT VARCHAR2(150)
71 ,OBJECT_VERSION_NUMBER NUMBER
72 ,CREATED_FROM_CTR_GRP_TMPL_ID NUMBER
73 ,ASSOCIATION_TYPE VARCHAR2(30)
74 ,SOURCE_OBJECT_CODE VARCHAR2(30)
75 ,SOURCE_OBJECT_ID NUMBER
76 ,SOURCE_COUNTER_GROUP_ID NUMBER
77 ,SECURITY_GROUP_ID NUMBER
78 ,UPGRADED_STATUS_FLAG VARCHAR2(1)
79 );
80 TYPE counter_groups_tbl IS TABLE OF counter_groups_rec INDEX BY BINARY_INTEGER;
81
82 TYPE counter_template_rec IS RECORD
83 (COUNTER_ID NUMBER
84 ,GROUP_ID NUMBER
85 ,COUNTER_TYPE VARCHAR2(30)
86 ,INITIAL_READING NUMBER
87 ,INITIAL_READING_DATE DATE
88 ,TOLERANCE_PLUS NUMBER
89 ,TOLERANCE_MINUS NUMBER
90 ,UOM_CODE VARCHAR2(3)
91 ,DERIVE_COUNTER_ID NUMBER
92 ,DERIVE_FUNCTION VARCHAR2(30)
93 ,DERIVE_PROPERTY_ID NUMBER
94 ,VALID_FLAG VARCHAR2(1)
95 ,FORMULA_INCOMPLETE_FLAG VARCHAR2(1)
96 ,FORMULA_TEXT VARCHAR2(1996)
97 ,ROLLOVER_LAST_READING NUMBER
98 ,ROLLOVER_FIRST_READING NUMBER
99 ,USAGE_ITEM_ID NUMBER
100 ,CTR_VAL_MAX_SEQ_NO NUMBER
101 ,START_DATE_ACTIVE DATE
102 ,END_DATE_ACTIVE DATE
103 ,OBJECT_VERSION_NUMBER NUMBER
104 ,LAST_UPDATE_DATE DATE
105 ,LAST_UPDATED_BY NUMBER
106 ,CREATION_DATE DATE
107 ,CREATED_BY NUMBER
108 ,LAST_UPDATE_LOGIN NUMBER
109 ,ATTRIBUTE1 VARCHAR2(150)
110 ,ATTRIBUTE2 VARCHAR2(150)
111 ,ATTRIBUTE3 VARCHAR2(150)
112 ,ATTRIBUTE4 VARCHAR2(150)
113 ,ATTRIBUTE5 VARCHAR2(150)
114 ,ATTRIBUTE6 VARCHAR2(150)
115 ,ATTRIBUTE7 VARCHAR2(150)
116 ,ATTRIBUTE8 VARCHAR2(150)
117 ,ATTRIBUTE9 VARCHAR2(150)
118 ,ATTRIBUTE10 VARCHAR2(150)
119 ,ATTRIBUTE11 VARCHAR2(150)
120 ,ATTRIBUTE12 VARCHAR2(150)
121 ,ATTRIBUTE13 VARCHAR2(150)
122 ,ATTRIBUTE14 VARCHAR2(150)
123 ,ATTRIBUTE15 VARCHAR2(150)
124 ,ATTRIBUTE16 VARCHAR2(150)
125 ,ATTRIBUTE17 VARCHAR2(150)
126 ,ATTRIBUTE18 VARCHAR2(150)
127 ,ATTRIBUTE19 VARCHAR2(150)
128 ,ATTRIBUTE20 VARCHAR2(150)
129 ,ATTRIBUTE21 VARCHAR2(150)
130 ,ATTRIBUTE22 VARCHAR2(150)
131 ,ATTRIBUTE23 VARCHAR2(150)
132 ,ATTRIBUTE24 VARCHAR2(150)
133 ,ATTRIBUTE25 VARCHAR2(150)
134 ,ATTRIBUTE26 VARCHAR2(150)
135 ,ATTRIBUTE27 VARCHAR2(150)
136 ,ATTRIBUTE28 VARCHAR2(150)
137 ,ATTRIBUTE29 VARCHAR2(150)
138 ,ATTRIBUTE30 VARCHAR2(150)
139 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
140 ,MIGRATED_FLAG VARCHAR2(1)
141 ,CUSTOMER_VIEW VARCHAR2(1)
142 ,DIRECTION VARCHAR2(1)
143 ,FILTER_TYPE VARCHAR2(30)
144 ,FILTER_READING_COUNT NUMBER
145 ,FILTER_TIME_UOM VARCHAR2(30)
146 ,ESTIMATION_ID NUMBER
147 ,READING_TYPE NUMBER
148 ,AUTOMATIC_ROLLOVER VARCHAR2(1)
149 ,DEFAULT_USAGE_RATE NUMBER
150 ,USE_PAST_READING NUMBER
151 ,USED_IN_SCHEDULING VARCHAR2(1)
152 ,DEFAULTED_GROUP_ID NUMBER
153 ,SECURITY_GROUP_ID NUMBER
154 ,NAME VARCHAR2(50)
155 ,DESCRIPTION VARCHAR2(240)
156 ,COMMENTS VARCHAR2(1996)
157 ,ASSOCIATION_TYPE VARCHAR2(30)
158 ,STEP_VALUE NUMBER
159 ,TIME_BASED_MANUAL_ENTRY VARCHAR2(1)
160 ,EAM_REQUIRED_FLAG VARCHAR2(1)
161 );
162 TYPE counter_template_tbl IS TABLE OF counter_template_rec INDEX BY BINARY_INTEGER;
163
164 TYPE ctr_item_associations_rec IS RECORD
165 (CTR_ASSOCIATION_ID NUMBER
166 ,GROUP_ID NUMBER
167 ,INVENTORY_ITEM_ID NUMBER
168 ,OBJECT_VERSION_NUMBER NUMBER
169 ,LAST_UPDATE_DATE DATE
170 ,LAST_UPDATED_BY NUMBER
171 ,LAST_UPDATE_LOGIN NUMBER
172 ,CREATION_DATE DATE
173 ,CREATED_BY NUMBER
174 ,ATTRIBUTE1 VARCHAR2(150)
175 ,ATTRIBUTE2 VARCHAR2(150)
176 ,ATTRIBUTE3 VARCHAR2(150)
177 ,ATTRIBUTE4 VARCHAR2(150)
178 ,ATTRIBUTE5 VARCHAR2(150)
179 ,ATTRIBUTE6 VARCHAR2(150)
180 ,ATTRIBUTE7 VARCHAR2(150)
181 ,ATTRIBUTE8 VARCHAR2(150)
182 ,ATTRIBUTE9 VARCHAR2(150)
183 ,ATTRIBUTE10 VARCHAR2(150)
184 ,ATTRIBUTE11 VARCHAR2(150)
185 ,ATTRIBUTE12 VARCHAR2(150)
186 ,ATTRIBUTE13 VARCHAR2(150)
187 ,ATTRIBUTE14 VARCHAR2(150)
188 ,ATTRIBUTE15 VARCHAR2(150)
189 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
190 ,SECURITY_GROUP_ID NUMBER
191 ,MIGRATED_FLAG VARCHAR2(1)
192 ,COUNTER_ID NUMBER
193 ,START_DATE_ACTIVE DATE
194 ,END_DATE_ACTIVE DATE
195 ,USAGE_RATE NUMBER
196 ,USE_PAST_READING NUMBER
197 ,ASSOCIATED_TO_GROUP VARCHAR2(1)
198 ,MAINT_ORGANIZATION_ID NUMBER
199 ,PRIMARY_FAILURE_FLAG VARCHAR2(1)
200 );
201 TYPE ctr_item_associations_tbl IS TABLE OF ctr_item_associations_rec INDEX BY BINARY_INTEGER;
202
203 TYPE counter_relationships_rec IS RECORD
204 (RELATIONSHIP_ID NUMBER
205 ,CTR_ASSOCIATION_ID NUMBER
206 ,RELATIONSHIP_TYPE_CODE VARCHAR2(30)
207 ,SOURCE_COUNTER_ID NUMBER
208 ,OBJECT_COUNTER_ID NUMBER
209 ,ACTIVE_START_DATE DATE
210 ,ACTIVE_END_DATE DATE
211 ,OBJECT_VERSION_NUMBER NUMBER
212 ,LAST_UPDATE_DATE DATE
213 ,LAST_UPDATED_BY NUMBER
214 ,CREATION_DATE DATE
215 ,CREATED_BY NUMBER
216 ,LAST_UPDATE_LOGIN NUMBER
217 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
218 ,ATTRIBUTE1 VARCHAR2(150)
219 ,ATTRIBUTE2 VARCHAR2(150)
220 ,ATTRIBUTE3 VARCHAR2(150)
221 ,ATTRIBUTE4 VARCHAR2(150)
222 ,ATTRIBUTE5 VARCHAR2(150)
223 ,ATTRIBUTE6 VARCHAR2(150)
224 ,ATTRIBUTE7 VARCHAR2(150)
225 ,ATTRIBUTE8 VARCHAR2(150)
226 ,ATTRIBUTE9 VARCHAR2(150)
227 ,ATTRIBUTE10 VARCHAR2(150)
228 ,ATTRIBUTE11 VARCHAR2(150)
229 ,ATTRIBUTE12 VARCHAR2(150)
230 ,ATTRIBUTE13 VARCHAR2(150)
231 ,ATTRIBUTE14 VARCHAR2(150)
232 ,ATTRIBUTE15 VARCHAR2(150)
233 ,SECURITY_GROUP_ID NUMBER
234 ,MIGRATED_FLAG VARCHAR2(1)
235 ,BIND_VARIABLE_NAME VARCHAR2(30)
236 ,FACTOR NUMBER
237 );
238 TYPE counter_relationships_tbl IS TABLE OF counter_relationships_rec INDEX BY BINARY_INTEGER;
239
240 TYPE ctr_property_template_rec IS RECORD
241 (COUNTER_PROPERTY_ID NUMBER
242 ,COUNTER_ID NUMBER
243 ,PROPERTY_DATA_TYPE VARCHAR2(30)
244 ,IS_NULLABLE VARCHAR2(1)
245 ,DEFAULT_VALUE VARCHAR2(240)
246 ,MINIMUM_VALUE VARCHAR2(240)
247 ,MAXIMUM_VALUE VARCHAR2(240)
248 ,UOM_CODE VARCHAR2(3)
249 ,START_DATE_ACTIVE DATE
250 ,END_DATE_ACTIVE DATE
251 ,OBJECT_VERSION_NUMBER NUMBER
252 ,LAST_UPDATE_DATE DATE
253 ,LAST_UPDATED_BY NUMBER
254 ,CREATION_DATE DATE
255 ,CREATED_BY NUMBER
256 ,LAST_UPDATE_LOGIN NUMBER
257 ,ATTRIBUTE1 VARCHAR2(150)
258 ,ATTRIBUTE2 VARCHAR2(150)
259 ,ATTRIBUTE3 VARCHAR2(150)
260 ,ATTRIBUTE4 VARCHAR2(150)
261 ,ATTRIBUTE5 VARCHAR2(150)
262 ,ATTRIBUTE6 VARCHAR2(150)
263 ,ATTRIBUTE7 VARCHAR2(150)
264 ,ATTRIBUTE8 VARCHAR2(150)
265 ,ATTRIBUTE9 VARCHAR2(150)
266 ,ATTRIBUTE10 VARCHAR2(150)
267 ,ATTRIBUTE11 VARCHAR2(150)
268 ,ATTRIBUTE12 VARCHAR2(150)
269 ,ATTRIBUTE13 VARCHAR2(150)
270 ,ATTRIBUTE14 VARCHAR2(150)
271 ,ATTRIBUTE15 VARCHAR2(150)
272 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
273 ,MIGRATED_FLAG VARCHAR2(1)
274 ,PROPERTY_LOV_TYPE VARCHAR2(30)
275 ,SECURITY_GROUP_ID NUMBER
276 ,NAME VARCHAR2(50)
277 ,DESCRIPTION VARCHAR2(240)
278 );
279 TYPE ctr_property_template_tbl IS TABLE OF ctr_property_template_rec INDEX BY BINARY_INTEGER;
280
281 TYPE ctr_estimation_methods_rec IS RECORD
282 (ESTIMATION_ID NUMBER
283 ,ESTIMATION_TYPE VARCHAR2(10)
284 ,FIXED_VALUE NUMBER
285 ,USAGE_MARKUP NUMBER
286 ,DEFAULT_VALUE NUMBER
287 ,ESTIMATION_AVG_TYPE VARCHAR2(10)
288 ,START_DATE_ACTIVE DATE
289 ,END_DATE_ACTIVE DATE
290 ,LAST_UPDATE_DATE DATE
291 ,LAST_UPDATED_BY NUMBER
292 ,CREATION_DATE DATE
293 ,CREATED_BY NUMBER
294 ,LAST_UPDATE_LOGIN NUMBER
295 ,ATTRIBUTE1 VARCHAR2(150)
296 ,ATTRIBUTE2 VARCHAR2(150)
297 ,ATTRIBUTE3 VARCHAR2(150)
298 ,ATTRIBUTE4 VARCHAR2(150)
299 ,ATTRIBUTE5 VARCHAR2(150)
300 ,ATTRIBUTE6 VARCHAR2(150)
301 ,ATTRIBUTE7 VARCHAR2(150)
302 ,ATTRIBUTE8 VARCHAR2(150)
303 ,ATTRIBUTE9 VARCHAR2(150)
304 ,ATTRIBUTE10 VARCHAR2(150)
305 ,ATTRIBUTE11 VARCHAR2(150)
306 ,ATTRIBUTE12 VARCHAR2(150)
307 ,ATTRIBUTE13 VARCHAR2(150)
308 ,ATTRIBUTE14 VARCHAR2(150)
309 ,ATTRIBUTE15 VARCHAR2(150)
310 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
311 ,OBJECT_VERSION_NUMBER NUMBER
312 ,MIGRATED_FLAG VARCHAR2(1)
313 ,NAME VARCHAR2(50)
314 ,DESCRIPTION VARCHAR2(240)
315 );
316 TYPE ctr_estimation_methods_tbl IS TABLE OF ctr_estimation_methods_rec INDEX BY BINARY_INTEGER;
317
318 TYPE ctr_derived_filters_rec IS RECORD
319 (COUNTER_DERIVED_FILTER_ID NUMBER
320 ,COUNTER_ID NUMBER
321 ,SEQ_NO NUMBER
322 ,LEFT_PARENT VARCHAR2(30)
323 ,COUNTER_PROPERTY_ID NUMBER
324 ,RELATIONAL_OPERATOR VARCHAR2(30)
325 ,RIGHT_VALUE VARCHAR2(240)
326 ,RIGHT_PARENT VARCHAR2(30)
327 ,LOGICAL_OPERATOR VARCHAR2(30)
328 ,START_DATE_ACTIVE DATE
329 ,END_DATE_ACTIVE DATE
330 ,OBJECT_VERSION_NUMBER NUMBER
331 ,LAST_UPDATE_DATE DATE
332 ,LAST_UPDATED_BY NUMBER
333 ,CREATION_DATE DATE
334 ,CREATED_BY NUMBER
335 ,LAST_UPDATE_LOGIN NUMBER
336 ,ATTRIBUTE1 VARCHAR2(150)
337 ,ATTRIBUTE2 VARCHAR2(150)
341 ,ATTRIBUTE6 VARCHAR2(150)
338 ,ATTRIBUTE3 VARCHAR2(150)
339 ,ATTRIBUTE4 VARCHAR2(150)
340 ,ATTRIBUTE5 VARCHAR2(150)
342 ,ATTRIBUTE7 VARCHAR2(150)
343 ,ATTRIBUTE8 VARCHAR2(150)
344 ,ATTRIBUTE9 VARCHAR2(150)
345 ,ATTRIBUTE10 VARCHAR2(150)
346 ,ATTRIBUTE11 VARCHAR2(150)
347 ,ATTRIBUTE12 VARCHAR2(150)
348 ,ATTRIBUTE13 VARCHAR2(150)
349 ,ATTRIBUTE14 VARCHAR2(150)
350 ,ATTRIBUTE15 VARCHAR2(150)
351 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
352 ,SECURITY_GROUP_ID NUMBER
353 ,MIGRATED_FLAG VARCHAR2(1)
354 );
355 TYPE ctr_derived_filters_tbl IS TABLE OF ctr_derived_filters_rec INDEX BY BINARY_INTEGER;
356
357
358 TYPE counter_instance_rec IS RECORD
359 (COUNTER_ID NUMBER
360 ,GROUP_ID NUMBER
361 ,COUNTER_TYPE VARCHAR2(30)
362 ,INITIAL_READING NUMBER
363 ,INITIAL_READING_DATE DATE
364 ,CREATED_FROM_COUNTER_TMPL_ID NUMBER
365 ,TOLERANCE_PLUS NUMBER
366 ,TOLERANCE_MINUS NUMBER
367 ,UOM_CODE VARCHAR2(3)
368 ,DERIVE_COUNTER_ID NUMBER
369 ,DERIVE_FUNCTION VARCHAR2(30)
370 ,DERIVE_PROPERTY_ID NUMBER
371 ,VALID_FLAG VARCHAR2(1)
372 ,FORMULA_INCOMPLETE_FLAG VARCHAR2(1)
373 ,FORMULA_TEXT VARCHAR2(1996)
374 ,ROLLOVER_LAST_READING NUMBER
375 ,ROLLOVER_FIRST_READING NUMBER
376 ,USAGE_ITEM_ID NUMBER
377 ,CTR_VAL_MAX_SEQ_NO NUMBER
378 ,START_DATE_ACTIVE DATE
379 ,END_DATE_ACTIVE DATE
380 ,OBJECT_VERSION_NUMBER NUMBER
381 ,LAST_UPDATE_DATE DATE
382 ,LAST_UPDATED_BY NUMBER
383 ,CREATION_DATE DATE
384 ,CREATED_BY NUMBER
385 ,LAST_UPDATE_LOGIN NUMBER
386 ,ATTRIBUTE1 VARCHAR2(150)
387 ,ATTRIBUTE2 VARCHAR2(150)
388 ,ATTRIBUTE3 VARCHAR2(150)
389 ,ATTRIBUTE4 VARCHAR2(150)
390 ,ATTRIBUTE5 VARCHAR2(150)
391 ,ATTRIBUTE6 VARCHAR2(150)
392 ,ATTRIBUTE7 VARCHAR2(150)
393 ,ATTRIBUTE8 VARCHAR2(150)
394 ,ATTRIBUTE9 VARCHAR2(150)
395 ,ATTRIBUTE10 VARCHAR2(150)
396 ,ATTRIBUTE11 VARCHAR2(150)
397 ,ATTRIBUTE12 VARCHAR2(150)
398 ,ATTRIBUTE13 VARCHAR2(150)
399 ,ATTRIBUTE14 VARCHAR2(150)
400 ,ATTRIBUTE15 VARCHAR2(150)
401 ,ATTRIBUTE16 VARCHAR2(150)
402 ,ATTRIBUTE17 VARCHAR2(150)
403 ,ATTRIBUTE18 VARCHAR2(150)
404 ,ATTRIBUTE19 VARCHAR2(150)
405 ,ATTRIBUTE20 VARCHAR2(150)
406 ,ATTRIBUTE21 VARCHAR2(150)
407 ,ATTRIBUTE22 VARCHAR2(150)
408 ,ATTRIBUTE23 VARCHAR2(150)
409 ,ATTRIBUTE24 VARCHAR2(150)
410 ,ATTRIBUTE25 VARCHAR2(150)
411 ,ATTRIBUTE26 VARCHAR2(150)
412 ,ATTRIBUTE27 VARCHAR2(150)
413 ,ATTRIBUTE28 VARCHAR2(150)
414 ,ATTRIBUTE29 VARCHAR2(150)
415 ,ATTRIBUTE30 VARCHAR2(150)
416 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
417 ,MIGRATED_FLAG VARCHAR2(1)
418 ,CUSTOMER_VIEW VARCHAR2(1)
419 ,DIRECTION VARCHAR2(1)
420 ,FILTER_TYPE VARCHAR2(30)
421 ,FILTER_READING_COUNT NUMBER
422 ,FILTER_TIME_UOM VARCHAR2(30)
423 ,ESTIMATION_ID NUMBER
424 ,READING_TYPE NUMBER
425 ,AUTOMATIC_ROLLOVER VARCHAR2(1)
426 ,DEFAULT_USAGE_RATE NUMBER
427 ,USE_PAST_READING NUMBER
428 ,USED_IN_SCHEDULING VARCHAR2(1)
429 ,DEFAULTED_GROUP_ID NUMBER
430 ,SECURITY_GROUP_ID NUMBER
431 ,NAME VARCHAR2(50)
432 ,DESCRIPTION VARCHAR2(240)
433 ,COMMENTS VARCHAR2(1996)
434 ,STEP_VALUE NUMBER
435 ,TIME_BASED_MANUAL_ENTRY VARCHAR2(1)
436 ,EAM_REQUIRED_FLAG VARCHAR2(1)
437 );
438 TYPE counter_instance_tbl IS TABLE OF counter_instance_rec INDEX BY BINARY_INTEGER;
439
440
441 TYPE ctr_properties_rec IS RECORD
442 (COUNTER_PROPERTY_ID NUMBER
443 ,COUNTER_ID NUMBER
444 ,PROPERTY_DATA_TYPE VARCHAR2(30)
445 ,IS_NULLABLE VARCHAR2(1)
449 ,UOM_CODE VARCHAR2(3)
446 ,DEFAULT_VALUE VARCHAR2(240)
447 ,MINIMUM_VALUE VARCHAR2(240)
448 ,MAXIMUM_VALUE VARCHAR2(240)
450 ,START_DATE_ACTIVE DATE
451 ,END_DATE_ACTIVE DATE
452 ,OBJECT_VERSION_NUMBER NUMBER
453 ,LAST_UPDATE_DATE DATE
454 ,LAST_UPDATED_BY NUMBER
455 ,CREATION_DATE DATE
456 ,CREATED_BY NUMBER
457 ,LAST_UPDATE_LOGIN NUMBER
458 ,ATTRIBUTE1 VARCHAR2(150)
459 ,ATTRIBUTE2 VARCHAR2(150)
460 ,ATTRIBUTE3 VARCHAR2(150)
461 ,ATTRIBUTE4 VARCHAR2(150)
462 ,ATTRIBUTE5 VARCHAR2(150)
463 ,ATTRIBUTE6 VARCHAR2(150)
464 ,ATTRIBUTE7 VARCHAR2(150)
465 ,ATTRIBUTE8 VARCHAR2(150)
466 ,ATTRIBUTE9 VARCHAR2(150)
467 ,ATTRIBUTE10 VARCHAR2(150)
468 ,ATTRIBUTE11 VARCHAR2(150)
469 ,ATTRIBUTE12 VARCHAR2(150)
470 ,ATTRIBUTE13 VARCHAR2(150)
471 ,ATTRIBUTE14 VARCHAR2(150)
472 ,ATTRIBUTE15 VARCHAR2(150)
473 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
474 ,MIGRATED_FLAG VARCHAR2(1)
475 ,PROPERTY_LOV_TYPE VARCHAR2(30)
476 ,CREATED_FROM_CTR_PROP_TMPL_ID NUMBER
477 ,SECURITY_GROUP_ID NUMBER
478 ,NAME VARCHAR2(50)
479 ,DESCRIPTION VARCHAR2(240)
480 );
481 TYPE ctr_properties_tbl IS TABLE OF ctr_properties_rec INDEX BY BINARY_INTEGER;
482
483 TYPE counter_associations_rec IS RECORD
484 (INSTANCE_ASSOCIATION_ID NUMBER
485 ,SOURCE_OBJECT_CODE VARCHAR2(30)
486 ,SOURCE_OBJECT_ID NUMBER
487 ,OBJECT_VERSION_NUMBER NUMBER
488 ,LAST_UPDATE_DATE DATE
489 ,LAST_UPDATED_BY NUMBER
490 ,LAST_UPDATE_LOGIN NUMBER
491 ,CREATION_DATE DATE
492 ,CREATED_BY NUMBER
493 ,ATTRIBUTE1 VARCHAR2(150)
494 ,ATTRIBUTE2 VARCHAR2(150)
495 ,ATTRIBUTE3 VARCHAR2(150)
496 ,ATTRIBUTE4 VARCHAR2(150)
497 ,ATTRIBUTE5 VARCHAR2(150)
498 ,ATTRIBUTE6 VARCHAR2(150)
499 ,ATTRIBUTE7 VARCHAR2(150)
500 ,ATTRIBUTE8 VARCHAR2(150)
501 ,ATTRIBUTE9 VARCHAR2(150)
502 ,ATTRIBUTE10 VARCHAR2(150)
503 ,ATTRIBUTE11 VARCHAR2(150)
504 ,ATTRIBUTE12 VARCHAR2(150)
505 ,ATTRIBUTE13 VARCHAR2(150)
506 ,ATTRIBUTE14 VARCHAR2(150)
507 ,ATTRIBUTE15 VARCHAR2(150)
508 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
509 ,SECURITY_GROUP_ID NUMBER
510 ,MIGRATED_FLAG VARCHAR2(1)
511 ,COUNTER_ID NUMBER
512 ,START_DATE_ACTIVE DATE
513 ,END_DATE_ACTIVE DATE
514 ,MAINT_ORGANIZATION_ID NUMBER
515 ,PRIMARY_FAILURE_FLAG VARCHAR2(1)
516 );
517 TYPE counter_associations_tbl IS TABLE OF counter_associations_rec INDEX BY BINARY_INTEGER;
518
519 TYPE counter_readings_rec IS RECORD
520 (COUNTER_VALUE_ID NUMBER
521 ,COUNTER_ID NUMBER
522 ,VALUE_TIMESTAMP DATE
523 ,COUNTER_READING NUMBER
524 ,RESET_MODE VARCHAR2(30)
525 ,RESET_REASON VARCHAR2(255)
526 ,ADJUSTMENT_TYPE VARCHAR2(30)
527 ,ADJUSTMENT_READING NUMBER
528 ,OBJECT_VERSION_NUMBER NUMBER
529 ,LAST_UPDATE_DATE DATE
530 ,LAST_UPDATED_BY NUMBER
531 ,CREATION_DATE DATE
532 ,CREATED_BY NUMBER
533 ,LAST_UPDATE_LOGIN NUMBER
534 ,ATTRIBUTE1 VARCHAR2(150)
535 ,ATTRIBUTE2 VARCHAR2(150)
536 ,ATTRIBUTE3 VARCHAR2(150)
537 ,ATTRIBUTE4 VARCHAR2(150)
538 ,ATTRIBUTE5 VARCHAR2(150)
539 ,ATTRIBUTE6 VARCHAR2(150)
540 ,ATTRIBUTE7 VARCHAR2(150)
541 ,ATTRIBUTE8 VARCHAR2(150)
542 ,ATTRIBUTE9 VARCHAR2(150)
543 ,ATTRIBUTE10 VARCHAR2(150)
544 ,ATTRIBUTE11 VARCHAR2(150)
545 ,ATTRIBUTE12 VARCHAR2(150)
546 ,ATTRIBUTE13 VARCHAR2(150)
547 ,ATTRIBUTE14 VARCHAR2(150)
548 ,ATTRIBUTE15 VARCHAR2(150)
549 ,ATTRIBUTE16 VARCHAR2(150)
550 ,ATTRIBUTE17 VARCHAR2(150)
551 ,ATTRIBUTE18 VARCHAR2(150)
552 ,ATTRIBUTE19 VARCHAR2(150)
553 ,ATTRIBUTE20 VARCHAR2(150)
557 ,ATTRIBUTE24 VARCHAR2(150)
554 ,ATTRIBUTE21 VARCHAR2(150)
555 ,ATTRIBUTE22 VARCHAR2(150)
556 ,ATTRIBUTE23 VARCHAR2(150)
558 ,ATTRIBUTE25 VARCHAR2(150)
559 ,ATTRIBUTE26 VARCHAR2(150)
560 ,ATTRIBUTE27 VARCHAR2(150)
561 ,ATTRIBUTE28 VARCHAR2(150)
562 ,ATTRIBUTE29 VARCHAR2(150)
563 ,ATTRIBUTE30 VARCHAR2(150)
564 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
565 ,MIGRATED_FLAG VARCHAR2(1)
566 ,COMMENTS VARCHAR2(2000)
567 ,LIFE_TO_DATE_READING NUMBER
568 ,TRANSACTION_ID NUMBER
569 ,AUTOMATIC_ROLLOVER_FLAG VARCHAR2(1)
570 ,INCLUDE_TARGET_RESETS VARCHAR2(1)
571 ,SOURCE_COUNTER_VALUE_ID NUMBER
572 ,RESET_COUNTER_READING NUMBER
573 ,NET_READING NUMBER
574 ,DISABLED_FLAG VARCHAR2(1)
575 ,SOURCE_CODE VARCHAR2(30)
576 ,SOURCE_LINE_ID NUMBER
577 ,SECURITY_GROUP_ID NUMBER
578 ,PARENT_TBL_INDEX NUMBER
579 ,INITIAL_READING_FLAG VARCHAR2(1)
580 );
581 TYPE counter_readings_tbl IS TABLE OF counter_readings_rec INDEX BY BINARY_INTEGER;
582
583 TYPE ctr_property_readings_rec IS RECORD
584 (COUNTER_PROP_VALUE_ID NUMBER
585 ,COUNTER_VALUE_ID NUMBER
586 ,COUNTER_PROPERTY_ID NUMBER
587 ,PROPERTY_VALUE VARCHAR2(240)
588 ,VALUE_TIMESTAMP DATE
589 ,OBJECT_VERSION_NUMBER NUMBER
590 ,LAST_UPDATE_DATE DATE
591 ,LAST_UPDATED_BY NUMBER
592 ,CREATION_DATE DATE
593 ,CREATED_BY NUMBER
594 ,LAST_UPDATE_LOGIN NUMBER
595 ,ATTRIBUTE1 VARCHAR2(150)
596 ,ATTRIBUTE2 VARCHAR2(150)
597 ,ATTRIBUTE3 VARCHAR2(150)
598 ,ATTRIBUTE4 VARCHAR2(150)
599 ,ATTRIBUTE5 VARCHAR2(150)
600 ,ATTRIBUTE6 VARCHAR2(150)
601 ,ATTRIBUTE7 VARCHAR2(150)
602 ,ATTRIBUTE8 VARCHAR2(150)
603 ,ATTRIBUTE9 VARCHAR2(150)
604 ,ATTRIBUTE10 VARCHAR2(150)
605 ,ATTRIBUTE11 VARCHAR2(150)
606 ,ATTRIBUTE12 VARCHAR2(150)
607 ,ATTRIBUTE13 VARCHAR2(150)
608 ,ATTRIBUTE14 VARCHAR2(150)
609 ,ATTRIBUTE15 VARCHAR2(150)
610 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
611 ,MIGRATED_FLAG VARCHAR2(1)
612 ,SECURITY_GROUP_ID NUMBER
613 ,PARENT_TBL_INDEX NUMBER
614 );
615 TYPE ctr_property_readings_tbl IS TABLE OF ctr_property_readings_rec INDEX BY BINARY_INTEGER;
616
617
618 TYPE ctr_usage_forecast_rec IS RECORD
619 (INSTANCE_FORECAST_ID NUMBER
620 ,COUNTER_ID NUMBER
621 ,USAGE_RATE NUMBER
622 ,USE_PAST_READING NUMBER
623 ,ACTIVE_START_DATE DATE
624 ,ACTIVE_END_DATE DATE
625 ,OBJECT_VERSION_NUMBER NUMBER
626 ,LAST_UPDATE_DATE DATE
627 ,LAST_UPDATED_BY NUMBER
628 ,CREATION_DATE DATE
629 ,CREATED_BY NUMBER
630 ,LAST_UPDATE_LOGIN NUMBER
631 );
632 TYPE ctr_usage_forecast_tbl IS TABLE OF ctr_usage_forecast_rec INDEX BY BINARY_INTEGER;
633
634 TYPE ctr_reading_lock_rec IS RECORD
635 (READING_LOCK_ID NUMBER
636 ,COUNTER_ID NUMBER
637 ,READING_LOCK_DATE DATE
638 ,ACTIVE_START_DATE DATE
639 ,ACTIVE_END_DATE DATE
640 ,OBJECT_VERSION_NUMBER NUMBER
641 ,LAST_UPDATE_DATE DATE
642 ,LAST_UPDATED_BY NUMBER
643 ,CREATION_DATE DATE
644 ,CREATED_BY NUMBER
645 ,LAST_UPDATE_LOGIN NUMBER
646 ,SOURCE_GROUP_REF_ID NUMBER
647 ,SOURCE_GROUP_REF VARCHAR2(50)
648 ,SOURCE_HEADER_REF_ID NUMBER
649 ,SOURCE_HEADER_REF VARCHAR2(50)
650 ,SOURCE_LINE_REF_ID NUMBER
651 ,SOURCE_LINE_REF VARCHAR2(50)
652 ,SOURCE_DIST_REF_ID1 NUMBER
653 ,SOURCE_DIST_REF_ID2 NUMBER
654 );
655
656
657 TYPE ctr_reading_lock_tbl IS TABLE OF ctr_reading_lock_rec INDEX BY BINARY_INTEGER;
658
659 TYPE ctr_estimated_readings_rec IS RECORD
660 (ESTIMATED_READING_ID NUMBER
661 ,COUNTER_ID NUMBER
662 ,ESTIMATION_ID NUMBER
663 ,VALUE_TIMESTAMP DATE
664 ,ESTIMATED_METER_READING NUMBER
665 ,NUM_OF_READINGS NUMBER
666 ,PERIOD_START_DATE DATE
667 ,PERIOD_END_DATE DATE
668 ,AVG_CALCULATION_START_DATE DATE
669 ,ESTIMATED_USAGE NUMBER
673 ,ATTRIBUTE4 VARCHAR2(150)
670 ,ATTRIBUTE1 VARCHAR2(150)
671 ,ATTRIBUTE2 VARCHAR2(150)
672 ,ATTRIBUTE3 VARCHAR2(150)
674 ,ATTRIBUTE5 VARCHAR2(150)
675 ,ATTRIBUTE6 VARCHAR2(150)
676 ,ATTRIBUTE7 VARCHAR2(150)
677 ,ATTRIBUTE8 VARCHAR2(150)
678 ,ATTRIBUTE9 VARCHAR2(150)
679 ,ATTRIBUTE10 VARCHAR2(150)
680 ,ATTRIBUTE11 VARCHAR2(150)
681 ,ATTRIBUTE12 VARCHAR2(150)
682 ,ATTRIBUTE13 VARCHAR2(150)
683 ,ATTRIBUTE14 VARCHAR2(150)
684 ,ATTRIBUTE15 VARCHAR2(150)
685 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
686 ,LAST_UPDATE_DATE DATE
687 ,LAST_UPDATED_BY NUMBER
688 ,LAST_UPDATE_LOGIN NUMBER
689 ,CREATION_DATE DATE
690 ,CREATED_BY NUMBER
691 ,OBJECT_VERSION_NUMBER VARCHAR2(240)
692 ,MIGRATED_FLAG VARCHAR2(1)
693 );
694 TYPE ctr_estimated_readings_tbl IS TABLE OF ctr_estimated_readings_rec INDEX BY BINARY_INTEGER;
695
696 TYPE ctr_readings_interface_rec IS RECORD
697 (COUNTER_INTERFACE_ID NUMBER
698 ,PARALLEL_WORKER_ID NUMBER
699 ,BATCH_NAME VARCHAR2(30)
700 ,SOURCE_TRANSACTION_DATE DATE
701 ,PROCESS_STATUS VARCHAR2(1)
702 ,ERROR_TEXT VARCHAR2(240)
703 ,COUNTER_VALUE_ID NUMBER
704 ,COUNTER_ID NUMBER
705 ,VALUE_TIMESTAMP DATE
706 ,COUNTER_READING NUMBER
707 ,RESET_MODE VARCHAR2(30)
708 ,RESET_REASON VARCHAR2(255)
709 ,ADJUSTMENT_TYPE VARCHAR2(30)
710 ,ADJUSTMENT_READING NUMBER
711 ,NET_READING NUMBER
712 ,LIFE_TO_DATE_READING NUMBER
713 ,AUTOMATIC_ROLLOVER_FLAG VARCHAR2(1)
714 ,INCLUDE_TARGET_RESETS VARCHAR2(1)
715 ,SOURCE_COUNTER_VALUE_ID NUMBER
716 ,DISABLED_FLAG VARCHAR2(1)
717 ,COMMENTS VARCHAR2(2000)
718 ,SECURITY_GROUP_ID NUMBER
719 ,OBJECT_VERSION_NUMBER NUMBER
720 ,LAST_UPDATE_DATE DATE
721 ,LAST_UPDATED_BY NUMBER
722 ,CREATION_DATE DATE
723 ,CREATED_BY NUMBER
724 ,LAST_UPDATE_LOGIN NUMBER
725 ,ATTRIBUTE1 VARCHAR2(150)
726 ,ATTRIBUTE2 VARCHAR2(150)
727 ,ATTRIBUTE3 VARCHAR2(150)
728 ,ATTRIBUTE4 VARCHAR2(150)
729 ,ATTRIBUTE5 VARCHAR2(150)
730 ,ATTRIBUTE6 VARCHAR2(150)
731 ,ATTRIBUTE7 VARCHAR2(150)
732 ,ATTRIBUTE8 VARCHAR2(150)
733 ,ATTRIBUTE9 VARCHAR2(150)
734 ,ATTRIBUTE10 VARCHAR2(150)
735 ,ATTRIBUTE11 VARCHAR2(150)
736 ,ATTRIBUTE12 VARCHAR2(150)
737 ,ATTRIBUTE13 VARCHAR2(150)
738 ,ATTRIBUTE14 VARCHAR2(150)
739 ,ATTRIBUTE15 VARCHAR2(150)
740 ,ATTRIBUTE16 VARCHAR2(150)
741 ,ATTRIBUTE17 VARCHAR2(150)
742 ,ATTRIBUTE18 VARCHAR2(150)
743 ,ATTRIBUTE19 VARCHAR2(150)
744 ,ATTRIBUTE20 VARCHAR2(150)
745 ,ATTRIBUTE21 VARCHAR2(150)
746 ,ATTRIBUTE22 VARCHAR2(150)
747 ,ATTRIBUTE23 VARCHAR2(150)
748 ,ATTRIBUTE24 VARCHAR2(150)
749 ,ATTRIBUTE25 VARCHAR2(150)
750 ,ATTRIBUTE26 VARCHAR2(150)
751 ,ATTRIBUTE27 VARCHAR2(150)
752 ,ATTRIBUTE28 VARCHAR2(150)
753 ,ATTRIBUTE29 VARCHAR2(150)
754 ,ATTRIBUTE30 VARCHAR2(150)
755 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
756 ,SOURCE_TRANSACTION_TYPE_ID NUMBER
757 ,SOURCE_TRANSACTION_ID NUMBER
758 ,SOURCE_CODE VARCHAR2(30)
759 ,SOURCE_LINE_ID NUMBER
760 ,RESET_COUNTER_READING NUMBER
761 ,COUNTER_NAME VARCHAR2(30)
762 );
763 TYPE ctr_readings_interface_tbl IS TABLE OF ctr_readings_interface_rec INDEX BY BINARY_INTEGER;
764
765 TYPE ctr_read_prop_interface_rec IS RECORD
766 (COUNTER_INTERFACE_ID NUMBER
767 ,PARALLEL_WORKER_ID NUMBER
768 ,ERROR_TEXT VARCHAR2(240)
769 ,COUNTER_PROP_VALUE_ID NUMBER
770 ,COUNTER_VALUE_ID NUMBER
771 ,COUNTER_PROPERTY_ID NUMBER
772 ,PROPERTY_VALUE VARCHAR2(240)
773 ,VALUE_TIMESTAMP DATE
774 ,OBJECT_VERSION_NUMBER NUMBER
775 ,LAST_UPDATE_DATE DATE
776 ,LAST_UPDATED_BY NUMBER
777 ,CREATION_DATE DATE
781 ,ATTRIBUTE2 VARCHAR2(150)
778 ,CREATED_BY NUMBER
779 ,LAST_UPDATE_LOGIN NUMBER
780 ,ATTRIBUTE1 VARCHAR2(150)
782 ,ATTRIBUTE3 VARCHAR2(150)
783 ,ATTRIBUTE4 VARCHAR2(150)
784 ,ATTRIBUTE5 VARCHAR2(150)
785 ,ATTRIBUTE6 VARCHAR2(150)
786 ,ATTRIBUTE7 VARCHAR2(150)
787 ,ATTRIBUTE8 VARCHAR2(150)
788 ,ATTRIBUTE9 VARCHAR2(150)
789 ,ATTRIBUTE10 VARCHAR2(150)
790 ,ATTRIBUTE11 VARCHAR2(150)
791 ,ATTRIBUTE12 VARCHAR2(150)
792 ,ATTRIBUTE13 VARCHAR2(150)
793 ,ATTRIBUTE14 VARCHAR2(150)
794 ,ATTRIBUTE15 VARCHAR2(150)
795 ,ATTRIBUTE_CATEGORY VARCHAR2(30)
796 );
797 TYPE ctr_read_prop_interface_tbl IS TABLE OF ctr_read_prop_interface_rec INDEX BY BINARY_INTEGER;
798
799 TYPE Ctr_Rec_Type IS RECORD
800 (
801 ctr_tbl_index NUMBER
802 ,counter_group_id NUMBER
803 ,name VARCHAR2(30)
804 ,description VARCHAR2(240)
805 ,type VARCHAR2(30)
806 ,step_value NUMBER
807 ,initial_reading NUMBER
808 ,rollover_last_reading NUMBER
809 ,rollover_first_reading NUMBER
810 ,uom_code VARCHAR2(3)
811 ,tolerance_plus NUMBER
812 ,tolerance_minus NUMBER
813 ,derive_function VARCHAR2(30)
814 ,derive_counter_id NUMBER
815 ,derive_property_id NUMBER
816 ,formula_text VARCHAR2(1996)
817 ,comments VARCHAR2(1996)
818 ,usage_item_id NUMBER
819 ,start_date_active DATE
820 ,end_date_active DATE
821 ,desc_flex DFF_Rec_Type
822 ,customer_view VARCHAR2(1)
823 ,direction VARCHAR2(1)
824 ,filter_reading_count NUMBER
825 ,filter_type VARCHAR2(30)
826 ,filter_time_uom VARCHAR2(30)
827 ,estimation_id NUMBER
828 );
829
830 TYPE Ctr_Prop_Rec_Type IS RECORD
831 (
832 ctr_tbl_index NUMBER
833 ,counter_id NUMBER
834 ,name VARCHAR2(30)
835 ,description VARCHAR2(240)
836 ,property_data_type VARCHAR2(30)
837 ,is_nullable VARCHAR2(1)
838 ,default_value VARCHAR2(240)
839 ,minimum_value VARCHAR2(240)
840 ,maximum_value VARCHAR2(240)
841 ,uom_code VARCHAR2(3)
842 ,start_date_active DATE
843 ,end_date_active DATE
844 ,desc_flex DFF_Rec_Type
845 ,property_lov_type VARCHAR2(30)
846 );
847
848 End CSI_CTR_DATASTRUCTURES_PUB;