APPS.WF_MAIL_UTIL dependencies on DBMS_LOB

Line 26: amount := dbms_lob.getLength(pIDoc);

22: chunkcount binary_integer := 0;
23: cBuffer varchar2(32000);
24: begin
25: chunksize := 12288;
26: amount := dbms_lob.getLength(pIDoc);
27: if(chunksize < amount) then
28: chunkcount := round((amount / chunksize)+0.5);
29: else
30: chunkCount := 1;

Line 34: dbms_lob.read(pIDoc, chunksize, position, rawData);

30: chunkCount := 1;
31: end if;
32:
33: for i in 1..chunkcount loop
34: dbms_lob.read(pIDoc, chunksize, position, rawData);
35: base64raw := utl_encode.base64_encode(rawData);
36: cBuffer := utl_raw.cast_to_varchar2(base64Raw);
37: dbms_lob.writeAppend(pODoc, length(cBuffer), cBuffer);
38: position := position + chunksize;

Line 37: dbms_lob.writeAppend(pODoc, length(cBuffer), cBuffer);

33: for i in 1..chunkcount loop
34: dbms_lob.read(pIDoc, chunksize, position, rawData);
35: base64raw := utl_encode.base64_encode(rawData);
36: cBuffer := utl_raw.cast_to_varchar2(base64Raw);
37: dbms_lob.writeAppend(pODoc, length(cBuffer), cBuffer);
38: position := position + chunksize;
39: end loop;
40: dbms_lob.WriteAppend(pODoc, 1, wf_core.newline);
41:

Line 40: dbms_lob.WriteAppend(pODoc, 1, wf_core.newline);

36: cBuffer := utl_raw.cast_to_varchar2(base64Raw);
37: dbms_lob.writeAppend(pODoc, length(cBuffer), cBuffer);
38: position := position + chunksize;
39: end loop;
40: dbms_lob.WriteAppend(pODoc, 1, wf_core.newline);
41:
42: exception
43: when others then
44: wf_core.context('WF_MAIL_UTIL', 'EncodeBLOB');

Line 66: amount := dbms_lob.getLength(pIDoc);

62: chunkcount binary_integer := 0;
63: cBuffer varchar2(32000);
64: bufsize number;
65: begin
66: amount := dbms_lob.getLength(pIDoc);
67: chunksize := 16896; -- Do not change
68: if(chunksize < amount) then
69: chunkcount := round((amount / chunksize)+0.5);
70: else

Line 74: dbms_lob.trim(pODoc, 0);

70: else
71: chunkCount := 1;
72: end if;
73:
74: dbms_lob.trim(pODoc, 0);
75: for i in 1..chunkcount loop
76: dbms_lob.read(pIDoc, chunksize, position, cBuffer);
77: base64raw := utl_raw.cast_to_raw(cBuffer);
78: rawData := utl_encode.base64_decode(base64Raw);

Line 76: dbms_lob.read(pIDoc, chunksize, position, cBuffer);

72: end if;
73:
74: dbms_lob.trim(pODoc, 0);
75: for i in 1..chunkcount loop
76: dbms_lob.read(pIDoc, chunksize, position, cBuffer);
77: base64raw := utl_raw.cast_to_raw(cBuffer);
78: rawData := utl_encode.base64_decode(base64Raw);
79: bufsize := utl_raw.length(rawData);
80: dbms_lob.writeAppend(pODoc, bufsize, rawData);

Line 80: dbms_lob.writeAppend(pODoc, bufsize, rawData);

76: dbms_lob.read(pIDoc, chunksize, position, cBuffer);
77: base64raw := utl_raw.cast_to_raw(cBuffer);
78: rawData := utl_encode.base64_decode(base64Raw);
79: bufsize := utl_raw.length(rawData);
80: dbms_lob.writeAppend(pODoc, bufsize, rawData);
81: position := position + chunksize;
82: end loop;
83:
84: exception