USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPTRANSFERPROCESS

The save procedure used by the add dataform template "Sponsorship Transfer Process Add Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	INOUT	The output parameter indicating the ID of the record added.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@NAME	nvarchar(100)	IN	Name
@DESCRIPTION	nvarchar(255)	IN	Description
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@SPONSORSHIPPROGRAMID	uniqueidentifier	IN	Program
@SPONSORSHIPLOCATIONID	uniqueidentifier	IN	Location
@SPROPPAGERANGEID	uniqueidentifier	IN	Age range
@GENDERCODE	int	IN	Gender
@ISHIVPOSITIVECODE	int	IN	HIV positive
@HASCONDITIONCODE	int	IN	Disability/Illness
@ISORPHANEDCODE	int	IN	Orphaned
@SPROPPPROJECTCATEGORYCODEID	uniqueidentifier	IN	Category
@SPONSORPREFERENCECODE	int	IN	Preferences option
@SPONSORSHIPREASONID	uniqueidentifier	IN	Reason
@MATCHINGRULECODE	int	IN	Matching rule
@TRANSFERTYPECODE	int	IN	Transfer type
@CREATESOURCESPONSORSHIPSIDSET	bit	IN	Create selection of successfully transferred source sponsorships
@SOURCESELECTIONNAME	nvarchar(100)	IN	Selection name
@OVERWRITESOURCESELECTION	bit	IN	Overwrite existing selection
@CREATETARGETSPONSORSHIPSIDSET	bit	IN	Create selection of successfully transferred target sponsorships
@TARGETSELECTIONNAME	nvarchar(100)	IN	Selection name
@OVERWRITETARGETSELECTION	bit	IN	Overwrite existing selection
@CREATEUNSUCCESSFULSPONSORSHIPSIDSET	bit	IN	Create selection of sponsorships not successfully transferred
@UNSUCCESSFULSELECTIONNAME	nvarchar(100)	IN	Selection name
@OVERWRITEUNSUCCESSFULSELECTION	bit	IN	Overwrite existing selection

Definition

Copy



          CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_SPONSORSHIPTRANSFERPROCESS
          (
              @ID uniqueidentifier = null output,    
              @CHANGEAGENTID uniqueidentifier = null,    
              @NAME nvarchar(100) = '',
              @DESCRIPTION nvarchar(255) = '',   
              @IDSETREGISTERID uniqueidentifier = null,
              @SPONSORSHIPPROGRAMID uniqueidentifier = null,
              @SPONSORSHIPLOCATIONID uniqueidentifier = null,          
              @SPROPPAGERANGEID uniqueidentifier = null,
              @GENDERCODE int = 0,
              @ISHIVPOSITIVECODE int = 0,
              @HASCONDITIONCODE int = 0,
              @ISORPHANEDCODE int = 0,
              @SPROPPPROJECTCATEGORYCODEID uniqueidentifier = null,
              @SPONSORPREFERENCECODE int = 0,
              @SPONSORSHIPREASONID uniqueidentifier = null,
              @MATCHINGRULECODE int = 0,
              @TRANSFERTYPECODE int  = 0,
                @CREATESOURCESPONSORSHIPSIDSET bit = 0,
                          @SOURCESELECTIONNAME nvarchar(100) = '', 
                          @OVERWRITESOURCESELECTION bit = 0,
                @CREATETARGETSPONSORSHIPSIDSET bit = 0,
                          @TARGETSELECTIONNAME nvarchar(100) = '', 
                          @OVERWRITETARGETSELECTION bit = 0,
                @CREATEUNSUCCESSFULSPONSORSHIPSIDSET bit = 0,
                          @UNSUCCESSFULSELECTIONNAME nvarchar(100) = '', 
                          @OVERWRITEUNSUCCESSFULSELECTION bit = 0              
          )
          as
          set nocount on;
          if @ID is null
              set @ID = newid()

          if @CHANGEAGENTID is null  
              exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output

          declare @CURRENTDATE datetime
          set @CURRENTDATE = getdate()

          begin try
              insert into dbo.SPONSORSHIPTRANSFERPROCESS
                     ([ID]
                     ,[NAME]
                     ,[DESCRIPTION]
                     ,[IDSETREGISTERID]
                     ,[SPONSORSHIPPROGRAMID]
                     ,[SPONSORSHIPLOCATIONID]
                     ,[SPROPPAGERANGEID]
                     ,[GENDERCODE]
                     ,[ISHIVPOSITIVECODE]
                     ,[HASCONDITIONCODE]
                     ,[ISORPHANEDCODE]
                     ,[SPROPPPROJECTCATEGORYCODEID]
                     ,[SPONSORPREFERENCECODE]
                     ,[SPONSORSHIPREASONID]
                     ,[MATCHINGRULECODE]
                     ,[TRANSFERTYPECODE]
                     ,[CREATESOURCESPONSORSHIPSIDSET]
                     ,[SOURCESELECTIONNAME]
                     ,[OVERWRITESOURCESELECTION]
                     ,[CREATETARGETSPONSORSHIPSIDSET]
                     ,[TARGETSELECTIONNAME]
                     ,[OVERWRITETARGETSELECTION]
                     ,[CREATEUNSUCCESSFULSPONSORSHIPSIDSET]
                     ,[UNSUCCESSFULSELECTIONNAME]
                     ,[OVERWRITEUNSUCCESSFULSELECTION]
                     ,[ADDEDBYID]
                     ,[CHANGEDBYID]
                     ,[DATEADDED]
                     ,[DATECHANGED])
               values(
                     @ID,
                         @NAME,
                         @DESCRIPTION,
                         @IDSETREGISTERID,
                     @SPONSORSHIPPROGRAMID,
                     @SPONSORSHIPLOCATIONID,          
                     @SPROPPAGERANGEID,
                     isnull(@GENDERCODE,0),
                     isnull(@ISHIVPOSITIVECODE,0),
                     isnull(@HASCONDITIONCODE,0),
                     isnull(@ISORPHANEDCODE,0),
                     @SPROPPPROJECTCATEGORYCODEID,
                     @SPONSORPREFERENCECODE,
                     @SPONSORSHIPREASONID,
                     @MATCHINGRULECODE,
                     @TRANSFERTYPECODE,
                     @CREATESOURCESPONSORSHIPSIDSET,
                     @SOURCESELECTIONNAME,
                     @OVERWRITESOURCESELECTION,
                     @CREATETARGETSPONSORSHIPSIDSET,
                     @TARGETSELECTIONNAME,
                     @OVERWRITETARGETSELECTION,     
                     @CREATEUNSUCCESSFULSPONSORSHIPSIDSET,
                     @UNSUCCESSFULSELECTIONNAME,
                     @OVERWRITEUNSUCCESSFULSELECTION,                          
                         @CHANGEAGENTID,
                         @CHANGEAGENTID,
                         @CURRENTDATE,
                         @CURRENTDATE)
            end try

            begin catch
                exec dbo.USP_RAISE_ERROR
                return 1
            end catch
          return 0