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