APPS.EGO_ITEM_PVT dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 2318: FROM EGO_FND_DSC_FLX_CTX_EXT

2314: -- Find the Attr Group ID and Label we will be inserting --
2315: -----------------------------------------------------------
2316: SELECT ATTR_GROUP_ID
2317: INTO l_attr_group_id
2318: FROM EGO_FND_DSC_FLX_CTX_EXT
2319: WHERE APPLICATION_ID = 431
2320: AND DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_ITEMMGMT_GROUP'
2321: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = 'ItemDetailDesc';
2322: --commented out as a part of Bug 4906499

Line 5499: FROM EGO_FND_DSC_FLX_CTX_EXT EXT1

5495: ,cp_attr_group_type IN VARCHAR2
5496: ,cp_attr_group_name IN VARCHAR2
5497: ) IS
5498: SELECT AGV_NAME
5499: FROM EGO_FND_DSC_FLX_CTX_EXT EXT1
5500: WHERE EXT1.AGV_NAME = cp_agv_name
5501: AND EXT1.ATTR_GROUP_ID NOT IN (SELECT ATTR_GROUP_ID
5502: FROM EGO_FND_DSC_FLX_CTX_EXT EXT2
5503: WHERE EXT2.AGV_NAME = cp_agv_name

Line 5502: FROM EGO_FND_DSC_FLX_CTX_EXT EXT2

5498: SELECT AGV_NAME
5499: FROM EGO_FND_DSC_FLX_CTX_EXT EXT1
5500: WHERE EXT1.AGV_NAME = cp_agv_name
5501: AND EXT1.ATTR_GROUP_ID NOT IN (SELECT ATTR_GROUP_ID
5502: FROM EGO_FND_DSC_FLX_CTX_EXT EXT2
5503: WHERE EXT2.AGV_NAME = cp_agv_name
5504: AND EXT2.APPLICATION_ID = cp_application_id
5505: AND EXT2.DESCRIPTIVE_FLEXFIELD_NAME = cp_attr_group_type
5506: AND EXT2.DESCRIPTIVE_FLEX_CONTEXT_CODE = cp_attr_group_name);

Line 5517: FROM EGO_FND_DSC_FLX_CTX_EXT

5513: SELECT OBJECT_NAME
5514: FROM SYS.ALL_OBJECTS
5515: WHERE OBJECT_NAME = cp_agv_name
5516: AND OBJECT_NAME NOT IN (SELECT AGV_NAME
5517: FROM EGO_FND_DSC_FLX_CTX_EXT
5518: WHERE AGV_NAME = cp_agv_name
5519: AND APPLICATION_ID = cp_application_id
5520: AND DESCRIPTIVE_FLEXFIELD_NAME = cp_attr_group_type
5521: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = cp_attr_group_name

Line 5727: UPDATE ego_fnd_dsc_flx_ctx_ext

5723: IF c_check_agv_name%FOUND OR c_check_obj_name%FOUND THEN
5724: l_views_exist := l_views_exist||' '||UPPER(l_views_to_process(i).ITEM_ATTR_AGV_NAME);--RAISE L_ITEM_VNAME_EXISTS;
5725: l_item_view_failed :=TRUE;
5726: ELSE
5727: UPDATE ego_fnd_dsc_flx_ctx_ext
5728: SET agv_name = UPPER(l_views_to_process(i).ITEM_ATTR_AGV_NAME)
5729: WHERE application_id = 431
5730: AND descriptive_flexfield_name = 'EGO_ITEMMGMT_GROUP'
5731: AND descriptive_flex_context_code = l_views_to_process(i).ITEM_ATTR_GROUP_NAME;

Line 5763: UPDATE ego_fnd_dsc_flx_ctx_ext

5759: IF c_check_agv_name%FOUND OR c_check_obj_name%FOUND THEN
5760: l_views_exist := l_views_exist||' '||UPPER(l_views_to_process(i).TP_ATTR_AGV_NAME);--RAISE L_TP_VNAME_EXISTS;
5761: l_tp_view_failed := TRUE;
5762: ELSE
5763: UPDATE ego_fnd_dsc_flx_ctx_ext
5764: SET agv_name = UPPER(l_views_to_process(i).TP_ATTR_AGV_NAME)
5765: WHERE application_id = 431
5766: AND descriptive_flexfield_name = 'EGO_ITEM_TP_EXT_ATTRS'
5767: AND descriptive_flex_context_code = l_views_to_process(i).TP_ATTR_GROUP_NAME;

Line 5780: FROM EGO_FND_DSC_FLX_CTX_EXT

5776: -- Fetching the attr group id for the item attr group --
5777: --------------------------------------------------------------
5778: SELECT ATTR_GROUP_ID, MULTI_ROW
5779: INTO l_temp_num, l_multi_row_ag
5780: FROM EGO_FND_DSC_FLX_CTX_EXT
5781: WHERE DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_ITEMMGMT_GROUP'
5782: AND APPLICATION_ID = 431
5783: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = l_views_to_process(i).ITEM_ATTR_GROUP_NAME;
5784:

Line 5828: FROM EGO_FND_DSC_FLX_CTX_EXT

5824: ----------------------------------------------------------------------
5825: BEGIN
5826: SELECT ATTR_GROUP_ID
5827: INTO l_temp_num
5828: FROM EGO_FND_DSC_FLX_CTX_EXT
5829: WHERE DESCRIPTIVE_FLEXFIELD_NAME = 'EGO_ITEM_TP_EXT_ATTRS'
5830: AND APPLICATION_ID = 431
5831: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = l_views_to_process(i).TP_ATTR_GROUP_NAME;
5832:

Line 6207: ' EGO_FND_DSC_FLX_CTX_EXT WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE ' ||

6203: END IF;
6204: IF p_gdsn_enabled = 'N' THEN
6205:
6206: l_attr_groups_to_exclude := 'SELECT ATTR_GROUP_ID FROM '||
6207: ' EGO_FND_DSC_FLX_CTX_EXT WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE ' ||
6208: ' LIKE ''EGOINT_GDSN%'' AND APPLICATION_ID = 431 ' ||
6209: ' AND DESCRIPTIVE_FLEXFIELD_NAME = ''EGO_ITEMMGMT_GROUP'' ' ;
6210: END IF;
6211: EGO_USER_ATTRS_DATA_PVT.Apply_Default_Vals_For_Entity