USP_DATAFORMTEMPLATE_EDITSAVE_COUNTRY_4

Edit DataForm Template for Country records

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.
@DESCRIPTION	nvarchar(100)	IN	Description
@ABBREVIATION	nvarchar(5)	IN	Abbreviation
@COUNTRYADDRESSFORMATID	uniqueidentifier	IN	Address format
@INACTIVE	bit	IN	Inactive
@ALLOWVALIDATION	bit	IN	Allow address validation
@VALIDATIONCOUNTRYCODE	tinyint	IN	Validate as
@ADDRESSLABEL	nvarchar(25)	IN	Address label
@CITYLABEL	nvarchar(25)	IN	City label
@REGIONLABEL	nvarchar(25)	IN	Region label
@POSTCODELABEL	nvarchar(25)	IN	Postcode label
@DPCLABEL	nvarchar(25)	IN	DPC label
@CARTLABEL	nvarchar(25)	IN	CART label
@LOTLABEL	nvarchar(25)	IN	LOT label
@COUNTYLABEL	nvarchar(25)	IN	County label
@CONGRESSIONALDISTRICTLABEL	nvarchar(25)	IN	Congressional district label
@STATEHOUSEDISTRICTLABEL	nvarchar(25)	IN	State house district label
@STATESENATEDISTRICTLABEL	nvarchar(25)	IN	State senate district label
@LOCALPRECINCTLABEL	nvarchar(25)	IN	Local precinct label

Definition

Copy



            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_COUNTRY_4
            (
                @ID uniqueidentifier,
                @CHANGEAGENTID uniqueidentifier = null,
                @DESCRIPTION nvarchar(100),
                @ABBREVIATION nvarchar(5),
                @COUNTRYADDRESSFORMATID uniqueidentifier,
                @INACTIVE bit,
                @ALLOWVALIDATION bit,
                @VALIDATIONCOUNTRYCODE tinyint,
                @ADDRESSLABEL nvarchar(25),
                @CITYLABEL nvarchar(25),
                @REGIONLABEL nvarchar(25),
                @POSTCODELABEL nvarchar(25),
                @DPCLABEL nvarchar(25),
                @CARTLABEL nvarchar(25),
                @LOTLABEL nvarchar(25),
                @COUNTYLABEL nvarchar(25),
                @CONGRESSIONALDISTRICTLABEL nvarchar(25),
                @STATEHOUSEDISTRICTLABEL nvarchar(25),
                @STATESENATEDISTRICTLABEL nvarchar(25),
                @LOCALPRECINCTLABEL nvarchar(25)
            )
            as
            begin
                set nocount on;

                declare @PHONEFORMATCODE tinyint;

                exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_COUNTRY_4
                    @ID,
                    @PHONEFORMATCODE = @PHONEFORMATCODE output;

                exec dbo.USP_DATAFORMTEMPLATE_EDITSAVE_COUNTRY_5
                    @ID,
                    @CHANGEAGENTID,
                    @DESCRIPTION,
                    @ABBREVIATION,
                    @COUNTRYADDRESSFORMATID,
                    @INACTIVE,
                    @ALLOWVALIDATION,
                    @VALIDATIONCOUNTRYCODE,
                    @ADDRESSLABEL,
                    @CITYLABEL,
                    @REGIONLABEL,
                    @POSTCODELABEL,
                    @DPCLABEL,
                    @CARTLABEL,
                    @LOTLABEL,
                    @COUNTYLABEL,
                    @CONGRESSIONALDISTRICTLABEL,
                    @STATEHOUSEDISTRICTLABEL,
                    @STATESENATEDISTRICTLABEL,
                    @LOCALPRECINCTLABEL,
                    @PHONEFORMATCODE

            end