USP_DATAFORMTEMPLATE_PROSPECTMANAGERREQUEST_EDITSAVE

USP_DATAFORMTEMPLATE_PROSPECTMANAGERREQUEST_EDITSAVE

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.
@CURRENTAPPUSERID uniqueidentifier IN Input parameter indicating the ID of the current user.
@PROSPECTMANAGERFUNDRAISERID uniqueidentifier IN Prospect manager

Definition

Copy


CREATE procedure USP_DATAFORMTEMPLATE_PROSPECTMANAGERREQUEST_EDITSAVE
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @CURRENTAPPUSERID uniqueidentifier = null,
    @PROSPECTMANAGERFUNDRAISERID uniqueidentifier
)

as
    set nocount on;

    declare @STARTDATE datetime;

    exec dbo.USP_DATAFORMTEMPLATE_PROSPECTMANAGERREQUEST_EDITLOAD
        @ID = @ID,
        @STARTDATE = @STARTDATE output

    exec dbo.USP_DATAFORMTEMPLATE_PROSPECTMANAGERREQUEST_EDITSAVE_2
        @ID,
        @CHANGEAGENTID,
        @CURRENTAPPUSERID,
        @PROSPECTMANAGERFUNDRAISERID,
        @STARTDATE

    return 0;