1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74
|
PROCEDURE mail_bl(v_bl IN VARCHAR2
, v_dest IN VARCHAR2) IS
conn utl_smtp.connection;
req utl_http.req;
resp utl_http.resp;
DATA RAW(200);
v_html_head LONG; /* HEADER HTML */
v_html_style LONG; /* DEFINI LA FEUILLE DE STYLE HTLM */
v_html_body LONG; /* BODY HTML */
v_data LONG; /* COPRS DE LA PIECE JOINTE */
v_corps LONG; /* CORPS DU MESSAGE */
BEGIN
v_html_head := TEIS_MAIL_PKG.html_header(v_bl);
v_html_body := TEIS_MAIL_PKG.html_body(v_bl); -- LE NUMERO DE BL PERMETTRA LA CREATION DU CORPS DU FICHIER AVEC LES INFORMATIONS LIEES AU BL
v_data := v_html_head || v_html_body;
v_data1 := v_html_head || v_html_body;
v_corps := '___________________ <br />
Societe<br />
Fin de préparation <br />
___________________ <br />
<br /><br />
+ Ci-joint le Bon de Livraison N° ' || v_bl || ' <br />
|____________________________________________________________ <br />
<br /><br />';
/* ----------------------------------------------------------------
INFOS MAIL
------------------------------------------------------------------- */
conn := TEIS_MAIL_PKG.begin_mail(
sender => 'BL_MAC <TSC_BLMAC@ma_societe.com>',
recipients => 'TSC_BLMAC@ma_societe.com',
subject => v_dest,
mime_type => TEIS_MAIL_PKG.MULTIPART_MIME_TYPE);
/* ----------------------------------------------------------------
CORPS DU MESSAGE
------------------------------------------------------------------- */
TEIS_MAIL_PKG.attach_text(
conn => conn,
DATA => v_corps,
mime_type => 'text/html');
/* ----------------------------------------------------------------
PIECES JOINTE
------------------------------------------------------------------- */
TEIS_MAIL_PKG.attach_text(
conn => conn,
DATA => v_data,
mime_type => 'text/html',
inline => FALSE,
filename => 'BL_' || v_bl ||'.html',
last => FALSE);
TEIS_MAIL_PKG.attach_text(
conn => conn,
DATA => v_data,
mime_type => 'text/html',
inline => FALSE,
filename => 'BL_' || v_bl ||'.doc',
last => TRUE);
TEIS_MAIL_PKG.end_mail( conn => conn );
END; |
Partager