ALTER TRIGGER "TR_U_XO_DET_period" BEFORE INSERT, DELETE, UPDATE
ORDER  1  ON "ADS"."U_XO_DET"
REFERENCING 

OLD AS old_tab
NEW AS new_tab

FOR EACH ROW /* WHEN( search_condition ) */
BEGIN

DECLARE @date_n date;
DECLARE @date_o date;

IF INSERTING THEN
    SET @date_n = (SELECT date_xo FROM U_XO a WHERE a.id_xo = new_tab.id_xo);
    SET @date_o = (SELECT date_xo FROM U_XO a WHERE a.id_xo = new_tab.id_xo);
ELSEIF UPDATING THEN
    SET @date_n = (SELECT date_xo FROM U_XO a WHERE a.id_xo = new_tab.id_xo);
    SET @date_o = (SELECT date_xo FROM U_XO a WHERE a.id_xo = old_tab.id_xo);
ELSEIF DELETING THEN
    SET @date_n = (SELECT date_xo FROM U_XO a WHERE a.id_xo = old_tab.id_xo);
    SET @date_o = (SELECT date_xo FROM U_XO a WHERE a.id_xo = old_tab.id_xo);
END IF;


IF EXISTS(
    SELECT *
    FROM SP_PRD
    WHERE ((@date_n BETWEEN N_PRD AND K_PRD) or (@date_o BETWEEN N_PRD AND K_PRD)) AND Status =  1  /*AND CURRENT USER <> 'ADS'*/ )
OR (SELECT Count(id_prd) FROM SP_PRD WHERE @date_n BETWEEN N_PRD AND K_PRD) <  1 
OR (SELECT Count(id_prd) FROM SP_PRD WHERE @date_o BETWEEN N_PRD AND K_PRD) <  1 
//OR (SELECT Count(id_prd) FROM SP_PRD WHERE ((@date_n BETWEEN N_PRD AND K_PRD) or (@date_o BETWEEN N_PRD AND K_PRD)) ) < 1
THEN
    RAISERROR  20000  'На изменение, добавление, удаление записи в закрытом периоде у Вас нет прав, обратитесь к Администратору...->'||@date_o||'<-3333';
    RETURN;
END IF;

END

OR (SELECT Count(id_prd) FROM SP_PRD WHERE @date_n BETWEEN N_PRD AND K_PRD) <  1 
OR (SELECT Count(id_prd) FROM SP_PRD WHERE @date_o BETWEEN N_PRD AND K_PRD) <  1