APPS.OKL_AM_SHIPPING_INSTR_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 98: , p5_a2 JTF_VARCHAR2_TABLE_100

94: , x_msg_count out nocopy NUMBER
95: , x_msg_data out nocopy VARCHAR2
96: , p5_a0 JTF_NUMBER_TABLE
97: , p5_a1 JTF_NUMBER_TABLE
98: , p5_a2 JTF_VARCHAR2_TABLE_100
99: , p5_a3 JTF_NUMBER_TABLE
100: , p5_a4 JTF_NUMBER_TABLE
101: , p5_a5 JTF_NUMBER_TABLE
102: , p5_a6 JTF_DATE_TABLE

Line 106: , p5_a10 JTF_VARCHAR2_TABLE_100

102: , p5_a6 JTF_DATE_TABLE
103: , p5_a7 JTF_VARCHAR2_TABLE_2000
104: , p5_a8 JTF_VARCHAR2_TABLE_300
105: , p5_a9 JTF_NUMBER_TABLE
106: , p5_a10 JTF_VARCHAR2_TABLE_100
107: , p5_a11 JTF_VARCHAR2_TABLE_500
108: , p5_a12 JTF_VARCHAR2_TABLE_500
109: , p5_a13 JTF_VARCHAR2_TABLE_500
110: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 132: , p5_a36 JTF_VARCHAR2_TABLE_100

128: , p5_a32 JTF_DATE_TABLE
129: , p5_a33 JTF_NUMBER_TABLE
130: , p5_a34 JTF_NUMBER_TABLE
131: , p5_a35 JTF_DATE_TABLE
132: , p5_a36 JTF_VARCHAR2_TABLE_100
133: , p5_a37 JTF_VARCHAR2_TABLE_100
134: , p5_a38 JTF_VARCHAR2_TABLE_100
135: , p5_a39 JTF_NUMBER_TABLE
136: , p5_a40 JTF_DATE_TABLE

Line 133: , p5_a37 JTF_VARCHAR2_TABLE_100

129: , p5_a33 JTF_NUMBER_TABLE
130: , p5_a34 JTF_NUMBER_TABLE
131: , p5_a35 JTF_DATE_TABLE
132: , p5_a36 JTF_VARCHAR2_TABLE_100
133: , p5_a37 JTF_VARCHAR2_TABLE_100
134: , p5_a38 JTF_VARCHAR2_TABLE_100
135: , p5_a39 JTF_NUMBER_TABLE
136: , p5_a40 JTF_DATE_TABLE
137: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 134: , p5_a38 JTF_VARCHAR2_TABLE_100

130: , p5_a34 JTF_NUMBER_TABLE
131: , p5_a35 JTF_DATE_TABLE
132: , p5_a36 JTF_VARCHAR2_TABLE_100
133: , p5_a37 JTF_VARCHAR2_TABLE_100
134: , p5_a38 JTF_VARCHAR2_TABLE_100
135: , p5_a39 JTF_NUMBER_TABLE
136: , p5_a40 JTF_DATE_TABLE
137: , p6_a0 out nocopy JTF_NUMBER_TABLE
138: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 139: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

135: , p5_a39 JTF_NUMBER_TABLE
136: , p5_a40 JTF_DATE_TABLE
137: , p6_a0 out nocopy JTF_NUMBER_TABLE
138: , p6_a1 out nocopy JTF_NUMBER_TABLE
139: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
140: , p6_a3 out nocopy JTF_NUMBER_TABLE
141: , p6_a4 out nocopy JTF_NUMBER_TABLE
142: , p6_a5 out nocopy JTF_NUMBER_TABLE
143: , p6_a6 out nocopy JTF_DATE_TABLE

Line 147: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

143: , p6_a6 out nocopy JTF_DATE_TABLE
144: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
145: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
146: , p6_a9 out nocopy JTF_NUMBER_TABLE
147: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
148: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
149: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
150: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
151: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 173: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

169: , p6_a32 out nocopy JTF_DATE_TABLE
170: , p6_a33 out nocopy JTF_NUMBER_TABLE
171: , p6_a34 out nocopy JTF_NUMBER_TABLE
172: , p6_a35 out nocopy JTF_DATE_TABLE
173: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
174: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
175: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
176: , p6_a39 out nocopy JTF_NUMBER_TABLE
177: , p6_a40 out nocopy JTF_DATE_TABLE

Line 174: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100

170: , p6_a33 out nocopy JTF_NUMBER_TABLE
171: , p6_a34 out nocopy JTF_NUMBER_TABLE
172: , p6_a35 out nocopy JTF_DATE_TABLE
173: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
174: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
175: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
176: , p6_a39 out nocopy JTF_NUMBER_TABLE
177: , p6_a40 out nocopy JTF_DATE_TABLE
178: );

Line 175: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

171: , p6_a34 out nocopy JTF_NUMBER_TABLE
172: , p6_a35 out nocopy JTF_DATE_TABLE
173: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
174: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
175: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
176: , p6_a39 out nocopy JTF_NUMBER_TABLE
177: , p6_a40 out nocopy JTF_DATE_TABLE
178: );
179: procedure update_shipping_instr(p_api_version NUMBER

Line 274: , p5_a2 JTF_VARCHAR2_TABLE_100

270: , x_msg_count out nocopy NUMBER
271: , x_msg_data out nocopy VARCHAR2
272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_100
275: , p5_a3 JTF_NUMBER_TABLE
276: , p5_a4 JTF_NUMBER_TABLE
277: , p5_a5 JTF_NUMBER_TABLE
278: , p5_a6 JTF_DATE_TABLE

Line 282: , p5_a10 JTF_VARCHAR2_TABLE_100

278: , p5_a6 JTF_DATE_TABLE
279: , p5_a7 JTF_VARCHAR2_TABLE_2000
280: , p5_a8 JTF_VARCHAR2_TABLE_300
281: , p5_a9 JTF_NUMBER_TABLE
282: , p5_a10 JTF_VARCHAR2_TABLE_100
283: , p5_a11 JTF_VARCHAR2_TABLE_500
284: , p5_a12 JTF_VARCHAR2_TABLE_500
285: , p5_a13 JTF_VARCHAR2_TABLE_500
286: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 308: , p5_a36 JTF_VARCHAR2_TABLE_100

304: , p5_a32 JTF_DATE_TABLE
305: , p5_a33 JTF_NUMBER_TABLE
306: , p5_a34 JTF_NUMBER_TABLE
307: , p5_a35 JTF_DATE_TABLE
308: , p5_a36 JTF_VARCHAR2_TABLE_100
309: , p5_a37 JTF_VARCHAR2_TABLE_100
310: , p5_a38 JTF_VARCHAR2_TABLE_100
311: , p5_a39 JTF_NUMBER_TABLE
312: , p5_a40 JTF_DATE_TABLE

Line 309: , p5_a37 JTF_VARCHAR2_TABLE_100

305: , p5_a33 JTF_NUMBER_TABLE
306: , p5_a34 JTF_NUMBER_TABLE
307: , p5_a35 JTF_DATE_TABLE
308: , p5_a36 JTF_VARCHAR2_TABLE_100
309: , p5_a37 JTF_VARCHAR2_TABLE_100
310: , p5_a38 JTF_VARCHAR2_TABLE_100
311: , p5_a39 JTF_NUMBER_TABLE
312: , p5_a40 JTF_DATE_TABLE
313: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 310: , p5_a38 JTF_VARCHAR2_TABLE_100

306: , p5_a34 JTF_NUMBER_TABLE
307: , p5_a35 JTF_DATE_TABLE
308: , p5_a36 JTF_VARCHAR2_TABLE_100
309: , p5_a37 JTF_VARCHAR2_TABLE_100
310: , p5_a38 JTF_VARCHAR2_TABLE_100
311: , p5_a39 JTF_NUMBER_TABLE
312: , p5_a40 JTF_DATE_TABLE
313: , p6_a0 out nocopy JTF_NUMBER_TABLE
314: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 315: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

311: , p5_a39 JTF_NUMBER_TABLE
312: , p5_a40 JTF_DATE_TABLE
313: , p6_a0 out nocopy JTF_NUMBER_TABLE
314: , p6_a1 out nocopy JTF_NUMBER_TABLE
315: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a3 out nocopy JTF_NUMBER_TABLE
317: , p6_a4 out nocopy JTF_NUMBER_TABLE
318: , p6_a5 out nocopy JTF_NUMBER_TABLE
319: , p6_a6 out nocopy JTF_DATE_TABLE

Line 323: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

319: , p6_a6 out nocopy JTF_DATE_TABLE
320: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
321: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
322: , p6_a9 out nocopy JTF_NUMBER_TABLE
323: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
324: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
325: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
326: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
327: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 349: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

345: , p6_a32 out nocopy JTF_DATE_TABLE
346: , p6_a33 out nocopy JTF_NUMBER_TABLE
347: , p6_a34 out nocopy JTF_NUMBER_TABLE
348: , p6_a35 out nocopy JTF_DATE_TABLE
349: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
350: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
351: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
352: , p6_a39 out nocopy JTF_NUMBER_TABLE
353: , p6_a40 out nocopy JTF_DATE_TABLE

Line 350: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100

346: , p6_a33 out nocopy JTF_NUMBER_TABLE
347: , p6_a34 out nocopy JTF_NUMBER_TABLE
348: , p6_a35 out nocopy JTF_DATE_TABLE
349: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
350: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
351: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
352: , p6_a39 out nocopy JTF_NUMBER_TABLE
353: , p6_a40 out nocopy JTF_DATE_TABLE
354: );

Line 351: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

