APPS.DPP_REQUEST_STATUS_PVT dependencies on DBMS_LOB

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

291: fetch lc_get_notes into l_notes_clob;
292: close lc_get_notes;
293:
294:
295: l_notes_varchar := dbms_lob.substr(lob_loc => l_notes_clob, amount => l_note_size, offset => 1);
296:
297: if p_itemtype = 'DPPTXAPP' then
298: l_request_type := 'PRICE PROTECTION';
299: end if;