USP_AUCTIONITEMBATCH_CONSTITUENT_UPDATEIDS

Updates auction item batch constituent IDs with actual constituent IDs.

Parameters

Parameter	Parameter Type	Mode
@BATCHAUCTIONITEMCONSTITUENTID	uniqueidentifier	IN
@CONSTITUENTID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@CURRENTRECOGNITIONS	xml	IN
@UPDATEDRECOGNITIONS	xml	INOUT
@UPDATEDAPPLICATIONRECOGNITIONS	xml	INOUT

Definition

Copy



            create procedure dbo.USP_AUCTIONITEMBATCH_CONSTITUENT_UPDATEIDS
            (
                @BATCHAUCTIONITEMCONSTITUENTID uniqueidentifier,
                @CONSTITUENTID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @CURRENTRECOGNITIONS xml = null,
                @UPDATEDRECOGNITIONS xml = null output,
                @UPDATEDAPPLICATIONRECOGNITIONS xml = null output
            )
            as
                set nocount on

                if @CHANGEAGENTID is null
                    exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

                declare @CURRENTDATE datetime
                set @CURRENTDATE = getdate()

                --update all existing batches to point to the newly created constituent instead of the imaginary auction item batch version

                update dbo.BATCHAUCTIONITEM 
                    set CONSTITUENTID = @CONSTITUENTID,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                where CONSTITUENTID = @BATCHAUCTIONITEMCONSTITUENTID