APPS.BOM_PFI_PVT dependencies on MTL_ITEM_CATEGORIES

Line 454: INSERT INTO MTL_ITEM_CATEGORIES

450: END IF;
451:
452: l_stmt_num := 3 ;
453:
454: INSERT INTO MTL_ITEM_CATEGORIES
455: ( INVENTORY_ITEM_ID ,
456: ORGANIZATION_ID ,
457: CATEGORY_SET_ID ,
458: CATEGORY_ID ,

Line 478: FROM MTL_ITEM_CATEGORIES icat

474: null
475: FROM dual
476: WHERE NOT EXISTS
477: ( SELECT 'x'
478: FROM MTL_ITEM_CATEGORIES icat
479: WHERE icat.INVENTORY_ITEM_ID = l_item_id
480: AND icat.ORGANIZATION_ID = l_org_id
481: AND icat.CATEGORY_SET_ID = G_PF_Category_Set_ID
482: );

Line 520: DELETE FROM MTL_ITEM_CATEGORIES

516: ITEM_CAT_NOTFOUND EXCEPTION ;
517: BEGIN
518: p_return_sts := 0 ;
519:
520: DELETE FROM MTL_ITEM_CATEGORIES
521: WHERE INVENTORY_ITEM_ID = p_item_id
522: AND ORGANIZATION_ID = p_org_id
523: AND CATEGORY_SET_ID = G_PF_Category_Set_ID ;
524: