APPS.EGO_SECURITY_PUB dependencies on FND_OBJECTS

Line 96: FROM fnd_objects obj,

92: cp_start_date DATE,
93: cp_end_date DATE) IS
94: -- Bug 16182516 Changing sql as this is same sql as on in grant_role_guid API, Call to this API will result in improved performance.
95: SELECT 'X'
96: FROM fnd_objects obj,
97: fnd_menus menus
98: WHERE obj.obj_name= cp_object_name
99: AND menus.menu_name=cp_menu_name
100: and exists

Line 332: FROM fnd_objects obj,

328: cp_end_date DATE) IS
329:
330: -- Bug 16182516 Changing sql as this is same sql as on in grant_role_guid API, Call to this API will result in improved performance.
331: SELECT 'X'
332: FROM fnd_objects obj,
333: fnd_menus menus
334: WHERE obj.obj_name= cp_object_name
335: AND menus.menu_name=cp_menu_name
336: and exists

Line 902: fnd_objects obj

898:
899: CURSOR get_object_privileges(cp_object_name VARCHAR2) IS
900: select function_name
901: from fnd_form_functions privs,
902: fnd_objects obj
903: where obj.obj_name=cp_object_name
904: AND obj.object_id=privs.object_id;
905:
906:

Line 1053: l_pk1_column fnd_objects.PK1_COLUMN_NAME%TYPE;

1049: -- Notes :
1050: --
1051: -- END OF comments
1052: l_api_name CONSTANT VARCHAR2(30) := 'get_security_predicate';
1053: l_pk1_column fnd_objects.PK1_COLUMN_NAME%TYPE;
1054:
1055: CURSOR get_db_object (cp_object_name VARCHAR2) IS
1056: SELECT PK1_COLUMN_NAME
1057: FROM fnd_objects

Line 1057: FROM fnd_objects

1053: l_pk1_column fnd_objects.PK1_COLUMN_NAME%TYPE;
1054:
1055: CURSOR get_db_object (cp_object_name VARCHAR2) IS
1056: SELECT PK1_COLUMN_NAME
1057: FROM fnd_objects
1058: WHERE OBJ_NAME=cp_object_name;
1059:
1060: BEGIN
1061:

Line 1509: l_pk1_column fnd_objects.PK1_COLUMN_NAME%TYPE;

1505:
1506: l_sysdate DATE := Sysdate;
1507:
1508: l_dynamic_sql VARCHAR2(32767);
1509: l_pk1_column fnd_objects.PK1_COLUMN_NAME%TYPE;
1510: l_instance_flag BOOLEAN DEFAULT TRUE;
1511: l_instance_set_flag BOOLEAN DEFAULT TRUE;
1512: l_set_predicate VARCHAR2(32767);
1513: l_db_object_name fnd_objects.DATABASE_OBJECT_NAME%TYPE;

Line 1513: l_db_object_name fnd_objects.DATABASE_OBJECT_NAME%TYPE;

1509: l_pk1_column fnd_objects.PK1_COLUMN_NAME%TYPE;
1510: l_instance_flag BOOLEAN DEFAULT TRUE;
1511: l_instance_set_flag BOOLEAN DEFAULT TRUE;
1512: l_set_predicate VARCHAR2(32767);
1513: l_db_object_name fnd_objects.DATABASE_OBJECT_NAME%TYPE;
1514: l_db_pk_column fnd_objects.PK1_COLUMN_NAME%TYPE;
1515: l_result VARCHAR2(1);
1516: l_dummy VARCHAR2(1);
1517:

Line 1514: l_db_pk_column fnd_objects.PK1_COLUMN_NAME%TYPE;

1510: l_instance_flag BOOLEAN DEFAULT TRUE;
1511: l_instance_set_flag BOOLEAN DEFAULT TRUE;
1512: l_set_predicate VARCHAR2(32767);
1513: l_db_object_name fnd_objects.DATABASE_OBJECT_NAME%TYPE;
1514: l_db_pk_column fnd_objects.PK1_COLUMN_NAME%TYPE;
1515: l_result VARCHAR2(1);
1516: l_dummy VARCHAR2(1);
1517:
1518:

Line 1527: FROM fnd_objects obj,

1523: CURSOR predicate_c (cp_object_name VARCHAR2,
1524: cp_instance_set_id NUMBER)
1525: IS
1526: SELECT DISTINCT obj.pk1_column_name, obj.database_object_name, sets.predicate
1527: FROM fnd_objects obj,
1528: fnd_object_instance_sets sets
1529: WHERE obj.obj_name = cp_object_name
1530: AND obj.object_id = sets.object_id
1531: AND sets.instance_set_id = cp_instance_set_id;

Line 1664: FROM fnd_objects obj,

1660: cp_end_date DATE) IS
1661:
1662: -- Bug 16182516 Adding here also as sql is same and call to this API in a flow will improve performance
1663: SELECT 'X'
1664: FROM fnd_objects obj,
1665: fnd_menus menus
1666: WHERE obj.obj_name= cp_object_name
1667: AND menus.menu_name=cp_menu_name
1668: and exists