TRIGGER: APPS.XTR_BU_CONFIRMATION_DETAILS_T

Source

Description

XTR_BU_CONFIRMATION_DETAILS_T
 BEFORE UPDATE on XTR_CONFIRMATION_DETAILS FOR EACH ROW
--

Type

BEFORE EACH ROW

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

begin
 if (nvl(:OLD.CONFIRMATION_VALIDATED_BY,'@@')
     <> nvl(:NEW.CONFIRMATION_VALIDATED_BY,'@@'))
  or (nvl(:OLD.CONFIRMATION_VALIDATED_ON,To_Date('01/01/1980','MM/DD/YYYY'))
     <> nvl(:NEW.CONFIRMATION_VALIDATED_ON,To_Date('01/01/1980','MM/DD/YYYY'))) then

  XTR_MISC_P.VALIDATE_DEALS(:NEW.DEAL_NO,
                 :NEW.TRANSACTION_NO,
                 :NEW.DEAL_TYPE,
                 :NEW.ACTION_TYPE,
                 :NEW.CONFIRMATION_VALIDATED_BY);
 end if;
end;