USP_DATAFORMTEMPLATE_EDIT_PLEDGEWRITEOFFPROCESS_3

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@CHANGEAGENTID	uniqueidentifier	IN
@NAME	nvarchar(100)	IN
@DESCRIPTION	nvarchar(255)	IN
@IDSETREGISTERID	uniqueidentifier	IN
@REASON	nvarchar(300)	IN
@POSTSTATUSCODE	tinyint	IN
@POSTDATE	datetime	IN
@CREATEOUTPUTIDSET	bit	IN
@OUTPUTIDSETNAME	nvarchar(100)	IN
@OVERWRITEOUTPUTIDSET	bit	IN
@REASONCODEID	uniqueidentifier	IN
@CURRENTAPPUSERID	uniqueidentifier	IN
@SITEID	uniqueidentifier	IN

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_PLEDGEWRITEOFFPROCESS_3
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @NAME nvarchar(100),
    @DESCRIPTION nvarchar(255),
    @IDSETREGISTERID uniqueidentifier,
    @REASON nvarchar(300),
    @POSTSTATUSCODE tinyint,
    @POSTDATE datetime,
    @CREATEOUTPUTIDSET bit,
    @OUTPUTIDSETNAME nvarchar(100),
    @OVERWRITEOUTPUTIDSET bit,
    @REASONCODEID uniqueidentifier,
    @CURRENTAPPUSERID uniqueidentifier,
    @SITEID uniqueidentifier
)

as
  set nocount on;

    declare @RECOGNITIONCREDITADJUSTMENTCODE tinyint;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_PLEDGEWRITEOFFPROCESS_2
        @ID = @ID,
        @RECOGNITIONCREDITADJUSTMENTCODE = @RECOGNITIONCREDITADJUSTMENTCODE output;

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_PLEDGEWRITEOFFPROCESS_4
        @ID,
        @CHANGEAGENTID,
        @NAME,
        @DESCRIPTION,
        @IDSETREGISTERID,
        @REASON,
        @POSTSTATUSCODE,
        @POSTDATE,
        @CREATEOUTPUTIDSET,
        @OUTPUTIDSETNAME,
        @OVERWRITEOUTPUTIDSET,
        @REASONCODEID,
        @CURRENTAPPUSERID,
        @SITEID,
        @RECOGNITIONCREDITADJUSTMENTCODE;

  return 0;