1 package oe_price_order_pvt_w_obsolete AUTHID CURRENT_USER as
2 /* $Header: OERVPROS.pls 115.2 2004/05/19 21:37:39 lchen noship $ */
3 procedure rosetta_table_copy_in_p3(t out oe_price_order_pvt.price_att_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_VARCHAR2_TABLE_100
6 , a3 JTF_VARCHAR2_TABLE_100
7 , a4 JTF_VARCHAR2_TABLE_100
8 , a5 JTF_VARCHAR2_TABLE_300
9 , a6 JTF_VARCHAR2_TABLE_100
10 );
11 procedure rosetta_table_copy_out_p3(t oe_price_order_pvt.price_att_tbl_type, a0 out JTF_NUMBER_TABLE
12 , a1 out JTF_NUMBER_TABLE
13 , a2 out JTF_VARCHAR2_TABLE_100
14 , a3 out JTF_VARCHAR2_TABLE_100
15 , a4 out JTF_VARCHAR2_TABLE_100
16 , a5 out JTF_VARCHAR2_TABLE_300
17 , a6 out JTF_VARCHAR2_TABLE_100
18 );
19
20 procedure price_order(p0_a0 in out NUMBER
21 , p0_a1 in out NUMBER
22 , p0_a2 in out VARCHAR2
23 , p0_a3 in out VARCHAR2
24 , p0_a4 in out VARCHAR2
25 , p0_a5 in out VARCHAR2
26 , p0_a6 in out VARCHAR2
27 , p0_a7 in out VARCHAR2
28 , p0_a8 in out VARCHAR2
29 , p0_a9 in out VARCHAR2
30 , p0_a10 in out VARCHAR2
31 , p0_a11 in out VARCHAR2
32 , p0_a12 in out VARCHAR2
33 , p0_a13 in out VARCHAR2
34 , p0_a14 in out VARCHAR2
35 , p0_a15 in out VARCHAR2
36 , p0_a16 in out VARCHAR2
37 , p0_a17 in out VARCHAR2
38 , p0_a18 in out VARCHAR2
39 , p0_a19 in out VARCHAR2
40 , p0_a20 in out VARCHAR2
41 , p0_a21 in out VARCHAR2
42 , p0_a22 in out VARCHAR2
43 , p0_a23 in out VARCHAR2
44 , p0_a24 in out VARCHAR2
45 , p0_a25 in out NUMBER
46 , p0_a26 in out DATE
47 , p0_a27 in out VARCHAR2
48 , p0_a28 in out VARCHAR2
49 , p0_a29 in out NUMBER
50 , p0_a30 in out DATE
51 , p0_a31 in out VARCHAR2
52 , p0_a32 in out NUMBER
53 , p0_a33 in out NUMBER
54 , p0_a34 in out VARCHAR2
55 , p0_a35 in out NUMBER
56 , p0_a36 in out DATE
57 , p0_a37 in out VARCHAR2
58 , p0_a38 in out VARCHAR2
59 , p0_a39 in out VARCHAR2
60 , p0_a40 in out VARCHAR2
61 , p0_a41 in out VARCHAR2
62 , p0_a42 in out VARCHAR2
63 , p0_a43 in out VARCHAR2
64 , p0_a44 in out VARCHAR2
65 , p0_a45 in out VARCHAR2
66 , p0_a46 in out VARCHAR2
67 , p0_a47 in out VARCHAR2
68 , p0_a48 in out VARCHAR2
69 , p0_a49 in out VARCHAR2
70 , p0_a50 in out VARCHAR2
71 , p0_a51 in out VARCHAR2
72 , p0_a52 in out VARCHAR2
73 , p0_a53 in out VARCHAR2
74 , p0_a54 in out VARCHAR2
75 , p0_a55 in out VARCHAR2
76 , p0_a56 in out VARCHAR2
77 , p0_a57 in out VARCHAR2
78 , p0_a58 in out VARCHAR2
79 , p0_a59 in out VARCHAR2
80 , p0_a60 in out VARCHAR2
81 , p0_a61 in out VARCHAR2
82 , p0_a62 in out VARCHAR2
83 , p0_a63 in out VARCHAR2
84 , p0_a64 in out VARCHAR2
85 , p0_a65 in out VARCHAR2
86 , p0_a66 in out VARCHAR2
87 , p0_a67 in out VARCHAR2
88 , p0_a68 in out VARCHAR2
89 , p0_a69 in out VARCHAR2
90 , p0_a70 in out VARCHAR2
91 , p0_a71 in out VARCHAR2
92 , p0_a72 in out VARCHAR2
93 , p0_a73 in out VARCHAR2
94 , p0_a74 in out VARCHAR2
95 , p0_a75 in out VARCHAR2
96 , p0_a76 in out VARCHAR2
97 , p0_a77 in out NUMBER
98 , p0_a78 in out NUMBER
99 , p0_a79 in out NUMBER
100 , p0_a80 in out NUMBER
101 , p0_a81 in out NUMBER
102 , p0_a82 in out DATE
103 , p0_a83 in out NUMBER
104 , p0_a84 in out NUMBER
105 , p0_a85 in out VARCHAR2
106 , p0_a86 in out VARCHAR2
107 , p0_a87 in out DATE
108 , p0_a88 in out VARCHAR2
109 , p0_a89 in out NUMBER
110 , p0_a90 in out NUMBER
111 , p0_a91 in out NUMBER
112 , p0_a92 in out NUMBER
113 , p0_a93 in out VARCHAR2
114 , p0_a94 in out VARCHAR2
115 , p0_a95 in out NUMBER
116 , p0_a96 in out NUMBER
117 , p0_a97 in out VARCHAR2
118 , p0_a98 in out DATE
119 , p0_a99 in out NUMBER
120 , p0_a100 in out NUMBER
121 , p0_a101 in out DATE
122 , p0_a102 in out DATE
123 , p0_a103 in out NUMBER
124 , p0_a104 in out VARCHAR2
125 , p0_a105 in out NUMBER
126 , p0_a106 in out VARCHAR2
127 , p0_a107 in out VARCHAR2
128 , p0_a108 in out VARCHAR2
129 , p0_a109 in out NUMBER
130 , p0_a110 in out NUMBER
131 , p0_a111 in out NUMBER
132 , p0_a112 in out NUMBER
133 , p0_a113 in out NUMBER
134 , p0_a114 in out NUMBER
135 , p0_a115 in out NUMBER
136 , p0_a116 in out NUMBER
137 , p0_a117 in out NUMBER
138 , p0_a118 in out NUMBER
139 , p0_a119 in out NUMBER
140 , p0_a120 in out VARCHAR2
141 , p0_a121 in out VARCHAR2
142 , p0_a122 in out VARCHAR2
143 , p0_a123 in out VARCHAR2
144 , p0_a124 in out VARCHAR2
145 , p0_a125 in out NUMBER
146 , p0_a126 in out VARCHAR2
147 , p0_a127 in out VARCHAR2
148 , p0_a128 in out VARCHAR2
149 , p0_a129 in out VARCHAR2
150 , p0_a130 in out DATE
151 , p0_a131 in out VARCHAR2
152 , p0_a132 in out DATE
153 , p0_a133 in out VARCHAR2
154 , p0_a134 in out VARCHAR2
155 , p0_a135 in out VARCHAR2
156 , p0_a136 in out VARCHAR2
157 , p0_a137 in out VARCHAR2
158 , p0_a138 in out VARCHAR2
159 , p0_a139 in out VARCHAR2
160 , p0_a140 in out VARCHAR2
161 , p0_a141 in out NUMBER
162 , p0_a142 in out VARCHAR2
163 , p0_a143 in out NUMBER
164 , p0_a144 in out VARCHAR2
165 , p0_a145 in out VARCHAR2
166 , p0_a146 in out VARCHAR2
167 , p0_a147 in out VARCHAR2
168 , p0_a148 in out DATE
169 , p0_a149 in out VARCHAR2
170 , p0_a150 in out DATE
171 , p0_a151 in out VARCHAR2
172 , p0_a152 in out VARCHAR2
173 , p0_a153 in out VARCHAR2
174 , p0_a154 in out DATE
175 , p0_a155 in out NUMBER
176 , p0_a156 in out VARCHAR2
177 , p0_a157 in out NUMBER
178 , p0_a158 in out VARCHAR2
179 , p0_a159 in out VARCHAR2
180 , p0_a160 in out VARCHAR2
181 , p0_a161 in out VARCHAR2
182 , p0_a162 in out NUMBER
183 , p0_a163 in out NUMBER
184 , p0_a164 in out NUMBER
185 , p0_a165 in out NUMBER
186 , p0_a166 in out VARCHAR2
187 , p0_a167 in out NUMBER
188 , p0_a168 in out NUMBER
189 , p0_a169 in out NUMBER
190 , p0_a170 in out NUMBER
191 , p0_a171 in out NUMBER
192 , p0_a172 in out VARCHAR2
193 , p0_a173 in out NUMBER
194 , p0_a174 in out VARCHAR2
195 , p0_a175 in out VARCHAR2
196 , p0_a176 in out VARCHAR2
197 , p0_a177 in out DATE
198 , p0_a178 in out NUMBER
199 , p0_a179 in out VARCHAR2
200 , p0_a180 in out VARCHAR2
201 , p0_a181 in out VARCHAR2
202 , p0_a182 in out VARCHAR2
203 , p0_a183 in out NUMBER
204 , p0_a184 in out NUMBER
205 , p0_a185 in out NUMBER
206 , p0_a186 in out VARCHAR2
207 , p0_a187 in out VARCHAR2
208 , p0_a188 in out VARCHAR2
209 , p0_a189 in out NUMBER
210 , p0_a190 in out NUMBER
211 , p0_a191 in out NUMBER
212 , p0_a192 in out VARCHAR2
213 , p0_a193 in out DATE
214 , p0_a194 in out VARCHAR2
215 , p0_a195 in out DATE
216 , p0_a196 in out NUMBER
217 , p0_a197 in out NUMBER
218 , p0_a198 in out NUMBER
219 , p0_a199 in out NUMBER
220 , p0_a200 in out NUMBER
221 , p0_a201 in out NUMBER
222 , p0_a202 in out NUMBER
223 , p0_a203 in out NUMBER
224 , p0_a204 in out NUMBER
225 , p0_a205 in out NUMBER
226 , p0_a206 in out NUMBER
227 , p0_a207 in out NUMBER
228 , p0_a208 in out NUMBER
229 , p0_a209 in out NUMBER
230 , p0_a210 in out NUMBER
231 , p0_a211 in out NUMBER
232 , p0_a212 in out NUMBER
233 , p0_a213 in out NUMBER
234 , p0_a214 in out VARCHAR2
235 , p0_a215 in out NUMBER
236 , p1_a0 in out NUMBER
237 , p1_a1 in out DATE
238 , p1_a2 in out DATE
239 , p1_a3 in out NUMBER
240 , p1_a4 in out NUMBER
241 , p1_a5 in out NUMBER
242 , p1_a6 in out VARCHAR2
243 , p1_a7 in out NUMBER
244 , p1_a8 in out VARCHAR2
245 , p1_a9 in out VARCHAR2
246 , p1_a10 in out NUMBER
247 , p1_a11 in out NUMBER
248 , p1_a12 in out NUMBER
249 , p1_a13 in out VARCHAR2
250 , p1_a14 in out NUMBER
251 , p1_a15 in out NUMBER
252 , p1_a16 in out NUMBER
253 , p1_a17 in out NUMBER
254 , p1_a18 in out NUMBER
255 , p1_a19 in out NUMBER
256 , p1_a20 in out VARCHAR2
257 , p1_a21 in out NUMBER
258 , p1_a22 in out DATE
259 , p1_a23 in out NUMBER
260 , p1_a24 in out VARCHAR2
261 , p1_a25 in out VARCHAR2
262 , p1_a26 in out VARCHAR2
263 , p1_a27 in out NUMBER
264 , p1_a28 in out VARCHAR2
265 , p1_a29 in out VARCHAR2
266 , p1_a30 in out VARCHAR2
267 , p1_a31 in out NUMBER
268 , p1_a32 in out NUMBER
269 , p1_a33 in out NUMBER
270 , p1_a34 in out VARCHAR2
271 , p1_a35 in out VARCHAR2
272 , p1_a36 in out VARCHAR2
273 , p1_a37 in out DATE
274 , p1_a38 in out VARCHAR2
275 , p1_a39 in out DATE
276 , p1_a40 in out VARCHAR2
277 , p1_a41 in out VARCHAR2
278 , p1_a42 in out VARCHAR2
279 , p1_a43 in out NUMBER
280 , p1_a44 in out NUMBER
281 , p1_a45 in out NUMBER
282 , p1_a46 in out NUMBER
283 , p1_a47 in out NUMBER
284 , p1_a48 in out NUMBER
285 , p1_a49 in out VARCHAR2
286 , p1_a50 in out NUMBER
287 , p1_a51 in out NUMBER
288 , p1_a52 in out NUMBER
289 , p1_a53 in out VARCHAR2
290 , p1_a54 in out VARCHAR2
291 , p1_a55 in out VARCHAR2
292 , p1_a56 in out NUMBER
293 , p1_a57 in out DATE
294 , p1_a58 in out NUMBER
295 , p1_a59 in out DATE
296 , p1_a60 in out VARCHAR2
297 , p1_a61 in out NUMBER
298 , p1_a62 in out NUMBER
299 , p1_a63 in out NUMBER
300 , p1_a64 in out VARCHAR2
301 , p1_a65 in out NUMBER
302 , p1_a66 in out NUMBER
303 , p1_a67 in out NUMBER
304 , p1_a68 in out NUMBER
305 , p1_a69 in out NUMBER
306 , p1_a70 in out VARCHAR2
307 , p1_a71 in out VARCHAR2
308 , p1_a72 in out NUMBER
309 , p1_a73 in out NUMBER
310 , p1_a74 in out NUMBER
311 , p1_a75 in out VARCHAR2
312 , p1_a76 in out VARCHAR2
313 , p1_a77 in out NUMBER
314 , p1_a78 in out VARCHAR2
315 , p1_a79 in out VARCHAR2
316 , p1_a80 in out VARCHAR2
317 , p1_a81 in out VARCHAR2
318 , p1_a82 in out NUMBER
319 , p1_a83 in out NUMBER
320 , p1_a84 in out VARCHAR2
321 , p1_a85 in out NUMBER
322 , p1_a86 in out VARCHAR2
323 , p1_a87 in out DATE
324 , p1_a88 in out NUMBER
325 , p1_a89 in out VARCHAR2
326 , p1_a90 in out NUMBER
327 , p1_a91 in out NUMBER
328 , p1_a92 in out DATE
329 , p1_a93 in out NUMBER
330 , p1_a94 in out DATE
331 , p1_a95 in out VARCHAR2
332 , p1_a96 in out NUMBER
333 , p1_a97 in out NUMBER
334 , p1_a98 in out NUMBER
335 , p1_a99 in out VARCHAR2
336 , p1_a100 in out DATE
337 , p1_a101 in out NUMBER
338 , p1_a102 in out NUMBER
339 , p1_a103 in out VARCHAR2
340 , p1_a104 in out VARCHAR2
341 , p1_a105 in out NUMBER
342 , p1_a106 in out DATE
343 , p1_a107 in out DATE
344 , p1_a108 in out VARCHAR2
345 , p1_a109 in out VARCHAR2
346 , p1_a110 in out NUMBER
347 , p1_a111 in out VARCHAR2
348 , p1_a112 in out NUMBER
349 , p1_a113 in out NUMBER
350 , p1_a114 in out VARCHAR2
351 , p1_a115 in out VARCHAR2
352 , p1_a116 in out NUMBER
353 , p1_a117 in out NUMBER
354 , p1_a118 in out VARCHAR2
355 , p1_a119 in out VARCHAR2
356 , p1_a120 in out NUMBER
357 , p1_a121 in out VARCHAR2
358 , p1_a122 in out NUMBER
359 , p1_a123 in out NUMBER
360 , p1_a124 in out NUMBER
361 , p1_a125 in out NUMBER
362 , p1_a126 in out NUMBER
363 , p1_a127 in out NUMBER
364 , p1_a128 in out NUMBER
365 , p1_a129 in out NUMBER
366 , p1_a130 in out VARCHAR2
367 , p1_a131 in out NUMBER
368 , p1_a132 in out NUMBER
369 , p1_a133 in out NUMBER
370 , p1_a134 in out VARCHAR2
371 , p1_a135 in out NUMBER
372 , p1_a136 in out NUMBER
373 , p1_a137 in out VARCHAR2
374 , p1_a138 in out DATE
375 , p1_a139 in out VARCHAR2
376 , p1_a140 in out VARCHAR2
377 , p1_a141 in out VARCHAR2
378 , p1_a142 in out VARCHAR2
379 , p1_a143 in out NUMBER
380 , p1_a144 in out NUMBER
381 , p1_a145 in out VARCHAR2
382 , p1_a146 in out NUMBER
383 , p1_a147 in out NUMBER
384 , p1_a148 in out NUMBER
385 , p1_a149 in out NUMBER
386 , p1_a150 in out NUMBER
387 , p1_a151 in out NUMBER
388 , p1_a152 in out NUMBER
389 , p1_a153 in out VARCHAR2
390 , p1_a154 in out VARCHAR2
391 , p1_a155 in out VARCHAR2
392 , p1_a156 in out VARCHAR2
393 , p1_a157 in out VARCHAR2
394 , p1_a158 in out DATE
395 , p1_a159 in out VARCHAR2
396 , p1_a160 in out DATE
397 , p1_a161 in out VARCHAR2
398 , p1_a162 in out VARCHAR2
399 , p1_a163 in out VARCHAR2
400 , p1_a164 in out VARCHAR2
401 , p1_a165 in out VARCHAR2
402 , p1_a166 in out NUMBER
403 , p1_a167 in out VARCHAR2
404 , p1_a168 in out VARCHAR2
405 , p1_a169 in out VARCHAR2
406 , p1_a170 in out VARCHAR2
407 , p1_a171 in out VARCHAR2
408 , p1_a172 in out VARCHAR2
409 , p1_a173 in out VARCHAR2
410 , p1_a174 in out NUMBER
411 , p1_a175 in out NUMBER
412 , p1_a176 in out NUMBER
413 , p1_a177 in out VARCHAR2
414 , p1_a178 in out VARCHAR2
415 , p1_a179 in out VARCHAR2
416 , p1_a180 in out VARCHAR2
417 , p1_a181 in out NUMBER
418 , p1_a182 in out VARCHAR2
419 , p1_a183 in out VARCHAR2
420 , p1_a184 in out NUMBER
421 , p1_a185 in out VARCHAR2
422 , p1_a186 in out DATE
423 , p1_a187 in out DATE
424 , p1_a188 in out VARCHAR2
425 , p1_a189 in out NUMBER
426 , p1_a190 in out NUMBER
427 , p1_a191 in out NUMBER
428 , p1_a192 in out NUMBER
429 , p1_a193 in out VARCHAR2
430 , p1_a194 in out NUMBER
431 , p1_a195 in out NUMBER
432 , p1_a196 in out NUMBER
433 , p1_a197 in out NUMBER
434 , p1_a198 in out VARCHAR2
435 , p1_a199 in out VARCHAR2
436 , p1_a200 in out VARCHAR2
437 , p1_a201 in out NUMBER
438 , p1_a202 in out NUMBER
439 , p1_a203 in out NUMBER
440 , p1_a204 in out NUMBER
441 , p1_a205 in out VARCHAR2
442 , p1_a206 in out VARCHAR2
443 , p1_a207 in out VARCHAR2
444 , p1_a208 in out VARCHAR2
445 , p1_a209 in out VARCHAR2
446 , p1_a210 in out VARCHAR2
447 , p1_a211 in out VARCHAR2
448 , p1_a212 in out NUMBER
449 , p1_a213 in out NUMBER
450 , p1_a214 in out DATE
451 , p1_a215 in out NUMBER
452 , p1_a216 in out VARCHAR2
453 , p1_a217 in out NUMBER
454 , p1_a218 in out VARCHAR2
455 , p1_a219 in out VARCHAR2
456 , p1_a220 in out VARCHAR2
457 , p1_a221 in out VARCHAR2
458 , p1_a222 in out VARCHAR2
459 , p1_a223 in out VARCHAR2
460 , p1_a224 in out NUMBER
461 , p1_a225 in out NUMBER
462 , p1_a226 in out NUMBER
463 , p1_a227 in out NUMBER
464 , p1_a228 in out VARCHAR2
465 , p1_a229 in out NUMBER
466 , p1_a230 in out VARCHAR2
467 , p1_a231 in out NUMBER
468 , p1_a232 in out VARCHAR2
469 , p1_a233 in out VARCHAR2
470 , p1_a234 in out NUMBER
471 , p1_a235 in out VARCHAR2
472 , p1_a236 in out NUMBER
473 , p1_a237 in out NUMBER
474 , p1_a238 in out NUMBER
475 , p1_a239 in out NUMBER
476 , p1_a240 in out NUMBER
477 , p1_a241 in out VARCHAR2
478 , p1_a242 in out VARCHAR2
479 , p1_a243 in out NUMBER
480 , p1_a244 in out NUMBER
481 , p1_a245 in out NUMBER
482 , p1_a246 in out NUMBER
483 , p1_a247 in out VARCHAR2
484 , p1_a248 in out VARCHAR2
485 , p1_a249 in out DATE
486 , p1_a250 in out VARCHAR2
487 , p1_a251 in out NUMBER
488 , p1_a252 in out NUMBER
489 , p1_a253 in out VARCHAR2
490 , p1_a254 in out VARCHAR2
491 , p1_a255 in out VARCHAR2
492 , p1_a256 in out NUMBER
493 , p1_a257 in out NUMBER
494 , p1_a258 in out NUMBER
495 , p1_a259 in out VARCHAR2
496 , p1_a260 in out DATE
497 , p1_a261 in out VARCHAR2
498 , p1_a262 in out DATE
499 , p1_a263 in out NUMBER
500 , p1_a264 in out NUMBER
501 , p1_a265 in out NUMBER
502 , p1_a266 in out NUMBER
503 , p1_a267 in out NUMBER
504 , p1_a268 in out NUMBER
505 , p1_a269 in out NUMBER
506 , p1_a270 in out NUMBER
507 , p1_a271 in out NUMBER
508 , p1_a272 in out NUMBER
509 , p1_a273 in out NUMBER
510 , p1_a274 in out NUMBER
511 , p1_a275 in out NUMBER
512 , p1_a276 in out NUMBER
513 , p1_a277 in out NUMBER
514 , p1_a278 in out NUMBER
515 , p1_a279 in out NUMBER
516 , p1_a280 in out NUMBER
517 , p2_a0 in out JTF_VARCHAR2_TABLE_300
518 , p2_a1 in out JTF_VARCHAR2_TABLE_300
519 , p2_a2 in out JTF_VARCHAR2_TABLE_300
520 , p2_a3 in out JTF_VARCHAR2_TABLE_300
521 , p2_a4 in out JTF_VARCHAR2_TABLE_300
522 , p2_a5 in out JTF_VARCHAR2_TABLE_300
523 , p2_a6 in out JTF_VARCHAR2_TABLE_300
524 , p2_a7 in out JTF_VARCHAR2_TABLE_300
525 , p2_a8 in out JTF_VARCHAR2_TABLE_300
526 , p2_a9 in out JTF_VARCHAR2_TABLE_300
527 , p2_a10 in out JTF_VARCHAR2_TABLE_300
528 , p2_a11 in out JTF_VARCHAR2_TABLE_300
529 , p2_a12 in out JTF_VARCHAR2_TABLE_300
530 , p2_a13 in out JTF_VARCHAR2_TABLE_300
531 , p2_a14 in out JTF_VARCHAR2_TABLE_300
532 , p2_a15 in out JTF_VARCHAR2_TABLE_100
533 , p2_a16 in out JTF_VARCHAR2_TABLE_100
534 , p2_a17 in out JTF_NUMBER_TABLE
535 , p2_a18 in out JTF_DATE_TABLE
536 , p2_a19 in out JTF_NUMBER_TABLE
537 , p2_a20 in out JTF_NUMBER_TABLE
538 , p2_a21 in out JTF_NUMBER_TABLE
539 , p2_a22 in out JTF_NUMBER_TABLE
540 , p2_a23 in out JTF_DATE_TABLE
541 , p2_a24 in out JTF_NUMBER_TABLE
542 , p2_a25 in out JTF_NUMBER_TABLE
543 , p2_a26 in out JTF_NUMBER_TABLE
544 , p2_a27 in out JTF_NUMBER_TABLE
545 , p2_a28 in out JTF_NUMBER_TABLE
546 , p2_a29 in out JTF_NUMBER_TABLE
547 , p2_a30 in out JTF_DATE_TABLE
548 , p2_a31 in out JTF_NUMBER_TABLE
549 , p2_a32 in out JTF_VARCHAR2_TABLE_100
550 , p2_a33 in out JTF_VARCHAR2_TABLE_100
551 , p2_a34 in out JTF_VARCHAR2_TABLE_100
552 , p2_a35 in out JTF_NUMBER_TABLE
553 , p2_a36 in out JTF_VARCHAR2_TABLE_100
554 , p2_a37 in out JTF_VARCHAR2_TABLE_100
555 , p2_a38 in out JTF_VARCHAR2_TABLE_100
556 , p2_a39 in out JTF_NUMBER_TABLE
557 , p2_a40 in out JTF_NUMBER_TABLE
558 , p2_a41 in out JTF_VARCHAR2_TABLE_100
559 , p2_a42 in out JTF_VARCHAR2_TABLE_100
560 , p2_a43 in out JTF_VARCHAR2_TABLE_300
561 , p2_a44 in out JTF_VARCHAR2_TABLE_300
562 , p2_a45 in out JTF_VARCHAR2_TABLE_100
563 , p2_a46 in out JTF_VARCHAR2_TABLE_100
564 , p2_a47 in out JTF_VARCHAR2_TABLE_100
565 , p2_a48 in out JTF_VARCHAR2_TABLE_100
566 , p2_a49 in out JTF_VARCHAR2_TABLE_2000
567 , p2_a50 in out JTF_NUMBER_TABLE
568 , p2_a51 in out JTF_NUMBER_TABLE
569 , p2_a52 in out JTF_VARCHAR2_TABLE_100
570 , p2_a53 in out JTF_NUMBER_TABLE
571 , p2_a54 in out JTF_VARCHAR2_TABLE_100
572 , p2_a55 in out JTF_VARCHAR2_TABLE_100
573 , p2_a56 in out JTF_VARCHAR2_TABLE_100
574 , p2_a57 in out JTF_VARCHAR2_TABLE_100
575 , p2_a58 in out JTF_NUMBER_TABLE
576 , p2_a59 in out JTF_VARCHAR2_TABLE_100
577 , p2_a60 in out JTF_VARCHAR2_TABLE_100
578 , p2_a61 in out JTF_VARCHAR2_TABLE_100
579 , p2_a62 in out JTF_VARCHAR2_TABLE_100
580 , p2_a63 in out JTF_NUMBER_TABLE
581 , p2_a64 in out JTF_NUMBER_TABLE
582 , p2_a65 in out JTF_NUMBER_TABLE
583 , p2_a66 in out JTF_VARCHAR2_TABLE_100
584 , p2_a67 in out JTF_VARCHAR2_TABLE_100
585 , p2_a68 in out JTF_VARCHAR2_TABLE_300
586 , p2_a69 in out JTF_VARCHAR2_TABLE_100
587 , p2_a70 in out JTF_NUMBER_TABLE
588 , p2_a71 in out JTF_VARCHAR2_TABLE_100
589 , p2_a72 in out JTF_VARCHAR2_TABLE_100
590 , p2_a73 in out JTF_DATE_TABLE
591 , p2_a74 in out JTF_VARCHAR2_TABLE_100
592 , p2_a75 in out JTF_VARCHAR2_TABLE_100
593 , p2_a76 in out JTF_VARCHAR2_TABLE_100
594 , p2_a77 in out JTF_DATE_TABLE
595 , p2_a78 in out JTF_VARCHAR2_TABLE_100
596 , p2_a79 in out JTF_VARCHAR2_TABLE_100
597 , p2_a80 in out JTF_NUMBER_TABLE
598 , p2_a81 in out JTF_NUMBER_TABLE
599 , p2_a82 in out JTF_NUMBER_TABLE
600 , p2_a83 in out JTF_VARCHAR2_TABLE_100
601 , p2_a84 in out JTF_VARCHAR2_TABLE_100
602 , p2_a85 in out JTF_VARCHAR2_TABLE_100
603 , p2_a86 in out JTF_VARCHAR2_TABLE_100
604 , p2_a87 in out JTF_VARCHAR2_TABLE_100
605 , p2_a88 in out JTF_VARCHAR2_TABLE_100
606 , p2_a89 in out JTF_VARCHAR2_TABLE_300
607 , p2_a90 in out JTF_VARCHAR2_TABLE_300
608 , p2_a91 in out JTF_VARCHAR2_TABLE_300
609 , p2_a92 in out JTF_VARCHAR2_TABLE_300
610 , p2_a93 in out JTF_VARCHAR2_TABLE_300
611 , p2_a94 in out JTF_VARCHAR2_TABLE_300
612 , p2_a95 in out JTF_VARCHAR2_TABLE_300
613 , p2_a96 in out JTF_VARCHAR2_TABLE_300
614 , p2_a97 in out JTF_VARCHAR2_TABLE_300
615 , p2_a98 in out JTF_VARCHAR2_TABLE_300
616 , p2_a99 in out JTF_VARCHAR2_TABLE_300
617 , p2_a100 in out JTF_VARCHAR2_TABLE_300
618 , p2_a101 in out JTF_VARCHAR2_TABLE_300
619 , p2_a102 in out JTF_VARCHAR2_TABLE_300
620 , p2_a103 in out JTF_VARCHAR2_TABLE_300
621 , p2_a104 in out JTF_VARCHAR2_TABLE_200
622 , p2_a105 in out JTF_NUMBER_TABLE
623 , p2_a106 in out JTF_NUMBER_TABLE
624 , p2_a107 in out JTF_NUMBER_TABLE
625 , p2_a108 in out JTF_NUMBER_TABLE
626 , p3_a0 JTF_NUMBER_TABLE
627 , p3_a1 JTF_NUMBER_TABLE
628 , p3_a2 JTF_VARCHAR2_TABLE_100
629 , p3_a3 JTF_VARCHAR2_TABLE_100
630 , p3_a4 JTF_VARCHAR2_TABLE_100
631 , p3_a5 JTF_VARCHAR2_TABLE_300
632 , p3_a6 JTF_VARCHAR2_TABLE_100
633 , p_action_code VARCHAR2
634 , p_pricing_events VARCHAR2
635 , p_simulation_flag VARCHAR2
636 , p_get_freight_flag VARCHAR2
637 , x_return_status out VARCHAR2
638 );
639 end oe_price_order_pvt_w_obsolete;
[Home] [Help]