USP_DATAFORMTEMPLATE_EDIT_DONORCONSTITUENCYCRITERIA_EDIT_2
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @CHANGEAGENTID | uniqueidentifier | IN | |
| @MAJORDONORCONSTITUENCYDEFCONSIDERRECOGNITION | bit | IN |
Definition
Copy
CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDIT_DONORCONSTITUENCYCRITERIA_EDIT_2
(
@CHANGEAGENTID uniqueidentifier,
@MAJORDONORCONSTITUENCYDEFCONSIDERRECOGNITION bit
)
as
set nocount on;
declare @CURRENTDATE datetime;
set @CURRENTDATE = dbo.UFN_DATE_GETEARLIESTTIME(getdate());
update dbo.CONSTITUENCYCRITERIASPOUSE set
MAJORDONORCONSTITUENCYDEFCONSIDERRECOGNITION = @MAJORDONORCONSTITUENCYDEFCONSIDERRECOGNITION,
DATECHANGED = @CURRENTDATE,
CHANGEDBYID = @CHANGEAGENTID