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

2887: 'SELECT DISTINCT fnd_functions.function_name ' ||
2888: ' FROM fnd_grants grants, ' ||
2889: ' fnd_form_functions fnd_functions, ' ||
2890: ' fnd_menu_entries cmf, '||
2891: ' ego_obj_role_mappings mapping '||
2892: ' WHERE grants.object_id = :object_id '||
2893: ' AND grants.start_date <= SYSDATE '||
2894: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
2895: ' AND ( ( grants.grantee_type = ''USER'' AND ' ||

Line 3030: ' ego_obj_role_mappings mapping, ' ||

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

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

6296: l_child_obj_id := get_object_id(p_object_name => p_child_obj_name);
6297: l_parent_role_id := get_role_id(p_role_name => p_parent_role_name);
6298: l_child_role_id := get_role_id(p_role_name => p_child_role_name);
6299:
6300: INSERT INTO EGO_OBJ_ROLE_MAPPINGS
6301: (
6302: PARENT_OBJECT_ID
6303: , PARENT_ROLE_ID
6304: , CHILD_OBJECT_ID

Line 6574: UPDATE EGO_OBJ_ROLE_MAPPINGS

6570: ' - l_child_role_id: '||l_child_role_id
6571: );
6572:
6573: IF (p_child_object_type is not null) THEN
6574: UPDATE EGO_OBJ_ROLE_MAPPINGS
6575: SET
6576: CHILD_ROLE_ID = l_child_role_id
6577: , LAST_UPDATE_DATE = l_Sysdate
6578: , LAST_UPDATED_BY = l_owner

Line 6586: UPDATE EGO_OBJ_ROLE_MAPPINGS

6582: PARENT_ROLE_ID = l_parent_role_id AND
6583: CHILD_OBJECT_ID = l_child_obj_id AND
6584: CHILD_OBJECT_TYPE = p_child_object_type;
6585: ELSE
6586: UPDATE EGO_OBJ_ROLE_MAPPINGS
6587: SET
6588: CHILD_ROLE_ID = l_child_role_id
6589: , LAST_UPDATE_DATE = l_Sysdate
6590: , LAST_UPDATED_BY = l_owner

Line 6841: DELETE FROM EGO_OBJ_ROLE_MAPPINGS

6837: ' - l_parent_role_id: '||l_parent_role_id
6838: );
6839:
6840: IF (p_child_object_type is not null) THEN
6841: DELETE FROM EGO_OBJ_ROLE_MAPPINGS
6842: WHERE
6843: PARENT_OBJECT_ID = l_parent_obj_id AND
6844: PARENT_ROLE_ID = l_parent_role_id AND
6845: CHILD_OBJECT_ID = l_child_obj_id AND

Line 6848: DELETE FROM EGO_OBJ_ROLE_MAPPINGS

6844: PARENT_ROLE_ID = l_parent_role_id AND
6845: CHILD_OBJECT_ID = l_child_obj_id AND
6846: CHILD_OBJECT_TYPE = p_child_object_type;
6847: ELSE
6848: DELETE FROM EGO_OBJ_ROLE_MAPPINGS
6849: WHERE
6850: PARENT_OBJECT_ID = l_parent_obj_id AND
6851: PARENT_ROLE_ID = l_parent_role_id AND
6852: CHILD_OBJECT_ID = l_child_obj_id AND

Line 7340: ' ego_obj_role_mappings mapping '||

7336: 'SELECT DISTINCT fnd_functions.function_name ' ||
7337: ' FROM fnd_grants grants, ' ||
7338: ' fnd_form_functions fnd_functions, ' ||
7339: ' fnd_menu_entries cmf, '||
7340: ' ego_obj_role_mappings mapping '||
7341: ' WHERE grants.object_id = :object_id '||
7342: ' AND grants.start_date <= SYSDATE '||
7343: ' AND NVL(grants.end_date,SYSDATE) >= SYSDATE ' ||
7344: ' AND ( ( grants.grantee_type = ''USER'' AND ' ||

Line 7428: ' ego_obj_role_mappings mapping, ' ||

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

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