USP_DATAFORMTEMPLATE_PRELOAD_ADD_TAXDECLARATION_2

The load procedure used by the edit dataform template "Tax Declaration Add Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.
@CONSTITUENTID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@CHARITYCLAIMREFERENCENUMBERID	uniqueidentifier	INOUT	Reference number
@NAMEOPTIONCODE	tinyint	INOUT
@ADDRESSOPTIONCODE	tinyint	INOUT

Definition

Copy



                    CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_TAXDECLARATION_2
                    (
                        @CURRENTAPPUSERID uniqueidentifier,
                        @CONSTITUENTID uniqueidentifier,
                        @CHARITYCLAIMREFERENCENUMBERID uniqueidentifier = null output,
                        @NAMEOPTIONCODE tinyint = null output,
                        @ADDRESSOPTIONCODE tinyint = null output
                    )
                    as
                    begin
                        set nocount on;

                        declare @SITEID uniqueidentifier;
                        set @SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID);

                        if @SITEID is not null
                            set @CHARITYCLAIMREFERENCENUMBERID = dbo.UFN_CHARITYCLAIMREFERENCENUMBER_GETBYSITE(@SITEID);

                        set @NAMEOPTIONCODE = 0;
                        set @ADDRESSOPTIONCODE = 0;

                        return 0;
                    end