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
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
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
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
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
43 , a14 out nocopy JTF_VARCHAR2_TABLE_100
44 , a15 out nocopy JTF_VARCHAR2_TABLE_4000
45 );
46
47 procedure is_leaf_node(p_imp_xml_element_id NUMBER
48 , x_return_status out nocopy VARCHAR2
49 , x_msg_data out nocopy VARCHAR2
50 , ddrosetta_retval_bool OUT NOCOPY NUMBER
51 );
52 procedure get_root_node(p_import_list_header_id NUMBER
53 , p1_a0 out nocopy NUMBER
54 , p1_a1 out nocopy DATE
55 , p1_a2 out nocopy NUMBER
56 , p1_a3 out nocopy DATE
57 , p1_a4 out nocopy NUMBER
58 , p1_a5 out nocopy NUMBER
59 , p1_a6 out nocopy NUMBER
60 , p1_a7 out nocopy NUMBER
61 , p1_a8 out nocopy NUMBER
62 , p1_a9 out nocopy NUMBER
63 , p1_a10 out nocopy VARCHAR2
64 , p1_a11 out nocopy VARCHAR2
65 , p1_a12 out nocopy NUMBER
66 , p1_a13 out nocopy VARCHAR2
67 , p1_a14 out nocopy VARCHAR2
68 , p1_a15 out nocopy VARCHAR2
69 , x_return_status out nocopy VARCHAR2
70 , x_msg_data out nocopy VARCHAR2
71 );
72 procedure get_parent_node(p_imp_xml_element_id NUMBER
73 , p1_a0 out nocopy NUMBER
74 , p1_a1 out nocopy DATE
75 , p1_a2 out nocopy NUMBER
76 , p1_a3 out nocopy DATE
77 , p1_a4 out nocopy NUMBER
78 , p1_a5 out nocopy NUMBER
79 , p1_a6 out nocopy NUMBER
80 , p1_a7 out nocopy NUMBER
81 , p1_a8 out nocopy NUMBER
82 , p1_a9 out nocopy NUMBER
83 , p1_a10 out nocopy VARCHAR2
84 , p1_a11 out nocopy VARCHAR2
85 , p1_a12 out nocopy NUMBER
86 , p1_a13 out nocopy VARCHAR2
87 , p1_a14 out nocopy VARCHAR2
88 , p1_a15 out nocopy VARCHAR2
89 , x_return_status out nocopy VARCHAR2
90 , x_msg_data out nocopy VARCHAR2
91 );
92 procedure get_first_child_node(p_imp_xml_element_id NUMBER
93 , p1_a0 out nocopy NUMBER
94 , p1_a1 out nocopy DATE
95 , p1_a2 out nocopy NUMBER
96 , p1_a3 out nocopy DATE
97 , p1_a4 out nocopy NUMBER
98 , p1_a5 out nocopy NUMBER
99 , p1_a6 out nocopy NUMBER
100 , p1_a7 out nocopy NUMBER
101 , p1_a8 out nocopy NUMBER
102 , p1_a9 out nocopy NUMBER
103 , p1_a10 out nocopy VARCHAR2
104 , p1_a11 out nocopy VARCHAR2
105 , p1_a12 out nocopy NUMBER
106 , p1_a13 out nocopy VARCHAR2
107 , p1_a14 out nocopy VARCHAR2
108 , p1_a15 out nocopy VARCHAR2
109 , x_return_status out nocopy VARCHAR2
110 , x_msg_data out nocopy VARCHAR2
111 );
112 procedure get_next_sibling_node(p_imp_xml_element_id NUMBER
113 , p1_a0 out nocopy NUMBER
114 , p1_a1 out nocopy DATE
115 , p1_a2 out nocopy NUMBER
116 , p1_a3 out nocopy DATE
117 , p1_a4 out nocopy NUMBER
118 , p1_a5 out nocopy NUMBER
119 , p1_a6 out nocopy NUMBER
120 , p1_a7 out nocopy NUMBER
121 , p1_a8 out nocopy NUMBER
122 , p1_a9 out nocopy NUMBER
123 , p1_a10 out nocopy VARCHAR2
124 , p1_a11 out nocopy VARCHAR2
125 , p1_a12 out nocopy NUMBER
126 , p1_a13 out nocopy VARCHAR2
127 , p1_a14 out nocopy VARCHAR2
128 , p1_a15 out nocopy VARCHAR2
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
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
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
155 , x_msg_data out nocopy VARCHAR2
156 );
157 end ams_import_xml_pvt_w;