DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on FND_OBJECTS

Line 1662: FROM FND_OBJECTS

1658: IF (l_object_id IS NULL) THEN
1659:
1660: SELECT OBJECT_ID
1661: INTO l_object_id
1662: FROM FND_OBJECTS
1663: WHERE OBJ_NAME = p_object_name;
1664:
1665: G_OBJECT_NAME_TO_ID_CACHE(l_object_id) := p_object_name;
1666:

Line 13229: FROM FND_OBJECTS

13225: ,p_attr_group_type
13226: ,p_attr_group_name);
13227: BEGIN
13228: SELECT OBJECT_ID INTO l_object_id
13229: FROM FND_OBJECTS
13230: WHERE OBJ_NAME = p_object_name;
13231: EXCEPTION
13232: WHEN OTHERS THEN
13233: NULL;

Line 17667: ,p_obj_name fnd_objects.obj_name%TYPE

17663:
17664: CURSOR relevant_ag_w_data_level(
17665: p_data_level ego_obj_ag_assocs_b.data_level%TYPE
17666: ,p_class_code ego_obj_ag_assocs_b.classification_code%TYPE
17667: ,p_obj_name fnd_objects.obj_name%TYPE
17668: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
17669: IS
17670: SELECT assoc.attr_group_id
17671: FROM ego_obj_ag_assocs_b assoc,

Line 17672: fnd_objects object,

17668: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
17669: IS
17670: SELECT assoc.attr_group_id
17671: FROM ego_obj_ag_assocs_b assoc,
17672: fnd_objects object,
17673: ego_fnd_dsc_flx_ctx_ext ag
17674: WHERE assoc.classification_code = p_class_code
17675: AND assoc.object_id = object.object_id
17676: AND object.obj_name = p_obj_name

Line 17683: ,p_obj_name fnd_objects.obj_name%TYPE

17679: AND assoc.data_level = p_data_level;
17680:
17681: CURSOR relevant_ag_wo_data_level(
17682: p_class_code ego_obj_ag_assocs_b.classification_code%TYPE
17683: ,p_obj_name fnd_objects.obj_name%TYPE
17684: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
17685: IS
17686: SELECT assoc.attr_group_id
17687: FROM ego_obj_ag_assocs_b assoc,

Line 17688: fnd_objects object,

17684: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
17685: IS
17686: SELECT assoc.attr_group_id
17687: FROM ego_obj_ag_assocs_b assoc,
17688: fnd_objects object,
17689: ego_fnd_dsc_flx_ctx_ext ag
17690: WHERE assoc.classification_code = p_class_code
17691: AND assoc.object_id = object.object_id
17692: AND object.obj_name = p_obj_name