TRIGGER: APPS.XTR_AD_EXPOSURE_TRANSACTIONS_T

Source

Description

"APPS"."XTR_AD_EXPOSURE_TRANSACTIONS_T" 
	 AFTER DELETE
 ON  "XTR"."XTR_EXPOSURE_TRANSACTIONS#"  	 FOR EACH ROW

Type

AFTER EACH ROW

Event

DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

begin
   --Delete row from XTR_CONFIRMATION_DETAILS table

   if :OLD.SETTLE_ACTION_REQD = 'Y'
       and :OLD.PURCHASING_MODULE = 'N'
       and nvl(:OLD.CASH_POSITION_EXPOSURE,'N') = 'N' then

       delete from XTR_CONFIRMATION_DETAILS
       where deal_type = 'EXP'
       and transaction_no = :OLD.TRANSACTION_NUMBER;

   end if;
end;