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