USP_DATAFORMTEMPLATE_EDITLOAD_DECEASINGOPTIONS

The load procedure used by the edit dataform template "Deceasing Options Edit Form"

Parameters

Parameter	Parameter Type	Mode	Description
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@UPDATECONSTITUENCIES	bit	INOUT	Update constituencies
@UPDATERELATIONSHIPS	bit	INOUT	Update relationships
@ADDDOCUMENTATION	bit	INOUT	Update documentation
@UPDATECONSTITUENTINTERACTIONS	bit	INOUT	Update pending interactions
@UPDATECONSTITUENTNAMEFORMATS	bit	INOUT	Update name formats
@ADDTRIBUTE	bit	INOUT	Update tributes
@UPDATEHOUSEHOLDMEMBERS	bit	INOUT	Update members
@UPDATEHOUSEHOLDINTERACTIONS	bit	INOUT	Update pending interactions
@UPDATEHOUSEHOLDNAMEFORMATS	bit	INOUT	Update name formats
@SHOWGROUPS	bit	INOUT	Show groups

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_DECEASINGOPTIONS
(
  @DATALOADED bit = 0 output,
  @UPDATECONSTITUENCIES bit = null output,
  @UPDATERELATIONSHIPS bit = null output,
  @ADDDOCUMENTATION bit = null output,
  @UPDATECONSTITUENTINTERACTIONS bit = null output,
  @UPDATECONSTITUENTNAMEFORMATS bit = null output,
  @ADDTRIBUTE bit = null output,
  @UPDATEHOUSEHOLDMEMBERS bit = null output,
  @UPDATEHOUSEHOLDINTERACTIONS bit = null output,
  @UPDATEHOUSEHOLDNAMEFORMATS bit = null output,
  @SHOWGROUPS bit = null output
) 
as
  set nocount on;
  set @DATALOADED = 0;

  select top 1
    @UPDATECONSTITUENCIES = UPDATECONSTITUENCIES,
    @UPDATERELATIONSHIPS = UPDATERELATIONSHIPS,
    @ADDDOCUMENTATION = ADDDOCUMENTATION,
    @UPDATECONSTITUENTINTERACTIONS = UPDATECONSTITUENTINTERACTIONS,
    @UPDATECONSTITUENTNAMEFORMATS = UPDATECONSTITUENTNAMEFORMATS,
    @ADDTRIBUTE = ADDTRIBUTE,
    @UPDATEHOUSEHOLDMEMBERS = UPDATEHOUSEHOLDMEMBERS,
    @UPDATEHOUSEHOLDINTERACTIONS = UPDATEHOUSEHOLDINTERACTIONS,
    @UPDATEHOUSEHOLDNAMEFORMATS = UPDATEHOUSEHOLDNAMEFORMATS,
    @SHOWGROUPS = SHOWGROUPS,
    @DATALOADED = 1
  from
    dbo.UFN_DECEASINGOPTION_GETRULES();

  return 0;