USP_RECORDOPERATION_PROGRAMREGISTRATIONINFORMATIONDELETE

CREATE procedure dbo.USP_RECORDOPERATION_PROGRAMREGISTRATIONINFORMATIONDELETE (
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier
) as begin
    set nocount on;

    declare @PROGRAMEVENTREGISTRATIONSECTIONID uniqueidentifier = (select PROGRAMEVENTREGISTRATIONSECTIONID from dbo.PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION where ID = @ID);

    -- use the system generated delete routine to allow proper recording of the deleting agent

    exec dbo.USP_PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION_DELETEBYID_WITHCHANGEAGENTID @ID, @CHANGEAGENTID;

    --clean up the section if no items refer to it...

    if not exists (select 1 from dbo.PROGRAMEVENTREGISTRATIONSECTIONREGISTRATIONINFORMATION where PROGRAMEVENTREGISTRATIONSECTIONID = @PROGRAMEVENTREGISTRATIONSECTIONID) begin
        exec dbo.USP_PROGRAMEVENTREGISTRATIONSECTION_DELETEBYID_WITHCHANGEAGENTID @PROGRAMEVENTREGISTRATIONSECTIONID, @CHANGEAGENTID;
    end

    return 0;
end