[Home] [Help]
PACKAGE: APPS.AHL_MC_TREE_PVT_W
Source
1 package ahl_mc_tree_pvt_w as
2 /* $Header: AHLWMCTS.pls 120.2 2005/07/30 06:32 tamdas noship $ */
3 procedure rosetta_table_copy_in_p2(t out nocopy ahl_mc_tree_pvt.tree_node_tbl_type, a0 JTF_NUMBER_TABLE
4 , a1 JTF_NUMBER_TABLE
5 , a2 JTF_NUMBER_TABLE
6 , a3 JTF_NUMBER_TABLE
7 , a4 JTF_NUMBER_TABLE
8 , a5 JTF_VARCHAR2_TABLE_100
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 , a11 JTF_VARCHAR2_TABLE_100
15 , a12 JTF_NUMBER_TABLE
16 , a13 JTF_NUMBER_TABLE
17 , a14 JTF_DATE_TABLE
18 , a15 JTF_DATE_TABLE
19 , a16 JTF_NUMBER_TABLE
20 , a17 JTF_VARCHAR2_TABLE_100
21 , a18 JTF_VARCHAR2_TABLE_100
22 , a19 JTF_VARCHAR2_TABLE_100
23 , a20 JTF_VARCHAR2_TABLE_100
24 , a21 JTF_VARCHAR2_TABLE_4000
25 , a22 JTF_NUMBER_TABLE
26 , a23 JTF_NUMBER_TABLE
27 , a24 JTF_NUMBER_TABLE
28 , a25 JTF_NUMBER_TABLE
29 , a26 JTF_VARCHAR2_TABLE_100
30 );
31 procedure rosetta_table_copy_out_p2(t ahl_mc_tree_pvt.tree_node_tbl_type, a0 out nocopy JTF_NUMBER_TABLE
32 , a1 out nocopy JTF_NUMBER_TABLE
33 , a2 out nocopy JTF_NUMBER_TABLE
34 , a3 out nocopy JTF_NUMBER_TABLE
35 , a4 out nocopy JTF_NUMBER_TABLE
36 , a5 out nocopy JTF_VARCHAR2_TABLE_100
37 , a6 out nocopy JTF_VARCHAR2_TABLE_100
38 , a7 out nocopy JTF_VARCHAR2_TABLE_100
39 , a8 out nocopy JTF_VARCHAR2_TABLE_100
40 , a9 out nocopy JTF_VARCHAR2_TABLE_100
41 , a10 out nocopy JTF_VARCHAR2_TABLE_100
42 , a11 out nocopy JTF_VARCHAR2_TABLE_100
43 , a12 out nocopy JTF_NUMBER_TABLE
44 , a13 out nocopy JTF_NUMBER_TABLE
45 , a14 out nocopy JTF_DATE_TABLE
46 , a15 out nocopy JTF_DATE_TABLE
47 , a16 out nocopy JTF_NUMBER_TABLE
48 , a17 out nocopy JTF_VARCHAR2_TABLE_100
49 , a18 out nocopy JTF_VARCHAR2_TABLE_100
50 , a19 out nocopy JTF_VARCHAR2_TABLE_100
51 , a20 out nocopy JTF_VARCHAR2_TABLE_100
52 , a21 out nocopy JTF_VARCHAR2_TABLE_4000
53 , a22 out nocopy JTF_NUMBER_TABLE
54 , a23 out nocopy JTF_NUMBER_TABLE
55 , a24 out nocopy JTF_NUMBER_TABLE
56 , a25 out nocopy JTF_NUMBER_TABLE
57 , a26 out nocopy JTF_VARCHAR2_TABLE_100
58 );
59
60 procedure get_masterconfig_nodes(p_api_version NUMBER
61 , x_return_status out nocopy VARCHAR2
62 , x_msg_count out nocopy NUMBER
63 , x_msg_data out nocopy VARCHAR2
64 , p_mc_header_id NUMBER
65 , p_parent_rel_id NUMBER
66 , p_is_parent_subconfig VARCHAR2
67 , p_parent_pos_path VARCHAR2
68 , p_is_top_config_node VARCHAR2
69 , p_is_sub_config_node VARCHAR2
70 , p10_a0 out nocopy JTF_NUMBER_TABLE
71 , p10_a1 out nocopy JTF_NUMBER_TABLE
72 , p10_a2 out nocopy JTF_NUMBER_TABLE
73 , p10_a3 out nocopy JTF_NUMBER_TABLE
74 , p10_a4 out nocopy JTF_NUMBER_TABLE
75 , p10_a5 out nocopy JTF_VARCHAR2_TABLE_100
76 , p10_a6 out nocopy JTF_VARCHAR2_TABLE_100
77 , p10_a7 out nocopy JTF_VARCHAR2_TABLE_100
78 , p10_a8 out nocopy JTF_VARCHAR2_TABLE_100
79 , p10_a9 out nocopy JTF_VARCHAR2_TABLE_100
80 , p10_a10 out nocopy JTF_VARCHAR2_TABLE_100
81 , p10_a11 out nocopy JTF_VARCHAR2_TABLE_100
82 , p10_a12 out nocopy JTF_NUMBER_TABLE
83 , p10_a13 out nocopy JTF_NUMBER_TABLE
84 , p10_a14 out nocopy JTF_DATE_TABLE
85 , p10_a15 out nocopy JTF_DATE_TABLE
86 , p10_a16 out nocopy JTF_NUMBER_TABLE
87 , p10_a17 out nocopy JTF_VARCHAR2_TABLE_100
88 , p10_a18 out nocopy JTF_VARCHAR2_TABLE_100
89 , p10_a19 out nocopy JTF_VARCHAR2_TABLE_100
90 , p10_a20 out nocopy JTF_VARCHAR2_TABLE_100
91 , p10_a21 out nocopy JTF_VARCHAR2_TABLE_4000
92 , p10_a22 out nocopy JTF_NUMBER_TABLE
93 , p10_a23 out nocopy JTF_NUMBER_TABLE
94 , p10_a24 out nocopy JTF_NUMBER_TABLE
95 , p10_a25 out nocopy JTF_NUMBER_TABLE
96 , p10_a26 out nocopy JTF_VARCHAR2_TABLE_100
97 );
98 end ahl_mc_tree_pvt_w;