USP_DATAFORMTEMPLATE_EDIT_PRINTMEMBERSHIPCARDSPREPROCESS_2

USP_DATAFORMTEMPLATE_EDIT_PRINTMEMBERSHIPCARDSPREPROCESS_2

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.
@MEMBERSHIPCARDFORMAT nvarchar(255) IN Card format to use
@CREATEOUTPUTIDSET bit IN Create constituent selection from results
@OUTPUTIDSETNAME nvarchar(100) IN Selection name
@OVERWRITEOUTPUTIDSET bit IN Overwrite existing selection
@LETTERTEMPLATEID uniqueidentifier IN Letter template to use

Definition

Copy


CREATE procedure USP_DATAFORMTEMPLATE_EDIT_PRINTMEMBERSHIPCARDSPREPROCESS_2
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @MEMBERSHIPCARDFORMAT nvarchar(255),
    @CREATEOUTPUTIDSET bit,
    @OUTPUTIDSETNAME nvarchar(100),
    @OVERWRITEOUTPUTIDSET bit,
    @LETTERTEMPLATEID uniqueidentifier
)

as
  set nocount on;

    declare @REPORTCATALOGID uniqueidentifier;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PRINTMEMBERSHIPCARDSPREPROCESS
        @ID = @ID,
        @REPORTCATALOGID = @REPORTCATALOGID output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_PRINTMEMBERSHIPCARDSPREPROCESS_3
        @ID,
        @CHANGEAGENTID,
        @MEMBERSHIPCARDFORMAT,
        @CREATEOUTPUTIDSET,
        @OUTPUTIDSETNAME,
        @OVERWRITEOUTPUTIDSET,
        @LETTERTEMPLATEID,
        @REPORTCATALOGID

  return 0;