USP_OPPORTUNITY_UPDATEACCEPTEDSTATUS

Marks an opportunity as accepted with a given response date if it was not previously accepted.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATE	datetime	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTDATE	datetime	IN

Definition

Copy



CREATE procedure dbo.USP_OPPORTUNITY_UPDATEACCEPTEDSTATUS
(
    @ID uniqueidentifier,
    @DATE datetime,
    @CHANGEAGENTID uniqueidentifier,
    @CURRENTDATE datetime
    )
    as
    begin

        update dbo.OPPORTUNITY set
            STATUSCODE = 3,  -- Accepted

            ASKDATE = coalesce(ASKDATE, @DATE),
            ACCEPTEDASKAMOUNT = ASKAMOUNT,
            TRANSACTIONACCEPTEDASKAMOUNT = TRANSACTIONASKAMOUNT,
            ORGANIZATIONACCEPTEDASKAMOUNT = ORGANIZATIONASKAMOUNT,
            RESPONSEDATE = @DATE,
            CHANGEDBYID = @CHANGEAGENTID,
            DATECHANGED = @CURRENTDATE
        where
            ID = @ID and STATUSCODE <> 3
    end