USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_ORGTOGROUP_3

Saves edits to a relationship between an organization and a group.

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@RELATIONSHIPTYPECODEID	uniqueidentifier	IN	Relationship type
@RECIPROCALTYPECODEID	uniqueidentifier	IN	Reciprocal relationship type
@STARTDATE	datetime	IN	Start date
@ENDDATE	datetime	IN	End date
@COMMENTS	nvarchar(max)	IN	Comments
@ISMATCHINGGIFTRELATIONSHIP	bit	IN	The organization will match contributions for this relationship

Definition

Copy



        CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_ORGTOGROUP_3
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier = null,                                                                        
                        @RELATIONSHIPTYPECODEID uniqueidentifier,
                        @RECIPROCALTYPECODEID uniqueidentifier,                                                
                        @STARTDATE datetime,
                        @ENDDATE datetime,
                        @COMMENTS nvarchar(max),
                        @ISMATCHINGGIFTRELATIONSHIP bit
                    )    
                    as
                        set nocount on;

                        declare @PRIMARYISCONSTITUENT bit;
                        declare @PRIMARYSOFTCREDITRELATIONSHIPEXISTS bit;
                        declare @PRIMARYSOFTCREDITMATCHFACTOR decimal(5,2);
                        declare @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS bit;
                        declare @RECIPROCALSOFTCREDITMATCHFACTOR decimal(5,2);
                        declare @PRIMARYRECOGNITIONTYPECODEID uniqueidentifier;
                        declare @RECIPROCALRECOGNITIONTYPECODEID uniqueidentifier

                        exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RELATIONSHIP_ORGTOGROUP 
                            @ID = @ID,
                            @PRIMARYISCONSTITUENT = @PRIMARYISCONSTITUENT output,
                            @PRIMARYSOFTCREDITRELATIONSHIPEXISTS = @PRIMARYSOFTCREDITRELATIONSHIPEXISTS output,
                            @PRIMARYSOFTCREDITMATCHFACTOR = @PRIMARYSOFTCREDITMATCHFACTOR output,
                            @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS = @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS output,
                            @RECIPROCALSOFTCREDITMATCHFACTOR = @RECIPROCALSOFTCREDITMATCHFACTOR output,
                            @PRIMARYRECOGNITIONTYPECODEID = @PRIMARYRECOGNITIONTYPECODEID output,
                            @RECIPROCALRECOGNITIONTYPECODEID = @RECIPROCALRECOGNITIONTYPECODEID output

                        exec dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_ORGTOGROUP_4 
                            @ID, 
                            @CHANGEAGENTID, 
                            @RELATIONSHIPTYPECODEID, 
                            @RECIPROCALTYPECODEID,
                            @STARTDATE, 
                            @ENDDATE, 
                            @COMMENTS, 
                            @ISMATCHINGGIFTRELATIONSHIP, 
                            @PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
                            @PRIMARYSOFTCREDITMATCHFACTOR,
                            @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
                            @RECIPROCALSOFTCREDITMATCHFACTOR,
                            @PRIMARYRECOGNITIONTYPECODEID, 
                            @RECIPROCALRECOGNITIONTYPECODEID