1244: IS
1245:
1246: CURSOR c_func_exists IS
1247: SELECT 'Y'
1248: FROM fnd_responsibility r, fnd_compiled_menu_functions m, fnd_FORm_functions f
1249: WHERE r.responsibility_id = fnd_global.resp_id
1250: AND r.application_id=fnd_global.resp_appl_id
1251: AND r.menu_id = m.menu_id
1252: AND m.function_id = f.function_id
1253: AND f.function_name = p_function_name;
1254:
1255: CURSOR c_func_excluded IS
1256: SELECT 'Y'
1257: FROM fnd_resp_functions rf, fnd_FORm_functions f
1258: WHERE rf.application_id = fnd_global.resp_appl_id
1259: AND rf.responsibility_id = fnd_global.resp_id
1260: AND rf.rule_type = 'F'
1261: AND rf.action_id = f.function_id