text: -- create new notification role
  INSERT INTO NOTIFICATION_MODULE_ROLE ( NOTIFICATION_MODULE_ROLE_ID, OBJ_ID, VER_NBR, UPDATE_TIMESTAMP, UPDATE_USER, MODULE_CODE, ROLE_NAME ) 
  VALUES ( SEQ_NTFCTN_MODULE_ROLE_ID.NEXTVAL, SYS_GUID(), 1, SYSDATE, 'admin', 7, 'KC-PROTOCOL:Organization Correspondent' )
  /
  -- specify required qualifier
  INSERT INTO NOTIFICATION_MDL_ROLE_QLFR (NOTIFICATION_MDL_ROLE_QLFR_ID, NOTIFICATION_MODULE_ROLE_ID, OBJ_ID, VER_NBR, UPDATE_TIMESTAMP, UPDATE_USER, QUALIFIER)
  values ( SEQ_NTFCTN_MDL_ROLE_QLFR_ID.NEXTVAL, (select NOTIFICATION_MODULE_ROLE_ID from NOTIFICATION_MODULE_ROLE where MODULE_CODE = 7 and ROLE_NAME = 'KC-PROTOCOL:Organization Correspondent'), SYS_GUID(), 1, SYSDATE, 'admin', 'protocol')
  /
  COMMIT
  /
  