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_VARCHAR2_TABLE_100
14: , p5_a6 JTF_DATE_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_VARCHAR2_TABLE_100
13: , p5_a5 JTF_VARCHAR2_TABLE_100
14: , p5_a6 JTF_DATE_TABLE
15: , p5_a7 JTF_DATE_TABLE
16: , p5_a8 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_VARCHAR2_TABLE_100
14: , p5_a6 JTF_DATE_TABLE
15: , p5_a7 JTF_DATE_TABLE
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_VARCHAR2_TABLE_100
13: , p5_a5 JTF_VARCHAR2_TABLE_100
14: , p5_a6 JTF_DATE_TABLE
15: , p5_a7 JTF_DATE_TABLE
16: , p5_a8 JTF_NUMBER_TABLE
17: , p5_a9 JTF_VARCHAR2_TABLE_100
18: , p5_a10 JTF_VARCHAR2_TABLE_500
19: , p5_a11 JTF_VARCHAR2_TABLE_500
20: , p5_a12 JTF_VARCHAR2_TABLE_500
21: , p5_a13 JTF_VARCHAR2_TABLE_500
34: , p5_a26 JTF_DATE_TABLE
35: , p5_a27 JTF_NUMBER_TABLE
36: , p5_a28 JTF_DATE_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_VARCHAR2_TABLE_100
39: , p5_a31 JTF_VARCHAR2_TABLE_100
40: , p6_a0 out nocopy JTF_NUMBER_TABLE
41: , p6_a1 out nocopy JTF_NUMBER_TABLE
42: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
35: , p5_a27 JTF_NUMBER_TABLE
36: , p5_a28 JTF_DATE_TABLE
37: , p5_a29 JTF_NUMBER_TABLE
38: , p5_a30 JTF_VARCHAR2_TABLE_100
39: , p5_a31 JTF_VARCHAR2_TABLE_100
40: , p6_a0 out nocopy JTF_NUMBER_TABLE
41: , p6_a1 out nocopy JTF_NUMBER_TABLE
42: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , p6_a3 out nocopy JTF_NUMBER_TABLE
38: , p5_a30 JTF_VARCHAR2_TABLE_100
39: , p5_a31 JTF_VARCHAR2_TABLE_100
40: , p6_a0 out nocopy JTF_NUMBER_TABLE
41: , p6_a1 out nocopy JTF_NUMBER_TABLE
42: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , p6_a3 out nocopy JTF_NUMBER_TABLE
44: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
45: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
46: , p6_a6 out nocopy JTF_DATE_TABLE
40: , p6_a0 out nocopy JTF_NUMBER_TABLE
41: , p6_a1 out nocopy JTF_NUMBER_TABLE
42: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , p6_a3 out nocopy JTF_NUMBER_TABLE
44: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
45: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
46: , p6_a6 out nocopy JTF_DATE_TABLE
47: , p6_a7 out nocopy JTF_DATE_TABLE
48: , p6_a8 out nocopy JTF_NUMBER_TABLE
41: , p6_a1 out nocopy JTF_NUMBER_TABLE
42: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , p6_a3 out nocopy JTF_NUMBER_TABLE
44: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
45: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
46: , p6_a6 out nocopy JTF_DATE_TABLE
47: , p6_a7 out nocopy JTF_DATE_TABLE
48: , p6_a8 out nocopy JTF_NUMBER_TABLE
49: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
45: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
46: , p6_a6 out nocopy JTF_DATE_TABLE
47: , p6_a7 out nocopy JTF_DATE_TABLE
48: , p6_a8 out nocopy JTF_NUMBER_TABLE
49: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
50: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
51: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
52: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
53: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
66: , p6_a26 out nocopy JTF_DATE_TABLE
67: , p6_a27 out nocopy JTF_NUMBER_TABLE
68: , p6_a28 out nocopy JTF_DATE_TABLE
69: , p6_a29 out nocopy JTF_NUMBER_TABLE
70: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
71: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
72: );
73: procedure insert_process_tmplts(p_api_version NUMBER
74: , p_init_msg_list VARCHAR2
67: , p6_a27 out nocopy JTF_NUMBER_TABLE
68: , p6_a28 out nocopy JTF_DATE_TABLE
69: , p6_a29 out nocopy JTF_NUMBER_TABLE
70: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
71: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
72: );
73: procedure insert_process_tmplts(p_api_version NUMBER
74: , p_init_msg_list VARCHAR2
75: , x_return_status out nocopy VARCHAR2
146: , x_msg_count out nocopy NUMBER
147: , x_msg_data out nocopy VARCHAR2
148: , p5_a0 JTF_NUMBER_TABLE
149: , p5_a1 JTF_NUMBER_TABLE
150: , p5_a2 JTF_VARCHAR2_TABLE_100
151: , p5_a3 JTF_NUMBER_TABLE
152: , p5_a4 JTF_VARCHAR2_TABLE_100
153: , p5_a5 JTF_VARCHAR2_TABLE_100
154: , p5_a6 JTF_DATE_TABLE
148: , p5_a0 JTF_NUMBER_TABLE
149: , p5_a1 JTF_NUMBER_TABLE
150: , p5_a2 JTF_VARCHAR2_TABLE_100
151: , p5_a3 JTF_NUMBER_TABLE
152: , p5_a4 JTF_VARCHAR2_TABLE_100
153: , p5_a5 JTF_VARCHAR2_TABLE_100
154: , p5_a6 JTF_DATE_TABLE
155: , p5_a7 JTF_DATE_TABLE
156: , p5_a8 JTF_NUMBER_TABLE
149: , p5_a1 JTF_NUMBER_TABLE
150: , p5_a2 JTF_VARCHAR2_TABLE_100
151: , p5_a3 JTF_NUMBER_TABLE
152: , p5_a4 JTF_VARCHAR2_TABLE_100
153: , p5_a5 JTF_VARCHAR2_TABLE_100
154: , p5_a6 JTF_DATE_TABLE
155: , p5_a7 JTF_DATE_TABLE
156: , p5_a8 JTF_NUMBER_TABLE
157: , p5_a9 JTF_VARCHAR2_TABLE_100
153: , p5_a5 JTF_VARCHAR2_TABLE_100
154: , p5_a6 JTF_DATE_TABLE
155: , p5_a7 JTF_DATE_TABLE
156: , p5_a8 JTF_NUMBER_TABLE
157: , p5_a9 JTF_VARCHAR2_TABLE_100
158: , p5_a10 JTF_VARCHAR2_TABLE_500
159: , p5_a11 JTF_VARCHAR2_TABLE_500
160: , p5_a12 JTF_VARCHAR2_TABLE_500
161: , p5_a13 JTF_VARCHAR2_TABLE_500
174: , p5_a26 JTF_DATE_TABLE
175: , p5_a27 JTF_NUMBER_TABLE
176: , p5_a28 JTF_DATE_TABLE
177: , p5_a29 JTF_NUMBER_TABLE
178: , p5_a30 JTF_VARCHAR2_TABLE_100
179: , p5_a31 JTF_VARCHAR2_TABLE_100
180: );
181: procedure lock_process_tmplts(p_api_version NUMBER
182: , p_init_msg_list VARCHAR2
175: , p5_a27 JTF_NUMBER_TABLE
176: , p5_a28 JTF_DATE_TABLE
177: , p5_a29 JTF_NUMBER_TABLE
178: , p5_a30 JTF_VARCHAR2_TABLE_100
179: , p5_a31 JTF_VARCHAR2_TABLE_100
180: );
181: procedure lock_process_tmplts(p_api_version NUMBER
182: , p_init_msg_list VARCHAR2
183: , x_return_status out nocopy VARCHAR2
222: , x_msg_count out nocopy NUMBER
223: , x_msg_data out nocopy VARCHAR2
224: , p5_a0 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_100
227: , p5_a3 JTF_NUMBER_TABLE
228: , p5_a4 JTF_VARCHAR2_TABLE_100
229: , p5_a5 JTF_VARCHAR2_TABLE_100
230: , p5_a6 JTF_DATE_TABLE
224: , p5_a0 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_100
227: , p5_a3 JTF_NUMBER_TABLE
228: , p5_a4 JTF_VARCHAR2_TABLE_100
229: , p5_a5 JTF_VARCHAR2_TABLE_100
230: , p5_a6 JTF_DATE_TABLE
231: , p5_a7 JTF_DATE_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
225: , p5_a1 JTF_NUMBER_TABLE
226: , p5_a2 JTF_VARCHAR2_TABLE_100
227: , p5_a3 JTF_NUMBER_TABLE
228: , p5_a4 JTF_VARCHAR2_TABLE_100
229: , p5_a5 JTF_VARCHAR2_TABLE_100
230: , p5_a6 JTF_DATE_TABLE
231: , p5_a7 JTF_DATE_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_VARCHAR2_TABLE_100
229: , p5_a5 JTF_VARCHAR2_TABLE_100
230: , p5_a6 JTF_DATE_TABLE
231: , p5_a7 JTF_DATE_TABLE
232: , p5_a8 JTF_NUMBER_TABLE
233: , p5_a9 JTF_VARCHAR2_TABLE_100
234: , p5_a10 JTF_VARCHAR2_TABLE_500
235: , p5_a11 JTF_VARCHAR2_TABLE_500
236: , p5_a12 JTF_VARCHAR2_TABLE_500
237: , p5_a13 JTF_VARCHAR2_TABLE_500
250: , p5_a26 JTF_DATE_TABLE
251: , p5_a27 JTF_NUMBER_TABLE
252: , p5_a28 JTF_DATE_TABLE
253: , p5_a29 JTF_NUMBER_TABLE
254: , p5_a30 JTF_VARCHAR2_TABLE_100
255: , p5_a31 JTF_VARCHAR2_TABLE_100
256: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
251: , p5_a27 JTF_NUMBER_TABLE
252: , p5_a28 JTF_DATE_TABLE
253: , p5_a29 JTF_NUMBER_TABLE
254: , p5_a30 JTF_VARCHAR2_TABLE_100
255: , p5_a31 JTF_VARCHAR2_TABLE_100
256: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a3 out nocopy JTF_NUMBER_TABLE
254: , p5_a30 JTF_VARCHAR2_TABLE_100
255: , p5_a31 JTF_VARCHAR2_TABLE_100
256: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a3 out nocopy JTF_NUMBER_TABLE
260: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
262: , p6_a6 out nocopy JTF_DATE_TABLE
256: , p6_a0 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a3 out nocopy JTF_NUMBER_TABLE
260: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
262: , p6_a6 out nocopy JTF_DATE_TABLE
263: , p6_a7 out nocopy JTF_DATE_TABLE
264: , p6_a8 out nocopy JTF_NUMBER_TABLE
257: , p6_a1 out nocopy JTF_NUMBER_TABLE
258: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
259: , p6_a3 out nocopy JTF_NUMBER_TABLE
260: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
262: , p6_a6 out nocopy JTF_DATE_TABLE
263: , p6_a7 out nocopy JTF_DATE_TABLE
264: , p6_a8 out nocopy JTF_NUMBER_TABLE
265: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
261: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
262: , p6_a6 out nocopy JTF_DATE_TABLE
263: , p6_a7 out nocopy JTF_DATE_TABLE
264: , p6_a8 out nocopy JTF_NUMBER_TABLE
265: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
266: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
267: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_500
268: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_500
269: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_500
282: , p6_a26 out nocopy JTF_DATE_TABLE
283: , p6_a27 out nocopy JTF_NUMBER_TABLE
284: , p6_a28 out nocopy JTF_DATE_TABLE
285: , p6_a29 out nocopy JTF_NUMBER_TABLE
286: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
287: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
288: );
289: procedure update_process_tmplts(p_api_version NUMBER
290: , p_init_msg_list VARCHAR2
283: , p6_a27 out nocopy JTF_NUMBER_TABLE
284: , p6_a28 out nocopy JTF_DATE_TABLE
285: , p6_a29 out nocopy JTF_NUMBER_TABLE
286: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
287: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
288: );
289: procedure update_process_tmplts(p_api_version NUMBER
290: , p_init_msg_list VARCHAR2
291: , x_return_status out nocopy VARCHAR2
362: , x_msg_count out nocopy NUMBER
363: , x_msg_data out nocopy VARCHAR2
364: , p5_a0 JTF_NUMBER_TABLE
365: , p5_a1 JTF_NUMBER_TABLE
366: , p5_a2 JTF_VARCHAR2_TABLE_100
367: , p5_a3 JTF_NUMBER_TABLE
368: , p5_a4 JTF_VARCHAR2_TABLE_100
369: , p5_a5 JTF_VARCHAR2_TABLE_100
370: , p5_a6 JTF_DATE_TABLE
364: , p5_a0 JTF_NUMBER_TABLE
365: , p5_a1 JTF_NUMBER_TABLE
366: , p5_a2 JTF_VARCHAR2_TABLE_100
367: , p5_a3 JTF_NUMBER_TABLE
368: , p5_a4 JTF_VARCHAR2_TABLE_100
369: , p5_a5 JTF_VARCHAR2_TABLE_100
370: , p5_a6 JTF_DATE_TABLE
371: , p5_a7 JTF_DATE_TABLE
372: , p5_a8 JTF_NUMBER_TABLE
365: , p5_a1 JTF_NUMBER_TABLE
366: , p5_a2 JTF_VARCHAR2_TABLE_100
367: , p5_a3 JTF_NUMBER_TABLE
368: , p5_a4 JTF_VARCHAR2_TABLE_100
369: , p5_a5 JTF_VARCHAR2_TABLE_100
370: , p5_a6 JTF_DATE_TABLE
371: , p5_a7 JTF_DATE_TABLE
372: , p5_a8 JTF_NUMBER_TABLE
373: , p5_a9 JTF_VARCHAR2_TABLE_100
369: , p5_a5 JTF_VARCHAR2_TABLE_100
370: , p5_a6 JTF_DATE_TABLE
371: , p5_a7 JTF_DATE_TABLE
372: , p5_a8 JTF_NUMBER_TABLE
373: , p5_a9 JTF_VARCHAR2_TABLE_100
374: , p5_a10 JTF_VARCHAR2_TABLE_500
375: , p5_a11 JTF_VARCHAR2_TABLE_500
376: , p5_a12 JTF_VARCHAR2_TABLE_500
377: , p5_a13 JTF_VARCHAR2_TABLE_500
390: , p5_a26 JTF_DATE_TABLE
391: , p5_a27 JTF_NUMBER_TABLE
392: , p5_a28 JTF_DATE_TABLE
393: , p5_a29 JTF_NUMBER_TABLE
394: , p5_a30 JTF_VARCHAR2_TABLE_100
395: , p5_a31 JTF_VARCHAR2_TABLE_100
396: );
397: procedure delete_process_tmplts(p_api_version NUMBER
398: , p_init_msg_list VARCHAR2
391: , p5_a27 JTF_NUMBER_TABLE
392: , p5_a28 JTF_DATE_TABLE
393: , p5_a29 JTF_NUMBER_TABLE
394: , p5_a30 JTF_VARCHAR2_TABLE_100
395: , p5_a31 JTF_VARCHAR2_TABLE_100
396: );
397: procedure delete_process_tmplts(p_api_version NUMBER
398: , p_init_msg_list VARCHAR2
399: , x_return_status out nocopy VARCHAR2
438: , x_msg_count out nocopy NUMBER
439: , x_msg_data out nocopy VARCHAR2
440: , p5_a0 JTF_NUMBER_TABLE
441: , p5_a1 JTF_NUMBER_TABLE
442: , p5_a2 JTF_VARCHAR2_TABLE_100
443: , p5_a3 JTF_NUMBER_TABLE
444: , p5_a4 JTF_VARCHAR2_TABLE_100
445: , p5_a5 JTF_VARCHAR2_TABLE_100
446: , p5_a6 JTF_DATE_TABLE
440: , p5_a0 JTF_NUMBER_TABLE
441: , p5_a1 JTF_NUMBER_TABLE
442: , p5_a2 JTF_VARCHAR2_TABLE_100
443: , p5_a3 JTF_NUMBER_TABLE
444: , p5_a4 JTF_VARCHAR2_TABLE_100
445: , p5_a5 JTF_VARCHAR2_TABLE_100
446: , p5_a6 JTF_DATE_TABLE
447: , p5_a7 JTF_DATE_TABLE
448: , p5_a8 JTF_NUMBER_TABLE
441: , p5_a1 JTF_NUMBER_TABLE
442: , p5_a2 JTF_VARCHAR2_TABLE_100
443: , p5_a3 JTF_NUMBER_TABLE
444: , p5_a4 JTF_VARCHAR2_TABLE_100
445: , p5_a5 JTF_VARCHAR2_TABLE_100
446: , p5_a6 JTF_DATE_TABLE
447: , p5_a7 JTF_DATE_TABLE
448: , p5_a8 JTF_NUMBER_TABLE
449: , p5_a9 JTF_VARCHAR2_TABLE_100
445: , p5_a5 JTF_VARCHAR2_TABLE_100
446: , p5_a6 JTF_DATE_TABLE
447: , p5_a7 JTF_DATE_TABLE
448: , p5_a8 JTF_NUMBER_TABLE
449: , p5_a9 JTF_VARCHAR2_TABLE_100
450: , p5_a10 JTF_VARCHAR2_TABLE_500
451: , p5_a11 JTF_VARCHAR2_TABLE_500
452: , p5_a12 JTF_VARCHAR2_TABLE_500
453: , p5_a13 JTF_VARCHAR2_TABLE_500
466: , p5_a26 JTF_DATE_TABLE
467: , p5_a27 JTF_NUMBER_TABLE
468: , p5_a28 JTF_DATE_TABLE
469: , p5_a29 JTF_NUMBER_TABLE
470: , p5_a30 JTF_VARCHAR2_TABLE_100
471: , p5_a31 JTF_VARCHAR2_TABLE_100
472: );
473: procedure validate_process_tmplts(p_api_version NUMBER
474: , p_init_msg_list VARCHAR2
467: , p5_a27 JTF_NUMBER_TABLE
468: , p5_a28 JTF_DATE_TABLE
469: , p5_a29 JTF_NUMBER_TABLE
470: , p5_a30 JTF_VARCHAR2_TABLE_100
471: , p5_a31 JTF_VARCHAR2_TABLE_100
472: );
473: procedure validate_process_tmplts(p_api_version NUMBER
474: , p_init_msg_list VARCHAR2
475: , x_return_status out nocopy VARCHAR2