USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_GROUPTOORG_3

Edits a relationship between a group and an organization.

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_GROUPTOORG_3
                (
                    @ID uniqueidentifier,
                    @CHANGEAGENTID uniqueidentifier = null,                                                                        
                    @RELATIONSHIPTYPECODEID uniqueidentifier,
                    @RECIPROCALTYPECODEID uniqueidentifier,                                                
                    @STARTDATE datetime,
                    @ENDDATE datetime,
                    @COMMENTS nvarchar(max),
                    @ISMATCHINGGIFTRELATIONSHIP bit
                )    
                as
                    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 USP_DATAFORMTEMPLATE_EDITLOAD_RELATIONSHIP_GROUPTOORG
                        @ID = @ID,
                        @PRIMARYISCONSTITUENT = @PRIMARYISCONSTITUENT output,
                        @PRIMARYSOFTCREDITRELATIONSHIPEXISTS = @PRIMARYSOFTCREDITRELATIONSHIPEXISTS output,
                        @PRIMARYSOFTCREDITMATCHFACTOR = @PRIMARYSOFTCREDITMATCHFACTOR output,
                        @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS = @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS output,
                        @RECIPROCALSOFTCREDITMATCHFACTOR = @RECIPROCALSOFTCREDITMATCHFACTOR output,
                        @PRIMARYRECOGNITIONTYPECODEID = @PRIMARYRECOGNITIONTYPECODEID output,
                        @RECIPROCALRECOGNITIONTYPECODEID = @RECIPROCALRECOGNITIONTYPECODEID output

                    exec USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_GROUPTOORG_4
                        @ID,
                        @CHANGEAGENTID,                                                                        
                        @RELATIONSHIPTYPECODEID,
                        @RECIPROCALTYPECODEID,                                                
                        @STARTDATE,
                        @ENDDATE,
                        @COMMENTS,
                        @ISMATCHINGGIFTRELATIONSHIP,
                        @PRIMARYISCONSTITUENT,
                        @PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
                        @PRIMARYSOFTCREDITMATCHFACTOR,
                        @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
                        @RECIPROCALSOFTCREDITMATCHFACTOR,
                        @PRIMARYRECOGNITIONTYPECODEID,
                        @RECIPROCALRECOGNITIONTYPECODEID

                    return 0;