[Home] [Help]
Skip to content
PACKAGE: APPS.OKL_QUICK_QUOTES_PVT_W
Source
1 package okl_quick_quotes_pvt_w AUTHID CURRENT_USER as
2 /* $Header: OKLEQQHS.pls 120.3 2006/02/10 07:40:59 asawanka noship $ */
3 procedure rosetta_table_copy_in_p8(t out nocopy okl_quick_quotes_pvt.rent_payments_tbl, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_DATE_TABLE
9 );
10 procedure rosetta_table_copy_out_p8(t okl_quick_quotes_pvt.rent_payments_tbl, a0 out nocopy JTF_NUMBER_TABLE
11 , a1 out nocopy JTF_NUMBER_TABLE
12 , a2 out nocopy JTF_NUMBER_TABLE
13 , a3 out nocopy JTF_NUMBER_TABLE
14 , a4 out nocopy JTF_NUMBER_TABLE
15 , a5 out nocopy JTF_DATE_TABLE
16 );
17
18 procedure rosetta_table_copy_in_p10(t out nocopy okl_quick_quotes_pvt.fee_service_payments_tbl, a0 JTF_VARCHAR2_TABLE_100
19 , a1 JTF_NUMBER_TABLE
20 , a2 JTF_NUMBER_TABLE
21 , a3 JTF_DATE_TABLE
22 );
23 procedure rosetta_table_copy_out_p10(t okl_quick_quotes_pvt.fee_service_payments_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_100
24 , a1 out nocopy JTF_NUMBER_TABLE
25 , a2 out nocopy JTF_NUMBER_TABLE
26 , a3 out nocopy JTF_DATE_TABLE
27 );
28
29 procedure rosetta_table_copy_in_p12(t out nocopy okl_quick_quotes_pvt.item_order_estimate_tbl, a0 JTF_VARCHAR2_TABLE_300
30 , a1 JTF_VARCHAR2_TABLE_300
31 , a2 JTF_NUMBER_TABLE
32 , a3 JTF_NUMBER_TABLE
33 , a4 JTF_NUMBER_TABLE
34 , a5 JTF_NUMBER_TABLE
35 , a6 JTF_NUMBER_TABLE
36 , a7 JTF_DATE_TABLE
37 );
38 procedure rosetta_table_copy_out_p12(t okl_quick_quotes_pvt.item_order_estimate_tbl, a0 out nocopy JTF_VARCHAR2_TABLE_300
39 , a1 out nocopy JTF_VARCHAR2_TABLE_300
40 , a2 out nocopy JTF_NUMBER_TABLE
41 , a3 out nocopy JTF_NUMBER_TABLE
42 , a4 out nocopy JTF_NUMBER_TABLE
43 , a5 out nocopy JTF_NUMBER_TABLE
44 , a6 out nocopy JTF_NUMBER_TABLE
45 , a7 out nocopy JTF_DATE_TABLE
46 );
47
48 procedure create_quick_qte(p_api_version NUMBER
49 , p_init_msg_list VARCHAR2
50 , x_return_status out nocopy VARCHAR2
51 , x_msg_count out nocopy NUMBER
52 , x_msg_data out nocopy VARCHAR2
53 , p5_a0 NUMBER
54 , p5_a1 NUMBER
55 , p5_a2 VARCHAR2
56 , p5_a3 VARCHAR2
57 , p5_a4 VARCHAR2
58 , p5_a5 VARCHAR2
59 , p5_a6 VARCHAR2
60 , p5_a7 VARCHAR2
61 , p5_a8 VARCHAR2
62 , p5_a9 VARCHAR2
63 , p5_a10 VARCHAR2
64 , p5_a11 VARCHAR2
65 , p5_a12 VARCHAR2
66 , p5_a13 VARCHAR2
67 , p5_a14 VARCHAR2
68 , p5_a15 VARCHAR2
69 , p5_a16 VARCHAR2
70 , p5_a17 VARCHAR2
71 , p5_a18 VARCHAR2
72 , p5_a19 DATE
73 , p5_a20 NUMBER
74 , p5_a21 NUMBER
75 , p5_a22 VARCHAR2
76 , p5_a23 NUMBER
77 , p5_a24 NUMBER
78 , p5_a25 VARCHAR2
79 , p5_a26 NUMBER
80 , p5_a27 NUMBER
81 , p5_a28 NUMBER
82 , p5_a29 NUMBER
83 , p5_a30 NUMBER
84 , p5_a31 VARCHAR2
85 , p5_a32 VARCHAR2
86 , p5_a33 NUMBER
87 , p5_a34 NUMBER
88 , p5_a35 NUMBER
89 , p5_a36 VARCHAR2
90 , p5_a37 NUMBER
91 , p5_a38 NUMBER
92 , p5_a39 VARCHAR2
93 , p5_a40 VARCHAR2
94 , p5_a41 NUMBER
95 , p5_a42 NUMBER
96 , p5_a43 NUMBER
97 , p5_a44 NUMBER
98 , p5_a45 NUMBER
99 , p5_a46 NUMBER
100 , p5_a47 NUMBER
101 , p5_a48 NUMBER
102 , p5_a49 NUMBER
103 , p5_a50 VARCHAR2
104 , p5_a51 VARCHAR2
105 , p5_a52 VARCHAR2
106 , p5_a53 VARCHAR2
107 , p6_a0 out nocopy NUMBER
108 , p6_a1 out nocopy NUMBER
109 , p6_a2 out nocopy VARCHAR2
110 , p6_a3 out nocopy VARCHAR2
111 , p6_a4 out nocopy VARCHAR2
112 , p6_a5 out nocopy VARCHAR2
113 , p6_a6 out nocopy VARCHAR2
114 , p6_a7 out nocopy VARCHAR2
115 , p6_a8 out nocopy VARCHAR2
116 , p6_a9 out nocopy VARCHAR2
117 , p6_a10 out nocopy VARCHAR2
118 , p6_a11 out nocopy VARCHAR2
119 , p6_a12 out nocopy VARCHAR2
120 , p6_a13 out nocopy VARCHAR2
121 , p6_a14 out nocopy VARCHAR2
122 , p6_a15 out nocopy VARCHAR2
123 , p6_a16 out nocopy VARCHAR2
124 , p6_a17 out nocopy VARCHAR2
125 , p6_a18 out nocopy VARCHAR2
126 , p6_a19 out nocopy DATE
127 , p6_a20 out nocopy NUMBER
128 , p6_a21 out nocopy NUMBER
129 , p6_a22 out nocopy VARCHAR2
130 , p6_a23 out nocopy NUMBER
131 , p6_a24 out nocopy NUMBER
132 , p6_a25 out nocopy VARCHAR2
133 , p6_a26 out nocopy NUMBER
134 , p6_a27 out nocopy NUMBER
135 , p6_a28 out nocopy NUMBER
136 , p6_a29 out nocopy NUMBER
137 , p6_a30 out nocopy NUMBER
138 , p6_a31 out nocopy VARCHAR2
139 , p6_a32 out nocopy VARCHAR2
140 , p6_a33 out nocopy NUMBER
141 , p6_a34 out nocopy NUMBER
142 , p6_a35 out nocopy NUMBER
143 , p6_a36 out nocopy VARCHAR2
144 , p6_a37 out nocopy NUMBER
145 , p6_a38 out nocopy NUMBER
146 , p6_a39 out nocopy VARCHAR2
147 , p6_a40 out nocopy VARCHAR2
148 , p6_a41 out nocopy NUMBER
149 , p6_a42 out nocopy NUMBER
150 , p6_a43 out nocopy NUMBER
151 , p6_a44 out nocopy NUMBER
152 , p6_a45 out nocopy NUMBER
153 , p6_a46 out nocopy NUMBER
154 , p6_a47 out nocopy NUMBER
155 , p6_a48 out nocopy NUMBER
156 , p6_a49 out nocopy NUMBER
157 , p6_a50 out nocopy VARCHAR2
158 , p6_a51 out nocopy VARCHAR2
159 , p6_a52 out nocopy VARCHAR2
160 , p6_a53 out nocopy VARCHAR2
161 , p7_a0 JTF_NUMBER_TABLE
162 , p7_a1 JTF_NUMBER_TABLE
163 , p7_a2 JTF_VARCHAR2_TABLE_100
164 , p7_a3 JTF_VARCHAR2_TABLE_500
165 , p7_a4 JTF_VARCHAR2_TABLE_500
166 , p7_a5 JTF_VARCHAR2_TABLE_500
167 , p7_a6 JTF_VARCHAR2_TABLE_500
168 , p7_a7 JTF_VARCHAR2_TABLE_500
169 , p7_a8 JTF_VARCHAR2_TABLE_500
170 , p7_a9 JTF_VARCHAR2_TABLE_500
171 , p7_a10 JTF_VARCHAR2_TABLE_500
172 , p7_a11 JTF_VARCHAR2_TABLE_500
173 , p7_a12 JTF_VARCHAR2_TABLE_500
174 , p7_a13 JTF_VARCHAR2_TABLE_500
175 , p7_a14 JTF_VARCHAR2_TABLE_500
176 , p7_a15 JTF_VARCHAR2_TABLE_500
177 , p7_a16 JTF_VARCHAR2_TABLE_500
178 , p7_a17 JTF_VARCHAR2_TABLE_500
179 , p7_a18 JTF_NUMBER_TABLE
180 , p7_a19 JTF_VARCHAR2_TABLE_100
181 , p7_a20 JTF_VARCHAR2_TABLE_100
182 , p7_a21 JTF_NUMBER_TABLE
183 , p7_a22 JTF_NUMBER_TABLE
184 , p7_a23 JTF_NUMBER_TABLE
185 , p7_a24 JTF_NUMBER_TABLE
186 , p7_a25 JTF_NUMBER_TABLE
187 , p7_a26 JTF_NUMBER_TABLE
188 , p7_a27 JTF_NUMBER_TABLE
189 , p7_a28 JTF_VARCHAR2_TABLE_300
190 , p7_a29 JTF_VARCHAR2_TABLE_2000
191 , p7_a30 JTF_VARCHAR2_TABLE_2000
192 , p8_a0 out nocopy JTF_NUMBER_TABLE
193 , p8_a1 out nocopy JTF_NUMBER_TABLE
194 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
195 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_500
196 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_500
197 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_500
198 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_500
199 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_500
200 , p8_a8 out nocopy JTF_VARCHAR2_TABLE_500
201 , p8_a9 out nocopy JTF_VARCHAR2_TABLE_500
202 , p8_a10 out nocopy JTF_VARCHAR2_TABLE_500
203 , p8_a11 out nocopy JTF_VARCHAR2_TABLE_500
204 , p8_a12 out nocopy JTF_VARCHAR2_TABLE_500
205 , p8_a13 out nocopy JTF_VARCHAR2_TABLE_500
206 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_500
207 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_500
208 , p8_a16 out nocopy JTF_VARCHAR2_TABLE_500
209 , p8_a17 out nocopy JTF_VARCHAR2_TABLE_500
210 , p8_a18 out nocopy JTF_NUMBER_TABLE
211 , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
212 , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
213 , p8_a21 out nocopy JTF_NUMBER_TABLE
214 , p8_a22 out nocopy JTF_NUMBER_TABLE
215 , p8_a23 out nocopy JTF_NUMBER_TABLE
216 , p8_a24 out nocopy JTF_NUMBER_TABLE
217 , p8_a25 out nocopy JTF_NUMBER_TABLE
218 , p8_a26 out nocopy JTF_NUMBER_TABLE
219 , p8_a27 out nocopy JTF_NUMBER_TABLE
220 , p8_a28 out nocopy JTF_VARCHAR2_TABLE_300
221 , p8_a29 out nocopy JTF_VARCHAR2_TABLE_2000
222 , p8_a30 out nocopy JTF_VARCHAR2_TABLE_2000
223 );
224 procedure update_quick_qte(p_api_version NUMBER
225 , p_init_msg_list VARCHAR2
226 , x_return_status out nocopy VARCHAR2
227 , x_msg_count out nocopy NUMBER
228 , x_msg_data out nocopy VARCHAR2
229 , p5_a0 NUMBER
230 , p5_a1 NUMBER
231 , p5_a2 VARCHAR2
232 , p5_a3 VARCHAR2
233 , p5_a4 VARCHAR2
234 , p5_a5 VARCHAR2
235 , p5_a6 VARCHAR2
236 , p5_a7 VARCHAR2
237 , p5_a8 VARCHAR2
238 , p5_a9 VARCHAR2
239 , p5_a10 VARCHAR2
240 , p5_a11 VARCHAR2
241 , p5_a12 VARCHAR2
242 , p5_a13 VARCHAR2
243 , p5_a14 VARCHAR2
244 , p5_a15 VARCHAR2
245 , p5_a16 VARCHAR2
246 , p5_a17 VARCHAR2
247 , p5_a18 VARCHAR2
248 , p5_a19 DATE
249 , p5_a20 NUMBER
250 , p5_a21 NUMBER
251 , p5_a22 VARCHAR2
252 , p5_a23 NUMBER
253 , p5_a24 NUMBER
254 , p5_a25 VARCHAR2
255 , p5_a26 NUMBER
256 , p5_a27 NUMBER
257 , p5_a28 NUMBER
258 , p5_a29 NUMBER
259 , p5_a30 NUMBER
260 , p5_a31 VARCHAR2
261 , p5_a32 VARCHAR2
262 , p5_a33 NUMBER
263 , p5_a34 NUMBER
264 , p5_a35 NUMBER
265 , p5_a36 VARCHAR2
266 , p5_a37 NUMBER
267 , p5_a38 NUMBER
268 , p5_a39 VARCHAR2
269 , p5_a40 VARCHAR2
270 , p5_a41 NUMBER
271 , p5_a42 NUMBER
272 , p5_a43 NUMBER
273 , p5_a44 NUMBER
274 , p5_a45 NUMBER
275 , p5_a46 NUMBER
276 , p5_a47 NUMBER
277 , p5_a48 NUMBER
278 , p5_a49 NUMBER
279 , p5_a50 VARCHAR2
280 , p5_a51 VARCHAR2
281 , p5_a52 VARCHAR2
282 , p5_a53 VARCHAR2
283 , p6_a0 out nocopy NUMBER
284 , p6_a1 out nocopy NUMBER
285 , p6_a2 out nocopy VARCHAR2
286 , p6_a3 out nocopy VARCHAR2
287 , p6_a4 out nocopy VARCHAR2
288 , p6_a5 out nocopy VARCHAR2
289 , p6_a6 out nocopy VARCHAR2
290 , p6_a7 out nocopy VARCHAR2
291 , p6_a8 out nocopy VARCHAR2
292 , p6_a9 out nocopy VARCHAR2
293 , p6_a10 out nocopy VARCHAR2
294 , p6_a11 out nocopy VARCHAR2
295 , p6_a12 out nocopy VARCHAR2
296 , p6_a13 out nocopy VARCHAR2
297 , p6_a14 out nocopy VARCHAR2
298 , p6_a15 out nocopy VARCHAR2
299 , p6_a16 out nocopy VARCHAR2
300 , p6_a17 out nocopy VARCHAR2
301 , p6_a18 out nocopy VARCHAR2
302 , p6_a19 out nocopy DATE
303 , p6_a20 out nocopy NUMBER
304 , p6_a21 out nocopy NUMBER
305 , p6_a22 out nocopy VARCHAR2
306 , p6_a23 out nocopy NUMBER
307 , p6_a24 out nocopy NUMBER
308 , p6_a25 out nocopy VARCHAR2
309 , p6_a26 out nocopy NUMBER
310 , p6_a27 out nocopy NUMBER
311 , p6_a28 out nocopy NUMBER
312 , p6_a29 out nocopy NUMBER
313 , p6_a30 out nocopy NUMBER
314 , p6_a31 out nocopy VARCHAR2
315 , p6_a32 out nocopy VARCHAR2
316 , p6_a33 out nocopy NUMBER
317 , p6_a34 out nocopy NUMBER
318 , p6_a35 out nocopy NUMBER
319 , p6_a36 out nocopy VARCHAR2
320 , p6_a37 out nocopy NUMBER
321 , p6_a38 out nocopy NUMBER
322 , p6_a39 out nocopy VARCHAR2
323 , p6_a40 out nocopy VARCHAR2
324 , p6_a41 out nocopy NUMBER
325 , p6_a42 out nocopy NUMBER
326 , p6_a43 out nocopy NUMBER
327 , p6_a44 out nocopy NUMBER
328 , p6_a45 out nocopy NUMBER
329 , p6_a46 out nocopy NUMBER
330 , p6_a47 out nocopy NUMBER
331 , p6_a48 out nocopy NUMBER
332 , p6_a49 out nocopy NUMBER
333 , p6_a50 out nocopy VARCHAR2
334 , p6_a51 out nocopy VARCHAR2
335 , p6_a52 out nocopy VARCHAR2
336 , p6_a53 out nocopy VARCHAR2
337 , p7_a0 JTF_NUMBER_TABLE
338 , p7_a1 JTF_NUMBER_TABLE
339 , p7_a2 JTF_VARCHAR2_TABLE_100
340 , p7_a3 JTF_VARCHAR2_TABLE_500
341 , p7_a4 JTF_VARCHAR2_TABLE_500
342 , p7_a5 JTF_VARCHAR2_TABLE_500
343 , p7_a6 JTF_VARCHAR2_TABLE_500
344 , p7_a7 JTF_VARCHAR2_TABLE_500
345 , p7_a8 JTF_VARCHAR2_TABLE_500
346 , p7_a9 JTF_VARCHAR2_TABLE_500
347 , p7_a10 JTF_VARCHAR2_TABLE_500
348 , p7_a11 JTF_VARCHAR2_TABLE_500
349 , p7_a12 JTF_VARCHAR2_TABLE_500
350 , p7_a13 JTF_VARCHAR2_TABLE_500
351 , p7_a14 JTF_VARCHAR2_TABLE_500
352 , p7_a15 JTF_VARCHAR2_TABLE_500
353 , p7_a16 JTF_VARCHAR2_TABLE_500
354 , p7_a17 JTF_VARCHAR2_TABLE_500
355 , p7_a18 JTF_NUMBER_TABLE
356 , p7_a19 JTF_VARCHAR2_TABLE_100
357 , p7_a20 JTF_VARCHAR2_TABLE_100
358 , p7_a21 JTF_NUMBER_TABLE
359 , p7_a22 JTF_NUMBER_TABLE
360 , p7_a23 JTF_NUMBER_TABLE
361 , p7_a24 JTF_NUMBER_TABLE
362 , p7_a25 JTF_NUMBER_TABLE
363 , p7_a26 JTF_NUMBER_TABLE
364 , p7_a27 JTF_NUMBER_TABLE
365 , p7_a28 JTF_VARCHAR2_TABLE_300
366 , p7_a29 JTF_VARCHAR2_TABLE_2000
367 , p7_a30 JTF_VARCHAR2_TABLE_2000
368 , p8_a0 out nocopy JTF_NUMBER_TABLE
369 , p8_a1 out nocopy JTF_NUMBER_TABLE
370 , p8_a2 out nocopy JTF_VARCHAR2_TABLE_100
371 , p8_a3 out nocopy JTF_VARCHAR2_TABLE_500
372 , p8_a4 out nocopy JTF_VARCHAR2_TABLE_500
373 , p8_a5 out nocopy JTF_VARCHAR2_TABLE_500
374 , p8_a6 out nocopy JTF_VARCHAR2_TABLE_500
375 , p8_a7 out nocopy JTF_VARCHAR2_TABLE_500
376 , p8_a8 out nocopy JTF_VARCHAR2_TABLE_500
377 , p8_a9 out nocopy JTF_VARCHAR2_TABLE_500
378 , p8_a10 out nocopy JTF_VARCHAR2_TABLE_500
379 , p8_a11 out nocopy JTF_VARCHAR2_TABLE_500
380 , p8_a12 out nocopy JTF_VARCHAR2_TABLE_500
381 , p8_a13 out nocopy JTF_VARCHAR2_TABLE_500
382 , p8_a14 out nocopy JTF_VARCHAR2_TABLE_500
383 , p8_a15 out nocopy JTF_VARCHAR2_TABLE_500
384 , p8_a16 out nocopy JTF_VARCHAR2_TABLE_500
385 , p8_a17 out nocopy JTF_VARCHAR2_TABLE_500
386 , p8_a18 out nocopy JTF_NUMBER_TABLE
387 , p8_a19 out nocopy JTF_VARCHAR2_TABLE_100
388 , p8_a20 out nocopy JTF_VARCHAR2_TABLE_100
389 , p8_a21 out nocopy JTF_NUMBER_TABLE
390 , p8_a22 out nocopy JTF_NUMBER_TABLE
391 , p8_a23 out nocopy JTF_NUMBER_TABLE
392 , p8_a24 out nocopy JTF_NUMBER_TABLE
393 , p8_a25 out nocopy JTF_NUMBER_TABLE
394 , p8_a26 out nocopy JTF_NUMBER_TABLE
395 , p8_a27 out nocopy JTF_NUMBER_TABLE
396 , p8_a28 out nocopy JTF_VARCHAR2_TABLE_300
397 , p8_a29 out nocopy JTF_VARCHAR2_TABLE_2000
398 , p8_a30 out nocopy JTF_VARCHAR2_TABLE_2000
399 );
400 procedure delete_qql(p_api_version NUMBER
401 , p_init_msg_list VARCHAR2
402 , x_return_status out nocopy VARCHAR2
403 , x_msg_count out nocopy NUMBER
404 , x_msg_data out nocopy VARCHAR2
405 , p5_a0 NUMBER
406 , p5_a1 NUMBER
407 , p5_a2 VARCHAR2
408 , p5_a3 VARCHAR2
409 , p5_a4 VARCHAR2
410 , p5_a5 VARCHAR2
411 , p5_a6 VARCHAR2
412 , p5_a7 VARCHAR2
413 , p5_a8 VARCHAR2
414 , p5_a9 VARCHAR2
415 , p5_a10 VARCHAR2
416 , p5_a11 VARCHAR2
417 , p5_a12 VARCHAR2
418 , p5_a13 VARCHAR2
419 , p5_a14 VARCHAR2
420 , p5_a15 VARCHAR2
421 , p5_a16 VARCHAR2
422 , p5_a17 VARCHAR2
423 , p5_a18 NUMBER
424 , p5_a19 VARCHAR2
425 , p5_a20 VARCHAR2
426 , p5_a21 NUMBER
427 , p5_a22 NUMBER
428 , p5_a23 NUMBER
429 , p5_a24 NUMBER
430 , p5_a25 NUMBER
431 , p5_a26 NUMBER
432 , p5_a27 NUMBER
433 , p5_a28 VARCHAR2
434 , p5_a29 VARCHAR2
435 , p5_a30 VARCHAR2
436 );
437 procedure delete_qql(p_api_version NUMBER
438 , p_init_msg_list VARCHAR2
439 , x_return_status out nocopy VARCHAR2
440 , x_msg_count out nocopy NUMBER
441 , x_msg_data out nocopy VARCHAR2
442 , p5_a0 JTF_NUMBER_TABLE
443 , p5_a1 JTF_NUMBER_TABLE
444 , p5_a2 JTF_VARCHAR2_TABLE_100
445 , p5_a3 JTF_VARCHAR2_TABLE_500
446 , p5_a4 JTF_VARCHAR2_TABLE_500
447 , p5_a5 JTF_VARCHAR2_TABLE_500
448 , p5_a6 JTF_VARCHAR2_TABLE_500
449 , p5_a7 JTF_VARCHAR2_TABLE_500
450 , p5_a8 JTF_VARCHAR2_TABLE_500
451 , p5_a9 JTF_VARCHAR2_TABLE_500
452 , p5_a10 JTF_VARCHAR2_TABLE_500
453 , p5_a11 JTF_VARCHAR2_TABLE_500
454 , p5_a12 JTF_VARCHAR2_TABLE_500
455 , p5_a13 JTF_VARCHAR2_TABLE_500
456 , p5_a14 JTF_VARCHAR2_TABLE_500
457 , p5_a15 JTF_VARCHAR2_TABLE_500
458 , p5_a16 JTF_VARCHAR2_TABLE_500
459 , p5_a17 JTF_VARCHAR2_TABLE_500
460 , p5_a18 JTF_NUMBER_TABLE
461 , p5_a19 JTF_VARCHAR2_TABLE_100
462 , p5_a20 JTF_VARCHAR2_TABLE_100
463 , p5_a21 JTF_NUMBER_TABLE
464 , p5_a22 JTF_NUMBER_TABLE
465 , p5_a23 JTF_NUMBER_TABLE
466 , p5_a24 JTF_NUMBER_TABLE
467 , p5_a25 JTF_NUMBER_TABLE
468 , p5_a26 JTF_NUMBER_TABLE
469 , p5_a27 JTF_NUMBER_TABLE
470 , p5_a28 JTF_VARCHAR2_TABLE_300
471 , p5_a29 JTF_VARCHAR2_TABLE_2000
472 , p5_a30 JTF_VARCHAR2_TABLE_2000
473 );
474 procedure handle_quick_quote(p_api_version NUMBER
475 , p_init_msg_list VARCHAR2
476 , x_return_status out nocopy VARCHAR2
477 , x_msg_count out nocopy NUMBER
478 , x_msg_data out nocopy VARCHAR2
479 , p5_a0 NUMBER
480 , p5_a1 NUMBER
481 , p5_a2 VARCHAR2
482 , p5_a3 VARCHAR2
483 , p5_a4 VARCHAR2
484 , p5_a5 VARCHAR2
485 , p5_a6 VARCHAR2
486 , p5_a7 VARCHAR2
487 , p5_a8 VARCHAR2
488 , p5_a9 VARCHAR2
489 , p5_a10 VARCHAR2
490 , p5_a11 VARCHAR2
491 , p5_a12 VARCHAR2
492 , p5_a13 VARCHAR2
493 , p5_a14 VARCHAR2
494 , p5_a15 VARCHAR2
495 , p5_a16 VARCHAR2
496 , p5_a17 VARCHAR2
497 , p5_a18 VARCHAR2
498 , p5_a19 DATE
499 , p5_a20 NUMBER
500 , p5_a21 NUMBER
501 , p5_a22 VARCHAR2
502 , p5_a23 NUMBER
503 , p5_a24 NUMBER
504 , p5_a25 VARCHAR2
505 , p5_a26 NUMBER
506 , p5_a27 NUMBER
507 , p5_a28 NUMBER
508 , p5_a29 NUMBER
509 , p5_a30 NUMBER
510 , p5_a31 VARCHAR2
511 , p5_a32 VARCHAR2
512 , p5_a33 NUMBER
513 , p5_a34 NUMBER
514 , p5_a35 NUMBER
515 , p5_a36 VARCHAR2
516 , p5_a37 NUMBER
517 , p5_a38 NUMBER
518 , p5_a39 VARCHAR2
519 , p5_a40 VARCHAR2
520 , p5_a41 NUMBER
521 , p5_a42 NUMBER
522 , p5_a43 NUMBER
523 , p5_a44 NUMBER
524 , p5_a45 NUMBER
525 , p5_a46 NUMBER
526 , p5_a47 NUMBER
527 , p5_a48 NUMBER
528 , p5_a49 NUMBER
529 , p5_a50 VARCHAR2
530 , p5_a51 VARCHAR2
531 , p5_a52 VARCHAR2
532 , p5_a53 VARCHAR2
533 , p6_a0 JTF_NUMBER_TABLE
534 , p6_a1 JTF_NUMBER_TABLE
535 , p6_a2 JTF_VARCHAR2_TABLE_100
536 , p6_a3 JTF_VARCHAR2_TABLE_500
537 , p6_a4 JTF_VARCHAR2_TABLE_500
538 , p6_a5 JTF_VARCHAR2_TABLE_500
539 , p6_a6 JTF_VARCHAR2_TABLE_500
540 , p6_a7 JTF_VARCHAR2_TABLE_500
541 , p6_a8 JTF_VARCHAR2_TABLE_500
542 , p6_a9 JTF_VARCHAR2_TABLE_500
543 , p6_a10 JTF_VARCHAR2_TABLE_500
544 , p6_a11 JTF_VARCHAR2_TABLE_500
545 , p6_a12 JTF_VARCHAR2_TABLE_500
546 , p6_a13 JTF_VARCHAR2_TABLE_500
547 , p6_a14 JTF_VARCHAR2_TABLE_500
548 , p6_a15 JTF_VARCHAR2_TABLE_500
549 , p6_a16 JTF_VARCHAR2_TABLE_500
550 , p6_a17 JTF_VARCHAR2_TABLE_500
551 , p6_a18 JTF_NUMBER_TABLE
552 , p6_a19 JTF_VARCHAR2_TABLE_100
553 , p6_a20 JTF_VARCHAR2_TABLE_100
554 , p6_a21 JTF_NUMBER_TABLE
555 , p6_a22 JTF_NUMBER_TABLE
556 , p6_a23 JTF_NUMBER_TABLE
557 , p6_a24 JTF_NUMBER_TABLE
558 , p6_a25 JTF_NUMBER_TABLE
559 , p6_a26 JTF_NUMBER_TABLE
560 , p6_a27 JTF_NUMBER_TABLE
561 , p6_a28 JTF_VARCHAR2_TABLE_300
562 , p6_a29 JTF_VARCHAR2_TABLE_2000
563 , p6_a30 JTF_VARCHAR2_TABLE_2000
564 , p7_a0 VARCHAR2
565 , p7_a1 NUMBER
566 , p7_a2 VARCHAR2
567 , p7_a3 VARCHAR2
568 , p7_a4 VARCHAR2
569 , p7_a5 VARCHAR2
570 , p7_a6 VARCHAR2
571 , p7_a7 VARCHAR2
572 , p7_a8 NUMBER
573 , p7_a9 VARCHAR2
574 , p7_a10 NUMBER
575 , p7_a11 NUMBER
576 , p7_a12 NUMBER
577 , p7_a13 NUMBER
578 , p8_a0 JTF_NUMBER_TABLE
579 , p8_a1 JTF_DATE_TABLE
580 , p8_a2 JTF_NUMBER_TABLE
581 , p8_a3 JTF_NUMBER_TABLE
582 , p8_a4 JTF_NUMBER_TABLE
583 , p8_a5 JTF_NUMBER_TABLE
584 , p8_a6 JTF_NUMBER_TABLE
585 , p8_a7 JTF_NUMBER_TABLE
586 , p8_a8 JTF_VARCHAR2_TABLE_100
587 , p8_a9 JTF_VARCHAR2_TABLE_100
588 , p_commit VARCHAR2
589 , create_yn VARCHAR2
590 , p11_a0 out nocopy NUMBER
591 , p11_a1 out nocopy NUMBER
592 , p11_a2 out nocopy VARCHAR2
593 , p11_a3 out nocopy VARCHAR2
594 , p11_a4 out nocopy NUMBER
595 , p11_a5 out nocopy NUMBER
596 , p11_a6 out nocopy NUMBER
597 , p11_a7 out nocopy NUMBER
598 , p11_a8 out nocopy NUMBER
599 , p11_a9 out nocopy NUMBER
600 , p11_a10 out nocopy NUMBER
601 , p11_a11 out nocopy NUMBER
602 , p12_a0 out nocopy JTF_NUMBER_TABLE
603 , p12_a1 out nocopy JTF_NUMBER_TABLE
604 , p12_a2 out nocopy JTF_NUMBER_TABLE
605 , p12_a3 out nocopy JTF_NUMBER_TABLE
606 , p12_a4 out nocopy JTF_NUMBER_TABLE
607 , p12_a5 out nocopy JTF_DATE_TABLE
608 , p13_a0 out nocopy JTF_VARCHAR2_TABLE_100
609 , p13_a1 out nocopy JTF_NUMBER_TABLE
610 , p13_a2 out nocopy JTF_NUMBER_TABLE
611 , p13_a3 out nocopy JTF_DATE_TABLE
612 , p14_a0 out nocopy JTF_VARCHAR2_TABLE_300
613 , p14_a1 out nocopy JTF_VARCHAR2_TABLE_300
614 , p14_a2 out nocopy JTF_NUMBER_TABLE
615 , p14_a3 out nocopy JTF_NUMBER_TABLE
616 , p14_a4 out nocopy JTF_NUMBER_TABLE
617 , p14_a5 out nocopy JTF_NUMBER_TABLE
618 , p14_a6 out nocopy JTF_NUMBER_TABLE
619 , p14_a7 out nocopy JTF_DATE_TABLE
620 , p15_a0 out nocopy NUMBER
621 , p15_a1 out nocopy NUMBER
622 , p15_a2 out nocopy VARCHAR2
623 , p15_a3 out nocopy VARCHAR2
624 , p15_a4 out nocopy VARCHAR2
625 , p15_a5 out nocopy VARCHAR2
626 , p15_a6 out nocopy VARCHAR2
627 , p15_a7 out nocopy VARCHAR2
628 , p15_a8 out nocopy VARCHAR2
629 , p15_a9 out nocopy VARCHAR2
630 , p15_a10 out nocopy VARCHAR2
631 , p15_a11 out nocopy VARCHAR2
632 , p15_a12 out nocopy VARCHAR2
633 , p15_a13 out nocopy VARCHAR2
634 , p15_a14 out nocopy VARCHAR2
635 , p15_a15 out nocopy VARCHAR2
636 , p15_a16 out nocopy VARCHAR2
637 , p15_a17 out nocopy VARCHAR2
638 , p15_a18 out nocopy VARCHAR2
639 , p15_a19 out nocopy DATE
640 , p15_a20 out nocopy NUMBER
641 , p15_a21 out nocopy NUMBER
642 , p15_a22 out nocopy VARCHAR2
643 , p15_a23 out nocopy NUMBER
644 , p15_a24 out nocopy NUMBER
645 , p15_a25 out nocopy VARCHAR2
646 , p15_a26 out nocopy NUMBER
647 , p15_a27 out nocopy NUMBER
648 , p15_a28 out nocopy NUMBER
649 , p15_a29 out nocopy NUMBER
650 , p15_a30 out nocopy NUMBER
651 , p15_a31 out nocopy VARCHAR2
652 , p15_a32 out nocopy VARCHAR2
653 , p15_a33 out nocopy NUMBER
654 , p15_a34 out nocopy NUMBER
655 , p15_a35 out nocopy NUMBER
656 , p15_a36 out nocopy VARCHAR2
657 , p15_a37 out nocopy NUMBER
658 , p15_a38 out nocopy NUMBER
659 , p15_a39 out nocopy VARCHAR2
660 , p15_a40 out nocopy VARCHAR2
661 , p15_a41 out nocopy NUMBER
662 , p15_a42 out nocopy NUMBER
663 , p15_a43 out nocopy NUMBER
664 , p15_a44 out nocopy NUMBER
665 , p15_a45 out nocopy NUMBER
666 , p15_a46 out nocopy NUMBER
667 , p15_a47 out nocopy NUMBER
668 , p15_a48 out nocopy NUMBER
669 , p15_a49 out nocopy NUMBER
670 , p15_a50 out nocopy VARCHAR2
671 , p15_a51 out nocopy VARCHAR2
672 , p15_a52 out nocopy VARCHAR2
673 , p15_a53 out nocopy VARCHAR2
674 , p16_a0 out nocopy JTF_NUMBER_TABLE
675 , p16_a1 out nocopy JTF_NUMBER_TABLE
676 , p16_a2 out nocopy JTF_VARCHAR2_TABLE_100
677 , p16_a3 out nocopy JTF_VARCHAR2_TABLE_500
678 , p16_a4 out nocopy JTF_VARCHAR2_TABLE_500
679 , p16_a5 out nocopy JTF_VARCHAR2_TABLE_500
680 , p16_a6 out nocopy JTF_VARCHAR2_TABLE_500
681 , p16_a7 out nocopy JTF_VARCHAR2_TABLE_500
682 , p16_a8 out nocopy JTF_VARCHAR2_TABLE_500
683 , p16_a9 out nocopy JTF_VARCHAR2_TABLE_500
684 , p16_a10 out nocopy JTF_VARCHAR2_TABLE_500
685 , p16_a11 out nocopy JTF_VARCHAR2_TABLE_500
686 , p16_a12 out nocopy JTF_VARCHAR2_TABLE_500
687 , p16_a13 out nocopy JTF_VARCHAR2_TABLE_500
688 , p16_a14 out nocopy JTF_VARCHAR2_TABLE_500
689 , p16_a15 out nocopy JTF_VARCHAR2_TABLE_500
690 , p16_a16 out nocopy JTF_VARCHAR2_TABLE_500
691 , p16_a17 out nocopy JTF_VARCHAR2_TABLE_500
692 , p16_a18 out nocopy JTF_NUMBER_TABLE
693 , p16_a19 out nocopy JTF_VARCHAR2_TABLE_100
694 , p16_a20 out nocopy JTF_VARCHAR2_TABLE_100
695 , p16_a21 out nocopy JTF_NUMBER_TABLE
696 , p16_a22 out nocopy JTF_NUMBER_TABLE
697 , p16_a23 out nocopy JTF_NUMBER_TABLE
698 , p16_a24 out nocopy JTF_NUMBER_TABLE
699 , p16_a25 out nocopy JTF_NUMBER_TABLE
700 , p16_a26 out nocopy JTF_NUMBER_TABLE
701 , p16_a27 out nocopy JTF_NUMBER_TABLE
702 , p16_a28 out nocopy JTF_VARCHAR2_TABLE_300
703 , p16_a29 out nocopy JTF_VARCHAR2_TABLE_2000
704 , p16_a30 out nocopy JTF_VARCHAR2_TABLE_2000
705 );
706 procedure cancel_quick_quote(p_api_version NUMBER
707 , p_init_msg_list VARCHAR2
708 , x_return_status out nocopy VARCHAR2
709 , x_msg_count out nocopy NUMBER
710 , x_msg_data out nocopy VARCHAR2
711 , p5_a0 NUMBER
712 , p5_a1 NUMBER
713 , p5_a2 VARCHAR2
714 , p5_a3 VARCHAR2
715 , p5_a4 VARCHAR2
716 , p5_a5 VARCHAR2
717 , p5_a6 VARCHAR2
718 , p5_a7 VARCHAR2
719 , p5_a8 VARCHAR2
720 , p5_a9 VARCHAR2
721 , p5_a10 VARCHAR2
722 , p5_a11 VARCHAR2
723 , p5_a12 VARCHAR2
724 , p5_a13 VARCHAR2
725 , p5_a14 VARCHAR2
726 , p5_a15 VARCHAR2
727 , p5_a16 VARCHAR2
728 , p5_a17 VARCHAR2
729 , p5_a18 VARCHAR2
730 , p5_a19 DATE
731 , p5_a20 NUMBER
732 , p5_a21 NUMBER
733 , p5_a22 VARCHAR2
734 , p5_a23 NUMBER
735 , p5_a24 NUMBER
736 , p5_a25 VARCHAR2
737 , p5_a26 NUMBER
738 , p5_a27 NUMBER
739 , p5_a28 NUMBER
740 , p5_a29 NUMBER
741 , p5_a30 NUMBER
742 , p5_a31 VARCHAR2
743 , p5_a32 VARCHAR2
744 , p5_a33 NUMBER
745 , p5_a34 NUMBER
746 , p5_a35 NUMBER
747 , p5_a36 VARCHAR2
748 , p5_a37 NUMBER
749 , p5_a38 NUMBER
750 , p5_a39 VARCHAR2
751 , p5_a40 VARCHAR2
752 , p5_a41 NUMBER
753 , p5_a42 NUMBER
754 , p5_a43 NUMBER
755 , p5_a44 NUMBER
756 , p5_a45 NUMBER
757 , p5_a46 NUMBER
758 , p5_a47 NUMBER
759 , p5_a48 NUMBER
760 , p5_a49 NUMBER
761 , p5_a50 VARCHAR2
762 , p5_a51 VARCHAR2
763 , p5_a52 VARCHAR2
764 , p5_a53 VARCHAR2
765 , p6_a0 out nocopy NUMBER
766 , p6_a1 out nocopy NUMBER
767 , p6_a2 out nocopy VARCHAR2
768 , p6_a3 out nocopy VARCHAR2
769 , p6_a4 out nocopy VARCHAR2
770 , p6_a5 out nocopy VARCHAR2
771 , p6_a6 out nocopy VARCHAR2
772 , p6_a7 out nocopy VARCHAR2
773 , p6_a8 out nocopy VARCHAR2
774 , p6_a9 out nocopy VARCHAR2
775 , p6_a10 out nocopy VARCHAR2
776 , p6_a11 out nocopy VARCHAR2
777 , p6_a12 out nocopy VARCHAR2
778 , p6_a13 out nocopy VARCHAR2
779 , p6_a14 out nocopy VARCHAR2
780 , p6_a15 out nocopy VARCHAR2
781 , p6_a16 out nocopy VARCHAR2
782 , p6_a17 out nocopy VARCHAR2
783 , p6_a18 out nocopy VARCHAR2
784 , p6_a19 out nocopy DATE
785 , p6_a20 out nocopy NUMBER
786 , p6_a21 out nocopy NUMBER
787 , p6_a22 out nocopy VARCHAR2
788 , p6_a23 out nocopy NUMBER
789 , p6_a24 out nocopy NUMBER
790 , p6_a25 out nocopy VARCHAR2
791 , p6_a26 out nocopy NUMBER
792 , p6_a27 out nocopy NUMBER
793 , p6_a28 out nocopy NUMBER
794 , p6_a29 out nocopy NUMBER
795 , p6_a30 out nocopy NUMBER
796 , p6_a31 out nocopy VARCHAR2
797 , p6_a32 out nocopy VARCHAR2
798 , p6_a33 out nocopy NUMBER
799 , p6_a34 out nocopy NUMBER
800 , p6_a35 out nocopy NUMBER
801 , p6_a36 out nocopy VARCHAR2
802 , p6_a37 out nocopy NUMBER
803 , p6_a38 out nocopy NUMBER
804 , p6_a39 out nocopy VARCHAR2
805 , p6_a40 out nocopy VARCHAR2
806 , p6_a41 out nocopy NUMBER
807 , p6_a42 out nocopy NUMBER
808 , p6_a43 out nocopy NUMBER
809 , p6_a44 out nocopy NUMBER
810 , p6_a45 out nocopy NUMBER
811 , p6_a46 out nocopy NUMBER
812 , p6_a47 out nocopy NUMBER
813 , p6_a48 out nocopy NUMBER
814 , p6_a49 out nocopy NUMBER
815 , p6_a50 out nocopy VARCHAR2
816 , p6_a51 out nocopy VARCHAR2
817 , p6_a52 out nocopy VARCHAR2
818 , p6_a53 out nocopy VARCHAR2
819 );
820 end okl_quick_quotes_pvt_w;