APPS.EGO_DATA_SECURITY dependencies on FND_MENUS

Line 394: from fnd_menus

390: l_role_id number;
391: Begin
392: select menu_id
393: into l_role_id
394: from fnd_menus
395: where menu_name = p_role_name;
396: RETURN l_role_id;
397: EXCEPTION
398: when no_data_found then

Line 1343: fnd_menus m, ego_obj_role_mappings p

1339: cp_object_type VARCHAR2, cp_parent_object_id NUMBER)
1340: IS
1341: SELECT p.parent_role_id parent_role_id
1342: FROM fnd_menu_entries r, fnd_form_functions f,
1343: fnd_menus m, ego_obj_role_mappings p
1344: WHERE r.function_id = f.function_id
1345: AND r.menu_id = m.menu_id
1346: AND f.function_name = cp_function
1347: AND m.menu_id = p.child_role_id

Line 3133: ' fnd_menus menus ' ||

3129: ' SELECT DISTINCT fnd_functions.function_name ' ||
3130: ' FROM fnd_form_functions fnd_functions, ' ||
3131: ' fnd_menu_entries cmf, ' ||
3132: ' ego_obj_role_mappings mapping, ' ||
3133: ' fnd_menus menus ' ||
3134: ' WHERE menus.menu_name = :profile_role ' ||
3135: ' AND mapping.parent_role_id = menus.menu_id ' ||
3136: ' AND mapping.child_role_id = cmf.menu_id ' ||
3137: ' AND mapping.child_object_id = :profile_ch_object_id ' ||

Line 5127: fnd_menus m, ego_obj_role_mappings p

5123: AND grants.object_id = cp_parent_object_id
5124: AND ( grants.menu_id in
5125: ( SELECT p.parent_role_id
5126: FROM fnd_menu_entries r, fnd_form_functions f,
5127: fnd_menus m, ego_obj_role_mappings p
5128: WHERE r.function_id = f.function_id
5129: AND r.menu_id = m.menu_id
5130: AND f.function_name = cp_function
5131: AND m.menu_id = p.child_role_id

Line 5154: fnd_menus m, ego_obj_role_mappings p

5150: )
5151: IS
5152: SELECT DISTINCT p.parent_role_id
5153: FROM fnd_menu_entries r, fnd_form_functions f,
5154: fnd_menus m, ego_obj_role_mappings p
5155: WHERE r.function_id = f.function_id
5156: AND r.menu_id = m.menu_id
5157: AND f.function_name = cp_function
5158: AND m.menu_id = p.child_role_id

Line 5171: fnd_menus m, ego_obj_role_mappings p

5167: )
5168: IS
5169: SELECT DISTINCT p.parent_role_id
5170: FROM fnd_menu_entries r, fnd_form_functions f,
5171: fnd_menus m, ego_obj_role_mappings p
5172: WHERE r.function_id = f.function_id
5173: AND r.menu_id = m.menu_id
5174: AND f.function_name = cp_function
5175: AND m.menu_id = p.child_role_id

Line 5186: fnd_menus m, ego_obj_role_mappings r, fnd_menus cm

5182: cp_child_object_type VARCHAR2
5183: )
5184: IS
5185: select cm.menu_name from
5186: fnd_menus m, ego_obj_role_mappings r, fnd_menus cm
5187: where r.parent_role_id = m.menu_id and
5188: m.menu_name = cp_parent_role
5189: and r.parent_object_id = cp_parent_object_id
5190: and r.child_object_id = cp_child_object_id

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

5587: ' SELECT DISTINCT instance_sets.predicate '||
5588: ' FROM fnd_grants grants, '||
5589: ' fnd_object_instance_sets instance_sets,' ||
5590: ' fnd_form_functions F, fnd_menu_entries R, '||
5591: ' fnd_menus M, ego_obj_role_mappings P '||
5592: ' WHERE grants.instance_type = ''SET'' '||
5593: ' AND grants.start_date <= SYSDATE ' ||
5594: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE '||
5595: ' AND grants.instance_set_id = instance_sets.instance_set_id '||

