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 602: l_text:=dbms_lob.substr(l_data,dbms_lob.getlength(l_data),1);

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

Line 607: dbms_lob.freetemporary(l_data);

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