USP_REVENUE_CLEARANDADDCAMPAIGNS

Removes existing campaigns and adds default campaigns based on designations.

Parameters

Parameter	Parameter Type	Mode
@REVENUEID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            create procedure dbo.USP_REVENUE_CLEARANDADDCAMPAIGNS
            (
                @REVENUEID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier,
                @CHANGEDATE datetime
            )
            as
                set nocount on

                begin try
                    exec dbo.USP_REVENUE_CLEARCAMPAIGNS @REVENUEID, @CHANGEAGENTID

                    exec dbo.USP_REVENUE_ADDCAMPAIGNS @REVENUEID, @CHANGEAGENTID, @CHANGEDATE
                end try
                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1                
                end catch