APPS.EGO_ITEM_PVT dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 2092: FROM EGO_FND_DSC_FLX_CTX_EXT

2088: -- Find the Attr Group ID and Label we will be inserting --
2089: -----------------------------------------------------------
2090: SELECT ATTR_GROUP_ID
2091: INTO l_attr_group_id
2092: FROM EGO_FND_DSC_FLX_CTX_EXT
2093: WHERE APPLICATION_ID = 431
2094: AND DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_ITEMMGMT_GROUP'
2095: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = 'ItemDetailDesc';
2096: --commented out as a part of Bug 4906499

Line 5003: FROM EGO_FND_DSC_FLX_CTX_EXT EXT1

4999: ,cp_attr_group_type IN VARCHAR2
5000: ,cp_attr_group_name IN VARCHAR2
5001: ) IS
5002: SELECT AGV_NAME
5003: FROM EGO_FND_DSC_FLX_CTX_EXT EXT1
5004: WHERE EXT1.AGV_NAME = cp_agv_name
5005: AND EXT1.ATTR_GROUP_ID NOT IN (SELECT ATTR_GROUP_ID
5006: FROM EGO_FND_DSC_FLX_CTX_EXT EXT2
5007: WHERE EXT2.AGV_NAME = cp_agv_name

Line 5006: FROM EGO_FND_DSC_FLX_CTX_EXT EXT2

5002: SELECT AGV_NAME
5003: FROM EGO_FND_DSC_FLX_CTX_EXT EXT1
5004: WHERE EXT1.AGV_NAME = cp_agv_name
5005: AND EXT1.ATTR_GROUP_ID NOT IN (SELECT ATTR_GROUP_ID
5006: FROM EGO_FND_DSC_FLX_CTX_EXT EXT2
5007: WHERE EXT2.AGV_NAME = cp_agv_name
5008: AND EXT2.APPLICATION_ID = cp_application_id
5009: AND EXT2.DESCRIPTIVE_FLEXFIELD_NAME = cp_attr_group_type
5010: AND EXT2.DESCRIPTIVE_FLEX_CONTEXT_CODE = cp_attr_group_name);

Line 5021: FROM EGO_FND_DSC_FLX_CTX_EXT

5017: SELECT OBJECT_NAME
5018: FROM SYS.ALL_OBJECTS
5019: WHERE OBJECT_NAME = cp_agv_name
5020: AND OBJECT_NAME NOT IN (SELECT AGV_NAME
5021: FROM EGO_FND_DSC_FLX_CTX_EXT
5022: WHERE AGV_NAME = cp_agv_name
5023: AND APPLICATION_ID = cp_application_id
5024: AND DESCRIPTIVE_FLEXFIELD_NAME = cp_attr_group_type
5025: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = cp_attr_group_name

Line 5231: UPDATE ego_fnd_dsc_flx_ctx_ext

5227: IF c_check_agv_name%FOUND OR c_check_obj_name%FOUND THEN
5228: l_views_exist := l_views_exist||' '||UPPER(l_views_to_process(i).ITEM_ATTR_AGV_NAME);--RAISE L_ITEM_VNAME_EXISTS;
5229: l_item_view_failed :=TRUE;
5230: ELSE
5231: UPDATE ego_fnd_dsc_flx_ctx_ext
5232: SET agv_name = UPPER(l_views_to_process(i).ITEM_ATTR_AGV_NAME)
5233: WHERE application_id = 431
5234: AND descriptive_flexfield_name = 'EGO_ITEMMGMT_GROUP'
5235: AND descriptive_flex_context_code = l_views_to_process(i).ITEM_ATTR_GROUP_NAME;

Line 5267: UPDATE ego_fnd_dsc_flx_ctx_ext

5263: IF c_check_agv_name%FOUND OR c_check_obj_name%FOUND THEN
5264: l_views_exist := l_views_exist||' '||UPPER(l_views_to_process(i).TP_ATTR_AGV_NAME);--RAISE L_TP_VNAME_EXISTS;
5265: l_tp_view_failed := TRUE;
5266: ELSE
5267: UPDATE ego_fnd_dsc_flx_ctx_ext
5268: SET agv_name = UPPER(l_views_to_process(i).TP_ATTR_AGV_NAME)
5269: WHERE application_id = 431
5270: AND descriptive_flexfield_name = 'EGO_ITEM_TP_EXT_ATTRS'
5271: AND descriptive_flex_context_code = l_views_to_process(i).TP_ATTR_GROUP_NAME;

Line 5284: FROM EGO_FND_DSC_FLX_CTX_EXT

5280: -- Fetching the attr group id for the item attr group --
5281: --------------------------------------------------------------
5282: SELECT ATTR_GROUP_ID, MULTI_ROW
5283: INTO l_temp_num, l_multi_row_ag
5284: FROM EGO_FND_DSC_FLX_CTX_EXT
5285: WHERE DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_ITEMMGMT_GROUP'
5286: AND APPLICATION_ID = 431
5287: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = l_views_to_process(i).ITEM_ATTR_GROUP_NAME;
5288:

Line 5332: FROM EGO_FND_DSC_FLX_CTX_EXT

5328: ----------------------------------------------------------------------
5329: BEGIN
5330: SELECT ATTR_GROUP_ID
5331: INTO l_temp_num
5332: FROM EGO_FND_DSC_FLX_CTX_EXT
5333: WHERE DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_ITEM_TP_EXT_ATTRS'
5334: AND APPLICATION_ID = 431
5335: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = l_views_to_process(i).TP_ATTR_GROUP_NAME;
5336:

Line 5692: ' EGO_FND_DSC_FLX_CTX_EXT WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE ' ||

5688: END IF;
5689: IF p_gdsn_enabled = 'N' THEN
5690:
5691: l_attr_groups_to_exclude := 'SELECT ATTR_GROUP_ID FROM '||
5692: ' EGO_FND_DSC_FLX_CTX_EXT WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE ' ||
5693: ' LIKE ''EGOINT_GDSN%'' AND APPLICATION_ID = 431 ' ||
5694: ' AND DESCRIPTIVE_FLEXFIELD_NAME = ''EGO_ITEMMGMT_GROUP'' ' ;
5695: END IF;
5696: EGO_USER_ATTRS_DATA_PVT.Apply_Default_Vals_For_Entity