DBA Data[Home] [Help]

APPS.OKL_OPT_RUL_TMP_PUB_W dependencies on JTF_NUMBER_TABLE

Line 29: , p6_a1 JTF_NUMBER_TABLE

25: , x_msg_count out nocopy NUMBER
26: , x_msg_data out nocopy VARCHAR2
27: , p_ovd_id NUMBER
28: , p6_a0 JTF_VARCHAR2_TABLE_100
29: , p6_a1 JTF_NUMBER_TABLE
30: , p6_a2 JTF_NUMBER_TABLE
31: , p6_a3 JTF_VARCHAR2_TABLE_100
32: , p6_a4 JTF_VARCHAR2_TABLE_100
33: , p6_a5 JTF_VARCHAR2_TABLE_100

Line 30: , p6_a2 JTF_NUMBER_TABLE

26: , x_msg_data out nocopy VARCHAR2
27: , p_ovd_id NUMBER
28: , p6_a0 JTF_VARCHAR2_TABLE_100
29: , p6_a1 JTF_NUMBER_TABLE
30: , p6_a2 JTF_NUMBER_TABLE
31: , p6_a3 JTF_VARCHAR2_TABLE_100
32: , p6_a4 JTF_VARCHAR2_TABLE_100
33: , p6_a5 JTF_VARCHAR2_TABLE_100
34: , p6_a6 JTF_VARCHAR2_TABLE_100

Line 41: , p6_a13 JTF_NUMBER_TABLE

37: , p6_a9 JTF_VARCHAR2_TABLE_200
38: , p6_a10 JTF_VARCHAR2_TABLE_100
39: , p6_a11 JTF_VARCHAR2_TABLE_100
40: , p6_a12 JTF_VARCHAR2_TABLE_100
41: , p6_a13 JTF_NUMBER_TABLE
42: , p6_a14 JTF_NUMBER_TABLE
43: , p6_a15 JTF_NUMBER_TABLE
44: , p6_a16 JTF_VARCHAR2_TABLE_100
45: , p6_a17 JTF_VARCHAR2_TABLE_2000

Line 42: , p6_a14 JTF_NUMBER_TABLE

38: , p6_a10 JTF_VARCHAR2_TABLE_100
39: , p6_a11 JTF_VARCHAR2_TABLE_100
40: , p6_a12 JTF_VARCHAR2_TABLE_100
41: , p6_a13 JTF_NUMBER_TABLE
42: , p6_a14 JTF_NUMBER_TABLE
43: , p6_a15 JTF_NUMBER_TABLE
44: , p6_a16 JTF_VARCHAR2_TABLE_100
45: , p6_a17 JTF_VARCHAR2_TABLE_2000
46: , p6_a18 JTF_VARCHAR2_TABLE_100

Line 43: , p6_a15 JTF_NUMBER_TABLE

39: , p6_a11 JTF_VARCHAR2_TABLE_100
40: , p6_a12 JTF_VARCHAR2_TABLE_100
41: , p6_a13 JTF_NUMBER_TABLE
42: , p6_a14 JTF_NUMBER_TABLE
43: , p6_a15 JTF_NUMBER_TABLE
44: , p6_a16 JTF_VARCHAR2_TABLE_100
45: , p6_a17 JTF_VARCHAR2_TABLE_2000
46: , p6_a18 JTF_VARCHAR2_TABLE_100
47: , p6_a19 JTF_VARCHAR2_TABLE_100

Line 63: , p6_a35 JTF_NUMBER_TABLE

59: , p6_a31 JTF_VARCHAR2_TABLE_500
60: , p6_a32 JTF_VARCHAR2_TABLE_500
61: , p6_a33 JTF_VARCHAR2_TABLE_500
62: , p6_a34 JTF_VARCHAR2_TABLE_500
63: , p6_a35 JTF_NUMBER_TABLE
64: , p6_a36 JTF_DATE_TABLE
65: , p6_a37 JTF_NUMBER_TABLE
66: , p6_a38 JTF_DATE_TABLE
67: , p6_a39 JTF_NUMBER_TABLE

Line 65: , p6_a37 JTF_NUMBER_TABLE

61: , p6_a33 JTF_VARCHAR2_TABLE_500
62: , p6_a34 JTF_VARCHAR2_TABLE_500
63: , p6_a35 JTF_NUMBER_TABLE
64: , p6_a36 JTF_DATE_TABLE
65: , p6_a37 JTF_NUMBER_TABLE
66: , p6_a38 JTF_DATE_TABLE
67: , p6_a39 JTF_NUMBER_TABLE
68: , p6_a40 JTF_VARCHAR2_TABLE_100
69: , p6_a41 JTF_VARCHAR2_TABLE_500

