74: , p_init_msg_list VARCHAR2
75: , x_return_status out nocopy VARCHAR2
76: , x_msg_count out nocopy NUMBER
77: , x_msg_data out nocopy VARCHAR2
78: , p5_a0 JTF_NUMBER_TABLE
79: , p5_a1 JTF_NUMBER_TABLE
80: , p5_a2 JTF_VARCHAR2_TABLE_100
81: , p5_a3 JTF_VARCHAR2_TABLE_100
82: , p5_a4 JTF_VARCHAR2_TABLE_200
75: , x_return_status out nocopy VARCHAR2
76: , x_msg_count out nocopy NUMBER
77: , x_msg_data out nocopy VARCHAR2
78: , p5_a0 JTF_NUMBER_TABLE
79: , p5_a1 JTF_NUMBER_TABLE
80: , p5_a2 JTF_VARCHAR2_TABLE_100
81: , p5_a3 JTF_VARCHAR2_TABLE_100
82: , p5_a4 JTF_VARCHAR2_TABLE_200
83: , p5_a5 JTF_VARCHAR2_TABLE_2000
100: , p5_a22 JTF_VARCHAR2_TABLE_500
101: , p5_a23 JTF_VARCHAR2_TABLE_500
102: , p5_a24 JTF_VARCHAR2_TABLE_500
103: , p5_a25 JTF_VARCHAR2_TABLE_500
104: , p5_a26 JTF_NUMBER_TABLE
105: , p5_a27 JTF_NUMBER_TABLE
106: , p5_a28 JTF_DATE_TABLE
107: , p5_a29 JTF_NUMBER_TABLE
108: , p5_a30 JTF_DATE_TABLE
101: , p5_a23 JTF_VARCHAR2_TABLE_500
102: , p5_a24 JTF_VARCHAR2_TABLE_500
103: , p5_a25 JTF_VARCHAR2_TABLE_500
104: , p5_a26 JTF_NUMBER_TABLE
105: , p5_a27 JTF_NUMBER_TABLE
106: , p5_a28 JTF_DATE_TABLE
107: , p5_a29 JTF_NUMBER_TABLE
108: , p5_a30 JTF_DATE_TABLE
109: , p5_a31 JTF_NUMBER_TABLE
103: , p5_a25 JTF_VARCHAR2_TABLE_500
104: , p5_a26 JTF_NUMBER_TABLE
105: , p5_a27 JTF_NUMBER_TABLE
106: , p5_a28 JTF_DATE_TABLE
107: , p5_a29 JTF_NUMBER_TABLE
108: , p5_a30 JTF_DATE_TABLE
109: , p5_a31 JTF_NUMBER_TABLE
110: , p6_a0 out nocopy JTF_NUMBER_TABLE
111: , p6_a1 out nocopy JTF_NUMBER_TABLE
105: , p5_a27 JTF_NUMBER_TABLE
106: , p5_a28 JTF_DATE_TABLE
107: , p5_a29 JTF_NUMBER_TABLE
108: , p5_a30 JTF_DATE_TABLE
109: , p5_a31 JTF_NUMBER_TABLE
110: , p6_a0 out nocopy JTF_NUMBER_TABLE
111: , p6_a1 out nocopy JTF_NUMBER_TABLE
112: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
113: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
106: , p5_a28 JTF_DATE_TABLE
107: , p5_a29 JTF_NUMBER_TABLE
108: , p5_a30 JTF_DATE_TABLE
109: , p5_a31 JTF_NUMBER_TABLE
110: , p6_a0 out nocopy JTF_NUMBER_TABLE
111: , p6_a1 out nocopy JTF_NUMBER_TABLE
112: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
113: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
114: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
107: , p5_a29 JTF_NUMBER_TABLE
108: , p5_a30 JTF_DATE_TABLE
109: , p5_a31 JTF_NUMBER_TABLE
110: , p6_a0 out nocopy JTF_NUMBER_TABLE
111: , p6_a1 out nocopy JTF_NUMBER_TABLE
112: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
113: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
114: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
115: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
132: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
133: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
134: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
135: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
136: , p6_a26 out nocopy JTF_NUMBER_TABLE
137: , p6_a27 out nocopy JTF_NUMBER_TABLE
138: , p6_a28 out nocopy JTF_DATE_TABLE
139: , p6_a29 out nocopy JTF_NUMBER_TABLE
140: , p6_a30 out nocopy JTF_DATE_TABLE
133: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
134: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
135: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
136: , p6_a26 out nocopy JTF_NUMBER_TABLE
137: , p6_a27 out nocopy JTF_NUMBER_TABLE
138: , p6_a28 out nocopy JTF_DATE_TABLE
139: , p6_a29 out nocopy JTF_NUMBER_TABLE
140: , p6_a30 out nocopy JTF_DATE_TABLE
141: , p6_a31 out nocopy JTF_NUMBER_TABLE
135: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
136: , p6_a26 out nocopy JTF_NUMBER_TABLE
137: , p6_a27 out nocopy JTF_NUMBER_TABLE
138: , p6_a28 out nocopy JTF_DATE_TABLE
139: , p6_a29 out nocopy JTF_NUMBER_TABLE
140: , p6_a30 out nocopy JTF_DATE_TABLE
141: , p6_a31 out nocopy JTF_NUMBER_TABLE
142: );
143: procedure lock_data_src_fnctns(p_api_version NUMBER
137: , p6_a27 out nocopy JTF_NUMBER_TABLE
138: , p6_a28 out nocopy JTF_DATE_TABLE
139: , p6_a29 out nocopy JTF_NUMBER_TABLE
140: , p6_a30 out nocopy JTF_DATE_TABLE
141: , p6_a31 out nocopy JTF_NUMBER_TABLE
142: );
143: procedure lock_data_src_fnctns(p_api_version NUMBER
144: , p_init_msg_list VARCHAR2
145: , x_return_status out nocopy VARCHAR2
182: , p_init_msg_list VARCHAR2
183: , x_return_status out nocopy VARCHAR2
184: , x_msg_count out nocopy NUMBER
185: , x_msg_data out nocopy VARCHAR2
186: , p5_a0 JTF_NUMBER_TABLE
187: , p5_a1 JTF_NUMBER_TABLE
188: , p5_a2 JTF_VARCHAR2_TABLE_100
189: , p5_a3 JTF_VARCHAR2_TABLE_100
190: , p5_a4 JTF_VARCHAR2_TABLE_200
183: , x_return_status out nocopy VARCHAR2
184: , x_msg_count out nocopy NUMBER
185: , x_msg_data out nocopy VARCHAR2
186: , p5_a0 JTF_NUMBER_TABLE
187: , p5_a1 JTF_NUMBER_TABLE
188: , p5_a2 JTF_VARCHAR2_TABLE_100
189: , p5_a3 JTF_VARCHAR2_TABLE_100
190: , p5_a4 JTF_VARCHAR2_TABLE_200
191: , p5_a5 JTF_VARCHAR2_TABLE_2000
208: , p5_a22 JTF_VARCHAR2_TABLE_500
209: , p5_a23 JTF_VARCHAR2_TABLE_500
210: , p5_a24 JTF_VARCHAR2_TABLE_500
211: , p5_a25 JTF_VARCHAR2_TABLE_500
212: , p5_a26 JTF_NUMBER_TABLE
213: , p5_a27 JTF_NUMBER_TABLE
214: , p5_a28 JTF_DATE_TABLE
215: , p5_a29 JTF_NUMBER_TABLE
216: , p5_a30 JTF_DATE_TABLE
209: , p5_a23 JTF_VARCHAR2_TABLE_500
210: , p5_a24 JTF_VARCHAR2_TABLE_500
211: , p5_a25 JTF_VARCHAR2_TABLE_500
212: , p5_a26 JTF_NUMBER_TABLE
213: , p5_a27 JTF_NUMBER_TABLE
214: , p5_a28 JTF_DATE_TABLE
215: , p5_a29 JTF_NUMBER_TABLE
216: , p5_a30 JTF_DATE_TABLE
217: , p5_a31 JTF_NUMBER_TABLE
211: , p5_a25 JTF_VARCHAR2_TABLE_500
212: , p5_a26 JTF_NUMBER_TABLE
213: , p5_a27 JTF_NUMBER_TABLE
214: , p5_a28 JTF_DATE_TABLE
215: , p5_a29 JTF_NUMBER_TABLE
216: , p5_a30 JTF_DATE_TABLE
217: , p5_a31 JTF_NUMBER_TABLE
218: );
219: procedure update_data_src_fnctns(p_api_version NUMBER
213: , p5_a27 JTF_NUMBER_TABLE
214: , p5_a28 JTF_DATE_TABLE
215: , p5_a29 JTF_NUMBER_TABLE
216: , p5_a30 JTF_DATE_TABLE
217: , p5_a31 JTF_NUMBER_TABLE
218: );
219: procedure update_data_src_fnctns(p_api_version NUMBER
220: , p_init_msg_list VARCHAR2
221: , x_return_status out nocopy VARCHAR2
290: , p_init_msg_list VARCHAR2
291: , x_return_status out nocopy VARCHAR2
292: , x_msg_count out nocopy NUMBER
293: , x_msg_data out nocopy VARCHAR2
294: , p5_a0 JTF_NUMBER_TABLE
295: , p5_a1 JTF_NUMBER_TABLE
296: , p5_a2 JTF_VARCHAR2_TABLE_100
297: , p5_a3 JTF_VARCHAR2_TABLE_100
298: , p5_a4 JTF_VARCHAR2_TABLE_200
291: , x_return_status out nocopy VARCHAR2
292: , x_msg_count out nocopy NUMBER
293: , x_msg_data out nocopy VARCHAR2
294: , p5_a0 JTF_NUMBER_TABLE
295: , p5_a1 JTF_NUMBER_TABLE
296: , p5_a2 JTF_VARCHAR2_TABLE_100
297: , p5_a3 JTF_VARCHAR2_TABLE_100
298: , p5_a4 JTF_VARCHAR2_TABLE_200
299: , p5_a5 JTF_VARCHAR2_TABLE_2000
316: , p5_a22 JTF_VARCHAR2_TABLE_500
317: , p5_a23 JTF_VARCHAR2_TABLE_500
318: , p5_a24 JTF_VARCHAR2_TABLE_500
319: , p5_a25 JTF_VARCHAR2_TABLE_500
320: , p5_a26 JTF_NUMBER_TABLE
321: , p5_a27 JTF_NUMBER_TABLE
322: , p5_a28 JTF_DATE_TABLE
323: , p5_a29 JTF_NUMBER_TABLE
324: , p5_a30 JTF_DATE_TABLE
317: , p5_a23 JTF_VARCHAR2_TABLE_500
318: , p5_a24 JTF_VARCHAR2_TABLE_500
319: , p5_a25 JTF_VARCHAR2_TABLE_500
320: , p5_a26 JTF_NUMBER_TABLE
321: , p5_a27 JTF_NUMBER_TABLE
322: , p5_a28 JTF_DATE_TABLE
323: , p5_a29 JTF_NUMBER_TABLE
324: , p5_a30 JTF_DATE_TABLE
325: , p5_a31 JTF_NUMBER_TABLE
319: , p5_a25 JTF_VARCHAR2_TABLE_500
320: , p5_a26 JTF_NUMBER_TABLE
321: , p5_a27 JTF_NUMBER_TABLE
322: , p5_a28 JTF_DATE_TABLE
323: , p5_a29 JTF_NUMBER_TABLE
324: , p5_a30 JTF_DATE_TABLE
325: , p5_a31 JTF_NUMBER_TABLE
326: , p6_a0 out nocopy JTF_NUMBER_TABLE
327: , p6_a1 out nocopy JTF_NUMBER_TABLE
321: , p5_a27 JTF_NUMBER_TABLE
322: , p5_a28 JTF_DATE_TABLE
323: , p5_a29 JTF_NUMBER_TABLE
324: , p5_a30 JTF_DATE_TABLE
325: , p5_a31 JTF_NUMBER_TABLE
326: , p6_a0 out nocopy JTF_NUMBER_TABLE
327: , p6_a1 out nocopy JTF_NUMBER_TABLE
328: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
329: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
322: , p5_a28 JTF_DATE_TABLE
323: , p5_a29 JTF_NUMBER_TABLE
324: , p5_a30 JTF_DATE_TABLE
325: , p5_a31 JTF_NUMBER_TABLE
326: , p6_a0 out nocopy JTF_NUMBER_TABLE
327: , p6_a1 out nocopy JTF_NUMBER_TABLE
328: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
329: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
330: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
323: , p5_a29 JTF_NUMBER_TABLE
324: , p5_a30 JTF_DATE_TABLE
325: , p5_a31 JTF_NUMBER_TABLE
326: , p6_a0 out nocopy JTF_NUMBER_TABLE
327: , p6_a1 out nocopy JTF_NUMBER_TABLE
328: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
329: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
330: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
331: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
348: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
349: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
350: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
351: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
352: , p6_a26 out nocopy JTF_NUMBER_TABLE
353: , p6_a27 out nocopy JTF_NUMBER_TABLE
354: , p6_a28 out nocopy JTF_DATE_TABLE
355: , p6_a29 out nocopy JTF_NUMBER_TABLE
356: , p6_a30 out nocopy JTF_DATE_TABLE
349: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
350: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
351: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
352: , p6_a26 out nocopy JTF_NUMBER_TABLE
353: , p6_a27 out nocopy JTF_NUMBER_TABLE
354: , p6_a28 out nocopy JTF_DATE_TABLE
355: , p6_a29 out nocopy JTF_NUMBER_TABLE
356: , p6_a30 out nocopy JTF_DATE_TABLE
357: , p6_a31 out nocopy JTF_NUMBER_TABLE
351: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_500
352: , p6_a26 out nocopy JTF_NUMBER_TABLE
353: , p6_a27 out nocopy JTF_NUMBER_TABLE
354: , p6_a28 out nocopy JTF_DATE_TABLE
355: , p6_a29 out nocopy JTF_NUMBER_TABLE
356: , p6_a30 out nocopy JTF_DATE_TABLE
357: , p6_a31 out nocopy JTF_NUMBER_TABLE
358: );
359: procedure delete_data_src_fnctns(p_api_version NUMBER
353: , p6_a27 out nocopy JTF_NUMBER_TABLE
354: , p6_a28 out nocopy JTF_DATE_TABLE
355: , p6_a29 out nocopy JTF_NUMBER_TABLE
356: , p6_a30 out nocopy JTF_DATE_TABLE
357: , p6_a31 out nocopy JTF_NUMBER_TABLE
358: );
359: procedure delete_data_src_fnctns(p_api_version NUMBER
360: , p_init_msg_list VARCHAR2
361: , x_return_status out nocopy VARCHAR2
398: , p_init_msg_list VARCHAR2
399: , x_return_status out nocopy VARCHAR2
400: , x_msg_count out nocopy NUMBER
401: , x_msg_data out nocopy VARCHAR2
402: , p5_a0 JTF_NUMBER_TABLE
403: , p5_a1 JTF_NUMBER_TABLE
404: , p5_a2 JTF_VARCHAR2_TABLE_100
405: , p5_a3 JTF_VARCHAR2_TABLE_100
406: , p5_a4 JTF_VARCHAR2_TABLE_200
399: , x_return_status out nocopy VARCHAR2
400: , x_msg_count out nocopy NUMBER
401: , x_msg_data out nocopy VARCHAR2
402: , p5_a0 JTF_NUMBER_TABLE
403: , p5_a1 JTF_NUMBER_TABLE
404: , p5_a2 JTF_VARCHAR2_TABLE_100
405: , p5_a3 JTF_VARCHAR2_TABLE_100
406: , p5_a4 JTF_VARCHAR2_TABLE_200
407: , p5_a5 JTF_VARCHAR2_TABLE_2000
424: , p5_a22 JTF_VARCHAR2_TABLE_500
425: , p5_a23 JTF_VARCHAR2_TABLE_500
426: , p5_a24 JTF_VARCHAR2_TABLE_500
427: , p5_a25 JTF_VARCHAR2_TABLE_500
428: , p5_a26 JTF_NUMBER_TABLE
429: , p5_a27 JTF_NUMBER_TABLE
430: , p5_a28 JTF_DATE_TABLE
431: , p5_a29 JTF_NUMBER_TABLE
432: , p5_a30 JTF_DATE_TABLE
425: , p5_a23 JTF_VARCHAR2_TABLE_500
426: , p5_a24 JTF_VARCHAR2_TABLE_500
427: , p5_a25 JTF_VARCHAR2_TABLE_500
428: , p5_a26 JTF_NUMBER_TABLE
429: , p5_a27 JTF_NUMBER_TABLE
430: , p5_a28 JTF_DATE_TABLE
431: , p5_a29 JTF_NUMBER_TABLE
432: , p5_a30 JTF_DATE_TABLE
433: , p5_a31 JTF_NUMBER_TABLE
427: , p5_a25 JTF_VARCHAR2_TABLE_500
428: , p5_a26 JTF_NUMBER_TABLE
429: , p5_a27 JTF_NUMBER_TABLE
430: , p5_a28 JTF_DATE_TABLE
431: , p5_a29 JTF_NUMBER_TABLE
432: , p5_a30 JTF_DATE_TABLE
433: , p5_a31 JTF_NUMBER_TABLE
434: );
435: procedure validate_data_src_fnctns(p_api_version NUMBER
429: , p5_a27 JTF_NUMBER_TABLE
430: , p5_a28 JTF_DATE_TABLE
431: , p5_a29 JTF_NUMBER_TABLE
432: , p5_a30 JTF_DATE_TABLE
433: , p5_a31 JTF_NUMBER_TABLE
434: );
435: procedure validate_data_src_fnctns(p_api_version NUMBER
436: , p_init_msg_list VARCHAR2
437: , x_return_status out nocopy VARCHAR2
474: , p_init_msg_list VARCHAR2
475: , x_return_status out nocopy VARCHAR2
476: , x_msg_count out nocopy NUMBER
477: , x_msg_data out nocopy VARCHAR2
478: , p5_a0 JTF_NUMBER_TABLE
479: , p5_a1 JTF_NUMBER_TABLE
480: , p5_a2 JTF_VARCHAR2_TABLE_100
481: , p5_a3 JTF_VARCHAR2_TABLE_100
482: , p5_a4 JTF_VARCHAR2_TABLE_200
475: , x_return_status out nocopy VARCHAR2
476: , x_msg_count out nocopy NUMBER
477: , x_msg_data out nocopy VARCHAR2
478: , p5_a0 JTF_NUMBER_TABLE
479: , p5_a1 JTF_NUMBER_TABLE
480: , p5_a2 JTF_VARCHAR2_TABLE_100
481: , p5_a3 JTF_VARCHAR2_TABLE_100
482: , p5_a4 JTF_VARCHAR2_TABLE_200
483: , p5_a5 JTF_VARCHAR2_TABLE_2000
500: , p5_a22 JTF_VARCHAR2_TABLE_500
501: , p5_a23 JTF_VARCHAR2_TABLE_500
502: , p5_a24 JTF_VARCHAR2_TABLE_500
503: , p5_a25 JTF_VARCHAR2_TABLE_500
504: , p5_a26 JTF_NUMBER_TABLE
505: , p5_a27 JTF_NUMBER_TABLE
506: , p5_a28 JTF_DATE_TABLE
507: , p5_a29 JTF_NUMBER_TABLE
508: , p5_a30 JTF_DATE_TABLE
501: , p5_a23 JTF_VARCHAR2_TABLE_500
502: , p5_a24 JTF_VARCHAR2_TABLE_500
503: , p5_a25 JTF_VARCHAR2_TABLE_500
504: , p5_a26 JTF_NUMBER_TABLE
505: , p5_a27 JTF_NUMBER_TABLE
506: , p5_a28 JTF_DATE_TABLE
507: , p5_a29 JTF_NUMBER_TABLE
508: , p5_a30 JTF_DATE_TABLE
509: , p5_a31 JTF_NUMBER_TABLE
503: , p5_a25 JTF_VARCHAR2_TABLE_500
504: , p5_a26 JTF_NUMBER_TABLE
505: , p5_a27 JTF_NUMBER_TABLE
506: , p5_a28 JTF_DATE_TABLE
507: , p5_a29 JTF_NUMBER_TABLE
508: , p5_a30 JTF_DATE_TABLE
509: , p5_a31 JTF_NUMBER_TABLE
510: );
511: end okl_data_src_fnctns_pub_w;
505: , p5_a27 JTF_NUMBER_TABLE
506: , p5_a28 JTF_DATE_TABLE
507: , p5_a29 JTF_NUMBER_TABLE
508: , p5_a30 JTF_DATE_TABLE
509: , p5_a31 JTF_NUMBER_TABLE
510: );
511: end okl_data_src_fnctns_pub_w;