USP_DATAFORMTEMPLATE_ADD_VENDOR_IND_PRELOAD
The load procedure used by the edit dataform template "Vendor Individual Add Data Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ADDRESS_COUNTRYID | uniqueidentifier | INOUT | Country |
| @ZIPLOOKUPCOUNTRIES | xml | INOUT | |
| @VALIDATIONCOUNTRIES | xml | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_VENDOR_IND_PRELOAD (
@ADDRESS_COUNTRYID uniqueidentifier = null output
,@ZIPLOOKUPCOUNTRIES xml = null output
,@VALIDATIONCOUNTRIES xml = null output
)
as
set nocount on;
exec @ADDRESS_COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT;
select @ZIPLOOKUPCOUNTRIES = dbo.UFN_ZIPCITYSTATE_GETCOUNTRIES_TOITEMLISTXML();
select @VALIDATIONCOUNTRIES = dbo.UFN_COUNTRY_GETVALIDATIONCOUNTRIES_TOITEMLISTXML();
return 0;