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_SECURITY_PUB dependencies on FND_OBJECTS

Line 97: fnd_objects obj,

93: cp_end_date DATE) IS
94:
95: SELECT 'X'
96: FROM fnd_grants grants,
97: fnd_objects obj,
98: fnd_menus menus
99: WHERE grants.grantee_key=cp_grantee_key
100: AND grants.grantee_type=cp_grantee_type
101: AND grants.menu_id=menus.menu_id

Line 307: fnd_objects obj,

303: cp_end_date DATE) IS
304:
305: SELECT 'X'
306: FROM fnd_grants grants,
307: fnd_objects obj,
308: fnd_menus menus
309: WHERE grants.grantee_key=cp_grantee_key
310: AND grants.grantee_type=cp_grantee_type
311: AND grants.menu_id=menus.menu_id

Line 847: fnd_objects obj

843:
844: CURSOR get_object_privileges(cp_object_name VARCHAR2) IS
845: select function_name
846: from fnd_form_functions privs,
847: fnd_objects obj
848: where obj.obj_name=cp_object_name
849: AND obj.object_id=privs.object_id;
850:
851:

Line 998: l_pk1_column fnd_objects.PK1_COLUMN_NAME%TYPE;

994: -- Notes :
995: --
996: -- END OF comments
997: l_api_name CONSTANT VARCHAR2(30) := 'get_security_predicate';
998: l_pk1_column fnd_objects.PK1_COLUMN_NAME%TYPE;
999:
1000: CURSOR get_db_object (cp_object_name VARCHAR2) IS
1001: SELECT PK1_COLUMN_NAME
1002: FROM fnd_objects

Line 1002: FROM fnd_objects

998: l_pk1_column fnd_objects.PK1_COLUMN_NAME%TYPE;
999:
1000: CURSOR get_db_object (cp_object_name VARCHAR2) IS
1001: SELECT PK1_COLUMN_NAME
1002: FROM fnd_objects
1003: WHERE OBJ_NAME=cp_object_name;
1004:
1005: BEGIN
1006:

Line 1454: l_pk1_column fnd_objects.PK1_COLUMN_NAME%TYPE;

1450:
1451: l_sysdate DATE := Sysdate;
1452:
1453: l_dynamic_sql VARCHAR2(32767);
1454: l_pk1_column fnd_objects.PK1_COLUMN_NAME%TYPE;
1455: l_instance_flag BOOLEAN DEFAULT TRUE;
1456: l_instance_set_flag BOOLEAN DEFAULT TRUE;
1457: l_set_predicate VARCHAR2(32767);
1458: l_db_object_name fnd_objects.DATABASE_OBJECT_NAME%TYPE;

Line 1458: l_db_object_name fnd_objects.DATABASE_OBJECT_NAME%TYPE;

1454: l_pk1_column fnd_objects.PK1_COLUMN_NAME%TYPE;
1455: l_instance_flag BOOLEAN DEFAULT TRUE;
1456: l_instance_set_flag BOOLEAN DEFAULT TRUE;
1457: l_set_predicate VARCHAR2(32767);
1458: l_db_object_name fnd_objects.DATABASE_OBJECT_NAME%TYPE;
1459: l_db_pk_column fnd_objects.PK1_COLUMN_NAME%TYPE;
1460: l_result VARCHAR2(1);
1461: l_dummy VARCHAR2(1);
1462:

Line 1459: l_db_pk_column fnd_objects.PK1_COLUMN_NAME%TYPE;

1455: l_instance_flag BOOLEAN DEFAULT TRUE;
1456: l_instance_set_flag BOOLEAN DEFAULT TRUE;
1457: l_set_predicate VARCHAR2(32767);
1458: l_db_object_name fnd_objects.DATABASE_OBJECT_NAME%TYPE;
1459: l_db_pk_column fnd_objects.PK1_COLUMN_NAME%TYPE;
1460: l_result VARCHAR2(1);
1461: l_dummy VARCHAR2(1);
1462:
1463:

Line 1472: FROM fnd_objects obj,

1468: CURSOR predicate_c (cp_object_name VARCHAR2,
1469: cp_instance_set_id NUMBER)
1470: IS
1471: SELECT DISTINCT obj.pk1_column_name, obj.database_object_name, sets.predicate
1472: FROM fnd_objects obj,
1473: fnd_object_instance_sets sets
1474: WHERE obj.obj_name = cp_object_name
1475: AND obj.object_id = sets.object_id
1476: AND sets.instance_set_id = cp_instance_set_id;

Line 1609: fnd_objects obj,

1605: cp_end_date DATE) IS
1606:
1607: SELECT 'X'
1608: FROM fnd_grants grants,
1609: fnd_objects obj,
1610: fnd_menus menus
1611: WHERE grants.grantee_key=cp_grantee_key
1612: AND grants.grantee_type=cp_grantee_type
1613: AND grants.menu_id=menus.menu_id