SAD

IF(v_size_package != rec.PACK_SIZE OR v_type_package != rec.PACK_TYPE OR v_diet_type != red.DIET_TYPE OR v_liquid_weight != rec.LIQ_WEIGHT) THEN
              UPDATE t_dim_product
              SET is_expired_version = 'YES'
              WHERE product_key = v_product_key;
            ELSE
                 INSERT INTO t_dim_products(
                      PRODUCT_KEY, PRODUCT_NATURAL_KEY, PRODUCT_NAME, PRODUCT_BRAND,
                      PRODUCT_CATEGORY,
                      PRODUCT_SIZE_PACKAGE,
                      PRODUCT_TYPE_PACKAGE,
                      PRODUCT_DIET_TYPE,
                      PRODUCT_LIQUID_WEIGHT,
                      IS_EXPIRED_VERSION
                      )
                  VALUES (SEQ_DIM_PRODUCT.nextval, rec.id, rec.name,rec.BRAND,
                      rec.CATEGORY_NAME,
                      rec.PACK_SIZE,
                      rec.PACK_TYPE,
                      rec.DIET_TYPE,
                      rec.LIQ_WEIGHT,
                      FALSE);
           END IF;