USP_DATAFORMTEMPLATE_EDIT_HOUSEHOLDRECOGNITIONSETTINGS

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.
@HOUSEHOLDRECOGNIZEHOUSEHOLD	bit	IN	Household
@HOUSEHOLDRECOGNIZEMEMBERS	tinyint	IN	All members
@HOUSEHOLDSPECIFIEDMEMBERS	xml	IN	Household specified members
@MEMBERRECOGNIZEHOUSEHOLD	bit	IN	Household
@MEMBERRECOGNIZEMEMBER	bit	IN	Member
@MEMBERRECOGNIZEOTHERMEMBERS	tinyint	IN	All other members
@MEMBERSPECIFIEDMEMBERS	xml	IN	Member specified members

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_HOUSEHOLDRECOGNITIONSETTINGS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @HOUSEHOLDRECOGNIZEHOUSEHOLD bit,
    @HOUSEHOLDRECOGNIZEMEMBERS tinyint,
    @HOUSEHOLDSPECIFIEDMEMBERS xml,
    @MEMBERRECOGNIZEHOUSEHOLD bit,
    @MEMBERRECOGNIZEMEMBER bit,
    @MEMBERRECOGNIZEOTHERMEMBERS tinyint,
    @MEMBERSPECIFIEDMEMBERS xml
)

as
  set nocount on;

    declare @HOUSEHOLDREVENUERECOGNITIONTYPECODEID uniqueidentifier;
    declare @MEMBERREVENUERECOGNITIONTYPECODEID uniqueidentifier;
    declare @MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_HOUSEHOLDRECOGNITIONSETTINGS
        @ID = @ID,
        @HOUSEHOLDREVENUERECOGNITIONTYPECODEID = @HOUSEHOLDREVENUERECOGNITIONTYPECODEID output,
        @MEMBERREVENUERECOGNITIONTYPECODEID = @MEMBERREVENUERECOGNITIONTYPECODEID output,
        @MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID = @MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_HOUSEHOLDRECOGNITIONSETTINGS_2
        @ID,
        @CHANGEAGENTID,
        @HOUSEHOLDRECOGNIZEHOUSEHOLD,
        @HOUSEHOLDRECOGNIZEMEMBERS,
        @HOUSEHOLDSPECIFIEDMEMBERS,
        @MEMBERRECOGNIZEHOUSEHOLD,
        @MEMBERRECOGNIZEMEMBER,
        @MEMBERRECOGNIZEOTHERMEMBERS,
        @MEMBERSPECIFIEDMEMBERS,
        @HOUSEHOLDREVENUERECOGNITIONTYPECODEID,
        @MEMBERREVENUERECOGNITIONTYPECODEID,
        @MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID

  return 0;