USP_DATAFORMTEMPLATE_ADD_PLEDGEREMINDERPROCESS
The save procedure used by the add dataform template "Pledge Reminder Process Add Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | INOUT | The output parameter indicating the ID of the record added. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
| @NAME | nvarchar(100) | IN | Name |
| @IDSETREGISTERID | uniqueidentifier | IN | Selection |
| @DESCRIPTION | nvarchar(255) | IN | Description |
| @CREATEOUTPUTIDSET | bit | IN | Create selection from results |
| @OUTPUTIDSETRECORDTYPEID | uniqueidentifier | IN | Selection type |
| @OUTPUTIDSETNAME | nvarchar(100) | IN | Selection name |
| @OVERWRITEOUTPUTIDSET | bit | IN | Overwrite existing Selection |
| @DATETYPECODE | tinyint | IN | Calculate amounts as of |
| @DATE | datetime | IN | Process date |
| @BUSINESSPROCESSVIEWID | uniqueidentifier | IN | Output format |
| @LETTERFILENAME | nvarchar(255) | IN | Word template |
| @LETTERFILE | varbinary | IN | File |
| @LABELFILENAME | nvarchar(255) | IN | Mailing label template |
| @LABELFILE | varbinary | IN | LABELFILE |
| @MARKREMINDERSSENT | bit | IN | Mark reminders sent when process completes |
| @SENTDATETYPECODE | tinyint | IN | Sent date |
| @SENTDATE | datetime | IN | Sent date |
| @EXCLUDEMAIL | bit | IN | Exclude mail |
| @EXCLUDEPHONE | bit | IN | Exclude phone |
| @EXCLUDEEMAIL | bit | IN | Exclude email |
| @HASNAMEFORMATS | bit | IN | |
| @ADDRESSEEFORMATID | uniqueidentifier | IN | Use this format, if defined: |
| @ALTADDRESSEEFORMATID | uniqueidentifier | IN | Otherwise, use this format: |
| @ADDRESSEEFUNCTIONID | uniqueidentifier | IN | Addressee system format: |
| @SALUTATIONFORMATID | uniqueidentifier | IN | Use this format, if defined: |
| @ALTSALUTATIONFORMATID | uniqueidentifier | IN | Otherwise, use this format: |
| @SALUTATIONFUNCTIONID | uniqueidentifier | IN | Salutation system format: |
| @CONTACTADDRESSEEFORMATID | uniqueidentifier | IN | Use this format, if defined: |
| @ALTCONTACTADDRESSEEFORMATID | uniqueidentifier | IN | Otherwise, use this format: |
| @CONTACTADDRESSEEFUNCTIONID | uniqueidentifier | IN | Contact addressee system format: |
| @ORGSALUTATIONCODE | tinyint | IN | Organization salutation |
| @CONTACTSALUTATIONFORMATID | uniqueidentifier | IN | Use this format, if defined: |
| @ALTCONTACTSALUTATIONFORMATID | uniqueidentifier | IN | Otherwise, use this format: |
| @CONTACTSALUTATIONFUNCTIONID | uniqueidentifier | IN | Contact salutation system format: |
| @CONTACTSALUTATIONOPTIONCODE | tinyint | IN | If contact is not available, use: |
| @CUSTOMNAME | nvarchar(100) | IN | Custom name |
| @USEADDRESSEEFORMAT | bit | IN | Use the pre-defined name formats for addressee |
| @USESALUTATIONFORMAT | bit | IN | Use the pre-defined name formats for salutation |
| @USECONTACTADDRESSEEFORMAT | bit | IN | Use the pre-defined name formats for addressee |
| @USEADDRESSEESYSTEMFUNCTION | bit | IN | Use a system function to build the name formats for addressee |
| @USESALUTATIONSYSTEMFUNCTION | bit | IN | Use a system function to build the name formats for salutation |
| @USECONTACTADDRESSEESYSTEMFUNCTION | bit | IN | Use a system function to build the name formats for addressee |
| @USECONTACTSALUTATIONSYSTEMFUNCTION | bit | IN | Use a system function to build the name formats for salutation |
| @USECONTACTSALUTATIONFORMAT | bit | IN | Use the pre-defined name formats for salutation |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_PLEDGEREMINDERPROCESS
(
@ID uniqueidentifier = null output,
@CHANGEAGENTID uniqueidentifier = null,
@NAME nvarchar(100)='',
@IDSETREGISTERID uniqueidentifier = null,
@DESCRIPTION nvarchar(255)='',
@CREATEOUTPUTIDSET bit = 0,
@OUTPUTIDSETRECORDTYPEID uniqueidentifier = null,
@OUTPUTIDSETNAME nvarchar(100) = '',
@OVERWRITEOUTPUTIDSET bit = 0,
@DATETYPECODE tinyint = 0,
@DATE datetime = null,
@BUSINESSPROCESSVIEWID uniqueidentifier = null,
@LETTERFILENAME nvarchar(255) = null,
@LETTERFILE varbinary(max) = null,
@LABELFILENAME nvarchar(255) = null,
@LABELFILE varbinary(max) = null,
@MARKREMINDERSSENT bit = 0,
@SENTDATETYPECODE tinyint = 0,
@SENTDATE datetime = null,
@EXCLUDEMAIL bit = 0,
@EXCLUDEPHONE bit = 0,
@EXCLUDEEMAIL bit = 0,
@HASNAMEFORMATS bit = 0,
@ADDRESSEEFORMATID uniqueidentifier = null,
@ALTADDRESSEEFORMATID uniqueidentifier = null,
@ADDRESSEEFUNCTIONID uniqueidentifier = null,
@SALUTATIONFORMATID uniqueidentifier = null,
@ALTSALUTATIONFORMATID uniqueidentifier = null,
@SALUTATIONFUNCTIONID uniqueidentifier = null,
@CONTACTADDRESSEEFORMATID uniqueidentifier = null,
@ALTCONTACTADDRESSEEFORMATID uniqueidentifier = null,
@CONTACTADDRESSEEFUNCTIONID uniqueidentifier = null,
@ORGSALUTATIONCODE tinyint = 0,
@CONTACTSALUTATIONFORMATID uniqueidentifier = null,
@ALTCONTACTSALUTATIONFORMATID uniqueidentifier = null,
@CONTACTSALUTATIONFUNCTIONID uniqueidentifier = null,
@CONTACTSALUTATIONOPTIONCODE tinyint = 0,
@CUSTOMNAME nvarchar(100) = '',
@USEADDRESSEEFORMAT bit = 0,
@USESALUTATIONFORMAT bit = 0,
@USECONTACTADDRESSEEFORMAT bit = 0,
@USEADDRESSEESYSTEMFUNCTION bit = 0,
@USESALUTATIONSYSTEMFUNCTION bit = 0,
@USECONTACTADDRESSEESYSTEMFUNCTION bit = 0,
@USECONTACTSALUTATIONSYSTEMFUNCTION bit = 0,
@USECONTACTSALUTATIONFORMAT bit = 0
)
as
set nocount on;
declare @CURRENTDATE datetime;
if @ID is null
set @ID = newid();
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
set @CURRENTDATE = getdate();
if @DATE is null
set @DATE = getdate();
begin try
insert into dbo.PLEDGEREMINDERPROCESS
(ID, NAME, DESCRIPTION, IDSETREGISTERID, CREATEOUTPUTIDSET, OUTPUTIDSETRECORDTYPEID, OUTPUTIDSETNAME, OVERWRITEOUTPUTIDSET, DATETYPECODE, DATE, BUSINESSPROCESSVIEWID, LETTERFILENAME, LETTERFILE, LABELFILENAME, LABELFILE, MARKREMINDERSSENT, SENTDATETYPECODE, SENTDATE, EXCLUDEMAIL, EXCLUDEPHONE, EXCLUDEEMAIL, ADDEDBYID, CHANGEDBYID, DATEADDED, DATECHANGED)
values
(@ID, @NAME, @DESCRIPTION, @IDSETREGISTERID, @CREATEOUTPUTIDSET, @OUTPUTIDSETRECORDTYPEID, @OUTPUTIDSETNAME, @OVERWRITEOUTPUTIDSET, @DATETYPECODE, @DATE, @BUSINESSPROCESSVIEWID, @LETTERFILENAME, @LETTERFILE, @LABELFILENAME, @LABELFILE, @MARKREMINDERSSENT, @SENTDATETYPECODE, @SENTDATE, @EXCLUDEMAIL, @EXCLUDEPHONE, @EXCLUDEEMAIL, @CHANGEAGENTID, @CHANGEAGENTID, @CURRENTDATE, @CURRENTDATE);
if @HASNAMEFORMATS = 1
begin
declare @NAMEFORMATID uniqueidentifier;
set @NAMEFORMATID = newid();
insert into dbo.PLEDGEREMINDERPROCESSNAMEFORMAT
( ID,
PLEDGEREMINDERPROCESSID,
ADDRESSEEFORMATID,
ALTADDRESSEEFORMATID,
ADDRESSEEFUNCTIONID,
SALUTATIONFORMATID,
ALTSALUTATIONFORMATID,
SALUTATIONFUNCTIONID,
CONTACTADDRESSEEFORMATID,
ALTCONTACTADDRESSEEFORMATID,
CONTACTADDRESSEEFUNCTIONID,
ORGSALUTATIONCODE,
CONTACTSALUTATIONFORMATID,
ALTCONTACTSALUTATIONFORMATID,
CONTACTSALUTATIONFUNCTIONID,
CONTACTSALUTATIONOPTIONCODE,
CUSTOMNAME,
USEADDRESSEEFORMAT,
USESALUTATIONFORMAT,
USECONTACTADDRESSEEFORMAT,
USECONTACTSALUTATIONFORMAT,
ADDEDBYID,
CHANGEDBYID,
DATEADDED,
DATECHANGED)
values
( @NAMEFORMATID,
@ID,
@ADDRESSEEFORMATID,
@ALTADDRESSEEFORMATID,
@ADDRESSEEFUNCTIONID,
@SALUTATIONFORMATID,
@ALTSALUTATIONFORMATID,
@SALUTATIONFUNCTIONID,
@CONTACTADDRESSEEFORMATID,
@ALTCONTACTADDRESSEEFORMATID,
@CONTACTADDRESSEEFUNCTIONID,
@ORGSALUTATIONCODE,
@CONTACTSALUTATIONFORMATID,
@ALTCONTACTSALUTATIONFORMATID,
@CONTACTSALUTATIONFUNCTIONID,
@CONTACTSALUTATIONOPTIONCODE,
@CUSTOMNAME,
@USEADDRESSEEFORMAT,
@USESALUTATIONFORMAT,
@USECONTACTADDRESSEEFORMAT,
@USECONTACTSALUTATIONFORMAT,
@CHANGEAGENTID,
@CHANGEAGENTID,
@CURRENTDATE,
@CURRENTDATE);
end
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch
return 0;