DBA Data[Home] [Help]

APPS.OKL_REPAIR_COSTS_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_VARCHAR2_TABLE_100
11: , p5_a3 JTF_VARCHAR2_TABLE_100
12: , p5_a4 JTF_NUMBER_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_VARCHAR2_TABLE_100
11: , p5_a3 JTF_VARCHAR2_TABLE_100
12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_VARCHAR2_TABLE_300

Line 12: , p5_a4 JTF_NUMBER_TABLE

8: , p5_a0 JTF_NUMBER_TABLE
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_VARCHAR2_TABLE_100
11: , p5_a3 JTF_VARCHAR2_TABLE_100
12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_VARCHAR2_TABLE_300
14: , p5_a6 JTF_VARCHAR2_TABLE_2000
15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_NUMBER_TABLE

Line 15: , p5_a7 JTF_NUMBER_TABLE

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

Line 16: , p5_a8 JTF_NUMBER_TABLE

12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_VARCHAR2_TABLE_300
14: , p5_a6 JTF_VARCHAR2_TABLE_2000
15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_DATE_TABLE
18: , p5_a10 JTF_NUMBER_TABLE
19: , p5_a11 JTF_DATE_TABLE
20: , p5_a12 JTF_NUMBER_TABLE

Line 18: , p5_a10 JTF_NUMBER_TABLE

14: , p5_a6 JTF_VARCHAR2_TABLE_2000
15: , p5_a7 JTF_NUMBER_TABLE
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_DATE_TABLE
18: , p5_a10 JTF_NUMBER_TABLE
19: , p5_a11 JTF_DATE_TABLE
20: , p5_a12 JTF_NUMBER_TABLE
21: , p5_a13 JTF_VARCHAR2_TABLE_100
22: , p5_a14 JTF_VARCHAR2_TABLE_100

Line 20: , p5_a12 JTF_NUMBER_TABLE

16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_DATE_TABLE
18: , p5_a10 JTF_NUMBER_TABLE
19: , p5_a11 JTF_DATE_TABLE
20: , p5_a12 JTF_NUMBER_TABLE
21: , p5_a13 JTF_VARCHAR2_TABLE_100
22: , p5_a14 JTF_VARCHAR2_TABLE_100
23: , p5_a15 JTF_VARCHAR2_TABLE_100
24: , p5_a16 JTF_NUMBER_TABLE

Line 24: , p5_a16 JTF_NUMBER_TABLE

20: , p5_a12 JTF_NUMBER_TABLE
21: , p5_a13 JTF_VARCHAR2_TABLE_100
22: , p5_a14 JTF_VARCHAR2_TABLE_100
23: , p5_a15 JTF_VARCHAR2_TABLE_100
24: , p5_a16 JTF_NUMBER_TABLE
25: , p5_a17 JTF_DATE_TABLE
26: , p6_a0 out nocopy JTF_NUMBER_TABLE
27: , p6_a1 out nocopy JTF_NUMBER_TABLE
28: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 26: , p6_a0 out nocopy JTF_NUMBER_TABLE

22: , p5_a14 JTF_VARCHAR2_TABLE_100
23: , p5_a15 JTF_VARCHAR2_TABLE_100
24: , p5_a16 JTF_NUMBER_TABLE
25: , p5_a17 JTF_DATE_TABLE
26: , p6_a0 out nocopy JTF_NUMBER_TABLE
27: , p6_a1 out nocopy JTF_NUMBER_TABLE
28: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
29: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
30: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 27: , p6_a1 out nocopy JTF_NUMBER_TABLE

23: , p5_a15 JTF_VARCHAR2_TABLE_100
24: , p5_a16 JTF_NUMBER_TABLE
25: , p5_a17 JTF_DATE_TABLE
26: , p6_a0 out nocopy JTF_NUMBER_TABLE
27: , p6_a1 out nocopy JTF_NUMBER_TABLE
28: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
29: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
30: , p6_a4 out nocopy JTF_NUMBER_TABLE
31: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 30: , p6_a4 out nocopy JTF_NUMBER_TABLE

26: , p6_a0 out nocopy JTF_NUMBER_TABLE
27: , p6_a1 out nocopy JTF_NUMBER_TABLE
28: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
29: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
30: , p6_a4 out nocopy JTF_NUMBER_TABLE
31: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
32: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
33: , p6_a7 out nocopy JTF_NUMBER_TABLE
34: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 33: , p6_a7 out nocopy JTF_NUMBER_TABLE

29: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
30: , p6_a4 out nocopy JTF_NUMBER_TABLE
31: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
32: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
33: , p6_a7 out nocopy JTF_NUMBER_TABLE
34: , p6_a8 out nocopy JTF_NUMBER_TABLE
35: , p6_a9 out nocopy JTF_DATE_TABLE
36: , p6_a10 out nocopy JTF_NUMBER_TABLE
37: , p6_a11 out nocopy JTF_DATE_TABLE

Line 34: , p6_a8 out nocopy JTF_NUMBER_TABLE

30: , p6_a4 out nocopy JTF_NUMBER_TABLE
31: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
32: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
33: , p6_a7 out nocopy JTF_NUMBER_TABLE
34: , p6_a8 out nocopy JTF_NUMBER_TABLE
35: , p6_a9 out nocopy JTF_DATE_TABLE
36: , p6_a10 out nocopy JTF_NUMBER_TABLE
37: , p6_a11 out nocopy JTF_DATE_TABLE
38: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 36: , p6_a10 out nocopy JTF_NUMBER_TABLE

32: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
33: , p6_a7 out nocopy JTF_NUMBER_TABLE
34: , p6_a8 out nocopy JTF_NUMBER_TABLE
35: , p6_a9 out nocopy JTF_DATE_TABLE
36: , p6_a10 out nocopy JTF_NUMBER_TABLE
37: , p6_a11 out nocopy JTF_DATE_TABLE
38: , p6_a12 out nocopy JTF_NUMBER_TABLE
39: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
40: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 38: , p6_a12 out nocopy JTF_NUMBER_TABLE

34: , p6_a8 out nocopy JTF_NUMBER_TABLE
35: , p6_a9 out nocopy JTF_DATE_TABLE
36: , p6_a10 out nocopy JTF_NUMBER_TABLE
37: , p6_a11 out nocopy JTF_DATE_TABLE
38: , p6_a12 out nocopy JTF_NUMBER_TABLE
39: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
40: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
41: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
42: , p6_a16 out nocopy JTF_NUMBER_TABLE

Line 42: , p6_a16 out nocopy JTF_NUMBER_TABLE

