DBA Data[Home] [Help]

APPS.AP_ACCTG_DATA_FIX_PKG dependencies on UTL_TCP

Line 6441: utl_smtp.write_data(v_smtp_connection,'Date: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || utl_tcp.crlf);

6437: utl_smtp.open_data (v_smtp_connection);
6438:
6439:
6440: --writing headers of the message
6441: utl_smtp.write_data(v_smtp_connection,'Date: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || utl_tcp.crlf);
6442: utl_smtp.write_data(v_smtp_connection,'From: ' || v_sender || utl_tcp.crlf);
6443: utl_smtp.write_data(v_smtp_connection,'Subject: '|| v_subject || utl_tcp.crlf);
6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);
6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);

Line 6442: utl_smtp.write_data(v_smtp_connection,'From: ' || v_sender || utl_tcp.crlf);

6438:
6439:
6440: --writing headers of the message
6441: utl_smtp.write_data(v_smtp_connection,'Date: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || utl_tcp.crlf);
6442: utl_smtp.write_data(v_smtp_connection,'From: ' || v_sender || utl_tcp.crlf);
6443: utl_smtp.write_data(v_smtp_connection,'Subject: '|| v_subject || utl_tcp.crlf);
6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);
6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);
6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type

Line 6443: utl_smtp.write_data(v_smtp_connection,'Subject: '|| v_subject || utl_tcp.crlf);

6439:
6440: --writing headers of the message
6441: utl_smtp.write_data(v_smtp_connection,'Date: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || utl_tcp.crlf);
6442: utl_smtp.write_data(v_smtp_connection,'From: ' || v_sender || utl_tcp.crlf);
6443: utl_smtp.write_data(v_smtp_connection,'Subject: '|| v_subject || utl_tcp.crlf);
6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);
6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);
6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type
6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);

Line 6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);

6440: --writing headers of the message
6441: utl_smtp.write_data(v_smtp_connection,'Date: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || utl_tcp.crlf);
6442: utl_smtp.write_data(v_smtp_connection,'From: ' || v_sender || utl_tcp.crlf);
6443: utl_smtp.write_data(v_smtp_connection,'Subject: '|| v_subject || utl_tcp.crlf);
6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);
6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);
6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type
6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);
6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);

Line 6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);

6441: utl_smtp.write_data(v_smtp_connection,'Date: ' || to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') || utl_tcp.crlf);
6442: utl_smtp.write_data(v_smtp_connection,'From: ' || v_sender || utl_tcp.crlf);
6443: utl_smtp.write_data(v_smtp_connection,'Subject: '|| v_subject || utl_tcp.crlf);
6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);
6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);
6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type
6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);
6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);
6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);

Line 6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type

6442: utl_smtp.write_data(v_smtp_connection,'From: ' || v_sender || utl_tcp.crlf);
6443: utl_smtp.write_data(v_smtp_connection,'Subject: '|| v_subject || utl_tcp.crlf);
6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);
6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);
6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type
6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);
6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);
6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);

Line 6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);

6443: utl_smtp.write_data(v_smtp_connection,'Subject: '|| v_subject || utl_tcp.crlf);
6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);
6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);
6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type
6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);
6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);
6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);
6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);

Line 6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);

6444: utl_smtp.write_data(v_smtp_connection,'To: ' || v_recipient || utl_tcp.crlf);
6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);
6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type
6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);
6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);
6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);
6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);
6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);

Line 6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);

6445: utl_smtp.write_data(v_smtp_connection,'Cc: ' || v_cc || utl_tcp.crlf);
6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type
6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);
6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);
6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);
6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);
6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);

Line 6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);

6446: utl_smtp.write_data(v_smtp_connection,'MIME-Version: 1.0'|| utl_tcp.crlf); --adding MIME type
6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);
6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);
6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);
6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);
6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);

Line 6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);

6447: utl_smtp.write_data(v_smtp_connection,'Content-Type: multipart/mixed;' || utl_tcp.crlf);
6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);
6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);
6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);
6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);
6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);

Line 6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);

6448: utl_smtp.write_data(v_smtp_connection,' boundary="-----SECBOUND"'|| utl_tcp.crlf);
6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);
6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);
6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);
6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);
6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);

