trigger is creating two rows with new and old value

Hi All,

I am trying to create a trigger on AP_SUPPLIERS table as well in AP_SUPPLIER_SITES_ALL table.

My intention is if any change in VENDOR name then it should fire and store into my staging table.

I have done with the code but the issue is every time its inserting two rows in my staging table with old  and new vendor name.

My code is:

create or replace

TRIGGER XXSTAR_AP_VENDOR

AFTER INSERT OR UPDATE OF VENDOR_ID,VENDOR_NAME

ON AP_SUPPLIERS

FOR EACH ROW

BEGIN

INSERT INTO XXSTAR_AP_VENDOR_TAB  (VENDOR_NUMBER,VENDOR_NAME)