APPS.DPP_REQUEST_STATUS_PVT dependencies on DBMS_LOB

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

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