830: CURSOR DEFAULT_CAT_ASSIGN_CREATE ( CP_ITEM_ID NUMBER
831: ,CP_ORG_ID NUMBER ) IS
832: SELECT S.CATEGORY_SET_ID,
833: S.CATEGORY_ID
834: FROM MTL_ITEM_CATEGORIES S
835: WHERE S.INVENTORY_ITEM_ID = CP_ITEM_ID
836: AND S.ORGANIZATION_ID = CP_ORG_ID
837: AND EXISTS
838: (SELECT 'X'
855: CURSOR DEFAULT_CAT_ASSIGN_UPDATE ( CP_ITEM_ID NUMBER
856: ,CP_ORG_ID NUMBER ) IS
857: SELECT S.CATEGORY_SET_ID,
858: S.CATEGORY_ID
859: FROM MTL_ITEM_CATEGORIES S,
860: MTL_CATEGORY_SETS_B D
861: WHERE S.INVENTORY_ITEM_ID = CP_ITEM_ID
862: AND S.CATEGORY_SET_ID = D.CATEGORY_SET_ID
863: AND S.ORGANIZATION_ID = CP_ORG_ID