DBA Data[Home] [Help]

APPS.UMX_W3H_UTL dependencies on FND_MENUS

Line 16: -- p_menu_name - takes in FND_MENUS.MENU_NAME%TYPE object

12: -- This method takes in the name of permission set for the corresponding
13: -- database security object and returns the list for the
14: -- permission set
15: -- IN
16: -- p_menu_name - takes in FND_MENUS.MENU_NAME%TYPE object
17: -- RETURNS
18: -- List for the permission set
19:
20: function getObjectDetails(p_menu_name in FND_MENUS.MENU_NAME%TYPE)

Line 20: function getObjectDetails(p_menu_name in FND_MENUS.MENU_NAME%TYPE)

16: -- p_menu_name - takes in FND_MENUS.MENU_NAME%TYPE object
17: -- RETURNS
18: -- List for the permission set
19:
20: function getObjectDetails(p_menu_name in FND_MENUS.MENU_NAME%TYPE)
21: return varchar2
22:
23: IS
24:

Line 25: l_menu_name FND_MENUS.MENU_NAME%TYPE;

21: return varchar2
22:
23: IS
24:
25: l_menu_name FND_MENUS.MENU_NAME%TYPE;
26: l_function_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;
27: l_list varchar2(3200);
28:
29: cursor function_list IS

Line 31: from fnd_form_functions frm,fnd_compiled_menu_functions fcm,fnd_menus fm

27: l_list varchar2(3200);
28:
29: cursor function_list IS
30: select frm.function_name
31: from fnd_form_functions frm,fnd_compiled_menu_functions fcm,fnd_menus fm
32: where frm.function_id=fcm.function_id
33: and fcm.menu_id=fm.menu_id
34: and fm.menu_name=l_menu_name;
35: