USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPTRANSFERPROCESS

The load procedure used by the edit dataform template "Sponsorship Transfer Process Edit 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.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@NAME	nvarchar(100)	INOUT	Name
@DESCRIPTION	nvarchar(255)	INOUT	Description
@IDSETREGISTERID	uniqueidentifier	INOUT	Selection
@SPONSORSHIPPROGRAMID	uniqueidentifier	INOUT	Program
@SPONSORSHIPLOCATIONID	uniqueidentifier	INOUT	Location
@SPROPPAGERANGEID	uniqueidentifier	INOUT	Age range
@GENDERCODE	int	INOUT	Gender
@ISHIVPOSITIVECODE	int	INOUT	HIV positive
@HASCONDITIONCODE	int	INOUT	Disability/Illness
@ISORPHANEDCODE	int	INOUT	Orphaned
@SPROPPPROJECTCATEGORYCODEID	uniqueidentifier	INOUT	Category
@SPONSORPREFERENCECODE	int	INOUT	Preferences option
@SPONSORSHIPREASONID	uniqueidentifier	INOUT	Reason
@SPONSORSHIPRECORDTYPEID	uniqueidentifier	INOUT	Sponsorship record type
@FORMTITLE	nvarchar(100)	INOUT
@MATCHINGRULECODE	int	INOUT	Matching rule
@TRANSFERTYPECODE	int	INOUT	Transfer type
@CREATESOURCESPONSORSHIPSIDSET	bit	INOUT	Create selection of successfully transferred source sponsorships
@SOURCESELECTIONNAME	nvarchar(100)	INOUT	Selection name
@OVERWRITESOURCESELECTION	bit	INOUT	Overwrite existing selection
@CREATETARGETSPONSORSHIPSIDSET	bit	INOUT	Create selection of successfully transferred target sponsorships
@TARGETSELECTIONNAME	nvarchar(100)	INOUT	Selection name
@OVERWRITETARGETSELECTION	bit	INOUT	Overwrite existing selection
@CREATEUNSUCCESSFULSPONSORSHIPSIDSET	bit	INOUT	Create selection of sponsorships not successfully transferred
@UNSUCCESSFULSELECTIONNAME	nvarchar(100)	INOUT	Selection name
@OVERWRITEUNSUCCESSFULSELECTION	bit	INOUT	Overwrite existing selection

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPTRANSFERPROCESS
          (
          @ID uniqueidentifier,
          @DATALOADED bit = 0 output,
          @TSLONG bigint = 0 output,    
            @NAME nvarchar(100) = null output,
            @DESCRIPTION nvarchar(255) = null output,
            @IDSETREGISTERID uniqueidentifier = null output,
          @SPONSORSHIPPROGRAMID uniqueidentifier = null output,
          @SPONSORSHIPLOCATIONID uniqueidentifier = null output,          
          @SPROPPAGERANGEID uniqueidentifier = null output,
          @GENDERCODE int = null output,
          @ISHIVPOSITIVECODE int = null output,
          @HASCONDITIONCODE int = null output,
          @ISORPHANEDCODE int = null output,
          @SPROPPPROJECTCATEGORYCODEID uniqueidentifier = null output,
          @SPONSORPREFERENCECODE int = null output,
          @SPONSORSHIPREASONID uniqueidentifier = null output,
            @SPONSORSHIPRECORDTYPEID uniqueidentifier = null output,
          @FORMTITLE nvarchar(100) = null output,
          @MATCHINGRULECODE int = null output,
          @TRANSFERTYPECODE int = null output,
            @CREATESOURCESPONSORSHIPSIDSET bit = null output,
                  @SOURCESELECTIONNAME nvarchar(100) = null output, 
                  @OVERWRITESOURCESELECTION bit = null output,
            @CREATETARGETSPONSORSHIPSIDSET bit = null output,
                  @TARGETSELECTIONNAME nvarchar(100) = null output, 
                  @OVERWRITETARGETSELECTION bit = null output,
            @CREATEUNSUCCESSFULSPONSORSHIPSIDSET bit = null output,
                  @UNSUCCESSFULSELECTIONNAME nvarchar(100) = null output, 
                  @OVERWRITEUNSUCCESSFULSELECTION bit = null output)
        as

          set nocount on;
          set @DATALOADED = 0;
          set @TSLONG = 0;

        --set @FORMTITLE = 'Edit sponsorship transfer business process'


          select
              @DATALOADED = 1,
              @NAME = NAME,
              @DESCRIPTION = DESCRIPTION,
              @IDSETREGISTERID = IDSETREGISTERID,
          @SPONSORSHIPPROGRAMID = SPONSORSHIPPROGRAMID,
          @SPONSORSHIPLOCATIONID = SPONSORSHIPLOCATIONID,          
          @SPROPPAGERANGEID = SPROPPAGERANGEID,
          @GENDERCODE = GENDERCODE, 
          @ISHIVPOSITIVECODE = ISHIVPOSITIVECODE, 
          @HASCONDITIONCODE = HASCONDITIONCODE,
          @ISORPHANEDCODE = ISORPHANEDCODE,
          @SPROPPPROJECTCATEGORYCODEID = SPROPPPROJECTCATEGORYCODEID,
          @SPONSORPREFERENCECODE = SPONSORPREFERENCECODE,
          @SPONSORSHIPREASONID = SPONSORSHIPREASONID,
          @MATCHINGRULECODE = MATCHINGRULECODE,
          @TRANSFERTYPECODE = TRANSFERTYPECODE,
            @CREATESOURCESPONSORSHIPSIDSET = CREATESOURCESPONSORSHIPSIDSET,
                  @SOURCESELECTIONNAME = SOURCESELECTIONNAME, 
                  @OVERWRITESOURCESELECTION = OVERWRITESOURCESELECTION,
            @CREATETARGETSPONSORSHIPSIDSET = CREATETARGETSPONSORSHIPSIDSET,
                  @TARGETSELECTIONNAME = TARGETSELECTIONNAME, 
                  @OVERWRITETARGETSELECTION = OVERWRITETARGETSELECTION,
            @CREATEUNSUCCESSFULSPONSORSHIPSIDSET = CREATEUNSUCCESSFULSPONSORSHIPSIDSET,
                  @UNSUCCESSFULSELECTIONNAME = UNSUCCESSFULSELECTIONNAME, 
                  @OVERWRITEUNSUCCESSFULSELECTION = OVERWRITEUNSUCCESSFULSELECTION          

          from 
              dbo.SPONSORSHIPTRANSFERPROCESS
          where 
              ID = @ID;

          select @SPONSORSHIPRECORDTYPEID = ID from dbo.RECORDTYPE where upper(NAME) = 'SPONSORSHIP';

          return 0;