TRIGGER rtsrv_cus_sgn_before

CREATE OR REPLACE TRIGGER rtsrv_cus_sgn_before
BEFORE INSERT OR DELETE
ON rtsrv_cus_sgn
FOR EACH ROW
BEGIN
IF INSERTING
THEN
INSERT INTO rtsrv_cus_sgn_trg
(rcs_wbl_num, rcs_dlv_eno, rcs_cfm_cnd,
rcs_sgn_ymd, rcs_crt_seq, rcs_crt_dtm
)
VALUES (:NEW.rcs_wbl_num, :NEW.rcs_dlv_eno, :NEW.rcs_cfm_cnd,
:NEW.rcs_sgn_ymd, rcs_crt_seq.NEXTVAL, SYSDATE
);
END IF;

IF DELETING
THEN
UPDATE rtsrv_cus_sgn_trg
SET rcs_del_dtm = SYSDATE,
rcs_del_seq = rcs_del_seq.NEXTVAL
WHERE rcs_wbl_num = :OLD.rcs_wbl_num;
END IF;
END;