Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement