APPS.OKL_SIF_RETS_PUB_W dependencies on JTF_DATE_TABLE

Line 113: , p5_a27 JTF_DATE_TABLE

109: , p5_a23 JTF_VARCHAR2_TABLE_500
110: , p5_a24 JTF_NUMBER_TABLE
111: , p5_a25 JTF_NUMBER_TABLE
112: , p5_a26 JTF_NUMBER_TABLE
113: , p5_a27 JTF_DATE_TABLE
114: , p5_a28 JTF_DATE_TABLE
115: , p5_a29 JTF_NUMBER_TABLE
116: , p5_a30 JTF_NUMBER_TABLE
117: , p5_a31 JTF_DATE_TABLE

Line 114: , p5_a28 JTF_DATE_TABLE

110: , p5_a24 JTF_NUMBER_TABLE
111: , p5_a25 JTF_NUMBER_TABLE
112: , p5_a26 JTF_NUMBER_TABLE
113: , p5_a27 JTF_DATE_TABLE
114: , p5_a28 JTF_DATE_TABLE
115: , p5_a29 JTF_NUMBER_TABLE
116: , p5_a30 JTF_NUMBER_TABLE
117: , p5_a31 JTF_DATE_TABLE
118: , p5_a32 JTF_NUMBER_TABLE

Line 117: , p5_a31 JTF_DATE_TABLE

113: , p5_a27 JTF_DATE_TABLE
114: , p5_a28 JTF_DATE_TABLE
115: , p5_a29 JTF_NUMBER_TABLE
116: , p5_a30 JTF_NUMBER_TABLE
117: , p5_a31 JTF_DATE_TABLE
118: , p5_a32 JTF_NUMBER_TABLE
119: , p5_a33 JTF_NUMBER_TABLE
120: , p5_a34 JTF_NUMBER_TABLE
121: , p5_a35 JTF_DATE_TABLE

Line 121: , p5_a35 JTF_DATE_TABLE

117: , p5_a31 JTF_DATE_TABLE
118: , p5_a32 JTF_NUMBER_TABLE
119: , p5_a33 JTF_NUMBER_TABLE
120: , p5_a34 JTF_NUMBER_TABLE
121: , p5_a35 JTF_DATE_TABLE
122: , p6_a0 out nocopy JTF_NUMBER_TABLE
123: , p6_a1 out nocopy JTF_NUMBER_TABLE
124: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
125: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 149: , p6_a27 out nocopy JTF_DATE_TABLE

145: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
146: , p6_a24 out nocopy JTF_NUMBER_TABLE
147: , p6_a25 out nocopy JTF_NUMBER_TABLE
148: , p6_a26 out nocopy JTF_NUMBER_TABLE
149: , p6_a27 out nocopy JTF_DATE_TABLE
150: , p6_a28 out nocopy JTF_DATE_TABLE
151: , p6_a29 out nocopy JTF_NUMBER_TABLE
152: , p6_a30 out nocopy JTF_NUMBER_TABLE
153: , p6_a31 out nocopy JTF_DATE_TABLE

Line 150: , p6_a28 out nocopy JTF_DATE_TABLE

146: , p6_a24 out nocopy JTF_NUMBER_TABLE
147: , p6_a25 out nocopy JTF_NUMBER_TABLE
148: , p6_a26 out nocopy JTF_NUMBER_TABLE
149: , p6_a27 out nocopy JTF_DATE_TABLE
150: , p6_a28 out nocopy JTF_DATE_TABLE
151: , p6_a29 out nocopy JTF_NUMBER_TABLE
152: , p6_a30 out nocopy JTF_NUMBER_TABLE
153: , p6_a31 out nocopy JTF_DATE_TABLE
154: , p6_a32 out nocopy JTF_NUMBER_TABLE

Line 153: , p6_a31 out nocopy JTF_DATE_TABLE

149: , p6_a27 out nocopy JTF_DATE_TABLE
150: , p6_a28 out nocopy JTF_DATE_TABLE
151: , p6_a29 out nocopy JTF_NUMBER_TABLE
152: , p6_a30 out nocopy JTF_NUMBER_TABLE
153: , p6_a31 out nocopy JTF_DATE_TABLE
154: , p6_a32 out nocopy JTF_NUMBER_TABLE
155: , p6_a33 out nocopy JTF_NUMBER_TABLE
156: , p6_a34 out nocopy JTF_NUMBER_TABLE
157: , p6_a35 out nocopy JTF_DATE_TABLE

Line 157: , p6_a35 out nocopy JTF_DATE_TABLE

153: , p6_a31 out nocopy JTF_DATE_TABLE
154: , p6_a32 out nocopy JTF_NUMBER_TABLE
155: , p6_a33 out nocopy JTF_NUMBER_TABLE
156: , p6_a34 out nocopy JTF_NUMBER_TABLE
157: , p6_a35 out nocopy JTF_DATE_TABLE
158: );
159: procedure lock_sif_rets(p_api_version NUMBER
160: , p_init_msg_list VARCHAR2
161: , x_return_status out nocopy VARCHAR2

Line 233: , p5_a27 JTF_DATE_TABLE

229: , p5_a23 JTF_VARCHAR2_TABLE_500
230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_NUMBER_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_DATE_TABLE
235: , p5_a29 JTF_NUMBER_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p5_a31 JTF_DATE_TABLE

Line 234: , p5_a28 JTF_DATE_TABLE

230: , p5_a24 JTF_NUMBER_TABLE
231: , p5_a25 JTF_NUMBER_TABLE
232: , p5_a26 JTF_NUMBER_TABLE
233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_DATE_TABLE
235: , p5_a29 JTF_NUMBER_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p5_a31 JTF_DATE_TABLE
238: , p5_a32 JTF_NUMBER_TABLE

Line 237: , p5_a31 JTF_DATE_TABLE

233: , p5_a27 JTF_DATE_TABLE
234: , p5_a28 JTF_DATE_TABLE
235: , p5_a29 JTF_NUMBER_TABLE
236: , p5_a30 JTF_NUMBER_TABLE
237: , p5_a31 JTF_DATE_TABLE
238: , p5_a32 JTF_NUMBER_TABLE
239: , p5_a33 JTF_NUMBER_TABLE
240: , p5_a34 JTF_NUMBER_TABLE
241: , p5_a35 JTF_DATE_TABLE

Line 241: , p5_a35 JTF_DATE_TABLE

237: , p5_a31 JTF_DATE_TABLE
238: , p5_a32 JTF_NUMBER_TABLE
239: , p5_a33 JTF_NUMBER_TABLE
240: , p5_a34 JTF_NUMBER_TABLE
241: , p5_a35 JTF_DATE_TABLE
242: );
243: procedure update_sif_rets(p_api_version NUMBER
244: , p_init_msg_list VARCHAR2
245: , x_return_status out nocopy VARCHAR2

Line 353: , p5_a27 JTF_DATE_TABLE

349: , p5_a23 JTF_VARCHAR2_TABLE_500
350: , p5_a24 JTF_NUMBER_TABLE
351: , p5_a25 JTF_NUMBER_TABLE
352: , p5_a26 JTF_NUMBER_TABLE
353: , p5_a27 JTF_DATE_TABLE
354: , p5_a28 JTF_DATE_TABLE
355: , p5_a29 JTF_NUMBER_TABLE
356: , p5_a30 JTF_NUMBER_TABLE
357: , p5_a31 JTF_DATE_TABLE

Line 354: , p5_a28 JTF_DATE_TABLE

350: , p5_a24 JTF_NUMBER_TABLE
351: , p5_a25 JTF_NUMBER_TABLE
352: , p5_a26 JTF_NUMBER_TABLE
353: , p5_a27 JTF_DATE_TABLE
354: , p5_a28 JTF_DATE_TABLE
355: , p5_a29 JTF_NUMBER_TABLE
356: , p5_a30 JTF_NUMBER_TABLE
357: , p5_a31 JTF_DATE_TABLE
358: , p5_a32 JTF_NUMBER_TABLE

Line 357: , p5_a31 JTF_DATE_TABLE

353: , p5_a27 JTF_DATE_TABLE
354: , p5_a28 JTF_DATE_TABLE
355: , p5_a29 JTF_NUMBER_TABLE
356: , p5_a30 JTF_NUMBER_TABLE
357: , p5_a31 JTF_DATE_TABLE
358: , p5_a32 JTF_NUMBER_TABLE
359: , p5_a33 JTF_NUMBER_TABLE
360: , p5_a34 JTF_NUMBER_TABLE
361: , p5_a35 JTF_DATE_TABLE

Line 361: , p5_a35 JTF_DATE_TABLE

357: , p5_a31 JTF_DATE_TABLE
358: , p5_a32 JTF_NUMBER_TABLE
359: , p5_a33 JTF_NUMBER_TABLE
360: , p5_a34 JTF_NUMBER_TABLE
361: , p5_a35 JTF_DATE_TABLE
362: , p6_a0 out nocopy JTF_NUMBER_TABLE
363: , p6_a1 out nocopy JTF_NUMBER_TABLE
364: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
365: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 389: , p6_a27 out nocopy JTF_DATE_TABLE

385: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
386: , p6_a24 out nocopy JTF_NUMBER_TABLE
387: , p6_a25 out nocopy JTF_NUMBER_TABLE
388: , p6_a26 out nocopy JTF_NUMBER_TABLE
389: , p6_a27 out nocopy JTF_DATE_TABLE
390: , p6_a28 out nocopy JTF_DATE_TABLE
391: , p6_a29 out nocopy JTF_NUMBER_TABLE
392: , p6_a30 out nocopy JTF_NUMBER_TABLE
393: , p6_a31 out nocopy JTF_DATE_TABLE

Line 390: , p6_a28 out nocopy JTF_DATE_TABLE

386: , p6_a24 out nocopy JTF_NUMBER_TABLE
387: , p6_a25 out nocopy JTF_NUMBER_TABLE
388: , p6_a26 out nocopy JTF_NUMBER_TABLE
389: , p6_a27 out nocopy JTF_DATE_TABLE
390: , p6_a28 out nocopy JTF_DATE_TABLE
391: , p6_a29 out nocopy JTF_NUMBER_TABLE
392: , p6_a30 out nocopy JTF_NUMBER_TABLE
393: , p6_a31 out nocopy JTF_DATE_TABLE
394: , p6_a32 out nocopy JTF_NUMBER_TABLE

Line 393: , p6_a31 out nocopy JTF_DATE_TABLE

389: , p6_a27 out nocopy JTF_DATE_TABLE
390: , p6_a28 out nocopy JTF_DATE_TABLE
391: , p6_a29 out nocopy JTF_NUMBER_TABLE
392: , p6_a30 out nocopy JTF_NUMBER_TABLE
393: , p6_a31 out nocopy JTF_DATE_TABLE
394: , p6_a32 out nocopy JTF_NUMBER_TABLE
395: , p6_a33 out nocopy JTF_NUMBER_TABLE
396: , p6_a34 out nocopy JTF_NUMBER_TABLE
397: , p6_a35 out nocopy JTF_DATE_TABLE

Line 397: , p6_a35 out nocopy JTF_DATE_TABLE

393: , p6_a31 out nocopy JTF_DATE_TABLE
394: , p6_a32 out nocopy JTF_NUMBER_TABLE
395: , p6_a33 out nocopy JTF_NUMBER_TABLE
396: , p6_a34 out nocopy JTF_NUMBER_TABLE
397: , p6_a35 out nocopy JTF_DATE_TABLE
398: );
399: procedure delete_sif_rets(p_api_version NUMBER
400: , p_init_msg_list VARCHAR2
401: , x_return_status out nocopy VARCHAR2

Line 509: , p5_a27 JTF_DATE_TABLE

505: , p5_a23 JTF_VARCHAR2_TABLE_500
506: , p5_a24 JTF_NUMBER_TABLE
507: , p5_a25 JTF_NUMBER_TABLE
508: , p5_a26 JTF_NUMBER_TABLE
509: , p5_a27 JTF_DATE_TABLE
510: , p5_a28 JTF_DATE_TABLE
511: , p5_a29 JTF_NUMBER_TABLE
512: , p5_a30 JTF_NUMBER_TABLE
513: , p5_a31 JTF_DATE_TABLE

Line 510: , p5_a28 JTF_DATE_TABLE

506: , p5_a24 JTF_NUMBER_TABLE
507: , p5_a25 JTF_NUMBER_TABLE
508: , p5_a26 JTF_NUMBER_TABLE
509: , p5_a27 JTF_DATE_TABLE
510: , p5_a28 JTF_DATE_TABLE
511: , p5_a29 JTF_NUMBER_TABLE
512: , p5_a30 JTF_NUMBER_TABLE
513: , p5_a31 JTF_DATE_TABLE
514: , p5_a32 JTF_NUMBER_TABLE

Line 513: , p5_a31 JTF_DATE_TABLE

509: , p5_a27 JTF_DATE_TABLE
510: , p5_a28 JTF_DATE_TABLE
511: , p5_a29 JTF_NUMBER_TABLE
512: , p5_a30 JTF_NUMBER_TABLE
513: , p5_a31 JTF_DATE_TABLE
514: , p5_a32 JTF_NUMBER_TABLE
515: , p5_a33 JTF_NUMBER_TABLE
516: , p5_a34 JTF_NUMBER_TABLE
517: , p5_a35 JTF_DATE_TABLE

Line 517: , p5_a35 JTF_DATE_TABLE

513: , p5_a31 JTF_DATE_TABLE
514: , p5_a32 JTF_NUMBER_TABLE
515: , p5_a33 JTF_NUMBER_TABLE
516: , p5_a34 JTF_NUMBER_TABLE
517: , p5_a35 JTF_DATE_TABLE
518: , p6_a0 out nocopy JTF_NUMBER_TABLE
519: , p6_a1 out nocopy JTF_NUMBER_TABLE
520: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
521: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 545: , p6_a27 out nocopy JTF_DATE_TABLE

541: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
542: , p6_a24 out nocopy JTF_NUMBER_TABLE
543: , p6_a25 out nocopy JTF_NUMBER_TABLE
544: , p6_a26 out nocopy JTF_NUMBER_TABLE
545: , p6_a27 out nocopy JTF_DATE_TABLE
546: , p6_a28 out nocopy JTF_DATE_TABLE
547: , p6_a29 out nocopy JTF_NUMBER_TABLE
548: , p6_a30 out nocopy JTF_NUMBER_TABLE
549: , p6_a31 out nocopy JTF_DATE_TABLE

Line 546: , p6_a28 out nocopy JTF_DATE_TABLE

542: , p6_a24 out nocopy JTF_NUMBER_TABLE
543: , p6_a25 out nocopy JTF_NUMBER_TABLE
544: , p6_a26 out nocopy JTF_NUMBER_TABLE
545: , p6_a27 out nocopy JTF_DATE_TABLE
546: , p6_a28 out nocopy JTF_DATE_TABLE
547: , p6_a29 out nocopy JTF_NUMBER_TABLE
548: , p6_a30 out nocopy JTF_NUMBER_TABLE
549: , p6_a31 out nocopy JTF_DATE_TABLE
550: , p6_a32 out nocopy JTF_NUMBER_TABLE

Line 549: , p6_a31 out nocopy JTF_DATE_TABLE

545: , p6_a27 out nocopy JTF_DATE_TABLE
546: , p6_a28 out nocopy JTF_DATE_TABLE
547: , p6_a29 out nocopy JTF_NUMBER_TABLE
548: , p6_a30 out nocopy JTF_NUMBER_TABLE
549: , p6_a31 out nocopy JTF_DATE_TABLE
550: , p6_a32 out nocopy JTF_NUMBER_TABLE
551: , p6_a33 out nocopy JTF_NUMBER_TABLE
552: , p6_a34 out nocopy JTF_NUMBER_TABLE
553: , p6_a35 out nocopy JTF_DATE_TABLE

Line 553: , p6_a35 out nocopy JTF_DATE_TABLE

549: , p6_a31 out nocopy JTF_DATE_TABLE
550: , p6_a32 out nocopy JTF_NUMBER_TABLE
551: , p6_a33 out nocopy JTF_NUMBER_TABLE
552: , p6_a34 out nocopy JTF_NUMBER_TABLE
553: , p6_a35 out nocopy JTF_DATE_TABLE
554: );
555: procedure validate_sif_rets(p_api_version NUMBER
556: , p_init_msg_list VARCHAR2
557: , x_return_status out nocopy VARCHAR2

Line 665: , p5_a27 JTF_DATE_TABLE

661: , p5_a23 JTF_VARCHAR2_TABLE_500
662: , p5_a24 JTF_NUMBER_TABLE
663: , p5_a25 JTF_NUMBER_TABLE
664: , p5_a26 JTF_NUMBER_TABLE
665: , p5_a27 JTF_DATE_TABLE
666: , p5_a28 JTF_DATE_TABLE
667: , p5_a29 JTF_NUMBER_TABLE
668: , p5_a30 JTF_NUMBER_TABLE
669: , p5_a31 JTF_DATE_TABLE

Line 666: , p5_a28 JTF_DATE_TABLE

662: , p5_a24 JTF_NUMBER_TABLE
663: , p5_a25 JTF_NUMBER_TABLE
664: , p5_a26 JTF_NUMBER_TABLE
665: , p5_a27 JTF_DATE_TABLE
666: , p5_a28 JTF_DATE_TABLE
667: , p5_a29 JTF_NUMBER_TABLE
668: , p5_a30 JTF_NUMBER_TABLE
669: , p5_a31 JTF_DATE_TABLE
670: , p5_a32 JTF_NUMBER_TABLE

Line 669: , p5_a31 JTF_DATE_TABLE

665: , p5_a27 JTF_DATE_TABLE
666: , p5_a28 JTF_DATE_TABLE
667: , p5_a29 JTF_NUMBER_TABLE
668: , p5_a30 JTF_NUMBER_TABLE
669: , p5_a31 JTF_DATE_TABLE
670: , p5_a32 JTF_NUMBER_TABLE
671: , p5_a33 JTF_NUMBER_TABLE
672: , p5_a34 JTF_NUMBER_TABLE
673: , p5_a35 JTF_DATE_TABLE

Line 673: , p5_a35 JTF_DATE_TABLE

669: , p5_a31 JTF_DATE_TABLE
670: , p5_a32 JTF_NUMBER_TABLE
671: , p5_a33 JTF_NUMBER_TABLE
672: , p5_a34 JTF_NUMBER_TABLE
673: , p5_a35 JTF_DATE_TABLE
674: , p6_a0 out nocopy JTF_NUMBER_TABLE
675: , p6_a1 out nocopy JTF_NUMBER_TABLE
676: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
677: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 701: , p6_a27 out nocopy JTF_DATE_TABLE

697: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
698: , p6_a24 out nocopy JTF_NUMBER_TABLE
699: , p6_a25 out nocopy JTF_NUMBER_TABLE
700: , p6_a26 out nocopy JTF_NUMBER_TABLE
701: , p6_a27 out nocopy JTF_DATE_TABLE
702: , p6_a28 out nocopy JTF_DATE_TABLE
703: , p6_a29 out nocopy JTF_NUMBER_TABLE
704: , p6_a30 out nocopy JTF_NUMBER_TABLE
705: , p6_a31 out nocopy JTF_DATE_TABLE

Line 702: , p6_a28 out nocopy JTF_DATE_TABLE

698: , p6_a24 out nocopy JTF_NUMBER_TABLE
699: , p6_a25 out nocopy JTF_NUMBER_TABLE
700: , p6_a26 out nocopy JTF_NUMBER_TABLE
701: , p6_a27 out nocopy JTF_DATE_TABLE
702: , p6_a28 out nocopy JTF_DATE_TABLE
703: , p6_a29 out nocopy JTF_NUMBER_TABLE
704: , p6_a30 out nocopy JTF_NUMBER_TABLE
705: , p6_a31 out nocopy JTF_DATE_TABLE
706: , p6_a32 out nocopy JTF_NUMBER_TABLE

Line 705: , p6_a31 out nocopy JTF_DATE_TABLE

701: , p6_a27 out nocopy JTF_DATE_TABLE
702: , p6_a28 out nocopy JTF_DATE_TABLE
703: , p6_a29 out nocopy JTF_NUMBER_TABLE
704: , p6_a30 out nocopy JTF_NUMBER_TABLE
705: , p6_a31 out nocopy JTF_DATE_TABLE
706: , p6_a32 out nocopy JTF_NUMBER_TABLE
707: , p6_a33 out nocopy JTF_NUMBER_TABLE
708: , p6_a34 out nocopy JTF_NUMBER_TABLE
709: , p6_a35 out nocopy JTF_DATE_TABLE

Line 709: , p6_a35 out nocopy JTF_DATE_TABLE

705: , p6_a31 out nocopy JTF_DATE_TABLE
706: , p6_a32 out nocopy JTF_NUMBER_TABLE
707: , p6_a33 out nocopy JTF_NUMBER_TABLE
708: , p6_a34 out nocopy JTF_NUMBER_TABLE
709: , p6_a35 out nocopy JTF_DATE_TABLE
710: );
711: end okl_sif_rets_pub_w;