Line 67: , p6_a39 JTF_NUMBER_TABLE

63: , p6_a35 JTF_NUMBER_TABLE
64: , p6_a36 JTF_DATE_TABLE
65: , p6_a37 JTF_NUMBER_TABLE
66: , p6_a38 JTF_DATE_TABLE
67: , p6_a39 JTF_NUMBER_TABLE
68: , p6_a40 JTF_VARCHAR2_TABLE_100
69: , p6_a41 JTF_VARCHAR2_TABLE_500
70: , p6_a42 JTF_VARCHAR2_TABLE_500
71: , p6_a43 JTF_VARCHAR2_TABLE_500

Line 88: , p6_a60 JTF_NUMBER_TABLE

84: , p6_a56 JTF_VARCHAR2_TABLE_100
85: , p6_a57 JTF_VARCHAR2_TABLE_100
86: , p6_a58 JTF_VARCHAR2_TABLE_100
87: , p6_a59 JTF_VARCHAR2_TABLE_100
88: , p6_a60 JTF_NUMBER_TABLE
89: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
90: , p7_a1 out nocopy JTF_NUMBER_TABLE
91: , p7_a2 out nocopy JTF_NUMBER_TABLE
92: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 90: , p7_a1 out nocopy JTF_NUMBER_TABLE

86: , p6_a58 JTF_VARCHAR2_TABLE_100
87: , p6_a59 JTF_VARCHAR2_TABLE_100
88: , p6_a60 JTF_NUMBER_TABLE
89: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
90: , p7_a1 out nocopy JTF_NUMBER_TABLE
91: , p7_a2 out nocopy JTF_NUMBER_TABLE
92: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
93: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
94: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 91: , p7_a2 out nocopy JTF_NUMBER_TABLE

87: , p6_a59 JTF_VARCHAR2_TABLE_100
88: , p6_a60 JTF_NUMBER_TABLE
89: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
90: , p7_a1 out nocopy JTF_NUMBER_TABLE
91: , p7_a2 out nocopy JTF_NUMBER_TABLE
92: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
93: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
94: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
95: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 102: , p7_a13 out nocopy JTF_NUMBER_TABLE

98: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_200
99: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
100: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
101: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
102: , p7_a13 out nocopy JTF_NUMBER_TABLE
103: , p7_a14 out nocopy JTF_NUMBER_TABLE
104: , p7_a15 out nocopy JTF_NUMBER_TABLE
105: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
106: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000

Line 103: , p7_a14 out nocopy JTF_NUMBER_TABLE

99: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
100: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
101: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
102: , p7_a13 out nocopy JTF_NUMBER_TABLE
103: , p7_a14 out nocopy JTF_NUMBER_TABLE
104: , p7_a15 out nocopy JTF_NUMBER_TABLE
105: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
106: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000
107: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 104: , p7_a15 out nocopy JTF_NUMBER_TABLE

100: , p7_a11 out nocopy JTF_VARCHAR2_TABLE_100
101: , p7_a12 out nocopy JTF_VARCHAR2_TABLE_100
102: , p7_a13 out nocopy JTF_NUMBER_TABLE
103: , p7_a14 out nocopy JTF_NUMBER_TABLE
104: , p7_a15 out nocopy JTF_NUMBER_TABLE
105: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
106: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_2000
107: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
108: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 124: , p7_a35 out nocopy JTF_NUMBER_TABLE

120: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_500
121: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_500
122: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_500
123: , p7_a34 out nocopy JTF_VARCHAR2_TABLE_500
124: , p7_a35 out nocopy JTF_NUMBER_TABLE
125: , p7_a36 out nocopy JTF_DATE_TABLE
126: , p7_a37 out nocopy JTF_NUMBER_TABLE
127: , p7_a38 out nocopy JTF_DATE_TABLE
128: , p7_a39 out nocopy JTF_NUMBER_TABLE

Line 126: , p7_a37 out nocopy JTF_NUMBER_TABLE

122: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_500
123: , p7_a34 out nocopy JTF_VARCHAR2_TABLE_500
124: , p7_a35 out nocopy JTF_NUMBER_TABLE
125: , p7_a36 out nocopy JTF_DATE_TABLE
126: , p7_a37 out nocopy JTF_NUMBER_TABLE
127: , p7_a38 out nocopy JTF_DATE_TABLE
128: , p7_a39 out nocopy JTF_NUMBER_TABLE
129: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
130: , p7_a41 out nocopy JTF_VARCHAR2_TABLE_500

Line 128: , p7_a39 out nocopy JTF_NUMBER_TABLE

124: , p7_a35 out nocopy JTF_NUMBER_TABLE
125: , p7_a36 out nocopy JTF_DATE_TABLE
126: , p7_a37 out nocopy JTF_NUMBER_TABLE
127: , p7_a38 out nocopy JTF_DATE_TABLE
128: , p7_a39 out nocopy JTF_NUMBER_TABLE
129: , p7_a40 out nocopy JTF_VARCHAR2_TABLE_100
130: , p7_a41 out nocopy JTF_VARCHAR2_TABLE_500
131: , p7_a42 out nocopy JTF_VARCHAR2_TABLE_500
132: , p7_a43 out nocopy JTF_VARCHAR2_TABLE_500

Line 149: , p7_a60 out nocopy JTF_NUMBER_TABLE

145: , p7_a56 out nocopy JTF_VARCHAR2_TABLE_100
146: , p7_a57 out nocopy JTF_VARCHAR2_TABLE_100
147: , p7_a58 out nocopy JTF_VARCHAR2_TABLE_100
148: , p7_a59 out nocopy JTF_VARCHAR2_TABLE_100
149: , p7_a60 out nocopy JTF_NUMBER_TABLE
150: )
151:
152: as
153: ddp_rgrv_tbl okl_opt_rul_tmp_pub.rgrv_tbl_type;

Line 604: , p5_a1 JTF_NUMBER_TABLE

600: , x_return_status out nocopy VARCHAR2
601: , x_msg_count out nocopy NUMBER
602: , x_msg_data out nocopy VARCHAR2
603: , p5_a0 JTF_VARCHAR2_TABLE_100
604: , p5_a1 JTF_NUMBER_TABLE
605: , p5_a2 JTF_NUMBER_TABLE
606: , p5_a3 JTF_VARCHAR2_TABLE_100
607: , p5_a4 JTF_VARCHAR2_TABLE_100
608: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 605: , p5_a2 JTF_NUMBER_TABLE

601: , x_msg_count out nocopy NUMBER
602: , x_msg_data out nocopy VARCHAR2
603: , p5_a0 JTF_VARCHAR2_TABLE_100
604: , p5_a1 JTF_NUMBER_TABLE
605: , p5_a2 JTF_NUMBER_TABLE
606: , p5_a3 JTF_VARCHAR2_TABLE_100
607: , p5_a4 JTF_VARCHAR2_TABLE_100
608: , p5_a5 JTF_VARCHAR2_TABLE_100
609: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 616: , p5_a13 JTF_NUMBER_TABLE

612: , p5_a9 JTF_VARCHAR2_TABLE_200
613: , p5_a10 JTF_VARCHAR2_TABLE_100
614: , p5_a11 JTF_VARCHAR2_TABLE_100
615: , p5_a12 JTF_VARCHAR2_TABLE_100
616: , p5_a13 JTF_NUMBER_TABLE
617: , p5_a14 JTF_NUMBER_TABLE
618: , p5_a15 JTF_NUMBER_TABLE
619: , p5_a16 JTF_VARCHAR2_TABLE_100
620: , p5_a17 JTF_VARCHAR2_TABLE_2000

Line 617: , p5_a14 JTF_NUMBER_TABLE

613: , p5_a10 JTF_VARCHAR2_TABLE_100
614: , p5_a11 JTF_VARCHAR2_TABLE_100
615: , p5_a12 JTF_VARCHAR2_TABLE_100
616: , p5_a13 JTF_NUMBER_TABLE
617: , p5_a14 JTF_NUMBER_TABLE
618: , p5_a15 JTF_NUMBER_TABLE
619: , p5_a16 JTF_VARCHAR2_TABLE_100
620: , p5_a17 JTF_VARCHAR2_TABLE_2000
621: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 618: , p5_a15 JTF_NUMBER_TABLE

614: , p5_a11 JTF_VARCHAR2_TABLE_100
615: , p5_a12 JTF_VARCHAR2_TABLE_100
616: , p5_a13 JTF_NUMBER_TABLE
617: , p5_a14 JTF_NUMBER_TABLE
618: , p5_a15 JTF_NUMBER_TABLE
619: , p5_a16 JTF_VARCHAR2_TABLE_100
620: , p5_a17 JTF_VARCHAR2_TABLE_2000
621: , p5_a18 JTF_VARCHAR2_TABLE_100
622: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 638: , p5_a35 JTF_NUMBER_TABLE

634: , p5_a31 JTF_VARCHAR2_TABLE_500
635: , p5_a32 JTF_VARCHAR2_TABLE_500
636: , p5_a33 JTF_VARCHAR2_TABLE_500
637: , p5_a34 JTF_VARCHAR2_TABLE_500
638: , p5_a35 JTF_NUMBER_TABLE
639: , p5_a36 JTF_DATE_TABLE
640: , p5_a37 JTF_NUMBER_TABLE
641: , p5_a38 JTF_DATE_TABLE
642: , p5_a39 JTF_NUMBER_TABLE

Line 640: , p5_a37 JTF_NUMBER_TABLE

636: , p5_a33 JTF_VARCHAR2_TABLE_500
637: , p5_a34 JTF_VARCHAR2_TABLE_500
638: , p5_a35 JTF_NUMBER_TABLE
639: , p5_a36 JTF_DATE_TABLE
640: , p5_a37 JTF_NUMBER_TABLE
641: , p5_a38 JTF_DATE_TABLE
642: , p5_a39 JTF_NUMBER_TABLE
643: , p5_a40 JTF_VARCHAR2_TABLE_100
644: , p5_a41 JTF_VARCHAR2_TABLE_500

Line 642: , p5_a39 JTF_NUMBER_TABLE

638: , p5_a35 JTF_NUMBER_TABLE
639: , p5_a36 JTF_DATE_TABLE
640: , p5_a37 JTF_NUMBER_TABLE
641: , p5_a38 JTF_DATE_TABLE
642: , p5_a39 JTF_NUMBER_TABLE
643: , p5_a40 JTF_VARCHAR2_TABLE_100
644: , p5_a41 JTF_VARCHAR2_TABLE_500
645: , p5_a42 JTF_VARCHAR2_TABLE_500
646: , p5_a43 JTF_VARCHAR2_TABLE_500

Line 663: , p5_a60 JTF_NUMBER_TABLE

659: , p5_a56 JTF_VARCHAR2_TABLE_100
660: , p5_a57 JTF_VARCHAR2_TABLE_100
661: , p5_a58 JTF_VARCHAR2_TABLE_100
662: , p5_a59 JTF_VARCHAR2_TABLE_100
663: , p5_a60 JTF_NUMBER_TABLE
664: )
665:
666: as
667: ddp_rgrv_tbl okl_opt_rul_tmp_pub.rgrv_tbl_type;

Line 919: , p5_a1 JTF_NUMBER_TABLE

915: , x_return_status out nocopy VARCHAR2
916: , x_msg_count out nocopy NUMBER
917: , x_msg_data out nocopy VARCHAR2
918: , p5_a0 JTF_VARCHAR2_TABLE_100
919: , p5_a1 JTF_NUMBER_TABLE
920: , p5_a2 JTF_NUMBER_TABLE
921: , p5_a3 JTF_VARCHAR2_TABLE_100
922: , p5_a4 JTF_VARCHAR2_TABLE_100
923: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 920: , p5_a2 JTF_NUMBER_TABLE

916: , x_msg_count out nocopy NUMBER
917: , x_msg_data out nocopy VARCHAR2
918: , p5_a0 JTF_VARCHAR2_TABLE_100
919: , p5_a1 JTF_NUMBER_TABLE
920: , p5_a2 JTF_NUMBER_TABLE
921: , p5_a3 JTF_VARCHAR2_TABLE_100
922: , p5_a4 JTF_VARCHAR2_TABLE_100
923: , p5_a5 JTF_VARCHAR2_TABLE_100
924: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 931: , p5_a13 JTF_NUMBER_TABLE

927: , p5_a9 JTF_VARCHAR2_TABLE_200
928: , p5_a10 JTF_VARCHAR2_TABLE_100
929: , p5_a11 JTF_VARCHAR2_TABLE_100
930: , p5_a12 JTF_VARCHAR2_TABLE_100
931: , p5_a13 JTF_NUMBER_TABLE
932: , p5_a14 JTF_NUMBER_TABLE
933: , p5_a15 JTF_NUMBER_TABLE
934: , p5_a16 JTF_VARCHAR2_TABLE_100
935: , p5_a17 JTF_VARCHAR2_TABLE_2000

Line 932: , p5_a14 JTF_NUMBER_TABLE

928: , p5_a10 JTF_VARCHAR2_TABLE_100
929: , p5_a11 JTF_VARCHAR2_TABLE_100
930: , p5_a12 JTF_VARCHAR2_TABLE_100
931: , p5_a13 JTF_NUMBER_TABLE
932: , p5_a14 JTF_NUMBER_TABLE
933: , p5_a15 JTF_NUMBER_TABLE
934: , p5_a16 JTF_VARCHAR2_TABLE_100
935: , p5_a17 JTF_VARCHAR2_TABLE_2000
936: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 933: , p5_a15 JTF_NUMBER_TABLE

929: , p5_a11 JTF_VARCHAR2_TABLE_100
930: , p5_a12 JTF_VARCHAR2_TABLE_100
931: , p5_a13 JTF_NUMBER_TABLE
932: , p5_a14 JTF_NUMBER_TABLE
933: , p5_a15 JTF_NUMBER_TABLE
934: , p5_a16 JTF_VARCHAR2_TABLE_100
935: , p5_a17 JTF_VARCHAR2_TABLE_2000
936: , p5_a18 JTF_VARCHAR2_TABLE_100
937: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 953: , p5_a35 JTF_NUMBER_TABLE

