DBA Data[Home] [Help]

APPS.OKL_QUOTE_PARTIES_PUB_W dependencies on JTF_NUMBER_TABLE

Line 8: , p5_a0 JTF_NUMBER_TABLE

4: , p_init_msg_list VARCHAR2
5: , x_return_status out nocopy VARCHAR2
6: , x_msg_count out nocopy NUMBER
7: , x_msg_data out nocopy VARCHAR2
8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_NUMBER_TABLE
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_DATE_TABLE

Line 9: , p5_a1 JTF_NUMBER_TABLE

5: , x_return_status out nocopy VARCHAR2
6: , x_msg_count out nocopy NUMBER
7: , x_msg_data out nocopy VARCHAR2
8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_NUMBER_TABLE
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_DATE_TABLE
13: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 10: , p5_a2 JTF_NUMBER_TABLE

6: , x_msg_count out nocopy NUMBER
7: , x_msg_data out nocopy VARCHAR2
8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_NUMBER_TABLE
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_DATE_TABLE
13: , p5_a5 JTF_VARCHAR2_TABLE_100
14: , p5_a6 JTF_NUMBER_TABLE

Line 11: , p5_a3 JTF_NUMBER_TABLE

7: , x_msg_data out nocopy VARCHAR2
8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_NUMBER_TABLE
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_DATE_TABLE
13: , p5_a5 JTF_VARCHAR2_TABLE_100
14: , p5_a6 JTF_NUMBER_TABLE
15: , p5_a7 JTF_NUMBER_TABLE

Line 14: , p5_a6 JTF_NUMBER_TABLE

10: , p5_a2 JTF_NUMBER_TABLE
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_DATE_TABLE
13: , p5_a5 JTF_VARCHAR2_TABLE_100
14: , p5_a6 JTF_NUMBER_TABLE
15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_VARCHAR2_TABLE_600
17: , p5_a9 JTF_VARCHAR2_TABLE_100
18: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 15: , p5_a7 JTF_NUMBER_TABLE

11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_DATE_TABLE
13: , p5_a5 JTF_VARCHAR2_TABLE_100
14: , p5_a6 JTF_NUMBER_TABLE
15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_VARCHAR2_TABLE_600
17: , p5_a9 JTF_VARCHAR2_TABLE_100
18: , p5_a10 JTF_VARCHAR2_TABLE_100
19: , p5_a11 JTF_VARCHAR2_TABLE_200

Line 23: , p5_a15 JTF_NUMBER_TABLE

19: , p5_a11 JTF_VARCHAR2_TABLE_200
20: , p5_a12 JTF_VARCHAR2_TABLE_100
21: , p5_a13 JTF_VARCHAR2_TABLE_100
22: , p5_a14 JTF_VARCHAR2_TABLE_200
23: , p5_a15 JTF_NUMBER_TABLE
24: , p5_a16 JTF_DATE_TABLE
25: , p5_a17 JTF_NUMBER_TABLE
26: , p5_a18 JTF_DATE_TABLE
27: , p5_a19 JTF_NUMBER_TABLE

Line 25: , p5_a17 JTF_NUMBER_TABLE

21: , p5_a13 JTF_VARCHAR2_TABLE_100
22: , p5_a14 JTF_VARCHAR2_TABLE_200
23: , p5_a15 JTF_NUMBER_TABLE
24: , p5_a16 JTF_DATE_TABLE
25: , p5_a17 JTF_NUMBER_TABLE
26: , p5_a18 JTF_DATE_TABLE
27: , p5_a19 JTF_NUMBER_TABLE
28: , p6_a0 out nocopy JTF_NUMBER_TABLE
29: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 27: , p5_a19 JTF_NUMBER_TABLE

23: , p5_a15 JTF_NUMBER_TABLE
24: , p5_a16 JTF_DATE_TABLE
25: , p5_a17 JTF_NUMBER_TABLE
26: , p5_a18 JTF_DATE_TABLE
27: , p5_a19 JTF_NUMBER_TABLE
28: , p6_a0 out nocopy JTF_NUMBER_TABLE
29: , p6_a1 out nocopy JTF_NUMBER_TABLE
30: , p6_a2 out nocopy JTF_NUMBER_TABLE
31: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 28: , p6_a0 out nocopy JTF_NUMBER_TABLE

24: , p5_a16 JTF_DATE_TABLE
25: , p5_a17 JTF_NUMBER_TABLE
26: , p5_a18 JTF_DATE_TABLE
27: , p5_a19 JTF_NUMBER_TABLE
28: , p6_a0 out nocopy JTF_NUMBER_TABLE
29: , p6_a1 out nocopy JTF_NUMBER_TABLE
30: , p6_a2 out nocopy JTF_NUMBER_TABLE
31: , p6_a3 out nocopy JTF_NUMBER_TABLE
32: , p6_a4 out nocopy JTF_DATE_TABLE

Line 29: , p6_a1 out nocopy JTF_NUMBER_TABLE

25: , p5_a17 JTF_NUMBER_TABLE
26: , p5_a18 JTF_DATE_TABLE
27: , p5_a19 JTF_NUMBER_TABLE
28: , p6_a0 out nocopy JTF_NUMBER_TABLE
29: , p6_a1 out nocopy JTF_NUMBER_TABLE
30: , p6_a2 out nocopy JTF_NUMBER_TABLE
31: , p6_a3 out nocopy JTF_NUMBER_TABLE
32: , p6_a4 out nocopy JTF_DATE_TABLE
33: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 30: , p6_a2 out nocopy JTF_NUMBER_TABLE

26: , p5_a18 JTF_DATE_TABLE
27: , p5_a19 JTF_NUMBER_TABLE
28: , p6_a0 out nocopy JTF_NUMBER_TABLE
29: , p6_a1 out nocopy JTF_NUMBER_TABLE
30: , p6_a2 out nocopy JTF_NUMBER_TABLE
31: , p6_a3 out nocopy JTF_NUMBER_TABLE
32: , p6_a4 out nocopy JTF_DATE_TABLE
33: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
34: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 31: , p6_a3 out nocopy JTF_NUMBER_TABLE

27: , p5_a19 JTF_NUMBER_TABLE
28: , p6_a0 out nocopy JTF_NUMBER_TABLE
29: , p6_a1 out nocopy JTF_NUMBER_TABLE
30: , p6_a2 out nocopy JTF_NUMBER_TABLE
31: , p6_a3 out nocopy JTF_NUMBER_TABLE
32: , p6_a4 out nocopy JTF_DATE_TABLE
33: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
34: , p6_a6 out nocopy JTF_NUMBER_TABLE
35: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 34: , p6_a6 out nocopy JTF_NUMBER_TABLE

30: , p6_a2 out nocopy JTF_NUMBER_TABLE
31: , p6_a3 out nocopy JTF_NUMBER_TABLE
32: , p6_a4 out nocopy JTF_DATE_TABLE
33: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
34: , p6_a6 out nocopy JTF_NUMBER_TABLE
35: , p6_a7 out nocopy JTF_NUMBER_TABLE
36: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_600
37: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
38: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 35: , p6_a7 out nocopy JTF_NUMBER_TABLE

31: , p6_a3 out nocopy JTF_NUMBER_TABLE
32: , p6_a4 out nocopy JTF_DATE_TABLE
33: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
34: , p6_a6 out nocopy JTF_NUMBER_TABLE
35: , p6_a7 out nocopy JTF_NUMBER_TABLE
36: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_600
37: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
38: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
39: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 43: , p6_a15 out nocopy JTF_NUMBER_TABLE

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

Line 45: , p6_a17 out nocopy JTF_NUMBER_TABLE

