1: package jts_config_version_pvt_w AUTHID CURRENT_USER as
2: /* $Header: jtswcvrs.pls 115.5 2002/03/27 18:03:15 pkm ship $ */
3: procedure rosetta_table_copy_in_p4(t out jts_config_version_pvt.config_version_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_300
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_200
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_VARCHAR2_TABLE_300
8: , a5 JTF_VARCHAR2_TABLE_100
9: , a6 JTF_VARCHAR2_TABLE_200
10: , a7 JTF_VARCHAR2_TABLE_200
11: , a8 JTF_VARCHAR2_TABLE_200
12: , a9 JTF_VARCHAR2_TABLE_200
26: , a23 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_300
34: , a31 JTF_NUMBER_TABLE
27: , a24 JTF_DATE_TABLE
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_300
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
28: , a25 JTF_NUMBER_TABLE
29: , a26 JTF_NUMBER_TABLE
30: , a27 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_300
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
31: , a28 JTF_VARCHAR2_TABLE_100
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_300
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_DATE_TABLE
32: , a29 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_300
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_VARCHAR2_TABLE_100
33: , a30 JTF_VARCHAR2_TABLE_300
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
34: , a31 JTF_NUMBER_TABLE
35: , a32 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
36: , a33 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
37: , a34 JTF_VARCHAR2_TABLE_100
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
38: , a35 JTF_VARCHAR2_TABLE_100
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: );
39: , a36 JTF_DATE_TABLE
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: );
47: procedure rosetta_table_copy_out_p4(t jts_config_version_pvt.config_version_tbl_type, a0 out JTF_NUMBER_TABLE
40: , a37 JTF_VARCHAR2_TABLE_100
41: , a38 JTF_VARCHAR2_TABLE_100
42: , a39 JTF_VARCHAR2_TABLE_100
43: , a40 JTF_VARCHAR2_TABLE_100
44: , a41 JTF_VARCHAR2_TABLE_100
45: , a42 JTF_NUMBER_TABLE
46: );
47: procedure rosetta_table_copy_out_p4(t jts_config_version_pvt.config_version_tbl_type, a0 out JTF_NUMBER_TABLE
48: , a1 out JTF_NUMBER_TABLE
45: , a42 JTF_NUMBER_TABLE
46: );
47: procedure rosetta_table_copy_out_p4(t jts_config_version_pvt.config_version_tbl_type, a0 out JTF_NUMBER_TABLE
48: , a1 out JTF_NUMBER_TABLE
49: , a2 out JTF_VARCHAR2_TABLE_100
50: , a3 out JTF_NUMBER_TABLE
51: , a4 out JTF_VARCHAR2_TABLE_300
52: , a5 out JTF_VARCHAR2_TABLE_100
53: , a6 out JTF_VARCHAR2_TABLE_200
48: , a1 out JTF_NUMBER_TABLE
49: , a2 out JTF_VARCHAR2_TABLE_100
50: , a3 out JTF_NUMBER_TABLE
51: , a4 out JTF_VARCHAR2_TABLE_300
52: , a5 out JTF_VARCHAR2_TABLE_100
53: , a6 out JTF_VARCHAR2_TABLE_200
54: , a7 out JTF_VARCHAR2_TABLE_200
55: , a8 out JTF_VARCHAR2_TABLE_200
56: , a9 out JTF_VARCHAR2_TABLE_200
70: , a23 out JTF_NUMBER_TABLE
71: , a24 out JTF_DATE_TABLE
72: , a25 out JTF_NUMBER_TABLE
73: , a26 out JTF_NUMBER_TABLE
74: , a27 out JTF_VARCHAR2_TABLE_100
75: , a28 out JTF_VARCHAR2_TABLE_100
76: , a29 out JTF_VARCHAR2_TABLE_100
77: , a30 out JTF_VARCHAR2_TABLE_300
78: , a31 out JTF_NUMBER_TABLE
71: , a24 out JTF_DATE_TABLE
72: , a25 out JTF_NUMBER_TABLE
73: , a26 out JTF_NUMBER_TABLE
74: , a27 out JTF_VARCHAR2_TABLE_100
75: , a28 out JTF_VARCHAR2_TABLE_100
76: , a29 out JTF_VARCHAR2_TABLE_100
77: , a30 out JTF_VARCHAR2_TABLE_300
78: , a31 out JTF_NUMBER_TABLE
79: , a32 out JTF_VARCHAR2_TABLE_100
72: , a25 out JTF_NUMBER_TABLE
73: , a26 out JTF_NUMBER_TABLE
74: , a27 out JTF_VARCHAR2_TABLE_100
75: , a28 out JTF_VARCHAR2_TABLE_100
76: , a29 out JTF_VARCHAR2_TABLE_100
77: , a30 out JTF_VARCHAR2_TABLE_300
78: , a31 out JTF_NUMBER_TABLE
79: , a32 out JTF_VARCHAR2_TABLE_100
80: , a33 out JTF_VARCHAR2_TABLE_100
75: , a28 out JTF_VARCHAR2_TABLE_100
76: , a29 out JTF_VARCHAR2_TABLE_100
77: , a30 out JTF_VARCHAR2_TABLE_300
78: , a31 out JTF_NUMBER_TABLE
79: , a32 out JTF_VARCHAR2_TABLE_100
80: , a33 out JTF_VARCHAR2_TABLE_100
81: , a34 out JTF_VARCHAR2_TABLE_100
82: , a35 out JTF_VARCHAR2_TABLE_100
83: , a36 out JTF_DATE_TABLE
76: , a29 out JTF_VARCHAR2_TABLE_100
77: , a30 out JTF_VARCHAR2_TABLE_300
78: , a31 out JTF_NUMBER_TABLE
79: , a32 out JTF_VARCHAR2_TABLE_100
80: , a33 out JTF_VARCHAR2_TABLE_100
81: , a34 out JTF_VARCHAR2_TABLE_100
82: , a35 out JTF_VARCHAR2_TABLE_100
83: , a36 out JTF_DATE_TABLE
84: , a37 out JTF_VARCHAR2_TABLE_100
77: , a30 out JTF_VARCHAR2_TABLE_300
78: , a31 out JTF_NUMBER_TABLE
79: , a32 out JTF_VARCHAR2_TABLE_100
80: , a33 out JTF_VARCHAR2_TABLE_100
81: , a34 out JTF_VARCHAR2_TABLE_100
82: , a35 out JTF_VARCHAR2_TABLE_100
83: , a36 out JTF_DATE_TABLE
84: , a37 out JTF_VARCHAR2_TABLE_100
85: , a38 out JTF_VARCHAR2_TABLE_100
78: , a31 out JTF_NUMBER_TABLE
79: , a32 out JTF_VARCHAR2_TABLE_100
80: , a33 out JTF_VARCHAR2_TABLE_100
81: , a34 out JTF_VARCHAR2_TABLE_100
82: , a35 out JTF_VARCHAR2_TABLE_100
83: , a36 out JTF_DATE_TABLE
84: , a37 out JTF_VARCHAR2_TABLE_100
85: , a38 out JTF_VARCHAR2_TABLE_100
86: , a39 out JTF_VARCHAR2_TABLE_100
80: , a33 out JTF_VARCHAR2_TABLE_100
81: , a34 out JTF_VARCHAR2_TABLE_100
82: , a35 out JTF_VARCHAR2_TABLE_100
83: , a36 out JTF_DATE_TABLE
84: , a37 out JTF_VARCHAR2_TABLE_100
85: , a38 out JTF_VARCHAR2_TABLE_100
86: , a39 out JTF_VARCHAR2_TABLE_100
87: , a40 out JTF_VARCHAR2_TABLE_100
88: , a41 out JTF_VARCHAR2_TABLE_100
81: , a34 out JTF_VARCHAR2_TABLE_100
82: , a35 out JTF_VARCHAR2_TABLE_100
83: , a36 out JTF_DATE_TABLE
84: , a37 out JTF_VARCHAR2_TABLE_100
85: , a38 out JTF_VARCHAR2_TABLE_100
86: , a39 out JTF_VARCHAR2_TABLE_100
87: , a40 out JTF_VARCHAR2_TABLE_100
88: , a41 out JTF_VARCHAR2_TABLE_100
89: , a42 out JTF_NUMBER_TABLE
82: , a35 out JTF_VARCHAR2_TABLE_100
83: , a36 out JTF_DATE_TABLE
84: , a37 out JTF_VARCHAR2_TABLE_100
85: , a38 out JTF_VARCHAR2_TABLE_100
86: , a39 out JTF_VARCHAR2_TABLE_100
87: , a40 out JTF_VARCHAR2_TABLE_100
88: , a41 out JTF_VARCHAR2_TABLE_100
89: , a42 out JTF_NUMBER_TABLE
90: );
83: , a36 out JTF_DATE_TABLE
84: , a37 out JTF_VARCHAR2_TABLE_100
85: , a38 out JTF_VARCHAR2_TABLE_100
86: , a39 out JTF_VARCHAR2_TABLE_100
87: , a40 out JTF_VARCHAR2_TABLE_100
88: , a41 out JTF_VARCHAR2_TABLE_100
89: , a42 out JTF_NUMBER_TABLE
90: );
91:
84: , a37 out JTF_VARCHAR2_TABLE_100
85: , a38 out JTF_VARCHAR2_TABLE_100
86: , a39 out JTF_VARCHAR2_TABLE_100
87: , a40 out JTF_VARCHAR2_TABLE_100
88: , a41 out JTF_VARCHAR2_TABLE_100
89: , a42 out JTF_NUMBER_TABLE
90: );
91:
92: procedure rosetta_table_copy_in_p5(t out jts_config_version_pvt.version_id_tbl_type, a0 JTF_NUMBER_TABLE);
149: , p_order_by VARCHAR2
150: , p_how_to_order VARCHAR2
151: , p4_a0 out JTF_NUMBER_TABLE
152: , p4_a1 out JTF_NUMBER_TABLE
153: , p4_a2 out JTF_VARCHAR2_TABLE_100
154: , p4_a3 out JTF_NUMBER_TABLE
155: , p4_a4 out JTF_VARCHAR2_TABLE_300
156: , p4_a5 out JTF_VARCHAR2_TABLE_100
157: , p4_a6 out JTF_VARCHAR2_TABLE_200
152: , p4_a1 out JTF_NUMBER_TABLE
153: , p4_a2 out JTF_VARCHAR2_TABLE_100
154: , p4_a3 out JTF_NUMBER_TABLE
155: , p4_a4 out JTF_VARCHAR2_TABLE_300
156: , p4_a5 out JTF_VARCHAR2_TABLE_100
157: , p4_a6 out JTF_VARCHAR2_TABLE_200
158: , p4_a7 out JTF_VARCHAR2_TABLE_200
159: , p4_a8 out JTF_VARCHAR2_TABLE_200
160: , p4_a9 out JTF_VARCHAR2_TABLE_200
174: , p4_a23 out JTF_NUMBER_TABLE
175: , p4_a24 out JTF_DATE_TABLE
176: , p4_a25 out JTF_NUMBER_TABLE
177: , p4_a26 out JTF_NUMBER_TABLE
178: , p4_a27 out JTF_VARCHAR2_TABLE_100
179: , p4_a28 out JTF_VARCHAR2_TABLE_100
180: , p4_a29 out JTF_VARCHAR2_TABLE_100
181: , p4_a30 out JTF_VARCHAR2_TABLE_300
182: , p4_a31 out JTF_NUMBER_TABLE
175: , p4_a24 out JTF_DATE_TABLE
176: , p4_a25 out JTF_NUMBER_TABLE
177: , p4_a26 out JTF_NUMBER_TABLE
178: , p4_a27 out JTF_VARCHAR2_TABLE_100
179: , p4_a28 out JTF_VARCHAR2_TABLE_100
180: , p4_a29 out JTF_VARCHAR2_TABLE_100
181: , p4_a30 out JTF_VARCHAR2_TABLE_300
182: , p4_a31 out JTF_NUMBER_TABLE
183: , p4_a32 out JTF_VARCHAR2_TABLE_100
176: , p4_a25 out JTF_NUMBER_TABLE
177: , p4_a26 out JTF_NUMBER_TABLE
178: , p4_a27 out JTF_VARCHAR2_TABLE_100
179: , p4_a28 out JTF_VARCHAR2_TABLE_100
180: , p4_a29 out JTF_VARCHAR2_TABLE_100
181: , p4_a30 out JTF_VARCHAR2_TABLE_300
182: , p4_a31 out JTF_NUMBER_TABLE
183: , p4_a32 out JTF_VARCHAR2_TABLE_100
184: , p4_a33 out JTF_VARCHAR2_TABLE_100
179: , p4_a28 out JTF_VARCHAR2_TABLE_100
180: , p4_a29 out JTF_VARCHAR2_TABLE_100
181: , p4_a30 out JTF_VARCHAR2_TABLE_300
182: , p4_a31 out JTF_NUMBER_TABLE
183: , p4_a32 out JTF_VARCHAR2_TABLE_100
184: , p4_a33 out JTF_VARCHAR2_TABLE_100
185: , p4_a34 out JTF_VARCHAR2_TABLE_100
186: , p4_a35 out JTF_VARCHAR2_TABLE_100
187: , p4_a36 out JTF_DATE_TABLE
180: , p4_a29 out JTF_VARCHAR2_TABLE_100
181: , p4_a30 out JTF_VARCHAR2_TABLE_300
182: , p4_a31 out JTF_NUMBER_TABLE
183: , p4_a32 out JTF_VARCHAR2_TABLE_100
184: , p4_a33 out JTF_VARCHAR2_TABLE_100
185: , p4_a34 out JTF_VARCHAR2_TABLE_100
186: , p4_a35 out JTF_VARCHAR2_TABLE_100
187: , p4_a36 out JTF_DATE_TABLE
188: , p4_a37 out JTF_VARCHAR2_TABLE_100
181: , p4_a30 out JTF_VARCHAR2_TABLE_300
182: , p4_a31 out JTF_NUMBER_TABLE
183: , p4_a32 out JTF_VARCHAR2_TABLE_100
184: , p4_a33 out JTF_VARCHAR2_TABLE_100
185: , p4_a34 out JTF_VARCHAR2_TABLE_100
186: , p4_a35 out JTF_VARCHAR2_TABLE_100
187: , p4_a36 out JTF_DATE_TABLE
188: , p4_a37 out JTF_VARCHAR2_TABLE_100
189: , p4_a38 out JTF_VARCHAR2_TABLE_100
182: , p4_a31 out JTF_NUMBER_TABLE
183: , p4_a32 out JTF_VARCHAR2_TABLE_100
184: , p4_a33 out JTF_VARCHAR2_TABLE_100
185: , p4_a34 out JTF_VARCHAR2_TABLE_100
186: , p4_a35 out JTF_VARCHAR2_TABLE_100
187: , p4_a36 out JTF_DATE_TABLE
188: , p4_a37 out JTF_VARCHAR2_TABLE_100
189: , p4_a38 out JTF_VARCHAR2_TABLE_100
190: , p4_a39 out JTF_VARCHAR2_TABLE_100
184: , p4_a33 out JTF_VARCHAR2_TABLE_100
185: , p4_a34 out JTF_VARCHAR2_TABLE_100
186: , p4_a35 out JTF_VARCHAR2_TABLE_100
187: , p4_a36 out JTF_DATE_TABLE
188: , p4_a37 out JTF_VARCHAR2_TABLE_100
189: , p4_a38 out JTF_VARCHAR2_TABLE_100
190: , p4_a39 out JTF_VARCHAR2_TABLE_100
191: , p4_a40 out JTF_VARCHAR2_TABLE_100
192: , p4_a41 out JTF_VARCHAR2_TABLE_100
185: , p4_a34 out JTF_VARCHAR2_TABLE_100
186: , p4_a35 out JTF_VARCHAR2_TABLE_100
187: , p4_a36 out JTF_DATE_TABLE
188: , p4_a37 out JTF_VARCHAR2_TABLE_100
189: , p4_a38 out JTF_VARCHAR2_TABLE_100
190: , p4_a39 out JTF_VARCHAR2_TABLE_100
191: , p4_a40 out JTF_VARCHAR2_TABLE_100
192: , p4_a41 out JTF_VARCHAR2_TABLE_100
193: , p4_a42 out JTF_NUMBER_TABLE
186: , p4_a35 out JTF_VARCHAR2_TABLE_100
187: , p4_a36 out JTF_DATE_TABLE
188: , p4_a37 out JTF_VARCHAR2_TABLE_100
189: , p4_a38 out JTF_VARCHAR2_TABLE_100
190: , p4_a39 out JTF_VARCHAR2_TABLE_100
191: , p4_a40 out JTF_VARCHAR2_TABLE_100
192: , p4_a41 out JTF_VARCHAR2_TABLE_100
193: , p4_a42 out JTF_NUMBER_TABLE
194: , x_return_status out VARCHAR2
187: , p4_a36 out JTF_DATE_TABLE
188: , p4_a37 out JTF_VARCHAR2_TABLE_100
189: , p4_a38 out JTF_VARCHAR2_TABLE_100
190: , p4_a39 out JTF_VARCHAR2_TABLE_100
191: , p4_a40 out JTF_VARCHAR2_TABLE_100
192: , p4_a41 out JTF_VARCHAR2_TABLE_100
193: , p4_a42 out JTF_NUMBER_TABLE
194: , x_return_status out VARCHAR2
195: , x_msg_count out NUMBER
188: , p4_a37 out JTF_VARCHAR2_TABLE_100
189: , p4_a38 out JTF_VARCHAR2_TABLE_100
190: , p4_a39 out JTF_VARCHAR2_TABLE_100
191: , p4_a40 out JTF_VARCHAR2_TABLE_100
192: , p4_a41 out JTF_VARCHAR2_TABLE_100
193: , p4_a42 out JTF_NUMBER_TABLE
194: , x_return_status out VARCHAR2
195: , x_msg_count out NUMBER
196: , x_msg_data out VARCHAR2