I have a requirement for a Sales Quote that also has a Quote Expiration Date. (yes, it is ovbious that we should just make the field required so thay have to enter a date, but I am required to do it this way.) If the Expriration Date is Blank, take todays date and add 60 days to it and put it in the field. If the Expiration Date is not blank, do nothing. 

The example I was sent from IFS is the attached SalesQuoteExpirationDate.txt 

If you notice in the attachement, there is a ‘DECLARE which goes down a few lines and stops at END;’;

Then there is is code that does the exact same thing as above in a diffrent way, I was told we had to “fool” the system which is why it was done this way. During testing it was found that you have to save it twice and then refreash the screen. I think it is because of having to “fool” the system and this work around is not working. 

Sales does not like this. Is there a bettter way to do this through an Oracle Script? I dont mean easier, I know for a fact to make somthing  work the way a end user wants it, it requires work on the part of the developer.