APPS.AST_NOTE_PACKAGE dependencies on DBMS_LOB

Line 28: clob_size := dbms_lob.getlength(p_clob);

24: BEGIN
25: if p_clob is null then
26: return null;
27: else
28: clob_size := dbms_lob.getlength(p_clob);
29: if clob_size < amount then
30: amount := clob_size;
31: end if;
32: if clob_size = 0 then

Line 35: dbms_lob.read(p_clob, amount, 1, buffer);

31: end if;
32: if clob_size = 0 then
33: return null;
34: end if;
35: dbms_lob.read(p_clob, amount, 1, buffer);
36: if amount > 0 then
37: return buffer;
38: else
39: return null;

Line 66: clob_size := dbms_lob.getlength(p_clob);

62:
63: if p_clob is null then
64: return null;
65: else
66: clob_size := dbms_lob.getlength(p_clob);
67: if clob_size < amount then
68: amount := clob_size;
69: end if;
70: if clob_size = 0 then

Line 73: dbms_lob.read(p_clob, amount, 1, buffer);

69: end if;
70: if clob_size = 0 then
71: return null;
72: end if;
73: dbms_lob.read(p_clob, amount, 1, buffer);
74: if amount > 0 then
75: return buffer;
76: else
77: return null;