APPS.OZF_REQUEST_STATUS_PVT dependencies on DBMS_LOB

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

376: fetch lc_get_notes into l_notes_clob;
377: close lc_get_notes;
378:
379:
380: l_notes_varchar := dbms_lob.substr(lob_loc => l_notes_clob, amount => l_note_size, offset => 1);
381:
382: if p_itemtype = 'OZFSPBEN' then
383: l_request_type := 'SPECIAL_PRICE';
384: else