1: package okl_ims_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLEIMSS.pls 120.2 2005/07/14 11:57:21 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ims_pvt.ims_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
1: package okl_ims_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLEIMSS.pls 120.2 2005/07/14 11:57:21 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ims_pvt.ims_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
1: package okl_ims_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLEIMSS.pls 120.2 2005/07/14 11:57:21 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ims_pvt.ims_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_500
2: /* $Header: OKLEIMSS.pls 120.2 2005/07/14 11:57:21 asawanka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_ims_pvt.ims_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_DATE_TABLE
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_500
10: , a7 JTF_VARCHAR2_TABLE_500
20: , a17 JTF_VARCHAR2_TABLE_500
21: , a18 JTF_VARCHAR2_TABLE_500
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
22: , a19 JTF_VARCHAR2_TABLE_500
23: , a20 JTF_VARCHAR2_TABLE_500
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
24: , a21 JTF_NUMBER_TABLE
25: , a22 JTF_DATE_TABLE
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_300
32: );
29: , a26 JTF_DATE_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_300
32: );
33: procedure rosetta_table_copy_out_p2(t okl_ims_pvt.ims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_DATE_TABLE
30: , a27 JTF_VARCHAR2_TABLE_300
31: , a28 JTF_VARCHAR2_TABLE_300
32: );
33: procedure rosetta_table_copy_out_p2(t okl_ims_pvt.ims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_DATE_TABLE
38: , a5 out nocopy JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_300
32: );
33: procedure rosetta_table_copy_out_p2(t okl_ims_pvt.ims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_DATE_TABLE
38: , a5 out nocopy JTF_VARCHAR2_TABLE_100
39: , a6 out nocopy JTF_VARCHAR2_TABLE_500
32: );
33: procedure rosetta_table_copy_out_p2(t okl_ims_pvt.ims_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
34: , a1 out nocopy JTF_NUMBER_TABLE
35: , a2 out nocopy JTF_NUMBER_TABLE
36: , a3 out nocopy JTF_NUMBER_TABLE
37: , a4 out nocopy JTF_DATE_TABLE
38: , a5 out nocopy JTF_VARCHAR2_TABLE_100
39: , a6 out nocopy JTF_VARCHAR2_TABLE_500
40: , a7 out nocopy JTF_VARCHAR2_TABLE_500
50: , a17 out nocopy JTF_VARCHAR2_TABLE_500
51: , a18 out nocopy JTF_VARCHAR2_TABLE_500
52: , a19 out nocopy JTF_VARCHAR2_TABLE_500
53: , a20 out nocopy JTF_VARCHAR2_TABLE_500
54: , a21 out nocopy JTF_NUMBER_TABLE
55: , a22 out nocopy JTF_DATE_TABLE
56: , a23 out nocopy JTF_NUMBER_TABLE
57: , a24 out nocopy JTF_DATE_TABLE
58: , a25 out nocopy JTF_NUMBER_TABLE
52: , a19 out nocopy JTF_VARCHAR2_TABLE_500
53: , a20 out nocopy JTF_VARCHAR2_TABLE_500
54: , a21 out nocopy JTF_NUMBER_TABLE
55: , a22 out nocopy JTF_DATE_TABLE
56: , a23 out nocopy JTF_NUMBER_TABLE
57: , a24 out nocopy JTF_DATE_TABLE
58: , a25 out nocopy JTF_NUMBER_TABLE
59: , a26 out nocopy JTF_DATE_TABLE
60: , a27 out nocopy JTF_VARCHAR2_TABLE_300
54: , a21 out nocopy JTF_NUMBER_TABLE
55: , a22 out nocopy JTF_DATE_TABLE
56: , a23 out nocopy JTF_NUMBER_TABLE
57: , a24 out nocopy JTF_DATE_TABLE
58: , a25 out nocopy JTF_NUMBER_TABLE
59: , a26 out nocopy JTF_DATE_TABLE
60: , a27 out nocopy JTF_VARCHAR2_TABLE_300
61: , a28 out nocopy JTF_VARCHAR2_TABLE_300
62: );
60: , a27 out nocopy JTF_VARCHAR2_TABLE_300
61: , a28 out nocopy JTF_VARCHAR2_TABLE_300
62: );
63:
64: procedure rosetta_table_copy_in_p5(t out nocopy okl_ims_pvt.okl_invoice_mssgs_tl_tbl_type, a0 JTF_NUMBER_TABLE
65: , a1 JTF_VARCHAR2_TABLE_100
66: , a2 JTF_VARCHAR2_TABLE_100
67: , a3 JTF_VARCHAR2_TABLE_100
68: , a4 JTF_VARCHAR2_TABLE_200
67: , a3 JTF_VARCHAR2_TABLE_100
68: , a4 JTF_VARCHAR2_TABLE_200
69: , a5 JTF_VARCHAR2_TABLE_2000
70: , a6 JTF_VARCHAR2_TABLE_2000
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_DATE_TABLE
73: , a9 JTF_NUMBER_TABLE
74: , a10 JTF_DATE_TABLE
75: , a11 JTF_NUMBER_TABLE
69: , a5 JTF_VARCHAR2_TABLE_2000
70: , a6 JTF_VARCHAR2_TABLE_2000
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_DATE_TABLE
73: , a9 JTF_NUMBER_TABLE
74: , a10 JTF_DATE_TABLE
75: , a11 JTF_NUMBER_TABLE
76: );
77: procedure rosetta_table_copy_out_p5(t okl_ims_pvt.okl_invoice_mssgs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
71: , a7 JTF_NUMBER_TABLE
72: , a8 JTF_DATE_TABLE
73: , a9 JTF_NUMBER_TABLE
74: , a10 JTF_DATE_TABLE
75: , a11 JTF_NUMBER_TABLE
76: );
77: procedure rosetta_table_copy_out_p5(t okl_ims_pvt.okl_invoice_mssgs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_VARCHAR2_TABLE_100
79: , a2 out nocopy JTF_VARCHAR2_TABLE_100
73: , a9 JTF_NUMBER_TABLE
74: , a10 JTF_DATE_TABLE
75: , a11 JTF_NUMBER_TABLE
76: );
77: procedure rosetta_table_copy_out_p5(t okl_ims_pvt.okl_invoice_mssgs_tl_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
78: , a1 out nocopy JTF_VARCHAR2_TABLE_100
79: , a2 out nocopy JTF_VARCHAR2_TABLE_100
80: , a3 out nocopy JTF_VARCHAR2_TABLE_100
81: , a4 out nocopy JTF_VARCHAR2_TABLE_200
80: , a3 out nocopy JTF_VARCHAR2_TABLE_100
81: , a4 out nocopy JTF_VARCHAR2_TABLE_200
82: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
83: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
84: , a7 out nocopy JTF_NUMBER_TABLE
85: , a8 out nocopy JTF_DATE_TABLE
86: , a9 out nocopy JTF_NUMBER_TABLE
87: , a10 out nocopy JTF_DATE_TABLE
88: , a11 out nocopy JTF_NUMBER_TABLE
82: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
83: , a6 out nocopy JTF_VARCHAR2_TABLE_2000
84: , a7 out nocopy JTF_NUMBER_TABLE
85: , a8 out nocopy JTF_DATE_TABLE
86: , a9 out nocopy JTF_NUMBER_TABLE
87: , a10 out nocopy JTF_DATE_TABLE
88: , a11 out nocopy JTF_NUMBER_TABLE
89: );
90:
84: , a7 out nocopy JTF_NUMBER_TABLE
85: , a8 out nocopy JTF_DATE_TABLE
86: , a9 out nocopy JTF_NUMBER_TABLE
87: , a10 out nocopy JTF_DATE_TABLE
88: , a11 out nocopy JTF_NUMBER_TABLE
89: );
90:
91: procedure rosetta_table_copy_in_p8(t out nocopy okl_ims_pvt.imsv_tbl_type, a0 JTF_NUMBER_TABLE
92: , a1 JTF_NUMBER_TABLE
87: , a10 out nocopy JTF_DATE_TABLE
88: , a11 out nocopy JTF_NUMBER_TABLE
89: );
90:
91: procedure rosetta_table_copy_in_p8(t out nocopy okl_ims_pvt.imsv_tbl_type, a0 JTF_NUMBER_TABLE
92: , a1 JTF_NUMBER_TABLE
93: , a2 JTF_NUMBER_TABLE
94: , a3 JTF_VARCHAR2_TABLE_100
95: , a4 JTF_VARCHAR2_TABLE_200
88: , a11 out nocopy JTF_NUMBER_TABLE
89: );
90:
91: procedure rosetta_table_copy_in_p8(t out nocopy okl_ims_pvt.imsv_tbl_type, a0 JTF_NUMBER_TABLE
92: , a1 JTF_NUMBER_TABLE
93: , a2 JTF_NUMBER_TABLE
94: , a3 JTF_VARCHAR2_TABLE_100
95: , a4 JTF_VARCHAR2_TABLE_200
96: , a5 JTF_VARCHAR2_TABLE_2000
89: );
90:
91: procedure rosetta_table_copy_in_p8(t out nocopy okl_ims_pvt.imsv_tbl_type, a0 JTF_NUMBER_TABLE
92: , a1 JTF_NUMBER_TABLE
93: , a2 JTF_NUMBER_TABLE
94: , a3 JTF_VARCHAR2_TABLE_100
95: , a4 JTF_VARCHAR2_TABLE_200
96: , a5 JTF_VARCHAR2_TABLE_2000
97: , a6 JTF_NUMBER_TABLE
93: , a2 JTF_NUMBER_TABLE
94: , a3 JTF_VARCHAR2_TABLE_100
95: , a4 JTF_VARCHAR2_TABLE_200
96: , a5 JTF_VARCHAR2_TABLE_2000
97: , a6 JTF_NUMBER_TABLE
98: , a7 JTF_VARCHAR2_TABLE_2000
99: , a8 JTF_DATE_TABLE
100: , a9 JTF_VARCHAR2_TABLE_100
101: , a10 JTF_VARCHAR2_TABLE_500
112: , a21 JTF_VARCHAR2_TABLE_500
113: , a22 JTF_VARCHAR2_TABLE_500
114: , a23 JTF_VARCHAR2_TABLE_500
115: , a24 JTF_VARCHAR2_TABLE_500
116: , a25 JTF_NUMBER_TABLE
117: , a26 JTF_DATE_TABLE
118: , a27 JTF_NUMBER_TABLE
119: , a28 JTF_DATE_TABLE
120: , a29 JTF_NUMBER_TABLE
114: , a23 JTF_VARCHAR2_TABLE_500
115: , a24 JTF_VARCHAR2_TABLE_500
116: , a25 JTF_NUMBER_TABLE
117: , a26 JTF_DATE_TABLE
118: , a27 JTF_NUMBER_TABLE
119: , a28 JTF_DATE_TABLE
120: , a29 JTF_NUMBER_TABLE
121: , a30 JTF_DATE_TABLE
122: , a31 JTF_VARCHAR2_TABLE_300
116: , a25 JTF_NUMBER_TABLE
117: , a26 JTF_DATE_TABLE
118: , a27 JTF_NUMBER_TABLE
119: , a28 JTF_DATE_TABLE
120: , a29 JTF_NUMBER_TABLE
121: , a30 JTF_DATE_TABLE
122: , a31 JTF_VARCHAR2_TABLE_300
123: , a32 JTF_VARCHAR2_TABLE_300
124: );
121: , a30 JTF_DATE_TABLE
122: , a31 JTF_VARCHAR2_TABLE_300
123: , a32 JTF_VARCHAR2_TABLE_300
124: );
125: procedure rosetta_table_copy_out_p8(t okl_ims_pvt.imsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_NUMBER_TABLE
128: , a3 out nocopy JTF_VARCHAR2_TABLE_100
129: , a4 out nocopy JTF_VARCHAR2_TABLE_200
122: , a31 JTF_VARCHAR2_TABLE_300
123: , a32 JTF_VARCHAR2_TABLE_300
124: );
125: procedure rosetta_table_copy_out_p8(t okl_ims_pvt.imsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_NUMBER_TABLE
128: , a3 out nocopy JTF_VARCHAR2_TABLE_100
129: , a4 out nocopy JTF_VARCHAR2_TABLE_200
130: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
123: , a32 JTF_VARCHAR2_TABLE_300
124: );
125: procedure rosetta_table_copy_out_p8(t okl_ims_pvt.imsv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
126: , a1 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_NUMBER_TABLE
128: , a3 out nocopy JTF_VARCHAR2_TABLE_100
129: , a4 out nocopy JTF_VARCHAR2_TABLE_200
130: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
131: , a6 out nocopy JTF_NUMBER_TABLE
127: , a2 out nocopy JTF_NUMBER_TABLE
128: , a3 out nocopy JTF_VARCHAR2_TABLE_100
129: , a4 out nocopy JTF_VARCHAR2_TABLE_200
130: , a5 out nocopy JTF_VARCHAR2_TABLE_2000
131: , a6 out nocopy JTF_NUMBER_TABLE
132: , a7 out nocopy JTF_VARCHAR2_TABLE_2000
133: , a8 out nocopy JTF_DATE_TABLE
134: , a9 out nocopy JTF_VARCHAR2_TABLE_100
135: , a10 out nocopy JTF_VARCHAR2_TABLE_500
146: , a21 out nocopy JTF_VARCHAR2_TABLE_500
147: , a22 out nocopy JTF_VARCHAR2_TABLE_500
148: , a23 out nocopy JTF_VARCHAR2_TABLE_500
149: , a24 out nocopy JTF_VARCHAR2_TABLE_500
150: , a25 out nocopy JTF_NUMBER_TABLE
151: , a26 out nocopy JTF_DATE_TABLE
152: , a27 out nocopy JTF_NUMBER_TABLE
153: , a28 out nocopy JTF_DATE_TABLE
154: , a29 out nocopy JTF_NUMBER_TABLE
148: , a23 out nocopy JTF_VARCHAR2_TABLE_500
149: , a24 out nocopy JTF_VARCHAR2_TABLE_500
150: , a25 out nocopy JTF_NUMBER_TABLE
151: , a26 out nocopy JTF_DATE_TABLE
152: , a27 out nocopy JTF_NUMBER_TABLE
153: , a28 out nocopy JTF_DATE_TABLE
154: , a29 out nocopy JTF_NUMBER_TABLE
155: , a30 out nocopy JTF_DATE_TABLE
156: , a31 out nocopy JTF_VARCHAR2_TABLE_300
150: , a25 out nocopy JTF_NUMBER_TABLE
151: , a26 out nocopy JTF_DATE_TABLE
152: , a27 out nocopy JTF_NUMBER_TABLE
153: , a28 out nocopy JTF_DATE_TABLE
154: , a29 out nocopy JTF_NUMBER_TABLE
155: , a30 out nocopy JTF_DATE_TABLE
156: , a31 out nocopy JTF_VARCHAR2_TABLE_300
157: , a32 out nocopy JTF_VARCHAR2_TABLE_300
158: );
233: , p_init_msg_list VARCHAR2
234: , x_return_status out nocopy VARCHAR2
235: , x_msg_count out nocopy NUMBER
236: , x_msg_data out nocopy VARCHAR2
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_200
234: , x_return_status out nocopy VARCHAR2
235: , x_msg_count out nocopy NUMBER
236: , x_msg_data out nocopy VARCHAR2
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_200
242: , p5_a5 JTF_VARCHAR2_TABLE_2000
235: , x_msg_count out nocopy NUMBER
236: , x_msg_data out nocopy VARCHAR2
237: , p5_a0 JTF_NUMBER_TABLE
238: , p5_a1 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_200
242: , p5_a5 JTF_VARCHAR2_TABLE_2000
243: , p5_a6 JTF_NUMBER_TABLE
239: , p5_a2 JTF_NUMBER_TABLE
240: , p5_a3 JTF_VARCHAR2_TABLE_100
241: , p5_a4 JTF_VARCHAR2_TABLE_200
242: , p5_a5 JTF_VARCHAR2_TABLE_2000
243: , p5_a6 JTF_NUMBER_TABLE
244: , p5_a7 JTF_VARCHAR2_TABLE_2000
245: , p5_a8 JTF_DATE_TABLE
246: , p5_a9 JTF_VARCHAR2_TABLE_100
247: , p5_a10 JTF_VARCHAR2_TABLE_500
258: , p5_a21 JTF_VARCHAR2_TABLE_500
259: , p5_a22 JTF_VARCHAR2_TABLE_500
260: , p5_a23 JTF_VARCHAR2_TABLE_500
261: , p5_a24 JTF_VARCHAR2_TABLE_500
262: , p5_a25 JTF_NUMBER_TABLE
263: , p5_a26 JTF_DATE_TABLE
264: , p5_a27 JTF_NUMBER_TABLE
265: , p5_a28 JTF_DATE_TABLE
266: , p5_a29 JTF_NUMBER_TABLE
260: , p5_a23 JTF_VARCHAR2_TABLE_500
261: , p5_a24 JTF_VARCHAR2_TABLE_500
262: , p5_a25 JTF_NUMBER_TABLE
263: , p5_a26 JTF_DATE_TABLE
264: , p5_a27 JTF_NUMBER_TABLE
265: , p5_a28 JTF_DATE_TABLE
266: , p5_a29 JTF_NUMBER_TABLE
267: , p5_a30 JTF_DATE_TABLE
268: , p5_a31 JTF_VARCHAR2_TABLE_300
262: , p5_a25 JTF_NUMBER_TABLE
263: , p5_a26 JTF_DATE_TABLE
264: , p5_a27 JTF_NUMBER_TABLE
265: , p5_a28 JTF_DATE_TABLE
266: , p5_a29 JTF_NUMBER_TABLE
267: , p5_a30 JTF_DATE_TABLE
268: , p5_a31 JTF_VARCHAR2_TABLE_300
269: , p5_a32 JTF_VARCHAR2_TABLE_300
270: , p6_a0 out nocopy JTF_NUMBER_TABLE
266: , p5_a29 JTF_NUMBER_TABLE
267: , p5_a30 JTF_DATE_TABLE
268: , p5_a31 JTF_VARCHAR2_TABLE_300
269: , p5_a32 JTF_VARCHAR2_TABLE_300
270: , p6_a0 out nocopy JTF_NUMBER_TABLE
271: , p6_a1 out nocopy JTF_NUMBER_TABLE
272: , p6_a2 out nocopy JTF_NUMBER_TABLE
273: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
274: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
267: , p5_a30 JTF_DATE_TABLE
268: , p5_a31 JTF_VARCHAR2_TABLE_300
269: , p5_a32 JTF_VARCHAR2_TABLE_300
270: , p6_a0 out nocopy JTF_NUMBER_TABLE
271: , p6_a1 out nocopy JTF_NUMBER_TABLE
272: , p6_a2 out nocopy JTF_NUMBER_TABLE
273: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
274: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
275: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
268: , p5_a31 JTF_VARCHAR2_TABLE_300
269: , p5_a32 JTF_VARCHAR2_TABLE_300
270: , p6_a0 out nocopy JTF_NUMBER_TABLE
271: , p6_a1 out nocopy JTF_NUMBER_TABLE
272: , p6_a2 out nocopy JTF_NUMBER_TABLE
273: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
274: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
275: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
276: , p6_a6 out nocopy JTF_NUMBER_TABLE
272: , p6_a2 out nocopy JTF_NUMBER_TABLE
273: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
274: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
275: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
276: , p6_a6 out nocopy JTF_NUMBER_TABLE
277: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
278: , p6_a8 out nocopy JTF_DATE_TABLE
279: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
280: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
291: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
292: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
293: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
294: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
295: , p6_a25 out nocopy JTF_NUMBER_TABLE
296: , p6_a26 out nocopy JTF_DATE_TABLE
297: , p6_a27 out nocopy JTF_NUMBER_TABLE
298: , p6_a28 out nocopy JTF_DATE_TABLE
299: , p6_a29 out nocopy JTF_NUMBER_TABLE
293: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
294: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
295: , p6_a25 out nocopy JTF_NUMBER_TABLE
296: , p6_a26 out nocopy JTF_DATE_TABLE
297: , p6_a27 out nocopy JTF_NUMBER_TABLE
298: , p6_a28 out nocopy JTF_DATE_TABLE
299: , p6_a29 out nocopy JTF_NUMBER_TABLE
300: , p6_a30 out nocopy JTF_DATE_TABLE
301: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
295: , p6_a25 out nocopy JTF_NUMBER_TABLE
296: , p6_a26 out nocopy JTF_DATE_TABLE
297: , p6_a27 out nocopy JTF_NUMBER_TABLE
298: , p6_a28 out nocopy JTF_DATE_TABLE
299: , p6_a29 out nocopy JTF_NUMBER_TABLE
300: , p6_a30 out nocopy JTF_DATE_TABLE
301: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
302: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
303: );
344: , p_init_msg_list VARCHAR2
345: , x_return_status out nocopy VARCHAR2
346: , x_msg_count out nocopy NUMBER
347: , x_msg_data out nocopy VARCHAR2
348: , p5_a0 JTF_NUMBER_TABLE
349: , p5_a1 JTF_NUMBER_TABLE
350: , p5_a2 JTF_NUMBER_TABLE
351: , p5_a3 JTF_VARCHAR2_TABLE_100
352: , p5_a4 JTF_VARCHAR2_TABLE_200
345: , x_return_status out nocopy VARCHAR2
346: , x_msg_count out nocopy NUMBER
347: , x_msg_data out nocopy VARCHAR2
348: , p5_a0 JTF_NUMBER_TABLE
349: , p5_a1 JTF_NUMBER_TABLE
350: , p5_a2 JTF_NUMBER_TABLE
351: , p5_a3 JTF_VARCHAR2_TABLE_100
352: , p5_a4 JTF_VARCHAR2_TABLE_200
353: , p5_a5 JTF_VARCHAR2_TABLE_2000
346: , x_msg_count out nocopy NUMBER
347: , x_msg_data out nocopy VARCHAR2
348: , p5_a0 JTF_NUMBER_TABLE
349: , p5_a1 JTF_NUMBER_TABLE
350: , p5_a2 JTF_NUMBER_TABLE
351: , p5_a3 JTF_VARCHAR2_TABLE_100
352: , p5_a4 JTF_VARCHAR2_TABLE_200
353: , p5_a5 JTF_VARCHAR2_TABLE_2000
354: , p5_a6 JTF_NUMBER_TABLE
350: , p5_a2 JTF_NUMBER_TABLE
351: , p5_a3 JTF_VARCHAR2_TABLE_100
352: , p5_a4 JTF_VARCHAR2_TABLE_200
353: , p5_a5 JTF_VARCHAR2_TABLE_2000
354: , p5_a6 JTF_NUMBER_TABLE
355: , p5_a7 JTF_VARCHAR2_TABLE_2000
356: , p5_a8 JTF_DATE_TABLE
357: , p5_a9 JTF_VARCHAR2_TABLE_100
358: , p5_a10 JTF_VARCHAR2_TABLE_500
369: , p5_a21 JTF_VARCHAR2_TABLE_500
370: , p5_a22 JTF_VARCHAR2_TABLE_500
371: , p5_a23 JTF_VARCHAR2_TABLE_500
372: , p5_a24 JTF_VARCHAR2_TABLE_500
373: , p5_a25 JTF_NUMBER_TABLE
374: , p5_a26 JTF_DATE_TABLE
375: , p5_a27 JTF_NUMBER_TABLE
376: , p5_a28 JTF_DATE_TABLE
377: , p5_a29 JTF_NUMBER_TABLE
371: , p5_a23 JTF_VARCHAR2_TABLE_500
372: , p5_a24 JTF_VARCHAR2_TABLE_500
373: , p5_a25 JTF_NUMBER_TABLE
374: , p5_a26 JTF_DATE_TABLE
375: , p5_a27 JTF_NUMBER_TABLE
376: , p5_a28 JTF_DATE_TABLE
377: , p5_a29 JTF_NUMBER_TABLE
378: , p5_a30 JTF_DATE_TABLE
379: , p5_a31 JTF_VARCHAR2_TABLE_300
373: , p5_a25 JTF_NUMBER_TABLE
374: , p5_a26 JTF_DATE_TABLE
375: , p5_a27 JTF_NUMBER_TABLE
376: , p5_a28 JTF_DATE_TABLE
377: , p5_a29 JTF_NUMBER_TABLE
378: , p5_a30 JTF_DATE_TABLE
379: , p5_a31 JTF_VARCHAR2_TABLE_300
380: , p5_a32 JTF_VARCHAR2_TABLE_300
381: );
455: , p_init_msg_list VARCHAR2
456: , x_return_status out nocopy VARCHAR2
457: , x_msg_count out nocopy NUMBER
458: , x_msg_data out nocopy VARCHAR2
459: , p5_a0 JTF_NUMBER_TABLE
460: , p5_a1 JTF_NUMBER_TABLE
461: , p5_a2 JTF_NUMBER_TABLE
462: , p5_a3 JTF_VARCHAR2_TABLE_100
463: , p5_a4 JTF_VARCHAR2_TABLE_200
456: , x_return_status out nocopy VARCHAR2
457: , x_msg_count out nocopy NUMBER
458: , x_msg_data out nocopy VARCHAR2
459: , p5_a0 JTF_NUMBER_TABLE
460: , p5_a1 JTF_NUMBER_TABLE
461: , p5_a2 JTF_NUMBER_TABLE
462: , p5_a3 JTF_VARCHAR2_TABLE_100
463: , p5_a4 JTF_VARCHAR2_TABLE_200
464: , p5_a5 JTF_VARCHAR2_TABLE_2000
457: , x_msg_count out nocopy NUMBER
458: , x_msg_data out nocopy VARCHAR2
459: , p5_a0 JTF_NUMBER_TABLE
460: , p5_a1 JTF_NUMBER_TABLE
461: , p5_a2 JTF_NUMBER_TABLE
462: , p5_a3 JTF_VARCHAR2_TABLE_100
463: , p5_a4 JTF_VARCHAR2_TABLE_200
464: , p5_a5 JTF_VARCHAR2_TABLE_2000
465: , p5_a6 JTF_NUMBER_TABLE
461: , p5_a2 JTF_NUMBER_TABLE
462: , p5_a3 JTF_VARCHAR2_TABLE_100
463: , p5_a4 JTF_VARCHAR2_TABLE_200
464: , p5_a5 JTF_VARCHAR2_TABLE_2000
465: , p5_a6 JTF_NUMBER_TABLE
466: , p5_a7 JTF_VARCHAR2_TABLE_2000
467: , p5_a8 JTF_DATE_TABLE
468: , p5_a9 JTF_VARCHAR2_TABLE_100
469: , p5_a10 JTF_VARCHAR2_TABLE_500
480: , p5_a21 JTF_VARCHAR2_TABLE_500
481: , p5_a22 JTF_VARCHAR2_TABLE_500
482: , p5_a23 JTF_VARCHAR2_TABLE_500
483: , p5_a24 JTF_VARCHAR2_TABLE_500
484: , p5_a25 JTF_NUMBER_TABLE
485: , p5_a26 JTF_DATE_TABLE
486: , p5_a27 JTF_NUMBER_TABLE
487: , p5_a28 JTF_DATE_TABLE
488: , p5_a29 JTF_NUMBER_TABLE
482: , p5_a23 JTF_VARCHAR2_TABLE_500
483: , p5_a24 JTF_VARCHAR2_TABLE_500
484: , p5_a25 JTF_NUMBER_TABLE
485: , p5_a26 JTF_DATE_TABLE
486: , p5_a27 JTF_NUMBER_TABLE
487: , p5_a28 JTF_DATE_TABLE
488: , p5_a29 JTF_NUMBER_TABLE
489: , p5_a30 JTF_DATE_TABLE
490: , p5_a31 JTF_VARCHAR2_TABLE_300
484: , p5_a25 JTF_NUMBER_TABLE
485: , p5_a26 JTF_DATE_TABLE
486: , p5_a27 JTF_NUMBER_TABLE
487: , p5_a28 JTF_DATE_TABLE
488: , p5_a29 JTF_NUMBER_TABLE
489: , p5_a30 JTF_DATE_TABLE
490: , p5_a31 JTF_VARCHAR2_TABLE_300
491: , p5_a32 JTF_VARCHAR2_TABLE_300
492: , p6_a0 out nocopy JTF_NUMBER_TABLE
488: , p5_a29 JTF_NUMBER_TABLE
489: , p5_a30 JTF_DATE_TABLE
490: , p5_a31 JTF_VARCHAR2_TABLE_300
491: , p5_a32 JTF_VARCHAR2_TABLE_300
492: , p6_a0 out nocopy JTF_NUMBER_TABLE
493: , p6_a1 out nocopy JTF_NUMBER_TABLE
494: , p6_a2 out nocopy JTF_NUMBER_TABLE
495: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
496: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
489: , p5_a30 JTF_DATE_TABLE
490: , p5_a31 JTF_VARCHAR2_TABLE_300
491: , p5_a32 JTF_VARCHAR2_TABLE_300
492: , p6_a0 out nocopy JTF_NUMBER_TABLE
493: , p6_a1 out nocopy JTF_NUMBER_TABLE
494: , p6_a2 out nocopy JTF_NUMBER_TABLE
495: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
496: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
497: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
490: , p5_a31 JTF_VARCHAR2_TABLE_300
491: , p5_a32 JTF_VARCHAR2_TABLE_300
492: , p6_a0 out nocopy JTF_NUMBER_TABLE
493: , p6_a1 out nocopy JTF_NUMBER_TABLE
494: , p6_a2 out nocopy JTF_NUMBER_TABLE
495: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
496: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
497: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
498: , p6_a6 out nocopy JTF_NUMBER_TABLE
494: , p6_a2 out nocopy JTF_NUMBER_TABLE
495: , p6_a3 out nocopy JTF_VARCHAR2_TABLE_100
496: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_200
497: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_2000
498: , p6_a6 out nocopy JTF_NUMBER_TABLE
499: , p6_a7 out nocopy JTF_VARCHAR2_TABLE_2000
500: , p6_a8 out nocopy JTF_DATE_TABLE
501: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
502: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_500
513: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_500
514: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_500
515: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
516: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
517: , p6_a25 out nocopy JTF_NUMBER_TABLE
518: , p6_a26 out nocopy JTF_DATE_TABLE
519: , p6_a27 out nocopy JTF_NUMBER_TABLE
520: , p6_a28 out nocopy JTF_DATE_TABLE
521: , p6_a29 out nocopy JTF_NUMBER_TABLE
515: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_500
516: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_500
517: , p6_a25 out nocopy JTF_NUMBER_TABLE
518: , p6_a26 out nocopy JTF_DATE_TABLE
519: , p6_a27 out nocopy JTF_NUMBER_TABLE
520: , p6_a28 out nocopy JTF_DATE_TABLE
521: , p6_a29 out nocopy JTF_NUMBER_TABLE
522: , p6_a30 out nocopy JTF_DATE_TABLE
523: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
517: , p6_a25 out nocopy JTF_NUMBER_TABLE
518: , p6_a26 out nocopy JTF_DATE_TABLE
519: , p6_a27 out nocopy JTF_NUMBER_TABLE
520: , p6_a28 out nocopy JTF_DATE_TABLE
521: , p6_a29 out nocopy JTF_NUMBER_TABLE
522: , p6_a30 out nocopy JTF_DATE_TABLE
523: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_300
524: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_300
525: );
566: , p_init_msg_list VARCHAR2
567: , x_return_status out nocopy VARCHAR2
568: , x_msg_count out nocopy NUMBER
569: , x_msg_data out nocopy VARCHAR2
570: , p5_a0 JTF_NUMBER_TABLE
571: , p5_a1 JTF_NUMBER_TABLE
572: , p5_a2 JTF_NUMBER_TABLE
573: , p5_a3 JTF_VARCHAR2_TABLE_100
574: , p5_a4 JTF_VARCHAR2_TABLE_200
567: , x_return_status out nocopy VARCHAR2
568: , x_msg_count out nocopy NUMBER
569: , x_msg_data out nocopy VARCHAR2
570: , p5_a0 JTF_NUMBER_TABLE
571: , p5_a1 JTF_NUMBER_TABLE
572: , p5_a2 JTF_NUMBER_TABLE
573: , p5_a3 JTF_VARCHAR2_TABLE_100
574: , p5_a4 JTF_VARCHAR2_TABLE_200
575: , p5_a5 JTF_VARCHAR2_TABLE_2000
568: , x_msg_count out nocopy NUMBER
569: , x_msg_data out nocopy VARCHAR2
570: , p5_a0 JTF_NUMBER_TABLE
571: , p5_a1 JTF_NUMBER_TABLE
572: , p5_a2 JTF_NUMBER_TABLE
573: , p5_a3 JTF_VARCHAR2_TABLE_100
574: , p5_a4 JTF_VARCHAR2_TABLE_200
575: , p5_a5 JTF_VARCHAR2_TABLE_2000
576: , p5_a6 JTF_NUMBER_TABLE
572: , p5_a2 JTF_NUMBER_TABLE
573: , p5_a3 JTF_VARCHAR2_TABLE_100
574: , p5_a4 JTF_VARCHAR2_TABLE_200
575: , p5_a5 JTF_VARCHAR2_TABLE_2000
576: , p5_a6 JTF_NUMBER_TABLE
577: , p5_a7 JTF_VARCHAR2_TABLE_2000
578: , p5_a8 JTF_DATE_TABLE
579: , p5_a9 JTF_VARCHAR2_TABLE_100
580: , p5_a10 JTF_VARCHAR2_TABLE_500
591: , p5_a21 JTF_VARCHAR2_TABLE_500
592: , p5_a22 JTF_VARCHAR2_TABLE_500
593: , p5_a23 JTF_VARCHAR2_TABLE_500
594: , p5_a24 JTF_VARCHAR2_TABLE_500
595: , p5_a25 JTF_NUMBER_TABLE
596: , p5_a26 JTF_DATE_TABLE
597: , p5_a27 JTF_NUMBER_TABLE
598: , p5_a28 JTF_DATE_TABLE
599: , p5_a29 JTF_NUMBER_TABLE
593: , p5_a23 JTF_VARCHAR2_TABLE_500
594: , p5_a24 JTF_VARCHAR2_TABLE_500
595: , p5_a25 JTF_NUMBER_TABLE
596: , p5_a26 JTF_DATE_TABLE
597: , p5_a27 JTF_NUMBER_TABLE
598: , p5_a28 JTF_DATE_TABLE
599: , p5_a29 JTF_NUMBER_TABLE
600: , p5_a30 JTF_DATE_TABLE
601: , p5_a31 JTF_VARCHAR2_TABLE_300
595: , p5_a25 JTF_NUMBER_TABLE
596: , p5_a26 JTF_DATE_TABLE
597: , p5_a27 JTF_NUMBER_TABLE
598: , p5_a28 JTF_DATE_TABLE
599: , p5_a29 JTF_NUMBER_TABLE
600: , p5_a30 JTF_DATE_TABLE
601: , p5_a31 JTF_VARCHAR2_TABLE_300
602: , p5_a32 JTF_VARCHAR2_TABLE_300
603: );
644: , p_init_msg_list VARCHAR2
645: , x_return_status out nocopy VARCHAR2
646: , x_msg_count out nocopy NUMBER
647: , x_msg_data out nocopy VARCHAR2
648: , p5_a0 JTF_NUMBER_TABLE
649: , p5_a1 JTF_NUMBER_TABLE
650: , p5_a2 JTF_NUMBER_TABLE
651: , p5_a3 JTF_VARCHAR2_TABLE_100
652: , p5_a4 JTF_VARCHAR2_TABLE_200
645: , x_return_status out nocopy VARCHAR2
646: , x_msg_count out nocopy NUMBER
647: , x_msg_data out nocopy VARCHAR2
648: , p5_a0 JTF_NUMBER_TABLE
649: , p5_a1 JTF_NUMBER_TABLE
650: , p5_a2 JTF_NUMBER_TABLE
651: , p5_a3 JTF_VARCHAR2_TABLE_100
652: , p5_a4 JTF_VARCHAR2_TABLE_200
653: , p5_a5 JTF_VARCHAR2_TABLE_2000
646: , x_msg_count out nocopy NUMBER
647: , x_msg_data out nocopy VARCHAR2
648: , p5_a0 JTF_NUMBER_TABLE
649: , p5_a1 JTF_NUMBER_TABLE
650: , p5_a2 JTF_NUMBER_TABLE
651: , p5_a3 JTF_VARCHAR2_TABLE_100
652: , p5_a4 JTF_VARCHAR2_TABLE_200
653: , p5_a5 JTF_VARCHAR2_TABLE_2000
654: , p5_a6 JTF_NUMBER_TABLE
650: , p5_a2 JTF_NUMBER_TABLE
651: , p5_a3 JTF_VARCHAR2_TABLE_100
652: , p5_a4 JTF_VARCHAR2_TABLE_200
653: , p5_a5 JTF_VARCHAR2_TABLE_2000
654: , p5_a6 JTF_NUMBER_TABLE
655: , p5_a7 JTF_VARCHAR2_TABLE_2000
656: , p5_a8 JTF_DATE_TABLE
657: , p5_a9 JTF_VARCHAR2_TABLE_100
658: , p5_a10 JTF_VARCHAR2_TABLE_500
669: , p5_a21 JTF_VARCHAR2_TABLE_500
670: , p5_a22 JTF_VARCHAR2_TABLE_500
671: , p5_a23 JTF_VARCHAR2_TABLE_500
672: , p5_a24 JTF_VARCHAR2_TABLE_500
673: , p5_a25 JTF_NUMBER_TABLE
674: , p5_a26 JTF_DATE_TABLE
675: , p5_a27 JTF_NUMBER_TABLE
676: , p5_a28 JTF_DATE_TABLE
677: , p5_a29 JTF_NUMBER_TABLE
671: , p5_a23 JTF_VARCHAR2_TABLE_500
672: , p5_a24 JTF_VARCHAR2_TABLE_500
673: , p5_a25 JTF_NUMBER_TABLE
674: , p5_a26 JTF_DATE_TABLE
675: , p5_a27 JTF_NUMBER_TABLE
676: , p5_a28 JTF_DATE_TABLE
677: , p5_a29 JTF_NUMBER_TABLE
678: , p5_a30 JTF_DATE_TABLE
679: , p5_a31 JTF_VARCHAR2_TABLE_300
673: , p5_a25 JTF_NUMBER_TABLE
674: , p5_a26 JTF_DATE_TABLE
675: , p5_a27 JTF_NUMBER_TABLE
676: , p5_a28 JTF_DATE_TABLE
677: , p5_a29 JTF_NUMBER_TABLE
678: , p5_a30 JTF_DATE_TABLE
679: , p5_a31 JTF_VARCHAR2_TABLE_300
680: , p5_a32 JTF_VARCHAR2_TABLE_300
681: );