USP_DATAFORMTEMPLATE_TAXDECLARATION_EDIT_2

The save procedure used by the edit dataform template "Tax Declaration Edit Form 2".

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.
@DECLARATIONMADE	datetime	IN	Made
@DECLARATIONSTARTS	datetime	IN	Start date
@DECLARATIONENDS	datetime	IN	End date
@DECLARATIONINDICATORCODE	tinyint	IN	Indicator
@DECLARATIONSOURCECODEID	uniqueidentifier	IN	Source
@CHARITYCLAIMREFERENCENUMBERID	uniqueidentifier	IN	Reference number
@SCANNEDDOCSEXIST	bit	IN	Scanned documents exist
@CONFIRMATIONSENT	datetime	IN	Sent
@CONFIRMATIONRETURNED	datetime	IN	Returned
@PAYSTAXCODE	tinyint	IN	Pays tax
@TAXSTATUSCODEID	uniqueidentifier	IN	Status
@COMMENTS	nvarchar(255)	IN	Comment
@CURRENTAPPUSERID	uniqueidentifier	IN	Input parameter indicating the ID of the current user.

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_TAXDECLARATION_EDIT_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @DECLARATIONMADE datetime,
    @DECLARATIONSTARTS datetime,
    @DECLARATIONENDS datetime,
    @DECLARATIONINDICATORCODE tinyint,
    @DECLARATIONSOURCECODEID uniqueidentifier,
    @CHARITYCLAIMREFERENCENUMBERID uniqueidentifier,                        
    @SCANNEDDOCSEXIST bit,
    @CONFIRMATIONSENT datetime,
    @CONFIRMATIONRETURNED datetime,
    @PAYSTAXCODE tinyint,
    @TAXSTATUSCODEID uniqueidentifier,
    @COMMENTS nvarchar(255),
    @CURRENTAPPUSERID uniqueidentifier
)
as
    set nocount on;

    declare @NAMEOPTIONCODE tinyint;
    declare @ALIASID uniqueidentifier;
    declare @ADDRESSOPTIONCODE tinyint;
    declare @ADDRESSID uniqueidentifier;

    exec dbo.USP_DATAFORMTEMPLATE_TAXDECLARATION_EDITLOAD_2
        @ID = @ID,
        @NAMEOPTIONCODE = @NAMEOPTIONCODE output,
        @ALIASID = @ALIASID output,
        @ADDRESSOPTIONCODE = @ADDRESSOPTIONCODE output,
        @ADDRESSID = @ADDRESSID output;

    exec dbo.USP_DATAFORMTEMPLATE_TAXDECLARATION_EDIT_3
        @ID,
        @CHANGEAGENTID,
        @DECLARATIONMADE,
        @DECLARATIONSTARTS,
        @DECLARATIONENDS,
        @DECLARATIONINDICATORCODE,
        @DECLARATIONSOURCECODEID,
        @CHARITYCLAIMREFERENCENUMBERID,                        
        @SCANNEDDOCSEXIST,
        @CONFIRMATIONSENT,
        @CONFIRMATIONRETURNED,
        @PAYSTAXCODE,
        @TAXSTATUSCODEID,
        @COMMENTS,
        @CURRENTAPPUSERID,
        @NAMEOPTIONCODE,
        @ALIASID,
        @ADDRESSOPTIONCODE,
        @ADDRESSID;

  return 0;