Subversion Repositories DevTools

CREATE OR REPLACE TRIGGER TSB.NOTFORDISPLAY

AFTER UPDATE

OF FIELDVALUE

ON TSB.TXNSPEC_VALUES

REFERENCING NEW AS NEW OLD AS OLD

DECLARE

tmpVar NUMBER;

BEGIN

   update txnspec_values

   set displayable = 'N'

   where fieldname in ('formatVersion','txnMac', 'keyVersion', 'applicationProviderId', 'applicationSerialNumber', 'udType', 'udSubtype', 

   'currencyIndicatorFinDetails','processedDate','cardIssuerId','productIssuerId','routeLineId','numberOfPassengers','applicationPassengerType','passEndDateTime')

   and  displayable = 'Y';

END NOTFORDISPLAY;

/

SHOW ERRORS;