USP_DATAFORMTEMPLATE_VIEW_ASSIGNPLANNEDGIFTLETTERCODESPROCESS

The load procedure used by the view dataform template "Assign Planned Gift Letters Process View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@IDSETREGISTERNAME	nvarchar(60)	INOUT	Selection
@DATELASTRUN	datetime	INOUT	Date last run
@CREATEOUTPUTIDSET	bit	INOUT	Create output selection
@OUTPUTIDSETNAME	nvarchar(100)	INOUT	Output selection name
@OVERWRITEOUTPUTIDSET	bit	INOUT	Overwrite existing selection
@OUTPUTIDSETRECORDTYPENAME	nvarchar(100)	INOUT	Output selection type
@BUSINESSPROCESSCATALOGID	uniqueidentifier	INOUT	BUSINESSPROCESSCATALOGID
@PARAMETERSID	uniqueidentifier	INOUT	PARAMETERSID

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_ASSIGNPLANNEDGIFTLETTERCODESPROCESS
        (
          @ID uniqueidentifier,
          @DATALOADED bit = 0 output,
          @NAME nvarchar(100) = null output,
          @DESCRIPTION nvarchar(255) = null output,
          @IDSETREGISTERNAME nvarchar(60) = null output,
          @DATELASTRUN datetime = null output,
          @CREATEOUTPUTIDSET bit = null output,
          @OUTPUTIDSETNAME nvarchar(100) = null output,
          @OVERWRITEOUTPUTIDSET bit = null output,
          @OUTPUTIDSETRECORDTYPENAME nvarchar(100) = null output, 
          @BUSINESSPROCESSCATALOGID uniqueidentifier = null output,
          @PARAMETERSID uniqueidentifier = null output            
        )
        as
          set nocount on;

          set @DATALOADED = 0;

          select
            @DATALOADED = 1,
            @NAME = ASSIGNPLANNEDGIFTLETTERCODESPROCESS.NAME,
            @DESCRIPTION = ASSIGNPLANNEDGIFTLETTERCODESPROCESS.DESCRIPTION,
            @IDSETREGISTERNAME = dbo.UFN_IDSET_GETNAME(ASSIGNPLANNEDGIFTLETTERCODESPROCESS.IDSETREGISTERID),
            @DATELASTRUN = ASSIGNPLANNEDGIFTLETTERCODESPROCESS.DATELASTRUN,
            @CREATEOUTPUTIDSET = ASSIGNPLANNEDGIFTLETTERCODESPROCESS.CREATEOUTPUTIDSET,
            @OUTPUTIDSETNAME = ASSIGNPLANNEDGIFTLETTERCODESPROCESS.OUTPUTIDSETNAME,
            @OVERWRITEOUTPUTIDSET = ASSIGNPLANNEDGIFTLETTERCODESPROCESS.OVERWRITEOUTPUTIDSET,
            @OUTPUTIDSETRECORDTYPENAME = dbo.UFN_TRANSLATIONFUNCTION_RECORDTYPE_GETNAME(ASSIGNPLANNEDGIFTLETTERCODESPROCESS.OUTPUTIDSETRECORDTYPEID), 
            @BUSINESSPROCESSCATALOGID = '37910A93-C849-4B83-8664-BB22BD12EAFC',
            @PARAMETERSID = @ID                        
          from
            dbo.ASSIGNPLANNEDGIFTLETTERCODESPROCESS
          where
            ASSIGNPLANNEDGIFTLETTERCODESPROCESS.ID = @ID;

          return 0;