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;