APPS.OKL_ACC_GEN_RULE_PUB_W dependencies on JTF_DATE_TABLE

Line 32: , p6_a24 JTF_DATE_TABLE

28: , p6_a20 JTF_VARCHAR2_TABLE_500
29: , p6_a21 JTF_VARCHAR2_TABLE_500
30: , p6_a22 JTF_NUMBER_TABLE
31: , p6_a23 JTF_NUMBER_TABLE
32: , p6_a24 JTF_DATE_TABLE
33: , p6_a25 JTF_NUMBER_TABLE
34: , p6_a26 JTF_DATE_TABLE
35: , p6_a27 JTF_NUMBER_TABLE
36: , p7_a0 out nocopy NUMBER

Line 34: , p6_a26 JTF_DATE_TABLE

30: , p6_a22 JTF_NUMBER_TABLE
31: , p6_a23 JTF_NUMBER_TABLE
32: , p6_a24 JTF_DATE_TABLE
33: , p6_a25 JTF_NUMBER_TABLE
34: , p6_a26 JTF_DATE_TABLE
35: , p6_a27 JTF_NUMBER_TABLE
36: , p7_a0 out nocopy NUMBER
37: , p7_a1 out nocopy NUMBER
38: , p7_a2 out nocopy VARCHAR2

Line 70: , p8_a24 out nocopy JTF_DATE_TABLE

66: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_500
67: , p8_a21 out nocopy JTF_VARCHAR2_TABLE_500
68: , p8_a22 out nocopy JTF_NUMBER_TABLE
69: , p8_a23 out nocopy JTF_NUMBER_TABLE
70: , p8_a24 out nocopy JTF_DATE_TABLE
71: , p8_a25 out nocopy JTF_NUMBER_TABLE
72: , p8_a26 out nocopy JTF_DATE_TABLE
73: , p8_a27 out nocopy JTF_NUMBER_TABLE
74: , p5_a0 NUMBER := 0-1962.0724

Line 72: , p8_a26 out nocopy JTF_DATE_TABLE

68: , p8_a22 out nocopy JTF_NUMBER_TABLE
69: , p8_a23 out nocopy JTF_NUMBER_TABLE
70: , p8_a24 out nocopy JTF_DATE_TABLE
71: , p8_a25 out nocopy JTF_NUMBER_TABLE
72: , p8_a26 out nocopy JTF_DATE_TABLE
73: , p8_a27 out nocopy JTF_NUMBER_TABLE
74: , p5_a0 NUMBER := 0-1962.0724
75: , p5_a1 NUMBER := 0-1962.0724
76: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

Line 114: , p6_a24 JTF_DATE_TABLE

110: , p6_a20 JTF_VARCHAR2_TABLE_500
111: , p6_a21 JTF_VARCHAR2_TABLE_500
112: , p6_a22 JTF_NUMBER_TABLE
113: , p6_a23 JTF_NUMBER_TABLE
114: , p6_a24 JTF_DATE_TABLE
115: , p6_a25 JTF_NUMBER_TABLE
116: , p6_a26 JTF_DATE_TABLE
117: , p6_a27 JTF_NUMBER_TABLE
118: , p7_a0 out nocopy NUMBER

Line 116: , p6_a26 JTF_DATE_TABLE

112: , p6_a22 JTF_NUMBER_TABLE
113: , p6_a23 JTF_NUMBER_TABLE
114: , p6_a24 JTF_DATE_TABLE
115: , p6_a25 JTF_NUMBER_TABLE
116: , p6_a26 JTF_DATE_TABLE
117: , p6_a27 JTF_NUMBER_TABLE
118: , p7_a0 out nocopy NUMBER
119: , p7_a1 out nocopy NUMBER
120: , p7_a2 out nocopy VARCHAR2

Line 152: , p8_a24 out nocopy JTF_DATE_TABLE

148: , p8_a20 out nocopy JTF_VARCHAR2_TABLE_500
149: , p8_a21 out nocopy JTF_VARCHAR2_TABLE_500
150: , p8_a22 out nocopy JTF_NUMBER_TABLE
151: , p8_a23 out nocopy JTF_NUMBER_TABLE
152: , p8_a24 out nocopy JTF_DATE_TABLE
153: , p8_a25 out nocopy JTF_NUMBER_TABLE
154: , p8_a26 out nocopy JTF_DATE_TABLE
155: , p8_a27 out nocopy JTF_NUMBER_TABLE
156: , p5_a0 NUMBER := 0-1962.0724

Line 154: , p8_a26 out nocopy JTF_DATE_TABLE

150: , p8_a22 out nocopy JTF_NUMBER_TABLE
151: , p8_a23 out nocopy JTF_NUMBER_TABLE
152: , p8_a24 out nocopy JTF_DATE_TABLE
153: , p8_a25 out nocopy JTF_NUMBER_TABLE
154: , p8_a26 out nocopy JTF_DATE_TABLE
155: , p8_a27 out nocopy JTF_NUMBER_TABLE
156: , p5_a0 NUMBER := 0-1962.0724
157: , p5_a1 NUMBER := 0-1962.0724
158: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

Line 196: , p6_a24 JTF_DATE_TABLE

192: , p6_a20 JTF_VARCHAR2_TABLE_500
193: , p6_a21 JTF_VARCHAR2_TABLE_500
194: , p6_a22 JTF_NUMBER_TABLE
195: , p6_a23 JTF_NUMBER_TABLE
196: , p6_a24 JTF_DATE_TABLE
197: , p6_a25 JTF_NUMBER_TABLE
198: , p6_a26 JTF_DATE_TABLE
199: , p6_a27 JTF_NUMBER_TABLE
200: , p5_a0 NUMBER := 0-1962.0724

Line 198: , p6_a26 JTF_DATE_TABLE

194: , p6_a22 JTF_NUMBER_TABLE
195: , p6_a23 JTF_NUMBER_TABLE
196: , p6_a24 JTF_DATE_TABLE
197: , p6_a25 JTF_NUMBER_TABLE
198: , p6_a26 JTF_DATE_TABLE
199: , p6_a27 JTF_NUMBER_TABLE
200: , p5_a0 NUMBER := 0-1962.0724
201: , p5_a1 NUMBER := 0-1962.0724
202: , p5_a2 VARCHAR2 := fnd_api.g_miss_char

Line 222: , p5_a6 JTF_DATE_TABLE

218: , p5_a2 JTF_VARCHAR2_TABLE_100
219: , p5_a3 JTF_NUMBER_TABLE
220: , p5_a4 JTF_NUMBER_TABLE
221: , p5_a5 JTF_NUMBER_TABLE
222: , p5_a6 JTF_DATE_TABLE
223: , p5_a7 JTF_NUMBER_TABLE
224: , p5_a8 JTF_DATE_TABLE
225: , p5_a9 JTF_NUMBER_TABLE
226: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 224: , p5_a8 JTF_DATE_TABLE

220: , p5_a4 JTF_NUMBER_TABLE
221: , p5_a5 JTF_NUMBER_TABLE
222: , p5_a6 JTF_DATE_TABLE
223: , p5_a7 JTF_NUMBER_TABLE
224: , p5_a8 JTF_DATE_TABLE
225: , p5_a9 JTF_NUMBER_TABLE
226: , p6_a0 out nocopy JTF_NUMBER_TABLE
227: , p6_a1 out nocopy JTF_NUMBER_TABLE
228: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 232: , p6_a6 out nocopy JTF_DATE_TABLE

228: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
229: , p6_a3 out nocopy JTF_NUMBER_TABLE
230: , p6_a4 out nocopy JTF_NUMBER_TABLE
231: , p6_a5 out nocopy JTF_NUMBER_TABLE
232: , p6_a6 out nocopy JTF_DATE_TABLE
233: , p6_a7 out nocopy JTF_NUMBER_TABLE
234: , p6_a8 out nocopy JTF_DATE_TABLE
235: , p6_a9 out nocopy JTF_NUMBER_TABLE
236: );

Line 234: , p6_a8 out nocopy JTF_DATE_TABLE

230: , p6_a4 out nocopy JTF_NUMBER_TABLE
231: , p6_a5 out nocopy JTF_NUMBER_TABLE
232: , p6_a6 out nocopy JTF_DATE_TABLE
233: , p6_a7 out nocopy JTF_NUMBER_TABLE
234: , p6_a8 out nocopy JTF_DATE_TABLE
235: , p6_a9 out nocopy JTF_NUMBER_TABLE
236: );
237: procedure create_acc_gen_rule(p_api_version NUMBER
238: , p_init_msg_list VARCHAR2

Line 274: , p5_a6 JTF_DATE_TABLE

270: , p5_a2 JTF_VARCHAR2_TABLE_100
271: , p5_a3 JTF_NUMBER_TABLE
272: , p5_a4 JTF_NUMBER_TABLE
273: , p5_a5 JTF_NUMBER_TABLE
274: , p5_a6 JTF_DATE_TABLE
275: , p5_a7 JTF_NUMBER_TABLE
276: , p5_a8 JTF_DATE_TABLE
277: , p5_a9 JTF_NUMBER_TABLE
278: );

Line 276: , p5_a8 JTF_DATE_TABLE

272: , p5_a4 JTF_NUMBER_TABLE
273: , p5_a5 JTF_NUMBER_TABLE
274: , p5_a6 JTF_DATE_TABLE
275: , p5_a7 JTF_NUMBER_TABLE
276: , p5_a8 JTF_DATE_TABLE
277: , p5_a9 JTF_NUMBER_TABLE
278: );
279: procedure lock_acc_gen_rule(p_api_version NUMBER
280: , p_init_msg_list VARCHAR2

Line 306: , p5_a6 JTF_DATE_TABLE

302: , p5_a2 JTF_VARCHAR2_TABLE_100
303: , p5_a3 JTF_NUMBER_TABLE
304: , p5_a4 JTF_NUMBER_TABLE
305: , p5_a5 JTF_NUMBER_TABLE
306: , p5_a6 JTF_DATE_TABLE
307: , p5_a7 JTF_NUMBER_TABLE
308: , p5_a8 JTF_DATE_TABLE
309: , p5_a9 JTF_NUMBER_TABLE
310: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 308: , p5_a8 JTF_DATE_TABLE

304: , p5_a4 JTF_NUMBER_TABLE
305: , p5_a5 JTF_NUMBER_TABLE
306: , p5_a6 JTF_DATE_TABLE
307: , p5_a7 JTF_NUMBER_TABLE
308: , p5_a8 JTF_DATE_TABLE
309: , p5_a9 JTF_NUMBER_TABLE
310: , p6_a0 out nocopy JTF_NUMBER_TABLE
311: , p6_a1 out nocopy JTF_NUMBER_TABLE
312: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 316: , p6_a6 out nocopy JTF_DATE_TABLE

312: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
313: , p6_a3 out nocopy JTF_NUMBER_TABLE
314: , p6_a4 out nocopy JTF_NUMBER_TABLE
315: , p6_a5 out nocopy JTF_NUMBER_TABLE
316: , p6_a6 out nocopy JTF_DATE_TABLE
317: , p6_a7 out nocopy JTF_NUMBER_TABLE
318: , p6_a8 out nocopy JTF_DATE_TABLE
319: , p6_a9 out nocopy JTF_NUMBER_TABLE
320: );

Line 318: , p6_a8 out nocopy JTF_DATE_TABLE

314: , p6_a4 out nocopy JTF_NUMBER_TABLE
315: , p6_a5 out nocopy JTF_NUMBER_TABLE
316: , p6_a6 out nocopy JTF_DATE_TABLE
317: , p6_a7 out nocopy JTF_NUMBER_TABLE
318: , p6_a8 out nocopy JTF_DATE_TABLE
319: , p6_a9 out nocopy JTF_NUMBER_TABLE
320: );
321: procedure update_acc_gen_rule(p_api_version NUMBER
322: , p_init_msg_list VARCHAR2

Line 358: , p5_a6 JTF_DATE_TABLE

354: , p5_a2 JTF_VARCHAR2_TABLE_100
355: , p5_a3 JTF_NUMBER_TABLE
356: , p5_a4 JTF_NUMBER_TABLE
357: , p5_a5 JTF_NUMBER_TABLE
358: , p5_a6 JTF_DATE_TABLE
359: , p5_a7 JTF_NUMBER_TABLE
360: , p5_a8 JTF_DATE_TABLE
361: , p5_a9 JTF_NUMBER_TABLE
362: );

Line 360: , p5_a8 JTF_DATE_TABLE

356: , p5_a4 JTF_NUMBER_TABLE
357: , p5_a5 JTF_NUMBER_TABLE
358: , p5_a6 JTF_DATE_TABLE
359: , p5_a7 JTF_NUMBER_TABLE
360: , p5_a8 JTF_DATE_TABLE
361: , p5_a9 JTF_NUMBER_TABLE
362: );
363: procedure delete_acc_gen_rule(p_api_version NUMBER
364: , p_init_msg_list VARCHAR2

Line 390: , p5_a6 JTF_DATE_TABLE

386: , p5_a2 JTF_VARCHAR2_TABLE_100
387: , p5_a3 JTF_NUMBER_TABLE
388: , p5_a4 JTF_NUMBER_TABLE
389: , p5_a5 JTF_NUMBER_TABLE
390: , p5_a6 JTF_DATE_TABLE
391: , p5_a7 JTF_NUMBER_TABLE
392: , p5_a8 JTF_DATE_TABLE
393: , p5_a9 JTF_NUMBER_TABLE
394: );

Line 392: , p5_a8 JTF_DATE_TABLE

388: , p5_a4 JTF_NUMBER_TABLE
389: , p5_a5 JTF_NUMBER_TABLE
390: , p5_a6 JTF_DATE_TABLE
391: , p5_a7 JTF_NUMBER_TABLE
392: , p5_a8 JTF_DATE_TABLE
393: , p5_a9 JTF_NUMBER_TABLE
394: );
395: procedure validate_acc_gen_rule(p_api_version NUMBER
396: , p_init_msg_list VARCHAR2

Line 440: , p5_a24 JTF_DATE_TABLE

436: , p5_a20 JTF_VARCHAR2_TABLE_500
437: , p5_a21 JTF_VARCHAR2_TABLE_500
438: , p5_a22 JTF_NUMBER_TABLE
439: , p5_a23 JTF_NUMBER_TABLE
440: , p5_a24 JTF_DATE_TABLE
441: , p5_a25 JTF_NUMBER_TABLE
442: , p5_a26 JTF_DATE_TABLE
443: , p5_a27 JTF_NUMBER_TABLE
444: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 442: , p5_a26 JTF_DATE_TABLE

438: , p5_a22 JTF_NUMBER_TABLE
439: , p5_a23 JTF_NUMBER_TABLE
440: , p5_a24 JTF_DATE_TABLE
441: , p5_a25 JTF_NUMBER_TABLE
442: , p5_a26 JTF_DATE_TABLE
443: , p5_a27 JTF_NUMBER_TABLE
444: , p6_a0 out nocopy JTF_NUMBER_TABLE
445: , p6_a1 out nocopy JTF_NUMBER_TABLE
446: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 468: , p6_a24 out nocopy JTF_DATE_TABLE

464: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
465: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
466: , p6_a22 out nocopy JTF_NUMBER_TABLE
467: , p6_a23 out nocopy JTF_NUMBER_TABLE
468: , p6_a24 out nocopy JTF_DATE_TABLE
469: , p6_a25 out nocopy JTF_NUMBER_TABLE
470: , p6_a26 out nocopy JTF_DATE_TABLE
471: , p6_a27 out nocopy JTF_NUMBER_TABLE
472: );

Line 470: , p6_a26 out nocopy JTF_DATE_TABLE

466: , p6_a22 out nocopy JTF_NUMBER_TABLE
467: , p6_a23 out nocopy JTF_NUMBER_TABLE
468: , p6_a24 out nocopy JTF_DATE_TABLE
469: , p6_a25 out nocopy JTF_NUMBER_TABLE
470: , p6_a26 out nocopy JTF_DATE_TABLE
471: , p6_a27 out nocopy JTF_NUMBER_TABLE
472: );
473: procedure create_acc_gen_rule_lns(p_api_version NUMBER
474: , p_init_msg_list VARCHAR2

Line 564: , p5_a24 JTF_DATE_TABLE

560: , p5_a20 JTF_VARCHAR2_TABLE_500
561: , p5_a21 JTF_VARCHAR2_TABLE_500
562: , p5_a22 JTF_NUMBER_TABLE
563: , p5_a23 JTF_NUMBER_TABLE
564: , p5_a24 JTF_DATE_TABLE
565: , p5_a25 JTF_NUMBER_TABLE
566: , p5_a26 JTF_DATE_TABLE
567: , p5_a27 JTF_NUMBER_TABLE
568: );

Line 566: , p5_a26 JTF_DATE_TABLE

562: , p5_a22 JTF_NUMBER_TABLE
563: , p5_a23 JTF_NUMBER_TABLE
564: , p5_a24 JTF_DATE_TABLE
565: , p5_a25 JTF_NUMBER_TABLE
566: , p5_a26 JTF_DATE_TABLE
567: , p5_a27 JTF_NUMBER_TABLE
568: );
569: procedure lock_acc_gen_rule_lns(p_api_version NUMBER
570: , p_init_msg_list VARCHAR2

Line 632: , p5_a24 JTF_DATE_TABLE

628: , p5_a20 JTF_VARCHAR2_TABLE_500
629: , p5_a21 JTF_VARCHAR2_TABLE_500
630: , p5_a22 JTF_NUMBER_TABLE
631: , p5_a23 JTF_NUMBER_TABLE
632: , p5_a24 JTF_DATE_TABLE
633: , p5_a25 JTF_NUMBER_TABLE
634: , p5_a26 JTF_DATE_TABLE
635: , p5_a27 JTF_NUMBER_TABLE
636: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 634: , p5_a26 JTF_DATE_TABLE

630: , p5_a22 JTF_NUMBER_TABLE
631: , p5_a23 JTF_NUMBER_TABLE
632: , p5_a24 JTF_DATE_TABLE
633: , p5_a25 JTF_NUMBER_TABLE
634: , p5_a26 JTF_DATE_TABLE
635: , p5_a27 JTF_NUMBER_TABLE
636: , p6_a0 out nocopy JTF_NUMBER_TABLE
637: , p6_a1 out nocopy JTF_NUMBER_TABLE
638: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 660: , p6_a24 out nocopy JTF_DATE_TABLE

656: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
657: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
658: , p6_a22 out nocopy JTF_NUMBER_TABLE
659: , p6_a23 out nocopy JTF_NUMBER_TABLE
660: , p6_a24 out nocopy JTF_DATE_TABLE
661: , p6_a25 out nocopy JTF_NUMBER_TABLE
662: , p6_a26 out nocopy JTF_DATE_TABLE
663: , p6_a27 out nocopy JTF_NUMBER_TABLE
664: );

Line 662: , p6_a26 out nocopy JTF_DATE_TABLE

658: , p6_a22 out nocopy JTF_NUMBER_TABLE
659: , p6_a23 out nocopy JTF_NUMBER_TABLE
660: , p6_a24 out nocopy JTF_DATE_TABLE
661: , p6_a25 out nocopy JTF_NUMBER_TABLE
662: , p6_a26 out nocopy JTF_DATE_TABLE
663: , p6_a27 out nocopy JTF_NUMBER_TABLE
664: );
665: procedure update_acc_gen_rule_lns(p_api_version NUMBER
666: , p_init_msg_list VARCHAR2

Line 756: , p5_a24 JTF_DATE_TABLE

752: , p5_a20 JTF_VARCHAR2_TABLE_500
753: , p5_a21 JTF_VARCHAR2_TABLE_500
754: , p5_a22 JTF_NUMBER_TABLE
755: , p5_a23 JTF_NUMBER_TABLE
756: , p5_a24 JTF_DATE_TABLE
757: , p5_a25 JTF_NUMBER_TABLE
758: , p5_a26 JTF_DATE_TABLE
759: , p5_a27 JTF_NUMBER_TABLE
760: );

Line 758: , p5_a26 JTF_DATE_TABLE

754: , p5_a22 JTF_NUMBER_TABLE
755: , p5_a23 JTF_NUMBER_TABLE
756: , p5_a24 JTF_DATE_TABLE
757: , p5_a25 JTF_NUMBER_TABLE
758: , p5_a26 JTF_DATE_TABLE
759: , p5_a27 JTF_NUMBER_TABLE
760: );
761: procedure delete_acc_gen_rule_lns(p_api_version NUMBER
762: , p_init_msg_list VARCHAR2

Line 824: , p5_a24 JTF_DATE_TABLE

820: , p5_a20 JTF_VARCHAR2_TABLE_500
821: , p5_a21 JTF_VARCHAR2_TABLE_500
822: , p5_a22 JTF_NUMBER_TABLE
823: , p5_a23 JTF_NUMBER_TABLE
824: , p5_a24 JTF_DATE_TABLE
825: , p5_a25 JTF_NUMBER_TABLE
826: , p5_a26 JTF_DATE_TABLE
827: , p5_a27 JTF_NUMBER_TABLE
828: );

Line 826: , p5_a26 JTF_DATE_TABLE

822: , p5_a22 JTF_NUMBER_TABLE
823: , p5_a23 JTF_NUMBER_TABLE
824: , p5_a24 JTF_DATE_TABLE
825: , p5_a25 JTF_NUMBER_TABLE
826: , p5_a26 JTF_DATE_TABLE
827: , p5_a27 JTF_NUMBER_TABLE
828: );
829: procedure validate_acc_gen_rule_lns(p_api_version NUMBER
830: , p_init_msg_list VARCHAR2