APPS.OKL_REPAIR_COSTS_PUB_W dependencies on JTF_VARCHAR2_TABLE_100

Line 10: , p5_a2 JTF_VARCHAR2_TABLE_100

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
14: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 11: , p5_a3 JTF_VARCHAR2_TABLE_100

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
14: , p5_a6 JTF_VARCHAR2_TABLE_2000
15: , p5_a7 JTF_NUMBER_TABLE

Line 21: , p5_a13 JTF_VARCHAR2_TABLE_100

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
25: , p5_a17 JTF_DATE_TABLE

Line 22: , p5_a14 JTF_VARCHAR2_TABLE_100

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
25: , p5_a17 JTF_DATE_TABLE
26: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 23: , p5_a15 JTF_VARCHAR2_TABLE_100

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
25: , p5_a17 JTF_DATE_TABLE
26: , p6_a0 out nocopy JTF_NUMBER_TABLE
27: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 28: , p6_a2 out nocopy 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
32: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 29: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
32: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
33: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 39: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

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
43: , p6_a17 out nocopy JTF_DATE_TABLE

Line 40: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

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
43: , p6_a17 out nocopy JTF_DATE_TABLE
44: );

Line 41: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

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
43: , p6_a17 out nocopy JTF_DATE_TABLE
44: );
45: procedure insert_repair_costs(p_api_version NUMBER

Line 94: , p5_a2 JTF_VARCHAR2_TABLE_100

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
98: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 95: , p5_a3 JTF_VARCHAR2_TABLE_100

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
98: , p5_a6 JTF_VARCHAR2_TABLE_2000
99: , p5_a7 JTF_NUMBER_TABLE

Line 105: , p5_a13 JTF_VARCHAR2_TABLE_100

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
109: , p5_a17 JTF_DATE_TABLE

Line 106: , p5_a14 JTF_VARCHAR2_TABLE_100

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
109: , p5_a17 JTF_DATE_TABLE
110: );

Line 107: , p5_a15 JTF_VARCHAR2_TABLE_100

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
109: , p5_a17 JTF_DATE_TABLE
110: );
111: procedure lock_repair_costs(p_api_version NUMBER

Line 142: , p5_a2 JTF_VARCHAR2_TABLE_100

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
146: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 143: , p5_a3 JTF_VARCHAR2_TABLE_100

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
146: , p5_a6 JTF_VARCHAR2_TABLE_2000
147: , p5_a7 JTF_NUMBER_TABLE

Line 153: , p5_a13 JTF_VARCHAR2_TABLE_100

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
157: , p5_a17 JTF_DATE_TABLE

Line 154: , p5_a14 JTF_VARCHAR2_TABLE_100

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
157: , p5_a17 JTF_DATE_TABLE
158: , p6_a0 out nocopy JTF_NUMBER_TABLE

Line 155: , p5_a15 JTF_VARCHAR2_TABLE_100

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
157: , p5_a17 JTF_DATE_TABLE
158: , p6_a0 out nocopy JTF_NUMBER_TABLE
159: , p6_a1 out nocopy JTF_NUMBER_TABLE

Line 160: , p6_a2 out nocopy 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
164: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000

Line 161: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

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
164: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
165: , p6_a7 out nocopy JTF_NUMBER_TABLE

Line 171: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

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
175: , p6_a17 out nocopy JTF_DATE_TABLE

Line 172: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100

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
175: , p6_a17 out nocopy JTF_DATE_TABLE
176: );

Line 173: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

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
175: , p6_a17 out nocopy JTF_DATE_TABLE
176: );
177: procedure update_repair_costs(p_api_version NUMBER

Line 226: , p5_a2 JTF_VARCHAR2_TABLE_100

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
230: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 227: , p5_a3 JTF_VARCHAR2_TABLE_100

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
230: , p5_a6 JTF_VARCHAR2_TABLE_2000
231: , p5_a7 JTF_NUMBER_TABLE

Line 237: , p5_a13 JTF_VARCHAR2_TABLE_100

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
241: , p5_a17 JTF_DATE_TABLE

Line 238: , p5_a14 JTF_VARCHAR2_TABLE_100

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
241: , p5_a17 JTF_DATE_TABLE
242: );

Line 239: , p5_a15 JTF_VARCHAR2_TABLE_100

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
241: , p5_a17 JTF_DATE_TABLE
242: );
243: procedure delete_repair_costs(p_api_version NUMBER

Line 274: , p5_a2 JTF_VARCHAR2_TABLE_100

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
278: , p5_a6 JTF_VARCHAR2_TABLE_2000

Line 275: , p5_a3 JTF_VARCHAR2_TABLE_100

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
278: , p5_a6 JTF_VARCHAR2_TABLE_2000
279: , p5_a7 JTF_NUMBER_TABLE

Line 285: , p5_a13 JTF_VARCHAR2_TABLE_100

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
289: , p5_a17 JTF_DATE_TABLE

Line 286: , p5_a14 JTF_VARCHAR2_TABLE_100

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
289: , p5_a17 JTF_DATE_TABLE
290: );

Line 287: , p5_a15 JTF_VARCHAR2_TABLE_100

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
289: , p5_a17 JTF_DATE_TABLE
290: );
291: procedure validate_repair_costs(p_api_version NUMBER