TRIGGER: APPS.XTR_AD_EXPOSURE_TRANSACTIONS_T

Source

Description

XTR_AD_EXPOSURE_TRANSACTIONS_T
	 AFTER DELETE on 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;