USP_DATAFORMTEMPLATE_ADD_BATCHREVENUEORGANIZATION_PRELOAD

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

Parameters

Parameter	Parameter Type	Mode	Description
@ISORGANIZATION	bit	INOUT
@ORGANIZATION_COUNTRYID	uniqueidentifier	INOUT	Country
@ZIPLOOKUPCOUNTRIES	xml	INOUT
@VALIDATIONCOUNTRIES	xml	INOUT

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_BATCHREVENUEORGANIZATION_PRELOAD (
    @ISORGANIZATION bit = null output,
    @ORGANIZATION_COUNTRYID uniqueidentifier = null output,
    @ZIPLOOKUPCOUNTRIES xml = null output,
    @VALIDATIONCOUNTRIES xml = null output

) as
        set nocount on;
        exec @ORGANIZATION_COUNTRYID = dbo.UFN_COUNTRY_GETDEFAULT;

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

        set @ISORGANIZATION = 1;

return 0;