USP_SPONSORSHIPGREATESTNEEDRULESET_COPY
Executes the "Sponsorship Greatest Need Rule Set Copy Record Operation" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Input parameter indicating the ID of the record being updated. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the update. |
| @CURRENTAPPUSERID | uniqueidentifier | IN | Input parameter indicating the ID of the current user. |
Definition
Copy
create procedure dbo.USP_SPONSORSHIPGREATESTNEEDRULESET_COPY
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier,
@CURRENTAPPUSERID uniqueidentifier
)
as begin
insert into dbo.SPONSORSHIPGREATESTNEEDRULESET(ID,NAME,SPONSORSHIPOPPORTUNITYTYPECODE,RULESETDATA,ADDEDBYID,CHANGEDBYID)
select
newid(),
'Copy of ' + NAME,
SPONSORSHIPOPPORTUNITYTYPECODE,
RULESETDATA,
@CHANGEAGENTID,
@CHANGEAGENTID
from dbo.SPONSORSHIPGREATESTNEEDRULESET
where ID = @ID
return 0;
end