DBA Data[Home] [Help]

APPS.OKL_AM_SHIPPING_INSTR_PUB_W dependencies on JTF_DATE_TABLE

Line 102: , p5_a6 JTF_DATE_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
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

Line 126: , p5_a30 JTF_DATE_TABLE

122: , p5_a26 JTF_NUMBER_TABLE
123: , p5_a27 JTF_NUMBER_TABLE
124: , p5_a28 JTF_NUMBER_TABLE
125: , p5_a29 JTF_NUMBER_TABLE
126: , p5_a30 JTF_DATE_TABLE
127: , p5_a31 JTF_NUMBER_TABLE
128: , p5_a32 JTF_DATE_TABLE
129: , p5_a33 JTF_NUMBER_TABLE
130: , p5_a34 JTF_NUMBER_TABLE

Line 128: , p5_a32 JTF_DATE_TABLE

124: , p5_a28 JTF_NUMBER_TABLE
125: , p5_a29 JTF_NUMBER_TABLE
126: , p5_a30 JTF_DATE_TABLE
127: , p5_a31 JTF_NUMBER_TABLE
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

Line 131: , p5_a35 JTF_DATE_TABLE

127: , p5_a31 JTF_NUMBER_TABLE
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

Line 136: , p5_a40 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
139: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
140: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 143: , p6_a6 out nocopy JTF_DATE_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
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

Line 167: , p6_a30 out nocopy JTF_DATE_TABLE

163: , p6_a26 out nocopy JTF_NUMBER_TABLE
164: , p6_a27 out nocopy JTF_NUMBER_TABLE
165: , p6_a28 out nocopy JTF_NUMBER_TABLE
166: , p6_a29 out nocopy JTF_NUMBER_TABLE
167: , p6_a30 out nocopy JTF_DATE_TABLE
168: , p6_a31 out nocopy JTF_NUMBER_TABLE
169: , p6_a32 out nocopy JTF_DATE_TABLE
170: , p6_a33 out nocopy JTF_NUMBER_TABLE
171: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 169: , p6_a32 out nocopy JTF_DATE_TABLE

165: , p6_a28 out nocopy JTF_NUMBER_TABLE
166: , p6_a29 out nocopy JTF_NUMBER_TABLE
167: , p6_a30 out nocopy JTF_DATE_TABLE
168: , p6_a31 out nocopy JTF_NUMBER_TABLE
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

Line 172: , p6_a35 out nocopy JTF_DATE_TABLE

168: , p6_a31 out nocopy JTF_NUMBER_TABLE
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

Line 177: , p6_a40 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
180: , p_init_msg_list VARCHAR2
181: , x_return_status out nocopy VARCHAR2

Line 278: , p5_a6 JTF_DATE_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
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

Line 302: , p5_a30 JTF_DATE_TABLE

298: , p5_a26 JTF_NUMBER_TABLE
299: , p5_a27 JTF_NUMBER_TABLE
300: , p5_a28 JTF_NUMBER_TABLE
301: , p5_a29 JTF_NUMBER_TABLE
302: , p5_a30 JTF_DATE_TABLE
303: , p5_a31 JTF_NUMBER_TABLE
304: , p5_a32 JTF_DATE_TABLE
305: , p5_a33 JTF_NUMBER_TABLE
306: , p5_a34 JTF_NUMBER_TABLE

Line 304: , p5_a32 JTF_DATE_TABLE

300: , p5_a28 JTF_NUMBER_TABLE
301: , p5_a29 JTF_NUMBER_TABLE
302: , p5_a30 JTF_DATE_TABLE
303: , p5_a31 JTF_NUMBER_TABLE
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

Line 307: , p5_a35 JTF_DATE_TABLE

303: , p5_a31 JTF_NUMBER_TABLE
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

Line 312: , p5_a40 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
315: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 319: , p6_a6 out nocopy JTF_DATE_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
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

Line 343: , p6_a30 out nocopy JTF_DATE_TABLE

339: , p6_a26 out nocopy JTF_NUMBER_TABLE
340: , p6_a27 out nocopy JTF_NUMBER_TABLE
341: , p6_a28 out nocopy JTF_NUMBER_TABLE
342: , p6_a29 out nocopy JTF_NUMBER_TABLE
343: , p6_a30 out nocopy JTF_DATE_TABLE
344: , p6_a31 out nocopy JTF_NUMBER_TABLE
345: , p6_a32 out nocopy JTF_DATE_TABLE
346: , p6_a33 out nocopy JTF_NUMBER_TABLE
347: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 345: , p6_a32 out nocopy JTF_DATE_TABLE

341: , p6_a28 out nocopy JTF_NUMBER_TABLE
342: , p6_a29 out nocopy JTF_NUMBER_TABLE
343: , p6_a30 out nocopy JTF_DATE_TABLE
344: , p6_a31 out nocopy JTF_NUMBER_TABLE
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

Line 348: , p6_a35 out nocopy JTF_DATE_TABLE

344: , p6_a31 out nocopy JTF_NUMBER_TABLE
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

Line 353: , p6_a40 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
356: , p_init_msg_list VARCHAR2
357: , x_return_status out nocopy VARCHAR2

Line 454: , p5_a6 JTF_DATE_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
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

Line 478: , p5_a30 JTF_DATE_TABLE

474: , p5_a26 JTF_NUMBER_TABLE
475: , p5_a27 JTF_NUMBER_TABLE
476: , p5_a28 JTF_NUMBER_TABLE
477: , p5_a29 JTF_NUMBER_TABLE
478: , p5_a30 JTF_DATE_TABLE
479: , p5_a31 JTF_NUMBER_TABLE
480: , p5_a32 JTF_DATE_TABLE
481: , p5_a33 JTF_NUMBER_TABLE
482: , p5_a34 JTF_NUMBER_TABLE

Line 480: , p5_a32 JTF_DATE_TABLE

476: , p5_a28 JTF_NUMBER_TABLE
477: , p5_a29 JTF_NUMBER_TABLE
478: , p5_a30 JTF_DATE_TABLE
479: , p5_a31 JTF_NUMBER_TABLE
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

Line 483: , p5_a35 JTF_DATE_TABLE

479: , p5_a31 JTF_NUMBER_TABLE
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

Line 488: , p5_a40 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
491: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
492: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 495: , p6_a6 out nocopy JTF_DATE_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
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

Line 519: , p6_a30 out nocopy JTF_DATE_TABLE

515: , p6_a26 out nocopy JTF_NUMBER_TABLE
516: , p6_a27 out nocopy JTF_NUMBER_TABLE
517: , p6_a28 out nocopy JTF_NUMBER_TABLE
518: , p6_a29 out nocopy JTF_NUMBER_TABLE
519: , p6_a30 out nocopy JTF_DATE_TABLE
520: , p6_a31 out nocopy JTF_NUMBER_TABLE
521: , p6_a32 out nocopy JTF_DATE_TABLE
522: , p6_a33 out nocopy JTF_NUMBER_TABLE
523: , p6_a34 out nocopy JTF_NUMBER_TABLE

Line 521: , p6_a32 out nocopy JTF_DATE_TABLE

517: , p6_a28 out nocopy JTF_NUMBER_TABLE
518: , p6_a29 out nocopy JTF_NUMBER_TABLE
519: , p6_a30 out nocopy JTF_DATE_TABLE
520: , p6_a31 out nocopy JTF_NUMBER_TABLE
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

Line 524: , p6_a35 out nocopy JTF_DATE_TABLE

520: , p6_a31 out nocopy JTF_NUMBER_TABLE
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

Line 529: , p6_a40 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;