[Home] [Help]
PACKAGE BODY: APPS.CSI_COUNTER_TEMPLATE_PUB_W
Source
1 package body csi_counter_template_pub_w as
2 /* $Header: csiptewb.pls 120.11 2008/03/26 09:11:07 ngoutam ship $ */
3 rosetta_g_mistake_date date := to_date('01/01/+4713', 'MM/DD/SYYYY');
4 rosetta_g_miss_date date := to_date('01/01/-4712', 'MM/DD/SYYYY');
5 rosetta_g_mistake_date_high date := to_date('01/01/+4710', 'MM/DD/SYYYY');
6 rosetta_g_mistake_date_low date := to_date('01/01/-4710', 'MM/DD/SYYYY');
7
8 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
9 function rosetta_g_miss_date_in_map(d date) return date as
10 begin
11 if d > rosetta_g_mistake_date_high then return fnd_api.g_miss_date; end if;
12 if d < rosetta_g_mistake_date_low then return fnd_api.g_miss_date; end if;
13 return d;
14 end;
15
16 function rosetta_g_miss_num_map(n number) return number as
17 a number := fnd_api.g_miss_num;
18 b number := 0-1962.0724;
19 begin
20 if n=a then return b; end if;
21 if n=b then return a; end if;
22 return n;
23 end;
24
25 procedure rosetta_table_copy_in_p3(t out nocopy csi_counter_template_pub.ctr_template_autoinst_tbl, a0 JTF_NUMBER_TABLE
26 , a1 JTF_NUMBER_TABLE
27 ) as
28 ddindx binary_integer; indx binary_integer;
29 begin
30 if a0 is not null and a0.count > 0 then
31 if a0.count > 0 then
32 indx := a0.first;
33 ddindx := 1;
34 while true loop
35 t(ddindx).counter_id := rosetta_g_miss_num_map(a0(indx));
36 t(ddindx).group_id := rosetta_g_miss_num_map(a1(indx));
37 ddindx := ddindx+1;
38 if a0.last =indx
39 then exit;
40 end if;
41 indx := a0.next(indx);
42 end loop;
43 end if;
44 end if;
45 end rosetta_table_copy_in_p3;
46 procedure rosetta_table_copy_out_p3(t csi_counter_template_pub.ctr_template_autoinst_tbl, a0 out nocopy JTF_NUMBER_TABLE
47 , a1 out nocopy JTF_NUMBER_TABLE
48 ) as
49 ddindx binary_integer; indx binary_integer;
50 begin
51 if t is null or t.count = 0 then
52 a0 := JTF_NUMBER_TABLE();
53 a1 := JTF_NUMBER_TABLE();
54 else
55 a0 := JTF_NUMBER_TABLE();
56 a1 := JTF_NUMBER_TABLE();
57 if t.count > 0 then
58 a0.extend(t.count);
59 a1.extend(t.count);
60 ddindx := t.first;
61 indx := 1;
62 while true loop
63 a0(indx) := rosetta_g_miss_num_map(t(ddindx).counter_id);
64 a1(indx) := rosetta_g_miss_num_map(t(ddindx).group_id);
65 indx := indx+1;
66 if t.last =ddindx
67 then exit;
68 end if;
69 ddindx := t.next(ddindx);
70 end loop;
71 end if;
72 end if;
73 end rosetta_table_copy_out_p3;
74
75 procedure rosetta_table_copy_in_p5(t out nocopy csi_counter_template_pub.counter_autoinstantiate_tbl, a0 JTF_NUMBER_TABLE
76 , a1 JTF_NUMBER_TABLE
77 ) as
78 ddindx binary_integer; indx binary_integer;
79 begin
80 if a0 is not null and a0.count > 0 then
81 if a0.count > 0 then
82 indx := a0.first;
83 ddindx := 1;
84 while true loop
85 t(ddindx).counter_id := rosetta_g_miss_num_map(a0(indx));
86 t(ddindx).group_id := rosetta_g_miss_num_map(a1(indx));
87 ddindx := ddindx+1;
88 if a0.last =indx
89 then exit;
90 end if;
91 indx := a0.next(indx);
92 end loop;
93 end if;
94 end if;
95 end rosetta_table_copy_in_p5;
96 procedure rosetta_table_copy_out_p5(t csi_counter_template_pub.counter_autoinstantiate_tbl, a0 out nocopy JTF_NUMBER_TABLE
97 , a1 out nocopy JTF_NUMBER_TABLE
98 ) as
99 ddindx binary_integer; indx binary_integer;
100 begin
101 if t is null or t.count = 0 then
102 a0 := JTF_NUMBER_TABLE();
103 a1 := JTF_NUMBER_TABLE();
104 else
105 a0 := JTF_NUMBER_TABLE();
106 a1 := JTF_NUMBER_TABLE();
107 if t.count > 0 then
108 a0.extend(t.count);
109 a1.extend(t.count);
110 ddindx := t.first;
111 indx := 1;
112 while true loop
113 a0(indx) := rosetta_g_miss_num_map(t(ddindx).counter_id);
114 a1(indx) := rosetta_g_miss_num_map(t(ddindx).group_id);
115 indx := indx+1;
116 if t.last =ddindx
117 then exit;
118 end if;
119 ddindx := t.next(ddindx);
120 end loop;
121 end if;
122 end if;
123 end rosetta_table_copy_out_p5;
124
125 procedure create_counter_group(p_api_version NUMBER
126 , p_commit VARCHAR2
127 , p_init_msg_list VARCHAR2
128 , p_validation_level NUMBER
129 , p4_a0 in out nocopy NUMBER
130 , p4_a1 in out nocopy VARCHAR2
131 , p4_a2 in out nocopy VARCHAR2
132 , p4_a3 in out nocopy VARCHAR2
133 , p4_a4 in out nocopy DATE
134 , p4_a5 in out nocopy NUMBER
135 , p4_a6 in out nocopy DATE
136 , p4_a7 in out nocopy NUMBER
137 , p4_a8 in out nocopy NUMBER
138 , p4_a9 in out nocopy DATE
139 , p4_a10 in out nocopy DATE
140 , p4_a11 in out nocopy VARCHAR2
141 , p4_a12 in out nocopy VARCHAR2
142 , p4_a13 in out nocopy VARCHAR2
143 , p4_a14 in out nocopy VARCHAR2
144 , p4_a15 in out nocopy VARCHAR2
145 , p4_a16 in out nocopy VARCHAR2
146 , p4_a17 in out nocopy VARCHAR2
147 , p4_a18 in out nocopy VARCHAR2
148 , p4_a19 in out nocopy VARCHAR2
149 , p4_a20 in out nocopy VARCHAR2
150 , p4_a21 in out nocopy VARCHAR2
151 , p4_a22 in out nocopy VARCHAR2
152 , p4_a23 in out nocopy VARCHAR2
153 , p4_a24 in out nocopy VARCHAR2
154 , p4_a25 in out nocopy VARCHAR2
155 , p4_a26 in out nocopy VARCHAR2
156 , p4_a27 in out nocopy NUMBER
157 , p4_a28 in out nocopy NUMBER
158 , p4_a29 in out nocopy VARCHAR2
159 , p4_a30 in out nocopy VARCHAR2
160 , p4_a31 in out nocopy NUMBER
161 , p4_a32 in out nocopy NUMBER
162 , p4_a33 in out nocopy NUMBER
163 , p4_a34 in out nocopy VARCHAR2
164 , p5_a0 in out nocopy JTF_NUMBER_TABLE
165 , p5_a1 in out nocopy JTF_NUMBER_TABLE
166 , p5_a2 in out nocopy JTF_NUMBER_TABLE
167 , p5_a3 in out nocopy JTF_NUMBER_TABLE
168 , p5_a4 in out nocopy JTF_DATE_TABLE
169 , p5_a5 in out nocopy JTF_NUMBER_TABLE
170 , p5_a6 in out nocopy JTF_NUMBER_TABLE
171 , p5_a7 in out nocopy JTF_DATE_TABLE
172 , p5_a8 in out nocopy JTF_NUMBER_TABLE
173 , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_200
174 , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_200
175 , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
176 , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_200
177 , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_200
178 , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_200
179 , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_200
180 , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_200
181 , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_200
182 , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_200
183 , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_200
184 , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_200
185 , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_200
186 , p5_a22 in out nocopy JTF_VARCHAR2_TABLE_200
187 , p5_a23 in out nocopy JTF_VARCHAR2_TABLE_200
188 , p5_a24 in out nocopy JTF_VARCHAR2_TABLE_100
189 , p5_a25 in out nocopy JTF_NUMBER_TABLE
190 , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_100
191 , p5_a27 in out nocopy JTF_NUMBER_TABLE
192 , p5_a28 in out nocopy JTF_DATE_TABLE
193 , p5_a29 in out nocopy JTF_DATE_TABLE
194 , p5_a30 in out nocopy JTF_NUMBER_TABLE
195 , p5_a31 in out nocopy JTF_NUMBER_TABLE
196 , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
197 , p5_a33 in out nocopy JTF_NUMBER_TABLE
198 , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
199 , x_return_status out nocopy VARCHAR2
200 , x_msg_count out nocopy NUMBER
201 , x_msg_data out nocopy VARCHAR2
202 )
203
204 as
205 ddp_counter_groups_rec csi_ctr_datastructures_pub.counter_groups_rec;
206 ddp_ctr_item_associations_tbl csi_ctr_datastructures_pub.ctr_item_associations_tbl;
207 ddindx binary_integer; indx binary_integer;
208 begin
209
210 -- copy data to the local IN or IN-OUT args, if any
211
212
213
214
215 ddp_counter_groups_rec.counter_group_id := rosetta_g_miss_num_map(p4_a0);
216 ddp_counter_groups_rec.name := p4_a1;
217 ddp_counter_groups_rec.description := p4_a2;
218 ddp_counter_groups_rec.template_flag := p4_a3;
219 ddp_counter_groups_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a4);
220 ddp_counter_groups_rec.last_updated_by := rosetta_g_miss_num_map(p4_a5);
221 ddp_counter_groups_rec.creation_date := rosetta_g_miss_date_in_map(p4_a6);
222 ddp_counter_groups_rec.created_by := rosetta_g_miss_num_map(p4_a7);
223 ddp_counter_groups_rec.last_update_login := rosetta_g_miss_num_map(p4_a8);
224 ddp_counter_groups_rec.start_date_active := rosetta_g_miss_date_in_map(p4_a9);
225 ddp_counter_groups_rec.end_date_active := rosetta_g_miss_date_in_map(p4_a10);
226 ddp_counter_groups_rec.attribute1 := p4_a11;
227 ddp_counter_groups_rec.attribute2 := p4_a12;
228 ddp_counter_groups_rec.attribute3 := p4_a13;
229 ddp_counter_groups_rec.attribute4 := p4_a14;
230 ddp_counter_groups_rec.attribute5 := p4_a15;
231 ddp_counter_groups_rec.attribute6 := p4_a16;
232 ddp_counter_groups_rec.attribute7 := p4_a17;
233 ddp_counter_groups_rec.attribute8 := p4_a18;
234 ddp_counter_groups_rec.attribute9 := p4_a19;
235 ddp_counter_groups_rec.attribute10 := p4_a20;
236 ddp_counter_groups_rec.attribute11 := p4_a21;
237 ddp_counter_groups_rec.attribute12 := p4_a22;
238 ddp_counter_groups_rec.attribute13 := p4_a23;
239 ddp_counter_groups_rec.attribute14 := p4_a24;
240 ddp_counter_groups_rec.attribute15 := p4_a25;
241 ddp_counter_groups_rec.context := p4_a26;
242 ddp_counter_groups_rec.object_version_number := rosetta_g_miss_num_map(p4_a27);
243 ddp_counter_groups_rec.created_from_ctr_grp_tmpl_id := rosetta_g_miss_num_map(p4_a28);
244 ddp_counter_groups_rec.association_type := p4_a29;
245 ddp_counter_groups_rec.source_object_code := p4_a30;
246 ddp_counter_groups_rec.source_object_id := rosetta_g_miss_num_map(p4_a31);
247 ddp_counter_groups_rec.source_counter_group_id := rosetta_g_miss_num_map(p4_a32);
248 ddp_counter_groups_rec.security_group_id := rosetta_g_miss_num_map(p4_a33);
249 ddp_counter_groups_rec.upgraded_status_flag := p4_a34;
250
251 csi_ctr_datastructures_pub_w.rosetta_table_copy_in_p8(ddp_ctr_item_associations_tbl, p5_a0
252 , p5_a1
253 , p5_a2
254 , p5_a3
255 , p5_a4
256 , p5_a5
257 , p5_a6
258 , p5_a7
259 , p5_a8
260 , p5_a9
261 , p5_a10
262 , p5_a11
263 , p5_a12
264 , p5_a13
265 , p5_a14
266 , p5_a15
267 , p5_a16
268 , p5_a17
269 , p5_a18
270 , p5_a19
271 , p5_a20
272 , p5_a21
273 , p5_a22
274 , p5_a23
275 , p5_a24
276 , p5_a25
277 , p5_a26
278 , p5_a27
279 , p5_a28
280 , p5_a29
281 , p5_a30
282 , p5_a31
283 , p5_a32
284 , p5_a33
285 , p5_a34
286 );
287
288
289
290
291 -- here's the delegated call to the old PL/SQL routine
292 csi_counter_template_pub.create_counter_group(p_api_version,
293 p_commit,
294 p_init_msg_list,
295 p_validation_level,
296 ddp_counter_groups_rec,
297 ddp_ctr_item_associations_tbl,
298 x_return_status,
299 x_msg_count,
300 x_msg_data);
301
302 -- copy data back from the local variables to OUT or IN-OUT args, if any
303
304
305
306
307 p4_a0 := rosetta_g_miss_num_map(ddp_counter_groups_rec.counter_group_id);
308 p4_a1 := ddp_counter_groups_rec.name;
309 p4_a2 := ddp_counter_groups_rec.description;
310 p4_a3 := ddp_counter_groups_rec.template_flag;
311 p4_a4 := ddp_counter_groups_rec.last_update_date;
312 p4_a5 := rosetta_g_miss_num_map(ddp_counter_groups_rec.last_updated_by);
313 p4_a6 := ddp_counter_groups_rec.creation_date;
314 p4_a7 := rosetta_g_miss_num_map(ddp_counter_groups_rec.created_by);
315 p4_a8 := rosetta_g_miss_num_map(ddp_counter_groups_rec.last_update_login);
316 p4_a9 := ddp_counter_groups_rec.start_date_active;
317 p4_a10 := ddp_counter_groups_rec.end_date_active;
318 p4_a11 := ddp_counter_groups_rec.attribute1;
319 p4_a12 := ddp_counter_groups_rec.attribute2;
320 p4_a13 := ddp_counter_groups_rec.attribute3;
321 p4_a14 := ddp_counter_groups_rec.attribute4;
322 p4_a15 := ddp_counter_groups_rec.attribute5;
323 p4_a16 := ddp_counter_groups_rec.attribute6;
324 p4_a17 := ddp_counter_groups_rec.attribute7;
325 p4_a18 := ddp_counter_groups_rec.attribute8;
326 p4_a19 := ddp_counter_groups_rec.attribute9;
327 p4_a20 := ddp_counter_groups_rec.attribute10;
328 p4_a21 := ddp_counter_groups_rec.attribute11;
329 p4_a22 := ddp_counter_groups_rec.attribute12;
330 p4_a23 := ddp_counter_groups_rec.attribute13;
331 p4_a24 := ddp_counter_groups_rec.attribute14;
332 p4_a25 := ddp_counter_groups_rec.attribute15;
333 p4_a26 := ddp_counter_groups_rec.context;
334 p4_a27 := rosetta_g_miss_num_map(ddp_counter_groups_rec.object_version_number);
335 p4_a28 := rosetta_g_miss_num_map(ddp_counter_groups_rec.created_from_ctr_grp_tmpl_id);
336 p4_a29 := ddp_counter_groups_rec.association_type;
337 p4_a30 := ddp_counter_groups_rec.source_object_code;
338 p4_a31 := rosetta_g_miss_num_map(ddp_counter_groups_rec.source_object_id);
339 p4_a32 := rosetta_g_miss_num_map(ddp_counter_groups_rec.source_counter_group_id);
340 p4_a33 := rosetta_g_miss_num_map(ddp_counter_groups_rec.security_group_id);
341 p4_a34 := ddp_counter_groups_rec.upgraded_status_flag;
342
343 csi_ctr_datastructures_pub_w.rosetta_table_copy_out_p8(ddp_ctr_item_associations_tbl, p5_a0
344 , p5_a1
345 , p5_a2
346 , p5_a3
347 , p5_a4
348 , p5_a5
349 , p5_a6
350 , p5_a7
351 , p5_a8
352 , p5_a9
353 , p5_a10
354 , p5_a11
355 , p5_a12
356 , p5_a13
357 , p5_a14
358 , p5_a15
359 , p5_a16
360 , p5_a17
361 , p5_a18
362 , p5_a19
363 , p5_a20
364 , p5_a21
365 , p5_a22
366 , p5_a23
367 , p5_a24
368 , p5_a25
369 , p5_a26
370 , p5_a27
371 , p5_a28
372 , p5_a29
373 , p5_a30
374 , p5_a31
375 , p5_a32
376 , p5_a33
377 , p5_a34
378 );
379
380
381
382 end;
383
384 procedure create_item_association(p_api_version NUMBER
385 , p_commit VARCHAR2
386 , p_init_msg_list VARCHAR2
387 , p_validation_level NUMBER
388 , p4_a0 in out nocopy NUMBER
389 , p4_a1 in out nocopy NUMBER
390 , p4_a2 in out nocopy NUMBER
391 , p4_a3 in out nocopy NUMBER
392 , p4_a4 in out nocopy DATE
393 , p4_a5 in out nocopy NUMBER
394 , p4_a6 in out nocopy NUMBER
395 , p4_a7 in out nocopy DATE
396 , p4_a8 in out nocopy NUMBER
397 , p4_a9 in out nocopy VARCHAR2
398 , p4_a10 in out nocopy VARCHAR2
399 , p4_a11 in out nocopy VARCHAR2
400 , p4_a12 in out nocopy VARCHAR2
401 , p4_a13 in out nocopy VARCHAR2
402 , p4_a14 in out nocopy VARCHAR2
403 , p4_a15 in out nocopy VARCHAR2
404 , p4_a16 in out nocopy VARCHAR2
405 , p4_a17 in out nocopy VARCHAR2
406 , p4_a18 in out nocopy VARCHAR2
407 , p4_a19 in out nocopy VARCHAR2
408 , p4_a20 in out nocopy VARCHAR2
409 , p4_a21 in out nocopy VARCHAR2
410 , p4_a22 in out nocopy VARCHAR2
411 , p4_a23 in out nocopy VARCHAR2
412 , p4_a24 in out nocopy VARCHAR2
413 , p4_a25 in out nocopy NUMBER
414 , p4_a26 in out nocopy VARCHAR2
415 , p4_a27 in out nocopy NUMBER
416 , p4_a28 in out nocopy DATE
417 , p4_a29 in out nocopy DATE
418 , p4_a30 in out nocopy NUMBER
419 , p4_a31 in out nocopy NUMBER
420 , p4_a32 in out nocopy VARCHAR2
421 , p4_a33 in out nocopy NUMBER
422 , p4_a34 in out nocopy VARCHAR2
423 , x_return_status out nocopy VARCHAR2
424 , x_msg_count out nocopy NUMBER
425 , x_msg_data out nocopy VARCHAR2
426 )
427
428 as
429 ddp_ctr_item_associations_rec csi_ctr_datastructures_pub.ctr_item_associations_rec;
430 ddindx binary_integer; indx binary_integer;
431 begin
432
433 -- copy data to the local IN or IN-OUT args, if any
434
435
436
437
438 ddp_ctr_item_associations_rec.ctr_association_id := rosetta_g_miss_num_map(p4_a0);
439 ddp_ctr_item_associations_rec.group_id := rosetta_g_miss_num_map(p4_a1);
440 ddp_ctr_item_associations_rec.inventory_item_id := rosetta_g_miss_num_map(p4_a2);
441 ddp_ctr_item_associations_rec.object_version_number := rosetta_g_miss_num_map(p4_a3);
442 ddp_ctr_item_associations_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a4);
443 ddp_ctr_item_associations_rec.last_updated_by := rosetta_g_miss_num_map(p4_a5);
444 ddp_ctr_item_associations_rec.last_update_login := rosetta_g_miss_num_map(p4_a6);
445 ddp_ctr_item_associations_rec.creation_date := rosetta_g_miss_date_in_map(p4_a7);
446 ddp_ctr_item_associations_rec.created_by := rosetta_g_miss_num_map(p4_a8);
447 ddp_ctr_item_associations_rec.attribute1 := p4_a9;
448 ddp_ctr_item_associations_rec.attribute2 := p4_a10;
449 ddp_ctr_item_associations_rec.attribute3 := p4_a11;
450 ddp_ctr_item_associations_rec.attribute4 := p4_a12;
451 ddp_ctr_item_associations_rec.attribute5 := p4_a13;
452 ddp_ctr_item_associations_rec.attribute6 := p4_a14;
453 ddp_ctr_item_associations_rec.attribute7 := p4_a15;
454 ddp_ctr_item_associations_rec.attribute8 := p4_a16;
455 ddp_ctr_item_associations_rec.attribute9 := p4_a17;
456 ddp_ctr_item_associations_rec.attribute10 := p4_a18;
457 ddp_ctr_item_associations_rec.attribute11 := p4_a19;
458 ddp_ctr_item_associations_rec.attribute12 := p4_a20;
459 ddp_ctr_item_associations_rec.attribute13 := p4_a21;
460 ddp_ctr_item_associations_rec.attribute14 := p4_a22;
461 ddp_ctr_item_associations_rec.attribute15 := p4_a23;
462 ddp_ctr_item_associations_rec.attribute_category := p4_a24;
463 ddp_ctr_item_associations_rec.security_group_id := rosetta_g_miss_num_map(p4_a25);
464 ddp_ctr_item_associations_rec.migrated_flag := p4_a26;
465 ddp_ctr_item_associations_rec.counter_id := rosetta_g_miss_num_map(p4_a27);
466 ddp_ctr_item_associations_rec.start_date_active := rosetta_g_miss_date_in_map(p4_a28);
467 ddp_ctr_item_associations_rec.end_date_active := rosetta_g_miss_date_in_map(p4_a29);
468 ddp_ctr_item_associations_rec.usage_rate := rosetta_g_miss_num_map(p4_a30);
469 ddp_ctr_item_associations_rec.use_past_reading := rosetta_g_miss_num_map(p4_a31);
470 ddp_ctr_item_associations_rec.associated_to_group := p4_a32;
471 ddp_ctr_item_associations_rec.maint_organization_id := rosetta_g_miss_num_map(p4_a33);
472 ddp_ctr_item_associations_rec.primary_failure_flag := p4_a34;
473
474
475
476
477 -- here's the delegated call to the old PL/SQL routine
478 csi_counter_template_pub.create_item_association(p_api_version,
479 p_commit,
480 p_init_msg_list,
481 p_validation_level,
482 ddp_ctr_item_associations_rec,
483 x_return_status,
484 x_msg_count,
485 x_msg_data);
486
487 -- copy data back from the local variables to OUT or IN-OUT args, if any
488
489
490
491
492 p4_a0 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.ctr_association_id);
493 p4_a1 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.group_id);
494 p4_a2 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.inventory_item_id);
495 p4_a3 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.object_version_number);
496 p4_a4 := ddp_ctr_item_associations_rec.last_update_date;
497 p4_a5 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.last_updated_by);
498 p4_a6 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.last_update_login);
499 p4_a7 := ddp_ctr_item_associations_rec.creation_date;
500 p4_a8 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.created_by);
501 p4_a9 := ddp_ctr_item_associations_rec.attribute1;
502 p4_a10 := ddp_ctr_item_associations_rec.attribute2;
503 p4_a11 := ddp_ctr_item_associations_rec.attribute3;
504 p4_a12 := ddp_ctr_item_associations_rec.attribute4;
505 p4_a13 := ddp_ctr_item_associations_rec.attribute5;
506 p4_a14 := ddp_ctr_item_associations_rec.attribute6;
507 p4_a15 := ddp_ctr_item_associations_rec.attribute7;
508 p4_a16 := ddp_ctr_item_associations_rec.attribute8;
509 p4_a17 := ddp_ctr_item_associations_rec.attribute9;
510 p4_a18 := ddp_ctr_item_associations_rec.attribute10;
511 p4_a19 := ddp_ctr_item_associations_rec.attribute11;
512 p4_a20 := ddp_ctr_item_associations_rec.attribute12;
513 p4_a21 := ddp_ctr_item_associations_rec.attribute13;
514 p4_a22 := ddp_ctr_item_associations_rec.attribute14;
515 p4_a23 := ddp_ctr_item_associations_rec.attribute15;
516 p4_a24 := ddp_ctr_item_associations_rec.attribute_category;
517 p4_a25 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.security_group_id);
518 p4_a26 := ddp_ctr_item_associations_rec.migrated_flag;
519 p4_a27 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.counter_id);
520 p4_a28 := ddp_ctr_item_associations_rec.start_date_active;
521 p4_a29 := ddp_ctr_item_associations_rec.end_date_active;
522 p4_a30 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.usage_rate);
523 p4_a31 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.use_past_reading);
524 p4_a32 := ddp_ctr_item_associations_rec.associated_to_group;
525 p4_a33 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.maint_organization_id);
526 p4_a34 := ddp_ctr_item_associations_rec.primary_failure_flag;
527
528
529
530 end;
531
532 procedure create_counter_template(p_api_version NUMBER
533 , p_commit VARCHAR2
534 , p_init_msg_list VARCHAR2
535 , p_validation_level NUMBER
536 , p4_a0 in out nocopy NUMBER
537 , p4_a1 in out nocopy NUMBER
538 , p4_a2 in out nocopy VARCHAR2
539 , p4_a3 in out nocopy NUMBER
540 , p4_a4 in out nocopy DATE
541 , p4_a5 in out nocopy NUMBER
542 , p4_a6 in out nocopy NUMBER
543 , p4_a7 in out nocopy VARCHAR2
544 , p4_a8 in out nocopy NUMBER
545 , p4_a9 in out nocopy VARCHAR2
546 , p4_a10 in out nocopy NUMBER
547 , p4_a11 in out nocopy VARCHAR2
548 , p4_a12 in out nocopy VARCHAR2
549 , p4_a13 in out nocopy VARCHAR2
550 , p4_a14 in out nocopy NUMBER
551 , p4_a15 in out nocopy NUMBER
552 , p4_a16 in out nocopy NUMBER
553 , p4_a17 in out nocopy NUMBER
554 , p4_a18 in out nocopy DATE
555 , p4_a19 in out nocopy DATE
556 , p4_a20 in out nocopy NUMBER
557 , p4_a21 in out nocopy DATE
558 , p4_a22 in out nocopy NUMBER
559 , p4_a23 in out nocopy DATE
560 , p4_a24 in out nocopy NUMBER
561 , p4_a25 in out nocopy NUMBER
562 , p4_a26 in out nocopy VARCHAR2
563 , p4_a27 in out nocopy VARCHAR2
564 , p4_a28 in out nocopy VARCHAR2
565 , p4_a29 in out nocopy VARCHAR2
566 , p4_a30 in out nocopy VARCHAR2
567 , p4_a31 in out nocopy VARCHAR2
568 , p4_a32 in out nocopy VARCHAR2
569 , p4_a33 in out nocopy VARCHAR2
570 , p4_a34 in out nocopy VARCHAR2
571 , p4_a35 in out nocopy VARCHAR2
572 , p4_a36 in out nocopy VARCHAR2
573 , p4_a37 in out nocopy VARCHAR2
574 , p4_a38 in out nocopy VARCHAR2
575 , p4_a39 in out nocopy VARCHAR2
576 , p4_a40 in out nocopy VARCHAR2
577 , p4_a41 in out nocopy VARCHAR2
578 , p4_a42 in out nocopy VARCHAR2
579 , p4_a43 in out nocopy VARCHAR2
580 , p4_a44 in out nocopy VARCHAR2
581 , p4_a45 in out nocopy VARCHAR2
582 , p4_a46 in out nocopy VARCHAR2
583 , p4_a47 in out nocopy VARCHAR2
584 , p4_a48 in out nocopy VARCHAR2
585 , p4_a49 in out nocopy VARCHAR2
586 , p4_a50 in out nocopy VARCHAR2
587 , p4_a51 in out nocopy VARCHAR2
588 , p4_a52 in out nocopy VARCHAR2
589 , p4_a53 in out nocopy VARCHAR2
590 , p4_a54 in out nocopy VARCHAR2
591 , p4_a55 in out nocopy VARCHAR2
592 , p4_a56 in out nocopy VARCHAR2
593 , p4_a57 in out nocopy VARCHAR2
594 , p4_a58 in out nocopy VARCHAR2
595 , p4_a59 in out nocopy VARCHAR2
596 , p4_a60 in out nocopy VARCHAR2
597 , p4_a61 in out nocopy NUMBER
598 , p4_a62 in out nocopy VARCHAR2
599 , p4_a63 in out nocopy NUMBER
600 , p4_a64 in out nocopy NUMBER
601 , p4_a65 in out nocopy VARCHAR2
602 , p4_a66 in out nocopy NUMBER
603 , p4_a67 in out nocopy NUMBER
604 , p4_a68 in out nocopy VARCHAR2
605 , p4_a69 in out nocopy NUMBER
606 , p4_a70 in out nocopy NUMBER
607 , p4_a71 in out nocopy VARCHAR2
608 , p4_a72 in out nocopy VARCHAR2
609 , p4_a73 in out nocopy VARCHAR2
610 , p4_a74 in out nocopy VARCHAR2
611 , p4_a75 in out nocopy NUMBER
612 , p4_a76 in out nocopy VARCHAR2
613 , p4_a77 in out nocopy VARCHAR2
614 , p5_a0 in out nocopy JTF_NUMBER_TABLE
615 , p5_a1 in out nocopy JTF_NUMBER_TABLE
616 , p5_a2 in out nocopy JTF_NUMBER_TABLE
617 , p5_a3 in out nocopy JTF_NUMBER_TABLE
618 , p5_a4 in out nocopy JTF_DATE_TABLE
619 , p5_a5 in out nocopy JTF_NUMBER_TABLE
620 , p5_a6 in out nocopy JTF_NUMBER_TABLE
621 , p5_a7 in out nocopy JTF_DATE_TABLE
622 , p5_a8 in out nocopy JTF_NUMBER_TABLE
623 , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_200
624 , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_200
625 , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
626 , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_200
627 , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_200
628 , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_200
629 , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_200
630 , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_200
631 , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_200
632 , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_200
633 , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_200
634 , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_200
635 , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_200
636 , p5_a22 in out nocopy JTF_VARCHAR2_TABLE_200
637 , p5_a23 in out nocopy JTF_VARCHAR2_TABLE_200
638 , p5_a24 in out nocopy JTF_VARCHAR2_TABLE_100
639 , p5_a25 in out nocopy JTF_NUMBER_TABLE
640 , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_100
641 , p5_a27 in out nocopy JTF_NUMBER_TABLE
642 , p5_a28 in out nocopy JTF_DATE_TABLE
643 , p5_a29 in out nocopy JTF_DATE_TABLE
644 , p5_a30 in out nocopy JTF_NUMBER_TABLE
645 , p5_a31 in out nocopy JTF_NUMBER_TABLE
646 , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
647 , p5_a33 in out nocopy JTF_NUMBER_TABLE
648 , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
649 , p6_a0 in out nocopy JTF_NUMBER_TABLE
650 , p6_a1 in out nocopy JTF_NUMBER_TABLE
651 , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
652 , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100
653 , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_300
654 , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_300
655 , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_300
656 , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
657 , p6_a8 in out nocopy JTF_DATE_TABLE
658 , p6_a9 in out nocopy JTF_DATE_TABLE
659 , p6_a10 in out nocopy JTF_NUMBER_TABLE
660 , p6_a11 in out nocopy JTF_DATE_TABLE
661 , p6_a12 in out nocopy JTF_NUMBER_TABLE
662 , p6_a13 in out nocopy JTF_DATE_TABLE
663 , p6_a14 in out nocopy JTF_NUMBER_TABLE
664 , p6_a15 in out nocopy JTF_NUMBER_TABLE
665 , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_200
666 , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_200
667 , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_200
668 , p6_a19 in out nocopy JTF_VARCHAR2_TABLE_200
669 , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_200
670 , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_200
671 , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_200
672 , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_200
673 , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_200
674 , p6_a25 in out nocopy JTF_VARCHAR2_TABLE_200
675 , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_200
676 , p6_a27 in out nocopy JTF_VARCHAR2_TABLE_200
677 , p6_a28 in out nocopy JTF_VARCHAR2_TABLE_200
678 , p6_a29 in out nocopy JTF_VARCHAR2_TABLE_200
679 , p6_a30 in out nocopy JTF_VARCHAR2_TABLE_200
680 , p6_a31 in out nocopy JTF_VARCHAR2_TABLE_100
681 , p6_a32 in out nocopy JTF_VARCHAR2_TABLE_100
682 , p6_a33 in out nocopy JTF_VARCHAR2_TABLE_100
683 , p6_a34 in out nocopy JTF_NUMBER_TABLE
684 , p6_a35 in out nocopy JTF_VARCHAR2_TABLE_100
685 , p6_a36 in out nocopy JTF_VARCHAR2_TABLE_300
686 , p7_a0 in out nocopy JTF_NUMBER_TABLE
687 , p7_a1 in out nocopy JTF_NUMBER_TABLE
688 , p7_a2 in out nocopy JTF_VARCHAR2_TABLE_100
689 , p7_a3 in out nocopy JTF_NUMBER_TABLE
690 , p7_a4 in out nocopy JTF_NUMBER_TABLE
691 , p7_a5 in out nocopy JTF_DATE_TABLE
692 , p7_a6 in out nocopy JTF_DATE_TABLE
693 , p7_a7 in out nocopy JTF_NUMBER_TABLE
694 , p7_a8 in out nocopy JTF_DATE_TABLE
695 , p7_a9 in out nocopy JTF_NUMBER_TABLE
696 , p7_a10 in out nocopy JTF_DATE_TABLE
697 , p7_a11 in out nocopy JTF_NUMBER_TABLE
698 , p7_a12 in out nocopy JTF_NUMBER_TABLE
699 , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100
700 , p7_a14 in out nocopy JTF_VARCHAR2_TABLE_200
701 , p7_a15 in out nocopy JTF_VARCHAR2_TABLE_200
702 , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_200
703 , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200
704 , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
705 , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200
706 , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200
707 , p7_a21 in out nocopy JTF_VARCHAR2_TABLE_200
708 , p7_a22 in out nocopy JTF_VARCHAR2_TABLE_200
709 , p7_a23 in out nocopy JTF_VARCHAR2_TABLE_200
710 , p7_a24 in out nocopy JTF_VARCHAR2_TABLE_200
711 , p7_a25 in out nocopy JTF_VARCHAR2_TABLE_200
712 , p7_a26 in out nocopy JTF_VARCHAR2_TABLE_200
713 , p7_a27 in out nocopy JTF_VARCHAR2_TABLE_200
714 , p7_a28 in out nocopy JTF_VARCHAR2_TABLE_200
715 , p7_a29 in out nocopy JTF_NUMBER_TABLE
716 , p7_a30 in out nocopy JTF_VARCHAR2_TABLE_100
717 , p7_a31 in out nocopy JTF_VARCHAR2_TABLE_100
718 , p7_a32 in out nocopy JTF_NUMBER_TABLE
719 , p8_a0 in out nocopy JTF_NUMBER_TABLE
720 , p8_a1 in out nocopy JTF_NUMBER_TABLE
721 , p8_a2 in out nocopy JTF_NUMBER_TABLE
722 , p8_a3 in out nocopy JTF_VARCHAR2_TABLE_100
723 , p8_a4 in out nocopy JTF_NUMBER_TABLE
724 , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_100
725 , p8_a6 in out nocopy JTF_VARCHAR2_TABLE_300
726 , p8_a7 in out nocopy JTF_VARCHAR2_TABLE_100
727 , p8_a8 in out nocopy JTF_VARCHAR2_TABLE_100
728 , p8_a9 in out nocopy JTF_DATE_TABLE
729 , p8_a10 in out nocopy JTF_DATE_TABLE
730 , p8_a11 in out nocopy JTF_NUMBER_TABLE
731 , p8_a12 in out nocopy JTF_DATE_TABLE
732 , p8_a13 in out nocopy JTF_NUMBER_TABLE
733 , p8_a14 in out nocopy JTF_DATE_TABLE
734 , p8_a15 in out nocopy JTF_NUMBER_TABLE
735 , p8_a16 in out nocopy JTF_NUMBER_TABLE
736 , p8_a17 in out nocopy JTF_VARCHAR2_TABLE_200
737 , p8_a18 in out nocopy JTF_VARCHAR2_TABLE_200
738 , p8_a19 in out nocopy JTF_VARCHAR2_TABLE_200
739 , p8_a20 in out nocopy JTF_VARCHAR2_TABLE_200
740 , p8_a21 in out nocopy JTF_VARCHAR2_TABLE_200
741 , p8_a22 in out nocopy JTF_VARCHAR2_TABLE_200
742 , p8_a23 in out nocopy JTF_VARCHAR2_TABLE_200
743 , p8_a24 in out nocopy JTF_VARCHAR2_TABLE_200
744 , p8_a25 in out nocopy JTF_VARCHAR2_TABLE_200
745 , p8_a26 in out nocopy JTF_VARCHAR2_TABLE_200
746 , p8_a27 in out nocopy JTF_VARCHAR2_TABLE_200
747 , p8_a28 in out nocopy JTF_VARCHAR2_TABLE_200
748 , p8_a29 in out nocopy JTF_VARCHAR2_TABLE_200
749 , p8_a30 in out nocopy JTF_VARCHAR2_TABLE_200
750 , p8_a31 in out nocopy JTF_VARCHAR2_TABLE_200
751 , p8_a32 in out nocopy JTF_VARCHAR2_TABLE_100
752 , p8_a33 in out nocopy JTF_NUMBER_TABLE
753 , p8_a34 in out nocopy JTF_VARCHAR2_TABLE_100
754 , x_return_status out nocopy VARCHAR2
755 , x_msg_count out nocopy NUMBER
756 , x_msg_data out nocopy VARCHAR2
757 )
758
759 as
760 ddp_counter_template_rec csi_ctr_datastructures_pub.counter_template_rec;
761 ddp_ctr_item_associations_tbl csi_ctr_datastructures_pub.ctr_item_associations_tbl;
762 ddp_ctr_property_template_tbl csi_ctr_datastructures_pub.ctr_property_template_tbl;
763 ddp_counter_relationships_tbl csi_ctr_datastructures_pub.counter_relationships_tbl;
764 ddp_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
765 ddindx binary_integer; indx binary_integer;
766 begin
767
768 -- copy data to the local IN or IN-OUT args, if any
769
770
771
772
773 ddp_counter_template_rec.counter_id := rosetta_g_miss_num_map(p4_a0);
774 ddp_counter_template_rec.group_id := rosetta_g_miss_num_map(p4_a1);
775 ddp_counter_template_rec.counter_type := p4_a2;
776 ddp_counter_template_rec.initial_reading := rosetta_g_miss_num_map(p4_a3);
777 ddp_counter_template_rec.initial_reading_date := rosetta_g_miss_date_in_map(p4_a4);
778 ddp_counter_template_rec.tolerance_plus := rosetta_g_miss_num_map(p4_a5);
779 ddp_counter_template_rec.tolerance_minus := rosetta_g_miss_num_map(p4_a6);
780 ddp_counter_template_rec.uom_code := p4_a7;
781 ddp_counter_template_rec.derive_counter_id := rosetta_g_miss_num_map(p4_a8);
782 ddp_counter_template_rec.derive_function := p4_a9;
783 ddp_counter_template_rec.derive_property_id := rosetta_g_miss_num_map(p4_a10);
784 ddp_counter_template_rec.valid_flag := p4_a11;
785 ddp_counter_template_rec.formula_incomplete_flag := p4_a12;
786 ddp_counter_template_rec.formula_text := p4_a13;
787 ddp_counter_template_rec.rollover_last_reading := rosetta_g_miss_num_map(p4_a14);
788 ddp_counter_template_rec.rollover_first_reading := rosetta_g_miss_num_map(p4_a15);
789 ddp_counter_template_rec.usage_item_id := rosetta_g_miss_num_map(p4_a16);
790 ddp_counter_template_rec.ctr_val_max_seq_no := rosetta_g_miss_num_map(p4_a17);
791 ddp_counter_template_rec.start_date_active := rosetta_g_miss_date_in_map(p4_a18);
792 ddp_counter_template_rec.end_date_active := rosetta_g_miss_date_in_map(p4_a19);
793 ddp_counter_template_rec.object_version_number := rosetta_g_miss_num_map(p4_a20);
794 ddp_counter_template_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a21);
795 ddp_counter_template_rec.last_updated_by := rosetta_g_miss_num_map(p4_a22);
796 ddp_counter_template_rec.creation_date := rosetta_g_miss_date_in_map(p4_a23);
797 ddp_counter_template_rec.created_by := rosetta_g_miss_num_map(p4_a24);
798 ddp_counter_template_rec.last_update_login := rosetta_g_miss_num_map(p4_a25);
799 ddp_counter_template_rec.attribute1 := p4_a26;
800 ddp_counter_template_rec.attribute2 := p4_a27;
801 ddp_counter_template_rec.attribute3 := p4_a28;
802 ddp_counter_template_rec.attribute4 := p4_a29;
803 ddp_counter_template_rec.attribute5 := p4_a30;
804 ddp_counter_template_rec.attribute6 := p4_a31;
805 ddp_counter_template_rec.attribute7 := p4_a32;
806 ddp_counter_template_rec.attribute8 := p4_a33;
807 ddp_counter_template_rec.attribute9 := p4_a34;
808 ddp_counter_template_rec.attribute10 := p4_a35;
809 ddp_counter_template_rec.attribute11 := p4_a36;
810 ddp_counter_template_rec.attribute12 := p4_a37;
811 ddp_counter_template_rec.attribute13 := p4_a38;
812 ddp_counter_template_rec.attribute14 := p4_a39;
813 ddp_counter_template_rec.attribute15 := p4_a40;
814 ddp_counter_template_rec.attribute16 := p4_a41;
815 ddp_counter_template_rec.attribute17 := p4_a42;
816 ddp_counter_template_rec.attribute18 := p4_a43;
817 ddp_counter_template_rec.attribute19 := p4_a44;
818 ddp_counter_template_rec.attribute20 := p4_a45;
819 ddp_counter_template_rec.attribute21 := p4_a46;
820 ddp_counter_template_rec.attribute22 := p4_a47;
821 ddp_counter_template_rec.attribute23 := p4_a48;
822 ddp_counter_template_rec.attribute24 := p4_a49;
823 ddp_counter_template_rec.attribute25 := p4_a50;
824 ddp_counter_template_rec.attribute26 := p4_a51;
825 ddp_counter_template_rec.attribute27 := p4_a52;
826 ddp_counter_template_rec.attribute28 := p4_a53;
827 ddp_counter_template_rec.attribute29 := p4_a54;
828 ddp_counter_template_rec.attribute30 := p4_a55;
829 ddp_counter_template_rec.attribute_category := p4_a56;
830 ddp_counter_template_rec.migrated_flag := p4_a57;
831 ddp_counter_template_rec.customer_view := p4_a58;
832 ddp_counter_template_rec.direction := p4_a59;
833 ddp_counter_template_rec.filter_type := p4_a60;
834 ddp_counter_template_rec.filter_reading_count := rosetta_g_miss_num_map(p4_a61);
835 ddp_counter_template_rec.filter_time_uom := p4_a62;
836 ddp_counter_template_rec.estimation_id := rosetta_g_miss_num_map(p4_a63);
837 ddp_counter_template_rec.reading_type := rosetta_g_miss_num_map(p4_a64);
838 ddp_counter_template_rec.automatic_rollover := p4_a65;
839 ddp_counter_template_rec.default_usage_rate := rosetta_g_miss_num_map(p4_a66);
840 ddp_counter_template_rec.use_past_reading := rosetta_g_miss_num_map(p4_a67);
841 ddp_counter_template_rec.used_in_scheduling := p4_a68;
842 ddp_counter_template_rec.defaulted_group_id := rosetta_g_miss_num_map(p4_a69);
843 ddp_counter_template_rec.security_group_id := rosetta_g_miss_num_map(p4_a70);
844 ddp_counter_template_rec.name := p4_a71;
845 ddp_counter_template_rec.description := p4_a72;
846 ddp_counter_template_rec.comments := p4_a73;
847 ddp_counter_template_rec.association_type := p4_a74;
848 ddp_counter_template_rec.step_value := rosetta_g_miss_num_map(p4_a75);
849 ddp_counter_template_rec.time_based_manual_entry := p4_a76;
850 ddp_counter_template_rec.eam_required_flag := p4_a77;
851
852 csi_ctr_datastructures_pub_w.rosetta_table_copy_in_p8(ddp_ctr_item_associations_tbl, p5_a0
853 , p5_a1
854 , p5_a2
855 , p5_a3
856 , p5_a4
857 , p5_a5
858 , p5_a6
859 , p5_a7
860 , p5_a8
861 , p5_a9
862 , p5_a10
863 , p5_a11
864 , p5_a12
865 , p5_a13
866 , p5_a14
867 , p5_a15
868 , p5_a16
869 , p5_a17
870 , p5_a18
871 , p5_a19
872 , p5_a20
873 , p5_a21
874 , p5_a22
875 , p5_a23
876 , p5_a24
877 , p5_a25
878 , p5_a26
879 , p5_a27
880 , p5_a28
881 , p5_a29
882 , p5_a30
883 , p5_a31
884 , p5_a32
885 , p5_a33
886 , p5_a34
887 );
888
889 csi_ctr_datastructures_pub_w.rosetta_table_copy_in_p12(ddp_ctr_property_template_tbl, p6_a0
890 , p6_a1
891 , p6_a2
892 , p6_a3
893 , p6_a4
894 , p6_a5
895 , p6_a6
896 , p6_a7
897 , p6_a8
898 , p6_a9
899 , p6_a10
900 , p6_a11
901 , p6_a12
902 , p6_a13
903 , p6_a14
904 , p6_a15
905 , p6_a16
906 , p6_a17
907 , p6_a18
908 , p6_a19
909 , p6_a20
910 , p6_a21
911 , p6_a22
912 , p6_a23
913 , p6_a24
914 , p6_a25
915 , p6_a26
916 , p6_a27
917 , p6_a28
918 , p6_a29
919 , p6_a30
920 , p6_a31
921 , p6_a32
922 , p6_a33
923 , p6_a34
924 , p6_a35
925 , p6_a36
926 );
927
928 csi_ctr_datastructures_pub_w.rosetta_table_copy_in_p10(ddp_counter_relationships_tbl, p7_a0
929 , p7_a1
930 , p7_a2
931 , p7_a3
932 , p7_a4
933 , p7_a5
934 , p7_a6
935 , p7_a7
936 , p7_a8
937 , p7_a9
938 , p7_a10
939 , p7_a11
940 , p7_a12
941 , p7_a13
942 , p7_a14
943 , p7_a15
944 , p7_a16
945 , p7_a17
946 , p7_a18
947 , p7_a19
948 , p7_a20
949 , p7_a21
950 , p7_a22
951 , p7_a23
952 , p7_a24
953 , p7_a25
954 , p7_a26
955 , p7_a27
956 , p7_a28
957 , p7_a29
958 , p7_a30
959 , p7_a31
960 , p7_a32
961 );
962
963 csi_ctr_datastructures_pub_w.rosetta_table_copy_in_p16(ddp_ctr_derived_filters_tbl, p8_a0
964 , p8_a1
965 , p8_a2
966 , p8_a3
967 , p8_a4
968 , p8_a5
969 , p8_a6
970 , p8_a7
971 , p8_a8
972 , p8_a9
973 , p8_a10
974 , p8_a11
975 , p8_a12
976 , p8_a13
977 , p8_a14
978 , p8_a15
979 , p8_a16
980 , p8_a17
981 , p8_a18
982 , p8_a19
983 , p8_a20
984 , p8_a21
985 , p8_a22
986 , p8_a23
987 , p8_a24
988 , p8_a25
989 , p8_a26
990 , p8_a27
991 , p8_a28
992 , p8_a29
993 , p8_a30
994 , p8_a31
995 , p8_a32
996 , p8_a33
997 , p8_a34
998 );
999
1000
1001
1002
1003 -- here's the delegated call to the old PL/SQL routine
1004 csi_counter_template_pub.create_counter_template(p_api_version,
1005 p_commit,
1006 p_init_msg_list,
1007 p_validation_level,
1008 ddp_counter_template_rec,
1009 ddp_ctr_item_associations_tbl,
1010 ddp_ctr_property_template_tbl,
1011 ddp_counter_relationships_tbl,
1012 ddp_ctr_derived_filters_tbl,
1013 x_return_status,
1014 x_msg_count,
1015 x_msg_data);
1016
1017 -- copy data back from the local variables to OUT or IN-OUT args, if any
1018
1019
1020
1021
1022 p4_a0 := rosetta_g_miss_num_map(ddp_counter_template_rec.counter_id);
1023 p4_a1 := rosetta_g_miss_num_map(ddp_counter_template_rec.group_id);
1024 p4_a2 := ddp_counter_template_rec.counter_type;
1025 p4_a3 := rosetta_g_miss_num_map(ddp_counter_template_rec.initial_reading);
1026 p4_a4 := ddp_counter_template_rec.initial_reading_date;
1027 p4_a5 := rosetta_g_miss_num_map(ddp_counter_template_rec.tolerance_plus);
1028 p4_a6 := rosetta_g_miss_num_map(ddp_counter_template_rec.tolerance_minus);
1029 p4_a7 := ddp_counter_template_rec.uom_code;
1030 p4_a8 := rosetta_g_miss_num_map(ddp_counter_template_rec.derive_counter_id);
1031 p4_a9 := ddp_counter_template_rec.derive_function;
1032 p4_a10 := rosetta_g_miss_num_map(ddp_counter_template_rec.derive_property_id);
1033 p4_a11 := ddp_counter_template_rec.valid_flag;
1034 p4_a12 := ddp_counter_template_rec.formula_incomplete_flag;
1035 p4_a13 := ddp_counter_template_rec.formula_text;
1036 p4_a14 := rosetta_g_miss_num_map(ddp_counter_template_rec.rollover_last_reading);
1037 p4_a15 := rosetta_g_miss_num_map(ddp_counter_template_rec.rollover_first_reading);
1038 p4_a16 := rosetta_g_miss_num_map(ddp_counter_template_rec.usage_item_id);
1039 p4_a17 := rosetta_g_miss_num_map(ddp_counter_template_rec.ctr_val_max_seq_no);
1040 p4_a18 := ddp_counter_template_rec.start_date_active;
1041 p4_a19 := ddp_counter_template_rec.end_date_active;
1042 p4_a20 := rosetta_g_miss_num_map(ddp_counter_template_rec.object_version_number);
1043 p4_a21 := ddp_counter_template_rec.last_update_date;
1044 p4_a22 := rosetta_g_miss_num_map(ddp_counter_template_rec.last_updated_by);
1045 p4_a23 := ddp_counter_template_rec.creation_date;
1046 p4_a24 := rosetta_g_miss_num_map(ddp_counter_template_rec.created_by);
1047 p4_a25 := rosetta_g_miss_num_map(ddp_counter_template_rec.last_update_login);
1048 p4_a26 := ddp_counter_template_rec.attribute1;
1049 p4_a27 := ddp_counter_template_rec.attribute2;
1050 p4_a28 := ddp_counter_template_rec.attribute3;
1051 p4_a29 := ddp_counter_template_rec.attribute4;
1052 p4_a30 := ddp_counter_template_rec.attribute5;
1053 p4_a31 := ddp_counter_template_rec.attribute6;
1054 p4_a32 := ddp_counter_template_rec.attribute7;
1055 p4_a33 := ddp_counter_template_rec.attribute8;
1056 p4_a34 := ddp_counter_template_rec.attribute9;
1057 p4_a35 := ddp_counter_template_rec.attribute10;
1058 p4_a36 := ddp_counter_template_rec.attribute11;
1059 p4_a37 := ddp_counter_template_rec.attribute12;
1060 p4_a38 := ddp_counter_template_rec.attribute13;
1061 p4_a39 := ddp_counter_template_rec.attribute14;
1062 p4_a40 := ddp_counter_template_rec.attribute15;
1063 p4_a41 := ddp_counter_template_rec.attribute16;
1064 p4_a42 := ddp_counter_template_rec.attribute17;
1065 p4_a43 := ddp_counter_template_rec.attribute18;
1066 p4_a44 := ddp_counter_template_rec.attribute19;
1067 p4_a45 := ddp_counter_template_rec.attribute20;
1068 p4_a46 := ddp_counter_template_rec.attribute21;
1069 p4_a47 := ddp_counter_template_rec.attribute22;
1070 p4_a48 := ddp_counter_template_rec.attribute23;
1071 p4_a49 := ddp_counter_template_rec.attribute24;
1072 p4_a50 := ddp_counter_template_rec.attribute25;
1073 p4_a51 := ddp_counter_template_rec.attribute26;
1074 p4_a52 := ddp_counter_template_rec.attribute27;
1075 p4_a53 := ddp_counter_template_rec.attribute28;
1076 p4_a54 := ddp_counter_template_rec.attribute29;
1077 p4_a55 := ddp_counter_template_rec.attribute30;
1078 p4_a56 := ddp_counter_template_rec.attribute_category;
1079 p4_a57 := ddp_counter_template_rec.migrated_flag;
1080 p4_a58 := ddp_counter_template_rec.customer_view;
1081 p4_a59 := ddp_counter_template_rec.direction;
1082 p4_a60 := ddp_counter_template_rec.filter_type;
1083 p4_a61 := rosetta_g_miss_num_map(ddp_counter_template_rec.filter_reading_count);
1084 p4_a62 := ddp_counter_template_rec.filter_time_uom;
1085 p4_a63 := rosetta_g_miss_num_map(ddp_counter_template_rec.estimation_id);
1086 p4_a64 := rosetta_g_miss_num_map(ddp_counter_template_rec.reading_type);
1087 p4_a65 := ddp_counter_template_rec.automatic_rollover;
1088 p4_a66 := rosetta_g_miss_num_map(ddp_counter_template_rec.default_usage_rate);
1089 p4_a67 := rosetta_g_miss_num_map(ddp_counter_template_rec.use_past_reading);
1090 p4_a68 := ddp_counter_template_rec.used_in_scheduling;
1091 p4_a69 := rosetta_g_miss_num_map(ddp_counter_template_rec.defaulted_group_id);
1092 p4_a70 := rosetta_g_miss_num_map(ddp_counter_template_rec.security_group_id);
1093 p4_a71 := ddp_counter_template_rec.name;
1094 p4_a72 := ddp_counter_template_rec.description;
1095 p4_a73 := ddp_counter_template_rec.comments;
1096 p4_a74 := ddp_counter_template_rec.association_type;
1097 p4_a75 := rosetta_g_miss_num_map(ddp_counter_template_rec.step_value);
1098 p4_a76 := ddp_counter_template_rec.time_based_manual_entry;
1099 p4_a77 := ddp_counter_template_rec.eam_required_flag;
1100
1101 csi_ctr_datastructures_pub_w.rosetta_table_copy_out_p8(ddp_ctr_item_associations_tbl, p5_a0
1102 , p5_a1
1103 , p5_a2
1104 , p5_a3
1105 , p5_a4
1106 , p5_a5
1107 , p5_a6
1108 , p5_a7
1109 , p5_a8
1110 , p5_a9
1111 , p5_a10
1112 , p5_a11
1113 , p5_a12
1114 , p5_a13
1115 , p5_a14
1116 , p5_a15
1117 , p5_a16
1118 , p5_a17
1119 , p5_a18
1120 , p5_a19
1121 , p5_a20
1122 , p5_a21
1123 , p5_a22
1124 , p5_a23
1125 , p5_a24
1126 , p5_a25
1127 , p5_a26
1128 , p5_a27
1129 , p5_a28
1130 , p5_a29
1131 , p5_a30
1132 , p5_a31
1133 , p5_a32
1134 , p5_a33
1135 , p5_a34
1136 );
1137
1138 csi_ctr_datastructures_pub_w.rosetta_table_copy_out_p12(ddp_ctr_property_template_tbl, p6_a0
1139 , p6_a1
1140 , p6_a2
1141 , p6_a3
1142 , p6_a4
1143 , p6_a5
1144 , p6_a6
1145 , p6_a7
1146 , p6_a8
1147 , p6_a9
1148 , p6_a10
1149 , p6_a11
1150 , p6_a12
1151 , p6_a13
1152 , p6_a14
1153 , p6_a15
1154 , p6_a16
1155 , p6_a17
1156 , p6_a18
1157 , p6_a19
1158 , p6_a20
1159 , p6_a21
1160 , p6_a22
1161 , p6_a23
1162 , p6_a24
1163 , p6_a25
1164 , p6_a26
1165 , p6_a27
1166 , p6_a28
1167 , p6_a29
1168 , p6_a30
1169 , p6_a31
1170 , p6_a32
1171 , p6_a33
1172 , p6_a34
1173 , p6_a35
1174 , p6_a36
1175 );
1176
1177 csi_ctr_datastructures_pub_w.rosetta_table_copy_out_p10(ddp_counter_relationships_tbl, p7_a0
1178 , p7_a1
1179 , p7_a2
1180 , p7_a3
1181 , p7_a4
1182 , p7_a5
1183 , p7_a6
1184 , p7_a7
1185 , p7_a8
1186 , p7_a9
1187 , p7_a10
1188 , p7_a11
1189 , p7_a12
1190 , p7_a13
1191 , p7_a14
1192 , p7_a15
1193 , p7_a16
1194 , p7_a17
1195 , p7_a18
1196 , p7_a19
1197 , p7_a20
1198 , p7_a21
1199 , p7_a22
1200 , p7_a23
1201 , p7_a24
1202 , p7_a25
1203 , p7_a26
1204 , p7_a27
1205 , p7_a28
1206 , p7_a29
1207 , p7_a30
1208 , p7_a31
1209 , p7_a32
1210 );
1211
1212 csi_ctr_datastructures_pub_w.rosetta_table_copy_out_p16(ddp_ctr_derived_filters_tbl, p8_a0
1213 , p8_a1
1214 , p8_a2
1215 , p8_a3
1216 , p8_a4
1217 , p8_a5
1218 , p8_a6
1219 , p8_a7
1220 , p8_a8
1221 , p8_a9
1222 , p8_a10
1223 , p8_a11
1224 , p8_a12
1225 , p8_a13
1226 , p8_a14
1227 , p8_a15
1228 , p8_a16
1229 , p8_a17
1230 , p8_a18
1231 , p8_a19
1232 , p8_a20
1233 , p8_a21
1234 , p8_a22
1235 , p8_a23
1236 , p8_a24
1237 , p8_a25
1238 , p8_a26
1239 , p8_a27
1240 , p8_a28
1241 , p8_a29
1242 , p8_a30
1243 , p8_a31
1244 , p8_a32
1245 , p8_a33
1246 , p8_a34
1247 );
1248
1249
1250
1251 end;
1252
1253 procedure create_ctr_property_template(p_api_version NUMBER
1254 , p_commit VARCHAR2
1255 , p_init_msg_list VARCHAR2
1256 , p_validation_level NUMBER
1257 , p4_a0 in out nocopy NUMBER
1258 , p4_a1 in out nocopy NUMBER
1259 , p4_a2 in out nocopy VARCHAR2
1260 , p4_a3 in out nocopy VARCHAR2
1261 , p4_a4 in out nocopy VARCHAR2
1262 , p4_a5 in out nocopy VARCHAR2
1263 , p4_a6 in out nocopy VARCHAR2
1264 , p4_a7 in out nocopy VARCHAR2
1265 , p4_a8 in out nocopy DATE
1266 , p4_a9 in out nocopy DATE
1267 , p4_a10 in out nocopy NUMBER
1268 , p4_a11 in out nocopy DATE
1269 , p4_a12 in out nocopy NUMBER
1270 , p4_a13 in out nocopy DATE
1271 , p4_a14 in out nocopy NUMBER
1272 , p4_a15 in out nocopy NUMBER
1273 , p4_a16 in out nocopy VARCHAR2
1274 , p4_a17 in out nocopy VARCHAR2
1275 , p4_a18 in out nocopy VARCHAR2
1276 , p4_a19 in out nocopy VARCHAR2
1277 , p4_a20 in out nocopy VARCHAR2
1278 , p4_a21 in out nocopy VARCHAR2
1279 , p4_a22 in out nocopy VARCHAR2
1280 , p4_a23 in out nocopy VARCHAR2
1281 , p4_a24 in out nocopy VARCHAR2
1282 , p4_a25 in out nocopy VARCHAR2
1283 , p4_a26 in out nocopy VARCHAR2
1284 , p4_a27 in out nocopy VARCHAR2
1285 , p4_a28 in out nocopy VARCHAR2
1286 , p4_a29 in out nocopy VARCHAR2
1287 , p4_a30 in out nocopy VARCHAR2
1288 , p4_a31 in out nocopy VARCHAR2
1289 , p4_a32 in out nocopy VARCHAR2
1290 , p4_a33 in out nocopy VARCHAR2
1291 , p4_a34 in out nocopy NUMBER
1292 , p4_a35 in out nocopy VARCHAR2
1293 , p4_a36 in out nocopy VARCHAR2
1294 , x_return_status out nocopy VARCHAR2
1295 , x_msg_count out nocopy NUMBER
1296 , x_msg_data out nocopy VARCHAR2
1297 )
1298
1299 as
1300 ddp_ctr_property_template_rec csi_ctr_datastructures_pub.ctr_property_template_rec;
1301 ddindx binary_integer; indx binary_integer;
1302 begin
1303
1304 -- copy data to the local IN or IN-OUT args, if any
1305
1306
1307
1308
1309 ddp_ctr_property_template_rec.counter_property_id := rosetta_g_miss_num_map(p4_a0);
1310 ddp_ctr_property_template_rec.counter_id := rosetta_g_miss_num_map(p4_a1);
1311 ddp_ctr_property_template_rec.property_data_type := p4_a2;
1312 ddp_ctr_property_template_rec.is_nullable := p4_a3;
1313 ddp_ctr_property_template_rec.default_value := p4_a4;
1314 ddp_ctr_property_template_rec.minimum_value := p4_a5;
1315 ddp_ctr_property_template_rec.maximum_value := p4_a6;
1316 ddp_ctr_property_template_rec.uom_code := p4_a7;
1317 ddp_ctr_property_template_rec.start_date_active := rosetta_g_miss_date_in_map(p4_a8);
1318 ddp_ctr_property_template_rec.end_date_active := rosetta_g_miss_date_in_map(p4_a9);
1319 ddp_ctr_property_template_rec.object_version_number := rosetta_g_miss_num_map(p4_a10);
1320 ddp_ctr_property_template_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a11);
1321 ddp_ctr_property_template_rec.last_updated_by := rosetta_g_miss_num_map(p4_a12);
1322 ddp_ctr_property_template_rec.creation_date := rosetta_g_miss_date_in_map(p4_a13);
1323 ddp_ctr_property_template_rec.created_by := rosetta_g_miss_num_map(p4_a14);
1324 ddp_ctr_property_template_rec.last_update_login := rosetta_g_miss_num_map(p4_a15);
1325 ddp_ctr_property_template_rec.attribute1 := p4_a16;
1326 ddp_ctr_property_template_rec.attribute2 := p4_a17;
1327 ddp_ctr_property_template_rec.attribute3 := p4_a18;
1328 ddp_ctr_property_template_rec.attribute4 := p4_a19;
1329 ddp_ctr_property_template_rec.attribute5 := p4_a20;
1330 ddp_ctr_property_template_rec.attribute6 := p4_a21;
1331 ddp_ctr_property_template_rec.attribute7 := p4_a22;
1332 ddp_ctr_property_template_rec.attribute8 := p4_a23;
1333 ddp_ctr_property_template_rec.attribute9 := p4_a24;
1334 ddp_ctr_property_template_rec.attribute10 := p4_a25;
1335 ddp_ctr_property_template_rec.attribute11 := p4_a26;
1336 ddp_ctr_property_template_rec.attribute12 := p4_a27;
1337 ddp_ctr_property_template_rec.attribute13 := p4_a28;
1338 ddp_ctr_property_template_rec.attribute14 := p4_a29;
1339 ddp_ctr_property_template_rec.attribute15 := p4_a30;
1340 ddp_ctr_property_template_rec.attribute_category := p4_a31;
1341 ddp_ctr_property_template_rec.migrated_flag := p4_a32;
1342 ddp_ctr_property_template_rec.property_lov_type := p4_a33;
1343 ddp_ctr_property_template_rec.security_group_id := rosetta_g_miss_num_map(p4_a34);
1344 ddp_ctr_property_template_rec.name := p4_a35;
1345 ddp_ctr_property_template_rec.description := p4_a36;
1346
1347
1348
1349
1350 -- here's the delegated call to the old PL/SQL routine
1351 csi_counter_template_pub.create_ctr_property_template(p_api_version,
1352 p_commit,
1353 p_init_msg_list,
1354 p_validation_level,
1355 ddp_ctr_property_template_rec,
1356 x_return_status,
1357 x_msg_count,
1358 x_msg_data);
1359
1360 -- copy data back from the local variables to OUT or IN-OUT args, if any
1361
1362
1363
1364
1365 p4_a0 := rosetta_g_miss_num_map(ddp_ctr_property_template_rec.counter_property_id);
1366 p4_a1 := rosetta_g_miss_num_map(ddp_ctr_property_template_rec.counter_id);
1367 p4_a2 := ddp_ctr_property_template_rec.property_data_type;
1368 p4_a3 := ddp_ctr_property_template_rec.is_nullable;
1369 p4_a4 := ddp_ctr_property_template_rec.default_value;
1370 p4_a5 := ddp_ctr_property_template_rec.minimum_value;
1371 p4_a6 := ddp_ctr_property_template_rec.maximum_value;
1372 p4_a7 := ddp_ctr_property_template_rec.uom_code;
1373 p4_a8 := ddp_ctr_property_template_rec.start_date_active;
1374 p4_a9 := ddp_ctr_property_template_rec.end_date_active;
1375 p4_a10 := rosetta_g_miss_num_map(ddp_ctr_property_template_rec.object_version_number);
1376 p4_a11 := ddp_ctr_property_template_rec.last_update_date;
1377 p4_a12 := rosetta_g_miss_num_map(ddp_ctr_property_template_rec.last_updated_by);
1378 p4_a13 := ddp_ctr_property_template_rec.creation_date;
1379 p4_a14 := rosetta_g_miss_num_map(ddp_ctr_property_template_rec.created_by);
1380 p4_a15 := rosetta_g_miss_num_map(ddp_ctr_property_template_rec.last_update_login);
1381 p4_a16 := ddp_ctr_property_template_rec.attribute1;
1382 p4_a17 := ddp_ctr_property_template_rec.attribute2;
1383 p4_a18 := ddp_ctr_property_template_rec.attribute3;
1384 p4_a19 := ddp_ctr_property_template_rec.attribute4;
1385 p4_a20 := ddp_ctr_property_template_rec.attribute5;
1386 p4_a21 := ddp_ctr_property_template_rec.attribute6;
1387 p4_a22 := ddp_ctr_property_template_rec.attribute7;
1388 p4_a23 := ddp_ctr_property_template_rec.attribute8;
1389 p4_a24 := ddp_ctr_property_template_rec.attribute9;
1390 p4_a25 := ddp_ctr_property_template_rec.attribute10;
1391 p4_a26 := ddp_ctr_property_template_rec.attribute11;
1392 p4_a27 := ddp_ctr_property_template_rec.attribute12;
1393 p4_a28 := ddp_ctr_property_template_rec.attribute13;
1394 p4_a29 := ddp_ctr_property_template_rec.attribute14;
1395 p4_a30 := ddp_ctr_property_template_rec.attribute15;
1396 p4_a31 := ddp_ctr_property_template_rec.attribute_category;
1397 p4_a32 := ddp_ctr_property_template_rec.migrated_flag;
1398 p4_a33 := ddp_ctr_property_template_rec.property_lov_type;
1399 p4_a34 := rosetta_g_miss_num_map(ddp_ctr_property_template_rec.security_group_id);
1400 p4_a35 := ddp_ctr_property_template_rec.name;
1401 p4_a36 := ddp_ctr_property_template_rec.description;
1402
1403
1404
1405 end;
1406
1407 procedure create_counter_relationship(p_api_version NUMBER
1408 , p_commit VARCHAR2
1409 , p_init_msg_list VARCHAR2
1410 , p_validation_level NUMBER
1411 , p4_a0 in out nocopy NUMBER
1412 , p4_a1 in out nocopy NUMBER
1413 , p4_a2 in out nocopy VARCHAR2
1414 , p4_a3 in out nocopy NUMBER
1415 , p4_a4 in out nocopy NUMBER
1416 , p4_a5 in out nocopy DATE
1417 , p4_a6 in out nocopy DATE
1418 , p4_a7 in out nocopy NUMBER
1419 , p4_a8 in out nocopy DATE
1420 , p4_a9 in out nocopy NUMBER
1421 , p4_a10 in out nocopy DATE
1422 , p4_a11 in out nocopy NUMBER
1423 , p4_a12 in out nocopy NUMBER
1424 , p4_a13 in out nocopy VARCHAR2
1425 , p4_a14 in out nocopy VARCHAR2
1426 , p4_a15 in out nocopy VARCHAR2
1427 , p4_a16 in out nocopy VARCHAR2
1428 , p4_a17 in out nocopy VARCHAR2
1429 , p4_a18 in out nocopy VARCHAR2
1430 , p4_a19 in out nocopy VARCHAR2
1431 , p4_a20 in out nocopy VARCHAR2
1432 , p4_a21 in out nocopy VARCHAR2
1433 , p4_a22 in out nocopy VARCHAR2
1434 , p4_a23 in out nocopy VARCHAR2
1435 , p4_a24 in out nocopy VARCHAR2
1436 , p4_a25 in out nocopy VARCHAR2
1437 , p4_a26 in out nocopy VARCHAR2
1438 , p4_a27 in out nocopy VARCHAR2
1439 , p4_a28 in out nocopy VARCHAR2
1440 , p4_a29 in out nocopy NUMBER
1441 , p4_a30 in out nocopy VARCHAR2
1442 , p4_a31 in out nocopy VARCHAR2
1443 , p4_a32 in out nocopy NUMBER
1444 , x_return_status out nocopy VARCHAR2
1445 , x_msg_count out nocopy NUMBER
1446 , x_msg_data out nocopy VARCHAR2
1447 )
1448
1449 as
1450 ddp_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
1451 ddindx binary_integer; indx binary_integer;
1452 begin
1453
1454 -- copy data to the local IN or IN-OUT args, if any
1455
1456
1457
1458
1459 ddp_counter_relationships_rec.relationship_id := rosetta_g_miss_num_map(p4_a0);
1460 ddp_counter_relationships_rec.ctr_association_id := rosetta_g_miss_num_map(p4_a1);
1461 ddp_counter_relationships_rec.relationship_type_code := p4_a2;
1462 ddp_counter_relationships_rec.source_counter_id := rosetta_g_miss_num_map(p4_a3);
1463 ddp_counter_relationships_rec.object_counter_id := rosetta_g_miss_num_map(p4_a4);
1464 ddp_counter_relationships_rec.active_start_date := rosetta_g_miss_date_in_map(p4_a5);
1465 ddp_counter_relationships_rec.active_end_date := rosetta_g_miss_date_in_map(p4_a6);
1466 ddp_counter_relationships_rec.object_version_number := rosetta_g_miss_num_map(p4_a7);
1467 ddp_counter_relationships_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a8);
1468 ddp_counter_relationships_rec.last_updated_by := rosetta_g_miss_num_map(p4_a9);
1469 ddp_counter_relationships_rec.creation_date := rosetta_g_miss_date_in_map(p4_a10);
1470 ddp_counter_relationships_rec.created_by := rosetta_g_miss_num_map(p4_a11);
1471 ddp_counter_relationships_rec.last_update_login := rosetta_g_miss_num_map(p4_a12);
1472 ddp_counter_relationships_rec.attribute_category := p4_a13;
1473 ddp_counter_relationships_rec.attribute1 := p4_a14;
1474 ddp_counter_relationships_rec.attribute2 := p4_a15;
1475 ddp_counter_relationships_rec.attribute3 := p4_a16;
1476 ddp_counter_relationships_rec.attribute4 := p4_a17;
1477 ddp_counter_relationships_rec.attribute5 := p4_a18;
1478 ddp_counter_relationships_rec.attribute6 := p4_a19;
1479 ddp_counter_relationships_rec.attribute7 := p4_a20;
1480 ddp_counter_relationships_rec.attribute8 := p4_a21;
1481 ddp_counter_relationships_rec.attribute9 := p4_a22;
1482 ddp_counter_relationships_rec.attribute10 := p4_a23;
1483 ddp_counter_relationships_rec.attribute11 := p4_a24;
1484 ddp_counter_relationships_rec.attribute12 := p4_a25;
1485 ddp_counter_relationships_rec.attribute13 := p4_a26;
1486 ddp_counter_relationships_rec.attribute14 := p4_a27;
1487 ddp_counter_relationships_rec.attribute15 := p4_a28;
1488 ddp_counter_relationships_rec.security_group_id := rosetta_g_miss_num_map(p4_a29);
1489 ddp_counter_relationships_rec.migrated_flag := p4_a30;
1490 ddp_counter_relationships_rec.bind_variable_name := p4_a31;
1491 ddp_counter_relationships_rec.factor := rosetta_g_miss_num_map(p4_a32);
1492
1493
1494
1495
1496 -- here's the delegated call to the old PL/SQL routine
1497 csi_counter_template_pub.create_counter_relationship(p_api_version,
1498 p_commit,
1499 p_init_msg_list,
1500 p_validation_level,
1501 ddp_counter_relationships_rec,
1502 x_return_status,
1503 x_msg_count,
1504 x_msg_data);
1505
1506 -- copy data back from the local variables to OUT or IN-OUT args, if any
1507
1508
1509
1510
1511 p4_a0 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.relationship_id);
1512 p4_a1 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.ctr_association_id);
1513 p4_a2 := ddp_counter_relationships_rec.relationship_type_code;
1514 p4_a3 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.source_counter_id);
1515 p4_a4 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.object_counter_id);
1516 p4_a5 := ddp_counter_relationships_rec.active_start_date;
1517 p4_a6 := ddp_counter_relationships_rec.active_end_date;
1518 p4_a7 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.object_version_number);
1519 p4_a8 := ddp_counter_relationships_rec.last_update_date;
1520 p4_a9 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.last_updated_by);
1521 p4_a10 := ddp_counter_relationships_rec.creation_date;
1522 p4_a11 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.created_by);
1523 p4_a12 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.last_update_login);
1524 p4_a13 := ddp_counter_relationships_rec.attribute_category;
1525 p4_a14 := ddp_counter_relationships_rec.attribute1;
1526 p4_a15 := ddp_counter_relationships_rec.attribute2;
1527 p4_a16 := ddp_counter_relationships_rec.attribute3;
1528 p4_a17 := ddp_counter_relationships_rec.attribute4;
1529 p4_a18 := ddp_counter_relationships_rec.attribute5;
1530 p4_a19 := ddp_counter_relationships_rec.attribute6;
1531 p4_a20 := ddp_counter_relationships_rec.attribute7;
1532 p4_a21 := ddp_counter_relationships_rec.attribute8;
1533 p4_a22 := ddp_counter_relationships_rec.attribute9;
1534 p4_a23 := ddp_counter_relationships_rec.attribute10;
1535 p4_a24 := ddp_counter_relationships_rec.attribute11;
1536 p4_a25 := ddp_counter_relationships_rec.attribute12;
1537 p4_a26 := ddp_counter_relationships_rec.attribute13;
1538 p4_a27 := ddp_counter_relationships_rec.attribute14;
1539 p4_a28 := ddp_counter_relationships_rec.attribute15;
1540 p4_a29 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.security_group_id);
1541 p4_a30 := ddp_counter_relationships_rec.migrated_flag;
1542 p4_a31 := ddp_counter_relationships_rec.bind_variable_name;
1543 p4_a32 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.factor);
1544
1545
1546
1547 end;
1548
1549 procedure create_derived_filters(p_api_version NUMBER
1550 , p_commit VARCHAR2
1551 , p_init_msg_list VARCHAR2
1552 , p_validation_level NUMBER
1553 , p4_a0 in out nocopy JTF_NUMBER_TABLE
1554 , p4_a1 in out nocopy JTF_NUMBER_TABLE
1555 , p4_a2 in out nocopy JTF_NUMBER_TABLE
1556 , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
1557 , p4_a4 in out nocopy JTF_NUMBER_TABLE
1558 , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
1559 , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_300
1560 , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
1561 , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
1562 , p4_a9 in out nocopy JTF_DATE_TABLE
1563 , p4_a10 in out nocopy JTF_DATE_TABLE
1564 , p4_a11 in out nocopy JTF_NUMBER_TABLE
1565 , p4_a12 in out nocopy JTF_DATE_TABLE
1566 , p4_a13 in out nocopy JTF_NUMBER_TABLE
1567 , p4_a14 in out nocopy JTF_DATE_TABLE
1568 , p4_a15 in out nocopy JTF_NUMBER_TABLE
1569 , p4_a16 in out nocopy JTF_NUMBER_TABLE
1570 , p4_a17 in out nocopy JTF_VARCHAR2_TABLE_200
1571 , p4_a18 in out nocopy JTF_VARCHAR2_TABLE_200
1572 , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_200
1573 , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_200
1574 , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_200
1575 , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_200
1576 , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_200
1577 , p4_a24 in out nocopy JTF_VARCHAR2_TABLE_200
1578 , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_200
1579 , p4_a26 in out nocopy JTF_VARCHAR2_TABLE_200
1580 , p4_a27 in out nocopy JTF_VARCHAR2_TABLE_200
1581 , p4_a28 in out nocopy JTF_VARCHAR2_TABLE_200
1582 , p4_a29 in out nocopy JTF_VARCHAR2_TABLE_200
1583 , p4_a30 in out nocopy JTF_VARCHAR2_TABLE_200
1584 , p4_a31 in out nocopy JTF_VARCHAR2_TABLE_200
1585 , p4_a32 in out nocopy JTF_VARCHAR2_TABLE_100
1586 , p4_a33 in out nocopy JTF_NUMBER_TABLE
1587 , p4_a34 in out nocopy JTF_VARCHAR2_TABLE_100
1588 , x_return_status out nocopy VARCHAR2
1589 , x_msg_count out nocopy NUMBER
1590 , x_msg_data out nocopy VARCHAR2
1591 )
1592
1593 as
1594 ddp_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
1595 ddindx binary_integer; indx binary_integer;
1596 begin
1597
1598 -- copy data to the local IN or IN-OUT args, if any
1599
1600
1601
1602
1603 csi_ctr_datastructures_pub_w.rosetta_table_copy_in_p16(ddp_ctr_derived_filters_tbl, p4_a0
1604 , p4_a1
1605 , p4_a2
1606 , p4_a3
1607 , p4_a4
1608 , p4_a5
1609 , p4_a6
1610 , p4_a7
1611 , p4_a8
1612 , p4_a9
1613 , p4_a10
1614 , p4_a11
1615 , p4_a12
1616 , p4_a13
1617 , p4_a14
1618 , p4_a15
1619 , p4_a16
1620 , p4_a17
1621 , p4_a18
1622 , p4_a19
1623 , p4_a20
1624 , p4_a21
1625 , p4_a22
1626 , p4_a23
1627 , p4_a24
1628 , p4_a25
1629 , p4_a26
1630 , p4_a27
1631 , p4_a28
1632 , p4_a29
1633 , p4_a30
1634 , p4_a31
1635 , p4_a32
1636 , p4_a33
1637 , p4_a34
1638 );
1639
1640
1641
1642
1643 -- here's the delegated call to the old PL/SQL routine
1644 csi_counter_template_pub.create_derived_filters(p_api_version,
1645 p_commit,
1646 p_init_msg_list,
1647 p_validation_level,
1648 ddp_ctr_derived_filters_tbl,
1649 x_return_status,
1650 x_msg_count,
1651 x_msg_data);
1652
1653 -- copy data back from the local variables to OUT or IN-OUT args, if any
1654
1655
1656
1657
1658 csi_ctr_datastructures_pub_w.rosetta_table_copy_out_p16(ddp_ctr_derived_filters_tbl, p4_a0
1659 , p4_a1
1660 , p4_a2
1661 , p4_a3
1662 , p4_a4
1663 , p4_a5
1664 , p4_a6
1665 , p4_a7
1666 , p4_a8
1667 , p4_a9
1668 , p4_a10
1669 , p4_a11
1670 , p4_a12
1671 , p4_a13
1672 , p4_a14
1673 , p4_a15
1674 , p4_a16
1675 , p4_a17
1676 , p4_a18
1677 , p4_a19
1678 , p4_a20
1679 , p4_a21
1680 , p4_a22
1681 , p4_a23
1682 , p4_a24
1683 , p4_a25
1684 , p4_a26
1685 , p4_a27
1686 , p4_a28
1687 , p4_a29
1688 , p4_a30
1689 , p4_a31
1690 , p4_a32
1691 , p4_a33
1692 , p4_a34
1693 );
1694
1695
1696
1697 end;
1698
1699 procedure update_counter_group(p_api_version NUMBER
1700 , p_commit VARCHAR2
1701 , p_init_msg_list VARCHAR2
1702 , p_validation_level NUMBER
1703 , p4_a0 in out nocopy NUMBER
1704 , p4_a1 in out nocopy VARCHAR2
1705 , p4_a2 in out nocopy VARCHAR2
1706 , p4_a3 in out nocopy VARCHAR2
1707 , p4_a4 in out nocopy DATE
1708 , p4_a5 in out nocopy NUMBER
1709 , p4_a6 in out nocopy DATE
1710 , p4_a7 in out nocopy NUMBER
1711 , p4_a8 in out nocopy NUMBER
1712 , p4_a9 in out nocopy DATE
1713 , p4_a10 in out nocopy DATE
1714 , p4_a11 in out nocopy VARCHAR2
1715 , p4_a12 in out nocopy VARCHAR2
1716 , p4_a13 in out nocopy VARCHAR2
1717 , p4_a14 in out nocopy VARCHAR2
1718 , p4_a15 in out nocopy VARCHAR2
1719 , p4_a16 in out nocopy VARCHAR2
1720 , p4_a17 in out nocopy VARCHAR2
1721 , p4_a18 in out nocopy VARCHAR2
1722 , p4_a19 in out nocopy VARCHAR2
1723 , p4_a20 in out nocopy VARCHAR2
1724 , p4_a21 in out nocopy VARCHAR2
1725 , p4_a22 in out nocopy VARCHAR2
1726 , p4_a23 in out nocopy VARCHAR2
1727 , p4_a24 in out nocopy VARCHAR2
1728 , p4_a25 in out nocopy VARCHAR2
1729 , p4_a26 in out nocopy VARCHAR2
1730 , p4_a27 in out nocopy NUMBER
1731 , p4_a28 in out nocopy NUMBER
1732 , p4_a29 in out nocopy VARCHAR2
1733 , p4_a30 in out nocopy VARCHAR2
1734 , p4_a31 in out nocopy NUMBER
1735 , p4_a32 in out nocopy NUMBER
1736 , p4_a33 in out nocopy NUMBER
1737 , p4_a34 in out nocopy VARCHAR2
1738 , p5_a0 in out nocopy JTF_NUMBER_TABLE
1739 , p5_a1 in out nocopy JTF_NUMBER_TABLE
1740 , p5_a2 in out nocopy JTF_NUMBER_TABLE
1741 , p5_a3 in out nocopy JTF_NUMBER_TABLE
1742 , p5_a4 in out nocopy JTF_DATE_TABLE
1743 , p5_a5 in out nocopy JTF_NUMBER_TABLE
1744 , p5_a6 in out nocopy JTF_NUMBER_TABLE
1745 , p5_a7 in out nocopy JTF_DATE_TABLE
1746 , p5_a8 in out nocopy JTF_NUMBER_TABLE
1747 , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_200
1748 , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_200
1749 , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
1750 , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_200
1751 , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_200
1752 , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_200
1753 , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_200
1754 , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_200
1755 , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_200
1756 , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_200
1757 , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_200
1758 , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_200
1759 , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_200
1760 , p5_a22 in out nocopy JTF_VARCHAR2_TABLE_200
1761 , p5_a23 in out nocopy JTF_VARCHAR2_TABLE_200
1762 , p5_a24 in out nocopy JTF_VARCHAR2_TABLE_100
1763 , p5_a25 in out nocopy JTF_NUMBER_TABLE
1764 , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_100
1765 , p5_a27 in out nocopy JTF_NUMBER_TABLE
1766 , p5_a28 in out nocopy JTF_DATE_TABLE
1767 , p5_a29 in out nocopy JTF_DATE_TABLE
1768 , p5_a30 in out nocopy JTF_NUMBER_TABLE
1769 , p5_a31 in out nocopy JTF_NUMBER_TABLE
1770 , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
1771 , p5_a33 in out nocopy JTF_NUMBER_TABLE
1772 , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
1773 , x_return_status out nocopy VARCHAR2
1774 , x_msg_count out nocopy NUMBER
1775 , x_msg_data out nocopy VARCHAR2
1776 )
1777
1778 as
1779 ddp_counter_groups_rec csi_ctr_datastructures_pub.counter_groups_rec;
1780 ddp_ctr_item_associations_tbl csi_ctr_datastructures_pub.ctr_item_associations_tbl;
1781 ddindx binary_integer; indx binary_integer;
1782 begin
1783
1784 -- copy data to the local IN or IN-OUT args, if any
1785
1786
1787
1788
1789 ddp_counter_groups_rec.counter_group_id := rosetta_g_miss_num_map(p4_a0);
1790 ddp_counter_groups_rec.name := p4_a1;
1791 ddp_counter_groups_rec.description := p4_a2;
1792 ddp_counter_groups_rec.template_flag := p4_a3;
1793 ddp_counter_groups_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a4);
1794 ddp_counter_groups_rec.last_updated_by := rosetta_g_miss_num_map(p4_a5);
1795 ddp_counter_groups_rec.creation_date := rosetta_g_miss_date_in_map(p4_a6);
1796 ddp_counter_groups_rec.created_by := rosetta_g_miss_num_map(p4_a7);
1797 ddp_counter_groups_rec.last_update_login := rosetta_g_miss_num_map(p4_a8);
1798 ddp_counter_groups_rec.start_date_active := rosetta_g_miss_date_in_map(p4_a9);
1799 ddp_counter_groups_rec.end_date_active := rosetta_g_miss_date_in_map(p4_a10);
1800 ddp_counter_groups_rec.attribute1 := p4_a11;
1801 ddp_counter_groups_rec.attribute2 := p4_a12;
1802 ddp_counter_groups_rec.attribute3 := p4_a13;
1803 ddp_counter_groups_rec.attribute4 := p4_a14;
1804 ddp_counter_groups_rec.attribute5 := p4_a15;
1805 ddp_counter_groups_rec.attribute6 := p4_a16;
1806 ddp_counter_groups_rec.attribute7 := p4_a17;
1807 ddp_counter_groups_rec.attribute8 := p4_a18;
1808 ddp_counter_groups_rec.attribute9 := p4_a19;
1809 ddp_counter_groups_rec.attribute10 := p4_a20;
1810 ddp_counter_groups_rec.attribute11 := p4_a21;
1811 ddp_counter_groups_rec.attribute12 := p4_a22;
1812 ddp_counter_groups_rec.attribute13 := p4_a23;
1813 ddp_counter_groups_rec.attribute14 := p4_a24;
1814 ddp_counter_groups_rec.attribute15 := p4_a25;
1815 ddp_counter_groups_rec.context := p4_a26;
1816 ddp_counter_groups_rec.object_version_number := rosetta_g_miss_num_map(p4_a27);
1817 ddp_counter_groups_rec.created_from_ctr_grp_tmpl_id := rosetta_g_miss_num_map(p4_a28);
1818 ddp_counter_groups_rec.association_type := p4_a29;
1819 ddp_counter_groups_rec.source_object_code := p4_a30;
1820 ddp_counter_groups_rec.source_object_id := rosetta_g_miss_num_map(p4_a31);
1821 ddp_counter_groups_rec.source_counter_group_id := rosetta_g_miss_num_map(p4_a32);
1822 ddp_counter_groups_rec.security_group_id := rosetta_g_miss_num_map(p4_a33);
1823 ddp_counter_groups_rec.upgraded_status_flag := p4_a34;
1824
1825 csi_ctr_datastructures_pub_w.rosetta_table_copy_in_p8(ddp_ctr_item_associations_tbl, p5_a0
1826 , p5_a1
1827 , p5_a2
1828 , p5_a3
1829 , p5_a4
1830 , p5_a5
1831 , p5_a6
1832 , p5_a7
1833 , p5_a8
1834 , p5_a9
1835 , p5_a10
1836 , p5_a11
1837 , p5_a12
1838 , p5_a13
1839 , p5_a14
1840 , p5_a15
1841 , p5_a16
1842 , p5_a17
1843 , p5_a18
1844 , p5_a19
1845 , p5_a20
1846 , p5_a21
1847 , p5_a22
1848 , p5_a23
1849 , p5_a24
1850 , p5_a25
1851 , p5_a26
1852 , p5_a27
1853 , p5_a28
1854 , p5_a29
1855 , p5_a30
1856 , p5_a31
1857 , p5_a32
1858 , p5_a33
1859 , p5_a34
1860 );
1861
1862
1863
1864
1865 -- here's the delegated call to the old PL/SQL routine
1866 csi_counter_template_pub.update_counter_group(p_api_version,
1867 p_commit,
1868 p_init_msg_list,
1869 p_validation_level,
1870 ddp_counter_groups_rec,
1871 ddp_ctr_item_associations_tbl,
1872 x_return_status,
1873 x_msg_count,
1874 x_msg_data);
1875
1876 -- copy data back from the local variables to OUT or IN-OUT args, if any
1877
1878
1879
1880
1881 p4_a0 := rosetta_g_miss_num_map(ddp_counter_groups_rec.counter_group_id);
1882 p4_a1 := ddp_counter_groups_rec.name;
1883 p4_a2 := ddp_counter_groups_rec.description;
1884 p4_a3 := ddp_counter_groups_rec.template_flag;
1885 p4_a4 := ddp_counter_groups_rec.last_update_date;
1886 p4_a5 := rosetta_g_miss_num_map(ddp_counter_groups_rec.last_updated_by);
1887 p4_a6 := ddp_counter_groups_rec.creation_date;
1888 p4_a7 := rosetta_g_miss_num_map(ddp_counter_groups_rec.created_by);
1889 p4_a8 := rosetta_g_miss_num_map(ddp_counter_groups_rec.last_update_login);
1890 p4_a9 := ddp_counter_groups_rec.start_date_active;
1891 p4_a10 := ddp_counter_groups_rec.end_date_active;
1892 p4_a11 := ddp_counter_groups_rec.attribute1;
1893 p4_a12 := ddp_counter_groups_rec.attribute2;
1894 p4_a13 := ddp_counter_groups_rec.attribute3;
1895 p4_a14 := ddp_counter_groups_rec.attribute4;
1896 p4_a15 := ddp_counter_groups_rec.attribute5;
1897 p4_a16 := ddp_counter_groups_rec.attribute6;
1898 p4_a17 := ddp_counter_groups_rec.attribute7;
1899 p4_a18 := ddp_counter_groups_rec.attribute8;
1900 p4_a19 := ddp_counter_groups_rec.attribute9;
1901 p4_a20 := ddp_counter_groups_rec.attribute10;
1902 p4_a21 := ddp_counter_groups_rec.attribute11;
1903 p4_a22 := ddp_counter_groups_rec.attribute12;
1904 p4_a23 := ddp_counter_groups_rec.attribute13;
1905 p4_a24 := ddp_counter_groups_rec.attribute14;
1906 p4_a25 := ddp_counter_groups_rec.attribute15;
1907 p4_a26 := ddp_counter_groups_rec.context;
1908 p4_a27 := rosetta_g_miss_num_map(ddp_counter_groups_rec.object_version_number);
1909 p4_a28 := rosetta_g_miss_num_map(ddp_counter_groups_rec.created_from_ctr_grp_tmpl_id);
1910 p4_a29 := ddp_counter_groups_rec.association_type;
1911 p4_a30 := ddp_counter_groups_rec.source_object_code;
1912 p4_a31 := rosetta_g_miss_num_map(ddp_counter_groups_rec.source_object_id);
1913 p4_a32 := rosetta_g_miss_num_map(ddp_counter_groups_rec.source_counter_group_id);
1914 p4_a33 := rosetta_g_miss_num_map(ddp_counter_groups_rec.security_group_id);
1915 p4_a34 := ddp_counter_groups_rec.upgraded_status_flag;
1916
1917 csi_ctr_datastructures_pub_w.rosetta_table_copy_out_p8(ddp_ctr_item_associations_tbl, p5_a0
1918 , p5_a1
1919 , p5_a2
1920 , p5_a3
1921 , p5_a4
1922 , p5_a5
1923 , p5_a6
1924 , p5_a7
1925 , p5_a8
1926 , p5_a9
1927 , p5_a10
1928 , p5_a11
1929 , p5_a12
1930 , p5_a13
1931 , p5_a14
1932 , p5_a15
1933 , p5_a16
1934 , p5_a17
1935 , p5_a18
1936 , p5_a19
1937 , p5_a20
1938 , p5_a21
1939 , p5_a22
1940 , p5_a23
1941 , p5_a24
1942 , p5_a25
1943 , p5_a26
1944 , p5_a27
1945 , p5_a28
1946 , p5_a29
1947 , p5_a30
1948 , p5_a31
1949 , p5_a32
1950 , p5_a33
1951 , p5_a34
1952 );
1953
1954
1955
1956 end;
1957
1958 procedure update_item_association(p_api_version NUMBER
1959 , p_commit VARCHAR2
1960 , p_init_msg_list VARCHAR2
1961 , p_validation_level NUMBER
1962 , p4_a0 in out nocopy NUMBER
1963 , p4_a1 in out nocopy NUMBER
1964 , p4_a2 in out nocopy NUMBER
1965 , p4_a3 in out nocopy NUMBER
1966 , p4_a4 in out nocopy DATE
1967 , p4_a5 in out nocopy NUMBER
1968 , p4_a6 in out nocopy NUMBER
1969 , p4_a7 in out nocopy DATE
1970 , p4_a8 in out nocopy NUMBER
1971 , p4_a9 in out nocopy VARCHAR2
1972 , p4_a10 in out nocopy VARCHAR2
1973 , p4_a11 in out nocopy VARCHAR2
1974 , p4_a12 in out nocopy VARCHAR2
1975 , p4_a13 in out nocopy VARCHAR2
1976 , p4_a14 in out nocopy VARCHAR2
1977 , p4_a15 in out nocopy VARCHAR2
1978 , p4_a16 in out nocopy VARCHAR2
1979 , p4_a17 in out nocopy VARCHAR2
1980 , p4_a18 in out nocopy VARCHAR2
1981 , p4_a19 in out nocopy VARCHAR2
1982 , p4_a20 in out nocopy VARCHAR2
1983 , p4_a21 in out nocopy VARCHAR2
1984 , p4_a22 in out nocopy VARCHAR2
1985 , p4_a23 in out nocopy VARCHAR2
1986 , p4_a24 in out nocopy VARCHAR2
1987 , p4_a25 in out nocopy NUMBER
1988 , p4_a26 in out nocopy VARCHAR2
1989 , p4_a27 in out nocopy NUMBER
1990 , p4_a28 in out nocopy DATE
1991 , p4_a29 in out nocopy DATE
1992 , p4_a30 in out nocopy NUMBER
1993 , p4_a31 in out nocopy NUMBER
1994 , p4_a32 in out nocopy VARCHAR2
1995 , p4_a33 in out nocopy NUMBER
1996 , p4_a34 in out nocopy VARCHAR2
1997 , x_return_status out nocopy VARCHAR2
1998 , x_msg_count out nocopy NUMBER
1999 , x_msg_data out nocopy VARCHAR2
2000 )
2001
2002 as
2003 ddp_ctr_item_associations_rec csi_ctr_datastructures_pub.ctr_item_associations_rec;
2004 ddindx binary_integer; indx binary_integer;
2005 begin
2006
2007 -- copy data to the local IN or IN-OUT args, if any
2008
2009
2010
2011
2012 ddp_ctr_item_associations_rec.ctr_association_id := rosetta_g_miss_num_map(p4_a0);
2013 ddp_ctr_item_associations_rec.group_id := rosetta_g_miss_num_map(p4_a1);
2014 ddp_ctr_item_associations_rec.inventory_item_id := rosetta_g_miss_num_map(p4_a2);
2015 ddp_ctr_item_associations_rec.object_version_number := rosetta_g_miss_num_map(p4_a3);
2016 ddp_ctr_item_associations_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a4);
2017 ddp_ctr_item_associations_rec.last_updated_by := rosetta_g_miss_num_map(p4_a5);
2018 ddp_ctr_item_associations_rec.last_update_login := rosetta_g_miss_num_map(p4_a6);
2019 ddp_ctr_item_associations_rec.creation_date := rosetta_g_miss_date_in_map(p4_a7);
2020 ddp_ctr_item_associations_rec.created_by := rosetta_g_miss_num_map(p4_a8);
2021 ddp_ctr_item_associations_rec.attribute1 := p4_a9;
2022 ddp_ctr_item_associations_rec.attribute2 := p4_a10;
2023 ddp_ctr_item_associations_rec.attribute3 := p4_a11;
2024 ddp_ctr_item_associations_rec.attribute4 := p4_a12;
2025 ddp_ctr_item_associations_rec.attribute5 := p4_a13;
2026 ddp_ctr_item_associations_rec.attribute6 := p4_a14;
2027 ddp_ctr_item_associations_rec.attribute7 := p4_a15;
2028 ddp_ctr_item_associations_rec.attribute8 := p4_a16;
2029 ddp_ctr_item_associations_rec.attribute9 := p4_a17;
2030 ddp_ctr_item_associations_rec.attribute10 := p4_a18;
2031 ddp_ctr_item_associations_rec.attribute11 := p4_a19;
2032 ddp_ctr_item_associations_rec.attribute12 := p4_a20;
2033 ddp_ctr_item_associations_rec.attribute13 := p4_a21;
2034 ddp_ctr_item_associations_rec.attribute14 := p4_a22;
2035 ddp_ctr_item_associations_rec.attribute15 := p4_a23;
2036 ddp_ctr_item_associations_rec.attribute_category := p4_a24;
2037 ddp_ctr_item_associations_rec.security_group_id := rosetta_g_miss_num_map(p4_a25);
2038 ddp_ctr_item_associations_rec.migrated_flag := p4_a26;
2039 ddp_ctr_item_associations_rec.counter_id := rosetta_g_miss_num_map(p4_a27);
2040 ddp_ctr_item_associations_rec.start_date_active := rosetta_g_miss_date_in_map(p4_a28);
2041 ddp_ctr_item_associations_rec.end_date_active := rosetta_g_miss_date_in_map(p4_a29);
2042 ddp_ctr_item_associations_rec.usage_rate := rosetta_g_miss_num_map(p4_a30);
2043 ddp_ctr_item_associations_rec.use_past_reading := rosetta_g_miss_num_map(p4_a31);
2044 ddp_ctr_item_associations_rec.associated_to_group := p4_a32;
2045 ddp_ctr_item_associations_rec.maint_organization_id := rosetta_g_miss_num_map(p4_a33);
2046 ddp_ctr_item_associations_rec.primary_failure_flag := p4_a34;
2047
2048
2049
2050
2051 -- here's the delegated call to the old PL/SQL routine
2052 csi_counter_template_pub.update_item_association(p_api_version,
2053 p_commit,
2054 p_init_msg_list,
2055 p_validation_level,
2056 ddp_ctr_item_associations_rec,
2057 x_return_status,
2058 x_msg_count,
2059 x_msg_data);
2060
2061 -- copy data back from the local variables to OUT or IN-OUT args, if any
2062
2063
2064
2065
2066 p4_a0 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.ctr_association_id);
2067 p4_a1 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.group_id);
2068 p4_a2 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.inventory_item_id);
2069 p4_a3 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.object_version_number);
2070 p4_a4 := ddp_ctr_item_associations_rec.last_update_date;
2071 p4_a5 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.last_updated_by);
2072 p4_a6 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.last_update_login);
2073 p4_a7 := ddp_ctr_item_associations_rec.creation_date;
2074 p4_a8 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.created_by);
2075 p4_a9 := ddp_ctr_item_associations_rec.attribute1;
2076 p4_a10 := ddp_ctr_item_associations_rec.attribute2;
2077 p4_a11 := ddp_ctr_item_associations_rec.attribute3;
2078 p4_a12 := ddp_ctr_item_associations_rec.attribute4;
2079 p4_a13 := ddp_ctr_item_associations_rec.attribute5;
2080 p4_a14 := ddp_ctr_item_associations_rec.attribute6;
2081 p4_a15 := ddp_ctr_item_associations_rec.attribute7;
2082 p4_a16 := ddp_ctr_item_associations_rec.attribute8;
2083 p4_a17 := ddp_ctr_item_associations_rec.attribute9;
2084 p4_a18 := ddp_ctr_item_associations_rec.attribute10;
2085 p4_a19 := ddp_ctr_item_associations_rec.attribute11;
2086 p4_a20 := ddp_ctr_item_associations_rec.attribute12;
2087 p4_a21 := ddp_ctr_item_associations_rec.attribute13;
2088 p4_a22 := ddp_ctr_item_associations_rec.attribute14;
2089 p4_a23 := ddp_ctr_item_associations_rec.attribute15;
2090 p4_a24 := ddp_ctr_item_associations_rec.attribute_category;
2091 p4_a25 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.security_group_id);
2092 p4_a26 := ddp_ctr_item_associations_rec.migrated_flag;
2093 p4_a27 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.counter_id);
2094 p4_a28 := ddp_ctr_item_associations_rec.start_date_active;
2095 p4_a29 := ddp_ctr_item_associations_rec.end_date_active;
2096 p4_a30 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.usage_rate);
2097 p4_a31 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.use_past_reading);
2098 p4_a32 := ddp_ctr_item_associations_rec.associated_to_group;
2099 p4_a33 := rosetta_g_miss_num_map(ddp_ctr_item_associations_rec.maint_organization_id);
2100 p4_a34 := ddp_ctr_item_associations_rec.primary_failure_flag;
2101
2102
2103
2104 end;
2105
2106 procedure update_counter_template(p_api_version NUMBER
2107 , p_commit VARCHAR2
2108 , p_init_msg_list VARCHAR2
2109 , p_validation_level NUMBER
2110 , p4_a0 in out nocopy NUMBER
2111 , p4_a1 in out nocopy NUMBER
2112 , p4_a2 in out nocopy VARCHAR2
2113 , p4_a3 in out nocopy NUMBER
2114 , p4_a4 in out nocopy DATE
2115 , p4_a5 in out nocopy NUMBER
2116 , p4_a6 in out nocopy NUMBER
2117 , p4_a7 in out nocopy VARCHAR2
2118 , p4_a8 in out nocopy NUMBER
2119 , p4_a9 in out nocopy VARCHAR2
2120 , p4_a10 in out nocopy NUMBER
2121 , p4_a11 in out nocopy VARCHAR2
2122 , p4_a12 in out nocopy VARCHAR2
2123 , p4_a13 in out nocopy VARCHAR2
2124 , p4_a14 in out nocopy NUMBER
2125 , p4_a15 in out nocopy NUMBER
2126 , p4_a16 in out nocopy NUMBER
2127 , p4_a17 in out nocopy NUMBER
2128 , p4_a18 in out nocopy DATE
2129 , p4_a19 in out nocopy DATE
2130 , p4_a20 in out nocopy NUMBER
2131 , p4_a21 in out nocopy DATE
2132 , p4_a22 in out nocopy NUMBER
2133 , p4_a23 in out nocopy DATE
2134 , p4_a24 in out nocopy NUMBER
2135 , p4_a25 in out nocopy NUMBER
2136 , p4_a26 in out nocopy VARCHAR2
2137 , p4_a27 in out nocopy VARCHAR2
2138 , p4_a28 in out nocopy VARCHAR2
2139 , p4_a29 in out nocopy VARCHAR2
2140 , p4_a30 in out nocopy VARCHAR2
2141 , p4_a31 in out nocopy VARCHAR2
2142 , p4_a32 in out nocopy VARCHAR2
2143 , p4_a33 in out nocopy VARCHAR2
2144 , p4_a34 in out nocopy VARCHAR2
2145 , p4_a35 in out nocopy VARCHAR2
2146 , p4_a36 in out nocopy VARCHAR2
2147 , p4_a37 in out nocopy VARCHAR2
2148 , p4_a38 in out nocopy VARCHAR2
2149 , p4_a39 in out nocopy VARCHAR2
2150 , p4_a40 in out nocopy VARCHAR2
2151 , p4_a41 in out nocopy VARCHAR2
2152 , p4_a42 in out nocopy VARCHAR2
2153 , p4_a43 in out nocopy VARCHAR2
2154 , p4_a44 in out nocopy VARCHAR2
2155 , p4_a45 in out nocopy VARCHAR2
2156 , p4_a46 in out nocopy VARCHAR2
2157 , p4_a47 in out nocopy VARCHAR2
2158 , p4_a48 in out nocopy VARCHAR2
2159 , p4_a49 in out nocopy VARCHAR2
2160 , p4_a50 in out nocopy VARCHAR2
2161 , p4_a51 in out nocopy VARCHAR2
2162 , p4_a52 in out nocopy VARCHAR2
2163 , p4_a53 in out nocopy VARCHAR2
2164 , p4_a54 in out nocopy VARCHAR2
2165 , p4_a55 in out nocopy VARCHAR2
2166 , p4_a56 in out nocopy VARCHAR2
2167 , p4_a57 in out nocopy VARCHAR2
2168 , p4_a58 in out nocopy VARCHAR2
2169 , p4_a59 in out nocopy VARCHAR2
2170 , p4_a60 in out nocopy VARCHAR2
2171 , p4_a61 in out nocopy NUMBER
2172 , p4_a62 in out nocopy VARCHAR2
2173 , p4_a63 in out nocopy NUMBER
2174 , p4_a64 in out nocopy NUMBER
2175 , p4_a65 in out nocopy VARCHAR2
2176 , p4_a66 in out nocopy NUMBER
2177 , p4_a67 in out nocopy NUMBER
2178 , p4_a68 in out nocopy VARCHAR2
2179 , p4_a69 in out nocopy NUMBER
2180 , p4_a70 in out nocopy NUMBER
2181 , p4_a71 in out nocopy VARCHAR2
2182 , p4_a72 in out nocopy VARCHAR2
2183 , p4_a73 in out nocopy VARCHAR2
2184 , p4_a74 in out nocopy VARCHAR2
2185 , p4_a75 in out nocopy NUMBER
2186 , p4_a76 in out nocopy VARCHAR2
2187 , p4_a77 in out nocopy VARCHAR2
2188 , p5_a0 in out nocopy JTF_NUMBER_TABLE
2189 , p5_a1 in out nocopy JTF_NUMBER_TABLE
2190 , p5_a2 in out nocopy JTF_NUMBER_TABLE
2191 , p5_a3 in out nocopy JTF_NUMBER_TABLE
2192 , p5_a4 in out nocopy JTF_DATE_TABLE
2193 , p5_a5 in out nocopy JTF_NUMBER_TABLE
2194 , p5_a6 in out nocopy JTF_NUMBER_TABLE
2195 , p5_a7 in out nocopy JTF_DATE_TABLE
2196 , p5_a8 in out nocopy JTF_NUMBER_TABLE
2197 , p5_a9 in out nocopy JTF_VARCHAR2_TABLE_200
2198 , p5_a10 in out nocopy JTF_VARCHAR2_TABLE_200
2199 , p5_a11 in out nocopy JTF_VARCHAR2_TABLE_200
2200 , p5_a12 in out nocopy JTF_VARCHAR2_TABLE_200
2201 , p5_a13 in out nocopy JTF_VARCHAR2_TABLE_200
2202 , p5_a14 in out nocopy JTF_VARCHAR2_TABLE_200
2203 , p5_a15 in out nocopy JTF_VARCHAR2_TABLE_200
2204 , p5_a16 in out nocopy JTF_VARCHAR2_TABLE_200
2205 , p5_a17 in out nocopy JTF_VARCHAR2_TABLE_200
2206 , p5_a18 in out nocopy JTF_VARCHAR2_TABLE_200
2207 , p5_a19 in out nocopy JTF_VARCHAR2_TABLE_200
2208 , p5_a20 in out nocopy JTF_VARCHAR2_TABLE_200
2209 , p5_a21 in out nocopy JTF_VARCHAR2_TABLE_200
2210 , p5_a22 in out nocopy JTF_VARCHAR2_TABLE_200
2211 , p5_a23 in out nocopy JTF_VARCHAR2_TABLE_200
2212 , p5_a24 in out nocopy JTF_VARCHAR2_TABLE_100
2213 , p5_a25 in out nocopy JTF_NUMBER_TABLE
2214 , p5_a26 in out nocopy JTF_VARCHAR2_TABLE_100
2215 , p5_a27 in out nocopy JTF_NUMBER_TABLE
2216 , p5_a28 in out nocopy JTF_DATE_TABLE
2217 , p5_a29 in out nocopy JTF_DATE_TABLE
2218 , p5_a30 in out nocopy JTF_NUMBER_TABLE
2219 , p5_a31 in out nocopy JTF_NUMBER_TABLE
2220 , p5_a32 in out nocopy JTF_VARCHAR2_TABLE_100
2221 , p5_a33 in out nocopy JTF_NUMBER_TABLE
2222 , p5_a34 in out nocopy JTF_VARCHAR2_TABLE_100
2223 , p6_a0 in out nocopy JTF_NUMBER_TABLE
2224 , p6_a1 in out nocopy JTF_NUMBER_TABLE
2225 , p6_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2226 , p6_a3 in out nocopy JTF_VARCHAR2_TABLE_100
2227 , p6_a4 in out nocopy JTF_VARCHAR2_TABLE_300
2228 , p6_a5 in out nocopy JTF_VARCHAR2_TABLE_300
2229 , p6_a6 in out nocopy JTF_VARCHAR2_TABLE_300
2230 , p6_a7 in out nocopy JTF_VARCHAR2_TABLE_100
2231 , p6_a8 in out nocopy JTF_DATE_TABLE
2232 , p6_a9 in out nocopy JTF_DATE_TABLE
2233 , p6_a10 in out nocopy JTF_NUMBER_TABLE
2234 , p6_a11 in out nocopy JTF_DATE_TABLE
2235 , p6_a12 in out nocopy JTF_NUMBER_TABLE
2236 , p6_a13 in out nocopy JTF_DATE_TABLE
2237 , p6_a14 in out nocopy JTF_NUMBER_TABLE
2238 , p6_a15 in out nocopy JTF_NUMBER_TABLE
2239 , p6_a16 in out nocopy JTF_VARCHAR2_TABLE_200
2240 , p6_a17 in out nocopy JTF_VARCHAR2_TABLE_200
2241 , p6_a18 in out nocopy JTF_VARCHAR2_TABLE_200
2242 , p6_a19 in out nocopy JTF_VARCHAR2_TABLE_200
2243 , p6_a20 in out nocopy JTF_VARCHAR2_TABLE_200
2244 , p6_a21 in out nocopy JTF_VARCHAR2_TABLE_200
2245 , p6_a22 in out nocopy JTF_VARCHAR2_TABLE_200
2246 , p6_a23 in out nocopy JTF_VARCHAR2_TABLE_200
2247 , p6_a24 in out nocopy JTF_VARCHAR2_TABLE_200
2248 , p6_a25 in out nocopy JTF_VARCHAR2_TABLE_200
2249 , p6_a26 in out nocopy JTF_VARCHAR2_TABLE_200
2250 , p6_a27 in out nocopy JTF_VARCHAR2_TABLE_200
2251 , p6_a28 in out nocopy JTF_VARCHAR2_TABLE_200
2252 , p6_a29 in out nocopy JTF_VARCHAR2_TABLE_200
2253 , p6_a30 in out nocopy JTF_VARCHAR2_TABLE_200
2254 , p6_a31 in out nocopy JTF_VARCHAR2_TABLE_100
2255 , p6_a32 in out nocopy JTF_VARCHAR2_TABLE_100
2256 , p6_a33 in out nocopy JTF_VARCHAR2_TABLE_100
2257 , p6_a34 in out nocopy JTF_NUMBER_TABLE
2258 , p6_a35 in out nocopy JTF_VARCHAR2_TABLE_100
2259 , p6_a36 in out nocopy JTF_VARCHAR2_TABLE_300
2260 , p7_a0 in out nocopy JTF_NUMBER_TABLE
2261 , p7_a1 in out nocopy JTF_NUMBER_TABLE
2262 , p7_a2 in out nocopy JTF_VARCHAR2_TABLE_100
2263 , p7_a3 in out nocopy JTF_NUMBER_TABLE
2264 , p7_a4 in out nocopy JTF_NUMBER_TABLE
2265 , p7_a5 in out nocopy JTF_DATE_TABLE
2266 , p7_a6 in out nocopy JTF_DATE_TABLE
2267 , p7_a7 in out nocopy JTF_NUMBER_TABLE
2268 , p7_a8 in out nocopy JTF_DATE_TABLE
2269 , p7_a9 in out nocopy JTF_NUMBER_TABLE
2270 , p7_a10 in out nocopy JTF_DATE_TABLE
2271 , p7_a11 in out nocopy JTF_NUMBER_TABLE
2272 , p7_a12 in out nocopy JTF_NUMBER_TABLE
2273 , p7_a13 in out nocopy JTF_VARCHAR2_TABLE_100
2274 , p7_a14 in out nocopy JTF_VARCHAR2_TABLE_200
2275 , p7_a15 in out nocopy JTF_VARCHAR2_TABLE_200
2276 , p7_a16 in out nocopy JTF_VARCHAR2_TABLE_200
2277 , p7_a17 in out nocopy JTF_VARCHAR2_TABLE_200
2278 , p7_a18 in out nocopy JTF_VARCHAR2_TABLE_200
2279 , p7_a19 in out nocopy JTF_VARCHAR2_TABLE_200
2280 , p7_a20 in out nocopy JTF_VARCHAR2_TABLE_200
2281 , p7_a21 in out nocopy JTF_VARCHAR2_TABLE_200
2282 , p7_a22 in out nocopy JTF_VARCHAR2_TABLE_200
2283 , p7_a23 in out nocopy JTF_VARCHAR2_TABLE_200
2284 , p7_a24 in out nocopy JTF_VARCHAR2_TABLE_200
2285 , p7_a25 in out nocopy JTF_VARCHAR2_TABLE_200
2286 , p7_a26 in out nocopy JTF_VARCHAR2_TABLE_200
2287 , p7_a27 in out nocopy JTF_VARCHAR2_TABLE_200
2288 , p7_a28 in out nocopy JTF_VARCHAR2_TABLE_200
2289 , p7_a29 in out nocopy JTF_NUMBER_TABLE
2290 , p7_a30 in out nocopy JTF_VARCHAR2_TABLE_100
2291 , p7_a31 in out nocopy JTF_VARCHAR2_TABLE_100
2292 , p7_a32 in out nocopy JTF_NUMBER_TABLE
2293 , p8_a0 in out nocopy JTF_NUMBER_TABLE
2294 , p8_a1 in out nocopy JTF_NUMBER_TABLE
2295 , p8_a2 in out nocopy JTF_NUMBER_TABLE
2296 , p8_a3 in out nocopy JTF_VARCHAR2_TABLE_100
2297 , p8_a4 in out nocopy JTF_NUMBER_TABLE
2298 , p8_a5 in out nocopy JTF_VARCHAR2_TABLE_100
2299 , p8_a6 in out nocopy JTF_VARCHAR2_TABLE_300
2300 , p8_a7 in out nocopy JTF_VARCHAR2_TABLE_100
2301 , p8_a8 in out nocopy JTF_VARCHAR2_TABLE_100
2302 , p8_a9 in out nocopy JTF_DATE_TABLE
2303 , p8_a10 in out nocopy JTF_DATE_TABLE
2304 , p8_a11 in out nocopy JTF_NUMBER_TABLE
2305 , p8_a12 in out nocopy JTF_DATE_TABLE
2306 , p8_a13 in out nocopy JTF_NUMBER_TABLE
2307 , p8_a14 in out nocopy JTF_DATE_TABLE
2308 , p8_a15 in out nocopy JTF_NUMBER_TABLE
2309 , p8_a16 in out nocopy JTF_NUMBER_TABLE
2310 , p8_a17 in out nocopy JTF_VARCHAR2_TABLE_200
2311 , p8_a18 in out nocopy JTF_VARCHAR2_TABLE_200
2312 , p8_a19 in out nocopy JTF_VARCHAR2_TABLE_200
2313 , p8_a20 in out nocopy JTF_VARCHAR2_TABLE_200
2314 , p8_a21 in out nocopy JTF_VARCHAR2_TABLE_200
2315 , p8_a22 in out nocopy JTF_VARCHAR2_TABLE_200
2316 , p8_a23 in out nocopy JTF_VARCHAR2_TABLE_200
2317 , p8_a24 in out nocopy JTF_VARCHAR2_TABLE_200
2318 , p8_a25 in out nocopy JTF_VARCHAR2_TABLE_200
2319 , p8_a26 in out nocopy JTF_VARCHAR2_TABLE_200
2320 , p8_a27 in out nocopy JTF_VARCHAR2_TABLE_200
2321 , p8_a28 in out nocopy JTF_VARCHAR2_TABLE_200
2322 , p8_a29 in out nocopy JTF_VARCHAR2_TABLE_200
2323 , p8_a30 in out nocopy JTF_VARCHAR2_TABLE_200
2324 , p8_a31 in out nocopy JTF_VARCHAR2_TABLE_200
2325 , p8_a32 in out nocopy JTF_VARCHAR2_TABLE_100
2326 , p8_a33 in out nocopy JTF_NUMBER_TABLE
2327 , p8_a34 in out nocopy JTF_VARCHAR2_TABLE_100
2328 , x_return_status out nocopy VARCHAR2
2329 , x_msg_count out nocopy NUMBER
2330 , x_msg_data out nocopy VARCHAR2
2331 )
2332
2333 as
2334 ddp_counter_template_rec csi_ctr_datastructures_pub.counter_template_rec;
2335 ddp_ctr_item_associations_tbl csi_ctr_datastructures_pub.ctr_item_associations_tbl;
2336 ddp_ctr_property_template_tbl csi_ctr_datastructures_pub.ctr_property_template_tbl;
2337 ddp_counter_relationships_tbl csi_ctr_datastructures_pub.counter_relationships_tbl;
2338 ddp_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
2339 ddindx binary_integer; indx binary_integer;
2340 begin
2341
2342 -- copy data to the local IN or IN-OUT args, if any
2343
2344
2345
2346
2347 ddp_counter_template_rec.counter_id := rosetta_g_miss_num_map(p4_a0);
2348 ddp_counter_template_rec.group_id := rosetta_g_miss_num_map(p4_a1);
2349 ddp_counter_template_rec.counter_type := p4_a2;
2350 ddp_counter_template_rec.initial_reading := rosetta_g_miss_num_map(p4_a3);
2351 ddp_counter_template_rec.initial_reading_date := rosetta_g_miss_date_in_map(p4_a4);
2352 ddp_counter_template_rec.tolerance_plus := rosetta_g_miss_num_map(p4_a5);
2353 ddp_counter_template_rec.tolerance_minus := rosetta_g_miss_num_map(p4_a6);
2354 ddp_counter_template_rec.uom_code := p4_a7;
2355 ddp_counter_template_rec.derive_counter_id := rosetta_g_miss_num_map(p4_a8);
2356 ddp_counter_template_rec.derive_function := p4_a9;
2357 ddp_counter_template_rec.derive_property_id := rosetta_g_miss_num_map(p4_a10);
2358 ddp_counter_template_rec.valid_flag := p4_a11;
2359 ddp_counter_template_rec.formula_incomplete_flag := p4_a12;
2360 ddp_counter_template_rec.formula_text := p4_a13;
2361 ddp_counter_template_rec.rollover_last_reading := rosetta_g_miss_num_map(p4_a14);
2362 ddp_counter_template_rec.rollover_first_reading := rosetta_g_miss_num_map(p4_a15);
2363 ddp_counter_template_rec.usage_item_id := rosetta_g_miss_num_map(p4_a16);
2364 ddp_counter_template_rec.ctr_val_max_seq_no := rosetta_g_miss_num_map(p4_a17);
2365 ddp_counter_template_rec.start_date_active := rosetta_g_miss_date_in_map(p4_a18);
2366 ddp_counter_template_rec.end_date_active := rosetta_g_miss_date_in_map(p4_a19);
2367 ddp_counter_template_rec.object_version_number := rosetta_g_miss_num_map(p4_a20);
2368 ddp_counter_template_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a21);
2369 ddp_counter_template_rec.last_updated_by := rosetta_g_miss_num_map(p4_a22);
2370 ddp_counter_template_rec.creation_date := rosetta_g_miss_date_in_map(p4_a23);
2371 ddp_counter_template_rec.created_by := rosetta_g_miss_num_map(p4_a24);
2372 ddp_counter_template_rec.last_update_login := rosetta_g_miss_num_map(p4_a25);
2373 ddp_counter_template_rec.attribute1 := p4_a26;
2374 ddp_counter_template_rec.attribute2 := p4_a27;
2375 ddp_counter_template_rec.attribute3 := p4_a28;
2376 ddp_counter_template_rec.attribute4 := p4_a29;
2377 ddp_counter_template_rec.attribute5 := p4_a30;
2378 ddp_counter_template_rec.attribute6 := p4_a31;
2379 ddp_counter_template_rec.attribute7 := p4_a32;
2380 ddp_counter_template_rec.attribute8 := p4_a33;
2381 ddp_counter_template_rec.attribute9 := p4_a34;
2382 ddp_counter_template_rec.attribute10 := p4_a35;
2383 ddp_counter_template_rec.attribute11 := p4_a36;
2384 ddp_counter_template_rec.attribute12 := p4_a37;
2385 ddp_counter_template_rec.attribute13 := p4_a38;
2386 ddp_counter_template_rec.attribute14 := p4_a39;
2387 ddp_counter_template_rec.attribute15 := p4_a40;
2388 ddp_counter_template_rec.attribute16 := p4_a41;
2389 ddp_counter_template_rec.attribute17 := p4_a42;
2390 ddp_counter_template_rec.attribute18 := p4_a43;
2391 ddp_counter_template_rec.attribute19 := p4_a44;
2392 ddp_counter_template_rec.attribute20 := p4_a45;
2393 ddp_counter_template_rec.attribute21 := p4_a46;
2394 ddp_counter_template_rec.attribute22 := p4_a47;
2395 ddp_counter_template_rec.attribute23 := p4_a48;
2396 ddp_counter_template_rec.attribute24 := p4_a49;
2397 ddp_counter_template_rec.attribute25 := p4_a50;
2398 ddp_counter_template_rec.attribute26 := p4_a51;
2399 ddp_counter_template_rec.attribute27 := p4_a52;
2400 ddp_counter_template_rec.attribute28 := p4_a53;
2401 ddp_counter_template_rec.attribute29 := p4_a54;
2402 ddp_counter_template_rec.attribute30 := p4_a55;
2403 ddp_counter_template_rec.attribute_category := p4_a56;
2404 ddp_counter_template_rec.migrated_flag := p4_a57;
2405 ddp_counter_template_rec.customer_view := p4_a58;
2406 ddp_counter_template_rec.direction := p4_a59;
2407 ddp_counter_template_rec.filter_type := p4_a60;
2408 ddp_counter_template_rec.filter_reading_count := rosetta_g_miss_num_map(p4_a61);
2409 ddp_counter_template_rec.filter_time_uom := p4_a62;
2410 ddp_counter_template_rec.estimation_id := rosetta_g_miss_num_map(p4_a63);
2411 ddp_counter_template_rec.reading_type := rosetta_g_miss_num_map(p4_a64);
2412 ddp_counter_template_rec.automatic_rollover := p4_a65;
2413 ddp_counter_template_rec.default_usage_rate := rosetta_g_miss_num_map(p4_a66);
2414 ddp_counter_template_rec.use_past_reading := rosetta_g_miss_num_map(p4_a67);
2415 ddp_counter_template_rec.used_in_scheduling := p4_a68;
2416 ddp_counter_template_rec.defaulted_group_id := rosetta_g_miss_num_map(p4_a69);
2417 ddp_counter_template_rec.security_group_id := rosetta_g_miss_num_map(p4_a70);
2418 ddp_counter_template_rec.name := p4_a71;
2419 ddp_counter_template_rec.description := p4_a72;
2420 ddp_counter_template_rec.comments := p4_a73;
2421 ddp_counter_template_rec.association_type := p4_a74;
2422 ddp_counter_template_rec.step_value := rosetta_g_miss_num_map(p4_a75);
2423 ddp_counter_template_rec.time_based_manual_entry := p4_a76;
2424 ddp_counter_template_rec.eam_required_flag := p4_a77;
2425
2426 csi_ctr_datastructures_pub_w.rosetta_table_copy_in_p8(ddp_ctr_item_associations_tbl, p5_a0
2427 , p5_a1
2428 , p5_a2
2429 , p5_a3
2430 , p5_a4
2431 , p5_a5
2432 , p5_a6
2433 , p5_a7
2434 , p5_a8
2435 , p5_a9
2436 , p5_a10
2437 , p5_a11
2438 , p5_a12
2439 , p5_a13
2440 , p5_a14
2441 , p5_a15
2442 , p5_a16
2443 , p5_a17
2444 , p5_a18
2445 , p5_a19
2446 , p5_a20
2447 , p5_a21
2448 , p5_a22
2449 , p5_a23
2450 , p5_a24
2451 , p5_a25
2452 , p5_a26
2453 , p5_a27
2454 , p5_a28
2455 , p5_a29
2456 , p5_a30
2457 , p5_a31
2458 , p5_a32
2459 , p5_a33
2460 , p5_a34
2461 );
2462
2463 csi_ctr_datastructures_pub_w.rosetta_table_copy_in_p12(ddp_ctr_property_template_tbl, p6_a0
2464 , p6_a1
2465 , p6_a2
2466 , p6_a3
2467 , p6_a4
2468 , p6_a5
2469 , p6_a6
2470 , p6_a7
2471 , p6_a8
2472 , p6_a9
2473 , p6_a10
2474 , p6_a11
2475 , p6_a12
2476 , p6_a13
2477 , p6_a14
2478 , p6_a15
2479 , p6_a16
2480 , p6_a17
2481 , p6_a18
2482 , p6_a19
2483 , p6_a20
2484 , p6_a21
2485 , p6_a22
2486 , p6_a23
2487 , p6_a24
2488 , p6_a25
2489 , p6_a26
2490 , p6_a27
2491 , p6_a28
2492 , p6_a29
2493 , p6_a30
2494 , p6_a31
2495 , p6_a32
2496 , p6_a33
2497 , p6_a34
2498 , p6_a35
2499 , p6_a36
2500 );
2501
2502 csi_ctr_datastructures_pub_w.rosetta_table_copy_in_p10(ddp_counter_relationships_tbl, p7_a0
2503 , p7_a1
2504 , p7_a2
2505 , p7_a3
2506 , p7_a4
2507 , p7_a5
2508 , p7_a6
2509 , p7_a7
2510 , p7_a8
2511 , p7_a9
2512 , p7_a10
2513 , p7_a11
2514 , p7_a12
2515 , p7_a13
2516 , p7_a14
2517 , p7_a15
2518 , p7_a16
2519 , p7_a17
2520 , p7_a18
2521 , p7_a19
2522 , p7_a20
2523 , p7_a21
2524 , p7_a22
2525 , p7_a23
2526 , p7_a24
2527 , p7_a25
2528 , p7_a26
2529 , p7_a27
2530 , p7_a28
2531 , p7_a29
2532 , p7_a30
2533 , p7_a31
2534 , p7_a32
2535 );
2536
2537 csi_ctr_datastructures_pub_w.rosetta_table_copy_in_p16(ddp_ctr_derived_filters_tbl, p8_a0
2538 , p8_a1
2539 , p8_a2
2540 , p8_a3
2541 , p8_a4
2542 , p8_a5
2543 , p8_a6
2544 , p8_a7
2545 , p8_a8
2546 , p8_a9
2547 , p8_a10
2548 , p8_a11
2549 , p8_a12
2550 , p8_a13
2551 , p8_a14
2552 , p8_a15
2553 , p8_a16
2554 , p8_a17
2555 , p8_a18
2556 , p8_a19
2557 , p8_a20
2558 , p8_a21
2559 , p8_a22
2560 , p8_a23
2561 , p8_a24
2562 , p8_a25
2563 , p8_a26
2564 , p8_a27
2565 , p8_a28
2566 , p8_a29
2567 , p8_a30
2568 , p8_a31
2569 , p8_a32
2570 , p8_a33
2571 , p8_a34
2572 );
2573
2574
2575
2576
2577 -- here's the delegated call to the old PL/SQL routine
2578 csi_counter_template_pub.update_counter_template(p_api_version,
2579 p_commit,
2580 p_init_msg_list,
2581 p_validation_level,
2582 ddp_counter_template_rec,
2583 ddp_ctr_item_associations_tbl,
2584 ddp_ctr_property_template_tbl,
2585 ddp_counter_relationships_tbl,
2586 ddp_ctr_derived_filters_tbl,
2587 x_return_status,
2588 x_msg_count,
2589 x_msg_data);
2590
2591 -- copy data back from the local variables to OUT or IN-OUT args, if any
2592
2593
2594
2595
2596 p4_a0 := rosetta_g_miss_num_map(ddp_counter_template_rec.counter_id);
2597 p4_a1 := rosetta_g_miss_num_map(ddp_counter_template_rec.group_id);
2598 p4_a2 := ddp_counter_template_rec.counter_type;
2599 p4_a3 := rosetta_g_miss_num_map(ddp_counter_template_rec.initial_reading);
2600 p4_a4 := ddp_counter_template_rec.initial_reading_date;
2601 p4_a5 := rosetta_g_miss_num_map(ddp_counter_template_rec.tolerance_plus);
2602 p4_a6 := rosetta_g_miss_num_map(ddp_counter_template_rec.tolerance_minus);
2603 p4_a7 := ddp_counter_template_rec.uom_code;
2604 p4_a8 := rosetta_g_miss_num_map(ddp_counter_template_rec.derive_counter_id);
2605 p4_a9 := ddp_counter_template_rec.derive_function;
2606 p4_a10 := rosetta_g_miss_num_map(ddp_counter_template_rec.derive_property_id);
2607 p4_a11 := ddp_counter_template_rec.valid_flag;
2608 p4_a12 := ddp_counter_template_rec.formula_incomplete_flag;
2609 p4_a13 := ddp_counter_template_rec.formula_text;
2610 p4_a14 := rosetta_g_miss_num_map(ddp_counter_template_rec.rollover_last_reading);
2611 p4_a15 := rosetta_g_miss_num_map(ddp_counter_template_rec.rollover_first_reading);
2612 p4_a16 := rosetta_g_miss_num_map(ddp_counter_template_rec.usage_item_id);
2613 p4_a17 := rosetta_g_miss_num_map(ddp_counter_template_rec.ctr_val_max_seq_no);
2614 p4_a18 := ddp_counter_template_rec.start_date_active;
2615 p4_a19 := ddp_counter_template_rec.end_date_active;
2616 p4_a20 := rosetta_g_miss_num_map(ddp_counter_template_rec.object_version_number);
2617 p4_a21 := ddp_counter_template_rec.last_update_date;
2618 p4_a22 := rosetta_g_miss_num_map(ddp_counter_template_rec.last_updated_by);
2619 p4_a23 := ddp_counter_template_rec.creation_date;
2620 p4_a24 := rosetta_g_miss_num_map(ddp_counter_template_rec.created_by);
2621 p4_a25 := rosetta_g_miss_num_map(ddp_counter_template_rec.last_update_login);
2622 p4_a26 := ddp_counter_template_rec.attribute1;
2623 p4_a27 := ddp_counter_template_rec.attribute2;
2624 p4_a28 := ddp_counter_template_rec.attribute3;
2625 p4_a29 := ddp_counter_template_rec.attribute4;
2626 p4_a30 := ddp_counter_template_rec.attribute5;
2627 p4_a31 := ddp_counter_template_rec.attribute6;
2628 p4_a32 := ddp_counter_template_rec.attribute7;
2629 p4_a33 := ddp_counter_template_rec.attribute8;
2630 p4_a34 := ddp_counter_template_rec.attribute9;
2631 p4_a35 := ddp_counter_template_rec.attribute10;
2632 p4_a36 := ddp_counter_template_rec.attribute11;
2633 p4_a37 := ddp_counter_template_rec.attribute12;
2634 p4_a38 := ddp_counter_template_rec.attribute13;
2635 p4_a39 := ddp_counter_template_rec.attribute14;
2636 p4_a40 := ddp_counter_template_rec.attribute15;
2637 p4_a41 := ddp_counter_template_rec.attribute16;
2638 p4_a42 := ddp_counter_template_rec.attribute17;
2639 p4_a43 := ddp_counter_template_rec.attribute18;
2640 p4_a44 := ddp_counter_template_rec.attribute19;
2641 p4_a45 := ddp_counter_template_rec.attribute20;
2642 p4_a46 := ddp_counter_template_rec.attribute21;
2643 p4_a47 := ddp_counter_template_rec.attribute22;
2644 p4_a48 := ddp_counter_template_rec.attribute23;
2645 p4_a49 := ddp_counter_template_rec.attribute24;
2646 p4_a50 := ddp_counter_template_rec.attribute25;
2647 p4_a51 := ddp_counter_template_rec.attribute26;
2648 p4_a52 := ddp_counter_template_rec.attribute27;
2649 p4_a53 := ddp_counter_template_rec.attribute28;
2650 p4_a54 := ddp_counter_template_rec.attribute29;
2651 p4_a55 := ddp_counter_template_rec.attribute30;
2652 p4_a56 := ddp_counter_template_rec.attribute_category;
2653 p4_a57 := ddp_counter_template_rec.migrated_flag;
2654 p4_a58 := ddp_counter_template_rec.customer_view;
2655 p4_a59 := ddp_counter_template_rec.direction;
2656 p4_a60 := ddp_counter_template_rec.filter_type;
2657 p4_a61 := rosetta_g_miss_num_map(ddp_counter_template_rec.filter_reading_count);
2658 p4_a62 := ddp_counter_template_rec.filter_time_uom;
2659 p4_a63 := rosetta_g_miss_num_map(ddp_counter_template_rec.estimation_id);
2660 p4_a64 := rosetta_g_miss_num_map(ddp_counter_template_rec.reading_type);
2661 p4_a65 := ddp_counter_template_rec.automatic_rollover;
2662 p4_a66 := rosetta_g_miss_num_map(ddp_counter_template_rec.default_usage_rate);
2663 p4_a67 := rosetta_g_miss_num_map(ddp_counter_template_rec.use_past_reading);
2664 p4_a68 := ddp_counter_template_rec.used_in_scheduling;
2665 p4_a69 := rosetta_g_miss_num_map(ddp_counter_template_rec.defaulted_group_id);
2666 p4_a70 := rosetta_g_miss_num_map(ddp_counter_template_rec.security_group_id);
2667 p4_a71 := ddp_counter_template_rec.name;
2668 p4_a72 := ddp_counter_template_rec.description;
2669 p4_a73 := ddp_counter_template_rec.comments;
2670 p4_a74 := ddp_counter_template_rec.association_type;
2671 p4_a75 := rosetta_g_miss_num_map(ddp_counter_template_rec.step_value);
2672 p4_a76 := ddp_counter_template_rec.time_based_manual_entry;
2673 p4_a77 := ddp_counter_template_rec.eam_required_flag;
2674
2675 csi_ctr_datastructures_pub_w.rosetta_table_copy_out_p8(ddp_ctr_item_associations_tbl, p5_a0
2676 , p5_a1
2677 , p5_a2
2678 , p5_a3
2679 , p5_a4
2680 , p5_a5
2681 , p5_a6
2682 , p5_a7
2683 , p5_a8
2684 , p5_a9
2685 , p5_a10
2686 , p5_a11
2687 , p5_a12
2688 , p5_a13
2689 , p5_a14
2690 , p5_a15
2691 , p5_a16
2692 , p5_a17
2693 , p5_a18
2694 , p5_a19
2695 , p5_a20
2696 , p5_a21
2697 , p5_a22
2698 , p5_a23
2699 , p5_a24
2700 , p5_a25
2701 , p5_a26
2702 , p5_a27
2703 , p5_a28
2704 , p5_a29
2705 , p5_a30
2706 , p5_a31
2707 , p5_a32
2708 , p5_a33
2709 , p5_a34
2710 );
2711
2712 csi_ctr_datastructures_pub_w.rosetta_table_copy_out_p12(ddp_ctr_property_template_tbl, p6_a0
2713 , p6_a1
2714 , p6_a2
2715 , p6_a3
2716 , p6_a4
2717 , p6_a5
2718 , p6_a6
2719 , p6_a7
2720 , p6_a8
2721 , p6_a9
2722 , p6_a10
2723 , p6_a11
2724 , p6_a12
2725 , p6_a13
2726 , p6_a14
2727 , p6_a15
2728 , p6_a16
2729 , p6_a17
2730 , p6_a18
2731 , p6_a19
2732 , p6_a20
2733 , p6_a21
2734 , p6_a22
2735 , p6_a23
2736 , p6_a24
2737 , p6_a25
2738 , p6_a26
2739 , p6_a27
2740 , p6_a28
2741 , p6_a29
2742 , p6_a30
2743 , p6_a31
2744 , p6_a32
2745 , p6_a33
2746 , p6_a34
2747 , p6_a35
2748 , p6_a36
2749 );
2750
2751 csi_ctr_datastructures_pub_w.rosetta_table_copy_out_p10(ddp_counter_relationships_tbl, p7_a0
2752 , p7_a1
2753 , p7_a2
2754 , p7_a3
2755 , p7_a4
2756 , p7_a5
2757 , p7_a6
2758 , p7_a7
2759 , p7_a8
2760 , p7_a9
2761 , p7_a10
2762 , p7_a11
2763 , p7_a12
2764 , p7_a13
2765 , p7_a14
2766 , p7_a15
2767 , p7_a16
2768 , p7_a17
2769 , p7_a18
2770 , p7_a19
2771 , p7_a20
2772 , p7_a21
2773 , p7_a22
2774 , p7_a23
2775 , p7_a24
2776 , p7_a25
2777 , p7_a26
2778 , p7_a27
2779 , p7_a28
2780 , p7_a29
2781 , p7_a30
2782 , p7_a31
2783 , p7_a32
2784 );
2785
2786 csi_ctr_datastructures_pub_w.rosetta_table_copy_out_p16(ddp_ctr_derived_filters_tbl, p8_a0
2787 , p8_a1
2788 , p8_a2
2789 , p8_a3
2790 , p8_a4
2791 , p8_a5
2792 , p8_a6
2793 , p8_a7
2794 , p8_a8
2795 , p8_a9
2796 , p8_a10
2797 , p8_a11
2798 , p8_a12
2799 , p8_a13
2800 , p8_a14
2801 , p8_a15
2802 , p8_a16
2803 , p8_a17
2804 , p8_a18
2805 , p8_a19
2806 , p8_a20
2807 , p8_a21
2808 , p8_a22
2809 , p8_a23
2810 , p8_a24
2811 , p8_a25
2812 , p8_a26
2813 , p8_a27
2814 , p8_a28
2815 , p8_a29
2816 , p8_a30
2817 , p8_a31
2818 , p8_a32
2819 , p8_a33
2820 , p8_a34
2821 );
2822
2823
2824
2825 end;
2826
2827 procedure update_ctr_property_template(p_api_version NUMBER
2828 , p_commit VARCHAR2
2829 , p_init_msg_list VARCHAR2
2830 , p_validation_level NUMBER
2831 , p4_a0 in out nocopy NUMBER
2832 , p4_a1 in out nocopy NUMBER
2833 , p4_a2 in out nocopy VARCHAR2
2834 , p4_a3 in out nocopy VARCHAR2
2835 , p4_a4 in out nocopy VARCHAR2
2836 , p4_a5 in out nocopy VARCHAR2
2837 , p4_a6 in out nocopy VARCHAR2
2838 , p4_a7 in out nocopy VARCHAR2
2839 , p4_a8 in out nocopy DATE
2840 , p4_a9 in out nocopy DATE
2841 , p4_a10 in out nocopy NUMBER
2842 , p4_a11 in out nocopy DATE
2843 , p4_a12 in out nocopy NUMBER
2844 , p4_a13 in out nocopy DATE
2845 , p4_a14 in out nocopy NUMBER
2846 , p4_a15 in out nocopy NUMBER
2847 , p4_a16 in out nocopy VARCHAR2
2848 , p4_a17 in out nocopy VARCHAR2
2849 , p4_a18 in out nocopy VARCHAR2
2850 , p4_a19 in out nocopy VARCHAR2
2851 , p4_a20 in out nocopy VARCHAR2
2852 , p4_a21 in out nocopy VARCHAR2
2853 , p4_a22 in out nocopy VARCHAR2
2854 , p4_a23 in out nocopy VARCHAR2
2855 , p4_a24 in out nocopy VARCHAR2
2856 , p4_a25 in out nocopy VARCHAR2
2857 , p4_a26 in out nocopy VARCHAR2
2858 , p4_a27 in out nocopy VARCHAR2
2859 , p4_a28 in out nocopy VARCHAR2
2860 , p4_a29 in out nocopy VARCHAR2
2861 , p4_a30 in out nocopy VARCHAR2
2862 , p4_a31 in out nocopy VARCHAR2
2863 , p4_a32 in out nocopy VARCHAR2
2864 , p4_a33 in out nocopy VARCHAR2
2865 , p4_a34 in out nocopy NUMBER
2866 , p4_a35 in out nocopy VARCHAR2
2867 , p4_a36 in out nocopy VARCHAR2
2868 , x_return_status out nocopy VARCHAR2
2869 , x_msg_count out nocopy NUMBER
2870 , x_msg_data out nocopy VARCHAR2
2871 )
2872
2873 as
2874 ddp_ctr_property_template_rec csi_ctr_datastructures_pub.ctr_property_template_rec;
2875 ddindx binary_integer; indx binary_integer;
2876 begin
2877
2878 -- copy data to the local IN or IN-OUT args, if any
2879
2880
2881
2882
2883 ddp_ctr_property_template_rec.counter_property_id := rosetta_g_miss_num_map(p4_a0);
2884 ddp_ctr_property_template_rec.counter_id := rosetta_g_miss_num_map(p4_a1);
2885 ddp_ctr_property_template_rec.property_data_type := p4_a2;
2886 ddp_ctr_property_template_rec.is_nullable := p4_a3;
2887 ddp_ctr_property_template_rec.default_value := p4_a4;
2888 ddp_ctr_property_template_rec.minimum_value := p4_a5;
2889 ddp_ctr_property_template_rec.maximum_value := p4_a6;
2890 ddp_ctr_property_template_rec.uom_code := p4_a7;
2891 ddp_ctr_property_template_rec.start_date_active := rosetta_g_miss_date_in_map(p4_a8);
2892 ddp_ctr_property_template_rec.end_date_active := rosetta_g_miss_date_in_map(p4_a9);
2893 ddp_ctr_property_template_rec.object_version_number := rosetta_g_miss_num_map(p4_a10);
2894 ddp_ctr_property_template_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a11);
2895 ddp_ctr_property_template_rec.last_updated_by := rosetta_g_miss_num_map(p4_a12);
2896 ddp_ctr_property_template_rec.creation_date := rosetta_g_miss_date_in_map(p4_a13);
2897 ddp_ctr_property_template_rec.created_by := rosetta_g_miss_num_map(p4_a14);
2898 ddp_ctr_property_template_rec.last_update_login := rosetta_g_miss_num_map(p4_a15);
2899 ddp_ctr_property_template_rec.attribute1 := p4_a16;
2900 ddp_ctr_property_template_rec.attribute2 := p4_a17;
2901 ddp_ctr_property_template_rec.attribute3 := p4_a18;
2902 ddp_ctr_property_template_rec.attribute4 := p4_a19;
2903 ddp_ctr_property_template_rec.attribute5 := p4_a20;
2904 ddp_ctr_property_template_rec.attribute6 := p4_a21;
2905 ddp_ctr_property_template_rec.attribute7 := p4_a22;
2906 ddp_ctr_property_template_rec.attribute8 := p4_a23;
2907 ddp_ctr_property_template_rec.attribute9 := p4_a24;
2908 ddp_ctr_property_template_rec.attribute10 := p4_a25;
2909 ddp_ctr_property_template_rec.attribute11 := p4_a26;
2910 ddp_ctr_property_template_rec.attribute12 := p4_a27;
2911 ddp_ctr_property_template_rec.attribute13 := p4_a28;
2912 ddp_ctr_property_template_rec.attribute14 := p4_a29;
2913 ddp_ctr_property_template_rec.attribute15 := p4_a30;
2914 ddp_ctr_property_template_rec.attribute_category := p4_a31;
2915 ddp_ctr_property_template_rec.migrated_flag := p4_a32;
2916 ddp_ctr_property_template_rec.property_lov_type := p4_a33;
2917 ddp_ctr_property_template_rec.security_group_id := rosetta_g_miss_num_map(p4_a34);
2918 ddp_ctr_property_template_rec.name := p4_a35;
2919 ddp_ctr_property_template_rec.description := p4_a36;
2920
2921
2922
2923
2924 -- here's the delegated call to the old PL/SQL routine
2925 csi_counter_template_pub.update_ctr_property_template(p_api_version,
2926 p_commit,
2927 p_init_msg_list,
2928 p_validation_level,
2929 ddp_ctr_property_template_rec,
2930 x_return_status,
2931 x_msg_count,
2932 x_msg_data);
2933
2934 -- copy data back from the local variables to OUT or IN-OUT args, if any
2935
2936
2937
2938
2939 p4_a0 := rosetta_g_miss_num_map(ddp_ctr_property_template_rec.counter_property_id);
2940 p4_a1 := rosetta_g_miss_num_map(ddp_ctr_property_template_rec.counter_id);
2941 p4_a2 := ddp_ctr_property_template_rec.property_data_type;
2942 p4_a3 := ddp_ctr_property_template_rec.is_nullable;
2943 p4_a4 := ddp_ctr_property_template_rec.default_value;
2944 p4_a5 := ddp_ctr_property_template_rec.minimum_value;
2945 p4_a6 := ddp_ctr_property_template_rec.maximum_value;
2946 p4_a7 := ddp_ctr_property_template_rec.uom_code;
2947 p4_a8 := ddp_ctr_property_template_rec.start_date_active;
2948 p4_a9 := ddp_ctr_property_template_rec.end_date_active;
2949 p4_a10 := rosetta_g_miss_num_map(ddp_ctr_property_template_rec.object_version_number);
2950 p4_a11 := ddp_ctr_property_template_rec.last_update_date;
2951 p4_a12 := rosetta_g_miss_num_map(ddp_ctr_property_template_rec.last_updated_by);
2952 p4_a13 := ddp_ctr_property_template_rec.creation_date;
2953 p4_a14 := rosetta_g_miss_num_map(ddp_ctr_property_template_rec.created_by);
2954 p4_a15 := rosetta_g_miss_num_map(ddp_ctr_property_template_rec.last_update_login);
2955 p4_a16 := ddp_ctr_property_template_rec.attribute1;
2956 p4_a17 := ddp_ctr_property_template_rec.attribute2;
2957 p4_a18 := ddp_ctr_property_template_rec.attribute3;
2958 p4_a19 := ddp_ctr_property_template_rec.attribute4;
2959 p4_a20 := ddp_ctr_property_template_rec.attribute5;
2960 p4_a21 := ddp_ctr_property_template_rec.attribute6;
2961 p4_a22 := ddp_ctr_property_template_rec.attribute7;
2962 p4_a23 := ddp_ctr_property_template_rec.attribute8;
2963 p4_a24 := ddp_ctr_property_template_rec.attribute9;
2964 p4_a25 := ddp_ctr_property_template_rec.attribute10;
2965 p4_a26 := ddp_ctr_property_template_rec.attribute11;
2966 p4_a27 := ddp_ctr_property_template_rec.attribute12;
2967 p4_a28 := ddp_ctr_property_template_rec.attribute13;
2968 p4_a29 := ddp_ctr_property_template_rec.attribute14;
2969 p4_a30 := ddp_ctr_property_template_rec.attribute15;
2970 p4_a31 := ddp_ctr_property_template_rec.attribute_category;
2971 p4_a32 := ddp_ctr_property_template_rec.migrated_flag;
2972 p4_a33 := ddp_ctr_property_template_rec.property_lov_type;
2973 p4_a34 := rosetta_g_miss_num_map(ddp_ctr_property_template_rec.security_group_id);
2974 p4_a35 := ddp_ctr_property_template_rec.name;
2975 p4_a36 := ddp_ctr_property_template_rec.description;
2976
2977
2978
2979 end;
2980
2981 procedure update_counter_relationship(p_api_version NUMBER
2982 , p_commit VARCHAR2
2983 , p_init_msg_list VARCHAR2
2984 , p_validation_level NUMBER
2985 , p4_a0 in out nocopy NUMBER
2986 , p4_a1 in out nocopy NUMBER
2987 , p4_a2 in out nocopy VARCHAR2
2988 , p4_a3 in out nocopy NUMBER
2989 , p4_a4 in out nocopy NUMBER
2990 , p4_a5 in out nocopy DATE
2991 , p4_a6 in out nocopy DATE
2992 , p4_a7 in out nocopy NUMBER
2993 , p4_a8 in out nocopy DATE
2994 , p4_a9 in out nocopy NUMBER
2995 , p4_a10 in out nocopy DATE
2996 , p4_a11 in out nocopy NUMBER
2997 , p4_a12 in out nocopy NUMBER
2998 , p4_a13 in out nocopy VARCHAR2
2999 , p4_a14 in out nocopy VARCHAR2
3000 , p4_a15 in out nocopy VARCHAR2
3001 , p4_a16 in out nocopy VARCHAR2
3002 , p4_a17 in out nocopy VARCHAR2
3003 , p4_a18 in out nocopy VARCHAR2
3004 , p4_a19 in out nocopy VARCHAR2
3005 , p4_a20 in out nocopy VARCHAR2
3006 , p4_a21 in out nocopy VARCHAR2
3007 , p4_a22 in out nocopy VARCHAR2
3008 , p4_a23 in out nocopy VARCHAR2
3009 , p4_a24 in out nocopy VARCHAR2
3010 , p4_a25 in out nocopy VARCHAR2
3011 , p4_a26 in out nocopy VARCHAR2
3012 , p4_a27 in out nocopy VARCHAR2
3013 , p4_a28 in out nocopy VARCHAR2
3014 , p4_a29 in out nocopy NUMBER
3015 , p4_a30 in out nocopy VARCHAR2
3016 , p4_a31 in out nocopy VARCHAR2
3017 , p4_a32 in out nocopy NUMBER
3018 , x_return_status out nocopy VARCHAR2
3019 , x_msg_count out nocopy NUMBER
3020 , x_msg_data out nocopy VARCHAR2
3021 )
3022
3023 as
3024 ddp_counter_relationships_rec csi_ctr_datastructures_pub.counter_relationships_rec;
3025 ddindx binary_integer; indx binary_integer;
3026 begin
3027
3028 -- copy data to the local IN or IN-OUT args, if any
3029
3030
3031
3032
3033 ddp_counter_relationships_rec.relationship_id := rosetta_g_miss_num_map(p4_a0);
3034 ddp_counter_relationships_rec.ctr_association_id := rosetta_g_miss_num_map(p4_a1);
3035 ddp_counter_relationships_rec.relationship_type_code := p4_a2;
3036 ddp_counter_relationships_rec.source_counter_id := rosetta_g_miss_num_map(p4_a3);
3037 ddp_counter_relationships_rec.object_counter_id := rosetta_g_miss_num_map(p4_a4);
3038 ddp_counter_relationships_rec.active_start_date := rosetta_g_miss_date_in_map(p4_a5);
3039 ddp_counter_relationships_rec.active_end_date := rosetta_g_miss_date_in_map(p4_a6);
3040 ddp_counter_relationships_rec.object_version_number := rosetta_g_miss_num_map(p4_a7);
3041 ddp_counter_relationships_rec.last_update_date := rosetta_g_miss_date_in_map(p4_a8);
3042 ddp_counter_relationships_rec.last_updated_by := rosetta_g_miss_num_map(p4_a9);
3043 ddp_counter_relationships_rec.creation_date := rosetta_g_miss_date_in_map(p4_a10);
3044 ddp_counter_relationships_rec.created_by := rosetta_g_miss_num_map(p4_a11);
3045 ddp_counter_relationships_rec.last_update_login := rosetta_g_miss_num_map(p4_a12);
3046 ddp_counter_relationships_rec.attribute_category := p4_a13;
3047 ddp_counter_relationships_rec.attribute1 := p4_a14;
3048 ddp_counter_relationships_rec.attribute2 := p4_a15;
3049 ddp_counter_relationships_rec.attribute3 := p4_a16;
3050 ddp_counter_relationships_rec.attribute4 := p4_a17;
3051 ddp_counter_relationships_rec.attribute5 := p4_a18;
3052 ddp_counter_relationships_rec.attribute6 := p4_a19;
3053 ddp_counter_relationships_rec.attribute7 := p4_a20;
3054 ddp_counter_relationships_rec.attribute8 := p4_a21;
3055 ddp_counter_relationships_rec.attribute9 := p4_a22;
3056 ddp_counter_relationships_rec.attribute10 := p4_a23;
3057 ddp_counter_relationships_rec.attribute11 := p4_a24;
3058 ddp_counter_relationships_rec.attribute12 := p4_a25;
3059 ddp_counter_relationships_rec.attribute13 := p4_a26;
3060 ddp_counter_relationships_rec.attribute14 := p4_a27;
3061 ddp_counter_relationships_rec.attribute15 := p4_a28;
3062 ddp_counter_relationships_rec.security_group_id := rosetta_g_miss_num_map(p4_a29);
3063 ddp_counter_relationships_rec.migrated_flag := p4_a30;
3064 ddp_counter_relationships_rec.bind_variable_name := p4_a31;
3065 ddp_counter_relationships_rec.factor := rosetta_g_miss_num_map(p4_a32);
3066
3067
3068
3069
3070 -- here's the delegated call to the old PL/SQL routine
3071 csi_counter_template_pub.update_counter_relationship(p_api_version,
3072 p_commit,
3073 p_init_msg_list,
3074 p_validation_level,
3075 ddp_counter_relationships_rec,
3076 x_return_status,
3077 x_msg_count,
3078 x_msg_data);
3079
3080 -- copy data back from the local variables to OUT or IN-OUT args, if any
3081
3082
3083
3084
3085 p4_a0 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.relationship_id);
3086 p4_a1 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.ctr_association_id);
3087 p4_a2 := ddp_counter_relationships_rec.relationship_type_code;
3088 p4_a3 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.source_counter_id);
3089 p4_a4 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.object_counter_id);
3090 p4_a5 := ddp_counter_relationships_rec.active_start_date;
3091 p4_a6 := ddp_counter_relationships_rec.active_end_date;
3092 p4_a7 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.object_version_number);
3093 p4_a8 := ddp_counter_relationships_rec.last_update_date;
3094 p4_a9 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.last_updated_by);
3095 p4_a10 := ddp_counter_relationships_rec.creation_date;
3096 p4_a11 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.created_by);
3097 p4_a12 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.last_update_login);
3098 p4_a13 := ddp_counter_relationships_rec.attribute_category;
3099 p4_a14 := ddp_counter_relationships_rec.attribute1;
3100 p4_a15 := ddp_counter_relationships_rec.attribute2;
3101 p4_a16 := ddp_counter_relationships_rec.attribute3;
3102 p4_a17 := ddp_counter_relationships_rec.attribute4;
3103 p4_a18 := ddp_counter_relationships_rec.attribute5;
3104 p4_a19 := ddp_counter_relationships_rec.attribute6;
3105 p4_a20 := ddp_counter_relationships_rec.attribute7;
3106 p4_a21 := ddp_counter_relationships_rec.attribute8;
3107 p4_a22 := ddp_counter_relationships_rec.attribute9;
3108 p4_a23 := ddp_counter_relationships_rec.attribute10;
3109 p4_a24 := ddp_counter_relationships_rec.attribute11;
3110 p4_a25 := ddp_counter_relationships_rec.attribute12;
3111 p4_a26 := ddp_counter_relationships_rec.attribute13;
3112 p4_a27 := ddp_counter_relationships_rec.attribute14;
3113 p4_a28 := ddp_counter_relationships_rec.attribute15;
3114 p4_a29 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.security_group_id);
3115 p4_a30 := ddp_counter_relationships_rec.migrated_flag;
3116 p4_a31 := ddp_counter_relationships_rec.bind_variable_name;
3117 p4_a32 := rosetta_g_miss_num_map(ddp_counter_relationships_rec.factor);
3118
3119
3120
3121 end;
3122
3123 procedure update_derived_filters(p_api_version NUMBER
3124 , p_commit VARCHAR2
3125 , p_init_msg_list VARCHAR2
3126 , p_validation_level NUMBER
3127 , p4_a0 in out nocopy JTF_NUMBER_TABLE
3128 , p4_a1 in out nocopy JTF_NUMBER_TABLE
3129 , p4_a2 in out nocopy JTF_NUMBER_TABLE
3130 , p4_a3 in out nocopy JTF_VARCHAR2_TABLE_100
3131 , p4_a4 in out nocopy JTF_NUMBER_TABLE
3132 , p4_a5 in out nocopy JTF_VARCHAR2_TABLE_100
3133 , p4_a6 in out nocopy JTF_VARCHAR2_TABLE_300
3134 , p4_a7 in out nocopy JTF_VARCHAR2_TABLE_100
3135 , p4_a8 in out nocopy JTF_VARCHAR2_TABLE_100
3136 , p4_a9 in out nocopy JTF_DATE_TABLE
3137 , p4_a10 in out nocopy JTF_DATE_TABLE
3138 , p4_a11 in out nocopy JTF_NUMBER_TABLE
3139 , p4_a12 in out nocopy JTF_DATE_TABLE
3140 , p4_a13 in out nocopy JTF_NUMBER_TABLE
3141 , p4_a14 in out nocopy JTF_DATE_TABLE
3142 , p4_a15 in out nocopy JTF_NUMBER_TABLE
3143 , p4_a16 in out nocopy JTF_NUMBER_TABLE
3144 , p4_a17 in out nocopy JTF_VARCHAR2_TABLE_200
3145 , p4_a18 in out nocopy JTF_VARCHAR2_TABLE_200
3146 , p4_a19 in out nocopy JTF_VARCHAR2_TABLE_200
3147 , p4_a20 in out nocopy JTF_VARCHAR2_TABLE_200
3148 , p4_a21 in out nocopy JTF_VARCHAR2_TABLE_200
3149 , p4_a22 in out nocopy JTF_VARCHAR2_TABLE_200
3150 , p4_a23 in out nocopy JTF_VARCHAR2_TABLE_200
3151 , p4_a24 in out nocopy JTF_VARCHAR2_TABLE_200
3152 , p4_a25 in out nocopy JTF_VARCHAR2_TABLE_200
3153 , p4_a26 in out nocopy JTF_VARCHAR2_TABLE_200
3154 , p4_a27 in out nocopy JTF_VARCHAR2_TABLE_200
3155 , p4_a28 in out nocopy JTF_VARCHAR2_TABLE_200
3156 , p4_a29 in out nocopy JTF_VARCHAR2_TABLE_200
3157 , p4_a30 in out nocopy JTF_VARCHAR2_TABLE_200
3158 , p4_a31 in out nocopy JTF_VARCHAR2_TABLE_200
3159 , p4_a32 in out nocopy JTF_VARCHAR2_TABLE_100
3160 , p4_a33 in out nocopy JTF_NUMBER_TABLE
3161 , p4_a34 in out nocopy JTF_VARCHAR2_TABLE_100
3162 , x_return_status out nocopy VARCHAR2
3163 , x_msg_count out nocopy NUMBER
3164 , x_msg_data out nocopy VARCHAR2
3165 )
3166
3167 as
3168 ddp_ctr_derived_filters_tbl csi_ctr_datastructures_pub.ctr_derived_filters_tbl;
3169 ddindx binary_integer; indx binary_integer;
3170 begin
3171
3172 -- copy data to the local IN or IN-OUT args, if any
3173
3174
3175
3176
3177 csi_ctr_datastructures_pub_w.rosetta_table_copy_in_p16(ddp_ctr_derived_filters_tbl, p4_a0
3178 , p4_a1
3179 , p4_a2
3180 , p4_a3
3181 , p4_a4
3182 , p4_a5
3183 , p4_a6
3184 , p4_a7
3185 , p4_a8
3186 , p4_a9
3187 , p4_a10
3188 , p4_a11
3189 , p4_a12
3190 , p4_a13
3191 , p4_a14
3192 , p4_a15
3193 , p4_a16
3194 , p4_a17
3195 , p4_a18
3196 , p4_a19
3197 , p4_a20
3198 , p4_a21
3199 , p4_a22
3200 , p4_a23
3201 , p4_a24
3202 , p4_a25
3203 , p4_a26
3204 , p4_a27
3205 , p4_a28
3206 , p4_a29
3207 , p4_a30
3208 , p4_a31
3209 , p4_a32
3210 , p4_a33
3211 , p4_a34
3212 );
3213
3214
3215
3216
3217 -- here's the delegated call to the old PL/SQL routine
3218 csi_counter_template_pub.update_derived_filters(p_api_version,
3219 p_commit,
3220 p_init_msg_list,
3221 p_validation_level,
3222 ddp_ctr_derived_filters_tbl,
3223 x_return_status,
3224 x_msg_count,
3225 x_msg_data);
3226
3227 -- copy data back from the local variables to OUT or IN-OUT args, if any
3228
3229
3230
3231
3232 csi_ctr_datastructures_pub_w.rosetta_table_copy_out_p16(ddp_ctr_derived_filters_tbl, p4_a0
3233 , p4_a1
3234 , p4_a2
3235 , p4_a3
3236 , p4_a4
3237 , p4_a5
3238 , p4_a6
3239 , p4_a7
3240 , p4_a8
3241 , p4_a9
3242 , p4_a10
3243 , p4_a11
3244 , p4_a12
3245 , p4_a13
3246 , p4_a14
3247 , p4_a15
3248 , p4_a16
3249 , p4_a17
3250 , p4_a18
3251 , p4_a19
3252 , p4_a20
3253 , p4_a21
3254 , p4_a22
3255 , p4_a23
3256 , p4_a24
3257 , p4_a25
3258 , p4_a26
3259 , p4_a27
3260 , p4_a28
3261 , p4_a29
3262 , p4_a30
3263 , p4_a31
3264 , p4_a32
3265 , p4_a33
3266 , p4_a34
3267 );
3268
3269
3270
3271 end;
3272
3273 procedure create_estimation_method(p_api_version NUMBER
3274 , p_init_msg_list VARCHAR2
3275 , p_commit VARCHAR2
3276 , p_validation_level NUMBER
3277 , x_return_status out nocopy VARCHAR2
3278 , x_msg_count out nocopy NUMBER
3279 , x_msg_data out nocopy VARCHAR2
3280 , p7_a0 in out nocopy NUMBER
3281 , p7_a1 in out nocopy VARCHAR2
3282 , p7_a2 in out nocopy NUMBER
3283 , p7_a3 in out nocopy NUMBER
3284 , p7_a4 in out nocopy NUMBER
3285 , p7_a5 in out nocopy VARCHAR2
3286 , p7_a6 in out nocopy DATE
3287 , p7_a7 in out nocopy DATE
3288 , p7_a8 in out nocopy DATE
3289 , p7_a9 in out nocopy NUMBER
3290 , p7_a10 in out nocopy DATE
3291 , p7_a11 in out nocopy NUMBER
3292 , p7_a12 in out nocopy NUMBER
3293 , p7_a13 in out nocopy VARCHAR2
3294 , p7_a14 in out nocopy VARCHAR2
3295 , p7_a15 in out nocopy VARCHAR2
3296 , p7_a16 in out nocopy VARCHAR2
3297 , p7_a17 in out nocopy VARCHAR2
3298 , p7_a18 in out nocopy VARCHAR2
3299 , p7_a19 in out nocopy VARCHAR2
3300 , p7_a20 in out nocopy VARCHAR2
3301 , p7_a21 in out nocopy VARCHAR2
3302 , p7_a22 in out nocopy VARCHAR2
3303 , p7_a23 in out nocopy VARCHAR2
3304 , p7_a24 in out nocopy VARCHAR2
3305 , p7_a25 in out nocopy VARCHAR2
3306 , p7_a26 in out nocopy VARCHAR2
3307 , p7_a27 in out nocopy VARCHAR2
3308 , p7_a28 in out nocopy VARCHAR2
3309 , p7_a29 in out nocopy NUMBER
3310 , p7_a30 in out nocopy VARCHAR2
3311 , p7_a31 in out nocopy VARCHAR2
3312 , p7_a32 in out nocopy VARCHAR2
3313 )
3314
3315 as
3316 ddp_ctr_estimation_rec csi_ctr_datastructures_pub.ctr_estimation_methods_rec;
3317 ddindx binary_integer; indx binary_integer;
3318 begin
3319
3320 -- copy data to the local IN or IN-OUT args, if any
3321
3322
3323
3324
3325
3326
3327
3328 ddp_ctr_estimation_rec.estimation_id := rosetta_g_miss_num_map(p7_a0);
3329 ddp_ctr_estimation_rec.estimation_type := p7_a1;
3330 ddp_ctr_estimation_rec.fixed_value := rosetta_g_miss_num_map(p7_a2);
3331 ddp_ctr_estimation_rec.usage_markup := rosetta_g_miss_num_map(p7_a3);
3332 ddp_ctr_estimation_rec.default_value := rosetta_g_miss_num_map(p7_a4);
3333 ddp_ctr_estimation_rec.estimation_avg_type := p7_a5;
3334 ddp_ctr_estimation_rec.start_date_active := rosetta_g_miss_date_in_map(p7_a6);
3335 ddp_ctr_estimation_rec.end_date_active := rosetta_g_miss_date_in_map(p7_a7);
3336 ddp_ctr_estimation_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a8);
3337 ddp_ctr_estimation_rec.last_updated_by := rosetta_g_miss_num_map(p7_a9);
3338 ddp_ctr_estimation_rec.creation_date := rosetta_g_miss_date_in_map(p7_a10);
3339 ddp_ctr_estimation_rec.created_by := rosetta_g_miss_num_map(p7_a11);
3340 ddp_ctr_estimation_rec.last_update_login := rosetta_g_miss_num_map(p7_a12);
3341 ddp_ctr_estimation_rec.attribute1 := p7_a13;
3342 ddp_ctr_estimation_rec.attribute2 := p7_a14;
3343 ddp_ctr_estimation_rec.attribute3 := p7_a15;
3344 ddp_ctr_estimation_rec.attribute4 := p7_a16;
3345 ddp_ctr_estimation_rec.attribute5 := p7_a17;
3346 ddp_ctr_estimation_rec.attribute6 := p7_a18;
3347 ddp_ctr_estimation_rec.attribute7 := p7_a19;
3348 ddp_ctr_estimation_rec.attribute8 := p7_a20;
3349 ddp_ctr_estimation_rec.attribute9 := p7_a21;
3350 ddp_ctr_estimation_rec.attribute10 := p7_a22;
3351 ddp_ctr_estimation_rec.attribute11 := p7_a23;
3352 ddp_ctr_estimation_rec.attribute12 := p7_a24;
3353 ddp_ctr_estimation_rec.attribute13 := p7_a25;
3354 ddp_ctr_estimation_rec.attribute14 := p7_a26;
3355 ddp_ctr_estimation_rec.attribute15 := p7_a27;
3356 ddp_ctr_estimation_rec.attribute_category := p7_a28;
3357 ddp_ctr_estimation_rec.object_version_number := rosetta_g_miss_num_map(p7_a29);
3358 ddp_ctr_estimation_rec.migrated_flag := p7_a30;
3359 ddp_ctr_estimation_rec.name := p7_a31;
3360 ddp_ctr_estimation_rec.description := p7_a32;
3361
3362 -- here's the delegated call to the old PL/SQL routine
3363 csi_counter_template_pub.create_estimation_method(p_api_version,
3364 p_init_msg_list,
3365 p_commit,
3366 p_validation_level,
3367 x_return_status,
3368 x_msg_count,
3369 x_msg_data,
3370 ddp_ctr_estimation_rec);
3371
3372 -- copy data back from the local variables to OUT or IN-OUT args, if any
3373
3374
3375
3376
3377
3378
3379
3380 p7_a0 := rosetta_g_miss_num_map(ddp_ctr_estimation_rec.estimation_id);
3381 p7_a1 := ddp_ctr_estimation_rec.estimation_type;
3382 p7_a2 := rosetta_g_miss_num_map(ddp_ctr_estimation_rec.fixed_value);
3383 p7_a3 := rosetta_g_miss_num_map(ddp_ctr_estimation_rec.usage_markup);
3384 p7_a4 := rosetta_g_miss_num_map(ddp_ctr_estimation_rec.default_value);
3385 p7_a5 := ddp_ctr_estimation_rec.estimation_avg_type;
3386 p7_a6 := ddp_ctr_estimation_rec.start_date_active;
3387 p7_a7 := ddp_ctr_estimation_rec.end_date_active;
3388 p7_a8 := ddp_ctr_estimation_rec.last_update_date;
3389 p7_a9 := rosetta_g_miss_num_map(ddp_ctr_estimation_rec.last_updated_by);
3390 p7_a10 := ddp_ctr_estimation_rec.creation_date;
3391 p7_a11 := rosetta_g_miss_num_map(ddp_ctr_estimation_rec.created_by);
3392 p7_a12 := rosetta_g_miss_num_map(ddp_ctr_estimation_rec.last_update_login);
3393 p7_a13 := ddp_ctr_estimation_rec.attribute1;
3394 p7_a14 := ddp_ctr_estimation_rec.attribute2;
3395 p7_a15 := ddp_ctr_estimation_rec.attribute3;
3396 p7_a16 := ddp_ctr_estimation_rec.attribute4;
3397 p7_a17 := ddp_ctr_estimation_rec.attribute5;
3398 p7_a18 := ddp_ctr_estimation_rec.attribute6;
3399 p7_a19 := ddp_ctr_estimation_rec.attribute7;
3400 p7_a20 := ddp_ctr_estimation_rec.attribute8;
3401 p7_a21 := ddp_ctr_estimation_rec.attribute9;
3402 p7_a22 := ddp_ctr_estimation_rec.attribute10;
3403 p7_a23 := ddp_ctr_estimation_rec.attribute11;
3404 p7_a24 := ddp_ctr_estimation_rec.attribute12;
3405 p7_a25 := ddp_ctr_estimation_rec.attribute13;
3406 p7_a26 := ddp_ctr_estimation_rec.attribute14;
3407 p7_a27 := ddp_ctr_estimation_rec.attribute15;
3408 p7_a28 := ddp_ctr_estimation_rec.attribute_category;
3409 p7_a29 := rosetta_g_miss_num_map(ddp_ctr_estimation_rec.object_version_number);
3410 p7_a30 := ddp_ctr_estimation_rec.migrated_flag;
3411 p7_a31 := ddp_ctr_estimation_rec.name;
3412 p7_a32 := ddp_ctr_estimation_rec.description;
3413 end;
3414
3415 procedure update_estimation_method(p_api_version NUMBER
3416 , p_init_msg_list VARCHAR2
3417 , p_commit VARCHAR2
3418 , p_validation_level NUMBER
3419 , x_return_status out nocopy VARCHAR2
3420 , x_msg_count out nocopy NUMBER
3421 , x_msg_data out nocopy VARCHAR2
3422 , p7_a0 in out nocopy NUMBER
3423 , p7_a1 in out nocopy VARCHAR2
3424 , p7_a2 in out nocopy NUMBER
3425 , p7_a3 in out nocopy NUMBER
3426 , p7_a4 in out nocopy NUMBER
3427 , p7_a5 in out nocopy VARCHAR2
3428 , p7_a6 in out nocopy DATE
3429 , p7_a7 in out nocopy DATE
3430 , p7_a8 in out nocopy DATE
3431 , p7_a9 in out nocopy NUMBER
3432 , p7_a10 in out nocopy DATE
3433 , p7_a11 in out nocopy NUMBER
3434 , p7_a12 in out nocopy NUMBER
3435 , p7_a13 in out nocopy VARCHAR2
3436 , p7_a14 in out nocopy VARCHAR2
3437 , p7_a15 in out nocopy VARCHAR2
3438 , p7_a16 in out nocopy VARCHAR2
3439 , p7_a17 in out nocopy VARCHAR2
3440 , p7_a18 in out nocopy VARCHAR2
3441 , p7_a19 in out nocopy VARCHAR2
3442 , p7_a20 in out nocopy VARCHAR2
3443 , p7_a21 in out nocopy VARCHAR2
3444 , p7_a22 in out nocopy VARCHAR2
3445 , p7_a23 in out nocopy VARCHAR2
3446 , p7_a24 in out nocopy VARCHAR2
3447 , p7_a25 in out nocopy VARCHAR2
3448 , p7_a26 in out nocopy VARCHAR2
3449 , p7_a27 in out nocopy VARCHAR2
3450 , p7_a28 in out nocopy VARCHAR2
3451 , p7_a29 in out nocopy NUMBER
3452 , p7_a30 in out nocopy VARCHAR2
3453 , p7_a31 in out nocopy VARCHAR2
3454 , p7_a32 in out nocopy VARCHAR2
3455 )
3456
3457 as
3458 ddp_ctr_estimation_rec csi_ctr_datastructures_pub.ctr_estimation_methods_rec;
3459 ddindx binary_integer; indx binary_integer;
3460 begin
3461
3462 -- copy data to the local IN or IN-OUT args, if any
3463
3464
3465
3466
3467
3468
3469
3470 ddp_ctr_estimation_rec.estimation_id := rosetta_g_miss_num_map(p7_a0);
3471 ddp_ctr_estimation_rec.estimation_type := p7_a1;
3472 ddp_ctr_estimation_rec.fixed_value := rosetta_g_miss_num_map(p7_a2);
3473 ddp_ctr_estimation_rec.usage_markup := rosetta_g_miss_num_map(p7_a3);
3474 ddp_ctr_estimation_rec.default_value := rosetta_g_miss_num_map(p7_a4);
3475 ddp_ctr_estimation_rec.estimation_avg_type := p7_a5;
3476 ddp_ctr_estimation_rec.start_date_active := rosetta_g_miss_date_in_map(p7_a6);
3477 ddp_ctr_estimation_rec.end_date_active := rosetta_g_miss_date_in_map(p7_a7);
3478 ddp_ctr_estimation_rec.last_update_date := rosetta_g_miss_date_in_map(p7_a8);
3479 ddp_ctr_estimation_rec.last_updated_by := rosetta_g_miss_num_map(p7_a9);
3480 ddp_ctr_estimation_rec.creation_date := rosetta_g_miss_date_in_map(p7_a10);
3481 ddp_ctr_estimation_rec.created_by := rosetta_g_miss_num_map(p7_a11);
3482 ddp_ctr_estimation_rec.last_update_login := rosetta_g_miss_num_map(p7_a12);
3483 ddp_ctr_estimation_rec.attribute1 := p7_a13;
3484 ddp_ctr_estimation_rec.attribute2 := p7_a14;
3485 ddp_ctr_estimation_rec.attribute3 := p7_a15;
3486 ddp_ctr_estimation_rec.attribute4 := p7_a16;
3487 ddp_ctr_estimation_rec.attribute5 := p7_a17;
3488 ddp_ctr_estimation_rec.attribute6 := p7_a18;
3489 ddp_ctr_estimation_rec.attribute7 := p7_a19;
3490 ddp_ctr_estimation_rec.attribute8 := p7_a20;
3491 ddp_ctr_estimation_rec.attribute9 := p7_a21;
3492 ddp_ctr_estimation_rec.attribute10 := p7_a22;
3493 ddp_ctr_estimation_rec.attribute11 := p7_a23;
3494 ddp_ctr_estimation_rec.attribute12 := p7_a24;
3495 ddp_ctr_estimation_rec.attribute13 := p7_a25;
3496 ddp_ctr_estimation_rec.attribute14 := p7_a26;
3497 ddp_ctr_estimation_rec.attribute15 := p7_a27;
3498 ddp_ctr_estimation_rec.attribute_category := p7_a28;
3499 ddp_ctr_estimation_rec.object_version_number := rosetta_g_miss_num_map(p7_a29);
3500 ddp_ctr_estimation_rec.migrated_flag := p7_a30;
3501 ddp_ctr_estimation_rec.name := p7_a31;
3502 ddp_ctr_estimation_rec.description := p7_a32;
3503
3504 -- here's the delegated call to the old PL/SQL routine
3505 csi_counter_template_pub.update_estimation_method(p_api_version,
3506 p_init_msg_list,
3507 p_commit,
3508 p_validation_level,
3509 x_return_status,
3510 x_msg_count,
3511 x_msg_data,
3512 ddp_ctr_estimation_rec);
3513
3514 -- copy data back from the local variables to OUT or IN-OUT args, if any
3515
3516
3517
3518
3519
3520
3521
3522 p7_a0 := rosetta_g_miss_num_map(ddp_ctr_estimation_rec.estimation_id);
3523 p7_a1 := ddp_ctr_estimation_rec.estimation_type;
3524 p7_a2 := rosetta_g_miss_num_map(ddp_ctr_estimation_rec.fixed_value);
3525 p7_a3 := rosetta_g_miss_num_map(ddp_ctr_estimation_rec.usage_markup);
3526 p7_a4 := rosetta_g_miss_num_map(ddp_ctr_estimation_rec.default_value);
3527 p7_a5 := ddp_ctr_estimation_rec.estimation_avg_type;
3528 p7_a6 := ddp_ctr_estimation_rec.start_date_active;
3529 p7_a7 := ddp_ctr_estimation_rec.end_date_active;
3530 p7_a8 := ddp_ctr_estimation_rec.last_update_date;
3531 p7_a9 := rosetta_g_miss_num_map(ddp_ctr_estimation_rec.last_updated_by);
3532 p7_a10 := ddp_ctr_estimation_rec.creation_date;
3533 p7_a11 := rosetta_g_miss_num_map(ddp_ctr_estimation_rec.created_by);
3534 p7_a12 := rosetta_g_miss_num_map(ddp_ctr_estimation_rec.last_update_login);
3535 p7_a13 := ddp_ctr_estimation_rec.attribute1;
3536 p7_a14 := ddp_ctr_estimation_rec.attribute2;
3537 p7_a15 := ddp_ctr_estimation_rec.attribute3;
3538 p7_a16 := ddp_ctr_estimation_rec.attribute4;
3539 p7_a17 := ddp_ctr_estimation_rec.attribute5;
3540 p7_a18 := ddp_ctr_estimation_rec.attribute6;
3541 p7_a19 := ddp_ctr_estimation_rec.attribute7;
3542 p7_a20 := ddp_ctr_estimation_rec.attribute8;
3543 p7_a21 := ddp_ctr_estimation_rec.attribute9;
3544 p7_a22 := ddp_ctr_estimation_rec.attribute10;
3545 p7_a23 := ddp_ctr_estimation_rec.attribute11;
3546 p7_a24 := ddp_ctr_estimation_rec.attribute12;
3547 p7_a25 := ddp_ctr_estimation_rec.attribute13;
3548 p7_a26 := ddp_ctr_estimation_rec.attribute14;
3549 p7_a27 := ddp_ctr_estimation_rec.attribute15;
3550 p7_a28 := ddp_ctr_estimation_rec.attribute_category;
3551 p7_a29 := rosetta_g_miss_num_map(ddp_ctr_estimation_rec.object_version_number);
3552 p7_a30 := ddp_ctr_estimation_rec.migrated_flag;
3553 p7_a31 := ddp_ctr_estimation_rec.name;
3554 p7_a32 := ddp_ctr_estimation_rec.description;
3555 end;
3556
3557 procedure autoinstantiate_counters(p_api_version NUMBER
3558 , p_init_msg_list VARCHAR2
3559 , p_commit VARCHAR2
3560 , x_return_status out nocopy VARCHAR2
3561 , x_msg_count out nocopy NUMBER
3562 , x_msg_data out nocopy VARCHAR2
3563 , p_source_object_id_template NUMBER
3564 , p_source_object_id_instance NUMBER
3565 , p8_a0 in out nocopy JTF_NUMBER_TABLE
3566 , p8_a1 in out nocopy JTF_NUMBER_TABLE
3567 , p9_a0 in out nocopy JTF_NUMBER_TABLE
3568 , p9_a1 in out nocopy JTF_NUMBER_TABLE
3569 , x_ctr_grp_id_template in out nocopy NUMBER
3570 , x_ctr_grp_id_instance in out nocopy NUMBER
3571 , p_organization_id NUMBER
3572 )
3573
3574 as
3575 ddx_ctr_id_template csi_counter_template_pub.ctr_template_autoinst_tbl;
3576 ddx_ctr_id_instance csi_counter_template_pub.counter_autoinstantiate_tbl;
3577 ddindx binary_integer; indx binary_integer;
3578 begin
3579
3580 -- copy data to the local IN or IN-OUT args, if any
3581
3582
3583
3584
3585
3586
3587
3588
3589 csi_counter_template_pub_w.rosetta_table_copy_in_p3(ddx_ctr_id_template, p8_a0
3590 , p8_a1
3591 );
3592
3593 csi_counter_template_pub_w.rosetta_table_copy_in_p5(ddx_ctr_id_instance, p9_a0
3594 , p9_a1
3595 );
3596
3597
3598
3599
3600 -- here's the delegated call to the old PL/SQL routine
3601 csi_counter_template_pub.autoinstantiate_counters(p_api_version,
3602 p_init_msg_list,
3603 p_commit,
3604 x_return_status,
3605 x_msg_count,
3606 x_msg_data,
3607 p_source_object_id_template,
3608 p_source_object_id_instance,
3609 ddx_ctr_id_template,
3610 ddx_ctr_id_instance,
3611 x_ctr_grp_id_template,
3612 x_ctr_grp_id_instance,
3613 p_organization_id);
3614
3615 -- copy data back from the local variables to OUT or IN-OUT args, if any
3616
3617
3618
3619
3620
3621
3622
3623
3624 csi_counter_template_pub_w.rosetta_table_copy_out_p3(ddx_ctr_id_template, p8_a0
3625 , p8_a1
3626 );
3627
3628 csi_counter_template_pub_w.rosetta_table_copy_out_p5(ddx_ctr_id_instance, p9_a0
3629 , p9_a1
3630 );
3631
3632
3633
3634 end;
3635
3636 end csi_counter_template_pub_w;