DBA Data[Home] [Help]

APPS.OKL_RELOCATE_ASSETS_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_NUMBER_TABLE
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_NUMBER_TABLE
12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 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_VARCHAR2_TABLE_100
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_NUMBER_TABLE
14: , p5_a6 JTF_DATE_TABLE
15: , p5_a7 JTF_VARCHAR2_TABLE_2000

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_NUMBER_TABLE
12: , p5_a4 JTF_NUMBER_TABLE
13: , p5_a5 JTF_NUMBER_TABLE
14: , p5_a6 JTF_DATE_TABLE
15: , p5_a7 JTF_VARCHAR2_TABLE_2000
16: , p5_a8 JTF_VARCHAR2_TABLE_300

Line 13: , p5_a5 JTF_NUMBER_TABLE

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

Line 17: , p5_a9 JTF_NUMBER_TABLE

13: , p5_a5 JTF_NUMBER_TABLE
14: , p5_a6 JTF_DATE_TABLE
15: , p5_a7 JTF_VARCHAR2_TABLE_2000
16: , p5_a8 JTF_VARCHAR2_TABLE_300
17: , p5_a9 JTF_NUMBER_TABLE
18: , p5_a10 JTF_VARCHAR2_TABLE_100
19: , p5_a11 JTF_VARCHAR2_TABLE_500
20: , p5_a12 JTF_VARCHAR2_TABLE_500
21: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 34: , p5_a26 JTF_NUMBER_TABLE

30: , p5_a22 JTF_VARCHAR2_TABLE_500
31: , p5_a23 JTF_VARCHAR2_TABLE_500
32: , p5_a24 JTF_VARCHAR2_TABLE_500
33: , p5_a25 JTF_VARCHAR2_TABLE_500
34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_NUMBER_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE

Line 35: , p5_a27 JTF_NUMBER_TABLE

31: , p5_a23 JTF_VARCHAR2_TABLE_500
32: , p5_a24 JTF_VARCHAR2_TABLE_500
33: , p5_a25 JTF_VARCHAR2_TABLE_500
34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_NUMBER_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE

Line 36: , p5_a28 JTF_NUMBER_TABLE

32: , p5_a24 JTF_VARCHAR2_TABLE_500
33: , p5_a25 JTF_VARCHAR2_TABLE_500
34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_NUMBER_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p5_a32 JTF_DATE_TABLE

Line 37: , p5_a29 JTF_NUMBER_TABLE

33: , p5_a25 JTF_VARCHAR2_TABLE_500
34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_NUMBER_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p5_a32 JTF_DATE_TABLE
41: , p5_a33 JTF_NUMBER_TABLE

Line 39: , p5_a31 JTF_NUMBER_TABLE

35: , p5_a27 JTF_NUMBER_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p5_a32 JTF_DATE_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_NUMBER_TABLE
43: , p5_a35 JTF_DATE_TABLE

Line 41: , p5_a33 JTF_NUMBER_TABLE

37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p5_a32 JTF_DATE_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_NUMBER_TABLE
43: , p5_a35 JTF_DATE_TABLE
44: , p5_a36 JTF_VARCHAR2_TABLE_100
45: , p5_a37 JTF_VARCHAR2_TABLE_100

Line 42: , p5_a34 JTF_NUMBER_TABLE

38: , p5_a30 JTF_DATE_TABLE
39: , p5_a31 JTF_NUMBER_TABLE
40: , p5_a32 JTF_DATE_TABLE
41: , p5_a33 JTF_NUMBER_TABLE
42: , p5_a34 JTF_NUMBER_TABLE
43: , p5_a35 JTF_DATE_TABLE
44: , p5_a36 JTF_VARCHAR2_TABLE_100
45: , p5_a37 JTF_VARCHAR2_TABLE_100
46: , p5_a38 JTF_VARCHAR2_TABLE_100

Line 47: , p5_a39 JTF_NUMBER_TABLE

43: , p5_a35 JTF_DATE_TABLE
44: , p5_a36 JTF_VARCHAR2_TABLE_100
45: , p5_a37 JTF_VARCHAR2_TABLE_100
46: , p5_a38 JTF_VARCHAR2_TABLE_100
47: , p5_a39 JTF_NUMBER_TABLE
48: , p5_a40 JTF_DATE_TABLE
49: , p6_a0 out nocopy JTF_NUMBER_TABLE
50: , p6_a1 out nocopy JTF_NUMBER_TABLE
51: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 49: , p6_a0 out nocopy JTF_NUMBER_TABLE

45: , p5_a37 JTF_VARCHAR2_TABLE_100
46: , p5_a38 JTF_VARCHAR2_TABLE_100
47: , p5_a39 JTF_NUMBER_TABLE
48: , p5_a40 JTF_DATE_TABLE
49: , p6_a0 out nocopy JTF_NUMBER_TABLE
50: , p6_a1 out nocopy JTF_NUMBER_TABLE
51: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , p6_a3 out nocopy JTF_NUMBER_TABLE
53: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 50: , p6_a1 out nocopy JTF_NUMBER_TABLE

46: , p5_a38 JTF_VARCHAR2_TABLE_100
47: , p5_a39 JTF_NUMBER_TABLE
48: , p5_a40 JTF_DATE_TABLE
49: , p6_a0 out nocopy JTF_NUMBER_TABLE
50: , p6_a1 out nocopy JTF_NUMBER_TABLE
51: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , p6_a3 out nocopy JTF_NUMBER_TABLE
53: , p6_a4 out nocopy JTF_NUMBER_TABLE
54: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 52: , p6_a3 out nocopy JTF_NUMBER_TABLE

48: , p5_a40 JTF_DATE_TABLE
49: , p6_a0 out nocopy JTF_NUMBER_TABLE
50: , p6_a1 out nocopy JTF_NUMBER_TABLE
51: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , p6_a3 out nocopy JTF_NUMBER_TABLE
53: , p6_a4 out nocopy JTF_NUMBER_TABLE
54: , p6_a5 out nocopy JTF_NUMBER_TABLE
55: , p6_a6 out nocopy JTF_DATE_TABLE
56: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 53: , p6_a4 out nocopy JTF_NUMBER_TABLE

49: , p6_a0 out nocopy JTF_NUMBER_TABLE
50: , p6_a1 out nocopy JTF_NUMBER_TABLE
51: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , p6_a3 out nocopy JTF_NUMBER_TABLE
53: , p6_a4 out nocopy JTF_NUMBER_TABLE
54: , p6_a5 out nocopy JTF_NUMBER_TABLE
55: , p6_a6 out nocopy JTF_DATE_TABLE
56: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
57: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 54: , p6_a5 out nocopy JTF_NUMBER_TABLE

50: , p6_a1 out nocopy JTF_NUMBER_TABLE
51: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
52: , p6_a3 out nocopy JTF_NUMBER_TABLE
53: , p6_a4 out nocopy JTF_NUMBER_TABLE
54: , p6_a5 out nocopy JTF_NUMBER_TABLE
55: , p6_a6 out nocopy JTF_DATE_TABLE
56: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
57: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
58: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 58: , p6_a9 out nocopy JTF_NUMBER_TABLE

54: , p6_a5 out nocopy JTF_NUMBER_TABLE
55: , p6_a6 out nocopy JTF_DATE_TABLE
56: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
57: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
58: , p6_a9 out nocopy JTF_NUMBER_TABLE
59: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
60: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
61: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
62: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 75: , p6_a26 out nocopy JTF_NUMBER_TABLE

71: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
72: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
73: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
74: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
75: , p6_a26 out nocopy JTF_NUMBER_TABLE
76: , p6_a27 out nocopy JTF_NUMBER_TABLE
77: , p6_a28 out nocopy JTF_NUMBER_TABLE
78: , p6_a29 out nocopy JTF_NUMBER_TABLE
79: , p6_a30 out nocopy JTF_DATE_TABLE

Line 76: , p6_a27 out nocopy JTF_NUMBER_TABLE

72: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
73: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
74: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
75: , p6_a26 out nocopy JTF_NUMBER_TABLE
76: , p6_a27 out nocopy JTF_NUMBER_TABLE
77: , p6_a28 out nocopy JTF_NUMBER_TABLE
78: , p6_a29 out nocopy JTF_NUMBER_TABLE
79: , p6_a30 out nocopy JTF_DATE_TABLE
80: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 77: , p6_a28 out nocopy JTF_NUMBER_TABLE

73: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
74: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
75: , p6_a26 out nocopy JTF_NUMBER_TABLE
76: , p6_a27 out nocopy JTF_NUMBER_TABLE
77: , p6_a28 out nocopy JTF_NUMBER_TABLE
78: , p6_a29 out nocopy JTF_NUMBER_TABLE
79: , p6_a30 out nocopy JTF_DATE_TABLE
80: , p6_a31 out nocopy JTF_NUMBER_TABLE
81: , p6_a32 out nocopy JTF_DATE_TABLE

Line 78: , p6_a29 out nocopy JTF_NUMBER_TABLE

74: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
75: , p6_a26 out nocopy JTF_NUMBER_TABLE
76: , p6_a27 out nocopy JTF_NUMBER_TABLE
77: , p6_a28 out nocopy JTF_NUMBER_TABLE
78: , p6_a29 out nocopy JTF_NUMBER_TABLE
79: , p6_a30 out nocopy JTF_DATE_TABLE
80: , p6_a31 out nocopy JTF_NUMBER_TABLE
81: , p6_a32 out nocopy JTF_DATE_TABLE
82: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 80: , p6_a31 out nocopy JTF_NUMBER_TABLE

76: , p6_a27 out nocopy JTF_NUMBER_TABLE
77: , p6_a28 out nocopy JTF_NUMBER_TABLE
78: , p6_a29 out nocopy JTF_NUMBER_TABLE
79: , p6_a30 out nocopy JTF_DATE_TABLE
80: , p6_a31 out nocopy JTF_NUMBER_TABLE
81: , p6_a32 out nocopy JTF_DATE_TABLE
82: , p6_a33 out nocopy JTF_NUMBER_TABLE
83: , p6_a34 out nocopy JTF_NUMBER_TABLE
84: , p6_a35 out nocopy JTF_DATE_TABLE

Line 82: , p6_a33 out nocopy JTF_NUMBER_TABLE

78: , p6_a29 out nocopy JTF_NUMBER_TABLE
79: , p6_a30 out nocopy JTF_DATE_TABLE
80: , p6_a31 out nocopy JTF_NUMBER_TABLE
81: , p6_a32 out nocopy JTF_DATE_TABLE
82: , p6_a33 out nocopy JTF_NUMBER_TABLE
83: , p6_a34 out nocopy JTF_NUMBER_TABLE
84: , p6_a35 out nocopy JTF_DATE_TABLE
85: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
86: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100

Line 83: , p6_a34 out nocopy JTF_NUMBER_TABLE

79: , p6_a30 out nocopy JTF_DATE_TABLE
80: , p6_a31 out nocopy JTF_NUMBER_TABLE
81: , p6_a32 out nocopy JTF_DATE_TABLE
82: , p6_a33 out nocopy JTF_NUMBER_TABLE
83: , p6_a34 out nocopy JTF_NUMBER_TABLE
84: , p6_a35 out nocopy JTF_DATE_TABLE
85: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
86: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
87: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

Line 88: , p6_a39 out nocopy JTF_NUMBER_TABLE

84: , p6_a35 out nocopy JTF_DATE_TABLE
85: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
86: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
87: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
88: , p6_a39 out nocopy JTF_NUMBER_TABLE
89: , p6_a40 out nocopy JTF_DATE_TABLE
90: );
91: procedure insert_relocate_assets(p_api_version NUMBER
92: , p_init_msg_list VARCHAR2

Line 184: , p5_a0 JTF_NUMBER_TABLE

180: , p_init_msg_list VARCHAR2
181: , x_return_status out nocopy VARCHAR2
182: , x_msg_count out nocopy NUMBER
183: , x_msg_data out nocopy VARCHAR2
184: , p5_a0 JTF_NUMBER_TABLE
185: , p5_a1 JTF_NUMBER_TABLE
186: , p5_a2 JTF_VARCHAR2_TABLE_100
187: , p5_a3 JTF_NUMBER_TABLE
188: , p5_a4 JTF_NUMBER_TABLE

Line 185: , p5_a1 JTF_NUMBER_TABLE

181: , x_return_status out nocopy VARCHAR2
182: , x_msg_count out nocopy NUMBER
183: , x_msg_data out nocopy VARCHAR2
184: , p5_a0 JTF_NUMBER_TABLE
185: , p5_a1 JTF_NUMBER_TABLE
186: , p5_a2 JTF_VARCHAR2_TABLE_100
187: , p5_a3 JTF_NUMBER_TABLE
188: , p5_a4 JTF_NUMBER_TABLE
189: , p5_a5 JTF_NUMBER_TABLE

Line 187: , p5_a3 JTF_NUMBER_TABLE

183: , x_msg_data out nocopy VARCHAR2
184: , p5_a0 JTF_NUMBER_TABLE
185: , p5_a1 JTF_NUMBER_TABLE
186: , p5_a2 JTF_VARCHAR2_TABLE_100
187: , p5_a3 JTF_NUMBER_TABLE
188: , p5_a4 JTF_NUMBER_TABLE
189: , p5_a5 JTF_NUMBER_TABLE
190: , p5_a6 JTF_DATE_TABLE
191: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 188: , p5_a4 JTF_NUMBER_TABLE

184: , p5_a0 JTF_NUMBER_TABLE
185: , p5_a1 JTF_NUMBER_TABLE
186: , p5_a2 JTF_VARCHAR2_TABLE_100
187: , p5_a3 JTF_NUMBER_TABLE
188: , p5_a4 JTF_NUMBER_TABLE
189: , p5_a5 JTF_NUMBER_TABLE
190: , p5_a6 JTF_DATE_TABLE
191: , p5_a7 JTF_VARCHAR2_TABLE_2000
192: , p5_a8 JTF_VARCHAR2_TABLE_300

Line 189: , p5_a5 JTF_NUMBER_TABLE

185: , p5_a1 JTF_NUMBER_TABLE
186: , p5_a2 JTF_VARCHAR2_TABLE_100
187: , p5_a3 JTF_NUMBER_TABLE
188: , p5_a4 JTF_NUMBER_TABLE
189: , p5_a5 JTF_NUMBER_TABLE
190: , p5_a6 JTF_DATE_TABLE
191: , p5_a7 JTF_VARCHAR2_TABLE_2000
192: , p5_a8 JTF_VARCHAR2_TABLE_300
193: , p5_a9 JTF_NUMBER_TABLE

Line 193: , p5_a9 JTF_NUMBER_TABLE

189: , p5_a5 JTF_NUMBER_TABLE
190: , p5_a6 JTF_DATE_TABLE
191: , p5_a7 JTF_VARCHAR2_TABLE_2000
192: , p5_a8 JTF_VARCHAR2_TABLE_300
193: , p5_a9 JTF_NUMBER_TABLE
194: , p5_a10 JTF_VARCHAR2_TABLE_100
195: , p5_a11 JTF_VARCHAR2_TABLE_500
196: , p5_a12 JTF_VARCHAR2_TABLE_500
197: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 210: , p5_a26 JTF_NUMBER_TABLE

206: , p5_a22 JTF_VARCHAR2_TABLE_500
207: , p5_a23 JTF_VARCHAR2_TABLE_500
208: , p5_a24 JTF_VARCHAR2_TABLE_500
209: , p5_a25 JTF_VARCHAR2_TABLE_500
210: , p5_a26 JTF_NUMBER_TABLE
211: , p5_a27 JTF_NUMBER_TABLE
212: , p5_a28 JTF_NUMBER_TABLE
213: , p5_a29 JTF_NUMBER_TABLE
214: , p5_a30 JTF_DATE_TABLE

Line 211: , p5_a27 JTF_NUMBER_TABLE

207: , p5_a23 JTF_VARCHAR2_TABLE_500
208: , p5_a24 JTF_VARCHAR2_TABLE_500
209: , p5_a25 JTF_VARCHAR2_TABLE_500
210: , p5_a26 JTF_NUMBER_TABLE
211: , p5_a27 JTF_NUMBER_TABLE
212: , p5_a28 JTF_NUMBER_TABLE
213: , p5_a29 JTF_NUMBER_TABLE
214: , p5_a30 JTF_DATE_TABLE
215: , p5_a31 JTF_NUMBER_TABLE

Line 212: , p5_a28 JTF_NUMBER_TABLE

208: , p5_a24 JTF_VARCHAR2_TABLE_500
209: , p5_a25 JTF_VARCHAR2_TABLE_500
210: , p5_a26 JTF_NUMBER_TABLE
211: , p5_a27 JTF_NUMBER_TABLE
212: , p5_a28 JTF_NUMBER_TABLE
213: , p5_a29 JTF_NUMBER_TABLE
214: , p5_a30 JTF_DATE_TABLE
215: , p5_a31 JTF_NUMBER_TABLE
216: , p5_a32 JTF_DATE_TABLE

Line 213: , p5_a29 JTF_NUMBER_TABLE

209: , p5_a25 JTF_VARCHAR2_TABLE_500
210: , p5_a26 JTF_NUMBER_TABLE
211: , p5_a27 JTF_NUMBER_TABLE
212: , p5_a28 JTF_NUMBER_TABLE
213: , p5_a29 JTF_NUMBER_TABLE
214: , p5_a30 JTF_DATE_TABLE
215: , p5_a31 JTF_NUMBER_TABLE
216: , p5_a32 JTF_DATE_TABLE
217: , p5_a33 JTF_NUMBER_TABLE

Line 215: , p5_a31 JTF_NUMBER_TABLE

211: , p5_a27 JTF_NUMBER_TABLE
212: , p5_a28 JTF_NUMBER_TABLE
213: , p5_a29 JTF_NUMBER_TABLE
214: , p5_a30 JTF_DATE_TABLE
215: , p5_a31 JTF_NUMBER_TABLE
216: , p5_a32 JTF_DATE_TABLE
217: , p5_a33 JTF_NUMBER_TABLE
218: , p5_a34 JTF_NUMBER_TABLE
219: , p5_a35 JTF_DATE_TABLE

Line 217: , p5_a33 JTF_NUMBER_TABLE

213: , p5_a29 JTF_NUMBER_TABLE
214: , p5_a30 JTF_DATE_TABLE
215: , p5_a31 JTF_NUMBER_TABLE
216: , p5_a32 JTF_DATE_TABLE
217: , p5_a33 JTF_NUMBER_TABLE
218: , p5_a34 JTF_NUMBER_TABLE
219: , p5_a35 JTF_DATE_TABLE
220: , p5_a36 JTF_VARCHAR2_TABLE_100
221: , p5_a37 JTF_VARCHAR2_TABLE_100

Line 218: , p5_a34 JTF_NUMBER_TABLE

214: , p5_a30 JTF_DATE_TABLE
215: , p5_a31 JTF_NUMBER_TABLE
216: , p5_a32 JTF_DATE_TABLE
217: , p5_a33 JTF_NUMBER_TABLE
218: , p5_a34 JTF_NUMBER_TABLE
219: , p5_a35 JTF_DATE_TABLE
220: , p5_a36 JTF_VARCHAR2_TABLE_100
221: , p5_a37 JTF_VARCHAR2_TABLE_100
222: , p5_a38 JTF_VARCHAR2_TABLE_100

Line 223: , p5_a39 JTF_NUMBER_TABLE

219: , p5_a35 JTF_DATE_TABLE
220: , p5_a36 JTF_VARCHAR2_TABLE_100
221: , p5_a37 JTF_VARCHAR2_TABLE_100
222: , p5_a38 JTF_VARCHAR2_TABLE_100
223: , p5_a39 JTF_NUMBER_TABLE
224: , p5_a40 JTF_DATE_TABLE
225: );
226: procedure lock_relocate_assets(p_api_version NUMBER
227: , p_init_msg_list VARCHAR2

Line 278: , p5_a0 JTF_NUMBER_TABLE

274: , p_init_msg_list VARCHAR2
275: , x_return_status out nocopy VARCHAR2
276: , x_msg_count out nocopy NUMBER
277: , x_msg_data out nocopy VARCHAR2
278: , p5_a0 JTF_NUMBER_TABLE
279: , p5_a1 JTF_NUMBER_TABLE
280: , p5_a2 JTF_VARCHAR2_TABLE_100
281: , p5_a3 JTF_NUMBER_TABLE
282: , p5_a4 JTF_NUMBER_TABLE

Line 279: , p5_a1 JTF_NUMBER_TABLE

275: , x_return_status out nocopy VARCHAR2
276: , x_msg_count out nocopy NUMBER
277: , x_msg_data out nocopy VARCHAR2
278: , p5_a0 JTF_NUMBER_TABLE
279: , p5_a1 JTF_NUMBER_TABLE
280: , p5_a2 JTF_VARCHAR2_TABLE_100
281: , p5_a3 JTF_NUMBER_TABLE
282: , p5_a4 JTF_NUMBER_TABLE
283: , p5_a5 JTF_NUMBER_TABLE

Line 281: , p5_a3 JTF_NUMBER_TABLE

277: , x_msg_data out nocopy VARCHAR2
278: , p5_a0 JTF_NUMBER_TABLE
279: , p5_a1 JTF_NUMBER_TABLE
280: , p5_a2 JTF_VARCHAR2_TABLE_100
281: , p5_a3 JTF_NUMBER_TABLE
282: , p5_a4 JTF_NUMBER_TABLE
283: , p5_a5 JTF_NUMBER_TABLE
284: , p5_a6 JTF_DATE_TABLE
285: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 282: , p5_a4 JTF_NUMBER_TABLE

278: , p5_a0 JTF_NUMBER_TABLE
279: , p5_a1 JTF_NUMBER_TABLE
280: , p5_a2 JTF_VARCHAR2_TABLE_100
281: , p5_a3 JTF_NUMBER_TABLE
282: , p5_a4 JTF_NUMBER_TABLE
283: , p5_a5 JTF_NUMBER_TABLE
284: , p5_a6 JTF_DATE_TABLE
285: , p5_a7 JTF_VARCHAR2_TABLE_2000
286: , p5_a8 JTF_VARCHAR2_TABLE_300

Line 283: , p5_a5 JTF_NUMBER_TABLE

279: , p5_a1 JTF_NUMBER_TABLE
280: , p5_a2 JTF_VARCHAR2_TABLE_100
281: , p5_a3 JTF_NUMBER_TABLE
282: , p5_a4 JTF_NUMBER_TABLE
283: , p5_a5 JTF_NUMBER_TABLE
284: , p5_a6 JTF_DATE_TABLE
285: , p5_a7 JTF_VARCHAR2_TABLE_2000
286: , p5_a8 JTF_VARCHAR2_TABLE_300
287: , p5_a9 JTF_NUMBER_TABLE

Line 287: , p5_a9 JTF_NUMBER_TABLE

283: , p5_a5 JTF_NUMBER_TABLE
284: , p5_a6 JTF_DATE_TABLE
285: , p5_a7 JTF_VARCHAR2_TABLE_2000
286: , p5_a8 JTF_VARCHAR2_TABLE_300
287: , p5_a9 JTF_NUMBER_TABLE
288: , p5_a10 JTF_VARCHAR2_TABLE_100
289: , p5_a11 JTF_VARCHAR2_TABLE_500
290: , p5_a12 JTF_VARCHAR2_TABLE_500
291: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 304: , p5_a26 JTF_NUMBER_TABLE

300: , p5_a22 JTF_VARCHAR2_TABLE_500
301: , p5_a23 JTF_VARCHAR2_TABLE_500
302: , p5_a24 JTF_VARCHAR2_TABLE_500
303: , p5_a25 JTF_VARCHAR2_TABLE_500
304: , p5_a26 JTF_NUMBER_TABLE
305: , p5_a27 JTF_NUMBER_TABLE
306: , p5_a28 JTF_NUMBER_TABLE
307: , p5_a29 JTF_NUMBER_TABLE
308: , p5_a30 JTF_DATE_TABLE

Line 305: , p5_a27 JTF_NUMBER_TABLE

301: , p5_a23 JTF_VARCHAR2_TABLE_500
302: , p5_a24 JTF_VARCHAR2_TABLE_500
303: , p5_a25 JTF_VARCHAR2_TABLE_500
304: , p5_a26 JTF_NUMBER_TABLE
305: , p5_a27 JTF_NUMBER_TABLE
306: , p5_a28 JTF_NUMBER_TABLE
307: , p5_a29 JTF_NUMBER_TABLE
308: , p5_a30 JTF_DATE_TABLE
309: , p5_a31 JTF_NUMBER_TABLE

Line 306: , p5_a28 JTF_NUMBER_TABLE

302: , p5_a24 JTF_VARCHAR2_TABLE_500
303: , p5_a25 JTF_VARCHAR2_TABLE_500
304: , p5_a26 JTF_NUMBER_TABLE
305: , p5_a27 JTF_NUMBER_TABLE
306: , p5_a28 JTF_NUMBER_TABLE
307: , p5_a29 JTF_NUMBER_TABLE
308: , p5_a30 JTF_DATE_TABLE
309: , p5_a31 JTF_NUMBER_TABLE
310: , p5_a32 JTF_DATE_TABLE

Line 307: , p5_a29 JTF_NUMBER_TABLE

303: , p5_a25 JTF_VARCHAR2_TABLE_500
304: , p5_a26 JTF_NUMBER_TABLE
305: , p5_a27 JTF_NUMBER_TABLE
306: , p5_a28 JTF_NUMBER_TABLE
307: , p5_a29 JTF_NUMBER_TABLE
308: , p5_a30 JTF_DATE_TABLE
309: , p5_a31 JTF_NUMBER_TABLE
310: , p5_a32 JTF_DATE_TABLE
311: , p5_a33 JTF_NUMBER_TABLE

Line 309: , p5_a31 JTF_NUMBER_TABLE

305: , p5_a27 JTF_NUMBER_TABLE
306: , p5_a28 JTF_NUMBER_TABLE
307: , p5_a29 JTF_NUMBER_TABLE
308: , p5_a30 JTF_DATE_TABLE
309: , p5_a31 JTF_NUMBER_TABLE
310: , p5_a32 JTF_DATE_TABLE
311: , p5_a33 JTF_NUMBER_TABLE
312: , p5_a34 JTF_NUMBER_TABLE
313: , p5_a35 JTF_DATE_TABLE

Line 311: , p5_a33 JTF_NUMBER_TABLE

307: , p5_a29 JTF_NUMBER_TABLE
308: , p5_a30 JTF_DATE_TABLE
309: , p5_a31 JTF_NUMBER_TABLE
310: , p5_a32 JTF_DATE_TABLE
311: , p5_a33 JTF_NUMBER_TABLE
312: , p5_a34 JTF_NUMBER_TABLE
313: , p5_a35 JTF_DATE_TABLE
314: , p5_a36 JTF_VARCHAR2_TABLE_100
315: , p5_a37 JTF_VARCHAR2_TABLE_100

Line 312: , p5_a34 JTF_NUMBER_TABLE

308: , p5_a30 JTF_DATE_TABLE
309: , p5_a31 JTF_NUMBER_TABLE
310: , p5_a32 JTF_DATE_TABLE
311: , p5_a33 JTF_NUMBER_TABLE
312: , p5_a34 JTF_NUMBER_TABLE
313: , p5_a35 JTF_DATE_TABLE
314: , p5_a36 JTF_VARCHAR2_TABLE_100
315: , p5_a37 JTF_VARCHAR2_TABLE_100
316: , p5_a38 JTF_VARCHAR2_TABLE_100

Line 317: , p5_a39 JTF_NUMBER_TABLE

313: , p5_a35 JTF_DATE_TABLE
314: , p5_a36 JTF_VARCHAR2_TABLE_100
315: , p5_a37 JTF_VARCHAR2_TABLE_100
316: , p5_a38 JTF_VARCHAR2_TABLE_100
317: , p5_a39 JTF_NUMBER_TABLE
318: , p5_a40 JTF_DATE_TABLE
319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100

Line 319: , p6_a0 out nocopy JTF_NUMBER_TABLE

315: , p5_a37 JTF_VARCHAR2_TABLE_100
316: , p5_a38 JTF_VARCHAR2_TABLE_100
317: , p5_a39 JTF_NUMBER_TABLE
318: , p5_a40 JTF_DATE_TABLE
319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE
323: , p6_a4 out nocopy JTF_NUMBER_TABLE

Line 320: , p6_a1 out nocopy JTF_NUMBER_TABLE

316: , p5_a38 JTF_VARCHAR2_TABLE_100
317: , p5_a39 JTF_NUMBER_TABLE
318: , p5_a40 JTF_DATE_TABLE
319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE
323: , p6_a4 out nocopy JTF_NUMBER_TABLE
324: , p6_a5 out nocopy JTF_NUMBER_TABLE

Line 322: , p6_a3 out nocopy JTF_NUMBER_TABLE

318: , p5_a40 JTF_DATE_TABLE
319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE
323: , p6_a4 out nocopy JTF_NUMBER_TABLE
324: , p6_a5 out nocopy JTF_NUMBER_TABLE
325: , p6_a6 out nocopy JTF_DATE_TABLE
326: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000

Line 323: , p6_a4 out nocopy JTF_NUMBER_TABLE

319: , p6_a0 out nocopy JTF_NUMBER_TABLE
320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE
323: , p6_a4 out nocopy JTF_NUMBER_TABLE
324: , p6_a5 out nocopy JTF_NUMBER_TABLE
325: , p6_a6 out nocopy JTF_DATE_TABLE
326: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
327: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300

Line 324: , p6_a5 out nocopy JTF_NUMBER_TABLE

320: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a3 out nocopy JTF_NUMBER_TABLE
323: , p6_a4 out nocopy JTF_NUMBER_TABLE
324: , p6_a5 out nocopy JTF_NUMBER_TABLE
325: , p6_a6 out nocopy JTF_DATE_TABLE
326: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
327: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
328: , p6_a9 out nocopy JTF_NUMBER_TABLE

Line 328: , p6_a9 out nocopy JTF_NUMBER_TABLE

324: , p6_a5 out nocopy JTF_NUMBER_TABLE
325: , p6_a6 out nocopy JTF_DATE_TABLE
326: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
327: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_300
328: , p6_a9 out nocopy JTF_NUMBER_TABLE
329: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
330: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
331: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
332: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500

Line 345: , p6_a26 out nocopy JTF_NUMBER_TABLE

341: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
342: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
343: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
344: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
345: , p6_a26 out nocopy JTF_NUMBER_TABLE
346: , p6_a27 out nocopy JTF_NUMBER_TABLE
347: , p6_a28 out nocopy JTF_NUMBER_TABLE
348: , p6_a29 out nocopy JTF_NUMBER_TABLE
349: , p6_a30 out nocopy JTF_DATE_TABLE

Line 346: , p6_a27 out nocopy JTF_NUMBER_TABLE

342: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
343: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
344: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
345: , p6_a26 out nocopy JTF_NUMBER_TABLE
346: , p6_a27 out nocopy JTF_NUMBER_TABLE
347: , p6_a28 out nocopy JTF_NUMBER_TABLE
348: , p6_a29 out nocopy JTF_NUMBER_TABLE
349: , p6_a30 out nocopy JTF_DATE_TABLE
350: , p6_a31 out nocopy JTF_NUMBER_TABLE

Line 347: , p6_a28 out nocopy JTF_NUMBER_TABLE

343: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
344: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
345: , p6_a26 out nocopy JTF_NUMBER_TABLE
346: , p6_a27 out nocopy JTF_NUMBER_TABLE
347: , p6_a28 out nocopy JTF_NUMBER_TABLE
348: , p6_a29 out nocopy JTF_NUMBER_TABLE
349: , p6_a30 out nocopy JTF_DATE_TABLE
350: , p6_a31 out nocopy JTF_NUMBER_TABLE
351: , p6_a32 out nocopy JTF_DATE_TABLE

Line 348: , p6_a29 out nocopy JTF_NUMBER_TABLE

344: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
345: , p6_a26 out nocopy JTF_NUMBER_TABLE
346: , p6_a27 out nocopy JTF_NUMBER_TABLE
347: , p6_a28 out nocopy JTF_NUMBER_TABLE
348: , p6_a29 out nocopy JTF_NUMBER_TABLE
349: , p6_a30 out nocopy JTF_DATE_TABLE
350: , p6_a31 out nocopy JTF_NUMBER_TABLE
351: , p6_a32 out nocopy JTF_DATE_TABLE
352: , p6_a33 out nocopy JTF_NUMBER_TABLE

Line 350: , p6_a31 out nocopy JTF_NUMBER_TABLE

346: , p6_a27 out nocopy JTF_NUMBER_TABLE
347: , p6_a28 out nocopy JTF_NUMBER_TABLE
348: , p6_a29 out nocopy JTF_NUMBER_TABLE
349: , p6_a30 out nocopy JTF_DATE_TABLE
350: , p6_a31 out nocopy JTF_NUMBER_TABLE
351: , p6_a32 out nocopy JTF_DATE_TABLE
352: , p6_a33 out nocopy JTF_NUMBER_TABLE
353: , p6_a34 out nocopy JTF_NUMBER_TABLE
354: , p6_a35 out nocopy JTF_DATE_TABLE

Line 352: , p6_a33 out nocopy JTF_NUMBER_TABLE

348: , p6_a29 out nocopy JTF_NUMBER_TABLE
349: , p6_a30 out nocopy JTF_DATE_TABLE
350: , p6_a31 out nocopy JTF_NUMBER_TABLE
351: , p6_a32 out nocopy JTF_DATE_TABLE
352: , p6_a33 out nocopy JTF_NUMBER_TABLE
353: , p6_a34 out nocopy JTF_NUMBER_TABLE
354: , p6_a35 out nocopy JTF_DATE_TABLE
355: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
356: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100

Line 353: , p6_a34 out nocopy JTF_NUMBER_TABLE

349: , p6_a30 out nocopy JTF_DATE_TABLE
350: , p6_a31 out nocopy JTF_NUMBER_TABLE
351: , p6_a32 out nocopy JTF_DATE_TABLE
352: , p6_a33 out nocopy JTF_NUMBER_TABLE
353: , p6_a34 out nocopy JTF_NUMBER_TABLE
354: , p6_a35 out nocopy JTF_DATE_TABLE
355: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
356: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
357: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100

Line 358: , p6_a39 out nocopy JTF_NUMBER_TABLE

354: , p6_a35 out nocopy JTF_DATE_TABLE
355: , p6_a36 out nocopy JTF_VARCHAR2_TABLE_100
356: , p6_a37 out nocopy JTF_VARCHAR2_TABLE_100
357: , p6_a38 out nocopy JTF_VARCHAR2_TABLE_100
358: , p6_a39 out nocopy JTF_NUMBER_TABLE
359: , p6_a40 out nocopy JTF_DATE_TABLE
360: );
361: procedure update_relocate_assets(p_api_version NUMBER
362: , p_init_msg_list VARCHAR2

Line 454: , p5_a0 JTF_NUMBER_TABLE

450: , p_init_msg_list VARCHAR2
451: , x_return_status out nocopy VARCHAR2
452: , x_msg_count out nocopy NUMBER
453: , x_msg_data out nocopy VARCHAR2
454: , p5_a0 JTF_NUMBER_TABLE
455: , p5_a1 JTF_NUMBER_TABLE
456: , p5_a2 JTF_VARCHAR2_TABLE_100
457: , p5_a3 JTF_NUMBER_TABLE
458: , p5_a4 JTF_NUMBER_TABLE

Line 455: , p5_a1 JTF_NUMBER_TABLE

451: , x_return_status out nocopy VARCHAR2
452: , x_msg_count out nocopy NUMBER
453: , x_msg_data out nocopy VARCHAR2
454: , p5_a0 JTF_NUMBER_TABLE
455: , p5_a1 JTF_NUMBER_TABLE
456: , p5_a2 JTF_VARCHAR2_TABLE_100
457: , p5_a3 JTF_NUMBER_TABLE
458: , p5_a4 JTF_NUMBER_TABLE
459: , p5_a5 JTF_NUMBER_TABLE

Line 457: , p5_a3 JTF_NUMBER_TABLE

453: , x_msg_data out nocopy VARCHAR2
454: , p5_a0 JTF_NUMBER_TABLE
455: , p5_a1 JTF_NUMBER_TABLE
456: , p5_a2 JTF_VARCHAR2_TABLE_100
457: , p5_a3 JTF_NUMBER_TABLE
458: , p5_a4 JTF_NUMBER_TABLE
459: , p5_a5 JTF_NUMBER_TABLE
460: , p5_a6 JTF_DATE_TABLE
461: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 458: , p5_a4 JTF_NUMBER_TABLE

454: , p5_a0 JTF_NUMBER_TABLE
455: , p5_a1 JTF_NUMBER_TABLE
456: , p5_a2 JTF_VARCHAR2_TABLE_100
457: , p5_a3 JTF_NUMBER_TABLE
458: , p5_a4 JTF_NUMBER_TABLE
459: , p5_a5 JTF_NUMBER_TABLE
460: , p5_a6 JTF_DATE_TABLE
461: , p5_a7 JTF_VARCHAR2_TABLE_2000
462: , p5_a8 JTF_VARCHAR2_TABLE_300

Line 459: , p5_a5 JTF_NUMBER_TABLE

455: , p5_a1 JTF_NUMBER_TABLE
456: , p5_a2 JTF_VARCHAR2_TABLE_100
457: , p5_a3 JTF_NUMBER_TABLE
458: , p5_a4 JTF_NUMBER_TABLE
459: , p5_a5 JTF_NUMBER_TABLE
460: , p5_a6 JTF_DATE_TABLE
461: , p5_a7 JTF_VARCHAR2_TABLE_2000
462: , p5_a8 JTF_VARCHAR2_TABLE_300
463: , p5_a9 JTF_NUMBER_TABLE

Line 463: , p5_a9 JTF_NUMBER_TABLE

459: , p5_a5 JTF_NUMBER_TABLE
460: , p5_a6 JTF_DATE_TABLE
461: , p5_a7 JTF_VARCHAR2_TABLE_2000
462: , p5_a8 JTF_VARCHAR2_TABLE_300
463: , p5_a9 JTF_NUMBER_TABLE
464: , p5_a10 JTF_VARCHAR2_TABLE_100
465: , p5_a11 JTF_VARCHAR2_TABLE_500
466: , p5_a12 JTF_VARCHAR2_TABLE_500
467: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 480: , p5_a26 JTF_NUMBER_TABLE

476: , p5_a22 JTF_VARCHAR2_TABLE_500
477: , p5_a23 JTF_VARCHAR2_TABLE_500
478: , p5_a24 JTF_VARCHAR2_TABLE_500
479: , p5_a25 JTF_VARCHAR2_TABLE_500
480: , p5_a26 JTF_NUMBER_TABLE
481: , p5_a27 JTF_NUMBER_TABLE
482: , p5_a28 JTF_NUMBER_TABLE
483: , p5_a29 JTF_NUMBER_TABLE
484: , p5_a30 JTF_DATE_TABLE

Line 481: , p5_a27 JTF_NUMBER_TABLE

477: , p5_a23 JTF_VARCHAR2_TABLE_500
478: , p5_a24 JTF_VARCHAR2_TABLE_500
479: , p5_a25 JTF_VARCHAR2_TABLE_500
480: , p5_a26 JTF_NUMBER_TABLE
481: , p5_a27 JTF_NUMBER_TABLE
482: , p5_a28 JTF_NUMBER_TABLE
483: , p5_a29 JTF_NUMBER_TABLE
484: , p5_a30 JTF_DATE_TABLE
485: , p5_a31 JTF_NUMBER_TABLE

Line 482: , p5_a28 JTF_NUMBER_TABLE

478: , p5_a24 JTF_VARCHAR2_TABLE_500
479: , p5_a25 JTF_VARCHAR2_TABLE_500
480: , p5_a26 JTF_NUMBER_TABLE
481: , p5_a27 JTF_NUMBER_TABLE
482: , p5_a28 JTF_NUMBER_TABLE
483: , p5_a29 JTF_NUMBER_TABLE
484: , p5_a30 JTF_DATE_TABLE
485: , p5_a31 JTF_NUMBER_TABLE
486: , p5_a32 JTF_DATE_TABLE

Line 483: , p5_a29 JTF_NUMBER_TABLE

479: , p5_a25 JTF_VARCHAR2_TABLE_500
480: , p5_a26 JTF_NUMBER_TABLE
481: , p5_a27 JTF_NUMBER_TABLE
482: , p5_a28 JTF_NUMBER_TABLE
483: , p5_a29 JTF_NUMBER_TABLE
484: , p5_a30 JTF_DATE_TABLE
485: , p5_a31 JTF_NUMBER_TABLE
486: , p5_a32 JTF_DATE_TABLE
487: , p5_a33 JTF_NUMBER_TABLE

Line 485: , p5_a31 JTF_NUMBER_TABLE

481: , p5_a27 JTF_NUMBER_TABLE
482: , p5_a28 JTF_NUMBER_TABLE
483: , p5_a29 JTF_NUMBER_TABLE
484: , p5_a30 JTF_DATE_TABLE
485: , p5_a31 JTF_NUMBER_TABLE
486: , p5_a32 JTF_DATE_TABLE
487: , p5_a33 JTF_NUMBER_TABLE
488: , p5_a34 JTF_NUMBER_TABLE
489: , p5_a35 JTF_DATE_TABLE

Line 487: , p5_a33 JTF_NUMBER_TABLE

483: , p5_a29 JTF_NUMBER_TABLE
484: , p5_a30 JTF_DATE_TABLE
485: , p5_a31 JTF_NUMBER_TABLE
486: , p5_a32 JTF_DATE_TABLE
487: , p5_a33 JTF_NUMBER_TABLE
488: , p5_a34 JTF_NUMBER_TABLE
489: , p5_a35 JTF_DATE_TABLE
490: , p5_a36 JTF_VARCHAR2_TABLE_100
491: , p5_a37 JTF_VARCHAR2_TABLE_100

Line 488: , p5_a34 JTF_NUMBER_TABLE

484: , p5_a30 JTF_DATE_TABLE
485: , p5_a31 JTF_NUMBER_TABLE
486: , p5_a32 JTF_DATE_TABLE
487: , p5_a33 JTF_NUMBER_TABLE
488: , p5_a34 JTF_NUMBER_TABLE
489: , p5_a35 JTF_DATE_TABLE
490: , p5_a36 JTF_VARCHAR2_TABLE_100
491: , p5_a37 JTF_VARCHAR2_TABLE_100
492: , p5_a38 JTF_VARCHAR2_TABLE_100

Line 493: , p5_a39 JTF_NUMBER_TABLE

489: , p5_a35 JTF_DATE_TABLE
490: , p5_a36 JTF_VARCHAR2_TABLE_100
491: , p5_a37 JTF_VARCHAR2_TABLE_100
492: , p5_a38 JTF_VARCHAR2_TABLE_100
493: , p5_a39 JTF_NUMBER_TABLE
494: , p5_a40 JTF_DATE_TABLE
495: );
496: procedure delete_relocate_assets(p_api_version NUMBER
497: , p_init_msg_list VARCHAR2

Line 548: , p5_a0 JTF_NUMBER_TABLE

544: , p_init_msg_list VARCHAR2
545: , x_return_status out nocopy VARCHAR2
546: , x_msg_count out nocopy NUMBER
547: , x_msg_data out nocopy VARCHAR2
548: , p5_a0 JTF_NUMBER_TABLE
549: , p5_a1 JTF_NUMBER_TABLE
550: , p5_a2 JTF_VARCHAR2_TABLE_100
551: , p5_a3 JTF_NUMBER_TABLE
552: , p5_a4 JTF_NUMBER_TABLE

Line 549: , p5_a1 JTF_NUMBER_TABLE

545: , x_return_status out nocopy VARCHAR2
546: , x_msg_count out nocopy NUMBER
547: , x_msg_data out nocopy VARCHAR2
548: , p5_a0 JTF_NUMBER_TABLE
549: , p5_a1 JTF_NUMBER_TABLE
550: , p5_a2 JTF_VARCHAR2_TABLE_100
551: , p5_a3 JTF_NUMBER_TABLE
552: , p5_a4 JTF_NUMBER_TABLE
553: , p5_a5 JTF_NUMBER_TABLE

Line 551: , p5_a3 JTF_NUMBER_TABLE

547: , x_msg_data out nocopy VARCHAR2
548: , p5_a0 JTF_NUMBER_TABLE
549: , p5_a1 JTF_NUMBER_TABLE
550: , p5_a2 JTF_VARCHAR2_TABLE_100
551: , p5_a3 JTF_NUMBER_TABLE
552: , p5_a4 JTF_NUMBER_TABLE
553: , p5_a5 JTF_NUMBER_TABLE
554: , p5_a6 JTF_DATE_TABLE
555: , p5_a7 JTF_VARCHAR2_TABLE_2000

Line 552: , p5_a4 JTF_NUMBER_TABLE

548: , p5_a0 JTF_NUMBER_TABLE
549: , p5_a1 JTF_NUMBER_TABLE
550: , p5_a2 JTF_VARCHAR2_TABLE_100
551: , p5_a3 JTF_NUMBER_TABLE
552: , p5_a4 JTF_NUMBER_TABLE
553: , p5_a5 JTF_NUMBER_TABLE
554: , p5_a6 JTF_DATE_TABLE
555: , p5_a7 JTF_VARCHAR2_TABLE_2000
556: , p5_a8 JTF_VARCHAR2_TABLE_300

Line 553: , p5_a5 JTF_NUMBER_TABLE

549: , p5_a1 JTF_NUMBER_TABLE
550: , p5_a2 JTF_VARCHAR2_TABLE_100
551: , p5_a3 JTF_NUMBER_TABLE
552: , p5_a4 JTF_NUMBER_TABLE
553: , p5_a5 JTF_NUMBER_TABLE
554: , p5_a6 JTF_DATE_TABLE
555: , p5_a7 JTF_VARCHAR2_TABLE_2000
556: , p5_a8 JTF_VARCHAR2_TABLE_300
557: , p5_a9 JTF_NUMBER_TABLE

Line 557: , p5_a9 JTF_NUMBER_TABLE

553: , p5_a5 JTF_NUMBER_TABLE
554: , p5_a6 JTF_DATE_TABLE
555: , p5_a7 JTF_VARCHAR2_TABLE_2000
556: , p5_a8 JTF_VARCHAR2_TABLE_300
557: , p5_a9 JTF_NUMBER_TABLE
558: , p5_a10 JTF_VARCHAR2_TABLE_100
559: , p5_a11 JTF_VARCHAR2_TABLE_500
560: , p5_a12 JTF_VARCHAR2_TABLE_500
561: , p5_a13 JTF_VARCHAR2_TABLE_500

Line 574: , p5_a26 JTF_NUMBER_TABLE

570: , p5_a22 JTF_VARCHAR2_TABLE_500
571: , p5_a23 JTF_VARCHAR2_TABLE_500
572: , p5_a24 JTF_VARCHAR2_TABLE_500
573: , p5_a25 JTF_VARCHAR2_TABLE_500
574: , p5_a26 JTF_NUMBER_TABLE
575: , p5_a27 JTF_NUMBER_TABLE
576: , p5_a28 JTF_NUMBER_TABLE
577: , p5_a29 JTF_NUMBER_TABLE
578: , p5_a30 JTF_DATE_TABLE

Line 575: , p5_a27 JTF_NUMBER_TABLE

571: , p5_a23 JTF_VARCHAR2_TABLE_500
572: , p5_a24 JTF_VARCHAR2_TABLE_500
573: , p5_a25 JTF_VARCHAR2_TABLE_500
574: , p5_a26 JTF_NUMBER_TABLE
575: , p5_a27 JTF_NUMBER_TABLE
576: , p5_a28 JTF_NUMBER_TABLE
577: , p5_a29 JTF_NUMBER_TABLE
578: , p5_a30 JTF_DATE_TABLE
579: , p5_a31 JTF_NUMBER_TABLE

Line 576: , p5_a28 JTF_NUMBER_TABLE

572: , p5_a24 JTF_VARCHAR2_TABLE_500
573: , p5_a25 JTF_VARCHAR2_TABLE_500
574: , p5_a26 JTF_NUMBER_TABLE
575: , p5_a27 JTF_NUMBER_TABLE
576: , p5_a28 JTF_NUMBER_TABLE
577: , p5_a29 JTF_NUMBER_TABLE
578: , p5_a30 JTF_DATE_TABLE
579: , p5_a31 JTF_NUMBER_TABLE
580: , p5_a32 JTF_DATE_TABLE

Line 577: , p5_a29 JTF_NUMBER_TABLE

573: , p5_a25 JTF_VARCHAR2_TABLE_500
574: , p5_a26 JTF_NUMBER_TABLE
575: , p5_a27 JTF_NUMBER_TABLE
576: , p5_a28 JTF_NUMBER_TABLE
577: , p5_a29 JTF_NUMBER_TABLE
578: , p5_a30 JTF_DATE_TABLE
579: , p5_a31 JTF_NUMBER_TABLE
580: , p5_a32 JTF_DATE_TABLE
581: , p5_a33 JTF_NUMBER_TABLE

Line 579: , p5_a31 JTF_NUMBER_TABLE

575: , p5_a27 JTF_NUMBER_TABLE
576: , p5_a28 JTF_NUMBER_TABLE
577: , p5_a29 JTF_NUMBER_TABLE
578: , p5_a30 JTF_DATE_TABLE
579: , p5_a31 JTF_NUMBER_TABLE
580: , p5_a32 JTF_DATE_TABLE
581: , p5_a33 JTF_NUMBER_TABLE
582: , p5_a34 JTF_NUMBER_TABLE
583: , p5_a35 JTF_DATE_TABLE

Line 581: , p5_a33 JTF_NUMBER_TABLE

577: , p5_a29 JTF_NUMBER_TABLE
578: , p5_a30 JTF_DATE_TABLE
579: , p5_a31 JTF_NUMBER_TABLE
580: , p5_a32 JTF_DATE_TABLE
581: , p5_a33 JTF_NUMBER_TABLE
582: , p5_a34 JTF_NUMBER_TABLE
583: , p5_a35 JTF_DATE_TABLE
584: , p5_a36 JTF_VARCHAR2_TABLE_100
585: , p5_a37 JTF_VARCHAR2_TABLE_100

Line 582: , p5_a34 JTF_NUMBER_TABLE

578: , p5_a30 JTF_DATE_TABLE
579: , p5_a31 JTF_NUMBER_TABLE
580: , p5_a32 JTF_DATE_TABLE
581: , p5_a33 JTF_NUMBER_TABLE
582: , p5_a34 JTF_NUMBER_TABLE
583: , p5_a35 JTF_DATE_TABLE
584: , p5_a36 JTF_VARCHAR2_TABLE_100
585: , p5_a37 JTF_VARCHAR2_TABLE_100
586: , p5_a38 JTF_VARCHAR2_TABLE_100

Line 587: , p5_a39 JTF_NUMBER_TABLE

583: , p5_a35 JTF_DATE_TABLE
584: , p5_a36 JTF_VARCHAR2_TABLE_100
585: , p5_a37 JTF_VARCHAR2_TABLE_100
586: , p5_a38 JTF_VARCHAR2_TABLE_100
587: , p5_a39 JTF_NUMBER_TABLE
588: , p5_a40 JTF_DATE_TABLE
589: );
590: procedure validate_relocate_assets(p_api_version NUMBER
591: , p_init_msg_list VARCHAR2