USP_GLACCOUNTCODE_DELETE
Executes the "Account Code: Delete" 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_GLACCOUNTCODE_DELETE
(
@ID uniqueidentifier,
@CHANGEAGENTID uniqueidentifier
)
as begin
--revisit is the record in use on an account?
begin transaction
-- use the system generated delete routine to allow proper recording of the deleting agent
exec USP_ACCOUNTCODE_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
-- Now delete the row from the accounting element table
exec dbo.USP_PDACCOUNTSEGMENTVALUE_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID
commit transaction
return 0;
end