APPS.UMX_W3H_UTL dependencies on FND_FORM_FUNCTIONS

Line 26: l_function_name FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE;

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
30: select frm.function_name

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:

Line 143: from fnd_responsibility fr,fnd_resp_functions frf, wf_local_roles wur,fnd_form_functions frm,

139: FUNCTION get_excluded_function_list(p_resp_name WF_ROLES.NAME%TYPE) RETURN VARCHAR2 IS
140: /*cursor to gte all the functions excluded for a given reponsibility hierarchy*/
141: CURSOR func_list IS
142: select distinct wur.name||frm.function_name
143: from fnd_responsibility fr,fnd_resp_functions frf, wf_local_roles wur,fnd_form_functions frm,
144: (select wur1.name roleName from wf_local_roles wur1
145: where wur1.name = p_resp_name
146: union
147: select super_name roleName from wf_role_hierarchies

Line 200: FUNCTION is_function_menu_excluded(func_to_find FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE,resp_name WF_LOCAL_ROLES.NAME%TYPE) RETURN VARCHAR2 IS

196: /*This function accepts the function anme and the resp name in which the function is tobe searched,.
197: Returns 'Yes', if the function is found under the resp else 'no' is returned.
198: */
199:
200: FUNCTION is_function_menu_excluded(func_to_find FND_FORM_FUNCTIONS.FUNCTION_NAME%TYPE,resp_name WF_LOCAL_ROLES.NAME%TYPE) RETURN VARCHAR2 IS
201: BEGIN
202: /*Check whether the function is present in the function list*/
203: IF(l_function_list(resp_name||func_to_find)=resp_name||func_to_find) THEN
204: RETURN 'Yes';