APPS.CSK_SETUP_UTILITY_PKG dependencies on DBMS_LOB

Line 860: dbms_lob.createtemporary(l_lob, TRUE, dbms_lob.session);

856: l_len INTEGER;
857: l_offset INTEGER;
858: l_text_content varchar2(4000) := '';
859: begin
860: dbms_lob.createtemporary(l_lob, TRUE, dbms_lob.session);
861: cs_kb_ctx_pkg.Synthesize_Solution_Content(P_SET_ID,userenv('LANG'),l_lob);
862: l_len := dbms_lob.GETLENGTH(l_lob);
863: l_offset := 1;
864:

Line 862: l_len := dbms_lob.GETLENGTH(l_lob);

858: l_text_content varchar2(4000) := '';
859: begin
860: dbms_lob.createtemporary(l_lob, TRUE, dbms_lob.session);
861: cs_kb_ctx_pkg.Synthesize_Solution_Content(P_SET_ID,userenv('LANG'),l_lob);
862: l_len := dbms_lob.GETLENGTH(l_lob);
863: l_offset := 1;
864:
865: while l_len > 100 loop
866: l_text_content := l_text_content || dbms_lob.substr(l_lob,100,l_offset);

Line 866: l_text_content := l_text_content || dbms_lob.substr(l_lob,100,l_offset);

862: l_len := dbms_lob.GETLENGTH(l_lob);
863: l_offset := 1;
864:
865: while l_len > 100 loop
866: l_text_content := l_text_content || dbms_lob.substr(l_lob,100,l_offset);
867: l_offset := l_offset + 100;
868: l_len := l_len - 100;
869: end loop;
870: l_text_content := l_text_content || dbms_lob.substr(l_lob,l_len,l_offset);

Line 870: l_text_content := l_text_content || dbms_lob.substr(l_lob,l_len,l_offset);

866: l_text_content := l_text_content || dbms_lob.substr(l_lob,100,l_offset);
867: l_offset := l_offset + 100;
868: l_len := l_len - 100;
869: end loop;
870: l_text_content := l_text_content || dbms_lob.substr(l_lob,l_len,l_offset);
871: dbms_output.put_line(substr(l_text_content,0,200));
872: return l_text_content;
873: end;
874: