1: package ahl_uc_tree_pvt_w as
2: /* $Header: AHLWUCTS.pls 120.0.12010000.2 2008/11/06 10:59:33 sathapli ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
2: /* $Header: AHLWUCTS.pls 120.0.12010000.2 2008/11/06 10:59:33 sathapli ship $ */
3: procedure rosetta_table_copy_in_p1(t out nocopy ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 JTF_VARCHAR2_TABLE_100
4: , a1 JTF_NUMBER_TABLE
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
5: , a2 JTF_NUMBER_TABLE
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
6: , a3 JTF_VARCHAR2_TABLE_100
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: );
7: , a4 JTF_NUMBER_TABLE
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p1(t ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
8: , a5 JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p1(t ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16: , a1 out nocopy JTF_NUMBER_TABLE
9: , a6 JTF_VARCHAR2_TABLE_100
10: , a7 JTF_VARCHAR2_TABLE_100
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p1(t ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_NUMBER_TABLE
11: , a8 JTF_VARCHAR2_TABLE_100
12: , a9 JTF_VARCHAR2_TABLE_100
13: , a10 JTF_VARCHAR2_TABLE_100
14: );
15: procedure rosetta_table_copy_out_p1(t ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_NUMBER_TABLE
14: );
15: procedure rosetta_table_copy_out_p1(t ahl_uc_tree_pvt.uc_descendant_tbl_type, a0 out nocopy JTF_VARCHAR2_TABLE_100
16: , a1 out nocopy JTF_NUMBER_TABLE
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_VARCHAR2_TABLE_100
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
17: , a2 out nocopy JTF_NUMBER_TABLE
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_VARCHAR2_TABLE_100
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
23: , a8 out nocopy JTF_VARCHAR2_TABLE_100
24: , a9 out nocopy JTF_VARCHAR2_TABLE_100
25: , a10 out nocopy JTF_VARCHAR2_TABLE_100
18: , a3 out nocopy JTF_VARCHAR2_TABLE_100
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_VARCHAR2_TABLE_100
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
23: , a8 out nocopy JTF_VARCHAR2_TABLE_100
24: , a9 out nocopy JTF_VARCHAR2_TABLE_100
25: , a10 out nocopy JTF_VARCHAR2_TABLE_100
26: );
19: , a4 out nocopy JTF_NUMBER_TABLE
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_VARCHAR2_TABLE_100
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
23: , a8 out nocopy JTF_VARCHAR2_TABLE_100
24: , a9 out nocopy JTF_VARCHAR2_TABLE_100
25: , a10 out nocopy JTF_VARCHAR2_TABLE_100
26: );
27:
20: , a5 out nocopy JTF_NUMBER_TABLE
21: , a6 out nocopy JTF_VARCHAR2_TABLE_100
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
23: , a8 out nocopy JTF_VARCHAR2_TABLE_100
24: , a9 out nocopy JTF_VARCHAR2_TABLE_100
25: , a10 out nocopy JTF_VARCHAR2_TABLE_100
26: );
27:
28: procedure get_whole_uc_tree(p_api_version NUMBER
21: , a6 out nocopy JTF_VARCHAR2_TABLE_100
22: , a7 out nocopy JTF_VARCHAR2_TABLE_100
23: , a8 out nocopy JTF_VARCHAR2_TABLE_100
24: , a9 out nocopy JTF_VARCHAR2_TABLE_100
25: , a10 out nocopy JTF_VARCHAR2_TABLE_100
26: );
27:
28: procedure get_whole_uc_tree(p_api_version NUMBER
29: , p_init_msg_list VARCHAR2
31: , x_return_status out nocopy VARCHAR2
32: , x_msg_count out nocopy NUMBER
33: , x_msg_data out nocopy VARCHAR2
34: , p_uc_header_id NUMBER
35: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
36: , p7_a1 out nocopy JTF_NUMBER_TABLE
37: , p7_a2 out nocopy JTF_NUMBER_TABLE
38: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , p7_a4 out nocopy JTF_NUMBER_TABLE
34: , p_uc_header_id NUMBER
35: , p7_a0 out nocopy JTF_VARCHAR2_TABLE_100
36: , p7_a1 out nocopy JTF_NUMBER_TABLE
37: , p7_a2 out nocopy JTF_NUMBER_TABLE
38: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , p7_a4 out nocopy JTF_NUMBER_TABLE
40: , p7_a5 out nocopy JTF_NUMBER_TABLE
41: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
42: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
37: , p7_a2 out nocopy JTF_NUMBER_TABLE
38: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , p7_a4 out nocopy JTF_NUMBER_TABLE
40: , p7_a5 out nocopy JTF_NUMBER_TABLE
41: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
42: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
43: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
44: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
45: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
38: , p7_a3 out nocopy JTF_VARCHAR2_TABLE_100
39: , p7_a4 out nocopy JTF_NUMBER_TABLE
40: , p7_a5 out nocopy JTF_NUMBER_TABLE
41: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
42: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
43: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
44: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
45: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
46: );
39: , p7_a4 out nocopy JTF_NUMBER_TABLE
40: , p7_a5 out nocopy JTF_NUMBER_TABLE
41: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
42: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
43: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
44: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
45: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
46: );
47: end ahl_uc_tree_pvt_w;
40: , p7_a5 out nocopy JTF_NUMBER_TABLE
41: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
42: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
43: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
44: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
45: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
46: );
47: end ahl_uc_tree_pvt_w;
41: , p7_a6 out nocopy JTF_VARCHAR2_TABLE_100
42: , p7_a7 out nocopy JTF_VARCHAR2_TABLE_100
43: , p7_a8 out nocopy JTF_VARCHAR2_TABLE_100
44: , p7_a9 out nocopy JTF_VARCHAR2_TABLE_100
45: , p7_a10 out nocopy JTF_VARCHAR2_TABLE_100
46: );
47: end ahl_uc_tree_pvt_w;