How to create a trigger on customer header price list update?

Hi,

I am trying to create a database trigger on Customer Header Price list update. Its like below :

CREATE OR REPLACE TRIGGER TRIGGER_PRICE_LIST_UPDATE

   AFTER UPDATE OF PRICE_LIST_ID

   ON HZ_CUST_ACCOUNTS

   FOR EACH ROW

 

DECLARE

   V_USERID              VARCHAR2 (10);

   V_UPDATE_DATE         DATE;

   V_CUST_ACCOUNT_ID     NUMBER;

   V_ACCT_NUM            VARCHAR2 (30 BYTE);

   V_PARTY_ID            NUMBER;

   OLD_PRICE_LIST_NAME   VARCHAR2 (240 BYTE);

   NEW_PRICE_LIST_NAME   VARCHAR2 (240 BYTE);

 

BEGIN

   IF UPDATING ('PRICE_LIST_ID')

   THEN

      V_USERID := :new.LAST_UPDATED_BY;

      V_UPDATE_DATE := :new.LAST_UPDATE_DATE;

      V_CUST_ACCOUNT_ID := :old.CUST_ACCOUNT_ID;