1: package okl_am_parties_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLEAMPS.pls 115.10 2002/12/13 19:30:32 gkadarka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_am_parties_pvt.q_party_uv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
1: package okl_am_parties_pvt_w AUTHID CURRENT_USER as
2: /* $Header: OKLEAMPS.pls 115.10 2002/12/13 19:30:32 gkadarka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_am_parties_pvt.q_party_uv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
2: /* $Header: OKLEAMPS.pls 115.10 2002/12/13 19:30:32 gkadarka noship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy okl_am_parties_pvt.q_party_uv_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
7: , a4 JTF_VARCHAR2_TABLE_100
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
9: , a6 JTF_DATE_TABLE
10: , a7 JTF_DATE_TABLE
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_NUMBER_TABLE
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_DATE_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_DATE_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_NUMBER_TABLE
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_200
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_400
28: , a25 JTF_VARCHAR2_TABLE_2000
29: , a26 JTF_VARCHAR2_TABLE_2000
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_VARCHAR2_TABLE_2000
29: , a26 JTF_VARCHAR2_TABLE_2000
30: , a27 JTF_NUMBER_TABLE
31: , a28 JTF_DATE_TABLE
32: , a29 JTF_NUMBER_TABLE
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_2000
36: , a33 JTF_VARCHAR2_TABLE_2000
33: , a30 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_VARCHAR2_TABLE_100
35: , a32 JTF_VARCHAR2_TABLE_2000
36: , a33 JTF_VARCHAR2_TABLE_2000
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: );
40: procedure rosetta_table_copy_out_p2(t okl_am_parties_pvt.q_party_uv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
36: , a33 JTF_VARCHAR2_TABLE_2000
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: );
40: procedure rosetta_table_copy_out_p2(t okl_am_parties_pvt.q_party_uv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_VARCHAR2_TABLE_100
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_TABLE
39: );
40: procedure rosetta_table_copy_out_p2(t okl_am_parties_pvt.q_party_uv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_VARCHAR2_TABLE_100
45: , a5 out nocopy JTF_VARCHAR2_TABLE_100
39: );
40: procedure rosetta_table_copy_out_p2(t okl_am_parties_pvt.q_party_uv_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
41: , a1 out nocopy JTF_NUMBER_TABLE
42: , a2 out nocopy JTF_VARCHAR2_TABLE_100
43: , a3 out nocopy JTF_NUMBER_TABLE
44: , a4 out nocopy JTF_VARCHAR2_TABLE_100
45: , a5 out nocopy JTF_VARCHAR2_TABLE_100
46: , a6 out nocopy JTF_DATE_TABLE
47: , a7 out nocopy JTF_DATE_TABLE
44: , a4 out nocopy JTF_VARCHAR2_TABLE_100
45: , a5 out nocopy JTF_VARCHAR2_TABLE_100
46: , a6 out nocopy JTF_DATE_TABLE
47: , a7 out nocopy JTF_DATE_TABLE
48: , a8 out nocopy JTF_NUMBER_TABLE
49: , a9 out nocopy JTF_DATE_TABLE
50: , a10 out nocopy JTF_NUMBER_TABLE
51: , a11 out nocopy JTF_DATE_TABLE
52: , a12 out nocopy JTF_NUMBER_TABLE
46: , a6 out nocopy JTF_DATE_TABLE
47: , a7 out nocopy JTF_DATE_TABLE
48: , a8 out nocopy JTF_NUMBER_TABLE
49: , a9 out nocopy JTF_DATE_TABLE
50: , a10 out nocopy JTF_NUMBER_TABLE
51: , a11 out nocopy JTF_DATE_TABLE
52: , a12 out nocopy JTF_NUMBER_TABLE
53: , a13 out nocopy JTF_NUMBER_TABLE
54: , a14 out nocopy JTF_VARCHAR2_TABLE_100
48: , a8 out nocopy JTF_NUMBER_TABLE
49: , a9 out nocopy JTF_DATE_TABLE
50: , a10 out nocopy JTF_NUMBER_TABLE
51: , a11 out nocopy JTF_DATE_TABLE
52: , a12 out nocopy JTF_NUMBER_TABLE
53: , a13 out nocopy JTF_NUMBER_TABLE
54: , a14 out nocopy JTF_VARCHAR2_TABLE_100
55: , a15 out nocopy JTF_VARCHAR2_TABLE_100
56: , a16 out nocopy JTF_VARCHAR2_TABLE_100
49: , a9 out nocopy JTF_DATE_TABLE
50: , a10 out nocopy JTF_NUMBER_TABLE
51: , a11 out nocopy JTF_DATE_TABLE
52: , a12 out nocopy JTF_NUMBER_TABLE
53: , a13 out nocopy JTF_NUMBER_TABLE
54: , a14 out nocopy JTF_VARCHAR2_TABLE_100
55: , a15 out nocopy JTF_VARCHAR2_TABLE_100
56: , a16 out nocopy JTF_VARCHAR2_TABLE_100
57: , a17 out nocopy JTF_VARCHAR2_TABLE_200
63: , a23 out nocopy JTF_VARCHAR2_TABLE_100
64: , a24 out nocopy JTF_VARCHAR2_TABLE_400
65: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
66: , a26 out nocopy JTF_VARCHAR2_TABLE_2000
67: , a27 out nocopy JTF_NUMBER_TABLE
68: , a28 out nocopy JTF_DATE_TABLE
69: , a29 out nocopy JTF_NUMBER_TABLE
70: , a30 out nocopy JTF_VARCHAR2_TABLE_100
71: , a31 out nocopy JTF_VARCHAR2_TABLE_100
65: , a25 out nocopy JTF_VARCHAR2_TABLE_2000
66: , a26 out nocopy JTF_VARCHAR2_TABLE_2000
67: , a27 out nocopy JTF_NUMBER_TABLE
68: , a28 out nocopy JTF_DATE_TABLE
69: , a29 out nocopy JTF_NUMBER_TABLE
70: , a30 out nocopy JTF_VARCHAR2_TABLE_100
71: , a31 out nocopy JTF_VARCHAR2_TABLE_100
72: , a32 out nocopy JTF_VARCHAR2_TABLE_2000
73: , a33 out nocopy JTF_VARCHAR2_TABLE_2000
70: , a30 out nocopy JTF_VARCHAR2_TABLE_100
71: , a31 out nocopy JTF_VARCHAR2_TABLE_100
72: , a32 out nocopy JTF_VARCHAR2_TABLE_2000
73: , a33 out nocopy JTF_VARCHAR2_TABLE_2000
74: , a34 out nocopy JTF_NUMBER_TABLE
75: , a35 out nocopy JTF_DATE_TABLE
76: );
77:
78: procedure rosetta_table_copy_in_p3(t out nocopy okl_am_parties_pvt.party_object_tbl_type, a0 JTF_VARCHAR2_TABLE_100
90: , a12 JTF_VARCHAR2_TABLE_200
91: , a13 JTF_VARCHAR2_TABLE_400
92: , a14 JTF_VARCHAR2_TABLE_2000
93: , a15 JTF_VARCHAR2_TABLE_2000
94: , a16 JTF_NUMBER_TABLE
95: , a17 JTF_NUMBER_TABLE
96: , a18 JTF_VARCHAR2_TABLE_100
97: , a19 JTF_VARCHAR2_TABLE_2000
98: );
91: , a13 JTF_VARCHAR2_TABLE_400
92: , a14 JTF_VARCHAR2_TABLE_2000
93: , a15 JTF_VARCHAR2_TABLE_2000
94: , a16 JTF_NUMBER_TABLE
95: , a17 JTF_NUMBER_TABLE
96: , a18 JTF_VARCHAR2_TABLE_100
97: , a19 JTF_VARCHAR2_TABLE_2000
98: );
99: procedure rosetta_table_copy_out_p3(t okl_am_parties_pvt.party_object_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
111: , a12 out nocopy JTF_VARCHAR2_TABLE_200
112: , a13 out nocopy JTF_VARCHAR2_TABLE_400
113: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
114: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
115: , a16 out nocopy JTF_NUMBER_TABLE
116: , a17 out nocopy JTF_NUMBER_TABLE
117: , a18 out nocopy JTF_VARCHAR2_TABLE_100
118: , a19 out nocopy JTF_VARCHAR2_TABLE_2000
119: );
112: , a13 out nocopy JTF_VARCHAR2_TABLE_400
113: , a14 out nocopy JTF_VARCHAR2_TABLE_2000
114: , a15 out nocopy JTF_VARCHAR2_TABLE_2000
115: , a16 out nocopy JTF_NUMBER_TABLE
116: , a17 out nocopy JTF_NUMBER_TABLE
117: , a18 out nocopy JTF_VARCHAR2_TABLE_100
118: , a19 out nocopy JTF_VARCHAR2_TABLE_2000
119: );
120:
122: , p_init_msg_list VARCHAR2
123: , x_msg_count out nocopy NUMBER
124: , x_msg_data out nocopy VARCHAR2
125: , x_return_status out nocopy VARCHAR2
126: , p6_a0 out nocopy JTF_NUMBER_TABLE
127: , p6_a1 out nocopy JTF_NUMBER_TABLE
128: , p6_a2 out nocopy JTF_NUMBER_TABLE
129: , p6_a3 out nocopy JTF_NUMBER_TABLE
130: , p6_a4 out nocopy JTF_DATE_TABLE
123: , x_msg_count out nocopy NUMBER
124: , x_msg_data out nocopy VARCHAR2
125: , x_return_status out nocopy VARCHAR2
126: , p6_a0 out nocopy JTF_NUMBER_TABLE
127: , p6_a1 out nocopy JTF_NUMBER_TABLE
128: , p6_a2 out nocopy JTF_NUMBER_TABLE
129: , p6_a3 out nocopy JTF_NUMBER_TABLE
130: , p6_a4 out nocopy JTF_DATE_TABLE
131: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
124: , x_msg_data out nocopy VARCHAR2
125: , x_return_status out nocopy VARCHAR2
126: , p6_a0 out nocopy JTF_NUMBER_TABLE
127: , p6_a1 out nocopy JTF_NUMBER_TABLE
128: , p6_a2 out nocopy JTF_NUMBER_TABLE
129: , p6_a3 out nocopy JTF_NUMBER_TABLE
130: , p6_a4 out nocopy JTF_DATE_TABLE
131: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a6 out nocopy JTF_NUMBER_TABLE
125: , x_return_status out nocopy VARCHAR2
126: , p6_a0 out nocopy JTF_NUMBER_TABLE
127: , p6_a1 out nocopy JTF_NUMBER_TABLE
128: , p6_a2 out nocopy JTF_NUMBER_TABLE
129: , p6_a3 out nocopy JTF_NUMBER_TABLE
130: , p6_a4 out nocopy JTF_DATE_TABLE
131: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a6 out nocopy JTF_NUMBER_TABLE
133: , p6_a7 out nocopy JTF_NUMBER_TABLE
128: , p6_a2 out nocopy JTF_NUMBER_TABLE
129: , p6_a3 out nocopy JTF_NUMBER_TABLE
130: , p6_a4 out nocopy JTF_DATE_TABLE
131: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a6 out nocopy JTF_NUMBER_TABLE
133: , p6_a7 out nocopy JTF_NUMBER_TABLE
134: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_600
135: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
129: , p6_a3 out nocopy JTF_NUMBER_TABLE
130: , p6_a4 out nocopy JTF_DATE_TABLE
131: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
132: , p6_a6 out nocopy JTF_NUMBER_TABLE
133: , p6_a7 out nocopy JTF_NUMBER_TABLE
134: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_600
135: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
136: , p6_a10 out nocopy JTF_VARCHAR2_TABLE_100
137: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
137: , p6_a11 out nocopy JTF_VARCHAR2_TABLE_200
138: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
139: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
140: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
141: , p6_a15 out nocopy JTF_NUMBER_TABLE
142: , p6_a16 out nocopy JTF_DATE_TABLE
143: , p6_a17 out nocopy JTF_NUMBER_TABLE
144: , p6_a18 out nocopy JTF_DATE_TABLE
145: , p6_a19 out nocopy JTF_NUMBER_TABLE
139: , p6_a13 out nocopy JTF_VARCHAR2_TABLE_100
140: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_200
141: , p6_a15 out nocopy JTF_NUMBER_TABLE
142: , p6_a16 out nocopy JTF_DATE_TABLE
143: , p6_a17 out nocopy JTF_NUMBER_TABLE
144: , p6_a18 out nocopy JTF_DATE_TABLE
145: , p6_a19 out nocopy JTF_NUMBER_TABLE
146: , p7_a0 out nocopy JTF_NUMBER_TABLE
147: , p7_a1 out nocopy JTF_NUMBER_TABLE
141: , p6_a15 out nocopy JTF_NUMBER_TABLE
142: , p6_a16 out nocopy JTF_DATE_TABLE
143: , p6_a17 out nocopy JTF_NUMBER_TABLE
144: , p6_a18 out nocopy JTF_DATE_TABLE
145: , p6_a19 out nocopy JTF_NUMBER_TABLE
146: , p7_a0 out nocopy JTF_NUMBER_TABLE
147: , p7_a1 out nocopy JTF_NUMBER_TABLE
148: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
149: , p7_a3 out nocopy JTF_NUMBER_TABLE
142: , p6_a16 out nocopy JTF_DATE_TABLE
143: , p6_a17 out nocopy JTF_NUMBER_TABLE
144: , p6_a18 out nocopy JTF_DATE_TABLE
145: , p6_a19 out nocopy JTF_NUMBER_TABLE
146: , p7_a0 out nocopy JTF_NUMBER_TABLE
147: , p7_a1 out nocopy JTF_NUMBER_TABLE
148: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
149: , p7_a3 out nocopy JTF_NUMBER_TABLE
150: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
143: , p6_a17 out nocopy JTF_NUMBER_TABLE
144: , p6_a18 out nocopy JTF_DATE_TABLE
145: , p6_a19 out nocopy JTF_NUMBER_TABLE
146: , p7_a0 out nocopy JTF_NUMBER_TABLE
147: , p7_a1 out nocopy JTF_NUMBER_TABLE
148: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
149: , p7_a3 out nocopy JTF_NUMBER_TABLE
150: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
151: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
145: , p6_a19 out nocopy JTF_NUMBER_TABLE
146: , p7_a0 out nocopy JTF_NUMBER_TABLE
147: , p7_a1 out nocopy JTF_NUMBER_TABLE
148: , p7_a2 out nocopy JTF_VARCHAR2_TABLE_100
149: , p7_a3 out nocopy JTF_NUMBER_TABLE
150: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
151: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
152: , p7_a6 out nocopy JTF_DATE_TABLE
153: , p7_a7 out nocopy JTF_DATE_TABLE
150: , p7_a4 out nocopy JTF_VARCHAR2_TABLE_100
151: , p7_a5 out nocopy JTF_VARCHAR2_TABLE_100
152: , p7_a6 out nocopy JTF_DATE_TABLE
153: , p7_a7 out nocopy JTF_DATE_TABLE
154: , p7_a8 out nocopy JTF_NUMBER_TABLE
155: , p7_a9 out nocopy JTF_DATE_TABLE
156: , p7_a10 out nocopy JTF_NUMBER_TABLE
157: , p7_a11 out nocopy JTF_DATE_TABLE
158: , p7_a12 out nocopy JTF_NUMBER_TABLE
152: , p7_a6 out nocopy JTF_DATE_TABLE
153: , p7_a7 out nocopy JTF_DATE_TABLE
154: , p7_a8 out nocopy JTF_NUMBER_TABLE
155: , p7_a9 out nocopy JTF_DATE_TABLE
156: , p7_a10 out nocopy JTF_NUMBER_TABLE
157: , p7_a11 out nocopy JTF_DATE_TABLE
158: , p7_a12 out nocopy JTF_NUMBER_TABLE
159: , p7_a13 out nocopy JTF_NUMBER_TABLE
160: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
154: , p7_a8 out nocopy JTF_NUMBER_TABLE
155: , p7_a9 out nocopy JTF_DATE_TABLE
156: , p7_a10 out nocopy JTF_NUMBER_TABLE
157: , p7_a11 out nocopy JTF_DATE_TABLE
158: , p7_a12 out nocopy JTF_NUMBER_TABLE
159: , p7_a13 out nocopy JTF_NUMBER_TABLE
160: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
161: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
162: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
155: , p7_a9 out nocopy JTF_DATE_TABLE
156: , p7_a10 out nocopy JTF_NUMBER_TABLE
157: , p7_a11 out nocopy JTF_DATE_TABLE
158: , p7_a12 out nocopy JTF_NUMBER_TABLE
159: , p7_a13 out nocopy JTF_NUMBER_TABLE
160: , p7_a14 out nocopy JTF_VARCHAR2_TABLE_100
161: , p7_a15 out nocopy JTF_VARCHAR2_TABLE_100
162: , p7_a16 out nocopy JTF_VARCHAR2_TABLE_100
163: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_200
169: , p7_a23 out nocopy JTF_VARCHAR2_TABLE_100
170: , p7_a24 out nocopy JTF_VARCHAR2_TABLE_400
171: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
172: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_2000
173: , p7_a27 out nocopy JTF_NUMBER_TABLE
174: , p7_a28 out nocopy JTF_DATE_TABLE
175: , p7_a29 out nocopy JTF_NUMBER_TABLE
176: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
177: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
171: , p7_a25 out nocopy JTF_VARCHAR2_TABLE_2000
172: , p7_a26 out nocopy JTF_VARCHAR2_TABLE_2000
173: , p7_a27 out nocopy JTF_NUMBER_TABLE
174: , p7_a28 out nocopy JTF_DATE_TABLE
175: , p7_a29 out nocopy JTF_NUMBER_TABLE
176: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
177: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
178: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_2000
179: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_2000
176: , p7_a30 out nocopy JTF_VARCHAR2_TABLE_100
177: , p7_a31 out nocopy JTF_VARCHAR2_TABLE_100
178: , p7_a32 out nocopy JTF_VARCHAR2_TABLE_2000
179: , p7_a33 out nocopy JTF_VARCHAR2_TABLE_2000
180: , p7_a34 out nocopy JTF_NUMBER_TABLE
181: , p7_a35 out nocopy JTF_DATE_TABLE
182: , x_record_count out nocopy NUMBER
183: , p5_a0 NUMBER := 0-1962.0724
184: , p5_a1 NUMBER := 0-1962.0724
261: , p5_a78 NUMBER := 0-1962.0724
262: , p5_a79 DATE := fnd_api.g_miss_date
263: );
264: procedure create_partner_as_recipient(p_validate_only number
265: , p2_a0 out nocopy JTF_NUMBER_TABLE
266: , p2_a1 out nocopy JTF_NUMBER_TABLE
267: , p2_a2 out nocopy JTF_NUMBER_TABLE
268: , p2_a3 out nocopy JTF_NUMBER_TABLE
269: , p2_a4 out nocopy JTF_DATE_TABLE
262: , p5_a79 DATE := fnd_api.g_miss_date
263: );
264: procedure create_partner_as_recipient(p_validate_only number
265: , p2_a0 out nocopy JTF_NUMBER_TABLE
266: , p2_a1 out nocopy JTF_NUMBER_TABLE
267: , p2_a2 out nocopy JTF_NUMBER_TABLE
268: , p2_a3 out nocopy JTF_NUMBER_TABLE
269: , p2_a4 out nocopy JTF_DATE_TABLE
270: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
263: );
264: procedure create_partner_as_recipient(p_validate_only number
265: , p2_a0 out nocopy JTF_NUMBER_TABLE
266: , p2_a1 out nocopy JTF_NUMBER_TABLE
267: , p2_a2 out nocopy JTF_NUMBER_TABLE
268: , p2_a3 out nocopy JTF_NUMBER_TABLE
269: , p2_a4 out nocopy JTF_DATE_TABLE
270: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
271: , p2_a6 out nocopy JTF_NUMBER_TABLE
264: procedure create_partner_as_recipient(p_validate_only number
265: , p2_a0 out nocopy JTF_NUMBER_TABLE
266: , p2_a1 out nocopy JTF_NUMBER_TABLE
267: , p2_a2 out nocopy JTF_NUMBER_TABLE
268: , p2_a3 out nocopy JTF_NUMBER_TABLE
269: , p2_a4 out nocopy JTF_DATE_TABLE
270: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
271: , p2_a6 out nocopy JTF_NUMBER_TABLE
272: , p2_a7 out nocopy JTF_NUMBER_TABLE
267: , p2_a2 out nocopy JTF_NUMBER_TABLE
268: , p2_a3 out nocopy JTF_NUMBER_TABLE
269: , p2_a4 out nocopy JTF_DATE_TABLE
270: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
271: , p2_a6 out nocopy JTF_NUMBER_TABLE
272: , p2_a7 out nocopy JTF_NUMBER_TABLE
273: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_600
274: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_100
275: , p2_a10 out nocopy JTF_VARCHAR2_TABLE_100
268: , p2_a3 out nocopy JTF_NUMBER_TABLE
269: , p2_a4 out nocopy JTF_DATE_TABLE
270: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
271: , p2_a6 out nocopy JTF_NUMBER_TABLE
272: , p2_a7 out nocopy JTF_NUMBER_TABLE
273: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_600
274: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_100
275: , p2_a10 out nocopy JTF_VARCHAR2_TABLE_100
276: , p2_a11 out nocopy JTF_VARCHAR2_TABLE_200
276: , p2_a11 out nocopy JTF_VARCHAR2_TABLE_200
277: , p2_a12 out nocopy JTF_VARCHAR2_TABLE_100
278: , p2_a13 out nocopy JTF_VARCHAR2_TABLE_100
279: , p2_a14 out nocopy JTF_VARCHAR2_TABLE_200
280: , p2_a15 out nocopy JTF_NUMBER_TABLE
281: , p2_a16 out nocopy JTF_DATE_TABLE
282: , p2_a17 out nocopy JTF_NUMBER_TABLE
283: , p2_a18 out nocopy JTF_DATE_TABLE
284: , p2_a19 out nocopy JTF_NUMBER_TABLE
278: , p2_a13 out nocopy JTF_VARCHAR2_TABLE_100
279: , p2_a14 out nocopy JTF_VARCHAR2_TABLE_200
280: , p2_a15 out nocopy JTF_NUMBER_TABLE
281: , p2_a16 out nocopy JTF_DATE_TABLE
282: , p2_a17 out nocopy JTF_NUMBER_TABLE
283: , p2_a18 out nocopy JTF_DATE_TABLE
284: , p2_a19 out nocopy JTF_NUMBER_TABLE
285: , x_return_status out nocopy VARCHAR2
286: , p0_a0 NUMBER := 0-1962.0724
280: , p2_a15 out nocopy JTF_NUMBER_TABLE
281: , p2_a16 out nocopy JTF_DATE_TABLE
282: , p2_a17 out nocopy JTF_NUMBER_TABLE
283: , p2_a18 out nocopy JTF_DATE_TABLE
284: , p2_a19 out nocopy JTF_NUMBER_TABLE
285: , x_return_status out nocopy VARCHAR2
286: , p0_a0 NUMBER := 0-1962.0724
287: , p0_a1 NUMBER := 0-1962.0724
288: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
363: , p0_a77 VARCHAR2 := fnd_api.g_miss_char
364: , p0_a78 NUMBER := 0-1962.0724
365: , p0_a79 DATE := fnd_api.g_miss_date
366: );
367: procedure create_quote_parties(p1_a0 JTF_NUMBER_TABLE
368: , p1_a1 JTF_NUMBER_TABLE
369: , p1_a2 JTF_NUMBER_TABLE
370: , p1_a3 JTF_NUMBER_TABLE
371: , p1_a4 JTF_DATE_TABLE
364: , p0_a78 NUMBER := 0-1962.0724
365: , p0_a79 DATE := fnd_api.g_miss_date
366: );
367: procedure create_quote_parties(p1_a0 JTF_NUMBER_TABLE
368: , p1_a1 JTF_NUMBER_TABLE
369: , p1_a2 JTF_NUMBER_TABLE
370: , p1_a3 JTF_NUMBER_TABLE
371: , p1_a4 JTF_DATE_TABLE
372: , p1_a5 JTF_VARCHAR2_TABLE_100
365: , p0_a79 DATE := fnd_api.g_miss_date
366: );
367: procedure create_quote_parties(p1_a0 JTF_NUMBER_TABLE
368: , p1_a1 JTF_NUMBER_TABLE
369: , p1_a2 JTF_NUMBER_TABLE
370: , p1_a3 JTF_NUMBER_TABLE
371: , p1_a4 JTF_DATE_TABLE
372: , p1_a5 JTF_VARCHAR2_TABLE_100
373: , p1_a6 JTF_NUMBER_TABLE
366: );
367: procedure create_quote_parties(p1_a0 JTF_NUMBER_TABLE
368: , p1_a1 JTF_NUMBER_TABLE
369: , p1_a2 JTF_NUMBER_TABLE
370: , p1_a3 JTF_NUMBER_TABLE
371: , p1_a4 JTF_DATE_TABLE
372: , p1_a5 JTF_VARCHAR2_TABLE_100
373: , p1_a6 JTF_NUMBER_TABLE
374: , p1_a7 JTF_NUMBER_TABLE
369: , p1_a2 JTF_NUMBER_TABLE
370: , p1_a3 JTF_NUMBER_TABLE
371: , p1_a4 JTF_DATE_TABLE
372: , p1_a5 JTF_VARCHAR2_TABLE_100
373: , p1_a6 JTF_NUMBER_TABLE
374: , p1_a7 JTF_NUMBER_TABLE
375: , p1_a8 JTF_VARCHAR2_TABLE_600
376: , p1_a9 JTF_VARCHAR2_TABLE_100
377: , p1_a10 JTF_VARCHAR2_TABLE_100
370: , p1_a3 JTF_NUMBER_TABLE
371: , p1_a4 JTF_DATE_TABLE
372: , p1_a5 JTF_VARCHAR2_TABLE_100
373: , p1_a6 JTF_NUMBER_TABLE
374: , p1_a7 JTF_NUMBER_TABLE
375: , p1_a8 JTF_VARCHAR2_TABLE_600
376: , p1_a9 JTF_VARCHAR2_TABLE_100
377: , p1_a10 JTF_VARCHAR2_TABLE_100
378: , p1_a11 JTF_VARCHAR2_TABLE_200
378: , p1_a11 JTF_VARCHAR2_TABLE_200
379: , p1_a12 JTF_VARCHAR2_TABLE_100
380: , p1_a13 JTF_VARCHAR2_TABLE_100
381: , p1_a14 JTF_VARCHAR2_TABLE_200
382: , p1_a15 JTF_NUMBER_TABLE
383: , p1_a16 JTF_DATE_TABLE
384: , p1_a17 JTF_NUMBER_TABLE
385: , p1_a18 JTF_DATE_TABLE
386: , p1_a19 JTF_NUMBER_TABLE
380: , p1_a13 JTF_VARCHAR2_TABLE_100
381: , p1_a14 JTF_VARCHAR2_TABLE_200
382: , p1_a15 JTF_NUMBER_TABLE
383: , p1_a16 JTF_DATE_TABLE
384: , p1_a17 JTF_NUMBER_TABLE
385: , p1_a18 JTF_DATE_TABLE
386: , p1_a19 JTF_NUMBER_TABLE
387: , p_validate_only number
388: , p3_a0 out nocopy JTF_NUMBER_TABLE
382: , p1_a15 JTF_NUMBER_TABLE
383: , p1_a16 JTF_DATE_TABLE
384: , p1_a17 JTF_NUMBER_TABLE
385: , p1_a18 JTF_DATE_TABLE
386: , p1_a19 JTF_NUMBER_TABLE
387: , p_validate_only number
388: , p3_a0 out nocopy JTF_NUMBER_TABLE
389: , p3_a1 out nocopy JTF_NUMBER_TABLE
390: , p3_a2 out nocopy JTF_NUMBER_TABLE
384: , p1_a17 JTF_NUMBER_TABLE
385: , p1_a18 JTF_DATE_TABLE
386: , p1_a19 JTF_NUMBER_TABLE
387: , p_validate_only number
388: , p3_a0 out nocopy JTF_NUMBER_TABLE
389: , p3_a1 out nocopy JTF_NUMBER_TABLE
390: , p3_a2 out nocopy JTF_NUMBER_TABLE
391: , p3_a3 out nocopy JTF_NUMBER_TABLE
392: , p3_a4 out nocopy JTF_DATE_TABLE
385: , p1_a18 JTF_DATE_TABLE
386: , p1_a19 JTF_NUMBER_TABLE
387: , p_validate_only number
388: , p3_a0 out nocopy JTF_NUMBER_TABLE
389: , p3_a1 out nocopy JTF_NUMBER_TABLE
390: , p3_a2 out nocopy JTF_NUMBER_TABLE
391: , p3_a3 out nocopy JTF_NUMBER_TABLE
392: , p3_a4 out nocopy JTF_DATE_TABLE
393: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
386: , p1_a19 JTF_NUMBER_TABLE
387: , p_validate_only number
388: , p3_a0 out nocopy JTF_NUMBER_TABLE
389: , p3_a1 out nocopy JTF_NUMBER_TABLE
390: , p3_a2 out nocopy JTF_NUMBER_TABLE
391: , p3_a3 out nocopy JTF_NUMBER_TABLE
392: , p3_a4 out nocopy JTF_DATE_TABLE
393: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
394: , p3_a6 out nocopy JTF_NUMBER_TABLE
387: , p_validate_only number
388: , p3_a0 out nocopy JTF_NUMBER_TABLE
389: , p3_a1 out nocopy JTF_NUMBER_TABLE
390: , p3_a2 out nocopy JTF_NUMBER_TABLE
391: , p3_a3 out nocopy JTF_NUMBER_TABLE
392: , p3_a4 out nocopy JTF_DATE_TABLE
393: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
394: , p3_a6 out nocopy JTF_NUMBER_TABLE
395: , p3_a7 out nocopy JTF_NUMBER_TABLE
390: , p3_a2 out nocopy JTF_NUMBER_TABLE
391: , p3_a3 out nocopy JTF_NUMBER_TABLE
392: , p3_a4 out nocopy JTF_DATE_TABLE
393: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
394: , p3_a6 out nocopy JTF_NUMBER_TABLE
395: , p3_a7 out nocopy JTF_NUMBER_TABLE
396: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_600
397: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
398: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
391: , p3_a3 out nocopy JTF_NUMBER_TABLE
392: , p3_a4 out nocopy JTF_DATE_TABLE
393: , p3_a5 out nocopy JTF_VARCHAR2_TABLE_100
394: , p3_a6 out nocopy JTF_NUMBER_TABLE
395: , p3_a7 out nocopy JTF_NUMBER_TABLE
396: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_600
397: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
398: , p3_a10 out nocopy JTF_VARCHAR2_TABLE_100
399: , p3_a11 out nocopy JTF_VARCHAR2_TABLE_200
399: , p3_a11 out nocopy JTF_VARCHAR2_TABLE_200
400: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
401: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_100
402: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_200
403: , p3_a15 out nocopy JTF_NUMBER_TABLE
404: , p3_a16 out nocopy JTF_DATE_TABLE
405: , p3_a17 out nocopy JTF_NUMBER_TABLE
406: , p3_a18 out nocopy JTF_DATE_TABLE
407: , p3_a19 out nocopy JTF_NUMBER_TABLE
401: , p3_a13 out nocopy JTF_VARCHAR2_TABLE_100
402: , p3_a14 out nocopy JTF_VARCHAR2_TABLE_200
403: , p3_a15 out nocopy JTF_NUMBER_TABLE
404: , p3_a16 out nocopy JTF_DATE_TABLE
405: , p3_a17 out nocopy JTF_NUMBER_TABLE
406: , p3_a18 out nocopy JTF_DATE_TABLE
407: , p3_a19 out nocopy JTF_NUMBER_TABLE
408: , x_return_status out nocopy VARCHAR2
409: , p0_a0 NUMBER := 0-1962.0724
403: , p3_a15 out nocopy JTF_NUMBER_TABLE
404: , p3_a16 out nocopy JTF_DATE_TABLE
405: , p3_a17 out nocopy JTF_NUMBER_TABLE
406: , p3_a18 out nocopy JTF_DATE_TABLE
407: , p3_a19 out nocopy JTF_NUMBER_TABLE
408: , x_return_status out nocopy VARCHAR2
409: , p0_a0 NUMBER := 0-1962.0724
410: , p0_a1 NUMBER := 0-1962.0724
411: , p0_a2 VARCHAR2 := fnd_api.g_miss_char
504: , p2_a12 out nocopy JTF_VARCHAR2_TABLE_200
505: , p2_a13 out nocopy JTF_VARCHAR2_TABLE_400
506: , p2_a14 out nocopy JTF_VARCHAR2_TABLE_2000
507: , p2_a15 out nocopy JTF_VARCHAR2_TABLE_2000
508: , p2_a16 out nocopy JTF_NUMBER_TABLE
509: , p2_a17 out nocopy JTF_NUMBER_TABLE
510: , p2_a18 out nocopy JTF_VARCHAR2_TABLE_100
511: , p2_a19 out nocopy JTF_VARCHAR2_TABLE_2000
512: , x_return_status out nocopy VARCHAR2
505: , p2_a13 out nocopy JTF_VARCHAR2_TABLE_400
506: , p2_a14 out nocopy JTF_VARCHAR2_TABLE_2000
507: , p2_a15 out nocopy JTF_VARCHAR2_TABLE_2000
508: , p2_a16 out nocopy JTF_NUMBER_TABLE
509: , p2_a17 out nocopy JTF_NUMBER_TABLE
510: , p2_a18 out nocopy JTF_VARCHAR2_TABLE_100
511: , p2_a19 out nocopy JTF_VARCHAR2_TABLE_2000
512: , x_return_status out nocopy VARCHAR2
513: );
515: , p_init_msg_list VARCHAR2
516: , x_msg_count out nocopy NUMBER
517: , x_msg_data out nocopy VARCHAR2
518: , x_return_status out nocopy VARCHAR2
519: , p6_a0 out nocopy JTF_NUMBER_TABLE
520: , p6_a1 out nocopy JTF_NUMBER_TABLE
521: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
522: , p6_a3 out nocopy JTF_NUMBER_TABLE
523: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
516: , x_msg_count out nocopy NUMBER
517: , x_msg_data out nocopy VARCHAR2
518: , x_return_status out nocopy VARCHAR2
519: , p6_a0 out nocopy JTF_NUMBER_TABLE
520: , p6_a1 out nocopy JTF_NUMBER_TABLE
521: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
522: , p6_a3 out nocopy JTF_NUMBER_TABLE
523: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
524: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
518: , x_return_status out nocopy VARCHAR2
519: , p6_a0 out nocopy JTF_NUMBER_TABLE
520: , p6_a1 out nocopy JTF_NUMBER_TABLE
521: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
522: , p6_a3 out nocopy JTF_NUMBER_TABLE
523: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
524: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
525: , p6_a6 out nocopy JTF_DATE_TABLE
526: , p6_a7 out nocopy JTF_DATE_TABLE
523: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
524: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
525: , p6_a6 out nocopy JTF_DATE_TABLE
526: , p6_a7 out nocopy JTF_DATE_TABLE
527: , p6_a8 out nocopy JTF_NUMBER_TABLE
528: , p6_a9 out nocopy JTF_DATE_TABLE
529: , p6_a10 out nocopy JTF_NUMBER_TABLE
530: , p6_a11 out nocopy JTF_DATE_TABLE
531: , p6_a12 out nocopy JTF_NUMBER_TABLE
525: , p6_a6 out nocopy JTF_DATE_TABLE
526: , p6_a7 out nocopy JTF_DATE_TABLE
527: , p6_a8 out nocopy JTF_NUMBER_TABLE
528: , p6_a9 out nocopy JTF_DATE_TABLE
529: , p6_a10 out nocopy JTF_NUMBER_TABLE
530: , p6_a11 out nocopy JTF_DATE_TABLE
531: , p6_a12 out nocopy JTF_NUMBER_TABLE
532: , p6_a13 out nocopy JTF_NUMBER_TABLE
533: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
527: , p6_a8 out nocopy JTF_NUMBER_TABLE
528: , p6_a9 out nocopy JTF_DATE_TABLE
529: , p6_a10 out nocopy JTF_NUMBER_TABLE
530: , p6_a11 out nocopy JTF_DATE_TABLE
531: , p6_a12 out nocopy JTF_NUMBER_TABLE
532: , p6_a13 out nocopy JTF_NUMBER_TABLE
533: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
534: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
535: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
528: , p6_a9 out nocopy JTF_DATE_TABLE
529: , p6_a10 out nocopy JTF_NUMBER_TABLE
530: , p6_a11 out nocopy JTF_DATE_TABLE
531: , p6_a12 out nocopy JTF_NUMBER_TABLE
532: , p6_a13 out nocopy JTF_NUMBER_TABLE
533: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
534: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
535: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
536: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
542: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
543: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
544: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
545: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
546: , p6_a27 out nocopy JTF_NUMBER_TABLE
547: , p6_a28 out nocopy JTF_DATE_TABLE
548: , p6_a29 out nocopy JTF_NUMBER_TABLE
549: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
550: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
544: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
545: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
546: , p6_a27 out nocopy JTF_NUMBER_TABLE
547: , p6_a28 out nocopy JTF_DATE_TABLE
548: , p6_a29 out nocopy JTF_NUMBER_TABLE
549: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
550: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
551: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
552: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000
549: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
550: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
551: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
552: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000
553: , p6_a34 out nocopy JTF_NUMBER_TABLE
554: , p6_a35 out nocopy JTF_DATE_TABLE
555: , x_record_count out nocopy NUMBER
556: , p5_a0 NUMBER := 0-1962.0724
557: , p5_a1 NUMBER := 0-1962.0724
594: , p_init_msg_list VARCHAR2
595: , x_msg_count out nocopy NUMBER
596: , x_msg_data out nocopy VARCHAR2
597: , x_return_status out nocopy VARCHAR2
598: , p6_a0 out nocopy JTF_NUMBER_TABLE
599: , p6_a1 out nocopy JTF_NUMBER_TABLE
600: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
601: , p6_a3 out nocopy JTF_NUMBER_TABLE
602: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
595: , x_msg_count out nocopy NUMBER
596: , x_msg_data out nocopy VARCHAR2
597: , x_return_status out nocopy VARCHAR2
598: , p6_a0 out nocopy JTF_NUMBER_TABLE
599: , p6_a1 out nocopy JTF_NUMBER_TABLE
600: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
601: , p6_a3 out nocopy JTF_NUMBER_TABLE
602: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
597: , x_return_status out nocopy VARCHAR2
598: , p6_a0 out nocopy JTF_NUMBER_TABLE
599: , p6_a1 out nocopy JTF_NUMBER_TABLE
600: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
601: , p6_a3 out nocopy JTF_NUMBER_TABLE
602: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
604: , p6_a6 out nocopy JTF_DATE_TABLE
605: , p6_a7 out nocopy JTF_DATE_TABLE
602: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
603: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
604: , p6_a6 out nocopy JTF_DATE_TABLE
605: , p6_a7 out nocopy JTF_DATE_TABLE
606: , p6_a8 out nocopy JTF_NUMBER_TABLE
607: , p6_a9 out nocopy JTF_DATE_TABLE
608: , p6_a10 out nocopy JTF_NUMBER_TABLE
609: , p6_a11 out nocopy JTF_DATE_TABLE
610: , p6_a12 out nocopy JTF_NUMBER_TABLE
604: , p6_a6 out nocopy JTF_DATE_TABLE
605: , p6_a7 out nocopy JTF_DATE_TABLE
606: , p6_a8 out nocopy JTF_NUMBER_TABLE
607: , p6_a9 out nocopy JTF_DATE_TABLE
608: , p6_a10 out nocopy JTF_NUMBER_TABLE
609: , p6_a11 out nocopy JTF_DATE_TABLE
610: , p6_a12 out nocopy JTF_NUMBER_TABLE
611: , p6_a13 out nocopy JTF_NUMBER_TABLE
612: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
606: , p6_a8 out nocopy JTF_NUMBER_TABLE
607: , p6_a9 out nocopy JTF_DATE_TABLE
608: , p6_a10 out nocopy JTF_NUMBER_TABLE
609: , p6_a11 out nocopy JTF_DATE_TABLE
610: , p6_a12 out nocopy JTF_NUMBER_TABLE
611: , p6_a13 out nocopy JTF_NUMBER_TABLE
612: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
613: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
614: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
607: , p6_a9 out nocopy JTF_DATE_TABLE
608: , p6_a10 out nocopy JTF_NUMBER_TABLE
609: , p6_a11 out nocopy JTF_DATE_TABLE
610: , p6_a12 out nocopy JTF_NUMBER_TABLE
611: , p6_a13 out nocopy JTF_NUMBER_TABLE
612: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
613: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
614: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
615: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
621: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
622: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
623: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
624: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
625: , p6_a27 out nocopy JTF_NUMBER_TABLE
626: , p6_a28 out nocopy JTF_DATE_TABLE
627: , p6_a29 out nocopy JTF_NUMBER_TABLE
628: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
629: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
623: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
624: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
625: , p6_a27 out nocopy JTF_NUMBER_TABLE
626: , p6_a28 out nocopy JTF_DATE_TABLE
627: , p6_a29 out nocopy JTF_NUMBER_TABLE
628: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
629: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
630: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
631: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000
628: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
629: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
630: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
631: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000
632: , p6_a34 out nocopy JTF_NUMBER_TABLE
633: , p6_a35 out nocopy JTF_DATE_TABLE
634: , x_record_count out nocopy NUMBER
635: , p5_a0 NUMBER := 0-1962.0724
636: , p5_a1 NUMBER := 0-1962.0724
673: , p_init_msg_list VARCHAR2
674: , x_msg_count out nocopy NUMBER
675: , x_msg_data out nocopy VARCHAR2
676: , x_return_status out nocopy VARCHAR2
677: , p6_a0 out nocopy JTF_NUMBER_TABLE
678: , p6_a1 out nocopy JTF_NUMBER_TABLE
679: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
680: , p6_a3 out nocopy JTF_NUMBER_TABLE
681: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
674: , x_msg_count out nocopy NUMBER
675: , x_msg_data out nocopy VARCHAR2
676: , x_return_status out nocopy VARCHAR2
677: , p6_a0 out nocopy JTF_NUMBER_TABLE
678: , p6_a1 out nocopy JTF_NUMBER_TABLE
679: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
680: , p6_a3 out nocopy JTF_NUMBER_TABLE
681: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
682: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
676: , x_return_status out nocopy VARCHAR2
677: , p6_a0 out nocopy JTF_NUMBER_TABLE
678: , p6_a1 out nocopy JTF_NUMBER_TABLE
679: , p6_a2 out nocopy JTF_VARCHAR2_TABLE_100
680: , p6_a3 out nocopy JTF_NUMBER_TABLE
681: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
682: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
683: , p6_a6 out nocopy JTF_DATE_TABLE
684: , p6_a7 out nocopy JTF_DATE_TABLE
681: , p6_a4 out nocopy JTF_VARCHAR2_TABLE_100
682: , p6_a5 out nocopy JTF_VARCHAR2_TABLE_100
683: , p6_a6 out nocopy JTF_DATE_TABLE
684: , p6_a7 out nocopy JTF_DATE_TABLE
685: , p6_a8 out nocopy JTF_NUMBER_TABLE
686: , p6_a9 out nocopy JTF_DATE_TABLE
687: , p6_a10 out nocopy JTF_NUMBER_TABLE
688: , p6_a11 out nocopy JTF_DATE_TABLE
689: , p6_a12 out nocopy JTF_NUMBER_TABLE
683: , p6_a6 out nocopy JTF_DATE_TABLE
684: , p6_a7 out nocopy JTF_DATE_TABLE
685: , p6_a8 out nocopy JTF_NUMBER_TABLE
686: , p6_a9 out nocopy JTF_DATE_TABLE
687: , p6_a10 out nocopy JTF_NUMBER_TABLE
688: , p6_a11 out nocopy JTF_DATE_TABLE
689: , p6_a12 out nocopy JTF_NUMBER_TABLE
690: , p6_a13 out nocopy JTF_NUMBER_TABLE
691: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
685: , p6_a8 out nocopy JTF_NUMBER_TABLE
686: , p6_a9 out nocopy JTF_DATE_TABLE
687: , p6_a10 out nocopy JTF_NUMBER_TABLE
688: , p6_a11 out nocopy JTF_DATE_TABLE
689: , p6_a12 out nocopy JTF_NUMBER_TABLE
690: , p6_a13 out nocopy JTF_NUMBER_TABLE
691: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
692: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
693: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
686: , p6_a9 out nocopy JTF_DATE_TABLE
687: , p6_a10 out nocopy JTF_NUMBER_TABLE
688: , p6_a11 out nocopy JTF_DATE_TABLE
689: , p6_a12 out nocopy JTF_NUMBER_TABLE
690: , p6_a13 out nocopy JTF_NUMBER_TABLE
691: , p6_a14 out nocopy JTF_VARCHAR2_TABLE_100
692: , p6_a15 out nocopy JTF_VARCHAR2_TABLE_100
693: , p6_a16 out nocopy JTF_VARCHAR2_TABLE_100
694: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
700: , p6_a23 out nocopy JTF_VARCHAR2_TABLE_100
701: , p6_a24 out nocopy JTF_VARCHAR2_TABLE_400
702: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
703: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
704: , p6_a27 out nocopy JTF_NUMBER_TABLE
705: , p6_a28 out nocopy JTF_DATE_TABLE
706: , p6_a29 out nocopy JTF_NUMBER_TABLE
707: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
708: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
702: , p6_a25 out nocopy JTF_VARCHAR2_TABLE_2000
703: , p6_a26 out nocopy JTF_VARCHAR2_TABLE_2000
704: , p6_a27 out nocopy JTF_NUMBER_TABLE
705: , p6_a28 out nocopy JTF_DATE_TABLE
706: , p6_a29 out nocopy JTF_NUMBER_TABLE
707: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
708: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
709: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
710: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000
707: , p6_a30 out nocopy JTF_VARCHAR2_TABLE_100
708: , p6_a31 out nocopy JTF_VARCHAR2_TABLE_100
709: , p6_a32 out nocopy JTF_VARCHAR2_TABLE_2000
710: , p6_a33 out nocopy JTF_VARCHAR2_TABLE_2000
711: , p6_a34 out nocopy JTF_NUMBER_TABLE
712: , p6_a35 out nocopy JTF_DATE_TABLE
713: , x_record_count out nocopy NUMBER
714: , p5_a0 NUMBER := 0-1962.0724
715: , p5_a1 NUMBER := 0-1962.0724