v_mail=:control.test;
mail_pkg.send
        ( p_sender_email => 'test@test.com',
          p_from => 'test@test.com',
          p_to => mail_pkg.array(V_MAIL),
          p_cc => mail_pkg.array('test@test.com'),
          p_bcc => mail_pkg.array( 'test@test.com'),
          p_subject => 'test',
          p_body =>('Dear Recipient,'
          					||chr(13)||
          					' New Doc received, you can open it through clicking on below link:'
          					 ||chr(13)||
          					          					 ||chr(13)||
          					 'Document information as follow:'
          					 ||chr(13)||
          					 'Doc#:'||MISS
          					 ||chr(13)||
          					 'File Type:'||:filetype
          					 ||chr(13)||
          					 'File Ref:'||:fileref
          					 ||chr(13)||
          					 'Subject:'||:subject
          					 ||chr(13)||
          					 'Company:'||:company
          					 ||chr(13)||
          					 'From:'||:fromwhom
          					 ||chr(13)||
          					 chr(13)||
          					 
          					 'This is a notifiaction email sent from system, plese Do-Not-Reply.'
          ||chr(13)||
          chr(13)||
          'Regards,,,'));
       
  end;