949: , p5_a31 JTF_VARCHAR2_TABLE_500
950: , p5_a32 JTF_VARCHAR2_TABLE_500
951: , p5_a33 JTF_VARCHAR2_TABLE_500
952: , p5_a34 JTF_VARCHAR2_TABLE_500
953: , p5_a35 JTF_NUMBER_TABLE
954: , p5_a36 JTF_DATE_TABLE
955: , p5_a37 JTF_NUMBER_TABLE
956: , p5_a38 JTF_DATE_TABLE
957: , p5_a39 JTF_NUMBER_TABLE

Line 955: , p5_a37 JTF_NUMBER_TABLE

951: , p5_a33 JTF_VARCHAR2_TABLE_500
952: , p5_a34 JTF_VARCHAR2_TABLE_500
953: , p5_a35 JTF_NUMBER_TABLE
954: , p5_a36 JTF_DATE_TABLE
955: , p5_a37 JTF_NUMBER_TABLE
956: , p5_a38 JTF_DATE_TABLE
957: , p5_a39 JTF_NUMBER_TABLE
958: , p5_a40 JTF_VARCHAR2_TABLE_100
959: , p5_a41 JTF_VARCHAR2_TABLE_500

Line 957: , p5_a39 JTF_NUMBER_TABLE

953: , p5_a35 JTF_NUMBER_TABLE
954: , p5_a36 JTF_DATE_TABLE
955: , p5_a37 JTF_NUMBER_TABLE
956: , p5_a38 JTF_DATE_TABLE
957: , p5_a39 JTF_NUMBER_TABLE
958: , p5_a40 JTF_VARCHAR2_TABLE_100
959: , p5_a41 JTF_VARCHAR2_TABLE_500
960: , p5_a42 JTF_VARCHAR2_TABLE_500
961: , p5_a43 JTF_VARCHAR2_TABLE_500

Line 978: , p5_a60 JTF_NUMBER_TABLE

974: , p5_a56 JTF_VARCHAR2_TABLE_100
975: , p5_a57 JTF_VARCHAR2_TABLE_100
976: , p5_a58 JTF_VARCHAR2_TABLE_100
977: , p5_a59 JTF_VARCHAR2_TABLE_100
978: , p5_a60 JTF_NUMBER_TABLE
979: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
980: , p6_a1 out nocopy JTF_NUMBER_TABLE
981: , p6_a2 out nocopy JTF_NUMBER_TABLE
982: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 980: , p6_a1 out nocopy JTF_NUMBER_TABLE

976: , p5_a58 JTF_VARCHAR2_TABLE_100
977: , p5_a59 JTF_VARCHAR2_TABLE_100
978: , p5_a60 JTF_NUMBER_TABLE
979: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
980: , p6_a1 out nocopy JTF_NUMBER_TABLE
981: , p6_a2 out nocopy JTF_NUMBER_TABLE
982: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
983: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
984: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 981: , p6_a2 out nocopy JTF_NUMBER_TABLE

977: , p5_a59 JTF_VARCHAR2_TABLE_100
978: , p5_a60 JTF_NUMBER_TABLE
979: , p6_a0 out nocopy JTF_VARCHAR2_TABLE_100
980: , p6_a1 out nocopy JTF_NUMBER_TABLE
981: , p6_a2 out nocopy JTF_NUMBER_TABLE
982: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
983: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
984: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
985: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_100

Line 992: , p6_a13 out nocopy JTF_NUMBER_TABLE

988: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_200
989: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
990: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
991: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
992: , p6_a13 out nocopy JTF_NUMBER_TABLE
993: , p6_a14 out nocopy JTF_NUMBER_TABLE
994: , p6_a15 out nocopy JTF_NUMBER_TABLE
995: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
996: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000

Line 993: , p6_a14 out nocopy JTF_NUMBER_TABLE

989: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
990: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
991: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
992: , p6_a13 out nocopy JTF_NUMBER_TABLE
993: , p6_a14 out nocopy JTF_NUMBER_TABLE
994: , p6_a15 out nocopy JTF_NUMBER_TABLE
995: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
996: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
997: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100

Line 994: , p6_a15 out nocopy JTF_NUMBER_TABLE

990: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
991: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
992: , p6_a13 out nocopy JTF_NUMBER_TABLE
993: , p6_a14 out nocopy JTF_NUMBER_TABLE
994: , p6_a15 out nocopy JTF_NUMBER_TABLE
995: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
996: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_2000
997: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
998: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_100

