cust_hdc_sp_sms_stop_all_messages

CREATE PROC [dbo].[cust_hdc_sp_sms_stop_all_messages] (
    @FromNumber VARCHAR(20)
    ,@PossiblyFrom VARCHAR(200)
    ,@ToNumber VARCHAR(20)
    ,@ToNumberID INT
    ,@Message VARCHAR(2000)
    ,@OutStatus INT = 0 OUTPUT
    ,@OutMessage VARCHAR(2000) = '' OUTPUT
)
AS
BEGIN
    --
    -- @OutStatus can be one of the following values:
    -- 0 - Message has not been handled, do not send response.
    -- 1 - Message has been handled (no further processing) and send response if @OutMessage is set.
    --

    UPDATE core_person_phone SET sms_enabled = 0 WHERE '1' + phone_number_stripped = @FromNumber
    SET @OutStatus = 1
    SET @OutMessage = 'We will no longer receive text messages from this number. Send "start" to receive messages again.'
END