USP_ADDPROSPECTPLANSPROCESS_OPPORTUNITYDESIGNATIONS_UPDATEFROMXML_ALWAYSADD

Updates the designation collection on an add prospect plans process from XML. This procedure always deletes and re-adds every entry in the collection to avoid check constraint ordering issues.

Parameters

Parameter	Parameter Type	Mode
@ADDPROSPECTPLANSPROCESSID	uniqueidentifier	IN
@XML	xml	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CHANGEDATE	datetime	IN

Definition

Copy



            create procedure dbo.USP_ADDPROSPECTPLANSPROCESS_OPPORTUNITYDESIGNATIONS_UPDATEFROMXML_ALWAYSADD
            (
                @ADDPROSPECTPLANSPROCESSID uniqueidentifier,
                @XML xml,
                @CHANGEAGENTID uniqueidentifier = null,
                @CHANGEDATE datetime = null
            )
            as
            set nocount on;

            if @CHANGEAGENTID is null
                exec USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

            if @CHANGEDATE is null 
                set @CHANGEDATE = getdate()

            declare @contextCache varbinary(128);
            set @contextCache = CONTEXT_INFO();

            if not @CHANGEAGENTID is null
                set CONTEXT_INFO @CHANGEAGENTID;


            delete from dbo.ADDPROSPECTPLANSPROCESSOPPORTUNITYDESIGNATION where ADDPROSPECTPLANSPROCESSOPPORTUNITYDESIGNATION.ADDPROSPECTPLANSPROCESSID = @ADDPROSPECTPLANSPROCESSID

            if not @contextCache is null
                set CONTEXT_INFO @contextCache;

            exec dbo.USP_ADDPROSPECTPLANSPROCESS_OPPORTUNITYDESIGNATIONS_2_ADDFROMXML @ADDPROSPECTPLANSPROCESSID, @XML, @CHANGEAGENTID, @CHANGEDATE;