APPS.AP_ACCTG_DATA_FIX_PKG dependencies on DBMS_LOB

Line 6467: WHILE v_offset < dbms_lob.getlength(v_attachment)

6463: -- writing data from clob
6464: BEGIN
6465: v_offset := 1;
6466: v_amount := 1900;
6467: WHILE v_offset < dbms_lob.getlength(v_attachment)
6468: LOOP
6469: utl_smtp.write_data(v_smtp_connection,
6470: dbms_lob.substr(v_attachment,v_amount,v_offset));
6471: v_offset := v_offset + v_amount ;

Line 6470: dbms_lob.substr(v_attachment,v_amount,v_offset));

6466: v_amount := 1900;
6467: WHILE v_offset < dbms_lob.getlength(v_attachment)
6468: LOOP
6469: utl_smtp.write_data(v_smtp_connection,
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--';

Line 6472: v_amount := least(1900,dbms_lob.getlength(v_attachment) - v_amount);

6468: LOOP
6469: utl_smtp.write_data(v_smtp_connection,
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);

Line 6477: dbms_lob.freetemporary(v_attachment);

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;
6479: RETURN TRUE;
6480:
6481: EXCEPTION