USP_DATAFORMTEMPLATE_PRELOAD_ADD_CONSTITUENTNAMEFORMAT
The load procedure used by the edit dataform template "Constituent Name Format Add Form"
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@CONSTITUENTID | uniqueidentifier | IN | Input parameter indicating the context ID for the record being added. |
@CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
@SITEID | uniqueidentifier | INOUT | Site |
@SITEREQUIRED | bit | INOUT | Site Required |
@NAMEFORMATFUNCTIONS | xml | INOUT |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_PRELOAD_ADD_CONSTITUENTNAMEFORMAT
(
@CONSTITUENTID uniqueidentifier,
@CURRENTAPPUSERID uniqueidentifier,
@SITEID uniqueidentifier = null output,
@SITEREQUIRED bit = null output,
@NAMEFORMATFUNCTIONS xml = null output
)
as
begin
set nocount on;
select
@SITEID = dbo.UFN_APPUSER_DEFAULTSITEFORUSER(@CURRENTAPPUSERID),
@SITEREQUIRED = dbo.UFN_SITEREQUIREDFORUSER(@CURRENTAPPUSERID),
@NAMEFORMATFUNCTIONS = dbo.UFN_CONSTITUENT_NAMEFORMATFUNCTIONS_TOITEMLISTXML(@CONSTITUENTID);
return 0;
end