DBA Data[Home] [Help]

APPS.ENG_CHANGE_ROLES_PUB dependencies on FND_MENU_ENTRIES

Line 22: function_id IN (SELECT function_id FROM fnd_menu_entries WHERE menu_id = p_menu_id);

18:
19: SELECT count(function_name) into v_edit_priv
20: FROM fnd_form_functions
21: WHERE function_name='ENG_EDIT_CHANGE' AND
22: function_id IN (SELECT function_id FROM fnd_menu_entries WHERE menu_id = p_menu_id);
23:
24: SELECT count(function_name) into v_view_priv
25: FROM fnd_form_functions
26: WHERE function_name='ENG_VIEW_CHANGE' AND

Line 27: function_id IN (SELECT function_id FROM fnd_menu_entries WHERE menu_id = p_menu_id);

23:
24: SELECT count(function_name) into v_view_priv
25: FROM fnd_form_functions
26: WHERE function_name='ENG_VIEW_CHANGE' AND
27: function_id IN (SELECT function_id FROM fnd_menu_entries WHERE menu_id = p_menu_id);
28:
29: -- If the role has Edit privilege then return Administrator
30: IF v_edit_priv > 0 OR (v_edit_priv > 0 AND v_view_priv > 0) THEN
31: p_default_access := 'Administrator';