APPS.IEM_TEXT_PVT dependencies on DBMS_LOB

Line 592: dbms_lob.createtemporary(l_data, TRUE);

588: order by order_id;
589: l_html_flag number;
590: l_index number;
591: begin
592: dbms_lob.createtemporary(l_data, TRUE);
593: l_html_flag:=0; -- Plain Text
594: for v1 in c1 loop
595: l_text:=l_text||ltrim(v1.value,' ');
596: if v1.type like '%html%' then

Line 604: l_text:=dbms_lob.substr(l_data,dbms_lob.getlength(l_data),1);

600: end loop;
601: l_text:=substr(l_text,1,2000);
602: if l_html_flag=1 then
603: ctx_doc.policy_filter('IEM_HTML_EXTRACT_POLICY',l_text,l_data,TRUE,null,null,null);
604: l_text:=dbms_lob.substr(l_data,dbms_lob.getlength(l_data),1);
605: x_text:=ltrim(ltrim(l_text),fnd_global.local_chr(10));
606: else
607: x_text:=ltrim(l_text,' '); --Return the plain text as is.
608: end if;

Line 609: dbms_lob.freetemporary(l_data);

605: x_text:=ltrim(ltrim(l_text),fnd_global.local_chr(10));
606: else
607: x_text:=ltrim(l_text,' '); --Return the plain text as is.
608: end if;
609: dbms_lob.freetemporary(l_data);
610: x_status:='S';
611: exception when others then
612: x_status:='E';
613: end RETRIEVE_TEXT;