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_VARCHAR2_TABLE_100
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_VARCHAR2_TABLE_100
13: , p5_a5 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_VARCHAR2_TABLE_100
13: , p5_a5 JTF_NUMBER_TABLE
14: , p5_a6 JTF_VARCHAR2_TABLE_2000
15: , p5_a7 JTF_VARCHAR2_TABLE_100
9: , p5_a1 JTF_NUMBER_TABLE
10: , p5_a2 JTF_VARCHAR2_TABLE_100
11: , p5_a3 JTF_NUMBER_TABLE
12: , p5_a4 JTF_VARCHAR2_TABLE_100
13: , p5_a5 JTF_NUMBER_TABLE
14: , p5_a6 JTF_VARCHAR2_TABLE_2000
15: , p5_a7 JTF_VARCHAR2_TABLE_100
16: , p5_a8 JTF_VARCHAR2_TABLE_500
17: , p5_a9 JTF_VARCHAR2_TABLE_500
27: , p5_a19 JTF_VARCHAR2_TABLE_500
28: , p5_a20 JTF_VARCHAR2_TABLE_500
29: , p5_a21 JTF_VARCHAR2_TABLE_500
30: , p5_a22 JTF_VARCHAR2_TABLE_500
31: , p5_a23 JTF_NUMBER_TABLE
32: , p5_a24 JTF_NUMBER_TABLE
33: , p5_a25 JTF_NUMBER_TABLE
34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_DATE_TABLE
28: , p5_a20 JTF_VARCHAR2_TABLE_500
29: , p5_a21 JTF_VARCHAR2_TABLE_500
30: , p5_a22 JTF_VARCHAR2_TABLE_500
31: , p5_a23 JTF_NUMBER_TABLE
32: , p5_a24 JTF_NUMBER_TABLE
33: , p5_a25 JTF_NUMBER_TABLE
34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_DATE_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
29: , p5_a21 JTF_VARCHAR2_TABLE_500
30: , p5_a22 JTF_VARCHAR2_TABLE_500
31: , p5_a23 JTF_NUMBER_TABLE
32: , p5_a24 JTF_NUMBER_TABLE
33: , p5_a25 JTF_NUMBER_TABLE
34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_DATE_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_DATE_TABLE
30: , p5_a22 JTF_VARCHAR2_TABLE_500
31: , p5_a23 JTF_NUMBER_TABLE
32: , p5_a24 JTF_NUMBER_TABLE
33: , p5_a25 JTF_NUMBER_TABLE
34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_DATE_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
32: , p5_a24 JTF_NUMBER_TABLE
33: , p5_a25 JTF_NUMBER_TABLE
34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_DATE_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p5_a31 JTF_DATE_TABLE
40: , p5_a32 JTF_NUMBER_TABLE
34: , p5_a26 JTF_NUMBER_TABLE
35: , p5_a27 JTF_DATE_TABLE
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p5_a31 JTF_DATE_TABLE
40: , p5_a32 JTF_NUMBER_TABLE
41: , p5_a33 JTF_VARCHAR2_TABLE_100
42: , p5_a34 JTF_VARCHAR2_TABLE_100
36: , p5_a28 JTF_NUMBER_TABLE
37: , p5_a29 JTF_DATE_TABLE
38: , p5_a30 JTF_NUMBER_TABLE
39: , p5_a31 JTF_DATE_TABLE
40: , p5_a32 JTF_NUMBER_TABLE
41: , p5_a33 JTF_VARCHAR2_TABLE_100
42: , p5_a34 JTF_VARCHAR2_TABLE_100
43: , p5_a35 JTF_VARCHAR2_TABLE_100
44: , p5_a36 JTF_NUMBER_TABLE
40: , p5_a32 JTF_NUMBER_TABLE
41: , p5_a33 JTF_VARCHAR2_TABLE_100
42: , p5_a34 JTF_VARCHAR2_TABLE_100
43: , p5_a35 JTF_VARCHAR2_TABLE_100
44: , p5_a36 JTF_NUMBER_TABLE
45: , p5_a37 JTF_DATE_TABLE
46: , p6_a0 out nocopy JTF_NUMBER_TABLE
47: , p6_a1 out nocopy JTF_NUMBER_TABLE
48: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
42: , p5_a34 JTF_VARCHAR2_TABLE_100
43: , p5_a35 JTF_VARCHAR2_TABLE_100
44: , p5_a36 JTF_NUMBER_TABLE
45: , p5_a37 JTF_DATE_TABLE
46: , p6_a0 out nocopy JTF_NUMBER_TABLE
47: , p6_a1 out nocopy JTF_NUMBER_TABLE
48: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
49: , p6_a3 out nocopy JTF_NUMBER_TABLE
50: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
43: , p5_a35 JTF_VARCHAR2_TABLE_100
44: , p5_a36 JTF_NUMBER_TABLE
45: , p5_a37 JTF_DATE_TABLE
46: , p6_a0 out nocopy JTF_NUMBER_TABLE
47: , p6_a1 out nocopy JTF_NUMBER_TABLE
48: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
49: , p6_a3 out nocopy JTF_NUMBER_TABLE
50: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
51: , p6_a5 out nocopy JTF_NUMBER_TABLE
45: , p5_a37 JTF_DATE_TABLE
46: , p6_a0 out nocopy JTF_NUMBER_TABLE
47: , p6_a1 out nocopy JTF_NUMBER_TABLE
48: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
49: , p6_a3 out nocopy JTF_NUMBER_TABLE
50: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
51: , p6_a5 out nocopy JTF_NUMBER_TABLE
52: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
53: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
47: , p6_a1 out nocopy JTF_NUMBER_TABLE
48: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
49: , p6_a3 out nocopy JTF_NUMBER_TABLE
50: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
51: , p6_a5 out nocopy JTF_NUMBER_TABLE
52: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
53: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
54: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
55: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
65: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
66: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
67: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
68: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
69: , p6_a23 out nocopy JTF_NUMBER_TABLE
70: , p6_a24 out nocopy JTF_NUMBER_TABLE
71: , p6_a25 out nocopy JTF_NUMBER_TABLE
72: , p6_a26 out nocopy JTF_NUMBER_TABLE
73: , p6_a27 out nocopy JTF_DATE_TABLE
66: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
67: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
68: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
69: , p6_a23 out nocopy JTF_NUMBER_TABLE
70: , p6_a24 out nocopy JTF_NUMBER_TABLE
71: , p6_a25 out nocopy JTF_NUMBER_TABLE
72: , p6_a26 out nocopy JTF_NUMBER_TABLE
73: , p6_a27 out nocopy JTF_DATE_TABLE
74: , p6_a28 out nocopy JTF_NUMBER_TABLE
67: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
68: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
69: , p6_a23 out nocopy JTF_NUMBER_TABLE
70: , p6_a24 out nocopy JTF_NUMBER_TABLE
71: , p6_a25 out nocopy JTF_NUMBER_TABLE
72: , p6_a26 out nocopy JTF_NUMBER_TABLE
73: , p6_a27 out nocopy JTF_DATE_TABLE
74: , p6_a28 out nocopy JTF_NUMBER_TABLE
75: , p6_a29 out nocopy JTF_DATE_TABLE
68: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
69: , p6_a23 out nocopy JTF_NUMBER_TABLE
70: , p6_a24 out nocopy JTF_NUMBER_TABLE
71: , p6_a25 out nocopy JTF_NUMBER_TABLE
72: , p6_a26 out nocopy JTF_NUMBER_TABLE
73: , p6_a27 out nocopy JTF_DATE_TABLE
74: , p6_a28 out nocopy JTF_NUMBER_TABLE
75: , p6_a29 out nocopy JTF_DATE_TABLE
76: , p6_a30 out nocopy JTF_NUMBER_TABLE
70: , p6_a24 out nocopy JTF_NUMBER_TABLE
71: , p6_a25 out nocopy JTF_NUMBER_TABLE
72: , p6_a26 out nocopy JTF_NUMBER_TABLE
73: , p6_a27 out nocopy JTF_DATE_TABLE
74: , p6_a28 out nocopy JTF_NUMBER_TABLE
75: , p6_a29 out nocopy JTF_DATE_TABLE
76: , p6_a30 out nocopy JTF_NUMBER_TABLE
77: , p6_a31 out nocopy JTF_DATE_TABLE
78: , p6_a32 out nocopy JTF_NUMBER_TABLE
72: , p6_a26 out nocopy JTF_NUMBER_TABLE
73: , p6_a27 out nocopy JTF_DATE_TABLE
74: , p6_a28 out nocopy JTF_NUMBER_TABLE
75: , p6_a29 out nocopy JTF_DATE_TABLE
76: , p6_a30 out nocopy JTF_NUMBER_TABLE
77: , p6_a31 out nocopy JTF_DATE_TABLE
78: , p6_a32 out nocopy JTF_NUMBER_TABLE
79: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
80: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
74: , p6_a28 out nocopy JTF_NUMBER_TABLE
75: , p6_a29 out nocopy JTF_DATE_TABLE
76: , p6_a30 out nocopy JTF_NUMBER_TABLE
77: , p6_a31 out nocopy JTF_DATE_TABLE
78: , p6_a32 out nocopy JTF_NUMBER_TABLE
79: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
80: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
81: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
82: , p6_a36 out nocopy JTF_NUMBER_TABLE
78: , p6_a32 out nocopy JTF_NUMBER_TABLE
79: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
80: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
81: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
82: , p6_a36 out nocopy JTF_NUMBER_TABLE
83: , p6_a37 out nocopy JTF_DATE_TABLE
84: );
85: procedure insert_remarketing_costs(p_api_version NUMBER
86: , p_init_msg_list VARCHAR2
168: , p_init_msg_list VARCHAR2
169: , x_return_status out nocopy VARCHAR2
170: , x_msg_count out nocopy NUMBER
171: , x_msg_data out nocopy VARCHAR2
172: , p5_a0 JTF_NUMBER_TABLE
173: , p5_a1 JTF_NUMBER_TABLE
174: , p5_a2 JTF_VARCHAR2_TABLE_100
175: , p5_a3 JTF_NUMBER_TABLE
176: , p5_a4 JTF_VARCHAR2_TABLE_100
169: , x_return_status out nocopy VARCHAR2
170: , x_msg_count out nocopy NUMBER
171: , x_msg_data out nocopy VARCHAR2
172: , p5_a0 JTF_NUMBER_TABLE
173: , p5_a1 JTF_NUMBER_TABLE
174: , p5_a2 JTF_VARCHAR2_TABLE_100
175: , p5_a3 JTF_NUMBER_TABLE
176: , p5_a4 JTF_VARCHAR2_TABLE_100
177: , p5_a5 JTF_NUMBER_TABLE
171: , x_msg_data out nocopy VARCHAR2
172: , p5_a0 JTF_NUMBER_TABLE
173: , p5_a1 JTF_NUMBER_TABLE
174: , p5_a2 JTF_VARCHAR2_TABLE_100
175: , p5_a3 JTF_NUMBER_TABLE
176: , p5_a4 JTF_VARCHAR2_TABLE_100
177: , p5_a5 JTF_NUMBER_TABLE
178: , p5_a6 JTF_VARCHAR2_TABLE_2000
179: , p5_a7 JTF_VARCHAR2_TABLE_100
173: , p5_a1 JTF_NUMBER_TABLE
174: , p5_a2 JTF_VARCHAR2_TABLE_100
175: , p5_a3 JTF_NUMBER_TABLE
176: , p5_a4 JTF_VARCHAR2_TABLE_100
177: , p5_a5 JTF_NUMBER_TABLE
178: , p5_a6 JTF_VARCHAR2_TABLE_2000
179: , p5_a7 JTF_VARCHAR2_TABLE_100
180: , p5_a8 JTF_VARCHAR2_TABLE_500
181: , p5_a9 JTF_VARCHAR2_TABLE_500
191: , p5_a19 JTF_VARCHAR2_TABLE_500
192: , p5_a20 JTF_VARCHAR2_TABLE_500
193: , p5_a21 JTF_VARCHAR2_TABLE_500
194: , p5_a22 JTF_VARCHAR2_TABLE_500
195: , p5_a23 JTF_NUMBER_TABLE
196: , p5_a24 JTF_NUMBER_TABLE
197: , p5_a25 JTF_NUMBER_TABLE
198: , p5_a26 JTF_NUMBER_TABLE
199: , p5_a27 JTF_DATE_TABLE
192: , p5_a20 JTF_VARCHAR2_TABLE_500
193: , p5_a21 JTF_VARCHAR2_TABLE_500
194: , p5_a22 JTF_VARCHAR2_TABLE_500
195: , p5_a23 JTF_NUMBER_TABLE
196: , p5_a24 JTF_NUMBER_TABLE
197: , p5_a25 JTF_NUMBER_TABLE
198: , p5_a26 JTF_NUMBER_TABLE
199: , p5_a27 JTF_DATE_TABLE
200: , p5_a28 JTF_NUMBER_TABLE
193: , p5_a21 JTF_VARCHAR2_TABLE_500
194: , p5_a22 JTF_VARCHAR2_TABLE_500
195: , p5_a23 JTF_NUMBER_TABLE
196: , p5_a24 JTF_NUMBER_TABLE
197: , p5_a25 JTF_NUMBER_TABLE
198: , p5_a26 JTF_NUMBER_TABLE
199: , p5_a27 JTF_DATE_TABLE
200: , p5_a28 JTF_NUMBER_TABLE
201: , p5_a29 JTF_DATE_TABLE
194: , p5_a22 JTF_VARCHAR2_TABLE_500
195: , p5_a23 JTF_NUMBER_TABLE
196: , p5_a24 JTF_NUMBER_TABLE
197: , p5_a25 JTF_NUMBER_TABLE
198: , p5_a26 JTF_NUMBER_TABLE
199: , p5_a27 JTF_DATE_TABLE
200: , p5_a28 JTF_NUMBER_TABLE
201: , p5_a29 JTF_DATE_TABLE
202: , p5_a30 JTF_NUMBER_TABLE
196: , p5_a24 JTF_NUMBER_TABLE
197: , p5_a25 JTF_NUMBER_TABLE
198: , p5_a26 JTF_NUMBER_TABLE
199: , p5_a27 JTF_DATE_TABLE
200: , p5_a28 JTF_NUMBER_TABLE
201: , p5_a29 JTF_DATE_TABLE
202: , p5_a30 JTF_NUMBER_TABLE
203: , p5_a31 JTF_DATE_TABLE
204: , p5_a32 JTF_NUMBER_TABLE
198: , p5_a26 JTF_NUMBER_TABLE
199: , p5_a27 JTF_DATE_TABLE
200: , p5_a28 JTF_NUMBER_TABLE
201: , p5_a29 JTF_DATE_TABLE
202: , p5_a30 JTF_NUMBER_TABLE
203: , p5_a31 JTF_DATE_TABLE
204: , p5_a32 JTF_NUMBER_TABLE
205: , p5_a33 JTF_VARCHAR2_TABLE_100
206: , p5_a34 JTF_VARCHAR2_TABLE_100
200: , p5_a28 JTF_NUMBER_TABLE
201: , p5_a29 JTF_DATE_TABLE
202: , p5_a30 JTF_NUMBER_TABLE
203: , p5_a31 JTF_DATE_TABLE
204: , p5_a32 JTF_NUMBER_TABLE
205: , p5_a33 JTF_VARCHAR2_TABLE_100
206: , p5_a34 JTF_VARCHAR2_TABLE_100
207: , p5_a35 JTF_VARCHAR2_TABLE_100
208: , p5_a36 JTF_NUMBER_TABLE
204: , p5_a32 JTF_NUMBER_TABLE
205: , p5_a33 JTF_VARCHAR2_TABLE_100
206: , p5_a34 JTF_VARCHAR2_TABLE_100
207: , p5_a35 JTF_VARCHAR2_TABLE_100
208: , p5_a36 JTF_NUMBER_TABLE
209: , p5_a37 JTF_DATE_TABLE
210: );
211: procedure lock_remarketing_costs(p_api_version NUMBER
212: , p_init_msg_list VARCHAR2
256: , p_init_msg_list VARCHAR2
257: , x_return_status out nocopy VARCHAR2
258: , x_msg_count out nocopy NUMBER
259: , x_msg_data out nocopy VARCHAR2
260: , p5_a0 JTF_NUMBER_TABLE
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_VARCHAR2_TABLE_100
263: , p5_a3 JTF_NUMBER_TABLE
264: , p5_a4 JTF_VARCHAR2_TABLE_100
257: , x_return_status out nocopy VARCHAR2
258: , x_msg_count out nocopy NUMBER
259: , x_msg_data out nocopy VARCHAR2
260: , p5_a0 JTF_NUMBER_TABLE
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_VARCHAR2_TABLE_100
263: , p5_a3 JTF_NUMBER_TABLE
264: , p5_a4 JTF_VARCHAR2_TABLE_100
265: , p5_a5 JTF_NUMBER_TABLE
259: , x_msg_data out nocopy VARCHAR2
260: , p5_a0 JTF_NUMBER_TABLE
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_VARCHAR2_TABLE_100
263: , p5_a3 JTF_NUMBER_TABLE
264: , p5_a4 JTF_VARCHAR2_TABLE_100
265: , p5_a5 JTF_NUMBER_TABLE
266: , p5_a6 JTF_VARCHAR2_TABLE_2000
267: , p5_a7 JTF_VARCHAR2_TABLE_100
261: , p5_a1 JTF_NUMBER_TABLE
262: , p5_a2 JTF_VARCHAR2_TABLE_100
263: , p5_a3 JTF_NUMBER_TABLE
264: , p5_a4 JTF_VARCHAR2_TABLE_100
265: , p5_a5 JTF_NUMBER_TABLE
266: , p5_a6 JTF_VARCHAR2_TABLE_2000
267: , p5_a7 JTF_VARCHAR2_TABLE_100
268: , p5_a8 JTF_VARCHAR2_TABLE_500
269: , p5_a9 JTF_VARCHAR2_TABLE_500
279: , p5_a19 JTF_VARCHAR2_TABLE_500
280: , p5_a20 JTF_VARCHAR2_TABLE_500
281: , p5_a21 JTF_VARCHAR2_TABLE_500
282: , p5_a22 JTF_VARCHAR2_TABLE_500
283: , p5_a23 JTF_NUMBER_TABLE
284: , p5_a24 JTF_NUMBER_TABLE
285: , p5_a25 JTF_NUMBER_TABLE
286: , p5_a26 JTF_NUMBER_TABLE
287: , p5_a27 JTF_DATE_TABLE
280: , p5_a20 JTF_VARCHAR2_TABLE_500
281: , p5_a21 JTF_VARCHAR2_TABLE_500
282: , p5_a22 JTF_VARCHAR2_TABLE_500
283: , p5_a23 JTF_NUMBER_TABLE
284: , p5_a24 JTF_NUMBER_TABLE
285: , p5_a25 JTF_NUMBER_TABLE
286: , p5_a26 JTF_NUMBER_TABLE
287: , p5_a27 JTF_DATE_TABLE
288: , p5_a28 JTF_NUMBER_TABLE
281: , p5_a21 JTF_VARCHAR2_TABLE_500
282: , p5_a22 JTF_VARCHAR2_TABLE_500
283: , p5_a23 JTF_NUMBER_TABLE
284: , p5_a24 JTF_NUMBER_TABLE
285: , p5_a25 JTF_NUMBER_TABLE
286: , p5_a26 JTF_NUMBER_TABLE
287: , p5_a27 JTF_DATE_TABLE
288: , p5_a28 JTF_NUMBER_TABLE
289: , p5_a29 JTF_DATE_TABLE
282: , p5_a22 JTF_VARCHAR2_TABLE_500
283: , p5_a23 JTF_NUMBER_TABLE
284: , p5_a24 JTF_NUMBER_TABLE
285: , p5_a25 JTF_NUMBER_TABLE
286: , p5_a26 JTF_NUMBER_TABLE
287: , p5_a27 JTF_DATE_TABLE
288: , p5_a28 JTF_NUMBER_TABLE
289: , p5_a29 JTF_DATE_TABLE
290: , p5_a30 JTF_NUMBER_TABLE
284: , p5_a24 JTF_NUMBER_TABLE
285: , p5_a25 JTF_NUMBER_TABLE
286: , p5_a26 JTF_NUMBER_TABLE
287: , p5_a27 JTF_DATE_TABLE
288: , p5_a28 JTF_NUMBER_TABLE
289: , p5_a29 JTF_DATE_TABLE
290: , p5_a30 JTF_NUMBER_TABLE
291: , p5_a31 JTF_DATE_TABLE
292: , p5_a32 JTF_NUMBER_TABLE
286: , p5_a26 JTF_NUMBER_TABLE
287: , p5_a27 JTF_DATE_TABLE
288: , p5_a28 JTF_NUMBER_TABLE
289: , p5_a29 JTF_DATE_TABLE
290: , p5_a30 JTF_NUMBER_TABLE
291: , p5_a31 JTF_DATE_TABLE
292: , p5_a32 JTF_NUMBER_TABLE
293: , p5_a33 JTF_VARCHAR2_TABLE_100
294: , p5_a34 JTF_VARCHAR2_TABLE_100
288: , p5_a28 JTF_NUMBER_TABLE
289: , p5_a29 JTF_DATE_TABLE
290: , p5_a30 JTF_NUMBER_TABLE
291: , p5_a31 JTF_DATE_TABLE
292: , p5_a32 JTF_NUMBER_TABLE
293: , p5_a33 JTF_VARCHAR2_TABLE_100
294: , p5_a34 JTF_VARCHAR2_TABLE_100
295: , p5_a35 JTF_VARCHAR2_TABLE_100
296: , p5_a36 JTF_NUMBER_TABLE
292: , p5_a32 JTF_NUMBER_TABLE
293: , p5_a33 JTF_VARCHAR2_TABLE_100
294: , p5_a34 JTF_VARCHAR2_TABLE_100
295: , p5_a35 JTF_VARCHAR2_TABLE_100
296: , p5_a36 JTF_NUMBER_TABLE
297: , p5_a37 JTF_DATE_TABLE
298: , p6_a0 out nocopy JTF_NUMBER_TABLE
299: , p6_a1 out nocopy JTF_NUMBER_TABLE
300: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
294: , p5_a34 JTF_VARCHAR2_TABLE_100
295: , p5_a35 JTF_VARCHAR2_TABLE_100
296: , p5_a36 JTF_NUMBER_TABLE
297: , p5_a37 JTF_DATE_TABLE
298: , p6_a0 out nocopy JTF_NUMBER_TABLE
299: , p6_a1 out nocopy JTF_NUMBER_TABLE
300: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
301: , p6_a3 out nocopy JTF_NUMBER_TABLE
302: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
295: , p5_a35 JTF_VARCHAR2_TABLE_100
296: , p5_a36 JTF_NUMBER_TABLE
297: , p5_a37 JTF_DATE_TABLE
298: , p6_a0 out nocopy JTF_NUMBER_TABLE
299: , p6_a1 out nocopy JTF_NUMBER_TABLE
300: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
301: , p6_a3 out nocopy JTF_NUMBER_TABLE
302: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a5 out nocopy JTF_NUMBER_TABLE
297: , p5_a37 JTF_DATE_TABLE
298: , p6_a0 out nocopy JTF_NUMBER_TABLE
299: , p6_a1 out nocopy JTF_NUMBER_TABLE
300: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
301: , p6_a3 out nocopy JTF_NUMBER_TABLE
302: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a5 out nocopy JTF_NUMBER_TABLE
304: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
305: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
299: , p6_a1 out nocopy JTF_NUMBER_TABLE
300: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
301: , p6_a3 out nocopy JTF_NUMBER_TABLE
302: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
303: , p6_a5 out nocopy JTF_NUMBER_TABLE
304: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
305: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_100
306: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_500
307: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_500
317: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
318: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
319: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
320: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
321: , p6_a23 out nocopy JTF_NUMBER_TABLE
322: , p6_a24 out nocopy JTF_NUMBER_TABLE
323: , p6_a25 out nocopy JTF_NUMBER_TABLE
324: , p6_a26 out nocopy JTF_NUMBER_TABLE
325: , p6_a27 out nocopy JTF_DATE_TABLE
318: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
319: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
320: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
321: , p6_a23 out nocopy JTF_NUMBER_TABLE
322: , p6_a24 out nocopy JTF_NUMBER_TABLE
323: , p6_a25 out nocopy JTF_NUMBER_TABLE
324: , p6_a26 out nocopy JTF_NUMBER_TABLE
325: , p6_a27 out nocopy JTF_DATE_TABLE
326: , p6_a28 out nocopy JTF_NUMBER_TABLE
319: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
320: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
321: , p6_a23 out nocopy JTF_NUMBER_TABLE
322: , p6_a24 out nocopy JTF_NUMBER_TABLE
323: , p6_a25 out nocopy JTF_NUMBER_TABLE
324: , p6_a26 out nocopy JTF_NUMBER_TABLE
325: , p6_a27 out nocopy JTF_DATE_TABLE
326: , p6_a28 out nocopy JTF_NUMBER_TABLE
327: , p6_a29 out nocopy JTF_DATE_TABLE
320: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
321: , p6_a23 out nocopy JTF_NUMBER_TABLE
322: , p6_a24 out nocopy JTF_NUMBER_TABLE
323: , p6_a25 out nocopy JTF_NUMBER_TABLE
324: , p6_a26 out nocopy JTF_NUMBER_TABLE
325: , p6_a27 out nocopy JTF_DATE_TABLE
326: , p6_a28 out nocopy JTF_NUMBER_TABLE
327: , p6_a29 out nocopy JTF_DATE_TABLE
328: , p6_a30 out nocopy JTF_NUMBER_TABLE
322: , p6_a24 out nocopy JTF_NUMBER_TABLE
323: , p6_a25 out nocopy JTF_NUMBER_TABLE
324: , p6_a26 out nocopy JTF_NUMBER_TABLE
325: , p6_a27 out nocopy JTF_DATE_TABLE
326: , p6_a28 out nocopy JTF_NUMBER_TABLE
327: , p6_a29 out nocopy JTF_DATE_TABLE
328: , p6_a30 out nocopy JTF_NUMBER_TABLE
329: , p6_a31 out nocopy JTF_DATE_TABLE
330: , p6_a32 out nocopy JTF_NUMBER_TABLE
324: , p6_a26 out nocopy JTF_NUMBER_TABLE
325: , p6_a27 out nocopy JTF_DATE_TABLE
326: , p6_a28 out nocopy JTF_NUMBER_TABLE
327: , p6_a29 out nocopy JTF_DATE_TABLE
328: , p6_a30 out nocopy JTF_NUMBER_TABLE
329: , p6_a31 out nocopy JTF_DATE_TABLE
330: , p6_a32 out nocopy JTF_NUMBER_TABLE
331: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a28 out nocopy JTF_NUMBER_TABLE
327: , p6_a29 out nocopy JTF_DATE_TABLE
328: , p6_a30 out nocopy JTF_NUMBER_TABLE
329: , p6_a31 out nocopy JTF_DATE_TABLE
330: , p6_a32 out nocopy JTF_NUMBER_TABLE
331: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
333: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
334: , p6_a36 out nocopy JTF_NUMBER_TABLE
330: , p6_a32 out nocopy JTF_NUMBER_TABLE
331: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_100
332: , p6_a34 out nocopy JTF_VARCHAR2_TABLE_100
333: , p6_a35 out nocopy JTF_VARCHAR2_TABLE_100
334: , p6_a36 out nocopy JTF_NUMBER_TABLE
335: , p6_a37 out nocopy JTF_DATE_TABLE
336: );
337: procedure update_remarketing_costs(p_api_version NUMBER
338: , p_init_msg_list VARCHAR2
420: , p_init_msg_list VARCHAR2
421: , x_return_status out nocopy VARCHAR2
422: , x_msg_count out nocopy NUMBER
423: , x_msg_data out nocopy VARCHAR2
424: , p5_a0 JTF_NUMBER_TABLE
425: , p5_a1 JTF_NUMBER_TABLE
426: , p5_a2 JTF_VARCHAR2_TABLE_100
427: , p5_a3 JTF_NUMBER_TABLE
428: , p5_a4 JTF_VARCHAR2_TABLE_100
421: , x_return_status out nocopy VARCHAR2
422: , x_msg_count out nocopy NUMBER
423: , x_msg_data out nocopy VARCHAR2
424: , p5_a0 JTF_NUMBER_TABLE
425: , p5_a1 JTF_NUMBER_TABLE
426: , p5_a2 JTF_VARCHAR2_TABLE_100
427: , p5_a3 JTF_NUMBER_TABLE
428: , p5_a4 JTF_VARCHAR2_TABLE_100
429: , p5_a5 JTF_NUMBER_TABLE
423: , x_msg_data out nocopy VARCHAR2
424: , p5_a0 JTF_NUMBER_TABLE
425: , p5_a1 JTF_NUMBER_TABLE
426: , p5_a2 JTF_VARCHAR2_TABLE_100
427: , p5_a3 JTF_NUMBER_TABLE
428: , p5_a4 JTF_VARCHAR2_TABLE_100
429: , p5_a5 JTF_NUMBER_TABLE
430: , p5_a6 JTF_VARCHAR2_TABLE_2000
431: , p5_a7 JTF_VARCHAR2_TABLE_100
425: , p5_a1 JTF_NUMBER_TABLE
426: , p5_a2 JTF_VARCHAR2_TABLE_100
427: , p5_a3 JTF_NUMBER_TABLE
428: , p5_a4 JTF_VARCHAR2_TABLE_100
429: , p5_a5 JTF_NUMBER_TABLE
430: , p5_a6 JTF_VARCHAR2_TABLE_2000
431: , p5_a7 JTF_VARCHAR2_TABLE_100
432: , p5_a8 JTF_VARCHAR2_TABLE_500
433: , p5_a9 JTF_VARCHAR2_TABLE_500
443: , p5_a19 JTF_VARCHAR2_TABLE_500
444: , p5_a20 JTF_VARCHAR2_TABLE_500
445: , p5_a21 JTF_VARCHAR2_TABLE_500
446: , p5_a22 JTF_VARCHAR2_TABLE_500
447: , p5_a23 JTF_NUMBER_TABLE
448: , p5_a24 JTF_NUMBER_TABLE
449: , p5_a25 JTF_NUMBER_TABLE
450: , p5_a26 JTF_NUMBER_TABLE
451: , p5_a27 JTF_DATE_TABLE
444: , p5_a20 JTF_VARCHAR2_TABLE_500
445: , p5_a21 JTF_VARCHAR2_TABLE_500
446: , p5_a22 JTF_VARCHAR2_TABLE_500
447: , p5_a23 JTF_NUMBER_TABLE
448: , p5_a24 JTF_NUMBER_TABLE
449: , p5_a25 JTF_NUMBER_TABLE
450: , p5_a26 JTF_NUMBER_TABLE
451: , p5_a27 JTF_DATE_TABLE
452: , p5_a28 JTF_NUMBER_TABLE
445: , p5_a21 JTF_VARCHAR2_TABLE_500
446: , p5_a22 JTF_VARCHAR2_TABLE_500
447: , p5_a23 JTF_NUMBER_TABLE
448: , p5_a24 JTF_NUMBER_TABLE
449: , p5_a25 JTF_NUMBER_TABLE
450: , p5_a26 JTF_NUMBER_TABLE
451: , p5_a27 JTF_DATE_TABLE
452: , p5_a28 JTF_NUMBER_TABLE
453: , p5_a29 JTF_DATE_TABLE
446: , p5_a22 JTF_VARCHAR2_TABLE_500
447: , p5_a23 JTF_NUMBER_TABLE
448: , p5_a24 JTF_NUMBER_TABLE
449: , p5_a25 JTF_NUMBER_TABLE
450: , p5_a26 JTF_NUMBER_TABLE
451: , p5_a27 JTF_DATE_TABLE
452: , p5_a28 JTF_NUMBER_TABLE
453: , p5_a29 JTF_DATE_TABLE
454: , p5_a30 JTF_NUMBER_TABLE
448: , p5_a24 JTF_NUMBER_TABLE
449: , p5_a25 JTF_NUMBER_TABLE
450: , p5_a26 JTF_NUMBER_TABLE
451: , p5_a27 JTF_DATE_TABLE
452: , p5_a28 JTF_NUMBER_TABLE
453: , p5_a29 JTF_DATE_TABLE
454: , p5_a30 JTF_NUMBER_TABLE
455: , p5_a31 JTF_DATE_TABLE
456: , p5_a32 JTF_NUMBER_TABLE
450: , p5_a26 JTF_NUMBER_TABLE
451: , p5_a27 JTF_DATE_TABLE
452: , p5_a28 JTF_NUMBER_TABLE
453: , p5_a29 JTF_DATE_TABLE
454: , p5_a30 JTF_NUMBER_TABLE
455: , p5_a31 JTF_DATE_TABLE
456: , p5_a32 JTF_NUMBER_TABLE
457: , p5_a33 JTF_VARCHAR2_TABLE_100
458: , p5_a34 JTF_VARCHAR2_TABLE_100
452: , p5_a28 JTF_NUMBER_TABLE
453: , p5_a29 JTF_DATE_TABLE
454: , p5_a30 JTF_NUMBER_TABLE
455: , p5_a31 JTF_DATE_TABLE
456: , p5_a32 JTF_NUMBER_TABLE
457: , p5_a33 JTF_VARCHAR2_TABLE_100
458: , p5_a34 JTF_VARCHAR2_TABLE_100
459: , p5_a35 JTF_VARCHAR2_TABLE_100
460: , p5_a36 JTF_NUMBER_TABLE
456: , p5_a32 JTF_NUMBER_TABLE
457: , p5_a33 JTF_VARCHAR2_TABLE_100
458: , p5_a34 JTF_VARCHAR2_TABLE_100
459: , p5_a35 JTF_VARCHAR2_TABLE_100
460: , p5_a36 JTF_NUMBER_TABLE
461: , p5_a37 JTF_DATE_TABLE
462: );
463: procedure delete_remarketing_costs(p_api_version NUMBER
464: , p_init_msg_list VARCHAR2
508: , p_init_msg_list VARCHAR2
509: , x_return_status out nocopy VARCHAR2
510: , x_msg_count out nocopy NUMBER
511: , x_msg_data out nocopy VARCHAR2
512: , p5_a0 JTF_NUMBER_TABLE
513: , p5_a1 JTF_NUMBER_TABLE
514: , p5_a2 JTF_VARCHAR2_TABLE_100
515: , p5_a3 JTF_NUMBER_TABLE
516: , p5_a4 JTF_VARCHAR2_TABLE_100
509: , x_return_status out nocopy VARCHAR2
510: , x_msg_count out nocopy NUMBER
511: , x_msg_data out nocopy VARCHAR2
512: , p5_a0 JTF_NUMBER_TABLE
513: , p5_a1 JTF_NUMBER_TABLE
514: , p5_a2 JTF_VARCHAR2_TABLE_100
515: , p5_a3 JTF_NUMBER_TABLE
516: , p5_a4 JTF_VARCHAR2_TABLE_100
517: , p5_a5 JTF_NUMBER_TABLE
511: , x_msg_data out nocopy VARCHAR2
512: , p5_a0 JTF_NUMBER_TABLE
513: , p5_a1 JTF_NUMBER_TABLE
514: , p5_a2 JTF_VARCHAR2_TABLE_100
515: , p5_a3 JTF_NUMBER_TABLE
516: , p5_a4 JTF_VARCHAR2_TABLE_100
517: , p5_a5 JTF_NUMBER_TABLE
518: , p5_a6 JTF_VARCHAR2_TABLE_2000
519: , p5_a7 JTF_VARCHAR2_TABLE_100
513: , p5_a1 JTF_NUMBER_TABLE
514: , p5_a2 JTF_VARCHAR2_TABLE_100
515: , p5_a3 JTF_NUMBER_TABLE
516: , p5_a4 JTF_VARCHAR2_TABLE_100
517: , p5_a5 JTF_NUMBER_TABLE
518: , p5_a6 JTF_VARCHAR2_TABLE_2000
519: , p5_a7 JTF_VARCHAR2_TABLE_100
520: , p5_a8 JTF_VARCHAR2_TABLE_500
521: , p5_a9 JTF_VARCHAR2_TABLE_500
531: , p5_a19 JTF_VARCHAR2_TABLE_500
532: , p5_a20 JTF_VARCHAR2_TABLE_500
533: , p5_a21 JTF_VARCHAR2_TABLE_500
534: , p5_a22 JTF_VARCHAR2_TABLE_500
535: , p5_a23 JTF_NUMBER_TABLE
536: , p5_a24 JTF_NUMBER_TABLE
537: , p5_a25 JTF_NUMBER_TABLE
538: , p5_a26 JTF_NUMBER_TABLE
539: , p5_a27 JTF_DATE_TABLE
532: , p5_a20 JTF_VARCHAR2_TABLE_500
533: , p5_a21 JTF_VARCHAR2_TABLE_500
534: , p5_a22 JTF_VARCHAR2_TABLE_500
535: , p5_a23 JTF_NUMBER_TABLE
536: , p5_a24 JTF_NUMBER_TABLE
537: , p5_a25 JTF_NUMBER_TABLE
538: , p5_a26 JTF_NUMBER_TABLE
539: , p5_a27 JTF_DATE_TABLE
540: , p5_a28 JTF_NUMBER_TABLE
533: , p5_a21 JTF_VARCHAR2_TABLE_500
534: , p5_a22 JTF_VARCHAR2_TABLE_500
535: , p5_a23 JTF_NUMBER_TABLE
536: , p5_a24 JTF_NUMBER_TABLE
537: , p5_a25 JTF_NUMBER_TABLE
538: , p5_a26 JTF_NUMBER_TABLE
539: , p5_a27 JTF_DATE_TABLE
540: , p5_a28 JTF_NUMBER_TABLE
541: , p5_a29 JTF_DATE_TABLE
534: , p5_a22 JTF_VARCHAR2_TABLE_500
535: , p5_a23 JTF_NUMBER_TABLE
536: , p5_a24 JTF_NUMBER_TABLE
537: , p5_a25 JTF_NUMBER_TABLE
538: , p5_a26 JTF_NUMBER_TABLE
539: , p5_a27 JTF_DATE_TABLE
540: , p5_a28 JTF_NUMBER_TABLE
541: , p5_a29 JTF_DATE_TABLE
542: , p5_a30 JTF_NUMBER_TABLE
536: , p5_a24 JTF_NUMBER_TABLE
537: , p5_a25 JTF_NUMBER_TABLE
538: , p5_a26 JTF_NUMBER_TABLE
539: , p5_a27 JTF_DATE_TABLE
540: , p5_a28 JTF_NUMBER_TABLE
541: , p5_a29 JTF_DATE_TABLE
542: , p5_a30 JTF_NUMBER_TABLE
543: , p5_a31 JTF_DATE_TABLE
544: , p5_a32 JTF_NUMBER_TABLE
538: , p5_a26 JTF_NUMBER_TABLE
539: , p5_a27 JTF_DATE_TABLE
540: , p5_a28 JTF_NUMBER_TABLE
541: , p5_a29 JTF_DATE_TABLE
542: , p5_a30 JTF_NUMBER_TABLE
543: , p5_a31 JTF_DATE_TABLE
544: , p5_a32 JTF_NUMBER_TABLE
545: , p5_a33 JTF_VARCHAR2_TABLE_100
546: , p5_a34 JTF_VARCHAR2_TABLE_100
540: , p5_a28 JTF_NUMBER_TABLE
541: , p5_a29 JTF_DATE_TABLE
542: , p5_a30 JTF_NUMBER_TABLE
543: , p5_a31 JTF_DATE_TABLE
544: , p5_a32 JTF_NUMBER_TABLE
545: , p5_a33 JTF_VARCHAR2_TABLE_100
546: , p5_a34 JTF_VARCHAR2_TABLE_100
547: , p5_a35 JTF_VARCHAR2_TABLE_100
548: , p5_a36 JTF_NUMBER_TABLE
544: , p5_a32 JTF_NUMBER_TABLE
545: , p5_a33 JTF_VARCHAR2_TABLE_100
546: , p5_a34 JTF_VARCHAR2_TABLE_100
547: , p5_a35 JTF_VARCHAR2_TABLE_100
548: , p5_a36 JTF_NUMBER_TABLE
549: , p5_a37 JTF_DATE_TABLE
550: );
551: procedure validate_rmrkting_costs(p_api_version NUMBER
552: , p_init_msg_list VARCHAR2