Line 6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);

6449: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);
6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);
6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);
6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);
6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);
6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text

Line 6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);

6450: utl_smtp.write_data(v_smtp_connection, '-------SECBOUND'|| utl_tcp.crlf);
6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);
6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);
6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);
6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);
6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text
6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);

Line 6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);

6451: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;'|| utl_tcp.crlf);
6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);
6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);
6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);
6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text
6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6459: utl_smtp.write_data(v_smtp_connection,'Content-Disposition: attachment;'|| utl_tcp.crlf);

Line 6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);

6452: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);
6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);
6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);
6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text
6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6459: utl_smtp.write_data(v_smtp_connection,'Content-Disposition: attachment;'|| utl_tcp.crlf);
6460: utl_smtp.write_data(v_smtp_connection,' filename="log.html"'|| utl_tcp.crlf);

Line 6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text

6453: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);
6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);
6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);
6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text
6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6459: utl_smtp.write_data(v_smtp_connection,'Content-Disposition: attachment;'|| utl_tcp.crlf);
6460: utl_smtp.write_data(v_smtp_connection,' filename="log.html"'|| utl_tcp.crlf);
6461: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);

Line 6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);

6454: utl_smtp.write_data(v_smtp_connection,v_body || utl_tcp.crlf);
6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);
6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);
6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text
6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6459: utl_smtp.write_data(v_smtp_connection,'Content-Disposition: attachment;'|| utl_tcp.crlf);
6460: utl_smtp.write_data(v_smtp_connection,' filename="log.html"'|| utl_tcp.crlf);
6461: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6462:

Line 6459: utl_smtp.write_data(v_smtp_connection,'Content-Disposition: attachment;'|| utl_tcp.crlf);

6455: utl_smtp.write_data(v_smtp_connection,'-------SECBOUND'|| utl_tcp.crlf);
6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);
6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text
6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6459: utl_smtp.write_data(v_smtp_connection,'Content-Disposition: attachment;'|| utl_tcp.crlf);
6460: utl_smtp.write_data(v_smtp_connection,' filename="log.html"'|| utl_tcp.crlf);
6461: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6462:
6463: -- writing data from clob

Line 6460: utl_smtp.write_data(v_smtp_connection,' filename="log.html"'|| utl_tcp.crlf);

6456: utl_smtp.write_data(v_smtp_connection,'Content-Type: text/html;' || utl_tcp.crlf);
6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text
6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6459: utl_smtp.write_data(v_smtp_connection,'Content-Disposition: attachment;'|| utl_tcp.crlf);
6460: utl_smtp.write_data(v_smtp_connection,' filename="log.html"'|| utl_tcp.crlf);
6461: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6462:
6463: -- writing data from clob
6464: BEGIN

Line 6461: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);

6457: utl_smtp.write_data(v_smtp_connection,' name="log.html"'|| utl_tcp.crlf); -- file name that will hold the attached text
6458: utl_smtp.write_data(v_smtp_connection,'Content-Transfer_Encoding: 8bit'|| utl_tcp.crlf);
6459: utl_smtp.write_data(v_smtp_connection,'Content-Disposition: attachment;'|| utl_tcp.crlf);
6460: utl_smtp.write_data(v_smtp_connection,' filename="log.html"'|| utl_tcp.crlf);
6461: utl_smtp.write_data(v_smtp_connection,utl_tcp.crlf);
6462:
6463: -- writing data from clob
6464: BEGIN
6465: v_offset := 1;

Line 6474: vNewLine := utl_tcp.crlf ||utl_tcp.crlf ||'-------SECBOUND--';

6470: dbms_lob.substr(v_attachment,v_amount,v_offset));
6471: v_offset := v_offset + v_amount ;
6472: v_amount := least(1900,dbms_lob.getlength(v_attachment) - v_amount);
6473: END LOOP;
6474: vNewLine := utl_tcp.crlf ||utl_tcp.crlf ||'-------SECBOUND--';
6475: utl_smtp.close_data(v_smtp_connection);
6476: utl_smtp.quit(v_smtp_connection);
6477: dbms_lob.freetemporary(v_attachment);
6478: END;