-- =============================================
-- Author:      Vitacore   Anatoliy
-- Create date: 2023-08-09
-- Description: Удаление данных Документ инвентаризации МДЛП
-- =============================================
DROP PROCEDURE IF EXISTS stor.sp_DeleteMdlpInventoryDocumentProcess;

CREATE PROCEDURE stor.sp_DeleteMdlpInventoryDocumentProcess
(
	"id" uuid
)
    language plpgsql
as
$$
Begin 
	delete from STOR.T_MDLP_INVENTORY_ELEMENTS where MdlpInventoryDocument = "Id";
	delete from STOR.T_MDLP_INVENTORY_DOCUMENT where MdlpInventoryDocumentID = "Id";
End;
$$;