USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTRECOGNITIONDEFAULTBYSOURCE
The save procedure used by the edit dataform template "Constituent Recognition Default By Source Edit Form".
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | The input ID parameter indicating the ID of the record being edited. |
| @MATCHFACTOR | decimal(5, 2) | IN | Match percent |
| @STARTDATE | datetime | IN | Start date |
| @ENDDATE | datetime | IN | End date |
| @REVENUERECOGNITIONTYPECODEID | uniqueidentifier | IN | Recognition credit type |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the procedure. |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_CONSTITUENTRECOGNITIONDEFAULTBYSOURCE
(
@ID uniqueidentifier,
@MATCHFACTOR decimal(5, 2),
@STARTDATE datetime,
@ENDDATE datetime,
@REVENUERECOGNITIONTYPECODEID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier = null
)
as
set nocount on
declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()
if @CHANGEAGENTID is null
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output
begin try
update dbo.REVENUERECOGNITIONDEFAULT set
MATCHFACTOR = @MATCHFACTOR,
STARTDATE = @STARTDATE,
ENDDATE = @ENDDATE,
REVENUERECOGNITIONTYPECODEID = @REVENUERECOGNITIONTYPECODEID,
PREVENTRECOGNITIONSDEFAULTING = 0,
DATECHANGED = @CURRENTDATE,
CHANGEDBYID = @CHANGEAGENTID
where ID = @ID
end try
begin catch
exec dbo.USP_RAISE_ERROR;
return 1;
end catch