cust_hdc_sp_sms_start

CREATE PROC [dbo].[cust_hdc_sp_sms_start] (
	@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 = 1 WHERE '1' + phone_number_stripped = @FromNumber
	SET @OutStatus = 1
	SET @OutMessage = 'Thank you for your interest. Send "info" for list of commands.'
END