how to reset an expiration date =o in oracle 8i form?

I am developing a form in oracle 11.1.0 form

there is a reset button in trigger with the following code


The problem is

if it shows with  expiration 13-NOV-2008. That's today! Then I wanted to check the reset
reason field, so I reset it again. The new expiration date shows as
12-JAN-2009. I tried it again, and got 11-FEB-2009.

Everytime I reset the download, it upped the expiration date to be
30 days + the current expiration_date.  This is  fault, it should
actually be set to 30 days from the current date.

update xx_downloads
	   set 
	       expiration_date = nvl(expiration_date,sysdate) + 30,
	       download_attempts = 0,
	       last_updated_by = v_user_id,
	       last_update_date = sysdate
   	 where download_id = :XX_DOWNLOADS_V.download_id;

Select allOpen in new window