USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@NAME	nvarchar(100)	INOUT
@DESCRIPTION	nvarchar(255)	INOUT
@PROCESSPROGRAMS	nvarchar(255)	INOUT
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT
@PARAMETERSID	uniqueidentifier	INOUT
@DEFAULTPROCESS	bit	INOUT
@PROCESSPROGRAMSCODE	tinyint	INOUT
@MEMBERSHIPPROGRAMID	uniqueidentifier	INOUT
@CREATEOUTPUTIDSET	bit	INOUT
@OUTPUTSELECTIONNAME	nvarchar(255)	INOUT
@OVERWRITEOUTPUTSELECTION	bit	INOUT

Definition

Copy


        CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS
        (
        @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @NAME nvarchar(100) = null output, 
                @DESCRIPTION nvarchar(255) = null output, 
        @PROCESSPROGRAMS nvarchar(255) = null output,
                @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
                @PARAMETERSID uniqueidentifier = null output,
        @DEFAULTPROCESS bit  = null output,
        @PROCESSPROGRAMSCODE tinyint = null output,
        @MEMBERSHIPPROGRAMID uniqueidentifier = null output,
        @CREATEOUTPUTIDSET bit = null output,
        @OUTPUTSELECTIONNAME nvarchar(255) = null output,
        @OVERWRITEOUTPUTSELECTION  bit=null output
        )
        as
          set nocount on;

                set @DATALOADED = 0;

                select
                    @DATALOADED = 1,
                    @NAME = MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.NAME, 
                    @DESCRIPTION = MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.DESCRIPTION,                     
                    @PROCESSPROGRAMS = case MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.PROCESSPROGRAMSCODE
            when 0 then MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.PROCESSPROGRAMS
            when 1 then MP.NAME
            else MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.PROCESSPROGRAMS
            end,
                    @BUSINESSPROCESSCATALOGID = 'e2f6ff31-29ec-4480-b9a2-293c35fd2ca3',
                    @PARAMETERSID = @ID,
          @PROCESSPROGRAMSCODE = MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.PROCESSPROGRAMSCODE,
          @MEMBERSHIPPROGRAMID = MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.MEMBERSHIPPROGRAMID,
          @CREATEOUTPUTIDSET = MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.CREATEOUTPUTIDSET,
          @OUTPUTSELECTIONNAME = MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.OUTPUTSELECTIONNAME,
          @OVERWRITEOUTPUTSELECTION = MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.OVERWRITEOUTPUTSELECTION
                from dbo.MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS
        left join dbo.MEMBERSHIPPROGRAM MP on MP.ID = MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.MEMBERSHIPPROGRAMID
                where
                    MEMBERSHIPPROGRAMCONTRIBUTIONPROCESS.ID = @ID;

          set @DEFAULTPROCESS = 0;
          If exists (select 1 from dbo.SCHEDULE where ID = 'BDE5586B-D5C6-4849-9E14-22DD27D054E7') 
            if @ID = 'e2f6ff31-29ec-4480-b9a2-293c35fd2ca3'
              set @DEFAULTPROCESS = 1;  

            return 0;