1: package okl_pool_pvt_w as
2: /* $Header: OKLESZPS.pls 120.5 2007/12/14 11:10:47 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p46(t out nocopy okl_pool_pvt.polsrch_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_400
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
2: /* $Header: OKLESZPS.pls 120.5 2007/12/14 11:10:47 ssdeshpa noship $ */
3: procedure rosetta_table_copy_in_p46(t out nocopy okl_pool_pvt.polsrch_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_VARCHAR2_TABLE_400
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_VARCHAR2_TABLE_400
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
7: , a4 JTF_VARCHAR2_TABLE_200
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_DATE_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
15: , a12 JTF_DATE_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_500
19: , a16 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_NUMBER_TABLE
20: , a17 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_100
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
23: , a20 JTF_VARCHAR2_TABLE_100
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_200
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_200
32: , a29 JTF_VARCHAR2_TABLE_200
25: , a22 JTF_NUMBER_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_200
32: , a29 JTF_VARCHAR2_TABLE_200
33: , a30 JTF_VARCHAR2_TABLE_100
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_NUMBER_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_VARCHAR2_TABLE_200
32: , a29 JTF_VARCHAR2_TABLE_200
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_DATE_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_DATE_TABLE
36: , a33 JTF_DATE_TABLE
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_NUMBER_TABLE
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_DATE_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
40: , a37 JTF_DATE_TABLE
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: );
44: procedure rosetta_table_copy_out_p46(t okl_pool_pvt.polsrch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_VARCHAR2_TABLE_400
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_200
43: );
44: procedure rosetta_table_copy_out_p46(t okl_pool_pvt.polsrch_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
45: , a1 out nocopy JTF_VARCHAR2_TABLE_400
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_200
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_VARCHAR2_TABLE_100
45: , a1 out nocopy JTF_VARCHAR2_TABLE_400
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_200
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_VARCHAR2_TABLE_100
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_DATE_TABLE
46: , a2 out nocopy JTF_VARCHAR2_TABLE_100
47: , a3 out nocopy JTF_NUMBER_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_200
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_VARCHAR2_TABLE_100
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_DATE_TABLE
54: , a10 out nocopy JTF_DATE_TABLE
48: , a4 out nocopy JTF_VARCHAR2_TABLE_200
49: , a5 out nocopy JTF_NUMBER_TABLE
50: , a6 out nocopy JTF_NUMBER_TABLE
51: , a7 out nocopy JTF_VARCHAR2_TABLE_100
52: , a8 out nocopy JTF_NUMBER_TABLE
53: , a9 out nocopy JTF_DATE_TABLE
54: , a10 out nocopy JTF_DATE_TABLE
55: , a11 out nocopy JTF_DATE_TABLE
56: , a12 out nocopy JTF_DATE_TABLE
53: , a9 out nocopy JTF_DATE_TABLE
54: , a10 out nocopy JTF_DATE_TABLE
55: , a11 out nocopy JTF_DATE_TABLE
56: , a12 out nocopy JTF_DATE_TABLE
57: , a13 out nocopy JTF_NUMBER_TABLE
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_VARCHAR2_TABLE_500
60: , a16 out nocopy JTF_NUMBER_TABLE
61: , a17 out nocopy JTF_NUMBER_TABLE
56: , a12 out nocopy JTF_DATE_TABLE
57: , a13 out nocopy JTF_NUMBER_TABLE
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_VARCHAR2_TABLE_500
60: , a16 out nocopy JTF_NUMBER_TABLE
61: , a17 out nocopy JTF_NUMBER_TABLE
62: , a18 out nocopy JTF_VARCHAR2_TABLE_100
63: , a19 out nocopy JTF_VARCHAR2_TABLE_100
64: , a20 out nocopy JTF_VARCHAR2_TABLE_100
57: , a13 out nocopy JTF_NUMBER_TABLE
58: , a14 out nocopy JTF_VARCHAR2_TABLE_100
59: , a15 out nocopy JTF_VARCHAR2_TABLE_500
60: , a16 out nocopy JTF_NUMBER_TABLE
61: , a17 out nocopy JTF_NUMBER_TABLE
62: , a18 out nocopy JTF_VARCHAR2_TABLE_100
63: , a19 out nocopy JTF_VARCHAR2_TABLE_100
64: , a20 out nocopy JTF_VARCHAR2_TABLE_100
65: , a21 out nocopy JTF_NUMBER_TABLE
61: , a17 out nocopy JTF_NUMBER_TABLE
62: , a18 out nocopy JTF_VARCHAR2_TABLE_100
63: , a19 out nocopy JTF_VARCHAR2_TABLE_100
64: , a20 out nocopy JTF_VARCHAR2_TABLE_100
65: , a21 out nocopy JTF_NUMBER_TABLE
66: , a22 out nocopy JTF_NUMBER_TABLE
67: , a23 out nocopy JTF_NUMBER_TABLE
68: , a24 out nocopy JTF_NUMBER_TABLE
69: , a25 out nocopy JTF_NUMBER_TABLE
62: , a18 out nocopy JTF_VARCHAR2_TABLE_100
63: , a19 out nocopy JTF_VARCHAR2_TABLE_100
64: , a20 out nocopy JTF_VARCHAR2_TABLE_100
65: , a21 out nocopy JTF_NUMBER_TABLE
66: , a22 out nocopy JTF_NUMBER_TABLE
67: , a23 out nocopy JTF_NUMBER_TABLE
68: , a24 out nocopy JTF_NUMBER_TABLE
69: , a25 out nocopy JTF_NUMBER_TABLE
70: , a26 out nocopy JTF_NUMBER_TABLE
63: , a19 out nocopy JTF_VARCHAR2_TABLE_100
64: , a20 out nocopy JTF_VARCHAR2_TABLE_100
65: , a21 out nocopy JTF_NUMBER_TABLE
66: , a22 out nocopy JTF_NUMBER_TABLE
67: , a23 out nocopy JTF_NUMBER_TABLE
68: , a24 out nocopy JTF_NUMBER_TABLE
69: , a25 out nocopy JTF_NUMBER_TABLE
70: , a26 out nocopy JTF_NUMBER_TABLE
71: , a27 out nocopy JTF_NUMBER_TABLE
64: , a20 out nocopy JTF_VARCHAR2_TABLE_100
65: , a21 out nocopy JTF_NUMBER_TABLE
66: , a22 out nocopy JTF_NUMBER_TABLE
67: , a23 out nocopy JTF_NUMBER_TABLE
68: , a24 out nocopy JTF_NUMBER_TABLE
69: , a25 out nocopy JTF_NUMBER_TABLE
70: , a26 out nocopy JTF_NUMBER_TABLE
71: , a27 out nocopy JTF_NUMBER_TABLE
72: , a28 out nocopy JTF_VARCHAR2_TABLE_200
65: , a21 out nocopy JTF_NUMBER_TABLE
66: , a22 out nocopy JTF_NUMBER_TABLE
67: , a23 out nocopy JTF_NUMBER_TABLE
68: , a24 out nocopy JTF_NUMBER_TABLE
69: , a25 out nocopy JTF_NUMBER_TABLE
70: , a26 out nocopy JTF_NUMBER_TABLE
71: , a27 out nocopy JTF_NUMBER_TABLE
72: , a28 out nocopy JTF_VARCHAR2_TABLE_200
73: , a29 out nocopy JTF_VARCHAR2_TABLE_200
66: , a22 out nocopy JTF_NUMBER_TABLE
67: , a23 out nocopy JTF_NUMBER_TABLE
68: , a24 out nocopy JTF_NUMBER_TABLE
69: , a25 out nocopy JTF_NUMBER_TABLE
70: , a26 out nocopy JTF_NUMBER_TABLE
71: , a27 out nocopy JTF_NUMBER_TABLE
72: , a28 out nocopy JTF_VARCHAR2_TABLE_200
73: , a29 out nocopy JTF_VARCHAR2_TABLE_200
74: , a30 out nocopy JTF_VARCHAR2_TABLE_100
67: , a23 out nocopy JTF_NUMBER_TABLE
68: , a24 out nocopy JTF_NUMBER_TABLE
69: , a25 out nocopy JTF_NUMBER_TABLE
70: , a26 out nocopy JTF_NUMBER_TABLE
71: , a27 out nocopy JTF_NUMBER_TABLE
72: , a28 out nocopy JTF_VARCHAR2_TABLE_200
73: , a29 out nocopy JTF_VARCHAR2_TABLE_200
74: , a30 out nocopy JTF_VARCHAR2_TABLE_100
75: , a31 out nocopy JTF_VARCHAR2_TABLE_100
74: , a30 out nocopy JTF_VARCHAR2_TABLE_100
75: , a31 out nocopy JTF_VARCHAR2_TABLE_100
76: , a32 out nocopy JTF_DATE_TABLE
77: , a33 out nocopy JTF_DATE_TABLE
78: , a34 out nocopy JTF_NUMBER_TABLE
79: , a35 out nocopy JTF_NUMBER_TABLE
80: , a36 out nocopy JTF_DATE_TABLE
81: , a37 out nocopy JTF_DATE_TABLE
82: , a38 out nocopy JTF_VARCHAR2_TABLE_100
75: , a31 out nocopy JTF_VARCHAR2_TABLE_100
76: , a32 out nocopy JTF_DATE_TABLE
77: , a33 out nocopy JTF_DATE_TABLE
78: , a34 out nocopy JTF_NUMBER_TABLE
79: , a35 out nocopy JTF_NUMBER_TABLE
80: , a36 out nocopy JTF_DATE_TABLE
81: , a37 out nocopy JTF_DATE_TABLE
82: , a38 out nocopy JTF_VARCHAR2_TABLE_100
83: , a39 out nocopy JTF_VARCHAR2_TABLE_100
82: , a38 out nocopy JTF_VARCHAR2_TABLE_100
83: , a39 out nocopy JTF_VARCHAR2_TABLE_100
84: );
85:
86: procedure rosetta_table_copy_in_p48(t out nocopy okl_pool_pvt.poc_uv_tbl_type, a0 JTF_NUMBER_TABLE
87: , a1 JTF_VARCHAR2_TABLE_200
88: , a2 JTF_VARCHAR2_TABLE_200
89: , a3 JTF_VARCHAR2_TABLE_400
90: , a4 JTF_VARCHAR2_TABLE_200
87: , a1 JTF_VARCHAR2_TABLE_200
88: , a2 JTF_VARCHAR2_TABLE_200
89: , a3 JTF_VARCHAR2_TABLE_400
90: , a4 JTF_VARCHAR2_TABLE_200
91: , a5 JTF_NUMBER_TABLE
92: , a6 JTF_VARCHAR2_TABLE_100
93: , a7 JTF_VARCHAR2_TABLE_100
94: , a8 JTF_VARCHAR2_TABLE_100
95: );
92: , a6 JTF_VARCHAR2_TABLE_100
93: , a7 JTF_VARCHAR2_TABLE_100
94: , a8 JTF_VARCHAR2_TABLE_100
95: );
96: procedure rosetta_table_copy_out_p48(t okl_pool_pvt.poc_uv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
97: , a1 out nocopy JTF_VARCHAR2_TABLE_200
98: , a2 out nocopy JTF_VARCHAR2_TABLE_200
99: , a3 out nocopy JTF_VARCHAR2_TABLE_400
100: , a4 out nocopy JTF_VARCHAR2_TABLE_200
97: , a1 out nocopy JTF_VARCHAR2_TABLE_200
98: , a2 out nocopy JTF_VARCHAR2_TABLE_200
99: , a3 out nocopy JTF_VARCHAR2_TABLE_400
100: , a4 out nocopy JTF_VARCHAR2_TABLE_200
101: , a5 out nocopy JTF_NUMBER_TABLE
102: , a6 out nocopy JTF_VARCHAR2_TABLE_100
103: , a7 out nocopy JTF_VARCHAR2_TABLE_100
104: , a8 out nocopy JTF_VARCHAR2_TABLE_100
105: );
432: , p_init_msg_list VARCHAR2
433: , x_return_status out nocopy VARCHAR2
434: , x_msg_count out nocopy NUMBER
435: , x_msg_data out nocopy VARCHAR2
436: , p5_a0 JTF_NUMBER_TABLE
437: , p5_a1 JTF_NUMBER_TABLE
438: , p5_a2 JTF_NUMBER_TABLE
439: , p5_a3 JTF_NUMBER_TABLE
440: , p5_a4 JTF_NUMBER_TABLE
433: , x_return_status out nocopy VARCHAR2
434: , x_msg_count out nocopy NUMBER
435: , x_msg_data out nocopy VARCHAR2
436: , p5_a0 JTF_NUMBER_TABLE
437: , p5_a1 JTF_NUMBER_TABLE
438: , p5_a2 JTF_NUMBER_TABLE
439: , p5_a3 JTF_NUMBER_TABLE
440: , p5_a4 JTF_NUMBER_TABLE
441: , p5_a5 JTF_NUMBER_TABLE
434: , x_msg_count out nocopy NUMBER
435: , x_msg_data out nocopy VARCHAR2
436: , p5_a0 JTF_NUMBER_TABLE
437: , p5_a1 JTF_NUMBER_TABLE
438: , p5_a2 JTF_NUMBER_TABLE
439: , p5_a3 JTF_NUMBER_TABLE
440: , p5_a4 JTF_NUMBER_TABLE
441: , p5_a5 JTF_NUMBER_TABLE
442: , p5_a6 JTF_NUMBER_TABLE
435: , x_msg_data out nocopy VARCHAR2
436: , p5_a0 JTF_NUMBER_TABLE
437: , p5_a1 JTF_NUMBER_TABLE
438: , p5_a2 JTF_NUMBER_TABLE
439: , p5_a3 JTF_NUMBER_TABLE
440: , p5_a4 JTF_NUMBER_TABLE
441: , p5_a5 JTF_NUMBER_TABLE
442: , p5_a6 JTF_NUMBER_TABLE
443: , p5_a7 JTF_VARCHAR2_TABLE_200
436: , p5_a0 JTF_NUMBER_TABLE
437: , p5_a1 JTF_NUMBER_TABLE
438: , p5_a2 JTF_NUMBER_TABLE
439: , p5_a3 JTF_NUMBER_TABLE
440: , p5_a4 JTF_NUMBER_TABLE
441: , p5_a5 JTF_NUMBER_TABLE
442: , p5_a6 JTF_NUMBER_TABLE
443: , p5_a7 JTF_VARCHAR2_TABLE_200
444: , p5_a8 JTF_NUMBER_TABLE
437: , p5_a1 JTF_NUMBER_TABLE
438: , p5_a2 JTF_NUMBER_TABLE
439: , p5_a3 JTF_NUMBER_TABLE
440: , p5_a4 JTF_NUMBER_TABLE
441: , p5_a5 JTF_NUMBER_TABLE
442: , p5_a6 JTF_NUMBER_TABLE
443: , p5_a7 JTF_VARCHAR2_TABLE_200
444: , p5_a8 JTF_NUMBER_TABLE
445: , p5_a9 JTF_DATE_TABLE
438: , p5_a2 JTF_NUMBER_TABLE
439: , p5_a3 JTF_NUMBER_TABLE
440: , p5_a4 JTF_NUMBER_TABLE
441: , p5_a5 JTF_NUMBER_TABLE
442: , p5_a6 JTF_NUMBER_TABLE
443: , p5_a7 JTF_VARCHAR2_TABLE_200
444: , p5_a8 JTF_NUMBER_TABLE
445: , p5_a9 JTF_DATE_TABLE
446: , p5_a10 JTF_DATE_TABLE
440: , p5_a4 JTF_NUMBER_TABLE
441: , p5_a5 JTF_NUMBER_TABLE
442: , p5_a6 JTF_NUMBER_TABLE
443: , p5_a7 JTF_VARCHAR2_TABLE_200
444: , p5_a8 JTF_NUMBER_TABLE
445: , p5_a9 JTF_DATE_TABLE
446: , p5_a10 JTF_DATE_TABLE
447: , p5_a11 JTF_NUMBER_TABLE
448: , p5_a12 JTF_NUMBER_TABLE
443: , p5_a7 JTF_VARCHAR2_TABLE_200
444: , p5_a8 JTF_NUMBER_TABLE
445: , p5_a9 JTF_DATE_TABLE
446: , p5_a10 JTF_DATE_TABLE
447: , p5_a11 JTF_NUMBER_TABLE
448: , p5_a12 JTF_NUMBER_TABLE
449: , p5_a13 JTF_DATE_TABLE
450: , p5_a14 JTF_VARCHAR2_TABLE_100
451: , p5_a15 JTF_VARCHAR2_TABLE_100
444: , p5_a8 JTF_NUMBER_TABLE
445: , p5_a9 JTF_DATE_TABLE
446: , p5_a10 JTF_DATE_TABLE
447: , p5_a11 JTF_NUMBER_TABLE
448: , p5_a12 JTF_NUMBER_TABLE
449: , p5_a13 JTF_DATE_TABLE
450: , p5_a14 JTF_VARCHAR2_TABLE_100
451: , p5_a15 JTF_VARCHAR2_TABLE_100
452: , p5_a16 JTF_VARCHAR2_TABLE_500
463: , p5_a27 JTF_VARCHAR2_TABLE_500
464: , p5_a28 JTF_VARCHAR2_TABLE_500
465: , p5_a29 JTF_VARCHAR2_TABLE_500
466: , p5_a30 JTF_VARCHAR2_TABLE_500
467: , p5_a31 JTF_NUMBER_TABLE
468: , p5_a32 JTF_NUMBER_TABLE
469: , p5_a33 JTF_NUMBER_TABLE
470: , p5_a34 JTF_DATE_TABLE
471: , p5_a35 JTF_NUMBER_TABLE
464: , p5_a28 JTF_VARCHAR2_TABLE_500
465: , p5_a29 JTF_VARCHAR2_TABLE_500
466: , p5_a30 JTF_VARCHAR2_TABLE_500
467: , p5_a31 JTF_NUMBER_TABLE
468: , p5_a32 JTF_NUMBER_TABLE
469: , p5_a33 JTF_NUMBER_TABLE
470: , p5_a34 JTF_DATE_TABLE
471: , p5_a35 JTF_NUMBER_TABLE
472: , p5_a36 JTF_DATE_TABLE
465: , p5_a29 JTF_VARCHAR2_TABLE_500
466: , p5_a30 JTF_VARCHAR2_TABLE_500
467: , p5_a31 JTF_NUMBER_TABLE
468: , p5_a32 JTF_NUMBER_TABLE
469: , p5_a33 JTF_NUMBER_TABLE
470: , p5_a34 JTF_DATE_TABLE
471: , p5_a35 JTF_NUMBER_TABLE
472: , p5_a36 JTF_DATE_TABLE
473: , p5_a37 JTF_NUMBER_TABLE
467: , p5_a31 JTF_NUMBER_TABLE
468: , p5_a32 JTF_NUMBER_TABLE
469: , p5_a33 JTF_NUMBER_TABLE
470: , p5_a34 JTF_DATE_TABLE
471: , p5_a35 JTF_NUMBER_TABLE
472: , p5_a36 JTF_DATE_TABLE
473: , p5_a37 JTF_NUMBER_TABLE
474: , p5_a38 JTF_DATE_TABLE
475: , p5_a39 JTF_NUMBER_TABLE
469: , p5_a33 JTF_NUMBER_TABLE
470: , p5_a34 JTF_DATE_TABLE
471: , p5_a35 JTF_NUMBER_TABLE
472: , p5_a36 JTF_DATE_TABLE
473: , p5_a37 JTF_NUMBER_TABLE
474: , p5_a38 JTF_DATE_TABLE
475: , p5_a39 JTF_NUMBER_TABLE
476: , p6_a0 out nocopy JTF_NUMBER_TABLE
477: , p6_a1 out nocopy JTF_NUMBER_TABLE
471: , p5_a35 JTF_NUMBER_TABLE
472: , p5_a36 JTF_DATE_TABLE
473: , p5_a37 JTF_NUMBER_TABLE
474: , p5_a38 JTF_DATE_TABLE
475: , p5_a39 JTF_NUMBER_TABLE
476: , p6_a0 out nocopy JTF_NUMBER_TABLE
477: , p6_a1 out nocopy JTF_NUMBER_TABLE
478: , p6_a2 out nocopy JTF_NUMBER_TABLE
479: , p6_a3 out nocopy JTF_NUMBER_TABLE
472: , p5_a36 JTF_DATE_TABLE
473: , p5_a37 JTF_NUMBER_TABLE
474: , p5_a38 JTF_DATE_TABLE
475: , p5_a39 JTF_NUMBER_TABLE
476: , p6_a0 out nocopy JTF_NUMBER_TABLE
477: , p6_a1 out nocopy JTF_NUMBER_TABLE
478: , p6_a2 out nocopy JTF_NUMBER_TABLE
479: , p6_a3 out nocopy JTF_NUMBER_TABLE
480: , p6_a4 out nocopy JTF_NUMBER_TABLE
473: , p5_a37 JTF_NUMBER_TABLE
474: , p5_a38 JTF_DATE_TABLE
475: , p5_a39 JTF_NUMBER_TABLE
476: , p6_a0 out nocopy JTF_NUMBER_TABLE
477: , p6_a1 out nocopy JTF_NUMBER_TABLE
478: , p6_a2 out nocopy JTF_NUMBER_TABLE
479: , p6_a3 out nocopy JTF_NUMBER_TABLE
480: , p6_a4 out nocopy JTF_NUMBER_TABLE
481: , p6_a5 out nocopy JTF_NUMBER_TABLE
474: , p5_a38 JTF_DATE_TABLE
475: , p5_a39 JTF_NUMBER_TABLE
476: , p6_a0 out nocopy JTF_NUMBER_TABLE
477: , p6_a1 out nocopy JTF_NUMBER_TABLE
478: , p6_a2 out nocopy JTF_NUMBER_TABLE
479: , p6_a3 out nocopy JTF_NUMBER_TABLE
480: , p6_a4 out nocopy JTF_NUMBER_TABLE
481: , p6_a5 out nocopy JTF_NUMBER_TABLE
482: , p6_a6 out nocopy JTF_NUMBER_TABLE
475: , p5_a39 JTF_NUMBER_TABLE
476: , p6_a0 out nocopy JTF_NUMBER_TABLE
477: , p6_a1 out nocopy JTF_NUMBER_TABLE
478: , p6_a2 out nocopy JTF_NUMBER_TABLE
479: , p6_a3 out nocopy JTF_NUMBER_TABLE
480: , p6_a4 out nocopy JTF_NUMBER_TABLE
481: , p6_a5 out nocopy JTF_NUMBER_TABLE
482: , p6_a6 out nocopy JTF_NUMBER_TABLE
483: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
476: , p6_a0 out nocopy JTF_NUMBER_TABLE
477: , p6_a1 out nocopy JTF_NUMBER_TABLE
478: , p6_a2 out nocopy JTF_NUMBER_TABLE
479: , p6_a3 out nocopy JTF_NUMBER_TABLE
480: , p6_a4 out nocopy JTF_NUMBER_TABLE
481: , p6_a5 out nocopy JTF_NUMBER_TABLE
482: , p6_a6 out nocopy JTF_NUMBER_TABLE
483: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
484: , p6_a8 out nocopy JTF_NUMBER_TABLE
477: , p6_a1 out nocopy JTF_NUMBER_TABLE
478: , p6_a2 out nocopy JTF_NUMBER_TABLE
479: , p6_a3 out nocopy JTF_NUMBER_TABLE
480: , p6_a4 out nocopy JTF_NUMBER_TABLE
481: , p6_a5 out nocopy JTF_NUMBER_TABLE
482: , p6_a6 out nocopy JTF_NUMBER_TABLE
483: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
484: , p6_a8 out nocopy JTF_NUMBER_TABLE
485: , p6_a9 out nocopy JTF_DATE_TABLE
478: , p6_a2 out nocopy JTF_NUMBER_TABLE
479: , p6_a3 out nocopy JTF_NUMBER_TABLE
480: , p6_a4 out nocopy JTF_NUMBER_TABLE
481: , p6_a5 out nocopy JTF_NUMBER_TABLE
482: , p6_a6 out nocopy JTF_NUMBER_TABLE
483: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
484: , p6_a8 out nocopy JTF_NUMBER_TABLE
485: , p6_a9 out nocopy JTF_DATE_TABLE
486: , p6_a10 out nocopy JTF_DATE_TABLE
480: , p6_a4 out nocopy JTF_NUMBER_TABLE
481: , p6_a5 out nocopy JTF_NUMBER_TABLE
482: , p6_a6 out nocopy JTF_NUMBER_TABLE
483: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
484: , p6_a8 out nocopy JTF_NUMBER_TABLE
485: , p6_a9 out nocopy JTF_DATE_TABLE
486: , p6_a10 out nocopy JTF_DATE_TABLE
487: , p6_a11 out nocopy JTF_NUMBER_TABLE
488: , p6_a12 out nocopy JTF_NUMBER_TABLE
483: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
484: , p6_a8 out nocopy JTF_NUMBER_TABLE
485: , p6_a9 out nocopy JTF_DATE_TABLE
486: , p6_a10 out nocopy JTF_DATE_TABLE
487: , p6_a11 out nocopy JTF_NUMBER_TABLE
488: , p6_a12 out nocopy JTF_NUMBER_TABLE
489: , p6_a13 out nocopy JTF_DATE_TABLE
490: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
484: , p6_a8 out nocopy JTF_NUMBER_TABLE
485: , p6_a9 out nocopy JTF_DATE_TABLE
486: , p6_a10 out nocopy JTF_DATE_TABLE
487: , p6_a11 out nocopy JTF_NUMBER_TABLE
488: , p6_a12 out nocopy JTF_NUMBER_TABLE
489: , p6_a13 out nocopy JTF_DATE_TABLE
490: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
491: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
492: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
503: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
504: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
505: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
506: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
507: , p6_a31 out nocopy JTF_NUMBER_TABLE
508: , p6_a32 out nocopy JTF_NUMBER_TABLE
509: , p6_a33 out nocopy JTF_NUMBER_TABLE
510: , p6_a34 out nocopy JTF_DATE_TABLE
511: , p6_a35 out nocopy JTF_NUMBER_TABLE
504: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
505: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
506: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
507: , p6_a31 out nocopy JTF_NUMBER_TABLE
508: , p6_a32 out nocopy JTF_NUMBER_TABLE
509: , p6_a33 out nocopy JTF_NUMBER_TABLE
510: , p6_a34 out nocopy JTF_DATE_TABLE
511: , p6_a35 out nocopy JTF_NUMBER_TABLE
512: , p6_a36 out nocopy JTF_DATE_TABLE
505: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
506: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
507: , p6_a31 out nocopy JTF_NUMBER_TABLE
508: , p6_a32 out nocopy JTF_NUMBER_TABLE
509: , p6_a33 out nocopy JTF_NUMBER_TABLE
510: , p6_a34 out nocopy JTF_DATE_TABLE
511: , p6_a35 out nocopy JTF_NUMBER_TABLE
512: , p6_a36 out nocopy JTF_DATE_TABLE
513: , p6_a37 out nocopy JTF_NUMBER_TABLE
507: , p6_a31 out nocopy JTF_NUMBER_TABLE
508: , p6_a32 out nocopy JTF_NUMBER_TABLE
509: , p6_a33 out nocopy JTF_NUMBER_TABLE
510: , p6_a34 out nocopy JTF_DATE_TABLE
511: , p6_a35 out nocopy JTF_NUMBER_TABLE
512: , p6_a36 out nocopy JTF_DATE_TABLE
513: , p6_a37 out nocopy JTF_NUMBER_TABLE
514: , p6_a38 out nocopy JTF_DATE_TABLE
515: , p6_a39 out nocopy JTF_NUMBER_TABLE
509: , p6_a33 out nocopy JTF_NUMBER_TABLE
510: , p6_a34 out nocopy JTF_DATE_TABLE
511: , p6_a35 out nocopy JTF_NUMBER_TABLE
512: , p6_a36 out nocopy JTF_DATE_TABLE
513: , p6_a37 out nocopy JTF_NUMBER_TABLE
514: , p6_a38 out nocopy JTF_DATE_TABLE
515: , p6_a39 out nocopy JTF_NUMBER_TABLE
516: );
517: procedure update_pool_contents(p_api_version NUMBER
511: , p6_a35 out nocopy JTF_NUMBER_TABLE
512: , p6_a36 out nocopy JTF_DATE_TABLE
513: , p6_a37 out nocopy JTF_NUMBER_TABLE
514: , p6_a38 out nocopy JTF_DATE_TABLE
515: , p6_a39 out nocopy JTF_NUMBER_TABLE
516: );
517: procedure update_pool_contents(p_api_version NUMBER
518: , p_init_msg_list VARCHAR2
519: , x_return_status out nocopy VARCHAR2
604: , p_init_msg_list VARCHAR2
605: , x_return_status out nocopy VARCHAR2
606: , x_msg_count out nocopy NUMBER
607: , x_msg_data out nocopy VARCHAR2
608: , p5_a0 JTF_NUMBER_TABLE
609: , p5_a1 JTF_NUMBER_TABLE
610: , p5_a2 JTF_NUMBER_TABLE
611: , p5_a3 JTF_NUMBER_TABLE
612: , p5_a4 JTF_NUMBER_TABLE
605: , x_return_status out nocopy VARCHAR2
606: , x_msg_count out nocopy NUMBER
607: , x_msg_data out nocopy VARCHAR2
608: , p5_a0 JTF_NUMBER_TABLE
609: , p5_a1 JTF_NUMBER_TABLE
610: , p5_a2 JTF_NUMBER_TABLE
611: , p5_a3 JTF_NUMBER_TABLE
612: , p5_a4 JTF_NUMBER_TABLE
613: , p5_a5 JTF_NUMBER_TABLE
606: , x_msg_count out nocopy NUMBER
607: , x_msg_data out nocopy VARCHAR2
608: , p5_a0 JTF_NUMBER_TABLE
609: , p5_a1 JTF_NUMBER_TABLE
610: , p5_a2 JTF_NUMBER_TABLE
611: , p5_a3 JTF_NUMBER_TABLE
612: , p5_a4 JTF_NUMBER_TABLE
613: , p5_a5 JTF_NUMBER_TABLE
614: , p5_a6 JTF_NUMBER_TABLE
607: , x_msg_data out nocopy VARCHAR2
608: , p5_a0 JTF_NUMBER_TABLE
609: , p5_a1 JTF_NUMBER_TABLE
610: , p5_a2 JTF_NUMBER_TABLE
611: , p5_a3 JTF_NUMBER_TABLE
612: , p5_a4 JTF_NUMBER_TABLE
613: , p5_a5 JTF_NUMBER_TABLE
614: , p5_a6 JTF_NUMBER_TABLE
615: , p5_a7 JTF_VARCHAR2_TABLE_200
608: , p5_a0 JTF_NUMBER_TABLE
609: , p5_a1 JTF_NUMBER_TABLE
610: , p5_a2 JTF_NUMBER_TABLE
611: , p5_a3 JTF_NUMBER_TABLE
612: , p5_a4 JTF_NUMBER_TABLE
613: , p5_a5 JTF_NUMBER_TABLE
614: , p5_a6 JTF_NUMBER_TABLE
615: , p5_a7 JTF_VARCHAR2_TABLE_200
616: , p5_a8 JTF_NUMBER_TABLE
609: , p5_a1 JTF_NUMBER_TABLE
610: , p5_a2 JTF_NUMBER_TABLE
611: , p5_a3 JTF_NUMBER_TABLE
612: , p5_a4 JTF_NUMBER_TABLE
613: , p5_a5 JTF_NUMBER_TABLE
614: , p5_a6 JTF_NUMBER_TABLE
615: , p5_a7 JTF_VARCHAR2_TABLE_200
616: , p5_a8 JTF_NUMBER_TABLE
617: , p5_a9 JTF_DATE_TABLE
610: , p5_a2 JTF_NUMBER_TABLE
611: , p5_a3 JTF_NUMBER_TABLE
612: , p5_a4 JTF_NUMBER_TABLE
613: , p5_a5 JTF_NUMBER_TABLE
614: , p5_a6 JTF_NUMBER_TABLE
615: , p5_a7 JTF_VARCHAR2_TABLE_200
616: , p5_a8 JTF_NUMBER_TABLE
617: , p5_a9 JTF_DATE_TABLE
618: , p5_a10 JTF_DATE_TABLE
612: , p5_a4 JTF_NUMBER_TABLE
613: , p5_a5 JTF_NUMBER_TABLE
614: , p5_a6 JTF_NUMBER_TABLE
615: , p5_a7 JTF_VARCHAR2_TABLE_200
616: , p5_a8 JTF_NUMBER_TABLE
617: , p5_a9 JTF_DATE_TABLE
618: , p5_a10 JTF_DATE_TABLE
619: , p5_a11 JTF_NUMBER_TABLE
620: , p5_a12 JTF_NUMBER_TABLE
615: , p5_a7 JTF_VARCHAR2_TABLE_200
616: , p5_a8 JTF_NUMBER_TABLE
617: , p5_a9 JTF_DATE_TABLE
618: , p5_a10 JTF_DATE_TABLE
619: , p5_a11 JTF_NUMBER_TABLE
620: , p5_a12 JTF_NUMBER_TABLE
621: , p5_a13 JTF_DATE_TABLE
622: , p5_a14 JTF_VARCHAR2_TABLE_100
623: , p5_a15 JTF_VARCHAR2_TABLE_100
616: , p5_a8 JTF_NUMBER_TABLE
617: , p5_a9 JTF_DATE_TABLE
618: , p5_a10 JTF_DATE_TABLE
619: , p5_a11 JTF_NUMBER_TABLE
620: , p5_a12 JTF_NUMBER_TABLE
621: , p5_a13 JTF_DATE_TABLE
622: , p5_a14 JTF_VARCHAR2_TABLE_100
623: , p5_a15 JTF_VARCHAR2_TABLE_100
624: , p5_a16 JTF_VARCHAR2_TABLE_500
635: , p5_a27 JTF_VARCHAR2_TABLE_500
636: , p5_a28 JTF_VARCHAR2_TABLE_500
637: , p5_a29 JTF_VARCHAR2_TABLE_500
638: , p5_a30 JTF_VARCHAR2_TABLE_500
639: , p5_a31 JTF_NUMBER_TABLE
640: , p5_a32 JTF_NUMBER_TABLE
641: , p5_a33 JTF_NUMBER_TABLE
642: , p5_a34 JTF_DATE_TABLE
643: , p5_a35 JTF_NUMBER_TABLE
636: , p5_a28 JTF_VARCHAR2_TABLE_500
637: , p5_a29 JTF_VARCHAR2_TABLE_500
638: , p5_a30 JTF_VARCHAR2_TABLE_500
639: , p5_a31 JTF_NUMBER_TABLE
640: , p5_a32 JTF_NUMBER_TABLE
641: , p5_a33 JTF_NUMBER_TABLE
642: , p5_a34 JTF_DATE_TABLE
643: , p5_a35 JTF_NUMBER_TABLE
644: , p5_a36 JTF_DATE_TABLE
637: , p5_a29 JTF_VARCHAR2_TABLE_500
638: , p5_a30 JTF_VARCHAR2_TABLE_500
639: , p5_a31 JTF_NUMBER_TABLE
640: , p5_a32 JTF_NUMBER_TABLE
641: , p5_a33 JTF_NUMBER_TABLE
642: , p5_a34 JTF_DATE_TABLE
643: , p5_a35 JTF_NUMBER_TABLE
644: , p5_a36 JTF_DATE_TABLE
645: , p5_a37 JTF_NUMBER_TABLE
639: , p5_a31 JTF_NUMBER_TABLE
640: , p5_a32 JTF_NUMBER_TABLE
641: , p5_a33 JTF_NUMBER_TABLE
642: , p5_a34 JTF_DATE_TABLE
643: , p5_a35 JTF_NUMBER_TABLE
644: , p5_a36 JTF_DATE_TABLE
645: , p5_a37 JTF_NUMBER_TABLE
646: , p5_a38 JTF_DATE_TABLE
647: , p5_a39 JTF_NUMBER_TABLE
641: , p5_a33 JTF_NUMBER_TABLE
642: , p5_a34 JTF_DATE_TABLE
643: , p5_a35 JTF_NUMBER_TABLE
644: , p5_a36 JTF_DATE_TABLE
645: , p5_a37 JTF_NUMBER_TABLE
646: , p5_a38 JTF_DATE_TABLE
647: , p5_a39 JTF_NUMBER_TABLE
648: , p6_a0 out nocopy JTF_NUMBER_TABLE
649: , p6_a1 out nocopy JTF_NUMBER_TABLE
643: , p5_a35 JTF_NUMBER_TABLE
644: , p5_a36 JTF_DATE_TABLE
645: , p5_a37 JTF_NUMBER_TABLE
646: , p5_a38 JTF_DATE_TABLE
647: , p5_a39 JTF_NUMBER_TABLE
648: , p6_a0 out nocopy JTF_NUMBER_TABLE
649: , p6_a1 out nocopy JTF_NUMBER_TABLE
650: , p6_a2 out nocopy JTF_NUMBER_TABLE
651: , p6_a3 out nocopy JTF_NUMBER_TABLE
644: , p5_a36 JTF_DATE_TABLE
645: , p5_a37 JTF_NUMBER_TABLE
646: , p5_a38 JTF_DATE_TABLE
647: , p5_a39 JTF_NUMBER_TABLE
648: , p6_a0 out nocopy JTF_NUMBER_TABLE
649: , p6_a1 out nocopy JTF_NUMBER_TABLE
650: , p6_a2 out nocopy JTF_NUMBER_TABLE
651: , p6_a3 out nocopy JTF_NUMBER_TABLE
652: , p6_a4 out nocopy JTF_NUMBER_TABLE
645: , p5_a37 JTF_NUMBER_TABLE
646: , p5_a38 JTF_DATE_TABLE
647: , p5_a39 JTF_NUMBER_TABLE
648: , p6_a0 out nocopy JTF_NUMBER_TABLE
649: , p6_a1 out nocopy JTF_NUMBER_TABLE
650: , p6_a2 out nocopy JTF_NUMBER_TABLE
651: , p6_a3 out nocopy JTF_NUMBER_TABLE
652: , p6_a4 out nocopy JTF_NUMBER_TABLE
653: , p6_a5 out nocopy JTF_NUMBER_TABLE
646: , p5_a38 JTF_DATE_TABLE
647: , p5_a39 JTF_NUMBER_TABLE
648: , p6_a0 out nocopy JTF_NUMBER_TABLE
649: , p6_a1 out nocopy JTF_NUMBER_TABLE
650: , p6_a2 out nocopy JTF_NUMBER_TABLE
651: , p6_a3 out nocopy JTF_NUMBER_TABLE
652: , p6_a4 out nocopy JTF_NUMBER_TABLE
653: , p6_a5 out nocopy JTF_NUMBER_TABLE
654: , p6_a6 out nocopy JTF_NUMBER_TABLE
647: , p5_a39 JTF_NUMBER_TABLE
648: , p6_a0 out nocopy JTF_NUMBER_TABLE
649: , p6_a1 out nocopy JTF_NUMBER_TABLE
650: , p6_a2 out nocopy JTF_NUMBER_TABLE
651: , p6_a3 out nocopy JTF_NUMBER_TABLE
652: , p6_a4 out nocopy JTF_NUMBER_TABLE
653: , p6_a5 out nocopy JTF_NUMBER_TABLE
654: , p6_a6 out nocopy JTF_NUMBER_TABLE
655: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
648: , p6_a0 out nocopy JTF_NUMBER_TABLE
649: , p6_a1 out nocopy JTF_NUMBER_TABLE
650: , p6_a2 out nocopy JTF_NUMBER_TABLE
651: , p6_a3 out nocopy JTF_NUMBER_TABLE
652: , p6_a4 out nocopy JTF_NUMBER_TABLE
653: , p6_a5 out nocopy JTF_NUMBER_TABLE
654: , p6_a6 out nocopy JTF_NUMBER_TABLE
655: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
656: , p6_a8 out nocopy JTF_NUMBER_TABLE
649: , p6_a1 out nocopy JTF_NUMBER_TABLE
650: , p6_a2 out nocopy JTF_NUMBER_TABLE
651: , p6_a3 out nocopy JTF_NUMBER_TABLE
652: , p6_a4 out nocopy JTF_NUMBER_TABLE
653: , p6_a5 out nocopy JTF_NUMBER_TABLE
654: , p6_a6 out nocopy JTF_NUMBER_TABLE
655: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
656: , p6_a8 out nocopy JTF_NUMBER_TABLE
657: , p6_a9 out nocopy JTF_DATE_TABLE
650: , p6_a2 out nocopy JTF_NUMBER_TABLE
651: , p6_a3 out nocopy JTF_NUMBER_TABLE
652: , p6_a4 out nocopy JTF_NUMBER_TABLE
653: , p6_a5 out nocopy JTF_NUMBER_TABLE
654: , p6_a6 out nocopy JTF_NUMBER_TABLE
655: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
656: , p6_a8 out nocopy JTF_NUMBER_TABLE
657: , p6_a9 out nocopy JTF_DATE_TABLE
658: , p6_a10 out nocopy JTF_DATE_TABLE
652: , p6_a4 out nocopy JTF_NUMBER_TABLE
653: , p6_a5 out nocopy JTF_NUMBER_TABLE
654: , p6_a6 out nocopy JTF_NUMBER_TABLE
655: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
656: , p6_a8 out nocopy JTF_NUMBER_TABLE
657: , p6_a9 out nocopy JTF_DATE_TABLE
658: , p6_a10 out nocopy JTF_DATE_TABLE
659: , p6_a11 out nocopy JTF_NUMBER_TABLE
660: , p6_a12 out nocopy JTF_NUMBER_TABLE
655: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_200
656: , p6_a8 out nocopy JTF_NUMBER_TABLE
657: , p6_a9 out nocopy JTF_DATE_TABLE
658: , p6_a10 out nocopy JTF_DATE_TABLE
659: , p6_a11 out nocopy JTF_NUMBER_TABLE
660: , p6_a12 out nocopy JTF_NUMBER_TABLE
661: , p6_a13 out nocopy JTF_DATE_TABLE
662: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
663: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
656: , p6_a8 out nocopy JTF_NUMBER_TABLE
657: , p6_a9 out nocopy JTF_DATE_TABLE
658: , p6_a10 out nocopy JTF_DATE_TABLE
659: , p6_a11 out nocopy JTF_NUMBER_TABLE
660: , p6_a12 out nocopy JTF_NUMBER_TABLE
661: , p6_a13 out nocopy JTF_DATE_TABLE
662: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
663: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
664: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_500
675: , p6_a27 out nocopy JTF_VARCHAR2_TABLE_500
676: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
677: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
678: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
679: , p6_a31 out nocopy JTF_NUMBER_TABLE
680: , p6_a32 out nocopy JTF_NUMBER_TABLE
681: , p6_a33 out nocopy JTF_NUMBER_TABLE
682: , p6_a34 out nocopy JTF_DATE_TABLE
683: , p6_a35 out nocopy JTF_NUMBER_TABLE
676: , p6_a28 out nocopy JTF_VARCHAR2_TABLE_500
677: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
678: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
679: , p6_a31 out nocopy JTF_NUMBER_TABLE
680: , p6_a32 out nocopy JTF_NUMBER_TABLE
681: , p6_a33 out nocopy JTF_NUMBER_TABLE
682: , p6_a34 out nocopy JTF_DATE_TABLE
683: , p6_a35 out nocopy JTF_NUMBER_TABLE
684: , p6_a36 out nocopy JTF_DATE_TABLE
677: , p6_a29 out nocopy JTF_VARCHAR2_TABLE_500
678: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_500
679: , p6_a31 out nocopy JTF_NUMBER_TABLE
680: , p6_a32 out nocopy JTF_NUMBER_TABLE
681: , p6_a33 out nocopy JTF_NUMBER_TABLE
682: , p6_a34 out nocopy JTF_DATE_TABLE
683: , p6_a35 out nocopy JTF_NUMBER_TABLE
684: , p6_a36 out nocopy JTF_DATE_TABLE
685: , p6_a37 out nocopy JTF_NUMBER_TABLE
679: , p6_a31 out nocopy JTF_NUMBER_TABLE
680: , p6_a32 out nocopy JTF_NUMBER_TABLE
681: , p6_a33 out nocopy JTF_NUMBER_TABLE
682: , p6_a34 out nocopy JTF_DATE_TABLE
683: , p6_a35 out nocopy JTF_NUMBER_TABLE
684: , p6_a36 out nocopy JTF_DATE_TABLE
685: , p6_a37 out nocopy JTF_NUMBER_TABLE
686: , p6_a38 out nocopy JTF_DATE_TABLE
687: , p6_a39 out nocopy JTF_NUMBER_TABLE
681: , p6_a33 out nocopy JTF_NUMBER_TABLE
682: , p6_a34 out nocopy JTF_DATE_TABLE
683: , p6_a35 out nocopy JTF_NUMBER_TABLE
684: , p6_a36 out nocopy JTF_DATE_TABLE
685: , p6_a37 out nocopy JTF_NUMBER_TABLE
686: , p6_a38 out nocopy JTF_DATE_TABLE
687: , p6_a39 out nocopy JTF_NUMBER_TABLE
688: );
689: procedure delete_pool_contents(p_api_version NUMBER
683: , p6_a35 out nocopy JTF_NUMBER_TABLE
684: , p6_a36 out nocopy JTF_DATE_TABLE
685: , p6_a37 out nocopy JTF_NUMBER_TABLE
686: , p6_a38 out nocopy JTF_DATE_TABLE
687: , p6_a39 out nocopy JTF_NUMBER_TABLE
688: );
689: procedure delete_pool_contents(p_api_version NUMBER
690: , p_init_msg_list VARCHAR2
691: , x_return_status out nocopy VARCHAR2
736: , p_init_msg_list VARCHAR2
737: , x_return_status out nocopy VARCHAR2
738: , x_msg_count out nocopy NUMBER
739: , x_msg_data out nocopy VARCHAR2
740: , p5_a0 JTF_NUMBER_TABLE
741: , p5_a1 JTF_NUMBER_TABLE
742: , p5_a2 JTF_NUMBER_TABLE
743: , p5_a3 JTF_NUMBER_TABLE
744: , p5_a4 JTF_NUMBER_TABLE
737: , x_return_status out nocopy VARCHAR2
738: , x_msg_count out nocopy NUMBER
739: , x_msg_data out nocopy VARCHAR2
740: , p5_a0 JTF_NUMBER_TABLE
741: , p5_a1 JTF_NUMBER_TABLE
742: , p5_a2 JTF_NUMBER_TABLE
743: , p5_a3 JTF_NUMBER_TABLE
744: , p5_a4 JTF_NUMBER_TABLE
745: , p5_a5 JTF_NUMBER_TABLE
738: , x_msg_count out nocopy NUMBER
739: , x_msg_data out nocopy VARCHAR2
740: , p5_a0 JTF_NUMBER_TABLE
741: , p5_a1 JTF_NUMBER_TABLE
742: , p5_a2 JTF_NUMBER_TABLE
743: , p5_a3 JTF_NUMBER_TABLE
744: , p5_a4 JTF_NUMBER_TABLE
745: , p5_a5 JTF_NUMBER_TABLE
746: , p5_a6 JTF_NUMBER_TABLE
739: , x_msg_data out nocopy VARCHAR2
740: , p5_a0 JTF_NUMBER_TABLE
741: , p5_a1 JTF_NUMBER_TABLE
742: , p5_a2 JTF_NUMBER_TABLE
743: , p5_a3 JTF_NUMBER_TABLE
744: , p5_a4 JTF_NUMBER_TABLE
745: , p5_a5 JTF_NUMBER_TABLE
746: , p5_a6 JTF_NUMBER_TABLE
747: , p5_a7 JTF_VARCHAR2_TABLE_200
740: , p5_a0 JTF_NUMBER_TABLE
741: , p5_a1 JTF_NUMBER_TABLE
742: , p5_a2 JTF_NUMBER_TABLE
743: , p5_a3 JTF_NUMBER_TABLE
744: , p5_a4 JTF_NUMBER_TABLE
745: , p5_a5 JTF_NUMBER_TABLE
746: , p5_a6 JTF_NUMBER_TABLE
747: , p5_a7 JTF_VARCHAR2_TABLE_200
748: , p5_a8 JTF_NUMBER_TABLE
741: , p5_a1 JTF_NUMBER_TABLE
742: , p5_a2 JTF_NUMBER_TABLE
743: , p5_a3 JTF_NUMBER_TABLE
744: , p5_a4 JTF_NUMBER_TABLE
745: , p5_a5 JTF_NUMBER_TABLE
746: , p5_a6 JTF_NUMBER_TABLE
747: , p5_a7 JTF_VARCHAR2_TABLE_200
748: , p5_a8 JTF_NUMBER_TABLE
749: , p5_a9 JTF_DATE_TABLE
742: , p5_a2 JTF_NUMBER_TABLE
743: , p5_a3 JTF_NUMBER_TABLE
744: , p5_a4 JTF_NUMBER_TABLE
745: , p5_a5 JTF_NUMBER_TABLE
746: , p5_a6 JTF_NUMBER_TABLE
747: , p5_a7 JTF_VARCHAR2_TABLE_200
748: , p5_a8 JTF_NUMBER_TABLE
749: , p5_a9 JTF_DATE_TABLE
750: , p5_a10 JTF_DATE_TABLE
744: , p5_a4 JTF_NUMBER_TABLE
745: , p5_a5 JTF_NUMBER_TABLE
746: , p5_a6 JTF_NUMBER_TABLE
747: , p5_a7 JTF_VARCHAR2_TABLE_200
748: , p5_a8 JTF_NUMBER_TABLE
749: , p5_a9 JTF_DATE_TABLE
750: , p5_a10 JTF_DATE_TABLE
751: , p5_a11 JTF_NUMBER_TABLE
752: , p5_a12 JTF_NUMBER_TABLE
747: , p5_a7 JTF_VARCHAR2_TABLE_200
748: , p5_a8 JTF_NUMBER_TABLE
749: , p5_a9 JTF_DATE_TABLE
750: , p5_a10 JTF_DATE_TABLE
751: , p5_a11 JTF_NUMBER_TABLE
752: , p5_a12 JTF_NUMBER_TABLE
753: , p5_a13 JTF_DATE_TABLE
754: , p5_a14 JTF_VARCHAR2_TABLE_100
755: , p5_a15 JTF_VARCHAR2_TABLE_100
748: , p5_a8 JTF_NUMBER_TABLE
749: , p5_a9 JTF_DATE_TABLE
750: , p5_a10 JTF_DATE_TABLE
751: , p5_a11 JTF_NUMBER_TABLE
752: , p5_a12 JTF_NUMBER_TABLE
753: , p5_a13 JTF_DATE_TABLE
754: , p5_a14 JTF_VARCHAR2_TABLE_100
755: , p5_a15 JTF_VARCHAR2_TABLE_100
756: , p5_a16 JTF_VARCHAR2_TABLE_500
767: , p5_a27 JTF_VARCHAR2_TABLE_500
768: , p5_a28 JTF_VARCHAR2_TABLE_500
769: , p5_a29 JTF_VARCHAR2_TABLE_500
770: , p5_a30 JTF_VARCHAR2_TABLE_500
771: , p5_a31 JTF_NUMBER_TABLE
772: , p5_a32 JTF_NUMBER_TABLE
773: , p5_a33 JTF_NUMBER_TABLE
774: , p5_a34 JTF_DATE_TABLE
775: , p5_a35 JTF_NUMBER_TABLE
768: , p5_a28 JTF_VARCHAR2_TABLE_500
769: , p5_a29 JTF_VARCHAR2_TABLE_500
770: , p5_a30 JTF_VARCHAR2_TABLE_500
771: , p5_a31 JTF_NUMBER_TABLE
772: , p5_a32 JTF_NUMBER_TABLE
773: , p5_a33 JTF_NUMBER_TABLE
774: , p5_a34 JTF_DATE_TABLE
775: , p5_a35 JTF_NUMBER_TABLE
776: , p5_a36 JTF_DATE_TABLE
769: , p5_a29 JTF_VARCHAR2_TABLE_500
770: , p5_a30 JTF_VARCHAR2_TABLE_500
771: , p5_a31 JTF_NUMBER_TABLE
772: , p5_a32 JTF_NUMBER_TABLE
773: , p5_a33 JTF_NUMBER_TABLE
774: , p5_a34 JTF_DATE_TABLE
775: , p5_a35 JTF_NUMBER_TABLE
776: , p5_a36 JTF_DATE_TABLE
777: , p5_a37 JTF_NUMBER_TABLE
771: , p5_a31 JTF_NUMBER_TABLE
772: , p5_a32 JTF_NUMBER_TABLE
773: , p5_a33 JTF_NUMBER_TABLE
774: , p5_a34 JTF_DATE_TABLE
775: , p5_a35 JTF_NUMBER_TABLE
776: , p5_a36 JTF_DATE_TABLE
777: , p5_a37 JTF_NUMBER_TABLE
778: , p5_a38 JTF_DATE_TABLE
779: , p5_a39 JTF_NUMBER_TABLE
773: , p5_a33 JTF_NUMBER_TABLE
774: , p5_a34 JTF_DATE_TABLE
775: , p5_a35 JTF_NUMBER_TABLE
776: , p5_a36 JTF_DATE_TABLE
777: , p5_a37 JTF_NUMBER_TABLE
778: , p5_a38 JTF_DATE_TABLE
779: , p5_a39 JTF_NUMBER_TABLE
780: );
781: procedure create_pool_transaction(p_api_version NUMBER
775: , p5_a35 JTF_NUMBER_TABLE
776: , p5_a36 JTF_DATE_TABLE
777: , p5_a37 JTF_NUMBER_TABLE
778: , p5_a38 JTF_DATE_TABLE
779: , p5_a39 JTF_NUMBER_TABLE
780: );
781: procedure create_pool_transaction(p_api_version NUMBER
782: , p_init_msg_list VARCHAR2
783: , x_return_status out nocopy VARCHAR2
1065: , p_stream_type_subclass VARCHAR2
1066: , p_streams_from_date date
1067: , p_streams_to_date date
1068: , p_action_code VARCHAR2
1069: , p33_a0 out nocopy JTF_NUMBER_TABLE
1070: , p33_a1 out nocopy JTF_VARCHAR2_TABLE_200
1071: , p33_a2 out nocopy JTF_VARCHAR2_TABLE_200
1072: , p33_a3 out nocopy JTF_VARCHAR2_TABLE_400
1073: , p33_a4 out nocopy JTF_VARCHAR2_TABLE_200
1070: , p33_a1 out nocopy JTF_VARCHAR2_TABLE_200
1071: , p33_a2 out nocopy JTF_VARCHAR2_TABLE_200
1072: , p33_a3 out nocopy JTF_VARCHAR2_TABLE_400
1073: , p33_a4 out nocopy JTF_VARCHAR2_TABLE_200
1074: , p33_a5 out nocopy JTF_NUMBER_TABLE
1075: , p33_a6 out nocopy JTF_VARCHAR2_TABLE_100
1076: , p33_a7 out nocopy JTF_VARCHAR2_TABLE_100
1077: , p33_a8 out nocopy JTF_VARCHAR2_TABLE_100
1078: );