Line 1014: , p6_a35 out nocopy JTF_NUMBER_TABLE

1010: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_500
1011: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_500
1012: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1013: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
1014: , p6_a35 out nocopy JTF_NUMBER_TABLE
1015: , p6_a36 out nocopy JTF_DATE_TABLE
1016: , p6_a37 out nocopy JTF_NUMBER_TABLE
1017: , p6_a38 out nocopy JTF_DATE_TABLE
1018: , p6_a39 out nocopy JTF_NUMBER_TABLE

Line 1016: , p6_a37 out nocopy JTF_NUMBER_TABLE

1012: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_500
1013: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_500
1014: , p6_a35 out nocopy JTF_NUMBER_TABLE
1015: , p6_a36 out nocopy JTF_DATE_TABLE
1016: , p6_a37 out nocopy JTF_NUMBER_TABLE
1017: , p6_a38 out nocopy JTF_DATE_TABLE
1018: , p6_a39 out nocopy JTF_NUMBER_TABLE
1019: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1020: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500

Line 1018: , p6_a39 out nocopy JTF_NUMBER_TABLE

1014: , p6_a35 out nocopy JTF_NUMBER_TABLE
1015: , p6_a36 out nocopy JTF_DATE_TABLE
1016: , p6_a37 out nocopy JTF_NUMBER_TABLE
1017: , p6_a38 out nocopy JTF_DATE_TABLE
1018: , p6_a39 out nocopy JTF_NUMBER_TABLE
1019: , p6_a40 out nocopy JTF_VARCHAR2_TABLE_100
1020: , p6_a41 out nocopy JTF_VARCHAR2_TABLE_500
1021: , p6_a42 out nocopy JTF_VARCHAR2_TABLE_500
1022: , p6_a43 out nocopy JTF_VARCHAR2_TABLE_500

Line 1039: , p6_a60 out nocopy JTF_NUMBER_TABLE

1035: , p6_a56 out nocopy JTF_VARCHAR2_TABLE_100
1036: , p6_a57 out nocopy JTF_VARCHAR2_TABLE_100
1037: , p6_a58 out nocopy JTF_VARCHAR2_TABLE_100
1038: , p6_a59 out nocopy JTF_VARCHAR2_TABLE_100
1039: , p6_a60 out nocopy JTF_NUMBER_TABLE
1040: )
1041:
1042: as
1043: ddp_rgrv_tbl okl_opt_rul_tmp_pub.rgrv_tbl_type;

Line 1487: , p5_a1 JTF_NUMBER_TABLE

1483: , x_return_status out nocopy VARCHAR2
1484: , x_msg_count out nocopy NUMBER
1485: , x_msg_data out nocopy VARCHAR2
1486: , p5_a0 JTF_VARCHAR2_TABLE_100
1487: , p5_a1 JTF_NUMBER_TABLE
1488: , p5_a2 JTF_NUMBER_TABLE
1489: , p5_a3 JTF_VARCHAR2_TABLE_100
1490: , p5_a4 JTF_VARCHAR2_TABLE_100
1491: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1488: , p5_a2 JTF_NUMBER_TABLE

1484: , x_msg_count out nocopy NUMBER
1485: , x_msg_data out nocopy VARCHAR2
1486: , p5_a0 JTF_VARCHAR2_TABLE_100
1487: , p5_a1 JTF_NUMBER_TABLE
1488: , p5_a2 JTF_NUMBER_TABLE
1489: , p5_a3 JTF_VARCHAR2_TABLE_100
1490: , p5_a4 JTF_VARCHAR2_TABLE_100
1491: , p5_a5 JTF_VARCHAR2_TABLE_100
1492: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1499: , p5_a13 JTF_NUMBER_TABLE

1495: , p5_a9 JTF_VARCHAR2_TABLE_200
1496: , p5_a10 JTF_VARCHAR2_TABLE_100
1497: , p5_a11 JTF_VARCHAR2_TABLE_100
1498: , p5_a12 JTF_VARCHAR2_TABLE_100
1499: , p5_a13 JTF_NUMBER_TABLE
1500: , p5_a14 JTF_NUMBER_TABLE
1501: , p5_a15 JTF_NUMBER_TABLE
1502: , p5_a16 JTF_VARCHAR2_TABLE_100
1503: , p5_a17 JTF_VARCHAR2_TABLE_2000

Line 1500: , p5_a14 JTF_NUMBER_TABLE

1496: , p5_a10 JTF_VARCHAR2_TABLE_100
1497: , p5_a11 JTF_VARCHAR2_TABLE_100
1498: , p5_a12 JTF_VARCHAR2_TABLE_100
1499: , p5_a13 JTF_NUMBER_TABLE
1500: , p5_a14 JTF_NUMBER_TABLE
1501: , p5_a15 JTF_NUMBER_TABLE
1502: , p5_a16 JTF_VARCHAR2_TABLE_100
1503: , p5_a17 JTF_VARCHAR2_TABLE_2000
1504: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 1501: , p5_a15 JTF_NUMBER_TABLE

1497: , p5_a11 JTF_VARCHAR2_TABLE_100
1498: , p5_a12 JTF_VARCHAR2_TABLE_100
1499: , p5_a13 JTF_NUMBER_TABLE
1500: , p5_a14 JTF_NUMBER_TABLE
1501: , p5_a15 JTF_NUMBER_TABLE
1502: , p5_a16 JTF_VARCHAR2_TABLE_100
1503: , p5_a17 JTF_VARCHAR2_TABLE_2000
1504: , p5_a18 JTF_VARCHAR2_TABLE_100
1505: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 1521: , p5_a35 JTF_NUMBER_TABLE

1517: , p5_a31 JTF_VARCHAR2_TABLE_500
1518: , p5_a32 JTF_VARCHAR2_TABLE_500
1519: , p5_a33 JTF_VARCHAR2_TABLE_500
1520: , p5_a34 JTF_VARCHAR2_TABLE_500
1521: , p5_a35 JTF_NUMBER_TABLE
1522: , p5_a36 JTF_DATE_TABLE
1523: , p5_a37 JTF_NUMBER_TABLE
1524: , p5_a38 JTF_DATE_TABLE
1525: , p5_a39 JTF_NUMBER_TABLE

Line 1523: , p5_a37 JTF_NUMBER_TABLE

1519: , p5_a33 JTF_VARCHAR2_TABLE_500
1520: , p5_a34 JTF_VARCHAR2_TABLE_500
1521: , p5_a35 JTF_NUMBER_TABLE
1522: , p5_a36 JTF_DATE_TABLE
1523: , p5_a37 JTF_NUMBER_TABLE
1524: , p5_a38 JTF_DATE_TABLE
1525: , p5_a39 JTF_NUMBER_TABLE
1526: , p5_a40 JTF_VARCHAR2_TABLE_100
1527: , p5_a41 JTF_VARCHAR2_TABLE_500

Line 1525: , p5_a39 JTF_NUMBER_TABLE

1521: , p5_a35 JTF_NUMBER_TABLE
1522: , p5_a36 JTF_DATE_TABLE
1523: , p5_a37 JTF_NUMBER_TABLE
1524: , p5_a38 JTF_DATE_TABLE
1525: , p5_a39 JTF_NUMBER_TABLE
1526: , p5_a40 JTF_VARCHAR2_TABLE_100
1527: , p5_a41 JTF_VARCHAR2_TABLE_500
1528: , p5_a42 JTF_VARCHAR2_TABLE_500
1529: , p5_a43 JTF_VARCHAR2_TABLE_500

Line 1546: , p5_a60 JTF_NUMBER_TABLE

1542: , p5_a56 JTF_VARCHAR2_TABLE_100
1543: , p5_a57 JTF_VARCHAR2_TABLE_100
1544: , p5_a58 JTF_VARCHAR2_TABLE_100
1545: , p5_a59 JTF_VARCHAR2_TABLE_100
1546: , p5_a60 JTF_NUMBER_TABLE
1547: )
1548:
1549: as
1550: ddp_rgrv_tbl okl_opt_rul_tmp_pub.rgrv_tbl_type;

Line 1802: , p5_a1 JTF_NUMBER_TABLE

1798: , x_return_status out nocopy VARCHAR2
1799: , x_msg_count out nocopy NUMBER
1800: , x_msg_data out nocopy VARCHAR2
1801: , p5_a0 JTF_VARCHAR2_TABLE_100
1802: , p5_a1 JTF_NUMBER_TABLE
1803: , p5_a2 JTF_NUMBER_TABLE
1804: , p5_a3 JTF_VARCHAR2_TABLE_100
1805: , p5_a4 JTF_VARCHAR2_TABLE_100
1806: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 1803: , p5_a2 JTF_NUMBER_TABLE

1799: , x_msg_count out nocopy NUMBER
1800: , x_msg_data out nocopy VARCHAR2
1801: , p5_a0 JTF_VARCHAR2_TABLE_100
1802: , p5_a1 JTF_NUMBER_TABLE
1803: , p5_a2 JTF_NUMBER_TABLE
1804: , p5_a3 JTF_VARCHAR2_TABLE_100
1805: , p5_a4 JTF_VARCHAR2_TABLE_100
1806: , p5_a5 JTF_VARCHAR2_TABLE_100
1807: , p5_a6 JTF_VARCHAR2_TABLE_100

