Message Notification - with Attachment

Hi,

Working on a Custom Workflow having only one message only.

In a procedure are creating a file and saving under DIR_INVOICES db directory.

Now We need to add the file .csv as attachment to this Notification.

Following are the issues.

1. File Name

2. Attachment appearing as HTML document file name.

== Necessary Code Begins    ==

lc_file_name VARCHAR2(50) := 'eInvoices' || TO_CHAR(SYSDATE, 'RRRRMMDDHH24MISS') || '.csv' ;

PROCEDURE send_notificaiton ( p_conc_request_id IN NUMBER, p_file_name IN VARCHAR2 ) IS

ln_notification_id    NUMBER ;

lc_sender VARCHAR2(25) ;

lc_recipient VARCHAR2(50) ;

lc_username VARCHAR2(50) := NVL(FND_GLOBAL.USER_NAME, 'PKUMAR') ;