DBA Data[Home] [Help]

APPS.AMS_IMPORT_XML_PVT_W dependencies on JTF_NUMBER_TABLE

Line 3: procedure rosetta_table_copy_in_p0(t out nocopy ams_import_xml_pvt.xml_element_key_set_type, a0 JTF_NUMBER_TABLE);

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);

Line 4: procedure rosetta_table_copy_out_p0(t ams_import_xml_pvt.xml_element_key_set_type, a0 out nocopy JTF_NUMBER_TABLE);

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:

Line 12: procedure rosetta_table_copy_in_p3(t out nocopy ams_import_xml_pvt.xml_element_set_type, a0 JTF_NUMBER_TABLE

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

Line 14: , a2 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

Line 16: , a4 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

Line 17: , a5 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

Line 18: , a6 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

Line 19: , a7 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

Line 20: , a8 JTF_NUMBER_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

Line 21: , a9 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

Line 24: , a12 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: );

Line 29: procedure rosetta_table_copy_out_p3(t ams_import_xml_pvt.xml_element_set_type, a0 out nocopy 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

Line 31: , a2 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

Line 33: , a4 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

Line 34: , a5 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

Line 35: , a6 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

Line 36: , a7 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

Line 37: , a8 out nocopy JTF_NUMBER_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

Line 38: , a9 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

Line 41: , a12 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: );

Line 133: , x_child_ids out nocopy JTF_NUMBER_TABLE

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

Line 138: , p1_a0 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

Line 140: , p1_a2 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

Line 142: , p1_a4 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

Line 143: , p1_a5 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

Line 144: , p1_a6 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

Line 145: , p1_a7 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

Line 146: , p1_a8 out nocopy JTF_NUMBER_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

Line 147: , p1_a9 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

Line 150: , p1_a12 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