APPS.PV_WORKFLOW_PUB dependencies on DBMS_LOB

Line 2901: l_notes_varchar := dbms_lob.substr(lob_loc => l_note_rec.notes_detail, amount => l_note_size, offset => 1);

2897: for l_note_rec in lc_get_notes(pc_entity_id => l_entity_id) loop
2898:
2899: l_has_notes := true;
2900:
2901: l_notes_varchar := dbms_lob.substr(lob_loc => l_note_rec.notes_detail, amount => l_note_size, offset => 1);
2902: if l_notes_varchar is null or length(l_notes_varchar) = 0 then
2903: l_notes_varchar := l_note_rec.notes;
2904: end if;
2905: