APPS.IBC_CONTENT_CTX_PKG dependencies on DBMS_LOB

Line 83: dbms_lob.trim(p_clob, 0);

79:
80: BEGIN
81:
82: -- Clear out the output CLOB buffer
83: dbms_lob.trim(p_clob, 0);
84:
85: Open cur_name_desc(p_rowid);
86: Fetch cur_name_desc Into l_citem_version_id,
87: l_language,

Line 110: dbms_lob.writeappend(p_clob, l_amt, l_data);

106: l_data := l_data||l_newline||''||l_attachment_file_name||'';
107:
108: l_amt := length(l_data);
109:
110: dbms_lob.writeappend(p_clob, l_amt, l_data);
111:
112: Synthesize_Content_Attachments(l_attachment_file_id, p_clob);
113: Synthesize_Attribute_Bundles(l_attribute_bundle_id,p_clob);
114: Synthesize_Content_Keywords(l_citem_version_id,p_clob);

Line 153: dbms_lob.writeappend(p_clob, l_amt, l_data);

149: IF (l_file_data is NOT NULL) AND (isValidForFilter(l_file_content_type)) THEN
150:
151: l_data := l_data || l_newline||'';
152: l_amt := LENGTH(l_data);
153: dbms_lob.writeappend(p_clob, l_amt, l_data);
154:
155: -- Binary files get filtered as text file
156: -- msword,pdf etc is converted to text format
157: ctx_doc.policy_filter(policy_name =>'IBC_Binary2Text_Filter'

Line 166: dbms_lob.writeappend(p_clob, l_amt, l_data);

162: p_clob := p_clob || l_document;
163:
164: l_data := '';
165: l_amt := LENGTH(l_data);
166: dbms_lob.writeappend(p_clob, l_amt, l_data);
167:
168: END IF;
169:
170: END Synthesize_Content_Attachments;

Line 201: dbms_lob.writeappend(p_clob, l_amt, l_data);

197: IF l_attribute_data is NOT NULL THEN
198:
199: l_data := l_data || l_newline||'';
200: l_amt := LENGTH(l_data);
201: dbms_lob.writeappend(p_clob, l_amt, l_data);
202:
203: ctx_doc.policy_filter(policy_name =>'IBC_XML_Policy'
204: ,document =>l_attribute_data --l_file_data varvhar2,clob,blob
205: ,restab =>l_clean_xml_doc

Line 219: dbms_lob.writeappend(p_clob, l_amt, l_data);

215: p_clob := p_clob || l_clean_html_doc;
216:
217: l_data := l_newline|| '';
218: l_amt := LENGTH(l_data);
219: dbms_lob.writeappend(p_clob, l_amt, l_data);
220:
221: END IF;
222:
223: END Synthesize_Attribute_Bundles;

Line 250: dbms_lob.writeappend(p_clob, l_amt, l_data);

246: l_data := l_data || l_newline || cur_content_keywords_rec.keyword;
247: l_amt := LENGTH(l_data);
248: IF l_amt >= 31000 THEN
249: -- flush l_data to the p_clob
250: dbms_lob.writeappend(p_clob, l_amt, l_data);
251: l_data := l_newline;
252: END IF;
253: END LOOP;
254:

Line 257: dbms_lob.writeappend(p_clob, LENGTH(l_data), l_data);

253: END LOOP;
254:
255: IF l_data is NOT NULL THEN
256: l_data := l_newline||''|| l_data || '';
257: dbms_lob.writeappend(p_clob, LENGTH(l_data), l_data);
258: END IF;
259:
260: END Synthesize_Content_Keywords;
261:

Line 295: dbms_lob.writeappend(p_clob, l_amt, l_data);

291: l_rendition_file_name := NULL;
292:
293: l_data := l_data || l_newline||'';
294: l_amt := LENGTH(l_data);
295: dbms_lob.writeappend(p_clob, l_amt, l_data);
296:
297: FOR cur_rend_data_rec IN cur_rend_data(p_citem_version_id)
298: LOOP
299:

Line 317: dbms_lob.writeappend(p_clob, l_amt, l_rendition_file_name);

313: l_rendition_file_name := l_rendition_file_name || l_newline || cur_rend_data_rec.rendition_file_name;
314: l_amt := LENGTH(l_rendition_file_name);
315: IF l_amt >= 31000 THEN
316: -- flush l_rendition_file_name to the p_clob
317: dbms_lob.writeappend(p_clob, l_amt, l_rendition_file_name);
318: l_rendition_file_name := l_newline;
319: END IF;
320: END LOOP;
321:

Line 325: dbms_lob.writeappend(p_clob, l_amt, l_data);

321:
322: IF p_clob IS NOT NULL THEN
323: l_data := '' || l_newline;
324: l_amt := LENGTH(l_data);
325: dbms_lob.writeappend(p_clob, l_amt, l_data);
326: END IF;
327:
328: If l_rendition_file_name IS NOT NULL THEN
329: l_rendition_file_name := '' || l_newline||l_rendition_file_name ||'';

Line 330: dbms_lob.writeappend(p_clob, LENGTH(l_rendition_file_name), l_rendition_file_name);

326: END IF;
327:
328: If l_rendition_file_name IS NOT NULL THEN
329: l_rendition_file_name := '' || l_newline||l_rendition_file_name ||'';
330: dbms_lob.writeappend(p_clob, LENGTH(l_rendition_file_name), l_rendition_file_name);
331: END IF;
332:
333: END Synthesize_Content_Renditions;
334: