DBA Data[Home] [Help]

APPS.OKL_OPT_RUL_TMP_PVT_W dependencies on JTF_NUMBER_TABLE

Line 139: , p6_a1 JTF_NUMBER_TABLE

135: , x_msg_count out nocopy NUMBER
136: , x_msg_data out nocopy VARCHAR2
137: , p_ovd_id NUMBER
138: , p6_a0 JTF_VARCHAR2_TABLE_100
139: , p6_a1 JTF_NUMBER_TABLE
140: , p6_a2 JTF_NUMBER_TABLE
141: , p6_a3 JTF_VARCHAR2_TABLE_100
142: , p6_a4 JTF_VARCHAR2_TABLE_100
143: , p6_a5 JTF_VARCHAR2_TABLE_100

Line 140: , p6_a2 JTF_NUMBER_TABLE

136: , x_msg_data out nocopy VARCHAR2
137: , p_ovd_id NUMBER
138: , p6_a0 JTF_VARCHAR2_TABLE_100
139: , p6_a1 JTF_NUMBER_TABLE
140: , p6_a2 JTF_NUMBER_TABLE
141: , p6_a3 JTF_VARCHAR2_TABLE_100
142: , p6_a4 JTF_VARCHAR2_TABLE_100
143: , p6_a5 JTF_VARCHAR2_TABLE_100
144: , p6_a6 JTF_VARCHAR2_TABLE_100

Line 151: , p6_a13 JTF_NUMBER_TABLE

147: , p6_a9 JTF_VARCHAR2_TABLE_200
148: , p6_a10 JTF_VARCHAR2_TABLE_100
149: , p6_a11 JTF_VARCHAR2_TABLE_100
150: , p6_a12 JTF_VARCHAR2_TABLE_100
151: , p6_a13 JTF_NUMBER_TABLE
152: , p6_a14 JTF_NUMBER_TABLE
153: , p6_a15 JTF_NUMBER_TABLE
154: , p6_a16 JTF_VARCHAR2_TABLE_100
155: , p6_a17 JTF_VARCHAR2_TABLE_2000

Line 152: , p6_a14 JTF_NUMBER_TABLE

148: , p6_a10 JTF_VARCHAR2_TABLE_100
149: , p6_a11 JTF_VARCHAR2_TABLE_100
150: , p6_a12 JTF_VARCHAR2_TABLE_100
151: , p6_a13 JTF_NUMBER_TABLE
152: , p6_a14 JTF_NUMBER_TABLE
153: , p6_a15 JTF_NUMBER_TABLE
154: , p6_a16 JTF_VARCHAR2_TABLE_100
155: , p6_a17 JTF_VARCHAR2_TABLE_2000
156: , p6_a18 JTF_VARCHAR2_TABLE_100

Line 153: , p6_a15 JTF_NUMBER_TABLE

149: , p6_a11 JTF_VARCHAR2_TABLE_100
150: , p6_a12 JTF_VARCHAR2_TABLE_100
151: , p6_a13 JTF_NUMBER_TABLE
152: , p6_a14 JTF_NUMBER_TABLE
153: , p6_a15 JTF_NUMBER_TABLE
154: , p6_a16 JTF_VARCHAR2_TABLE_100
155: , p6_a17 JTF_VARCHAR2_TABLE_2000
156: , p6_a18 JTF_VARCHAR2_TABLE_100
157: , p6_a19 JTF_VARCHAR2_TABLE_100

Line 173: , p6_a35 JTF_NUMBER_TABLE

169: , p6_a31 JTF_VARCHAR2_TABLE_500
170: , p6_a32 JTF_VARCHAR2_TABLE_500
171: , p6_a33 JTF_VARCHAR2_TABLE_500
172: , p6_a34 JTF_VARCHAR2_TABLE_500
173: , p6_a35 JTF_NUMBER_TABLE
174: , p6_a36 JTF_DATE_TABLE
175: , p6_a37 JTF_NUMBER_TABLE
176: , p6_a38 JTF_DATE_TABLE
177: , p6_a39 JTF_NUMBER_TABLE

Line 175: , p6_a37 JTF_NUMBER_TABLE

171: , p6_a33 JTF_VARCHAR2_TABLE_500
172: , p6_a34 JTF_VARCHAR2_TABLE_500
173: , p6_a35 JTF_NUMBER_TABLE
174: , p6_a36 JTF_DATE_TABLE
175: , p6_a37 JTF_NUMBER_TABLE
176: , p6_a38 JTF_DATE_TABLE
177: , p6_a39 JTF_NUMBER_TABLE
178: , p6_a40 JTF_VARCHAR2_TABLE_100
179: , p6_a41 JTF_VARCHAR2_TABLE_500

Line 177: , p6_a39 JTF_NUMBER_TABLE

173: , p6_a35 JTF_NUMBER_TABLE
174: , p6_a36 JTF_DATE_TABLE
175: , p6_a37 JTF_NUMBER_TABLE
176: , p6_a38 JTF_DATE_TABLE
177: , p6_a39 JTF_NUMBER_TABLE
178: , p6_a40 JTF_VARCHAR2_TABLE_100
179: , p6_a41 JTF_VARCHAR2_TABLE_500
180: , p6_a42 JTF_VARCHAR2_TABLE_500
181: , p6_a43 JTF_VARCHAR2_TABLE_500

Line 198: , p6_a60 JTF_NUMBER_TABLE

194: , p6_a56 JTF_VARCHAR2_TABLE_100
195: , p6_a57 JTF_VARCHAR2_TABLE_100
196: , p6_a58 JTF_VARCHAR2_TABLE_100
197: , p6_a59 JTF_VARCHAR2_TABLE_100
198: , p6_a60 JTF_NUMBER_TABLE
199: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
200: , p7_a1 out nocopy JTF_NUMBER_TABLE
201: , p7_a2 out nocopy JTF_NUMBER_TABLE
202: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 200: , p7_a1 out nocopy JTF_NUMBER_TABLE

196: , p6_a58 JTF_VARCHAR2_TABLE_100
197: , p6_a59 JTF_VARCHAR2_TABLE_100
198: , p6_a60 JTF_NUMBER_TABLE
199: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
200: , p7_a1 out nocopy JTF_NUMBER_TABLE
201: , p7_a2 out nocopy JTF_NUMBER_TABLE
202: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
204: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 201: , p7_a2 out nocopy JTF_NUMBER_TABLE

197: , p6_a59 JTF_VARCHAR2_TABLE_100
198: , p6_a60 JTF_NUMBER_TABLE
199: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
200: , p7_a1 out nocopy JTF_NUMBER_TABLE
201: , p7_a2 out nocopy JTF_NUMBER_TABLE
202: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
203: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
204: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
205: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 212: , p7_a13 out nocopy JTF_NUMBER_TABLE

208: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_200
209: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
210: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
211: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
212: , p7_a13 out nocopy JTF_NUMBER_TABLE
213: , p7_a14 out nocopy JTF_NUMBER_TABLE
214: , p7_a15 out nocopy JTF_NUMBER_TABLE
215: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
216: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000

Line 213: , p7_a14 out nocopy JTF_NUMBER_TABLE

209: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
210: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
211: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
212: , p7_a13 out nocopy JTF_NUMBER_TABLE
213: , p7_a14 out nocopy JTF_NUMBER_TABLE
214: , p7_a15 out nocopy JTF_NUMBER_TABLE
215: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
216: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000
217: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 214: , p7_a15 out nocopy JTF_NUMBER_TABLE

210: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
211: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
212: , p7_a13 out nocopy JTF_NUMBER_TABLE
213: , p7_a14 out nocopy JTF_NUMBER_TABLE
214: , p7_a15 out nocopy JTF_NUMBER_TABLE
215: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
216: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000
217: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
218: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 234: , p7_a35 out nocopy JTF_NUMBER_TABLE

230: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_500
231: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_500
232: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_500
233: , p7_a34 out nocopy JTF_VARCHAR2_TABLE_500
234: , p7_a35 out nocopy JTF_NUMBER_TABLE
235: , p7_a36 out nocopy JTF_DATE_TABLE
236: , p7_a37 out nocopy JTF_NUMBER_TABLE
237: , p7_a38 out nocopy JTF_DATE_TABLE
238: , p7_a39 out nocopy JTF_NUMBER_TABLE

Line 236: , p7_a37 out nocopy JTF_NUMBER_TABLE

232: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_500
233: , p7_a34 out nocopy JTF_VARCHAR2_TABLE_500
234: , p7_a35 out nocopy JTF_NUMBER_TABLE
235: , p7_a36 out nocopy JTF_DATE_TABLE
236: , p7_a37 out nocopy JTF_NUMBER_TABLE
237: , p7_a38 out nocopy JTF_DATE_TABLE
238: , p7_a39 out nocopy JTF_NUMBER_TABLE
239: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
240: , p7_a41 out nocopy JTF_VARCHAR2_TABLE_500

Line 238: , p7_a39 out nocopy JTF_NUMBER_TABLE

234: , p7_a35 out nocopy JTF_NUMBER_TABLE
235: , p7_a36 out nocopy JTF_DATE_TABLE
236: , p7_a37 out nocopy JTF_NUMBER_TABLE
237: , p7_a38 out nocopy JTF_DATE_TABLE
238: , p7_a39 out nocopy JTF_NUMBER_TABLE
239: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
240: , p7_a41 out nocopy JTF_VARCHAR2_TABLE_500
241: , p7_a42 out nocopy JTF_VARCHAR2_TABLE_500
242: , p7_a43 out nocopy JTF_VARCHAR2_TABLE_500

Line 259: , p7_a60 out nocopy JTF_NUMBER_TABLE

255: , p7_a56 out nocopy JTF_VARCHAR2_TABLE_100
256: , p7_a57 out nocopy JTF_VARCHAR2_TABLE_100
257: , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100
258: , p7_a59 out nocopy JTF_VARCHAR2_TABLE_100
259: , p7_a60 out nocopy JTF_NUMBER_TABLE
260: );
261: procedure update_row(p_api_version NUMBER
262: , p_init_msg_list VARCHAR2
263: , x_return_status out nocopy VARCHAR2

Line 395: , p5_a1 JTF_NUMBER_TABLE

391: , x_return_status out nocopy VARCHAR2
392: , x_msg_count out nocopy NUMBER
393: , x_msg_data out nocopy VARCHAR2
394: , p5_a0 JTF_VARCHAR2_TABLE_100
395: , p5_a1 JTF_NUMBER_TABLE
396: , p5_a2 JTF_NUMBER_TABLE
397: , p5_a3 JTF_VARCHAR2_TABLE_100
398: , p5_a4 JTF_VARCHAR2_TABLE_100
399: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 396: , p5_a2 JTF_NUMBER_TABLE

392: , x_msg_count out nocopy NUMBER
393: , x_msg_data out nocopy VARCHAR2
394: , p5_a0 JTF_VARCHAR2_TABLE_100
395: , p5_a1 JTF_NUMBER_TABLE
396: , p5_a2 JTF_NUMBER_TABLE
397: , p5_a3 JTF_VARCHAR2_TABLE_100
398: , p5_a4 JTF_VARCHAR2_TABLE_100
399: , p5_a5 JTF_VARCHAR2_TABLE_100
400: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 407: , p5_a13 JTF_NUMBER_TABLE

403: , p5_a9 JTF_VARCHAR2_TABLE_200
404: , p5_a10 JTF_VARCHAR2_TABLE_100
405: , p5_a11 JTF_VARCHAR2_TABLE_100
406: , p5_a12 JTF_VARCHAR2_TABLE_100
407: , p5_a13 JTF_NUMBER_TABLE
408: , p5_a14 JTF_NUMBER_TABLE
409: , p5_a15 JTF_NUMBER_TABLE
410: , p5_a16 JTF_VARCHAR2_TABLE_100
411: , p5_a17 JTF_VARCHAR2_TABLE_2000

Line 408: , p5_a14 JTF_NUMBER_TABLE

404: , p5_a10 JTF_VARCHAR2_TABLE_100
405: , p5_a11 JTF_VARCHAR2_TABLE_100
406: , p5_a12 JTF_VARCHAR2_TABLE_100
407: , p5_a13 JTF_NUMBER_TABLE
408: , p5_a14 JTF_NUMBER_TABLE
409: , p5_a15 JTF_NUMBER_TABLE
410: , p5_a16 JTF_VARCHAR2_TABLE_100
411: , p5_a17 JTF_VARCHAR2_TABLE_2000
412: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 409: , p5_a15 JTF_NUMBER_TABLE

405: , p5_a11 JTF_VARCHAR2_TABLE_100
406: , p5_a12 JTF_VARCHAR2_TABLE_100
407: , p5_a13 JTF_NUMBER_TABLE
408: , p5_a14 JTF_NUMBER_TABLE
409: , p5_a15 JTF_NUMBER_TABLE
410: , p5_a16 JTF_VARCHAR2_TABLE_100
411: , p5_a17 JTF_VARCHAR2_TABLE_2000
412: , p5_a18 JTF_VARCHAR2_TABLE_100
413: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 429: , p5_a35 JTF_NUMBER_TABLE

425: , p5_a31 JTF_VARCHAR2_TABLE_500
426: , p5_a32 JTF_VARCHAR2_TABLE_500
427: , p5_a33 JTF_VARCHAR2_TABLE_500
428: , p5_a34 JTF_VARCHAR2_TABLE_500
429: , p5_a35 JTF_NUMBER_TABLE
430: , p5_a36 JTF_DATE_TABLE
431: , p5_a37 JTF_NUMBER_TABLE
432: , p5_a38 JTF_DATE_TABLE
433: , p5_a39 JTF_NUMBER_TABLE

Line 431: , p5_a37 JTF_NUMBER_TABLE

427: , p5_a33 JTF_VARCHAR2_TABLE_500
428: , p5_a34 JTF_VARCHAR2_TABLE_500
429: , p5_a35 JTF_NUMBER_TABLE
430: , p5_a36 JTF_DATE_TABLE
431: , p5_a37 JTF_NUMBER_TABLE
432: , p5_a38 JTF_DATE_TABLE
433: , p5_a39 JTF_NUMBER_TABLE
434: , p5_a40 JTF_VARCHAR2_TABLE_100
435: , p5_a41 JTF_VARCHAR2_TABLE_500

Line 433: , p5_a39 JTF_NUMBER_TABLE

429: , p5_a35 JTF_NUMBER_TABLE
430: , p5_a36 JTF_DATE_TABLE
431: , p5_a37 JTF_NUMBER_TABLE
432: , p5_a38 JTF_DATE_TABLE
433: , p5_a39 JTF_NUMBER_TABLE
434: , p5_a40 JTF_VARCHAR2_TABLE_100
435: , p5_a41 JTF_VARCHAR2_TABLE_500
436: , p5_a42 JTF_VARCHAR2_TABLE_500
437: , p5_a43 JTF_VARCHAR2_TABLE_500

Line 454: , p5_a60 JTF_NUMBER_TABLE

450: , p5_a56 JTF_VARCHAR2_TABLE_100
451: , p5_a57 JTF_VARCHAR2_TABLE_100
452: , p5_a58 JTF_VARCHAR2_TABLE_100
453: , p5_a59 JTF_VARCHAR2_TABLE_100
454: , p5_a60 JTF_NUMBER_TABLE
455: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
456: , p6_a1 out nocopy JTF_NUMBER_TABLE
457: , p6_a2 out nocopy JTF_NUMBER_TABLE
458: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 456: , p6_a1 out nocopy JTF_NUMBER_TABLE

452: , p5_a58 JTF_VARCHAR2_TABLE_100
453: , p5_a59 JTF_VARCHAR2_TABLE_100
454: , p5_a60 JTF_NUMBER_TABLE
455: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
456: , p6_a1 out nocopy JTF_NUMBER_TABLE
457: , p6_a2 out nocopy JTF_NUMBER_TABLE
458: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
459: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
460: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 457: , p6_a2 out nocopy JTF_NUMBER_TABLE

453: , p5_a59 JTF_VARCHAR2_TABLE_100
454: , p5_a60 JTF_NUMBER_TABLE
455: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
456: , p6_a1 out nocopy JTF_NUMBER_TABLE
457: , p6_a2 out nocopy JTF_NUMBER_TABLE
458: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
459: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
460: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
461: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 468: , p6_a13 out nocopy JTF_NUMBER_TABLE

464: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
465: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
467: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a13 out nocopy JTF_NUMBER_TABLE
469: , p6_a14 out nocopy JTF_NUMBER_TABLE
470: , p6_a15 out nocopy JTF_NUMBER_TABLE
471: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
472: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000

Line 469: , p6_a14 out nocopy JTF_NUMBER_TABLE

465: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
466: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
467: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a13 out nocopy JTF_NUMBER_TABLE
469: , p6_a14 out nocopy JTF_NUMBER_TABLE
470: , p6_a15 out nocopy JTF_NUMBER_TABLE
471: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
472: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
473: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 470: , p6_a15 out nocopy JTF_NUMBER_TABLE

466: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
467: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
468: , p6_a13 out nocopy JTF_NUMBER_TABLE
469: , p6_a14 out nocopy JTF_NUMBER_TABLE
470: , p6_a15 out nocopy JTF_NUMBER_TABLE
471: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
472: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
473: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
474: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 490: , p6_a35 out nocopy JTF_NUMBER_TABLE

486: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
487: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
488: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
489: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
490: , p6_a35 out nocopy JTF_NUMBER_TABLE
491: , p6_a36 out nocopy JTF_DATE_TABLE
492: , p6_a37 out nocopy JTF_NUMBER_TABLE
493: , p6_a38 out nocopy JTF_DATE_TABLE
494: , p6_a39 out nocopy JTF_NUMBER_TABLE

Line 492: , p6_a37 out nocopy JTF_NUMBER_TABLE

488: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
489: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
490: , p6_a35 out nocopy JTF_NUMBER_TABLE
491: , p6_a36 out nocopy JTF_DATE_TABLE
492: , p6_a37 out nocopy JTF_NUMBER_TABLE
493: , p6_a38 out nocopy JTF_DATE_TABLE
494: , p6_a39 out nocopy JTF_NUMBER_TABLE
495: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
496: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500

Line 494: , p6_a39 out nocopy JTF_NUMBER_TABLE

490: , p6_a35 out nocopy JTF_NUMBER_TABLE
491: , p6_a36 out nocopy JTF_DATE_TABLE
492: , p6_a37 out nocopy JTF_NUMBER_TABLE
493: , p6_a38 out nocopy JTF_DATE_TABLE
494: , p6_a39 out nocopy JTF_NUMBER_TABLE
495: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
496: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
497: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
498: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500

Line 515: , p6_a60 out nocopy JTF_NUMBER_TABLE

511: , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
512: , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
513: , p6_a58 out nocopy JTF_VARCHAR2_TABLE_100
514: , p6_a59 out nocopy JTF_VARCHAR2_TABLE_100
515: , p6_a60 out nocopy JTF_NUMBER_TABLE
516: );
517: procedure delete_row(p_api_version NUMBER
518: , p_init_msg_list VARCHAR2
519: , x_return_status out nocopy VARCHAR2

Line 590: , p5_a1 JTF_NUMBER_TABLE

586: , x_return_status out nocopy VARCHAR2
587: , x_msg_count out nocopy NUMBER
588: , x_msg_data out nocopy VARCHAR2
589: , p5_a0 JTF_VARCHAR2_TABLE_100
590: , p5_a1 JTF_NUMBER_TABLE
591: , p5_a2 JTF_NUMBER_TABLE
592: , p5_a3 JTF_VARCHAR2_TABLE_100
593: , p5_a4 JTF_VARCHAR2_TABLE_100
594: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 591: , p5_a2 JTF_NUMBER_TABLE

587: , x_msg_count out nocopy NUMBER
588: , x_msg_data out nocopy VARCHAR2
589: , p5_a0 JTF_VARCHAR2_TABLE_100
590: , p5_a1 JTF_NUMBER_TABLE
591: , p5_a2 JTF_NUMBER_TABLE
592: , p5_a3 JTF_VARCHAR2_TABLE_100
593: , p5_a4 JTF_VARCHAR2_TABLE_100
594: , p5_a5 JTF_VARCHAR2_TABLE_100
595: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 602: , p5_a13 JTF_NUMBER_TABLE

598: , p5_a9 JTF_VARCHAR2_TABLE_200
599: , p5_a10 JTF_VARCHAR2_TABLE_100
600: , p5_a11 JTF_VARCHAR2_TABLE_100
601: , p5_a12 JTF_VARCHAR2_TABLE_100
602: , p5_a13 JTF_NUMBER_TABLE
603: , p5_a14 JTF_NUMBER_TABLE
604: , p5_a15 JTF_NUMBER_TABLE
605: , p5_a16 JTF_VARCHAR2_TABLE_100
606: , p5_a17 JTF_VARCHAR2_TABLE_2000

Line 603: , p5_a14 JTF_NUMBER_TABLE

599: , p5_a10 JTF_VARCHAR2_TABLE_100
600: , p5_a11 JTF_VARCHAR2_TABLE_100
601: , p5_a12 JTF_VARCHAR2_TABLE_100
602: , p5_a13 JTF_NUMBER_TABLE
603: , p5_a14 JTF_NUMBER_TABLE
604: , p5_a15 JTF_NUMBER_TABLE
605: , p5_a16 JTF_VARCHAR2_TABLE_100
606: , p5_a17 JTF_VARCHAR2_TABLE_2000
607: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 604: , p5_a15 JTF_NUMBER_TABLE

600: , p5_a11 JTF_VARCHAR2_TABLE_100
601: , p5_a12 JTF_VARCHAR2_TABLE_100
602: , p5_a13 JTF_NUMBER_TABLE
603: , p5_a14 JTF_NUMBER_TABLE
604: , p5_a15 JTF_NUMBER_TABLE
605: , p5_a16 JTF_VARCHAR2_TABLE_100
606: , p5_a17 JTF_VARCHAR2_TABLE_2000
607: , p5_a18 JTF_VARCHAR2_TABLE_100
608: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 624: , p5_a35 JTF_NUMBER_TABLE

620: , p5_a31 JTF_VARCHAR2_TABLE_500
621: , p5_a32 JTF_VARCHAR2_TABLE_500
622: , p5_a33 JTF_VARCHAR2_TABLE_500
623: , p5_a34 JTF_VARCHAR2_TABLE_500
624: , p5_a35 JTF_NUMBER_TABLE
625: , p5_a36 JTF_DATE_TABLE
626: , p5_a37 JTF_NUMBER_TABLE
627: , p5_a38 JTF_DATE_TABLE
628: , p5_a39 JTF_NUMBER_TABLE

Line 626: , p5_a37 JTF_NUMBER_TABLE

622: , p5_a33 JTF_VARCHAR2_TABLE_500
623: , p5_a34 JTF_VARCHAR2_TABLE_500
624: , p5_a35 JTF_NUMBER_TABLE
625: , p5_a36 JTF_DATE_TABLE
626: , p5_a37 JTF_NUMBER_TABLE
627: , p5_a38 JTF_DATE_TABLE
628: , p5_a39 JTF_NUMBER_TABLE
629: , p5_a40 JTF_VARCHAR2_TABLE_100
630: , p5_a41 JTF_VARCHAR2_TABLE_500

Line 628: , p5_a39 JTF_NUMBER_TABLE

624: , p5_a35 JTF_NUMBER_TABLE
625: , p5_a36 JTF_DATE_TABLE
626: , p5_a37 JTF_NUMBER_TABLE
627: , p5_a38 JTF_DATE_TABLE
628: , p5_a39 JTF_NUMBER_TABLE
629: , p5_a40 JTF_VARCHAR2_TABLE_100
630: , p5_a41 JTF_VARCHAR2_TABLE_500
631: , p5_a42 JTF_VARCHAR2_TABLE_500
632: , p5_a43 JTF_VARCHAR2_TABLE_500

Line 649: , p5_a60 JTF_NUMBER_TABLE

645: , p5_a56 JTF_VARCHAR2_TABLE_100
646: , p5_a57 JTF_VARCHAR2_TABLE_100
647: , p5_a58 JTF_VARCHAR2_TABLE_100
648: , p5_a59 JTF_VARCHAR2_TABLE_100
649: , p5_a60 JTF_NUMBER_TABLE
650: );
651: end okl_opt_rul_tmp_pvt_w;