USP_DATAFORMTEMPLATE_ADD_PDACCOUNTCODEMAPDEVELOPMENTBENEFIT_PRELOAD
The load procedure used by the edit dataform template "Map Development Benefits Add Form"
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @SUBTYPEONE | xml | INOUT | Benefit |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PDACCOUNTCODEMAPDEVELOPMENTBENEFIT_PRELOAD
(
--@REVENUETYPES xml = null output,
@SUBTYPEONE xml = null output
)
as
set nocount on;
--set @REVENUETYPES = (select 'BA688A61-084F-41A1-AB90-CCD63033327F' as REVENUETYPEID for xml raw('ITEM'), type, elements, root('REVENUETYPES'), BINARY BASE64)
set @SUBTYPEONE = (
select '99999999-9999-9999-9999-999999999999' as SUBTYPEONEID
for xml raw('ITEM'), type, elements, root('SUBTYPEONE'), BINARY BASE64
)
return 0;