USP_DATAFORMTEMPLATE_ADD_REVENUEBATCHGROUP_PRELOAD

The load procedure used by the edit dataform template "Revenue Batch Group Add Form"

Parameters

Parameter	Parameter Type	Mode	Description
@COUNTRYID	uniqueidentifier	INOUT	Country
@ZIPLOOKUPCOUNTRIES	xml	INOUT
@VALIDATIONCOUNTRIES	xml	INOUT

Definition

Copy



                CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_REVENUEBATCHGROUP_PRELOAD 
                (
                    @COUNTRYID uniqueidentifier = null output,
                    @ZIPLOOKUPCOUNTRIES xml = null output,
                    @VALIDATIONCOUNTRIES xml = null output
                ) 
                as
                    set nocount on;

                    exec @COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT;

                    set @ZIPLOOKUPCOUNTRIES = dbo.UFN_ZIPCITYSTATE_GETCOUNTRIES_TOITEMLISTXML();
                    set @VALIDATIONCOUNTRIES = dbo.UFN_COUNTRY_GETVALIDATIONCOUNTRIES_TOITEMLISTXML();

                    return 0;