TRIGGER: APPS.XTR_AI_CURRENCY_CROSS_RATES_T

Source

Description

"APPS"."XTR_AI_CURRENCY_CROSS_RATES_T" 
 AFTER INSERT
 ON  "XTR"."XTR_CURRENCY_CROSS_RATES#"   FOR EACH ROW
 --
 

Type

AFTER EACH ROW

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

begin
   update XTR_BUY_SELL_COMBINATIONS
     set LATEST_CROSS_RATE = ((:NEW.BID_RATE + :NEW.OFFER_RATE) / 2),
         LATEST_CROSS_DATE = SYSDATE
     where CURRENCY_FIRST = :NEW.CURRENCY_FIRST
     and CURRENCY_SECOND = :NEW.CURRENCY_SECOND;
 end;