USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIPCONFIGURATION

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.
@RELATIONSHIP	nvarchar(200)	IN	Relationship
@GENDERCODE	tinyint	IN	Gender
@APPLIESTOINDIVIDUALS	bit	IN	Individuals
@APPLIESTOORGANIZATIONS	bit	IN	Organizations
@APPLIESTOGROUPS	bit	IN	Groups/Households
@RELATESTOINDIVIDUALS	bit	IN	Individuals
@RELATESTOORGANIZATIONS	bit	IN	Organizations
@RELATESTOGROUPS	bit	IN	Groups/Households
@ISEMPLOYEERELATIONSHIP	bit	IN	Is employee relationship type

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIPCONFIGURATION
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier,
    @RELATIONSHIP nvarchar(200),
    @GENDERCODE tinyint,
    @APPLIESTOINDIVIDUALS bit,
    @APPLIESTOORGANIZATIONS bit,
    @APPLIESTOGROUPS bit,
    @RELATESTOINDIVIDUALS bit,
    @RELATESTOORGANIZATIONS bit,
    @RELATESTOGROUPS bit,
    @ISEMPLOYEERELATIONSHIP bit
)

as
    set nocount on;

    declare @ISPEERRELATIONSHIPTYPE bit;

    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_RELATIONSHIPCONFIGURATION
        @ID = @ID,
        @ISPEERRELATIONSHIPTYPE = @ISPEERRELATIONSHIPTYPE output

    exec dbo.USP_DATAFORMTEMPLATE_EDIT_RELATIONSHIPCONFIGURATION_2
        @ID,
        @CHANGEAGENTID,
        @RELATIONSHIP,
        @GENDERCODE,
        @APPLIESTOINDIVIDUALS,
        @APPLIESTOORGANIZATIONS,
        @APPLIESTOGROUPS,
        @RELATESTOINDIVIDUALS,
        @RELATESTOORGANIZATIONS,
        @RELATESTOGROUPS,
        @ISEMPLOYEERELATIONSHIP,
        @ISPEERRELATIONSHIPTYPE

    return 0;