USP_DATAFORMTEMPLATE_ADD_MKTACKNOWLEDGEMENTMAILINGTEMPLATEASKLADDEROVERRIDE

The save procedure used by the add dataform template "Marketing Acknowledgement Template Ask Ladder Override 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.
@ACKNOWLEDGEMENTMAILINGTEMPLATEID	uniqueidentifier	IN	Input parameter indicating the context ID for the record being added.
@IDSETREGISTERID	uniqueidentifier	IN	Selection
@ASKLADDERID	uniqueidentifier	IN	Ask ladder

Definition

Copy



CREATE procedure dbo.[USP_DATAFORMTEMPLATE_ADD_MKTACKNOWLEDGEMENTMAILINGTEMPLATEASKLADDEROVERRIDE]
(
  @ID uniqueidentifier = null output,
  @CHANGEAGENTID uniqueidentifier = null,    
  @ACKNOWLEDGEMENTMAILINGTEMPLATEID uniqueidentifier,
  @IDSETREGISTERID uniqueidentifier,
  @ASKLADDERID uniqueidentifier
)
as

set nocount on;

declare @CURRENTDATE datetime;
declare @SEQUENCE int;

begin try
  if @ID is null
    set @ID = NewID();

  if @CHANGEAGENTID is null  
    exec dbo.[USP_CHANGEAGENT_GETORCREATECHANGEAGENT] @CHANGEAGENTID output;

  set @CURRENTDATE = getdate();

  select @SEQUENCE = isnull(max([SEQUENCE]), 0) + 1
  from dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATEASKLADDEROVERRIDE]
  where [ACKNOWLEDGEMENTMAILINGTEMPLATEID] = @ACKNOWLEDGEMENTMAILINGTEMPLATEID;

  insert into dbo.[MKTACKNOWLEDGEMENTMAILINGTEMPLATEASKLADDEROVERRIDE] (
    [ID],
    [ACKNOWLEDGEMENTMAILINGTEMPLATEID],
    [IDSETREGISTERID],
    [ASKLADDERID],
    [SEQUENCE],
    [ADDEDBYID],
    [CHANGEDBYID],
    [DATEADDED],
    [DATECHANGED]
  ) values (
    @ID,
    @ACKNOWLEDGEMENTMAILINGTEMPLATEID,
    @IDSETREGISTERID,
    @ASKLADDERID,
    @SEQUENCE,
    @CHANGEAGENTID,
    @CHANGEAGENTID,
    @CURRENTDATE,
    @CURRENTDATE
  );
end try

begin catch
  exec dbo.[USP_RAISE_ERROR];
  return 1;
end catch

return 0;