hi
im designing a form to keep track offer status.
When i click browse button i have written code to get file from any location as given below code.
DECLARE
filename VARCHAR2(256);
BEGIN filename := GET_FILE_NAME(File_Filter=> 'DOC Files (*.doc)|*.doc|');
:AATE_OFFER.TEXT_ITEM37 := filename;
end;
lets say file taken is from **E:\\files\\vignesh.doc**
My requirement is after selecting file when i give save button it should save only in my D:\company\offerletter path, with file name as offer_101.doc (this offer_101 where 101 is my empu_code so it should automatically take that value from text item empu_code) is it possible ??
pls help me with code

Thanks
Vignesh