Database Software

Hi,

I have a requirement where i need to attach a flat file generated with the notification.

My scenario is to send a notification to the user with a flat file. For this i have created a package which creates a flat file and stores it in specified directory.

I need to find out how i can dynamically identify the notification id of the run time notification, which can be then passed on to the attachment code to attach the files which has been generated. Is there any other possible way to attach the files, as i store both the file name and directory in a local variable which can be referenced for attaching the file.

So can you please let me know how this situation can be handled. I am new to workflow and appreciate your help in this.