DBA Data[Home] [Help]

APPS.BOM_PFI_PVT dependencies on MTL_CATEGORIES_B

Line 119: INSERT INTO MTL_CATEGORIES_B

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 ,

Line 329: DELETE FROM MTL_CATEGORIES_B

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 ;

Line 595: p_return_err := 'Get_Category_ID: Table MTL_CATEGORIES_B, flexfield MCAT: ' ||

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: