eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EGO_DATA_SECURITY dependencies on EGO_OBJ_ROLE_MAPPINGS

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 2993: ' ego_obj_role_mappings mapping '||

2989: 'SELECT DISTINCT fnd_functions.function_name ' ||
2990: ' FROM fnd_grants grants, ' ||
2991: ' fnd_form_functions fnd_functions, ' ||
2992: ' fnd_menu_entries cmf, '||
2993: ' ego_obj_role_mappings mapping '||
2994: ' WHERE grants.object_id = :object_id '||
2995: ' AND grants.start_date <= SYSDATE '||
2996: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
2997: ' AND ( ( grants.grantee_type = ''USER'' AND ' ||

Line 3132: ' ego_obj_role_mappings mapping, ' ||

3128: ' UNION ' ||
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 ' ||

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 6402: INSERT INTO EGO_OBJ_ROLE_MAPPINGS

6398: l_child_obj_id := get_object_id(p_object_name => p_child_obj_name);
6399: l_parent_role_id := get_role_id(p_role_name => p_parent_role_name);
6400: l_child_role_id := get_role_id(p_role_name => p_child_role_name);
6401:
6402: INSERT INTO EGO_OBJ_ROLE_MAPPINGS
6403: (
6404: PARENT_OBJECT_ID
6405: , PARENT_ROLE_ID
6406: , CHILD_OBJECT_ID

Line 6676: UPDATE EGO_OBJ_ROLE_MAPPINGS

6672: ' - l_child_role_id: '||l_child_role_id
6673: );
6674:
6675: IF (p_child_object_type is not null) THEN
6676: UPDATE EGO_OBJ_ROLE_MAPPINGS
6677: SET
6678: CHILD_ROLE_ID = l_child_role_id
6679: , LAST_UPDATE_DATE = l_Sysdate
6680: , LAST_UPDATED_BY = l_owner

Line 6688: UPDATE EGO_OBJ_ROLE_MAPPINGS

6684: PARENT_ROLE_ID = l_parent_role_id AND
6685: CHILD_OBJECT_ID = l_child_obj_id AND
6686: CHILD_OBJECT_TYPE = p_child_object_type;
6687: ELSE
6688: UPDATE EGO_OBJ_ROLE_MAPPINGS
6689: SET
6690: CHILD_ROLE_ID = l_child_role_id
6691: , LAST_UPDATE_DATE = l_Sysdate
6692: , LAST_UPDATED_BY = l_owner

Line 6943: DELETE FROM EGO_OBJ_ROLE_MAPPINGS

6939: ' - l_parent_role_id: '||l_parent_role_id
6940: );
6941:
6942: IF (p_child_object_type is not null) THEN
6943: DELETE FROM EGO_OBJ_ROLE_MAPPINGS
6944: WHERE
6945: PARENT_OBJECT_ID = l_parent_obj_id AND
6946: PARENT_ROLE_ID = l_parent_role_id AND
6947: CHILD_OBJECT_ID = l_child_obj_id AND

Line 6950: DELETE FROM EGO_OBJ_ROLE_MAPPINGS

6946: PARENT_ROLE_ID = l_parent_role_id AND
6947: CHILD_OBJECT_ID = l_child_obj_id AND
6948: CHILD_OBJECT_TYPE = p_child_object_type;
6949: ELSE
6950: DELETE FROM EGO_OBJ_ROLE_MAPPINGS
6951: WHERE
6952: PARENT_OBJECT_ID = l_parent_obj_id AND
6953: PARENT_ROLE_ID = l_parent_role_id AND
6954: CHILD_OBJECT_ID = l_child_obj_id AND

Line 7442: ' ego_obj_role_mappings mapping '||

7438: 'SELECT DISTINCT fnd_functions.function_name ' ||
7439: ' FROM fnd_grants grants, ' ||
7440: ' fnd_form_functions fnd_functions, ' ||
7441: ' fnd_menu_entries cmf, '||
7442: ' ego_obj_role_mappings mapping '||
7443: ' WHERE grants.object_id = :object_id '||
7444: ' AND grants.start_date <= SYSDATE '||
7445: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
7446: ' AND ( ( grants.grantee_type = ''USER'' AND ' ||

Line 7530: ' ego_obj_role_mappings mapping, ' ||

7526: l_dynamic_sql:= l_dynamic_sql ||' UNION ' ||
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 ' ||

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