[Home] [Help]
PACKAGE BODY: APPS.OKL_TRX_QUOTES_PUB_W
Source
1 package body okl_trx_quotes_pub_w as
2 /* $Header: OKLUQTEB.pls 120.2 2007/11/02 21:03:05 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 insert_trx_quotes(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 JTF_NUMBER_TABLE
111 , p6_a1 out nocopy JTF_NUMBER_TABLE
112 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
113 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
114 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
115 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
116 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
117 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
118 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
119 , p6_a9 out nocopy JTF_NUMBER_TABLE
120 , p6_a10 out nocopy JTF_NUMBER_TABLE
121 , p6_a11 out nocopy JTF_NUMBER_TABLE
122 , p6_a12 out nocopy JTF_NUMBER_TABLE
123 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
124 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
125 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
126 , p6_a16 out nocopy JTF_DATE_TABLE
127 , p6_a17 out nocopy JTF_DATE_TABLE
128 , p6_a18 out nocopy JTF_DATE_TABLE
129 , p6_a19 out nocopy JTF_DATE_TABLE
130 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
131 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
132 , p6_a22 out nocopy JTF_NUMBER_TABLE
133 , p6_a23 out nocopy JTF_NUMBER_TABLE
134 , p6_a24 out nocopy JTF_NUMBER_TABLE
135 , p6_a25 out nocopy JTF_NUMBER_TABLE
136 , p6_a26 out nocopy JTF_DATE_TABLE
137 , p6_a27 out nocopy JTF_DATE_TABLE
138 , p6_a28 out nocopy JTF_NUMBER_TABLE
139 , p6_a29 out nocopy JTF_NUMBER_TABLE
140 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_2000
141 , p6_a31 out nocopy JTF_DATE_TABLE
142 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_100
143 , p6_a33 out nocopy JTF_NUMBER_TABLE
144 , p6_a34 out nocopy JTF_DATE_TABLE
145 , p6_a35 out nocopy JTF_NUMBER_TABLE
146 , p6_a36 out nocopy JTF_NUMBER_TABLE
147 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
148 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
149 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
150 , p6_a40 out nocopy JTF_DATE_TABLE
151 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
152 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
153 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
154 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
155 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
156 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
157 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
158 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
159 , p6_a49 out nocopy JTF_VARCHAR2_TABLE_500
160 , p6_a50 out nocopy JTF_VARCHAR2_TABLE_500
161 , p6_a51 out nocopy JTF_VARCHAR2_TABLE_500
162 , p6_a52 out nocopy JTF_VARCHAR2_TABLE_500
163 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_500
164 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_500
165 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_500
166 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_500
167 , p6_a57 out nocopy JTF_DATE_TABLE
168 , p6_a58 out nocopy JTF_NUMBER_TABLE
169 , p6_a59 out nocopy JTF_NUMBER_TABLE
170 , p6_a60 out nocopy JTF_NUMBER_TABLE
171 , p6_a61 out nocopy JTF_NUMBER_TABLE
172 , p6_a62 out nocopy JTF_NUMBER_TABLE
173 , p6_a63 out nocopy JTF_DATE_TABLE
174 , p6_a64 out nocopy JTF_NUMBER_TABLE
175 , p6_a65 out nocopy JTF_DATE_TABLE
176 , p6_a66 out nocopy JTF_NUMBER_TABLE
177 , p6_a67 out nocopy JTF_DATE_TABLE
178 , p6_a68 out nocopy JTF_NUMBER_TABLE
179 , p6_a69 out nocopy JTF_NUMBER_TABLE
180 , p6_a70 out nocopy JTF_VARCHAR2_TABLE_200
181 , p6_a71 out nocopy JTF_NUMBER_TABLE
182 , p6_a72 out nocopy JTF_NUMBER_TABLE
183 , p6_a73 out nocopy JTF_NUMBER_TABLE
184 , p6_a74 out nocopy JTF_NUMBER_TABLE
185 , p6_a75 out nocopy JTF_NUMBER_TABLE
186 , p6_a76 out nocopy JTF_VARCHAR2_TABLE_100
187 , p6_a77 out nocopy JTF_VARCHAR2_TABLE_100
188 , p6_a78 out nocopy JTF_VARCHAR2_TABLE_100
189 , p6_a79 out nocopy JTF_NUMBER_TABLE
190 , p6_a80 out nocopy JTF_DATE_TABLE
191 , p6_a81 out nocopy JTF_NUMBER_TABLE
192 , p6_a82 out nocopy JTF_VARCHAR2_TABLE_100
193 )
194
195 as
196 ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
197 ddx_qtev_tbl okl_trx_quotes_pub.qtev_tbl_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_trx_quotes_pub.insert_trx_quotes(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_qtev_tbl);
301
302 -- copy data back from the local variables to OUT or IN-OUT args, if any
303
304
305
306
307
308
309 okl_qte_pvt_w.rosetta_table_copy_out_p8(ddx_qtev_tbl, p6_a0
310 , p6_a1
311 , p6_a2
312 , p6_a3
313 , p6_a4
314 , p6_a5
315 , p6_a6
316 , p6_a7
317 , p6_a8
318 , p6_a9
319 , p6_a10
320 , p6_a11
321 , p6_a12
322 , p6_a13
323 , p6_a14
324 , p6_a15
325 , p6_a16
326 , p6_a17
327 , p6_a18
328 , p6_a19
329 , p6_a20
330 , p6_a21
331 , p6_a22
332 , p6_a23
333 , p6_a24
334 , p6_a25
335 , p6_a26
336 , p6_a27
337 , p6_a28
338 , p6_a29
339 , p6_a30
340 , p6_a31
341 , p6_a32
342 , p6_a33
343 , p6_a34
344 , p6_a35
345 , p6_a36
346 , p6_a37
347 , p6_a38
348 , p6_a39
349 , p6_a40
350 , p6_a41
351 , p6_a42
352 , p6_a43
353 , p6_a44
354 , p6_a45
355 , p6_a46
356 , p6_a47
357 , p6_a48
358 , p6_a49
359 , p6_a50
360 , p6_a51
361 , p6_a52
362 , p6_a53
363 , p6_a54
364 , p6_a55
365 , p6_a56
366 , p6_a57
367 , p6_a58
368 , p6_a59
369 , p6_a60
370 , p6_a61
371 , p6_a62
372 , p6_a63
373 , p6_a64
374 , p6_a65
375 , p6_a66
376 , p6_a67
377 , p6_a68
378 , p6_a69
379 , p6_a70
380 , p6_a71
381 , p6_a72
382 , p6_a73
383 , p6_a74
384 , p6_a75
385 , p6_a76
386 , p6_a77
387 , p6_a78
388 , p6_a79
389 , p6_a80
390 , p6_a81
391 , p6_a82
392 );
393 end;
394
395 procedure insert_trx_quotes(p_api_version NUMBER
396 , p_init_msg_list VARCHAR2
397 , x_return_status out nocopy VARCHAR2
398 , x_msg_count out nocopy NUMBER
399 , x_msg_data out nocopy VARCHAR2
400 , p6_a0 out nocopy NUMBER
401 , p6_a1 out nocopy NUMBER
402 , p6_a2 out nocopy VARCHAR2
403 , p6_a3 out nocopy VARCHAR2
404 , p6_a4 out nocopy VARCHAR2
405 , p6_a5 out nocopy VARCHAR2
406 , p6_a6 out nocopy VARCHAR2
407 , p6_a7 out nocopy VARCHAR2
408 , p6_a8 out nocopy VARCHAR2
409 , p6_a9 out nocopy NUMBER
410 , p6_a10 out nocopy NUMBER
411 , p6_a11 out nocopy NUMBER
412 , p6_a12 out nocopy NUMBER
413 , p6_a13 out nocopy VARCHAR2
414 , p6_a14 out nocopy VARCHAR2
415 , p6_a15 out nocopy VARCHAR2
416 , p6_a16 out nocopy DATE
417 , p6_a17 out nocopy DATE
418 , p6_a18 out nocopy DATE
419 , p6_a19 out nocopy DATE
420 , p6_a20 out nocopy VARCHAR2
421 , p6_a21 out nocopy VARCHAR2
422 , p6_a22 out nocopy NUMBER
423 , p6_a23 out nocopy NUMBER
424 , p6_a24 out nocopy NUMBER
425 , p6_a25 out nocopy NUMBER
426 , p6_a26 out nocopy DATE
427 , p6_a27 out nocopy DATE
428 , p6_a28 out nocopy NUMBER
429 , p6_a29 out nocopy NUMBER
430 , p6_a30 out nocopy VARCHAR2
431 , p6_a31 out nocopy DATE
432 , p6_a32 out nocopy VARCHAR2
433 , p6_a33 out nocopy NUMBER
434 , p6_a34 out nocopy DATE
435 , p6_a35 out nocopy NUMBER
436 , p6_a36 out nocopy NUMBER
437 , p6_a37 out nocopy VARCHAR2
438 , p6_a38 out nocopy VARCHAR2
439 , p6_a39 out nocopy VARCHAR2
440 , p6_a40 out nocopy DATE
441 , p6_a41 out nocopy VARCHAR2
442 , p6_a42 out nocopy VARCHAR2
443 , p6_a43 out nocopy VARCHAR2
444 , p6_a44 out nocopy VARCHAR2
445 , p6_a45 out nocopy VARCHAR2
446 , p6_a46 out nocopy VARCHAR2
447 , p6_a47 out nocopy VARCHAR2
448 , p6_a48 out nocopy VARCHAR2
449 , p6_a49 out nocopy VARCHAR2
450 , p6_a50 out nocopy VARCHAR2
451 , p6_a51 out nocopy VARCHAR2
452 , p6_a52 out nocopy VARCHAR2
453 , p6_a53 out nocopy VARCHAR2
454 , p6_a54 out nocopy VARCHAR2
455 , p6_a55 out nocopy VARCHAR2
456 , p6_a56 out nocopy VARCHAR2
457 , p6_a57 out nocopy DATE
458 , p6_a58 out nocopy NUMBER
459 , p6_a59 out nocopy NUMBER
460 , p6_a60 out nocopy NUMBER
461 , p6_a61 out nocopy NUMBER
462 , p6_a62 out nocopy NUMBER
463 , p6_a63 out nocopy DATE
464 , p6_a64 out nocopy NUMBER
465 , p6_a65 out nocopy DATE
466 , p6_a66 out nocopy NUMBER
467 , p6_a67 out nocopy DATE
468 , p6_a68 out nocopy NUMBER
469 , p6_a69 out nocopy NUMBER
470 , p6_a70 out nocopy VARCHAR2
471 , p6_a71 out nocopy NUMBER
472 , p6_a72 out nocopy NUMBER
473 , p6_a73 out nocopy NUMBER
474 , p6_a74 out nocopy NUMBER
475 , p6_a75 out nocopy NUMBER
476 , p6_a76 out nocopy VARCHAR2
477 , p6_a77 out nocopy VARCHAR2
478 , p6_a78 out nocopy VARCHAR2
479 , p6_a79 out nocopy NUMBER
480 , p6_a80 out nocopy DATE
481 , p6_a81 out nocopy NUMBER
482 , p6_a82 out nocopy VARCHAR2
483 , p5_a0 NUMBER := 0-1962.0724
484 , p5_a1 NUMBER := 0-1962.0724
485 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
486 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
487 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
488 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
489 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
490 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
491 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
492 , p5_a9 NUMBER := 0-1962.0724
493 , p5_a10 NUMBER := 0-1962.0724
494 , p5_a11 NUMBER := 0-1962.0724
495 , p5_a12 NUMBER := 0-1962.0724
496 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
497 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
498 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
499 , p5_a16 DATE := fnd_api.g_miss_date
500 , p5_a17 DATE := fnd_api.g_miss_date
501 , p5_a18 DATE := fnd_api.g_miss_date
502 , p5_a19 DATE := fnd_api.g_miss_date
503 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
504 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
505 , p5_a22 NUMBER := 0-1962.0724
506 , p5_a23 NUMBER := 0-1962.0724
507 , p5_a24 NUMBER := 0-1962.0724
508 , p5_a25 NUMBER := 0-1962.0724
509 , p5_a26 DATE := fnd_api.g_miss_date
510 , p5_a27 DATE := fnd_api.g_miss_date
511 , p5_a28 NUMBER := 0-1962.0724
512 , p5_a29 NUMBER := 0-1962.0724
513 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
514 , p5_a31 DATE := fnd_api.g_miss_date
515 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
516 , p5_a33 NUMBER := 0-1962.0724
517 , p5_a34 DATE := fnd_api.g_miss_date
518 , p5_a35 NUMBER := 0-1962.0724
519 , p5_a36 NUMBER := 0-1962.0724
520 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
521 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
522 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
523 , p5_a40 DATE := fnd_api.g_miss_date
524 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
525 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
526 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
527 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
528 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
529 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
530 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
531 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
532 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
533 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
534 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
535 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
536 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
537 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
538 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
539 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
540 , p5_a57 DATE := fnd_api.g_miss_date
541 , p5_a58 NUMBER := 0-1962.0724
542 , p5_a59 NUMBER := 0-1962.0724
543 , p5_a60 NUMBER := 0-1962.0724
544 , p5_a61 NUMBER := 0-1962.0724
545 , p5_a62 NUMBER := 0-1962.0724
546 , p5_a63 DATE := fnd_api.g_miss_date
547 , p5_a64 NUMBER := 0-1962.0724
548 , p5_a65 DATE := fnd_api.g_miss_date
549 , p5_a66 NUMBER := 0-1962.0724
550 , p5_a67 DATE := fnd_api.g_miss_date
551 , p5_a68 NUMBER := 0-1962.0724
552 , p5_a69 NUMBER := 0-1962.0724
553 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
554 , p5_a71 NUMBER := 0-1962.0724
555 , p5_a72 NUMBER := 0-1962.0724
556 , p5_a73 NUMBER := 0-1962.0724
557 , p5_a74 NUMBER := 0-1962.0724
558 , p5_a75 NUMBER := 0-1962.0724
559 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
560 , p5_a77 VARCHAR2 := fnd_api.g_miss_char
561 , p5_a78 VARCHAR2 := fnd_api.g_miss_char
562 , p5_a79 NUMBER := 0-1962.0724
563 , p5_a80 DATE := fnd_api.g_miss_date
564 , p5_a81 NUMBER := 0-1962.0724
565 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
566 )
567
568 as
569 ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
570 ddx_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
571 ddindx binary_integer; indx binary_integer;
572 begin
573
574 -- copy data to the local IN or IN-OUT args, if any
575
576
577
578
579
580 ddp_qtev_rec.id := rosetta_g_miss_num_map(p5_a0);
581 ddp_qtev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
582 ddp_qtev_rec.sfwt_flag := p5_a2;
583 ddp_qtev_rec.qrs_code := p5_a3;
584 ddp_qtev_rec.qst_code := p5_a4;
585 ddp_qtev_rec.qtp_code := p5_a5;
586 ddp_qtev_rec.trn_code := p5_a6;
587 ddp_qtev_rec.pop_code_end := p5_a7;
588 ddp_qtev_rec.pop_code_early := p5_a8;
589 ddp_qtev_rec.consolidated_qte_id := rosetta_g_miss_num_map(p5_a9);
590 ddp_qtev_rec.khr_id := rosetta_g_miss_num_map(p5_a10);
591 ddp_qtev_rec.art_id := rosetta_g_miss_num_map(p5_a11);
592 ddp_qtev_rec.pdt_id := rosetta_g_miss_num_map(p5_a12);
593 ddp_qtev_rec.early_termination_yn := p5_a13;
594 ddp_qtev_rec.partial_yn := p5_a14;
595 ddp_qtev_rec.preproceeds_yn := p5_a15;
596 ddp_qtev_rec.date_requested := rosetta_g_miss_date_in_map(p5_a16);
597 ddp_qtev_rec.date_proposal := rosetta_g_miss_date_in_map(p5_a17);
598 ddp_qtev_rec.date_effective_to := rosetta_g_miss_date_in_map(p5_a18);
599 ddp_qtev_rec.date_accepted := rosetta_g_miss_date_in_map(p5_a19);
600 ddp_qtev_rec.summary_format_yn := p5_a20;
601 ddp_qtev_rec.consolidated_yn := p5_a21;
602 ddp_qtev_rec.principal_paydown_amount := rosetta_g_miss_num_map(p5_a22);
603 ddp_qtev_rec.residual_amount := rosetta_g_miss_num_map(p5_a23);
604 ddp_qtev_rec.yield := rosetta_g_miss_num_map(p5_a24);
605 ddp_qtev_rec.rent_amount := rosetta_g_miss_num_map(p5_a25);
606 ddp_qtev_rec.date_restructure_end := rosetta_g_miss_date_in_map(p5_a26);
607 ddp_qtev_rec.date_restructure_start := rosetta_g_miss_date_in_map(p5_a27);
608 ddp_qtev_rec.term := rosetta_g_miss_num_map(p5_a28);
609 ddp_qtev_rec.purchase_percent := rosetta_g_miss_num_map(p5_a29);
610 ddp_qtev_rec.comments := p5_a30;
611 ddp_qtev_rec.date_due := rosetta_g_miss_date_in_map(p5_a31);
612 ddp_qtev_rec.payment_frequency := p5_a32;
613 ddp_qtev_rec.remaining_payments := rosetta_g_miss_num_map(p5_a33);
614 ddp_qtev_rec.date_effective_from := rosetta_g_miss_date_in_map(p5_a34);
615 ddp_qtev_rec.quote_number := rosetta_g_miss_num_map(p5_a35);
616 ddp_qtev_rec.requested_by := rosetta_g_miss_num_map(p5_a36);
617 ddp_qtev_rec.approved_yn := p5_a37;
618 ddp_qtev_rec.accepted_yn := p5_a38;
619 ddp_qtev_rec.payment_received_yn := p5_a39;
620 ddp_qtev_rec.date_payment_received := rosetta_g_miss_date_in_map(p5_a40);
621 ddp_qtev_rec.attribute_category := p5_a41;
622 ddp_qtev_rec.attribute1 := p5_a42;
623 ddp_qtev_rec.attribute2 := p5_a43;
624 ddp_qtev_rec.attribute3 := p5_a44;
625 ddp_qtev_rec.attribute4 := p5_a45;
626 ddp_qtev_rec.attribute5 := p5_a46;
627 ddp_qtev_rec.attribute6 := p5_a47;
628 ddp_qtev_rec.attribute7 := p5_a48;
629 ddp_qtev_rec.attribute8 := p5_a49;
630 ddp_qtev_rec.attribute9 := p5_a50;
631 ddp_qtev_rec.attribute10 := p5_a51;
632 ddp_qtev_rec.attribute11 := p5_a52;
633 ddp_qtev_rec.attribute12 := p5_a53;
634 ddp_qtev_rec.attribute13 := p5_a54;
635 ddp_qtev_rec.attribute14 := p5_a55;
636 ddp_qtev_rec.attribute15 := p5_a56;
637 ddp_qtev_rec.date_approved := rosetta_g_miss_date_in_map(p5_a57);
638 ddp_qtev_rec.approved_by := rosetta_g_miss_num_map(p5_a58);
639 ddp_qtev_rec.org_id := rosetta_g_miss_num_map(p5_a59);
640 ddp_qtev_rec.request_id := rosetta_g_miss_num_map(p5_a60);
641 ddp_qtev_rec.program_application_id := rosetta_g_miss_num_map(p5_a61);
642 ddp_qtev_rec.program_id := rosetta_g_miss_num_map(p5_a62);
643 ddp_qtev_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a63);
644 ddp_qtev_rec.created_by := rosetta_g_miss_num_map(p5_a64);
645 ddp_qtev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a65);
646 ddp_qtev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a66);
647 ddp_qtev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a67);
648 ddp_qtev_rec.last_update_login := rosetta_g_miss_num_map(p5_a68);
649 ddp_qtev_rec.purchase_amount := rosetta_g_miss_num_map(p5_a69);
650 ddp_qtev_rec.purchase_formula := p5_a70;
651 ddp_qtev_rec.asset_value := rosetta_g_miss_num_map(p5_a71);
652 ddp_qtev_rec.residual_value := rosetta_g_miss_num_map(p5_a72);
653 ddp_qtev_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a73);
654 ddp_qtev_rec.gain_loss := rosetta_g_miss_num_map(p5_a74);
655 ddp_qtev_rec.perdiem_amount := rosetta_g_miss_num_map(p5_a75);
656 ddp_qtev_rec.currency_code := p5_a76;
657 ddp_qtev_rec.currency_conversion_code := p5_a77;
658 ddp_qtev_rec.currency_conversion_type := p5_a78;
659 ddp_qtev_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a79);
660 ddp_qtev_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a80);
661 ddp_qtev_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
662 ddp_qtev_rec.repo_quote_indicator_yn := p5_a82;
663
664
665 -- here's the delegated call to the old PL/SQL routine
666 okl_trx_quotes_pub.insert_trx_quotes(p_api_version,
667 p_init_msg_list,
668 x_return_status,
669 x_msg_count,
670 x_msg_data,
671 ddp_qtev_rec,
672 ddx_qtev_rec);
673
674 -- copy data back from the local variables to OUT or IN-OUT args, if any
675
676
677
678
679
680
681 p6_a0 := rosetta_g_miss_num_map(ddx_qtev_rec.id);
682 p6_a1 := rosetta_g_miss_num_map(ddx_qtev_rec.object_version_number);
683 p6_a2 := ddx_qtev_rec.sfwt_flag;
684 p6_a3 := ddx_qtev_rec.qrs_code;
685 p6_a4 := ddx_qtev_rec.qst_code;
686 p6_a5 := ddx_qtev_rec.qtp_code;
687 p6_a6 := ddx_qtev_rec.trn_code;
688 p6_a7 := ddx_qtev_rec.pop_code_end;
689 p6_a8 := ddx_qtev_rec.pop_code_early;
690 p6_a9 := rosetta_g_miss_num_map(ddx_qtev_rec.consolidated_qte_id);
691 p6_a10 := rosetta_g_miss_num_map(ddx_qtev_rec.khr_id);
692 p6_a11 := rosetta_g_miss_num_map(ddx_qtev_rec.art_id);
693 p6_a12 := rosetta_g_miss_num_map(ddx_qtev_rec.pdt_id);
694 p6_a13 := ddx_qtev_rec.early_termination_yn;
695 p6_a14 := ddx_qtev_rec.partial_yn;
696 p6_a15 := ddx_qtev_rec.preproceeds_yn;
697 p6_a16 := ddx_qtev_rec.date_requested;
698 p6_a17 := ddx_qtev_rec.date_proposal;
699 p6_a18 := ddx_qtev_rec.date_effective_to;
700 p6_a19 := ddx_qtev_rec.date_accepted;
701 p6_a20 := ddx_qtev_rec.summary_format_yn;
702 p6_a21 := ddx_qtev_rec.consolidated_yn;
703 p6_a22 := rosetta_g_miss_num_map(ddx_qtev_rec.principal_paydown_amount);
704 p6_a23 := rosetta_g_miss_num_map(ddx_qtev_rec.residual_amount);
705 p6_a24 := rosetta_g_miss_num_map(ddx_qtev_rec.yield);
706 p6_a25 := rosetta_g_miss_num_map(ddx_qtev_rec.rent_amount);
707 p6_a26 := ddx_qtev_rec.date_restructure_end;
708 p6_a27 := ddx_qtev_rec.date_restructure_start;
709 p6_a28 := rosetta_g_miss_num_map(ddx_qtev_rec.term);
710 p6_a29 := rosetta_g_miss_num_map(ddx_qtev_rec.purchase_percent);
711 p6_a30 := ddx_qtev_rec.comments;
712 p6_a31 := ddx_qtev_rec.date_due;
713 p6_a32 := ddx_qtev_rec.payment_frequency;
714 p6_a33 := rosetta_g_miss_num_map(ddx_qtev_rec.remaining_payments);
715 p6_a34 := ddx_qtev_rec.date_effective_from;
716 p6_a35 := rosetta_g_miss_num_map(ddx_qtev_rec.quote_number);
717 p6_a36 := rosetta_g_miss_num_map(ddx_qtev_rec.requested_by);
718 p6_a37 := ddx_qtev_rec.approved_yn;
719 p6_a38 := ddx_qtev_rec.accepted_yn;
720 p6_a39 := ddx_qtev_rec.payment_received_yn;
721 p6_a40 := ddx_qtev_rec.date_payment_received;
722 p6_a41 := ddx_qtev_rec.attribute_category;
723 p6_a42 := ddx_qtev_rec.attribute1;
724 p6_a43 := ddx_qtev_rec.attribute2;
725 p6_a44 := ddx_qtev_rec.attribute3;
726 p6_a45 := ddx_qtev_rec.attribute4;
727 p6_a46 := ddx_qtev_rec.attribute5;
728 p6_a47 := ddx_qtev_rec.attribute6;
729 p6_a48 := ddx_qtev_rec.attribute7;
730 p6_a49 := ddx_qtev_rec.attribute8;
731 p6_a50 := ddx_qtev_rec.attribute9;
732 p6_a51 := ddx_qtev_rec.attribute10;
733 p6_a52 := ddx_qtev_rec.attribute11;
734 p6_a53 := ddx_qtev_rec.attribute12;
735 p6_a54 := ddx_qtev_rec.attribute13;
736 p6_a55 := ddx_qtev_rec.attribute14;
737 p6_a56 := ddx_qtev_rec.attribute15;
738 p6_a57 := ddx_qtev_rec.date_approved;
739 p6_a58 := rosetta_g_miss_num_map(ddx_qtev_rec.approved_by);
740 p6_a59 := rosetta_g_miss_num_map(ddx_qtev_rec.org_id);
741 p6_a60 := rosetta_g_miss_num_map(ddx_qtev_rec.request_id);
742 p6_a61 := rosetta_g_miss_num_map(ddx_qtev_rec.program_application_id);
743 p6_a62 := rosetta_g_miss_num_map(ddx_qtev_rec.program_id);
744 p6_a63 := ddx_qtev_rec.program_update_date;
745 p6_a64 := rosetta_g_miss_num_map(ddx_qtev_rec.created_by);
746 p6_a65 := ddx_qtev_rec.creation_date;
747 p6_a66 := rosetta_g_miss_num_map(ddx_qtev_rec.last_updated_by);
748 p6_a67 := ddx_qtev_rec.last_update_date;
749 p6_a68 := rosetta_g_miss_num_map(ddx_qtev_rec.last_update_login);
750 p6_a69 := rosetta_g_miss_num_map(ddx_qtev_rec.purchase_amount);
751 p6_a70 := ddx_qtev_rec.purchase_formula;
752 p6_a71 := rosetta_g_miss_num_map(ddx_qtev_rec.asset_value);
753 p6_a72 := rosetta_g_miss_num_map(ddx_qtev_rec.residual_value);
754 p6_a73 := rosetta_g_miss_num_map(ddx_qtev_rec.unbilled_receivables);
755 p6_a74 := rosetta_g_miss_num_map(ddx_qtev_rec.gain_loss);
756 p6_a75 := rosetta_g_miss_num_map(ddx_qtev_rec.perdiem_amount);
757 p6_a76 := ddx_qtev_rec.currency_code;
758 p6_a77 := ddx_qtev_rec.currency_conversion_code;
759 p6_a78 := ddx_qtev_rec.currency_conversion_type;
760 p6_a79 := rosetta_g_miss_num_map(ddx_qtev_rec.currency_conversion_rate);
761 p6_a80 := ddx_qtev_rec.currency_conversion_date;
762 p6_a81 := rosetta_g_miss_num_map(ddx_qtev_rec.legal_entity_id);
763 p6_a82 := ddx_qtev_rec.repo_quote_indicator_yn;
764 end;
765
766 procedure lock_trx_quotes(p_api_version NUMBER
767 , p_init_msg_list VARCHAR2
768 , x_return_status out nocopy VARCHAR2
769 , x_msg_count out nocopy NUMBER
770 , x_msg_data out nocopy VARCHAR2
771 , p5_a0 JTF_NUMBER_TABLE
772 , p5_a1 JTF_NUMBER_TABLE
773 , p5_a2 JTF_VARCHAR2_TABLE_100
774 , p5_a3 JTF_VARCHAR2_TABLE_100
775 , p5_a4 JTF_VARCHAR2_TABLE_100
776 , p5_a5 JTF_VARCHAR2_TABLE_100
777 , p5_a6 JTF_VARCHAR2_TABLE_100
778 , p5_a7 JTF_VARCHAR2_TABLE_100
779 , p5_a8 JTF_VARCHAR2_TABLE_100
780 , p5_a9 JTF_NUMBER_TABLE
781 , p5_a10 JTF_NUMBER_TABLE
782 , p5_a11 JTF_NUMBER_TABLE
783 , p5_a12 JTF_NUMBER_TABLE
784 , p5_a13 JTF_VARCHAR2_TABLE_100
785 , p5_a14 JTF_VARCHAR2_TABLE_100
786 , p5_a15 JTF_VARCHAR2_TABLE_100
787 , p5_a16 JTF_DATE_TABLE
788 , p5_a17 JTF_DATE_TABLE
789 , p5_a18 JTF_DATE_TABLE
790 , p5_a19 JTF_DATE_TABLE
791 , p5_a20 JTF_VARCHAR2_TABLE_100
792 , p5_a21 JTF_VARCHAR2_TABLE_100
793 , p5_a22 JTF_NUMBER_TABLE
794 , p5_a23 JTF_NUMBER_TABLE
795 , p5_a24 JTF_NUMBER_TABLE
796 , p5_a25 JTF_NUMBER_TABLE
797 , p5_a26 JTF_DATE_TABLE
798 , p5_a27 JTF_DATE_TABLE
799 , p5_a28 JTF_NUMBER_TABLE
800 , p5_a29 JTF_NUMBER_TABLE
801 , p5_a30 JTF_VARCHAR2_TABLE_2000
802 , p5_a31 JTF_DATE_TABLE
803 , p5_a32 JTF_VARCHAR2_TABLE_100
804 , p5_a33 JTF_NUMBER_TABLE
805 , p5_a34 JTF_DATE_TABLE
806 , p5_a35 JTF_NUMBER_TABLE
807 , p5_a36 JTF_NUMBER_TABLE
808 , p5_a37 JTF_VARCHAR2_TABLE_100
809 , p5_a38 JTF_VARCHAR2_TABLE_100
810 , p5_a39 JTF_VARCHAR2_TABLE_100
811 , p5_a40 JTF_DATE_TABLE
812 , p5_a41 JTF_VARCHAR2_TABLE_100
813 , p5_a42 JTF_VARCHAR2_TABLE_500
814 , p5_a43 JTF_VARCHAR2_TABLE_500
815 , p5_a44 JTF_VARCHAR2_TABLE_500
816 , p5_a45 JTF_VARCHAR2_TABLE_500
817 , p5_a46 JTF_VARCHAR2_TABLE_500
818 , p5_a47 JTF_VARCHAR2_TABLE_500
819 , p5_a48 JTF_VARCHAR2_TABLE_500
820 , p5_a49 JTF_VARCHAR2_TABLE_500
821 , p5_a50 JTF_VARCHAR2_TABLE_500
822 , p5_a51 JTF_VARCHAR2_TABLE_500
823 , p5_a52 JTF_VARCHAR2_TABLE_500
824 , p5_a53 JTF_VARCHAR2_TABLE_500
825 , p5_a54 JTF_VARCHAR2_TABLE_500
826 , p5_a55 JTF_VARCHAR2_TABLE_500
827 , p5_a56 JTF_VARCHAR2_TABLE_500
828 , p5_a57 JTF_DATE_TABLE
829 , p5_a58 JTF_NUMBER_TABLE
830 , p5_a59 JTF_NUMBER_TABLE
831 , p5_a60 JTF_NUMBER_TABLE
832 , p5_a61 JTF_NUMBER_TABLE
833 , p5_a62 JTF_NUMBER_TABLE
834 , p5_a63 JTF_DATE_TABLE
835 , p5_a64 JTF_NUMBER_TABLE
836 , p5_a65 JTF_DATE_TABLE
837 , p5_a66 JTF_NUMBER_TABLE
838 , p5_a67 JTF_DATE_TABLE
839 , p5_a68 JTF_NUMBER_TABLE
840 , p5_a69 JTF_NUMBER_TABLE
841 , p5_a70 JTF_VARCHAR2_TABLE_200
842 , p5_a71 JTF_NUMBER_TABLE
843 , p5_a72 JTF_NUMBER_TABLE
844 , p5_a73 JTF_NUMBER_TABLE
845 , p5_a74 JTF_NUMBER_TABLE
846 , p5_a75 JTF_NUMBER_TABLE
847 , p5_a76 JTF_VARCHAR2_TABLE_100
848 , p5_a77 JTF_VARCHAR2_TABLE_100
849 , p5_a78 JTF_VARCHAR2_TABLE_100
850 , p5_a79 JTF_NUMBER_TABLE
851 , p5_a80 JTF_DATE_TABLE
852 , p5_a81 JTF_NUMBER_TABLE
853 , p5_a82 JTF_VARCHAR2_TABLE_100
854 )
855
856 as
857 ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
858 ddindx binary_integer; indx binary_integer;
859 begin
860
861 -- copy data to the local IN or IN-OUT args, if any
862
863
864
865
866
867 okl_qte_pvt_w.rosetta_table_copy_in_p8(ddp_qtev_tbl, p5_a0
868 , p5_a1
869 , p5_a2
870 , p5_a3
871 , p5_a4
872 , p5_a5
873 , p5_a6
874 , p5_a7
875 , p5_a8
876 , p5_a9
877 , p5_a10
878 , p5_a11
879 , p5_a12
880 , p5_a13
881 , p5_a14
882 , p5_a15
883 , p5_a16
884 , p5_a17
885 , p5_a18
886 , p5_a19
887 , p5_a20
888 , p5_a21
889 , p5_a22
890 , p5_a23
891 , p5_a24
892 , p5_a25
893 , p5_a26
894 , p5_a27
895 , p5_a28
896 , p5_a29
897 , p5_a30
898 , p5_a31
899 , p5_a32
900 , p5_a33
901 , p5_a34
902 , p5_a35
903 , p5_a36
904 , p5_a37
905 , p5_a38
906 , p5_a39
907 , p5_a40
908 , p5_a41
909 , p5_a42
910 , p5_a43
911 , p5_a44
912 , p5_a45
913 , p5_a46
914 , p5_a47
915 , p5_a48
916 , p5_a49
917 , p5_a50
918 , p5_a51
919 , p5_a52
920 , p5_a53
921 , p5_a54
922 , p5_a55
923 , p5_a56
924 , p5_a57
925 , p5_a58
926 , p5_a59
927 , p5_a60
928 , p5_a61
929 , p5_a62
930 , p5_a63
931 , p5_a64
932 , p5_a65
933 , p5_a66
934 , p5_a67
935 , p5_a68
936 , p5_a69
937 , p5_a70
938 , p5_a71
939 , p5_a72
940 , p5_a73
941 , p5_a74
942 , p5_a75
943 , p5_a76
944 , p5_a77
945 , p5_a78
946 , p5_a79
947 , p5_a80
948 , p5_a81
949 , p5_a82
950 );
951
952 -- here's the delegated call to the old PL/SQL routine
953 okl_trx_quotes_pub.lock_trx_quotes(p_api_version,
954 p_init_msg_list,
955 x_return_status,
956 x_msg_count,
957 x_msg_data,
958 ddp_qtev_tbl);
959
960 -- copy data back from the local variables to OUT or IN-OUT args, if any
961
962
963
964
965
966 end;
967
968 procedure lock_trx_quotes(p_api_version NUMBER
969 , p_init_msg_list VARCHAR2
970 , x_return_status out nocopy VARCHAR2
971 , x_msg_count out nocopy NUMBER
972 , x_msg_data out nocopy VARCHAR2
973 , p5_a0 NUMBER := 0-1962.0724
974 , p5_a1 NUMBER := 0-1962.0724
975 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
976 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
977 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
978 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
979 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
980 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
981 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
982 , p5_a9 NUMBER := 0-1962.0724
983 , p5_a10 NUMBER := 0-1962.0724
984 , p5_a11 NUMBER := 0-1962.0724
985 , p5_a12 NUMBER := 0-1962.0724
986 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
987 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
988 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
989 , p5_a16 DATE := fnd_api.g_miss_date
990 , p5_a17 DATE := fnd_api.g_miss_date
991 , p5_a18 DATE := fnd_api.g_miss_date
992 , p5_a19 DATE := fnd_api.g_miss_date
993 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
994 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
995 , p5_a22 NUMBER := 0-1962.0724
996 , p5_a23 NUMBER := 0-1962.0724
997 , p5_a24 NUMBER := 0-1962.0724
998 , p5_a25 NUMBER := 0-1962.0724
999 , p5_a26 DATE := fnd_api.g_miss_date
1000 , p5_a27 DATE := fnd_api.g_miss_date
1001 , p5_a28 NUMBER := 0-1962.0724
1002 , p5_a29 NUMBER := 0-1962.0724
1003 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1004 , p5_a31 DATE := fnd_api.g_miss_date
1005 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1006 , p5_a33 NUMBER := 0-1962.0724
1007 , p5_a34 DATE := fnd_api.g_miss_date
1008 , p5_a35 NUMBER := 0-1962.0724
1009 , p5_a36 NUMBER := 0-1962.0724
1010 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1011 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1012 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1013 , p5_a40 DATE := fnd_api.g_miss_date
1014 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1015 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1016 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1017 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1018 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1019 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1020 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1021 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1022 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1023 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
1024 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
1025 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1026 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1027 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
1028 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
1029 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
1030 , p5_a57 DATE := fnd_api.g_miss_date
1031 , p5_a58 NUMBER := 0-1962.0724
1032 , p5_a59 NUMBER := 0-1962.0724
1033 , p5_a60 NUMBER := 0-1962.0724
1034 , p5_a61 NUMBER := 0-1962.0724
1035 , p5_a62 NUMBER := 0-1962.0724
1036 , p5_a63 DATE := fnd_api.g_miss_date
1037 , p5_a64 NUMBER := 0-1962.0724
1038 , p5_a65 DATE := fnd_api.g_miss_date
1039 , p5_a66 NUMBER := 0-1962.0724
1040 , p5_a67 DATE := fnd_api.g_miss_date
1041 , p5_a68 NUMBER := 0-1962.0724
1042 , p5_a69 NUMBER := 0-1962.0724
1043 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
1044 , p5_a71 NUMBER := 0-1962.0724
1045 , p5_a72 NUMBER := 0-1962.0724
1046 , p5_a73 NUMBER := 0-1962.0724
1047 , p5_a74 NUMBER := 0-1962.0724
1048 , p5_a75 NUMBER := 0-1962.0724
1049 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
1050 , p5_a77 VARCHAR2 := fnd_api.g_miss_char
1051 , p5_a78 VARCHAR2 := fnd_api.g_miss_char
1052 , p5_a79 NUMBER := 0-1962.0724
1053 , p5_a80 DATE := fnd_api.g_miss_date
1054 , p5_a81 NUMBER := 0-1962.0724
1055 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
1056 )
1057
1058 as
1059 ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
1060 ddindx binary_integer; indx binary_integer;
1061 begin
1062
1063 -- copy data to the local IN or IN-OUT args, if any
1064
1065
1066
1067
1068
1069 ddp_qtev_rec.id := rosetta_g_miss_num_map(p5_a0);
1070 ddp_qtev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1071 ddp_qtev_rec.sfwt_flag := p5_a2;
1072 ddp_qtev_rec.qrs_code := p5_a3;
1073 ddp_qtev_rec.qst_code := p5_a4;
1074 ddp_qtev_rec.qtp_code := p5_a5;
1075 ddp_qtev_rec.trn_code := p5_a6;
1076 ddp_qtev_rec.pop_code_end := p5_a7;
1077 ddp_qtev_rec.pop_code_early := p5_a8;
1078 ddp_qtev_rec.consolidated_qte_id := rosetta_g_miss_num_map(p5_a9);
1079 ddp_qtev_rec.khr_id := rosetta_g_miss_num_map(p5_a10);
1080 ddp_qtev_rec.art_id := rosetta_g_miss_num_map(p5_a11);
1081 ddp_qtev_rec.pdt_id := rosetta_g_miss_num_map(p5_a12);
1082 ddp_qtev_rec.early_termination_yn := p5_a13;
1083 ddp_qtev_rec.partial_yn := p5_a14;
1084 ddp_qtev_rec.preproceeds_yn := p5_a15;
1085 ddp_qtev_rec.date_requested := rosetta_g_miss_date_in_map(p5_a16);
1086 ddp_qtev_rec.date_proposal := rosetta_g_miss_date_in_map(p5_a17);
1087 ddp_qtev_rec.date_effective_to := rosetta_g_miss_date_in_map(p5_a18);
1088 ddp_qtev_rec.date_accepted := rosetta_g_miss_date_in_map(p5_a19);
1089 ddp_qtev_rec.summary_format_yn := p5_a20;
1090 ddp_qtev_rec.consolidated_yn := p5_a21;
1091 ddp_qtev_rec.principal_paydown_amount := rosetta_g_miss_num_map(p5_a22);
1092 ddp_qtev_rec.residual_amount := rosetta_g_miss_num_map(p5_a23);
1093 ddp_qtev_rec.yield := rosetta_g_miss_num_map(p5_a24);
1094 ddp_qtev_rec.rent_amount := rosetta_g_miss_num_map(p5_a25);
1095 ddp_qtev_rec.date_restructure_end := rosetta_g_miss_date_in_map(p5_a26);
1096 ddp_qtev_rec.date_restructure_start := rosetta_g_miss_date_in_map(p5_a27);
1097 ddp_qtev_rec.term := rosetta_g_miss_num_map(p5_a28);
1098 ddp_qtev_rec.purchase_percent := rosetta_g_miss_num_map(p5_a29);
1099 ddp_qtev_rec.comments := p5_a30;
1100 ddp_qtev_rec.date_due := rosetta_g_miss_date_in_map(p5_a31);
1101 ddp_qtev_rec.payment_frequency := p5_a32;
1102 ddp_qtev_rec.remaining_payments := rosetta_g_miss_num_map(p5_a33);
1103 ddp_qtev_rec.date_effective_from := rosetta_g_miss_date_in_map(p5_a34);
1104 ddp_qtev_rec.quote_number := rosetta_g_miss_num_map(p5_a35);
1105 ddp_qtev_rec.requested_by := rosetta_g_miss_num_map(p5_a36);
1106 ddp_qtev_rec.approved_yn := p5_a37;
1107 ddp_qtev_rec.accepted_yn := p5_a38;
1108 ddp_qtev_rec.payment_received_yn := p5_a39;
1109 ddp_qtev_rec.date_payment_received := rosetta_g_miss_date_in_map(p5_a40);
1110 ddp_qtev_rec.attribute_category := p5_a41;
1111 ddp_qtev_rec.attribute1 := p5_a42;
1112 ddp_qtev_rec.attribute2 := p5_a43;
1113 ddp_qtev_rec.attribute3 := p5_a44;
1114 ddp_qtev_rec.attribute4 := p5_a45;
1115 ddp_qtev_rec.attribute5 := p5_a46;
1116 ddp_qtev_rec.attribute6 := p5_a47;
1117 ddp_qtev_rec.attribute7 := p5_a48;
1118 ddp_qtev_rec.attribute8 := p5_a49;
1119 ddp_qtev_rec.attribute9 := p5_a50;
1120 ddp_qtev_rec.attribute10 := p5_a51;
1121 ddp_qtev_rec.attribute11 := p5_a52;
1122 ddp_qtev_rec.attribute12 := p5_a53;
1123 ddp_qtev_rec.attribute13 := p5_a54;
1124 ddp_qtev_rec.attribute14 := p5_a55;
1125 ddp_qtev_rec.attribute15 := p5_a56;
1126 ddp_qtev_rec.date_approved := rosetta_g_miss_date_in_map(p5_a57);
1127 ddp_qtev_rec.approved_by := rosetta_g_miss_num_map(p5_a58);
1128 ddp_qtev_rec.org_id := rosetta_g_miss_num_map(p5_a59);
1129 ddp_qtev_rec.request_id := rosetta_g_miss_num_map(p5_a60);
1130 ddp_qtev_rec.program_application_id := rosetta_g_miss_num_map(p5_a61);
1131 ddp_qtev_rec.program_id := rosetta_g_miss_num_map(p5_a62);
1132 ddp_qtev_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a63);
1133 ddp_qtev_rec.created_by := rosetta_g_miss_num_map(p5_a64);
1134 ddp_qtev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a65);
1135 ddp_qtev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a66);
1136 ddp_qtev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a67);
1137 ddp_qtev_rec.last_update_login := rosetta_g_miss_num_map(p5_a68);
1138 ddp_qtev_rec.purchase_amount := rosetta_g_miss_num_map(p5_a69);
1139 ddp_qtev_rec.purchase_formula := p5_a70;
1140 ddp_qtev_rec.asset_value := rosetta_g_miss_num_map(p5_a71);
1141 ddp_qtev_rec.residual_value := rosetta_g_miss_num_map(p5_a72);
1142 ddp_qtev_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a73);
1143 ddp_qtev_rec.gain_loss := rosetta_g_miss_num_map(p5_a74);
1144 ddp_qtev_rec.perdiem_amount := rosetta_g_miss_num_map(p5_a75);
1145 ddp_qtev_rec.currency_code := p5_a76;
1146 ddp_qtev_rec.currency_conversion_code := p5_a77;
1147 ddp_qtev_rec.currency_conversion_type := p5_a78;
1148 ddp_qtev_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a79);
1149 ddp_qtev_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a80);
1150 ddp_qtev_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
1151 ddp_qtev_rec.repo_quote_indicator_yn := p5_a82;
1152
1153 -- here's the delegated call to the old PL/SQL routine
1154 okl_trx_quotes_pub.lock_trx_quotes(p_api_version,
1155 p_init_msg_list,
1156 x_return_status,
1157 x_msg_count,
1158 x_msg_data,
1159 ddp_qtev_rec);
1160
1161 -- copy data back from the local variables to OUT or IN-OUT args, if any
1162
1163
1164
1165
1166
1167 end;
1168
1169 procedure update_trx_quotes(p_api_version NUMBER
1170 , p_init_msg_list VARCHAR2
1171 , x_return_status out nocopy VARCHAR2
1172 , x_msg_count out nocopy NUMBER
1173 , x_msg_data out nocopy VARCHAR2
1174 , p5_a0 JTF_NUMBER_TABLE
1175 , p5_a1 JTF_NUMBER_TABLE
1176 , p5_a2 JTF_VARCHAR2_TABLE_100
1177 , p5_a3 JTF_VARCHAR2_TABLE_100
1178 , p5_a4 JTF_VARCHAR2_TABLE_100
1179 , p5_a5 JTF_VARCHAR2_TABLE_100
1180 , p5_a6 JTF_VARCHAR2_TABLE_100
1181 , p5_a7 JTF_VARCHAR2_TABLE_100
1182 , p5_a8 JTF_VARCHAR2_TABLE_100
1183 , p5_a9 JTF_NUMBER_TABLE
1184 , p5_a10 JTF_NUMBER_TABLE
1185 , p5_a11 JTF_NUMBER_TABLE
1186 , p5_a12 JTF_NUMBER_TABLE
1187 , p5_a13 JTF_VARCHAR2_TABLE_100
1188 , p5_a14 JTF_VARCHAR2_TABLE_100
1189 , p5_a15 JTF_VARCHAR2_TABLE_100
1190 , p5_a16 JTF_DATE_TABLE
1191 , p5_a17 JTF_DATE_TABLE
1192 , p5_a18 JTF_DATE_TABLE
1193 , p5_a19 JTF_DATE_TABLE
1194 , p5_a20 JTF_VARCHAR2_TABLE_100
1195 , p5_a21 JTF_VARCHAR2_TABLE_100
1196 , p5_a22 JTF_NUMBER_TABLE
1197 , p5_a23 JTF_NUMBER_TABLE
1198 , p5_a24 JTF_NUMBER_TABLE
1199 , p5_a25 JTF_NUMBER_TABLE
1200 , p5_a26 JTF_DATE_TABLE
1201 , p5_a27 JTF_DATE_TABLE
1202 , p5_a28 JTF_NUMBER_TABLE
1203 , p5_a29 JTF_NUMBER_TABLE
1204 , p5_a30 JTF_VARCHAR2_TABLE_2000
1205 , p5_a31 JTF_DATE_TABLE
1206 , p5_a32 JTF_VARCHAR2_TABLE_100
1207 , p5_a33 JTF_NUMBER_TABLE
1208 , p5_a34 JTF_DATE_TABLE
1209 , p5_a35 JTF_NUMBER_TABLE
1210 , p5_a36 JTF_NUMBER_TABLE
1211 , p5_a37 JTF_VARCHAR2_TABLE_100
1212 , p5_a38 JTF_VARCHAR2_TABLE_100
1213 , p5_a39 JTF_VARCHAR2_TABLE_100
1214 , p5_a40 JTF_DATE_TABLE
1215 , p5_a41 JTF_VARCHAR2_TABLE_100
1216 , p5_a42 JTF_VARCHAR2_TABLE_500
1217 , p5_a43 JTF_VARCHAR2_TABLE_500
1218 , p5_a44 JTF_VARCHAR2_TABLE_500
1219 , p5_a45 JTF_VARCHAR2_TABLE_500
1220 , p5_a46 JTF_VARCHAR2_TABLE_500
1221 , p5_a47 JTF_VARCHAR2_TABLE_500
1222 , p5_a48 JTF_VARCHAR2_TABLE_500
1223 , p5_a49 JTF_VARCHAR2_TABLE_500
1224 , p5_a50 JTF_VARCHAR2_TABLE_500
1225 , p5_a51 JTF_VARCHAR2_TABLE_500
1226 , p5_a52 JTF_VARCHAR2_TABLE_500
1227 , p5_a53 JTF_VARCHAR2_TABLE_500
1228 , p5_a54 JTF_VARCHAR2_TABLE_500
1229 , p5_a55 JTF_VARCHAR2_TABLE_500
1230 , p5_a56 JTF_VARCHAR2_TABLE_500
1231 , p5_a57 JTF_DATE_TABLE
1232 , p5_a58 JTF_NUMBER_TABLE
1233 , p5_a59 JTF_NUMBER_TABLE
1234 , p5_a60 JTF_NUMBER_TABLE
1235 , p5_a61 JTF_NUMBER_TABLE
1236 , p5_a62 JTF_NUMBER_TABLE
1237 , p5_a63 JTF_DATE_TABLE
1238 , p5_a64 JTF_NUMBER_TABLE
1239 , p5_a65 JTF_DATE_TABLE
1240 , p5_a66 JTF_NUMBER_TABLE
1241 , p5_a67 JTF_DATE_TABLE
1242 , p5_a68 JTF_NUMBER_TABLE
1243 , p5_a69 JTF_NUMBER_TABLE
1244 , p5_a70 JTF_VARCHAR2_TABLE_200
1245 , p5_a71 JTF_NUMBER_TABLE
1246 , p5_a72 JTF_NUMBER_TABLE
1247 , p5_a73 JTF_NUMBER_TABLE
1248 , p5_a74 JTF_NUMBER_TABLE
1249 , p5_a75 JTF_NUMBER_TABLE
1250 , p5_a76 JTF_VARCHAR2_TABLE_100
1251 , p5_a77 JTF_VARCHAR2_TABLE_100
1252 , p5_a78 JTF_VARCHAR2_TABLE_100
1253 , p5_a79 JTF_NUMBER_TABLE
1254 , p5_a80 JTF_DATE_TABLE
1255 , p5_a81 JTF_NUMBER_TABLE
1256 , p5_a82 JTF_VARCHAR2_TABLE_100
1257 , p6_a0 out nocopy JTF_NUMBER_TABLE
1258 , p6_a1 out nocopy JTF_NUMBER_TABLE
1259 , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
1260 , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
1261 , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
1262 , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
1263 , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100
1264 , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
1265 , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
1266 , p6_a9 out nocopy JTF_NUMBER_TABLE
1267 , p6_a10 out nocopy JTF_NUMBER_TABLE
1268 , p6_a11 out nocopy JTF_NUMBER_TABLE
1269 , p6_a12 out nocopy JTF_NUMBER_TABLE
1270 , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
1271 , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
1272 , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
1273 , p6_a16 out nocopy JTF_DATE_TABLE
1274 , p6_a17 out nocopy JTF_DATE_TABLE
1275 , p6_a18 out nocopy JTF_DATE_TABLE
1276 , p6_a19 out nocopy JTF_DATE_TABLE
1277 , p6_a20 out nocopy JTF_VARCHAR2_TABLE_100
1278 , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
1279 , p6_a22 out nocopy JTF_NUMBER_TABLE
1280 , p6_a23 out nocopy JTF_NUMBER_TABLE
1281 , p6_a24 out nocopy JTF_NUMBER_TABLE
1282 , p6_a25 out nocopy JTF_NUMBER_TABLE
1283 , p6_a26 out nocopy JTF_DATE_TABLE
1284 , p6_a27 out nocopy JTF_DATE_TABLE
1285 , p6_a28 out nocopy JTF_NUMBER_TABLE
1286 , p6_a29 out nocopy JTF_NUMBER_TABLE
1287 , p6_a30 out nocopy JTF_VARCHAR2_TABLE_2000
1288 , p6_a31 out nocopy JTF_DATE_TABLE
1289 , p6_a32 out nocopy JTF_VARCHAR2_TABLE_100
1290 , p6_a33 out nocopy JTF_NUMBER_TABLE
1291 , p6_a34 out nocopy JTF_DATE_TABLE
1292 , p6_a35 out nocopy JTF_NUMBER_TABLE
1293 , p6_a36 out nocopy JTF_NUMBER_TABLE
1294 , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
1295 , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
1296 , p6_a39 out nocopy JTF_VARCHAR2_TABLE_100
1297 , p6_a40 out nocopy JTF_DATE_TABLE
1298 , p6_a41 out nocopy JTF_VARCHAR2_TABLE_100
1299 , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
1300 , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500
1301 , p6_a44 out nocopy JTF_VARCHAR2_TABLE_500
1302 , p6_a45 out nocopy JTF_VARCHAR2_TABLE_500
1303 , p6_a46 out nocopy JTF_VARCHAR2_TABLE_500
1304 , p6_a47 out nocopy JTF_VARCHAR2_TABLE_500
1305 , p6_a48 out nocopy JTF_VARCHAR2_TABLE_500
1306 , p6_a49 out nocopy JTF_VARCHAR2_TABLE_500
1307 , p6_a50 out nocopy JTF_VARCHAR2_TABLE_500
1308 , p6_a51 out nocopy JTF_VARCHAR2_TABLE_500
1309 , p6_a52 out nocopy JTF_VARCHAR2_TABLE_500
1310 , p6_a53 out nocopy JTF_VARCHAR2_TABLE_500
1311 , p6_a54 out nocopy JTF_VARCHAR2_TABLE_500
1312 , p6_a55 out nocopy JTF_VARCHAR2_TABLE_500
1313 , p6_a56 out nocopy JTF_VARCHAR2_TABLE_500
1314 , p6_a57 out nocopy JTF_DATE_TABLE
1315 , p6_a58 out nocopy JTF_NUMBER_TABLE
1316 , p6_a59 out nocopy JTF_NUMBER_TABLE
1317 , p6_a60 out nocopy JTF_NUMBER_TABLE
1318 , p6_a61 out nocopy JTF_NUMBER_TABLE
1319 , p6_a62 out nocopy JTF_NUMBER_TABLE
1320 , p6_a63 out nocopy JTF_DATE_TABLE
1321 , p6_a64 out nocopy JTF_NUMBER_TABLE
1322 , p6_a65 out nocopy JTF_DATE_TABLE
1323 , p6_a66 out nocopy JTF_NUMBER_TABLE
1324 , p6_a67 out nocopy JTF_DATE_TABLE
1325 , p6_a68 out nocopy JTF_NUMBER_TABLE
1326 , p6_a69 out nocopy JTF_NUMBER_TABLE
1327 , p6_a70 out nocopy JTF_VARCHAR2_TABLE_200
1328 , p6_a71 out nocopy JTF_NUMBER_TABLE
1329 , p6_a72 out nocopy JTF_NUMBER_TABLE
1330 , p6_a73 out nocopy JTF_NUMBER_TABLE
1331 , p6_a74 out nocopy JTF_NUMBER_TABLE
1332 , p6_a75 out nocopy JTF_NUMBER_TABLE
1333 , p6_a76 out nocopy JTF_VARCHAR2_TABLE_100
1334 , p6_a77 out nocopy JTF_VARCHAR2_TABLE_100
1335 , p6_a78 out nocopy JTF_VARCHAR2_TABLE_100
1336 , p6_a79 out nocopy JTF_NUMBER_TABLE
1337 , p6_a80 out nocopy JTF_DATE_TABLE
1338 , p6_a81 out nocopy JTF_NUMBER_TABLE
1339 , p6_a82 out nocopy JTF_VARCHAR2_TABLE_100
1340 )
1341
1342 as
1343 ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
1344 ddx_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
1345 ddindx binary_integer; indx binary_integer;
1346 begin
1347
1348 -- copy data to the local IN or IN-OUT args, if any
1349
1350
1351
1352
1353
1354 okl_qte_pvt_w.rosetta_table_copy_in_p8(ddp_qtev_tbl, p5_a0
1355 , p5_a1
1356 , p5_a2
1357 , p5_a3
1358 , p5_a4
1359 , p5_a5
1360 , p5_a6
1361 , p5_a7
1362 , p5_a8
1363 , p5_a9
1364 , p5_a10
1365 , p5_a11
1366 , p5_a12
1367 , p5_a13
1368 , p5_a14
1369 , p5_a15
1370 , p5_a16
1371 , p5_a17
1372 , p5_a18
1373 , p5_a19
1374 , p5_a20
1375 , p5_a21
1376 , p5_a22
1377 , p5_a23
1378 , p5_a24
1379 , p5_a25
1380 , p5_a26
1381 , p5_a27
1382 , p5_a28
1383 , p5_a29
1384 , p5_a30
1385 , p5_a31
1386 , p5_a32
1387 , p5_a33
1388 , p5_a34
1389 , p5_a35
1390 , p5_a36
1391 , p5_a37
1392 , p5_a38
1393 , p5_a39
1394 , p5_a40
1395 , p5_a41
1396 , p5_a42
1397 , p5_a43
1398 , p5_a44
1399 , p5_a45
1400 , p5_a46
1401 , p5_a47
1402 , p5_a48
1403 , p5_a49
1404 , p5_a50
1405 , p5_a51
1406 , p5_a52
1407 , p5_a53
1408 , p5_a54
1409 , p5_a55
1410 , p5_a56
1411 , p5_a57
1412 , p5_a58
1413 , p5_a59
1414 , p5_a60
1415 , p5_a61
1416 , p5_a62
1417 , p5_a63
1418 , p5_a64
1419 , p5_a65
1420 , p5_a66
1421 , p5_a67
1422 , p5_a68
1423 , p5_a69
1424 , p5_a70
1425 , p5_a71
1426 , p5_a72
1427 , p5_a73
1428 , p5_a74
1429 , p5_a75
1430 , p5_a76
1431 , p5_a77
1432 , p5_a78
1433 , p5_a79
1434 , p5_a80
1435 , p5_a81
1436 , p5_a82
1437 );
1438
1439
1440 -- here's the delegated call to the old PL/SQL routine
1441 okl_trx_quotes_pub.update_trx_quotes(p_api_version,
1442 p_init_msg_list,
1443 x_return_status,
1444 x_msg_count,
1445 x_msg_data,
1446 ddp_qtev_tbl,
1447 ddx_qtev_tbl);
1448
1449 -- copy data back from the local variables to OUT or IN-OUT args, if any
1450
1451
1452
1453
1454
1455
1456 okl_qte_pvt_w.rosetta_table_copy_out_p8(ddx_qtev_tbl, p6_a0
1457 , p6_a1
1458 , p6_a2
1459 , p6_a3
1460 , p6_a4
1461 , p6_a5
1462 , p6_a6
1463 , p6_a7
1464 , p6_a8
1465 , p6_a9
1466 , p6_a10
1467 , p6_a11
1468 , p6_a12
1469 , p6_a13
1470 , p6_a14
1471 , p6_a15
1472 , p6_a16
1473 , p6_a17
1474 , p6_a18
1475 , p6_a19
1476 , p6_a20
1477 , p6_a21
1478 , p6_a22
1479 , p6_a23
1480 , p6_a24
1481 , p6_a25
1482 , p6_a26
1483 , p6_a27
1484 , p6_a28
1485 , p6_a29
1486 , p6_a30
1487 , p6_a31
1488 , p6_a32
1489 , p6_a33
1490 , p6_a34
1491 , p6_a35
1492 , p6_a36
1493 , p6_a37
1494 , p6_a38
1495 , p6_a39
1496 , p6_a40
1497 , p6_a41
1498 , p6_a42
1499 , p6_a43
1500 , p6_a44
1501 , p6_a45
1502 , p6_a46
1503 , p6_a47
1504 , p6_a48
1505 , p6_a49
1506 , p6_a50
1507 , p6_a51
1508 , p6_a52
1509 , p6_a53
1510 , p6_a54
1511 , p6_a55
1512 , p6_a56
1513 , p6_a57
1514 , p6_a58
1515 , p6_a59
1516 , p6_a60
1517 , p6_a61
1518 , p6_a62
1519 , p6_a63
1520 , p6_a64
1521 , p6_a65
1522 , p6_a66
1523 , p6_a67
1524 , p6_a68
1525 , p6_a69
1526 , p6_a70
1527 , p6_a71
1528 , p6_a72
1529 , p6_a73
1530 , p6_a74
1531 , p6_a75
1532 , p6_a76
1533 , p6_a77
1534 , p6_a78
1535 , p6_a79
1536 , p6_a80
1537 , p6_a81
1538 , p6_a82
1539 );
1540 end;
1541
1542 procedure update_trx_quotes(p_api_version NUMBER
1543 , p_init_msg_list VARCHAR2
1544 , x_return_status out nocopy VARCHAR2
1545 , x_msg_count out nocopy NUMBER
1546 , x_msg_data out nocopy VARCHAR2
1547 , p6_a0 out nocopy NUMBER
1548 , p6_a1 out nocopy NUMBER
1549 , p6_a2 out nocopy VARCHAR2
1550 , p6_a3 out nocopy VARCHAR2
1551 , p6_a4 out nocopy VARCHAR2
1552 , p6_a5 out nocopy VARCHAR2
1553 , p6_a6 out nocopy VARCHAR2
1554 , p6_a7 out nocopy VARCHAR2
1555 , p6_a8 out nocopy VARCHAR2
1556 , p6_a9 out nocopy NUMBER
1557 , p6_a10 out nocopy NUMBER
1558 , p6_a11 out nocopy NUMBER
1559 , p6_a12 out nocopy NUMBER
1560 , p6_a13 out nocopy VARCHAR2
1561 , p6_a14 out nocopy VARCHAR2
1562 , p6_a15 out nocopy VARCHAR2
1563 , p6_a16 out nocopy DATE
1564 , p6_a17 out nocopy DATE
1565 , p6_a18 out nocopy DATE
1566 , p6_a19 out nocopy DATE
1567 , p6_a20 out nocopy VARCHAR2
1568 , p6_a21 out nocopy VARCHAR2
1569 , p6_a22 out nocopy NUMBER
1570 , p6_a23 out nocopy NUMBER
1571 , p6_a24 out nocopy NUMBER
1572 , p6_a25 out nocopy NUMBER
1573 , p6_a26 out nocopy DATE
1574 , p6_a27 out nocopy DATE
1575 , p6_a28 out nocopy NUMBER
1576 , p6_a29 out nocopy NUMBER
1577 , p6_a30 out nocopy VARCHAR2
1578 , p6_a31 out nocopy DATE
1579 , p6_a32 out nocopy VARCHAR2
1580 , p6_a33 out nocopy NUMBER
1581 , p6_a34 out nocopy DATE
1582 , p6_a35 out nocopy NUMBER
1583 , p6_a36 out nocopy NUMBER
1584 , p6_a37 out nocopy VARCHAR2
1585 , p6_a38 out nocopy VARCHAR2
1586 , p6_a39 out nocopy VARCHAR2
1587 , p6_a40 out nocopy DATE
1588 , p6_a41 out nocopy VARCHAR2
1589 , p6_a42 out nocopy VARCHAR2
1590 , p6_a43 out nocopy VARCHAR2
1591 , p6_a44 out nocopy VARCHAR2
1592 , p6_a45 out nocopy VARCHAR2
1593 , p6_a46 out nocopy VARCHAR2
1594 , p6_a47 out nocopy VARCHAR2
1595 , p6_a48 out nocopy VARCHAR2
1596 , p6_a49 out nocopy VARCHAR2
1597 , p6_a50 out nocopy VARCHAR2
1598 , p6_a51 out nocopy VARCHAR2
1599 , p6_a52 out nocopy VARCHAR2
1600 , p6_a53 out nocopy VARCHAR2
1601 , p6_a54 out nocopy VARCHAR2
1602 , p6_a55 out nocopy VARCHAR2
1603 , p6_a56 out nocopy VARCHAR2
1604 , p6_a57 out nocopy DATE
1605 , p6_a58 out nocopy NUMBER
1606 , p6_a59 out nocopy NUMBER
1607 , p6_a60 out nocopy NUMBER
1608 , p6_a61 out nocopy NUMBER
1609 , p6_a62 out nocopy NUMBER
1610 , p6_a63 out nocopy DATE
1611 , p6_a64 out nocopy NUMBER
1612 , p6_a65 out nocopy DATE
1613 , p6_a66 out nocopy NUMBER
1614 , p6_a67 out nocopy DATE
1615 , p6_a68 out nocopy NUMBER
1616 , p6_a69 out nocopy NUMBER
1617 , p6_a70 out nocopy VARCHAR2
1618 , p6_a71 out nocopy NUMBER
1619 , p6_a72 out nocopy NUMBER
1620 , p6_a73 out nocopy NUMBER
1621 , p6_a74 out nocopy NUMBER
1622 , p6_a75 out nocopy NUMBER
1623 , p6_a76 out nocopy VARCHAR2
1624 , p6_a77 out nocopy VARCHAR2
1625 , p6_a78 out nocopy VARCHAR2
1626 , p6_a79 out nocopy NUMBER
1627 , p6_a80 out nocopy DATE
1628 , p6_a81 out nocopy NUMBER
1629 , p6_a82 out nocopy VARCHAR2
1630 , p5_a0 NUMBER := 0-1962.0724
1631 , p5_a1 NUMBER := 0-1962.0724
1632 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
1633 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
1634 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
1635 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
1636 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
1637 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
1638 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
1639 , p5_a9 NUMBER := 0-1962.0724
1640 , p5_a10 NUMBER := 0-1962.0724
1641 , p5_a11 NUMBER := 0-1962.0724
1642 , p5_a12 NUMBER := 0-1962.0724
1643 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
1644 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
1645 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
1646 , p5_a16 DATE := fnd_api.g_miss_date
1647 , p5_a17 DATE := fnd_api.g_miss_date
1648 , p5_a18 DATE := fnd_api.g_miss_date
1649 , p5_a19 DATE := fnd_api.g_miss_date
1650 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
1651 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
1652 , p5_a22 NUMBER := 0-1962.0724
1653 , p5_a23 NUMBER := 0-1962.0724
1654 , p5_a24 NUMBER := 0-1962.0724
1655 , p5_a25 NUMBER := 0-1962.0724
1656 , p5_a26 DATE := fnd_api.g_miss_date
1657 , p5_a27 DATE := fnd_api.g_miss_date
1658 , p5_a28 NUMBER := 0-1962.0724
1659 , p5_a29 NUMBER := 0-1962.0724
1660 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
1661 , p5_a31 DATE := fnd_api.g_miss_date
1662 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
1663 , p5_a33 NUMBER := 0-1962.0724
1664 , p5_a34 DATE := fnd_api.g_miss_date
1665 , p5_a35 NUMBER := 0-1962.0724
1666 , p5_a36 NUMBER := 0-1962.0724
1667 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
1668 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
1669 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
1670 , p5_a40 DATE := fnd_api.g_miss_date
1671 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
1672 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
1673 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
1674 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
1675 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
1676 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
1677 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
1678 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
1679 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
1680 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
1681 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
1682 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
1683 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
1684 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
1685 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
1686 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
1687 , p5_a57 DATE := fnd_api.g_miss_date
1688 , p5_a58 NUMBER := 0-1962.0724
1689 , p5_a59 NUMBER := 0-1962.0724
1690 , p5_a60 NUMBER := 0-1962.0724
1691 , p5_a61 NUMBER := 0-1962.0724
1692 , p5_a62 NUMBER := 0-1962.0724
1693 , p5_a63 DATE := fnd_api.g_miss_date
1694 , p5_a64 NUMBER := 0-1962.0724
1695 , p5_a65 DATE := fnd_api.g_miss_date
1696 , p5_a66 NUMBER := 0-1962.0724
1697 , p5_a67 DATE := fnd_api.g_miss_date
1698 , p5_a68 NUMBER := 0-1962.0724
1699 , p5_a69 NUMBER := 0-1962.0724
1700 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
1701 , p5_a71 NUMBER := 0-1962.0724
1702 , p5_a72 NUMBER := 0-1962.0724
1703 , p5_a73 NUMBER := 0-1962.0724
1704 , p5_a74 NUMBER := 0-1962.0724
1705 , p5_a75 NUMBER := 0-1962.0724
1706 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
1707 , p5_a77 VARCHAR2 := fnd_api.g_miss_char
1708 , p5_a78 VARCHAR2 := fnd_api.g_miss_char
1709 , p5_a79 NUMBER := 0-1962.0724
1710 , p5_a80 DATE := fnd_api.g_miss_date
1711 , p5_a81 NUMBER := 0-1962.0724
1712 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
1713 )
1714
1715 as
1716 ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
1717 ddx_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
1718 ddindx binary_integer; indx binary_integer;
1719 begin
1720
1721 -- copy data to the local IN or IN-OUT args, if any
1722
1723
1724
1725
1726
1727 ddp_qtev_rec.id := rosetta_g_miss_num_map(p5_a0);
1728 ddp_qtev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
1729 ddp_qtev_rec.sfwt_flag := p5_a2;
1730 ddp_qtev_rec.qrs_code := p5_a3;
1731 ddp_qtev_rec.qst_code := p5_a4;
1732 ddp_qtev_rec.qtp_code := p5_a5;
1733 ddp_qtev_rec.trn_code := p5_a6;
1734 ddp_qtev_rec.pop_code_end := p5_a7;
1735 ddp_qtev_rec.pop_code_early := p5_a8;
1736 ddp_qtev_rec.consolidated_qte_id := rosetta_g_miss_num_map(p5_a9);
1737 ddp_qtev_rec.khr_id := rosetta_g_miss_num_map(p5_a10);
1738 ddp_qtev_rec.art_id := rosetta_g_miss_num_map(p5_a11);
1739 ddp_qtev_rec.pdt_id := rosetta_g_miss_num_map(p5_a12);
1740 ddp_qtev_rec.early_termination_yn := p5_a13;
1741 ddp_qtev_rec.partial_yn := p5_a14;
1742 ddp_qtev_rec.preproceeds_yn := p5_a15;
1743 ddp_qtev_rec.date_requested := rosetta_g_miss_date_in_map(p5_a16);
1744 ddp_qtev_rec.date_proposal := rosetta_g_miss_date_in_map(p5_a17);
1745 ddp_qtev_rec.date_effective_to := rosetta_g_miss_date_in_map(p5_a18);
1746 ddp_qtev_rec.date_accepted := rosetta_g_miss_date_in_map(p5_a19);
1747 ddp_qtev_rec.summary_format_yn := p5_a20;
1748 ddp_qtev_rec.consolidated_yn := p5_a21;
1749 ddp_qtev_rec.principal_paydown_amount := rosetta_g_miss_num_map(p5_a22);
1750 ddp_qtev_rec.residual_amount := rosetta_g_miss_num_map(p5_a23);
1751 ddp_qtev_rec.yield := rosetta_g_miss_num_map(p5_a24);
1752 ddp_qtev_rec.rent_amount := rosetta_g_miss_num_map(p5_a25);
1753 ddp_qtev_rec.date_restructure_end := rosetta_g_miss_date_in_map(p5_a26);
1754 ddp_qtev_rec.date_restructure_start := rosetta_g_miss_date_in_map(p5_a27);
1755 ddp_qtev_rec.term := rosetta_g_miss_num_map(p5_a28);
1756 ddp_qtev_rec.purchase_percent := rosetta_g_miss_num_map(p5_a29);
1757 ddp_qtev_rec.comments := p5_a30;
1758 ddp_qtev_rec.date_due := rosetta_g_miss_date_in_map(p5_a31);
1759 ddp_qtev_rec.payment_frequency := p5_a32;
1760 ddp_qtev_rec.remaining_payments := rosetta_g_miss_num_map(p5_a33);
1761 ddp_qtev_rec.date_effective_from := rosetta_g_miss_date_in_map(p5_a34);
1762 ddp_qtev_rec.quote_number := rosetta_g_miss_num_map(p5_a35);
1763 ddp_qtev_rec.requested_by := rosetta_g_miss_num_map(p5_a36);
1764 ddp_qtev_rec.approved_yn := p5_a37;
1765 ddp_qtev_rec.accepted_yn := p5_a38;
1766 ddp_qtev_rec.payment_received_yn := p5_a39;
1767 ddp_qtev_rec.date_payment_received := rosetta_g_miss_date_in_map(p5_a40);
1768 ddp_qtev_rec.attribute_category := p5_a41;
1769 ddp_qtev_rec.attribute1 := p5_a42;
1770 ddp_qtev_rec.attribute2 := p5_a43;
1771 ddp_qtev_rec.attribute3 := p5_a44;
1772 ddp_qtev_rec.attribute4 := p5_a45;
1773 ddp_qtev_rec.attribute5 := p5_a46;
1774 ddp_qtev_rec.attribute6 := p5_a47;
1775 ddp_qtev_rec.attribute7 := p5_a48;
1776 ddp_qtev_rec.attribute8 := p5_a49;
1777 ddp_qtev_rec.attribute9 := p5_a50;
1778 ddp_qtev_rec.attribute10 := p5_a51;
1779 ddp_qtev_rec.attribute11 := p5_a52;
1780 ddp_qtev_rec.attribute12 := p5_a53;
1781 ddp_qtev_rec.attribute13 := p5_a54;
1782 ddp_qtev_rec.attribute14 := p5_a55;
1783 ddp_qtev_rec.attribute15 := p5_a56;
1784 ddp_qtev_rec.date_approved := rosetta_g_miss_date_in_map(p5_a57);
1785 ddp_qtev_rec.approved_by := rosetta_g_miss_num_map(p5_a58);
1786 ddp_qtev_rec.org_id := rosetta_g_miss_num_map(p5_a59);
1787 ddp_qtev_rec.request_id := rosetta_g_miss_num_map(p5_a60);
1788 ddp_qtev_rec.program_application_id := rosetta_g_miss_num_map(p5_a61);
1789 ddp_qtev_rec.program_id := rosetta_g_miss_num_map(p5_a62);
1790 ddp_qtev_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a63);
1791 ddp_qtev_rec.created_by := rosetta_g_miss_num_map(p5_a64);
1792 ddp_qtev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a65);
1793 ddp_qtev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a66);
1794 ddp_qtev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a67);
1795 ddp_qtev_rec.last_update_login := rosetta_g_miss_num_map(p5_a68);
1796 ddp_qtev_rec.purchase_amount := rosetta_g_miss_num_map(p5_a69);
1797 ddp_qtev_rec.purchase_formula := p5_a70;
1798 ddp_qtev_rec.asset_value := rosetta_g_miss_num_map(p5_a71);
1799 ddp_qtev_rec.residual_value := rosetta_g_miss_num_map(p5_a72);
1800 ddp_qtev_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a73);
1801 ddp_qtev_rec.gain_loss := rosetta_g_miss_num_map(p5_a74);
1802 ddp_qtev_rec.perdiem_amount := rosetta_g_miss_num_map(p5_a75);
1803 ddp_qtev_rec.currency_code := p5_a76;
1804 ddp_qtev_rec.currency_conversion_code := p5_a77;
1805 ddp_qtev_rec.currency_conversion_type := p5_a78;
1806 ddp_qtev_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a79);
1807 ddp_qtev_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a80);
1808 ddp_qtev_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
1809 ddp_qtev_rec.repo_quote_indicator_yn := p5_a82;
1810
1811
1812 -- here's the delegated call to the old PL/SQL routine
1813 okl_trx_quotes_pub.update_trx_quotes(p_api_version,
1814 p_init_msg_list,
1815 x_return_status,
1816 x_msg_count,
1817 x_msg_data,
1818 ddp_qtev_rec,
1819 ddx_qtev_rec);
1820
1821 -- copy data back from the local variables to OUT or IN-OUT args, if any
1822
1823
1824
1825
1826
1827
1828 p6_a0 := rosetta_g_miss_num_map(ddx_qtev_rec.id);
1829 p6_a1 := rosetta_g_miss_num_map(ddx_qtev_rec.object_version_number);
1830 p6_a2 := ddx_qtev_rec.sfwt_flag;
1831 p6_a3 := ddx_qtev_rec.qrs_code;
1832 p6_a4 := ddx_qtev_rec.qst_code;
1833 p6_a5 := ddx_qtev_rec.qtp_code;
1834 p6_a6 := ddx_qtev_rec.trn_code;
1835 p6_a7 := ddx_qtev_rec.pop_code_end;
1836 p6_a8 := ddx_qtev_rec.pop_code_early;
1837 p6_a9 := rosetta_g_miss_num_map(ddx_qtev_rec.consolidated_qte_id);
1838 p6_a10 := rosetta_g_miss_num_map(ddx_qtev_rec.khr_id);
1839 p6_a11 := rosetta_g_miss_num_map(ddx_qtev_rec.art_id);
1840 p6_a12 := rosetta_g_miss_num_map(ddx_qtev_rec.pdt_id);
1841 p6_a13 := ddx_qtev_rec.early_termination_yn;
1842 p6_a14 := ddx_qtev_rec.partial_yn;
1843 p6_a15 := ddx_qtev_rec.preproceeds_yn;
1844 p6_a16 := ddx_qtev_rec.date_requested;
1845 p6_a17 := ddx_qtev_rec.date_proposal;
1846 p6_a18 := ddx_qtev_rec.date_effective_to;
1847 p6_a19 := ddx_qtev_rec.date_accepted;
1848 p6_a20 := ddx_qtev_rec.summary_format_yn;
1849 p6_a21 := ddx_qtev_rec.consolidated_yn;
1850 p6_a22 := rosetta_g_miss_num_map(ddx_qtev_rec.principal_paydown_amount);
1851 p6_a23 := rosetta_g_miss_num_map(ddx_qtev_rec.residual_amount);
1852 p6_a24 := rosetta_g_miss_num_map(ddx_qtev_rec.yield);
1853 p6_a25 := rosetta_g_miss_num_map(ddx_qtev_rec.rent_amount);
1854 p6_a26 := ddx_qtev_rec.date_restructure_end;
1855 p6_a27 := ddx_qtev_rec.date_restructure_start;
1856 p6_a28 := rosetta_g_miss_num_map(ddx_qtev_rec.term);
1857 p6_a29 := rosetta_g_miss_num_map(ddx_qtev_rec.purchase_percent);
1858 p6_a30 := ddx_qtev_rec.comments;
1859 p6_a31 := ddx_qtev_rec.date_due;
1860 p6_a32 := ddx_qtev_rec.payment_frequency;
1861 p6_a33 := rosetta_g_miss_num_map(ddx_qtev_rec.remaining_payments);
1862 p6_a34 := ddx_qtev_rec.date_effective_from;
1863 p6_a35 := rosetta_g_miss_num_map(ddx_qtev_rec.quote_number);
1864 p6_a36 := rosetta_g_miss_num_map(ddx_qtev_rec.requested_by);
1865 p6_a37 := ddx_qtev_rec.approved_yn;
1866 p6_a38 := ddx_qtev_rec.accepted_yn;
1867 p6_a39 := ddx_qtev_rec.payment_received_yn;
1868 p6_a40 := ddx_qtev_rec.date_payment_received;
1869 p6_a41 := ddx_qtev_rec.attribute_category;
1870 p6_a42 := ddx_qtev_rec.attribute1;
1871 p6_a43 := ddx_qtev_rec.attribute2;
1872 p6_a44 := ddx_qtev_rec.attribute3;
1873 p6_a45 := ddx_qtev_rec.attribute4;
1874 p6_a46 := ddx_qtev_rec.attribute5;
1875 p6_a47 := ddx_qtev_rec.attribute6;
1876 p6_a48 := ddx_qtev_rec.attribute7;
1877 p6_a49 := ddx_qtev_rec.attribute8;
1878 p6_a50 := ddx_qtev_rec.attribute9;
1879 p6_a51 := ddx_qtev_rec.attribute10;
1880 p6_a52 := ddx_qtev_rec.attribute11;
1881 p6_a53 := ddx_qtev_rec.attribute12;
1882 p6_a54 := ddx_qtev_rec.attribute13;
1883 p6_a55 := ddx_qtev_rec.attribute14;
1884 p6_a56 := ddx_qtev_rec.attribute15;
1885 p6_a57 := ddx_qtev_rec.date_approved;
1886 p6_a58 := rosetta_g_miss_num_map(ddx_qtev_rec.approved_by);
1887 p6_a59 := rosetta_g_miss_num_map(ddx_qtev_rec.org_id);
1888 p6_a60 := rosetta_g_miss_num_map(ddx_qtev_rec.request_id);
1889 p6_a61 := rosetta_g_miss_num_map(ddx_qtev_rec.program_application_id);
1890 p6_a62 := rosetta_g_miss_num_map(ddx_qtev_rec.program_id);
1891 p6_a63 := ddx_qtev_rec.program_update_date;
1892 p6_a64 := rosetta_g_miss_num_map(ddx_qtev_rec.created_by);
1893 p6_a65 := ddx_qtev_rec.creation_date;
1894 p6_a66 := rosetta_g_miss_num_map(ddx_qtev_rec.last_updated_by);
1895 p6_a67 := ddx_qtev_rec.last_update_date;
1896 p6_a68 := rosetta_g_miss_num_map(ddx_qtev_rec.last_update_login);
1897 p6_a69 := rosetta_g_miss_num_map(ddx_qtev_rec.purchase_amount);
1898 p6_a70 := ddx_qtev_rec.purchase_formula;
1899 p6_a71 := rosetta_g_miss_num_map(ddx_qtev_rec.asset_value);
1900 p6_a72 := rosetta_g_miss_num_map(ddx_qtev_rec.residual_value);
1901 p6_a73 := rosetta_g_miss_num_map(ddx_qtev_rec.unbilled_receivables);
1902 p6_a74 := rosetta_g_miss_num_map(ddx_qtev_rec.gain_loss);
1903 p6_a75 := rosetta_g_miss_num_map(ddx_qtev_rec.perdiem_amount);
1904 p6_a76 := ddx_qtev_rec.currency_code;
1905 p6_a77 := ddx_qtev_rec.currency_conversion_code;
1906 p6_a78 := ddx_qtev_rec.currency_conversion_type;
1907 p6_a79 := rosetta_g_miss_num_map(ddx_qtev_rec.currency_conversion_rate);
1908 p6_a80 := ddx_qtev_rec.currency_conversion_date;
1909 p6_a81 := rosetta_g_miss_num_map(ddx_qtev_rec.legal_entity_id);
1910 p6_a82 := ddx_qtev_rec.repo_quote_indicator_yn;
1911 end;
1912
1913 procedure delete_trx_quotes(p_api_version NUMBER
1914 , p_init_msg_list VARCHAR2
1915 , x_return_status out nocopy VARCHAR2
1916 , x_msg_count out nocopy NUMBER
1917 , x_msg_data out nocopy VARCHAR2
1918 , p5_a0 JTF_NUMBER_TABLE
1919 , p5_a1 JTF_NUMBER_TABLE
1920 , p5_a2 JTF_VARCHAR2_TABLE_100
1921 , p5_a3 JTF_VARCHAR2_TABLE_100
1922 , p5_a4 JTF_VARCHAR2_TABLE_100
1923 , p5_a5 JTF_VARCHAR2_TABLE_100
1924 , p5_a6 JTF_VARCHAR2_TABLE_100
1925 , p5_a7 JTF_VARCHAR2_TABLE_100
1926 , p5_a8 JTF_VARCHAR2_TABLE_100
1927 , p5_a9 JTF_NUMBER_TABLE
1928 , p5_a10 JTF_NUMBER_TABLE
1929 , p5_a11 JTF_NUMBER_TABLE
1930 , p5_a12 JTF_NUMBER_TABLE
1931 , p5_a13 JTF_VARCHAR2_TABLE_100
1932 , p5_a14 JTF_VARCHAR2_TABLE_100
1933 , p5_a15 JTF_VARCHAR2_TABLE_100
1934 , p5_a16 JTF_DATE_TABLE
1935 , p5_a17 JTF_DATE_TABLE
1936 , p5_a18 JTF_DATE_TABLE
1937 , p5_a19 JTF_DATE_TABLE
1938 , p5_a20 JTF_VARCHAR2_TABLE_100
1939 , p5_a21 JTF_VARCHAR2_TABLE_100
1940 , p5_a22 JTF_NUMBER_TABLE
1941 , p5_a23 JTF_NUMBER_TABLE
1942 , p5_a24 JTF_NUMBER_TABLE
1943 , p5_a25 JTF_NUMBER_TABLE
1944 , p5_a26 JTF_DATE_TABLE
1945 , p5_a27 JTF_DATE_TABLE
1946 , p5_a28 JTF_NUMBER_TABLE
1947 , p5_a29 JTF_NUMBER_TABLE
1948 , p5_a30 JTF_VARCHAR2_TABLE_2000
1949 , p5_a31 JTF_DATE_TABLE
1950 , p5_a32 JTF_VARCHAR2_TABLE_100
1951 , p5_a33 JTF_NUMBER_TABLE
1952 , p5_a34 JTF_DATE_TABLE
1953 , p5_a35 JTF_NUMBER_TABLE
1954 , p5_a36 JTF_NUMBER_TABLE
1955 , p5_a37 JTF_VARCHAR2_TABLE_100
1956 , p5_a38 JTF_VARCHAR2_TABLE_100
1957 , p5_a39 JTF_VARCHAR2_TABLE_100
1958 , p5_a40 JTF_DATE_TABLE
1959 , p5_a41 JTF_VARCHAR2_TABLE_100
1960 , p5_a42 JTF_VARCHAR2_TABLE_500
1961 , p5_a43 JTF_VARCHAR2_TABLE_500
1962 , p5_a44 JTF_VARCHAR2_TABLE_500
1963 , p5_a45 JTF_VARCHAR2_TABLE_500
1964 , p5_a46 JTF_VARCHAR2_TABLE_500
1965 , p5_a47 JTF_VARCHAR2_TABLE_500
1966 , p5_a48 JTF_VARCHAR2_TABLE_500
1967 , p5_a49 JTF_VARCHAR2_TABLE_500
1968 , p5_a50 JTF_VARCHAR2_TABLE_500
1969 , p5_a51 JTF_VARCHAR2_TABLE_500
1970 , p5_a52 JTF_VARCHAR2_TABLE_500
1971 , p5_a53 JTF_VARCHAR2_TABLE_500
1972 , p5_a54 JTF_VARCHAR2_TABLE_500
1973 , p5_a55 JTF_VARCHAR2_TABLE_500
1974 , p5_a56 JTF_VARCHAR2_TABLE_500
1975 , p5_a57 JTF_DATE_TABLE
1976 , p5_a58 JTF_NUMBER_TABLE
1977 , p5_a59 JTF_NUMBER_TABLE
1978 , p5_a60 JTF_NUMBER_TABLE
1979 , p5_a61 JTF_NUMBER_TABLE
1980 , p5_a62 JTF_NUMBER_TABLE
1981 , p5_a63 JTF_DATE_TABLE
1982 , p5_a64 JTF_NUMBER_TABLE
1983 , p5_a65 JTF_DATE_TABLE
1984 , p5_a66 JTF_NUMBER_TABLE
1985 , p5_a67 JTF_DATE_TABLE
1986 , p5_a68 JTF_NUMBER_TABLE
1987 , p5_a69 JTF_NUMBER_TABLE
1988 , p5_a70 JTF_VARCHAR2_TABLE_200
1989 , p5_a71 JTF_NUMBER_TABLE
1990 , p5_a72 JTF_NUMBER_TABLE
1991 , p5_a73 JTF_NUMBER_TABLE
1992 , p5_a74 JTF_NUMBER_TABLE
1993 , p5_a75 JTF_NUMBER_TABLE
1994 , p5_a76 JTF_VARCHAR2_TABLE_100
1995 , p5_a77 JTF_VARCHAR2_TABLE_100
1996 , p5_a78 JTF_VARCHAR2_TABLE_100
1997 , p5_a79 JTF_NUMBER_TABLE
1998 , p5_a80 JTF_DATE_TABLE
1999 , p5_a81 JTF_NUMBER_TABLE
2000 , p5_a82 JTF_VARCHAR2_TABLE_100
2001 )
2002
2003 as
2004 ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
2005 ddindx binary_integer; indx binary_integer;
2006 begin
2007
2008 -- copy data to the local IN or IN-OUT args, if any
2009
2010
2011
2012
2013
2014 okl_qte_pvt_w.rosetta_table_copy_in_p8(ddp_qtev_tbl, p5_a0
2015 , p5_a1
2016 , p5_a2
2017 , p5_a3
2018 , p5_a4
2019 , p5_a5
2020 , p5_a6
2021 , p5_a7
2022 , p5_a8
2023 , p5_a9
2024 , p5_a10
2025 , p5_a11
2026 , p5_a12
2027 , p5_a13
2028 , p5_a14
2029 , p5_a15
2030 , p5_a16
2031 , p5_a17
2032 , p5_a18
2033 , p5_a19
2034 , p5_a20
2035 , p5_a21
2036 , p5_a22
2037 , p5_a23
2038 , p5_a24
2039 , p5_a25
2040 , p5_a26
2041 , p5_a27
2042 , p5_a28
2043 , p5_a29
2044 , p5_a30
2045 , p5_a31
2046 , p5_a32
2047 , p5_a33
2048 , p5_a34
2049 , p5_a35
2050 , p5_a36
2051 , p5_a37
2052 , p5_a38
2053 , p5_a39
2054 , p5_a40
2055 , p5_a41
2056 , p5_a42
2057 , p5_a43
2058 , p5_a44
2059 , p5_a45
2060 , p5_a46
2061 , p5_a47
2062 , p5_a48
2063 , p5_a49
2064 , p5_a50
2065 , p5_a51
2066 , p5_a52
2067 , p5_a53
2068 , p5_a54
2069 , p5_a55
2070 , p5_a56
2071 , p5_a57
2072 , p5_a58
2073 , p5_a59
2074 , p5_a60
2075 , p5_a61
2076 , p5_a62
2077 , p5_a63
2078 , p5_a64
2079 , p5_a65
2080 , p5_a66
2081 , p5_a67
2082 , p5_a68
2083 , p5_a69
2084 , p5_a70
2085 , p5_a71
2086 , p5_a72
2087 , p5_a73
2088 , p5_a74
2089 , p5_a75
2090 , p5_a76
2091 , p5_a77
2092 , p5_a78
2093 , p5_a79
2094 , p5_a80
2095 , p5_a81
2096 , p5_a82
2097 );
2098
2099 -- here's the delegated call to the old PL/SQL routine
2100 okl_trx_quotes_pub.delete_trx_quotes(p_api_version,
2101 p_init_msg_list,
2102 x_return_status,
2103 x_msg_count,
2104 x_msg_data,
2105 ddp_qtev_tbl);
2106
2107 -- copy data back from the local variables to OUT or IN-OUT args, if any
2108
2109
2110
2111
2112
2113 end;
2114
2115 procedure delete_trx_quotes(p_api_version NUMBER
2116 , p_init_msg_list VARCHAR2
2117 , x_return_status out nocopy VARCHAR2
2118 , x_msg_count out nocopy NUMBER
2119 , x_msg_data out nocopy VARCHAR2
2120 , p5_a0 NUMBER := 0-1962.0724
2121 , p5_a1 NUMBER := 0-1962.0724
2122 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2123 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2124 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2125 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2126 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2127 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2128 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2129 , p5_a9 NUMBER := 0-1962.0724
2130 , p5_a10 NUMBER := 0-1962.0724
2131 , p5_a11 NUMBER := 0-1962.0724
2132 , p5_a12 NUMBER := 0-1962.0724
2133 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2134 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2135 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2136 , p5_a16 DATE := fnd_api.g_miss_date
2137 , p5_a17 DATE := fnd_api.g_miss_date
2138 , p5_a18 DATE := fnd_api.g_miss_date
2139 , p5_a19 DATE := fnd_api.g_miss_date
2140 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2141 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2142 , p5_a22 NUMBER := 0-1962.0724
2143 , p5_a23 NUMBER := 0-1962.0724
2144 , p5_a24 NUMBER := 0-1962.0724
2145 , p5_a25 NUMBER := 0-1962.0724
2146 , p5_a26 DATE := fnd_api.g_miss_date
2147 , p5_a27 DATE := fnd_api.g_miss_date
2148 , p5_a28 NUMBER := 0-1962.0724
2149 , p5_a29 NUMBER := 0-1962.0724
2150 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2151 , p5_a31 DATE := fnd_api.g_miss_date
2152 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2153 , p5_a33 NUMBER := 0-1962.0724
2154 , p5_a34 DATE := fnd_api.g_miss_date
2155 , p5_a35 NUMBER := 0-1962.0724
2156 , p5_a36 NUMBER := 0-1962.0724
2157 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2158 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2159 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2160 , p5_a40 DATE := fnd_api.g_miss_date
2161 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2162 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2163 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
2164 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
2165 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
2166 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
2167 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
2168 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2169 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
2170 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
2171 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
2172 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
2173 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
2174 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
2175 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
2176 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
2177 , p5_a57 DATE := fnd_api.g_miss_date
2178 , p5_a58 NUMBER := 0-1962.0724
2179 , p5_a59 NUMBER := 0-1962.0724
2180 , p5_a60 NUMBER := 0-1962.0724
2181 , p5_a61 NUMBER := 0-1962.0724
2182 , p5_a62 NUMBER := 0-1962.0724
2183 , p5_a63 DATE := fnd_api.g_miss_date
2184 , p5_a64 NUMBER := 0-1962.0724
2185 , p5_a65 DATE := fnd_api.g_miss_date
2186 , p5_a66 NUMBER := 0-1962.0724
2187 , p5_a67 DATE := fnd_api.g_miss_date
2188 , p5_a68 NUMBER := 0-1962.0724
2189 , p5_a69 NUMBER := 0-1962.0724
2190 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
2191 , p5_a71 NUMBER := 0-1962.0724
2192 , p5_a72 NUMBER := 0-1962.0724
2193 , p5_a73 NUMBER := 0-1962.0724
2194 , p5_a74 NUMBER := 0-1962.0724
2195 , p5_a75 NUMBER := 0-1962.0724
2196 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
2197 , p5_a77 VARCHAR2 := fnd_api.g_miss_char
2198 , p5_a78 VARCHAR2 := fnd_api.g_miss_char
2199 , p5_a79 NUMBER := 0-1962.0724
2200 , p5_a80 DATE := fnd_api.g_miss_date
2201 , p5_a81 NUMBER := 0-1962.0724
2202 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
2203 )
2204
2205 as
2206 ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
2207 ddindx binary_integer; indx binary_integer;
2208 begin
2209
2210 -- copy data to the local IN or IN-OUT args, if any
2211
2212
2213
2214
2215
2216 ddp_qtev_rec.id := rosetta_g_miss_num_map(p5_a0);
2217 ddp_qtev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2218 ddp_qtev_rec.sfwt_flag := p5_a2;
2219 ddp_qtev_rec.qrs_code := p5_a3;
2220 ddp_qtev_rec.qst_code := p5_a4;
2221 ddp_qtev_rec.qtp_code := p5_a5;
2222 ddp_qtev_rec.trn_code := p5_a6;
2223 ddp_qtev_rec.pop_code_end := p5_a7;
2224 ddp_qtev_rec.pop_code_early := p5_a8;
2225 ddp_qtev_rec.consolidated_qte_id := rosetta_g_miss_num_map(p5_a9);
2226 ddp_qtev_rec.khr_id := rosetta_g_miss_num_map(p5_a10);
2227 ddp_qtev_rec.art_id := rosetta_g_miss_num_map(p5_a11);
2228 ddp_qtev_rec.pdt_id := rosetta_g_miss_num_map(p5_a12);
2229 ddp_qtev_rec.early_termination_yn := p5_a13;
2230 ddp_qtev_rec.partial_yn := p5_a14;
2231 ddp_qtev_rec.preproceeds_yn := p5_a15;
2232 ddp_qtev_rec.date_requested := rosetta_g_miss_date_in_map(p5_a16);
2233 ddp_qtev_rec.date_proposal := rosetta_g_miss_date_in_map(p5_a17);
2234 ddp_qtev_rec.date_effective_to := rosetta_g_miss_date_in_map(p5_a18);
2235 ddp_qtev_rec.date_accepted := rosetta_g_miss_date_in_map(p5_a19);
2236 ddp_qtev_rec.summary_format_yn := p5_a20;
2237 ddp_qtev_rec.consolidated_yn := p5_a21;
2238 ddp_qtev_rec.principal_paydown_amount := rosetta_g_miss_num_map(p5_a22);
2239 ddp_qtev_rec.residual_amount := rosetta_g_miss_num_map(p5_a23);
2240 ddp_qtev_rec.yield := rosetta_g_miss_num_map(p5_a24);
2241 ddp_qtev_rec.rent_amount := rosetta_g_miss_num_map(p5_a25);
2242 ddp_qtev_rec.date_restructure_end := rosetta_g_miss_date_in_map(p5_a26);
2243 ddp_qtev_rec.date_restructure_start := rosetta_g_miss_date_in_map(p5_a27);
2244 ddp_qtev_rec.term := rosetta_g_miss_num_map(p5_a28);
2245 ddp_qtev_rec.purchase_percent := rosetta_g_miss_num_map(p5_a29);
2246 ddp_qtev_rec.comments := p5_a30;
2247 ddp_qtev_rec.date_due := rosetta_g_miss_date_in_map(p5_a31);
2248 ddp_qtev_rec.payment_frequency := p5_a32;
2249 ddp_qtev_rec.remaining_payments := rosetta_g_miss_num_map(p5_a33);
2250 ddp_qtev_rec.date_effective_from := rosetta_g_miss_date_in_map(p5_a34);
2251 ddp_qtev_rec.quote_number := rosetta_g_miss_num_map(p5_a35);
2252 ddp_qtev_rec.requested_by := rosetta_g_miss_num_map(p5_a36);
2253 ddp_qtev_rec.approved_yn := p5_a37;
2254 ddp_qtev_rec.accepted_yn := p5_a38;
2255 ddp_qtev_rec.payment_received_yn := p5_a39;
2256 ddp_qtev_rec.date_payment_received := rosetta_g_miss_date_in_map(p5_a40);
2257 ddp_qtev_rec.attribute_category := p5_a41;
2258 ddp_qtev_rec.attribute1 := p5_a42;
2259 ddp_qtev_rec.attribute2 := p5_a43;
2260 ddp_qtev_rec.attribute3 := p5_a44;
2261 ddp_qtev_rec.attribute4 := p5_a45;
2262 ddp_qtev_rec.attribute5 := p5_a46;
2263 ddp_qtev_rec.attribute6 := p5_a47;
2264 ddp_qtev_rec.attribute7 := p5_a48;
2265 ddp_qtev_rec.attribute8 := p5_a49;
2266 ddp_qtev_rec.attribute9 := p5_a50;
2267 ddp_qtev_rec.attribute10 := p5_a51;
2268 ddp_qtev_rec.attribute11 := p5_a52;
2269 ddp_qtev_rec.attribute12 := p5_a53;
2270 ddp_qtev_rec.attribute13 := p5_a54;
2271 ddp_qtev_rec.attribute14 := p5_a55;
2272 ddp_qtev_rec.attribute15 := p5_a56;
2273 ddp_qtev_rec.date_approved := rosetta_g_miss_date_in_map(p5_a57);
2274 ddp_qtev_rec.approved_by := rosetta_g_miss_num_map(p5_a58);
2275 ddp_qtev_rec.org_id := rosetta_g_miss_num_map(p5_a59);
2276 ddp_qtev_rec.request_id := rosetta_g_miss_num_map(p5_a60);
2277 ddp_qtev_rec.program_application_id := rosetta_g_miss_num_map(p5_a61);
2278 ddp_qtev_rec.program_id := rosetta_g_miss_num_map(p5_a62);
2279 ddp_qtev_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a63);
2280 ddp_qtev_rec.created_by := rosetta_g_miss_num_map(p5_a64);
2281 ddp_qtev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a65);
2282 ddp_qtev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a66);
2283 ddp_qtev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a67);
2284 ddp_qtev_rec.last_update_login := rosetta_g_miss_num_map(p5_a68);
2285 ddp_qtev_rec.purchase_amount := rosetta_g_miss_num_map(p5_a69);
2286 ddp_qtev_rec.purchase_formula := p5_a70;
2287 ddp_qtev_rec.asset_value := rosetta_g_miss_num_map(p5_a71);
2288 ddp_qtev_rec.residual_value := rosetta_g_miss_num_map(p5_a72);
2289 ddp_qtev_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a73);
2290 ddp_qtev_rec.gain_loss := rosetta_g_miss_num_map(p5_a74);
2291 ddp_qtev_rec.perdiem_amount := rosetta_g_miss_num_map(p5_a75);
2292 ddp_qtev_rec.currency_code := p5_a76;
2293 ddp_qtev_rec.currency_conversion_code := p5_a77;
2294 ddp_qtev_rec.currency_conversion_type := p5_a78;
2295 ddp_qtev_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a79);
2296 ddp_qtev_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a80);
2297 ddp_qtev_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
2298 ddp_qtev_rec.repo_quote_indicator_yn := p5_a82;
2299
2300 -- here's the delegated call to the old PL/SQL routine
2301 okl_trx_quotes_pub.delete_trx_quotes(p_api_version,
2302 p_init_msg_list,
2303 x_return_status,
2304 x_msg_count,
2305 x_msg_data,
2306 ddp_qtev_rec);
2307
2308 -- copy data back from the local variables to OUT or IN-OUT args, if any
2309
2310
2311
2312
2313
2314 end;
2315
2316 procedure validate_trx_quotes(p_api_version NUMBER
2317 , p_init_msg_list VARCHAR2
2318 , x_return_status out nocopy VARCHAR2
2319 , x_msg_count out nocopy NUMBER
2320 , x_msg_data out nocopy VARCHAR2
2321 , p5_a0 JTF_NUMBER_TABLE
2322 , p5_a1 JTF_NUMBER_TABLE
2323 , p5_a2 JTF_VARCHAR2_TABLE_100
2324 , p5_a3 JTF_VARCHAR2_TABLE_100
2325 , p5_a4 JTF_VARCHAR2_TABLE_100
2326 , p5_a5 JTF_VARCHAR2_TABLE_100
2327 , p5_a6 JTF_VARCHAR2_TABLE_100
2328 , p5_a7 JTF_VARCHAR2_TABLE_100
2329 , p5_a8 JTF_VARCHAR2_TABLE_100
2330 , p5_a9 JTF_NUMBER_TABLE
2331 , p5_a10 JTF_NUMBER_TABLE
2332 , p5_a11 JTF_NUMBER_TABLE
2333 , p5_a12 JTF_NUMBER_TABLE
2334 , p5_a13 JTF_VARCHAR2_TABLE_100
2335 , p5_a14 JTF_VARCHAR2_TABLE_100
2336 , p5_a15 JTF_VARCHAR2_TABLE_100
2337 , p5_a16 JTF_DATE_TABLE
2338 , p5_a17 JTF_DATE_TABLE
2339 , p5_a18 JTF_DATE_TABLE
2340 , p5_a19 JTF_DATE_TABLE
2341 , p5_a20 JTF_VARCHAR2_TABLE_100
2342 , p5_a21 JTF_VARCHAR2_TABLE_100
2343 , p5_a22 JTF_NUMBER_TABLE
2344 , p5_a23 JTF_NUMBER_TABLE
2345 , p5_a24 JTF_NUMBER_TABLE
2346 , p5_a25 JTF_NUMBER_TABLE
2347 , p5_a26 JTF_DATE_TABLE
2348 , p5_a27 JTF_DATE_TABLE
2349 , p5_a28 JTF_NUMBER_TABLE
2350 , p5_a29 JTF_NUMBER_TABLE
2351 , p5_a30 JTF_VARCHAR2_TABLE_2000
2352 , p5_a31 JTF_DATE_TABLE
2353 , p5_a32 JTF_VARCHAR2_TABLE_100
2354 , p5_a33 JTF_NUMBER_TABLE
2355 , p5_a34 JTF_DATE_TABLE
2356 , p5_a35 JTF_NUMBER_TABLE
2357 , p5_a36 JTF_NUMBER_TABLE
2358 , p5_a37 JTF_VARCHAR2_TABLE_100
2359 , p5_a38 JTF_VARCHAR2_TABLE_100
2360 , p5_a39 JTF_VARCHAR2_TABLE_100
2361 , p5_a40 JTF_DATE_TABLE
2362 , p5_a41 JTF_VARCHAR2_TABLE_100
2363 , p5_a42 JTF_VARCHAR2_TABLE_500
2364 , p5_a43 JTF_VARCHAR2_TABLE_500
2365 , p5_a44 JTF_VARCHAR2_TABLE_500
2366 , p5_a45 JTF_VARCHAR2_TABLE_500
2367 , p5_a46 JTF_VARCHAR2_TABLE_500
2368 , p5_a47 JTF_VARCHAR2_TABLE_500
2369 , p5_a48 JTF_VARCHAR2_TABLE_500
2370 , p5_a49 JTF_VARCHAR2_TABLE_500
2371 , p5_a50 JTF_VARCHAR2_TABLE_500
2372 , p5_a51 JTF_VARCHAR2_TABLE_500
2373 , p5_a52 JTF_VARCHAR2_TABLE_500
2374 , p5_a53 JTF_VARCHAR2_TABLE_500
2375 , p5_a54 JTF_VARCHAR2_TABLE_500
2376 , p5_a55 JTF_VARCHAR2_TABLE_500
2377 , p5_a56 JTF_VARCHAR2_TABLE_500
2378 , p5_a57 JTF_DATE_TABLE
2379 , p5_a58 JTF_NUMBER_TABLE
2380 , p5_a59 JTF_NUMBER_TABLE
2381 , p5_a60 JTF_NUMBER_TABLE
2382 , p5_a61 JTF_NUMBER_TABLE
2383 , p5_a62 JTF_NUMBER_TABLE
2384 , p5_a63 JTF_DATE_TABLE
2385 , p5_a64 JTF_NUMBER_TABLE
2386 , p5_a65 JTF_DATE_TABLE
2387 , p5_a66 JTF_NUMBER_TABLE
2388 , p5_a67 JTF_DATE_TABLE
2389 , p5_a68 JTF_NUMBER_TABLE
2390 , p5_a69 JTF_NUMBER_TABLE
2391 , p5_a70 JTF_VARCHAR2_TABLE_200
2392 , p5_a71 JTF_NUMBER_TABLE
2393 , p5_a72 JTF_NUMBER_TABLE
2394 , p5_a73 JTF_NUMBER_TABLE
2395 , p5_a74 JTF_NUMBER_TABLE
2396 , p5_a75 JTF_NUMBER_TABLE
2397 , p5_a76 JTF_VARCHAR2_TABLE_100
2398 , p5_a77 JTF_VARCHAR2_TABLE_100
2399 , p5_a78 JTF_VARCHAR2_TABLE_100
2400 , p5_a79 JTF_NUMBER_TABLE
2401 , p5_a80 JTF_DATE_TABLE
2402 , p5_a81 JTF_NUMBER_TABLE
2403 , p5_a82 JTF_VARCHAR2_TABLE_100
2404 )
2405
2406 as
2407 ddp_qtev_tbl okl_trx_quotes_pub.qtev_tbl_type;
2408 ddindx binary_integer; indx binary_integer;
2409 begin
2410
2411 -- copy data to the local IN or IN-OUT args, if any
2412
2413
2414
2415
2416
2417 okl_qte_pvt_w.rosetta_table_copy_in_p8(ddp_qtev_tbl, p5_a0
2418 , p5_a1
2419 , p5_a2
2420 , p5_a3
2421 , p5_a4
2422 , p5_a5
2423 , p5_a6
2424 , p5_a7
2425 , p5_a8
2426 , p5_a9
2427 , p5_a10
2428 , p5_a11
2429 , p5_a12
2430 , p5_a13
2431 , p5_a14
2432 , p5_a15
2433 , p5_a16
2434 , p5_a17
2435 , p5_a18
2436 , p5_a19
2437 , p5_a20
2438 , p5_a21
2439 , p5_a22
2440 , p5_a23
2441 , p5_a24
2442 , p5_a25
2443 , p5_a26
2444 , p5_a27
2445 , p5_a28
2446 , p5_a29
2447 , p5_a30
2448 , p5_a31
2449 , p5_a32
2450 , p5_a33
2451 , p5_a34
2452 , p5_a35
2453 , p5_a36
2454 , p5_a37
2455 , p5_a38
2456 , p5_a39
2457 , p5_a40
2458 , p5_a41
2459 , p5_a42
2460 , p5_a43
2461 , p5_a44
2462 , p5_a45
2463 , p5_a46
2464 , p5_a47
2465 , p5_a48
2466 , p5_a49
2467 , p5_a50
2468 , p5_a51
2469 , p5_a52
2470 , p5_a53
2471 , p5_a54
2472 , p5_a55
2473 , p5_a56
2474 , p5_a57
2475 , p5_a58
2476 , p5_a59
2477 , p5_a60
2478 , p5_a61
2479 , p5_a62
2480 , p5_a63
2481 , p5_a64
2482 , p5_a65
2483 , p5_a66
2484 , p5_a67
2485 , p5_a68
2486 , p5_a69
2487 , p5_a70
2488 , p5_a71
2489 , p5_a72
2490 , p5_a73
2491 , p5_a74
2492 , p5_a75
2493 , p5_a76
2494 , p5_a77
2495 , p5_a78
2496 , p5_a79
2497 , p5_a80
2498 , p5_a81
2499 , p5_a82
2500 );
2501
2502 -- here's the delegated call to the old PL/SQL routine
2503 okl_trx_quotes_pub.validate_trx_quotes(p_api_version,
2504 p_init_msg_list,
2505 x_return_status,
2506 x_msg_count,
2507 x_msg_data,
2508 ddp_qtev_tbl);
2509
2510 -- copy data back from the local variables to OUT or IN-OUT args, if any
2511
2512
2513
2514
2515
2516 end;
2517
2518 procedure validate_trx_quotes(p_api_version NUMBER
2519 , p_init_msg_list VARCHAR2
2520 , x_return_status out nocopy VARCHAR2
2521 , x_msg_count out nocopy NUMBER
2522 , x_msg_data out nocopy VARCHAR2
2523 , p5_a0 NUMBER := 0-1962.0724
2524 , p5_a1 NUMBER := 0-1962.0724
2525 , p5_a2 VARCHAR2 := fnd_api.g_miss_char
2526 , p5_a3 VARCHAR2 := fnd_api.g_miss_char
2527 , p5_a4 VARCHAR2 := fnd_api.g_miss_char
2528 , p5_a5 VARCHAR2 := fnd_api.g_miss_char
2529 , p5_a6 VARCHAR2 := fnd_api.g_miss_char
2530 , p5_a7 VARCHAR2 := fnd_api.g_miss_char
2531 , p5_a8 VARCHAR2 := fnd_api.g_miss_char
2532 , p5_a9 NUMBER := 0-1962.0724
2533 , p5_a10 NUMBER := 0-1962.0724
2534 , p5_a11 NUMBER := 0-1962.0724
2535 , p5_a12 NUMBER := 0-1962.0724
2536 , p5_a13 VARCHAR2 := fnd_api.g_miss_char
2537 , p5_a14 VARCHAR2 := fnd_api.g_miss_char
2538 , p5_a15 VARCHAR2 := fnd_api.g_miss_char
2539 , p5_a16 DATE := fnd_api.g_miss_date
2540 , p5_a17 DATE := fnd_api.g_miss_date
2541 , p5_a18 DATE := fnd_api.g_miss_date
2542 , p5_a19 DATE := fnd_api.g_miss_date
2543 , p5_a20 VARCHAR2 := fnd_api.g_miss_char
2544 , p5_a21 VARCHAR2 := fnd_api.g_miss_char
2545 , p5_a22 NUMBER := 0-1962.0724
2546 , p5_a23 NUMBER := 0-1962.0724
2547 , p5_a24 NUMBER := 0-1962.0724
2548 , p5_a25 NUMBER := 0-1962.0724
2549 , p5_a26 DATE := fnd_api.g_miss_date
2550 , p5_a27 DATE := fnd_api.g_miss_date
2551 , p5_a28 NUMBER := 0-1962.0724
2552 , p5_a29 NUMBER := 0-1962.0724
2553 , p5_a30 VARCHAR2 := fnd_api.g_miss_char
2554 , p5_a31 DATE := fnd_api.g_miss_date
2555 , p5_a32 VARCHAR2 := fnd_api.g_miss_char
2556 , p5_a33 NUMBER := 0-1962.0724
2557 , p5_a34 DATE := fnd_api.g_miss_date
2558 , p5_a35 NUMBER := 0-1962.0724
2559 , p5_a36 NUMBER := 0-1962.0724
2560 , p5_a37 VARCHAR2 := fnd_api.g_miss_char
2561 , p5_a38 VARCHAR2 := fnd_api.g_miss_char
2562 , p5_a39 VARCHAR2 := fnd_api.g_miss_char
2563 , p5_a40 DATE := fnd_api.g_miss_date
2564 , p5_a41 VARCHAR2 := fnd_api.g_miss_char
2565 , p5_a42 VARCHAR2 := fnd_api.g_miss_char
2566 , p5_a43 VARCHAR2 := fnd_api.g_miss_char
2567 , p5_a44 VARCHAR2 := fnd_api.g_miss_char
2568 , p5_a45 VARCHAR2 := fnd_api.g_miss_char
2569 , p5_a46 VARCHAR2 := fnd_api.g_miss_char
2570 , p5_a47 VARCHAR2 := fnd_api.g_miss_char
2571 , p5_a48 VARCHAR2 := fnd_api.g_miss_char
2572 , p5_a49 VARCHAR2 := fnd_api.g_miss_char
2573 , p5_a50 VARCHAR2 := fnd_api.g_miss_char
2574 , p5_a51 VARCHAR2 := fnd_api.g_miss_char
2575 , p5_a52 VARCHAR2 := fnd_api.g_miss_char
2576 , p5_a53 VARCHAR2 := fnd_api.g_miss_char
2577 , p5_a54 VARCHAR2 := fnd_api.g_miss_char
2578 , p5_a55 VARCHAR2 := fnd_api.g_miss_char
2579 , p5_a56 VARCHAR2 := fnd_api.g_miss_char
2580 , p5_a57 DATE := fnd_api.g_miss_date
2581 , p5_a58 NUMBER := 0-1962.0724
2582 , p5_a59 NUMBER := 0-1962.0724
2583 , p5_a60 NUMBER := 0-1962.0724
2584 , p5_a61 NUMBER := 0-1962.0724
2585 , p5_a62 NUMBER := 0-1962.0724
2586 , p5_a63 DATE := fnd_api.g_miss_date
2587 , p5_a64 NUMBER := 0-1962.0724
2588 , p5_a65 DATE := fnd_api.g_miss_date
2589 , p5_a66 NUMBER := 0-1962.0724
2590 , p5_a67 DATE := fnd_api.g_miss_date
2591 , p5_a68 NUMBER := 0-1962.0724
2592 , p5_a69 NUMBER := 0-1962.0724
2593 , p5_a70 VARCHAR2 := fnd_api.g_miss_char
2594 , p5_a71 NUMBER := 0-1962.0724
2595 , p5_a72 NUMBER := 0-1962.0724
2596 , p5_a73 NUMBER := 0-1962.0724
2597 , p5_a74 NUMBER := 0-1962.0724
2598 , p5_a75 NUMBER := 0-1962.0724
2599 , p5_a76 VARCHAR2 := fnd_api.g_miss_char
2600 , p5_a77 VARCHAR2 := fnd_api.g_miss_char
2601 , p5_a78 VARCHAR2 := fnd_api.g_miss_char
2602 , p5_a79 NUMBER := 0-1962.0724
2603 , p5_a80 DATE := fnd_api.g_miss_date
2604 , p5_a81 NUMBER := 0-1962.0724
2605 , p5_a82 VARCHAR2 := fnd_api.g_miss_char
2606 )
2607
2608 as
2609 ddp_qtev_rec okl_trx_quotes_pub.qtev_rec_type;
2610 ddindx binary_integer; indx binary_integer;
2611 begin
2612
2613 -- copy data to the local IN or IN-OUT args, if any
2614
2615
2616
2617
2618
2619 ddp_qtev_rec.id := rosetta_g_miss_num_map(p5_a0);
2620 ddp_qtev_rec.object_version_number := rosetta_g_miss_num_map(p5_a1);
2621 ddp_qtev_rec.sfwt_flag := p5_a2;
2622 ddp_qtev_rec.qrs_code := p5_a3;
2623 ddp_qtev_rec.qst_code := p5_a4;
2624 ddp_qtev_rec.qtp_code := p5_a5;
2625 ddp_qtev_rec.trn_code := p5_a6;
2626 ddp_qtev_rec.pop_code_end := p5_a7;
2627 ddp_qtev_rec.pop_code_early := p5_a8;
2628 ddp_qtev_rec.consolidated_qte_id := rosetta_g_miss_num_map(p5_a9);
2629 ddp_qtev_rec.khr_id := rosetta_g_miss_num_map(p5_a10);
2630 ddp_qtev_rec.art_id := rosetta_g_miss_num_map(p5_a11);
2631 ddp_qtev_rec.pdt_id := rosetta_g_miss_num_map(p5_a12);
2632 ddp_qtev_rec.early_termination_yn := p5_a13;
2633 ddp_qtev_rec.partial_yn := p5_a14;
2634 ddp_qtev_rec.preproceeds_yn := p5_a15;
2635 ddp_qtev_rec.date_requested := rosetta_g_miss_date_in_map(p5_a16);
2636 ddp_qtev_rec.date_proposal := rosetta_g_miss_date_in_map(p5_a17);
2637 ddp_qtev_rec.date_effective_to := rosetta_g_miss_date_in_map(p5_a18);
2638 ddp_qtev_rec.date_accepted := rosetta_g_miss_date_in_map(p5_a19);
2639 ddp_qtev_rec.summary_format_yn := p5_a20;
2640 ddp_qtev_rec.consolidated_yn := p5_a21;
2641 ddp_qtev_rec.principal_paydown_amount := rosetta_g_miss_num_map(p5_a22);
2642 ddp_qtev_rec.residual_amount := rosetta_g_miss_num_map(p5_a23);
2643 ddp_qtev_rec.yield := rosetta_g_miss_num_map(p5_a24);
2644 ddp_qtev_rec.rent_amount := rosetta_g_miss_num_map(p5_a25);
2645 ddp_qtev_rec.date_restructure_end := rosetta_g_miss_date_in_map(p5_a26);
2646 ddp_qtev_rec.date_restructure_start := rosetta_g_miss_date_in_map(p5_a27);
2647 ddp_qtev_rec.term := rosetta_g_miss_num_map(p5_a28);
2648 ddp_qtev_rec.purchase_percent := rosetta_g_miss_num_map(p5_a29);
2649 ddp_qtev_rec.comments := p5_a30;
2650 ddp_qtev_rec.date_due := rosetta_g_miss_date_in_map(p5_a31);
2651 ddp_qtev_rec.payment_frequency := p5_a32;
2652 ddp_qtev_rec.remaining_payments := rosetta_g_miss_num_map(p5_a33);
2653 ddp_qtev_rec.date_effective_from := rosetta_g_miss_date_in_map(p5_a34);
2654 ddp_qtev_rec.quote_number := rosetta_g_miss_num_map(p5_a35);
2655 ddp_qtev_rec.requested_by := rosetta_g_miss_num_map(p5_a36);
2656 ddp_qtev_rec.approved_yn := p5_a37;
2657 ddp_qtev_rec.accepted_yn := p5_a38;
2658 ddp_qtev_rec.payment_received_yn := p5_a39;
2659 ddp_qtev_rec.date_payment_received := rosetta_g_miss_date_in_map(p5_a40);
2660 ddp_qtev_rec.attribute_category := p5_a41;
2661 ddp_qtev_rec.attribute1 := p5_a42;
2662 ddp_qtev_rec.attribute2 := p5_a43;
2663 ddp_qtev_rec.attribute3 := p5_a44;
2664 ddp_qtev_rec.attribute4 := p5_a45;
2665 ddp_qtev_rec.attribute5 := p5_a46;
2666 ddp_qtev_rec.attribute6 := p5_a47;
2667 ddp_qtev_rec.attribute7 := p5_a48;
2668 ddp_qtev_rec.attribute8 := p5_a49;
2669 ddp_qtev_rec.attribute9 := p5_a50;
2670 ddp_qtev_rec.attribute10 := p5_a51;
2671 ddp_qtev_rec.attribute11 := p5_a52;
2672 ddp_qtev_rec.attribute12 := p5_a53;
2673 ddp_qtev_rec.attribute13 := p5_a54;
2674 ddp_qtev_rec.attribute14 := p5_a55;
2675 ddp_qtev_rec.attribute15 := p5_a56;
2676 ddp_qtev_rec.date_approved := rosetta_g_miss_date_in_map(p5_a57);
2677 ddp_qtev_rec.approved_by := rosetta_g_miss_num_map(p5_a58);
2678 ddp_qtev_rec.org_id := rosetta_g_miss_num_map(p5_a59);
2679 ddp_qtev_rec.request_id := rosetta_g_miss_num_map(p5_a60);
2680 ddp_qtev_rec.program_application_id := rosetta_g_miss_num_map(p5_a61);
2681 ddp_qtev_rec.program_id := rosetta_g_miss_num_map(p5_a62);
2682 ddp_qtev_rec.program_update_date := rosetta_g_miss_date_in_map(p5_a63);
2683 ddp_qtev_rec.created_by := rosetta_g_miss_num_map(p5_a64);
2684 ddp_qtev_rec.creation_date := rosetta_g_miss_date_in_map(p5_a65);
2685 ddp_qtev_rec.last_updated_by := rosetta_g_miss_num_map(p5_a66);
2686 ddp_qtev_rec.last_update_date := rosetta_g_miss_date_in_map(p5_a67);
2687 ddp_qtev_rec.last_update_login := rosetta_g_miss_num_map(p5_a68);
2688 ddp_qtev_rec.purchase_amount := rosetta_g_miss_num_map(p5_a69);
2689 ddp_qtev_rec.purchase_formula := p5_a70;
2690 ddp_qtev_rec.asset_value := rosetta_g_miss_num_map(p5_a71);
2691 ddp_qtev_rec.residual_value := rosetta_g_miss_num_map(p5_a72);
2692 ddp_qtev_rec.unbilled_receivables := rosetta_g_miss_num_map(p5_a73);
2693 ddp_qtev_rec.gain_loss := rosetta_g_miss_num_map(p5_a74);
2694 ddp_qtev_rec.perdiem_amount := rosetta_g_miss_num_map(p5_a75);
2695 ddp_qtev_rec.currency_code := p5_a76;
2696 ddp_qtev_rec.currency_conversion_code := p5_a77;
2697 ddp_qtev_rec.currency_conversion_type := p5_a78;
2698 ddp_qtev_rec.currency_conversion_rate := rosetta_g_miss_num_map(p5_a79);
2699 ddp_qtev_rec.currency_conversion_date := rosetta_g_miss_date_in_map(p5_a80);
2700 ddp_qtev_rec.legal_entity_id := rosetta_g_miss_num_map(p5_a81);
2701 ddp_qtev_rec.repo_quote_indicator_yn := p5_a82;
2702
2703 -- here's the delegated call to the old PL/SQL routine
2704 okl_trx_quotes_pub.validate_trx_quotes(p_api_version,
2705 p_init_msg_list,
2706 x_return_status,
2707 x_msg_count,
2708 x_msg_data,
2709 ddp_qtev_rec);
2710
2711 -- copy data back from the local variables to OUT or IN-OUT args, if any
2712
2713
2714
2715
2716
2717 end;
2718
2719 end okl_trx_quotes_pub_w;