[Home] [Help]
PACKAGE BODY: APPS.OKL_AM_CONSOLIDATED_QTE_PUB_W
Source
1 package body okl_am_consolidated_qte_pub_w as
2 /* $Header: OKLUCNQB.pls 120.2 2007/11/02 21:05:49 rmunjulu 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
6 -- this is to workaround the JDBC bug regarding IN DATE of value GMiss
7 function rosetta_g_miss_date_in_map(d date) return date as
8 begin
9 if d = rosetta_g_mistake_date then return fnd_api.g_miss_date; end if;
10 return d;
11 end;
12
13 function rosetta_g_miss_num_map(n number) return number as
14 a number := fnd_api.g_miss_num;
15 b number := 0-1962.0724;
16 begin
17 if n=a then return b; end if;
18 if n=b then return a; end if;
19 return n;
20 end;
21
22 procedure create_consolidate_quote(p_api_version NUMBER
23 , p_init_msg_list VARCHAR2
24 , x_return_status out nocopy VARCHAR2
25 , x_msg_count out nocopy NUMBER
26 , x_msg_data out nocopy VARCHAR2
27 , p5_a0 JTF_NUMBER_TABLE
28 , p5_a1 JTF_NUMBER_TABLE
29 , p5_a2 JTF_VARCHAR2_TABLE_100
30 , p5_a3 JTF_VARCHAR2_TABLE_100
31 , p5_a4 JTF_VARCHAR2_TABLE_100
32 , p5_a5 JTF_VARCHAR2_TABLE_100
33 , p5_a6 JTF_VARCHAR2_TABLE_100
34 , p5_a7 JTF_VARCHAR2_TABLE_100
35 , p5_a8 JTF_VARCHAR2_TABLE_100
36 , p5_a9 JTF_NUMBER_TABLE
37 , p5_a10 JTF_NUMBER_TABLE
38 , p5_a11 JTF_NUMBER_TABLE
39 , p5_a12 JTF_NUMBER_TABLE
40 , p5_a13 JTF_VARCHAR2_TABLE_100
41 , p5_a14 JTF_VARCHAR2_TABLE_100
42 , p5_a15 JTF_VARCHAR2_TABLE_100
43 , p5_a16 JTF_DATE_TABLE
44 , p5_a17 JTF_DATE_TABLE
45 , p5_a18 JTF_DATE_TABLE
46 , p5_a19 JTF_DATE_TABLE
47 , p5_a20 JTF_VARCHAR2_TABLE_100
48 , p5_a21 JTF_VARCHAR2_TABLE_100
49 , p5_a22 JTF_NUMBER_TABLE
50 , p5_a23 JTF_NUMBER_TABLE
51 , p5_a24 JTF_NUMBER_TABLE
52 , p5_a25 JTF_NUMBER_TABLE
53 , p5_a26 JTF_DATE_TABLE
54 , p5_a27 JTF_DATE_TABLE
55 , p5_a28 JTF_NUMBER_TABLE
56 , p5_a29 JTF_NUMBER_TABLE
57 , p5_a30 JTF_VARCHAR2_TABLE_2000
58 , p5_a31 JTF_DATE_TABLE
59 , p5_a32 JTF_VARCHAR2_TABLE_100
60 , p5_a33 JTF_NUMBER_TABLE
61 , p5_a34 JTF_DATE_TABLE
62 , p5_a35 JTF_NUMBER_TABLE
63 , p5_a36 JTF_NUMBER_TABLE
64 , p5_a37 JTF_VARCHAR2_TABLE_100
65 , p5_a38 JTF_VARCHAR2_TABLE_100
66 , p5_a39 JTF_VARCHAR2_TABLE_100
67 , p5_a40 JTF_DATE_TABLE
68 , p5_a41 JTF_VARCHAR2_TABLE_100
69 , p5_a42 JTF_VARCHAR2_TABLE_500
70 , p5_a43 JTF_VARCHAR2_TABLE_500
71 , p5_a44 JTF_VARCHAR2_TABLE_500
72 , p5_a45 JTF_VARCHAR2_TABLE_500
73 , p5_a46 JTF_VARCHAR2_TABLE_500
74 , p5_a47 JTF_VARCHAR2_TABLE_500
75 , p5_a48 JTF_VARCHAR2_TABLE_500
76 , p5_a49 JTF_VARCHAR2_TABLE_500
77 , p5_a50 JTF_VARCHAR2_TABLE_500
78 , p5_a51 JTF_VARCHAR2_TABLE_500
79 , p5_a52 JTF_VARCHAR2_TABLE_500
80 , p5_a53 JTF_VARCHAR2_TABLE_500
81 , p5_a54 JTF_VARCHAR2_TABLE_500
82 , p5_a55 JTF_VARCHAR2_TABLE_500
83 , p5_a56 JTF_VARCHAR2_TABLE_500
84 , p5_a57 JTF_DATE_TABLE
85 , p5_a58 JTF_NUMBER_TABLE
86 , p5_a59 JTF_NUMBER_TABLE
87 , p5_a60 JTF_NUMBER_TABLE
88 , p5_a61 JTF_NUMBER_TABLE
89 , p5_a62 JTF_NUMBER_TABLE
90 , p5_a63 JTF_DATE_TABLE
91 , p5_a64 JTF_NUMBER_TABLE
92 , p5_a65 JTF_DATE_TABLE
93 , p5_a66 JTF_NUMBER_TABLE
94 , p5_a67 JTF_DATE_TABLE
95 , p5_a68 JTF_NUMBER_TABLE
96 , p5_a69 JTF_NUMBER_TABLE
97 , p5_a70 JTF_VARCHAR2_TABLE_200
98 , p5_a71 JTF_NUMBER_TABLE
99 , p5_a72 JTF_NUMBER_TABLE
100 , p5_a73 JTF_NUMBER_TABLE
101 , p5_a74 JTF_NUMBER_TABLE
102 , p5_a75 JTF_NUMBER_TABLE
103 , p5_a76 JTF_VARCHAR2_TABLE_100
104 , p5_a77 JTF_VARCHAR2_TABLE_100
105 , p5_a78 JTF_VARCHAR2_TABLE_100
106 , p5_a79 JTF_NUMBER_TABLE
107 , p5_a80 JTF_DATE_TABLE
108 , p5_a81 JTF_NUMBER_TABLE
109 , p5_a82 JTF_VARCHAR2_TABLE_100
110 , p6_a0 out nocopy NUMBER
111 , p6_a1 out nocopy NUMBER
112 , p6_a2 out nocopy VARCHAR2
113 , p6_a3 out nocopy VARCHAR2
114 , p6_a4 out nocopy VARCHAR2
115 , p6_a5 out nocopy VARCHAR2
116 , p6_a6 out nocopy VARCHAR2
117 , p6_a7 out nocopy VARCHAR2
118 , p6_a8 out nocopy VARCHAR2
119 , p6_a9 out nocopy NUMBER
120 , p6_a10 out nocopy NUMBER
121 , p6_a11 out nocopy NUMBER
122 , p6_a12 out nocopy NUMBER
123 , p6_a13 out nocopy VARCHAR2
124 , p6_a14 out nocopy VARCHAR2
125 , p6_a15 out nocopy VARCHAR2
126 , p6_a16 out nocopy DATE
127 , p6_a17 out nocopy DATE
128 , p6_a18 out nocopy DATE
129 , p6_a19 out nocopy DATE
130 , p6_a20 out nocopy VARCHAR2
131 , p6_a21 out nocopy VARCHAR2
132 , p6_a22 out nocopy NUMBER
133 , p6_a23 out nocopy NUMBER
134 , p6_a24 out nocopy NUMBER
135 , p6_a25 out nocopy NUMBER
136 , p6_a26 out nocopy DATE
137 , p6_a27 out nocopy DATE
138 , p6_a28 out nocopy NUMBER
139 , p6_a29 out nocopy NUMBER
140 , p6_a30 out nocopy VARCHAR2
141 , p6_a31 out nocopy DATE
142 , p6_a32 out nocopy VARCHAR2
143 , p6_a33 out nocopy NUMBER
144 , p6_a34 out nocopy DATE
145 , p6_a35 out nocopy NUMBER
146 , p6_a36 out nocopy NUMBER
147 , p6_a37 out nocopy VARCHAR2
148 , p6_a38 out nocopy VARCHAR2
149 , p6_a39 out nocopy VARCHAR2
150 , p6_a40 out nocopy DATE
151 , p6_a41 out nocopy VARCHAR2
152 , p6_a42 out nocopy VARCHAR2
153 , p6_a43 out nocopy VARCHAR2
154 , p6_a44 out nocopy VARCHAR2
155 , p6_a45 out nocopy VARCHAR2
156 , p6_a46 out nocopy VARCHAR2
157 , p6_a47 out nocopy VARCHAR2
158 , p6_a48 out nocopy VARCHAR2
159 , p6_a49 out nocopy VARCHAR2
160 , p6_a50 out nocopy VARCHAR2
161 , p6_a51 out nocopy VARCHAR2
162 , p6_a52 out nocopy VARCHAR2
163 , p6_a53 out nocopy VARCHAR2
164 , p6_a54 out nocopy VARCHAR2
165 , p6_a55 out nocopy VARCHAR2
166 , p6_a56 out nocopy VARCHAR2
167 , p6_a57 out nocopy DATE
168 , p6_a58 out nocopy NUMBER
169 , p6_a59 out nocopy NUMBER
170 , p6_a60 out nocopy NUMBER
171 , p6_a61 out nocopy NUMBER
172 , p6_a62 out nocopy NUMBER
173 , p6_a63 out nocopy DATE
174 , p6_a64 out nocopy NUMBER
175 , p6_a65 out nocopy DATE
176 , p6_a66 out nocopy NUMBER
177 , p6_a67 out nocopy DATE
178 , p6_a68 out nocopy NUMBER
179 , p6_a69 out nocopy NUMBER
180 , p6_a70 out nocopy VARCHAR2
181 , p6_a71 out nocopy NUMBER
182 , p6_a72 out nocopy NUMBER
183 , p6_a73 out nocopy NUMBER
184 , p6_a74 out nocopy NUMBER
185 , p6_a75 out nocopy NUMBER
186 , p6_a76 out nocopy VARCHAR2
187 , p6_a77 out nocopy VARCHAR2
188 , p6_a78 out nocopy VARCHAR2
189 , p6_a79 out nocopy NUMBER
190 , p6_a80 out nocopy DATE
191 , p6_a81 out nocopy NUMBER
192 , p6_a82 out nocopy VARCHAR2
193 )
194
195 as
196 ddp_qtev_tbl okl_am_consolidated_qte_pub.qtev_tbl_type;
197 ddx_cons_rec okl_am_consolidated_qte_pub.qtev_rec_type;
198 ddindx binary_integer; indx binary_integer;
199 begin
200
201 -- copy data to the local IN or IN-OUT args, if any
202
203
204
205
206
207 okl_qte_pvt_w.rosetta_table_copy_in_p8(ddp_qtev_tbl, p5_a0
208 , p5_a1
209 , p5_a2
210 , p5_a3
211 , p5_a4
212 , p5_a5
213 , p5_a6
214 , p5_a7
215 , p5_a8
216 , p5_a9
217 , p5_a10
218 , p5_a11
219 , p5_a12
220 , p5_a13
221 , p5_a14
222 , p5_a15
223 , p5_a16
224 , p5_a17
225 , p5_a18
226 , p5_a19
227 , p5_a20
228 , p5_a21
229 , p5_a22
230 , p5_a23
231 , p5_a24
232 , p5_a25
233 , p5_a26
234 , p5_a27
235 , p5_a28
236 , p5_a29
237 , p5_a30
238 , p5_a31
239 , p5_a32
240 , p5_a33
241 , p5_a34
242 , p5_a35
243 , p5_a36
244 , p5_a37
245 , p5_a38
246 , p5_a39
247 , p5_a40
248 , p5_a41
249 , p5_a42
250 , p5_a43
251 , p5_a44
252 , p5_a45
253 , p5_a46
254 , p5_a47
255 , p5_a48
256 , p5_a49
257 , p5_a50
258 , p5_a51
259 , p5_a52
260 , p5_a53
261 , p5_a54
262 , p5_a55
263 , p5_a56
264 , p5_a57
265 , p5_a58
266 , p5_a59
267 , p5_a60
268 , p5_a61
269 , p5_a62
270 , p5_a63
271 , p5_a64
272 , p5_a65
273 , p5_a66
274 , p5_a67
275 , p5_a68
276 , p5_a69
277 , p5_a70
278 , p5_a71
279 , p5_a72
280 , p5_a73
281 , p5_a74
282 , p5_a75
283 , p5_a76
284 , p5_a77
285 , p5_a78
286 , p5_a79
287 , p5_a80
288 , p5_a81
289 , p5_a82
290 );
291
292
293 -- here's the delegated call to the old PL/SQL routine
294 okl_am_consolidated_qte_pub.create_consolidate_quote(p_api_version,
295 p_init_msg_list,
296 x_return_status,
297 x_msg_count,
298 x_msg_data,
299 ddp_qtev_tbl,
300 ddx_cons_rec);
301
302 -- copy data back from the local variables to OUT or IN-OUT args, if any
303
304
305
306
307
308
309 p6_a0 := rosetta_g_miss_num_map(ddx_cons_rec.id);
310 p6_a1 := rosetta_g_miss_num_map(ddx_cons_rec.object_version_number);
311 p6_a2 := ddx_cons_rec.sfwt_flag;
312 p6_a3 := ddx_cons_rec.qrs_code;
313 p6_a4 := ddx_cons_rec.qst_code;
314 p6_a5 := ddx_cons_rec.qtp_code;
315 p6_a6 := ddx_cons_rec.trn_code;
316 p6_a7 := ddx_cons_rec.pop_code_end;
317 p6_a8 := ddx_cons_rec.pop_code_early;
318 p6_a9 := rosetta_g_miss_num_map(ddx_cons_rec.consolidated_qte_id);
319 p6_a10 := rosetta_g_miss_num_map(ddx_cons_rec.khr_id);
320 p6_a11 := rosetta_g_miss_num_map(ddx_cons_rec.art_id);
321 p6_a12 := rosetta_g_miss_num_map(ddx_cons_rec.pdt_id);
322 p6_a13 := ddx_cons_rec.early_termination_yn;
323 p6_a14 := ddx_cons_rec.partial_yn;
324 p6_a15 := ddx_cons_rec.preproceeds_yn;
325 p6_a16 := ddx_cons_rec.date_requested;
326 p6_a17 := ddx_cons_rec.date_proposal;
327 p6_a18 := ddx_cons_rec.date_effective_to;
328 p6_a19 := ddx_cons_rec.date_accepted;
329 p6_a20 := ddx_cons_rec.summary_format_yn;
330 p6_a21 := ddx_cons_rec.consolidated_yn;
331 p6_a22 := rosetta_g_miss_num_map(ddx_cons_rec.principal_paydown_amount);
332 p6_a23 := rosetta_g_miss_num_map(ddx_cons_rec.residual_amount);
333 p6_a24 := rosetta_g_miss_num_map(ddx_cons_rec.yield);
334 p6_a25 := rosetta_g_miss_num_map(ddx_cons_rec.rent_amount);
335 p6_a26 := ddx_cons_rec.date_restructure_end;
336 p6_a27 := ddx_cons_rec.date_restructure_start;
337 p6_a28 := rosetta_g_miss_num_map(ddx_cons_rec.term);
338 p6_a29 := rosetta_g_miss_num_map(ddx_cons_rec.purchase_percent);
339 p6_a30 := ddx_cons_rec.comments;
340 p6_a31 := ddx_cons_rec.date_due;
341 p6_a32 := ddx_cons_rec.payment_frequency;
342 p6_a33 := rosetta_g_miss_num_map(ddx_cons_rec.remaining_payments);
343 p6_a34 := ddx_cons_rec.date_effective_from;
344 p6_a35 := rosetta_g_miss_num_map(ddx_cons_rec.quote_number);
345 p6_a36 := rosetta_g_miss_num_map(ddx_cons_rec.requested_by);
346 p6_a37 := ddx_cons_rec.approved_yn;
347 p6_a38 := ddx_cons_rec.accepted_yn;
348 p6_a39 := ddx_cons_rec.payment_received_yn;
349 p6_a40 := ddx_cons_rec.date_payment_received;
350 p6_a41 := ddx_cons_rec.attribute_category;
351 p6_a42 := ddx_cons_rec.attribute1;
352 p6_a43 := ddx_cons_rec.attribute2;
353 p6_a44 := ddx_cons_rec.attribute3;
354 p6_a45 := ddx_cons_rec.attribute4;
355 p6_a46 := ddx_cons_rec.attribute5;
356 p6_a47 := ddx_cons_rec.attribute6;
357 p6_a48 := ddx_cons_rec.attribute7;
358 p6_a49 := ddx_cons_rec.attribute8;
359 p6_a50 := ddx_cons_rec.attribute9;
360 p6_a51 := ddx_cons_rec.attribute10;
361 p6_a52 := ddx_cons_rec.attribute11;
362 p6_a53 := ddx_cons_rec.attribute12;
363 p6_a54 := ddx_cons_rec.attribute13;
364 p6_a55 := ddx_cons_rec.attribute14;
365 p6_a56 := ddx_cons_rec.attribute15;
366 p6_a57 := ddx_cons_rec.date_approved;
367 p6_a58 := rosetta_g_miss_num_map(ddx_cons_rec.approved_by);
368 p6_a59 := rosetta_g_miss_num_map(ddx_cons_rec.org_id);
369 p6_a60 := rosetta_g_miss_num_map(ddx_cons_rec.request_id);
370 p6_a61 := rosetta_g_miss_num_map(ddx_cons_rec.program_application_id);
371 p6_a62 := rosetta_g_miss_num_map(ddx_cons_rec.program_id);
372 p6_a63 := ddx_cons_rec.program_update_date;
373 p6_a64 := rosetta_g_miss_num_map(ddx_cons_rec.created_by);
374 p6_a65 := ddx_cons_rec.creation_date;
375 p6_a66 := rosetta_g_miss_num_map(ddx_cons_rec.last_updated_by);
376 p6_a67 := ddx_cons_rec.last_update_date;
377 p6_a68 := rosetta_g_miss_num_map(ddx_cons_rec.last_update_login);
378 p6_a69 := rosetta_g_miss_num_map(ddx_cons_rec.purchase_amount);
379 p6_a70 := ddx_cons_rec.purchase_formula;
380 p6_a71 := rosetta_g_miss_num_map(ddx_cons_rec.asset_value);
381 p6_a72 := rosetta_g_miss_num_map(ddx_cons_rec.residual_value);
382 p6_a73 := rosetta_g_miss_num_map(ddx_cons_rec.unbilled_receivables);
383 p6_a74 := rosetta_g_miss_num_map(ddx_cons_rec.gain_loss);
384 p6_a75 := rosetta_g_miss_num_map(ddx_cons_rec.perdiem_amount);
385 p6_a76 := ddx_cons_rec.currency_code;
386 p6_a77 := ddx_cons_rec.currency_conversion_code;
387 p6_a78 := ddx_cons_rec.currency_conversion_type;
388 p6_a79 := rosetta_g_miss_num_map(ddx_cons_rec.currency_conversion_rate);
389 p6_a80 := ddx_cons_rec.currency_conversion_date;
390 p6_a81 := rosetta_g_miss_num_map(ddx_cons_rec.legal_entity_id);
391 p6_a82 := ddx_cons_rec.repo_quote_indicator_yn;
392 end;
393
394 procedure update_consolidate_quote(p_api_version NUMBER
395 , p_init_msg_list VARCHAR2
396 , x_return_status out nocopy VARCHAR2
397 , x_msg_count out nocopy NUMBER
398 , x_msg_data out nocopy VARCHAR2
399 , p6_a0 out nocopy NUMBER
400 , p6_a1 out nocopy NUMBER
401 , p6_a2 out nocopy VARCHAR2
402 , p6_a3 out nocopy VARCHAR2
403 , p6_a4 out nocopy VARCHAR2
404 , p6_a5 out nocopy VARCHAR2
405 , p6_a6 out nocopy VARCHAR2
406 , p6_a7 out nocopy VARCHAR2
407 , p6_a8 out nocopy VARCHAR2
408 , p6_a9 out nocopy NUMBER
409 , p6_a10 out nocopy NUMBER
410 , p6_a11 out nocopy NUMBER
411 , p6_a12 out nocopy NUMBER
412 , p6_a13 out nocopy VARCHAR2
413 , p6_a14 out nocopy VARCHAR2
414 , p6_a15 out nocopy VARCHAR2
415 , p6_a16 out nocopy DATE
416 , p6_a17 out nocopy DATE
417 , p6_a18 out nocopy DATE
418 , p6_a19 out nocopy DATE
419 , p6_a20 out nocopy VARCHAR2
420 , p6_a21 out nocopy VARCHAR2
421 , p6_a22 out nocopy NUMBER
422 , p6_a23 out nocopy NUMBER
423 , p6_a24 out nocopy NUMBER
424 , p6_a25 out nocopy NUMBER
425 , p6_a26 out nocopy DATE
426 , p6_a27 out nocopy DATE
427 , p6_a28 out nocopy NUMBER
428 , p6_a29 out nocopy NUMBER
429 , p6_a30 out nocopy VARCHAR2
430 , p6_a31 out nocopy DATE
431 , p6_a32 out nocopy VARCHAR2
432 , p6_a33 out nocopy NUMBER
433 , p6_a34 out nocopy DATE
434 , p6_a35 out nocopy NUMBER
435 , p6_a36 out nocopy NUMBER
436 , p6_a37 out nocopy VARCHAR2
437 , p6_a38 out nocopy VARCHAR2
438 , p6_a39 out nocopy VARCHAR2
439 , p6_a40 out nocopy DATE
440 , p6_a41 out nocopy VARCHAR2
441 , p6_a42 out nocopy VARCHAR2
442 , p6_a43 out nocopy VARCHAR2
443 , p6_a44 out nocopy VARCHAR2
444 , p6_a45 out nocopy VARCHAR2
445 , p6_a46 out nocopy VARCHAR2
446 , p6_a47 out nocopy VARCHAR2
447 , p6_a48 out nocopy VARCHAR2
448 , p6_a49 out nocopy VARCHAR2
449 , p6_a50 out nocopy VARCHAR2
450 , p6_a51 out nocopy VARCHAR2
451 , p6_a52 out nocopy VARCHAR2
452 , p6_a53 out nocopy VARCHAR2
453 , p6_a54 out nocopy VARCHAR2
454 , p6_a55 out nocopy VARCHAR2
455 , p6_a56 out nocopy VARCHAR2
456 , p6_a57 out nocopy DATE
457 , p6_a58 out nocopy NUMBER
458 , p6_a59 out nocopy NUMBER
459 , p6_a60 out nocopy NUMBER
460 , p6_a61 out nocopy NUMBER
461 , p6_a62 out nocopy NUMBER
462 , p6_a63 out nocopy DATE
463 , p6_a64 out nocopy NUMBER
464 , p6_a65 out nocopy DATE
465 , p6_a66 out nocopy NUMBER
466 , p6_a67 out nocopy DATE
467 , p6_a68 out nocopy NUMBER
468 , p6_a69 out nocopy NUMBER
469 , p6_a70 out nocopy VARCHAR2
470 , p6_a71 out nocopy NUMBER
471 , p6_a72 out nocopy NUMBER
472 , p6_a73 out nocopy NUMBER
473 , p6_a74 out nocopy NUMBER
474 , p6_a75 out nocopy NUMBER
475 , p6_a76 out nocopy VARCHAR2
476 , p6_a77 out nocopy VARCHAR2
477 , p6_a78 out nocopy VARCHAR2
478 , p6_a79 out nocopy NUMBER
479 , p6_a80 out nocopy DATE
480 , p6_a81 out nocopy NUMBER
481 , p6_a82 out nocopy VARCHAR2
482 , p7_a0 out nocopy JTF_NUMBER_TABLE
483 , p7_a1 out nocopy JTF_NUMBER_TABLE
484 , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
485 , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
486 , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
487 , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
488 , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
489 , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
490 , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
491 , p7_a9 out nocopy JTF_NUMBER_TABLE
492 , p7_a10 out nocopy JTF_NUMBER_TABLE
493 , p7_a11 out nocopy JTF_NUMBER_TABLE
494 , p7_a12 out nocopy JTF_NUMBER_TABLE
495 , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
496 , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
497 , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
498 , p7_a16 out nocopy JTF_DATE_TABLE
499 , p7_a17 out nocopy JTF_DATE_TABLE
500 , p7_a18 out nocopy JTF_DATE_TABLE
501 , p7_a19 out nocopy JTF_DATE_TABLE
502 , p7_a20 out nocopy JTF_VARCHAR2_TABLE_100
503 , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
504 , p7_a22 out nocopy JTF_NUMBER_TABLE
505 , p7_a23 out nocopy JTF_NUMBER_TABLE
506 , p7_a24 out nocopy JTF_NUMBER_TABLE
507 , p7_a25 out nocopy JTF_NUMBER_TABLE
508 , p7_a26 out nocopy JTF_DATE_TABLE
509 , p7_a27 out nocopy JTF_DATE_TABLE
510 , p7_a28 out nocopy JTF_NUMBER_TABLE
511 , p7_a29 out nocopy JTF_NUMBER_TABLE
512 , p7_a30 out nocopy JTF_VARCHAR2_TABLE_2000
513 , p7_a31 out nocopy JTF_DATE_TABLE
514 , p7_a32 out nocopy JTF_VARCHAR2_TABLE_100
515 , p7_a33 out nocopy JTF_NUMBER_TABLE
516 , p7_a34 out nocopy JTF_DATE_TABLE
517 , p7_a35 out nocopy JTF_NUMBER_TABLE
518 , p7_a36 out nocopy JTF_NUMBER_TABLE
519 , p7_a37 out nocopy JTF_VARCHAR2_TABLE_100
520 , p7_a38 out nocopy JTF_VARCHAR2_TABLE_100
521 , p7_a39 out nocopy JTF_VARCHAR2_TABLE_100
522 , p7_a40 out nocopy JTF_DATE_TABLE
523 , p7_a41 out nocopy JTF_VARCHAR2_TABLE_100
524 , p7_a42 out nocopy JTF_VARCHAR2_TABLE_500
525 , p7_a43 out nocopy JTF_VARCHAR2_TABLE_500
526 , p7_a44 out nocopy JTF_VARCHAR2_TABLE_500
527 , p7_a45 out nocopy JTF_VARCHAR2_TABLE_500
528 , p7_a46 out nocopy JTF_VARCHAR2_TABLE_500
529 , p7_a47 out nocopy JTF_VARCHAR2_TABLE_500
530 , p7_a48 out nocopy JTF_VARCHAR2_TABLE_500
531 , p7_a49 out nocopy JTF_VARCHAR2_TABLE_500
532 , p7_a50 out nocopy JTF_VARCHAR2_TABLE_500
533 , p7_a51 out nocopy JTF_VARCHAR2_TABLE_500
534 , p7_a52 out nocopy JTF_VARCHAR2_TABLE_500
535 , p7_a53 out nocopy JTF_VARCHAR2_TABLE_500
536 , p7_a54 out nocopy JTF_VARCHAR2_TABLE_500
537 , p7_a55 out nocopy JTF_VARCHAR2_TABLE_500
538 , p7_a56 out nocopy JTF_VARCHAR2_TABLE_500
539 , p7_a57 out nocopy JTF_DATE_TABLE
540 , p7_a58 out nocopy JTF_NUMBER_TABLE
541 , p7_a59 out nocopy JTF_NUMBER_TABLE
542 , p7_a60 out nocopy JTF_NUMBER_TABLE
543 , p7_a61 out nocopy JTF_NUMBER_TABLE
544 , p7_a62 out nocopy JTF_NUMBER_TABLE
545 , p7_a63 out nocopy JTF_DATE_TABLE
546 , p7_a64 out nocopy JTF_NUMBER_TABLE
547 , p7_a65 out nocopy JTF_DATE_TABLE
548 , p7_a66 out nocopy JTF_NUMBER_TABLE
549 , p7_a67 out nocopy JTF_DATE_TABLE
550 , p7_a68 out nocopy JTF_NUMBER_TABLE
551 , p7_a69 out nocopy JTF_NUMBER_TABLE
552 , p7_a70 out nocopy JTF_VARCHAR2_TABLE_200
553 , p7_a71 out nocopy JTF_NUMBER_TABLE
554 , p7_a72 out nocopy JTF_NUMBER_TABLE
555 , p7_a73 out nocopy JTF_NUMBER_TABLE
556 , p7_a74 out nocopy JTF_NUMBER_TABLE
557 , p7_a75 out nocopy JTF_NUMBER_TABLE
558 , p7_a76 out nocopy JTF_VARCHAR2_TABLE_100
559 , p7_a77 out nocopy JTF_VARCHAR2_TABLE_100
560 , p7_a78 out nocopy JTF_VARCHAR2_TABLE_100
561 , p7_a79 out nocopy JTF_NUMBER_TABLE
562 , p7_a80 out nocopy JTF_DATE_TABLE
563 , p7_a81 out nocopy JTF_NUMBER_TABLE
564 , p7_a82 out nocopy JTF_VARCHAR2_TABLE_100
565 , p5_a0 NUMBER := 0-1962.0724
566 , p5_a1 NUMBER := 0-1962.0724
567 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
568 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
569 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
570 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
571 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
572 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
573 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
574 , p5_a9 NUMBER := 0-1962.0724
575 , p5_a10 NUMBER := 0-1962.0724
576 , p5_a11 NUMBER := 0-1962.0724
577 , p5_a12 NUMBER := 0-1962.0724
578 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
579 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
580 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
581 , p5_a16 DATE := fnd_api.g_miss_date
582 , p5_a17 DATE := fnd_api.g_miss_date
583 , p5_a18 DATE := fnd_api.g_miss_date
584 , p5_a19 DATE := fnd_api.g_miss_date
585 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
586 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
587 , p5_a22 NUMBER := 0-1962.0724
588 , p5_a23 NUMBER := 0-1962.0724
589 , p5_a24 NUMBER := 0-1962.0724
590 , p5_a25 NUMBER := 0-1962.0724
591 , p5_a26 DATE := fnd_api.g_miss_date
592 , p5_a27 DATE := fnd_api.g_miss_date
593 , p5_a28 NUMBER := 0-1962.0724
594 , p5_a29 NUMBER := 0-1962.0724
595 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
596 , p5_a31 DATE := fnd_api.g_miss_date
597 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
598 , p5_a33 NUMBER := 0-1962.0724
599 , p5_a34 DATE := fnd_api.g_miss_date
600 , p5_a35 NUMBER := 0-1962.0724
601 , p5_a36 NUMBER := 0-1962.0724
602 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
603 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
604 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
605 , p5_a40 DATE := fnd_api.g_miss_date
606 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
607 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
608 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
609 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
610 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
611 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
612 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
613 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
614 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
615 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
616 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
617 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
618 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
619 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
620 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
621 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
622 , p5_a57 DATE := fnd_api.g_miss_date
623 , p5_a58 NUMBER := 0-1962.0724
624 , p5_a59 NUMBER := 0-1962.0724
625 , p5_a60 NUMBER := 0-1962.0724
626 , p5_a61 NUMBER := 0-1962.0724
627 , p5_a62 NUMBER := 0-1962.0724
628 , p5_a63 DATE := fnd_api.g_miss_date
629 , p5_a64 NUMBER := 0-1962.0724
630 , p5_a65 DATE := fnd_api.g_miss_date
631 , p5_a66 NUMBER := 0-1962.0724
632 , p5_a67 DATE := fnd_api.g_miss_date
633 , p5_a68 NUMBER := 0-1962.0724
634 , p5_a69 NUMBER := 0-1962.0724
635 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
636 , p5_a71 NUMBER := 0-1962.0724
637 , p5_a72 NUMBER := 0-1962.0724
638 , p5_a73 NUMBER := 0-1962.0724
639 , p5_a74 NUMBER := 0-1962.0724
640 , p5_a75 NUMBER := 0-1962.0724
641 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
642 , p5_a77 VARCHAR2 := fnd_api.g_miss_char
643 , p5_a78 VARCHAR2 := fnd_api.g_miss_char
644 , p5_a79 NUMBER := 0-1962.0724
645 , p5_a80 DATE := fnd_api.g_miss_date
646 , p5_a81 NUMBER := 0-1962.0724
647 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
648 )
649
650 as
651 ddp_cons_rec okl_am_consolidated_qte_pub.qtev_rec_type;
652 ddx_cons_rec okl_am_consolidated_qte_pub.qtev_rec_type;
653 ddx_qtev_tbl okl_am_consolidated_qte_pub.qtev_tbl_type;
654 ddindx binary_integer; indx binary_integer;
655 begin
656
657 -- copy data to the local IN or IN-OUT args, if any
658
659
660
661
662
663 ddp_cons_rec.id := rosetta_g_miss_num_map(p5_a0);
664 ddp_cons_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
665 ddp_cons_rec.sfwt_flag := p5_a2;
666 ddp_cons_rec.qrs_code := p5_a3;
667 ddp_cons_rec.qst_code := p5_a4;
668 ddp_cons_rec.qtp_code := p5_a5;
669 ddp_cons_rec.trn_code := p5_a6;
670 ddp_cons_rec.pop_code_end := p5_a7;
671 ddp_cons_rec.pop_code_early := p5_a8;
672 ddp_cons_rec.consolidated_qte_id := rosetta_g_miss_num_map(p5_a9);
673 ddp_cons_rec.khr_id := rosetta_g_miss_num_map(p5_a10);
674 ddp_cons_rec.art_id := rosetta_g_miss_num_map(p5_a11);
675 ddp_cons_rec.pdt_id := rosetta_g_miss_num_map(p5_a12);
676 ddp_cons_rec.early_termination_yn := p5_a13;
677 ddp_cons_rec.partial_yn := p5_a14;
678 ddp_cons_rec.preproceeds_yn := p5_a15;
679 ddp_cons_rec.date_requested := rosetta_g_miss_date_in_map(p5_a16);
680 ddp_cons_rec.date_proposal := rosetta_g_miss_date_in_map(p5_a17);
681 ddp_cons_rec.date_effective_to := rosetta_g_miss_date_in_map(p5_a18);
682 ddp_cons_rec.date_accepted := rosetta_g_miss_date_in_map(p5_a19);
683 ddp_cons_rec.summary_format_yn := p5_a20;
684 ddp_cons_rec.consolidated_yn := p5_a21;
685 ddp_cons_rec.principal_paydown_amount := rosetta_g_miss_num_map(p5_a22);
686 ddp_cons_rec.residual_amount := rosetta_g_miss_num_map(p5_a23);
687 ddp_cons_rec.yield := rosetta_g_miss_num_map(p5_a24);
688 ddp_cons_rec.rent_amount := rosetta_g_miss_num_map(p5_a25);
689 ddp_cons_rec.date_restructure_end := rosetta_g_miss_date_in_map(p5_a26);
690 ddp_cons_rec.date_restructure_start := rosetta_g_miss_date_in_map(p5_a27);
691 ddp_cons_rec.term := rosetta_g_miss_num_map(p5_a28);
692 ddp_cons_rec.purchase_percent := rosetta_g_miss_num_map(p5_a29);
693 ddp_cons_rec.comments := p5_a30;
694 ddp_cons_rec.date_due := rosetta_g_miss_date_in_map(p5_a31);
695 ddp_cons_rec.payment_frequency := p5_a32;
696 ddp_cons_rec.remaining_payments := rosetta_g_miss_num_map(p5_a33);
697 ddp_cons_rec.date_effective_from := rosetta_g_miss_date_in_map(p5_a34);
698 ddp_cons_rec.quote_number := rosetta_g_miss_num_map(p5_a35);
699 ddp_cons_rec.requested_by := rosetta_g_miss_num_map(p5_a36);
700 ddp_cons_rec.approved_yn := p5_a37;
701 ddp_cons_rec.accepted_yn := p5_a38;
702 ddp_cons_rec.payment_received_yn := p5_a39;
703 ddp_cons_rec.date_payment_received := rosetta_g_miss_date_in_map(p5_a40);
704 ddp_cons_rec.attribute_category := p5_a41;
705 ddp_cons_rec.attribute1 := p5_a42;
706 ddp_cons_rec.attribute2 := p5_a43;
707 ddp_cons_rec.attribute3 := p5_a44;
708 ddp_cons_rec.attribute4 := p5_a45;
709 ddp_cons_rec.attribute5 := p5_a46;
710 ddp_cons_rec.attribute6 := p5_a47;
711 ddp_cons_rec.attribute7 := p5_a48;
712 ddp_cons_rec.attribute8 := p5_a49;
713 ddp_cons_rec.attribute9 := p5_a50;
714 ddp_cons_rec.attribute10 := p5_a51;
715 ddp_cons_rec.attribute11 := p5_a52;
716 ddp_cons_rec.attribute12 := p5_a53;
717 ddp_cons_rec.attribute13 := p5_a54;
718 ddp_cons_rec.attribute14 := p5_a55;
719 ddp_cons_rec.attribute15 := p5_a56;
720 ddp_cons_rec.date_approved := rosetta_g_miss_date_in_map(p5_a57);
721 ddp_cons_rec.approved_by := rosetta_g_miss_num_map(p5_a58);
722 ddp_cons_rec.org_id := rosetta_g_miss_num_map(p5_a59);
723 ddp_cons_rec.request_id := rosetta_g_miss_num_map(p5_a60);
724 ddp_cons_rec.program_application_id := rosetta_g_miss_num_map(p5_a61);
725 ddp_cons_rec.program_id := rosetta_g_miss_num_map(p5_a62);
726 ddp_cons_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a63);
727 ddp_cons_rec.created_by := rosetta_g_miss_num_map(p5_a64);
728 ddp_cons_rec.creation_date := rosetta_g_miss_date_in_map(p5_a65);
729 ddp_cons_rec.last_updated_by := rosetta_g_miss_num_map(p5_a66);
730 ddp_cons_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a67);
731 ddp_cons_rec.last_update_login := rosetta_g_miss_num_map(p5_a68);
732 ddp_cons_rec.purchase_amount := rosetta_g_miss_num_map(p5_a69);
733 ddp_cons_rec.purchase_formula := p5_a70;
734 ddp_cons_rec.asset_value := rosetta_g_miss_num_map(p5_a71);
735 ddp_cons_rec.residual_value := rosetta_g_miss_num_map(p5_a72);
736 ddp_cons_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a73);
737 ddp_cons_rec.gain_loss := rosetta_g_miss_num_map(p5_a74);
738 ddp_cons_rec.perdiem_amount := rosetta_g_miss_num_map(p5_a75);
739 ddp_cons_rec.currency_code := p5_a76;
740 ddp_cons_rec.currency_conversion_code := p5_a77;
741 ddp_cons_rec.currency_conversion_type := p5_a78;
742 ddp_cons_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a79);
743 ddp_cons_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a80);
744 ddp_cons_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
745 ddp_cons_rec.repo_quote_indicator_yn := p5_a82;
746
747
748
749 -- here's the delegated call to the old PL/SQL routine
750 okl_am_consolidated_qte_pub.update_consolidate_quote(p_api_version,
751 p_init_msg_list,
752 x_return_status,
753 x_msg_count,
754 x_msg_data,
755 ddp_cons_rec,
756 ddx_cons_rec,
757 ddx_qtev_tbl);
758
759 -- copy data back from the local variables to OUT or IN-OUT args, if any
760
761
762
763
764
765
766 p6_a0 := rosetta_g_miss_num_map(ddx_cons_rec.id);
767 p6_a1 := rosetta_g_miss_num_map(ddx_cons_rec.object_version_number);
768 p6_a2 := ddx_cons_rec.sfwt_flag;
769 p6_a3 := ddx_cons_rec.qrs_code;
770 p6_a4 := ddx_cons_rec.qst_code;
771 p6_a5 := ddx_cons_rec.qtp_code;
772 p6_a6 := ddx_cons_rec.trn_code;
773 p6_a7 := ddx_cons_rec.pop_code_end;
774 p6_a8 := ddx_cons_rec.pop_code_early;
775 p6_a9 := rosetta_g_miss_num_map(ddx_cons_rec.consolidated_qte_id);
776 p6_a10 := rosetta_g_miss_num_map(ddx_cons_rec.khr_id);
777 p6_a11 := rosetta_g_miss_num_map(ddx_cons_rec.art_id);
778 p6_a12 := rosetta_g_miss_num_map(ddx_cons_rec.pdt_id);
779 p6_a13 := ddx_cons_rec.early_termination_yn;
780 p6_a14 := ddx_cons_rec.partial_yn;
781 p6_a15 := ddx_cons_rec.preproceeds_yn;
782 p6_a16 := ddx_cons_rec.date_requested;
783 p6_a17 := ddx_cons_rec.date_proposal;
784 p6_a18 := ddx_cons_rec.date_effective_to;
785 p6_a19 := ddx_cons_rec.date_accepted;
786 p6_a20 := ddx_cons_rec.summary_format_yn;
787 p6_a21 := ddx_cons_rec.consolidated_yn;
788 p6_a22 := rosetta_g_miss_num_map(ddx_cons_rec.principal_paydown_amount);
789 p6_a23 := rosetta_g_miss_num_map(ddx_cons_rec.residual_amount);
790 p6_a24 := rosetta_g_miss_num_map(ddx_cons_rec.yield);
791 p6_a25 := rosetta_g_miss_num_map(ddx_cons_rec.rent_amount);
792 p6_a26 := ddx_cons_rec.date_restructure_end;
793 p6_a27 := ddx_cons_rec.date_restructure_start;
794 p6_a28 := rosetta_g_miss_num_map(ddx_cons_rec.term);
795 p6_a29 := rosetta_g_miss_num_map(ddx_cons_rec.purchase_percent);
796 p6_a30 := ddx_cons_rec.comments;
797 p6_a31 := ddx_cons_rec.date_due;
798 p6_a32 := ddx_cons_rec.payment_frequency;
799 p6_a33 := rosetta_g_miss_num_map(ddx_cons_rec.remaining_payments);
800 p6_a34 := ddx_cons_rec.date_effective_from;
801 p6_a35 := rosetta_g_miss_num_map(ddx_cons_rec.quote_number);
802 p6_a36 := rosetta_g_miss_num_map(ddx_cons_rec.requested_by);
803 p6_a37 := ddx_cons_rec.approved_yn;
804 p6_a38 := ddx_cons_rec.accepted_yn;
805 p6_a39 := ddx_cons_rec.payment_received_yn;
806 p6_a40 := ddx_cons_rec.date_payment_received;
807 p6_a41 := ddx_cons_rec.attribute_category;
808 p6_a42 := ddx_cons_rec.attribute1;
809 p6_a43 := ddx_cons_rec.attribute2;
810 p6_a44 := ddx_cons_rec.attribute3;
811 p6_a45 := ddx_cons_rec.attribute4;
812 p6_a46 := ddx_cons_rec.attribute5;
813 p6_a47 := ddx_cons_rec.attribute6;
814 p6_a48 := ddx_cons_rec.attribute7;
815 p6_a49 := ddx_cons_rec.attribute8;
816 p6_a50 := ddx_cons_rec.attribute9;
817 p6_a51 := ddx_cons_rec.attribute10;
818 p6_a52 := ddx_cons_rec.attribute11;
819 p6_a53 := ddx_cons_rec.attribute12;
820 p6_a54 := ddx_cons_rec.attribute13;
821 p6_a55 := ddx_cons_rec.attribute14;
822 p6_a56 := ddx_cons_rec.attribute15;
823 p6_a57 := ddx_cons_rec.date_approved;
824 p6_a58 := rosetta_g_miss_num_map(ddx_cons_rec.approved_by);
825 p6_a59 := rosetta_g_miss_num_map(ddx_cons_rec.org_id);
826 p6_a60 := rosetta_g_miss_num_map(ddx_cons_rec.request_id);
827 p6_a61 := rosetta_g_miss_num_map(ddx_cons_rec.program_application_id);
828 p6_a62 := rosetta_g_miss_num_map(ddx_cons_rec.program_id);
829 p6_a63 := ddx_cons_rec.program_update_date;
830 p6_a64 := rosetta_g_miss_num_map(ddx_cons_rec.created_by);
831 p6_a65 := ddx_cons_rec.creation_date;
832 p6_a66 := rosetta_g_miss_num_map(ddx_cons_rec.last_updated_by);
833 p6_a67 := ddx_cons_rec.last_update_date;
834 p6_a68 := rosetta_g_miss_num_map(ddx_cons_rec.last_update_login);
835 p6_a69 := rosetta_g_miss_num_map(ddx_cons_rec.purchase_amount);
836 p6_a70 := ddx_cons_rec.purchase_formula;
837 p6_a71 := rosetta_g_miss_num_map(ddx_cons_rec.asset_value);
838 p6_a72 := rosetta_g_miss_num_map(ddx_cons_rec.residual_value);
839 p6_a73 := rosetta_g_miss_num_map(ddx_cons_rec.unbilled_receivables);
840 p6_a74 := rosetta_g_miss_num_map(ddx_cons_rec.gain_loss);
841 p6_a75 := rosetta_g_miss_num_map(ddx_cons_rec.perdiem_amount);
842 p6_a76 := ddx_cons_rec.currency_code;
843 p6_a77 := ddx_cons_rec.currency_conversion_code;
844 p6_a78 := ddx_cons_rec.currency_conversion_type;
845 p6_a79 := rosetta_g_miss_num_map(ddx_cons_rec.currency_conversion_rate);
846 p6_a80 := ddx_cons_rec.currency_conversion_date;
847 p6_a81 := rosetta_g_miss_num_map(ddx_cons_rec.legal_entity_id);
848 p6_a82 := ddx_cons_rec.repo_quote_indicator_yn;
849
850 okl_qte_pvt_w.rosetta_table_copy_out_p8(ddx_qtev_tbl, p7_a0
851 , p7_a1
852 , p7_a2
853 , p7_a3
854 , p7_a4
855 , p7_a5
856 , p7_a6
857 , p7_a7
858 , p7_a8
859 , p7_a9
860 , p7_a10
861 , p7_a11
862 , p7_a12
863 , p7_a13
864 , p7_a14
865 , p7_a15
866 , p7_a16
867 , p7_a17
868 , p7_a18
869 , p7_a19
870 , p7_a20
871 , p7_a21
872 , p7_a22
873 , p7_a23
874 , p7_a24
875 , p7_a25
876 , p7_a26
877 , p7_a27
878 , p7_a28
879 , p7_a29
880 , p7_a30
881 , p7_a31
882 , p7_a32
883 , p7_a33
884 , p7_a34
885 , p7_a35
886 , p7_a36
887 , p7_a37
888 , p7_a38
889 , p7_a39
890 , p7_a40
891 , p7_a41
892 , p7_a42
893 , p7_a43
894 , p7_a44
895 , p7_a45
896 , p7_a46
897 , p7_a47
898 , p7_a48
899 , p7_a49
900 , p7_a50
901 , p7_a51
902 , p7_a52
903 , p7_a53
904 , p7_a54
905 , p7_a55
906 , p7_a56
907 , p7_a57
908 , p7_a58
909 , p7_a59
910 , p7_a60
911 , p7_a61
912 , p7_a62
913 , p7_a63
914 , p7_a64
915 , p7_a65
916 , p7_a66
917 , p7_a67
918 , p7_a68
919 , p7_a69
920 , p7_a70
921 , p7_a71
922 , p7_a72
923 , p7_a73
924 , p7_a74
925 , p7_a75
926 , p7_a76
927 , p7_a77
928 , p7_a78
929 , p7_a79
930 , p7_a80
931 , p7_a81
932 , p7_a82
933 );
934 end;
935
936 end okl_am_consolidated_qte_pub_w;