APPS.CS_KB_SYNC_INDEX_PKG dependencies on DBMS_LOB

Line 65: dbms_lob.createtemporary(l_content, TRUE);

61: end if;
62:
63: -- Create a temporary CLOB and populate it with the synthesized
64: -- solution content, to be indexed
65: dbms_lob.createtemporary(l_content, TRUE);
66: cs_kb_ctx_pkg.synthesize_solution_content
67: ( p_solution_id, p_lang, l_content );
68:
69: -- Copy the synthesized solution content into the content cache

Line 71: l_content_len := dbms_lob.getlength(l_content);

67: ( p_solution_id, p_lang, l_content );
68:
69: -- Copy the synthesized solution content into the content cache
70: -- through the LOB locator
71: l_content_len := dbms_lob.getlength(l_content);
72: dbms_lob.open(l_cache, DBMS_LOB.LOB_READWRITE);
73: dbms_lob.copy(l_cache, l_content, l_content_len, l_dest_pos, l_src_pos );
74: dbms_lob.close(l_cache);
75:

Line 72: dbms_lob.open(l_cache, DBMS_LOB.LOB_READWRITE);

68:
69: -- Copy the synthesized solution content into the content cache
70: -- through the LOB locator
71: l_content_len := dbms_lob.getlength(l_content);
72: dbms_lob.open(l_cache, DBMS_LOB.LOB_READWRITE);
73: dbms_lob.copy(l_cache, l_content, l_content_len, l_dest_pos, l_src_pos );
74: dbms_lob.close(l_cache);
75:
76: -- Free up the temporary CLOB created earlier

Line 73: dbms_lob.copy(l_cache, l_content, l_content_len, l_dest_pos, l_src_pos );

69: -- Copy the synthesized solution content into the content cache
70: -- through the LOB locator
71: l_content_len := dbms_lob.getlength(l_content);
72: dbms_lob.open(l_cache, DBMS_LOB.LOB_READWRITE);
73: dbms_lob.copy(l_cache, l_content, l_content_len, l_dest_pos, l_src_pos );
74: dbms_lob.close(l_cache);
75:
76: -- Free up the temporary CLOB created earlier
77: dbms_lob.freetemporary(l_content);

Line 74: dbms_lob.close(l_cache);

70: -- through the LOB locator
71: l_content_len := dbms_lob.getlength(l_content);
72: dbms_lob.open(l_cache, DBMS_LOB.LOB_READWRITE);
73: dbms_lob.copy(l_cache, l_content, l_content_len, l_dest_pos, l_src_pos );
74: dbms_lob.close(l_cache);
75:
76: -- Free up the temporary CLOB created earlier
77: dbms_lob.freetemporary(l_content);
78: end Populate_Soln_Content_Cache;

Line 77: dbms_lob.freetemporary(l_content);

73: dbms_lob.copy(l_cache, l_content, l_content_len, l_dest_pos, l_src_pos );
74: dbms_lob.close(l_cache);
75:
76: -- Free up the temporary CLOB created earlier
77: dbms_lob.freetemporary(l_content);
78: end Populate_Soln_Content_Cache;
79:
80:
81: /*