APPS.EGO_DATA_SECURITY dependencies on FND_MENUS

Line 383: from fnd_menus

379: l_role_id number;
380: Begin
381: select menu_id
382: into l_role_id
383: from fnd_menus
384: where menu_name = p_role_name;
385: RETURN l_role_id;
386: EXCEPTION
387: when no_data_found then

Line 1243: fnd_menus m, ego_obj_role_mappings p

1239: cp_object_type VARCHAR2, cp_parent_object_id NUMBER)
1240: IS
1241: SELECT p.parent_role_id parent_role_id
1242: FROM fnd_menu_entries r, fnd_form_functions f,
1243: fnd_menus m, ego_obj_role_mappings p
1244: WHERE r.function_id = f.function_id
1245: AND r.menu_id = m.menu_id
1246: AND f.function_name = cp_function
1247: AND m.menu_id = p.child_role_id

Line 3031: ' fnd_menus menus ' ||

3027: ' SELECT DISTINCT fnd_functions.function_name ' ||
3028: ' FROM fnd_form_functions fnd_functions, ' ||
3029: ' fnd_menu_entries cmf, ' ||
3030: ' ego_obj_role_mappings mapping, ' ||
3031: ' fnd_menus menus ' ||
3032: ' WHERE menus.menu_name = :profile_role ' ||
3033: ' AND mapping.parent_role_id = menus.menu_id ' ||
3034: ' AND mapping.child_role_id = cmf.menu_id ' ||
3035: ' AND mapping.child_object_id = :profile_ch_object_id ' ||

Line 5025: fnd_menus m, ego_obj_role_mappings p

5021: AND grants.object_id = cp_parent_object_id
5022: AND ( grants.menu_id in
5023: ( SELECT p.parent_role_id
5024: FROM fnd_menu_entries r, fnd_form_functions f,
5025: fnd_menus m, ego_obj_role_mappings p
5026: WHERE r.function_id = f.function_id
5027: AND r.menu_id = m.menu_id
5028: AND f.function_name = cp_function
5029: AND m.menu_id = p.child_role_id

Line 5052: fnd_menus m, ego_obj_role_mappings p

5048: )
5049: IS
5050: SELECT DISTINCT p.parent_role_id
5051: FROM fnd_menu_entries r, fnd_form_functions f,
5052: fnd_menus m, ego_obj_role_mappings p
5053: WHERE r.function_id = f.function_id
5054: AND r.menu_id = m.menu_id
5055: AND f.function_name = cp_function
5056: AND m.menu_id = p.child_role_id

Line 5069: fnd_menus m, ego_obj_role_mappings p

5065: )
5066: IS
5067: SELECT DISTINCT p.parent_role_id
5068: FROM fnd_menu_entries r, fnd_form_functions f,
5069: fnd_menus m, ego_obj_role_mappings p
5070: WHERE r.function_id = f.function_id
5071: AND r.menu_id = m.menu_id
5072: AND f.function_name = cp_function
5073: AND m.menu_id = p.child_role_id

Line 5084: fnd_menus m, ego_obj_role_mappings r, fnd_menus cm

5080: cp_child_object_type VARCHAR2
5081: )
5082: IS
5083: select cm.menu_name from
5084: fnd_menus m, ego_obj_role_mappings r, fnd_menus cm
5085: where r.parent_role_id = m.menu_id and
5086: m.menu_name = cp_parent_role
5087: and r.parent_object_id = cp_parent_object_id
5088: and r.child_object_id = cp_child_object_id

Line 5489: ' fnd_menus M, ego_obj_role_mappings P '||

5485: ' SELECT DISTINCT instance_sets.predicate '||
5486: ' FROM fnd_grants grants, '||
5487: ' fnd_object_instance_sets instance_sets,' ||
5488: ' fnd_form_functions F, fnd_menu_entries R, '||
5489: ' fnd_menus M, ego_obj_role_mappings P '||
5490: ' WHERE grants.instance_type = ''SET'' '||
5491: ' AND grants.start_date <= SYSDATE ' ||
5492: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE '||
5493: ' AND grants.instance_set_id = instance_sets.instance_set_id '||

Line 6248: l_parent_role_id fnd_menus.menu_id%type;

6244: l_api_version CONSTANT NUMBER := 1.0;
6245:
6246: -- General variables
6247: l_parent_obj_id fnd_objects.object_id%type;
6248: l_parent_role_id fnd_menus.menu_id%type;
6249: l_child_obj_id fnd_objects.object_id%type;
6250: l_child_role_id fnd_menus.menu_id%type;
6251:
6252: l_Sysdate DATE := Sysdate;

Line 6250: l_child_role_id fnd_menus.menu_id%type;

6246: -- General variables
6247: l_parent_obj_id fnd_objects.object_id%type;
6248: l_parent_role_id fnd_menus.menu_id%type;
6249: l_child_obj_id fnd_objects.object_id%type;
6250: l_child_role_id fnd_menus.menu_id%type;
6251:
6252: l_Sysdate DATE := Sysdate;
6253: l_owner NUMBER;
6254:

Line 6513: l_parent_role_id fnd_menus.menu_id%type;

6509:
6510: -- General variables
6511:
6512: l_parent_obj_id fnd_objects.object_id%type;
6513: l_parent_role_id fnd_menus.menu_id%type;
6514: l_child_obj_id fnd_objects.object_id%type;
6515: l_child_role_id fnd_menus.menu_id%type;
6516: l_Sysdate DATE := Sysdate;
6517: l_owner NUMBER;

Line 6515: l_child_role_id fnd_menus.menu_id%type;

6511:
6512: l_parent_obj_id fnd_objects.object_id%type;
6513: l_parent_role_id fnd_menus.menu_id%type;
6514: l_child_obj_id fnd_objects.object_id%type;
6515: l_child_role_id fnd_menus.menu_id%type;
6516: l_Sysdate DATE := Sysdate;
6517: l_owner NUMBER;
6518:
6519: BEGIN

Line 6790: l_parent_role_id fnd_menus.menu_id%type;

6786:
6787: -- General variables
6788:
6789: l_parent_obj_id fnd_objects.object_id%type;
6790: l_parent_role_id fnd_menus.menu_id%type;
6791: l_child_obj_id fnd_objects.object_id%type;
6792:
6793: l_Sysdate DATE := Sysdate;
6794:

Line 6979: fnd_menus menus

6975: IS
6976: SELECT functions.function_name
6977: FROM fnd_form_functions functions,
6978: fnd_menu_entries cmf,
6979: fnd_menus menus
6980: WHERE functions.function_id = cmf.function_id
6981: AND menus.menu_id = cmf.menu_id
6982: AND menus.menu_name = cp_role_name;
6983:

Line 7429: ' fnd_menus menus ' ||

7425: ' SELECT DISTINCT fnd_functions.function_name ' ||
7426: ' FROM fnd_form_functions fnd_functions, ' ||
7427: ' fnd_menu_entries cmf, ' ||
7428: ' ego_obj_role_mappings mapping, ' ||
7429: ' fnd_menus menus ' ||
7430: ' WHERE menus.menu_name = :profile_role ' ||
7431: ' AND mapping.parent_role_id = menus.menu_id ' ||
7432: ' AND mapping.child_role_id = cmf.menu_id ' ||
7433: ' AND mapping.child_object_id = :profile_object_id ' ||

Line 7729: fnd_menus m, ego_obj_role_mappings p

7725: cp_object_type VARCHAR2, cp_parent_object_id NUMBER)
7726: IS
7727: select p.parent_role_id parent_role_id
7728: from fnd_menu_entries r, fnd_form_functions f,
7729: fnd_menus m, ego_obj_role_mappings p
7730: where r.function_id = f.function_id
7731: and r.menu_id = m.menu_id
7732: and f.function_name = cp_function
7733: and m.menu_id = p.child_role_id