1 PACKAGE RRS_HIERARCHY_INFO AUTHID CURRENT_USER AS
2 /* $Header: RRSGHDTS.pls 120.4 2011/03/03 21:44:35 sunarang noship $ */
3
4
5 G_RET_STS_SUCCESS CONSTANT VARCHAR2(1):='S';
6 G_RET_STS_ERROR CONSTANT VARCHAR2(1):='E';
7 G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1):='U';
8 G_RET_STS_WARNING CONSTANT VARCHAR2(1):='W';
9
10 e_no_hierarchy_found EXCEPTION;
11 e_no_parent_member_found EXCEPTION;
12
13
14 ------------------------
15 --Get Hierarchy Header--
16 ------------------------
17
18 Procedure Get_Hierarchy_Header(
19 p_api_version IN number
20 ,p_hier_version_id IN number
21 ,x_hier_header_rec OUT NOCOPY rrs_hier_header_rec
22 ,x_return_status OUT NOCOPY varchar2
23 ,x_msg_count OUT NOCOPY number
24 ,x_msg_data OUT NOCOPY varchar2
25 );
26
27 Procedure Get_Hierarchy_Header(
28 p_api_version IN number
29 ,p_hier_id IN number
30 ,p_hier_version_number IN number
31 ,x_hier_header_rec OUT NOCOPY rrs_hier_header_rec
32 ,x_return_status OUT NOCOPY varchar2
33 ,x_msg_count OUT NOCOPY number
34 ,x_msg_data OUT NOCOPY varchar2
35 );
36
37 Procedure Get_Hierarchy_Header(
38 p_api_version IN number
39 ,p_hier_name IN varchar2
40 ,x_hier_header_rec OUT NOCOPY rrs_hier_header_rec
41 ,x_return_status OUT NOCOPY varchar2
42 ,x_msg_count OUT NOCOPY number
43 ,x_msg_data OUT NOCOPY varchar2
44 );
45
46 -------------------------
47 --Get Hierarchy Members--
48 -------------------------
49
50 Procedure Get_Hierarchy_Members(
51 p_api_version IN number
52 ,p_hier_version_id IN number
53 ,p_parent_member_type IN varchar2
54 ,p_parent_member_id_num IN varchar2
55 ,x_hier_members_tab OUT NOCOPY rrs_hier_members_tab
56 ,x_return_status OUT NOCOPY varchar2
57 ,x_msg_count OUT NOCOPY number
58 ,x_msg_data OUT NOCOPY varchar2
59 );
60
61 Procedure Get_Hierarchy_Members(
62 p_api_version IN number
63 ,p_hier_id IN number
64 ,p_hier_version_number IN number
65 ,p_parent_member_type IN varchar2
66 ,p_parent_member_id_num IN varchar2
67 ,x_hier_members_tab OUT NOCOPY rrs_hier_members_tab
68 ,x_return_status OUT NOCOPY varchar2
69 ,x_msg_count OUT NOCOPY number
70 ,x_msg_data OUT NOCOPY varchar2
71 );
72
73 Procedure Get_Hierarchy_Members(
74 p_api_version IN number
75 ,p_hier_name IN varchar2
76 ,p_hier_version_number IN number
77 ,p_parent_member_type IN varchar2
78 ,p_parent_member_id_num IN varchar2
79 ,x_hier_members_tab OUT NOCOPY rrs_hier_members_tab
80 ,x_return_status OUT NOCOPY varchar2
81 ,x_msg_count OUT NOCOPY number
82 ,x_msg_data OUT NOCOPY varchar2
83 );
84
85 ----------------------------
86 --Get Hierarchy Attributes--
87 ----------------------------
88
89 Procedure Get_Hierarchy_Attributes(
90 p_api_version IN number
91 ,p_hier_version_id IN number
92 ,p_page_name IN varchar2
93 ,x_hier_attr_row_tab OUT NOCOPY ego_user_attr_row_table
94 ,x_hier_attr_data_tab OUT NOCOPY ego_user_attr_data_table
95 ,x_return_status OUT NOCOPY varchar2
96 ,x_msg_count OUT NOCOPY number
97 ,x_msg_data OUT NOCOPY varchar2
98 );
99
100 Procedure Get_Hierarchy_Attributes(
101 p_api_version IN number
102 ,p_hier_id IN number
103 ,p_hier_version_number IN number
104 ,p_page_name IN varchar2
105 ,x_hier_attr_row_tab OUT NOCOPY ego_user_attr_row_table
106 ,x_hier_attr_data_tab OUT NOCOPY ego_user_attr_data_table
107 ,x_return_status OUT NOCOPY varchar2
108 ,x_msg_count OUT NOCOPY number
109 ,x_msg_data OUT NOCOPY varchar2
110 );
111
112 Procedure Get_Hierarchy_Attributes(
113 p_api_version IN number
114 ,p_hier_name IN varchar2
115 ,p_hier_version_number IN number
116 ,p_page_name IN varchar2
117 ,x_hier_attr_row_tab OUT NOCOPY ego_user_attr_row_table
118 ,x_hier_attr_data_tab OUT NOCOPY ego_user_attr_data_table
119 ,x_return_status OUT NOCOPY varchar2
120 ,x_msg_count OUT NOCOPY number
121 ,x_msg_data OUT NOCOPY varchar2
122 );
123
124 ----------------------------------
125 --Get Hierarchy Complete Details--
126 ----------------------------------
127
128 Procedure Get_Complete_Hierarchy_Details(
129 p_api_version IN number
130 ,p_hier_version_id IN number
131 ,p_page_name IN varchar2
132 ,x_hier_header_rec OUT NOCOPY rrs_hier_header_rec
133 ,x_hier_members_tab OUT NOCOPY rrs_hier_members_tab
134 ,x_hier_attr_row_tab OUT NOCOPY ego_user_attr_row_table
135 ,x_hier_attr_data_tab OUT NOCOPY ego_user_attr_data_table
136 ,x_return_status OUT NOCOPY varchar2
137 ,x_msg_count OUT NOCOPY number
138 ,x_msg_data OUT NOCOPY varchar2
139 );
140
141 Procedure Get_Complete_Hierarchy_Details(
142 p_api_version IN number
143 ,p_hier_id IN number
144 ,p_hier_version_number IN number
145 ,p_page_name IN varchar2
146 ,x_hier_header_rec OUT NOCOPY rrs_hier_header_rec
147 ,x_hier_members_tab OUT NOCOPY rrs_hier_members_tab
148 ,x_hier_attr_row_tab OUT NOCOPY ego_user_attr_row_table
149 ,x_hier_attr_data_tab OUT NOCOPY ego_user_attr_data_table
150 ,x_return_status OUT NOCOPY varchar2
151 ,x_msg_count OUT NOCOPY number
152 ,x_msg_data OUT NOCOPY varchar2
153 );
154
155 Procedure Get_Complete_Hierarchy_Details(
156 p_api_version IN number
157 ,p_hier_name IN varchar2
158 ,p_hier_version_number IN number
159 ,p_page_name IN varchar2
160 ,x_hier_header_rec OUT NOCOPY rrs_hier_header_rec
161 ,x_hier_members_tab OUT NOCOPY rrs_hier_members_tab
162 ,x_hier_attr_row_tab OUT NOCOPY ego_user_attr_row_table
163 ,x_hier_attr_data_tab OUT NOCOPY ego_user_attr_data_table
164 ,x_return_status OUT NOCOPY varchar2
165 ,x_msg_count OUT NOCOPY number
166 ,x_msg_data OUT NOCOPY varchar2
167 );
168
169
170 /**
171 ** Test Methods
172 **
173 *
174 Procedure Get_Hierarchy_Header_Test;
175 Procedure Get_Hierarchy_Members_Test;
176 Procedure Get_Hierarchy_Attributes_Test;
177 Procedure Get_Comp_Hier_Details_Test;
178 */
179
180 END RRS_HIERARCHY_INFO;