56: stmt_num :=100;
57:
58: SELECT MICGK.concatenated_segments
59: INTO group_name
60: FROM mtl_item_catalog_groups_kfv MICGK
61: WHERE MICGK.item_catalog_group_id = group_id;
62:
63: else
64: /* This is to get the description of the catalog */
63: else
64: /* This is to get the description of the catalog */
65: SELECT MICG.description
66: INTO group_name
67: FROM mtl_item_catalog_groups MICG
68: WHERE MICG.item_catalog_group_id = group_id;
69:
70: end if;
71: return(0);