Line 6350: l_parent_role_id fnd_menus.menu_id%type;

6346: l_api_version CONSTANT NUMBER := 1.0;
6347:
6348: -- General variables
6349: l_parent_obj_id fnd_objects.object_id%type;
6350: l_parent_role_id fnd_menus.menu_id%type;
6351: l_child_obj_id fnd_objects.object_id%type;
6352: l_child_role_id fnd_menus.menu_id%type;
6353:
6354: l_Sysdate DATE := Sysdate;

Line 6352: l_child_role_id fnd_menus.menu_id%type;

6348: -- General variables
6349: l_parent_obj_id fnd_objects.object_id%type;
6350: l_parent_role_id fnd_menus.menu_id%type;
6351: l_child_obj_id fnd_objects.object_id%type;
6352: l_child_role_id fnd_menus.menu_id%type;
6353:
6354: l_Sysdate DATE := Sysdate;
6355: l_owner NUMBER;
6356:

Line 6615: l_parent_role_id fnd_menus.menu_id%type;

6611:
6612: -- General variables
6613:
6614: l_parent_obj_id fnd_objects.object_id%type;
6615: l_parent_role_id fnd_menus.menu_id%type;
6616: l_child_obj_id fnd_objects.object_id%type;
6617: l_child_role_id fnd_menus.menu_id%type;
6618: l_Sysdate DATE := Sysdate;
6619: l_owner NUMBER;

Line 6617: l_child_role_id fnd_menus.menu_id%type;

6613:
6614: l_parent_obj_id fnd_objects.object_id%type;
6615: l_parent_role_id fnd_menus.menu_id%type;
6616: l_child_obj_id fnd_objects.object_id%type;
6617: l_child_role_id fnd_menus.menu_id%type;
6618: l_Sysdate DATE := Sysdate;
6619: l_owner NUMBER;
6620:
6621: BEGIN

Line 6892: l_parent_role_id fnd_menus.menu_id%type;

6888:
6889: -- General variables
6890:
6891: l_parent_obj_id fnd_objects.object_id%type;
6892: l_parent_role_id fnd_menus.menu_id%type;
6893: l_child_obj_id fnd_objects.object_id%type;
6894:
6895: l_Sysdate DATE := Sysdate;
6896:

Line 7081: fnd_menus menus

7077: IS
7078: SELECT functions.function_name
7079: FROM fnd_form_functions functions,
7080: fnd_menu_entries cmf,
7081: fnd_menus menus
7082: WHERE functions.function_id = cmf.function_id
7083: AND menus.menu_id = cmf.menu_id
7084: AND menus.menu_name = cp_role_name;
7085:

Line 7531: ' fnd_menus menus ' ||

7527: ' SELECT DISTINCT fnd_functions.function_name ' ||
7528: ' FROM fnd_form_functions fnd_functions, ' ||
7529: ' fnd_menu_entries cmf, ' ||
7530: ' ego_obj_role_mappings mapping, ' ||
7531: ' fnd_menus menus ' ||
7532: ' WHERE menus.menu_name = :profile_role ' ||
7533: ' AND mapping.parent_role_id = menus.menu_id ' ||
7534: ' AND mapping.child_role_id = cmf.menu_id ' ||
7535: ' AND mapping.child_object_id = :profile_object_id ' ||

Line 7831: fnd_menus m, ego_obj_role_mappings p

7827: cp_object_type VARCHAR2, cp_parent_object_id NUMBER)
7828: IS
7829: select p.parent_role_id parent_role_id
7830: from fnd_menu_entries r, fnd_form_functions f,
7831: fnd_menus m, ego_obj_role_mappings p
7832: where r.function_id = f.function_id
7833: and r.menu_id = m.menu_id
7834: and f.function_name = cp_function
7835: and m.menu_id = p.child_role_id