USP_GLOBALCHANGE_EDITINSTANCE

Edits the specified global change instance.

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@GLOBALCHANGEDATAFORMITEM	xml	IN
@SITEID	uniqueidentifier	IN

Definition

Copy



            CREATE procedure dbo.USP_GLOBALCHANGE_EDITINSTANCE
            (
                @ID uniqueidentifier,                        
                @CHANGEAGENTID uniqueidentifier = null,                
                @NAME nvarchar(100),
                @GLOBALCHANGEDATAFORMITEM xml,
                @SITEID uniqueidentifier = null
            )
            as
            begin

                set nocount on

                declare @CURRENTDATE datetime
                set @CURRENTDATE = getdate()

                begin try
                    if @CHANGEAGENTID is null  
                        exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;

                    update dbo.GLOBALCHANGE
                    set
                        NAME = @NAME,
                        GLOBALCHANGEDATAFORMITEM = @GLOBALCHANGEDATAFORMITEM,
                        CHANGEDBYID = @CHANGEAGENTID,
                        DATECHANGED = @CURRENTDATE
                    where ID = @ID;                        

                    update dbo.BUSINESSPROCESSINSTANCE 
                    set 
                        SITEID = @SITEID, 
                        CHANGEDBYID = @CHANGEAGENTID, 
                        DATECHANGED = @CURRENTDATE                        
                    where BUSINESSPROCESSPARAMETERSETID = @ID;

                end try

                begin catch
                    exec dbo.USP_RAISE_ERROR
                    return 1
                end catch

                return 0
            end