USP_GLOBALCHANGE_ADDINSTANCE

Saves a new global change instance.

Parameters

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

Definition

Copy



            CREATE procedure dbo.USP_GLOBALCHANGE_ADDINSTANCE
            (
                @ID uniqueidentifier = null,
                @CHANGEAGENTID uniqueidentifier = null,    
                @GLOBALCHANGECATALOGID uniqueidentifier,
                @GLOBALCHANGEDATAFORMITEM xml = null,
                @NAME nvarchar(100) = '',
                @CURRENTAPPUSERID uniqueidentifier,
                @SITEID uniqueidentifier = null
            )
            as
                set nocount on;

                declare @CURRENTDATE datetime;

                begin try
                    if @ID is null
                        set @ID = newid();

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

                    set @CURRENTDATE = getdate();

                    insert into dbo.GLOBALCHANGE
                        (ID, NAME, GLOBALCHANGECATALOGID, GLOBALCHANGEDATAFORMITEM, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)            
                    values
                        (@ID, @NAME, @GLOBALCHANGECATALOGID, @GLOBALCHANGEDATAFORMITEM, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);

                    exec dbo.USP_BUSINESSPROCESSINSTANCE_ADD 
                        @CHANGEAGENTID = @CHANGEAGENTID, 
                        @BUSINESSPROCESSCATALOGID = '3269A1D1-31CB-4D28-945C-B7623A3EFCCA', 
                        @BUSINESSPROCESSPARAMETERSETID = @ID, 
                        @OWNERID = @CURRENTAPPUSERID,
                        @SITEID = @SITEID;
                end try

                begin catch
                    exec dbo.USP_RAISE_ERROR;
                    return 1;
                end catch

                return 0;