1: package eam_asset_operation_txn_pub_w as
2: /* $Header: EAMPAORS.pls 120.4 2008/01/26 01:54:44 devijay ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy eam_asset_operation_txn_pub.eam_quality_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
1: package eam_asset_operation_txn_pub_w as
2: /* $Header: EAMPAORS.pls 120.4 2008/01/26 01:54:44 devijay ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy eam_asset_operation_txn_pub.eam_quality_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
1: package eam_asset_operation_txn_pub_w as
2: /* $Header: EAMPAORS.pls 120.4 2008/01/26 01:54:44 devijay ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy eam_asset_operation_txn_pub.eam_quality_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
2: /* $Header: EAMPAORS.pls 120.4 2008/01/26 01:54:44 devijay ship $ */
3: procedure rosetta_table_copy_in_p2(t out nocopy eam_asset_operation_txn_pub.eam_quality_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
3: procedure rosetta_table_copy_in_p2(t out nocopy eam_asset_operation_txn_pub.eam_quality_tbl_type, a0 JTF_NUMBER_TABLE
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
6: , a3 JTF_NUMBER_TABLE
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
9: , a6 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
10: , a7 JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: );
11: , a8 JTF_VARCHAR2_TABLE_2000
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: );
19: procedure rosetta_table_copy_out_p2(t eam_asset_operation_txn_pub.eam_quality_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
13: , a10 JTF_NUMBER_TABLE
14: , a11 JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: );
19: procedure rosetta_table_copy_out_p2(t eam_asset_operation_txn_pub.eam_quality_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
20: , a1 out nocopy JTF_NUMBER_TABLE
21: , a2 out nocopy JTF_NUMBER_TABLE
15: , a12 JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: );
19: procedure rosetta_table_copy_out_p2(t eam_asset_operation_txn_pub.eam_quality_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
20: , a1 out nocopy JTF_NUMBER_TABLE
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_NUMBER_TABLE
16: , a13 JTF_VARCHAR2_TABLE_100
17: , a14 JTF_NUMBER_TABLE
18: );
19: procedure rosetta_table_copy_out_p2(t eam_asset_operation_txn_pub.eam_quality_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
20: , a1 out nocopy JTF_NUMBER_TABLE
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_NUMBER_TABLE
24: , a5 out nocopy JTF_NUMBER_TABLE
17: , a14 JTF_NUMBER_TABLE
18: );
19: procedure rosetta_table_copy_out_p2(t eam_asset_operation_txn_pub.eam_quality_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
20: , a1 out nocopy JTF_NUMBER_TABLE
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_NUMBER_TABLE
24: , a5 out nocopy JTF_NUMBER_TABLE
25: , a6 out nocopy JTF_NUMBER_TABLE
18: );
19: procedure rosetta_table_copy_out_p2(t eam_asset_operation_txn_pub.eam_quality_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
20: , a1 out nocopy JTF_NUMBER_TABLE
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_NUMBER_TABLE
24: , a5 out nocopy JTF_NUMBER_TABLE
25: , a6 out nocopy JTF_NUMBER_TABLE
26: , a7 out nocopy JTF_NUMBER_TABLE
19: procedure rosetta_table_copy_out_p2(t eam_asset_operation_txn_pub.eam_quality_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
20: , a1 out nocopy JTF_NUMBER_TABLE
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_NUMBER_TABLE
24: , a5 out nocopy JTF_NUMBER_TABLE
25: , a6 out nocopy JTF_NUMBER_TABLE
26: , a7 out nocopy JTF_NUMBER_TABLE
27: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
20: , a1 out nocopy JTF_NUMBER_TABLE
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_NUMBER_TABLE
24: , a5 out nocopy JTF_NUMBER_TABLE
25: , a6 out nocopy JTF_NUMBER_TABLE
26: , a7 out nocopy JTF_NUMBER_TABLE
27: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
28: , a9 out nocopy JTF_VARCHAR2_TABLE_100
21: , a2 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_NUMBER_TABLE
24: , a5 out nocopy JTF_NUMBER_TABLE
25: , a6 out nocopy JTF_NUMBER_TABLE
26: , a7 out nocopy JTF_NUMBER_TABLE
27: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
28: , a9 out nocopy JTF_VARCHAR2_TABLE_100
29: , a10 out nocopy JTF_NUMBER_TABLE
22: , a3 out nocopy JTF_NUMBER_TABLE
23: , a4 out nocopy JTF_NUMBER_TABLE
24: , a5 out nocopy JTF_NUMBER_TABLE
25: , a6 out nocopy JTF_NUMBER_TABLE
26: , a7 out nocopy JTF_NUMBER_TABLE
27: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
28: , a9 out nocopy JTF_VARCHAR2_TABLE_100
29: , a10 out nocopy JTF_NUMBER_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
25: , a6 out nocopy JTF_NUMBER_TABLE
26: , a7 out nocopy JTF_NUMBER_TABLE
27: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
28: , a9 out nocopy JTF_VARCHAR2_TABLE_100
29: , a10 out nocopy JTF_NUMBER_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_NUMBER_TABLE
32: , a13 out nocopy JTF_VARCHAR2_TABLE_100
33: , a14 out nocopy JTF_NUMBER_TABLE
26: , a7 out nocopy JTF_NUMBER_TABLE
27: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
28: , a9 out nocopy JTF_VARCHAR2_TABLE_100
29: , a10 out nocopy JTF_NUMBER_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_NUMBER_TABLE
32: , a13 out nocopy JTF_VARCHAR2_TABLE_100
33: , a14 out nocopy JTF_NUMBER_TABLE
34: );
27: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
28: , a9 out nocopy JTF_VARCHAR2_TABLE_100
29: , a10 out nocopy JTF_NUMBER_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_NUMBER_TABLE
32: , a13 out nocopy JTF_VARCHAR2_TABLE_100
33: , a14 out nocopy JTF_NUMBER_TABLE
34: );
35:
29: , a10 out nocopy JTF_NUMBER_TABLE
30: , a11 out nocopy JTF_NUMBER_TABLE
31: , a12 out nocopy JTF_NUMBER_TABLE
32: , a13 out nocopy JTF_VARCHAR2_TABLE_100
33: , a14 out nocopy JTF_NUMBER_TABLE
34: );
35:
36: procedure rosetta_table_copy_in_p4(t out nocopy eam_asset_operation_txn_pub.ctr_property_readings_tbl, a0 JTF_NUMBER_TABLE
37: , a1 JTF_NUMBER_TABLE
32: , a13 out nocopy JTF_VARCHAR2_TABLE_100
33: , a14 out nocopy JTF_NUMBER_TABLE
34: );
35:
36: procedure rosetta_table_copy_in_p4(t out nocopy eam_asset_operation_txn_pub.ctr_property_readings_tbl, a0 JTF_NUMBER_TABLE
37: , a1 JTF_NUMBER_TABLE
38: , a2 JTF_VARCHAR2_TABLE_300
39: , a3 JTF_DATE_TABLE
40: , a4 JTF_VARCHAR2_TABLE_100
33: , a14 out nocopy JTF_NUMBER_TABLE
34: );
35:
36: procedure rosetta_table_copy_in_p4(t out nocopy eam_asset_operation_txn_pub.ctr_property_readings_tbl, a0 JTF_NUMBER_TABLE
37: , a1 JTF_NUMBER_TABLE
38: , a2 JTF_VARCHAR2_TABLE_300
39: , a3 JTF_DATE_TABLE
40: , a4 JTF_VARCHAR2_TABLE_100
41: , a5 JTF_VARCHAR2_TABLE_200
54: , a18 JTF_VARCHAR2_TABLE_200
55: , a19 JTF_VARCHAR2_TABLE_200
56: , a20 JTF_VARCHAR2_TABLE_100
57: );
58: procedure rosetta_table_copy_out_p4(t eam_asset_operation_txn_pub.ctr_property_readings_tbl, a0 out nocopy JTF_NUMBER_TABLE
59: , a1 out nocopy JTF_NUMBER_TABLE
60: , a2 out nocopy JTF_VARCHAR2_TABLE_300
61: , a3 out nocopy JTF_DATE_TABLE
62: , a4 out nocopy JTF_VARCHAR2_TABLE_100
55: , a19 JTF_VARCHAR2_TABLE_200
56: , a20 JTF_VARCHAR2_TABLE_100
57: );
58: procedure rosetta_table_copy_out_p4(t eam_asset_operation_txn_pub.ctr_property_readings_tbl, a0 out nocopy JTF_NUMBER_TABLE
59: , a1 out nocopy JTF_NUMBER_TABLE
60: , a2 out nocopy JTF_VARCHAR2_TABLE_300
61: , a3 out nocopy JTF_DATE_TABLE
62: , a4 out nocopy JTF_VARCHAR2_TABLE_100
63: , a5 out nocopy JTF_VARCHAR2_TABLE_200
77: , a19 out nocopy JTF_VARCHAR2_TABLE_200
78: , a20 out nocopy JTF_VARCHAR2_TABLE_100
79: );
80:
81: procedure rosetta_table_copy_in_p6(t out nocopy eam_asset_operation_txn_pub.meter_reading_rec_tbl_type, a0 JTF_NUMBER_TABLE
82: , a1 JTF_NUMBER_TABLE
83: , a2 JTF_NUMBER_TABLE
84: , a3 JTF_DATE_TABLE
85: , a4 JTF_VARCHAR2_TABLE_100
78: , a20 out nocopy JTF_VARCHAR2_TABLE_100
79: );
80:
81: procedure rosetta_table_copy_in_p6(t out nocopy eam_asset_operation_txn_pub.meter_reading_rec_tbl_type, a0 JTF_NUMBER_TABLE
82: , a1 JTF_NUMBER_TABLE
83: , a2 JTF_NUMBER_TABLE
84: , a3 JTF_DATE_TABLE
85: , a4 JTF_VARCHAR2_TABLE_100
86: , a5 JTF_VARCHAR2_TABLE_100
79: );
80:
81: procedure rosetta_table_copy_in_p6(t out nocopy eam_asset_operation_txn_pub.meter_reading_rec_tbl_type, a0 JTF_NUMBER_TABLE
82: , a1 JTF_NUMBER_TABLE
83: , a2 JTF_NUMBER_TABLE
84: , a3 JTF_DATE_TABLE
85: , a4 JTF_VARCHAR2_TABLE_100
86: , a5 JTF_VARCHAR2_TABLE_100
87: , a6 JTF_NUMBER_TABLE
83: , a2 JTF_NUMBER_TABLE
84: , a3 JTF_DATE_TABLE
85: , a4 JTF_VARCHAR2_TABLE_100
86: , a5 JTF_VARCHAR2_TABLE_100
87: , a6 JTF_NUMBER_TABLE
88: , a7 JTF_NUMBER_TABLE
89: , a8 JTF_NUMBER_TABLE
90: , a9 JTF_NUMBER_TABLE
91: , a10 JTF_VARCHAR2_TABLE_100
84: , a3 JTF_DATE_TABLE
85: , a4 JTF_VARCHAR2_TABLE_100
86: , a5 JTF_VARCHAR2_TABLE_100
87: , a6 JTF_NUMBER_TABLE
88: , a7 JTF_NUMBER_TABLE
89: , a8 JTF_NUMBER_TABLE
90: , a9 JTF_NUMBER_TABLE
91: , a10 JTF_VARCHAR2_TABLE_100
92: , a11 JTF_VARCHAR2_TABLE_100
85: , a4 JTF_VARCHAR2_TABLE_100
86: , a5 JTF_VARCHAR2_TABLE_100
87: , a6 JTF_NUMBER_TABLE
88: , a7 JTF_NUMBER_TABLE
89: , a8 JTF_NUMBER_TABLE
90: , a9 JTF_NUMBER_TABLE
91: , a10 JTF_VARCHAR2_TABLE_100
92: , a11 JTF_VARCHAR2_TABLE_100
93: , a12 JTF_VARCHAR2_TABLE_100
86: , a5 JTF_VARCHAR2_TABLE_100
87: , a6 JTF_NUMBER_TABLE
88: , a7 JTF_NUMBER_TABLE
89: , a8 JTF_NUMBER_TABLE
90: , a9 JTF_NUMBER_TABLE
91: , a10 JTF_VARCHAR2_TABLE_100
92: , a11 JTF_VARCHAR2_TABLE_100
93: , a12 JTF_VARCHAR2_TABLE_100
94: , a13 JTF_NUMBER_TABLE
90: , a9 JTF_NUMBER_TABLE
91: , a10 JTF_VARCHAR2_TABLE_100
92: , a11 JTF_VARCHAR2_TABLE_100
93: , a12 JTF_VARCHAR2_TABLE_100
94: , a13 JTF_NUMBER_TABLE
95: , a14 JTF_NUMBER_TABLE
96: , a15 JTF_VARCHAR2_TABLE_300
97: , a16 JTF_VARCHAR2_TABLE_100
98: , a17 JTF_VARCHAR2_TABLE_200
91: , a10 JTF_VARCHAR2_TABLE_100
92: , a11 JTF_VARCHAR2_TABLE_100
93: , a12 JTF_VARCHAR2_TABLE_100
94: , a13 JTF_NUMBER_TABLE
95: , a14 JTF_NUMBER_TABLE
96: , a15 JTF_VARCHAR2_TABLE_300
97: , a16 JTF_VARCHAR2_TABLE_100
98: , a17 JTF_VARCHAR2_TABLE_200
99: , a18 JTF_VARCHAR2_TABLE_200
124: , a43 JTF_VARCHAR2_TABLE_200
125: , a44 JTF_VARCHAR2_TABLE_200
126: , a45 JTF_VARCHAR2_TABLE_200
127: , a46 JTF_VARCHAR2_TABLE_200
128: , a47 JTF_NUMBER_TABLE
129: , a48 JTF_VARCHAR2_TABLE_100
130: );
131: procedure rosetta_table_copy_out_p6(t eam_asset_operation_txn_pub.meter_reading_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
132: , a1 out nocopy JTF_NUMBER_TABLE
127: , a46 JTF_VARCHAR2_TABLE_200
128: , a47 JTF_NUMBER_TABLE
129: , a48 JTF_VARCHAR2_TABLE_100
130: );
131: procedure rosetta_table_copy_out_p6(t eam_asset_operation_txn_pub.meter_reading_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
132: , a1 out nocopy JTF_NUMBER_TABLE
133: , a2 out nocopy JTF_NUMBER_TABLE
134: , a3 out nocopy JTF_DATE_TABLE
135: , a4 out nocopy JTF_VARCHAR2_TABLE_100
128: , a47 JTF_NUMBER_TABLE
129: , a48 JTF_VARCHAR2_TABLE_100
130: );
131: procedure rosetta_table_copy_out_p6(t eam_asset_operation_txn_pub.meter_reading_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
132: , a1 out nocopy JTF_NUMBER_TABLE
133: , a2 out nocopy JTF_NUMBER_TABLE
134: , a3 out nocopy JTF_DATE_TABLE
135: , a4 out nocopy JTF_VARCHAR2_TABLE_100
136: , a5 out nocopy JTF_VARCHAR2_TABLE_100
129: , a48 JTF_VARCHAR2_TABLE_100
130: );
131: procedure rosetta_table_copy_out_p6(t eam_asset_operation_txn_pub.meter_reading_rec_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
132: , a1 out nocopy JTF_NUMBER_TABLE
133: , a2 out nocopy JTF_NUMBER_TABLE
134: , a3 out nocopy JTF_DATE_TABLE
135: , a4 out nocopy JTF_VARCHAR2_TABLE_100
136: , a5 out nocopy JTF_VARCHAR2_TABLE_100
137: , a6 out nocopy JTF_NUMBER_TABLE
133: , a2 out nocopy JTF_NUMBER_TABLE
134: , a3 out nocopy JTF_DATE_TABLE
135: , a4 out nocopy JTF_VARCHAR2_TABLE_100
136: , a5 out nocopy JTF_VARCHAR2_TABLE_100
137: , a6 out nocopy JTF_NUMBER_TABLE
138: , a7 out nocopy JTF_NUMBER_TABLE
139: , a8 out nocopy JTF_NUMBER_TABLE
140: , a9 out nocopy JTF_NUMBER_TABLE
141: , a10 out nocopy JTF_VARCHAR2_TABLE_100
134: , a3 out nocopy JTF_DATE_TABLE
135: , a4 out nocopy JTF_VARCHAR2_TABLE_100
136: , a5 out nocopy JTF_VARCHAR2_TABLE_100
137: , a6 out nocopy JTF_NUMBER_TABLE
138: , a7 out nocopy JTF_NUMBER_TABLE
139: , a8 out nocopy JTF_NUMBER_TABLE
140: , a9 out nocopy JTF_NUMBER_TABLE
141: , a10 out nocopy JTF_VARCHAR2_TABLE_100
142: , a11 out nocopy JTF_VARCHAR2_TABLE_100
135: , a4 out nocopy JTF_VARCHAR2_TABLE_100
136: , a5 out nocopy JTF_VARCHAR2_TABLE_100
137: , a6 out nocopy JTF_NUMBER_TABLE
138: , a7 out nocopy JTF_NUMBER_TABLE
139: , a8 out nocopy JTF_NUMBER_TABLE
140: , a9 out nocopy JTF_NUMBER_TABLE
141: , a10 out nocopy JTF_VARCHAR2_TABLE_100
142: , a11 out nocopy JTF_VARCHAR2_TABLE_100
143: , a12 out nocopy JTF_VARCHAR2_TABLE_100
136: , a5 out nocopy JTF_VARCHAR2_TABLE_100
137: , a6 out nocopy JTF_NUMBER_TABLE
138: , a7 out nocopy JTF_NUMBER_TABLE
139: , a8 out nocopy JTF_NUMBER_TABLE
140: , a9 out nocopy JTF_NUMBER_TABLE
141: , a10 out nocopy JTF_VARCHAR2_TABLE_100
142: , a11 out nocopy JTF_VARCHAR2_TABLE_100
143: , a12 out nocopy JTF_VARCHAR2_TABLE_100
144: , a13 out nocopy JTF_NUMBER_TABLE
140: , a9 out nocopy JTF_NUMBER_TABLE
141: , a10 out nocopy JTF_VARCHAR2_TABLE_100
142: , a11 out nocopy JTF_VARCHAR2_TABLE_100
143: , a12 out nocopy JTF_VARCHAR2_TABLE_100
144: , a13 out nocopy JTF_NUMBER_TABLE
145: , a14 out nocopy JTF_NUMBER_TABLE
146: , a15 out nocopy JTF_VARCHAR2_TABLE_300
147: , a16 out nocopy JTF_VARCHAR2_TABLE_100
148: , a17 out nocopy JTF_VARCHAR2_TABLE_200
141: , a10 out nocopy JTF_VARCHAR2_TABLE_100
142: , a11 out nocopy JTF_VARCHAR2_TABLE_100
143: , a12 out nocopy JTF_VARCHAR2_TABLE_100
144: , a13 out nocopy JTF_NUMBER_TABLE
145: , a14 out nocopy JTF_NUMBER_TABLE
146: , a15 out nocopy JTF_VARCHAR2_TABLE_300
147: , a16 out nocopy JTF_VARCHAR2_TABLE_100
148: , a17 out nocopy JTF_VARCHAR2_TABLE_200
149: , a18 out nocopy JTF_VARCHAR2_TABLE_200
174: , a43 out nocopy JTF_VARCHAR2_TABLE_200
175: , a44 out nocopy JTF_VARCHAR2_TABLE_200
176: , a45 out nocopy JTF_VARCHAR2_TABLE_200
177: , a46 out nocopy JTF_VARCHAR2_TABLE_200
178: , a47 out nocopy JTF_NUMBER_TABLE
179: , a48 out nocopy JTF_VARCHAR2_TABLE_100
180: );
181:
182: procedure process_checkinout_txn(p_api_version NUMBER
189: , p_comments VARCHAR2
190: , p_qa_collection_id NUMBER
191: , p_operable_flag NUMBER
192: , p_employee_id NUMBER
193: , p11_a0 JTF_NUMBER_TABLE
194: , p11_a1 JTF_NUMBER_TABLE
195: , p11_a2 JTF_NUMBER_TABLE
196: , p11_a3 JTF_NUMBER_TABLE
197: , p11_a4 JTF_NUMBER_TABLE
190: , p_qa_collection_id NUMBER
191: , p_operable_flag NUMBER
192: , p_employee_id NUMBER
193: , p11_a0 JTF_NUMBER_TABLE
194: , p11_a1 JTF_NUMBER_TABLE
195: , p11_a2 JTF_NUMBER_TABLE
196: , p11_a3 JTF_NUMBER_TABLE
197: , p11_a4 JTF_NUMBER_TABLE
198: , p11_a5 JTF_NUMBER_TABLE
191: , p_operable_flag NUMBER
192: , p_employee_id NUMBER
193: , p11_a0 JTF_NUMBER_TABLE
194: , p11_a1 JTF_NUMBER_TABLE
195: , p11_a2 JTF_NUMBER_TABLE
196: , p11_a3 JTF_NUMBER_TABLE
197: , p11_a4 JTF_NUMBER_TABLE
198: , p11_a5 JTF_NUMBER_TABLE
199: , p11_a6 JTF_NUMBER_TABLE
192: , p_employee_id NUMBER
193: , p11_a0 JTF_NUMBER_TABLE
194: , p11_a1 JTF_NUMBER_TABLE
195: , p11_a2 JTF_NUMBER_TABLE
196: , p11_a3 JTF_NUMBER_TABLE
197: , p11_a4 JTF_NUMBER_TABLE
198: , p11_a5 JTF_NUMBER_TABLE
199: , p11_a6 JTF_NUMBER_TABLE
200: , p11_a7 JTF_NUMBER_TABLE
193: , p11_a0 JTF_NUMBER_TABLE
194: , p11_a1 JTF_NUMBER_TABLE
195: , p11_a2 JTF_NUMBER_TABLE
196: , p11_a3 JTF_NUMBER_TABLE
197: , p11_a4 JTF_NUMBER_TABLE
198: , p11_a5 JTF_NUMBER_TABLE
199: , p11_a6 JTF_NUMBER_TABLE
200: , p11_a7 JTF_NUMBER_TABLE
201: , p11_a8 JTF_VARCHAR2_TABLE_2000
194: , p11_a1 JTF_NUMBER_TABLE
195: , p11_a2 JTF_NUMBER_TABLE
196: , p11_a3 JTF_NUMBER_TABLE
197: , p11_a4 JTF_NUMBER_TABLE
198: , p11_a5 JTF_NUMBER_TABLE
199: , p11_a6 JTF_NUMBER_TABLE
200: , p11_a7 JTF_NUMBER_TABLE
201: , p11_a8 JTF_VARCHAR2_TABLE_2000
202: , p11_a9 JTF_VARCHAR2_TABLE_100
195: , p11_a2 JTF_NUMBER_TABLE
196: , p11_a3 JTF_NUMBER_TABLE
197: , p11_a4 JTF_NUMBER_TABLE
198: , p11_a5 JTF_NUMBER_TABLE
199: , p11_a6 JTF_NUMBER_TABLE
200: , p11_a7 JTF_NUMBER_TABLE
201: , p11_a8 JTF_VARCHAR2_TABLE_2000
202: , p11_a9 JTF_VARCHAR2_TABLE_100
203: , p11_a10 JTF_NUMBER_TABLE
196: , p11_a3 JTF_NUMBER_TABLE
197: , p11_a4 JTF_NUMBER_TABLE
198: , p11_a5 JTF_NUMBER_TABLE
199: , p11_a6 JTF_NUMBER_TABLE
200: , p11_a7 JTF_NUMBER_TABLE
201: , p11_a8 JTF_VARCHAR2_TABLE_2000
202: , p11_a9 JTF_VARCHAR2_TABLE_100
203: , p11_a10 JTF_NUMBER_TABLE
204: , p11_a11 JTF_NUMBER_TABLE
199: , p11_a6 JTF_NUMBER_TABLE
200: , p11_a7 JTF_NUMBER_TABLE
201: , p11_a8 JTF_VARCHAR2_TABLE_2000
202: , p11_a9 JTF_VARCHAR2_TABLE_100
203: , p11_a10 JTF_NUMBER_TABLE
204: , p11_a11 JTF_NUMBER_TABLE
205: , p11_a12 JTF_NUMBER_TABLE
206: , p11_a13 JTF_VARCHAR2_TABLE_100
207: , p11_a14 JTF_NUMBER_TABLE
200: , p11_a7 JTF_NUMBER_TABLE
201: , p11_a8 JTF_VARCHAR2_TABLE_2000
202: , p11_a9 JTF_VARCHAR2_TABLE_100
203: , p11_a10 JTF_NUMBER_TABLE
204: , p11_a11 JTF_NUMBER_TABLE
205: , p11_a12 JTF_NUMBER_TABLE
206: , p11_a13 JTF_VARCHAR2_TABLE_100
207: , p11_a14 JTF_NUMBER_TABLE
208: , p12_a0 JTF_NUMBER_TABLE
201: , p11_a8 JTF_VARCHAR2_TABLE_2000
202: , p11_a9 JTF_VARCHAR2_TABLE_100
203: , p11_a10 JTF_NUMBER_TABLE
204: , p11_a11 JTF_NUMBER_TABLE
205: , p11_a12 JTF_NUMBER_TABLE
206: , p11_a13 JTF_VARCHAR2_TABLE_100
207: , p11_a14 JTF_NUMBER_TABLE
208: , p12_a0 JTF_NUMBER_TABLE
209: , p12_a1 JTF_NUMBER_TABLE
203: , p11_a10 JTF_NUMBER_TABLE
204: , p11_a11 JTF_NUMBER_TABLE
205: , p11_a12 JTF_NUMBER_TABLE
206: , p11_a13 JTF_VARCHAR2_TABLE_100
207: , p11_a14 JTF_NUMBER_TABLE
208: , p12_a0 JTF_NUMBER_TABLE
209: , p12_a1 JTF_NUMBER_TABLE
210: , p12_a2 JTF_NUMBER_TABLE
211: , p12_a3 JTF_DATE_TABLE
204: , p11_a11 JTF_NUMBER_TABLE
205: , p11_a12 JTF_NUMBER_TABLE
206: , p11_a13 JTF_VARCHAR2_TABLE_100
207: , p11_a14 JTF_NUMBER_TABLE
208: , p12_a0 JTF_NUMBER_TABLE
209: , p12_a1 JTF_NUMBER_TABLE
210: , p12_a2 JTF_NUMBER_TABLE
211: , p12_a3 JTF_DATE_TABLE
212: , p12_a4 JTF_VARCHAR2_TABLE_100
205: , p11_a12 JTF_NUMBER_TABLE
206: , p11_a13 JTF_VARCHAR2_TABLE_100
207: , p11_a14 JTF_NUMBER_TABLE
208: , p12_a0 JTF_NUMBER_TABLE
209: , p12_a1 JTF_NUMBER_TABLE
210: , p12_a2 JTF_NUMBER_TABLE
211: , p12_a3 JTF_DATE_TABLE
212: , p12_a4 JTF_VARCHAR2_TABLE_100
213: , p12_a5 JTF_VARCHAR2_TABLE_100
206: , p11_a13 JTF_VARCHAR2_TABLE_100
207: , p11_a14 JTF_NUMBER_TABLE
208: , p12_a0 JTF_NUMBER_TABLE
209: , p12_a1 JTF_NUMBER_TABLE
210: , p12_a2 JTF_NUMBER_TABLE
211: , p12_a3 JTF_DATE_TABLE
212: , p12_a4 JTF_VARCHAR2_TABLE_100
213: , p12_a5 JTF_VARCHAR2_TABLE_100
214: , p12_a6 JTF_NUMBER_TABLE
210: , p12_a2 JTF_NUMBER_TABLE
211: , p12_a3 JTF_DATE_TABLE
212: , p12_a4 JTF_VARCHAR2_TABLE_100
213: , p12_a5 JTF_VARCHAR2_TABLE_100
214: , p12_a6 JTF_NUMBER_TABLE
215: , p12_a7 JTF_NUMBER_TABLE
216: , p12_a8 JTF_NUMBER_TABLE
217: , p12_a9 JTF_NUMBER_TABLE
218: , p12_a10 JTF_VARCHAR2_TABLE_100
211: , p12_a3 JTF_DATE_TABLE
212: , p12_a4 JTF_VARCHAR2_TABLE_100
213: , p12_a5 JTF_VARCHAR2_TABLE_100
214: , p12_a6 JTF_NUMBER_TABLE
215: , p12_a7 JTF_NUMBER_TABLE
216: , p12_a8 JTF_NUMBER_TABLE
217: , p12_a9 JTF_NUMBER_TABLE
218: , p12_a10 JTF_VARCHAR2_TABLE_100
219: , p12_a11 JTF_VARCHAR2_TABLE_100
212: , p12_a4 JTF_VARCHAR2_TABLE_100
213: , p12_a5 JTF_VARCHAR2_TABLE_100
214: , p12_a6 JTF_NUMBER_TABLE
215: , p12_a7 JTF_NUMBER_TABLE
216: , p12_a8 JTF_NUMBER_TABLE
217: , p12_a9 JTF_NUMBER_TABLE
218: , p12_a10 JTF_VARCHAR2_TABLE_100
219: , p12_a11 JTF_VARCHAR2_TABLE_100
220: , p12_a12 JTF_VARCHAR2_TABLE_100
213: , p12_a5 JTF_VARCHAR2_TABLE_100
214: , p12_a6 JTF_NUMBER_TABLE
215: , p12_a7 JTF_NUMBER_TABLE
216: , p12_a8 JTF_NUMBER_TABLE
217: , p12_a9 JTF_NUMBER_TABLE
218: , p12_a10 JTF_VARCHAR2_TABLE_100
219: , p12_a11 JTF_VARCHAR2_TABLE_100
220: , p12_a12 JTF_VARCHAR2_TABLE_100
221: , p12_a13 JTF_NUMBER_TABLE
217: , p12_a9 JTF_NUMBER_TABLE
218: , p12_a10 JTF_VARCHAR2_TABLE_100
219: , p12_a11 JTF_VARCHAR2_TABLE_100
220: , p12_a12 JTF_VARCHAR2_TABLE_100
221: , p12_a13 JTF_NUMBER_TABLE
222: , p12_a14 JTF_NUMBER_TABLE
223: , p12_a15 JTF_VARCHAR2_TABLE_300
224: , p12_a16 JTF_VARCHAR2_TABLE_100
225: , p12_a17 JTF_VARCHAR2_TABLE_200
218: , p12_a10 JTF_VARCHAR2_TABLE_100
219: , p12_a11 JTF_VARCHAR2_TABLE_100
220: , p12_a12 JTF_VARCHAR2_TABLE_100
221: , p12_a13 JTF_NUMBER_TABLE
222: , p12_a14 JTF_NUMBER_TABLE
223: , p12_a15 JTF_VARCHAR2_TABLE_300
224: , p12_a16 JTF_VARCHAR2_TABLE_100
225: , p12_a17 JTF_VARCHAR2_TABLE_200
226: , p12_a18 JTF_VARCHAR2_TABLE_200
251: , p12_a43 JTF_VARCHAR2_TABLE_200
252: , p12_a44 JTF_VARCHAR2_TABLE_200
253: , p12_a45 JTF_VARCHAR2_TABLE_200
254: , p12_a46 JTF_VARCHAR2_TABLE_200
255: , p12_a47 JTF_NUMBER_TABLE
256: , p12_a48 JTF_VARCHAR2_TABLE_100
257: , p13_a0 JTF_NUMBER_TABLE
258: , p13_a1 JTF_NUMBER_TABLE
259: , p13_a2 JTF_VARCHAR2_TABLE_300
253: , p12_a45 JTF_VARCHAR2_TABLE_200
254: , p12_a46 JTF_VARCHAR2_TABLE_200
255: , p12_a47 JTF_NUMBER_TABLE
256: , p12_a48 JTF_VARCHAR2_TABLE_100
257: , p13_a0 JTF_NUMBER_TABLE
258: , p13_a1 JTF_NUMBER_TABLE
259: , p13_a2 JTF_VARCHAR2_TABLE_300
260: , p13_a3 JTF_DATE_TABLE
261: , p13_a4 JTF_VARCHAR2_TABLE_100
254: , p12_a46 JTF_VARCHAR2_TABLE_200
255: , p12_a47 JTF_NUMBER_TABLE
256: , p12_a48 JTF_VARCHAR2_TABLE_100
257: , p13_a0 JTF_NUMBER_TABLE
258: , p13_a1 JTF_NUMBER_TABLE
259: , p13_a2 JTF_VARCHAR2_TABLE_300
260: , p13_a3 JTF_DATE_TABLE
261: , p13_a4 JTF_VARCHAR2_TABLE_100
262: , p13_a5 JTF_VARCHAR2_TABLE_200