DBA Data[Home] [Help]

APPS.UMX_W3H_UTL dependencies on WF_ROLES

Line 139: FUNCTION get_excluded_function_list(p_resp_name WF_ROLES.NAME%TYPE) RETURN VARCHAR2 IS

135: -- RETURNS
136: -- result as Success on success, error message on failure
137: /* This procedure will populate the l_function_list table type with all the excluded functions*/
138:
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,