41: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
42: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
43: , p6_a15 out nocopy JTF_NUMBER_TABLE
44: , p6_a16 out nocopy JTF_DATE_TABLE
45: , p6_a17 out nocopy JTF_NUMBER_TABLE
46: , p6_a18 out nocopy JTF_DATE_TABLE
47: , p6_a19 out nocopy JTF_NUMBER_TABLE
48: );
49: procedure insert_quote_parties(p_api_version NUMBER

Line 47: , p6_a19 out nocopy JTF_NUMBER_TABLE

43: , p6_a15 out nocopy JTF_NUMBER_TABLE
44: , p6_a16 out nocopy JTF_DATE_TABLE
45: , p6_a17 out nocopy JTF_NUMBER_TABLE
46: , p6_a18 out nocopy JTF_DATE_TABLE
47: , p6_a19 out nocopy JTF_NUMBER_TABLE
48: );
49: procedure insert_quote_parties(p_api_version NUMBER
50: , p_init_msg_list VARCHAR2
51: , x_return_status out nocopy VARCHAR2

Line 100: , p5_a0 JTF_NUMBER_TABLE

96: , p_init_msg_list VARCHAR2
97: , x_return_status out nocopy VARCHAR2
98: , x_msg_count out nocopy NUMBER
99: , x_msg_data out nocopy VARCHAR2
100: , p5_a0 JTF_NUMBER_TABLE
101: , p5_a1 JTF_NUMBER_TABLE
102: , p5_a2 JTF_NUMBER_TABLE
103: , p5_a3 JTF_NUMBER_TABLE
104: , p5_a4 JTF_DATE_TABLE

Line 101: , p5_a1 JTF_NUMBER_TABLE

97: , x_return_status out nocopy VARCHAR2
98: , x_msg_count out nocopy NUMBER
99: , x_msg_data out nocopy VARCHAR2
100: , p5_a0 JTF_NUMBER_TABLE
101: , p5_a1 JTF_NUMBER_TABLE
102: , p5_a2 JTF_NUMBER_TABLE
103: , p5_a3 JTF_NUMBER_TABLE
104: , p5_a4 JTF_DATE_TABLE
105: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 102: , p5_a2 JTF_NUMBER_TABLE

98: , x_msg_count out nocopy NUMBER
99: , x_msg_data out nocopy VARCHAR2
100: , p5_a0 JTF_NUMBER_TABLE
101: , p5_a1 JTF_NUMBER_TABLE
102: , p5_a2 JTF_NUMBER_TABLE
103: , p5_a3 JTF_NUMBER_TABLE
104: , p5_a4 JTF_DATE_TABLE
105: , p5_a5 JTF_VARCHAR2_TABLE_100
106: , p5_a6 JTF_NUMBER_TABLE

Line 103: , p5_a3 JTF_NUMBER_TABLE

99: , x_msg_data out nocopy VARCHAR2
100: , p5_a0 JTF_NUMBER_TABLE
101: , p5_a1 JTF_NUMBER_TABLE
102: , p5_a2 JTF_NUMBER_TABLE
103: , p5_a3 JTF_NUMBER_TABLE
104: , p5_a4 JTF_DATE_TABLE
105: , p5_a5 JTF_VARCHAR2_TABLE_100
106: , p5_a6 JTF_NUMBER_TABLE
107: , p5_a7 JTF_NUMBER_TABLE

Line 106: , p5_a6 JTF_NUMBER_TABLE

102: , p5_a2 JTF_NUMBER_TABLE
103: , p5_a3 JTF_NUMBER_TABLE
104: , p5_a4 JTF_DATE_TABLE
105: , p5_a5 JTF_VARCHAR2_TABLE_100
106: , p5_a6 JTF_NUMBER_TABLE
107: , p5_a7 JTF_NUMBER_TABLE
108: , p5_a8 JTF_VARCHAR2_TABLE_600
109: , p5_a9 JTF_VARCHAR2_TABLE_100
110: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 107: , p5_a7 JTF_NUMBER_TABLE

103: , p5_a3 JTF_NUMBER_TABLE
104: , p5_a4 JTF_DATE_TABLE
105: , p5_a5 JTF_VARCHAR2_TABLE_100
106: , p5_a6 JTF_NUMBER_TABLE
107: , p5_a7 JTF_NUMBER_TABLE
108: , p5_a8 JTF_VARCHAR2_TABLE_600
109: , p5_a9 JTF_VARCHAR2_TABLE_100
110: , p5_a10 JTF_VARCHAR2_TABLE_100
111: , p5_a11 JTF_VARCHAR2_TABLE_200

Line 115: , p5_a15 JTF_NUMBER_TABLE

111: , p5_a11 JTF_VARCHAR2_TABLE_200
112: , p5_a12 JTF_VARCHAR2_TABLE_100
113: , p5_a13 JTF_VARCHAR2_TABLE_100
114: , p5_a14 JTF_VARCHAR2_TABLE_200
115: , p5_a15 JTF_NUMBER_TABLE
116: , p5_a16 JTF_DATE_TABLE
117: , p5_a17 JTF_NUMBER_TABLE
118: , p5_a18 JTF_DATE_TABLE
119: , p5_a19 JTF_NUMBER_TABLE

Line 117: , p5_a17 JTF_NUMBER_TABLE

113: , p5_a13 JTF_VARCHAR2_TABLE_100
114: , p5_a14 JTF_VARCHAR2_TABLE_200
115: , p5_a15 JTF_NUMBER_TABLE
116: , p5_a16 JTF_DATE_TABLE
117: , p5_a17 JTF_NUMBER_TABLE
118: , p5_a18 JTF_DATE_TABLE
119: , p5_a19 JTF_NUMBER_TABLE
120: );
121: procedure lock_quote_parties(p_api_version NUMBER

Line 119: , p5_a19 JTF_NUMBER_TABLE

115: , p5_a15 JTF_NUMBER_TABLE
116: , p5_a16 JTF_DATE_TABLE
117: , p5_a17 JTF_NUMBER_TABLE
118: , p5_a18 JTF_DATE_TABLE
119: , p5_a19 JTF_NUMBER_TABLE
120: );
121: procedure lock_quote_parties(p_api_version NUMBER
122: , p_init_msg_list VARCHAR2
123: , x_return_status out nocopy VARCHAR2

Line 152: , p5_a0 JTF_NUMBER_TABLE

148: , p_init_msg_list VARCHAR2
149: , x_return_status out nocopy VARCHAR2
150: , x_msg_count out nocopy NUMBER
151: , x_msg_data out nocopy VARCHAR2
152: , p5_a0 JTF_NUMBER_TABLE
153: , p5_a1 JTF_NUMBER_TABLE
154: , p5_a2 JTF_NUMBER_TABLE
155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_DATE_TABLE

Line 153: , p5_a1 JTF_NUMBER_TABLE

149: , x_return_status out nocopy VARCHAR2
150: , x_msg_count out nocopy NUMBER
151: , x_msg_data out nocopy VARCHAR2
152: , p5_a0 JTF_NUMBER_TABLE
153: , p5_a1 JTF_NUMBER_TABLE
154: , p5_a2 JTF_NUMBER_TABLE
155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_DATE_TABLE
157: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 154: , p5_a2 JTF_NUMBER_TABLE

150: , x_msg_count out nocopy NUMBER
151: , x_msg_data out nocopy VARCHAR2
152: , p5_a0 JTF_NUMBER_TABLE
153: , p5_a1 JTF_NUMBER_TABLE
154: , p5_a2 JTF_NUMBER_TABLE
155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_DATE_TABLE
157: , p5_a5 JTF_VARCHAR2_TABLE_100
158: , p5_a6 JTF_NUMBER_TABLE

Line 155: , p5_a3 JTF_NUMBER_TABLE

151: , x_msg_data out nocopy VARCHAR2
152: , p5_a0 JTF_NUMBER_TABLE
153: , p5_a1 JTF_NUMBER_TABLE
154: , p5_a2 JTF_NUMBER_TABLE
155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_DATE_TABLE
157: , p5_a5 JTF_VARCHAR2_TABLE_100
158: , p5_a6 JTF_NUMBER_TABLE
159: , p5_a7 JTF_NUMBER_TABLE

Line 158: , p5_a6 JTF_NUMBER_TABLE

154: , p5_a2 JTF_NUMBER_TABLE
155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_DATE_TABLE
157: , p5_a5 JTF_VARCHAR2_TABLE_100
158: , p5_a6 JTF_NUMBER_TABLE
159: , p5_a7 JTF_NUMBER_TABLE
160: , p5_a8 JTF_VARCHAR2_TABLE_600
161: , p5_a9 JTF_VARCHAR2_TABLE_100
162: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 159: , p5_a7 JTF_NUMBER_TABLE

155: , p5_a3 JTF_NUMBER_TABLE
156: , p5_a4 JTF_DATE_TABLE
157: , p5_a5 JTF_VARCHAR2_TABLE_100
158: , p5_a6 JTF_NUMBER_TABLE
159: , p5_a7 JTF_NUMBER_TABLE
160: , p5_a8 JTF_VARCHAR2_TABLE_600
161: , p5_a9 JTF_VARCHAR2_TABLE_100
162: , p5_a10 JTF_VARCHAR2_TABLE_100
163: , p5_a11 JTF_VARCHAR2_TABLE_200

Line 167: , p5_a15 JTF_NUMBER_TABLE

163: , p5_a11 JTF_VARCHAR2_TABLE_200
164: , p5_a12 JTF_VARCHAR2_TABLE_100
165: , p5_a13 JTF_VARCHAR2_TABLE_100
166: , p5_a14 JTF_VARCHAR2_TABLE_200
167: , p5_a15 JTF_NUMBER_TABLE
168: , p5_a16 JTF_DATE_TABLE
169: , p5_a17 JTF_NUMBER_TABLE
170: , p5_a18 JTF_DATE_TABLE
171: , p5_a19 JTF_NUMBER_TABLE

Line 169: , p5_a17 JTF_NUMBER_TABLE

165: , p5_a13 JTF_VARCHAR2_TABLE_100
166: , p5_a14 JTF_VARCHAR2_TABLE_200
167: , p5_a15 JTF_NUMBER_TABLE
168: , p5_a16 JTF_DATE_TABLE
169: , p5_a17 JTF_NUMBER_TABLE
170: , p5_a18 JTF_DATE_TABLE
171: , p5_a19 JTF_NUMBER_TABLE
172: , p6_a0 out nocopy JTF_NUMBER_TABLE
173: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 171: , p5_a19 JTF_NUMBER_TABLE

167: , p5_a15 JTF_NUMBER_TABLE
168: , p5_a16 JTF_DATE_TABLE
169: , p5_a17 JTF_NUMBER_TABLE
170: , p5_a18 JTF_DATE_TABLE
171: , p5_a19 JTF_NUMBER_TABLE
172: , p6_a0 out nocopy JTF_NUMBER_TABLE
173: , p6_a1 out nocopy JTF_NUMBER_TABLE
174: , p6_a2 out nocopy JTF_NUMBER_TABLE
175: , p6_a3 out nocopy JTF_NUMBER_TABLE

Line 172: , p6_a0 out nocopy JTF_NUMBER_TABLE

168: , p5_a16 JTF_DATE_TABLE
169: , p5_a17 JTF_NUMBER_TABLE
170: , p5_a18 JTF_DATE_TABLE
171: , p5_a19 JTF_NUMBER_TABLE
172: , p6_a0 out nocopy JTF_NUMBER_TABLE
173: , p6_a1 out nocopy JTF_NUMBER_TABLE
174: , p6_a2 out nocopy JTF_NUMBER_TABLE
175: , p6_a3 out nocopy JTF_NUMBER_TABLE
176: , p6_a4 out nocopy JTF_DATE_TABLE

Line 173: , p6_a1 out nocopy JTF_NUMBER_TABLE

169: , p5_a17 JTF_NUMBER_TABLE
170: , p5_a18 JTF_DATE_TABLE
171: , p5_a19 JTF_NUMBER_TABLE
172: , p6_a0 out nocopy JTF_NUMBER_TABLE
173: , p6_a1 out nocopy JTF_NUMBER_TABLE
174: , p6_a2 out nocopy JTF_NUMBER_TABLE
175: , p6_a3 out nocopy JTF_NUMBER_TABLE
176: , p6_a4 out nocopy JTF_DATE_TABLE
177: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100

Line 174: , p6_a2 out nocopy JTF_NUMBER_TABLE

170: , p5_a18 JTF_DATE_TABLE
171: , p5_a19 JTF_NUMBER_TABLE
172: , p6_a0 out nocopy JTF_NUMBER_TABLE
173: , p6_a1 out nocopy JTF_NUMBER_TABLE
174: , p6_a2 out nocopy JTF_NUMBER_TABLE
175: , p6_a3 out nocopy JTF_NUMBER_TABLE
176: , p6_a4 out nocopy JTF_DATE_TABLE
177: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
178: , p6_a6 out nocopy JTF_NUMBER_TABLE

Line 175: , p6_a3 out nocopy JTF_NUMBER_TABLE

171: , p5_a19 JTF_NUMBER_TABLE
172: , p6_a0 out nocopy JTF_NUMBER_TABLE
173: , p6_a1 out nocopy JTF_NUMBER_TABLE
174: , p6_a2 out nocopy JTF_NUMBER_TABLE
175: , p6_a3 out nocopy JTF_NUMBER_TABLE
176: , p6_a4 out nocopy JTF_DATE_TABLE
177: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
178: , p6_a6 out nocopy JTF_NUMBER_TABLE
179: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 178: , p6_a6 out nocopy JTF_NUMBER_TABLE

174: , p6_a2 out nocopy JTF_NUMBER_TABLE
175: , p6_a3 out nocopy JTF_NUMBER_TABLE
176: , p6_a4 out nocopy JTF_DATE_TABLE
177: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
178: , p6_a6 out nocopy JTF_NUMBER_TABLE
179: , p6_a7 out nocopy JTF_NUMBER_TABLE
180: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_600
181: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
182: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100

Line 179: , p6_a7 out nocopy JTF_NUMBER_TABLE

175: , p6_a3 out nocopy JTF_NUMBER_TABLE
176: , p6_a4 out nocopy JTF_DATE_TABLE
177: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
178: , p6_a6 out nocopy JTF_NUMBER_TABLE
179: , p6_a7 out nocopy JTF_NUMBER_TABLE
180: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_600
181: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
182: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
183: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200

Line 187: , p6_a15 out nocopy JTF_NUMBER_TABLE

183: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
184: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
185: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
186: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
187: , p6_a15 out nocopy JTF_NUMBER_TABLE
188: , p6_a16 out nocopy JTF_DATE_TABLE
189: , p6_a17 out nocopy JTF_NUMBER_TABLE
190: , p6_a18 out nocopy JTF_DATE_TABLE
191: , p6_a19 out nocopy JTF_NUMBER_TABLE

Line 189: , p6_a17 out nocopy JTF_NUMBER_TABLE

185: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
186: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
187: , p6_a15 out nocopy JTF_NUMBER_TABLE
188: , p6_a16 out nocopy JTF_DATE_TABLE
189: , p6_a17 out nocopy JTF_NUMBER_TABLE
190: , p6_a18 out nocopy JTF_DATE_TABLE
191: , p6_a19 out nocopy JTF_NUMBER_TABLE
192: );
193: procedure update_quote_parties(p_api_version NUMBER

Line 191: , p6_a19 out nocopy JTF_NUMBER_TABLE

187: , p6_a15 out nocopy JTF_NUMBER_TABLE
188: , p6_a16 out nocopy JTF_DATE_TABLE
189: , p6_a17 out nocopy JTF_NUMBER_TABLE
190: , p6_a18 out nocopy JTF_DATE_TABLE
191: , p6_a19 out nocopy JTF_NUMBER_TABLE
192: );
193: procedure update_quote_parties(p_api_version NUMBER
194: , p_init_msg_list VARCHAR2
195: , x_return_status out nocopy VARCHAR2

Line 244: , p5_a0 JTF_NUMBER_TABLE

240: , p_init_msg_list VARCHAR2
241: , x_return_status out nocopy VARCHAR2
242: , x_msg_count out nocopy NUMBER
243: , x_msg_data out nocopy VARCHAR2
244: , p5_a0 JTF_NUMBER_TABLE
245: , p5_a1 JTF_NUMBER_TABLE
246: , p5_a2 JTF_NUMBER_TABLE
247: , p5_a3 JTF_NUMBER_TABLE
248: , p5_a4 JTF_DATE_TABLE

Line 245: , p5_a1 JTF_NUMBER_TABLE

241: , x_return_status out nocopy VARCHAR2
242: , x_msg_count out nocopy NUMBER
243: , x_msg_data out nocopy VARCHAR2
244: , p5_a0 JTF_NUMBER_TABLE
245: , p5_a1 JTF_NUMBER_TABLE
246: , p5_a2 JTF_NUMBER_TABLE
247: , p5_a3 JTF_NUMBER_TABLE
248: , p5_a4 JTF_DATE_TABLE
249: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 246: , p5_a2 JTF_NUMBER_TABLE

242: , x_msg_count out nocopy NUMBER
243: , x_msg_data out nocopy VARCHAR2
244: , p5_a0 JTF_NUMBER_TABLE
245: , p5_a1 JTF_NUMBER_TABLE
246: , p5_a2 JTF_NUMBER_TABLE
247: , p5_a3 JTF_NUMBER_TABLE
248: , p5_a4 JTF_DATE_TABLE
249: , p5_a5 JTF_VARCHAR2_TABLE_100
250: , p5_a6 JTF_NUMBER_TABLE

Line 247: , p5_a3 JTF_NUMBER_TABLE

243: , x_msg_data out nocopy VARCHAR2
244: , p5_a0 JTF_NUMBER_TABLE
245: , p5_a1 JTF_NUMBER_TABLE
246: , p5_a2 JTF_NUMBER_TABLE
247: , p5_a3 JTF_NUMBER_TABLE
248: , p5_a4 JTF_DATE_TABLE
249: , p5_a5 JTF_VARCHAR2_TABLE_100
250: , p5_a6 JTF_NUMBER_TABLE
251: , p5_a7 JTF_NUMBER_TABLE

Line 250: , p5_a6 JTF_NUMBER_TABLE

246: , p5_a2 JTF_NUMBER_TABLE
247: , p5_a3 JTF_NUMBER_TABLE
248: , p5_a4 JTF_DATE_TABLE
249: , p5_a5 JTF_VARCHAR2_TABLE_100
250: , p5_a6 JTF_NUMBER_TABLE
251: , p5_a7 JTF_NUMBER_TABLE
252: , p5_a8 JTF_VARCHAR2_TABLE_600
253: , p5_a9 JTF_VARCHAR2_TABLE_100
254: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 251: , p5_a7 JTF_NUMBER_TABLE

247: , p5_a3 JTF_NUMBER_TABLE
248: , p5_a4 JTF_DATE_TABLE
249: , p5_a5 JTF_VARCHAR2_TABLE_100
250: , p5_a6 JTF_NUMBER_TABLE
251: , p5_a7 JTF_NUMBER_TABLE
252: , p5_a8 JTF_VARCHAR2_TABLE_600
253: , p5_a9 JTF_VARCHAR2_TABLE_100
254: , p5_a10 JTF_VARCHAR2_TABLE_100
255: , p5_a11 JTF_VARCHAR2_TABLE_200

Line 259: , p5_a15 JTF_NUMBER_TABLE

255: , p5_a11 JTF_VARCHAR2_TABLE_200
256: , p5_a12 JTF_VARCHAR2_TABLE_100
257: , p5_a13 JTF_VARCHAR2_TABLE_100
258: , p5_a14 JTF_VARCHAR2_TABLE_200
259: , p5_a15 JTF_NUMBER_TABLE
260: , p5_a16 JTF_DATE_TABLE
261: , p5_a17 JTF_NUMBER_TABLE
262: , p5_a18 JTF_DATE_TABLE
263: , p5_a19 JTF_NUMBER_TABLE

Line 261: , p5_a17 JTF_NUMBER_TABLE

257: , p5_a13 JTF_VARCHAR2_TABLE_100
258: , p5_a14 JTF_VARCHAR2_TABLE_200
259: , p5_a15 JTF_NUMBER_TABLE
260: , p5_a16 JTF_DATE_TABLE
261: , p5_a17 JTF_NUMBER_TABLE
262: , p5_a18 JTF_DATE_TABLE
263: , p5_a19 JTF_NUMBER_TABLE
264: );
265: procedure delete_quote_parties(p_api_version NUMBER

Line 263: , p5_a19 JTF_NUMBER_TABLE

259: , p5_a15 JTF_NUMBER_TABLE
260: , p5_a16 JTF_DATE_TABLE
261: , p5_a17 JTF_NUMBER_TABLE
262: , p5_a18 JTF_DATE_TABLE
263: , p5_a19 JTF_NUMBER_TABLE
264: );
265: procedure delete_quote_parties(p_api_version NUMBER
266: , p_init_msg_list VARCHAR2
267: , x_return_status out nocopy VARCHAR2

Line 296: , p5_a0 JTF_NUMBER_TABLE

292: , p_init_msg_list VARCHAR2
293: , x_return_status out nocopy VARCHAR2
294: , x_msg_count out nocopy NUMBER
295: , x_msg_data out nocopy VARCHAR2
296: , p5_a0 JTF_NUMBER_TABLE
297: , p5_a1 JTF_NUMBER_TABLE
298: , p5_a2 JTF_NUMBER_TABLE
299: , p5_a3 JTF_NUMBER_TABLE
300: , p5_a4 JTF_DATE_TABLE

Line 297: , p5_a1 JTF_NUMBER_TABLE

293: , x_return_status out nocopy VARCHAR2
294: , x_msg_count out nocopy NUMBER
295: , x_msg_data out nocopy VARCHAR2
296: , p5_a0 JTF_NUMBER_TABLE
297: , p5_a1 JTF_NUMBER_TABLE
298: , p5_a2 JTF_NUMBER_TABLE
299: , p5_a3 JTF_NUMBER_TABLE
300: , p5_a4 JTF_DATE_TABLE
301: , p5_a5 JTF_VARCHAR2_TABLE_100

Line 298: , p5_a2 JTF_NUMBER_TABLE

294: , x_msg_count out nocopy NUMBER
295: , x_msg_data out nocopy VARCHAR2
296: , p5_a0 JTF_NUMBER_TABLE
297: , p5_a1 JTF_NUMBER_TABLE
298: , p5_a2 JTF_NUMBER_TABLE
299: , p5_a3 JTF_NUMBER_TABLE
300: , p5_a4 JTF_DATE_TABLE
301: , p5_a5 JTF_VARCHAR2_TABLE_100
302: , p5_a6 JTF_NUMBER_TABLE

Line 299: , p5_a3 JTF_NUMBER_TABLE

295: , x_msg_data out nocopy VARCHAR2
296: , p5_a0 JTF_NUMBER_TABLE
297: , p5_a1 JTF_NUMBER_TABLE
298: , p5_a2 JTF_NUMBER_TABLE
299: , p5_a3 JTF_NUMBER_TABLE
300: , p5_a4 JTF_DATE_TABLE
301: , p5_a5 JTF_VARCHAR2_TABLE_100
302: , p5_a6 JTF_NUMBER_TABLE
303: , p5_a7 JTF_NUMBER_TABLE

Line 302: , p5_a6 JTF_NUMBER_TABLE

298: , p5_a2 JTF_NUMBER_TABLE
299: , p5_a3 JTF_NUMBER_TABLE
300: , p5_a4 JTF_DATE_TABLE
301: , p5_a5 JTF_VARCHAR2_TABLE_100
302: , p5_a6 JTF_NUMBER_TABLE
303: , p5_a7 JTF_NUMBER_TABLE
304: , p5_a8 JTF_VARCHAR2_TABLE_600
305: , p5_a9 JTF_VARCHAR2_TABLE_100
306: , p5_a10 JTF_VARCHAR2_TABLE_100

Line 303: , p5_a7 JTF_NUMBER_TABLE

299: , p5_a3 JTF_NUMBER_TABLE
300: , p5_a4 JTF_DATE_TABLE
301: , p5_a5 JTF_VARCHAR2_TABLE_100
302: , p5_a6 JTF_NUMBER_TABLE
303: , p5_a7 JTF_NUMBER_TABLE
304: , p5_a8 JTF_VARCHAR2_TABLE_600
305: , p5_a9 JTF_VARCHAR2_TABLE_100
306: , p5_a10 JTF_VARCHAR2_TABLE_100
307: , p5_a11 JTF_VARCHAR2_TABLE_200

Line 311: , p5_a15 JTF_NUMBER_TABLE

307: , p5_a11 JTF_VARCHAR2_TABLE_200
308: , p5_a12 JTF_VARCHAR2_TABLE_100
309: , p5_a13 JTF_VARCHAR2_TABLE_100
310: , p5_a14 JTF_VARCHAR2_TABLE_200
311: , p5_a15 JTF_NUMBER_TABLE
312: , p5_a16 JTF_DATE_TABLE
313: , p5_a17 JTF_NUMBER_TABLE
314: , p5_a18 JTF_DATE_TABLE
315: , p5_a19 JTF_NUMBER_TABLE

Line 313: , p5_a17 JTF_NUMBER_TABLE

309: , p5_a13 JTF_VARCHAR2_TABLE_100
310: , p5_a14 JTF_VARCHAR2_TABLE_200
311: , p5_a15 JTF_NUMBER_TABLE
312: , p5_a16 JTF_DATE_TABLE
313: , p5_a17 JTF_NUMBER_TABLE
314: , p5_a18 JTF_DATE_TABLE
315: , p5_a19 JTF_NUMBER_TABLE
316: );
317: procedure validate_quote_parties(p_api_version NUMBER

Line 315: , p5_a19 JTF_NUMBER_TABLE

311: , p5_a15 JTF_NUMBER_TABLE
312: , p5_a16 JTF_DATE_TABLE
313: , p5_a17 JTF_NUMBER_TABLE
314: , p5_a18 JTF_DATE_TABLE
315: , p5_a19 JTF_NUMBER_TABLE
316: );
317: procedure validate_quote_parties(p_api_version NUMBER
318: , p_init_msg_list VARCHAR2
319: , x_return_status out nocopy VARCHAR2