APPS.CS_KB_R_CTX_PKG dependencies on DBMS_LOB

Line 48: dbms_lob.createtemporary(l_temp_clob, TRUE, dbms_lob.call);

44:
45: begin
46:
47: -- temp clob lives for at most the duration of call.
48: dbms_lob.createtemporary(l_temp_clob, TRUE, dbms_lob.call);
49:
50: open get_data_csr(p_rowid);
51: fetch get_data_csr into l_message_id, l_lang, l_name, l_desc_clob, l_mesg_number;
52: close get_data_csr;

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

57: l_data := l_data||'';
58:
59: l_data := CS_KB_CTX_PKG.Remove_Tags(l_data);
60:
61: dbms_lob.trim(p_clob, 0);
62: dbms_lob.writeappend(p_clob, length(l_data), l_data);
63:
64: dbms_lob.open(p_clob, DBMS_LOB.LOB_READWRITE);
65: dbms_lob.open (l_desc_clob, DBMS_LOB.LOB_READONLY);

Line 62: dbms_lob.writeappend(p_clob, length(l_data), l_data);

58:
59: l_data := CS_KB_CTX_PKG.Remove_Tags(l_data);
60:
61: dbms_lob.trim(p_clob, 0);
62: dbms_lob.writeappend(p_clob, length(l_data), l_data);
63:
64: dbms_lob.open(p_clob, DBMS_LOB.LOB_READWRITE);
65: dbms_lob.open (l_desc_clob, DBMS_LOB.LOB_READONLY);
66: dbms_lob.append(p_clob, CS_KB_CTX_PKG.Remove_Tags_Clob(l_desc_clob,l_temp_clob));

Line 64: dbms_lob.open(p_clob, DBMS_LOB.LOB_READWRITE);

60:
61: dbms_lob.trim(p_clob, 0);
62: dbms_lob.writeappend(p_clob, length(l_data), l_data);
63:
64: dbms_lob.open(p_clob, DBMS_LOB.LOB_READWRITE);
65: dbms_lob.open (l_desc_clob, DBMS_LOB.LOB_READONLY);
66: dbms_lob.append(p_clob, CS_KB_CTX_PKG.Remove_Tags_Clob(l_desc_clob,l_temp_clob));
67:
68: dbms_lob.close(p_clob);

Line 65: dbms_lob.open (l_desc_clob, DBMS_LOB.LOB_READONLY);

61: dbms_lob.trim(p_clob, 0);
62: dbms_lob.writeappend(p_clob, length(l_data), l_data);
63:
64: dbms_lob.open(p_clob, DBMS_LOB.LOB_READWRITE);
65: dbms_lob.open (l_desc_clob, DBMS_LOB.LOB_READONLY);
66: dbms_lob.append(p_clob, CS_KB_CTX_PKG.Remove_Tags_Clob(l_desc_clob,l_temp_clob));
67:
68: dbms_lob.close(p_clob);
69: dbms_lob.close(l_desc_clob);

Line 66: dbms_lob.append(p_clob, CS_KB_CTX_PKG.Remove_Tags_Clob(l_desc_clob,l_temp_clob));

62: dbms_lob.writeappend(p_clob, length(l_data), l_data);
63:
64: dbms_lob.open(p_clob, DBMS_LOB.LOB_READWRITE);
65: dbms_lob.open (l_desc_clob, DBMS_LOB.LOB_READONLY);
66: dbms_lob.append(p_clob, CS_KB_CTX_PKG.Remove_Tags_Clob(l_desc_clob,l_temp_clob));
67:
68: dbms_lob.close(p_clob);
69: dbms_lob.close(l_desc_clob);
70: dbms_lob.writeappend(p_clob, length(''), '');

Line 68: dbms_lob.close(p_clob);

64: dbms_lob.open(p_clob, DBMS_LOB.LOB_READWRITE);
65: dbms_lob.open (l_desc_clob, DBMS_LOB.LOB_READONLY);
66: dbms_lob.append(p_clob, CS_KB_CTX_PKG.Remove_Tags_Clob(l_desc_clob,l_temp_clob));
67:
68: dbms_lob.close(p_clob);
69: dbms_lob.close(l_desc_clob);
70: dbms_lob.writeappend(p_clob, length(''), '');
71:
72: l_data := ''||l_lang||'';

Line 69: dbms_lob.close(l_desc_clob);

65: dbms_lob.open (l_desc_clob, DBMS_LOB.LOB_READONLY);
66: dbms_lob.append(p_clob, CS_KB_CTX_PKG.Remove_Tags_Clob(l_desc_clob,l_temp_clob));
67:
68: dbms_lob.close(p_clob);
69: dbms_lob.close(l_desc_clob);
70: dbms_lob.writeappend(p_clob, length(''), '');
71:
72: l_data := ''||l_lang||'';
73: dbms_lob.writeappend(p_clob, length(l_data), l_data);

Line 70: dbms_lob.writeappend(p_clob, length(''), '');

66: dbms_lob.append(p_clob, CS_KB_CTX_PKG.Remove_Tags_Clob(l_desc_clob,l_temp_clob));
67:
68: dbms_lob.close(p_clob);
69: dbms_lob.close(l_desc_clob);
70: dbms_lob.writeappend(p_clob, length(''), '');
71:
72: l_data := ''||l_lang||'';
73: dbms_lob.writeappend(p_clob, length(l_data), l_data);
74:

Line 73: dbms_lob.writeappend(p_clob, length(l_data), l_data);

69: dbms_lob.close(l_desc_clob);
70: dbms_lob.writeappend(p_clob, length(''), '');
71:
72: l_data := ''||l_lang||'';
73: dbms_lob.writeappend(p_clob, length(l_data), l_data);
74:
75: -- explicitly free the clob
76: dbms_lob.freetemporary(l_temp_clob);
77:

Line 76: dbms_lob.freetemporary(l_temp_clob);

72: l_data := ''||l_lang||'';
73: dbms_lob.writeappend(p_clob, length(l_data), l_data);
74:
75: -- explicitly free the clob
76: dbms_lob.freetemporary(l_temp_clob);
77:
78: End Get_Forum_Composite_Cols;
79: end cs_kb_r_ctx_pkg;