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 ,
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: );
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: