APPS.EGO_DOM_SECURITY_PVT dependencies on FND_OBJECTS

Line 98: FND_OBJECTS

94: CURSOR get_object_id (cp_entity_name VARCHAR2)
95: IS
96: SELECT object_id
97: FROM
98: FND_OBJECTS
99: WHERE obj_name = cp_entity_name;
100: */
101:
102:

Line 128: fnd_objects OBJECTS,

124: menus.Menu_name role_name,
125: menus.user_menu_name role_display_name,
126: menus.menu_id menu_id
127: FROM fnd_grants GRANTS,
128: fnd_objects OBJECTS,
129: fnd_menus_vl MENUS
130: WHERE OBJECTS.object_id = GRANTS.object_id
131: AND OBJECTS.obj_name=cp_entity_name
132: AND GRANTS.instance_type='INSTANCE'

Line 333: 'fnd_objects obj ' ||

329: 'hz_parties grantee_person_company, ' ||
330: 'hz_relationships grantee_person_company_rel, ' ||
331: 'fnd_menus_tl granted_menu, ' ||
332: 'fnd_menus granted_menu_data, ' ||
333: 'fnd_objects obj ' ||
334: 'WHERE grants.object_id = obj.object_id ' ||
335: 'AND grants.grantee_type = ''USER'' ' ||
336: 'AND grantee_person.status = ''A'' ' ||
337: 'AND grantee_person.party_type = ''PERSON'' ' ||

Line 411: 'fnd_objects obj ' ||

407: 'FROM fnd_grants grants, ' ||
408: 'hz_parties grantee_group, ' ||
409: 'fnd_menus_tl granted_menu, ' ||
410: 'fnd_menus granted_menu_data, ' ||
411: 'fnd_objects obj ' ||
412: 'WHERE grants.object_id = obj.object_id ' ||
413: 'AND grants.grantee_type = ''GROUP'' ' ||
414: 'AND grants.grantee_key like ''HZ_GROUP:%'' ' ||
415: 'AND grantee_group.party_type = ''GROUP'' ' ||

Line 426: 'fnd_objects o ' ||

422: 'SELECT ' ||
423: ' ''X'' ' ||
424: 'FROM fnd_grants f, ' ||
425: 'fnd_menus m, ' ||
426: 'fnd_objects o ' ||
427: 'WHERE f.instance_pk1_value = to_char(grantee_group.party_id) ' ||
428: 'AND f.start_date <= SYSDATE ' ||
429: 'AND NVL(f.end_date, SYSDATE+1) >= SYSDATE ' ||
430: 'AND f.menu_id = m.menu_id ' ||

Line 494: 'fnd_objects obj ' ||

490: 'FROM fnd_grants grants, ' ||
491: 'hz_parties grantee_company, ' ||
492: 'fnd_menus_tl granted_menu, ' ||
493: 'fnd_menus granted_menu_data, ' ||
494: 'fnd_objects obj ' ||
495: 'WHERE grants.object_id = obj.object_id ' ||
496: 'AND grants.grantee_type = ''COMPANY'' ' ||
497: 'AND grants.grantee_key like ''HZ_COMPANY:%'' ' ||
498: 'AND grantee_company.party_type = ''ORGANIZATION'' ' ||

Line 547: 'fnd_objects obj ' ||

543: 'FROM fnd_grants grants, ' ||
544: 'hz_parties grantee_global, ' ||
545: 'fnd_menus_tl granted_menu, ' ||
546: 'fnd_menus granted_menu_data, ' ||
547: 'fnd_objects obj ' ||
548: 'WHERE grants.object_id = obj.object_id ' ||
549: 'AND grants.grantee_type = ''GLOBAL'' ' ||
550: 'AND grantee_global.party_id = -1000 ' ||
551: 'AND nvl(grants.end_date, sysdate+1) >= trunc(sysdate) ' ||

Line 580: ' fnd_objects obj, ' ||

576: ' trunc(grants.start_date) start_date , ' ||
577: ' trunc(grants.end_date) end_date ' ||
578: ' FROM fnd_grants grants, ' ||
579: ' fnd_menus granted_menu, ' ||
580: ' fnd_objects obj, ' ||
581: ' hz_parties grantee_person, ' ||
582: ' fnd_menus_tl granted_menu_tl ' ||
583: ' WHERE granted_menu.menu_id = grants.menu_id ' ||
584: ' AND grants.instance_type = ''SET'' AND grants.instance_pk1_value = ''*NULL*''' ||

Line 628: ' fnd_objects obj , ' ||

624: ' trunc(grants.end_date) end_date ' ||
625: ' FROM ' ||
626: ' fnd_grants grants , ' ||
627: ' fnd_menus granted_menu, ' ||
628: ' fnd_objects obj , ' ||
629: ' hz_parties member , ' ||
630: ' hz_relationships member_group , ' ||
631: ' hz_parties grantee_group, ' ||
632: ' fnd_menus_tl granted_menu_tl ' ||

Line 793: fnd_objects obj

789: sets.instance_set_name instance_set_name,
790: sets.predicate predicate
791: FROM fnd_grants grants,
792: fnd_object_instance_sets sets,
793: fnd_objects obj
794: WHERE obj.obj_name = p_obj_name
795: AND grants.object_id = obj.object_id
796: AND grants.instance_type='SET'
797: AND grants.parameter1 is null

Line 811: FROM fnd_objects

807: PK2_COLUMN_NAME,
808: PK3_COLUMN_NAME,
809: PK4_COLUMN_NAME,
810: PK5_COLUMN_NAME
811: FROM fnd_objects
812: WHERE OBJ_NAME = p_obj_name;
813:
814: obj_meta_data_rec obj_meta_data%ROWTYPE;
815: i NUMBER := 1;