[Home] [Help]
PACKAGE: APPS.AMV_USER_PVT
Source
1 PACKAGE amv_user_pvt AS
2 /* $Header: amvvusrs.pls 120.1 2005/06/30 13:27:27 appldev ship $ */
3 -- Start of Comments
4 --
5 -- NAME
6 -- AMV_USER_PVT
7 --
8 -- PURPOSE
9 -- This package is a private user API in AMV.
10 -- It is the main part of user profile block API.
11 -- All the procedures are used to handle users (resources)
12 -- and their profile (privileges, access, etc).
13 --
14 -- This package contains the following procedures
15 --
16 -- Resource
17 -- --Add_Resource;
18 -- --Delete_Resource;
19 -- --Update_Resource;
20 -- --Get_Resource;
21 -- Get_ResourceId;
22 -- Find_Resource;
23 -- Resource Roles
24 -- Add_ResourceRole;
25 -- Remove_ResourceRole;
26 -- Replace_ResourceRole;
27 -- Get_ResourceRoles;
28 -- Check_ResourceRole;
29 -- Is_Administrator;
30 -- Can_PublishContent;
31 -- Can_ApproveContent;
32 -- Can_SetupChannel;
33 -- Can_SetupCategory;
34 -- Can_SetupDistRule;
35 --
36 -- Group Roles
37 -- Add_GroupRole;
38 -- Remove_GroupRole;
39 -- Replace_GroupRole;
40 -- Check_GroupRole;
41 -- Get_GroupRoles;
42 --
43 -- Groups
44 -- Add_Group
45 -- Update_Group
46 -- Delete_Group
47 -- Get_Group
48 -- Find_Group
49 --
50 -- Group Membership
51 -- Add_GroupMember;
52 -- Remove_GroupMember;
53 -- Check_GroupMember;
54 -- --Get_AllGroupMember;
55 --
56 -- Resource and Group Access
57 -- Update_Access;
58 --
59 -- Update_ResourceApplAccess;
60 -- Update_ResourceChanAccess;
61 -- Update_ResourceCateAccess;
62 -- Update_ResourceItemAccess;
63 -- Update_GroupApplAccess;
64 -- Update_GroupChanAccess;
65 -- Update_GroupCateAccess;
66 -- Update_GroupItemAccess;
67 --
68 -- Get_ResourceApplAccess;
69 -- Get_ResourceChanAccess;
70 -- Get_ResourceCateAccess;
71 -- Get_ResourceItemAccess;
72 -- Get_GroupApplAccess;
73 -- Get_GroupChanAccess;
74 -- Get_GroupCateAccess;
75 -- Get_GroupItemAccess;
76 -- Get_ChannelsAccess;
77 -- --Check_ResourceViewCategory;
78 -- --Check_ResourceViewChannel;
79 -- --Check_ResourceViewItem;
80 --
81 -- NOTES
82 --
83 --
84 -- HISTORY
85 -- 11/01/1999 PWU created
86 --
87 -- 06/30/2000 SHITIJ VATSA UPDATED
88 -- (svatsa) Made the follwoing changes for Territory Privilege Integration
89 -- Created the following three global variables
90 -- 1. G_CAN_SETUP_TERRITORY_NAME
91 -- 2. G_CAN_SETUP_TERRITORY_CODE
92 -- 3. G_CAN_SETUP_TERRITORY_ID
93 --
94 -- Modified the API Get_RoleIDArray to support Territory Intg
95 -- End of Comments
96 --
97 --
98 G_VERSION CONSTANT NUMBER := 1.0;
99 --
100 G_MES_ROLE_TYPE_NAME CONSTANT VARCHAR2(30) := 'MES';
101 G_MES_GROUP_USAGE CONSTANT VARCHAR2(30) := 'MES_GROUP';
102 G_RESOURCE_CATEGORY CONSTANT VARCHAR2(30) := 'EMPLOYEE';
103
104 G_ADMINISTRTOR_NAME CONSTANT VARCHAR2(30) := 'MES Administrator';
105 G_ADMINISTRTOR_CODE CONSTANT VARCHAR2(30) := 'MES_ADMIN';
106 G_ADMINISTRTOR_ID NUMBER := FND_API.G_MISS_NUM;
107
108 G_CAN_PUBLISH_NAME CONSTANT VARCHAR2(30) := 'MES publish content';
109 G_CAN_PUBLISH_CODE CONSTANT VARCHAR2(30) := 'MES_PUBLISH';
110 G_CAN_PUBLISH_ID NUMBER := FND_API.G_MISS_NUM;
111
112 G_CAN_APPROVE_NAME CONSTANT VARCHAR2(30) := 'MES approve content';
113 G_CAN_APPROVE_CODE CONSTANT VARCHAR2(30) := 'MES_APPROVE';
114 G_CAN_APPROVE_ID NUMBER := FND_API.G_MISS_NUM;
115
116 G_CAN_SETUP_CHANNEL_NAME CONSTANT VARCHAR2(30) := 'MES setup channel';
117 G_CAN_SETUP_CHANNEL_CODE CONSTANT VARCHAR2(30) := 'MES_SETUP_CHANNEL';
118 G_CAN_SETUP_CHANNEL_ID NUMBER := FND_API.G_MISS_NUM;
119
120 G_CAN_SETUP_CATEGORY_NAME CONSTANT VARCHAR2(30) := 'MES setup category';
121 G_CAN_SETUP_CATEGORY_CODE CONSTANT VARCHAR2(30) := 'MES_SETUP_CATEGORY';
122 G_CAN_SETUP_CATEGORY_ID NUMBER := FND_API.G_MISS_NUM;
123
124 G_CAN_SETUP_DIST_NAME CONSTANT VARCHAR2(30) := 'MES setup distribution rule';
125 G_CAN_SETUP_DIST_CODE CONSTANT VARCHAR2(30) := 'MES_SETUP_DIST_RULE';
126 G_CAN_SETUP_DIST_ID NUMBER := FND_API.G_MISS_NUM;
127
128 -- Begin : Territory Integration
129 -- 06/30/2000 svatsa
130 G_CAN_SETUP_TERRITORY_NAME CONSTANT VARCHAR2(30) := 'MES publish territory';
131 G_CAN_SETUP_TERRITORY_CODE CONSTANT VARCHAR2(30) := 'MES_PUBLISH_TERRITORY';
132 G_CAN_SETUP_TERRITORY_ID NUMBER := FND_API.G_MISS_NUM;
133 -- End : Territory Integration
134 --
135 G_GROUP_ARC_TYPE CONSTANT VARCHAR2(30) := 'GROUP';
136 G_USER_ARC_TYPE CONSTANT VARCHAR2(30) := 'USER';
137 G_ITEM_ARC_TYPE CONSTANT VARCHAR2(30) := 'ITEM';
138 G_APPL_ARC_TYPE CONSTANT VARCHAR2(30) := 'APPLICATION';
139 G_CHAN_ARC_TYPE CONSTANT VARCHAR2(30) := 'CHANNEL';
140 G_CATE_ARC_TYPE CONSTANT VARCHAR2(30) := 'CATEGORY';
141
142 --Type definitions
143
144 TYPE AMV_CHAR_VARRAY_TYPE IS TABLE OF VARCHAR2(4000);
145 --INDEX BY BINARY_INTEGER;
146
147 TYPE AMV_NUMBER_VARRAY_TYPE IS TABLE OF NUMBER;
148 --INDEX BY BINARY_INTEGER;
149
150 TYPE amv_return_obj_type IS RECORD(
151 returned_record_count NUMBER,
152 next_record_position NUMBER,
153 total_record_count NUMBER
154 );
155
156 TYPE amv_request_obj_type IS RECORD(
157 records_requested NUMBER,
158 start_record_position NUMBER,
159 return_total_count_flag VARCHAR2(1)
160 );
161
162 TYPE amv_resource_obj_type IS RECORD(
163 resource_id NUMBER,
164 person_id NUMBER,
165 user_name VARCHAR2(100),
166 first_name VARCHAR2(40),
167 last_name VARCHAR2(40)
168 );
169
170 TYPE amv_resource_obj_varray IS TABLE of amv_resource_obj_type;
171 --INDEX BY BINARY_INTEGER;
172
173 TYPE amv_group_obj_type IS RECORD(
174 group_id NUMBER,
175 group_name VARCHAR2(80),
176 object_version_number NUMBER,
177 email_address VARCHAR2(240),
178 description VARCHAR2(2000),
179 effective_start_date DATE,
180 expiration_date DATE
181 );
182
183 TYPE amv_group_obj_varray IS TABLE of amv_group_obj_type;
184 --INDEX BY BINARY_INTEGER;
185
186 TYPE amv_access_obj_type IS RECORD(
187 ACCESS_ID NUMBER,
188 OBJECT_VERSION_NUMBER NUMBER(9),
189 ACCESS_TO_TABLE_CODE VARCHAR2(30),
190 ACCESS_TO_TABLE_RECORD_ID NUMBER,
191 USER_OR_GROUP_ID NUMBER,
192 USER_OR_GROUP_TYPE VARCHAR2(30),
193 EFFECTIVE_START_DATE DATE,
194 EXPIRATION_DATE DATE,
195 CAN_VIEW_FLAG VARCHAR2(1),
196 CAN_CREATE_FLAG VARCHAR2(1),
197 CAN_DELETE_FLAG VARCHAR2(1),
198 CAN_UPDATE_FLAG VARCHAR2(1),
199 CAN_CREATE_DIST_RULE_FLAG VARCHAR2(1),
200 CHL_APPROVER_FLAG VARCHAR2(1),
201 CHL_REQUIRED_FLAG VARCHAR2(1),
202 CHL_REQUIRED_NEED_NOTIF_FLAG VARCHAR2(1)
203 );
204
205 TYPE amv_access_obj_varray IS TABLE of amv_access_obj_type;
206 --INDEX BY BINARY_INTEGER;
207
208 TYPE amv_access_flag_obj_type IS RECORD(
209 CAN_VIEW_FLAG VARCHAR2(1),
210 CAN_CREATE_FLAG VARCHAR2(1),
211 CAN_DELETE_FLAG VARCHAR2(1),
212 CAN_UPDATE_FLAG VARCHAR2(1),
213 CAN_CREATE_DIST_RULE_FLAG VARCHAR2(1),
214 CHL_APPROVER_FLAG VARCHAR2(1),
215 CHL_REQUIRED_FLAG VARCHAR2(1),
216 CHL_REQUIRED_NEED_NOTIF_FLAG VARCHAR2(1)
217 );
218
219 --------------------------------------------------------------------------------
220 -- Start of comments
221 -- API name : Get_ResourceId
222 -- Type : Private
223 -- Pre-reqs : None
224 -- Function : Get the resource id based on the passed user id.
225 -- Parameters :
226 -- IN p_api_version NUMBER Required
227 -- p_init_msg_list VARCHAR2 Optional
228 -- Default = FND_API.G_FALSE
229 -- p_validation_level NUMBER Optional
230 -- Default = FND_API.G_VALID_LEVEL_FULL
231 -- p_check_login_user VARCHAR2 Optional
232 -- Default = FND_API.G_TRUE
233 -- Flag for checking user privilege and if user is login.
234 -- p_user_id NUMBER Optional
235 -- Default = FND_API.G_MISS_NUM
236 -- If default, use the current(login) user id
237 -- OUT : x_return_status VARCHAR2
238 -- x_msg_count NUMBER
239 -- x_msg_data VARCHAR2
240 -- x_resource_id NUMBER
241 -- Version : Current version 1.0
242 -- Previous version 1.0
243 -- Initial version 1.0
244 -- Notes :
245 -- End of comments
246 --
247 --------------------------------------------------------------------------------
248 PROCEDURE Get_ResourceId
249 (
250 p_api_version IN NUMBER,
251 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
252 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2,
256 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
257 p_user_id IN NUMBER := FND_API.G_MISS_NUM,
258 x_resource_id OUT NOCOPY NUMBER
259 );
260 --------------------------------------------------------------------------------
261 -- Start of comments
262 -- API name : Find_Resource
263 -- Type : Private
264 -- Pre-reqs : None
265 -- Function : Find resource given the search criteria.
266 -- Parameters :
267 -- IN p_api_version NUMBER Required
268 -- p_init_msg_list VARCHAR2 Optional
269 -- Default = FND_API.G_FALSE
270 -- p_validation_level NUMBER Optional
271 -- Default = FND_API.G_VALID_LEVEL_FULL
272 -- p_check_login_user VARCHAR2 Optional
273 -- Default = FND_API.G_TRUE
274 -- Flag for checking user privilege and if user is login.
275 -- p_group_id NUMBER Optional
276 -- default FND_API.G_MISS_NUM
277 -- p_check_effective_date VARCHAR2 Optional
278 -- default FND_API.G_TRUE
279 -- p_user_name VARCHAR2 Optional
280 -- default = FND_API.G_MISS_CHAR
281 -- p_last_name VARCHAR2 Optional
282 -- default = FND_API.G_MISS_CHAR
283 -- p_first_name VARCHAR2 Optional
284 -- default = FND_API.G_MISS_CHAR
285 -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE
286 -- Required.
287 -- OUT : x_return_status VARCHAR2
288 -- x_msg_count NUMBER
289 -- x_msg_data VARCHAR2
290 -- x_subset_return_obj AMV_RETURN_OBJ_TYPE
291 -- x_resource_obj_array AMV_RESOURCE_OBJ_VARRAY
292 -- Version : Current version 1.0
293 -- Previous version 1.0
294 -- Initial version 1.0
295 -- Notes :
296 -- End of comments
297 --
298 PROCEDURE Find_Resource
299 (
300 p_api_version IN NUMBER,
301 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
302 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
303 x_return_status OUT NOCOPY VARCHAR2,
304 x_msg_count OUT NOCOPY NUMBER,
305 x_msg_data OUT NOCOPY VARCHAR2,
306 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
307 p_group_id IN NUMBER := FND_API.G_MISS_NUM,
308 p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
309 p_user_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
310 p_last_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
311 p_first_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
312 p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
313 x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
314 x_resource_obj_array OUT NOCOPY AMV_RESOURCE_OBJ_VARRAY
315 );
316 --
317 --------------------------------------------------------------------------------
318 -- Start of comments
319 -- API name : Find_Resource
320 -- Type : Private
321 -- Pre-reqs : None
322 -- Function : Find resource given the search criteria.
323 -- Parameters :
324 -- IN p_api_version NUMBER Required
325 -- p_init_msg_list VARCHAR2 Optional
326 -- Default = FND_API.G_FALSE
327 -- p_validation_level NUMBER Optional
328 -- Default = FND_API.G_VALID_LEVEL_FULL
329 -- p_check_login_user VARCHAR2 Optional
330 -- Default = FND_API.G_TRUE
331 -- Flag for checking user privilege and if user is login.
332 -- p_group_id NUMBER Optional
333 -- default FND_API.G_MISS_NUM
334 -- p_check_effective_date VARCHAR2 Optional
335 -- default FND_API.G_TRUE
336 -- p_user_name VARCHAR2 Optional
337 -- default = FND_API.G_MISS_CHAR
338 -- p_last_name VARCHAR2 Optional
339 -- default = FND_API.G_MISS_CHAR
340 -- p_first_name VARCHAR2 Optional
341 -- default = FND_API.G_MISS_CHAR
342 -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE
343 -- Required.
344 -- OUT : x_return_status VARCHAR2
345 -- x_msg_count NUMBER
346 -- x_msg_data VARCHAR2
347 -- x_subset_return_obj AMV_RETURN_OBJ_TYPE
348 -- x_resource_obj_array AMV_RESOURCE_OBJ_VARRAY
349 -- Version : Current version 1.0
350 -- Previous version 1.0
351 -- Initial version 1.0
352 -- Notes :
353 -- End of comments
354 --
355 PROCEDURE Find_Resource
356 (
357 p_api_version IN NUMBER,
358 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
359 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
360 x_return_status OUT NOCOPY VARCHAR2,
361 x_msg_count OUT NOCOPY NUMBER,
362 x_msg_data OUT NOCOPY VARCHAR2,
363 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
364 p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
365 p_resource_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
366 p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
367 x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
371 --------------------------------------------------------------------------------
368 x_resource_obj_array OUT NOCOPY AMV_RESOURCE_OBJ_VARRAY,
369 x_role_code_varray OUT NOCOPY AMV_CHAR_VARRAY_TYPE
370 );
372 -- Start of comments
373 -- API name : Add_ResourceRole
374 -- Type : Private
375 -- Pre-reqs : None
376 -- Function : Add a role to resource.
377 -- Parameters :
378 -- IN p_api_version NUMBER Required
379 -- p_init_msg_list VARCHAR2 Optional
380 -- Default = FND_API.G_FALSE
381 -- p_commit VARCHAR2 Optional
382 -- Default = FND_API.G_FALSE
383 -- p_validation_level NUMBER Optional
384 -- Default = FND_API.G_VALID_LEVEL_FULL
385 -- p_check_login_user VARCHAR2 Optional
386 -- Default = FND_API.G_TRUE
387 -- Flag for checking user privilege and if user is login.
388 -- p_resource_id NUMBER Required
389 -- the id of the resource
390 -- p_role_id NUMBER Optional
391 -- Default FND_API.G_MISS_NUM
392 -- p_role_code VARCHAR2 Optional
393 -- Default FND_API.G_MISS_CHAR
394 -- OUT : x_return_status VARCHAR2
395 -- x_msg_count NUMBER
396 -- x_msg_data VARCHAR2
397 -- Version : Current version 1.0
398 -- Previous version 1.0
399 -- Initial version 1.0
400 -- Notes :
401 -- End of comments
402 --
403 PROCEDURE Add_ResourceRole
404 (
405 p_api_version IN NUMBER,
406 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
407 p_commit IN VARCHAR2 := FND_API.G_FALSE,
408 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
409 x_return_status OUT NOCOPY VARCHAR2,
410 x_msg_count OUT NOCOPY NUMBER,
411 x_msg_data OUT NOCOPY VARCHAR2,
412 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
413 p_resource_id IN NUMBER,
414 p_role_id IN NUMBER := FND_API.G_MISS_NUM,
415 p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
416 );
417 --
418 --------------------------------------------------------------------------------
419 -- Start of comments
420 -- API name : Add_ResourceRole
421 -- Type : Private
422 -- Pre-reqs : None
423 -- Function : Add several roles to a resource.
424 -- Parameters :
425 -- IN p_api_version NUMBER Required
426 -- p_init_msg_list VARCHAR2 Optional
427 -- Default = FND_API.G_FALSE
428 -- p_commit VARCHAR2 Optional
429 -- Default = FND_API.G_FALSE
430 -- p_validation_level NUMBER Optional
431 -- Default = FND_API.G_VALID_LEVEL_FULL
432 -- p_check_login_user VARCHAR2 Optional
433 -- Default = FND_API.G_TRUE
434 -- Flag for checking user privilege and if user is login.
435 -- p_resource_id NUMBER Required
436 -- p_role_id_varray AMV_NUMBER_VARRAY_TYPE
437 -- array of role ids. Required
438 -- OUT : x_return_status VARCHAR2
439 -- x_msg_count NUMBER
440 -- x_msg_data VARCHAR2
441 -- Version : Current version 1.0
442 -- Previous version 1.0
443 -- Initial version 1.0
444 -- Notes :
445 -- End of comments
446 --
447 PROCEDURE Add_ResourceRole
448 (
449 p_api_version IN NUMBER,
450 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
451 p_commit IN VARCHAR2 := FND_API.G_FALSE,
452 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
453 x_return_status OUT NOCOPY VARCHAR2,
454 x_msg_count OUT NOCOPY NUMBER,
455 x_msg_data OUT NOCOPY VARCHAR2,
456 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
457 p_resource_id IN NUMBER,
458 p_role_id_varray IN AMV_NUMBER_VARRAY_TYPE
459 );
460 --------------------------------------------------------------------------------
461 -- Start of comments
462 -- API name : Remove_ResourceRole
463 -- Type : Private
464 -- Pre-reqs : None
465 -- Function : Remove a role from a resource.
466 -- Parameters :
467 -- IN p_api_version NUMBER Required
468 -- p_init_msg_list VARCHAR2 Optional
469 -- Default = FND_API.G_FALSE
470 -- p_commit VARCHAR2 Optional
471 -- Default = FND_API.G_FALSE
472 -- p_validation_level NUMBER Optional
473 -- Default = FND_API.G_VALID_LEVEL_FULL
474 -- p_check_login_user VARCHAR2 Optional
475 -- Default = FND_API.G_TRUE
479 -- Default FND_API.G_MISS_NUM
476 -- Flag for checking user privilege and if user is login.
477 -- p_resource_id NUMBER Required
478 -- p_role_id NUMBER Optional
480 -- p_role_code VARCHAR2 Optional
481 -- Default FND_API.G_MISS_CHAR
482 -- OUT : x_return_status VARCHAR2
483 -- x_msg_count NUMBER
484 -- x_msg_data VARCHAR2
485 -- Version : Current version 1.0
486 -- Previous version 1.0
487 -- Initial version 1.0
488 -- Notes :
489 -- End of comments
490 --
491 PROCEDURE Remove_ResourceRole
492 (
493 p_api_version IN NUMBER,
494 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
495 p_commit IN VARCHAR2 := FND_API.G_FALSE,
496 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
497 x_return_status OUT NOCOPY VARCHAR2,
498 x_msg_count OUT NOCOPY NUMBER,
499 x_msg_data OUT NOCOPY VARCHAR2,
500 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
501 p_resource_id IN NUMBER,
502 p_role_id IN NUMBER := FND_API.G_MISS_NUM,
503 p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
504 );
505 --
506 --------------------------------------------------------------------------------
507 -- Start of comments
508 -- API name : Remove_ResourceRole
509 -- Type : Private
510 -- Pre-reqs : None
511 -- Function : Remove several roles from a resource.
512 -- Parameters :
513 -- IN p_api_version NUMBER Required
514 -- p_init_msg_list VARCHAR2 Optional
515 -- Default = FND_API.G_FALSE
516 -- p_commit VARCHAR2 Optional
517 -- Default = FND_API.G_FALSE
518 -- p_validation_level NUMBER Optional
519 -- Default = FND_API.G_VALID_LEVEL_FULL
520 -- p_check_login_user VARCHAR2 Optional
521 -- Default = FND_API.G_TRUE
522 -- Flag for checking user privilege and if user is login.
523 -- Default = null
524 -- p_resource_id NUMBER Required
525 -- p_role_id_varray AMV_NUMBER_VARRAY_TYPE
526 -- OUT : x_return_status VARCHAR2
527 -- x_msg_count NUMBER
528 -- x_msg_data VARCHAR2
529 -- Version : Current version 1.0
530 -- Previous version 1.0
531 -- Initial version 1.0
532 -- Notes :
533 -- End of comments
534 --
535 PROCEDURE Remove_ResourceRole
536 (
537 p_api_version IN NUMBER,
538 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
539 p_commit IN VARCHAR2 := FND_API.G_FALSE,
540 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
541 x_return_status OUT NOCOPY VARCHAR2,
542 x_msg_count OUT NOCOPY NUMBER,
543 x_msg_data OUT NOCOPY VARCHAR2,
544 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
545 p_resource_id IN NUMBER,
546 p_role_id_varray IN AMV_NUMBER_VARRAY_TYPE := NULL
547 );
548 --------------------------------------------------------------------------------
549 -- Start of comments
550 -- API name : Replace_ResourceRole
551 -- Type : Private
552 -- Pre-reqs : None
553 -- Function : Replace all the roles of a resource.
554 -- Parameters :
555 -- IN p_api_version NUMBER Required
556 -- p_init_msg_list VARCHAR2 Optional
557 -- Default = FND_API.G_FALSE
558 -- p_commit VARCHAR2 Optional
559 -- Default = FND_API.G_FALSE
560 -- p_validation_level NUMBER Optional
561 -- Default = FND_API.G_VALID_LEVEL_FULL
562 -- p_check_login_user VARCHAR2 Optional
563 -- Default = FND_API.G_TRUE
564 -- Flag for checking user privilege and if user is login.
565 -- p_resource_id NUMBER Required
566 -- p_role_id_varray AMV_NUMBER_VARRAY_TYPE
567 -- array of new role ids Required
568 -- OUT : x_return_status VARCHAR2
569 -- x_msg_count NUMBER
570 -- x_msg_data VARCHAR2
571 -- Version : Current version 1.0
572 -- Previous version 1.0
573 -- Initial version 1.0
574 -- Notes :
575 -- End of comments
576 --
577 PROCEDURE Replace_ResourceRole
578 (
579 p_api_version IN NUMBER,
580 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
581 p_commit IN VARCHAR2 := FND_API.G_FALSE,
582 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
583 x_return_status OUT NOCOPY VARCHAR2,
584 x_msg_count OUT NOCOPY NUMBER,
588 p_role_id_varray IN AMV_NUMBER_VARRAY_TYPE
585 x_msg_data OUT NOCOPY VARCHAR2,
586 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
587 p_resource_id IN NUMBER,
589 );
590 PROCEDURE Replace_ResourceRole
591 (
592 p_api_version IN NUMBER,
593 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
594 p_commit IN VARCHAR2 := FND_API.G_FALSE,
595 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
596 x_return_status OUT NOCOPY VARCHAR2,
597 x_msg_count OUT NOCOPY NUMBER,
598 x_msg_data OUT NOCOPY VARCHAR2,
599 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
600 p_resource_id IN NUMBER,
601 p_role_code IN VARCHAR2
602 );
603 --------------------------------------------------------------------------------
604 -- Start of comments
605 -- API name : Get_ResourceRoles
606 -- Type : Private
607 -- Pre-reqs : None
608 -- Function : Retrieve all the roles of a resource.
609 -- Parameters :
610 -- IN p_api_version NUMBER Required
611 -- p_init_msg_list VARCHAR2 Optional
612 -- Default = FND_API.G_FALSE
613 -- p_validation_level NUMBER Optional
614 -- Default = FND_API.G_VALID_LEVEL_FULL
615 -- p_check_login_user VARCHAR2 Optional
616 -- Default = FND_API.G_TRUE
617 -- Flag for checking user privilege and if user is login.
618 -- p_resource_id NUMBER Optional
619 -- Default = FND_API.G_MISS_NUM
620 -- p_check_effective_date VARCHAR2 Optional
621 -- default FND_API.G_TRUE
622 -- OUT : x_return_status VARCHAR2
623 -- x_msg_count NUMBER
624 -- x_msg_data VARCHAR2
625 -- x_role_id_varray AMV_NUMBER_VARRAY_TYPE
626 -- x_role_code_varray AMV_CHAR_VARRAY_TYPE
627 -- Version : Current version 1.0
628 -- Previous version 1.0
629 -- Initial version 1.0
630 -- Notes :
631 -- End of comments
632 --
633 PROCEDURE Get_ResourceRoles
634 (
635 p_api_version IN NUMBER,
636 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
637 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
638 x_return_status OUT NOCOPY VARCHAR2,
639 x_msg_count OUT NOCOPY NUMBER,
640 x_msg_data OUT NOCOPY VARCHAR2,
641 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
642 p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
643 x_role_id_varray OUT NOCOPY AMV_NUMBER_VARRAY_TYPE,
644 x_role_code_varray OUT NOCOPY AMV_CHAR_VARRAY_TYPE
645 );
646 --------------------------------------------------------------------------------
647 -- Start of comments
648 -- API name : Check_ResourceRole
649 -- Type : Private
650 -- Pre-reqs : None
651 -- Function : Check if the passed resource has the passed role.
652 -- Parameters :
653 -- IN p_api_version NUMBER Required
654 -- p_init_msg_list VARCHAR2 Optional
655 -- Default = FND_API.G_FALSE
656 -- p_validation_level NUMBER Optional
657 -- Default = FND_API.G_VALID_LEVEL_FULL
658 -- p_check_login_user VARCHAR2 Optional
659 -- Default = FND_API.G_TRUE
660 -- Flag for checking user privilege and if user is login.
661 -- p_resource_id NUMBER Optional
662 -- Default = FND_API.G_MISS_NUM
663 -- If MISS, check the current (login) resource).
664 -- p_role_id NUMBER Required
665 -- p_include_group_flag VARCHAR2 Optional
666 -- Default = FND_API.G_TRUE
667 -- p_check_effective_date VARCHAR2 Optional
668 -- default FND_API.G_TRUE
669 -- OUT : x_return_status VARCHAR2
670 -- x_msg_count NUMBER
671 -- x_msg_data VARCHAR2
672 -- x_result_flag VARCHAR2
673 -- Version : Current version 1.0
674 -- Previous version 1.0
675 -- Initial version 1.0
676 -- Notes :
677 -- End of comments
678 --
679 PROCEDURE Check_ResourceRole
680 (
681 p_api_version IN NUMBER,
682 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
683 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
684 x_return_status OUT NOCOPY VARCHAR2,
685 x_msg_count OUT NOCOPY NUMBER,
686 x_msg_data OUT NOCOPY VARCHAR2,
687 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
688 p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
689 p_role_id IN NUMBER,
690 p_group_usage IN VARCHAR2 := G_MES_GROUP_USAGE,
691 p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
695 --------------------------------------------------------------------------------
692 p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
693 x_result_flag OUT NOCOPY VARCHAR2
694 );
696 -- Start of comments
697 -- API name : Is_Administrator
698 -- Type : Private
699 -- Pre-reqs : None
700 -- Function : Check if the resource is a administrator
701 -- Parameters :
702 -- IN p_api_version NUMBER Required
703 -- p_init_msg_list VARCHAR2 Optional
704 -- Default = FND_API.G_FALSE
705 -- p_validation_level NUMBER Optional
706 -- Default = FND_API.G_VALID_LEVEL_FULL
707 -- p_check_login_user VARCHAR2 Optional
708 -- Default = FND_API.G_TRUE
709 -- Flag for checking user privilege and if user is login.
710 -- p_resource_id NUMBER Optional
711 -- Default = FND_API.G_MISS_NUM
712 -- p_include_group_flag VARCHAR2 Optional
713 -- Default = FND_API.G_TRUE
714 -- OUT : x_return_status VARCHAR2
715 -- x_msg_count NUMBER
716 -- x_msg_data VARCHAR2
717 -- x_result_flag VARCHAR2
718 -- Version : Current version 1.0
719 -- Previous version 1.0
720 -- Initial version 1.0
721 -- Notes :
722 -- End of comments
723 --
724 PROCEDURE Is_Administrator
725 (
726 p_api_version IN NUMBER,
727 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
728 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
729 x_return_status OUT NOCOPY VARCHAR2,
730 x_msg_count OUT NOCOPY NUMBER,
731 x_msg_data OUT NOCOPY VARCHAR2,
732 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
733 p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
734 p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
735 x_result_flag OUT NOCOPY VARCHAR2
736 );
737 --------------------------------------------------------------------------------
738 -- Start of comments
739 -- API name : Can_PublishContent
740 -- Type : Private
741 -- Pre-reqs : None
742 -- Function : Check if the resource has publish content privelege.
743 -- Parameters :
744 -- IN p_api_version NUMBER Required
745 -- p_init_msg_list VARCHAR2 Optional
746 -- Default = FND_API.G_FALSE
747 -- p_validation_level NUMBER Optional
748 -- Default = FND_API.G_VALID_LEVEL_FULL
749 -- p_check_login_user VARCHAR2 Optional
750 -- Default = FND_API.G_TRUE
751 -- Flag for checking user privilege and if user is login.
752 -- p_resource_id NUMBER Optional
753 -- Default = FND_API.G_MISS_NUM
754 -- p_include_group_flag VARCHAR2 Optional
755 -- Default = FND_API.G_TRUE
756 -- OUT : x_return_status VARCHAR2
757 -- x_msg_count NUMBER
758 -- x_msg_data VARCHAR2
759 -- x_result_flag VARCHAR2
760 -- Version : Current version 1.0
761 -- Previous version 1.0
762 -- Initial version 1.0
763 -- Notes :
764 -- End of comments
765 --
766 PROCEDURE Can_PublishContent
767 (
768 p_api_version IN NUMBER,
769 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
770 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
771 x_return_status OUT NOCOPY VARCHAR2,
772 x_msg_count OUT NOCOPY NUMBER,
773 x_msg_data OUT NOCOPY VARCHAR2,
774 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
775 p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
776 p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
777 x_result_flag OUT NOCOPY VARCHAR2
778 );
779 --------------------------------------------------------------------------------
780 -- Start of comments
781 -- API name : Can_ApproveContent
782 -- Type : Private
783 -- Pre-reqs : None
784 -- Function : Check if the resource has approve content privelege.
785 -- Parameters :
786 -- IN p_api_version NUMBER Required
787 -- p_init_msg_list VARCHAR2 Optional
788 -- Default = FND_API.G_FALSE
789 -- p_validation_level NUMBER Optional
790 -- Default = FND_API.G_VALID_LEVEL_FULL
791 -- p_check_login_user VARCHAR2 Optional
792 -- Default = FND_API.G_TRUE
793 -- Flag for checking user privilege and if user is login.
794 -- p_resource_id NUMBER Optional
795 -- Default = FND_API.G_MISS_NUM
796 -- p_include_group_flag VARCHAR2 Optional
797 -- Default = FND_API.G_TRUE
798 -- OUT : x_return_status VARCHAR2
802 -- Version : Current version 1.0
799 -- x_msg_count NUMBER
800 -- x_msg_data VARCHAR2
801 -- x_result_flag VARCHAR2
803 -- Previous version 1.0
804 -- Initial version 1.0
805 -- Notes :
806 -- End of comments
807 --
808 PROCEDURE Can_ApproveContent
809 (
810 p_api_version IN NUMBER,
811 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
812 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
813 x_return_status OUT NOCOPY VARCHAR2,
814 x_msg_count OUT NOCOPY NUMBER,
815 x_msg_data OUT NOCOPY VARCHAR2,
816 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
817 p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
818 p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
819 x_result_flag OUT NOCOPY VARCHAR2
820 );
821 --------------------------------------------------------------------------------
822 -- Start of comments
823 -- API name : Can_SetupChannel
824 -- Type : Private
825 -- Pre-reqs : None
826 -- Function : Check if the resource has setup channel privelege.
827 -- Parameters :
828 -- IN p_api_version NUMBER Required
829 -- p_init_msg_list VARCHAR2 Optional
830 -- Default = FND_API.G_FALSE
831 -- p_validation_level NUMBER Optional
832 -- Default = FND_API.G_VALID_LEVEL_FULL
833 -- p_check_login_user VARCHAR2 Optional
834 -- Default = FND_API.G_TRUE
835 -- Flag for checking user privilege and if user is login.
836 -- p_resource_id NUMBER Optional
837 -- Default = FND_API.G_MISS_NUM
838 -- p_include_group_flag VARCHAR2 Optional
839 -- Default = FND_API.G_TRUE
840 -- OUT : x_return_status VARCHAR2
841 -- x_msg_count NUMBER
842 -- x_msg_data VARCHAR2
843 -- x_result_flag VARCHAR2
844 -- Version : Current version 1.0
845 -- Previous version 1.0
846 -- Initial version 1.0
847 -- Notes :
848 -- End of comments
849 --
850 PROCEDURE Can_SetupChannel
851 (
852 p_api_version IN NUMBER,
853 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
854 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
855 x_return_status OUT NOCOPY VARCHAR2,
856 x_msg_count OUT NOCOPY NUMBER,
857 x_msg_data OUT NOCOPY VARCHAR2,
858 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
859 p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
860 p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
861 x_result_flag OUT NOCOPY VARCHAR2
862 );
863 --------------------------------------------------------------------------------
864 -- Start of comments
865 -- API name : Can_SetupCategory
866 -- Type : Private
867 -- Pre-reqs : None
868 -- Function : Check if the resource has setup category privelege.
869 -- Parameters :
870 -- IN p_api_version NUMBER Required
871 -- p_init_msg_list VARCHAR2 Optional
872 -- Default = FND_API.G_FALSE
873 -- p_validation_level NUMBER Optional
874 -- Default = FND_API.G_VALID_LEVEL_FULL
875 -- p_check_login_user VARCHAR2 Optional
876 -- Default = FND_API.G_TRUE
877 -- Flag for checking user privilege and if user is login.
878 -- p_resource_id NUMBER Optional
879 -- Default = FND_API.G_MISS_NUM
880 -- p_include_group_flag VARCHAR2 Optional
881 -- Default = FND_API.G_TRUE
882 -- OUT : x_return_status VARCHAR2
883 -- x_msg_count NUMBER
884 -- x_msg_data VARCHAR2
885 -- x_result_flag VARCHAR2
886 -- Version : Current version 1.0
887 -- Previous version 1.0
888 -- Initial version 1.0
889 -- Notes :
890 -- End of comments
891 --
892 PROCEDURE Can_SetupCategory
893 (
894 p_api_version IN NUMBER,
895 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
896 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
897 x_return_status OUT NOCOPY VARCHAR2,
898 x_msg_count OUT NOCOPY NUMBER,
899 x_msg_data OUT NOCOPY VARCHAR2,
900 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
901 p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
902 p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
903 x_result_flag OUT NOCOPY VARCHAR2
904 );
905 --------------------------------------------------------------------------------
906 -- Start of comments
907 -- API name : Can_SetupDistRule
908 -- Type : Private
909 -- Pre-reqs : None
913 -- p_init_msg_list VARCHAR2 Optional
910 -- Function : Check if the resource has setup distribution privelege.
911 -- Parameters :
912 -- IN p_api_version NUMBER Required
914 -- Default = FND_API.G_FALSE
915 -- p_validation_level NUMBER Optional
916 -- Default = FND_API.G_VALID_LEVEL_FULL
917 -- p_check_login_user VARCHAR2 Optional
918 -- Default = FND_API.G_TRUE
919 -- Flag for checking user privilege and if user is login.
920 -- p_resource_id NUMBER Optional
921 -- Default = FND_API.G_MISS_NUM
922 -- p_include_group_flag VARCHAR2 Optional
923 -- Default = FND_API.G_TRUE
924 -- OUT : x_return_status VARCHAR2
925 -- x_msg_count NUMBER
926 -- x_msg_data VARCHAR2
927 -- x_result_flag VARCHAR2
928 -- Version : Current version 1.0
929 -- Previous version 1.0
930 -- Initial version 1.0
931 -- Notes :
932 -- End of comments
933 --
934 PROCEDURE Can_SetupDistRule
935 (
936 p_api_version IN NUMBER,
937 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
938 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
939 x_return_status OUT NOCOPY VARCHAR2,
940 x_msg_count OUT NOCOPY NUMBER,
941 x_msg_data OUT NOCOPY VARCHAR2,
942 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
943 p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
944 p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
945 x_result_flag OUT NOCOPY VARCHAR2
946 );
947 --------------------------------------------------------------------------------
948 ----------------------------- GROUP PRIVELEGES ---------------------------------
949 --------------------------------------------------------------------------------
950 -- Start of comments
951 -- API name : Add_GroupRole
952 -- Type : Private
953 -- Pre-reqs : None
954 -- Function : Add a role to a group.
955 -- Parameters :
956 -- IN p_api_version NUMBER Required
957 -- p_init_msg_list VARCHAR2 Optional
958 -- Default = FND_API.G_FALSE
959 -- p_commit VARCHAR2 Optional
960 -- Default = FND_API.G_FALSE
961 -- p_validation_level NUMBER Optional
962 -- Default = FND_API.G_VALID_LEVEL_FULL
963 -- p_check_login_user VARCHAR2 Optional
964 -- Default = FND_API.G_TRUE
965 -- Flag for checking user privilege and if user is login.
966 -- p_group_id NUMBER Required
967 -- the id of the group
968 -- p_role_id NUMBER Optional
969 -- Default FND_API.G_MISS_NUM
970 -- p_role_code VARCHAR2 Optional
971 -- Default FND_API.G_MISS_CHAR
972 -- OUT : x_return_status VARCHAR2
973 -- x_msg_count NUMBER
974 -- x_msg_data VARCHAR2
975 -- Version : Current version 1.0
976 -- Previous version 1.0
977 -- Initial version 1.0
978 -- Notes :
979 -- End of comments
980 --
981 PROCEDURE Add_GroupRole
982 (
983 p_api_version IN NUMBER,
984 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
985 p_commit IN VARCHAR2 := FND_API.G_FALSE,
986 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
987 x_return_status OUT NOCOPY VARCHAR2,
988 x_msg_count OUT NOCOPY NUMBER,
989 x_msg_data OUT NOCOPY VARCHAR2,
990 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
991 p_group_id IN NUMBER,
992 p_role_id IN NUMBER := FND_API.G_MISS_NUM,
993 p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
994 );
995 --
996 --------------------------------------------------------------------------------
997 -- Start of comments
998 -- API name : Add_GroupRole
999 -- Type : Private
1000 -- Pre-reqs : None
1001 -- Function : Add several roles to a group.
1002 -- Parameters :
1003 -- IN p_api_version NUMBER Required
1004 -- p_init_msg_list VARCHAR2 Optional
1005 -- Default = FND_API.G_FALSE
1006 -- p_commit VARCHAR2 Optional
1007 -- Default = FND_API.G_FALSE
1008 -- p_validation_level NUMBER Optional
1009 -- Default = FND_API.G_VALID_LEVEL_FULL
1010 -- p_check_login_user VARCHAR2 Optional
1011 -- Default = FND_API.G_TRUE
1012 -- Flag for checking user privilege and if user is login.
1013 -- p_group_id NUMBER Required
1014 -- the id of the group
1018 -- x_msg_count NUMBER
1015 -- p_role_id_varray AMV_NUMBER_VARRAY_TYPE
1016 -- array of role ids. Required
1017 -- OUT : x_return_status VARCHAR2
1019 -- x_msg_data VARCHAR2
1020 -- Version : Current version 1.0
1021 -- Previous version 1.0
1022 -- Initial version 1.0
1023 -- Notes :
1024 -- End of comments
1025 --
1026 PROCEDURE Add_GroupRole
1027 (
1028 p_api_version IN NUMBER,
1029 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1030 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1031 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1032 x_return_status OUT NOCOPY VARCHAR2,
1033 x_msg_count OUT NOCOPY NUMBER,
1034 x_msg_data OUT NOCOPY VARCHAR2,
1035 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1036 p_group_id IN NUMBER,
1037 p_role_id_varray IN AMV_NUMBER_VARRAY_TYPE
1038 );
1039 --------------------------------------------------------------------------------
1040 -- Start of comments
1041 -- API name : Remove_GroupRole
1042 -- Type : Private
1043 -- Pre-reqs : None
1044 -- Function : Remove a role from a group.
1045 -- Parameters :
1046 -- IN p_api_version NUMBER Required
1047 -- p_init_msg_list VARCHAR2 Optional
1048 -- Default = FND_API.G_FALSE
1049 -- p_commit VARCHAR2 Optional
1050 -- Default = FND_API.G_FALSE
1051 -- p_validation_level NUMBER Optional
1052 -- Default = FND_API.G_VALID_LEVEL_FULL
1053 -- p_check_login_user VARCHAR2 Optional
1054 -- Default = FND_API.G_TRUE
1055 -- Flag for checking user privilege and if user is login.
1056 -- p_group_id NUMBER Required
1057 -- p_role_id NUMBER Optional
1058 -- Default FND_API.G_MISS_NUM
1059 -- p_role_code VARCHAR2 Optional
1060 -- Default FND_API.G_MISS_CHAR
1061 -- OUT : x_return_status VARCHAR2
1062 -- x_msg_count NUMBER
1063 -- x_msg_data VARCHAR2
1064 -- Version : Current version 1.0
1065 -- Previous version 1.0
1066 -- Initial version 1.0
1067 -- Notes :
1068 -- End of comments
1069 --
1070 PROCEDURE Remove_GroupRole
1071 (
1072 p_api_version IN NUMBER,
1073 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1074 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1075 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1076 x_return_status OUT NOCOPY VARCHAR2,
1077 x_msg_count OUT NOCOPY NUMBER,
1078 x_msg_data OUT NOCOPY VARCHAR2,
1079 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1080 p_group_id IN NUMBER,
1081 p_role_id IN NUMBER := FND_API.G_MISS_NUM,
1082 p_role_code IN VARCHAR2 := FND_API.G_MISS_CHAR
1083 );
1084 --
1085 --------------------------------------------------------------------------------
1086 -- Start of comments
1087 -- API name : Remove_GroupRole
1088 -- Type : Private
1089 -- Pre-reqs : None
1090 -- Function : Remove several roles from a group.
1091 -- Parameters :
1092 -- IN p_api_version NUMBER Required
1093 -- p_init_msg_list VARCHAR2 Optional
1094 -- Default = FND_API.G_FALSE
1095 -- p_commit VARCHAR2 Optional
1096 -- Default = FND_API.G_FALSE
1097 -- p_validation_level NUMBER Optional
1098 -- Default = FND_API.G_VALID_LEVEL_FULL
1099 -- p_check_login_user VARCHAR2 Optional
1100 -- Default = FND_API.G_TRUE
1101 -- Flag for checking user privilege and if user is login.
1102 -- p_group_id NUMBER Required
1103 -- p_role_id_varray AMV_NUMBER_VARRAY_TYPE
1104 -- array of role ids. Required
1105 -- OUT : x_return_status VARCHAR2
1106 -- x_msg_count NUMBER
1107 -- x_msg_data VARCHAR2
1108 -- Version : Current version 1.0
1109 -- Previous version 1.0
1110 -- Initial version 1.0
1111 -- Notes :
1112 -- End of comments
1113 --
1114 PROCEDURE Remove_GroupRole
1115 (
1116 p_api_version IN NUMBER,
1117 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1118 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1119 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1120 x_return_status OUT NOCOPY VARCHAR2,
1121 x_msg_count OUT NOCOPY NUMBER,
1122 x_msg_data OUT NOCOPY VARCHAR2,
1123 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1127 --------------------------------------------------------------------------------
1124 p_group_id IN NUMBER,
1125 p_role_id_varray IN AMV_NUMBER_VARRAY_TYPE
1126 );
1128 -- Start of comments
1129 -- API name : Replace_GroupRole
1130 -- Type : Private
1131 -- Pre-reqs : None
1132 -- Function : Replace all the roles of a group.
1133 -- Parameters :
1134 -- IN p_api_version NUMBER Required
1135 -- p_init_msg_list VARCHAR2 Optional
1136 -- Default = FND_API.G_FALSE
1137 -- p_commit VARCHAR2 Optional
1138 -- Default = FND_API.G_FALSE
1139 -- p_validation_level NUMBER Optional
1140 -- Default = FND_API.G_VALID_LEVEL_FULL
1141 -- p_check_login_user VARCHAR2 Optional
1142 -- Default = FND_API.G_TRUE
1143 -- Flag for checking user privilege and if user is login.
1144 -- p_group_id NUMBER Required
1145 -- p_role_id_varray AMV_NUMBER_VARRAY_TYPE
1146 -- array of role ids. Required
1147 -- OUT : x_return_status VARCHAR2
1148 -- x_msg_count NUMBER
1149 -- x_msg_data VARCHAR2
1150 -- Version : Current version 1.0
1151 -- Previous version 1.0
1152 -- Initial version 1.0
1153 -- Notes :
1154 -- End of comments
1155 --
1156 PROCEDURE Replace_GroupRole
1157 (
1158 p_api_version IN NUMBER,
1159 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1160 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1161 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1162 x_return_status OUT NOCOPY VARCHAR2,
1163 x_msg_count OUT NOCOPY NUMBER,
1164 x_msg_data OUT NOCOPY VARCHAR2,
1165 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1166 p_group_id IN NUMBER,
1167 p_role_id_varray IN AMV_NUMBER_VARRAY_TYPE
1168 );
1169 PROCEDURE Replace_GroupRole
1170 (
1171 p_api_version IN NUMBER,
1172 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1173 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1174 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1175 x_return_status OUT NOCOPY VARCHAR2,
1176 x_msg_count OUT NOCOPY NUMBER,
1177 x_msg_data OUT NOCOPY VARCHAR2,
1178 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1179 p_group_id IN NUMBER,
1180 p_role_code IN VARCHAR2
1181 );
1182 --------------------------------------------------------------------------------
1183 -- Start of comments
1184 -- API name : Get_GroupRoles
1185 -- Type : Private
1186 -- Pre-reqs : None
1187 -- Function : Retrieve all the roles of a group.
1188 -- Parameters :
1189 -- IN p_api_version NUMBER Required
1190 -- p_init_msg_list VARCHAR2 Optional
1191 -- Default = FND_API.G_FALSE
1192 -- p_validation_level NUMBER Optional
1193 -- Default = FND_API.G_VALID_LEVEL_FULL
1194 -- p_check_login_user VARCHAR2 Optional
1195 -- Default = FND_API.G_TRUE
1196 -- Flag for checking user privilege and if user is login.
1197 -- p_group_id NUMBER Required
1198 -- p_check_effective_date VARCHAR2 Optional
1199 -- default FND_API.G_TRUE
1200 -- OUT : x_return_status VARCHAR2
1201 -- x_msg_count NUMBER
1202 -- x_msg_data VARCHAR2
1203 -- x_role_id_varray AMV_NUMBER_VARRAY_TYPE
1204 -- x_role_code_varray AMV_CHAR_VARRAY_TYPE
1205 -- Version : Current version 1.0
1206 -- Previous version 1.0
1207 -- Initial version 1.0
1208 -- Notes :
1209 -- End of comments
1210 --
1211 PROCEDURE Get_GroupRoles
1212 (
1213 p_api_version IN NUMBER,
1214 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1215 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1216 x_return_status OUT NOCOPY VARCHAR2,
1217 x_msg_count OUT NOCOPY NUMBER,
1218 x_msg_data OUT NOCOPY VARCHAR2,
1219 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1220 p_group_id IN NUMBER,
1221 p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
1222 x_role_id_varray OUT NOCOPY AMV_NUMBER_VARRAY_TYPE,
1223 x_role_code_varray OUT NOCOPY AMV_CHAR_VARRAY_TYPE
1224 );
1225 --------------------------------------------------------------------------------
1226 -- Start of comments
1227 -- API name : Check_GroupRole
1228 -- Type : Private
1229 -- Pre-reqs : None
1230 -- Function : Check if the passed group has the passed role.
1231 -- Parameters :
1232 -- IN p_api_version NUMBER Required
1233 -- p_init_msg_list VARCHAR2 Optional
1234 -- Default = FND_API.G_FALSE
1238 -- Default = FND_API.G_TRUE
1235 -- p_validation_level NUMBER Optional
1236 -- Default = FND_API.G_VALID_LEVEL_FULL
1237 -- p_check_login_user VARCHAR2 Optional
1239 -- Flag for checking user privilege and if user is login.
1240 -- p_group_id NUMBER Required
1241 -- p_role_id NUMBER Required
1242 -- p_check_effective_date VARCHAR2 Optional
1243 -- default FND_API.G_TRUE
1244 -- OUT : x_return_status VARCHAR2
1245 -- x_msg_count NUMBER
1246 -- x_msg_data VARCHAR2
1247 -- x_result_flag VARCHAR2
1248 -- Version : Current version 1.0
1249 -- Previous version 1.0
1250 -- Initial version 1.0
1251 -- Notes :
1252 -- End of comments
1253 --
1254 PROCEDURE Check_GroupRole
1255 (
1256 p_api_version IN NUMBER,
1257 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1258 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1259 x_return_status OUT NOCOPY VARCHAR2,
1260 x_msg_count OUT NOCOPY NUMBER,
1261 x_msg_data OUT NOCOPY VARCHAR2,
1262 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1263 p_group_id IN NUMBER,
1264 p_role_id IN NUMBER,
1265 p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
1266 x_result_flag OUT NOCOPY VARCHAR2
1267 );
1268 --------------------------------------------------------------------------------
1269 ---------------------------------- GROUP ---------------------------------------
1270 --------------------------------------------------------------------------------
1271 -- Start of comments
1272 -- API name : Add_Group
1273 -- Type : Private
1274 -- Pre-reqs : None
1275 -- Function : Create a resource group
1276 -- Parameters :
1277 -- IN p_api_version NUMBER Required
1278 -- p_init_msg_list VARCHAR2 Optional
1279 -- Default = FND_API.G_FALSE
1280 -- p_commit VARCHAR2 Optional
1281 -- Default = FND_API.G_FALSE
1282 -- p_validation_level NUMBER Optional
1283 -- Default = FND_API.G_VALID_LEVEL_FULL
1284 -- p_check_login_user VARCHAR2 Optional
1285 -- Default = FND_API.G_TRUE
1286 -- Flag for checking user privilege and if user is login.
1287 -- p_group_name VARCHAR2 Required
1288 -- group name are unique
1289 -- p_group_desc VARCHAR2 Optional
1290 -- default null
1291 -- p_start_date DATE Optional
1292 -- default null
1293 -- p_end_date DATE Optional
1294 -- default null
1295 -- p_owner_id NUMBER Optional
1296 -- default null
1297 -- OUT : x_return_status VARCHAR2
1298 -- x_msg_count NUMBER
1299 -- x_msg_data VARCHAR2
1300 -- x_group_id NUMBER
1301 -- Version : Current version 1.0
1302 -- Previous version 1.0
1303 -- Initial version 1.0
1304 -- Notes :
1305 -- End of comments
1306 --
1307 PROCEDURE Add_Group
1308 (
1309 p_api_version IN NUMBER,
1310 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1311 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1312 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1313 x_return_status OUT NOCOPY VARCHAR2,
1314 x_msg_count OUT NOCOPY NUMBER,
1315 x_msg_data OUT NOCOPY VARCHAR2,
1316 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1317 p_group_name IN VARCHAR2,
1318 p_group_desc IN VARCHAR2 := NULL,
1319 p_group_usage IN VARCHAR2,
1320 p_email_address IN VARCHAR2 := NULL,
1321 p_start_date IN DATE := NULL,
1322 p_end_date IN DATE := NULL,
1323 x_group_id OUT NOCOPY NUMBER
1324 );
1325 --------------------------------------------------------------------------------
1326 -- Start of comments
1327 -- API name : Update_Group
1328 -- Type : Private
1329 -- Pre-reqs : None
1330 -- Function : Update a resource group
1331 -- Parameters :
1332 -- IN p_api_version NUMBER Required
1333 -- p_init_msg_list VARCHAR2 Optional
1334 -- Default = FND_API.G_FALSE
1335 -- p_commit VARCHAR2 Optional
1336 -- Default = FND_API.G_FALSE
1337 -- p_validation_level NUMBER Optional
1338 -- Default = FND_API.G_VALID_LEVEL_FULL
1339 -- p_check_login_user VARCHAR2 Optional
1340 -- Default = FND_API.G_TRUE
1341 -- Flag for checking user privilege and if user is login.
1345 -- p_new_group_desc VARCHAR2 Optional
1342 -- p_group_id NUMBER Required
1343 -- p_new_group_name VARCHAR2 Optional
1344 -- default FND_API.G_MISS_CHAR
1346 -- default FND_API.G_MISS_CHAR
1347 -- p_new_start_date DATE Optional
1348 -- default FND_API.G_MISS_DATE
1349 -- p_new_end_date DATE Optional
1350 -- default FND_API.G_MISS_DATE
1351 -- OUT : x_return_status VARCHAR2
1352 -- x_msg_count NUMBER
1353 -- x_msg_data VARCHAR2
1354 -- Version : Current version 1.0
1355 -- Previous version 1.0
1356 -- Initial version 1.0
1357 -- Notes :
1358 -- End of comments
1359 --
1360 PROCEDURE Update_Group
1361 (
1362 p_api_version IN NUMBER,
1363 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1364 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1365 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1366 x_return_status OUT NOCOPY VARCHAR2,
1367 x_msg_count OUT NOCOPY NUMBER,
1368 x_msg_data OUT NOCOPY VARCHAR2,
1369 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1370 p_group_id IN NUMBER,
1371 p_new_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1372 p_new_group_desc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1373 p_group_usage IN VARCHAR2 := G_MES_GROUP_USAGE,
1374 p_email_address IN VARCHAR2 := FND_API.G_MISS_CHAR,
1375 p_new_start_date IN DATE := FND_API.G_MISS_DATE,
1376 p_new_end_date IN DATE := FND_API.G_MISS_DATE
1377 );
1378 --------------------------------------------------------------------------------
1379 -- Start of comments
1380 -- API name : Delete_Group
1381 -- Type : Private
1382 -- Pre-reqs : None
1383 -- Function : Delete a resource group
1384 -- Parameters :
1385 -- IN p_api_version NUMBER Required
1386 -- p_init_msg_list VARCHAR2 Optional
1387 -- Default = FND_API.G_FALSE
1388 -- p_commit VARCHAR2 Optional
1389 -- Default = FND_API.G_FALSE
1390 -- p_validation_level NUMBER Optional
1391 -- Default = FND_API.G_VALID_LEVEL_FULL
1392 -- p_check_login_user VARCHAR2 Optional
1393 -- Default = FND_API.G_TRUE
1394 -- Flag for checking user privilege and if user is login.
1395 -- p_group_name VARCHAR2 Optional
1396 -- default FND_API.G_MISS_CHAR
1397 -- p_group_id NUMBER Optional
1398 -- default FND_API.G_MISS_NUM
1399 -- OUT : x_return_status VARCHAR2
1400 -- x_msg_count NUMBER
1401 -- x_msg_data VARCHAR2
1402 -- Version : Current version 1.0
1403 -- Previous version 1.0
1404 -- Initial version 1.0
1405 -- Notes :
1406 -- End of comments
1407 --
1408 PROCEDURE Delete_Group
1409 (
1410 p_api_version IN NUMBER,
1411 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1412 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1413 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1414 x_return_status OUT NOCOPY VARCHAR2,
1415 x_msg_count OUT NOCOPY NUMBER,
1416 x_msg_data OUT NOCOPY VARCHAR2,
1417 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1418 p_group_id IN NUMBER := FND_API.G_MISS_NUM,
1419 p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR
1420 );
1421 --------------------------------------------------------------------------------
1422 -- Start of comments
1423 -- API name : Get_Group
1424 -- Type : Private
1425 -- Pre-reqs : None
1426 -- Function : Get a resource group information based on the passed id.
1427 -- Parameters :
1428 -- IN p_api_version NUMBER Required
1429 -- p_init_msg_list VARCHAR2 Optional
1430 -- Default = FND_API.G_FALSE
1431 -- p_validation_level NUMBER Optional
1432 -- Default = FND_API.G_VALID_LEVEL_FULL
1433 -- p_check_login_user VARCHAR2 Optional
1434 -- Default = FND_API.G_TRUE
1435 -- Flag for checking user privilege and if user is login.
1436 -- p_group_id NUMBER Required
1437 -- OUT : x_return_status VARCHAR2
1438 -- x_msg_count NUMBER
1439 -- x_msg_data VARCHAR2
1440 -- x_group_obj AMV_GROUP2_OBJ_TYPE
1441 -- Version : Current version 1.0
1442 -- Previous version 1.0
1443 -- Initial version 1.0
1444 -- Notes :
1445 -- End of comments
1446 --
1447 PROCEDURE Get_Group
1448 (
1449 p_api_version IN NUMBER,
1453 x_msg_count OUT NOCOPY NUMBER,
1450 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1451 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1452 x_return_status OUT NOCOPY VARCHAR2,
1454 x_msg_data OUT NOCOPY VARCHAR2,
1455 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1456 p_group_id IN NUMBER,
1457 x_group_obj OUT NOCOPY AMV_GROUP_OBJ_TYPE
1458 );
1459 --------------------------------------------------------------------------------
1460 -- Start of comments
1461 -- API name : Find_Group
1462 -- Type : Private
1463 -- Pre-reqs : None
1464 -- Function : Query for resource groups
1465 -- Parameters :
1466 -- IN p_api_version NUMBER Required
1467 -- p_init_msg_list VARCHAR2 Optional
1468 -- Default = FND_API.G_FALSE
1469 -- p_validation_level NUMBER Optional
1470 -- Default = FND_API.G_VALID_LEVEL_FULL
1471 -- p_check_login_user VARCHAR2 Optional
1472 -- Default = FND_API.G_TRUE
1473 -- Flag for checking user privilege and if user is login.
1474 -- p_resource_id NUMBER Optional
1475 -- default FND_API.G_MISS_NUM,
1476 -- p_group_name VARCHAR2 Optional
1477 -- default FND_API.G_MISS_CHAR
1478 -- p_group_desc VARCHAR2 Optional
1479 -- default FND_API.G_MISS_CHAR
1480 -- p_owner_id NUMBER Optional
1481 -- default FND_API.G_MISS_NUM
1482 -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE
1483 -- Required.
1484 -- OUT : x_return_status VARCHAR2
1485 -- x_msg_count NUMBER
1486 -- x_msg_data VARCHAR2
1487 -- x_subset_return_obj AMV_RETURN_OBJ_TYPE
1488 -- x_resource_obj_array AMV_RESOURCE_OBJ_VARRAY
1489 -- Version : Current version 1.0
1490 -- Previous version 1.0
1491 -- Initial version 1.0
1492 -- Notes :
1493 -- End of comments
1494 --
1495 PROCEDURE Find_Group
1496 (
1497 p_api_version IN NUMBER,
1498 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1499 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1500 x_return_status OUT NOCOPY VARCHAR2,
1501 x_msg_count OUT NOCOPY NUMBER,
1502 x_msg_data OUT NOCOPY VARCHAR2,
1503 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1504 p_resource_id IN NUMBER := FND_API.G_MISS_NUM,
1505 p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1506 p_group_desc IN VARCHAR2 := FND_API.G_MISS_CHAR,
1507 p_group_email IN VARCHAR2 := FND_API.G_MISS_CHAR,
1508 p_group_usage IN VARCHAR2,
1509 p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
1510 x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
1511 x_group_obj_array OUT NOCOPY AMV_GROUP_OBJ_VARRAY
1512 );
1513 --------------------------------------------------------------------------------
1514 -- Start of comments
1515 -- API name : Find_Group
1516 -- Type : Private
1517 -- Pre-reqs : None
1518 -- Function : Query for resource groups
1519 -- Parameters :
1520 -- IN p_api_version NUMBER Required
1521 -- p_init_msg_list VARCHAR2 Optional
1522 -- Default = FND_API.G_FALSE
1523 -- p_validation_level NUMBER Optional
1524 -- Default = FND_API.G_VALID_LEVEL_FULL
1525 -- p_check_login_user VARCHAR2 Optional
1526 -- Default = FND_API.G_TRUE
1527 -- Flag for checking user privilege and if user is login.
1528 -- p_resource_id NUMBER Optional
1529 -- default FND_API.G_MISS_NUM,
1530 -- p_group_name VARCHAR2 Optional
1531 -- default FND_API.G_MISS_CHAR
1532 -- p_group_desc VARCHAR2 Optional
1533 -- default FND_API.G_MISS_CHAR
1534 -- p_owner_id NUMBER Optional
1535 -- default FND_API.G_MISS_NUM
1536 -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE
1537 -- Required.
1538 -- OUT : x_return_status VARCHAR2
1539 -- x_msg_count NUMBER
1540 -- x_msg_data VARCHAR2
1541 -- x_subset_return_obj AMV_RETURN_OBJ_TYPE
1542 -- x_resource_obj_array AMV_RESOURCE_OBJ_VARRAY
1543 -- Version : Current version 1.0
1544 -- Previous version 1.0
1545 -- Initial version 1.0
1546 -- Notes :
1547 -- End of comments
1548 --
1549 PROCEDURE Find_Group
1550 (
1551 p_api_version IN NUMBER,
1552 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1553 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1557 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1554 x_return_status OUT NOCOPY VARCHAR2,
1555 x_msg_count OUT NOCOPY NUMBER,
1556 x_msg_data OUT NOCOPY VARCHAR2,
1558 p_group_id IN NUMBER := FND_API.G_MISS_NUM,
1559 p_group_name IN VARCHAR2 := FND_API.G_MISS_CHAR,
1560 p_group_usage IN VARCHAR2,
1561 p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
1562 x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
1563 x_group_obj_array OUT NOCOPY AMV_GROUP_OBJ_VARRAY,
1564 x_role_code_varray OUT NOCOPY AMV_CHAR_VARRAY_TYPE
1565 );
1566 --------------------------------------------------------------------------------
1567 --------------------------- GROUP MEMBERSHIP ----------------------------------
1568 --------------------------------------------------------------------------------
1569 -- Start of comments
1570 -- API name : Add_GroupMember
1571 -- Type : Private
1572 -- Pre-reqs : None
1573 -- Function : Add a resource to a group.
1574 -- Parameters :
1575 -- IN p_api_version NUMBER Required
1576 -- p_init_msg_list VARCHAR2 Optional
1577 -- Default = FND_API.G_FALSE
1578 -- p_commit VARCHAR2 Optional
1579 -- Default = FND_API.G_FALSE
1580 -- p_validation_level NUMBER Optional
1581 -- Default = FND_API.G_VALID_LEVEL_FULL
1582 -- p_check_login_user VARCHAR2 Optional
1583 -- Default = FND_API.G_TRUE
1584 -- Flag for checking user privilege and if user is login.
1585 -- p_group_id NUMBER Required
1586 -- the id of the group
1587 -- p_resource_id NUMBER Required
1588 -- p_start_date DATE Optional
1589 -- default NULL
1590 -- p_end_date DATE Optional
1591 -- default NULL
1592 -- OUT : x_return_status VARCHAR2
1593 -- x_msg_count NUMBER
1594 -- x_msg_data VARCHAR2
1595 -- Version : Current version 1.0
1596 -- Previous version 1.0
1597 -- Initial version 1.0
1598 -- Notes :
1599 -- End of comments
1600 --
1601 PROCEDURE Add_GroupMember
1602 (
1603 p_api_version IN NUMBER,
1604 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1605 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1606 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1607 x_return_status OUT NOCOPY VARCHAR2,
1608 x_msg_count OUT NOCOPY NUMBER,
1609 x_msg_data OUT NOCOPY VARCHAR2,
1610 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1611 p_group_id IN NUMBER,
1612 p_resource_id IN NUMBER
1613 );
1614 --------------------------------------------------------------------------------
1615 -- Start of comments
1616 -- API name : Add_GroupMember
1617 -- Type : Private
1618 -- Pre-reqs : None
1619 -- Function : Add a few resources to a group.
1620 -- Parameters :
1621 -- IN p_api_version NUMBER Required
1622 -- p_init_msg_list VARCHAR2 Optional
1623 -- Default = FND_API.G_FALSE
1624 -- p_commit VARCHAR2 Optional
1625 -- Default = FND_API.G_FALSE
1626 -- p_validation_level NUMBER Optional
1627 -- Default = FND_API.G_VALID_LEVEL_FULL
1628 -- p_check_login_user VARCHAR2 Optional
1629 -- Default = FND_API.G_TRUE
1630 -- Flag for checking user privilege and if user is login.
1631 -- p_group_id NUMBER Required
1632 -- p_resource_id_varray AMV_NUMBER_VARRAY_TYPE
1633 -- OUT : x_return_status VARCHAR2
1634 -- x_msg_count NUMBER
1635 -- x_msg_data VARCHAR2
1636 -- Version : Current version 1.0
1637 -- Previous version 1.0
1638 -- Initial version 1.0
1639 -- Notes :
1640 -- End of comments
1641 --
1642 PROCEDURE Add_GroupMember
1643 (
1644 p_api_version IN NUMBER,
1645 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1646 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1647 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1648 x_return_status OUT NOCOPY VARCHAR2,
1649 x_msg_count OUT NOCOPY NUMBER,
1650 x_msg_data OUT NOCOPY VARCHAR2,
1651 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1652 p_group_id IN NUMBER,
1653 p_resource_id_varray IN AMV_NUMBER_VARRAY_TYPE
1654 );
1655 --------------------------------------------------------------------------------
1656 -- Start of comments
1657 -- API name : Remove_GroupMember
1658 -- Type : Private
1659 -- Pre-reqs : None
1660 -- Function : Remove a resource from a group.
1661 -- Parameters :
1662 -- IN p_api_version NUMBER Required
1666 -- Default = FND_API.G_FALSE
1663 -- p_init_msg_list VARCHAR2 Optional
1664 -- Default = FND_API.G_FALSE
1665 -- p_commit VARCHAR2 Optional
1667 -- p_validation_level NUMBER Optional
1668 -- Default = FND_API.G_VALID_LEVEL_FULL
1669 -- p_check_login_user VARCHAR2 Optional
1670 -- Default = FND_API.G_TRUE
1671 -- Flag for checking user privilege and if user is login.
1672 -- p_group_id NUMBER Required
1673 -- the id of the group
1674 -- p_resource_id NUMBER Required
1675 -- OUT : x_return_status VARCHAR2
1676 -- x_msg_count NUMBER
1677 -- x_msg_data VARCHAR2
1678 -- Version : Current version 1.0
1679 -- Previous version 1.0
1680 -- Initial version 1.0
1681 -- Notes :
1682 -- End of comments
1683 --
1684 PROCEDURE Remove_GroupMember
1685 (
1686 p_api_version IN NUMBER,
1687 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1688 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1689 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1690 x_return_status OUT NOCOPY VARCHAR2,
1691 x_msg_count OUT NOCOPY NUMBER,
1692 x_msg_data OUT NOCOPY VARCHAR2,
1693 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1694 p_group_id IN NUMBER,
1695 p_resource_id IN NUMBER
1696 );
1697 --------------------------------------------------------------------------------
1698 -- Start of comments
1699 -- API name : Remove_GroupMember
1700 -- Type : Private
1701 -- Pre-reqs : None
1702 -- Function : Remove a few resources from a group.
1703 -- Parameters :
1704 -- IN p_api_version NUMBER Required
1705 -- p_init_msg_list VARCHAR2 Optional
1706 -- Default = FND_API.G_FALSE
1707 -- p_commit VARCHAR2 Optional
1708 -- Default = FND_API.G_FALSE
1709 -- p_validation_level NUMBER Optional
1710 -- Default = FND_API.G_VALID_LEVEL_FULL
1711 -- p_check_login_user VARCHAR2 Optional
1712 -- Default = FND_API.G_TRUE
1713 -- Flag for checking user privilege and if user is login.
1714 -- p_group_id NUMBER Required
1715 -- p_resource_id_varray AMV_NUMBER_VARRAY_TYPE
1716 -- OUT : x_return_status VARCHAR2
1717 -- x_msg_count NUMBER
1718 -- x_msg_data VARCHAR2
1719 -- Version : Current version 1.0
1720 -- Previous version 1.0
1721 -- Initial version 1.0
1722 -- Notes :
1723 -- End of comments
1724 --
1725 PROCEDURE Remove_GroupMember
1726 (
1727 p_api_version IN NUMBER,
1728 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1729 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1730 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1731 x_return_status OUT NOCOPY VARCHAR2,
1732 x_msg_count OUT NOCOPY NUMBER,
1733 x_msg_data OUT NOCOPY VARCHAR2,
1734 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1735 p_group_id IN NUMBER,
1736 p_resource_id_varray IN AMV_NUMBER_VARRAY_TYPE
1737 );
1738 --------------------------------------------------------------------------------
1739 -- Start of comments
1740 -- API name : Check_GroupMember
1741 -- Type : Private
1742 -- Pre-reqs : None
1743 -- Function : Check if a resource belong to a group.
1744 -- Parameters :
1745 -- IN p_api_version NUMBER Required
1746 -- p_init_msg_list VARCHAR2 Optional
1747 -- Default = FND_API.G_FALSE
1748 -- p_commit VARCHAR2 Optional
1749 -- Default = FND_API.G_FALSE
1750 -- p_validation_level NUMBER Optional
1751 -- Default = FND_API.G_VALID_LEVEL_FULL
1752 -- p_check_login_user VARCHAR2 Optional
1753 -- Default = FND_API.G_TRUE
1754 -- Flag for checking user privilege and if user is login.
1755 -- p_group_id NUMBER Required
1756 -- p_resource_id NUMBER Required
1757 -- p_check_effective_date VARCHAR2 Optional
1758 -- default FND_API.G_TRUE
1759 -- OUT : x_return_status VARCHAR2
1760 -- x_msg_count NUMBER
1761 -- x_msg_data VARCHAR2
1762 -- x_result_flag VARCHAR2
1763 -- Version : Current version 1.0
1764 -- Previous version 1.0
1765 -- Initial version 1.0
1766 -- Notes :
1767 -- End of comments
1768 --
1769 PROCEDURE Check_GroupMember
1770 (
1774 x_return_status OUT NOCOPY VARCHAR2,
1771 p_api_version IN NUMBER,
1772 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1773 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1775 x_msg_count OUT NOCOPY NUMBER,
1776 x_msg_data OUT NOCOPY VARCHAR2,
1777 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1778 p_group_id IN NUMBER,
1779 p_resource_id IN NUMBER,
1780 x_result_flag OUT NOCOPY VARCHAR2
1781 );
1782 /*
1783 --------------------------------------------------------------------------------
1784 -- Start of comments
1785 -- API name : Get_AllGroupMember
1786 -- Type : Private
1787 -- Pre-reqs : None
1788 -- Function : Get all the group resources given the group.
1789 -- Parameters :
1790 -- IN p_api_version NUMBER Required
1791 -- p_init_msg_list VARCHAR2 Optional
1792 -- Default = FND_API.G_FALSE
1793 -- p_validation_level NUMBER Optional
1794 -- Default = FND_API.G_VALID_LEVEL_FULL
1795 -- p_check_login_user VARCHAR2 Optional
1796 -- Default = FND_API.G_TRUE
1797 -- Flag for checking user privilege and if user is login.
1798 -- p_group_id NUMBER Optional
1799 -- default FND_API.G_MISS_NUM,
1800 -- p_subset_request_obj AMV_REQUEST_OBJ_TYPE
1801 -- Required.
1802 -- OUT : x_return_status VARCHAR2
1803 -- x_msg_count NUMBER
1804 -- x_msg_data VARCHAR2
1805 -- x_subset_return_obj AMV_RETURN_OBJ_TYPE
1806 -- x_resource_obj_array AMV_RESOURCE_OBJ_VARRAY
1807 -- Version : Current version 1.0
1808 -- Previous version 1.0
1809 -- Initial version 1.0
1810 -- Notes :
1811 -- End of comments
1812 --
1813 PROCEDURE Get_AllGroupMember
1814 (
1815 p_api_version IN NUMBER,
1816 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1817 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1818 x_return_status OUT NOCOPY VARCHAR2,
1819 x_msg_count OUT NOCOPY NUMBER,
1820 x_msg_data OUT NOCOPY VARCHAR2,
1821 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1822 p_group_id IN NUMBER := FND_API.G_MISS_NUM,
1823 p_subset_request_obj IN AMV_REQUEST_OBJ_TYPE,
1824 x_subset_return_obj OUT NOCOPY AMV_RETURN_OBJ_TYPE,
1825 x_resource_obj_array OUT NOCOPY AMV_RESOURCE_OBJ_VARRAY
1826 );
1827 */
1828 --------------------------------------------------------------------------------
1829 --------------------------- RESOURCE ACCESS ----------------------------------
1830 --------------------------------------------------------------------------------
1831 -- Start of comments
1832 -- API name : Update_Access
1833 -- Type : Private
1834 -- Pre-reqs : None
1835 -- Function : Update the resource or group object access.
1836 -- Object can be application, channel, category, or item
1837 -- Parameters :
1838 -- IN p_api_version NUMBER Required
1839 -- p_init_msg_list VARCHAR2 Optional
1840 -- Default = FND_API.G_FALSE
1841 -- p_commit VARCHAR2 Optional
1842 -- Default = FND_API.G_FALSE
1843 -- p_validation_level NUMBER Optional
1844 -- Default = FND_API.G_VALID_LEVEL_FULL
1845 -- p_check_login_user VARCHAR2 Optional
1846 -- Default = FND_API.G_TRUE
1847 -- Flag for checking user privilege and if user is login.
1848 -- p_access_obj AMV_ACCESS_OBJ_TYPE
1849 -- OUT : x_return_status VARCHAR2
1850 -- x_msg_count NUMBER
1851 -- x_msg_data VARCHAR2
1852 -- Version : Current version 1.0
1853 -- Previous version 1.0
1854 -- Initial version 1.0
1855 -- Notes :
1856 -- End of comments
1857 --
1858 PROCEDURE Update_Access
1859 (
1860 p_api_version IN NUMBER,
1861 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1862 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1863 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1864 x_return_status OUT NOCOPY VARCHAR2,
1865 x_msg_count OUT NOCOPY NUMBER,
1866 x_msg_data OUT NOCOPY VARCHAR2,
1867 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1868 p_access_obj IN AMV_ACCESS_OBJ_TYPE
1869 );
1870 --------------------------------------------------------------------------------
1871 -- Start of comments
1872 -- API name : Update_Access
1873 -- Type : Private
1874 -- Pre-reqs : None
1875 -- Function : Update the resource or group object access.
1876 -- Object can be application, channel, category, or item
1877 -- Parameters :
1878 -- IN p_api_version NUMBER Required
1882 -- Default = FND_API.G_FALSE
1879 -- p_init_msg_list VARCHAR2 Optional
1880 -- Default = FND_API.G_FALSE
1881 -- p_commit VARCHAR2 Optional
1883 -- p_validation_level NUMBER Optional
1884 -- Default = FND_API.G_VALID_LEVEL_FULL
1885 -- p_check_login_user VARCHAR2 Optional
1886 -- Default = FND_API.G_TRUE
1887 -- Flag for checking user privilege and if user is login.
1888 -- p_access_obj AMV_ACCESS_OBJ_TYPE
1889 -- OUT : x_return_status VARCHAR2
1890 -- x_msg_count NUMBER
1891 -- x_msg_data VARCHAR2
1892 -- Version : Current version 1.0
1893 -- Previous version 1.0
1894 -- Initial version 1.0
1895 -- Notes :
1896 -- End of comments
1897 --
1898 PROCEDURE Update_Access
1899 (
1900 p_api_version IN NUMBER,
1901 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1902 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1903 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1904 x_return_status OUT NOCOPY VARCHAR2,
1905 x_msg_count OUT NOCOPY NUMBER,
1906 x_msg_data OUT NOCOPY VARCHAR2,
1907 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1908 p_access_obj_array IN AMV_ACCESS_OBJ_VARRAY
1909 );
1910 --------------------------------------------------------------------------------
1911 -- Start of comments
1912 -- API name : Update_ResourceApplAccess
1913 -- Type : Private
1914 -- Pre-reqs : None
1915 -- Function : Update all the accesses of a resource with an application
1916 -- Parameters :
1917 -- IN p_api_version NUMBER Required
1918 -- p_init_msg_list VARCHAR2 Optional
1919 -- Default = FND_API.G_FALSE
1920 -- p_commit VARCHAR2 Optional
1921 -- Default = FND_API.G_FALSE
1922 -- p_validation_level NUMBER Optional
1923 -- Default = FND_API.G_VALID_LEVEL_FULL
1924 -- p_check_login_user VARCHAR2 Optional
1925 -- Default = FND_API.G_TRUE
1926 -- Flag for checking user privilege and if user is login.
1927 -- p_resource_id NUMBER Required
1928 -- p_application_id NUMBER Required
1929 -- p_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
1930 -- OUT : x_return_status VARCHAR2
1931 -- x_msg_count NUMBER
1932 -- x_msg_data VARCHAR2
1933 -- Version : Current version 1.0
1934 -- Previous version 1.0
1935 -- Initial version 1.0
1936 -- Notes :
1937 -- End of comments
1938 --
1939 PROCEDURE Update_ResourceApplAccess
1940 (
1941 p_api_version IN NUMBER,
1942 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1943 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1944 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1945 x_return_status OUT NOCOPY VARCHAR2,
1946 x_msg_count OUT NOCOPY NUMBER,
1947 x_msg_data OUT NOCOPY VARCHAR2,
1948 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1949 p_resource_id IN NUMBER,
1950 p_application_id IN NUMBER,
1951 p_access_flag_obj IN AMV_ACCESS_FLAG_OBJ_TYPE
1952 );
1953 --------------------------------------------------------------------------------
1954 -- Start of comments
1955 -- API name : Update_ResourceChanAccess
1956 -- Type : Private
1957 -- Pre-reqs : None
1958 -- Function : Update all the accesses of a resource with a channel
1959 -- Parameters :
1960 -- IN p_api_version NUMBER Required
1961 -- p_init_msg_list VARCHAR2 Optional
1962 -- Default = FND_API.G_FALSE
1963 -- p_commit VARCHAR2 Optional
1964 -- Default = FND_API.G_FALSE
1965 -- p_validation_level NUMBER Optional
1966 -- Default = FND_API.G_VALID_LEVEL_FULL
1967 -- p_check_login_user VARCHAR2 Optional
1968 -- Default = FND_API.G_TRUE
1969 -- Flag for checking user privilege and if user is login.
1970 -- p_resource_id NUMBER Required
1971 -- p_channel_id NUMBER Required
1972 -- p_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
1973 -- OUT : x_return_status VARCHAR2
1974 -- x_msg_count NUMBER
1975 -- x_msg_data VARCHAR2
1976 -- Version : Current version 1.0
1977 -- Previous version 1.0
1978 -- Initial version 1.0
1979 -- Notes :
1980 -- End of comments
1981 --
1982 PROCEDURE Update_ResourceChanAccess
1983 (
1984 p_api_version IN NUMBER,
1988 x_return_status OUT NOCOPY VARCHAR2,
1985 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1986 p_commit IN VARCHAR2 := FND_API.G_FALSE,
1987 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1989 x_msg_count OUT NOCOPY NUMBER,
1990 x_msg_data OUT NOCOPY VARCHAR2,
1991 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
1992 p_resource_id IN NUMBER,
1993 p_channel_id IN NUMBER,
1994 p_access_flag_obj IN AMV_ACCESS_FLAG_OBJ_TYPE
1995 );
1996 --------------------------------------------------------------------------------
1997 -- Start of comments
1998 -- API name : Update_ResourceCateAccess
1999 -- Type : Private
2000 -- Pre-reqs : None
2001 -- Function : Update all the accesses of a resource with a category
2002 -- Parameters :
2003 -- IN p_api_version NUMBER Required
2004 -- p_init_msg_list VARCHAR2 Optional
2005 -- Default = FND_API.G_FALSE
2006 -- p_commit VARCHAR2 Optional
2007 -- Default = FND_API.G_FALSE
2008 -- p_validation_level NUMBER Optional
2009 -- Default = FND_API.G_VALID_LEVEL_FULL
2010 -- p_check_login_user VARCHAR2 Optional
2011 -- Default = FND_API.G_TRUE
2012 -- Flag for checking user privilege and if user is login.
2013 -- p_resource_id NUMBER Required
2014 -- p_category_id NUMBER Required
2015 -- p_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
2016 -- OUT : x_return_status VARCHAR2
2017 -- x_msg_count NUMBER
2018 -- x_msg_data VARCHAR2
2019 -- Version : Current version 1.0
2020 -- Previous version 1.0
2021 -- Initial version 1.0
2022 -- Notes :
2023 -- End of comments
2024 --
2025 PROCEDURE Update_ResourceCateAccess
2026 (
2027 p_api_version IN NUMBER,
2028 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2029 p_commit IN VARCHAR2 := FND_API.G_FALSE,
2030 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2031 x_return_status OUT NOCOPY VARCHAR2,
2032 x_msg_count OUT NOCOPY NUMBER,
2033 x_msg_data OUT NOCOPY VARCHAR2,
2034 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2035 p_resource_id IN NUMBER,
2036 p_category_id IN NUMBER,
2037 p_access_flag_obj IN AMV_ACCESS_FLAG_OBJ_TYPE
2038 );
2039 --------------------------------------------------------------------------------
2040 -- Start of comments
2041 -- API name : Update_ResourceItemAccess
2042 -- Type : Private
2043 -- Pre-reqs : None
2044 -- Function : Update all the accesses of a resource with a item
2045 -- Parameters :
2046 -- IN p_api_version NUMBER Required
2047 -- p_init_msg_list VARCHAR2 Optional
2048 -- Default = FND_API.G_FALSE
2049 -- p_commit VARCHAR2 Optional
2050 -- Default = FND_API.G_FALSE
2051 -- p_validation_level NUMBER Optional
2052 -- Default = FND_API.G_VALID_LEVEL_FULL
2053 -- p_check_login_user VARCHAR2 Optional
2054 -- Default = FND_API.G_TRUE
2055 -- Flag for checking user privilege and if user is login.
2056 -- p_resource_id NUMBER Required
2057 -- p_item_id NUMBER Required
2058 -- p_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
2059 -- OUT : x_return_status VARCHAR2
2060 -- x_msg_count NUMBER
2061 -- x_msg_data VARCHAR2
2062 -- Version : Current version 1.0
2063 -- Previous version 1.0
2064 -- Initial version 1.0
2065 -- Notes :
2066 -- End of comments
2067 --
2068 PROCEDURE Update_ResourceItemAccess
2069 (
2070 p_api_version IN NUMBER,
2071 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2072 p_commit IN VARCHAR2 := FND_API.G_FALSE,
2073 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2074 x_return_status OUT NOCOPY VARCHAR2,
2075 x_msg_count OUT NOCOPY NUMBER,
2076 x_msg_data OUT NOCOPY VARCHAR2,
2077 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2078 p_resource_id IN NUMBER,
2079 p_item_id IN NUMBER,
2080 p_access_flag_obj IN AMV_ACCESS_FLAG_OBJ_TYPE
2081 );
2082 --------------------------------------------------------------------------------
2083 -- Start of comments
2084 -- API name : Update_GroupApplAccess
2085 -- Type : Private
2086 -- Pre-reqs : None
2087 -- Function : Update all the accesses of a group with an application
2088 -- Parameters :
2089 -- IN p_api_version NUMBER Required
2090 -- p_init_msg_list VARCHAR2 Optional
2091 -- Default = FND_API.G_FALSE
2095 -- Default = FND_API.G_VALID_LEVEL_FULL
2092 -- p_commit VARCHAR2 Optional
2093 -- Default = FND_API.G_FALSE
2094 -- p_validation_level NUMBER Optional
2096 -- p_check_login_user VARCHAR2 Optional
2097 -- Default = FND_API.G_TRUE
2098 -- Flag for checking user privilege and if user is login.
2099 -- p_group_id NUMBER Required
2100 -- p_application_id NUMBER Required
2101 -- p_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
2102 -- OUT : x_return_status VARCHAR2
2103 -- x_msg_count NUMBER
2104 -- x_msg_data VARCHAR2
2105 -- Version : Current version 1.0
2106 -- Previous version 1.0
2107 -- Initial version 1.0
2108 -- Notes :
2109 -- End of comments
2110 --
2111 PROCEDURE Update_GroupApplAccess
2112 (
2113 p_api_version IN NUMBER,
2114 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2115 p_commit IN VARCHAR2 := FND_API.G_FALSE,
2116 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2117 x_return_status OUT NOCOPY VARCHAR2,
2118 x_msg_count OUT NOCOPY NUMBER,
2119 x_msg_data OUT NOCOPY VARCHAR2,
2120 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2121 p_resource_id IN NUMBER,
2122 p_group_id IN NUMBER,
2123 p_application_id IN NUMBER,
2124 p_access_flag_obj IN AMV_ACCESS_FLAG_OBJ_TYPE
2125 );
2126 --------------------------------------------------------------------------------
2127 -- Start of comments
2128 -- API name : Update_GroupChanAccess
2129 -- Type : Private
2130 -- Pre-reqs : None
2131 -- Function : Update all the accesses of a group with a channel
2132 -- Parameters :
2133 -- IN p_api_version NUMBER Required
2134 -- p_init_msg_list VARCHAR2 Optional
2135 -- Default = FND_API.G_FALSE
2136 -- p_commit VARCHAR2 Optional
2137 -- Default = FND_API.G_FALSE
2138 -- p_validation_level NUMBER Optional
2139 -- Default = FND_API.G_VALID_LEVEL_FULL
2140 -- p_check_login_user VARCHAR2 Optional
2141 -- Default = FND_API.G_TRUE
2142 -- Flag for checking user privilege and if user is login.
2143 -- p_group_id NUMBER Required
2144 -- p_channel_id NUMBER Required
2145 -- p_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
2146 -- OUT : x_return_status VARCHAR2
2147 -- x_msg_count NUMBER
2148 -- x_msg_data VARCHAR2
2149 -- Version : Current version 1.0
2150 -- Previous version 1.0
2151 -- Initial version 1.0
2152 -- Notes :
2153 -- End of comments
2154 --
2155 PROCEDURE Update_GroupChanAccess
2156 (
2157 p_api_version IN NUMBER,
2158 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2159 p_commit IN VARCHAR2 := FND_API.G_FALSE,
2160 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2161 x_return_status OUT NOCOPY VARCHAR2,
2162 x_msg_count OUT NOCOPY NUMBER,
2163 x_msg_data OUT NOCOPY VARCHAR2,
2164 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2165 p_group_id IN NUMBER,
2166 p_channel_id IN NUMBER,
2167 p_access_flag_obj IN AMV_ACCESS_FLAG_OBJ_TYPE
2168 );
2169 --------------------------------------------------------------------------------
2170 -- Start of comments
2171 -- API name : Update_GroupCateAccess
2172 -- Type : Private
2173 -- Pre-reqs : None
2174 -- Function : Update all the accesses of a group with a category
2175 -- Parameters :
2176 -- IN p_api_version NUMBER Required
2177 -- p_init_msg_list VARCHAR2 Optional
2178 -- Default = FND_API.G_FALSE
2179 -- p_commit VARCHAR2 Optional
2180 -- Default = FND_API.G_FALSE
2181 -- p_validation_level NUMBER Optional
2182 -- Default = FND_API.G_VALID_LEVEL_FULL
2183 -- p_check_login_user VARCHAR2 Optional
2184 -- Default = FND_API.G_TRUE
2185 -- Flag for checking user privilege and if user is login.
2186 -- p_group_id NUMBER Required
2187 -- p_category_id NUMBER Required
2188 -- p_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
2189 -- OUT : x_return_status VARCHAR2
2190 -- x_msg_count NUMBER
2191 -- x_msg_data VARCHAR2
2192 -- Version : Current version 1.0
2193 -- Previous version 1.0
2194 -- Initial version 1.0
2195 -- Notes :
2196 -- End of comments
2200 p_api_version IN NUMBER,
2197 --
2198 PROCEDURE Update_GroupCateAccess
2199 (
2201 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2202 p_commit IN VARCHAR2 := FND_API.G_FALSE,
2203 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2204 x_return_status OUT NOCOPY VARCHAR2,
2205 x_msg_count OUT NOCOPY NUMBER,
2206 x_msg_data OUT NOCOPY VARCHAR2,
2207 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2208 p_group_id IN NUMBER,
2209 p_category_id IN NUMBER,
2210 p_access_flag_obj IN AMV_ACCESS_FLAG_OBJ_TYPE
2211 );
2212 --------------------------------------------------------------------------------
2213 -- Start of comments
2214 -- API name : Update_GroupItemAccess
2215 -- Type : Private
2216 -- Pre-reqs : None
2217 -- Function : Update all the accesses of a group with a item
2218 -- Parameters :
2219 -- IN p_api_version NUMBER Required
2220 -- p_init_msg_list VARCHAR2 Optional
2221 -- Default = FND_API.G_FALSE
2222 -- p_commit VARCHAR2 Optional
2223 -- Default = FND_API.G_FALSE
2224 -- p_validation_level NUMBER Optional
2225 -- Default = FND_API.G_VALID_LEVEL_FULL
2226 -- p_check_login_user VARCHAR2 Optional
2227 -- Default = FND_API.G_TRUE
2228 -- Flag for checking user privilege and if user is login.
2229 -- p_group_id NUMBER Required
2230 -- p_item_id NUMBER Required
2231 -- p_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
2232 -- OUT : x_return_status VARCHAR2
2233 -- x_msg_count NUMBER
2234 -- x_msg_data VARCHAR2
2235 -- Version : Current version 1.0
2236 -- Previous version 1.0
2237 -- Initial version 1.0
2238 -- Notes : This overloaded version is for (user/group) administrator
2239 -- page to use.
2240 -- End of comments
2241 --
2242 PROCEDURE Update_GroupItemAccess
2243 (
2244 p_api_version IN NUMBER,
2245 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2246 p_commit IN VARCHAR2 := FND_API.G_FALSE,
2247 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2248 x_return_status OUT NOCOPY VARCHAR2,
2249 x_msg_count OUT NOCOPY NUMBER,
2250 x_msg_data OUT NOCOPY VARCHAR2,
2251 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2252 p_group_id IN NUMBER,
2253 p_item_id IN NUMBER,
2254 p_access_flag_obj IN AMV_ACCESS_FLAG_OBJ_TYPE
2255 );
2256 --------------------------------------------------------------------------------
2257 -- Start of comments
2258 -- API name : Get_BusinessObjectAccess
2259 -- Type : Private
2260 -- Pre-reqs : None
2261 -- Function : Retrieve all the access of a resource/group
2262 -- with a business object
2263 -- Parameters :
2264 -- IN p_api_version NUMBER Required
2265 -- p_init_msg_list VARCHAR2 Optional
2266 -- Default = FND_API.G_FALSE
2267 -- p_validation_level NUMBER Optional
2268 -- Default = FND_API.G_VALID_LEVEL_FULL
2269 -- p_check_login_user VARCHAR2 Optional
2270 -- Default = FND_API.G_TRUE
2271 -- Flag for checking user privilege and if user is login.
2272 -- p_user_or_group_id NUMBER Required
2273 -- p_user_or_group_type VARCHAR2 Required
2274 -- p_business_object_id NUMBER Required
2275 -- p_business_object_type VARCHAR2 Required
2276 -- here business object can be item, channel, category,
2277 -- and application
2278 -- OUT : x_return_status VARCHAR2
2279 -- x_msg_count NUMBER
2280 -- x_msg_data VARCHAR2
2281 -- x_access_obj AMV_ACCESS_OBJ_TYPE
2282 -- Version : Current version 1.0
2283 -- Previous version 1.0
2284 -- Initial version 1.0
2285 -- Notes :
2286 -- End of comments
2287 --
2288 PROCEDURE Get_BusinessObjectAccess
2289 (
2290 p_api_version IN NUMBER,
2291 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2292 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2293 x_return_status OUT NOCOPY VARCHAR2,
2294 x_msg_count OUT NOCOPY NUMBER,
2295 x_msg_data OUT NOCOPY VARCHAR2,
2296 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2297 p_user_or_group_id IN NUMBER,
2298 p_user_or_group_type IN VARCHAR2,
2299 p_business_object_id IN NUMBER,
2300 p_business_object_type IN VARCHAR2,
2301 x_access_obj OUT NOCOPY AMV_ACCESS_OBJ_TYPE
2302 );
2303 --------------------------------------------------------------------------------
2304 -- Start of comments
2305 -- API name : Get_ChannelAccess
2309 -- Parameters :
2306 -- Type : Private
2307 -- Pre-reqs : None
2308 -- Function : Retrieve all the channel access of a resource/group
2310 -- IN p_api_version NUMBER Required
2311 -- p_init_msg_list VARCHAR2 Optional
2312 -- Default = FND_API.G_FALSE
2313 -- p_validation_level NUMBER Optional
2314 -- Default = FND_API.G_VALID_LEVEL_FULL
2315 -- p_check_login_user VARCHAR2 Optional
2316 -- Default = FND_API.G_TRUE
2317 -- Flag for checking user privilege and if user is login.
2318 -- p_user_or_group_id NUMBER Required
2319 -- p_user_or_group_type VARCHAR2 Required
2320 -- OUT : x_return_status VARCHAR2
2321 -- x_msg_count NUMBER
2322 -- x_msg_data VARCHAR2
2323 -- x_channel_name_varray AMV_CHAR_VARRAY_TYPE,
2324 -- x_access_obj_varray AMV_ACCESS_OBJ_VARRAY
2325 -- Version : Current version 1.0
2326 -- Previous version 1.0
2327 -- Initial version 1.0
2328 -- Notes :
2329 -- End of comments
2330 --
2331 PROCEDURE Get_ChannelAccess
2332 (
2333 p_api_version IN NUMBER,
2334 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2335 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2336 x_return_status OUT NOCOPY VARCHAR2,
2337 x_msg_count OUT NOCOPY NUMBER,
2338 x_msg_data OUT NOCOPY VARCHAR2,
2339 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2340 p_user_or_group_id IN NUMBER,
2341 p_user_or_group_type IN VARCHAR2,
2342 x_channel_name_varray OUT NOCOPY AMV_CHAR_VARRAY_TYPE,
2343 x_access_obj_varray OUT NOCOPY AMV_ACCESS_OBJ_VARRAY
2344 );
2345 --------------------------------------------------------------------------------
2346 -- Start of comments
2347 -- API name : Get_AccessPerChannel
2348 -- Type : Private
2349 -- Pre-reqs : None
2350 -- Function : Retrieve all the channel user/group access of a fixed channel
2351 -- Parameters :
2352 -- IN p_api_version NUMBER Required
2353 -- p_init_msg_list VARCHAR2 Optional
2354 -- Default = FND_API.G_FALSE
2355 -- p_validation_level NUMBER Optional
2356 -- Default = FND_API.G_VALID_LEVEL_FULL
2357 -- p_check_login_user VARCHAR2 Optional
2358 -- Default = FND_API.G_TRUE
2359 -- Flag for checking user privilege and if user is login.
2360 -- p_channel_id NUMBER Required
2361 -- p_user_or_group_type VARCHAR2 Required
2362 -- OUT : x_return_status VARCHAR2
2363 -- x_msg_count NUMBER
2364 -- x_msg_data VARCHAR2
2365 -- x_name_varray AMV_CHAR_VARRAY_TYPE,
2366 -- x_access_obj_varray AMV_ACCESS_OBJ_VARRAY
2367 -- Version : Current version 1.0
2368 -- Previous version 1.0
2369 -- Initial version 1.0
2370 -- Notes :
2371 -- End of comments
2372 --
2373 PROCEDURE Get_AccessPerChannel
2374 (
2375 p_api_version IN NUMBER,
2376 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2377 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2378 x_return_status OUT NOCOPY VARCHAR2,
2379 x_msg_count OUT NOCOPY NUMBER,
2380 x_msg_data OUT NOCOPY VARCHAR2,
2381 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2382 p_channel_id IN NUMBER,
2383 p_user_or_group_type IN VARCHAR2,
2384 x_name_varray OUT NOCOPY AMV_CHAR_VARRAY_TYPE,
2385 x_access_obj_varray OUT NOCOPY AMV_ACCESS_OBJ_VARRAY
2386 );
2387 --------------------------------------------------------------------------------
2388 -- Start of comments
2389 -- API name : Get_BusinessObjectAccess
2390 -- Type : Private
2391 -- Pre-reqs : None
2392 -- Function : Retrieve all the access of a resource/group
2393 -- with a business object
2394 -- Parameters :
2395 -- IN p_api_version NUMBER Required
2396 -- p_init_msg_list VARCHAR2 Optional
2397 -- Default = FND_API.G_FALSE
2398 -- p_validation_level NUMBER Optional
2399 -- Default = FND_API.G_VALID_LEVEL_FULL
2400 -- p_check_login_user VARCHAR2 Optional
2401 -- Default = FND_API.G_TRUE
2402 -- Flag for checking user privilege and if user is login.
2403 -- p_include_group_flag VARCHAR2 Optional
2404 -- it is ignored for the resource. Only check for group.
2405 -- Default = FND_API.G_TRUE
2406 -- p_check_effective_date VARCHAR2 Optional
2407 -- default FND_API.G_TRUE
2408 -- p_user_or_group_id NUMBER Required
2412 -- here business object can be item, channel, category,
2409 -- p_user_or_group_type VARCHAR2 Required
2410 -- p_business_object_id NUMBER Required
2411 -- p_business_object_type VARCHAR2 Required
2413 -- and application
2414 -- OUT : x_return_status VARCHAR2
2415 -- x_msg_count NUMBER
2416 -- x_msg_data VARCHAR2
2417 -- x_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
2418 -- Version : Current version 1.0
2419 -- Previous version 1.0
2420 -- Initial version 1.0
2421 -- Notes :
2422 -- End of comments
2423 --
2424 PROCEDURE Get_BusinessObjectAccess
2425 (
2426 p_api_version IN NUMBER,
2427 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2428 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2429 x_return_status OUT NOCOPY VARCHAR2,
2430 x_msg_count OUT NOCOPY NUMBER,
2431 x_msg_data OUT NOCOPY VARCHAR2,
2432 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2433 p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
2434 p_check_effective_date IN VARCHAR2 := FND_API.G_TRUE,
2435 p_user_or_group_id IN NUMBER,
2436 p_user_or_group_type IN VARCHAR2,
2437 p_business_object_id IN NUMBER,
2438 p_business_object_type IN VARCHAR2,
2439 x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2440 );
2441 --------------------------------------------------------------------------------
2442 -- Start of comments
2443 -- API name : Get_ResourceApplAccess
2444 -- Type : Private
2445 -- Pre-reqs : None
2446 -- Function : Retrieve all the access of a resource with an application
2447 -- Parameters :
2448 -- IN p_api_version NUMBER Required
2449 -- p_init_msg_list VARCHAR2 Optional
2450 -- Default = FND_API.G_FALSE
2451 -- p_validation_level NUMBER Optional
2452 -- Default = FND_API.G_VALID_LEVEL_FULL
2453 -- p_check_login_user VARCHAR2 Optional
2454 -- Default = FND_API.G_TRUE
2455 -- Flag for checking user privilege and if user is login.
2456 -- p_include_group_flag VARCHAR2 Optional
2457 -- Default = FND_API.G_TRUE
2458 -- p_resource_id NUMBER Required
2459 -- p_application_id NUMBER Required
2460 -- OUT : x_return_status VARCHAR2
2461 -- x_msg_count NUMBER
2462 -- x_msg_data VARCHAR2
2463 -- x_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
2464 -- Version : Current version 1.0
2465 -- Previous version 1.0
2466 -- Initial version 1.0
2467 -- Notes :
2468 -- End of comments
2469 --
2470 PROCEDURE Get_ResourceApplAccess
2471 (
2472 p_api_version IN NUMBER,
2473 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2474 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2475 x_return_status OUT NOCOPY VARCHAR2,
2476 x_msg_count OUT NOCOPY NUMBER,
2477 x_msg_data OUT NOCOPY VARCHAR2,
2478 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2479 p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
2480 p_resource_id IN NUMBER,
2481 p_application_id IN NUMBER,
2482 x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2483 );
2484 --------------------------------------------------------------------------------
2485 -- Start of comments
2486 -- API name : Get_ResourceChanAccess
2487 -- Type : Private
2488 -- Pre-reqs : None
2489 -- Function : Retrieve all the access of a resource with an channel
2490 -- Parameters :
2491 -- IN p_api_version NUMBER Required
2492 -- p_init_msg_list VARCHAR2 Optional
2493 -- Default = FND_API.G_FALSE
2494 -- p_validation_level NUMBER Optional
2495 -- Default = FND_API.G_VALID_LEVEL_FULL
2496 -- p_check_login_user VARCHAR2 Optional
2497 -- Default = FND_API.G_TRUE
2498 -- Flag for checking user privilege and if user is login.
2499 -- p_include_group_flag VARCHAR2 Optional
2500 -- Default = FND_API.G_TRUE
2501 -- p_resource_id NUMBER Required
2502 -- p_channel_id NUMBER Required
2503 -- OUT : x_return_status VARCHAR2
2504 -- x_msg_count NUMBER
2505 -- x_msg_data VARCHAR2
2506 -- x_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
2507 -- Version : Current version 1.0
2508 -- Previous version 1.0
2509 -- Initial version 1.0
2510 -- Notes :
2511 -- End of comments
2512 --
2513 PROCEDURE Get_ResourceChanAccess
2514 (
2515 p_api_version IN NUMBER,
2516 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2520 x_msg_data OUT NOCOPY VARCHAR2,
2517 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2518 x_return_status OUT NOCOPY VARCHAR2,
2519 x_msg_count OUT NOCOPY NUMBER,
2521 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2522 p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
2523 p_resource_id IN NUMBER,
2524 p_channel_id IN NUMBER,
2525 x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2526 );
2527 --------------------------------------------------------------------------------
2528 -- Start of comments
2529 -- API name : Get_ResourceCateAccess
2530 -- Type : Private
2531 -- Pre-reqs : None
2532 -- Function : Retrieve all the access of a resource with an category
2533 -- Parameters :
2534 -- IN p_api_version NUMBER Required
2535 -- p_init_msg_list VARCHAR2 Optional
2536 -- Default = FND_API.G_FALSE
2537 -- p_validation_level NUMBER Optional
2538 -- Default = FND_API.G_VALID_LEVEL_FULL
2539 -- p_check_login_user VARCHAR2 Optional
2540 -- Default = FND_API.G_TRUE
2541 -- Flag for checking user privilege and if user is login.
2542 -- p_include_group_flag VARCHAR2 Optional
2543 -- Default = FND_API.G_TRUE
2544 -- p_resource_id NUMBER Required
2545 -- p_category_id NUMBER Required
2546 -- OUT : x_return_status VARCHAR2
2547 -- x_msg_count NUMBER
2548 -- x_msg_data VARCHAR2
2549 -- x_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
2550 -- Version : Current version 1.0
2551 -- Previous version 1.0
2552 -- Initial version 1.0
2553 -- Notes :
2554 -- End of comments
2555 --
2556 PROCEDURE Get_ResourceCateAccess
2557 (
2558 p_api_version IN NUMBER,
2559 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2560 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2561 x_return_status OUT NOCOPY VARCHAR2,
2562 x_msg_count OUT NOCOPY NUMBER,
2563 x_msg_data OUT NOCOPY VARCHAR2,
2564 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2565 p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
2566 p_resource_id IN NUMBER,
2567 p_category_id IN NUMBER,
2568 x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2569 );
2570 --------------------------------------------------------------------------------
2571 -- Start of comments
2572 -- API name : Get_ResourceItemAccess
2573 -- Type : Private
2574 -- Pre-reqs : None
2575 -- Function : Retrieve all the access of a resource with an item
2576 -- Parameters :
2577 -- IN p_api_version NUMBER Required
2578 -- p_init_msg_list VARCHAR2 Optional
2579 -- Default = FND_API.G_FALSE
2580 -- p_validation_level NUMBER Optional
2581 -- Default = FND_API.G_VALID_LEVEL_FULL
2582 -- p_check_login_user VARCHAR2 Optional
2583 -- Default = FND_API.G_TRUE
2584 -- Flag for checking user privilege and if user is login.
2585 -- p_include_group_flag VARCHAR2 Optional
2586 -- Default = FND_API.G_TRUE
2587 -- p_resource_id NUMBER Required
2588 -- p_item_id NUMBER Required
2589 -- OUT : x_return_status VARCHAR2
2590 -- x_msg_count NUMBER
2591 -- x_msg_data VARCHAR2
2592 -- x_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
2593 -- Version : Current version 1.0
2594 -- Previous version 1.0
2595 -- Initial version 1.0
2596 -- Notes :
2597 -- End of comments
2598 --
2599 PROCEDURE Get_ResourceItemAccess
2600 (
2601 p_api_version IN NUMBER,
2602 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2603 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2604 x_return_status OUT NOCOPY VARCHAR2,
2605 x_msg_count OUT NOCOPY NUMBER,
2606 x_msg_data OUT NOCOPY VARCHAR2,
2607 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2608 p_include_group_flag IN VARCHAR2 := FND_API.G_TRUE,
2609 p_resource_id IN NUMBER,
2610 p_item_id IN NUMBER,
2611 x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2612 );
2613 --------------------------------------------------------------------------------
2614 -- Start of comments
2615 -- API name : Get_GroupApplAccess
2616 -- Type : Private
2617 -- Pre-reqs : None
2618 -- Function : Retrieve all the access of a group with an application
2619 -- Parameters :
2620 -- IN p_api_version NUMBER Required
2621 -- p_init_msg_list VARCHAR2 Optional
2622 -- Default = FND_API.G_FALSE
2626 -- Default = FND_API.G_TRUE
2623 -- p_validation_level NUMBER Optional
2624 -- Default = FND_API.G_VALID_LEVEL_FULL
2625 -- p_check_login_user VARCHAR2 Optional
2627 -- Flag for checking user privilege and if user is login.
2628 -- p_group_id NUMBER Required
2629 -- p_application_id NUMBER Required
2630 -- OUT : x_return_status VARCHAR2
2631 -- x_msg_count NUMBER
2632 -- x_msg_data VARCHAR2
2633 -- x_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
2634 -- Version : Current version 1.0
2635 -- Previous version 1.0
2636 -- Initial version 1.0
2637 -- Notes :
2638 -- End of comments
2639 --
2640 PROCEDURE Get_GroupApplAccess
2641 (
2642 p_api_version IN NUMBER,
2643 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2644 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2645 x_return_status OUT NOCOPY VARCHAR2,
2646 x_msg_count OUT NOCOPY NUMBER,
2647 x_msg_data OUT NOCOPY VARCHAR2,
2648 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2649 p_group_id IN NUMBER,
2650 p_application_id IN NUMBER,
2651 x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2652 );
2653 --------------------------------------------------------------------------------
2654 -- Start of comments
2655 -- API name : Get_GroupChanAccess
2656 -- Type : Private
2657 -- Pre-reqs : None
2658 -- Function : Retrieve all the access of a group with an channel
2659 -- Parameters :
2660 -- IN p_api_version NUMBER Required
2661 -- p_init_msg_list VARCHAR2 Optional
2662 -- Default = FND_API.G_FALSE
2663 -- p_validation_level NUMBER Optional
2664 -- Default = FND_API.G_VALID_LEVEL_FULL
2665 -- p_check_login_user VARCHAR2 Optional
2666 -- Default = FND_API.G_TRUE
2667 -- Flag for checking user privilege and if user is login.
2668 -- p_group_id NUMBER Required
2669 -- p_channel_id NUMBER Required
2670 -- OUT : x_return_status VARCHAR2
2671 -- x_msg_count NUMBER
2672 -- x_msg_data VARCHAR2
2673 -- x_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
2674 -- Version : Current version 1.0
2675 -- Previous version 1.0
2676 -- Initial version 1.0
2677 -- Notes :
2678 -- End of comments
2679 --
2680 PROCEDURE Get_GroupChanAccess
2681 (
2682 p_api_version IN NUMBER,
2683 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2684 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2685 x_return_status OUT NOCOPY VARCHAR2,
2686 x_msg_count OUT NOCOPY NUMBER,
2687 x_msg_data OUT NOCOPY VARCHAR2,
2688 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2689 p_group_id IN NUMBER,
2690 p_channel_id IN NUMBER,
2691 x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2692 );
2693 --------------------------------------------------------------------------------
2694 -- Start of comments
2695 -- API name : Get_GroupCateAccess
2696 -- Type : Private
2697 -- Pre-reqs : None
2698 -- Function : Retrieve all the access of a group with an category
2699 -- Parameters :
2700 -- IN p_api_version NUMBER Required
2701 -- p_init_msg_list VARCHAR2 Optional
2702 -- Default = FND_API.G_FALSE
2703 -- p_validation_level NUMBER Optional
2704 -- Default = FND_API.G_VALID_LEVEL_FULL
2705 -- p_check_login_user VARCHAR2 Optional
2706 -- Default = FND_API.G_TRUE
2707 -- Flag for checking user privilege and if user is login.
2708 -- p_group_id NUMBER Required
2709 -- p_category_id NUMBER Required
2710 -- OUT : x_return_status VARCHAR2
2711 -- x_msg_count NUMBER
2712 -- x_msg_data VARCHAR2
2713 -- x_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
2714 -- Version : Current version 1.0
2715 -- Previous version 1.0
2716 -- Initial version 1.0
2717 -- Notes :
2718 -- End of comments
2719 --
2720 PROCEDURE Get_GroupCateAccess
2721 (
2722 p_api_version IN NUMBER,
2723 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2724 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2725 x_return_status OUT NOCOPY VARCHAR2,
2726 x_msg_count OUT NOCOPY NUMBER,
2727 x_msg_data OUT NOCOPY VARCHAR2,
2728 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2729 p_group_id IN NUMBER,
2730 p_category_id IN NUMBER,
2731 x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2732 );
2733 --------------------------------------------------------------------------------
2734 -- Start of comments
2735 -- API name : Get_GroupItemAccess
2736 -- Type : Private
2737 -- Pre-reqs : None
2738 -- Function : Retrieve all the access of a group with an item
2739 -- Parameters :
2740 -- IN p_api_version NUMBER Required
2741 -- p_init_msg_list VARCHAR2 Optional
2742 -- Default = FND_API.G_FALSE
2743 -- p_validation_level NUMBER Optional
2744 -- Default = FND_API.G_VALID_LEVEL_FULL
2745 -- p_check_login_user VARCHAR2 Optional
2746 -- Default = FND_API.G_TRUE
2747 -- Flag for checking user privilege and if user is login.
2748 -- p_group_id NUMBER Required
2749 -- p_item_id NUMBER Required
2750 -- OUT : x_return_status VARCHAR2
2751 -- x_msg_count NUMBER
2752 -- x_msg_data VARCHAR2
2753 -- x_access_flag_obj AMV_ACCESS_FLAG_OBJ_TYPE
2754 -- Version : Current version 1.0
2755 -- Previous version 1.0
2756 -- Initial version 1.0
2757 -- Notes :
2758 -- End of comments
2759 --
2760 PROCEDURE Get_ResourceItemAccess
2761 (
2762 p_api_version IN NUMBER,
2763 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2764 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2765 x_return_status OUT NOCOPY VARCHAR2,
2766 x_msg_count OUT NOCOPY NUMBER,
2767 x_msg_data OUT NOCOPY VARCHAR2,
2768 p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2769 p_group_id IN NUMBER,
2770 p_item_id IN NUMBER,
2771 x_access_flag_obj OUT NOCOPY AMV_ACCESS_FLAG_OBJ_TYPE
2772 );
2773 --------------------------------------------------------------------------------
2774 --------------------------------------------------------------------------------
2775 --
2776 END amv_user_pvt;