APPS.OKL_OPTION_RULES_PVT_W dependencies on JTF_DATE_TABLE

Line 19: , p6_a11 JTF_DATE_TABLE

15: , p6_a7 JTF_NUMBER_TABLE
16: , p6_a8 JTF_NUMBER_TABLE
17: , p6_a9 JTF_VARCHAR2_TABLE_100
18: , p6_a10 JTF_NUMBER_TABLE
19: , p6_a11 JTF_DATE_TABLE
20: , p6_a12 JTF_NUMBER_TABLE
21: , p6_a13 JTF_DATE_TABLE
22: , p6_a14 JTF_NUMBER_TABLE
23: , p7_a0 out nocopy NUMBER

Line 21: , p6_a13 JTF_DATE_TABLE

17: , p6_a9 JTF_VARCHAR2_TABLE_100
18: , p6_a10 JTF_NUMBER_TABLE
19: , p6_a11 JTF_DATE_TABLE
20: , p6_a12 JTF_NUMBER_TABLE
21: , p6_a13 JTF_DATE_TABLE
22: , p6_a14 JTF_NUMBER_TABLE
23: , p7_a0 out nocopy NUMBER
24: , p7_a1 out nocopy NUMBER
25: , p7_a2 out nocopy NUMBER

Line 48: , p8_a11 out nocopy JTF_DATE_TABLE

44: , p8_a7 out nocopy JTF_NUMBER_TABLE
45: , p8_a8 out nocopy JTF_NUMBER_TABLE
46: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
47: , p8_a10 out nocopy JTF_NUMBER_TABLE
48: , p8_a11 out nocopy JTF_DATE_TABLE
49: , p8_a12 out nocopy JTF_NUMBER_TABLE
50: , p8_a13 out nocopy JTF_DATE_TABLE
51: , p8_a14 out nocopy JTF_NUMBER_TABLE
52: , p5_a0 NUMBER := 0-1962.0724

Line 50: , p8_a13 out nocopy JTF_DATE_TABLE

46: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
47: , p8_a10 out nocopy JTF_NUMBER_TABLE
48: , p8_a11 out nocopy JTF_DATE_TABLE
49: , p8_a12 out nocopy JTF_NUMBER_TABLE
50: , p8_a13 out nocopy JTF_DATE_TABLE
51: , p8_a14 out nocopy JTF_NUMBER_TABLE
52: , p5_a0 NUMBER := 0-1962.0724
53: , p5_a1 NUMBER := 0-1962.0724
54: , p5_a2 NUMBER := 0-1962.0724

Line 83: , p6_a11 JTF_DATE_TABLE

79: , p6_a7 JTF_NUMBER_TABLE
80: , p6_a8 JTF_NUMBER_TABLE
81: , p6_a9 JTF_VARCHAR2_TABLE_100
82: , p6_a10 JTF_NUMBER_TABLE
83: , p6_a11 JTF_DATE_TABLE
84: , p6_a12 JTF_NUMBER_TABLE
85: , p6_a13 JTF_DATE_TABLE
86: , p6_a14 JTF_NUMBER_TABLE
87: , p7_a0 out nocopy NUMBER

Line 85: , p6_a13 JTF_DATE_TABLE

81: , p6_a9 JTF_VARCHAR2_TABLE_100
82: , p6_a10 JTF_NUMBER_TABLE
83: , p6_a11 JTF_DATE_TABLE
84: , p6_a12 JTF_NUMBER_TABLE
85: , p6_a13 JTF_DATE_TABLE
86: , p6_a14 JTF_NUMBER_TABLE
87: , p7_a0 out nocopy NUMBER
88: , p7_a1 out nocopy NUMBER
89: , p7_a2 out nocopy NUMBER

Line 112: , p8_a11 out nocopy JTF_DATE_TABLE

108: , p8_a7 out nocopy JTF_NUMBER_TABLE
109: , p8_a8 out nocopy JTF_NUMBER_TABLE
110: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
111: , p8_a10 out nocopy JTF_NUMBER_TABLE
112: , p8_a11 out nocopy JTF_DATE_TABLE
113: , p8_a12 out nocopy JTF_NUMBER_TABLE
114: , p8_a13 out nocopy JTF_DATE_TABLE
115: , p8_a14 out nocopy JTF_NUMBER_TABLE
116: , p5_a0 NUMBER := 0-1962.0724

Line 114: , p8_a13 out nocopy JTF_DATE_TABLE

110: , p8_a9 out nocopy JTF_VARCHAR2_TABLE_100
111: , p8_a10 out nocopy JTF_NUMBER_TABLE
112: , p8_a11 out nocopy JTF_DATE_TABLE
113: , p8_a12 out nocopy JTF_NUMBER_TABLE
114: , p8_a13 out nocopy JTF_DATE_TABLE
115: , p8_a14 out nocopy JTF_NUMBER_TABLE
116: , p5_a0 NUMBER := 0-1962.0724
117: , p5_a1 NUMBER := 0-1962.0724
118: , p5_a2 NUMBER := 0-1962.0724

Line 147: , p6_a11 JTF_DATE_TABLE

143: , p6_a7 JTF_NUMBER_TABLE
144: , p6_a8 JTF_NUMBER_TABLE
145: , p6_a9 JTF_VARCHAR2_TABLE_100
146: , p6_a10 JTF_NUMBER_TABLE
147: , p6_a11 JTF_DATE_TABLE
148: , p6_a12 JTF_NUMBER_TABLE
149: , p6_a13 JTF_DATE_TABLE
150: , p6_a14 JTF_NUMBER_TABLE
151: , p5_a0 NUMBER := 0-1962.0724

Line 149: , p6_a13 JTF_DATE_TABLE

145: , p6_a9 JTF_VARCHAR2_TABLE_100
146: , p6_a10 JTF_NUMBER_TABLE
147: , p6_a11 JTF_DATE_TABLE
148: , p6_a12 JTF_NUMBER_TABLE
149: , p6_a13 JTF_DATE_TABLE
150: , p6_a14 JTF_NUMBER_TABLE
151: , p5_a0 NUMBER := 0-1962.0724
152: , p5_a1 NUMBER := 0-1962.0724
153: , p5_a2 NUMBER := 0-1962.0724

Line 181: , p5_a10 JTF_DATE_TABLE

177: , p5_a6 JTF_NUMBER_TABLE
178: , p5_a7 JTF_NUMBER_TABLE
179: , p5_a8 JTF_VARCHAR2_TABLE_2000
180: , p5_a9 JTF_NUMBER_TABLE
181: , p5_a10 JTF_DATE_TABLE
182: , p5_a11 JTF_NUMBER_TABLE
183: , p5_a12 JTF_DATE_TABLE
184: , p5_a13 JTF_NUMBER_TABLE
185: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 183: , p5_a12 JTF_DATE_TABLE

179: , p5_a8 JTF_VARCHAR2_TABLE_2000
180: , p5_a9 JTF_NUMBER_TABLE
181: , p5_a10 JTF_DATE_TABLE
182: , p5_a11 JTF_NUMBER_TABLE
183: , p5_a12 JTF_DATE_TABLE
184: , p5_a13 JTF_NUMBER_TABLE
185: , p6_a0 out nocopy JTF_NUMBER_TABLE
186: , p6_a1 out nocopy JTF_NUMBER_TABLE
187: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 195: , p6_a10 out nocopy JTF_DATE_TABLE

191: , p6_a6 out nocopy JTF_NUMBER_TABLE
192: , p6_a7 out nocopy JTF_NUMBER_TABLE
193: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
194: , p6_a9 out nocopy JTF_NUMBER_TABLE
195: , p6_a10 out nocopy JTF_DATE_TABLE
196: , p6_a11 out nocopy JTF_NUMBER_TABLE
197: , p6_a12 out nocopy JTF_DATE_TABLE
198: , p6_a13 out nocopy JTF_NUMBER_TABLE
199: );

Line 197: , p6_a12 out nocopy JTF_DATE_TABLE

193: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
194: , p6_a9 out nocopy JTF_NUMBER_TABLE
195: , p6_a10 out nocopy JTF_DATE_TABLE
196: , p6_a11 out nocopy JTF_NUMBER_TABLE
197: , p6_a12 out nocopy JTF_DATE_TABLE
198: , p6_a13 out nocopy JTF_NUMBER_TABLE
199: );
200: procedure create_option_rules(p_api_version NUMBER
201: , p_init_msg_list VARCHAR2

Line 249: , p5_a10 JTF_DATE_TABLE

245: , p5_a6 JTF_NUMBER_TABLE
246: , p5_a7 JTF_NUMBER_TABLE
247: , p5_a8 JTF_VARCHAR2_TABLE_2000
248: , p5_a9 JTF_NUMBER_TABLE
249: , p5_a10 JTF_DATE_TABLE
250: , p5_a11 JTF_NUMBER_TABLE
251: , p5_a12 JTF_DATE_TABLE
252: , p5_a13 JTF_NUMBER_TABLE
253: );

Line 251: , p5_a12 JTF_DATE_TABLE

247: , p5_a8 JTF_VARCHAR2_TABLE_2000
248: , p5_a9 JTF_NUMBER_TABLE
249: , p5_a10 JTF_DATE_TABLE
250: , p5_a11 JTF_NUMBER_TABLE
251: , p5_a12 JTF_DATE_TABLE
252: , p5_a13 JTF_NUMBER_TABLE
253: );
254: procedure lock_option_rules(p_api_version NUMBER
255: , p_init_msg_list VARCHAR2

Line 289: , p5_a10 JTF_DATE_TABLE

285: , p5_a6 JTF_NUMBER_TABLE
286: , p5_a7 JTF_NUMBER_TABLE
287: , p5_a8 JTF_VARCHAR2_TABLE_2000
288: , p5_a9 JTF_NUMBER_TABLE
289: , p5_a10 JTF_DATE_TABLE
290: , p5_a11 JTF_NUMBER_TABLE
291: , p5_a12 JTF_DATE_TABLE
292: , p5_a13 JTF_NUMBER_TABLE
293: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 291: , p5_a12 JTF_DATE_TABLE

287: , p5_a8 JTF_VARCHAR2_TABLE_2000
288: , p5_a9 JTF_NUMBER_TABLE
289: , p5_a10 JTF_DATE_TABLE
290: , p5_a11 JTF_NUMBER_TABLE
291: , p5_a12 JTF_DATE_TABLE
292: , p5_a13 JTF_NUMBER_TABLE
293: , p6_a0 out nocopy JTF_NUMBER_TABLE
294: , p6_a1 out nocopy JTF_NUMBER_TABLE
295: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 303: , p6_a10 out nocopy JTF_DATE_TABLE

299: , p6_a6 out nocopy JTF_NUMBER_TABLE
300: , p6_a7 out nocopy JTF_NUMBER_TABLE
301: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
302: , p6_a9 out nocopy JTF_NUMBER_TABLE
303: , p6_a10 out nocopy JTF_DATE_TABLE
304: , p6_a11 out nocopy JTF_NUMBER_TABLE
305: , p6_a12 out nocopy JTF_DATE_TABLE
306: , p6_a13 out nocopy JTF_NUMBER_TABLE
307: );

Line 305: , p6_a12 out nocopy JTF_DATE_TABLE

301: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_2000
302: , p6_a9 out nocopy JTF_NUMBER_TABLE
303: , p6_a10 out nocopy JTF_DATE_TABLE
304: , p6_a11 out nocopy JTF_NUMBER_TABLE
305: , p6_a12 out nocopy JTF_DATE_TABLE
306: , p6_a13 out nocopy JTF_NUMBER_TABLE
307: );
308: procedure update_option_rules(p_api_version NUMBER
309: , p_init_msg_list VARCHAR2

Line 357: , p5_a10 JTF_DATE_TABLE

353: , p5_a6 JTF_NUMBER_TABLE
354: , p5_a7 JTF_NUMBER_TABLE
355: , p5_a8 JTF_VARCHAR2_TABLE_2000
356: , p5_a9 JTF_NUMBER_TABLE
357: , p5_a10 JTF_DATE_TABLE
358: , p5_a11 JTF_NUMBER_TABLE
359: , p5_a12 JTF_DATE_TABLE
360: , p5_a13 JTF_NUMBER_TABLE
361: );

Line 359: , p5_a12 JTF_DATE_TABLE

355: , p5_a8 JTF_VARCHAR2_TABLE_2000
356: , p5_a9 JTF_NUMBER_TABLE
357: , p5_a10 JTF_DATE_TABLE
358: , p5_a11 JTF_NUMBER_TABLE
359: , p5_a12 JTF_DATE_TABLE
360: , p5_a13 JTF_NUMBER_TABLE
361: );
362: procedure delete_option_rules(p_api_version NUMBER
363: , p_init_msg_list VARCHAR2

Line 397: , p5_a10 JTF_DATE_TABLE

393: , p5_a6 JTF_NUMBER_TABLE
394: , p5_a7 JTF_NUMBER_TABLE
395: , p5_a8 JTF_VARCHAR2_TABLE_2000
396: , p5_a9 JTF_NUMBER_TABLE
397: , p5_a10 JTF_DATE_TABLE
398: , p5_a11 JTF_NUMBER_TABLE
399: , p5_a12 JTF_DATE_TABLE
400: , p5_a13 JTF_NUMBER_TABLE
401: );

Line 399: , p5_a12 JTF_DATE_TABLE

395: , p5_a8 JTF_VARCHAR2_TABLE_2000
396: , p5_a9 JTF_NUMBER_TABLE
397: , p5_a10 JTF_DATE_TABLE
398: , p5_a11 JTF_NUMBER_TABLE
399: , p5_a12 JTF_DATE_TABLE
400: , p5_a13 JTF_NUMBER_TABLE
401: );
402: procedure validate_option_rules(p_api_version NUMBER
403: , p_init_msg_list VARCHAR2

Line 438: , p5_a11 JTF_DATE_TABLE

434: , p5_a7 JTF_NUMBER_TABLE
435: , p5_a8 JTF_NUMBER_TABLE
436: , p5_a9 JTF_VARCHAR2_TABLE_100
437: , p5_a10 JTF_NUMBER_TABLE
438: , p5_a11 JTF_DATE_TABLE
439: , p5_a12 JTF_NUMBER_TABLE
440: , p5_a13 JTF_DATE_TABLE
441: , p5_a14 JTF_NUMBER_TABLE
442: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 440: , p5_a13 JTF_DATE_TABLE

436: , p5_a9 JTF_VARCHAR2_TABLE_100
437: , p5_a10 JTF_NUMBER_TABLE
438: , p5_a11 JTF_DATE_TABLE
439: , p5_a12 JTF_NUMBER_TABLE
440: , p5_a13 JTF_DATE_TABLE
441: , p5_a14 JTF_NUMBER_TABLE
442: , p6_a0 out nocopy JTF_NUMBER_TABLE
443: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
444: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 453: , p6_a11 out nocopy JTF_DATE_TABLE

449: , p6_a7 out nocopy JTF_NUMBER_TABLE
450: , p6_a8 out nocopy JTF_NUMBER_TABLE
451: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
452: , p6_a10 out nocopy JTF_NUMBER_TABLE
453: , p6_a11 out nocopy JTF_DATE_TABLE
454: , p6_a12 out nocopy JTF_NUMBER_TABLE
455: , p6_a13 out nocopy JTF_DATE_TABLE
456: , p6_a14 out nocopy JTF_NUMBER_TABLE
457: );

Line 455: , p6_a13 out nocopy JTF_DATE_TABLE

451: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
452: , p6_a10 out nocopy JTF_NUMBER_TABLE
453: , p6_a11 out nocopy JTF_DATE_TABLE
454: , p6_a12 out nocopy JTF_NUMBER_TABLE
455: , p6_a13 out nocopy JTF_DATE_TABLE
456: , p6_a14 out nocopy JTF_NUMBER_TABLE
457: );
458: procedure create_option_val_rules(p_api_version NUMBER
459: , p_init_msg_list VARCHAR2

Line 510: , p5_a11 JTF_DATE_TABLE

506: , p5_a7 JTF_NUMBER_TABLE
507: , p5_a8 JTF_NUMBER_TABLE
508: , p5_a9 JTF_VARCHAR2_TABLE_100
509: , p5_a10 JTF_NUMBER_TABLE
510: , p5_a11 JTF_DATE_TABLE
511: , p5_a12 JTF_NUMBER_TABLE
512: , p5_a13 JTF_DATE_TABLE
513: , p5_a14 JTF_NUMBER_TABLE
514: );

Line 512: , p5_a13 JTF_DATE_TABLE

