USP_MICROSITE_PROGRAMMING_ONLINE_DISABLE
Parameters
Parameter | Parameter Type | Mode | Description |
---|---|---|---|
@ID | uniqueidentifier | IN | |
@CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
create procedure dbo.USP_MICROSITE_PROGRAMMING_ONLINE_DISABLE
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier
)
as begin
if exists(select 1 from dbo.[EVENT] where [ID] = @ID)
exec dbo.USP_EVENTSALESMETHOD_ONLINE_DISABLE @ID, @CHANGEAGENTID
else if exists(select 1 from dbo.[PROGRAM] where [ID] = @ID and [ISDAILYADMISSION] = 1)
exec dbo.USP_PROGRAMSALESMETHOD_ONLINE_DISABLE @ID, @CHANGEAGENTID
end