APPS.OKL_SIF_RET_STRMS_PUB_W dependencies on JTF_DATE_TABLE

Line 136: , p0_a5 JTF_DATE_TABLE

132: , p0_a1 JTF_VARCHAR2_TABLE_200
133: , p0_a2 JTF_NUMBER_TABLE
134: , p0_a3 JTF_VARCHAR2_TABLE_100
135: , p0_a4 JTF_NUMBER_TABLE
136: , p0_a5 JTF_DATE_TABLE
137: , p0_a6 JTF_NUMBER_TABLE
138: , p0_a7 JTF_NUMBER_TABLE
139: , p0_a8 JTF_VARCHAR2_TABLE_500
140: , p0_a9 JTF_VARCHAR2_TABLE_500

Line 157: , p0_a26 JTF_DATE_TABLE

153: , p0_a22 JTF_VARCHAR2_TABLE_500
154: , p0_a23 JTF_NUMBER_TABLE
155: , p0_a24 JTF_NUMBER_TABLE
156: , p0_a25 JTF_NUMBER_TABLE
157: , p0_a26 JTF_DATE_TABLE
158: , p0_a27 JTF_DATE_TABLE
159: , p0_a28 JTF_NUMBER_TABLE
160: );
161: procedure insert_sif_ret_strms(p_api_version NUMBER

Line 158: , p0_a27 JTF_DATE_TABLE

154: , p0_a23 JTF_NUMBER_TABLE
155: , p0_a24 JTF_NUMBER_TABLE
156: , p0_a25 JTF_NUMBER_TABLE
157: , p0_a26 JTF_DATE_TABLE
158: , p0_a27 JTF_DATE_TABLE
159: , p0_a28 JTF_NUMBER_TABLE
160: );
161: procedure insert_sif_ret_strms(p_api_version NUMBER
162: , p_init_msg_list VARCHAR2

Line 171: , p5_a5 JTF_DATE_TABLE

167: , p5_a1 JTF_VARCHAR2_TABLE_200
168: , p5_a2 JTF_NUMBER_TABLE
169: , p5_a3 JTF_VARCHAR2_TABLE_100
170: , p5_a4 JTF_NUMBER_TABLE
171: , p5_a5 JTF_DATE_TABLE
172: , p5_a6 JTF_NUMBER_TABLE
173: , p5_a7 JTF_NUMBER_TABLE
174: , p5_a8 JTF_VARCHAR2_TABLE_500
175: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 192: , p5_a26 JTF_DATE_TABLE

188: , p5_a22 JTF_VARCHAR2_TABLE_500
189: , p5_a23 JTF_NUMBER_TABLE
190: , p5_a24 JTF_NUMBER_TABLE
191: , p5_a25 JTF_NUMBER_TABLE
192: , p5_a26 JTF_DATE_TABLE
193: , p5_a27 JTF_DATE_TABLE
194: , p5_a28 JTF_NUMBER_TABLE
195: , p6_a0 out nocopy JTF_NUMBER_TABLE
196: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 193: , p5_a27 JTF_DATE_TABLE

189: , p5_a23 JTF_NUMBER_TABLE
190: , p5_a24 JTF_NUMBER_TABLE
191: , p5_a25 JTF_NUMBER_TABLE
192: , p5_a26 JTF_DATE_TABLE
193: , p5_a27 JTF_DATE_TABLE
194: , p5_a28 JTF_NUMBER_TABLE
195: , p6_a0 out nocopy JTF_NUMBER_TABLE
196: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
197: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 200: , p6_a5 out nocopy JTF_DATE_TABLE

196: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
197: , p6_a2 out nocopy JTF_NUMBER_TABLE
198: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
199: , p6_a4 out nocopy JTF_NUMBER_TABLE
200: , p6_a5 out nocopy JTF_DATE_TABLE
201: , p6_a6 out nocopy JTF_NUMBER_TABLE
202: , p6_a7 out nocopy JTF_NUMBER_TABLE
203: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
204: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 221: , p6_a26 out nocopy JTF_DATE_TABLE

217: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
218: , p6_a23 out nocopy JTF_NUMBER_TABLE
219: , p6_a24 out nocopy JTF_NUMBER_TABLE
220: , p6_a25 out nocopy JTF_NUMBER_TABLE
221: , p6_a26 out nocopy JTF_DATE_TABLE
222: , p6_a27 out nocopy JTF_DATE_TABLE
223: , p6_a28 out nocopy JTF_NUMBER_TABLE
224: );
225: procedure lock_sif_ret_strms(p_api_version NUMBER

Line 222: , p6_a27 out nocopy JTF_DATE_TABLE

218: , p6_a23 out nocopy JTF_NUMBER_TABLE
219: , p6_a24 out nocopy JTF_NUMBER_TABLE
220: , p6_a25 out nocopy JTF_NUMBER_TABLE
221: , p6_a26 out nocopy JTF_DATE_TABLE
222: , p6_a27 out nocopy JTF_DATE_TABLE
223: , p6_a28 out nocopy JTF_NUMBER_TABLE
224: );
225: procedure lock_sif_ret_strms(p_api_version NUMBER
226: , p_init_msg_list VARCHAR2

Line 270: , p5_a5 JTF_DATE_TABLE

266: , p5_a1 JTF_VARCHAR2_TABLE_200
267: , p5_a2 JTF_NUMBER_TABLE
268: , p5_a3 JTF_VARCHAR2_TABLE_100
269: , p5_a4 JTF_NUMBER_TABLE
270: , p5_a5 JTF_DATE_TABLE
271: , p5_a6 JTF_NUMBER_TABLE
272: , p5_a7 JTF_NUMBER_TABLE
273: , p5_a8 JTF_VARCHAR2_TABLE_500
274: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 291: , p5_a26 JTF_DATE_TABLE

287: , p5_a22 JTF_VARCHAR2_TABLE_500
288: , p5_a23 JTF_NUMBER_TABLE
289: , p5_a24 JTF_NUMBER_TABLE
290: , p5_a25 JTF_NUMBER_TABLE
291: , p5_a26 JTF_DATE_TABLE
292: , p5_a27 JTF_DATE_TABLE
293: , p5_a28 JTF_NUMBER_TABLE
294: );
295: procedure update_sif_ret_strms(p_api_version NUMBER

Line 292: , p5_a27 JTF_DATE_TABLE

288: , p5_a23 JTF_NUMBER_TABLE
289: , p5_a24 JTF_NUMBER_TABLE
290: , p5_a25 JTF_NUMBER_TABLE
291: , p5_a26 JTF_DATE_TABLE
292: , p5_a27 JTF_DATE_TABLE
293: , p5_a28 JTF_NUMBER_TABLE
294: );
295: procedure update_sif_ret_strms(p_api_version NUMBER
296: , p_init_msg_list VARCHAR2

Line 369: , p5_a5 JTF_DATE_TABLE

365: , p5_a1 JTF_VARCHAR2_TABLE_200
366: , p5_a2 JTF_NUMBER_TABLE
367: , p5_a3 JTF_VARCHAR2_TABLE_100
368: , p5_a4 JTF_NUMBER_TABLE
369: , p5_a5 JTF_DATE_TABLE
370: , p5_a6 JTF_NUMBER_TABLE
371: , p5_a7 JTF_NUMBER_TABLE
372: , p5_a8 JTF_VARCHAR2_TABLE_500
373: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 390: , p5_a26 JTF_DATE_TABLE

386: , p5_a22 JTF_VARCHAR2_TABLE_500
387: , p5_a23 JTF_NUMBER_TABLE
388: , p5_a24 JTF_NUMBER_TABLE
389: , p5_a25 JTF_NUMBER_TABLE
390: , p5_a26 JTF_DATE_TABLE
391: , p5_a27 JTF_DATE_TABLE
392: , p5_a28 JTF_NUMBER_TABLE
393: , p6_a0 out nocopy JTF_NUMBER_TABLE
394: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 391: , p5_a27 JTF_DATE_TABLE

387: , p5_a23 JTF_NUMBER_TABLE
388: , p5_a24 JTF_NUMBER_TABLE
389: , p5_a25 JTF_NUMBER_TABLE
390: , p5_a26 JTF_DATE_TABLE
391: , p5_a27 JTF_DATE_TABLE
392: , p5_a28 JTF_NUMBER_TABLE
393: , p6_a0 out nocopy JTF_NUMBER_TABLE
394: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
395: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 398: , p6_a5 out nocopy JTF_DATE_TABLE

394: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
395: , p6_a2 out nocopy JTF_NUMBER_TABLE
396: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
397: , p6_a4 out nocopy JTF_NUMBER_TABLE
398: , p6_a5 out nocopy JTF_DATE_TABLE
399: , p6_a6 out nocopy JTF_NUMBER_TABLE
400: , p6_a7 out nocopy JTF_NUMBER_TABLE
401: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
402: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 419: , p6_a26 out nocopy JTF_DATE_TABLE

415: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
416: , p6_a23 out nocopy JTF_NUMBER_TABLE
417: , p6_a24 out nocopy JTF_NUMBER_TABLE
418: , p6_a25 out nocopy JTF_NUMBER_TABLE
419: , p6_a26 out nocopy JTF_DATE_TABLE
420: , p6_a27 out nocopy JTF_DATE_TABLE
421: , p6_a28 out nocopy JTF_NUMBER_TABLE
422: );
423: procedure delete_sif_ret_strms(p_api_version NUMBER

Line 420: , p6_a27 out nocopy JTF_DATE_TABLE

416: , p6_a23 out nocopy JTF_NUMBER_TABLE
417: , p6_a24 out nocopy JTF_NUMBER_TABLE
418: , p6_a25 out nocopy JTF_NUMBER_TABLE
419: , p6_a26 out nocopy JTF_DATE_TABLE
420: , p6_a27 out nocopy JTF_DATE_TABLE
421: , p6_a28 out nocopy JTF_NUMBER_TABLE
422: );
423: procedure delete_sif_ret_strms(p_api_version NUMBER
424: , p_init_msg_list VARCHAR2

Line 497: , p5_a5 JTF_DATE_TABLE

493: , p5_a1 JTF_VARCHAR2_TABLE_200
494: , p5_a2 JTF_NUMBER_TABLE
495: , p5_a3 JTF_VARCHAR2_TABLE_100
496: , p5_a4 JTF_NUMBER_TABLE
497: , p5_a5 JTF_DATE_TABLE
498: , p5_a6 JTF_NUMBER_TABLE
499: , p5_a7 JTF_NUMBER_TABLE
500: , p5_a8 JTF_VARCHAR2_TABLE_500
501: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 518: , p5_a26 JTF_DATE_TABLE

514: , p5_a22 JTF_VARCHAR2_TABLE_500
515: , p5_a23 JTF_NUMBER_TABLE
516: , p5_a24 JTF_NUMBER_TABLE
517: , p5_a25 JTF_NUMBER_TABLE
518: , p5_a26 JTF_DATE_TABLE
519: , p5_a27 JTF_DATE_TABLE
520: , p5_a28 JTF_NUMBER_TABLE
521: , p6_a0 out nocopy JTF_NUMBER_TABLE
522: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 519: , p5_a27 JTF_DATE_TABLE

515: , p5_a23 JTF_NUMBER_TABLE
516: , p5_a24 JTF_NUMBER_TABLE
517: , p5_a25 JTF_NUMBER_TABLE
518: , p5_a26 JTF_DATE_TABLE
519: , p5_a27 JTF_DATE_TABLE
520: , p5_a28 JTF_NUMBER_TABLE
521: , p6_a0 out nocopy JTF_NUMBER_TABLE
522: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
523: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 526: , p6_a5 out nocopy JTF_DATE_TABLE

522: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
523: , p6_a2 out nocopy JTF_NUMBER_TABLE
524: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
525: , p6_a4 out nocopy JTF_NUMBER_TABLE
526: , p6_a5 out nocopy JTF_DATE_TABLE
527: , p6_a6 out nocopy JTF_NUMBER_TABLE
528: , p6_a7 out nocopy JTF_NUMBER_TABLE
529: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
530: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 547: , p6_a26 out nocopy JTF_DATE_TABLE

543: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
544: , p6_a23 out nocopy JTF_NUMBER_TABLE
545: , p6_a24 out nocopy JTF_NUMBER_TABLE
546: , p6_a25 out nocopy JTF_NUMBER_TABLE
547: , p6_a26 out nocopy JTF_DATE_TABLE
548: , p6_a27 out nocopy JTF_DATE_TABLE
549: , p6_a28 out nocopy JTF_NUMBER_TABLE
550: );
551: procedure validate_sif_ret_strms(p_api_version NUMBER

Line 548: , p6_a27 out nocopy JTF_DATE_TABLE

544: , p6_a23 out nocopy JTF_NUMBER_TABLE
545: , p6_a24 out nocopy JTF_NUMBER_TABLE
546: , p6_a25 out nocopy JTF_NUMBER_TABLE
547: , p6_a26 out nocopy JTF_DATE_TABLE
548: , p6_a27 out nocopy JTF_DATE_TABLE
549: , p6_a28 out nocopy JTF_NUMBER_TABLE
550: );
551: procedure validate_sif_ret_strms(p_api_version NUMBER
552: , p_init_msg_list VARCHAR2

Line 625: , p5_a5 JTF_DATE_TABLE

621: , p5_a1 JTF_VARCHAR2_TABLE_200
622: , p5_a2 JTF_NUMBER_TABLE
623: , p5_a3 JTF_VARCHAR2_TABLE_100
624: , p5_a4 JTF_NUMBER_TABLE
625: , p5_a5 JTF_DATE_TABLE
626: , p5_a6 JTF_NUMBER_TABLE
627: , p5_a7 JTF_NUMBER_TABLE
628: , p5_a8 JTF_VARCHAR2_TABLE_500
629: , p5_a9 JTF_VARCHAR2_TABLE_500

Line 646: , p5_a26 JTF_DATE_TABLE

642: , p5_a22 JTF_VARCHAR2_TABLE_500
643: , p5_a23 JTF_NUMBER_TABLE
644: , p5_a24 JTF_NUMBER_TABLE
645: , p5_a25 JTF_NUMBER_TABLE
646: , p5_a26 JTF_DATE_TABLE
647: , p5_a27 JTF_DATE_TABLE
648: , p5_a28 JTF_NUMBER_TABLE
649: , p6_a0 out nocopy JTF_NUMBER_TABLE
650: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200

Line 647: , p5_a27 JTF_DATE_TABLE

643: , p5_a23 JTF_NUMBER_TABLE
644: , p5_a24 JTF_NUMBER_TABLE
645: , p5_a25 JTF_NUMBER_TABLE
646: , p5_a26 JTF_DATE_TABLE
647: , p5_a27 JTF_DATE_TABLE
648: , p5_a28 JTF_NUMBER_TABLE
649: , p6_a0 out nocopy JTF_NUMBER_TABLE
650: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
651: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 654: , p6_a5 out nocopy JTF_DATE_TABLE

650: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_200
651: , p6_a2 out nocopy JTF_NUMBER_TABLE
652: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
653: , p6_a4 out nocopy JTF_NUMBER_TABLE
654: , p6_a5 out nocopy JTF_DATE_TABLE
655: , p6_a6 out nocopy JTF_NUMBER_TABLE
656: , p6_a7 out nocopy JTF_NUMBER_TABLE
657: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
658: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500

Line 675: , p6_a26 out nocopy JTF_DATE_TABLE

671: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
672: , p6_a23 out nocopy JTF_NUMBER_TABLE
673: , p6_a24 out nocopy JTF_NUMBER_TABLE
674: , p6_a25 out nocopy JTF_NUMBER_TABLE
675: , p6_a26 out nocopy JTF_DATE_TABLE
676: , p6_a27 out nocopy JTF_DATE_TABLE
677: , p6_a28 out nocopy JTF_NUMBER_TABLE
678: );
679: end okl_sif_ret_strms_pub_w;

Line 676: , p6_a27 out nocopy JTF_DATE_TABLE

672: , p6_a23 out nocopy JTF_NUMBER_TABLE
673: , p6_a24 out nocopy JTF_NUMBER_TABLE
674: , p6_a25 out nocopy JTF_NUMBER_TABLE
675: , p6_a26 out nocopy JTF_DATE_TABLE
676: , p6_a27 out nocopy JTF_DATE_TABLE
677: , p6_a28 out nocopy JTF_NUMBER_TABLE
678: );
679: end okl_sif_ret_strms_pub_w;