508: , p5_a9 JTF_VARCHAR2_TABLE_100
509: , p5_a10 JTF_NUMBER_TABLE
510: , p5_a11 JTF_DATE_TABLE
511: , p5_a12 JTF_NUMBER_TABLE
512: , p5_a13 JTF_DATE_TABLE
513: , p5_a14 JTF_NUMBER_TABLE
514: );
515: procedure lock_option_val_rules(p_api_version NUMBER
516: , p_init_msg_list VARCHAR2

Line 552: , p5_a11 JTF_DATE_TABLE

548: , p5_a7 JTF_NUMBER_TABLE
549: , p5_a8 JTF_NUMBER_TABLE
550: , p5_a9 JTF_VARCHAR2_TABLE_100
551: , p5_a10 JTF_NUMBER_TABLE
552: , p5_a11 JTF_DATE_TABLE
553: , p5_a12 JTF_NUMBER_TABLE
554: , p5_a13 JTF_DATE_TABLE
555: , p5_a14 JTF_NUMBER_TABLE
556: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 554: , p5_a13 JTF_DATE_TABLE

550: , p5_a9 JTF_VARCHAR2_TABLE_100
551: , p5_a10 JTF_NUMBER_TABLE
552: , p5_a11 JTF_DATE_TABLE
553: , p5_a12 JTF_NUMBER_TABLE
554: , p5_a13 JTF_DATE_TABLE
555: , p5_a14 JTF_NUMBER_TABLE
556: , p6_a0 out nocopy JTF_NUMBER_TABLE
557: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
558: , p6_a2 out nocopy JTF_NUMBER_TABLE

Line 567: , p6_a11 out nocopy JTF_DATE_TABLE

563: , p6_a7 out nocopy JTF_NUMBER_TABLE
564: , p6_a8 out nocopy JTF_NUMBER_TABLE
565: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
566: , p6_a10 out nocopy JTF_NUMBER_TABLE
567: , p6_a11 out nocopy JTF_DATE_TABLE
568: , p6_a12 out nocopy JTF_NUMBER_TABLE
569: , p6_a13 out nocopy JTF_DATE_TABLE
570: , p6_a14 out nocopy JTF_NUMBER_TABLE
571: );

Line 569: , p6_a13 out nocopy JTF_DATE_TABLE

565: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
566: , p6_a10 out nocopy JTF_NUMBER_TABLE
567: , p6_a11 out nocopy JTF_DATE_TABLE
568: , p6_a12 out nocopy JTF_NUMBER_TABLE
569: , p6_a13 out nocopy JTF_DATE_TABLE
570: , p6_a14 out nocopy JTF_NUMBER_TABLE
571: );
572: procedure update_option_val_rules(p_api_version NUMBER
573: , p_init_msg_list VARCHAR2

Line 624: , p5_a11 JTF_DATE_TABLE

620: , p5_a7 JTF_NUMBER_TABLE
621: , p5_a8 JTF_NUMBER_TABLE
622: , p5_a9 JTF_VARCHAR2_TABLE_100
623: , p5_a10 JTF_NUMBER_TABLE
624: , p5_a11 JTF_DATE_TABLE
625: , p5_a12 JTF_NUMBER_TABLE
626: , p5_a13 JTF_DATE_TABLE
627: , p5_a14 JTF_NUMBER_TABLE
628: );

Line 626: , p5_a13 JTF_DATE_TABLE

622: , p5_a9 JTF_VARCHAR2_TABLE_100
623: , p5_a10 JTF_NUMBER_TABLE
624: , p5_a11 JTF_DATE_TABLE
625: , p5_a12 JTF_NUMBER_TABLE
626: , p5_a13 JTF_DATE_TABLE
627: , p5_a14 JTF_NUMBER_TABLE
628: );
629: procedure delete_option_val_rules(p_api_version NUMBER
630: , p_init_msg_list VARCHAR2

Line 666: , p5_a11 JTF_DATE_TABLE

662: , p5_a7 JTF_NUMBER_TABLE
663: , p5_a8 JTF_NUMBER_TABLE
664: , p5_a9 JTF_VARCHAR2_TABLE_100
665: , p5_a10 JTF_NUMBER_TABLE
666: , p5_a11 JTF_DATE_TABLE
667: , p5_a12 JTF_NUMBER_TABLE
668: , p5_a13 JTF_DATE_TABLE
669: , p5_a14 JTF_NUMBER_TABLE
670: );

Line 668: , p5_a13 JTF_DATE_TABLE

664: , p5_a9 JTF_VARCHAR2_TABLE_100
665: , p5_a10 JTF_NUMBER_TABLE
666: , p5_a11 JTF_DATE_TABLE
667: , p5_a12 JTF_NUMBER_TABLE
668: , p5_a13 JTF_DATE_TABLE
669: , p5_a14 JTF_NUMBER_TABLE
670: );
671: procedure validate_option_val_rules(p_api_version NUMBER
672: , p_init_msg_list VARCHAR2