APPS.PV_BENFT_STATUS_CHANGE dependencies on DBMS_LOB

Line 1269: l_notes_varchar := dbms_lob.substr(lob_loc => l_notes_clob, amount => l_note_size, offset => 1);

1265: open lc_get_notes(pc_entity_type => p_itemtype, pc_entity_id => p_entity_id);
1266: fetch lc_get_notes into l_notes, l_notes_clob;
1267: close lc_get_notes;
1268:
1269: l_notes_varchar := dbms_lob.substr(lob_loc => l_notes_clob, amount => l_note_size, offset => 1);
1270: if l_notes_varchar is null or length(l_notes_varchar) = 0 then
1271: l_notes_varchar := l_notes;
1272: end if;
1273: