DBA Data[Home] [Help]

APPS.BOM_PFI_PVT dependencies on MTL_CATEGORIES_TL

Line 191: insert into MTL_CATEGORIES_TL (

187: IF ( SQL%NOTFOUND ) THEN
188: RAISE CAT_NOT_INSERTED;
189: END IF;
190:
191: insert into MTL_CATEGORIES_TL (
192: CATEGORY_ID,
193: LANGUAGE,
194: SOURCE_LANG,
195: DESCRIPTION,

Line 215: from MTL_CATEGORIES_TL T

211: from FND_LANGUAGES L
212: where L.INSTALLED_FLAG in ('I', 'B')
213: and not exists
214: ( select NULL
215: from MTL_CATEGORIES_TL T
216: where T.CATEGORY_ID = l_New_Category_ID
217: and T.LANGUAGE = L.LANGUAGE_CODE );
218:
219: <>

Line 326: DELETE FROM MTL_CATEGORIES_TL

322: -- The category could have not been created.
323:
324: IF ( l_return_sts = 0 ) THEN
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 ;