USP_DATAFORMTEMPLATE_EDIT_HOUSEHOLDRECOGNITIONDEFAULTSETTINGS

Backwards compatibility save method for HouseholdRecognitionDefaultSettins.Edit

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
@MEMBERREVENUERECOGNITIONTYPECODEID	uniqueidentifier	IN

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_HOUSEHOLDRECOGNITIONDEFAULTSETTINGS
(
    @CHANGEAGENTID uniqueidentifier = null,
    @HOUSEHOLDRECOGNIZEHOUSEHOLD bit,
    @HOUSEHOLDRECOGNIZEMEMBERS bit,
    @MEMBERRECOGNIZEHOUSEHOLD bit,
    @MEMBERRECOGNIZEMEMBER bit,
    @MEMBERRECOGNIZEOTHERMEMBERS bit,
    @HOUSEHOLDREVENUERECOGNITIONTYPECODEID uniqueidentifier,
    @MEMBERREVENUERECOGNITIONTYPECODEID uniqueidentifier
)
as
begin
    -- do work

    declare @HOUSEHOLDRECOGNITIONTYPE uniqueidentifier
    declare @MEMBERRECOGNITIONTYPE uniqueidentifier
    exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_HOUSEHOLDRECOGNITIONDEFAULTSETTINGS 
        @HOUSEHOLDREVENUERECOGNITIONTYPECODEID = @HOUSEHOLDRECOGNITIONTYPE output, 
        @MEMBERREVENUERECOGNITIONTYPECODEID = @MEMBERRECOGNITIONTYPE output
    exec dbo.USP_DATAFORMTEMPLATE_EDIT_HOUSEHOLDRECOGNITIONDEFAULTSETTINGS_2 
        @CHANGEAGENTID, 
        @HOUSEHOLDRECOGNIZEHOUSEHOLD, 
        @HOUSEHOLDRECOGNIZEMEMBERS, 
        @MEMBERRECOGNIZEHOUSEHOLD,
        @MEMBERRECOGNIZEMEMBER,
        @MEMBERRECOGNIZEOTHERMEMBERS,
        @HOUSEHOLDRECOGNITIONTYPE,
        @MEMBERRECOGNITIONTYPE
end