USP_MICROSITE_PROGRAMMING_ONLINE_ENABLE

Parameters

Parameter Parameter Type Mode Description
@ID uniqueidentifier IN
@CHANGEAGENTID uniqueidentifier IN

Definition

Copy


                    create procedure dbo.USP_MICROSITE_PROGRAMMING_ONLINE_ENABLE
                    (
                        @ID uniqueidentifier,
                        @CHANGEAGENTID uniqueidentifier
                    )
                    as begin
                        if exists(select 1 from dbo.[EVENT] where [ID] = @ID)
                            exec dbo.USP_EVENTSALESMETHOD_ONLINE_ENABLE @ID, @CHANGEAGENTID
                        else if exists(select 1 from dbo.[PROGRAM] where [ID] = @ID and [ISDAILYADMISSION] = 1)
                            exec dbo.USP_PROGRAMSALESMETHOD_ONLINE_ENABLE @ID, @CHANGEAGENTID
                    end