USP_CURRENCY_MARKINACTIVE
Executes the "Currency: Mark Inactive" 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. |
Definition
Copy
CREATE procedure dbo.USP_CURRENCY_MARKINACTIVE
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier
)
as
set nocount on
declare @CURRENTDATE datetime
set @CURRENTDATE = getdate()
if exists (
select
CURRENCYSET.ID
from
dbo.CURRENCYSET
where
CURRENCYSET.BASECURRENCYID = @ID
)
raiserror('ERR_CURRENCYDELETE_CURRENCYISBASECURRENCYINSET', 13, 1);
if exists (
select
CURRENCYSETTRANSACTIONCURRENCY.ID
from
dbo.CURRENCYSETTRANSACTIONCURRENCY
where
CURRENCYSETTRANSACTIONCURRENCY.CURRENCYID = @ID
)
raiserror('ERR_CURRENCYDELETE_CURRENCYISTRANSACTIONCURRENCYINSET', 13, 1);
begin try
update dbo.CURRENCY set
INACTIVE = 1,
DATECHANGED = @CURRENTDATE,
CHANGEDBYID = @CHANGEAGENTID
where ID = @ID
end try
begin catch
exec dbo.USP_RAISE_ERROR
return 1
end catch