eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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: /*

Line 141: dbms_lob.createtemporary(l_attach_content, TRUE);

137: end if;
138:
139: -- Create a temporary CLOB and populate it with the synthesized
140: -- solution content, to be indexed
141: dbms_lob.createtemporary(l_attach_content, TRUE);
142: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'cs.plsql.csksyncb.pls',
144: 'Before cs_kb_ctx_pkg.synthesize_sol_attach_content - ');
145: END IF;

Line 156: l_attach_content_len := dbms_lob.getlength(l_attach_content);

152: END IF;
153:
154: -- Copy the synthesized solution content into the content cache
155: -- through the LOB locator
156: l_attach_content_len := dbms_lob.getlength(l_attach_content);
157: dbms_lob.open(l_attach_cache, DBMS_LOB.LOB_READWRITE);
158: dbms_lob.copy(l_attach_cache, l_attach_content, l_attach_content_len, l_attach_dest_pos, l_attach_src_pos );
159: dbms_lob.close(l_attach_cache);
160:

Line 157: dbms_lob.open(l_attach_cache, DBMS_LOB.LOB_READWRITE);

153:
154: -- Copy the synthesized solution content into the content cache
155: -- through the LOB locator
156: l_attach_content_len := dbms_lob.getlength(l_attach_content);
157: dbms_lob.open(l_attach_cache, DBMS_LOB.LOB_READWRITE);
158: dbms_lob.copy(l_attach_cache, l_attach_content, l_attach_content_len, l_attach_dest_pos, l_attach_src_pos );
159: dbms_lob.close(l_attach_cache);
160:
161: -- Free up the temporary CLOB created earlier

Line 158: dbms_lob.copy(l_attach_cache, l_attach_content, l_attach_content_len, l_attach_dest_pos, l_attach_src_pos );

154: -- Copy the synthesized solution content into the content cache
155: -- through the LOB locator
156: l_attach_content_len := dbms_lob.getlength(l_attach_content);
157: dbms_lob.open(l_attach_cache, DBMS_LOB.LOB_READWRITE);
158: dbms_lob.copy(l_attach_cache, l_attach_content, l_attach_content_len, l_attach_dest_pos, l_attach_src_pos );
159: dbms_lob.close(l_attach_cache);
160:
161: -- Free up the temporary CLOB created earlier
162: dbms_lob.freetemporary(l_attach_content);

Line 159: dbms_lob.close(l_attach_cache);

155: -- through the LOB locator
156: l_attach_content_len := dbms_lob.getlength(l_attach_content);
157: dbms_lob.open(l_attach_cache, DBMS_LOB.LOB_READWRITE);
158: dbms_lob.copy(l_attach_cache, l_attach_content, l_attach_content_len, l_attach_dest_pos, l_attach_src_pos );
159: dbms_lob.close(l_attach_cache);
160:
161: -- Free up the temporary CLOB created earlier
162: dbms_lob.freetemporary(l_attach_content);
163: end Pop_Soln_Attach_Content_Cache;

Line 162: dbms_lob.freetemporary(l_attach_content);

158: dbms_lob.copy(l_attach_cache, l_attach_content, l_attach_content_len, l_attach_dest_pos, l_attach_src_pos );
159: dbms_lob.close(l_attach_cache);
160:
161: -- Free up the temporary CLOB created earlier
162: dbms_lob.freetemporary(l_attach_content);
163: end Pop_Soln_Attach_Content_Cache;
164:
165:
166: /*