USP_UPDATEALL_SITEPAGE_BBPAYTEMPLATEVERSION
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BBPAYTEMPLATEVERSION | smallint | IN | |
| @ENVIRONMENTID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_UPDATEALL_SITEPAGE_BBPAYTEMPLATEVERSION
(
@BBPAYTEMPLATEVERSION smallint,
@ENVIRONMENTID uniqueidentifier
)
as
begin
declare @CHANGEAGENTID uniqueidentifier;
exec dbo.USP_CHANGEAGENT_GETORCREATECHANGEAGENT @CHANGEAGENTID output;
declare @CURRENTDATE datetime;
set @CURRENTDATE = getdate();
update dbo.CMSSITEPAGEBBPAYTEMPLATEVERSION set BBPAYTEMPLATEVERSION = @BBPAYTEMPLATEVERSION, DATECHANGED = @CURRENTDATE, CHANGEDBYID = @CHANGEAGENTID
where EnvironmentId = @ENVIRONMENTID;
end