80: , p_init_msg_list VARCHAR2
81: , x_return_status out nocopy VARCHAR2
82: , x_msg_count out nocopy NUMBER
83: , x_msg_data out nocopy VARCHAR2
84: , p5_a0 JTF_NUMBER_TABLE
85: , p5_a1 JTF_NUMBER_TABLE
86: , p5_a2 JTF_VARCHAR2_TABLE_200
87: , p5_a3 JTF_NUMBER_TABLE
88: , p5_a4 JTF_NUMBER_TABLE
81: , x_return_status out nocopy VARCHAR2
82: , x_msg_count out nocopy NUMBER
83: , x_msg_data out nocopy VARCHAR2
84: , p5_a0 JTF_NUMBER_TABLE
85: , p5_a1 JTF_NUMBER_TABLE
86: , p5_a2 JTF_VARCHAR2_TABLE_200
87: , p5_a3 JTF_NUMBER_TABLE
88: , p5_a4 JTF_NUMBER_TABLE
89: , p5_a5 JTF_VARCHAR2_TABLE_200
83: , x_msg_data out nocopy VARCHAR2
84: , p5_a0 JTF_NUMBER_TABLE
85: , p5_a1 JTF_NUMBER_TABLE
86: , p5_a2 JTF_VARCHAR2_TABLE_200
87: , p5_a3 JTF_NUMBER_TABLE
88: , p5_a4 JTF_NUMBER_TABLE
89: , p5_a5 JTF_VARCHAR2_TABLE_200
90: , p5_a6 JTF_VARCHAR2_TABLE_2000
91: , p5_a7 JTF_NUMBER_TABLE
84: , p5_a0 JTF_NUMBER_TABLE
85: , p5_a1 JTF_NUMBER_TABLE
86: , p5_a2 JTF_VARCHAR2_TABLE_200
87: , p5_a3 JTF_NUMBER_TABLE
88: , p5_a4 JTF_NUMBER_TABLE
89: , p5_a5 JTF_VARCHAR2_TABLE_200
90: , p5_a6 JTF_VARCHAR2_TABLE_2000
91: , p5_a7 JTF_NUMBER_TABLE
92: , p5_a8 JTF_DATE_TABLE
87: , p5_a3 JTF_NUMBER_TABLE
88: , p5_a4 JTF_NUMBER_TABLE
89: , p5_a5 JTF_VARCHAR2_TABLE_200
90: , p5_a6 JTF_VARCHAR2_TABLE_2000
91: , p5_a7 JTF_NUMBER_TABLE
92: , p5_a8 JTF_DATE_TABLE
93: , p5_a9 JTF_DATE_TABLE
94: , p5_a10 JTF_VARCHAR2_TABLE_100
95: , p5_a11 JTF_VARCHAR2_TABLE_500
106: , p5_a22 JTF_VARCHAR2_TABLE_500
107: , p5_a23 JTF_VARCHAR2_TABLE_500
108: , p5_a24 JTF_VARCHAR2_TABLE_500
109: , p5_a25 JTF_VARCHAR2_TABLE_500
110: , p5_a26 JTF_NUMBER_TABLE
111: , p5_a27 JTF_NUMBER_TABLE
112: , p5_a28 JTF_NUMBER_TABLE
113: , p5_a29 JTF_DATE_TABLE
114: , p5_a30 JTF_NUMBER_TABLE
107: , p5_a23 JTF_VARCHAR2_TABLE_500
108: , p5_a24 JTF_VARCHAR2_TABLE_500
109: , p5_a25 JTF_VARCHAR2_TABLE_500
110: , p5_a26 JTF_NUMBER_TABLE
111: , p5_a27 JTF_NUMBER_TABLE
112: , p5_a28 JTF_NUMBER_TABLE
113: , p5_a29 JTF_DATE_TABLE
114: , p5_a30 JTF_NUMBER_TABLE
115: , p5_a31 JTF_DATE_TABLE
108: , p5_a24 JTF_VARCHAR2_TABLE_500
109: , p5_a25 JTF_VARCHAR2_TABLE_500
110: , p5_a26 JTF_NUMBER_TABLE
111: , p5_a27 JTF_NUMBER_TABLE
112: , p5_a28 JTF_NUMBER_TABLE
113: , p5_a29 JTF_DATE_TABLE
114: , p5_a30 JTF_NUMBER_TABLE
115: , p5_a31 JTF_DATE_TABLE
116: , p5_a32 JTF_NUMBER_TABLE
110: , p5_a26 JTF_NUMBER_TABLE
111: , p5_a27 JTF_NUMBER_TABLE
112: , p5_a28 JTF_NUMBER_TABLE
113: , p5_a29 JTF_DATE_TABLE
114: , p5_a30 JTF_NUMBER_TABLE
115: , p5_a31 JTF_DATE_TABLE
116: , p5_a32 JTF_NUMBER_TABLE
117: , p5_a33 JTF_DATE_TABLE
118: , p5_a34 JTF_NUMBER_TABLE
112: , p5_a28 JTF_NUMBER_TABLE
113: , p5_a29 JTF_DATE_TABLE
114: , p5_a30 JTF_NUMBER_TABLE
115: , p5_a31 JTF_DATE_TABLE
116: , p5_a32 JTF_NUMBER_TABLE
117: , p5_a33 JTF_DATE_TABLE
118: , p5_a34 JTF_NUMBER_TABLE
119: , p6_a0 out nocopy JTF_NUMBER_TABLE
120: , p6_a1 out nocopy JTF_NUMBER_TABLE
114: , p5_a30 JTF_NUMBER_TABLE
115: , p5_a31 JTF_DATE_TABLE
116: , p5_a32 JTF_NUMBER_TABLE
117: , p5_a33 JTF_DATE_TABLE
118: , p5_a34 JTF_NUMBER_TABLE
119: , p6_a0 out nocopy JTF_NUMBER_TABLE
120: , p6_a1 out nocopy JTF_NUMBER_TABLE
121: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
122: , p6_a3 out nocopy JTF_NUMBER_TABLE
115: , p5_a31 JTF_DATE_TABLE
116: , p5_a32 JTF_NUMBER_TABLE
117: , p5_a33 JTF_DATE_TABLE
118: , p5_a34 JTF_NUMBER_TABLE
119: , p6_a0 out nocopy JTF_NUMBER_TABLE
120: , p6_a1 out nocopy JTF_NUMBER_TABLE
121: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
122: , p6_a3 out nocopy JTF_NUMBER_TABLE
123: , p6_a4 out nocopy JTF_NUMBER_TABLE
116: , p5_a32 JTF_NUMBER_TABLE
117: , p5_a33 JTF_DATE_TABLE
118: , p5_a34 JTF_NUMBER_TABLE
119: , p6_a0 out nocopy JTF_NUMBER_TABLE
120: , p6_a1 out nocopy JTF_NUMBER_TABLE
121: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
122: , p6_a3 out nocopy JTF_NUMBER_TABLE
123: , p6_a4 out nocopy JTF_NUMBER_TABLE
124: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
118: , p5_a34 JTF_NUMBER_TABLE
119: , p6_a0 out nocopy JTF_NUMBER_TABLE
120: , p6_a1 out nocopy JTF_NUMBER_TABLE
121: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
122: , p6_a3 out nocopy JTF_NUMBER_TABLE
123: , p6_a4 out nocopy JTF_NUMBER_TABLE
124: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
125: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
126: , p6_a7 out nocopy JTF_NUMBER_TABLE
119: , p6_a0 out nocopy JTF_NUMBER_TABLE
120: , p6_a1 out nocopy JTF_NUMBER_TABLE
121: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
122: , p6_a3 out nocopy JTF_NUMBER_TABLE
123: , p6_a4 out nocopy JTF_NUMBER_TABLE
124: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
125: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
126: , p6_a7 out nocopy JTF_NUMBER_TABLE
127: , p6_a8 out nocopy JTF_DATE_TABLE
122: , p6_a3 out nocopy JTF_NUMBER_TABLE
123: , p6_a4 out nocopy JTF_NUMBER_TABLE
124: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
125: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
126: , p6_a7 out nocopy JTF_NUMBER_TABLE
127: , p6_a8 out nocopy JTF_DATE_TABLE
128: , p6_a9 out nocopy JTF_DATE_TABLE
129: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
130: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
141: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
142: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
143: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
144: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
145: , p6_a26 out nocopy JTF_NUMBER_TABLE
146: , p6_a27 out nocopy JTF_NUMBER_TABLE
147: , p6_a28 out nocopy JTF_NUMBER_TABLE
148: , p6_a29 out nocopy JTF_DATE_TABLE
149: , p6_a30 out nocopy JTF_NUMBER_TABLE
142: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
143: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
144: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
145: , p6_a26 out nocopy JTF_NUMBER_TABLE
146: , p6_a27 out nocopy JTF_NUMBER_TABLE
147: , p6_a28 out nocopy JTF_NUMBER_TABLE
148: , p6_a29 out nocopy JTF_DATE_TABLE
149: , p6_a30 out nocopy JTF_NUMBER_TABLE
150: , p6_a31 out nocopy JTF_DATE_TABLE
143: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
144: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
145: , p6_a26 out nocopy JTF_NUMBER_TABLE
146: , p6_a27 out nocopy JTF_NUMBER_TABLE
147: , p6_a28 out nocopy JTF_NUMBER_TABLE
148: , p6_a29 out nocopy JTF_DATE_TABLE
149: , p6_a30 out nocopy JTF_NUMBER_TABLE
150: , p6_a31 out nocopy JTF_DATE_TABLE
151: , p6_a32 out nocopy JTF_NUMBER_TABLE
145: , p6_a26 out nocopy JTF_NUMBER_TABLE
146: , p6_a27 out nocopy JTF_NUMBER_TABLE
147: , p6_a28 out nocopy JTF_NUMBER_TABLE
148: , p6_a29 out nocopy JTF_DATE_TABLE
149: , p6_a30 out nocopy JTF_NUMBER_TABLE
150: , p6_a31 out nocopy JTF_DATE_TABLE
151: , p6_a32 out nocopy JTF_NUMBER_TABLE
152: , p6_a33 out nocopy JTF_DATE_TABLE
153: , p6_a34 out nocopy JTF_NUMBER_TABLE
147: , p6_a28 out nocopy JTF_NUMBER_TABLE
148: , p6_a29 out nocopy JTF_DATE_TABLE
149: , p6_a30 out nocopy JTF_NUMBER_TABLE
150: , p6_a31 out nocopy JTF_DATE_TABLE
151: , p6_a32 out nocopy JTF_NUMBER_TABLE
152: , p6_a33 out nocopy JTF_DATE_TABLE
153: , p6_a34 out nocopy JTF_NUMBER_TABLE
154: );
155: procedure lock_index_interfaces(p_api_version NUMBER
149: , p6_a30 out nocopy JTF_NUMBER_TABLE
150: , p6_a31 out nocopy JTF_DATE_TABLE
151: , p6_a32 out nocopy JTF_NUMBER_TABLE
152: , p6_a33 out nocopy JTF_DATE_TABLE
153: , p6_a34 out nocopy JTF_NUMBER_TABLE
154: );
155: procedure lock_index_interfaces(p_api_version NUMBER
156: , p_init_msg_list VARCHAR2
157: , x_return_status out nocopy VARCHAR2
197: , p_init_msg_list VARCHAR2
198: , x_return_status out nocopy VARCHAR2
199: , x_msg_count out nocopy NUMBER
200: , x_msg_data out nocopy VARCHAR2
201: , p5_a0 JTF_NUMBER_TABLE
202: , p5_a1 JTF_NUMBER_TABLE
203: , p5_a2 JTF_VARCHAR2_TABLE_200
204: , p5_a3 JTF_NUMBER_TABLE
205: , p5_a4 JTF_NUMBER_TABLE
198: , x_return_status out nocopy VARCHAR2
199: , x_msg_count out nocopy NUMBER
200: , x_msg_data out nocopy VARCHAR2
201: , p5_a0 JTF_NUMBER_TABLE
202: , p5_a1 JTF_NUMBER_TABLE
203: , p5_a2 JTF_VARCHAR2_TABLE_200
204: , p5_a3 JTF_NUMBER_TABLE
205: , p5_a4 JTF_NUMBER_TABLE
206: , p5_a5 JTF_VARCHAR2_TABLE_200
200: , x_msg_data out nocopy VARCHAR2
201: , p5_a0 JTF_NUMBER_TABLE
202: , p5_a1 JTF_NUMBER_TABLE
203: , p5_a2 JTF_VARCHAR2_TABLE_200
204: , p5_a3 JTF_NUMBER_TABLE
205: , p5_a4 JTF_NUMBER_TABLE
206: , p5_a5 JTF_VARCHAR2_TABLE_200
207: , p5_a6 JTF_VARCHAR2_TABLE_2000
208: , p5_a7 JTF_NUMBER_TABLE
201: , p5_a0 JTF_NUMBER_TABLE
202: , p5_a1 JTF_NUMBER_TABLE
203: , p5_a2 JTF_VARCHAR2_TABLE_200
204: , p5_a3 JTF_NUMBER_TABLE
205: , p5_a4 JTF_NUMBER_TABLE
206: , p5_a5 JTF_VARCHAR2_TABLE_200
207: , p5_a6 JTF_VARCHAR2_TABLE_2000
208: , p5_a7 JTF_NUMBER_TABLE
209: , p5_a8 JTF_DATE_TABLE
204: , p5_a3 JTF_NUMBER_TABLE
205: , p5_a4 JTF_NUMBER_TABLE
206: , p5_a5 JTF_VARCHAR2_TABLE_200
207: , p5_a6 JTF_VARCHAR2_TABLE_2000
208: , p5_a7 JTF_NUMBER_TABLE
209: , p5_a8 JTF_DATE_TABLE
210: , p5_a9 JTF_DATE_TABLE
211: , p5_a10 JTF_VARCHAR2_TABLE_100
212: , p5_a11 JTF_VARCHAR2_TABLE_500
223: , p5_a22 JTF_VARCHAR2_TABLE_500
224: , p5_a23 JTF_VARCHAR2_TABLE_500
225: , p5_a24 JTF_VARCHAR2_TABLE_500
226: , p5_a25 JTF_VARCHAR2_TABLE_500
227: , p5_a26 JTF_NUMBER_TABLE
228: , p5_a27 JTF_NUMBER_TABLE
229: , p5_a28 JTF_NUMBER_TABLE
230: , p5_a29 JTF_DATE_TABLE
231: , p5_a30 JTF_NUMBER_TABLE
224: , p5_a23 JTF_VARCHAR2_TABLE_500
225: , p5_a24 JTF_VARCHAR2_TABLE_500
226: , p5_a25 JTF_VARCHAR2_TABLE_500
227: , p5_a26 JTF_NUMBER_TABLE
228: , p5_a27 JTF_NUMBER_TABLE
229: , p5_a28 JTF_NUMBER_TABLE
230: , p5_a29 JTF_DATE_TABLE
231: , p5_a30 JTF_NUMBER_TABLE
232: , p5_a31 JTF_DATE_TABLE
225: , p5_a24 JTF_VARCHAR2_TABLE_500
226: , p5_a25 JTF_VARCHAR2_TABLE_500
227: , p5_a26 JTF_NUMBER_TABLE
228: , p5_a27 JTF_NUMBER_TABLE
229: , p5_a28 JTF_NUMBER_TABLE
230: , p5_a29 JTF_DATE_TABLE
231: , p5_a30 JTF_NUMBER_TABLE
232: , p5_a31 JTF_DATE_TABLE
233: , p5_a32 JTF_NUMBER_TABLE
227: , p5_a26 JTF_NUMBER_TABLE
228: , p5_a27 JTF_NUMBER_TABLE
229: , p5_a28 JTF_NUMBER_TABLE
230: , p5_a29 JTF_DATE_TABLE
231: , p5_a30 JTF_NUMBER_TABLE
232: , p5_a31 JTF_DATE_TABLE
233: , p5_a32 JTF_NUMBER_TABLE
234: , p5_a33 JTF_DATE_TABLE
235: , p5_a34 JTF_NUMBER_TABLE
229: , p5_a28 JTF_NUMBER_TABLE
230: , p5_a29 JTF_DATE_TABLE
231: , p5_a30 JTF_NUMBER_TABLE
232: , p5_a31 JTF_DATE_TABLE
233: , p5_a32 JTF_NUMBER_TABLE
234: , p5_a33 JTF_DATE_TABLE
235: , p5_a34 JTF_NUMBER_TABLE
236: );
237: procedure update_index_interfaces(p_api_version NUMBER
231: , p5_a30 JTF_NUMBER_TABLE
232: , p5_a31 JTF_DATE_TABLE
233: , p5_a32 JTF_NUMBER_TABLE
234: , p5_a33 JTF_DATE_TABLE
235: , p5_a34 JTF_NUMBER_TABLE
236: );
237: procedure update_index_interfaces(p_api_version NUMBER
238: , p_init_msg_list VARCHAR2
239: , x_return_status out nocopy VARCHAR2
314: , p_init_msg_list VARCHAR2
315: , x_return_status out nocopy VARCHAR2
316: , x_msg_count out nocopy NUMBER
317: , x_msg_data out nocopy VARCHAR2
318: , p5_a0 JTF_NUMBER_TABLE
319: , p5_a1 JTF_NUMBER_TABLE
320: , p5_a2 JTF_VARCHAR2_TABLE_200
321: , p5_a3 JTF_NUMBER_TABLE
322: , p5_a4 JTF_NUMBER_TABLE
315: , x_return_status out nocopy VARCHAR2
316: , x_msg_count out nocopy NUMBER
317: , x_msg_data out nocopy VARCHAR2
318: , p5_a0 JTF_NUMBER_TABLE
319: , p5_a1 JTF_NUMBER_TABLE
320: , p5_a2 JTF_VARCHAR2_TABLE_200
321: , p5_a3 JTF_NUMBER_TABLE
322: , p5_a4 JTF_NUMBER_TABLE
323: , p5_a5 JTF_VARCHAR2_TABLE_200
317: , x_msg_data out nocopy VARCHAR2
318: , p5_a0 JTF_NUMBER_TABLE
319: , p5_a1 JTF_NUMBER_TABLE
320: , p5_a2 JTF_VARCHAR2_TABLE_200
321: , p5_a3 JTF_NUMBER_TABLE
322: , p5_a4 JTF_NUMBER_TABLE
323: , p5_a5 JTF_VARCHAR2_TABLE_200
324: , p5_a6 JTF_VARCHAR2_TABLE_2000
325: , p5_a7 JTF_NUMBER_TABLE
318: , p5_a0 JTF_NUMBER_TABLE
319: , p5_a1 JTF_NUMBER_TABLE
320: , p5_a2 JTF_VARCHAR2_TABLE_200
321: , p5_a3 JTF_NUMBER_TABLE
322: , p5_a4 JTF_NUMBER_TABLE
323: , p5_a5 JTF_VARCHAR2_TABLE_200
324: , p5_a6 JTF_VARCHAR2_TABLE_2000
325: , p5_a7 JTF_NUMBER_TABLE
326: , p5_a8 JTF_DATE_TABLE
321: , p5_a3 JTF_NUMBER_TABLE
322: , p5_a4 JTF_NUMBER_TABLE
323: , p5_a5 JTF_VARCHAR2_TABLE_200
324: , p5_a6 JTF_VARCHAR2_TABLE_2000
325: , p5_a7 JTF_NUMBER_TABLE
326: , p5_a8 JTF_DATE_TABLE
327: , p5_a9 JTF_DATE_TABLE
328: , p5_a10 JTF_VARCHAR2_TABLE_100
329: , p5_a11 JTF_VARCHAR2_TABLE_500
340: , p5_a22 JTF_VARCHAR2_TABLE_500
341: , p5_a23 JTF_VARCHAR2_TABLE_500
342: , p5_a24 JTF_VARCHAR2_TABLE_500
343: , p5_a25 JTF_VARCHAR2_TABLE_500
344: , p5_a26 JTF_NUMBER_TABLE
345: , p5_a27 JTF_NUMBER_TABLE
346: , p5_a28 JTF_NUMBER_TABLE
347: , p5_a29 JTF_DATE_TABLE
348: , p5_a30 JTF_NUMBER_TABLE
341: , p5_a23 JTF_VARCHAR2_TABLE_500
342: , p5_a24 JTF_VARCHAR2_TABLE_500
343: , p5_a25 JTF_VARCHAR2_TABLE_500
344: , p5_a26 JTF_NUMBER_TABLE
345: , p5_a27 JTF_NUMBER_TABLE
346: , p5_a28 JTF_NUMBER_TABLE
347: , p5_a29 JTF_DATE_TABLE
348: , p5_a30 JTF_NUMBER_TABLE
349: , p5_a31 JTF_DATE_TABLE
342: , p5_a24 JTF_VARCHAR2_TABLE_500
343: , p5_a25 JTF_VARCHAR2_TABLE_500
344: , p5_a26 JTF_NUMBER_TABLE
345: , p5_a27 JTF_NUMBER_TABLE
346: , p5_a28 JTF_NUMBER_TABLE
347: , p5_a29 JTF_DATE_TABLE
348: , p5_a30 JTF_NUMBER_TABLE
349: , p5_a31 JTF_DATE_TABLE
350: , p5_a32 JTF_NUMBER_TABLE
344: , p5_a26 JTF_NUMBER_TABLE
345: , p5_a27 JTF_NUMBER_TABLE
346: , p5_a28 JTF_NUMBER_TABLE
347: , p5_a29 JTF_DATE_TABLE
348: , p5_a30 JTF_NUMBER_TABLE
349: , p5_a31 JTF_DATE_TABLE
350: , p5_a32 JTF_NUMBER_TABLE
351: , p5_a33 JTF_DATE_TABLE
352: , p5_a34 JTF_NUMBER_TABLE
346: , p5_a28 JTF_NUMBER_TABLE
347: , p5_a29 JTF_DATE_TABLE
348: , p5_a30 JTF_NUMBER_TABLE
349: , p5_a31 JTF_DATE_TABLE
350: , p5_a32 JTF_NUMBER_TABLE
351: , p5_a33 JTF_DATE_TABLE
352: , p5_a34 JTF_NUMBER_TABLE
353: , p6_a0 out nocopy JTF_NUMBER_TABLE
354: , p6_a1 out nocopy JTF_NUMBER_TABLE
348: , p5_a30 JTF_NUMBER_TABLE
349: , p5_a31 JTF_DATE_TABLE
350: , p5_a32 JTF_NUMBER_TABLE
351: , p5_a33 JTF_DATE_TABLE
352: , p5_a34 JTF_NUMBER_TABLE
353: , p6_a0 out nocopy JTF_NUMBER_TABLE
354: , p6_a1 out nocopy JTF_NUMBER_TABLE
355: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
356: , p6_a3 out nocopy JTF_NUMBER_TABLE
349: , p5_a31 JTF_DATE_TABLE
350: , p5_a32 JTF_NUMBER_TABLE
351: , p5_a33 JTF_DATE_TABLE
352: , p5_a34 JTF_NUMBER_TABLE
353: , p6_a0 out nocopy JTF_NUMBER_TABLE
354: , p6_a1 out nocopy JTF_NUMBER_TABLE
355: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
356: , p6_a3 out nocopy JTF_NUMBER_TABLE
357: , p6_a4 out nocopy JTF_NUMBER_TABLE
350: , p5_a32 JTF_NUMBER_TABLE
351: , p5_a33 JTF_DATE_TABLE
352: , p5_a34 JTF_NUMBER_TABLE
353: , p6_a0 out nocopy JTF_NUMBER_TABLE
354: , p6_a1 out nocopy JTF_NUMBER_TABLE
355: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
356: , p6_a3 out nocopy JTF_NUMBER_TABLE
357: , p6_a4 out nocopy JTF_NUMBER_TABLE
358: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
352: , p5_a34 JTF_NUMBER_TABLE
353: , p6_a0 out nocopy JTF_NUMBER_TABLE
354: , p6_a1 out nocopy JTF_NUMBER_TABLE
355: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
356: , p6_a3 out nocopy JTF_NUMBER_TABLE
357: , p6_a4 out nocopy JTF_NUMBER_TABLE
358: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
359: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
360: , p6_a7 out nocopy JTF_NUMBER_TABLE
353: , p6_a0 out nocopy JTF_NUMBER_TABLE
354: , p6_a1 out nocopy JTF_NUMBER_TABLE
355: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_200
356: , p6_a3 out nocopy JTF_NUMBER_TABLE
357: , p6_a4 out nocopy JTF_NUMBER_TABLE
358: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
359: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
360: , p6_a7 out nocopy JTF_NUMBER_TABLE
361: , p6_a8 out nocopy JTF_DATE_TABLE
356: , p6_a3 out nocopy JTF_NUMBER_TABLE
357: , p6_a4 out nocopy JTF_NUMBER_TABLE
358: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
359: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
360: , p6_a7 out nocopy JTF_NUMBER_TABLE
361: , p6_a8 out nocopy JTF_DATE_TABLE
362: , p6_a9 out nocopy JTF_DATE_TABLE
363: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
364: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
375: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
376: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
377: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
378: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
379: , p6_a26 out nocopy JTF_NUMBER_TABLE
380: , p6_a27 out nocopy JTF_NUMBER_TABLE
381: , p6_a28 out nocopy JTF_NUMBER_TABLE
382: , p6_a29 out nocopy JTF_DATE_TABLE
383: , p6_a30 out nocopy JTF_NUMBER_TABLE
376: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
377: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
378: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
379: , p6_a26 out nocopy JTF_NUMBER_TABLE
380: , p6_a27 out nocopy JTF_NUMBER_TABLE
381: , p6_a28 out nocopy JTF_NUMBER_TABLE
382: , p6_a29 out nocopy JTF_DATE_TABLE
383: , p6_a30 out nocopy JTF_NUMBER_TABLE
384: , p6_a31 out nocopy JTF_DATE_TABLE
377: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
378: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
379: , p6_a26 out nocopy JTF_NUMBER_TABLE
380: , p6_a27 out nocopy JTF_NUMBER_TABLE
381: , p6_a28 out nocopy JTF_NUMBER_TABLE
382: , p6_a29 out nocopy JTF_DATE_TABLE
383: , p6_a30 out nocopy JTF_NUMBER_TABLE
384: , p6_a31 out nocopy JTF_DATE_TABLE
385: , p6_a32 out nocopy JTF_NUMBER_TABLE
379: , p6_a26 out nocopy JTF_NUMBER_TABLE
380: , p6_a27 out nocopy JTF_NUMBER_TABLE
381: , p6_a28 out nocopy JTF_NUMBER_TABLE
382: , p6_a29 out nocopy JTF_DATE_TABLE
383: , p6_a30 out nocopy JTF_NUMBER_TABLE
384: , p6_a31 out nocopy JTF_DATE_TABLE
385: , p6_a32 out nocopy JTF_NUMBER_TABLE
386: , p6_a33 out nocopy JTF_DATE_TABLE
387: , p6_a34 out nocopy JTF_NUMBER_TABLE
381: , p6_a28 out nocopy JTF_NUMBER_TABLE
382: , p6_a29 out nocopy JTF_DATE_TABLE
383: , p6_a30 out nocopy JTF_NUMBER_TABLE
384: , p6_a31 out nocopy JTF_DATE_TABLE
385: , p6_a32 out nocopy JTF_NUMBER_TABLE
386: , p6_a33 out nocopy JTF_DATE_TABLE
387: , p6_a34 out nocopy JTF_NUMBER_TABLE
388: );
389: procedure delete_index_interfaces(p_api_version NUMBER
383: , p6_a30 out nocopy JTF_NUMBER_TABLE
384: , p6_a31 out nocopy JTF_DATE_TABLE
385: , p6_a32 out nocopy JTF_NUMBER_TABLE
386: , p6_a33 out nocopy JTF_DATE_TABLE
387: , p6_a34 out nocopy JTF_NUMBER_TABLE
388: );
389: procedure delete_index_interfaces(p_api_version NUMBER
390: , p_init_msg_list VARCHAR2
391: , x_return_status out nocopy VARCHAR2
431: , p_init_msg_list VARCHAR2
432: , x_return_status out nocopy VARCHAR2
433: , x_msg_count out nocopy NUMBER
434: , x_msg_data out nocopy VARCHAR2
435: , p5_a0 JTF_NUMBER_TABLE
436: , p5_a1 JTF_NUMBER_TABLE
437: , p5_a2 JTF_VARCHAR2_TABLE_200
438: , p5_a3 JTF_NUMBER_TABLE
439: , p5_a4 JTF_NUMBER_TABLE
432: , x_return_status out nocopy VARCHAR2
433: , x_msg_count out nocopy NUMBER
434: , x_msg_data out nocopy VARCHAR2
435: , p5_a0 JTF_NUMBER_TABLE
436: , p5_a1 JTF_NUMBER_TABLE
437: , p5_a2 JTF_VARCHAR2_TABLE_200
438: , p5_a3 JTF_NUMBER_TABLE
439: , p5_a4 JTF_NUMBER_TABLE
440: , p5_a5 JTF_VARCHAR2_TABLE_200
434: , x_msg_data out nocopy VARCHAR2
435: , p5_a0 JTF_NUMBER_TABLE
436: , p5_a1 JTF_NUMBER_TABLE
437: , p5_a2 JTF_VARCHAR2_TABLE_200
438: , p5_a3 JTF_NUMBER_TABLE
439: , p5_a4 JTF_NUMBER_TABLE
440: , p5_a5 JTF_VARCHAR2_TABLE_200
441: , p5_a6 JTF_VARCHAR2_TABLE_2000
442: , p5_a7 JTF_NUMBER_TABLE
435: , p5_a0 JTF_NUMBER_TABLE
436: , p5_a1 JTF_NUMBER_TABLE
437: , p5_a2 JTF_VARCHAR2_TABLE_200
438: , p5_a3 JTF_NUMBER_TABLE
439: , p5_a4 JTF_NUMBER_TABLE
440: , p5_a5 JTF_VARCHAR2_TABLE_200
441: , p5_a6 JTF_VARCHAR2_TABLE_2000
442: , p5_a7 JTF_NUMBER_TABLE
443: , p5_a8 JTF_DATE_TABLE
438: , p5_a3 JTF_NUMBER_TABLE
439: , p5_a4 JTF_NUMBER_TABLE
440: , p5_a5 JTF_VARCHAR2_TABLE_200
441: , p5_a6 JTF_VARCHAR2_TABLE_2000
442: , p5_a7 JTF_NUMBER_TABLE
443: , p5_a8 JTF_DATE_TABLE
444: , p5_a9 JTF_DATE_TABLE
445: , p5_a10 JTF_VARCHAR2_TABLE_100
446: , p5_a11 JTF_VARCHAR2_TABLE_500
457: , p5_a22 JTF_VARCHAR2_TABLE_500
458: , p5_a23 JTF_VARCHAR2_TABLE_500
459: , p5_a24 JTF_VARCHAR2_TABLE_500
460: , p5_a25 JTF_VARCHAR2_TABLE_500
461: , p5_a26 JTF_NUMBER_TABLE
462: , p5_a27 JTF_NUMBER_TABLE
463: , p5_a28 JTF_NUMBER_TABLE
464: , p5_a29 JTF_DATE_TABLE
465: , p5_a30 JTF_NUMBER_TABLE
458: , p5_a23 JTF_VARCHAR2_TABLE_500
459: , p5_a24 JTF_VARCHAR2_TABLE_500
460: , p5_a25 JTF_VARCHAR2_TABLE_500
461: , p5_a26 JTF_NUMBER_TABLE
462: , p5_a27 JTF_NUMBER_TABLE
463: , p5_a28 JTF_NUMBER_TABLE
464: , p5_a29 JTF_DATE_TABLE
465: , p5_a30 JTF_NUMBER_TABLE
466: , p5_a31 JTF_DATE_TABLE
459: , p5_a24 JTF_VARCHAR2_TABLE_500
460: , p5_a25 JTF_VARCHAR2_TABLE_500
461: , p5_a26 JTF_NUMBER_TABLE
462: , p5_a27 JTF_NUMBER_TABLE
463: , p5_a28 JTF_NUMBER_TABLE
464: , p5_a29 JTF_DATE_TABLE
465: , p5_a30 JTF_NUMBER_TABLE
466: , p5_a31 JTF_DATE_TABLE
467: , p5_a32 JTF_NUMBER_TABLE
461: , p5_a26 JTF_NUMBER_TABLE
462: , p5_a27 JTF_NUMBER_TABLE
463: , p5_a28 JTF_NUMBER_TABLE
464: , p5_a29 JTF_DATE_TABLE
465: , p5_a30 JTF_NUMBER_TABLE
466: , p5_a31 JTF_DATE_TABLE
467: , p5_a32 JTF_NUMBER_TABLE
468: , p5_a33 JTF_DATE_TABLE
469: , p5_a34 JTF_NUMBER_TABLE
463: , p5_a28 JTF_NUMBER_TABLE
464: , p5_a29 JTF_DATE_TABLE
465: , p5_a30 JTF_NUMBER_TABLE
466: , p5_a31 JTF_DATE_TABLE
467: , p5_a32 JTF_NUMBER_TABLE
468: , p5_a33 JTF_DATE_TABLE
469: , p5_a34 JTF_NUMBER_TABLE
470: );
471: procedure validate_index_interfaces(p_api_version NUMBER
465: , p5_a30 JTF_NUMBER_TABLE
466: , p5_a31 JTF_DATE_TABLE
467: , p5_a32 JTF_NUMBER_TABLE
468: , p5_a33 JTF_DATE_TABLE
469: , p5_a34 JTF_NUMBER_TABLE
470: );
471: procedure validate_index_interfaces(p_api_version NUMBER
472: , p_init_msg_list VARCHAR2
473: , x_return_status out nocopy VARCHAR2
513: , p_init_msg_list VARCHAR2
514: , x_return_status out nocopy VARCHAR2
515: , x_msg_count out nocopy NUMBER
516: , x_msg_data out nocopy VARCHAR2
517: , p5_a0 JTF_NUMBER_TABLE
518: , p5_a1 JTF_NUMBER_TABLE
519: , p5_a2 JTF_VARCHAR2_TABLE_200
520: , p5_a3 JTF_NUMBER_TABLE
521: , p5_a4 JTF_NUMBER_TABLE
514: , x_return_status out nocopy VARCHAR2
515: , x_msg_count out nocopy NUMBER
516: , x_msg_data out nocopy VARCHAR2
517: , p5_a0 JTF_NUMBER_TABLE
518: , p5_a1 JTF_NUMBER_TABLE
519: , p5_a2 JTF_VARCHAR2_TABLE_200
520: , p5_a3 JTF_NUMBER_TABLE
521: , p5_a4 JTF_NUMBER_TABLE
522: , p5_a5 JTF_VARCHAR2_TABLE_200
516: , x_msg_data out nocopy VARCHAR2
517: , p5_a0 JTF_NUMBER_TABLE
518: , p5_a1 JTF_NUMBER_TABLE
519: , p5_a2 JTF_VARCHAR2_TABLE_200
520: , p5_a3 JTF_NUMBER_TABLE
521: , p5_a4 JTF_NUMBER_TABLE
522: , p5_a5 JTF_VARCHAR2_TABLE_200
523: , p5_a6 JTF_VARCHAR2_TABLE_2000
524: , p5_a7 JTF_NUMBER_TABLE
517: , p5_a0 JTF_NUMBER_TABLE
518: , p5_a1 JTF_NUMBER_TABLE
519: , p5_a2 JTF_VARCHAR2_TABLE_200
520: , p5_a3 JTF_NUMBER_TABLE
521: , p5_a4 JTF_NUMBER_TABLE
522: , p5_a5 JTF_VARCHAR2_TABLE_200
523: , p5_a6 JTF_VARCHAR2_TABLE_2000
524: , p5_a7 JTF_NUMBER_TABLE
525: , p5_a8 JTF_DATE_TABLE
520: , p5_a3 JTF_NUMBER_TABLE
521: , p5_a4 JTF_NUMBER_TABLE
522: , p5_a5 JTF_VARCHAR2_TABLE_200
523: , p5_a6 JTF_VARCHAR2_TABLE_2000
524: , p5_a7 JTF_NUMBER_TABLE
525: , p5_a8 JTF_DATE_TABLE
526: , p5_a9 JTF_DATE_TABLE
527: , p5_a10 JTF_VARCHAR2_TABLE_100
528: , p5_a11 JTF_VARCHAR2_TABLE_500
539: , p5_a22 JTF_VARCHAR2_TABLE_500
540: , p5_a23 JTF_VARCHAR2_TABLE_500
541: , p5_a24 JTF_VARCHAR2_TABLE_500
542: , p5_a25 JTF_VARCHAR2_TABLE_500
543: , p5_a26 JTF_NUMBER_TABLE
544: , p5_a27 JTF_NUMBER_TABLE
545: , p5_a28 JTF_NUMBER_TABLE
546: , p5_a29 JTF_DATE_TABLE
547: , p5_a30 JTF_NUMBER_TABLE
540: , p5_a23 JTF_VARCHAR2_TABLE_500
541: , p5_a24 JTF_VARCHAR2_TABLE_500
542: , p5_a25 JTF_VARCHAR2_TABLE_500
543: , p5_a26 JTF_NUMBER_TABLE
544: , p5_a27 JTF_NUMBER_TABLE
545: , p5_a28 JTF_NUMBER_TABLE
546: , p5_a29 JTF_DATE_TABLE
547: , p5_a30 JTF_NUMBER_TABLE
548: , p5_a31 JTF_DATE_TABLE
541: , p5_a24 JTF_VARCHAR2_TABLE_500
542: , p5_a25 JTF_VARCHAR2_TABLE_500
543: , p5_a26 JTF_NUMBER_TABLE
544: , p5_a27 JTF_NUMBER_TABLE
545: , p5_a28 JTF_NUMBER_TABLE
546: , p5_a29 JTF_DATE_TABLE
547: , p5_a30 JTF_NUMBER_TABLE
548: , p5_a31 JTF_DATE_TABLE
549: , p5_a32 JTF_NUMBER_TABLE
543: , p5_a26 JTF_NUMBER_TABLE
544: , p5_a27 JTF_NUMBER_TABLE
545: , p5_a28 JTF_NUMBER_TABLE
546: , p5_a29 JTF_DATE_TABLE
547: , p5_a30 JTF_NUMBER_TABLE
548: , p5_a31 JTF_DATE_TABLE
549: , p5_a32 JTF_NUMBER_TABLE
550: , p5_a33 JTF_DATE_TABLE
551: , p5_a34 JTF_NUMBER_TABLE
545: , p5_a28 JTF_NUMBER_TABLE
546: , p5_a29 JTF_DATE_TABLE
547: , p5_a30 JTF_NUMBER_TABLE
548: , p5_a31 JTF_DATE_TABLE
549: , p5_a32 JTF_NUMBER_TABLE
550: , p5_a33 JTF_DATE_TABLE
551: , p5_a34 JTF_NUMBER_TABLE
552: );
553: end okl_index_interfaces_pub_w;
547: , p5_a30 JTF_NUMBER_TABLE
548: , p5_a31 JTF_DATE_TABLE
549: , p5_a32 JTF_NUMBER_TABLE
550: , p5_a33 JTF_DATE_TABLE
551: , p5_a34 JTF_NUMBER_TABLE
552: );
553: end okl_index_interfaces_pub_w;