1: package ams_import_xml_pvt_w as
2: /* $Header: amswmixs.pls 120.1 2006/01/12 22:10 rmbhanda noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy ams_import_xml_pvt.xml_element_key_set_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p0(t ams_import_xml_pvt.xml_element_key_set_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy ams_import_xml_pvt.xml_source_column_set_type, a0 JTF_VARCHAR2_TABLE_200);
7: procedure rosetta_table_copy_out_p1(t ams_import_xml_pvt.xml_source_column_set_type, a0 out nocopy JTF_VARCHAR2_TABLE_200);
1: package ams_import_xml_pvt_w as
2: /* $Header: amswmixs.pls 120.1 2006/01/12 22:10 rmbhanda noship $ */
3: procedure rosetta_table_copy_in_p0(t out nocopy ams_import_xml_pvt.xml_element_key_set_type, a0 JTF_NUMBER_TABLE);
4: procedure rosetta_table_copy_out_p0(t ams_import_xml_pvt.xml_element_key_set_type, a0 out nocopy JTF_NUMBER_TABLE);
5:
6: procedure rosetta_table_copy_in_p1(t out nocopy ams_import_xml_pvt.xml_source_column_set_type, a0 JTF_VARCHAR2_TABLE_200);
7: procedure rosetta_table_copy_out_p1(t ams_import_xml_pvt.xml_source_column_set_type, a0 out nocopy JTF_VARCHAR2_TABLE_200);
8:
8:
9: procedure rosetta_table_copy_in_p2(t out nocopy ams_import_xml_pvt.xml_target_column_set_type, a0 JTF_VARCHAR2_TABLE_100);
10: procedure rosetta_table_copy_out_p2(t ams_import_xml_pvt.xml_target_column_set_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy ams_import_xml_pvt.xml_element_set_type, a0 JTF_NUMBER_TABLE
13: , a1 JTF_DATE_TABLE
14: , a2 JTF_NUMBER_TABLE
15: , a3 JTF_DATE_TABLE
16: , a4 JTF_NUMBER_TABLE
10: procedure rosetta_table_copy_out_p2(t ams_import_xml_pvt.xml_target_column_set_type, a0 out nocopy JTF_VARCHAR2_TABLE_100);
11:
12: procedure rosetta_table_copy_in_p3(t out nocopy ams_import_xml_pvt.xml_element_set_type, a0 JTF_NUMBER_TABLE
13: , a1 JTF_DATE_TABLE
14: , a2 JTF_NUMBER_TABLE
15: , a3 JTF_DATE_TABLE
16: , a4 JTF_NUMBER_TABLE
17: , a5 JTF_NUMBER_TABLE
18: , a6 JTF_NUMBER_TABLE
12: procedure rosetta_table_copy_in_p3(t out nocopy ams_import_xml_pvt.xml_element_set_type, a0 JTF_NUMBER_TABLE
13: , a1 JTF_DATE_TABLE
14: , a2 JTF_NUMBER_TABLE
15: , a3 JTF_DATE_TABLE
16: , a4 JTF_NUMBER_TABLE
17: , a5 JTF_NUMBER_TABLE
18: , a6 JTF_NUMBER_TABLE
19: , a7 JTF_NUMBER_TABLE
20: , a8 JTF_NUMBER_TABLE
13: , a1 JTF_DATE_TABLE
14: , a2 JTF_NUMBER_TABLE
15: , a3 JTF_DATE_TABLE
16: , a4 JTF_NUMBER_TABLE
17: , a5 JTF_NUMBER_TABLE
18: , a6 JTF_NUMBER_TABLE
19: , a7 JTF_NUMBER_TABLE
20: , a8 JTF_NUMBER_TABLE
21: , a9 JTF_NUMBER_TABLE
14: , a2 JTF_NUMBER_TABLE
15: , a3 JTF_DATE_TABLE
16: , a4 JTF_NUMBER_TABLE
17: , a5 JTF_NUMBER_TABLE
18: , a6 JTF_NUMBER_TABLE
19: , a7 JTF_NUMBER_TABLE
20: , a8 JTF_NUMBER_TABLE
21: , a9 JTF_NUMBER_TABLE
22: , a10 JTF_VARCHAR2_TABLE_2000
15: , a3 JTF_DATE_TABLE
16: , a4 JTF_NUMBER_TABLE
17: , a5 JTF_NUMBER_TABLE
18: , a6 JTF_NUMBER_TABLE
19: , a7 JTF_NUMBER_TABLE
20: , a8 JTF_NUMBER_TABLE
21: , a9 JTF_NUMBER_TABLE
22: , a10 JTF_VARCHAR2_TABLE_2000
23: , a11 JTF_VARCHAR2_TABLE_2000
16: , a4 JTF_NUMBER_TABLE
17: , a5 JTF_NUMBER_TABLE
18: , a6 JTF_NUMBER_TABLE
19: , a7 JTF_NUMBER_TABLE
20: , a8 JTF_NUMBER_TABLE
21: , a9 JTF_NUMBER_TABLE
22: , a10 JTF_VARCHAR2_TABLE_2000
23: , a11 JTF_VARCHAR2_TABLE_2000
24: , a12 JTF_NUMBER_TABLE
17: , a5 JTF_NUMBER_TABLE
18: , a6 JTF_NUMBER_TABLE
19: , a7 JTF_NUMBER_TABLE
20: , a8 JTF_NUMBER_TABLE
21: , a9 JTF_NUMBER_TABLE
22: , a10 JTF_VARCHAR2_TABLE_2000
23: , a11 JTF_VARCHAR2_TABLE_2000
24: , a12 JTF_NUMBER_TABLE
25: , a13 JTF_VARCHAR2_TABLE_100
20: , a8 JTF_NUMBER_TABLE
21: , a9 JTF_NUMBER_TABLE
22: , a10 JTF_VARCHAR2_TABLE_2000
23: , a11 JTF_VARCHAR2_TABLE_2000
24: , a12 JTF_NUMBER_TABLE
25: , a13 JTF_VARCHAR2_TABLE_100
26: , a14 JTF_VARCHAR2_TABLE_100
27: , a15 JTF_VARCHAR2_TABLE_4000
28: );
25: , a13 JTF_VARCHAR2_TABLE_100
26: , a14 JTF_VARCHAR2_TABLE_100
27: , a15 JTF_VARCHAR2_TABLE_4000
28: );
29: procedure rosetta_table_copy_out_p3(t ams_import_xml_pvt.xml_element_set_type, a0 out nocopy JTF_NUMBER_TABLE
30: , a1 out nocopy JTF_DATE_TABLE
31: , a2 out nocopy JTF_NUMBER_TABLE
32: , a3 out nocopy JTF_DATE_TABLE
33: , a4 out nocopy JTF_NUMBER_TABLE
27: , a15 JTF_VARCHAR2_TABLE_4000
28: );
29: procedure rosetta_table_copy_out_p3(t ams_import_xml_pvt.xml_element_set_type, a0 out nocopy JTF_NUMBER_TABLE
30: , a1 out nocopy JTF_DATE_TABLE
31: , a2 out nocopy JTF_NUMBER_TABLE
32: , a3 out nocopy JTF_DATE_TABLE
33: , a4 out nocopy JTF_NUMBER_TABLE
34: , a5 out nocopy JTF_NUMBER_TABLE
35: , a6 out nocopy JTF_NUMBER_TABLE
29: procedure rosetta_table_copy_out_p3(t ams_import_xml_pvt.xml_element_set_type, a0 out nocopy JTF_NUMBER_TABLE
30: , a1 out nocopy JTF_DATE_TABLE
31: , a2 out nocopy JTF_NUMBER_TABLE
32: , a3 out nocopy JTF_DATE_TABLE
33: , a4 out nocopy JTF_NUMBER_TABLE
34: , a5 out nocopy JTF_NUMBER_TABLE
35: , a6 out nocopy JTF_NUMBER_TABLE
36: , a7 out nocopy JTF_NUMBER_TABLE
37: , a8 out nocopy JTF_NUMBER_TABLE
30: , a1 out nocopy JTF_DATE_TABLE
31: , a2 out nocopy JTF_NUMBER_TABLE
32: , a3 out nocopy JTF_DATE_TABLE
33: , a4 out nocopy JTF_NUMBER_TABLE
34: , a5 out nocopy JTF_NUMBER_TABLE
35: , a6 out nocopy JTF_NUMBER_TABLE
36: , a7 out nocopy JTF_NUMBER_TABLE
37: , a8 out nocopy JTF_NUMBER_TABLE
38: , a9 out nocopy JTF_NUMBER_TABLE
31: , a2 out nocopy JTF_NUMBER_TABLE
32: , a3 out nocopy JTF_DATE_TABLE
33: , a4 out nocopy JTF_NUMBER_TABLE
34: , a5 out nocopy JTF_NUMBER_TABLE
35: , a6 out nocopy JTF_NUMBER_TABLE
36: , a7 out nocopy JTF_NUMBER_TABLE
37: , a8 out nocopy JTF_NUMBER_TABLE
38: , a9 out nocopy JTF_NUMBER_TABLE
39: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
32: , a3 out nocopy JTF_DATE_TABLE
33: , a4 out nocopy JTF_NUMBER_TABLE
34: , a5 out nocopy JTF_NUMBER_TABLE
35: , a6 out nocopy JTF_NUMBER_TABLE
36: , a7 out nocopy JTF_NUMBER_TABLE
37: , a8 out nocopy JTF_NUMBER_TABLE
38: , a9 out nocopy JTF_NUMBER_TABLE
39: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
40: , a11 out nocopy JTF_VARCHAR2_TABLE_2000
33: , a4 out nocopy JTF_NUMBER_TABLE
34: , a5 out nocopy JTF_NUMBER_TABLE
35: , a6 out nocopy JTF_NUMBER_TABLE
36: , a7 out nocopy JTF_NUMBER_TABLE
37: , a8 out nocopy JTF_NUMBER_TABLE
38: , a9 out nocopy JTF_NUMBER_TABLE
39: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
40: , a11 out nocopy JTF_VARCHAR2_TABLE_2000
41: , a12 out nocopy JTF_NUMBER_TABLE
34: , a5 out nocopy JTF_NUMBER_TABLE
35: , a6 out nocopy JTF_NUMBER_TABLE
36: , a7 out nocopy JTF_NUMBER_TABLE
37: , a8 out nocopy JTF_NUMBER_TABLE
38: , a9 out nocopy JTF_NUMBER_TABLE
39: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
40: , a11 out nocopy JTF_VARCHAR2_TABLE_2000
41: , a12 out nocopy JTF_NUMBER_TABLE
42: , a13 out nocopy JTF_VARCHAR2_TABLE_100
37: , a8 out nocopy JTF_NUMBER_TABLE
38: , a9 out nocopy JTF_NUMBER_TABLE
39: , a10 out nocopy JTF_VARCHAR2_TABLE_2000
40: , a11 out nocopy JTF_VARCHAR2_TABLE_2000
41: , a12 out nocopy JTF_NUMBER_TABLE
42: , a13 out nocopy JTF_VARCHAR2_TABLE_100
43: , a14 out nocopy JTF_VARCHAR2_TABLE_100
44: , a15 out nocopy JTF_VARCHAR2_TABLE_4000
45: );
129: , x_return_status out nocopy VARCHAR2
130: , x_msg_data out nocopy VARCHAR2
131: );
132: procedure get_children_nodes(p_imp_xml_element_id NUMBER
133: , x_child_ids out nocopy JTF_NUMBER_TABLE
134: , x_return_status out nocopy VARCHAR2
135: , x_msg_data out nocopy VARCHAR2
136: );
137: procedure get_children_nodes(p_imp_xml_element_id NUMBER
134: , x_return_status out nocopy VARCHAR2
135: , x_msg_data out nocopy VARCHAR2
136: );
137: procedure get_children_nodes(p_imp_xml_element_id NUMBER
138: , p1_a0 out nocopy JTF_NUMBER_TABLE
139: , p1_a1 out nocopy JTF_DATE_TABLE
140: , p1_a2 out nocopy JTF_NUMBER_TABLE
141: , p1_a3 out nocopy JTF_DATE_TABLE
142: , p1_a4 out nocopy JTF_NUMBER_TABLE
136: );
137: procedure get_children_nodes(p_imp_xml_element_id NUMBER
138: , p1_a0 out nocopy JTF_NUMBER_TABLE
139: , p1_a1 out nocopy JTF_DATE_TABLE
140: , p1_a2 out nocopy JTF_NUMBER_TABLE
141: , p1_a3 out nocopy JTF_DATE_TABLE
142: , p1_a4 out nocopy JTF_NUMBER_TABLE
143: , p1_a5 out nocopy JTF_NUMBER_TABLE
144: , p1_a6 out nocopy JTF_NUMBER_TABLE
138: , p1_a0 out nocopy JTF_NUMBER_TABLE
139: , p1_a1 out nocopy JTF_DATE_TABLE
140: , p1_a2 out nocopy JTF_NUMBER_TABLE
141: , p1_a3 out nocopy JTF_DATE_TABLE
142: , p1_a4 out nocopy JTF_NUMBER_TABLE
143: , p1_a5 out nocopy JTF_NUMBER_TABLE
144: , p1_a6 out nocopy JTF_NUMBER_TABLE
145: , p1_a7 out nocopy JTF_NUMBER_TABLE
146: , p1_a8 out nocopy JTF_NUMBER_TABLE
139: , p1_a1 out nocopy JTF_DATE_TABLE
140: , p1_a2 out nocopy JTF_NUMBER_TABLE
141: , p1_a3 out nocopy JTF_DATE_TABLE
142: , p1_a4 out nocopy JTF_NUMBER_TABLE
143: , p1_a5 out nocopy JTF_NUMBER_TABLE
144: , p1_a6 out nocopy JTF_NUMBER_TABLE
145: , p1_a7 out nocopy JTF_NUMBER_TABLE
146: , p1_a8 out nocopy JTF_NUMBER_TABLE
147: , p1_a9 out nocopy JTF_NUMBER_TABLE
140: , p1_a2 out nocopy JTF_NUMBER_TABLE
141: , p1_a3 out nocopy JTF_DATE_TABLE
142: , p1_a4 out nocopy JTF_NUMBER_TABLE
143: , p1_a5 out nocopy JTF_NUMBER_TABLE
144: , p1_a6 out nocopy JTF_NUMBER_TABLE
145: , p1_a7 out nocopy JTF_NUMBER_TABLE
146: , p1_a8 out nocopy JTF_NUMBER_TABLE
147: , p1_a9 out nocopy JTF_NUMBER_TABLE
148: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_2000
141: , p1_a3 out nocopy JTF_DATE_TABLE
142: , p1_a4 out nocopy JTF_NUMBER_TABLE
143: , p1_a5 out nocopy JTF_NUMBER_TABLE
144: , p1_a6 out nocopy JTF_NUMBER_TABLE
145: , p1_a7 out nocopy JTF_NUMBER_TABLE
146: , p1_a8 out nocopy JTF_NUMBER_TABLE
147: , p1_a9 out nocopy JTF_NUMBER_TABLE
148: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_2000
149: , p1_a11 out nocopy JTF_VARCHAR2_TABLE_2000
142: , p1_a4 out nocopy JTF_NUMBER_TABLE
143: , p1_a5 out nocopy JTF_NUMBER_TABLE
144: , p1_a6 out nocopy JTF_NUMBER_TABLE
145: , p1_a7 out nocopy JTF_NUMBER_TABLE
146: , p1_a8 out nocopy JTF_NUMBER_TABLE
147: , p1_a9 out nocopy JTF_NUMBER_TABLE
148: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_2000
149: , p1_a11 out nocopy JTF_VARCHAR2_TABLE_2000
150: , p1_a12 out nocopy JTF_NUMBER_TABLE
143: , p1_a5 out nocopy JTF_NUMBER_TABLE
144: , p1_a6 out nocopy JTF_NUMBER_TABLE
145: , p1_a7 out nocopy JTF_NUMBER_TABLE
146: , p1_a8 out nocopy JTF_NUMBER_TABLE
147: , p1_a9 out nocopy JTF_NUMBER_TABLE
148: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_2000
149: , p1_a11 out nocopy JTF_VARCHAR2_TABLE_2000
150: , p1_a12 out nocopy JTF_NUMBER_TABLE
151: , p1_a13 out nocopy JTF_VARCHAR2_TABLE_100
146: , p1_a8 out nocopy JTF_NUMBER_TABLE
147: , p1_a9 out nocopy JTF_NUMBER_TABLE
148: , p1_a10 out nocopy JTF_VARCHAR2_TABLE_2000
149: , p1_a11 out nocopy JTF_VARCHAR2_TABLE_2000
150: , p1_a12 out nocopy JTF_NUMBER_TABLE
151: , p1_a13 out nocopy JTF_VARCHAR2_TABLE_100
152: , p1_a14 out nocopy JTF_VARCHAR2_TABLE_100
153: , p1_a15 out nocopy JTF_VARCHAR2_TABLE_4000
154: , x_return_status out nocopy VARCHAR2