DBA Data[Home] [Help]

APPS.OKL_FE_EO_TERM_OPTIONS_PVT_W dependencies on JTF_DATE_TABLE

Line 46: , p7_a25 out nocopy JTF_DATE_TABLE

42: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_500
43: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_500
44: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
45: , p7_a24 out nocopy JTF_NUMBER_TABLE
46: , p7_a25 out nocopy JTF_DATE_TABLE
47: , p7_a26 out nocopy JTF_NUMBER_TABLE
48: , p7_a27 out nocopy JTF_DATE_TABLE
49: , p7_a28 out nocopy JTF_NUMBER_TABLE
50: );

Line 48: , p7_a27 out nocopy JTF_DATE_TABLE

44: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_500
45: , p7_a24 out nocopy JTF_NUMBER_TABLE
46: , p7_a25 out nocopy JTF_DATE_TABLE
47: , p7_a26 out nocopy JTF_NUMBER_TABLE
48: , p7_a27 out nocopy JTF_DATE_TABLE
49: , p7_a28 out nocopy JTF_NUMBER_TABLE
50: );
51: procedure get_eo_term_values(p_api_version NUMBER
52: , p_init_msg_list VARCHAR2

Line 80: , p7_a22 out nocopy JTF_DATE_TABLE

76: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_500
77: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_500
78: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_500
79: , p7_a21 out nocopy JTF_NUMBER_TABLE
80: , p7_a22 out nocopy JTF_DATE_TABLE
81: , p7_a23 out nocopy JTF_NUMBER_TABLE
82: , p7_a24 out nocopy JTF_DATE_TABLE
83: , p7_a25 out nocopy JTF_NUMBER_TABLE
84: );

Line 82: , p7_a24 out nocopy JTF_DATE_TABLE

78: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_500
79: , p7_a21 out nocopy JTF_NUMBER_TABLE
80: , p7_a22 out nocopy JTF_DATE_TABLE
81: , p7_a23 out nocopy JTF_NUMBER_TABLE
82: , p7_a24 out nocopy JTF_DATE_TABLE
83: , p7_a25 out nocopy JTF_NUMBER_TABLE
84: );
85: procedure get_end_of_term_option(p_api_version NUMBER
86: , p_init_msg_list VARCHAR2

Line 179: , p9_a25 out nocopy JTF_DATE_TABLE

175: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
176: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
177: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
178: , p9_a24 out nocopy JTF_NUMBER_TABLE
179: , p9_a25 out nocopy JTF_DATE_TABLE
180: , p9_a26 out nocopy JTF_NUMBER_TABLE
181: , p9_a27 out nocopy JTF_DATE_TABLE
182: , p9_a28 out nocopy JTF_NUMBER_TABLE
183: , p10_a0 out nocopy JTF_NUMBER_TABLE

Line 181: , p9_a27 out nocopy JTF_DATE_TABLE

177: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
178: , p9_a24 out nocopy JTF_NUMBER_TABLE
179: , p9_a25 out nocopy JTF_DATE_TABLE
180: , p9_a26 out nocopy JTF_NUMBER_TABLE
181: , p9_a27 out nocopy JTF_DATE_TABLE
182: , p9_a28 out nocopy JTF_NUMBER_TABLE
183: , p10_a0 out nocopy JTF_NUMBER_TABLE
184: , p10_a1 out nocopy JTF_NUMBER_TABLE
185: , p10_a2 out nocopy JTF_NUMBER_TABLE

Line 205: , p10_a22 out nocopy JTF_DATE_TABLE

201: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
202: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
203: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
204: , p10_a21 out nocopy JTF_NUMBER_TABLE
205: , p10_a22 out nocopy JTF_DATE_TABLE
206: , p10_a23 out nocopy JTF_NUMBER_TABLE
207: , p10_a24 out nocopy JTF_DATE_TABLE
208: , p10_a25 out nocopy JTF_NUMBER_TABLE
209: );

Line 207: , p10_a24 out nocopy JTF_DATE_TABLE

