USP_DATAFORMTEMPLATE_ADD_PDACCOUNTCODEMAPDEVELOPMENTBENEFIT_PRELOAD2

The load procedure used by the edit dataform template "Map Development Benefits Add Form 2"

Parameters

Parameter	Parameter Type	Mode	Description
@SYSTEMID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@SUBTYPEONE	xml	INOUT	Benefit
@PDACCOUNTSYSTEMID	uniqueidentifier	INOUT

Definition

Copy


        CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PDACCOUNTCODEMAPDEVELOPMENTBENEFIT_PRELOAD2
        (
            @SYSTEMID  uniqueidentifier,
            @SUBTYPEONE xml = null output,
            @PDACCOUNTSYSTEMID uniqueidentifier = null output
        )
        as

        set nocount on;


        set @SUBTYPEONE = (
            select '99999999-9999-9999-9999-999999999999' as SUBTYPEONEID
            for xml raw('ITEM'), type, elements, root('SUBTYPEONE'), BINARY BASE64
        )

        set @PDACCOUNTSYSTEMID = @SYSTEMID

        return 0;