APPS.UMX_W3H_UTL dependencies on WF_LOCAL_ROLES

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 144: (select wur1.name roleName from wf_local_roles wur1

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
148: where enabled_flag='Y'

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';