USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_GROUPTOGROUP_2

Updates a relationship between two groups.

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

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIP_GROUPTOGROUP_2
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier,                                                                        
                        @RELATIONSHIPTYPECODEID uniqueidentifier,
                        @RECIPROCALTYPECODEID uniqueidentifier,                                                
                        @STARTDATE datetime,
                        @ENDDATE datetime,
                        @COMMENTS nvarchar(max)
                    )    
                    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_GROUPTOGROUP
                            @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_GROUPTOGROUP_3
                            @ID,
                            @CHANGEAGENTID,                                                                        
                            @RELATIONSHIPTYPECODEID,
                            @RECIPROCALTYPECODEID,                                                
                            @STARTDATE,
                            @ENDDATE,
                            @COMMENTS,
                            @PRIMARYISCONSTITUENT,
                            @PRIMARYSOFTCREDITRELATIONSHIPEXISTS,
                            @PRIMARYSOFTCREDITMATCHFACTOR,
                            @RECIPROCALSOFTCREDITRELATIONSHIPEXISTS,
                            @RECIPROCALSOFTCREDITMATCHFACTOR,
                            @PRIMARYRECOGNITIONTYPECODEID,
                            @RECIPROCALRECOGNITIONTYPECODEID

                        return 0;