38: , p6_a12 out nocopy JTF_NUMBER_TABLE
39: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
40: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
41: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
42: , p6_a16 out nocopy JTF_NUMBER_TABLE
43: , p6_a17 out nocopy JTF_DATE_TABLE
44: );
45: procedure insert_repair_costs(p_api_version NUMBER
46: , p_init_msg_list VARCHAR2

Line 92: , p5_a0 JTF_NUMBER_TABLE

88: , p_init_msg_list VARCHAR2
89: , x_return_status out nocopy VARCHAR2
90: , x_msg_count out nocopy NUMBER
91: , x_msg_data out nocopy VARCHAR2
92: , p5_a0 JTF_NUMBER_TABLE
93: , p5_a1 JTF_NUMBER_TABLE
94: , p5_a2 JTF_VARCHAR2_TABLE_100
95: , p5_a3 JTF_VARCHAR2_TABLE_100
96: , p5_a4 JTF_NUMBER_TABLE

Line 93: , p5_a1 JTF_NUMBER_TABLE

89: , x_return_status out nocopy VARCHAR2
90: , x_msg_count out nocopy NUMBER
91: , x_msg_data out nocopy VARCHAR2
92: , p5_a0 JTF_NUMBER_TABLE
93: , p5_a1 JTF_NUMBER_TABLE
94: , p5_a2 JTF_VARCHAR2_TABLE_100
95: , p5_a3 JTF_VARCHAR2_TABLE_100
96: , p5_a4 JTF_NUMBER_TABLE
97: , p5_a5 JTF_VARCHAR2_TABLE_300

Line 96: , p5_a4 JTF_NUMBER_TABLE

92: , p5_a0 JTF_NUMBER_TABLE
93: , p5_a1 JTF_NUMBER_TABLE
94: , p5_a2 JTF_VARCHAR2_TABLE_100
95: , p5_a3 JTF_VARCHAR2_TABLE_100
96: , p5_a4 JTF_NUMBER_TABLE
97: , p5_a5 JTF_VARCHAR2_TABLE_300
98: , p5_a6 JTF_VARCHAR2_TABLE_2000
99: , p5_a7 JTF_NUMBER_TABLE
100: , p5_a8 JTF_NUMBER_TABLE

Line 99: , p5_a7 JTF_NUMBER_TABLE

95: , p5_a3 JTF_VARCHAR2_TABLE_100
96: , p5_a4 JTF_NUMBER_TABLE
97: , p5_a5 JTF_VARCHAR2_TABLE_300
98: , p5_a6 JTF_VARCHAR2_TABLE_2000
99: , p5_a7 JTF_NUMBER_TABLE
100: , p5_a8 JTF_NUMBER_TABLE
101: , p5_a9 JTF_DATE_TABLE
102: , p5_a10 JTF_NUMBER_TABLE
103: , p5_a11 JTF_DATE_TABLE

Line 100: , p5_a8 JTF_NUMBER_TABLE

96: , p5_a4 JTF_NUMBER_TABLE
97: , p5_a5 JTF_VARCHAR2_TABLE_300
98: , p5_a6 JTF_VARCHAR2_TABLE_2000
99: , p5_a7 JTF_NUMBER_TABLE
100: , p5_a8 JTF_NUMBER_TABLE
101: , p5_a9 JTF_DATE_TABLE
102: , p5_a10 JTF_NUMBER_TABLE
103: , p5_a11 JTF_DATE_TABLE
104: , p5_a12 JTF_NUMBER_TABLE

Line 102: , p5_a10 JTF_NUMBER_TABLE

98: , p5_a6 JTF_VARCHAR2_TABLE_2000
99: , p5_a7 JTF_NUMBER_TABLE
100: , p5_a8 JTF_NUMBER_TABLE
101: , p5_a9 JTF_DATE_TABLE
102: , p5_a10 JTF_NUMBER_TABLE
103: , p5_a11 JTF_DATE_TABLE
104: , p5_a12 JTF_NUMBER_TABLE
105: , p5_a13 JTF_VARCHAR2_TABLE_100
106: , p5_a14 JTF_VARCHAR2_TABLE_100

Line 104: , p5_a12 JTF_NUMBER_TABLE

100: , p5_a8 JTF_NUMBER_TABLE
101: , p5_a9 JTF_DATE_TABLE
102: , p5_a10 JTF_NUMBER_TABLE
103: , p5_a11 JTF_DATE_TABLE
104: , p5_a12 JTF_NUMBER_TABLE
105: , p5_a13 JTF_VARCHAR2_TABLE_100
106: , p5_a14 JTF_VARCHAR2_TABLE_100
107: , p5_a15 JTF_VARCHAR2_TABLE_100
108: , p5_a16 JTF_NUMBER_TABLE

Line 108: , p5_a16 JTF_NUMBER_TABLE

104: , p5_a12 JTF_NUMBER_TABLE
105: , p5_a13 JTF_VARCHAR2_TABLE_100
106: , p5_a14 JTF_VARCHAR2_TABLE_100
107: , p5_a15 JTF_VARCHAR2_TABLE_100
108: , p5_a16 JTF_NUMBER_TABLE
109: , p5_a17 JTF_DATE_TABLE
110: );
111: procedure lock_repair_costs(p_api_version NUMBER
112: , p_init_msg_list VARCHAR2

Line 140: , p5_a0 JTF_NUMBER_TABLE

136: , p_init_msg_list VARCHAR2
137: , x_return_status out nocopy VARCHAR2
138: , x_msg_count out nocopy NUMBER
139: , x_msg_data out nocopy VARCHAR2
140: , p5_a0 JTF_NUMBER_TABLE
141: , p5_a1 JTF_NUMBER_TABLE
142: , p5_a2 JTF_VARCHAR2_TABLE_100
143: , p5_a3 JTF_VARCHAR2_TABLE_100
144: , p5_a4 JTF_NUMBER_TABLE

Line 141: , p5_a1 JTF_NUMBER_TABLE

137: , x_return_status out nocopy VARCHAR2
138: , x_msg_count out nocopy NUMBER
139: , x_msg_data out nocopy VARCHAR2
140: , p5_a0 JTF_NUMBER_TABLE
141: , p5_a1 JTF_NUMBER_TABLE
142: , p5_a2 JTF_VARCHAR2_TABLE_100
143: , p5_a3 JTF_VARCHAR2_TABLE_100
144: , p5_a4 JTF_NUMBER_TABLE
145: , p5_a5 JTF_VARCHAR2_TABLE_300

Line 144: , p5_a4 JTF_NUMBER_TABLE

140: , p5_a0 JTF_NUMBER_TABLE
141: , p5_a1 JTF_NUMBER_TABLE
142: , p5_a2 JTF_VARCHAR2_TABLE_100
143: , p5_a3 JTF_VARCHAR2_TABLE_100
144: , p5_a4 JTF_NUMBER_TABLE
145: , p5_a5 JTF_VARCHAR2_TABLE_300
146: , p5_a6 JTF_VARCHAR2_TABLE_2000
147: , p5_a7 JTF_NUMBER_TABLE
148: , p5_a8 JTF_NUMBER_TABLE

Line 147: , p5_a7 JTF_NUMBER_TABLE

143: , p5_a3 JTF_VARCHAR2_TABLE_100
144: , p5_a4 JTF_NUMBER_TABLE
145: , p5_a5 JTF_VARCHAR2_TABLE_300
146: , p5_a6 JTF_VARCHAR2_TABLE_2000
147: , p5_a7 JTF_NUMBER_TABLE
148: , p5_a8 JTF_NUMBER_TABLE
149: , p5_a9 JTF_DATE_TABLE
150: , p5_a10 JTF_NUMBER_TABLE
151: , p5_a11 JTF_DATE_TABLE

Line 148: , p5_a8 JTF_NUMBER_TABLE

144: , p5_a4 JTF_NUMBER_TABLE
145: , p5_a5 JTF_VARCHAR2_TABLE_300
146: , p5_a6 JTF_VARCHAR2_TABLE_2000
147: , p5_a7 JTF_NUMBER_TABLE
148: , p5_a8 JTF_NUMBER_TABLE
149: , p5_a9 JTF_DATE_TABLE
150: , p5_a10 JTF_NUMBER_TABLE
151: , p5_a11 JTF_DATE_TABLE
152: , p5_a12 JTF_NUMBER_TABLE

Line 150: , p5_a10 JTF_NUMBER_TABLE

146: , p5_a6 JTF_VARCHAR2_TABLE_2000
147: , p5_a7 JTF_NUMBER_TABLE
148: , p5_a8 JTF_NUMBER_TABLE
149: , p5_a9 JTF_DATE_TABLE
150: , p5_a10 JTF_NUMBER_TABLE
151: , p5_a11 JTF_DATE_TABLE
152: , p5_a12 JTF_NUMBER_TABLE
153: , p5_a13 JTF_VARCHAR2_TABLE_100
154: , p5_a14 JTF_VARCHAR2_TABLE_100

Line 152: , p5_a12 JTF_NUMBER_TABLE

148: , p5_a8 JTF_NUMBER_TABLE
149: , p5_a9 JTF_DATE_TABLE
150: , p5_a10 JTF_NUMBER_TABLE
151: , p5_a11 JTF_DATE_TABLE
152: , p5_a12 JTF_NUMBER_TABLE
153: , p5_a13 JTF_VARCHAR2_TABLE_100
154: , p5_a14 JTF_VARCHAR2_TABLE_100
155: , p5_a15 JTF_VARCHAR2_TABLE_100
156: , p5_a16 JTF_NUMBER_TABLE

Line 156: , p5_a16 JTF_NUMBER_TABLE

152: , p5_a12 JTF_NUMBER_TABLE
153: , p5_a13 JTF_VARCHAR2_TABLE_100
154: , p5_a14 JTF_VARCHAR2_TABLE_100
155: , p5_a15 JTF_VARCHAR2_TABLE_100
156: , p5_a16 JTF_NUMBER_TABLE
157: , p5_a17 JTF_DATE_TABLE
158: , p6_a0 out nocopy JTF_NUMBER_TABLE
159: , p6_a1 out nocopy JTF_NUMBER_TABLE
160: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 158: , p6_a0 out nocopy JTF_NUMBER_TABLE

154: , p5_a14 JTF_VARCHAR2_TABLE_100
155: , p5_a15 JTF_VARCHAR2_TABLE_100
156: , p5_a16 JTF_NUMBER_TABLE
157: , p5_a17 JTF_DATE_TABLE
158: , p6_a0 out nocopy JTF_NUMBER_TABLE
159: , p6_a1 out nocopy JTF_NUMBER_TABLE
160: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
161: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
162: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 159: , p6_a1 out nocopy JTF_NUMBER_TABLE

155: , p5_a15 JTF_VARCHAR2_TABLE_100
156: , p5_a16 JTF_NUMBER_TABLE
157: , p5_a17 JTF_DATE_TABLE
158: , p6_a0 out nocopy JTF_NUMBER_TABLE
159: , p6_a1 out nocopy JTF_NUMBER_TABLE
160: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
161: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
162: , p6_a4 out nocopy JTF_NUMBER_TABLE
163: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300

Line 162: , p6_a4 out nocopy JTF_NUMBER_TABLE

158: , p6_a0 out nocopy JTF_NUMBER_TABLE
159: , p6_a1 out nocopy JTF_NUMBER_TABLE
160: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
161: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
162: , p6_a4 out nocopy JTF_NUMBER_TABLE
163: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
164: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
165: , p6_a7 out nocopy JTF_NUMBER_TABLE
166: , p6_a8 out nocopy JTF_NUMBER_TABLE

Line 165: , p6_a7 out nocopy JTF_NUMBER_TABLE

161: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
162: , p6_a4 out nocopy JTF_NUMBER_TABLE
163: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
164: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
165: , p6_a7 out nocopy JTF_NUMBER_TABLE
166: , p6_a8 out nocopy JTF_NUMBER_TABLE
167: , p6_a9 out nocopy JTF_DATE_TABLE
168: , p6_a10 out nocopy JTF_NUMBER_TABLE
169: , p6_a11 out nocopy JTF_DATE_TABLE

Line 166: , p6_a8 out nocopy JTF_NUMBER_TABLE

162: , p6_a4 out nocopy JTF_NUMBER_TABLE
163: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_300
164: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
165: , p6_a7 out nocopy JTF_NUMBER_TABLE
166: , p6_a8 out nocopy JTF_NUMBER_TABLE
167: , p6_a9 out nocopy JTF_DATE_TABLE
168: , p6_a10 out nocopy JTF_NUMBER_TABLE
169: , p6_a11 out nocopy JTF_DATE_TABLE
170: , p6_a12 out nocopy JTF_NUMBER_TABLE

Line 168: , p6_a10 out nocopy JTF_NUMBER_TABLE

164: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
165: , p6_a7 out nocopy JTF_NUMBER_TABLE
166: , p6_a8 out nocopy JTF_NUMBER_TABLE
167: , p6_a9 out nocopy JTF_DATE_TABLE
168: , p6_a10 out nocopy JTF_NUMBER_TABLE
169: , p6_a11 out nocopy JTF_DATE_TABLE
170: , p6_a12 out nocopy JTF_NUMBER_TABLE
171: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
172: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

Line 170: , p6_a12 out nocopy JTF_NUMBER_TABLE

166: , p6_a8 out nocopy JTF_NUMBER_TABLE
167: , p6_a9 out nocopy JTF_DATE_TABLE
168: , p6_a10 out nocopy JTF_NUMBER_TABLE
169: , p6_a11 out nocopy JTF_DATE_TABLE
170: , p6_a12 out nocopy JTF_NUMBER_TABLE
171: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
172: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
173: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
174: , p6_a16 out nocopy JTF_NUMBER_TABLE

Line 174: , p6_a16 out nocopy JTF_NUMBER_TABLE

170: , p6_a12 out nocopy JTF_NUMBER_TABLE
171: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
172: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
173: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
174: , p6_a16 out nocopy JTF_NUMBER_TABLE
175: , p6_a17 out nocopy JTF_DATE_TABLE
176: );
177: procedure update_repair_costs(p_api_version NUMBER
178: , p_init_msg_list VARCHAR2

Line 224: , p5_a0 JTF_NUMBER_TABLE

220: , p_init_msg_list VARCHAR2
221: , x_return_status out nocopy VARCHAR2
222: , x_msg_count out nocopy NUMBER
223: , x_msg_data out nocopy VARCHAR2
224: , p5_a0 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_100
227: , p5_a3 JTF_VARCHAR2_TABLE_100
228: , p5_a4 JTF_NUMBER_TABLE

Line 225: , p5_a1 JTF_NUMBER_TABLE

221: , x_return_status out nocopy VARCHAR2
222: , x_msg_count out nocopy NUMBER
223: , x_msg_data out nocopy VARCHAR2
224: , p5_a0 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_100
227: , p5_a3 JTF_VARCHAR2_TABLE_100
228: , p5_a4 JTF_NUMBER_TABLE
229: , p5_a5 JTF_VARCHAR2_TABLE_300

Line 228: , p5_a4 JTF_NUMBER_TABLE

224: , p5_a0 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_100
227: , p5_a3 JTF_VARCHAR2_TABLE_100
228: , p5_a4 JTF_NUMBER_TABLE
229: , p5_a5 JTF_VARCHAR2_TABLE_300
230: , p5_a6 JTF_VARCHAR2_TABLE_2000
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE

Line 231: , p5_a7 JTF_NUMBER_TABLE

227: , p5_a3 JTF_VARCHAR2_TABLE_100
228: , p5_a4 JTF_NUMBER_TABLE
229: , p5_a5 JTF_VARCHAR2_TABLE_300
230: , p5_a6 JTF_VARCHAR2_TABLE_2000
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_DATE_TABLE
234: , p5_a10 JTF_NUMBER_TABLE
235: , p5_a11 JTF_DATE_TABLE

Line 232: , p5_a8 JTF_NUMBER_TABLE

228: , p5_a4 JTF_NUMBER_TABLE
229: , p5_a5 JTF_VARCHAR2_TABLE_300
230: , p5_a6 JTF_VARCHAR2_TABLE_2000
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_DATE_TABLE
234: , p5_a10 JTF_NUMBER_TABLE
235: , p5_a11 JTF_DATE_TABLE
236: , p5_a12 JTF_NUMBER_TABLE

Line 234: , p5_a10 JTF_NUMBER_TABLE

230: , p5_a6 JTF_VARCHAR2_TABLE_2000
231: , p5_a7 JTF_NUMBER_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_DATE_TABLE
234: , p5_a10 JTF_NUMBER_TABLE
235: , p5_a11 JTF_DATE_TABLE
236: , p5_a12 JTF_NUMBER_TABLE
237: , p5_a13 JTF_VARCHAR2_TABLE_100
238: , p5_a14 JTF_VARCHAR2_TABLE_100

Line 236: , p5_a12 JTF_NUMBER_TABLE

232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_DATE_TABLE
234: , p5_a10 JTF_NUMBER_TABLE
235: , p5_a11 JTF_DATE_TABLE
236: , p5_a12 JTF_NUMBER_TABLE
237: , p5_a13 JTF_VARCHAR2_TABLE_100
238: , p5_a14 JTF_VARCHAR2_TABLE_100
239: , p5_a15 JTF_VARCHAR2_TABLE_100
240: , p5_a16 JTF_NUMBER_TABLE

Line 240: , p5_a16 JTF_NUMBER_TABLE

236: , p5_a12 JTF_NUMBER_TABLE
237: , p5_a13 JTF_VARCHAR2_TABLE_100
238: , p5_a14 JTF_VARCHAR2_TABLE_100
239: , p5_a15 JTF_VARCHAR2_TABLE_100
240: , p5_a16 JTF_NUMBER_TABLE
241: , p5_a17 JTF_DATE_TABLE
242: );
243: procedure delete_repair_costs(p_api_version NUMBER
244: , p_init_msg_list VARCHAR2

Line 272: , p5_a0 JTF_NUMBER_TABLE

268: , p_init_msg_list VARCHAR2
269: , x_return_status out nocopy VARCHAR2
270: , x_msg_count out nocopy NUMBER
271: , x_msg_data out nocopy VARCHAR2
272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_100
275: , p5_a3 JTF_VARCHAR2_TABLE_100
276: , p5_a4 JTF_NUMBER_TABLE

Line 273: , p5_a1 JTF_NUMBER_TABLE

269: , x_return_status out nocopy VARCHAR2
270: , x_msg_count out nocopy NUMBER
271: , x_msg_data out nocopy VARCHAR2
272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_100
275: , p5_a3 JTF_VARCHAR2_TABLE_100
276: , p5_a4 JTF_NUMBER_TABLE
277: , p5_a5 JTF_VARCHAR2_TABLE_300

Line 276: , p5_a4 JTF_NUMBER_TABLE

272: , p5_a0 JTF_NUMBER_TABLE
273: , p5_a1 JTF_NUMBER_TABLE
274: , p5_a2 JTF_VARCHAR2_TABLE_100
275: , p5_a3 JTF_VARCHAR2_TABLE_100
276: , p5_a4 JTF_NUMBER_TABLE
277: , p5_a5 JTF_VARCHAR2_TABLE_300
278: , p5_a6 JTF_VARCHAR2_TABLE_2000
279: , p5_a7 JTF_NUMBER_TABLE
280: , p5_a8 JTF_NUMBER_TABLE

Line 279: , p5_a7 JTF_NUMBER_TABLE

275: , p5_a3 JTF_VARCHAR2_TABLE_100
276: , p5_a4 JTF_NUMBER_TABLE
277: , p5_a5 JTF_VARCHAR2_TABLE_300
278: , p5_a6 JTF_VARCHAR2_TABLE_2000
279: , p5_a7 JTF_NUMBER_TABLE
280: , p5_a8 JTF_NUMBER_TABLE
281: , p5_a9 JTF_DATE_TABLE
282: , p5_a10 JTF_NUMBER_TABLE
283: , p5_a11 JTF_DATE_TABLE

Line 280: , p5_a8 JTF_NUMBER_TABLE

276: , p5_a4 JTF_NUMBER_TABLE
277: , p5_a5 JTF_VARCHAR2_TABLE_300
278: , p5_a6 JTF_VARCHAR2_TABLE_2000
279: , p5_a7 JTF_NUMBER_TABLE
280: , p5_a8 JTF_NUMBER_TABLE
281: , p5_a9 JTF_DATE_TABLE
282: , p5_a10 JTF_NUMBER_TABLE
283: , p5_a11 JTF_DATE_TABLE
284: , p5_a12 JTF_NUMBER_TABLE

Line 282: , p5_a10 JTF_NUMBER_TABLE

278: , p5_a6 JTF_VARCHAR2_TABLE_2000
279: , p5_a7 JTF_NUMBER_TABLE
280: , p5_a8 JTF_NUMBER_TABLE
281: , p5_a9 JTF_DATE_TABLE
282: , p5_a10 JTF_NUMBER_TABLE
283: , p5_a11 JTF_DATE_TABLE
284: , p5_a12 JTF_NUMBER_TABLE
285: , p5_a13 JTF_VARCHAR2_TABLE_100
286: , p5_a14 JTF_VARCHAR2_TABLE_100

Line 284: , p5_a12 JTF_NUMBER_TABLE

280: , p5_a8 JTF_NUMBER_TABLE
281: , p5_a9 JTF_DATE_TABLE
282: , p5_a10 JTF_NUMBER_TABLE
283: , p5_a11 JTF_DATE_TABLE
284: , p5_a12 JTF_NUMBER_TABLE
285: , p5_a13 JTF_VARCHAR2_TABLE_100
286: , p5_a14 JTF_VARCHAR2_TABLE_100
287: , p5_a15 JTF_VARCHAR2_TABLE_100
288: , p5_a16 JTF_NUMBER_TABLE

Line 288: , p5_a16 JTF_NUMBER_TABLE

284: , p5_a12 JTF_NUMBER_TABLE
285: , p5_a13 JTF_VARCHAR2_TABLE_100
286: , p5_a14 JTF_VARCHAR2_TABLE_100
287: , p5_a15 JTF_VARCHAR2_TABLE_100
288: , p5_a16 JTF_NUMBER_TABLE
289: , p5_a17 JTF_DATE_TABLE
290: );
291: procedure validate_repair_costs(p_api_version NUMBER
292: , p_init_msg_list VARCHAR2