1 PACKAGE UMX_W3H_UTL AUTHID CURRENT_USER AS
2 /* $Header: UMXW3HUTLS.pls 120.3 2008/05/23 07:45:22 kkasibha noship $ */
3
4 -- Function
5 -- getObjectDetails
6 --
7 -- Description
8 -- This method takes in the name of permission set for the corresponding
9 -- database security object and returns the list for the
10 -- permission set
11 -- IN
12 -- p_menu_name - takes in FND_MENUS.MENU_NAME%TYPE object
13 -- RETURNS
14 -- List for the permission set
15
16 function getObjectDetails(
17 p_menu_name in FND_MENUS.MENU_NAME%TYPE) return varchar2;
18 /***************************************************************************************/
19
20 -- Function
21 -- isFunctionAccessible
22 --
23 -- Description
24 -- This method takes in user name and role name for the a list of functions
25 -- for a user and returns true or false for accessibility
26 -- IN
27 -- p_user_name - varchar2 (takes the user_name)
28 -- p_role_name - varchar2 (takes the role_name)
29 -- RETURNS
30 -- result as true or false
31 function isFunctionAccessible(
32 p_user_name in varchar2,p_role_name in varchar2) return varchar2;
33 /***************************************************************************************/
34
35
36 -- Function
37 -- get_excluded_function_list
38 --
39 -- Description
40 -- This method takes in the name of the responsibility, gets all the excluded function for the resps in its hierarchy and places them in a associative array
41 -- IN
42 -- p_resp_name - varchar2 (name of the responsibility)
43 -- RETURNS
44 -- result as Success on success, error message on failure
45 FUNCTION get_excluded_function_list(
46 p_resp_name WF_ROLES.NAME%TYPE) RETURN VARCHAR2;
47 /***************************************************************************************/
48
49
50 -- Function
51 -- is_function_menu_excluded
52 --
53 -- Description
54 -- This method takes in the name of the function to find
55 -- and the responsibility name under which the function is to be searched for accssiblity
56 -- IN
57 -- func_to_find - varchar2 (name of the function to find)
58 -- resp_name - varchar2 (responsibility name)
59 -- RETURNS
60 -- result as Yes or No
61
62 FUNCTION is_function_menu_excluded(
63 func_to_find FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE,resp_name WF_LOCAL_ROLES.NAME%TYPE) RETURN varchar2;
64 /***************************************************************************************/
65
66 end UMX_W3H_UTL;