USP_DATAFORMTEMPLATE_PRELOAD_ADD_ASSIGNPLANNEDGIFTLETTERCODESPROCESS_2

The load procedure used by the edit dataform template "Assign Planned Gift Letters Process Add Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@RECORDTYPEID	uniqueidentifier	INOUT
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@SITEID	uniqueidentifier	INOUT	Site

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_ASSIGNPLANNEDGIFTLETTERCODESPROCESS_2
          (
            @RECORDTYPEID uniqueidentifier = null output,
            @CURRENTAPPUSERID uniqueidentifier = null,
            @SITEID uniqueidentifier = null output
          )
          as
            set nocount on;

            select 
              @RECORDTYPEID = ID
            from 
              dbo.RECORDTYPE 
            where 
              upper(NAME) = 'PLANNED GIFT';

            set @SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID);

            return 0;