72: , p_init_msg_list VARCHAR2
73: , x_return_status out nocopy VARCHAR2
74: , x_msg_count out nocopy NUMBER
75: , x_msg_data out nocopy VARCHAR2
76: , p5_a0 JTF_NUMBER_TABLE
77: , p5_a1 JTF_VARCHAR2_TABLE_100
78: , p5_a2 JTF_VARCHAR2_TABLE_100
79: , p5_a3 JTF_VARCHAR2_TABLE_400
80: , p5_a4 JTF_VARCHAR2_TABLE_100
78: , p5_a2 JTF_VARCHAR2_TABLE_100
79: , p5_a3 JTF_VARCHAR2_TABLE_400
80: , p5_a4 JTF_VARCHAR2_TABLE_100
81: , p5_a5 JTF_VARCHAR2_TABLE_400
82: , p5_a6 JTF_NUMBER_TABLE
83: , p5_a7 JTF_VARCHAR2_TABLE_400
84: , p5_a8 JTF_VARCHAR2_TABLE_100
85: , p5_a9 JTF_DATE_TABLE
86: , p5_a10 JTF_DATE_TABLE
98: , p5_a22 JTF_VARCHAR2_TABLE_300
99: , p5_a23 JTF_VARCHAR2_TABLE_300
100: , p5_a24 JTF_VARCHAR2_TABLE_300
101: , p5_a25 JTF_VARCHAR2_TABLE_300
102: , p5_a26 JTF_NUMBER_TABLE
103: , p5_a27 JTF_DATE_TABLE
104: , p5_a28 JTF_NUMBER_TABLE
105: , p5_a29 JTF_DATE_TABLE
106: , p5_a30 JTF_NUMBER_TABLE
100: , p5_a24 JTF_VARCHAR2_TABLE_300
101: , p5_a25 JTF_VARCHAR2_TABLE_300
102: , p5_a26 JTF_NUMBER_TABLE
103: , p5_a27 JTF_DATE_TABLE
104: , p5_a28 JTF_NUMBER_TABLE
105: , p5_a29 JTF_DATE_TABLE
106: , p5_a30 JTF_NUMBER_TABLE
107: , p6_a0 out nocopy JTF_NUMBER_TABLE
108: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
102: , p5_a26 JTF_NUMBER_TABLE
103: , p5_a27 JTF_DATE_TABLE
104: , p5_a28 JTF_NUMBER_TABLE
105: , p5_a29 JTF_DATE_TABLE
106: , p5_a30 JTF_NUMBER_TABLE
107: , p6_a0 out nocopy JTF_NUMBER_TABLE
108: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
109: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_400
103: , p5_a27 JTF_DATE_TABLE
104: , p5_a28 JTF_NUMBER_TABLE
105: , p5_a29 JTF_DATE_TABLE
106: , p5_a30 JTF_NUMBER_TABLE
107: , p6_a0 out nocopy JTF_NUMBER_TABLE
108: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
109: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_400
111: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
109: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
110: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_400
111: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
112: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_400
113: , p6_a6 out nocopy JTF_NUMBER_TABLE
114: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_400
115: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
116: , p6_a9 out nocopy JTF_DATE_TABLE
117: , p6_a10 out nocopy JTF_DATE_TABLE
129: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
130: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_300
131: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
132: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
133: , p6_a26 out nocopy JTF_NUMBER_TABLE
134: , p6_a27 out nocopy JTF_DATE_TABLE
135: , p6_a28 out nocopy JTF_NUMBER_TABLE
136: , p6_a29 out nocopy JTF_DATE_TABLE
137: , p6_a30 out nocopy JTF_NUMBER_TABLE
131: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
132: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
133: , p6_a26 out nocopy JTF_NUMBER_TABLE
134: , p6_a27 out nocopy JTF_DATE_TABLE
135: , p6_a28 out nocopy JTF_NUMBER_TABLE
136: , p6_a29 out nocopy JTF_DATE_TABLE
137: , p6_a30 out nocopy JTF_NUMBER_TABLE
138: );
139: procedure lock_sgn_translations(p_api_version NUMBER
133: , p6_a26 out nocopy JTF_NUMBER_TABLE
134: , p6_a27 out nocopy JTF_DATE_TABLE
135: , p6_a28 out nocopy JTF_NUMBER_TABLE
136: , p6_a29 out nocopy JTF_DATE_TABLE
137: , p6_a30 out nocopy JTF_NUMBER_TABLE
138: );
139: procedure lock_sgn_translations(p_api_version NUMBER
140: , p_init_msg_list VARCHAR2
141: , x_return_status out nocopy VARCHAR2
177: , p_init_msg_list VARCHAR2
178: , x_return_status out nocopy VARCHAR2
179: , x_msg_count out nocopy NUMBER
180: , x_msg_data out nocopy VARCHAR2
181: , p5_a0 JTF_NUMBER_TABLE
182: , p5_a1 JTF_VARCHAR2_TABLE_100
183: , p5_a2 JTF_VARCHAR2_TABLE_100
184: , p5_a3 JTF_VARCHAR2_TABLE_400
185: , p5_a4 JTF_VARCHAR2_TABLE_100
183: , p5_a2 JTF_VARCHAR2_TABLE_100
184: , p5_a3 JTF_VARCHAR2_TABLE_400
185: , p5_a4 JTF_VARCHAR2_TABLE_100
186: , p5_a5 JTF_VARCHAR2_TABLE_400
187: , p5_a6 JTF_NUMBER_TABLE
188: , p5_a7 JTF_VARCHAR2_TABLE_400
189: , p5_a8 JTF_VARCHAR2_TABLE_100
190: , p5_a9 JTF_DATE_TABLE
191: , p5_a10 JTF_DATE_TABLE
203: , p5_a22 JTF_VARCHAR2_TABLE_300
204: , p5_a23 JTF_VARCHAR2_TABLE_300
205: , p5_a24 JTF_VARCHAR2_TABLE_300
206: , p5_a25 JTF_VARCHAR2_TABLE_300
207: , p5_a26 JTF_NUMBER_TABLE
208: , p5_a27 JTF_DATE_TABLE
209: , p5_a28 JTF_NUMBER_TABLE
210: , p5_a29 JTF_DATE_TABLE
211: , p5_a30 JTF_NUMBER_TABLE
205: , p5_a24 JTF_VARCHAR2_TABLE_300
206: , p5_a25 JTF_VARCHAR2_TABLE_300
207: , p5_a26 JTF_NUMBER_TABLE
208: , p5_a27 JTF_DATE_TABLE
209: , p5_a28 JTF_NUMBER_TABLE
210: , p5_a29 JTF_DATE_TABLE
211: , p5_a30 JTF_NUMBER_TABLE
212: );
213: procedure update_sgn_translations(p_api_version NUMBER
207: , p5_a26 JTF_NUMBER_TABLE
208: , p5_a27 JTF_DATE_TABLE
209: , p5_a28 JTF_NUMBER_TABLE
210: , p5_a29 JTF_DATE_TABLE
211: , p5_a30 JTF_NUMBER_TABLE
212: );
213: procedure update_sgn_translations(p_api_version NUMBER
214: , p_init_msg_list VARCHAR2
215: , x_return_status out nocopy VARCHAR2
282: , p_init_msg_list VARCHAR2
283: , x_return_status out nocopy VARCHAR2
284: , x_msg_count out nocopy NUMBER
285: , x_msg_data out nocopy VARCHAR2
286: , p5_a0 JTF_NUMBER_TABLE
287: , p5_a1 JTF_VARCHAR2_TABLE_100
288: , p5_a2 JTF_VARCHAR2_TABLE_100
289: , p5_a3 JTF_VARCHAR2_TABLE_400
290: , p5_a4 JTF_VARCHAR2_TABLE_100
288: , p5_a2 JTF_VARCHAR2_TABLE_100
289: , p5_a3 JTF_VARCHAR2_TABLE_400
290: , p5_a4 JTF_VARCHAR2_TABLE_100
291: , p5_a5 JTF_VARCHAR2_TABLE_400
292: , p5_a6 JTF_NUMBER_TABLE
293: , p5_a7 JTF_VARCHAR2_TABLE_400
294: , p5_a8 JTF_VARCHAR2_TABLE_100
295: , p5_a9 JTF_DATE_TABLE
296: , p5_a10 JTF_DATE_TABLE
308: , p5_a22 JTF_VARCHAR2_TABLE_300
309: , p5_a23 JTF_VARCHAR2_TABLE_300
310: , p5_a24 JTF_VARCHAR2_TABLE_300
311: , p5_a25 JTF_VARCHAR2_TABLE_300
312: , p5_a26 JTF_NUMBER_TABLE
313: , p5_a27 JTF_DATE_TABLE
314: , p5_a28 JTF_NUMBER_TABLE
315: , p5_a29 JTF_DATE_TABLE
316: , p5_a30 JTF_NUMBER_TABLE
310: , p5_a24 JTF_VARCHAR2_TABLE_300
311: , p5_a25 JTF_VARCHAR2_TABLE_300
312: , p5_a26 JTF_NUMBER_TABLE
313: , p5_a27 JTF_DATE_TABLE
314: , p5_a28 JTF_NUMBER_TABLE
315: , p5_a29 JTF_DATE_TABLE
316: , p5_a30 JTF_NUMBER_TABLE
317: , p6_a0 out nocopy JTF_NUMBER_TABLE
318: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
312: , p5_a26 JTF_NUMBER_TABLE
313: , p5_a27 JTF_DATE_TABLE
314: , p5_a28 JTF_NUMBER_TABLE
315: , p5_a29 JTF_DATE_TABLE
316: , p5_a30 JTF_NUMBER_TABLE
317: , p6_a0 out nocopy JTF_NUMBER_TABLE
318: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
319: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
320: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_400
313: , p5_a27 JTF_DATE_TABLE
314: , p5_a28 JTF_NUMBER_TABLE
315: , p5_a29 JTF_DATE_TABLE
316: , p5_a30 JTF_NUMBER_TABLE
317: , p6_a0 out nocopy JTF_NUMBER_TABLE
318: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
319: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
320: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_400
321: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
319: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
320: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_400
321: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
322: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_400
323: , p6_a6 out nocopy JTF_NUMBER_TABLE
324: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_400
325: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
326: , p6_a9 out nocopy JTF_DATE_TABLE
327: , p6_a10 out nocopy JTF_DATE_TABLE
339: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
340: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_300
341: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
342: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
343: , p6_a26 out nocopy JTF_NUMBER_TABLE
344: , p6_a27 out nocopy JTF_DATE_TABLE
345: , p6_a28 out nocopy JTF_NUMBER_TABLE
346: , p6_a29 out nocopy JTF_DATE_TABLE
347: , p6_a30 out nocopy JTF_NUMBER_TABLE
341: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
342: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
343: , p6_a26 out nocopy JTF_NUMBER_TABLE
344: , p6_a27 out nocopy JTF_DATE_TABLE
345: , p6_a28 out nocopy JTF_NUMBER_TABLE
346: , p6_a29 out nocopy JTF_DATE_TABLE
347: , p6_a30 out nocopy JTF_NUMBER_TABLE
348: );
349: procedure delete_sgn_translations(p_api_version NUMBER
343: , p6_a26 out nocopy JTF_NUMBER_TABLE
344: , p6_a27 out nocopy JTF_DATE_TABLE
345: , p6_a28 out nocopy JTF_NUMBER_TABLE
346: , p6_a29 out nocopy JTF_DATE_TABLE
347: , p6_a30 out nocopy JTF_NUMBER_TABLE
348: );
349: procedure delete_sgn_translations(p_api_version NUMBER
350: , p_init_msg_list VARCHAR2
351: , x_return_status out nocopy VARCHAR2
387: , p_init_msg_list VARCHAR2
388: , x_return_status out nocopy VARCHAR2
389: , x_msg_count out nocopy NUMBER
390: , x_msg_data out nocopy VARCHAR2
391: , p5_a0 JTF_NUMBER_TABLE
392: , p5_a1 JTF_VARCHAR2_TABLE_100
393: , p5_a2 JTF_VARCHAR2_TABLE_100
394: , p5_a3 JTF_VARCHAR2_TABLE_400
395: , p5_a4 JTF_VARCHAR2_TABLE_100
393: , p5_a2 JTF_VARCHAR2_TABLE_100
394: , p5_a3 JTF_VARCHAR2_TABLE_400
395: , p5_a4 JTF_VARCHAR2_TABLE_100
396: , p5_a5 JTF_VARCHAR2_TABLE_400
397: , p5_a6 JTF_NUMBER_TABLE
398: , p5_a7 JTF_VARCHAR2_TABLE_400
399: , p5_a8 JTF_VARCHAR2_TABLE_100
400: , p5_a9 JTF_DATE_TABLE
401: , p5_a10 JTF_DATE_TABLE
413: , p5_a22 JTF_VARCHAR2_TABLE_300
414: , p5_a23 JTF_VARCHAR2_TABLE_300
415: , p5_a24 JTF_VARCHAR2_TABLE_300
416: , p5_a25 JTF_VARCHAR2_TABLE_300
417: , p5_a26 JTF_NUMBER_TABLE
418: , p5_a27 JTF_DATE_TABLE
419: , p5_a28 JTF_NUMBER_TABLE
420: , p5_a29 JTF_DATE_TABLE
421: , p5_a30 JTF_NUMBER_TABLE
415: , p5_a24 JTF_VARCHAR2_TABLE_300
416: , p5_a25 JTF_VARCHAR2_TABLE_300
417: , p5_a26 JTF_NUMBER_TABLE
418: , p5_a27 JTF_DATE_TABLE
419: , p5_a28 JTF_NUMBER_TABLE
420: , p5_a29 JTF_DATE_TABLE
421: , p5_a30 JTF_NUMBER_TABLE
422: );
423: procedure validate_sgn_translations(p_api_version NUMBER
417: , p5_a26 JTF_NUMBER_TABLE
418: , p5_a27 JTF_DATE_TABLE
419: , p5_a28 JTF_NUMBER_TABLE
420: , p5_a29 JTF_DATE_TABLE
421: , p5_a30 JTF_NUMBER_TABLE
422: );
423: procedure validate_sgn_translations(p_api_version NUMBER
424: , p_init_msg_list VARCHAR2
425: , x_return_status out nocopy VARCHAR2
492: , p_init_msg_list VARCHAR2
493: , x_return_status out nocopy VARCHAR2
494: , x_msg_count out nocopy NUMBER
495: , x_msg_data out nocopy VARCHAR2
496: , p5_a0 JTF_NUMBER_TABLE
497: , p5_a1 JTF_VARCHAR2_TABLE_100
498: , p5_a2 JTF_VARCHAR2_TABLE_100
499: , p5_a3 JTF_VARCHAR2_TABLE_400
500: , p5_a4 JTF_VARCHAR2_TABLE_100
498: , p5_a2 JTF_VARCHAR2_TABLE_100
499: , p5_a3 JTF_VARCHAR2_TABLE_400
500: , p5_a4 JTF_VARCHAR2_TABLE_100
501: , p5_a5 JTF_VARCHAR2_TABLE_400
502: , p5_a6 JTF_NUMBER_TABLE
503: , p5_a7 JTF_VARCHAR2_TABLE_400
504: , p5_a8 JTF_VARCHAR2_TABLE_100
505: , p5_a9 JTF_DATE_TABLE
506: , p5_a10 JTF_DATE_TABLE
518: , p5_a22 JTF_VARCHAR2_TABLE_300
519: , p5_a23 JTF_VARCHAR2_TABLE_300
520: , p5_a24 JTF_VARCHAR2_TABLE_300
521: , p5_a25 JTF_VARCHAR2_TABLE_300
522: , p5_a26 JTF_NUMBER_TABLE
523: , p5_a27 JTF_DATE_TABLE
524: , p5_a28 JTF_NUMBER_TABLE
525: , p5_a29 JTF_DATE_TABLE
526: , p5_a30 JTF_NUMBER_TABLE
520: , p5_a24 JTF_VARCHAR2_TABLE_300
521: , p5_a25 JTF_VARCHAR2_TABLE_300
522: , p5_a26 JTF_NUMBER_TABLE
523: , p5_a27 JTF_DATE_TABLE
524: , p5_a28 JTF_NUMBER_TABLE
525: , p5_a29 JTF_DATE_TABLE
526: , p5_a30 JTF_NUMBER_TABLE
527: , p6_a0 out nocopy JTF_NUMBER_TABLE
528: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
522: , p5_a26 JTF_NUMBER_TABLE
523: , p5_a27 JTF_DATE_TABLE
524: , p5_a28 JTF_NUMBER_TABLE
525: , p5_a29 JTF_DATE_TABLE
526: , p5_a30 JTF_NUMBER_TABLE
527: , p6_a0 out nocopy JTF_NUMBER_TABLE
528: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
529: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
530: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_400
523: , p5_a27 JTF_DATE_TABLE
524: , p5_a28 JTF_NUMBER_TABLE
525: , p5_a29 JTF_DATE_TABLE
526: , p5_a30 JTF_NUMBER_TABLE
527: , p6_a0 out nocopy JTF_NUMBER_TABLE
528: , p6_a1 out nocopy JTF_VARCHAR2_TABLE_100
529: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
530: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_400
531: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
529: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
530: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_400
531: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
532: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_400
533: , p6_a6 out nocopy JTF_NUMBER_TABLE
534: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_400
535: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_100
536: , p6_a9 out nocopy JTF_DATE_TABLE
537: , p6_a10 out nocopy JTF_DATE_TABLE
549: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_300
550: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_300
551: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
552: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
553: , p6_a26 out nocopy JTF_NUMBER_TABLE
554: , p6_a27 out nocopy JTF_DATE_TABLE
555: , p6_a28 out nocopy JTF_NUMBER_TABLE
556: , p6_a29 out nocopy JTF_DATE_TABLE
557: , p6_a30 out nocopy JTF_NUMBER_TABLE
551: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_300
552: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_300
553: , p6_a26 out nocopy JTF_NUMBER_TABLE
554: , p6_a27 out nocopy JTF_DATE_TABLE
555: , p6_a28 out nocopy JTF_NUMBER_TABLE
556: , p6_a29 out nocopy JTF_DATE_TABLE
557: , p6_a30 out nocopy JTF_NUMBER_TABLE
558: );
559: end okl_sgn_translations_pub_w;
553: , p6_a26 out nocopy JTF_NUMBER_TABLE
554: , p6_a27 out nocopy JTF_DATE_TABLE
555: , p6_a28 out nocopy JTF_NUMBER_TABLE
556: , p6_a29 out nocopy JTF_DATE_TABLE
557: , p6_a30 out nocopy JTF_NUMBER_TABLE
558: );
559: end okl_sgn_translations_pub_w;