INSERT INTO WKS_SCRIPT_MESSAGE(
   SCRIPT_MESSAGE_ID,
   SCRIPT_VARIATION_CD,
   SCRIPT_MESSAGE_TEXT,
   BEG_DT, END_DT,
   DELETE_FLAG,
   MESSAGE_REQUIRED_FLAG,
   SCRIPT_MESSAGE_TYPE_CD
   )
  VALUES((SELECT MAX(TO_NUMBER(script_message_id))+ 1
            FROM WKS_SCRIPT_MESSAGE ),
          '0',
          'Provide the caller with the address for mailing the death certificate, and then click  "Close '||
          '&'||' Wrap" when ready to complete.',SYSDATE,'','N','N','16001'
          );