CREATE OR REPLACE TRIGGER SOT_COMMENT_ADMIN_REMARK
AFTER INSERT OR UPDATE OF SO_COMMENT ON SOCIAL_OFFICE_TRANSACTION
FOR EACH ROW
BEGIN
IF (:NEW.SO_COMMENT IS NOT NULL) THEN
  IF (:NEW.SO_COMMENT LIKE '%Remarque 1 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 1 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 1);
  END IF;

    IF (:NEW.SO_COMMENT LIKE '%Remarque 2 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 2 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 2);
  END IF;

    IF (:NEW.SO_COMMENT LIKE '%Remarque 3 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 3 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 3);
  END IF;

    IF (:NEW.SO_COMMENT LIKE '%Remarque 4 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 4 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 4);
  END IF;

    IF (:NEW.SO_COMMENT LIKE '%Remarque 5 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 5 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 5);
  END IF;

    IF (:NEW.SO_COMMENT LIKE '%Remarque 6 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 6 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 6);
  END IF;

    IF (:NEW.SO_COMMENT LIKE '%Remarque 7 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 7 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 7);
  END IF;

    IF (:NEW.SO_COMMENT LIKE '%Remarque 8 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 8 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 8);
  END IF;

    IF (:NEW.SO_COMMENT LIKE '%Remarque 9 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 9 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 9);
  END IF;

    IF (:NEW.SO_COMMENT LIKE '%Remarque 10 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 10 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 10);
  END IF;

    IF (:NEW.SO_COMMENT LIKE '%Remarque 11 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 11 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 11);
  END IF;

    IF (:NEW.SO_COMMENT LIKE '%Remarque 12 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 12 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 12);
  END IF;

    IF (:NEW.SO_COMMENT LIKE '%Remarque 13 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 13 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 13);
  END IF;

    IF (:NEW.SO_COMMENT LIKE '%Remarque 14 %' OR :NEW.SO_COMMENT LIKE '%Opmerking 14 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 14);
  END IF;

    IF (:NEW.SO_COMMENT LIKE '%Remarque 15 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 15 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 15);
  END IF;

    IF (:NEW.SO_COMMENT LIKE '%Remarque 16 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 16 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 16);
  END IF;

    IF (:NEW.SO_COMMENT LIKE '%Remarque 17 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 17 :%') THEN
    INSERT INTO SOT_ADMIN_REMARK
    VALUES (:NEW.social_office_transaction_id, 17);
  END IF;
END IF;
END;