DBA Data[Home] [Help]

APPS.EGO_USER_ATTRS_DATA_PVT dependencies on EGO_FND_DESC_FLEXS_EXT

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

584:
585: IF (l_hierarchy_row_index IS NULL) THEN
586:
587: -- get hierarchy query for this object and run it
588: l_dynamic_sql := 'SELECT HIERARCHY_NODE_QUERY FROM EGO_FND_DESC_FLEXS_EXT '||
589: 'WHERE DESCRIPTIVE_FLEXFIELD_NAME = :1';
590:
591: EXECUTE IMMEDIATE l_dynamic_sql INTO l_hierarchy_query USING p_ag_type;
592:

Line 6183: FROM EGO_FND_DESC_FLEXS_EXT

6179: IF p_pre_event_flag IS NULL THEN
6180: BEGIN
6181: SELECT BUSINESS_EVENT_NAME
6182: INTO l_event_name
6183: FROM EGO_FND_DESC_FLEXS_EXT
6184: WHERE APPLICATION_ID = p_attr_group_metadata_obj.APPLICATION_ID
6185: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_metadata_obj.ATTR_GROUP_TYPE;
6186: EXCEPTION
6187: WHEN NO_DATA_FOUND THEN

Line 6194: FROM EGO_FND_DESC_FLEXS_EXT

6190: ELSE
6191: BEGIN --Added for 4105841
6192: SELECT PRE_BUSINESS_EVENT_NAME
6193: INTO l_event_name
6194: FROM EGO_FND_DESC_FLEXS_EXT
6195: WHERE APPLICATION_ID = p_attr_group_metadata_obj.APPLICATION_ID
6196: AND DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_metadata_obj.ATTR_GROUP_TYPE;
6197: EXCEPTION
6198: WHEN NO_DATA_FOUND THEN

Line 18399: EGO_FND_DESC_FLEXS_EXT FLEX_EXT

18395: FLEX_EXT.APPLICATION_VL_NAME EXT_VL_NAME
18396: INTO l_ext_b_table_name,
18397: l_ext_vl_name
18398: FROM FND_DESCRIPTIVE_FLEXS FLEX,
18399: EGO_FND_DESC_FLEXS_EXT FLEX_EXT
18400: WHERE FLEX.APPLICATION_ID = FLEX_EXT.APPLICATION_ID(+)
18401: AND FLEX.DESCRIPTIVE_FLEXFIELD_NAME = FLEX_EXT.DESCRIPTIVE_FLEXFIELD_NAME(+)
18402: AND FLEX.APPLICATION_ID = p_application_id
18403: AND FLEX.DESCRIPTIVE_FLEXFIELD_NAME = p_attr_group_type;