DBA Data[Home] [Help]

APPS.OKL_FE_EO_TERM_OPTIONS_PUB_W dependencies on JTF_DATE_TABLE

Line 35: , p7_a25 out nocopy JTF_DATE_TABLE

31: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_500
32: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_500
33: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
34: , p7_a24 out nocopy JTF_NUMBER_TABLE
35: , p7_a25 out nocopy JTF_DATE_TABLE
36: , p7_a26 out nocopy JTF_NUMBER_TABLE
37: , p7_a27 out nocopy JTF_DATE_TABLE
38: , p7_a28 out nocopy JTF_NUMBER_TABLE
39: );

Line 37: , p7_a27 out nocopy JTF_DATE_TABLE

33: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
34: , p7_a24 out nocopy JTF_NUMBER_TABLE
35: , p7_a25 out nocopy JTF_DATE_TABLE
36: , p7_a26 out nocopy JTF_NUMBER_TABLE
37: , p7_a27 out nocopy JTF_DATE_TABLE
38: , p7_a28 out nocopy JTF_NUMBER_TABLE
39: );
40: procedure get_eo_term_values(p_api_version NUMBER
41: , p_init_msg_list VARCHAR2

Line 69: , p7_a22 out nocopy JTF_DATE_TABLE

65: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_500
66: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_500
67: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_500
68: , p7_a21 out nocopy JTF_NUMBER_TABLE
69: , p7_a22 out nocopy JTF_DATE_TABLE
70: , p7_a23 out nocopy JTF_NUMBER_TABLE
71: , p7_a24 out nocopy JTF_DATE_TABLE
72: , p7_a25 out nocopy JTF_NUMBER_TABLE
73: );

Line 71: , p7_a24 out nocopy JTF_DATE_TABLE

67: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_500
68: , p7_a21 out nocopy JTF_NUMBER_TABLE
69: , p7_a22 out nocopy JTF_DATE_TABLE
70: , p7_a23 out nocopy JTF_NUMBER_TABLE
71: , p7_a24 out nocopy JTF_DATE_TABLE
72: , p7_a25 out nocopy JTF_NUMBER_TABLE
73: );
74: procedure get_end_of_term_option(p_api_version NUMBER
75: , p_init_msg_list VARCHAR2

Line 168: , p9_a25 out nocopy JTF_DATE_TABLE

164: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
165: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
166: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
167: , p9_a24 out nocopy JTF_NUMBER_TABLE
168: , p9_a25 out nocopy JTF_DATE_TABLE
169: , p9_a26 out nocopy JTF_NUMBER_TABLE
170: , p9_a27 out nocopy JTF_DATE_TABLE
171: , p9_a28 out nocopy JTF_NUMBER_TABLE
172: , p10_a0 out nocopy JTF_NUMBER_TABLE

Line 170: , p9_a27 out nocopy JTF_DATE_TABLE

166: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
167: , p9_a24 out nocopy JTF_NUMBER_TABLE
168: , p9_a25 out nocopy JTF_DATE_TABLE
169: , p9_a26 out nocopy JTF_NUMBER_TABLE
170: , p9_a27 out nocopy JTF_DATE_TABLE
171: , p9_a28 out nocopy JTF_NUMBER_TABLE
172: , p10_a0 out nocopy JTF_NUMBER_TABLE
173: , p10_a1 out nocopy JTF_NUMBER_TABLE
174: , p10_a2 out nocopy JTF_NUMBER_TABLE

Line 194: , p10_a22 out nocopy JTF_DATE_TABLE

190: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
191: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
192: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
193: , p10_a21 out nocopy JTF_NUMBER_TABLE
194: , p10_a22 out nocopy JTF_DATE_TABLE
195: , p10_a23 out nocopy JTF_NUMBER_TABLE
196: , p10_a24 out nocopy JTF_DATE_TABLE
197: , p10_a25 out nocopy JTF_NUMBER_TABLE
198: );

Line 196: , p10_a24 out nocopy JTF_DATE_TABLE

