115: select MTL_CATEGORIES_S.nextval
116: into l_New_Category_ID
117: from dual ;
118:
119: INSERT INTO MTL_CATEGORIES_B
120: (
121: CATEGORY_ID ,
122: STRUCTURE_ID ,
123: DISABLE_DATE ,
325:
326: DELETE FROM MTL_CATEGORIES_TL
327: WHERE CATEGORY_ID = l_category_id ;
328:
329: DELETE FROM MTL_CATEGORIES_B
330: WHERE CATEGORY_ID = l_category_id ;
331:
332: ELSE
333: p_return_sts := 2 ;
591: THEN
592: p_category_id := FND_FLEX_KEYVAL.combination_id ;
593: ELSE
594: p_return_sts := 3 ;
595: p_return_err := 'Get_Category_ID: Table MTL_CATEGORIES_B, flexfield MCAT: ' ||
596: FND_FLEX_KEYVAL.error_message ;
597: RETURN;
598: END IF;
599: