1: package okl_sip_pvt_w as
2: /* $Header: OKLISIPS.pls 120.1 2005/10/30 04:01:01 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sip_pvt.sipv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_2000
2: /* $Header: OKLISIPS.pls 120.1 2005/10/30 04:01:01 appldev noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sip_pvt.sipv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_DATE_TABLE
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_sip_pvt.sipv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_200
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_2000
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_DATE_TABLE
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: , a11 JTF_VARCHAR2_TABLE_100
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: , a15 JTF_NUMBER_TABLE
19: , a16 JTF_DATE_TABLE
20: , a17 JTF_VARCHAR2_TABLE_100
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_VARCHAR2_TABLE_500
40: , a37 JTF_NUMBER_TABLE
41: );
42: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_VARCHAR2_TABLE_200
48: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
41: );
42: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_VARCHAR2_TABLE_200
48: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
49: , a7 out nocopy JTF_DATE_TABLE
42: procedure rosetta_table_copy_out_p2(t okl_sip_pvt.sipv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
43: , a1 out nocopy JTF_NUMBER_TABLE
44: , a2 out nocopy JTF_VARCHAR2_TABLE_100
45: , a3 out nocopy JTF_VARCHAR2_TABLE_100
46: , a4 out nocopy JTF_VARCHAR2_TABLE_100
47: , a5 out nocopy JTF_VARCHAR2_TABLE_200
48: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
49: , a7 out nocopy JTF_DATE_TABLE
50: , a8 out nocopy JTF_DATE_TABLE
47: , a5 out nocopy JTF_VARCHAR2_TABLE_200
48: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
49: , a7 out nocopy JTF_DATE_TABLE
50: , a8 out nocopy JTF_DATE_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_VARCHAR2_TABLE_100
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
48: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
49: , a7 out nocopy JTF_DATE_TABLE
50: , a8 out nocopy JTF_DATE_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_VARCHAR2_TABLE_100
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
49: , a7 out nocopy JTF_DATE_TABLE
50: , a8 out nocopy JTF_DATE_TABLE
51: , a9 out nocopy JTF_VARCHAR2_TABLE_100
52: , a10 out nocopy JTF_VARCHAR2_TABLE_100
53: , a11 out nocopy JTF_VARCHAR2_TABLE_100
54: , a12 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_NUMBER_TABLE
55: , a13 out nocopy JTF_NUMBER_TABLE
56: , a14 out nocopy JTF_NUMBER_TABLE
57: , a15 out nocopy JTF_NUMBER_TABLE
58: , a16 out nocopy JTF_DATE_TABLE
59: , a17 out nocopy JTF_VARCHAR2_TABLE_100
60: , a18 out nocopy JTF_VARCHAR2_TABLE_500
61: , a19 out nocopy JTF_VARCHAR2_TABLE_500
62: , a20 out nocopy JTF_VARCHAR2_TABLE_500
63: , a21 out nocopy JTF_VARCHAR2_TABLE_500
81:
82: procedure rosetta_table_copy_in_p5(t out nocopy okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 JTF_NUMBER_TABLE
83: , a1 JTF_VARCHAR2_TABLE_200
84: , a2 JTF_VARCHAR2_TABLE_2000
85: , a3 JTF_VARCHAR2_TABLE_100
86: , a4 JTF_VARCHAR2_TABLE_100
87: , a5 JTF_VARCHAR2_TABLE_100
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_DATE_TABLE
82: procedure rosetta_table_copy_in_p5(t out nocopy okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 JTF_NUMBER_TABLE
83: , a1 JTF_VARCHAR2_TABLE_200
84: , a2 JTF_VARCHAR2_TABLE_2000
85: , a3 JTF_VARCHAR2_TABLE_100
86: , a4 JTF_VARCHAR2_TABLE_100
87: , a5 JTF_VARCHAR2_TABLE_100
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_DATE_TABLE
90: , a8 JTF_NUMBER_TABLE
83: , a1 JTF_VARCHAR2_TABLE_200
84: , a2 JTF_VARCHAR2_TABLE_2000
85: , a3 JTF_VARCHAR2_TABLE_100
86: , a4 JTF_VARCHAR2_TABLE_100
87: , a5 JTF_VARCHAR2_TABLE_100
88: , a6 JTF_NUMBER_TABLE
89: , a7 JTF_DATE_TABLE
90: , a8 JTF_NUMBER_TABLE
91: , a9 JTF_DATE_TABLE
93: );
94: procedure rosetta_table_copy_out_p5(t okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_200
96: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a3 out nocopy JTF_VARCHAR2_TABLE_100
98: , a4 out nocopy JTF_VARCHAR2_TABLE_100
99: , a5 out nocopy JTF_VARCHAR2_TABLE_100
100: , a6 out nocopy JTF_NUMBER_TABLE
101: , a7 out nocopy JTF_DATE_TABLE
94: procedure rosetta_table_copy_out_p5(t okl_sip_pvt.okl_subsidy_pools_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_200
96: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a3 out nocopy JTF_VARCHAR2_TABLE_100
98: , a4 out nocopy JTF_VARCHAR2_TABLE_100
99: , a5 out nocopy JTF_VARCHAR2_TABLE_100
100: , a6 out nocopy JTF_NUMBER_TABLE
101: , a7 out nocopy JTF_DATE_TABLE
102: , a8 out nocopy JTF_NUMBER_TABLE
95: , a1 out nocopy JTF_VARCHAR2_TABLE_200
96: , a2 out nocopy JTF_VARCHAR2_TABLE_2000
97: , a3 out nocopy JTF_VARCHAR2_TABLE_100
98: , a4 out nocopy JTF_VARCHAR2_TABLE_100
99: , a5 out nocopy JTF_VARCHAR2_TABLE_100
100: , a6 out nocopy JTF_NUMBER_TABLE
101: , a7 out nocopy JTF_DATE_TABLE
102: , a8 out nocopy JTF_NUMBER_TABLE
103: , a9 out nocopy JTF_DATE_TABLE
105: );
106:
107: procedure rosetta_table_copy_in_p8(t out nocopy okl_sip_pvt.sip_tbl_type, a0 JTF_NUMBER_TABLE
108: , a1 JTF_NUMBER_TABLE
109: , a2 JTF_VARCHAR2_TABLE_100
110: , a3 JTF_VARCHAR2_TABLE_100
111: , a4 JTF_DATE_TABLE
112: , a5 JTF_DATE_TABLE
113: , a6 JTF_VARCHAR2_TABLE_100
106:
107: procedure rosetta_table_copy_in_p8(t out nocopy okl_sip_pvt.sip_tbl_type, a0 JTF_NUMBER_TABLE
108: , a1 JTF_NUMBER_TABLE
109: , a2 JTF_VARCHAR2_TABLE_100
110: , a3 JTF_VARCHAR2_TABLE_100
111: , a4 JTF_DATE_TABLE
112: , a5 JTF_DATE_TABLE
113: , a6 JTF_VARCHAR2_TABLE_100
114: , a7 JTF_VARCHAR2_TABLE_100
109: , a2 JTF_VARCHAR2_TABLE_100
110: , a3 JTF_VARCHAR2_TABLE_100
111: , a4 JTF_DATE_TABLE
112: , a5 JTF_DATE_TABLE
113: , a6 JTF_VARCHAR2_TABLE_100
114: , a7 JTF_VARCHAR2_TABLE_100
115: , a8 JTF_VARCHAR2_TABLE_100
116: , a9 JTF_NUMBER_TABLE
117: , a10 JTF_NUMBER_TABLE
110: , a3 JTF_VARCHAR2_TABLE_100
111: , a4 JTF_DATE_TABLE
112: , a5 JTF_DATE_TABLE
113: , a6 JTF_VARCHAR2_TABLE_100
114: , a7 JTF_VARCHAR2_TABLE_100
115: , a8 JTF_VARCHAR2_TABLE_100
116: , a9 JTF_NUMBER_TABLE
117: , a10 JTF_NUMBER_TABLE
118: , a11 JTF_NUMBER_TABLE
111: , a4 JTF_DATE_TABLE
112: , a5 JTF_DATE_TABLE
113: , a6 JTF_VARCHAR2_TABLE_100
114: , a7 JTF_VARCHAR2_TABLE_100
115: , a8 JTF_VARCHAR2_TABLE_100
116: , a9 JTF_NUMBER_TABLE
117: , a10 JTF_NUMBER_TABLE
118: , a11 JTF_NUMBER_TABLE
119: , a12 JTF_NUMBER_TABLE
117: , a10 JTF_NUMBER_TABLE
118: , a11 JTF_NUMBER_TABLE
119: , a12 JTF_NUMBER_TABLE
120: , a13 JTF_DATE_TABLE
121: , a14 JTF_VARCHAR2_TABLE_100
122: , a15 JTF_VARCHAR2_TABLE_500
123: , a16 JTF_VARCHAR2_TABLE_500
124: , a17 JTF_VARCHAR2_TABLE_500
125: , a18 JTF_VARCHAR2_TABLE_500
141: , a34 JTF_NUMBER_TABLE
142: );
143: procedure rosetta_table_copy_out_p8(t okl_sip_pvt.sip_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
144: , a1 out nocopy JTF_NUMBER_TABLE
145: , a2 out nocopy JTF_VARCHAR2_TABLE_100
146: , a3 out nocopy JTF_VARCHAR2_TABLE_100
147: , a4 out nocopy JTF_DATE_TABLE
148: , a5 out nocopy JTF_DATE_TABLE
149: , a6 out nocopy JTF_VARCHAR2_TABLE_100
142: );
143: procedure rosetta_table_copy_out_p8(t okl_sip_pvt.sip_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
144: , a1 out nocopy JTF_NUMBER_TABLE
145: , a2 out nocopy JTF_VARCHAR2_TABLE_100
146: , a3 out nocopy JTF_VARCHAR2_TABLE_100
147: , a4 out nocopy JTF_DATE_TABLE
148: , a5 out nocopy JTF_DATE_TABLE
149: , a6 out nocopy JTF_VARCHAR2_TABLE_100
150: , a7 out nocopy JTF_VARCHAR2_TABLE_100
145: , a2 out nocopy JTF_VARCHAR2_TABLE_100
146: , a3 out nocopy JTF_VARCHAR2_TABLE_100
147: , a4 out nocopy JTF_DATE_TABLE
148: , a5 out nocopy JTF_DATE_TABLE
149: , a6 out nocopy JTF_VARCHAR2_TABLE_100
150: , a7 out nocopy JTF_VARCHAR2_TABLE_100
151: , a8 out nocopy JTF_VARCHAR2_TABLE_100
152: , a9 out nocopy JTF_NUMBER_TABLE
153: , a10 out nocopy JTF_NUMBER_TABLE
146: , a3 out nocopy JTF_VARCHAR2_TABLE_100
147: , a4 out nocopy JTF_DATE_TABLE
148: , a5 out nocopy JTF_DATE_TABLE
149: , a6 out nocopy JTF_VARCHAR2_TABLE_100
150: , a7 out nocopy JTF_VARCHAR2_TABLE_100
151: , a8 out nocopy JTF_VARCHAR2_TABLE_100
152: , a9 out nocopy JTF_NUMBER_TABLE
153: , a10 out nocopy JTF_NUMBER_TABLE
154: , a11 out nocopy JTF_NUMBER_TABLE
147: , a4 out nocopy JTF_DATE_TABLE
148: , a5 out nocopy JTF_DATE_TABLE
149: , a6 out nocopy JTF_VARCHAR2_TABLE_100
150: , a7 out nocopy JTF_VARCHAR2_TABLE_100
151: , a8 out nocopy JTF_VARCHAR2_TABLE_100
152: , a9 out nocopy JTF_NUMBER_TABLE
153: , a10 out nocopy JTF_NUMBER_TABLE
154: , a11 out nocopy JTF_NUMBER_TABLE
155: , a12 out nocopy JTF_NUMBER_TABLE
153: , a10 out nocopy JTF_NUMBER_TABLE
154: , a11 out nocopy JTF_NUMBER_TABLE
155: , a12 out nocopy JTF_NUMBER_TABLE
156: , a13 out nocopy JTF_DATE_TABLE
157: , a14 out nocopy JTF_VARCHAR2_TABLE_100
158: , a15 out nocopy JTF_VARCHAR2_TABLE_500
159: , a16 out nocopy JTF_VARCHAR2_TABLE_500
160: , a17 out nocopy JTF_VARCHAR2_TABLE_500
161: , a18 out nocopy JTF_VARCHAR2_TABLE_500
265: , x_msg_count out nocopy NUMBER
266: , x_msg_data out nocopy VARCHAR2
267: , p5_a0 JTF_NUMBER_TABLE
268: , p5_a1 JTF_NUMBER_TABLE
269: , p5_a2 JTF_VARCHAR2_TABLE_100
270: , p5_a3 JTF_VARCHAR2_TABLE_100
271: , p5_a4 JTF_VARCHAR2_TABLE_100
272: , p5_a5 JTF_VARCHAR2_TABLE_200
273: , p5_a6 JTF_VARCHAR2_TABLE_2000
266: , x_msg_data out nocopy VARCHAR2
267: , p5_a0 JTF_NUMBER_TABLE
268: , p5_a1 JTF_NUMBER_TABLE
269: , p5_a2 JTF_VARCHAR2_TABLE_100
270: , p5_a3 JTF_VARCHAR2_TABLE_100
271: , p5_a4 JTF_VARCHAR2_TABLE_100
272: , p5_a5 JTF_VARCHAR2_TABLE_200
273: , p5_a6 JTF_VARCHAR2_TABLE_2000
274: , p5_a7 JTF_DATE_TABLE
267: , p5_a0 JTF_NUMBER_TABLE
268: , p5_a1 JTF_NUMBER_TABLE
269: , p5_a2 JTF_VARCHAR2_TABLE_100
270: , p5_a3 JTF_VARCHAR2_TABLE_100
271: , p5_a4 JTF_VARCHAR2_TABLE_100
272: , p5_a5 JTF_VARCHAR2_TABLE_200
273: , p5_a6 JTF_VARCHAR2_TABLE_2000
274: , p5_a7 JTF_DATE_TABLE
275: , p5_a8 JTF_DATE_TABLE
272: , p5_a5 JTF_VARCHAR2_TABLE_200
273: , p5_a6 JTF_VARCHAR2_TABLE_2000
274: , p5_a7 JTF_DATE_TABLE
275: , p5_a8 JTF_DATE_TABLE
276: , p5_a9 JTF_VARCHAR2_TABLE_100
277: , p5_a10 JTF_VARCHAR2_TABLE_100
278: , p5_a11 JTF_VARCHAR2_TABLE_100
279: , p5_a12 JTF_NUMBER_TABLE
280: , p5_a13 JTF_NUMBER_TABLE
273: , p5_a6 JTF_VARCHAR2_TABLE_2000
274: , p5_a7 JTF_DATE_TABLE
275: , p5_a8 JTF_DATE_TABLE
276: , p5_a9 JTF_VARCHAR2_TABLE_100
277: , p5_a10 JTF_VARCHAR2_TABLE_100
278: , p5_a11 JTF_VARCHAR2_TABLE_100
279: , p5_a12 JTF_NUMBER_TABLE
280: , p5_a13 JTF_NUMBER_TABLE
281: , p5_a14 JTF_NUMBER_TABLE
274: , p5_a7 JTF_DATE_TABLE
275: , p5_a8 JTF_DATE_TABLE
276: , p5_a9 JTF_VARCHAR2_TABLE_100
277: , p5_a10 JTF_VARCHAR2_TABLE_100
278: , p5_a11 JTF_VARCHAR2_TABLE_100
279: , p5_a12 JTF_NUMBER_TABLE
280: , p5_a13 JTF_NUMBER_TABLE
281: , p5_a14 JTF_NUMBER_TABLE
282: , p5_a15 JTF_NUMBER_TABLE
280: , p5_a13 JTF_NUMBER_TABLE
281: , p5_a14 JTF_NUMBER_TABLE
282: , p5_a15 JTF_NUMBER_TABLE
283: , p5_a16 JTF_DATE_TABLE
284: , p5_a17 JTF_VARCHAR2_TABLE_100
285: , p5_a18 JTF_VARCHAR2_TABLE_500
286: , p5_a19 JTF_VARCHAR2_TABLE_500
287: , p5_a20 JTF_VARCHAR2_TABLE_500
288: , p5_a21 JTF_VARCHAR2_TABLE_500
303: , p5_a36 JTF_DATE_TABLE
304: , p5_a37 JTF_NUMBER_TABLE
305: , p6_a0 out nocopy JTF_NUMBER_TABLE
306: , p6_a1 out nocopy JTF_NUMBER_TABLE
307: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
309: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
310: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
311: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
304: , p5_a37 JTF_NUMBER_TABLE
305: , p6_a0 out nocopy JTF_NUMBER_TABLE
306: , p6_a1 out nocopy JTF_NUMBER_TABLE
307: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
309: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
310: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
311: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
312: , p6_a7 out nocopy JTF_DATE_TABLE
305: , p6_a0 out nocopy JTF_NUMBER_TABLE
306: , p6_a1 out nocopy JTF_NUMBER_TABLE
307: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
308: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
309: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
310: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
311: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
312: , p6_a7 out nocopy JTF_DATE_TABLE
313: , p6_a8 out nocopy JTF_DATE_TABLE
310: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
311: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
312: , p6_a7 out nocopy JTF_DATE_TABLE
313: , p6_a8 out nocopy JTF_DATE_TABLE
314: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
315: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a12 out nocopy JTF_NUMBER_TABLE
318: , p6_a13 out nocopy JTF_NUMBER_TABLE
311: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
312: , p6_a7 out nocopy JTF_DATE_TABLE
313: , p6_a8 out nocopy JTF_DATE_TABLE
314: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
315: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a12 out nocopy JTF_NUMBER_TABLE
318: , p6_a13 out nocopy JTF_NUMBER_TABLE
319: , p6_a14 out nocopy JTF_NUMBER_TABLE
312: , p6_a7 out nocopy JTF_DATE_TABLE
313: , p6_a8 out nocopy JTF_DATE_TABLE
314: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
315: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
316: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
317: , p6_a12 out nocopy JTF_NUMBER_TABLE
318: , p6_a13 out nocopy JTF_NUMBER_TABLE
319: , p6_a14 out nocopy JTF_NUMBER_TABLE
320: , p6_a15 out nocopy JTF_NUMBER_TABLE
318: , p6_a13 out nocopy JTF_NUMBER_TABLE
319: , p6_a14 out nocopy JTF_NUMBER_TABLE
320: , p6_a15 out nocopy JTF_NUMBER_TABLE
321: , p6_a16 out nocopy JTF_DATE_TABLE
322: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
323: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
324: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
325: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
326: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
391: , x_msg_count out nocopy NUMBER
392: , x_msg_data out nocopy VARCHAR2
393: , p5_a0 JTF_NUMBER_TABLE
394: , p5_a1 JTF_NUMBER_TABLE
395: , p5_a2 JTF_VARCHAR2_TABLE_100
396: , p5_a3 JTF_VARCHAR2_TABLE_100
397: , p5_a4 JTF_VARCHAR2_TABLE_100
398: , p5_a5 JTF_VARCHAR2_TABLE_200
399: , p5_a6 JTF_VARCHAR2_TABLE_2000
392: , x_msg_data out nocopy VARCHAR2
393: , p5_a0 JTF_NUMBER_TABLE
394: , p5_a1 JTF_NUMBER_TABLE
395: , p5_a2 JTF_VARCHAR2_TABLE_100
396: , p5_a3 JTF_VARCHAR2_TABLE_100
397: , p5_a4 JTF_VARCHAR2_TABLE_100
398: , p5_a5 JTF_VARCHAR2_TABLE_200
399: , p5_a6 JTF_VARCHAR2_TABLE_2000
400: , p5_a7 JTF_DATE_TABLE
393: , p5_a0 JTF_NUMBER_TABLE
394: , p5_a1 JTF_NUMBER_TABLE
395: , p5_a2 JTF_VARCHAR2_TABLE_100
396: , p5_a3 JTF_VARCHAR2_TABLE_100
397: , p5_a4 JTF_VARCHAR2_TABLE_100
398: , p5_a5 JTF_VARCHAR2_TABLE_200
399: , p5_a6 JTF_VARCHAR2_TABLE_2000
400: , p5_a7 JTF_DATE_TABLE
401: , p5_a8 JTF_DATE_TABLE
398: , p5_a5 JTF_VARCHAR2_TABLE_200
399: , p5_a6 JTF_VARCHAR2_TABLE_2000
400: , p5_a7 JTF_DATE_TABLE
401: , p5_a8 JTF_DATE_TABLE
402: , p5_a9 JTF_VARCHAR2_TABLE_100
403: , p5_a10 JTF_VARCHAR2_TABLE_100
404: , p5_a11 JTF_VARCHAR2_TABLE_100
405: , p5_a12 JTF_NUMBER_TABLE
406: , p5_a13 JTF_NUMBER_TABLE
399: , p5_a6 JTF_VARCHAR2_TABLE_2000
400: , p5_a7 JTF_DATE_TABLE
401: , p5_a8 JTF_DATE_TABLE
402: , p5_a9 JTF_VARCHAR2_TABLE_100
403: , p5_a10 JTF_VARCHAR2_TABLE_100
404: , p5_a11 JTF_VARCHAR2_TABLE_100
405: , p5_a12 JTF_NUMBER_TABLE
406: , p5_a13 JTF_NUMBER_TABLE
407: , p5_a14 JTF_NUMBER_TABLE
400: , p5_a7 JTF_DATE_TABLE
401: , p5_a8 JTF_DATE_TABLE
402: , p5_a9 JTF_VARCHAR2_TABLE_100
403: , p5_a10 JTF_VARCHAR2_TABLE_100
404: , p5_a11 JTF_VARCHAR2_TABLE_100
405: , p5_a12 JTF_NUMBER_TABLE
406: , p5_a13 JTF_NUMBER_TABLE
407: , p5_a14 JTF_NUMBER_TABLE
408: , p5_a15 JTF_NUMBER_TABLE
406: , p5_a13 JTF_NUMBER_TABLE
407: , p5_a14 JTF_NUMBER_TABLE
408: , p5_a15 JTF_NUMBER_TABLE
409: , p5_a16 JTF_DATE_TABLE
410: , p5_a17 JTF_VARCHAR2_TABLE_100
411: , p5_a18 JTF_VARCHAR2_TABLE_500
412: , p5_a19 JTF_VARCHAR2_TABLE_500
413: , p5_a20 JTF_VARCHAR2_TABLE_500
414: , p5_a21 JTF_VARCHAR2_TABLE_500
517: , x_msg_count out nocopy NUMBER
518: , x_msg_data out nocopy VARCHAR2
519: , p5_a0 JTF_NUMBER_TABLE
520: , p5_a1 JTF_NUMBER_TABLE
521: , p5_a2 JTF_VARCHAR2_TABLE_100
522: , p5_a3 JTF_VARCHAR2_TABLE_100
523: , p5_a4 JTF_VARCHAR2_TABLE_100
524: , p5_a5 JTF_VARCHAR2_TABLE_200
525: , p5_a6 JTF_VARCHAR2_TABLE_2000
518: , x_msg_data out nocopy VARCHAR2
519: , p5_a0 JTF_NUMBER_TABLE
520: , p5_a1 JTF_NUMBER_TABLE
521: , p5_a2 JTF_VARCHAR2_TABLE_100
522: , p5_a3 JTF_VARCHAR2_TABLE_100
523: , p5_a4 JTF_VARCHAR2_TABLE_100
524: , p5_a5 JTF_VARCHAR2_TABLE_200
525: , p5_a6 JTF_VARCHAR2_TABLE_2000
526: , p5_a7 JTF_DATE_TABLE
519: , p5_a0 JTF_NUMBER_TABLE
520: , p5_a1 JTF_NUMBER_TABLE
521: , p5_a2 JTF_VARCHAR2_TABLE_100
522: , p5_a3 JTF_VARCHAR2_TABLE_100
523: , p5_a4 JTF_VARCHAR2_TABLE_100
524: , p5_a5 JTF_VARCHAR2_TABLE_200
525: , p5_a6 JTF_VARCHAR2_TABLE_2000
526: , p5_a7 JTF_DATE_TABLE
527: , p5_a8 JTF_DATE_TABLE
524: , p5_a5 JTF_VARCHAR2_TABLE_200
525: , p5_a6 JTF_VARCHAR2_TABLE_2000
526: , p5_a7 JTF_DATE_TABLE
527: , p5_a8 JTF_DATE_TABLE
528: , p5_a9 JTF_VARCHAR2_TABLE_100
529: , p5_a10 JTF_VARCHAR2_TABLE_100
530: , p5_a11 JTF_VARCHAR2_TABLE_100
531: , p5_a12 JTF_NUMBER_TABLE
532: , p5_a13 JTF_NUMBER_TABLE
525: , p5_a6 JTF_VARCHAR2_TABLE_2000
526: , p5_a7 JTF_DATE_TABLE
527: , p5_a8 JTF_DATE_TABLE
528: , p5_a9 JTF_VARCHAR2_TABLE_100
529: , p5_a10 JTF_VARCHAR2_TABLE_100
530: , p5_a11 JTF_VARCHAR2_TABLE_100
531: , p5_a12 JTF_NUMBER_TABLE
532: , p5_a13 JTF_NUMBER_TABLE
533: , p5_a14 JTF_NUMBER_TABLE
526: , p5_a7 JTF_DATE_TABLE
527: , p5_a8 JTF_DATE_TABLE
528: , p5_a9 JTF_VARCHAR2_TABLE_100
529: , p5_a10 JTF_VARCHAR2_TABLE_100
530: , p5_a11 JTF_VARCHAR2_TABLE_100
531: , p5_a12 JTF_NUMBER_TABLE
532: , p5_a13 JTF_NUMBER_TABLE
533: , p5_a14 JTF_NUMBER_TABLE
534: , p5_a15 JTF_NUMBER_TABLE
532: , p5_a13 JTF_NUMBER_TABLE
533: , p5_a14 JTF_NUMBER_TABLE
534: , p5_a15 JTF_NUMBER_TABLE
535: , p5_a16 JTF_DATE_TABLE
536: , p5_a17 JTF_VARCHAR2_TABLE_100
537: , p5_a18 JTF_VARCHAR2_TABLE_500
538: , p5_a19 JTF_VARCHAR2_TABLE_500
539: , p5_a20 JTF_VARCHAR2_TABLE_500
540: , p5_a21 JTF_VARCHAR2_TABLE_500
555: , p5_a36 JTF_DATE_TABLE
556: , p5_a37 JTF_NUMBER_TABLE
557: , p6_a0 out nocopy JTF_NUMBER_TABLE
558: , p6_a1 out nocopy JTF_NUMBER_TABLE
559: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
560: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
561: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
562: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
563: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
556: , p5_a37 JTF_NUMBER_TABLE
557: , p6_a0 out nocopy JTF_NUMBER_TABLE
558: , p6_a1 out nocopy JTF_NUMBER_TABLE
559: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
560: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
561: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
562: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
563: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
564: , p6_a7 out nocopy JTF_DATE_TABLE
557: , p6_a0 out nocopy JTF_NUMBER_TABLE
558: , p6_a1 out nocopy JTF_NUMBER_TABLE
559: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
560: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
561: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
562: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
563: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
564: , p6_a7 out nocopy JTF_DATE_TABLE
565: , p6_a8 out nocopy JTF_DATE_TABLE
562: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_200
563: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
564: , p6_a7 out nocopy JTF_DATE_TABLE
565: , p6_a8 out nocopy JTF_DATE_TABLE
566: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
567: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
568: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
569: , p6_a12 out nocopy JTF_NUMBER_TABLE
570: , p6_a13 out nocopy JTF_NUMBER_TABLE
563: , p6_a6 out nocopy JTF_VARCHAR2_TABLE_2000
564: , p6_a7 out nocopy JTF_DATE_TABLE
565: , p6_a8 out nocopy JTF_DATE_TABLE
566: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
567: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
568: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
569: , p6_a12 out nocopy JTF_NUMBER_TABLE
570: , p6_a13 out nocopy JTF_NUMBER_TABLE
571: , p6_a14 out nocopy JTF_NUMBER_TABLE
564: , p6_a7 out nocopy JTF_DATE_TABLE
565: , p6_a8 out nocopy JTF_DATE_TABLE
566: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
567: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
568: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_100
569: , p6_a12 out nocopy JTF_NUMBER_TABLE
570: , p6_a13 out nocopy JTF_NUMBER_TABLE
571: , p6_a14 out nocopy JTF_NUMBER_TABLE
572: , p6_a15 out nocopy JTF_NUMBER_TABLE
570: , p6_a13 out nocopy JTF_NUMBER_TABLE
571: , p6_a14 out nocopy JTF_NUMBER_TABLE
572: , p6_a15 out nocopy JTF_NUMBER_TABLE
573: , p6_a16 out nocopy JTF_DATE_TABLE
574: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_100
575: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_500
576: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_500
577: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_500
578: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
643: , x_msg_count out nocopy NUMBER
644: , x_msg_data out nocopy VARCHAR2
645: , p5_a0 JTF_NUMBER_TABLE
646: , p5_a1 JTF_NUMBER_TABLE
647: , p5_a2 JTF_VARCHAR2_TABLE_100
648: , p5_a3 JTF_VARCHAR2_TABLE_100
649: , p5_a4 JTF_VARCHAR2_TABLE_100
650: , p5_a5 JTF_VARCHAR2_TABLE_200
651: , p5_a6 JTF_VARCHAR2_TABLE_2000
644: , x_msg_data out nocopy VARCHAR2
645: , p5_a0 JTF_NUMBER_TABLE
646: , p5_a1 JTF_NUMBER_TABLE
647: , p5_a2 JTF_VARCHAR2_TABLE_100
648: , p5_a3 JTF_VARCHAR2_TABLE_100
649: , p5_a4 JTF_VARCHAR2_TABLE_100
650: , p5_a5 JTF_VARCHAR2_TABLE_200
651: , p5_a6 JTF_VARCHAR2_TABLE_2000
652: , p5_a7 JTF_DATE_TABLE
645: , p5_a0 JTF_NUMBER_TABLE
646: , p5_a1 JTF_NUMBER_TABLE
647: , p5_a2 JTF_VARCHAR2_TABLE_100
648: , p5_a3 JTF_VARCHAR2_TABLE_100
649: , p5_a4 JTF_VARCHAR2_TABLE_100
650: , p5_a5 JTF_VARCHAR2_TABLE_200
651: , p5_a6 JTF_VARCHAR2_TABLE_2000
652: , p5_a7 JTF_DATE_TABLE
653: , p5_a8 JTF_DATE_TABLE
650: , p5_a5 JTF_VARCHAR2_TABLE_200
651: , p5_a6 JTF_VARCHAR2_TABLE_2000
652: , p5_a7 JTF_DATE_TABLE
653: , p5_a8 JTF_DATE_TABLE
654: , p5_a9 JTF_VARCHAR2_TABLE_100
655: , p5_a10 JTF_VARCHAR2_TABLE_100
656: , p5_a11 JTF_VARCHAR2_TABLE_100
657: , p5_a12 JTF_NUMBER_TABLE
658: , p5_a13 JTF_NUMBER_TABLE
651: , p5_a6 JTF_VARCHAR2_TABLE_2000
652: , p5_a7 JTF_DATE_TABLE
653: , p5_a8 JTF_DATE_TABLE
654: , p5_a9 JTF_VARCHAR2_TABLE_100
655: , p5_a10 JTF_VARCHAR2_TABLE_100
656: , p5_a11 JTF_VARCHAR2_TABLE_100
657: , p5_a12 JTF_NUMBER_TABLE
658: , p5_a13 JTF_NUMBER_TABLE
659: , p5_a14 JTF_NUMBER_TABLE
652: , p5_a7 JTF_DATE_TABLE
653: , p5_a8 JTF_DATE_TABLE
654: , p5_a9 JTF_VARCHAR2_TABLE_100
655: , p5_a10 JTF_VARCHAR2_TABLE_100
656: , p5_a11 JTF_VARCHAR2_TABLE_100
657: , p5_a12 JTF_NUMBER_TABLE
658: , p5_a13 JTF_NUMBER_TABLE
659: , p5_a14 JTF_NUMBER_TABLE
660: , p5_a15 JTF_NUMBER_TABLE
658: , p5_a13 JTF_NUMBER_TABLE
659: , p5_a14 JTF_NUMBER_TABLE
660: , p5_a15 JTF_NUMBER_TABLE
661: , p5_a16 JTF_DATE_TABLE
662: , p5_a17 JTF_VARCHAR2_TABLE_100
663: , p5_a18 JTF_VARCHAR2_TABLE_500
664: , p5_a19 JTF_VARCHAR2_TABLE_500
665: , p5_a20 JTF_VARCHAR2_TABLE_500
666: , p5_a21 JTF_VARCHAR2_TABLE_500
731: , x_msg_count out nocopy NUMBER
732: , x_msg_data out nocopy VARCHAR2
733: , p5_a0 JTF_NUMBER_TABLE
734: , p5_a1 JTF_NUMBER_TABLE
735: , p5_a2 JTF_VARCHAR2_TABLE_100
736: , p5_a3 JTF_VARCHAR2_TABLE_100
737: , p5_a4 JTF_VARCHAR2_TABLE_100
738: , p5_a5 JTF_VARCHAR2_TABLE_200
739: , p5_a6 JTF_VARCHAR2_TABLE_2000
732: , x_msg_data out nocopy VARCHAR2
733: , p5_a0 JTF_NUMBER_TABLE
734: , p5_a1 JTF_NUMBER_TABLE
735: , p5_a2 JTF_VARCHAR2_TABLE_100
736: , p5_a3 JTF_VARCHAR2_TABLE_100
737: , p5_a4 JTF_VARCHAR2_TABLE_100
738: , p5_a5 JTF_VARCHAR2_TABLE_200
739: , p5_a6 JTF_VARCHAR2_TABLE_2000
740: , p5_a7 JTF_DATE_TABLE
733: , p5_a0 JTF_NUMBER_TABLE
734: , p5_a1 JTF_NUMBER_TABLE
735: , p5_a2 JTF_VARCHAR2_TABLE_100
736: , p5_a3 JTF_VARCHAR2_TABLE_100
737: , p5_a4 JTF_VARCHAR2_TABLE_100
738: , p5_a5 JTF_VARCHAR2_TABLE_200
739: , p5_a6 JTF_VARCHAR2_TABLE_2000
740: , p5_a7 JTF_DATE_TABLE
741: , p5_a8 JTF_DATE_TABLE
738: , p5_a5 JTF_VARCHAR2_TABLE_200
739: , p5_a6 JTF_VARCHAR2_TABLE_2000
740: , p5_a7 JTF_DATE_TABLE
741: , p5_a8 JTF_DATE_TABLE
742: , p5_a9 JTF_VARCHAR2_TABLE_100
743: , p5_a10 JTF_VARCHAR2_TABLE_100
744: , p5_a11 JTF_VARCHAR2_TABLE_100
745: , p5_a12 JTF_NUMBER_TABLE
746: , p5_a13 JTF_NUMBER_TABLE
739: , p5_a6 JTF_VARCHAR2_TABLE_2000
740: , p5_a7 JTF_DATE_TABLE
741: , p5_a8 JTF_DATE_TABLE
742: , p5_a9 JTF_VARCHAR2_TABLE_100
743: , p5_a10 JTF_VARCHAR2_TABLE_100
744: , p5_a11 JTF_VARCHAR2_TABLE_100
745: , p5_a12 JTF_NUMBER_TABLE
746: , p5_a13 JTF_NUMBER_TABLE
747: , p5_a14 JTF_NUMBER_TABLE
740: , p5_a7 JTF_DATE_TABLE
741: , p5_a8 JTF_DATE_TABLE
742: , p5_a9 JTF_VARCHAR2_TABLE_100
743: , p5_a10 JTF_VARCHAR2_TABLE_100
744: , p5_a11 JTF_VARCHAR2_TABLE_100
745: , p5_a12 JTF_NUMBER_TABLE
746: , p5_a13 JTF_NUMBER_TABLE
747: , p5_a14 JTF_NUMBER_TABLE
748: , p5_a15 JTF_NUMBER_TABLE
746: , p5_a13 JTF_NUMBER_TABLE
747: , p5_a14 JTF_NUMBER_TABLE
748: , p5_a15 JTF_NUMBER_TABLE
749: , p5_a16 JTF_DATE_TABLE
750: , p5_a17 JTF_VARCHAR2_TABLE_100
751: , p5_a18 JTF_VARCHAR2_TABLE_500
752: , p5_a19 JTF_VARCHAR2_TABLE_500
753: , p5_a20 JTF_VARCHAR2_TABLE_500
754: , p5_a21 JTF_VARCHAR2_TABLE_500