psi_mmobile

Untitled

Sep 25th, 2020
987
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE OR REPLACE TRIGGER SOT_COMMENT_ADMIN_REMARK
  2. AFTER INSERT OR UPDATE OF SO_COMMENT ON SOCIAL_OFFICE_TRANSACTION
  3. FOR EACH ROW
  4. BEGIN
  5. IF (:NEW.SO_COMMENT IS NOT NULL) THEN
  6.   IF (:NEW.SO_COMMENT LIKE '%Remarque 1 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 1 :%') THEN
  7.     INSERT INTO SOT_ADMIN_REMARK
  8.     VALUES (:NEW.social_office_transaction_id, 1);
  9.   END IF;
  10.  
  11.     IF (:NEW.SO_COMMENT LIKE '%Remarque 2 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 2 :%') THEN
  12.     INSERT INTO SOT_ADMIN_REMARK
  13.     VALUES (:NEW.social_office_transaction_id, 2);
  14.   END IF;
  15.  
  16.     IF (:NEW.SO_COMMENT LIKE '%Remarque 3 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 3 :%') THEN
  17.     INSERT INTO SOT_ADMIN_REMARK
  18.     VALUES (:NEW.social_office_transaction_id, 3);
  19.   END IF;
  20.  
  21.     IF (:NEW.SO_COMMENT LIKE '%Remarque 4 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 4 :%') THEN
  22.     INSERT INTO SOT_ADMIN_REMARK
  23.     VALUES (:NEW.social_office_transaction_id, 4);
  24.   END IF;
  25.  
  26.     IF (:NEW.SO_COMMENT LIKE '%Remarque 5 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 5 :%') THEN
  27.     INSERT INTO SOT_ADMIN_REMARK
  28.     VALUES (:NEW.social_office_transaction_id, 5);
  29.   END IF;
  30.  
  31.     IF (:NEW.SO_COMMENT LIKE '%Remarque 6 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 6 :%') THEN
  32.     INSERT INTO SOT_ADMIN_REMARK
  33.     VALUES (:NEW.social_office_transaction_id, 6);
  34.   END IF;
  35.  
  36.     IF (:NEW.SO_COMMENT LIKE '%Remarque 7 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 7 :%') THEN
  37.     INSERT INTO SOT_ADMIN_REMARK
  38.     VALUES (:NEW.social_office_transaction_id, 7);
  39.   END IF;
  40.  
  41.     IF (:NEW.SO_COMMENT LIKE '%Remarque 8 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 8 :%') THEN
  42.     INSERT INTO SOT_ADMIN_REMARK
  43.     VALUES (:NEW.social_office_transaction_id, 8);
  44.   END IF;
  45.  
  46.     IF (:NEW.SO_COMMENT LIKE '%Remarque 9 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 9 :%') THEN
  47.     INSERT INTO SOT_ADMIN_REMARK
  48.     VALUES (:NEW.social_office_transaction_id, 9);
  49.   END IF;
  50.  
  51.     IF (:NEW.SO_COMMENT LIKE '%Remarque 10 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 10 :%') THEN
  52.     INSERT INTO SOT_ADMIN_REMARK
  53.     VALUES (:NEW.social_office_transaction_id, 10);
  54.   END IF;
  55.  
  56.     IF (:NEW.SO_COMMENT LIKE '%Remarque 11 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 11 :%') THEN
  57.     INSERT INTO SOT_ADMIN_REMARK
  58.     VALUES (:NEW.social_office_transaction_id, 11);
  59.   END IF;
  60.  
  61.     IF (:NEW.SO_COMMENT LIKE '%Remarque 12 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 12 :%') THEN
  62.     INSERT INTO SOT_ADMIN_REMARK
  63.     VALUES (:NEW.social_office_transaction_id, 12);
  64.   END IF;
  65.  
  66.     IF (:NEW.SO_COMMENT LIKE '%Remarque 13 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 13 :%') THEN
  67.     INSERT INTO SOT_ADMIN_REMARK
  68.     VALUES (:NEW.social_office_transaction_id, 13);
  69.   END IF;
  70.  
  71.     IF (:NEW.SO_COMMENT LIKE '%Remarque 14 %' OR :NEW.SO_COMMENT LIKE '%Opmerking 14 :%') THEN
  72.     INSERT INTO SOT_ADMIN_REMARK
  73.     VALUES (:NEW.social_office_transaction_id, 14);
  74.   END IF;
  75.  
  76.     IF (:NEW.SO_COMMENT LIKE '%Remarque 15 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 15 :%') THEN
  77.     INSERT INTO SOT_ADMIN_REMARK
  78.     VALUES (:NEW.social_office_transaction_id, 15);
  79.   END IF;
  80.  
  81.     IF (:NEW.SO_COMMENT LIKE '%Remarque 16 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 16 :%') THEN
  82.     INSERT INTO SOT_ADMIN_REMARK
  83.     VALUES (:NEW.social_office_transaction_id, 16);
  84.   END IF;
  85.  
  86.     IF (:NEW.SO_COMMENT LIKE '%Remarque 17 :%' OR :NEW.SO_COMMENT LIKE '%Opmerking 17 :%') THEN
  87.     INSERT INTO SOT_ADMIN_REMARK
  88.     VALUES (:NEW.social_office_transaction_id, 17);
  89.   END IF;
  90. END IF;
  91. END;
RAW Paste Data