203: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
204: , p10_a21 out nocopy JTF_NUMBER_TABLE
205: , p10_a22 out nocopy JTF_DATE_TABLE
206: , p10_a23 out nocopy JTF_NUMBER_TABLE
207: , p10_a24 out nocopy JTF_DATE_TABLE
208: , p10_a25 out nocopy JTF_NUMBER_TABLE
209: );
210: procedure insert_end_of_term_option(p_api_version NUMBER
211: , p_init_msg_list VARCHAR2

Line 302: , p7_a25 JTF_DATE_TABLE

298: , p7_a21 JTF_VARCHAR2_TABLE_500
299: , p7_a22 JTF_VARCHAR2_TABLE_500
300: , p7_a23 JTF_VARCHAR2_TABLE_500
301: , p7_a24 JTF_NUMBER_TABLE
302: , p7_a25 JTF_DATE_TABLE
303: , p7_a26 JTF_NUMBER_TABLE
304: , p7_a27 JTF_DATE_TABLE
305: , p7_a28 JTF_NUMBER_TABLE
306: , p8_a0 JTF_NUMBER_TABLE

Line 304: , p7_a27 JTF_DATE_TABLE

300: , p7_a23 JTF_VARCHAR2_TABLE_500
301: , p7_a24 JTF_NUMBER_TABLE
302: , p7_a25 JTF_DATE_TABLE
303: , p7_a26 JTF_NUMBER_TABLE
304: , p7_a27 JTF_DATE_TABLE
305: , p7_a28 JTF_NUMBER_TABLE
306: , p8_a0 JTF_NUMBER_TABLE
307: , p8_a1 JTF_NUMBER_TABLE
308: , p8_a2 JTF_NUMBER_TABLE

Line 328: , p8_a22 JTF_DATE_TABLE

324: , p8_a18 JTF_VARCHAR2_TABLE_500
325: , p8_a19 JTF_VARCHAR2_TABLE_500
326: , p8_a20 JTF_VARCHAR2_TABLE_500
327: , p8_a21 JTF_NUMBER_TABLE
328: , p8_a22 JTF_DATE_TABLE
329: , p8_a23 JTF_NUMBER_TABLE
330: , p8_a24 JTF_DATE_TABLE
331: , p8_a25 JTF_NUMBER_TABLE
332: , p9_a0 out nocopy NUMBER

Line 330: , p8_a24 JTF_DATE_TABLE

326: , p8_a20 JTF_VARCHAR2_TABLE_500
327: , p8_a21 JTF_NUMBER_TABLE
328: , p8_a22 JTF_DATE_TABLE
329: , p8_a23 JTF_NUMBER_TABLE
330: , p8_a24 JTF_DATE_TABLE
331: , p8_a25 JTF_NUMBER_TABLE
332: , p9_a0 out nocopy NUMBER
333: , p9_a1 out nocopy NUMBER
334: , p9_a2 out nocopy VARCHAR2

Line 419: , p11_a25 out nocopy JTF_DATE_TABLE

415: , p11_a21 out nocopy JTF_VARCHAR2_TABLE_500
416: , p11_a22 out nocopy JTF_VARCHAR2_TABLE_500
417: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_500
418: , p11_a24 out nocopy JTF_NUMBER_TABLE
419: , p11_a25 out nocopy JTF_DATE_TABLE
420: , p11_a26 out nocopy JTF_NUMBER_TABLE
421: , p11_a27 out nocopy JTF_DATE_TABLE
422: , p11_a28 out nocopy JTF_NUMBER_TABLE
423: , p12_a0 out nocopy JTF_NUMBER_TABLE

Line 421: , p11_a27 out nocopy JTF_DATE_TABLE

417: , p11_a23 out nocopy JTF_VARCHAR2_TABLE_500
418: , p11_a24 out nocopy JTF_NUMBER_TABLE
419: , p11_a25 out nocopy JTF_DATE_TABLE
420: , p11_a26 out nocopy JTF_NUMBER_TABLE
421: , p11_a27 out nocopy JTF_DATE_TABLE
422: , p11_a28 out nocopy JTF_NUMBER_TABLE
423: , p12_a0 out nocopy JTF_NUMBER_TABLE
424: , p12_a1 out nocopy JTF_NUMBER_TABLE
425: , p12_a2 out nocopy JTF_NUMBER_TABLE

Line 445: , p12_a22 out nocopy JTF_DATE_TABLE

441: , p12_a18 out nocopy JTF_VARCHAR2_TABLE_500
442: , p12_a19 out nocopy JTF_VARCHAR2_TABLE_500
443: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_500
444: , p12_a21 out nocopy JTF_NUMBER_TABLE
445: , p12_a22 out nocopy JTF_DATE_TABLE
446: , p12_a23 out nocopy JTF_NUMBER_TABLE
447: , p12_a24 out nocopy JTF_DATE_TABLE
448: , p12_a25 out nocopy JTF_NUMBER_TABLE
449: );

Line 447: , p12_a24 out nocopy JTF_DATE_TABLE

