1 PACKAGE HZ_MIXNM_WEBUI_UTILITY AUTHID CURRENT_USER AS
2 /*$Header: ARHXWUTS.pls 120.2 2005/01/20 16:05:41 dmmehta noship $ */
3
4 TYPE IDList IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5 TYPE VARCHARList IS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER;
6
7 /**
8 * PROCEDURE Create_Rule
9 *
10 * DESCRIPTION
11 * Create an user creation / overwrite rule.
12 *
13 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
14 *
15 * ARGUMENTS
16 * IN:
17 * p_rule_type Rule type. 'USER_CREATE_RULE' is for user create rule.
18 * 'USER_OVERWRITE_RULE is for user overwrite rule.
19 * p_rule_name Rule name.
20 * p_entity_attr_id_tab Entity / attribute id list.
21 * p_attribute_group_name_tab A list of attribute group name.
22 * p_flag_tab A list of creation / overwrite flags for each
23 * entity / attribute.
24 * IN/OUT:
25 * p_rule_id Rule id.
26 *
27 * NOTES
28 *
29 * MODIFICATION HISTORY
30 *
31 * 03-01-2002 Jianying Huang o Created.
32 */
33
34 PROCEDURE Create_Rule (
35 p_rule_type IN VARCHAR2,
36 p_rule_id IN OUT NOCOPY NUMBER,
37 p_rule_name IN VARCHAR2,
38 p_entity_attr_id_tab IN IDList,
39 p_attribute_group_name_tab IN VARCHARList,
40 p_flag_tab IN VARCHARList,
41 p_os_tab IN VARCHARList
42 );
43
44 /**
45 * PROCEDURE Update_Rule
46 *
47 * DESCRIPTION
48 * Update an user creation / overwrite rule.
49 *
50 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
51 *
52 * ARGUMENTS
53 * IN:
54 * p_rule_type Rule type. 'USER_CREATE_RULE' is for user create rule.
55 * 'USER_OVERWRITE_RULE is for user overwrite rule.
56 * p_rule_id Rule id.
57 * p_rule_name Rule name.
58 * p_entity_attr_id_tab Entity / attribute id list.
59 * p_attribute_group_name_tab A list of attribute group name.
60 * p_flag_tab A list of creation / overwrite flags for each
61 * entity / attribute.
62 *
63 * NOTES
64 *
65 * MODIFICATION HISTORY
66 *
67 * 03-01-2002 Jianying Huang o Created.
68 */
69
70 PROCEDURE Update_Rule (
71 p_rule_type IN VARCHAR2,
72 p_rule_id IN NUMBER,
73 p_rule_name IN VARCHAR2,
74 p_entity_attr_id_tab IN IDList,
75 p_attribute_group_name_tab IN VARCHARList,
76 p_flag_tab IN VARCHARList,
77 p_os_tab IN VARCHARList
78 );
79
80 /**
81 * PROCEDURE Copy_Rule
82 *
83 * DESCRIPTION
84 * Copy an user creation / overwrite rule.
85 *
86 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
87 *
88 * ARGUMENTS
89 * IN:
90 * p_rule_type Rule type. 'USER_CREATE_RULE' is for user create rule.
91 * 'USER_OVERWRITE_RULE is for user overwrite rule.
92 * p_rule_id Rule id.
93 * p_rule_name Rule name.
94 * OUT:
95 * x_new_rule_id New rule id.
96 *
97 * NOTES
98 *
99 * MODIFICATION HISTORY
100 *
101 * 03-01-2002 Jianying Huang o Created.
102 */
103
104 PROCEDURE Copy_Rule (
105 p_rule_type IN VARCHAR2,
106 p_rule_id IN NUMBER,
107 p_rule_name IN VARCHAR2,
108 x_new_rule_id OUT NOCOPY NUMBER
109 );
110
111 /**
112 * PROCEDURE Delete_Rule
113 *
114 * DESCRIPTION
115 * Delete an user creation / overwrite rule.
116 *
117 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
118 *
119 * ARGUMENTS
120 * IN:
121 * p_rule_type Rule type. 'USER_CREATE_RULE' is for user create rule.
122 * 'USER_OVERWRITE_RULE is for user overwrite rule.
123 * p_rule_id Rule id.
124 *
125 * NOTES
126 *
127 * MODIFICATION HISTORY
128 *
129 * 03-01-2002 Jianying Huang o Created.
130 */
131
132 PROCEDURE Delete_Rule (
133 p_rule_type IN VARCHAR2,
134 p_rule_id IN NUMBER
135 );
136
137
138 /**
139 * PROCEDURE Update_ThirdPartyRule
140 *
141 * DESCRIPTION
142 * Update the third party rule.
143 *
144 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
145 *
146 * ARGUMENTS
147 * IN:
148 * p_rule_exists 'Y'/'N' indicator to indicate if the rule
149 * p_entity_attr_id_tab Entity / attribute id list.
150 * p_attribute_group_name_tab A list of attribute group name.
151 * p_flag_tab A list of overwrite flags for each attribute.
152 *
153 * NOTES
154 *
155 * MODIFICATION HISTORY
156 *
157 * 03-01-2002 Jianying Huang o Created.
158 */
159
160 PROCEDURE Update_ThirdPartyRule (
161 p_rule_exists IN VARCHAR2,
162 p_entity_attr_id_tab IN IDList,
163 p_attribute_group_name_tab IN VARCHARList,
164 p_flag_tab IN VARCHARList,
165 p_os_tab IN VARCHARList
166 );
167
168 /**
169 * PROCEDURE Set_DataSources
170 *
171 * DESCRIPTION
172 * Set the data sources for a list of attributes.
173 *
174 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
175 *
176 * ARGUMENTS
177 * IN:
178 * p_entity_attr_id_tab Entity / attribute id list.
179 * p_attribute_group_name_tab A list of attribute group name.
180 * p_range_tab The index range of each attribute.
181 * p_data_sources_tab The list of data sources for each attributes.
182 * p_ranking_tab The list of data sources ranking for each attributes.
183 *
184 * NOTES
185 *
186 * MODIFICATION HISTORY
187 *
188 * 03-01-2002 Jianying Huang o Created.
189 */
190
191 PROCEDURE Set_DataSources (
192 p_entity_attr_id_tab IN IDList,
193 p_attribute_group_name_tab IN VARCHARList,
194 p_range_tab IN IDList,
195 p_data_sources_tab IN VARCHARList,
196 p_ranking_tab IN IDList
197 );
198
199 /**
200 * PROCEDURE Get_DataSourcesForAGroup
201 *
202 * DESCRIPTION
203 * Get the data source setup for a group of attributes.
204 *
205 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
206 *
207 * ARGUMENTS
208 * IN:
209 * p_entity_type Entity type.
210 * p_entity_attr_id_tab Entity / attribute id list.
211 * x_has_same_setup 'Y'/'N' indicator for if the attributes have
212 * the same data source setup.
213 * x_data_sources_tab The list of data sources meaning for all of the attributes.
214 * x_meaning_tab The list of data sources for all of the attributes.
215 * x_ranking_tab The list of data sources ranking for all of the attributes.
216 *
217 * NOTES
218 *
219 * MODIFICATION HISTORY
220 *
221 * 03-01-2002 Jianying Huang o Created.
222 */
223
224 PROCEDURE Get_DataSourcesForAGroup (
225 p_entity_type IN VARCHAR2,
226 p_entity_attr_id_tab IN IDList,
227 x_has_same_setup OUT NOCOPY VARCHAR2,
228 x_data_sources_tab OUT NOCOPY VARCHARList,
229 x_meaning_tab OUT NOCOPY VARCHARList,
230 x_ranking_tab OUT NOCOPY IDList
231 );
232
233 /**
234 * PROCEDURE Set_DataSourcesForAGroup
235 *
236 * DESCRIPTION
237 * Set the data sources for a list of attributes.
238 *
239 * EXTERNAL PROCEDURES/FUNCTIONS ACCESSED
240 *
241 * ARGUMENTS
242 * IN:
243 * p_entity_attr_id_tab Entity / attribute id list.
244 * p_attribute_group_name_tab A list of attribute group name.
245 * p_data_sources_tab The list of data sources for each attributes.
246 * p_ranking_tab The list of data sources ranking for each attributes.
247 *
248 * NOTES
249 *
250 * MODIFICATION HISTORY
251 *
252 * 03-01-2002 Jianying Huang o Created.
253 */
254
255 PROCEDURE Set_DataSourcesForAGroup (
256 p_entity_attr_id_tab IN IDList,
257 p_attribute_group_name_tab IN VARCHARList,
258 p_data_sources_tab IN VARCHARList,
259 p_ranking_tab IN IDList
260 );
261
262 END HZ_MIXNM_WEBUI_UTILITY;