APPS.OZF_REQUEST_STATUS_PVT dependencies on DBMS_LOB

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

386: fetch lc_get_notes into l_notes_clob;
387: close lc_get_notes;
388:
389:
390: l_notes_varchar := dbms_lob.substr(lob_loc => l_notes_clob, amount => l_note_size, offset => 1);
391:
392: if p_itemtype = 'OZFSPBEN' then
393: l_request_type := 'SPECIAL_PRICE';
394: else