443: , p12_a20 out nocopy JTF_VARCHAR2_TABLE_500
444: , p12_a21 out nocopy JTF_NUMBER_TABLE
445: , p12_a22 out nocopy JTF_DATE_TABLE
446: , p12_a23 out nocopy JTF_NUMBER_TABLE
447: , p12_a24 out nocopy JTF_DATE_TABLE
448: , p12_a25 out nocopy JTF_NUMBER_TABLE
449: );
450: procedure update_end_of_term_option(p_api_version NUMBER
451: , p_init_msg_list VARCHAR2

Line 508: , p6_a25 JTF_DATE_TABLE

504: , p6_a21 JTF_VARCHAR2_TABLE_500
505: , p6_a22 JTF_VARCHAR2_TABLE_500
506: , p6_a23 JTF_VARCHAR2_TABLE_500
507: , p6_a24 JTF_NUMBER_TABLE
508: , p6_a25 JTF_DATE_TABLE
509: , p6_a26 JTF_NUMBER_TABLE
510: , p6_a27 JTF_DATE_TABLE
511: , p6_a28 JTF_NUMBER_TABLE
512: , p7_a0 JTF_NUMBER_TABLE

Line 510: , p6_a27 JTF_DATE_TABLE

506: , p6_a23 JTF_VARCHAR2_TABLE_500
507: , p6_a24 JTF_NUMBER_TABLE
508: , p6_a25 JTF_DATE_TABLE
509: , p6_a26 JTF_NUMBER_TABLE
510: , p6_a27 JTF_DATE_TABLE
511: , p6_a28 JTF_NUMBER_TABLE
512: , p7_a0 JTF_NUMBER_TABLE
513: , p7_a1 JTF_NUMBER_TABLE
514: , p7_a2 JTF_NUMBER_TABLE

Line 534: , p7_a22 JTF_DATE_TABLE

530: , p7_a18 JTF_VARCHAR2_TABLE_500
531: , p7_a19 JTF_VARCHAR2_TABLE_500
532: , p7_a20 JTF_VARCHAR2_TABLE_500
533: , p7_a21 JTF_NUMBER_TABLE
534: , p7_a22 JTF_DATE_TABLE
535: , p7_a23 JTF_NUMBER_TABLE
536: , p7_a24 JTF_DATE_TABLE
537: , p7_a25 JTF_NUMBER_TABLE
538: , p8_a0 out nocopy NUMBER

Line 536: , p7_a24 JTF_DATE_TABLE

532: , p7_a20 JTF_VARCHAR2_TABLE_500
533: , p7_a21 JTF_NUMBER_TABLE
534: , p7_a22 JTF_DATE_TABLE
535: , p7_a23 JTF_NUMBER_TABLE
536: , p7_a24 JTF_DATE_TABLE
537: , p7_a25 JTF_NUMBER_TABLE
538: , p8_a0 out nocopy NUMBER
539: , p8_a1 out nocopy NUMBER
540: , p8_a2 out nocopy VARCHAR2

Line 591: , p9_a25 out nocopy JTF_DATE_TABLE

587: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
588: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
589: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
590: , p9_a24 out nocopy JTF_NUMBER_TABLE
591: , p9_a25 out nocopy JTF_DATE_TABLE
592: , p9_a26 out nocopy JTF_NUMBER_TABLE
593: , p9_a27 out nocopy JTF_DATE_TABLE
594: , p9_a28 out nocopy JTF_NUMBER_TABLE
595: , p10_a0 out nocopy JTF_NUMBER_TABLE

Line 593: , p9_a27 out nocopy JTF_DATE_TABLE

589: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
590: , p9_a24 out nocopy JTF_NUMBER_TABLE
591: , p9_a25 out nocopy JTF_DATE_TABLE
592: , p9_a26 out nocopy JTF_NUMBER_TABLE
593: , p9_a27 out nocopy JTF_DATE_TABLE
594: , p9_a28 out nocopy JTF_NUMBER_TABLE
595: , p10_a0 out nocopy JTF_NUMBER_TABLE
596: , p10_a1 out nocopy JTF_NUMBER_TABLE
597: , p10_a2 out nocopy JTF_NUMBER_TABLE

Line 617: , p10_a22 out nocopy JTF_DATE_TABLE

613: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
614: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
615: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
616: , p10_a21 out nocopy JTF_NUMBER_TABLE
617: , p10_a22 out nocopy JTF_DATE_TABLE
618: , p10_a23 out nocopy JTF_NUMBER_TABLE
619: , p10_a24 out nocopy JTF_DATE_TABLE
620: , p10_a25 out nocopy JTF_NUMBER_TABLE
621: );

Line 619: , p10_a24 out nocopy JTF_DATE_TABLE

