34: , a6 JTF_VARCHAR2_TABLE_100
35: , a7 JTF_VARCHAR2_TABLE_100
36: , a8 JTF_VARCHAR2_TABLE_2000
37: , a9 JTF_VARCHAR2_TABLE_100
38: , a10 JTF_DATE_TABLE
39: , a11 JTF_DATE_TABLE
40: , a12 JTF_NUMBER_TABLE
41: , a13 JTF_VARCHAR2_TABLE_100
42: );
35: , a7 JTF_VARCHAR2_TABLE_100
36: , a8 JTF_VARCHAR2_TABLE_2000
37: , a9 JTF_VARCHAR2_TABLE_100
38: , a10 JTF_DATE_TABLE
39: , a11 JTF_DATE_TABLE
40: , a12 JTF_NUMBER_TABLE
41: , a13 JTF_VARCHAR2_TABLE_100
42: );
43: procedure rosetta_table_copy_out_p3(t ahl_mr_loop_chain_relns_pvt.mr_chain_loop_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
49: , a6 out nocopy JTF_VARCHAR2_TABLE_100
50: , a7 out nocopy JTF_VARCHAR2_TABLE_100
51: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
52: , a9 out nocopy JTF_VARCHAR2_TABLE_100
53: , a10 out nocopy JTF_DATE_TABLE
54: , a11 out nocopy JTF_DATE_TABLE
55: , a12 out nocopy JTF_NUMBER_TABLE
56: , a13 out nocopy JTF_VARCHAR2_TABLE_100
57: );
50: , a7 out nocopy JTF_VARCHAR2_TABLE_100
51: , a8 out nocopy JTF_VARCHAR2_TABLE_2000
52: , a9 out nocopy JTF_VARCHAR2_TABLE_100
53: , a10 out nocopy JTF_DATE_TABLE
54: , a11 out nocopy JTF_DATE_TABLE
55: , a12 out nocopy JTF_NUMBER_TABLE
56: , a13 out nocopy JTF_VARCHAR2_TABLE_100
57: );
58:
98: , p2_a6 out nocopy JTF_VARCHAR2_TABLE_100
99: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
100: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_2000
101: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_100
102: , p2_a10 out nocopy JTF_DATE_TABLE
103: , p2_a11 out nocopy JTF_DATE_TABLE
104: , p2_a12 out nocopy JTF_NUMBER_TABLE
105: , p2_a13 out nocopy JTF_VARCHAR2_TABLE_100
106: , x_return_status out nocopy VARCHAR2
99: , p2_a7 out nocopy JTF_VARCHAR2_TABLE_100
100: , p2_a8 out nocopy JTF_VARCHAR2_TABLE_2000
101: , p2_a9 out nocopy JTF_VARCHAR2_TABLE_100
102: , p2_a10 out nocopy JTF_DATE_TABLE
103: , p2_a11 out nocopy JTF_DATE_TABLE
104: , p2_a12 out nocopy JTF_NUMBER_TABLE
105: , p2_a13 out nocopy JTF_VARCHAR2_TABLE_100
106: , x_return_status out nocopy VARCHAR2
107: , x_msg_count out nocopy NUMBER
134: , p8_a6 JTF_VARCHAR2_TABLE_100
135: , p8_a7 JTF_VARCHAR2_TABLE_100
136: , p8_a8 JTF_VARCHAR2_TABLE_2000
137: , p8_a9 JTF_VARCHAR2_TABLE_100
138: , p8_a10 JTF_DATE_TABLE
139: , p8_a11 JTF_DATE_TABLE
140: , p8_a12 JTF_NUMBER_TABLE
141: , p8_a13 JTF_VARCHAR2_TABLE_100
142: );
135: , p8_a7 JTF_VARCHAR2_TABLE_100
136: , p8_a8 JTF_VARCHAR2_TABLE_2000
137: , p8_a9 JTF_VARCHAR2_TABLE_100
138: , p8_a10 JTF_DATE_TABLE
139: , p8_a11 JTF_DATE_TABLE
140: , p8_a12 JTF_NUMBER_TABLE
141: , p8_a13 JTF_VARCHAR2_TABLE_100
142: );
143: procedure view_mr_loop_chain(p_api_version NUMBER
173: , p14_a6 out nocopy JTF_VARCHAR2_TABLE_100
174: , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100
175: , p14_a8 out nocopy JTF_VARCHAR2_TABLE_2000
176: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
177: , p14_a10 out nocopy JTF_DATE_TABLE
178: , p14_a11 out nocopy JTF_DATE_TABLE
179: , p14_a12 out nocopy JTF_NUMBER_TABLE
180: , p14_a13 out nocopy JTF_VARCHAR2_TABLE_100
181: );
174: , p14_a7 out nocopy JTF_VARCHAR2_TABLE_100
175: , p14_a8 out nocopy JTF_VARCHAR2_TABLE_2000
176: , p14_a9 out nocopy JTF_VARCHAR2_TABLE_100
177: , p14_a10 out nocopy JTF_DATE_TABLE
178: , p14_a11 out nocopy JTF_DATE_TABLE
179: , p14_a12 out nocopy JTF_NUMBER_TABLE
180: , p14_a13 out nocopy JTF_VARCHAR2_TABLE_100
181: );
182: procedure get_valid_loop_chain_relns(p_mr_header_id NUMBER
195: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
196: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
197: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_2000
198: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
199: , p7_a10 out nocopy JTF_DATE_TABLE
200: , p7_a11 out nocopy JTF_DATE_TABLE
201: , p7_a12 out nocopy JTF_NUMBER_TABLE
202: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
203: );
196: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
197: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_2000
198: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
199: , p7_a10 out nocopy JTF_DATE_TABLE
200: , p7_a11 out nocopy JTF_DATE_TABLE
201: , p7_a12 out nocopy JTF_NUMBER_TABLE
202: , p7_a13 out nocopy JTF_VARCHAR2_TABLE_100
203: );
204: end ahl_mr_loop_chain_relns_pvt_w;