DBA Data[Home] [Help]

APPS.OKL_REPAIR_COSTS_PUB_W dependencies on JTF_DATE_TABLE

Line 17: , p5_a9 JTF_DATE_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
21: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 19: , p5_a11 JTF_DATE_TABLE

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
23: , p5_a15 JTF_VARCHAR2_TABLE_100

Line 25: , p5_a17 JTF_DATE_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
29: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 35: , p6_a9 out nocopy JTF_DATE_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
39: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 37: , p6_a11 out nocopy JTF_DATE_TABLE

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
41: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 43: , p6_a17 out nocopy JTF_DATE_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
47: , x_return_status out nocopy VARCHAR2

Line 101: , p5_a9 JTF_DATE_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
105: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 103: , p5_a11 JTF_DATE_TABLE

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
107: , p5_a15 JTF_VARCHAR2_TABLE_100

Line 109: , p5_a17 JTF_DATE_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
113: , x_return_status out nocopy VARCHAR2

Line 149: , p5_a9 JTF_DATE_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
153: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 151: , p5_a11 JTF_DATE_TABLE

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
155: , p5_a15 JTF_VARCHAR2_TABLE_100

Line 157: , p5_a17 JTF_DATE_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
161: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100

Line 167: , p6_a9 out nocopy JTF_DATE_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
171: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100

Line 169: , p6_a11 out nocopy JTF_DATE_TABLE

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
173: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100

Line 175: , p6_a17 out nocopy JTF_DATE_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
179: , x_return_status out nocopy VARCHAR2

Line 233: , p5_a9 JTF_DATE_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
237: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 235: , p5_a11 JTF_DATE_TABLE

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
239: , p5_a15 JTF_VARCHAR2_TABLE_100

Line 241: , p5_a17 JTF_DATE_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
245: , x_return_status out nocopy VARCHAR2

Line 281: , p5_a9 JTF_DATE_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
285: , p5_a13 JTF_VARCHAR2_TABLE_100

Line 283: , p5_a11 JTF_DATE_TABLE

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
287: , p5_a15 JTF_VARCHAR2_TABLE_100

Line 289: , p5_a17 JTF_DATE_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
293: , x_return_status out nocopy VARCHAR2