DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on FND_OBJECTS

Line 1519: FROM FND_OBJECTS

1515: IF (l_object_id IS NULL) THEN
1516:
1517: SELECT OBJECT_ID
1518: INTO l_object_id
1519: FROM FND_OBJECTS
1520: WHERE OBJ_NAME = p_object_name;
1521:
1522: G_OBJECT_NAME_TO_ID_CACHE(l_object_id) := p_object_name;
1523:

Line 12209: FROM FND_OBJECTS

12205: ,p_attr_group_type
12206: ,p_attr_group_name);
12207: BEGIN
12208: SELECT OBJECT_ID INTO l_object_id
12209: FROM FND_OBJECTS
12210: WHERE OBJ_NAME = p_object_name;
12211: EXCEPTION
12212: WHEN OTHERS THEN
12213: NULL;

Line 16506: ,p_obj_name fnd_objects.obj_name%TYPE

16502:
16503: CURSOR relevant_ag_w_data_level(
16504: p_data_level ego_obj_ag_assocs_b.data_level%TYPE
16505: ,p_class_code ego_obj_ag_assocs_b.classification_code%TYPE
16506: ,p_obj_name fnd_objects.obj_name%TYPE
16507: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
16508: IS
16509: SELECT assoc.attr_group_id
16510: FROM ego_obj_ag_assocs_b assoc,

Line 16511: fnd_objects object,

16507: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
16508: IS
16509: SELECT assoc.attr_group_id
16510: FROM ego_obj_ag_assocs_b assoc,
16511: fnd_objects object,
16512: ego_fnd_dsc_flx_ctx_ext ag
16513: WHERE assoc.classification_code = p_class_code
16514: AND assoc.object_id = object.object_id
16515: AND object.obj_name = p_obj_name

Line 16522: ,p_obj_name fnd_objects.obj_name%TYPE

16518: AND assoc.data_level = p_data_level;
16519:
16520: CURSOR relevant_ag_wo_data_level(
16521: p_class_code ego_obj_ag_assocs_b.classification_code%TYPE
16522: ,p_obj_name fnd_objects.obj_name%TYPE
16523: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
16524: IS
16525: SELECT assoc.attr_group_id
16526: FROM ego_obj_ag_assocs_b assoc,

Line 16527: fnd_objects object,

16523: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
16524: IS
16525: SELECT assoc.attr_group_id
16526: FROM ego_obj_ag_assocs_b assoc,
16527: fnd_objects object,
16528: ego_fnd_dsc_flx_ctx_ext ag
16529: WHERE assoc.classification_code = p_class_code
16530: AND assoc.object_id = object.object_id
16531: AND object.obj_name = p_obj_name