Trigger to modify the time-stamp on the need by date

Hi ,

The time-stamp on the need by date on the requisition generated from KANBAN is 23:59:59. This is an intended design of Oracle but this is causing an issue with lead time tolerance.

Hence i would like to go for a trigger that would over-write the time-stamp to 00:00:01 when the record gets inserted into po_requisitions_interface_all.

I did try my logic as below but then the trigger is not to be seen fired and see a flaw  here. Please help to resolve this.

CREATE OR REPLACE TRIGGER xx_xx_xx_trg

BEFORE INSERT    

ON PO_REQUISITIONS_INTERFACE_ALL

FOR EACH ROW