615: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
616: , p10_a21 out nocopy JTF_NUMBER_TABLE
617: , p10_a22 out nocopy JTF_DATE_TABLE
618: , p10_a23 out nocopy JTF_NUMBER_TABLE
619: , p10_a24 out nocopy JTF_DATE_TABLE
620: , p10_a25 out nocopy JTF_NUMBER_TABLE
621: );
622: procedure create_version(p_api_version NUMBER
623: , p_init_msg_list VARCHAR2

Line 680: , p6_a25 JTF_DATE_TABLE

676: , p6_a21 JTF_VARCHAR2_TABLE_500
677: , p6_a22 JTF_VARCHAR2_TABLE_500
678: , p6_a23 JTF_VARCHAR2_TABLE_500
679: , p6_a24 JTF_NUMBER_TABLE
680: , p6_a25 JTF_DATE_TABLE
681: , p6_a26 JTF_NUMBER_TABLE
682: , p6_a27 JTF_DATE_TABLE
683: , p6_a28 JTF_NUMBER_TABLE
684: , p7_a0 JTF_NUMBER_TABLE

Line 682: , p6_a27 JTF_DATE_TABLE

678: , p6_a23 JTF_VARCHAR2_TABLE_500
679: , p6_a24 JTF_NUMBER_TABLE
680: , p6_a25 JTF_DATE_TABLE
681: , p6_a26 JTF_NUMBER_TABLE
682: , p6_a27 JTF_DATE_TABLE
683: , p6_a28 JTF_NUMBER_TABLE
684: , p7_a0 JTF_NUMBER_TABLE
685: , p7_a1 JTF_NUMBER_TABLE
686: , p7_a2 JTF_NUMBER_TABLE

Line 706: , p7_a22 JTF_DATE_TABLE

702: , p7_a18 JTF_VARCHAR2_TABLE_500
703: , p7_a19 JTF_VARCHAR2_TABLE_500
704: , p7_a20 JTF_VARCHAR2_TABLE_500
705: , p7_a21 JTF_NUMBER_TABLE
706: , p7_a22 JTF_DATE_TABLE
707: , p7_a23 JTF_NUMBER_TABLE
708: , p7_a24 JTF_DATE_TABLE
709: , p7_a25 JTF_NUMBER_TABLE
710: , p8_a0 out nocopy NUMBER

Line 708: , p7_a24 JTF_DATE_TABLE

704: , p7_a20 JTF_VARCHAR2_TABLE_500
705: , p7_a21 JTF_NUMBER_TABLE
706: , p7_a22 JTF_DATE_TABLE
707: , p7_a23 JTF_NUMBER_TABLE
708: , p7_a24 JTF_DATE_TABLE
709: , p7_a25 JTF_NUMBER_TABLE
710: , p8_a0 out nocopy NUMBER
711: , p8_a1 out nocopy NUMBER
712: , p8_a2 out nocopy VARCHAR2

Line 763: , p9_a25 out nocopy JTF_DATE_TABLE

759: , p9_a21 out nocopy JTF_VARCHAR2_TABLE_500
760: , p9_a22 out nocopy JTF_VARCHAR2_TABLE_500
761: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
762: , p9_a24 out nocopy JTF_NUMBER_TABLE
763: , p9_a25 out nocopy JTF_DATE_TABLE
764: , p9_a26 out nocopy JTF_NUMBER_TABLE
765: , p9_a27 out nocopy JTF_DATE_TABLE
766: , p9_a28 out nocopy JTF_NUMBER_TABLE
767: , p10_a0 out nocopy JTF_NUMBER_TABLE

Line 765: , p9_a27 out nocopy JTF_DATE_TABLE

761: , p9_a23 out nocopy JTF_VARCHAR2_TABLE_500
762: , p9_a24 out nocopy JTF_NUMBER_TABLE
763: , p9_a25 out nocopy JTF_DATE_TABLE
764: , p9_a26 out nocopy JTF_NUMBER_TABLE
765: , p9_a27 out nocopy JTF_DATE_TABLE
766: , p9_a28 out nocopy JTF_NUMBER_TABLE
767: , p10_a0 out nocopy JTF_NUMBER_TABLE
768: , p10_a1 out nocopy JTF_NUMBER_TABLE
769: , p10_a2 out nocopy JTF_NUMBER_TABLE

Line 789: , p10_a22 out nocopy JTF_DATE_TABLE

785: , p10_a18 out nocopy JTF_VARCHAR2_TABLE_500
786: , p10_a19 out nocopy JTF_VARCHAR2_TABLE_500
787: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
788: , p10_a21 out nocopy JTF_NUMBER_TABLE
789: , p10_a22 out nocopy JTF_DATE_TABLE
790: , p10_a23 out nocopy JTF_NUMBER_TABLE
791: , p10_a24 out nocopy JTF_DATE_TABLE
792: , p10_a25 out nocopy JTF_NUMBER_TABLE
793: );

Line 791: , p10_a24 out nocopy JTF_DATE_TABLE

787: , p10_a20 out nocopy JTF_VARCHAR2_TABLE_500
788: , p10_a21 out nocopy JTF_NUMBER_TABLE
789: , p10_a22 out nocopy JTF_DATE_TABLE
790: , p10_a23 out nocopy JTF_NUMBER_TABLE
791: , p10_a24 out nocopy JTF_DATE_TABLE
792: , p10_a25 out nocopy JTF_NUMBER_TABLE
793: );
794: procedure invalid_objects(p_api_version NUMBER
795: , p_init_msg_list VARCHAR2