USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTRECOGNITIONDECLINEDLEVELSBYLEVEL

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@TSLONG	bigint	INOUT
@RECOGNITIONPROGRAMID	uniqueidentifier	INOUT
@DECLINEPROGRAM	bit	INOUT
@DECLINEDRECOGNITIONLEVELS	xml	INOUT
@REASONCODE	uniqueidentifier	INOUT

Definition

Copy


        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_CONSTITUENTRECOGNITIONDECLINEDLEVELSBYLEVEL
        (
            @ID uniqueidentifier,
            @DATALOADED bit = 0 output,
            @TSLONG bigint = 0 output,
              @RECOGNITIONPROGRAMID uniqueidentifier = null output,
              @DECLINEPROGRAM bit = null output,
              @DECLINEDRECOGNITIONLEVELS xml = null output,
            @REASONCODE uniqueidentifier = null output
        )
        as

         set nocount on;

            set @DATALOADED = 0

          declare @CONSTITUENTID uniqueidentifier

          select @CONSTITUENTID = CONSTITUENTID,
                 @RECOGNITIONPROGRAMID = RECOGNITIONPROGRAMID,
                 @REASONCODE = REASONCODEID
          from dbo.CONSTITUENTRECOGNITIONDECLINEDLEVEL 
          where ID = @ID 

          select @CONSTITUENTID = CONSTITUENTID,
                 @RECOGNITIONPROGRAMID = RECOGNITIONPROGRAMID,
                 @REASONCODE = REASONCODEID
          from dbo.CONSTITUENTRECOGNITIONDECLINEDPROGRAM
          where ID = @ID 



          set @DECLINEPROGRAM = case when exists (select ID from dbo.CONSTITUENTRECOGNITIONDECLINEDPROGRAM where ID=@ID) then 1
                                else 0
                                end;

          select
                  @DATALOADED = 1,
              @DECLINEDRECOGNITIONLEVELS =  (SELECT [DECLINED], [DECLINEDLEVELID], [RECOGNITIONLEVELID],[RECOGNITIONLEVELNAME]
                                              FROM dbo.[UFN_CONSTITUENTRECOGNITION_GETDECLINEDLEVELS](@CONSTITUENTID, @RECOGNITIONPROGRAMID)
                                              for xml raw('ITEM'),type,elements,root('DECLINEDRECOGNITIONLEVELS'),BINARY BASE64)                      

            return 0;