[Home] [Help]
PACKAGE BODY: APPS.AHL_RA_SETUPS_PVT_W
Source
1 package body ahl_ra_setups_pvt_w as
2 /* $Header: AHLWRASB.pls 120.2 2005/09/15 00:15 sagarwal noship $ */
3 procedure create_setup_data(p_api_version NUMBER
4 , p_init_msg_list VARCHAR2
5 , p_commit VARCHAR2
6 , p_validation_level NUMBER
7 , p_module_type VARCHAR2
8 , x_return_status out nocopy VARCHAR2
9 , x_msg_count out nocopy NUMBER
10 , x_msg_data out nocopy VARCHAR2
11 , p8_a0 in out nocopy NUMBER
12 , p8_a1 in out nocopy VARCHAR2
13 , p8_a2 in out nocopy NUMBER
14 , p8_a3 in out nocopy VARCHAR2
15 , p8_a4 in out nocopy VARCHAR2
16 , p8_a5 in out nocopy NUMBER
17 , p8_a6 in out nocopy NUMBER
18 , p8_a7 in out nocopy DATE
19 , p8_a8 in out nocopy NUMBER
20 , p8_a9 in out nocopy DATE
21 , p8_a10 in out nocopy NUMBER
22 , p8_a11 in out nocopy NUMBER
23 , p8_a12 in out nocopy VARCHAR2
24 , p8_a13 in out nocopy VARCHAR2
25 , p8_a14 in out nocopy VARCHAR2
26 , p8_a15 in out nocopy VARCHAR2
27 , p8_a16 in out nocopy VARCHAR2
28 , p8_a17 in out nocopy VARCHAR2
29 , p8_a18 in out nocopy VARCHAR2
30 , p8_a19 in out nocopy VARCHAR2
31 , p8_a20 in out nocopy VARCHAR2
32 , p8_a21 in out nocopy VARCHAR2
33 , p8_a22 in out nocopy VARCHAR2
34 , p8_a23 in out nocopy VARCHAR2
35 , p8_a24 in out nocopy VARCHAR2
36 , p8_a25 in out nocopy VARCHAR2
37 , p8_a26 in out nocopy VARCHAR2
38 , p8_a27 in out nocopy VARCHAR2
39 )
40
41 as
42 ddp_x_setup_data_rec ahl_ra_setups_pvt.ra_setup_data_rec_type;
43 ddindx binary_integer; indx binary_integer;
44 begin
45
46 -- copy data to the local IN or IN-OUT args, if any
47
48
49
50
51
52
53
54
55 ddp_x_setup_data_rec.ra_setup_id := p8_a0;
56 ddp_x_setup_data_rec.setup_code := p8_a1;
57 ddp_x_setup_data_rec.status_id := p8_a2;
58 ddp_x_setup_data_rec.removal_code := p8_a3;
59 ddp_x_setup_data_rec.operation_flag := p8_a4;
60 ddp_x_setup_data_rec.object_version_number := p8_a5;
61 ddp_x_setup_data_rec.security_group_id := p8_a6;
62 ddp_x_setup_data_rec.creation_date := p8_a7;
63 ddp_x_setup_data_rec.created_by := p8_a8;
64 ddp_x_setup_data_rec.last_update_date := p8_a9;
65 ddp_x_setup_data_rec.last_updated_by := p8_a10;
66 ddp_x_setup_data_rec.last_update_login := p8_a11;
67 ddp_x_setup_data_rec.attribute_category := p8_a12;
68 ddp_x_setup_data_rec.attribute1 := p8_a13;
69 ddp_x_setup_data_rec.attribute2 := p8_a14;
70 ddp_x_setup_data_rec.attribute3 := p8_a15;
71 ddp_x_setup_data_rec.attribute4 := p8_a16;
72 ddp_x_setup_data_rec.attribute5 := p8_a17;
73 ddp_x_setup_data_rec.attribute6 := p8_a18;
74 ddp_x_setup_data_rec.attribute7 := p8_a19;
75 ddp_x_setup_data_rec.attribute8 := p8_a20;
76 ddp_x_setup_data_rec.attribute9 := p8_a21;
77 ddp_x_setup_data_rec.attribute10 := p8_a22;
78 ddp_x_setup_data_rec.attribute11 := p8_a23;
79 ddp_x_setup_data_rec.attribute12 := p8_a24;
80 ddp_x_setup_data_rec.attribute13 := p8_a25;
81 ddp_x_setup_data_rec.attribute14 := p8_a26;
82 ddp_x_setup_data_rec.attribute15 := p8_a27;
83
84 -- here's the delegated call to the old PL/SQL routine
85 ahl_ra_setups_pvt.create_setup_data(p_api_version,
86 p_init_msg_list,
87 p_commit,
88 p_validation_level,
89 p_module_type,
90 x_return_status,
91 x_msg_count,
92 x_msg_data,
93 ddp_x_setup_data_rec);
94
95 -- copy data back from the local variables to OUT or IN-OUT args, if any
96
97
98
99
100
101
102
103
104 p8_a0 := ddp_x_setup_data_rec.ra_setup_id;
105 p8_a1 := ddp_x_setup_data_rec.setup_code;
106 p8_a2 := ddp_x_setup_data_rec.status_id;
107 p8_a3 := ddp_x_setup_data_rec.removal_code;
108 p8_a4 := ddp_x_setup_data_rec.operation_flag;
109 p8_a5 := ddp_x_setup_data_rec.object_version_number;
110 p8_a6 := ddp_x_setup_data_rec.security_group_id;
111 p8_a7 := ddp_x_setup_data_rec.creation_date;
112 p8_a8 := ddp_x_setup_data_rec.created_by;
113 p8_a9 := ddp_x_setup_data_rec.last_update_date;
114 p8_a10 := ddp_x_setup_data_rec.last_updated_by;
115 p8_a11 := ddp_x_setup_data_rec.last_update_login;
116 p8_a12 := ddp_x_setup_data_rec.attribute_category;
117 p8_a13 := ddp_x_setup_data_rec.attribute1;
118 p8_a14 := ddp_x_setup_data_rec.attribute2;
119 p8_a15 := ddp_x_setup_data_rec.attribute3;
120 p8_a16 := ddp_x_setup_data_rec.attribute4;
121 p8_a17 := ddp_x_setup_data_rec.attribute5;
122 p8_a18 := ddp_x_setup_data_rec.attribute6;
123 p8_a19 := ddp_x_setup_data_rec.attribute7;
124 p8_a20 := ddp_x_setup_data_rec.attribute8;
125 p8_a21 := ddp_x_setup_data_rec.attribute9;
126 p8_a22 := ddp_x_setup_data_rec.attribute10;
127 p8_a23 := ddp_x_setup_data_rec.attribute11;
128 p8_a24 := ddp_x_setup_data_rec.attribute12;
129 p8_a25 := ddp_x_setup_data_rec.attribute13;
130 p8_a26 := ddp_x_setup_data_rec.attribute14;
131 p8_a27 := ddp_x_setup_data_rec.attribute15;
132 end;
133
134 procedure delete_setup_data(p_api_version NUMBER
135 , p_init_msg_list VARCHAR2
136 , p_commit VARCHAR2
137 , p_validation_level NUMBER
138 , p_module_type VARCHAR2
139 , x_return_status out nocopy VARCHAR2
140 , x_msg_count out nocopy NUMBER
141 , x_msg_data out nocopy VARCHAR2
142 , p8_a0 NUMBER
143 , p8_a1 VARCHAR2
144 , p8_a2 NUMBER
145 , p8_a3 VARCHAR2
146 , p8_a4 VARCHAR2
147 , p8_a5 NUMBER
148 , p8_a6 NUMBER
149 , p8_a7 DATE
150 , p8_a8 NUMBER
151 , p8_a9 DATE
152 , p8_a10 NUMBER
153 , p8_a11 NUMBER
154 , p8_a12 VARCHAR2
155 , p8_a13 VARCHAR2
156 , p8_a14 VARCHAR2
157 , p8_a15 VARCHAR2
158 , p8_a16 VARCHAR2
159 , p8_a17 VARCHAR2
160 , p8_a18 VARCHAR2
161 , p8_a19 VARCHAR2
162 , p8_a20 VARCHAR2
163 , p8_a21 VARCHAR2
164 , p8_a22 VARCHAR2
165 , p8_a23 VARCHAR2
166 , p8_a24 VARCHAR2
167 , p8_a25 VARCHAR2
168 , p8_a26 VARCHAR2
169 , p8_a27 VARCHAR2
170 )
171
172 as
173 ddp_setup_data_rec ahl_ra_setups_pvt.ra_setup_data_rec_type;
174 ddindx binary_integer; indx binary_integer;
175 begin
176
177 -- copy data to the local IN or IN-OUT args, if any
178
179
180
181
182
183
184
185
186 ddp_setup_data_rec.ra_setup_id := p8_a0;
187 ddp_setup_data_rec.setup_code := p8_a1;
188 ddp_setup_data_rec.status_id := p8_a2;
189 ddp_setup_data_rec.removal_code := p8_a3;
190 ddp_setup_data_rec.operation_flag := p8_a4;
191 ddp_setup_data_rec.object_version_number := p8_a5;
192 ddp_setup_data_rec.security_group_id := p8_a6;
193 ddp_setup_data_rec.creation_date := p8_a7;
194 ddp_setup_data_rec.created_by := p8_a8;
195 ddp_setup_data_rec.last_update_date := p8_a9;
196 ddp_setup_data_rec.last_updated_by := p8_a10;
197 ddp_setup_data_rec.last_update_login := p8_a11;
198 ddp_setup_data_rec.attribute_category := p8_a12;
199 ddp_setup_data_rec.attribute1 := p8_a13;
200 ddp_setup_data_rec.attribute2 := p8_a14;
201 ddp_setup_data_rec.attribute3 := p8_a15;
202 ddp_setup_data_rec.attribute4 := p8_a16;
203 ddp_setup_data_rec.attribute5 := p8_a17;
204 ddp_setup_data_rec.attribute6 := p8_a18;
205 ddp_setup_data_rec.attribute7 := p8_a19;
206 ddp_setup_data_rec.attribute8 := p8_a20;
207 ddp_setup_data_rec.attribute9 := p8_a21;
208 ddp_setup_data_rec.attribute10 := p8_a22;
209 ddp_setup_data_rec.attribute11 := p8_a23;
210 ddp_setup_data_rec.attribute12 := p8_a24;
211 ddp_setup_data_rec.attribute13 := p8_a25;
212 ddp_setup_data_rec.attribute14 := p8_a26;
213 ddp_setup_data_rec.attribute15 := p8_a27;
214
215 -- here's the delegated call to the old PL/SQL routine
216 ahl_ra_setups_pvt.delete_setup_data(p_api_version,
217 p_init_msg_list,
218 p_commit,
219 p_validation_level,
220 p_module_type,
221 x_return_status,
222 x_msg_count,
223 x_msg_data,
224 ddp_setup_data_rec);
225
226 -- copy data back from the local variables to OUT or IN-OUT args, if any
227
228
229
230
231
232
233
234
235 end;
236
237 procedure create_reliability_data(p_api_version NUMBER
238 , p_init_msg_list VARCHAR2
239 , p_commit VARCHAR2
240 , p_validation_level NUMBER
241 , p_module_type VARCHAR2
242 , x_return_status out nocopy VARCHAR2
243 , x_msg_count out nocopy NUMBER
244 , x_msg_data out nocopy VARCHAR2
245 , p8_a0 in out nocopy NUMBER
246 , p8_a1 in out nocopy NUMBER
247 , p8_a2 in out nocopy NUMBER
248 , p8_a3 in out nocopy NUMBER
249 , p8_a4 in out nocopy VARCHAR2
250 , p8_a5 in out nocopy NUMBER
251 , p8_a6 in out nocopy VARCHAR2
252 , p8_a7 in out nocopy NUMBER
253 , p8_a8 in out nocopy NUMBER
254 , p8_a9 in out nocopy DATE
255 , p8_a10 in out nocopy NUMBER
256 , p8_a11 in out nocopy DATE
257 , p8_a12 in out nocopy NUMBER
258 , p8_a13 in out nocopy NUMBER
259 , p8_a14 in out nocopy VARCHAR2
260 , p8_a15 in out nocopy VARCHAR2
261 , p8_a16 in out nocopy VARCHAR2
262 , p8_a17 in out nocopy VARCHAR2
263 , p8_a18 in out nocopy VARCHAR2
264 , p8_a19 in out nocopy VARCHAR2
265 , p8_a20 in out nocopy VARCHAR2
266 , p8_a21 in out nocopy VARCHAR2
267 , p8_a22 in out nocopy VARCHAR2
268 , p8_a23 in out nocopy VARCHAR2
269 , p8_a24 in out nocopy VARCHAR2
270 , p8_a25 in out nocopy VARCHAR2
271 , p8_a26 in out nocopy VARCHAR2
272 , p8_a27 in out nocopy VARCHAR2
273 , p8_a28 in out nocopy VARCHAR2
274 , p8_a29 in out nocopy VARCHAR2
275 )
276
277 as
278 ddp_x_reliability_data_rec ahl_ra_setups_pvt.ra_definition_hdr_rec_type;
279 ddindx binary_integer; indx binary_integer;
280 begin
281
282 -- copy data to the local IN or IN-OUT args, if any
283
284
285
286
287
288
289
290
291 ddp_x_reliability_data_rec.ra_definition_hdr_id := p8_a0;
292 ddp_x_reliability_data_rec.mc_header_id := p8_a1;
293 ddp_x_reliability_data_rec.inventory_item_id := p8_a2;
294 ddp_x_reliability_data_rec.inventory_org_id := p8_a3;
295 ddp_x_reliability_data_rec.item_revision := p8_a4;
296 ddp_x_reliability_data_rec.relationship_id := p8_a5;
297 ddp_x_reliability_data_rec.operation_flag := p8_a6;
298 ddp_x_reliability_data_rec.object_version_number := p8_a7;
299 ddp_x_reliability_data_rec.security_group_id := p8_a8;
300 ddp_x_reliability_data_rec.creation_date := p8_a9;
301 ddp_x_reliability_data_rec.created_by := p8_a10;
302 ddp_x_reliability_data_rec.last_update_date := p8_a11;
303 ddp_x_reliability_data_rec.last_updated_by := p8_a12;
304 ddp_x_reliability_data_rec.last_update_login := p8_a13;
305 ddp_x_reliability_data_rec.attribute_category := p8_a14;
306 ddp_x_reliability_data_rec.attribute1 := p8_a15;
307 ddp_x_reliability_data_rec.attribute2 := p8_a16;
308 ddp_x_reliability_data_rec.attribute3 := p8_a17;
309 ddp_x_reliability_data_rec.attribute4 := p8_a18;
310 ddp_x_reliability_data_rec.attribute5 := p8_a19;
311 ddp_x_reliability_data_rec.attribute6 := p8_a20;
312 ddp_x_reliability_data_rec.attribute7 := p8_a21;
313 ddp_x_reliability_data_rec.attribute8 := p8_a22;
314 ddp_x_reliability_data_rec.attribute9 := p8_a23;
315 ddp_x_reliability_data_rec.attribute10 := p8_a24;
316 ddp_x_reliability_data_rec.attribute11 := p8_a25;
317 ddp_x_reliability_data_rec.attribute12 := p8_a26;
318 ddp_x_reliability_data_rec.attribute13 := p8_a27;
319 ddp_x_reliability_data_rec.attribute14 := p8_a28;
320 ddp_x_reliability_data_rec.attribute15 := p8_a29;
321
322 -- here's the delegated call to the old PL/SQL routine
323 ahl_ra_setups_pvt.create_reliability_data(p_api_version,
324 p_init_msg_list,
325 p_commit,
326 p_validation_level,
327 p_module_type,
328 x_return_status,
329 x_msg_count,
330 x_msg_data,
331 ddp_x_reliability_data_rec);
332
333 -- copy data back from the local variables to OUT or IN-OUT args, if any
334
335
336
337
338
339
340
341
342 p8_a0 := ddp_x_reliability_data_rec.ra_definition_hdr_id;
343 p8_a1 := ddp_x_reliability_data_rec.mc_header_id;
344 p8_a2 := ddp_x_reliability_data_rec.inventory_item_id;
345 p8_a3 := ddp_x_reliability_data_rec.inventory_org_id;
346 p8_a4 := ddp_x_reliability_data_rec.item_revision;
347 p8_a5 := ddp_x_reliability_data_rec.relationship_id;
348 p8_a6 := ddp_x_reliability_data_rec.operation_flag;
349 p8_a7 := ddp_x_reliability_data_rec.object_version_number;
350 p8_a8 := ddp_x_reliability_data_rec.security_group_id;
351 p8_a9 := ddp_x_reliability_data_rec.creation_date;
352 p8_a10 := ddp_x_reliability_data_rec.created_by;
353 p8_a11 := ddp_x_reliability_data_rec.last_update_date;
354 p8_a12 := ddp_x_reliability_data_rec.last_updated_by;
355 p8_a13 := ddp_x_reliability_data_rec.last_update_login;
356 p8_a14 := ddp_x_reliability_data_rec.attribute_category;
357 p8_a15 := ddp_x_reliability_data_rec.attribute1;
358 p8_a16 := ddp_x_reliability_data_rec.attribute2;
359 p8_a17 := ddp_x_reliability_data_rec.attribute3;
360 p8_a18 := ddp_x_reliability_data_rec.attribute4;
361 p8_a19 := ddp_x_reliability_data_rec.attribute5;
362 p8_a20 := ddp_x_reliability_data_rec.attribute6;
363 p8_a21 := ddp_x_reliability_data_rec.attribute7;
364 p8_a22 := ddp_x_reliability_data_rec.attribute8;
365 p8_a23 := ddp_x_reliability_data_rec.attribute9;
366 p8_a24 := ddp_x_reliability_data_rec.attribute10;
367 p8_a25 := ddp_x_reliability_data_rec.attribute11;
368 p8_a26 := ddp_x_reliability_data_rec.attribute12;
369 p8_a27 := ddp_x_reliability_data_rec.attribute13;
370 p8_a28 := ddp_x_reliability_data_rec.attribute14;
371 p8_a29 := ddp_x_reliability_data_rec.attribute15;
372 end;
373
374 procedure delete_reliability_data(p_api_version NUMBER
375 , p_init_msg_list VARCHAR2
376 , p_commit VARCHAR2
377 , p_validation_level NUMBER
378 , p_module_type VARCHAR2
379 , x_return_status out nocopy VARCHAR2
380 , x_msg_count out nocopy NUMBER
381 , x_msg_data out nocopy VARCHAR2
382 , p8_a0 NUMBER
383 , p8_a1 NUMBER
384 , p8_a2 NUMBER
385 , p8_a3 NUMBER
386 , p8_a4 VARCHAR2
387 , p8_a5 NUMBER
388 , p8_a6 VARCHAR2
389 , p8_a7 NUMBER
390 , p8_a8 NUMBER
391 , p8_a9 DATE
392 , p8_a10 NUMBER
393 , p8_a11 DATE
394 , p8_a12 NUMBER
395 , p8_a13 NUMBER
396 , p8_a14 VARCHAR2
397 , p8_a15 VARCHAR2
398 , p8_a16 VARCHAR2
399 , p8_a17 VARCHAR2
400 , p8_a18 VARCHAR2
401 , p8_a19 VARCHAR2
402 , p8_a20 VARCHAR2
403 , p8_a21 VARCHAR2
404 , p8_a22 VARCHAR2
405 , p8_a23 VARCHAR2
406 , p8_a24 VARCHAR2
407 , p8_a25 VARCHAR2
408 , p8_a26 VARCHAR2
409 , p8_a27 VARCHAR2
410 , p8_a28 VARCHAR2
411 , p8_a29 VARCHAR2
412 )
413
414 as
415 ddp_reliability_data_rec ahl_ra_setups_pvt.ra_definition_hdr_rec_type;
416 ddindx binary_integer; indx binary_integer;
417 begin
418
419 -- copy data to the local IN or IN-OUT args, if any
420
421
422
423
424
425
426
427
428 ddp_reliability_data_rec.ra_definition_hdr_id := p8_a0;
429 ddp_reliability_data_rec.mc_header_id := p8_a1;
430 ddp_reliability_data_rec.inventory_item_id := p8_a2;
431 ddp_reliability_data_rec.inventory_org_id := p8_a3;
432 ddp_reliability_data_rec.item_revision := p8_a4;
433 ddp_reliability_data_rec.relationship_id := p8_a5;
434 ddp_reliability_data_rec.operation_flag := p8_a6;
435 ddp_reliability_data_rec.object_version_number := p8_a7;
436 ddp_reliability_data_rec.security_group_id := p8_a8;
437 ddp_reliability_data_rec.creation_date := p8_a9;
438 ddp_reliability_data_rec.created_by := p8_a10;
439 ddp_reliability_data_rec.last_update_date := p8_a11;
440 ddp_reliability_data_rec.last_updated_by := p8_a12;
441 ddp_reliability_data_rec.last_update_login := p8_a13;
442 ddp_reliability_data_rec.attribute_category := p8_a14;
443 ddp_reliability_data_rec.attribute1 := p8_a15;
444 ddp_reliability_data_rec.attribute2 := p8_a16;
445 ddp_reliability_data_rec.attribute3 := p8_a17;
446 ddp_reliability_data_rec.attribute4 := p8_a18;
447 ddp_reliability_data_rec.attribute5 := p8_a19;
448 ddp_reliability_data_rec.attribute6 := p8_a20;
449 ddp_reliability_data_rec.attribute7 := p8_a21;
450 ddp_reliability_data_rec.attribute8 := p8_a22;
451 ddp_reliability_data_rec.attribute9 := p8_a23;
452 ddp_reliability_data_rec.attribute10 := p8_a24;
453 ddp_reliability_data_rec.attribute11 := p8_a25;
454 ddp_reliability_data_rec.attribute12 := p8_a26;
455 ddp_reliability_data_rec.attribute13 := p8_a27;
456 ddp_reliability_data_rec.attribute14 := p8_a28;
457 ddp_reliability_data_rec.attribute15 := p8_a29;
458
459 -- here's the delegated call to the old PL/SQL routine
460 ahl_ra_setups_pvt.delete_reliability_data(p_api_version,
461 p_init_msg_list,
462 p_commit,
463 p_validation_level,
464 p_module_type,
465 x_return_status,
466 x_msg_count,
467 x_msg_data,
468 ddp_reliability_data_rec);
469
470 -- copy data back from the local variables to OUT or IN-OUT args, if any
471
472
473
474
475
476
477
478
479 end;
480
481 procedure create_mtbf_data(p_api_version NUMBER
482 , p_init_msg_list VARCHAR2
483 , p_commit VARCHAR2
484 , p_validation_level NUMBER
485 , p_module_type VARCHAR2
486 , x_return_status out nocopy VARCHAR2
487 , x_msg_count out nocopy NUMBER
488 , x_msg_data out nocopy VARCHAR2
489 , p8_a0 in out nocopy NUMBER
490 , p8_a1 in out nocopy NUMBER
491 , p8_a2 in out nocopy NUMBER
492 , p8_a3 in out nocopy NUMBER
493 , p8_a4 in out nocopy VARCHAR2
494 , p8_a5 in out nocopy NUMBER
495 , p8_a6 in out nocopy VARCHAR2
496 , p8_a7 in out nocopy NUMBER
497 , p8_a8 in out nocopy NUMBER
498 , p8_a9 in out nocopy DATE
499 , p8_a10 in out nocopy NUMBER
500 , p8_a11 in out nocopy DATE
501 , p8_a12 in out nocopy NUMBER
502 , p8_a13 in out nocopy NUMBER
503 , p8_a14 in out nocopy VARCHAR2
504 , p8_a15 in out nocopy VARCHAR2
505 , p8_a16 in out nocopy VARCHAR2
506 , p8_a17 in out nocopy VARCHAR2
507 , p8_a18 in out nocopy VARCHAR2
508 , p8_a19 in out nocopy VARCHAR2
509 , p8_a20 in out nocopy VARCHAR2
510 , p8_a21 in out nocopy VARCHAR2
511 , p8_a22 in out nocopy VARCHAR2
512 , p8_a23 in out nocopy VARCHAR2
513 , p8_a24 in out nocopy VARCHAR2
514 , p8_a25 in out nocopy VARCHAR2
515 , p8_a26 in out nocopy VARCHAR2
516 , p8_a27 in out nocopy VARCHAR2
517 , p8_a28 in out nocopy VARCHAR2
518 , p8_a29 in out nocopy VARCHAR2
519 , p9_a0 in out nocopy NUMBER
520 , p9_a1 in out nocopy NUMBER
521 , p9_a2 in out nocopy NUMBER
522 , p9_a3 in out nocopy NUMBER
523 , p9_a4 in out nocopy VARCHAR2
524 , p9_a5 in out nocopy NUMBER
525 , p9_a6 in out nocopy NUMBER
526 , p9_a7 in out nocopy DATE
527 , p9_a8 in out nocopy NUMBER
528 , p9_a9 in out nocopy DATE
529 , p9_a10 in out nocopy NUMBER
530 , p9_a11 in out nocopy NUMBER
531 , p9_a12 in out nocopy VARCHAR2
532 , p9_a13 in out nocopy VARCHAR2
533 , p9_a14 in out nocopy VARCHAR2
534 , p9_a15 in out nocopy VARCHAR2
535 , p9_a16 in out nocopy VARCHAR2
536 , p9_a17 in out nocopy VARCHAR2
537 , p9_a18 in out nocopy VARCHAR2
538 , p9_a19 in out nocopy VARCHAR2
539 , p9_a20 in out nocopy VARCHAR2
540 , p9_a21 in out nocopy VARCHAR2
541 , p9_a22 in out nocopy VARCHAR2
542 , p9_a23 in out nocopy VARCHAR2
543 , p9_a24 in out nocopy VARCHAR2
544 , p9_a25 in out nocopy VARCHAR2
545 , p9_a26 in out nocopy VARCHAR2
546 , p9_a27 in out nocopy VARCHAR2
547 )
548
549 as
550 ddp_x_reliability_data_rec ahl_ra_setups_pvt.ra_definition_hdr_rec_type;
551 ddp_x_mtbf_data_rec ahl_ra_setups_pvt.ra_definition_dtls_rec_type;
552 ddindx binary_integer; indx binary_integer;
553 begin
554
555 -- copy data to the local IN or IN-OUT args, if any
556
557
558
559
560
561
562
563
564 ddp_x_reliability_data_rec.ra_definition_hdr_id := p8_a0;
565 ddp_x_reliability_data_rec.mc_header_id := p8_a1;
566 ddp_x_reliability_data_rec.inventory_item_id := p8_a2;
567 ddp_x_reliability_data_rec.inventory_org_id := p8_a3;
568 ddp_x_reliability_data_rec.item_revision := p8_a4;
569 ddp_x_reliability_data_rec.relationship_id := p8_a5;
570 ddp_x_reliability_data_rec.operation_flag := p8_a6;
571 ddp_x_reliability_data_rec.object_version_number := p8_a7;
572 ddp_x_reliability_data_rec.security_group_id := p8_a8;
573 ddp_x_reliability_data_rec.creation_date := p8_a9;
574 ddp_x_reliability_data_rec.created_by := p8_a10;
575 ddp_x_reliability_data_rec.last_update_date := p8_a11;
576 ddp_x_reliability_data_rec.last_updated_by := p8_a12;
577 ddp_x_reliability_data_rec.last_update_login := p8_a13;
578 ddp_x_reliability_data_rec.attribute_category := p8_a14;
579 ddp_x_reliability_data_rec.attribute1 := p8_a15;
580 ddp_x_reliability_data_rec.attribute2 := p8_a16;
581 ddp_x_reliability_data_rec.attribute3 := p8_a17;
582 ddp_x_reliability_data_rec.attribute4 := p8_a18;
583 ddp_x_reliability_data_rec.attribute5 := p8_a19;
584 ddp_x_reliability_data_rec.attribute6 := p8_a20;
585 ddp_x_reliability_data_rec.attribute7 := p8_a21;
586 ddp_x_reliability_data_rec.attribute8 := p8_a22;
587 ddp_x_reliability_data_rec.attribute9 := p8_a23;
588 ddp_x_reliability_data_rec.attribute10 := p8_a24;
589 ddp_x_reliability_data_rec.attribute11 := p8_a25;
590 ddp_x_reliability_data_rec.attribute12 := p8_a26;
591 ddp_x_reliability_data_rec.attribute13 := p8_a27;
592 ddp_x_reliability_data_rec.attribute14 := p8_a28;
593 ddp_x_reliability_data_rec.attribute15 := p8_a29;
594
595 ddp_x_mtbf_data_rec.ra_definition_dtl_id := p9_a0;
596 ddp_x_mtbf_data_rec.ra_definition_hdr_id := p9_a1;
597 ddp_x_mtbf_data_rec.counter_id := p9_a2;
598 ddp_x_mtbf_data_rec.mtbf_value := p9_a3;
599 ddp_x_mtbf_data_rec.operation_flag := p9_a4;
600 ddp_x_mtbf_data_rec.object_version_number := p9_a5;
601 ddp_x_mtbf_data_rec.security_group_id := p9_a6;
602 ddp_x_mtbf_data_rec.creation_date := p9_a7;
603 ddp_x_mtbf_data_rec.created_by := p9_a8;
604 ddp_x_mtbf_data_rec.last_update_date := p9_a9;
605 ddp_x_mtbf_data_rec.last_updated_by := p9_a10;
606 ddp_x_mtbf_data_rec.last_update_login := p9_a11;
607 ddp_x_mtbf_data_rec.attribute_category := p9_a12;
608 ddp_x_mtbf_data_rec.attribute1 := p9_a13;
609 ddp_x_mtbf_data_rec.attribute2 := p9_a14;
610 ddp_x_mtbf_data_rec.attribute3 := p9_a15;
611 ddp_x_mtbf_data_rec.attribute4 := p9_a16;
612 ddp_x_mtbf_data_rec.attribute5 := p9_a17;
613 ddp_x_mtbf_data_rec.attribute6 := p9_a18;
614 ddp_x_mtbf_data_rec.attribute7 := p9_a19;
615 ddp_x_mtbf_data_rec.attribute8 := p9_a20;
616 ddp_x_mtbf_data_rec.attribute9 := p9_a21;
617 ddp_x_mtbf_data_rec.attribute10 := p9_a22;
618 ddp_x_mtbf_data_rec.attribute11 := p9_a23;
619 ddp_x_mtbf_data_rec.attribute12 := p9_a24;
620 ddp_x_mtbf_data_rec.attribute13 := p9_a25;
621 ddp_x_mtbf_data_rec.attribute14 := p9_a26;
622 ddp_x_mtbf_data_rec.attribute15 := p9_a27;
623
624 -- here's the delegated call to the old PL/SQL routine
625 ahl_ra_setups_pvt.create_mtbf_data(p_api_version,
626 p_init_msg_list,
627 p_commit,
628 p_validation_level,
629 p_module_type,
630 x_return_status,
631 x_msg_count,
632 x_msg_data,
633 ddp_x_reliability_data_rec,
634 ddp_x_mtbf_data_rec);
635
636 -- copy data back from the local variables to OUT or IN-OUT args, if any
637
638
639
640
641
642
643
644
645 p8_a0 := ddp_x_reliability_data_rec.ra_definition_hdr_id;
646 p8_a1 := ddp_x_reliability_data_rec.mc_header_id;
647 p8_a2 := ddp_x_reliability_data_rec.inventory_item_id;
648 p8_a3 := ddp_x_reliability_data_rec.inventory_org_id;
649 p8_a4 := ddp_x_reliability_data_rec.item_revision;
650 p8_a5 := ddp_x_reliability_data_rec.relationship_id;
651 p8_a6 := ddp_x_reliability_data_rec.operation_flag;
652 p8_a7 := ddp_x_reliability_data_rec.object_version_number;
653 p8_a8 := ddp_x_reliability_data_rec.security_group_id;
654 p8_a9 := ddp_x_reliability_data_rec.creation_date;
655 p8_a10 := ddp_x_reliability_data_rec.created_by;
656 p8_a11 := ddp_x_reliability_data_rec.last_update_date;
657 p8_a12 := ddp_x_reliability_data_rec.last_updated_by;
658 p8_a13 := ddp_x_reliability_data_rec.last_update_login;
659 p8_a14 := ddp_x_reliability_data_rec.attribute_category;
660 p8_a15 := ddp_x_reliability_data_rec.attribute1;
661 p8_a16 := ddp_x_reliability_data_rec.attribute2;
662 p8_a17 := ddp_x_reliability_data_rec.attribute3;
663 p8_a18 := ddp_x_reliability_data_rec.attribute4;
664 p8_a19 := ddp_x_reliability_data_rec.attribute5;
665 p8_a20 := ddp_x_reliability_data_rec.attribute6;
666 p8_a21 := ddp_x_reliability_data_rec.attribute7;
667 p8_a22 := ddp_x_reliability_data_rec.attribute8;
668 p8_a23 := ddp_x_reliability_data_rec.attribute9;
669 p8_a24 := ddp_x_reliability_data_rec.attribute10;
670 p8_a25 := ddp_x_reliability_data_rec.attribute11;
671 p8_a26 := ddp_x_reliability_data_rec.attribute12;
672 p8_a27 := ddp_x_reliability_data_rec.attribute13;
673 p8_a28 := ddp_x_reliability_data_rec.attribute14;
674 p8_a29 := ddp_x_reliability_data_rec.attribute15;
675
676 p9_a0 := ddp_x_mtbf_data_rec.ra_definition_dtl_id;
677 p9_a1 := ddp_x_mtbf_data_rec.ra_definition_hdr_id;
678 p9_a2 := ddp_x_mtbf_data_rec.counter_id;
679 p9_a3 := ddp_x_mtbf_data_rec.mtbf_value;
680 p9_a4 := ddp_x_mtbf_data_rec.operation_flag;
681 p9_a5 := ddp_x_mtbf_data_rec.object_version_number;
682 p9_a6 := ddp_x_mtbf_data_rec.security_group_id;
683 p9_a7 := ddp_x_mtbf_data_rec.creation_date;
684 p9_a8 := ddp_x_mtbf_data_rec.created_by;
685 p9_a9 := ddp_x_mtbf_data_rec.last_update_date;
686 p9_a10 := ddp_x_mtbf_data_rec.last_updated_by;
687 p9_a11 := ddp_x_mtbf_data_rec.last_update_login;
688 p9_a12 := ddp_x_mtbf_data_rec.attribute_category;
689 p9_a13 := ddp_x_mtbf_data_rec.attribute1;
690 p9_a14 := ddp_x_mtbf_data_rec.attribute2;
691 p9_a15 := ddp_x_mtbf_data_rec.attribute3;
692 p9_a16 := ddp_x_mtbf_data_rec.attribute4;
693 p9_a17 := ddp_x_mtbf_data_rec.attribute5;
694 p9_a18 := ddp_x_mtbf_data_rec.attribute6;
695 p9_a19 := ddp_x_mtbf_data_rec.attribute7;
696 p9_a20 := ddp_x_mtbf_data_rec.attribute8;
697 p9_a21 := ddp_x_mtbf_data_rec.attribute9;
698 p9_a22 := ddp_x_mtbf_data_rec.attribute10;
699 p9_a23 := ddp_x_mtbf_data_rec.attribute11;
700 p9_a24 := ddp_x_mtbf_data_rec.attribute12;
701 p9_a25 := ddp_x_mtbf_data_rec.attribute13;
702 p9_a26 := ddp_x_mtbf_data_rec.attribute14;
703 p9_a27 := ddp_x_mtbf_data_rec.attribute15;
704 end;
705
706 procedure update_mtbf_data(p_api_version NUMBER
707 , p_init_msg_list VARCHAR2
708 , p_commit VARCHAR2
709 , p_validation_level NUMBER
710 , p_module_type VARCHAR2
711 , x_return_status out nocopy VARCHAR2
712 , x_msg_count out nocopy NUMBER
713 , x_msg_data out nocopy VARCHAR2
714 , p8_a0 in out nocopy NUMBER
715 , p8_a1 in out nocopy NUMBER
716 , p8_a2 in out nocopy NUMBER
717 , p8_a3 in out nocopy NUMBER
718 , p8_a4 in out nocopy VARCHAR2
719 , p8_a5 in out nocopy NUMBER
720 , p8_a6 in out nocopy VARCHAR2
721 , p8_a7 in out nocopy NUMBER
722 , p8_a8 in out nocopy NUMBER
723 , p8_a9 in out nocopy DATE
724 , p8_a10 in out nocopy NUMBER
725 , p8_a11 in out nocopy DATE
726 , p8_a12 in out nocopy NUMBER
727 , p8_a13 in out nocopy NUMBER
728 , p8_a14 in out nocopy VARCHAR2
729 , p8_a15 in out nocopy VARCHAR2
730 , p8_a16 in out nocopy VARCHAR2
731 , p8_a17 in out nocopy VARCHAR2
732 , p8_a18 in out nocopy VARCHAR2
733 , p8_a19 in out nocopy VARCHAR2
734 , p8_a20 in out nocopy VARCHAR2
735 , p8_a21 in out nocopy VARCHAR2
736 , p8_a22 in out nocopy VARCHAR2
737 , p8_a23 in out nocopy VARCHAR2
738 , p8_a24 in out nocopy VARCHAR2
739 , p8_a25 in out nocopy VARCHAR2
740 , p8_a26 in out nocopy VARCHAR2
741 , p8_a27 in out nocopy VARCHAR2
742 , p8_a28 in out nocopy VARCHAR2
743 , p8_a29 in out nocopy VARCHAR2
744 , p9_a0 in out nocopy NUMBER
745 , p9_a1 in out nocopy NUMBER
746 , p9_a2 in out nocopy NUMBER
747 , p9_a3 in out nocopy NUMBER
748 , p9_a4 in out nocopy VARCHAR2
749 , p9_a5 in out nocopy NUMBER
750 , p9_a6 in out nocopy NUMBER
751 , p9_a7 in out nocopy DATE
752 , p9_a8 in out nocopy NUMBER
753 , p9_a9 in out nocopy DATE
754 , p9_a10 in out nocopy NUMBER
755 , p9_a11 in out nocopy NUMBER
756 , p9_a12 in out nocopy VARCHAR2
757 , p9_a13 in out nocopy VARCHAR2
758 , p9_a14 in out nocopy VARCHAR2
759 , p9_a15 in out nocopy VARCHAR2
760 , p9_a16 in out nocopy VARCHAR2
761 , p9_a17 in out nocopy VARCHAR2
762 , p9_a18 in out nocopy VARCHAR2
763 , p9_a19 in out nocopy VARCHAR2
764 , p9_a20 in out nocopy VARCHAR2
765 , p9_a21 in out nocopy VARCHAR2
766 , p9_a22 in out nocopy VARCHAR2
767 , p9_a23 in out nocopy VARCHAR2
768 , p9_a24 in out nocopy VARCHAR2
769 , p9_a25 in out nocopy VARCHAR2
770 , p9_a26 in out nocopy VARCHAR2
771 , p9_a27 in out nocopy VARCHAR2
772 )
773
774 as
775 ddp_x_reliability_data_rec ahl_ra_setups_pvt.ra_definition_hdr_rec_type;
776 ddp_x_mtbf_data_rec ahl_ra_setups_pvt.ra_definition_dtls_rec_type;
777 ddindx binary_integer; indx binary_integer;
778 begin
779
780 -- copy data to the local IN or IN-OUT args, if any
781
782
783
784
785
786
787
788
789 ddp_x_reliability_data_rec.ra_definition_hdr_id := p8_a0;
790 ddp_x_reliability_data_rec.mc_header_id := p8_a1;
791 ddp_x_reliability_data_rec.inventory_item_id := p8_a2;
792 ddp_x_reliability_data_rec.inventory_org_id := p8_a3;
793 ddp_x_reliability_data_rec.item_revision := p8_a4;
794 ddp_x_reliability_data_rec.relationship_id := p8_a5;
795 ddp_x_reliability_data_rec.operation_flag := p8_a6;
796 ddp_x_reliability_data_rec.object_version_number := p8_a7;
797 ddp_x_reliability_data_rec.security_group_id := p8_a8;
798 ddp_x_reliability_data_rec.creation_date := p8_a9;
799 ddp_x_reliability_data_rec.created_by := p8_a10;
800 ddp_x_reliability_data_rec.last_update_date := p8_a11;
801 ddp_x_reliability_data_rec.last_updated_by := p8_a12;
802 ddp_x_reliability_data_rec.last_update_login := p8_a13;
803 ddp_x_reliability_data_rec.attribute_category := p8_a14;
804 ddp_x_reliability_data_rec.attribute1 := p8_a15;
805 ddp_x_reliability_data_rec.attribute2 := p8_a16;
806 ddp_x_reliability_data_rec.attribute3 := p8_a17;
807 ddp_x_reliability_data_rec.attribute4 := p8_a18;
808 ddp_x_reliability_data_rec.attribute5 := p8_a19;
809 ddp_x_reliability_data_rec.attribute6 := p8_a20;
810 ddp_x_reliability_data_rec.attribute7 := p8_a21;
811 ddp_x_reliability_data_rec.attribute8 := p8_a22;
812 ddp_x_reliability_data_rec.attribute9 := p8_a23;
813 ddp_x_reliability_data_rec.attribute10 := p8_a24;
814 ddp_x_reliability_data_rec.attribute11 := p8_a25;
815 ddp_x_reliability_data_rec.attribute12 := p8_a26;
816 ddp_x_reliability_data_rec.attribute13 := p8_a27;
817 ddp_x_reliability_data_rec.attribute14 := p8_a28;
818 ddp_x_reliability_data_rec.attribute15 := p8_a29;
819
820 ddp_x_mtbf_data_rec.ra_definition_dtl_id := p9_a0;
821 ddp_x_mtbf_data_rec.ra_definition_hdr_id := p9_a1;
822 ddp_x_mtbf_data_rec.counter_id := p9_a2;
823 ddp_x_mtbf_data_rec.mtbf_value := p9_a3;
824 ddp_x_mtbf_data_rec.operation_flag := p9_a4;
825 ddp_x_mtbf_data_rec.object_version_number := p9_a5;
826 ddp_x_mtbf_data_rec.security_group_id := p9_a6;
827 ddp_x_mtbf_data_rec.creation_date := p9_a7;
828 ddp_x_mtbf_data_rec.created_by := p9_a8;
829 ddp_x_mtbf_data_rec.last_update_date := p9_a9;
830 ddp_x_mtbf_data_rec.last_updated_by := p9_a10;
831 ddp_x_mtbf_data_rec.last_update_login := p9_a11;
832 ddp_x_mtbf_data_rec.attribute_category := p9_a12;
833 ddp_x_mtbf_data_rec.attribute1 := p9_a13;
834 ddp_x_mtbf_data_rec.attribute2 := p9_a14;
835 ddp_x_mtbf_data_rec.attribute3 := p9_a15;
836 ddp_x_mtbf_data_rec.attribute4 := p9_a16;
837 ddp_x_mtbf_data_rec.attribute5 := p9_a17;
838 ddp_x_mtbf_data_rec.attribute6 := p9_a18;
839 ddp_x_mtbf_data_rec.attribute7 := p9_a19;
840 ddp_x_mtbf_data_rec.attribute8 := p9_a20;
841 ddp_x_mtbf_data_rec.attribute9 := p9_a21;
842 ddp_x_mtbf_data_rec.attribute10 := p9_a22;
843 ddp_x_mtbf_data_rec.attribute11 := p9_a23;
844 ddp_x_mtbf_data_rec.attribute12 := p9_a24;
845 ddp_x_mtbf_data_rec.attribute13 := p9_a25;
846 ddp_x_mtbf_data_rec.attribute14 := p9_a26;
847 ddp_x_mtbf_data_rec.attribute15 := p9_a27;
848
849 -- here's the delegated call to the old PL/SQL routine
850 ahl_ra_setups_pvt.update_mtbf_data(p_api_version,
851 p_init_msg_list,
852 p_commit,
853 p_validation_level,
854 p_module_type,
855 x_return_status,
856 x_msg_count,
857 x_msg_data,
858 ddp_x_reliability_data_rec,
859 ddp_x_mtbf_data_rec);
860
861 -- copy data back from the local variables to OUT or IN-OUT args, if any
862
863
864
865
866
867
868
869
870 p8_a0 := ddp_x_reliability_data_rec.ra_definition_hdr_id;
871 p8_a1 := ddp_x_reliability_data_rec.mc_header_id;
872 p8_a2 := ddp_x_reliability_data_rec.inventory_item_id;
873 p8_a3 := ddp_x_reliability_data_rec.inventory_org_id;
874 p8_a4 := ddp_x_reliability_data_rec.item_revision;
875 p8_a5 := ddp_x_reliability_data_rec.relationship_id;
876 p8_a6 := ddp_x_reliability_data_rec.operation_flag;
877 p8_a7 := ddp_x_reliability_data_rec.object_version_number;
878 p8_a8 := ddp_x_reliability_data_rec.security_group_id;
879 p8_a9 := ddp_x_reliability_data_rec.creation_date;
880 p8_a10 := ddp_x_reliability_data_rec.created_by;
881 p8_a11 := ddp_x_reliability_data_rec.last_update_date;
882 p8_a12 := ddp_x_reliability_data_rec.last_updated_by;
883 p8_a13 := ddp_x_reliability_data_rec.last_update_login;
884 p8_a14 := ddp_x_reliability_data_rec.attribute_category;
885 p8_a15 := ddp_x_reliability_data_rec.attribute1;
886 p8_a16 := ddp_x_reliability_data_rec.attribute2;
887 p8_a17 := ddp_x_reliability_data_rec.attribute3;
888 p8_a18 := ddp_x_reliability_data_rec.attribute4;
889 p8_a19 := ddp_x_reliability_data_rec.attribute5;
890 p8_a20 := ddp_x_reliability_data_rec.attribute6;
891 p8_a21 := ddp_x_reliability_data_rec.attribute7;
892 p8_a22 := ddp_x_reliability_data_rec.attribute8;
893 p8_a23 := ddp_x_reliability_data_rec.attribute9;
894 p8_a24 := ddp_x_reliability_data_rec.attribute10;
895 p8_a25 := ddp_x_reliability_data_rec.attribute11;
896 p8_a26 := ddp_x_reliability_data_rec.attribute12;
897 p8_a27 := ddp_x_reliability_data_rec.attribute13;
898 p8_a28 := ddp_x_reliability_data_rec.attribute14;
899 p8_a29 := ddp_x_reliability_data_rec.attribute15;
900
901 p9_a0 := ddp_x_mtbf_data_rec.ra_definition_dtl_id;
902 p9_a1 := ddp_x_mtbf_data_rec.ra_definition_hdr_id;
903 p9_a2 := ddp_x_mtbf_data_rec.counter_id;
904 p9_a3 := ddp_x_mtbf_data_rec.mtbf_value;
905 p9_a4 := ddp_x_mtbf_data_rec.operation_flag;
906 p9_a5 := ddp_x_mtbf_data_rec.object_version_number;
907 p9_a6 := ddp_x_mtbf_data_rec.security_group_id;
908 p9_a7 := ddp_x_mtbf_data_rec.creation_date;
909 p9_a8 := ddp_x_mtbf_data_rec.created_by;
910 p9_a9 := ddp_x_mtbf_data_rec.last_update_date;
911 p9_a10 := ddp_x_mtbf_data_rec.last_updated_by;
912 p9_a11 := ddp_x_mtbf_data_rec.last_update_login;
913 p9_a12 := ddp_x_mtbf_data_rec.attribute_category;
914 p9_a13 := ddp_x_mtbf_data_rec.attribute1;
915 p9_a14 := ddp_x_mtbf_data_rec.attribute2;
916 p9_a15 := ddp_x_mtbf_data_rec.attribute3;
917 p9_a16 := ddp_x_mtbf_data_rec.attribute4;
918 p9_a17 := ddp_x_mtbf_data_rec.attribute5;
919 p9_a18 := ddp_x_mtbf_data_rec.attribute6;
920 p9_a19 := ddp_x_mtbf_data_rec.attribute7;
921 p9_a20 := ddp_x_mtbf_data_rec.attribute8;
922 p9_a21 := ddp_x_mtbf_data_rec.attribute9;
923 p9_a22 := ddp_x_mtbf_data_rec.attribute10;
924 p9_a23 := ddp_x_mtbf_data_rec.attribute11;
925 p9_a24 := ddp_x_mtbf_data_rec.attribute12;
926 p9_a25 := ddp_x_mtbf_data_rec.attribute13;
927 p9_a26 := ddp_x_mtbf_data_rec.attribute14;
928 p9_a27 := ddp_x_mtbf_data_rec.attribute15;
929 end;
930
931 procedure delete_mtbf_data(p_api_version NUMBER
932 , p_init_msg_list VARCHAR2
933 , p_commit VARCHAR2
934 , p_validation_level NUMBER
935 , p_module_type VARCHAR2
936 , x_return_status out nocopy VARCHAR2
937 , x_msg_count out nocopy NUMBER
938 , x_msg_data out nocopy VARCHAR2
939 , p8_a0 in out nocopy NUMBER
940 , p8_a1 in out nocopy NUMBER
941 , p8_a2 in out nocopy NUMBER
942 , p8_a3 in out nocopy NUMBER
943 , p8_a4 in out nocopy VARCHAR2
944 , p8_a5 in out nocopy NUMBER
945 , p8_a6 in out nocopy VARCHAR2
946 , p8_a7 in out nocopy NUMBER
947 , p8_a8 in out nocopy NUMBER
948 , p8_a9 in out nocopy DATE
949 , p8_a10 in out nocopy NUMBER
950 , p8_a11 in out nocopy DATE
951 , p8_a12 in out nocopy NUMBER
952 , p8_a13 in out nocopy NUMBER
953 , p8_a14 in out nocopy VARCHAR2
954 , p8_a15 in out nocopy VARCHAR2
955 , p8_a16 in out nocopy VARCHAR2
956 , p8_a17 in out nocopy VARCHAR2
957 , p8_a18 in out nocopy VARCHAR2
958 , p8_a19 in out nocopy VARCHAR2
959 , p8_a20 in out nocopy VARCHAR2
960 , p8_a21 in out nocopy VARCHAR2
961 , p8_a22 in out nocopy VARCHAR2
962 , p8_a23 in out nocopy VARCHAR2
963 , p8_a24 in out nocopy VARCHAR2
964 , p8_a25 in out nocopy VARCHAR2
965 , p8_a26 in out nocopy VARCHAR2
966 , p8_a27 in out nocopy VARCHAR2
967 , p8_a28 in out nocopy VARCHAR2
968 , p8_a29 in out nocopy VARCHAR2
969 , p9_a0 NUMBER
970 , p9_a1 NUMBER
971 , p9_a2 NUMBER
972 , p9_a3 NUMBER
973 , p9_a4 VARCHAR2
974 , p9_a5 NUMBER
975 , p9_a6 NUMBER
976 , p9_a7 DATE
977 , p9_a8 NUMBER
978 , p9_a9 DATE
979 , p9_a10 NUMBER
980 , p9_a11 NUMBER
981 , p9_a12 VARCHAR2
982 , p9_a13 VARCHAR2
983 , p9_a14 VARCHAR2
984 , p9_a15 VARCHAR2
985 , p9_a16 VARCHAR2
986 , p9_a17 VARCHAR2
987 , p9_a18 VARCHAR2
988 , p9_a19 VARCHAR2
989 , p9_a20 VARCHAR2
990 , p9_a21 VARCHAR2
991 , p9_a22 VARCHAR2
992 , p9_a23 VARCHAR2
993 , p9_a24 VARCHAR2
994 , p9_a25 VARCHAR2
995 , p9_a26 VARCHAR2
996 , p9_a27 VARCHAR2
997 )
998
999 as
1000 ddp_x_reliability_data_rec ahl_ra_setups_pvt.ra_definition_hdr_rec_type;
1001 ddp_mtbf_data_rec ahl_ra_setups_pvt.ra_definition_dtls_rec_type;
1002 ddindx binary_integer; indx binary_integer;
1003 begin
1004
1005 -- copy data to the local IN or IN-OUT args, if any
1006
1007
1008
1009
1010
1011
1012
1013
1014 ddp_x_reliability_data_rec.ra_definition_hdr_id := p8_a0;
1015 ddp_x_reliability_data_rec.mc_header_id := p8_a1;
1016 ddp_x_reliability_data_rec.inventory_item_id := p8_a2;
1017 ddp_x_reliability_data_rec.inventory_org_id := p8_a3;
1018 ddp_x_reliability_data_rec.item_revision := p8_a4;
1019 ddp_x_reliability_data_rec.relationship_id := p8_a5;
1020 ddp_x_reliability_data_rec.operation_flag := p8_a6;
1021 ddp_x_reliability_data_rec.object_version_number := p8_a7;
1022 ddp_x_reliability_data_rec.security_group_id := p8_a8;
1023 ddp_x_reliability_data_rec.creation_date := p8_a9;
1024 ddp_x_reliability_data_rec.created_by := p8_a10;
1025 ddp_x_reliability_data_rec.last_update_date := p8_a11;
1026 ddp_x_reliability_data_rec.last_updated_by := p8_a12;
1027 ddp_x_reliability_data_rec.last_update_login := p8_a13;
1028 ddp_x_reliability_data_rec.attribute_category := p8_a14;
1029 ddp_x_reliability_data_rec.attribute1 := p8_a15;
1030 ddp_x_reliability_data_rec.attribute2 := p8_a16;
1031 ddp_x_reliability_data_rec.attribute3 := p8_a17;
1032 ddp_x_reliability_data_rec.attribute4 := p8_a18;
1033 ddp_x_reliability_data_rec.attribute5 := p8_a19;
1034 ddp_x_reliability_data_rec.attribute6 := p8_a20;
1035 ddp_x_reliability_data_rec.attribute7 := p8_a21;
1036 ddp_x_reliability_data_rec.attribute8 := p8_a22;
1037 ddp_x_reliability_data_rec.attribute9 := p8_a23;
1038 ddp_x_reliability_data_rec.attribute10 := p8_a24;
1039 ddp_x_reliability_data_rec.attribute11 := p8_a25;
1040 ddp_x_reliability_data_rec.attribute12 := p8_a26;
1041 ddp_x_reliability_data_rec.attribute13 := p8_a27;
1042 ddp_x_reliability_data_rec.attribute14 := p8_a28;
1043 ddp_x_reliability_data_rec.attribute15 := p8_a29;
1044
1045 ddp_mtbf_data_rec.ra_definition_dtl_id := p9_a0;
1046 ddp_mtbf_data_rec.ra_definition_hdr_id := p9_a1;
1047 ddp_mtbf_data_rec.counter_id := p9_a2;
1048 ddp_mtbf_data_rec.mtbf_value := p9_a3;
1049 ddp_mtbf_data_rec.operation_flag := p9_a4;
1050 ddp_mtbf_data_rec.object_version_number := p9_a5;
1051 ddp_mtbf_data_rec.security_group_id := p9_a6;
1052 ddp_mtbf_data_rec.creation_date := p9_a7;
1053 ddp_mtbf_data_rec.created_by := p9_a8;
1054 ddp_mtbf_data_rec.last_update_date := p9_a9;
1055 ddp_mtbf_data_rec.last_updated_by := p9_a10;
1056 ddp_mtbf_data_rec.last_update_login := p9_a11;
1057 ddp_mtbf_data_rec.attribute_category := p9_a12;
1058 ddp_mtbf_data_rec.attribute1 := p9_a13;
1059 ddp_mtbf_data_rec.attribute2 := p9_a14;
1060 ddp_mtbf_data_rec.attribute3 := p9_a15;
1061 ddp_mtbf_data_rec.attribute4 := p9_a16;
1062 ddp_mtbf_data_rec.attribute5 := p9_a17;
1063 ddp_mtbf_data_rec.attribute6 := p9_a18;
1064 ddp_mtbf_data_rec.attribute7 := p9_a19;
1065 ddp_mtbf_data_rec.attribute8 := p9_a20;
1066 ddp_mtbf_data_rec.attribute9 := p9_a21;
1067 ddp_mtbf_data_rec.attribute10 := p9_a22;
1068 ddp_mtbf_data_rec.attribute11 := p9_a23;
1069 ddp_mtbf_data_rec.attribute12 := p9_a24;
1070 ddp_mtbf_data_rec.attribute13 := p9_a25;
1071 ddp_mtbf_data_rec.attribute14 := p9_a26;
1072 ddp_mtbf_data_rec.attribute15 := p9_a27;
1073
1074 -- here's the delegated call to the old PL/SQL routine
1075 ahl_ra_setups_pvt.delete_mtbf_data(p_api_version,
1076 p_init_msg_list,
1077 p_commit,
1078 p_validation_level,
1079 p_module_type,
1080 x_return_status,
1081 x_msg_count,
1082 x_msg_data,
1083 ddp_x_reliability_data_rec,
1084 ddp_mtbf_data_rec);
1085
1086 -- copy data back from the local variables to OUT or IN-OUT args, if any
1087
1088
1089
1090
1091
1092
1093
1094
1095 p8_a0 := ddp_x_reliability_data_rec.ra_definition_hdr_id;
1096 p8_a1 := ddp_x_reliability_data_rec.mc_header_id;
1097 p8_a2 := ddp_x_reliability_data_rec.inventory_item_id;
1098 p8_a3 := ddp_x_reliability_data_rec.inventory_org_id;
1099 p8_a4 := ddp_x_reliability_data_rec.item_revision;
1100 p8_a5 := ddp_x_reliability_data_rec.relationship_id;
1101 p8_a6 := ddp_x_reliability_data_rec.operation_flag;
1102 p8_a7 := ddp_x_reliability_data_rec.object_version_number;
1103 p8_a8 := ddp_x_reliability_data_rec.security_group_id;
1104 p8_a9 := ddp_x_reliability_data_rec.creation_date;
1105 p8_a10 := ddp_x_reliability_data_rec.created_by;
1106 p8_a11 := ddp_x_reliability_data_rec.last_update_date;
1107 p8_a12 := ddp_x_reliability_data_rec.last_updated_by;
1108 p8_a13 := ddp_x_reliability_data_rec.last_update_login;
1109 p8_a14 := ddp_x_reliability_data_rec.attribute_category;
1110 p8_a15 := ddp_x_reliability_data_rec.attribute1;
1111 p8_a16 := ddp_x_reliability_data_rec.attribute2;
1112 p8_a17 := ddp_x_reliability_data_rec.attribute3;
1113 p8_a18 := ddp_x_reliability_data_rec.attribute4;
1114 p8_a19 := ddp_x_reliability_data_rec.attribute5;
1115 p8_a20 := ddp_x_reliability_data_rec.attribute6;
1116 p8_a21 := ddp_x_reliability_data_rec.attribute7;
1117 p8_a22 := ddp_x_reliability_data_rec.attribute8;
1118 p8_a23 := ddp_x_reliability_data_rec.attribute9;
1119 p8_a24 := ddp_x_reliability_data_rec.attribute10;
1120 p8_a25 := ddp_x_reliability_data_rec.attribute11;
1121 p8_a26 := ddp_x_reliability_data_rec.attribute12;
1122 p8_a27 := ddp_x_reliability_data_rec.attribute13;
1123 p8_a28 := ddp_x_reliability_data_rec.attribute14;
1124 p8_a29 := ddp_x_reliability_data_rec.attribute15;
1125
1126 end;
1127
1128 procedure create_counter_assoc(p_api_version NUMBER
1129 , p_init_msg_list VARCHAR2
1130 , p_commit VARCHAR2
1131 , p_validation_level NUMBER
1132 , p_module_type VARCHAR2
1133 , x_return_status out nocopy VARCHAR2
1134 , x_msg_count out nocopy NUMBER
1135 , x_msg_data out nocopy VARCHAR2
1136 , p8_a0 in out nocopy NUMBER
1137 , p8_a1 in out nocopy NUMBER
1138 , p8_a2 in out nocopy NUMBER
1139 , p8_a3 in out nocopy VARCHAR2
1140 , p8_a4 in out nocopy VARCHAR2
1141 , p8_a5 in out nocopy NUMBER
1142 , p8_a6 in out nocopy NUMBER
1143 , p8_a7 in out nocopy DATE
1144 , p8_a8 in out nocopy NUMBER
1145 , p8_a9 in out nocopy DATE
1146 , p8_a10 in out nocopy NUMBER
1147 , p8_a11 in out nocopy NUMBER
1148 , p8_a12 in out nocopy VARCHAR2
1149 , p8_a13 in out nocopy VARCHAR2
1150 , p8_a14 in out nocopy VARCHAR2
1151 , p8_a15 in out nocopy VARCHAR2
1152 , p8_a16 in out nocopy VARCHAR2
1153 , p8_a17 in out nocopy VARCHAR2
1154 , p8_a18 in out nocopy VARCHAR2
1155 , p8_a19 in out nocopy VARCHAR2
1156 , p8_a20 in out nocopy VARCHAR2
1157 , p8_a21 in out nocopy VARCHAR2
1158 , p8_a22 in out nocopy VARCHAR2
1159 , p8_a23 in out nocopy VARCHAR2
1160 , p8_a24 in out nocopy VARCHAR2
1161 , p8_a25 in out nocopy VARCHAR2
1162 , p8_a26 in out nocopy VARCHAR2
1163 , p8_a27 in out nocopy VARCHAR2
1164 )
1165
1166 as
1167 ddp_x_counter_assoc_rec ahl_ra_setups_pvt.ra_counter_assoc_rec_type;
1168 ddindx binary_integer; indx binary_integer;
1169 begin
1170
1171 -- copy data to the local IN or IN-OUT args, if any
1172
1173
1174
1175
1176
1177
1178
1179
1180 ddp_x_counter_assoc_rec.ra_counter_association_id := p8_a0;
1181 ddp_x_counter_assoc_rec.since_new_counter_id := p8_a1;
1182 ddp_x_counter_assoc_rec.since_overhaul_counter_id := p8_a2;
1183 ddp_x_counter_assoc_rec.description := p8_a3;
1184 ddp_x_counter_assoc_rec.operation_flag := p8_a4;
1185 ddp_x_counter_assoc_rec.object_version_number := p8_a5;
1186 ddp_x_counter_assoc_rec.security_group_id := p8_a6;
1187 ddp_x_counter_assoc_rec.creation_date := p8_a7;
1188 ddp_x_counter_assoc_rec.created_by := p8_a8;
1189 ddp_x_counter_assoc_rec.last_update_date := p8_a9;
1190 ddp_x_counter_assoc_rec.last_updated_by := p8_a10;
1191 ddp_x_counter_assoc_rec.last_update_login := p8_a11;
1192 ddp_x_counter_assoc_rec.attribute_category := p8_a12;
1193 ddp_x_counter_assoc_rec.attribute1 := p8_a13;
1194 ddp_x_counter_assoc_rec.attribute2 := p8_a14;
1195 ddp_x_counter_assoc_rec.attribute3 := p8_a15;
1196 ddp_x_counter_assoc_rec.attribute4 := p8_a16;
1197 ddp_x_counter_assoc_rec.attribute5 := p8_a17;
1198 ddp_x_counter_assoc_rec.attribute6 := p8_a18;
1199 ddp_x_counter_assoc_rec.attribute7 := p8_a19;
1200 ddp_x_counter_assoc_rec.attribute8 := p8_a20;
1201 ddp_x_counter_assoc_rec.attribute9 := p8_a21;
1202 ddp_x_counter_assoc_rec.attribute10 := p8_a22;
1203 ddp_x_counter_assoc_rec.attribute11 := p8_a23;
1204 ddp_x_counter_assoc_rec.attribute12 := p8_a24;
1205 ddp_x_counter_assoc_rec.attribute13 := p8_a25;
1206 ddp_x_counter_assoc_rec.attribute14 := p8_a26;
1207 ddp_x_counter_assoc_rec.attribute15 := p8_a27;
1208
1209 -- here's the delegated call to the old PL/SQL routine
1210 ahl_ra_setups_pvt.create_counter_assoc(p_api_version,
1211 p_init_msg_list,
1212 p_commit,
1213 p_validation_level,
1214 p_module_type,
1215 x_return_status,
1216 x_msg_count,
1217 x_msg_data,
1218 ddp_x_counter_assoc_rec);
1219
1220 -- copy data back from the local variables to OUT or IN-OUT args, if any
1221
1222
1223
1224
1225
1226
1227
1228
1229 p8_a0 := ddp_x_counter_assoc_rec.ra_counter_association_id;
1230 p8_a1 := ddp_x_counter_assoc_rec.since_new_counter_id;
1231 p8_a2 := ddp_x_counter_assoc_rec.since_overhaul_counter_id;
1232 p8_a3 := ddp_x_counter_assoc_rec.description;
1233 p8_a4 := ddp_x_counter_assoc_rec.operation_flag;
1234 p8_a5 := ddp_x_counter_assoc_rec.object_version_number;
1235 p8_a6 := ddp_x_counter_assoc_rec.security_group_id;
1236 p8_a7 := ddp_x_counter_assoc_rec.creation_date;
1237 p8_a8 := ddp_x_counter_assoc_rec.created_by;
1238 p8_a9 := ddp_x_counter_assoc_rec.last_update_date;
1239 p8_a10 := ddp_x_counter_assoc_rec.last_updated_by;
1240 p8_a11 := ddp_x_counter_assoc_rec.last_update_login;
1241 p8_a12 := ddp_x_counter_assoc_rec.attribute_category;
1242 p8_a13 := ddp_x_counter_assoc_rec.attribute1;
1243 p8_a14 := ddp_x_counter_assoc_rec.attribute2;
1244 p8_a15 := ddp_x_counter_assoc_rec.attribute3;
1245 p8_a16 := ddp_x_counter_assoc_rec.attribute4;
1246 p8_a17 := ddp_x_counter_assoc_rec.attribute5;
1247 p8_a18 := ddp_x_counter_assoc_rec.attribute6;
1248 p8_a19 := ddp_x_counter_assoc_rec.attribute7;
1249 p8_a20 := ddp_x_counter_assoc_rec.attribute8;
1250 p8_a21 := ddp_x_counter_assoc_rec.attribute9;
1251 p8_a22 := ddp_x_counter_assoc_rec.attribute10;
1252 p8_a23 := ddp_x_counter_assoc_rec.attribute11;
1253 p8_a24 := ddp_x_counter_assoc_rec.attribute12;
1254 p8_a25 := ddp_x_counter_assoc_rec.attribute13;
1255 p8_a26 := ddp_x_counter_assoc_rec.attribute14;
1256 p8_a27 := ddp_x_counter_assoc_rec.attribute15;
1257 end;
1258
1259 procedure delete_counter_assoc(p_api_version NUMBER
1260 , p_init_msg_list VARCHAR2
1261 , p_commit VARCHAR2
1262 , p_validation_level NUMBER
1263 , p_module_type VARCHAR2
1264 , x_return_status out nocopy VARCHAR2
1265 , x_msg_count out nocopy NUMBER
1266 , x_msg_data out nocopy VARCHAR2
1267 , p8_a0 NUMBER
1268 , p8_a1 NUMBER
1269 , p8_a2 NUMBER
1270 , p8_a3 VARCHAR2
1271 , p8_a4 VARCHAR2
1272 , p8_a5 NUMBER
1273 , p8_a6 NUMBER
1274 , p8_a7 DATE
1275 , p8_a8 NUMBER
1276 , p8_a9 DATE
1277 , p8_a10 NUMBER
1278 , p8_a11 NUMBER
1279 , p8_a12 VARCHAR2
1280 , p8_a13 VARCHAR2
1281 , p8_a14 VARCHAR2
1282 , p8_a15 VARCHAR2
1283 , p8_a16 VARCHAR2
1284 , p8_a17 VARCHAR2
1285 , p8_a18 VARCHAR2
1286 , p8_a19 VARCHAR2
1287 , p8_a20 VARCHAR2
1288 , p8_a21 VARCHAR2
1289 , p8_a22 VARCHAR2
1290 , p8_a23 VARCHAR2
1291 , p8_a24 VARCHAR2
1292 , p8_a25 VARCHAR2
1293 , p8_a26 VARCHAR2
1294 , p8_a27 VARCHAR2
1295 )
1296
1297 as
1298 ddp_counter_assoc_rec ahl_ra_setups_pvt.ra_counter_assoc_rec_type;
1299 ddindx binary_integer; indx binary_integer;
1300 begin
1301
1302 -- copy data to the local IN or IN-OUT args, if any
1303
1304
1305
1306
1307
1308
1309
1310
1311 ddp_counter_assoc_rec.ra_counter_association_id := p8_a0;
1312 ddp_counter_assoc_rec.since_new_counter_id := p8_a1;
1313 ddp_counter_assoc_rec.since_overhaul_counter_id := p8_a2;
1314 ddp_counter_assoc_rec.description := p8_a3;
1315 ddp_counter_assoc_rec.operation_flag := p8_a4;
1316 ddp_counter_assoc_rec.object_version_number := p8_a5;
1317 ddp_counter_assoc_rec.security_group_id := p8_a6;
1318 ddp_counter_assoc_rec.creation_date := p8_a7;
1319 ddp_counter_assoc_rec.created_by := p8_a8;
1320 ddp_counter_assoc_rec.last_update_date := p8_a9;
1321 ddp_counter_assoc_rec.last_updated_by := p8_a10;
1322 ddp_counter_assoc_rec.last_update_login := p8_a11;
1323 ddp_counter_assoc_rec.attribute_category := p8_a12;
1324 ddp_counter_assoc_rec.attribute1 := p8_a13;
1325 ddp_counter_assoc_rec.attribute2 := p8_a14;
1326 ddp_counter_assoc_rec.attribute3 := p8_a15;
1327 ddp_counter_assoc_rec.attribute4 := p8_a16;
1328 ddp_counter_assoc_rec.attribute5 := p8_a17;
1329 ddp_counter_assoc_rec.attribute6 := p8_a18;
1330 ddp_counter_assoc_rec.attribute7 := p8_a19;
1331 ddp_counter_assoc_rec.attribute8 := p8_a20;
1332 ddp_counter_assoc_rec.attribute9 := p8_a21;
1333 ddp_counter_assoc_rec.attribute10 := p8_a22;
1334 ddp_counter_assoc_rec.attribute11 := p8_a23;
1335 ddp_counter_assoc_rec.attribute12 := p8_a24;
1336 ddp_counter_assoc_rec.attribute13 := p8_a25;
1337 ddp_counter_assoc_rec.attribute14 := p8_a26;
1338 ddp_counter_assoc_rec.attribute15 := p8_a27;
1339
1340 -- here's the delegated call to the old PL/SQL routine
1341 ahl_ra_setups_pvt.delete_counter_assoc(p_api_version,
1342 p_init_msg_list,
1343 p_commit,
1344 p_validation_level,
1345 p_module_type,
1346 x_return_status,
1347 x_msg_count,
1348 x_msg_data,
1349 ddp_counter_assoc_rec);
1350
1351 -- copy data back from the local variables to OUT or IN-OUT args, if any
1352
1353
1354
1355
1356
1357
1358
1359
1360 end;
1361
1362 procedure create_fct_assoc_data(p_api_version NUMBER
1363 , p_init_msg_list VARCHAR2
1364 , p_commit VARCHAR2
1365 , p_validation_level NUMBER
1366 , p_module_type VARCHAR2
1367 , x_return_status out nocopy VARCHAR2
1368 , x_msg_count out nocopy NUMBER
1369 , x_msg_data out nocopy VARCHAR2
1370 , p8_a0 in out nocopy NUMBER
1371 , p8_a1 in out nocopy VARCHAR2
1372 , p8_a2 in out nocopy VARCHAR2
1373 , p8_a3 in out nocopy NUMBER
1374 , p8_a4 in out nocopy NUMBER
1375 , p8_a5 in out nocopy NUMBER
1376 , p8_a6 in out nocopy VARCHAR2
1377 , p8_a7 in out nocopy NUMBER
1378 , p8_a8 in out nocopy NUMBER
1379 , p8_a9 in out nocopy DATE
1380 , p8_a10 in out nocopy NUMBER
1381 , p8_a11 in out nocopy DATE
1382 , p8_a12 in out nocopy NUMBER
1383 , p8_a13 in out nocopy NUMBER
1384 , p8_a14 in out nocopy VARCHAR2
1385 , p8_a15 in out nocopy VARCHAR2
1386 , p8_a16 in out nocopy VARCHAR2
1387 , p8_a17 in out nocopy VARCHAR2
1388 , p8_a18 in out nocopy VARCHAR2
1389 , p8_a19 in out nocopy VARCHAR2
1390 , p8_a20 in out nocopy VARCHAR2
1391 , p8_a21 in out nocopy VARCHAR2
1392 , p8_a22 in out nocopy VARCHAR2
1393 , p8_a23 in out nocopy VARCHAR2
1394 , p8_a24 in out nocopy VARCHAR2
1395 , p8_a25 in out nocopy VARCHAR2
1396 , p8_a26 in out nocopy VARCHAR2
1397 , p8_a27 in out nocopy VARCHAR2
1398 , p8_a28 in out nocopy VARCHAR2
1399 , p8_a29 in out nocopy VARCHAR2
1400 )
1401
1402 as
1403 ddp_x_fct_assoc_rec ahl_ra_setups_pvt.ra_fct_assoc_rec_type;
1404 ddindx binary_integer; indx binary_integer;
1405 begin
1406
1407 -- copy data to the local IN or IN-OUT args, if any
1408
1409
1410
1411
1412
1413
1414
1415
1416 ddp_x_fct_assoc_rec.ra_fct_association_id := p8_a0;
1417 ddp_x_fct_assoc_rec.forecast_designator := p8_a1;
1418 ddp_x_fct_assoc_rec.association_type_code := p8_a2;
1419 ddp_x_fct_assoc_rec.organization_id := p8_a3;
1420 ddp_x_fct_assoc_rec.probability_from := p8_a4;
1421 ddp_x_fct_assoc_rec.probability_to := p8_a5;
1422 ddp_x_fct_assoc_rec.operation_flag := p8_a6;
1423 ddp_x_fct_assoc_rec.object_version_number := p8_a7;
1424 ddp_x_fct_assoc_rec.security_group_id := p8_a8;
1425 ddp_x_fct_assoc_rec.creation_date := p8_a9;
1426 ddp_x_fct_assoc_rec.created_by := p8_a10;
1427 ddp_x_fct_assoc_rec.last_update_date := p8_a11;
1428 ddp_x_fct_assoc_rec.last_updated_by := p8_a12;
1429 ddp_x_fct_assoc_rec.last_update_login := p8_a13;
1430 ddp_x_fct_assoc_rec.attribute_category := p8_a14;
1431 ddp_x_fct_assoc_rec.attribute1 := p8_a15;
1432 ddp_x_fct_assoc_rec.attribute2 := p8_a16;
1433 ddp_x_fct_assoc_rec.attribute3 := p8_a17;
1434 ddp_x_fct_assoc_rec.attribute4 := p8_a18;
1435 ddp_x_fct_assoc_rec.attribute5 := p8_a19;
1436 ddp_x_fct_assoc_rec.attribute6 := p8_a20;
1437 ddp_x_fct_assoc_rec.attribute7 := p8_a21;
1438 ddp_x_fct_assoc_rec.attribute8 := p8_a22;
1439 ddp_x_fct_assoc_rec.attribute9 := p8_a23;
1440 ddp_x_fct_assoc_rec.attribute10 := p8_a24;
1441 ddp_x_fct_assoc_rec.attribute11 := p8_a25;
1442 ddp_x_fct_assoc_rec.attribute12 := p8_a26;
1443 ddp_x_fct_assoc_rec.attribute13 := p8_a27;
1444 ddp_x_fct_assoc_rec.attribute14 := p8_a28;
1445 ddp_x_fct_assoc_rec.attribute15 := p8_a29;
1446
1447 -- here's the delegated call to the old PL/SQL routine
1448 ahl_ra_setups_pvt.create_fct_assoc_data(p_api_version,
1449 p_init_msg_list,
1450 p_commit,
1451 p_validation_level,
1452 p_module_type,
1453 x_return_status,
1454 x_msg_count,
1455 x_msg_data,
1456 ddp_x_fct_assoc_rec);
1457
1458 -- copy data back from the local variables to OUT or IN-OUT args, if any
1459
1460
1461
1462
1463
1464
1465
1466
1467 p8_a0 := ddp_x_fct_assoc_rec.ra_fct_association_id;
1468 p8_a1 := ddp_x_fct_assoc_rec.forecast_designator;
1469 p8_a2 := ddp_x_fct_assoc_rec.association_type_code;
1470 p8_a3 := ddp_x_fct_assoc_rec.organization_id;
1471 p8_a4 := ddp_x_fct_assoc_rec.probability_from;
1472 p8_a5 := ddp_x_fct_assoc_rec.probability_to;
1473 p8_a6 := ddp_x_fct_assoc_rec.operation_flag;
1474 p8_a7 := ddp_x_fct_assoc_rec.object_version_number;
1475 p8_a8 := ddp_x_fct_assoc_rec.security_group_id;
1476 p8_a9 := ddp_x_fct_assoc_rec.creation_date;
1477 p8_a10 := ddp_x_fct_assoc_rec.created_by;
1478 p8_a11 := ddp_x_fct_assoc_rec.last_update_date;
1479 p8_a12 := ddp_x_fct_assoc_rec.last_updated_by;
1480 p8_a13 := ddp_x_fct_assoc_rec.last_update_login;
1481 p8_a14 := ddp_x_fct_assoc_rec.attribute_category;
1482 p8_a15 := ddp_x_fct_assoc_rec.attribute1;
1483 p8_a16 := ddp_x_fct_assoc_rec.attribute2;
1484 p8_a17 := ddp_x_fct_assoc_rec.attribute3;
1485 p8_a18 := ddp_x_fct_assoc_rec.attribute4;
1486 p8_a19 := ddp_x_fct_assoc_rec.attribute5;
1487 p8_a20 := ddp_x_fct_assoc_rec.attribute6;
1488 p8_a21 := ddp_x_fct_assoc_rec.attribute7;
1489 p8_a22 := ddp_x_fct_assoc_rec.attribute8;
1490 p8_a23 := ddp_x_fct_assoc_rec.attribute9;
1491 p8_a24 := ddp_x_fct_assoc_rec.attribute10;
1492 p8_a25 := ddp_x_fct_assoc_rec.attribute11;
1493 p8_a26 := ddp_x_fct_assoc_rec.attribute12;
1494 p8_a27 := ddp_x_fct_assoc_rec.attribute13;
1495 p8_a28 := ddp_x_fct_assoc_rec.attribute14;
1496 p8_a29 := ddp_x_fct_assoc_rec.attribute15;
1497 end;
1498
1499 procedure update_fct_assoc_data(p_api_version NUMBER
1500 , p_init_msg_list VARCHAR2
1501 , p_commit VARCHAR2
1502 , p_validation_level NUMBER
1503 , p_module_type VARCHAR2
1504 , x_return_status out nocopy VARCHAR2
1505 , x_msg_count out nocopy NUMBER
1506 , x_msg_data out nocopy VARCHAR2
1507 , p8_a0 in out nocopy NUMBER
1508 , p8_a1 in out nocopy VARCHAR2
1509 , p8_a2 in out nocopy VARCHAR2
1510 , p8_a3 in out nocopy NUMBER
1511 , p8_a4 in out nocopy NUMBER
1512 , p8_a5 in out nocopy NUMBER
1513 , p8_a6 in out nocopy VARCHAR2
1514 , p8_a7 in out nocopy NUMBER
1515 , p8_a8 in out nocopy NUMBER
1516 , p8_a9 in out nocopy DATE
1517 , p8_a10 in out nocopy NUMBER
1518 , p8_a11 in out nocopy DATE
1519 , p8_a12 in out nocopy NUMBER
1520 , p8_a13 in out nocopy NUMBER
1521 , p8_a14 in out nocopy VARCHAR2
1522 , p8_a15 in out nocopy VARCHAR2
1523 , p8_a16 in out nocopy VARCHAR2
1524 , p8_a17 in out nocopy VARCHAR2
1525 , p8_a18 in out nocopy VARCHAR2
1526 , p8_a19 in out nocopy VARCHAR2
1527 , p8_a20 in out nocopy VARCHAR2
1528 , p8_a21 in out nocopy VARCHAR2
1529 , p8_a22 in out nocopy VARCHAR2
1530 , p8_a23 in out nocopy VARCHAR2
1531 , p8_a24 in out nocopy VARCHAR2
1532 , p8_a25 in out nocopy VARCHAR2
1533 , p8_a26 in out nocopy VARCHAR2
1534 , p8_a27 in out nocopy VARCHAR2
1535 , p8_a28 in out nocopy VARCHAR2
1536 , p8_a29 in out nocopy VARCHAR2
1537 )
1538
1539 as
1540 ddp_x_fct_assoc_rec ahl_ra_setups_pvt.ra_fct_assoc_rec_type;
1541 ddindx binary_integer; indx binary_integer;
1542 begin
1543
1544 -- copy data to the local IN or IN-OUT args, if any
1545
1546
1547
1548
1549
1550
1551
1552
1553 ddp_x_fct_assoc_rec.ra_fct_association_id := p8_a0;
1554 ddp_x_fct_assoc_rec.forecast_designator := p8_a1;
1555 ddp_x_fct_assoc_rec.association_type_code := p8_a2;
1556 ddp_x_fct_assoc_rec.organization_id := p8_a3;
1557 ddp_x_fct_assoc_rec.probability_from := p8_a4;
1558 ddp_x_fct_assoc_rec.probability_to := p8_a5;
1559 ddp_x_fct_assoc_rec.operation_flag := p8_a6;
1560 ddp_x_fct_assoc_rec.object_version_number := p8_a7;
1561 ddp_x_fct_assoc_rec.security_group_id := p8_a8;
1562 ddp_x_fct_assoc_rec.creation_date := p8_a9;
1563 ddp_x_fct_assoc_rec.created_by := p8_a10;
1564 ddp_x_fct_assoc_rec.last_update_date := p8_a11;
1565 ddp_x_fct_assoc_rec.last_updated_by := p8_a12;
1566 ddp_x_fct_assoc_rec.last_update_login := p8_a13;
1567 ddp_x_fct_assoc_rec.attribute_category := p8_a14;
1568 ddp_x_fct_assoc_rec.attribute1 := p8_a15;
1569 ddp_x_fct_assoc_rec.attribute2 := p8_a16;
1570 ddp_x_fct_assoc_rec.attribute3 := p8_a17;
1571 ddp_x_fct_assoc_rec.attribute4 := p8_a18;
1572 ddp_x_fct_assoc_rec.attribute5 := p8_a19;
1573 ddp_x_fct_assoc_rec.attribute6 := p8_a20;
1574 ddp_x_fct_assoc_rec.attribute7 := p8_a21;
1575 ddp_x_fct_assoc_rec.attribute8 := p8_a22;
1576 ddp_x_fct_assoc_rec.attribute9 := p8_a23;
1577 ddp_x_fct_assoc_rec.attribute10 := p8_a24;
1578 ddp_x_fct_assoc_rec.attribute11 := p8_a25;
1579 ddp_x_fct_assoc_rec.attribute12 := p8_a26;
1580 ddp_x_fct_assoc_rec.attribute13 := p8_a27;
1581 ddp_x_fct_assoc_rec.attribute14 := p8_a28;
1582 ddp_x_fct_assoc_rec.attribute15 := p8_a29;
1583
1584 -- here's the delegated call to the old PL/SQL routine
1585 ahl_ra_setups_pvt.update_fct_assoc_data(p_api_version,
1586 p_init_msg_list,
1587 p_commit,
1588 p_validation_level,
1589 p_module_type,
1590 x_return_status,
1591 x_msg_count,
1592 x_msg_data,
1593 ddp_x_fct_assoc_rec);
1594
1595 -- copy data back from the local variables to OUT or IN-OUT args, if any
1596
1597
1598
1599
1600
1601
1602
1603
1604 p8_a0 := ddp_x_fct_assoc_rec.ra_fct_association_id;
1605 p8_a1 := ddp_x_fct_assoc_rec.forecast_designator;
1606 p8_a2 := ddp_x_fct_assoc_rec.association_type_code;
1607 p8_a3 := ddp_x_fct_assoc_rec.organization_id;
1608 p8_a4 := ddp_x_fct_assoc_rec.probability_from;
1609 p8_a5 := ddp_x_fct_assoc_rec.probability_to;
1610 p8_a6 := ddp_x_fct_assoc_rec.operation_flag;
1611 p8_a7 := ddp_x_fct_assoc_rec.object_version_number;
1612 p8_a8 := ddp_x_fct_assoc_rec.security_group_id;
1613 p8_a9 := ddp_x_fct_assoc_rec.creation_date;
1614 p8_a10 := ddp_x_fct_assoc_rec.created_by;
1615 p8_a11 := ddp_x_fct_assoc_rec.last_update_date;
1616 p8_a12 := ddp_x_fct_assoc_rec.last_updated_by;
1617 p8_a13 := ddp_x_fct_assoc_rec.last_update_login;
1618 p8_a14 := ddp_x_fct_assoc_rec.attribute_category;
1619 p8_a15 := ddp_x_fct_assoc_rec.attribute1;
1620 p8_a16 := ddp_x_fct_assoc_rec.attribute2;
1621 p8_a17 := ddp_x_fct_assoc_rec.attribute3;
1622 p8_a18 := ddp_x_fct_assoc_rec.attribute4;
1623 p8_a19 := ddp_x_fct_assoc_rec.attribute5;
1624 p8_a20 := ddp_x_fct_assoc_rec.attribute6;
1625 p8_a21 := ddp_x_fct_assoc_rec.attribute7;
1626 p8_a22 := ddp_x_fct_assoc_rec.attribute8;
1627 p8_a23 := ddp_x_fct_assoc_rec.attribute9;
1628 p8_a24 := ddp_x_fct_assoc_rec.attribute10;
1629 p8_a25 := ddp_x_fct_assoc_rec.attribute11;
1630 p8_a26 := ddp_x_fct_assoc_rec.attribute12;
1631 p8_a27 := ddp_x_fct_assoc_rec.attribute13;
1632 p8_a28 := ddp_x_fct_assoc_rec.attribute14;
1633 p8_a29 := ddp_x_fct_assoc_rec.attribute15;
1634 end;
1635
1636 procedure delete_fct_assoc_data(p_api_version NUMBER
1637 , p_init_msg_list VARCHAR2
1638 , p_commit VARCHAR2
1639 , p_validation_level NUMBER
1640 , p_module_type VARCHAR2
1641 , x_return_status out nocopy VARCHAR2
1642 , x_msg_count out nocopy NUMBER
1643 , x_msg_data out nocopy VARCHAR2
1644 , p8_a0 NUMBER
1645 , p8_a1 VARCHAR2
1646 , p8_a2 VARCHAR2
1647 , p8_a3 NUMBER
1648 , p8_a4 NUMBER
1649 , p8_a5 NUMBER
1650 , p8_a6 VARCHAR2
1651 , p8_a7 NUMBER
1652 , p8_a8 NUMBER
1653 , p8_a9 DATE
1654 , p8_a10 NUMBER
1655 , p8_a11 DATE
1656 , p8_a12 NUMBER
1657 , p8_a13 NUMBER
1658 , p8_a14 VARCHAR2
1659 , p8_a15 VARCHAR2
1660 , p8_a16 VARCHAR2
1661 , p8_a17 VARCHAR2
1662 , p8_a18 VARCHAR2
1663 , p8_a19 VARCHAR2
1664 , p8_a20 VARCHAR2
1665 , p8_a21 VARCHAR2
1666 , p8_a22 VARCHAR2
1667 , p8_a23 VARCHAR2
1668 , p8_a24 VARCHAR2
1669 , p8_a25 VARCHAR2
1670 , p8_a26 VARCHAR2
1671 , p8_a27 VARCHAR2
1672 , p8_a28 VARCHAR2
1673 , p8_a29 VARCHAR2
1674 )
1675
1676 as
1677 ddp_fct_assoc_rec ahl_ra_setups_pvt.ra_fct_assoc_rec_type;
1678 ddindx binary_integer; indx binary_integer;
1679 begin
1680
1681 -- copy data to the local IN or IN-OUT args, if any
1682
1683
1684
1685
1686
1687
1688
1689
1690 ddp_fct_assoc_rec.ra_fct_association_id := p8_a0;
1691 ddp_fct_assoc_rec.forecast_designator := p8_a1;
1692 ddp_fct_assoc_rec.association_type_code := p8_a2;
1693 ddp_fct_assoc_rec.organization_id := p8_a3;
1694 ddp_fct_assoc_rec.probability_from := p8_a4;
1695 ddp_fct_assoc_rec.probability_to := p8_a5;
1696 ddp_fct_assoc_rec.operation_flag := p8_a6;
1697 ddp_fct_assoc_rec.object_version_number := p8_a7;
1698 ddp_fct_assoc_rec.security_group_id := p8_a8;
1699 ddp_fct_assoc_rec.creation_date := p8_a9;
1700 ddp_fct_assoc_rec.created_by := p8_a10;
1701 ddp_fct_assoc_rec.last_update_date := p8_a11;
1702 ddp_fct_assoc_rec.last_updated_by := p8_a12;
1703 ddp_fct_assoc_rec.last_update_login := p8_a13;
1704 ddp_fct_assoc_rec.attribute_category := p8_a14;
1705 ddp_fct_assoc_rec.attribute1 := p8_a15;
1706 ddp_fct_assoc_rec.attribute2 := p8_a16;
1707 ddp_fct_assoc_rec.attribute3 := p8_a17;
1708 ddp_fct_assoc_rec.attribute4 := p8_a18;
1709 ddp_fct_assoc_rec.attribute5 := p8_a19;
1710 ddp_fct_assoc_rec.attribute6 := p8_a20;
1711 ddp_fct_assoc_rec.attribute7 := p8_a21;
1712 ddp_fct_assoc_rec.attribute8 := p8_a22;
1713 ddp_fct_assoc_rec.attribute9 := p8_a23;
1714 ddp_fct_assoc_rec.attribute10 := p8_a24;
1715 ddp_fct_assoc_rec.attribute11 := p8_a25;
1716 ddp_fct_assoc_rec.attribute12 := p8_a26;
1717 ddp_fct_assoc_rec.attribute13 := p8_a27;
1718 ddp_fct_assoc_rec.attribute14 := p8_a28;
1719 ddp_fct_assoc_rec.attribute15 := p8_a29;
1720
1721 -- here's the delegated call to the old PL/SQL routine
1722 ahl_ra_setups_pvt.delete_fct_assoc_data(p_api_version,
1723 p_init_msg_list,
1724 p_commit,
1725 p_validation_level,
1726 p_module_type,
1727 x_return_status,
1728 x_msg_count,
1729 x_msg_data,
1730 ddp_fct_assoc_rec);
1731
1732 -- copy data back from the local variables to OUT or IN-OUT args, if any
1733
1734
1735
1736
1737
1738
1739
1740
1741 end;
1742
1743 end ahl_ra_setups_pvt_w;