2339: FETCH get_parent_category_id_csr into l_parent_categories;
2340: EXIT WHEN get_parent_category_id_csr%NOTFOUND;
2341:
2342: SELECT C.CONCATENATED_SEGMENTS into l_category_name
2343: FROM MTL_CATEGORIES_KFV C
2344: WHERE C.CATEGORY_ID = l_parent_categories.CATEGORY_ID;
2345:
2346: l_tmp_names := l_category_hierarchy_names;
2347: IF (l_tmp_names IS NULL) THEN
2357: IF l_tmp_names IS NOT NULL THEN
2358: l_category_hierarchy_names := l_category_set_name || ' > ' || l_tmp_names;
2359: ELSE
2360: SELECT C.CONCATENATED_SEGMENTS into l_category_hierarchy_names
2361: FROM MTL_CATEGORIES_KFV C
2362: WHERE C.CATEGORY_ID = p_category_id;
2363: END IF;
2364: RETURN l_category_hierarchy_names;
2365: