USP_DATAFORMTEMPLATE_EDIT_PHONEFINDERSUBMITPROCESS
The save procedure used by the edit dataform template "PhoneFinder Submit Process Edit Data Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The input ID parameter indicating the ID of the record being edited. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @IDSETREGISTERID | uniqueidentifier | IN | Selected constituents |
| @CREATEOUTPUTIDSET | bit | IN | Create selection from results |
| @OUTPUTIDSETNAME | nvarchar(300) | IN | Selection name |
| @OVERWRITEOUTPUTIDSET | bit | IN | Overwrite existing selection |
| @INDIVIDUALADDRESSINCLUDECODE | tinyint | IN | For individuals |
| @INDIVIDUALADDRESSTYPECODEID | uniqueidentifier | IN | Individuals |
| @ORGANIZATIONADDRESSINCLUDECODE | tinyint | IN | For organizations |
| @ORGANIZATIONADDRESSTYPECODEID | uniqueidentifier | IN | Organizations |
| @INDIVIDUALPHONENUMBERINCLUDECODE | tinyint | IN | For individuals |
| @INDIVIDUALPHONETYPECODEID | uniqueidentifier | IN | Individuals |
| @ORGANIZATIONPHONENUMBERINCLUDECODE | tinyint | IN | For organizations |
| @ORGANIZATIONPHONETYPECODEID | uniqueidentifier | IN | Organizations |
| @INCLUDEINACTIVE | bit | IN | Include inactive constituents |
| @INCLUDEINCOMPLETEADDRESSES | bit | IN | Include incomplete addresses |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_PHONEFINDERSUBMITPROCESS
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null,
@IDSETREGISTERID uniqueidentifier,
@CREATEOUTPUTIDSET bit,
@OUTPUTIDSETNAME nvarchar(300),
@OVERWRITEOUTPUTIDSET bit,
@INDIVIDUALADDRESSINCLUDECODE tinyint,
@INDIVIDUALADDRESSTYPECODEID uniqueidentifier,
@ORGANIZATIONADDRESSINCLUDECODE tinyint,
@ORGANIZATIONADDRESSTYPECODEID uniqueidentifier,
@INDIVIDUALPHONENUMBERINCLUDECODE tinyint,
@INDIVIDUALPHONETYPECODEID uniqueidentifier,
@ORGANIZATIONPHONENUMBERINCLUDECODE tinyint,
@ORGANIZATIONPHONETYPECODEID uniqueidentifier,
@INCLUDEINACTIVE bit,
@INCLUDEINCOMPLETEADDRESSES bit
)
as begin
set nocount on;
declare @INCLUDECONSTITUENTDNM bit;
-- Load the new INCLUDECONSTITUENTDNM field
exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PHONEFINDERSUBMITPROCESS
@ID = @ID,
@INCLUDECONSTITUENTDNM = @INCLUDECONSTITUENTDNM output;
-- Call the new edit procedure
exec dbo.USP_DATAFORMTEMPLATE_EDIT_PHONEFINDERSUBMITPROCESS_2
@ID,
@CHANGEAGENTID,
@IDSETREGISTERID,
@CREATEOUTPUTIDSET,
@OUTPUTIDSETNAME,
@OVERWRITEOUTPUTIDSET,
@INDIVIDUALADDRESSINCLUDECODE,
@INDIVIDUALADDRESSTYPECODEID,
@ORGANIZATIONADDRESSINCLUDECODE,
@ORGANIZATIONADDRESSTYPECODEID,
@INDIVIDUALPHONENUMBERINCLUDECODE,
@INDIVIDUALPHONETYPECODEID,
@ORGANIZATIONPHONENUMBERINCLUDECODE,
@ORGANIZATIONPHONETYPECODEID,
@INCLUDEINACTIVE,
@INCLUDEINCOMPLETEADDRESSES,
@INCLUDECONSTITUENTDNM
end