[Home] [Help]
PACKAGE BODY: APPS.EGO_USER_ATTRS_DATA_PUB
Source
1 PACKAGE BODY EGO_USER_ATTRS_DATA_PUB AS
2 /* $Header: EGOPEFBB.pls 120.4 2007/05/02 18:26:31 ssarnoba ship $ */
3
4
5
6 ----------------
7 -- Procedures --
8 ----------------
9
10 PROCEDURE Process_User_Attrs_Data (
11 p_api_version IN NUMBER
12 ,p_object_name IN VARCHAR2
13 ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
14 ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
15 ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
16 ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
17 ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
18 ,p_entity_id IN NUMBER DEFAULT NULL
19 ,p_entity_index IN NUMBER DEFAULT NULL
20 ,p_entity_code IN VARCHAR2 DEFAULT NULL
21 ,p_debug_level IN NUMBER DEFAULT 0
22 ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
23 ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
24 ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
25 ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
26 ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
27 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
28 ,x_failed_row_id_list OUT NOCOPY VARCHAR2
29 ,x_return_status OUT NOCOPY VARCHAR2
30 ,x_errorcode OUT NOCOPY NUMBER
31 ,x_msg_count OUT NOCOPY NUMBER
32 ,x_msg_data OUT NOCOPY VARCHAR2
33 ) IS
34
35 BEGIN
36
37 EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data
38 (
39 p_api_version => p_api_version
40 ,p_object_name => p_object_name
41 ,p_attributes_row_table => p_attributes_row_table
42 ,p_attributes_data_table => p_attributes_data_table
43 ,p_pk_column_name_value_pairs => p_pk_column_name_value_pairs
44 ,p_class_code_name_value_pairs => p_class_code_name_value_pairs
45 ,p_user_privileges_on_object => p_user_privileges_on_object
46 ,p_entity_id => p_entity_id
47 ,p_entity_index => p_entity_index
48 ,p_entity_code => p_entity_code
49 ,p_debug_level => p_debug_level
50 ,p_init_error_handler => p_init_error_handler
51 ,p_write_to_concurrent_log => p_write_to_concurrent_log
52 ,p_init_fnd_msg_list => p_init_fnd_msg_list
53 ,p_log_errors => p_log_errors
54 ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
55 ,p_commit => p_commit
56 ,x_failed_row_id_list => x_failed_row_id_list
57 ,x_return_status => x_return_status
58 ,x_errorcode => x_errorcode
59 ,x_msg_count => x_msg_count
60 ,x_msg_data => x_msg_data
61 );
62
63 END Process_User_Attrs_Data;
64
65 /* Overload method with additional parameters x_extension_id, x_mode */
66
67 PROCEDURE Process_User_Attrs_Data (
68 p_api_version IN NUMBER
69 ,p_object_name IN VARCHAR2
70 ,p_attributes_row_table IN EGO_USER_ATTR_ROW_TABLE
71 ,p_attributes_data_table IN EGO_USER_ATTR_DATA_TABLE
72 ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
73 ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
74 ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
75 ,p_entity_id IN NUMBER DEFAULT NULL
76 ,p_entity_index IN NUMBER DEFAULT NULL
77 ,p_entity_code IN VARCHAR2 DEFAULT NULL
78 ,p_debug_level IN NUMBER DEFAULT 0
79 ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
80 ,p_write_to_concurrent_log IN VARCHAR2 DEFAULT FND_API.G_FALSE
81 ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
82 ,p_log_errors IN VARCHAR2 DEFAULT FND_API.G_FALSE
83 ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
84 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
85 ,x_extension_id OUT NOCOPY NUMBER
86 ,x_mode OUT NOCOPY VARCHAR2
87 ,x_failed_row_id_list OUT NOCOPY VARCHAR2
88 ,x_return_status OUT NOCOPY VARCHAR2
89 ,x_errorcode OUT NOCOPY NUMBER
90 ,x_msg_count OUT NOCOPY NUMBER
91 ,x_msg_data OUT NOCOPY VARCHAR2
92 ) IS
93 BEGIN
94
95 EGO_USER_ATTRS_DATA_PVT.Process_User_Attrs_Data
96 (
97 p_api_version => p_api_version
98 ,p_object_name => p_object_name
99 ,p_attributes_row_table => p_attributes_row_table
100 ,p_attributes_data_table => p_attributes_data_table
101 ,p_pk_column_name_value_pairs => p_pk_column_name_value_pairs
102 ,p_class_code_name_value_pairs => p_class_code_name_value_pairs
103 ,p_user_privileges_on_object => p_user_privileges_on_object
104 ,p_entity_id => p_entity_id
105 ,p_entity_index => p_entity_index
106 ,p_entity_code => p_entity_code
107 ,p_debug_level => p_debug_level
108 ,p_init_error_handler => p_init_error_handler
109 ,p_write_to_concurrent_log => p_write_to_concurrent_log
110 ,p_init_fnd_msg_list => p_init_fnd_msg_list
111 ,p_log_errors => p_log_errors
112 ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
113 ,p_commit => p_commit
114 ,x_extension_id => x_extension_id
115 ,x_mode => x_mode
116 ,x_failed_row_id_list => x_failed_row_id_list
117 ,x_return_status => x_return_status
118 ,x_errorcode => x_errorcode
119 ,x_msg_count => x_msg_count
120 ,x_msg_data => x_msg_data
121 );
122
123 END Process_User_Attrs_Data;
124
125 ----------------------------------------------------------------------
126
127
128 PROCEDURE Get_User_Attrs_Data (
129 p_api_version IN NUMBER
130 ,p_object_name IN VARCHAR2
131 ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
132 ,p_attr_group_request_table IN EGO_ATTR_GROUP_REQUEST_TABLE
133 ,p_user_privileges_on_object IN EGO_VARCHAR_TBL_TYPE DEFAULT NULL
134 ,p_entity_id IN VARCHAR2 DEFAULT NULL
135 ,p_entity_index IN NUMBER DEFAULT NULL
136 ,p_entity_code IN VARCHAR2 DEFAULT NULL
137 ,p_debug_level IN NUMBER DEFAULT 0
138 ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
139 ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
140 ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
141 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
142 ,x_attributes_row_table OUT NOCOPY EGO_USER_ATTR_ROW_TABLE
143 ,x_attributes_data_table OUT NOCOPY EGO_USER_ATTR_DATA_TABLE
144 ,x_return_status OUT NOCOPY VARCHAR2
145 ,x_errorcode OUT NOCOPY NUMBER
146 ,x_msg_count OUT NOCOPY NUMBER
147 ,x_msg_data OUT NOCOPY VARCHAR2
148 ) IS
149
150 BEGIN
151
152 EGO_USER_ATTRS_DATA_PVT.Get_User_Attrs_Data
153 (
154 p_api_version => p_api_version
155 ,p_object_name => p_object_name
156 ,p_pk_column_name_value_pairs => p_pk_column_name_value_pairs
157 ,p_attr_group_request_table => p_attr_group_request_table
158 ,p_user_privileges_on_object => p_user_privileges_on_object
159 ,p_entity_id => p_entity_id
160 ,p_entity_index => p_entity_index
161 ,p_entity_code => p_entity_code
162 ,p_debug_level => p_debug_level
163 ,p_init_error_handler => p_init_error_handler
164 ,p_init_fnd_msg_list => p_init_fnd_msg_list
165 ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
166 ,p_commit => p_commit
167 ,x_attributes_row_table => x_attributes_row_table
168 ,x_attributes_data_table => x_attributes_data_table
169 ,x_return_status => x_return_status
170 ,x_errorcode => x_errorcode
171 ,x_msg_count => x_msg_count
172 ,x_msg_data => x_msg_data
173 );
174
175 END Get_User_Attrs_Data;
176
177 ----------------------------------------------------------------------
178
179 PROCEDURE Copy_User_Attrs_Data (
180 p_api_version IN NUMBER
181 ,p_application_id IN NUMBER
182 ,p_object_id IN NUMBER DEFAULT NULL
183 ,p_object_name IN VARCHAR2 DEFAULT NULL
184 ,p_old_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
185 ,p_old_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
186 ,p_new_pk_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
187 ,p_new_dtlevel_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
188 ,p_new_cc_col_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY DEFAULT NULL
189 ,p_init_error_handler IN VARCHAR2 DEFAULT FND_API.G_FALSE
190 ,p_init_fnd_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
191 ,p_add_errors_to_fnd_stack IN VARCHAR2 DEFAULT FND_API.G_FALSE
192 ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
193 ,x_return_status OUT NOCOPY VARCHAR2
194 ,x_errorcode OUT NOCOPY NUMBER
195 ,x_msg_count OUT NOCOPY NUMBER
196 ,x_msg_data OUT NOCOPY VARCHAR2
197 ) IS
198
199 BEGIN
200
201 EGO_USER_ATTRS_DATA_PVT.Copy_User_Attrs_Data
202 (
203 p_api_version => p_api_version
204 ,p_application_id => p_application_id
205 ,p_object_id => p_object_id
206 ,p_object_name => p_object_name
207 ,p_old_pk_col_value_pairs => p_old_pk_col_value_pairs
208 ,p_old_dtlevel_col_value_pairs => p_old_dtlevel_col_value_pairs
209 ,p_new_pk_col_value_pairs => p_new_pk_col_value_pairs
210 ,p_new_dtlevel_col_value_pairs => p_new_dtlevel_col_value_pairs
211 ,p_init_error_handler => p_init_error_handler
212 ,p_init_fnd_msg_list => p_init_fnd_msg_list
213 ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
214 ,p_commit => p_commit
215 ,x_return_status => x_return_status
216 ,x_errorcode => x_errorcode
217 ,x_msg_count => x_msg_count
218 ,x_msg_data => x_msg_data
219 );
220
221 END Copy_User_Attrs_Data;
222
223 PROCEDURE Validate_Required_Attrs (
224 p_api_version IN NUMBER
225 ,p_object_name IN VARCHAR2
226 -- FND_OBJECTS.OBJECT_NAME
227 ,p_pk_column_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
228 -- Attr values to be validated
229 ,p_class_code_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
230 ,p_data_level_name IN EGO_DATA_LEVEL_B.DATA_LEVEL_NAME%TYPE := NULL
231 ,p_data_level_name_value_pairs IN EGO_COL_NAME_VALUE_PAIR_ARRAY
232 ,p_attr_group_type_table IN EGO_VARCHAR_TBL_TYPE
233 -- FND_DESCRIPTIVE_FLEXS.APPLICATION_TABLE_NAME
234 ,p_entity_id IN NUMBER
235 ,p_entity_index IN NUMBER
236 ,p_entity_code IN VARCHAR2
237 ,p_debug_level IN NUMBER
238 ,p_init_error_handler IN VARCHAR2
239 ,p_write_to_concurrent_log IN VARCHAR2
240 ,p_init_fnd_msg_list IN VARCHAR2
241 ,p_log_errors IN VARCHAR2
242 ,p_add_errors_to_fnd_stack IN VARCHAR2
243 ,x_attributes_req_table OUT NOCOPY EGO_USER_ATTR_TABLE
244 ,x_return_status OUT NOCOPY VARCHAR2
245 ,x_errorcode OUT NOCOPY NUMBER
246 ,x_msg_count OUT NOCOPY NUMBER
247 ,x_msg_data OUT NOCOPY VARCHAR2
248 ) IS
249 BEGIN
250
251 EGO_USER_ATTRS_DATA_PVT.Validate_Required_Attrs
252 (
253 p_api_version => p_api_version
254 ,p_object_name => p_object_name
255 ,p_pk_column_name_value_pairs => p_pk_column_name_value_pairs
256 ,p_class_code_name_value_pairs => p_class_code_name_value_pairs
257 ,p_data_level_name => p_data_level_name
258 ,p_data_level_name_value_pairs => p_data_level_name_value_pairs
259 ,p_attr_group_type_table => p_attr_group_type_table
260 ,p_entity_id => p_entity_id
261 ,p_entity_index => p_entity_index
262 ,p_entity_code => p_entity_code
263 ,p_debug_level => p_debug_level
264 ,p_init_error_handler => p_init_error_handler
265 ,p_write_to_concurrent_log => p_write_to_concurrent_log
266 ,p_init_fnd_msg_list => p_init_fnd_msg_list
267 ,p_log_errors => p_log_errors
268 ,p_add_errors_to_fnd_stack => p_add_errors_to_fnd_stack
269 ,x_attributes_req_table => x_attributes_req_table
270 ,x_return_status => x_return_status
271 ,x_errorcode => x_errorcode
272 ,x_msg_count => x_msg_count
273 ,x_msg_data => x_msg_data
274 );
275
276 END Validate_Required_Attrs;
277 ----------------------------------------------------------------------
278
279
280 /*
281 * Build_Attr_Group_Row_Object builds and trturns an instance of
282 * EGO_USER_ATTR_ROW_OBJ using the passed in infomation.
283 */
284
285 FUNCTION Build_Attr_Group_Row_Object( p_row_identifier IN NUMBER
286 ,p_attr_group_id IN NUMBER DEFAULT NULL
287 ,p_attr_group_app_id IN NUMBER
288 ,p_attr_group_type IN VARCHAR2
289 ,p_attr_group_name IN VARCHAR2
290 ,p_data_level IN VARCHAR2 DEFAULT NULL
291 ,p_data_level_1 IN VARCHAR2 DEFAULT NULL
292 ,p_data_level_2 IN VARCHAR2 DEFAULT NULL
293 ,p_data_level_3 IN VARCHAR2 DEFAULT NULL
294 ,p_data_level_4 IN VARCHAR2 DEFAULT NULL
295 ,p_data_level_5 IN VARCHAR2 DEFAULT NULL
296 ,p_transaction_type IN VARCHAR2
297 )
298 RETURN EGO_USER_ATTR_ROW_OBJ
299 IS
300 BEGIN
301 RETURN EGO_USER_ATTR_ROW_OBJ ( p_row_identifier
302 ,p_attr_group_id
303 ,p_attr_group_app_id
304 ,p_attr_group_type
305 ,p_attr_group_name
306 ,p_data_level
307 ,p_data_level_1
308 ,p_data_level_2
309 ,p_data_level_3
310 ,p_data_level_4
311 ,p_data_level_5
312 ,p_transaction_type
313 );
314
315 END Build_Attr_Group_Row_Object;
316
317 /*
318 * Build_Attr_Group_Row_Table builds up the EGO_USER_ATTR_ROW_TABLE.
319 * an instance of EGO_USER_ATTR_ROW_OBJ is built using the passed in
320 * infomation and appended to the table here.
321 */
322
323 FUNCTION Build_Attr_Group_Row_Table( p_attr_group_row_table IN EGO_USER_ATTR_ROW_TABLE
324 ,p_row_identifier IN NUMBER
325 ,p_attr_group_id IN NUMBER DEFAULT NULL
326 ,p_attr_group_app_id IN NUMBER
327 ,p_attr_group_type IN VARCHAR2
328 ,p_attr_group_name IN VARCHAR2
329 ,p_data_level IN VARCHAR2 DEFAULT NULL
330 ,p_data_level_1 IN VARCHAR2 DEFAULT NULL
331 ,p_data_level_2 IN VARCHAR2 DEFAULT NULL
332 ,p_data_level_3 IN VARCHAR2 DEFAULT NULL
333 ,p_data_level_4 IN VARCHAR2 DEFAULT NULL
334 ,p_data_level_5 IN VARCHAR2 DEFAULT NULL
335 ,p_transaction_type IN VARCHAR2
336 )
337 RETURN EGO_USER_ATTR_ROW_TABLE
338 IS
339 l_user_Attr_row_tab EGO_USER_ATTR_ROW_TABLE;
340 BEGIN
341 IF (p_attr_group_row_table IS NULL) THEN
342 l_user_Attr_row_tab := EGO_USER_ATTR_ROW_TABLE();
343 l_user_Attr_row_tab.EXTEND();
344 ELSE
345 l_user_Attr_row_tab := p_attr_group_row_table;
346 l_user_Attr_row_tab.EXTEND();
347 END IF;
348
349 l_user_Attr_row_tab(l_user_Attr_row_tab.LAST) := Build_Attr_Group_Row_Object( p_row_identifier => p_row_identifier
350 ,p_attr_group_id => p_attr_group_id
351 ,p_attr_group_app_id => p_attr_group_app_id
352 ,p_attr_group_type => p_attr_group_type
353 ,p_attr_group_name => p_attr_group_name
354 ,p_data_level => p_data_level
355 ,p_data_level_1 => p_data_level_1
356 ,p_data_level_2 => p_data_level_2
357 ,p_data_level_3 => p_data_level_3
358 ,p_data_level_4 => p_data_level_4
359 ,p_data_level_5 => p_data_level_5
360 ,p_transaction_type => p_transaction_type
361 );
362 RETURN l_user_Attr_row_tab;
363
364 END Build_Attr_Group_Row_Table;
365
366 /*
367 * Build_Attr_Group_Request_Obj creates and returns an instance of
368 * EGO_ATTR_GROUP_REQUEST_OBJ using the passed in infomation.
369 */
370
371 FUNCTION Build_Attr_Group_Request_Obj(p_attr_group_id IN NUMBER DEFAULT NULL
372 ,p_application_id IN NUMBER
373 ,p_attr_group_type IN VARCHAR2
374 ,p_attr_group_name IN VARCHAR2
375 ,p_data_level IN VARCHAR2 DEFAULT NULL
376 ,p_data_level_1 IN VARCHAR2 DEFAULT NULL
377 ,p_data_level_2 IN VARCHAR2 DEFAULT NULL
378 ,p_data_level_3 IN VARCHAR2 DEFAULT NULL
379 ,p_data_level_4 IN VARCHAR2 DEFAULT NULL
380 ,p_data_level_5 IN VARCHAR2 DEFAULT NULL
381 ,p_attr_name_list IN VARCHAR2 DEFAULT NULL
382 )
383 RETURN EGO_ATTR_GROUP_REQUEST_OBJ
384 IS
385 BEGIN
386
387 RETURN EGO_ATTR_GROUP_REQUEST_OBJ (p_attr_group_id
388 ,p_application_id
389 ,p_attr_group_type
390 ,p_attr_group_name
391 ,p_data_level
392 ,p_data_level_1
393 ,p_data_level_2
394 ,p_data_level_3
395 ,p_data_level_4
396 ,p_data_level_5
397 ,p_attr_name_list
398 );
399
400 END Build_Attr_Group_Request_Obj;
401
402 /*
403 * Build_Attr_Group_Request_Table builds up the EGO_ATTR_GROUP_REQUEST_TABLE.
404 * An instance of EGO_ATTR_GROUP_REQUEST_OBJ is built using the passed in
405 * infomation and appended to the table here.
406 */
407
408 FUNCTION Build_Attr_Group_Request_Table( p_ag_req_table IN EGO_ATTR_GROUP_REQUEST_TABLE
409 ,p_attr_group_id IN NUMBER DEFAULT NULL
410 ,p_application_id IN NUMBER
411 ,p_attr_group_type IN VARCHAR2
412 ,p_attr_group_name IN VARCHAR2
413 ,p_data_level IN VARCHAR2 DEFAULT NULL
414 ,p_data_level_1 IN VARCHAR2 DEFAULT NULL
415 ,p_data_level_2 IN VARCHAR2 DEFAULT NULL
416 ,p_data_level_3 IN VARCHAR2 DEFAULT NULL
417 ,p_data_level_4 IN VARCHAR2 DEFAULT NULL
418 ,p_data_level_5 IN VARCHAR2 DEFAULT NULL
419 ,p_attr_name_list IN VARCHAR2 DEFAULT NULL
420 )
421 RETURN EGO_ATTR_GROUP_REQUEST_TABLE
422 IS
423 l_req_table EGO_ATTR_GROUP_REQUEST_TABLE;
424 BEGIN
425
426 IF (l_req_table IS NULL) THEN
427 l_req_table := EGO_ATTR_GROUP_REQUEST_TABLE();
428 l_req_table.EXTEND();
429 ELSE
430 l_req_table := p_ag_req_table;
431 l_req_table.EXTEND();
432 END IF;
433
434 l_req_table(l_req_table.LAST) := Build_Attr_Group_Request_Obj(p_attr_group_id => p_attr_group_id
435 ,p_application_id => p_application_id
436 ,p_attr_group_type => p_attr_group_type
437 ,p_attr_group_name => p_attr_group_name
438 ,p_data_level => p_data_level
439 ,p_data_level_1 => p_data_level_1
440 ,p_data_level_2 => p_data_level_2
441 ,p_data_level_3 => p_data_level_3
442 ,p_data_level_4 => p_data_level_4
443 ,p_data_level_5 => p_data_level_5
444 ,p_attr_name_list => p_attr_name_list
445 );
446
447 RETURN l_req_table;
448
449
450 END Build_Attr_Group_Request_Table;
451
452
453
454
455
456
457
458
459
460 END EGO_USER_ATTRS_DATA_PUB;
461