DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on EGO_FND_DESC_FLEXS_EXT

Line 488: l_dynamic_sql := 'SELECT HIERARCHY_NODE_QUERY FROM EGO_FND_DESC_FLEXS_EXT '||

484:
485: IF (l_hierarchy_row_index IS NULL) THEN
486:
487: -- get hierarchy query for this object and run it
488: l_dynamic_sql := 'SELECT HIERARCHY_NODE_QUERY FROM EGO_FND_DESC_FLEXS_EXT '||
489: 'WHERE DESCRIPTIVE_FLEXFIELD_NAME = :1';
490:
491: EXECUTE IMMEDIATE l_dynamic_sql INTO l_hierarchy_query USING p_ag_type;
492:

Line 5688: FROM EGO_FND_DESC_FLEXS_EXT

5684: IF p_pre_event_flag IS NULL THEN
5685: BEGIN
5686: SELECT BUSINESS_EVENT_NAME
5687: INTO l_event_name
5688: FROM EGO_FND_DESC_FLEXS_EXT
5689: WHERE APPLICATION_ID = p_attr_group_metadata_obj.APPLICATION_ID
5690: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_metadata_obj.ATTR_GROUP_TYPE;
5691: EXCEPTION
5692: WHEN NO_DATA_FOUND THEN

Line 5699: FROM EGO_FND_DESC_FLEXS_EXT

5695: ELSE
5696: BEGIN --Added for 4105841
5697: SELECT PRE_BUSINESS_EVENT_NAME
5698: INTO l_event_name
5699: FROM EGO_FND_DESC_FLEXS_EXT
5700: WHERE APPLICATION_ID = p_attr_group_metadata_obj.APPLICATION_ID
5701: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_metadata_obj.ATTR_GROUP_TYPE;
5702: EXCEPTION
5703: WHEN NO_DATA_FOUND THEN

Line 17238: EGO_FND_DESC_FLEXS_EXT FLEX_EXT

17234: FLEX_EXT.APPLICATION_VL_NAME EXT_VL_NAME
17235: INTO l_ext_b_table_name,
17236: l_ext_vl_name
17237: FROM FND_DESCRIPTIVE_FLEXS FLEX,
17238: EGO_FND_DESC_FLEXS_EXT FLEX_EXT
17239: WHERE FLEX.APPLICATION_ID = FLEX_EXT.APPLICATION_ID(+)
17240: AND FLEX.DESCRIPTIVE_FLEXFIELD_NAME = FLEX_EXT.DESCRIPTIVE_FLEXFIELD_NAME(+)
17241: AND FLEX.APPLICATION_ID = p_application_id
17242: AND FLEX.DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type;