USP_DATAFORMTEMPLATE_VIEW_RECURRINGGIFTSTATUSUPDATEBUSINESSPROCESSSTATUS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@NAME	nvarchar(100)	INOUT
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT
@PARAMETERSETID	uniqueidentifier	INOUT
@RECENTSTATUSID	uniqueidentifier	INOUT

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_RECURRINGGIFTSTATUSUPDATEBUSINESSPROCESSSTATUS
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @NAME nvarchar(100) = null output,
                    @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
                    @PARAMETERSETID uniqueidentifier = null output,
                    @RECENTSTATUSID uniqueidentifier = null output
                )
                as
                    set nocount on;

                    set @DATALOADED = 0;

                    select 
                        @DATALOADED = 1,
                        @NAME = RECURRINGGIFTSTATUSUPDATEPROCESS.NAME, 
                        @BUSINESSPROCESSCATALOGID = '2a13ea65-e2a3-4edc-8407-ab09ac62d7bb',
                        @PARAMETERSETID = @ID
                    from 
                        dbo.RECURRINGGIFTSTATUSUPDATEPROCESS
                    where
                        RECURRINGGIFTSTATUSUPDATEPROCESS.ID = @ID;

                    select top 1 @RECENTSTATUSID = ID
                        from dbo.BUSINESSPROCESSSTATUS
                        where BUSINESSPROCESSCATALOGID = @BUSINESSPROCESSCATALOGID
                        and BUSINESSPROCESSPARAMETERSETID = @ID
                        order by STARTEDON desc

                    if @RECENTSTATUSID is null
                        set @RECENTSTATUSID = '00000000-0000-0000-0000-000000000000'

                    return 0;