APPS.EGO_USER_ATTRS_DATA_PVT dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 305: ' FROM ego_data_level_b dl, ego_obj_ag_assocs_b assoc, ego_fnd_dsc_flx_ctx_ext ag '||

301: -- new code will have p_data_level and must return only one record
302: --
303: BEGIN
304: l_dynamic_sql := 'SELECT DISTINCT(assoc.data_level_id) ' ||
305: ' FROM ego_data_level_b dl, ego_obj_ag_assocs_b assoc, ego_fnd_dsc_flx_ctx_ext ag '||
306: ' WHERE ag.attr_group_id = '||p_attr_group_id ||
307: ' AND dl.attr_group_type = ag.descriptive_flexfield_name '||
308: ' AND dl.application_id = ag.application_id ';
309: IF p_data_level_name IS NOT NULL THEN

Line 5718: FROM EGO_FND_DSC_FLX_CTX_EXT

5714: IF p_pre_event_flag IS NULL THEN
5715: /*
5716: SELECT BUSINESS_EVENT_FLAG
5717: INTO l_is_event_enabled_flag
5718: FROM EGO_FND_DSC_FLX_CTX_EXT
5719: WHERE ATTR_GROUP_ID = p_attr_group_metadata_obj.ATTR_GROUP_ID;*/
5720: SELECT COUNT(*)
5721: INTO l_dummy
5722: FROM EGO_ATTR_GROUP_DL

Line 5736: FROM EGO_FND_DSC_FLX_CTX_EXT

5732: ELSE --Added for 4105841
5733: /*
5734: SELECT PRE_BUSINESS_EVENT_FLAG
5735: INTO l_is_event_enabled_flag
5736: FROM EGO_FND_DSC_FLX_CTX_EXT
5737: WHERE ATTR_GROUP_ID = p_attr_group_metadata_obj.ATTR_GROUP_ID;*/
5738: SELECT COUNT(*)
5739: INTO l_dummy
5740: FROM EGO_ATTR_GROUP_DL

Line 16507: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)

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,
16511: fnd_objects object,

Line 16512: ego_fnd_dsc_flx_ctx_ext ag

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
16516: AND ag.descriptive_flexfield_name = p_ag_type

Line 16523: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)

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,
16527: fnd_objects object,

Line 16528: ego_fnd_dsc_flx_ctx_ext ag

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
16532: AND ag.descriptive_flexfield_name = p_ag_type

Line 17306: ' EGO_FND_DSC_FLX_CTX_EXT ATTR_GROUP_TBL,'||

17302: l_dynamic_sql := ' SELECT ATTR_GROUP_TBL.ATTR_GROUP_ID, ATTR_TBL.DESCRIPTIVE_FLEX_CONTEXT_CODE ATTR_GROUP_NAME,'||
17303: ' ATTR_TBL.END_USER_COLUMN_NAME ATTR_NAME, REQUIRED_FLAG, DEFAULT_VALUE , ASSOC_TBL.DATA_LEVEL,'||
17304: ' ATTR_EXT_TBL.DATA_TYPE'||
17305: ' FROM FND_DESCR_FLEX_COLUMN_USAGES ATTR_TBL,'||
17306: ' EGO_FND_DSC_FLX_CTX_EXT ATTR_GROUP_TBL,'||
17307: ' EGO_OBJ_AG_ASSOCS_B ASSOC_TBL,'||
17308: ' EGO_FND_DF_COL_USGS_EXT ATTR_EXT_TBL'||
17309: ' WHERE ATTR_TBL.APPLICATION_ID = ATTR_GROUP_TBL.APPLICATION_ID ';
17310: