USP_DATAFORMTEMPLATE_EDITSAVE_COUNTRY_5

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
@PHONEFORMATCODE	tinyint	IN	Phone format

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITSAVE_COUNTRY_5
(
    @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),
    @PHONEFORMATCODE tinyint
)
as
begin
    set nocount on;

    declare @COUNTRYCODE nvarchar(5);

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

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

    end