Line 1814: , p5_a13 JTF_NUMBER_TABLE

1810: , p5_a9 JTF_VARCHAR2_TABLE_200
1811: , p5_a10 JTF_VARCHAR2_TABLE_100
1812: , p5_a11 JTF_VARCHAR2_TABLE_100
1813: , p5_a12 JTF_VARCHAR2_TABLE_100
1814: , p5_a13 JTF_NUMBER_TABLE
1815: , p5_a14 JTF_NUMBER_TABLE
1816: , p5_a15 JTF_NUMBER_TABLE
1817: , p5_a16 JTF_VARCHAR2_TABLE_100
1818: , p5_a17 JTF_VARCHAR2_TABLE_2000

Line 1815: , p5_a14 JTF_NUMBER_TABLE

1811: , p5_a10 JTF_VARCHAR2_TABLE_100
1812: , p5_a11 JTF_VARCHAR2_TABLE_100
1813: , p5_a12 JTF_VARCHAR2_TABLE_100
1814: , p5_a13 JTF_NUMBER_TABLE
1815: , p5_a14 JTF_NUMBER_TABLE
1816: , p5_a15 JTF_NUMBER_TABLE
1817: , p5_a16 JTF_VARCHAR2_TABLE_100
1818: , p5_a17 JTF_VARCHAR2_TABLE_2000
1819: , p5_a18 JTF_VARCHAR2_TABLE_100

Line 1816: , p5_a15 JTF_NUMBER_TABLE

1812: , p5_a11 JTF_VARCHAR2_TABLE_100
1813: , p5_a12 JTF_VARCHAR2_TABLE_100
1814: , p5_a13 JTF_NUMBER_TABLE
1815: , p5_a14 JTF_NUMBER_TABLE
1816: , p5_a15 JTF_NUMBER_TABLE
1817: , p5_a16 JTF_VARCHAR2_TABLE_100
1818: , p5_a17 JTF_VARCHAR2_TABLE_2000
1819: , p5_a18 JTF_VARCHAR2_TABLE_100
1820: , p5_a19 JTF_VARCHAR2_TABLE_100

Line 1836: , p5_a35 JTF_NUMBER_TABLE

1832: , p5_a31 JTF_VARCHAR2_TABLE_500
1833: , p5_a32 JTF_VARCHAR2_TABLE_500
1834: , p5_a33 JTF_VARCHAR2_TABLE_500
1835: , p5_a34 JTF_VARCHAR2_TABLE_500
1836: , p5_a35 JTF_NUMBER_TABLE
1837: , p5_a36 JTF_DATE_TABLE
1838: , p5_a37 JTF_NUMBER_TABLE
1839: , p5_a38 JTF_DATE_TABLE
1840: , p5_a39 JTF_NUMBER_TABLE

Line 1838: , p5_a37 JTF_NUMBER_TABLE

1834: , p5_a33 JTF_VARCHAR2_TABLE_500
1835: , p5_a34 JTF_VARCHAR2_TABLE_500
1836: , p5_a35 JTF_NUMBER_TABLE
1837: , p5_a36 JTF_DATE_TABLE
1838: , p5_a37 JTF_NUMBER_TABLE
1839: , p5_a38 JTF_DATE_TABLE
1840: , p5_a39 JTF_NUMBER_TABLE
1841: , p5_a40 JTF_VARCHAR2_TABLE_100
1842: , p5_a41 JTF_VARCHAR2_TABLE_500

Line 1840: , p5_a39 JTF_NUMBER_TABLE

1836: , p5_a35 JTF_NUMBER_TABLE
1837: , p5_a36 JTF_DATE_TABLE
1838: , p5_a37 JTF_NUMBER_TABLE
1839: , p5_a38 JTF_DATE_TABLE
1840: , p5_a39 JTF_NUMBER_TABLE
1841: , p5_a40 JTF_VARCHAR2_TABLE_100
1842: , p5_a41 JTF_VARCHAR2_TABLE_500
1843: , p5_a42 JTF_VARCHAR2_TABLE_500
1844: , p5_a43 JTF_VARCHAR2_TABLE_500

Line 1861: , p5_a60 JTF_NUMBER_TABLE

1857: , p5_a56 JTF_VARCHAR2_TABLE_100
1858: , p5_a57 JTF_VARCHAR2_TABLE_100
1859: , p5_a58 JTF_VARCHAR2_TABLE_100
1860: , p5_a59 JTF_VARCHAR2_TABLE_100
1861: , p5_a60 JTF_NUMBER_TABLE
1862: )
1863:
1864: as
1865: ddp_rgrv_tbl okl_opt_rul_tmp_pub.rgrv_tbl_type;