347: , p6_a34 out nocopy JTF_NUMBER_TABLE
348: , p6_a35 out nocopy JTF_DATE_TABLE
349: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
350: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
351: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
352: , p6_a39 out nocopy JTF_NUMBER_TABLE
353: , p6_a40 out nocopy JTF_DATE_TABLE
354: );
355: procedure send_shipping_instr(p_api_version NUMBER

Line 450: , p5_a2 JTF_VARCHAR2_TABLE_100

446: , x_msg_count out nocopy NUMBER
447: , x_msg_data out nocopy VARCHAR2
448: , p5_a0 JTF_NUMBER_TABLE
449: , p5_a1 JTF_NUMBER_TABLE
450: , p5_a2 JTF_VARCHAR2_TABLE_100
451: , p5_a3 JTF_NUMBER_TABLE
452: , p5_a4 JTF_NUMBER_TABLE
453: , p5_a5 JTF_NUMBER_TABLE
454: , p5_a6 JTF_DATE_TABLE

Line 458: , p5_a10 JTF_VARCHAR2_TABLE_100

454: , p5_a6 JTF_DATE_TABLE
455: , p5_a7 JTF_VARCHAR2_TABLE_2000
456: , p5_a8 JTF_VARCHAR2_TABLE_300
457: , p5_a9 JTF_NUMBER_TABLE
458: , p5_a10 JTF_VARCHAR2_TABLE_100
459: , p5_a11 JTF_VARCHAR2_TABLE_500
460: , p5_a12 JTF_VARCHAR2_TABLE_500
461: , p5_a13 JTF_VARCHAR2_TABLE_500
462: , p5_a14 JTF_VARCHAR2_TABLE_500

Line 484: , p5_a36 JTF_VARCHAR2_TABLE_100

480: , p5_a32 JTF_DATE_TABLE
481: , p5_a33 JTF_NUMBER_TABLE
482: , p5_a34 JTF_NUMBER_TABLE
483: , p5_a35 JTF_DATE_TABLE
484: , p5_a36 JTF_VARCHAR2_TABLE_100
485: , p5_a37 JTF_VARCHAR2_TABLE_100
486: , p5_a38 JTF_VARCHAR2_TABLE_100
487: , p5_a39 JTF_NUMBER_TABLE
488: , p5_a40 JTF_DATE_TABLE

Line 485: , p5_a37 JTF_VARCHAR2_TABLE_100

481: , p5_a33 JTF_NUMBER_TABLE
482: , p5_a34 JTF_NUMBER_TABLE
483: , p5_a35 JTF_DATE_TABLE
484: , p5_a36 JTF_VARCHAR2_TABLE_100
485: , p5_a37 JTF_VARCHAR2_TABLE_100
486: , p5_a38 JTF_VARCHAR2_TABLE_100
487: , p5_a39 JTF_NUMBER_TABLE
488: , p5_a40 JTF_DATE_TABLE
489: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 486: , p5_a38 JTF_VARCHAR2_TABLE_100

482: , p5_a34 JTF_NUMBER_TABLE
483: , p5_a35 JTF_DATE_TABLE
484: , p5_a36 JTF_VARCHAR2_TABLE_100
485: , p5_a37 JTF_VARCHAR2_TABLE_100
486: , p5_a38 JTF_VARCHAR2_TABLE_100
487: , p5_a39 JTF_NUMBER_TABLE
488: , p5_a40 JTF_DATE_TABLE
489: , p6_a0 out nocopy JTF_NUMBER_TABLE
490: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 491: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

487: , p5_a39 JTF_NUMBER_TABLE
488: , p5_a40 JTF_DATE_TABLE
489: , p6_a0 out nocopy JTF_NUMBER_TABLE
490: , p6_a1 out nocopy JTF_NUMBER_TABLE
491: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
492: , p6_a3 out nocopy JTF_NUMBER_TABLE
493: , p6_a4 out nocopy JTF_NUMBER_TABLE
494: , p6_a5 out nocopy JTF_NUMBER_TABLE
495: , p6_a6 out nocopy JTF_DATE_TABLE

Line 499: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

495: , p6_a6 out nocopy JTF_DATE_TABLE
496: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
497: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
498: , p6_a9 out nocopy JTF_NUMBER_TABLE
499: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
500: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
501: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
502: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
503: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_500

Line 525: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100

521: , p6_a32 out nocopy JTF_DATE_TABLE
522: , p6_a33 out nocopy JTF_NUMBER_TABLE
523: , p6_a34 out nocopy JTF_NUMBER_TABLE
524: , p6_a35 out nocopy JTF_DATE_TABLE
525: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
526: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
527: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
528: , p6_a39 out nocopy JTF_NUMBER_TABLE
529: , p6_a40 out nocopy JTF_DATE_TABLE

Line 526: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100

522: , p6_a33 out nocopy JTF_NUMBER_TABLE
523: , p6_a34 out nocopy JTF_NUMBER_TABLE
524: , p6_a35 out nocopy JTF_DATE_TABLE
525: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
526: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
527: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
528: , p6_a39 out nocopy JTF_NUMBER_TABLE
529: , p6_a40 out nocopy JTF_DATE_TABLE
530: );

Line 527: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

523: , p6_a34 out nocopy JTF_NUMBER_TABLE
524: , p6_a35 out nocopy JTF_DATE_TABLE
525: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
526: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
527: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
528: , p6_a39 out nocopy JTF_NUMBER_TABLE
529: , p6_a40 out nocopy JTF_DATE_TABLE
530: );
531: end okl_am_shipping_instr_pub_w;