USP_PROGRAMSALESMETHOD_ONLINE_DISABLE
Executes the "Microsite Programming Program Offline" record operation.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ID | uniqueidentifier | IN | Input parameter indicating the ID of the record being deleted. |
| @CHANGEAGENTID | uniqueidentifier | IN | Input parameter indicating the ID of the change agent invoking the delete. |
Definition
Copy
CREATE procedure dbo.USP_PROGRAMSALESMETHOD_ONLINE_DISABLE
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier
)
as begin
--check deletion rules, if any
declare @ONLINESALESMETHOD uniqueidentifier = dbo.UFN_SALESMETHOD_GETIDFROMTYPECODE(2);--2 = online
declare @PSMID uniqueidentifier
select @PSMID = ID from PROGRAMSALESMETHOD where (PROGRAMID = @ID) and (SALESMETHODID = @ONLINESALESMETHOD)
-- use the system generated delete routine to allow proper recording of the deleting agent
exec USP_PROGRAMSALESMETHOD_DELETEBYID_WITHCHANGEAGENTID @PSMID, @CHANGEAGENTID
return 0;
end