APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on MTL_ITEM_CATALOG_GROUPS_KFV

Line 299: FROM MTL_ITEM_CATALOG_GROUPS_KFV

295: WHEN OTHERS THEN
296: l_token_table(1).TOKEN_NAME := 'CAT_GROUP_NAME';
297: SELECT CONCATENATED_SEGMENTS
298: INTO l_token_table(1).TOKEN_VALUE
299: FROM MTL_ITEM_CATALOG_GROUPS_KFV
300: WHERE ITEM_CATALOG_GROUP_ID = p_catalog_group_id;
301: ERROR_HANDLER.Add_Error_Message(
302: p_message_name => 'EGO_TOO_MANY_CAT_GROUPS'
303: ,p_application_id => 'EGO'

Line 423: l_current_category_name MTL_ITEM_CATALOG_GROUPS_KFV.concatenated_segments%TYPE;

419: l_current_attr_group_obj EGO_ATTR_GROUP_METADATA_OBJ;
420: l_policy_check_name VARCHAR2(30);
421: l_add_all_to_cm VARCHAR2(1);
422: l_current_attr_group_name FND_DESCR_FLEX_CONTEXTS_TL.descriptive_flex_context_name%TYPE;
423: l_current_category_name MTL_ITEM_CATALOG_GROUPS_KFV.concatenated_segments%TYPE;
424: l_current_life_cycle VARCHAR2(240);
425: l_current_phase_name VARCHAR2(240);
426: l_prev_loop_org_id NUMBER;
427: l_prev_loop_inv_item_id NUMBER;

Line 2766: FROM MTL_ITEM_CATALOG_GROUPS_KFV

2762: l_current_category_name := l_catalog_category_names_table(error_rec.prog_int_num1);--Bugfix:5343821
2763: ELSE
2764: SELECT concatenated_segments
2765: INTO l_current_category_name
2766: FROM MTL_ITEM_CATALOG_GROUPS_KFV
2767: WHERE ITEM_CATALOG_GROUP_ID = error_rec.prog_int_num1;
2768: l_catalog_category_names_table(error_rec.prog_int_num1) := l_current_category_name;
2769: END IF;
2770: l_token_table(3).TOKEN_NAME := 'CATALOG_CATEGORY_NAME';