192: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
193: , p10_a21 out nocopy JTF_NUMBER_TABLE
194: , p10_a22 out nocopy JTF_DATE_TABLE
195: , p10_a23 out nocopy JTF_NUMBER_TABLE
196: , p10_a24 out nocopy JTF_DATE_TABLE
197: , p10_a25 out nocopy JTF_NUMBER_TABLE
198: );
199: procedure insert_end_of_term_option(p_api_version NUMBER
200: , p_init_msg_list VARCHAR2

Line 291: , p7_a25 JTF_DATE_TABLE

287: , p7_a21 JTF_VARCHAR2_TABLE_500
288: , p7_a22 JTF_VARCHAR2_TABLE_500
289: , p7_a23 JTF_VARCHAR2_TABLE_500
290: , p7_a24 JTF_NUMBER_TABLE
291: , p7_a25 JTF_DATE_TABLE
292: , p7_a26 JTF_NUMBER_TABLE
293: , p7_a27 JTF_DATE_TABLE
294: , p7_a28 JTF_NUMBER_TABLE
295: , p8_a0 JTF_NUMBER_TABLE

Line 293: , p7_a27 JTF_DATE_TABLE

289: , p7_a23 JTF_VARCHAR2_TABLE_500
290: , p7_a24 JTF_NUMBER_TABLE
291: , p7_a25 JTF_DATE_TABLE
292: , p7_a26 JTF_NUMBER_TABLE
293: , p7_a27 JTF_DATE_TABLE
294: , p7_a28 JTF_NUMBER_TABLE
295: , p8_a0 JTF_NUMBER_TABLE
296: , p8_a1 JTF_NUMBER_TABLE
297: , p8_a2 JTF_NUMBER_TABLE

Line 317: , p8_a22 JTF_DATE_TABLE

313: , p8_a18 JTF_VARCHAR2_TABLE_500
314: , p8_a19 JTF_VARCHAR2_TABLE_500
315: , p8_a20 JTF_VARCHAR2_TABLE_500
316: , p8_a21 JTF_NUMBER_TABLE
317: , p8_a22 JTF_DATE_TABLE
318: , p8_a23 JTF_NUMBER_TABLE
319: , p8_a24 JTF_DATE_TABLE
320: , p8_a25 JTF_NUMBER_TABLE
321: , p9_a0 out nocopy NUMBER

Line 319: , p8_a24 JTF_DATE_TABLE

315: , p8_a20 JTF_VARCHAR2_TABLE_500
316: , p8_a21 JTF_NUMBER_TABLE
317: , p8_a22 JTF_DATE_TABLE
318: , p8_a23 JTF_NUMBER_TABLE
319: , p8_a24 JTF_DATE_TABLE
320: , p8_a25 JTF_NUMBER_TABLE
321: , p9_a0 out nocopy NUMBER
322: , p9_a1 out nocopy NUMBER
323: , p9_a2 out nocopy VARCHAR2

Line 408: , p11_a25 out nocopy JTF_DATE_TABLE

404: , p11_a21 out nocopy JTF_VARCHAR2_TABLE_500
405: , p11_a22 out nocopy JTF_VARCHAR2_TABLE_500
406: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_500
407: , p11_a24 out nocopy JTF_NUMBER_TABLE
408: , p11_a25 out nocopy JTF_DATE_TABLE
409: , p11_a26 out nocopy JTF_NUMBER_TABLE
410: , p11_a27 out nocopy JTF_DATE_TABLE
411: , p11_a28 out nocopy JTF_NUMBER_TABLE
412: , p12_a0 out nocopy JTF_NUMBER_TABLE

Line 410: , p11_a27 out nocopy JTF_DATE_TABLE

406: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_500
407: , p11_a24 out nocopy JTF_NUMBER_TABLE
408: , p11_a25 out nocopy JTF_DATE_TABLE
409: , p11_a26 out nocopy JTF_NUMBER_TABLE
410: , p11_a27 out nocopy JTF_DATE_TABLE
411: , p11_a28 out nocopy JTF_NUMBER_TABLE
412: , p12_a0 out nocopy JTF_NUMBER_TABLE
413: , p12_a1 out nocopy JTF_NUMBER_TABLE
414: , p12_a2 out nocopy JTF_NUMBER_TABLE

Line 434: , p12_a22 out nocopy JTF_DATE_TABLE

430: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_500
431: , p12_a19 out nocopy JTF_VARCHAR2_TABLE_500
432: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_500
433: , p12_a21 out nocopy JTF_NUMBER_TABLE
434: , p12_a22 out nocopy JTF_DATE_TABLE
435: , p12_a23 out nocopy JTF_NUMBER_TABLE
436: , p12_a24 out nocopy JTF_DATE_TABLE
437: , p12_a25 out nocopy JTF_NUMBER_TABLE
438: );

Line 436: , p12_a24 out nocopy JTF_DATE_TABLE

432: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_500
433: , p12_a21 out nocopy JTF_NUMBER_TABLE
434: , p12_a22 out nocopy JTF_DATE_TABLE
435: , p12_a23 out nocopy JTF_NUMBER_TABLE
436: , p12_a24 out nocopy JTF_DATE_TABLE
437: , p12_a25 out nocopy JTF_NUMBER_TABLE
438: );
439: procedure update_end_of_term_option(p_api_version NUMBER
440: , p_init_msg_list VARCHAR2

Line 497: , p6_a25 JTF_DATE_TABLE

493: , p6_a21 JTF_VARCHAR2_TABLE_500
494: , p6_a22 JTF_VARCHAR2_TABLE_500
495: , p6_a23 JTF_VARCHAR2_TABLE_500
496: , p6_a24 JTF_NUMBER_TABLE
497: , p6_a25 JTF_DATE_TABLE
498: , p6_a26 JTF_NUMBER_TABLE
499: , p6_a27 JTF_DATE_TABLE
500: , p6_a28 JTF_NUMBER_TABLE
501: , p7_a0 JTF_NUMBER_TABLE

Line 499: , p6_a27 JTF_DATE_TABLE

495: , p6_a23 JTF_VARCHAR2_TABLE_500
496: , p6_a24 JTF_NUMBER_TABLE
497: , p6_a25 JTF_DATE_TABLE
498: , p6_a26 JTF_NUMBER_TABLE
499: , p6_a27 JTF_DATE_TABLE
500: , p6_a28 JTF_NUMBER_TABLE
501: , p7_a0 JTF_NUMBER_TABLE
502: , p7_a1 JTF_NUMBER_TABLE
503: , p7_a2 JTF_NUMBER_TABLE

Line 523: , p7_a22 JTF_DATE_TABLE

519: , p7_a18 JTF_VARCHAR2_TABLE_500
520: , p7_a19 JTF_VARCHAR2_TABLE_500
521: , p7_a20 JTF_VARCHAR2_TABLE_500
522: , p7_a21 JTF_NUMBER_TABLE
523: , p7_a22 JTF_DATE_TABLE
524: , p7_a23 JTF_NUMBER_TABLE
525: , p7_a24 JTF_DATE_TABLE
526: , p7_a25 JTF_NUMBER_TABLE
527: , p8_a0 out nocopy NUMBER

Line 525: , p7_a24 JTF_DATE_TABLE

521: , p7_a20 JTF_VARCHAR2_TABLE_500
522: , p7_a21 JTF_NUMBER_TABLE
523: , p7_a22 JTF_DATE_TABLE
524: , p7_a23 JTF_NUMBER_TABLE
525: , p7_a24 JTF_DATE_TABLE
526: , p7_a25 JTF_NUMBER_TABLE
527: , p8_a0 out nocopy NUMBER
528: , p8_a1 out nocopy NUMBER
529: , p8_a2 out nocopy VARCHAR2

Line 580: , p9_a25 out nocopy JTF_DATE_TABLE

576: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
577: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
578: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
579: , p9_a24 out nocopy JTF_NUMBER_TABLE
580: , p9_a25 out nocopy JTF_DATE_TABLE
581: , p9_a26 out nocopy JTF_NUMBER_TABLE
582: , p9_a27 out nocopy JTF_DATE_TABLE
583: , p9_a28 out nocopy JTF_NUMBER_TABLE
584: , p10_a0 out nocopy JTF_NUMBER_TABLE

Line 582: , p9_a27 out nocopy JTF_DATE_TABLE

578: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
579: , p9_a24 out nocopy JTF_NUMBER_TABLE
580: , p9_a25 out nocopy JTF_DATE_TABLE
581: , p9_a26 out nocopy JTF_NUMBER_TABLE
582: , p9_a27 out nocopy JTF_DATE_TABLE
583: , p9_a28 out nocopy JTF_NUMBER_TABLE
584: , p10_a0 out nocopy JTF_NUMBER_TABLE
585: , p10_a1 out nocopy JTF_NUMBER_TABLE
586: , p10_a2 out nocopy JTF_NUMBER_TABLE

Line 606: , p10_a22 out nocopy JTF_DATE_TABLE

602: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
603: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
604: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
605: , p10_a21 out nocopy JTF_NUMBER_TABLE
606: , p10_a22 out nocopy JTF_DATE_TABLE
607: , p10_a23 out nocopy JTF_NUMBER_TABLE
608: , p10_a24 out nocopy JTF_DATE_TABLE
609: , p10_a25 out nocopy JTF_NUMBER_TABLE
610: );

Line 608: , p10_a24 out nocopy JTF_DATE_TABLE

604: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
605: , p10_a21 out nocopy JTF_NUMBER_TABLE
606: , p10_a22 out nocopy JTF_DATE_TABLE
607: , p10_a23 out nocopy JTF_NUMBER_TABLE
608: , p10_a24 out nocopy JTF_DATE_TABLE
609: , p10_a25 out nocopy JTF_NUMBER_TABLE
610: );
611: procedure create_version(p_api_version NUMBER
612: , p_init_msg_list VARCHAR2

Line 669: , p6_a25 JTF_DATE_TABLE

665: , p6_a21 JTF_VARCHAR2_TABLE_500
666: , p6_a22 JTF_VARCHAR2_TABLE_500
667: , p6_a23 JTF_VARCHAR2_TABLE_500
668: , p6_a24 JTF_NUMBER_TABLE
669: , p6_a25 JTF_DATE_TABLE
670: , p6_a26 JTF_NUMBER_TABLE
671: , p6_a27 JTF_DATE_TABLE
672: , p6_a28 JTF_NUMBER_TABLE
673: , p7_a0 JTF_NUMBER_TABLE

Line 671: , p6_a27 JTF_DATE_TABLE

667: , p6_a23 JTF_VARCHAR2_TABLE_500
668: , p6_a24 JTF_NUMBER_TABLE
669: , p6_a25 JTF_DATE_TABLE
670: , p6_a26 JTF_NUMBER_TABLE
671: , p6_a27 JTF_DATE_TABLE
672: , p6_a28 JTF_NUMBER_TABLE
673: , p7_a0 JTF_NUMBER_TABLE
674: , p7_a1 JTF_NUMBER_TABLE
675: , p7_a2 JTF_NUMBER_TABLE

Line 695: , p7_a22 JTF_DATE_TABLE

691: , p7_a18 JTF_VARCHAR2_TABLE_500
692: , p7_a19 JTF_VARCHAR2_TABLE_500
693: , p7_a20 JTF_VARCHAR2_TABLE_500
694: , p7_a21 JTF_NUMBER_TABLE
695: , p7_a22 JTF_DATE_TABLE
696: , p7_a23 JTF_NUMBER_TABLE
697: , p7_a24 JTF_DATE_TABLE
698: , p7_a25 JTF_NUMBER_TABLE
699: , p8_a0 out nocopy NUMBER

Line 697: , p7_a24 JTF_DATE_TABLE

693: , p7_a20 JTF_VARCHAR2_TABLE_500
694: , p7_a21 JTF_NUMBER_TABLE
695: , p7_a22 JTF_DATE_TABLE
696: , p7_a23 JTF_NUMBER_TABLE
697: , p7_a24 JTF_DATE_TABLE
698: , p7_a25 JTF_NUMBER_TABLE
699: , p8_a0 out nocopy NUMBER
700: , p8_a1 out nocopy NUMBER
701: , p8_a2 out nocopy VARCHAR2

Line 752: , p9_a25 out nocopy JTF_DATE_TABLE

748: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
749: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
750: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
751: , p9_a24 out nocopy JTF_NUMBER_TABLE
752: , p9_a25 out nocopy JTF_DATE_TABLE
753: , p9_a26 out nocopy JTF_NUMBER_TABLE
754: , p9_a27 out nocopy JTF_DATE_TABLE
755: , p9_a28 out nocopy JTF_NUMBER_TABLE
756: , p10_a0 out nocopy JTF_NUMBER_TABLE

Line 754: , p9_a27 out nocopy JTF_DATE_TABLE

750: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
751: , p9_a24 out nocopy JTF_NUMBER_TABLE
752: , p9_a25 out nocopy JTF_DATE_TABLE
753: , p9_a26 out nocopy JTF_NUMBER_TABLE
754: , p9_a27 out nocopy JTF_DATE_TABLE
755: , p9_a28 out nocopy JTF_NUMBER_TABLE
756: , p10_a0 out nocopy JTF_NUMBER_TABLE
757: , p10_a1 out nocopy JTF_NUMBER_TABLE
758: , p10_a2 out nocopy JTF_NUMBER_TABLE

Line 778: , p10_a22 out nocopy JTF_DATE_TABLE

774: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
775: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
776: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
777: , p10_a21 out nocopy JTF_NUMBER_TABLE
778: , p10_a22 out nocopy JTF_DATE_TABLE
779: , p10_a23 out nocopy JTF_NUMBER_TABLE
780: , p10_a24 out nocopy JTF_DATE_TABLE
781: , p10_a25 out nocopy JTF_NUMBER_TABLE
782: );

Line 780: , p10_a24 out nocopy JTF_DATE_TABLE

776: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
777: , p10_a21 out nocopy JTF_NUMBER_TABLE
778: , p10_a22 out nocopy JTF_DATE_TABLE
779: , p10_a23 out nocopy JTF_NUMBER_TABLE
780: , p10_a24 out nocopy JTF_DATE_TABLE
781: , p10_a25 out nocopy JTF_NUMBER_TABLE
782: );
783: procedure invalid_objects(p_api_version NUMBER
784: , p_init_msg_list VARCHAR2