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
9: , a6 JTF_DATE_TABLE
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
11: , a8 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
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
20: , a17 JTF_VARCHAR2_TABLE_200
21: , a18 JTF_VARCHAR2_TABLE_100
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
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_400
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
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_400
23: , a20 JTF_VARCHAR2_TABLE_2000
17: , a14 JTF_VARCHAR2_TABLE_100
18: , a15 JTF_VARCHAR2_TABLE_100
19: , a16 JTF_VARCHAR2_TABLE_100
20: , a17 JTF_VARCHAR2_TABLE_200
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_400
23: , a20 JTF_VARCHAR2_TABLE_2000
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_200
20: , a17 JTF_VARCHAR2_TABLE_200
21: , a18 JTF_VARCHAR2_TABLE_100
22: , a19 JTF_VARCHAR2_TABLE_400
23: , a20 JTF_VARCHAR2_TABLE_2000
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 JTF_VARCHAR2_TABLE_200
26: , a23 JTF_VARCHAR2_TABLE_100
27: , a24 JTF_VARCHAR2_TABLE_400
28: , a25 JTF_VARCHAR2_TABLE_2000
22: , a19 JTF_VARCHAR2_TABLE_400
23: , a20 JTF_VARCHAR2_TABLE_2000
24: , a21 JTF_VARCHAR2_TABLE_100
25: , a22 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
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
37: , a34 JTF_NUMBER_TABLE
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
37: , a34 JTF_NUMBER_TABLE
38: , a35 JTF_DATE_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
46: , a6 out nocopy JTF_DATE_TABLE
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
48: , a8 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
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
57: , a17 out nocopy JTF_VARCHAR2_TABLE_200
58: , a18 out nocopy JTF_VARCHAR2_TABLE_100
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
58: , a18 out nocopy JTF_VARCHAR2_TABLE_100
59: , a19 out nocopy JTF_VARCHAR2_TABLE_400
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
58: , a18 out nocopy JTF_VARCHAR2_TABLE_100
59: , a19 out nocopy JTF_VARCHAR2_TABLE_400
60: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
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
58: , a18 out nocopy JTF_VARCHAR2_TABLE_100
59: , a19 out nocopy JTF_VARCHAR2_TABLE_400
60: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
61: , a21 out nocopy JTF_VARCHAR2_TABLE_100
62: , a22 out nocopy JTF_VARCHAR2_TABLE_200
57: , a17 out nocopy JTF_VARCHAR2_TABLE_200
58: , a18 out nocopy JTF_VARCHAR2_TABLE_100
59: , a19 out nocopy JTF_VARCHAR2_TABLE_400
60: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
61: , a21 out nocopy JTF_VARCHAR2_TABLE_100
62: , a22 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
59: , a19 out nocopy JTF_VARCHAR2_TABLE_400
60: , a20 out nocopy JTF_VARCHAR2_TABLE_2000
61: , a21 out nocopy JTF_VARCHAR2_TABLE_100
62: , a22 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
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
74: , a34 out nocopy JTF_NUMBER_TABLE
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
74: , a34 out nocopy JTF_NUMBER_TABLE
75: , a35 out nocopy JTF_DATE_TABLE
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
79: , a1 JTF_VARCHAR2_TABLE_100
80: , a2 JTF_VARCHAR2_TABLE_200
81: , a3 JTF_VARCHAR2_TABLE_400
82: , a4 JTF_VARCHAR2_TABLE_2000
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
79: , a1 JTF_VARCHAR2_TABLE_100
80: , a2 JTF_VARCHAR2_TABLE_200
81: , a3 JTF_VARCHAR2_TABLE_400
82: , a4 JTF_VARCHAR2_TABLE_2000
83: , a5 JTF_VARCHAR2_TABLE_100
79: , a1 JTF_VARCHAR2_TABLE_100
80: , a2 JTF_VARCHAR2_TABLE_200
81: , a3 JTF_VARCHAR2_TABLE_400
82: , a4 JTF_VARCHAR2_TABLE_2000
83: , a5 JTF_VARCHAR2_TABLE_100
84: , a6 JTF_VARCHAR2_TABLE_100
85: , a7 JTF_VARCHAR2_TABLE_200
86: , a8 JTF_VARCHAR2_TABLE_400
87: , a9 JTF_VARCHAR2_TABLE_2000
80: , a2 JTF_VARCHAR2_TABLE_200
81: , a3 JTF_VARCHAR2_TABLE_400
82: , a4 JTF_VARCHAR2_TABLE_2000
83: , a5 JTF_VARCHAR2_TABLE_100
84: , a6 JTF_VARCHAR2_TABLE_100
85: , a7 JTF_VARCHAR2_TABLE_200
86: , a8 JTF_VARCHAR2_TABLE_400
87: , a9 JTF_VARCHAR2_TABLE_2000
88: , a10 JTF_VARCHAR2_TABLE_100
84: , a6 JTF_VARCHAR2_TABLE_100
85: , a7 JTF_VARCHAR2_TABLE_200
86: , a8 JTF_VARCHAR2_TABLE_400
87: , a9 JTF_VARCHAR2_TABLE_2000
88: , a10 JTF_VARCHAR2_TABLE_100
89: , a11 JTF_VARCHAR2_TABLE_100
90: , a12 JTF_VARCHAR2_TABLE_200
91: , a13 JTF_VARCHAR2_TABLE_400
92: , a14 JTF_VARCHAR2_TABLE_2000
85: , a7 JTF_VARCHAR2_TABLE_200
86: , a8 JTF_VARCHAR2_TABLE_400
87: , a9 JTF_VARCHAR2_TABLE_2000
88: , a10 JTF_VARCHAR2_TABLE_100
89: , a11 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
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
100: , a1 out nocopy JTF_VARCHAR2_TABLE_100
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
100: , a1 out nocopy JTF_VARCHAR2_TABLE_100
101: , a2 out nocopy JTF_VARCHAR2_TABLE_200
102: , a3 out nocopy JTF_VARCHAR2_TABLE_400
103: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
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
100: , a1 out nocopy JTF_VARCHAR2_TABLE_100
101: , a2 out nocopy JTF_VARCHAR2_TABLE_200
102: , a3 out nocopy JTF_VARCHAR2_TABLE_400
103: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
104: , a5 out nocopy JTF_VARCHAR2_TABLE_100
100: , a1 out nocopy JTF_VARCHAR2_TABLE_100
101: , a2 out nocopy JTF_VARCHAR2_TABLE_200
102: , a3 out nocopy JTF_VARCHAR2_TABLE_400
103: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
104: , a5 out nocopy JTF_VARCHAR2_TABLE_100
105: , a6 out nocopy JTF_VARCHAR2_TABLE_100
106: , a7 out nocopy JTF_VARCHAR2_TABLE_200
107: , a8 out nocopy JTF_VARCHAR2_TABLE_400
108: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
101: , a2 out nocopy JTF_VARCHAR2_TABLE_200
102: , a3 out nocopy JTF_VARCHAR2_TABLE_400
103: , a4 out nocopy JTF_VARCHAR2_TABLE_2000
104: , a5 out nocopy JTF_VARCHAR2_TABLE_100
105: , a6 out nocopy JTF_VARCHAR2_TABLE_100
106: , a7 out nocopy JTF_VARCHAR2_TABLE_200
107: , a8 out nocopy JTF_VARCHAR2_TABLE_400
108: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
109: , a10 out nocopy JTF_VARCHAR2_TABLE_100
105: , a6 out nocopy JTF_VARCHAR2_TABLE_100
106: , a7 out nocopy JTF_VARCHAR2_TABLE_200
107: , a8 out nocopy JTF_VARCHAR2_TABLE_400
108: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
109: , a10 out nocopy JTF_VARCHAR2_TABLE_100
110: , a11 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
106: , a7 out nocopy JTF_VARCHAR2_TABLE_200
107: , a8 out nocopy JTF_VARCHAR2_TABLE_400
108: , a9 out nocopy JTF_VARCHAR2_TABLE_2000
109: , a10 out nocopy JTF_VARCHAR2_TABLE_100
110: , a11 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
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:
121: procedure fetch_rule_quote_parties(p_api_version NUMBER
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
134: , p6_a8 out nocopy JTF_VARCHAR2_TABLE_600
135: , p6_a9 out nocopy JTF_VARCHAR2_TABLE_100
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
138: , p6_a12 out nocopy JTF_VARCHAR2_TABLE_100
139: , p6_a13 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
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
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
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
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
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
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
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
154: , p7_a8 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
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
163: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_200
164: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
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
164: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
165: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_400
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
164: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
165: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_400
166: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_2000
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
164: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
165: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_400
166: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_2000
167: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
168: , p7_a22 out nocopy JTF_VARCHAR2_TABLE_200
163: , p7_a17 out nocopy JTF_VARCHAR2_TABLE_200
164: , p7_a18 out nocopy JTF_VARCHAR2_TABLE_100
165: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_400
166: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_2000
167: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
168: , p7_a22 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
165: , p7_a19 out nocopy JTF_VARCHAR2_TABLE_400
166: , p7_a20 out nocopy JTF_VARCHAR2_TABLE_2000
167: , p7_a21 out nocopy JTF_VARCHAR2_TABLE_100
168: , p7_a22 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
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
180: , p7_a34 out nocopy JTF_NUMBER_TABLE
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
180: , p7_a34 out nocopy JTF_NUMBER_TABLE
181: , p7_a35 out nocopy JTF_DATE_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
273: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_600
274: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_100
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
277: , p2_a12 out nocopy JTF_VARCHAR2_TABLE_100
278: , p2_a13 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
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
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
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
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
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
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
375: , p1_a8 JTF_VARCHAR2_TABLE_600
376: , p1_a9 JTF_VARCHAR2_TABLE_100
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
379: , p1_a12 JTF_VARCHAR2_TABLE_100
380: , p1_a13 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
379: , p1_a12 JTF_VARCHAR2_TABLE_100
380: , p1_a13 JTF_VARCHAR2_TABLE_100
381: , p1_a14 JTF_VARCHAR2_TABLE_200
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
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
376: , p1_a9 JTF_VARCHAR2_TABLE_100
377: , p1_a10 JTF_VARCHAR2_TABLE_100
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
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
396: , p3_a8 out nocopy JTF_VARCHAR2_TABLE_600
397: , p3_a9 out nocopy JTF_VARCHAR2_TABLE_100
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
400: , p3_a12 out nocopy JTF_VARCHAR2_TABLE_100
401: , p3_a13 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
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
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
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
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
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
488: , p0_a79 DATE := fnd_api.g_miss_date
489: );
490: procedure get_party_details(p_id_code VARCHAR2
491: , p_id_value VARCHAR2
492: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
493: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
494: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_200
495: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_400
496: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_2000
489: );
490: procedure get_party_details(p_id_code VARCHAR2
491: , p_id_value VARCHAR2
492: , p2_a0 out nocopy JTF_VARCHAR2_TABLE_100
493: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
494: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_200
495: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_400
496: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_2000
497: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
493: , p2_a1 out nocopy JTF_VARCHAR2_TABLE_100
494: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_200
495: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_400
496: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_2000
497: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
498: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
499: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_200
500: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_400
501: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_2000
494: , p2_a2 out nocopy JTF_VARCHAR2_TABLE_200
495: , p2_a3 out nocopy JTF_VARCHAR2_TABLE_400
496: , p2_a4 out nocopy JTF_VARCHAR2_TABLE_2000
497: , p2_a5 out nocopy JTF_VARCHAR2_TABLE_100
498: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
499: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_200
500: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_400
501: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_2000
502: , p2_a10 out nocopy JTF_VARCHAR2_TABLE_100
498: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
499: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_200
500: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_400
501: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_2000
502: , p2_a10 out nocopy JTF_VARCHAR2_TABLE_100
503: , p2_a11 out nocopy JTF_VARCHAR2_TABLE_100
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
499: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_200
500: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_400
501: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_2000
502: , p2_a10 out nocopy JTF_VARCHAR2_TABLE_100
503: , p2_a11 out nocopy JTF_VARCHAR2_TABLE_100
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
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: );
514: procedure get_quote_parties(p_api_version 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
525: , p6_a6 out nocopy JTF_DATE_TABLE
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
527: , p6_a8 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
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
536: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
537: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
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
537: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
538: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
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
537: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
538: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
539: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
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
537: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
538: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
539: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
540: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
541: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
536: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
537: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
538: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
539: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
540: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
541: , p6_a22 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
538: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
539: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
540: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
541: , p6_a22 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
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
553: , p6_a34 out nocopy JTF_NUMBER_TABLE
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
553: , p6_a34 out nocopy JTF_NUMBER_TABLE
554: , p6_a35 out nocopy JTF_DATE_TABLE
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
604: , p6_a6 out nocopy JTF_DATE_TABLE
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
606: , p6_a8 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
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
615: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
616: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
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
616: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
617: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
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
616: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
617: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
618: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
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
616: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
617: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
618: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
619: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
620: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
615: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
616: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
617: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
618: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
619: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
620: , p6_a22 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
617: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
618: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
619: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
620: , p6_a22 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
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
632: , p6_a34 out nocopy JTF_NUMBER_TABLE
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
632: , p6_a34 out nocopy JTF_NUMBER_TABLE
633: , p6_a35 out nocopy JTF_DATE_TABLE
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
683: , p6_a6 out nocopy JTF_DATE_TABLE
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
685: , p6_a8 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
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
694: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
695: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
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
695: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
696: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
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
695: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
696: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
697: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
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
695: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
696: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
697: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
698: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
699: , p6_a22 out nocopy JTF_VARCHAR2_TABLE_200
694: , p6_a17 out nocopy JTF_VARCHAR2_TABLE_200
695: , p6_a18 out nocopy JTF_VARCHAR2_TABLE_100
696: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
697: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
698: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
699: , p6_a22 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
696: , p6_a19 out nocopy JTF_VARCHAR2_TABLE_400
697: , p6_a20 out nocopy JTF_VARCHAR2_TABLE_2000
698: , p6_a21 out nocopy JTF_VARCHAR2_TABLE_100
699: , p6_a22 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
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
711: , p6_a34 out nocopy JTF_NUMBER_TABLE
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
711: , p6_a34 out nocopy JTF_NUMBER_TABLE
712: , p6_a35 out nocopy JTF_DATE_TABLE