CREATE OR REPLACE TRIGGER F4211_IN
AFTER                                              
 INSERT OR UPDATE OR DELETE ON F4211
FOR EACH ROW                                
---------------------------------------------------------------------------------------------------------------------------------------------------------------    
DECLARE
    V_COUNT NUMBER := 0;
BEGIN
  ---------------------------------------------------------------------------------------------------------------------------------------------------------------    
    IF :NEW.SDLTTR = 541 THEN -- SDLTTR 값이 541인 경우에만 동작
  ---------------------------------------------------------------------------------------------------------------------------------------------------------------    

   IF INSERTING THEN                            

         SELECT Count(*) INTO V_COUNT 
         FROM F500002                                     
         WHERE 1=1
                AND B1KCOO      =:NEW.SDKCOO            
                AND B1DOCO    =:NEW.SDDOCO
                AND B1DCTO    =:NEW.SDDCTO
                AND B1LNID    =:NEW.SDLNID;
                  
      IF V_COUNT = 0       THEN          
        INSERT INTO F500002 (
    B1KCOO,
    B1DOCO,
    B1DCTO,
    B1LNID,
    B1AN8
)
    VALUES (
    :NEW.SDKCOO,
    :NEW.SDDOCO,
    :NEW.SDDCTO,
    :NEW.SDLNID,
    :NEW.SDAN8
);
    END IF; 
    
---------------------------------------------------------------------------------------------------------------------------------------------------------------    

   ELSIF UPDATING THEN
  SELECT Count(*) INTO V_COUNT 
  FROM F500002
  WHERE 1=1
        AND B1KCOO = :OLD.SDKCOO -- 기존에 있던 오더
        AND B1DOCO = :OLD.SDDOCO
        AND B1DCTO = :OLD.SDDCTO
        AND B1LNID = :OLD.SDLNID;
  
  IF V_COUNT <> 0 THEN 
    UPDATE F500002
    SET
      B1KCOO = :NEW.SDKCOO,
      B1DOCO = :NEW.SDDOCO,
      B1DCTO = :NEW.SDDCTO,
      B1LNID = :NEW.SDLNID,
      B1AN8 = :NEW.SDAN8,

    WHERE 1=1
      AND B1KCOO = :OLD.SDKCOO 
      AND B1DOCO = :OLD.SDDOCO
      AND B1DCTO = :OLD.SDDCTO
      AND B1LNID = :OLD.SDLNID;
  END IF; 
END IF;
END IF;

END;