USP_DATAFORMTEMPLATE_EDIT_HOUSEHOLDRECOGNITIONDEFAULTSETTINGS_2

Parameters

Parameter	Parameter Type	Mode	Description
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@HOUSEHOLDRECOGNIZEHOUSEHOLD	bit	IN	Household
@HOUSEHOLDRECOGNIZEMEMBERS	bit	IN	All members
@MEMBERRECOGNIZEHOUSEHOLD	bit	IN	Household
@MEMBERRECOGNIZEMEMBER	bit	IN	Member
@MEMBERRECOGNIZEOTHERMEMBERS	bit	IN	All other members
@HOUSEHOLDREVENUERECOGNITIONTYPECODEID	uniqueidentifier	IN	Default recognition credit type
@MEMBERREVENUERECOGNITIONTYPECODEID	uniqueidentifier	IN	Default recognition credit type

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_HOUSEHOLDRECOGNITIONDEFAULTSETTINGS_2
(
    @CHANGEAGENTID uniqueidentifier = null,
    @HOUSEHOLDRECOGNIZEHOUSEHOLD bit,
    @HOUSEHOLDRECOGNIZEMEMBERS bit,
    @MEMBERRECOGNIZEHOUSEHOLD bit,
    @MEMBERRECOGNIZEMEMBER bit,
    @MEMBERRECOGNIZEOTHERMEMBERS bit,
    @HOUSEHOLDREVENUERECOGNITIONTYPECODEID uniqueidentifier,
    @MEMBERREVENUERECOGNITIONTYPECODEID uniqueidentifier
)

as
  set nocount on;

    declare @MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_HOUSEHOLDRECOGNITIONDEFAULTSETTINGS
        @MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID = @MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_HOUSEHOLDRECOGNITIONDEFAULTSETTINGS_3
        @CHANGEAGENTID,
        @HOUSEHOLDRECOGNIZEHOUSEHOLD,
        @HOUSEHOLDRECOGNIZEMEMBERS,
        @MEMBERRECOGNIZEHOUSEHOLD,
        @MEMBERRECOGNIZEMEMBER,
        @MEMBERRECOGNIZEOTHERMEMBERS,
        @HOUSEHOLDREVENUERECOGNITIONTYPECODEID,
        @MEMBERREVENUERECOGNITIONTYPECODEID,
        @MEMBERHOUSEHOLDREVENUERECOGNITIONTYPECODEID

  return 0;