APPS.CS_KB_CTX_PKG dependencies on CS_KB_SETS_TL

Line 123: FROM CS_KB_SETS_TL tl, CS_KB_SETS_B b

119: b.status,
120: tl.content_cache,
121: b.set_number,
122: b.set_type_id
123: FROM CS_KB_SETS_TL tl, CS_KB_SETS_B b
124: WHERE tl.ROWID = p_rowid
125: AND b.set_id = tl.set_id;
126:
127: l_set_number VARCHAR2(30);

Line 136: from CS_KB_SETS_TL tl, CS_KB_SETS_B b

132: /*
133: -- Get the solution id and language, based on the rowid
134: select tl.set_id, tl.language, b.status, tl.content_cache
135: into l_solnid, l_lang, l_status, l_clob
136: from CS_KB_SETS_TL tl, CS_KB_SETS_B b
137: where tl.rowid = p_rowid
138: and b.set_id = tl.set_id;
139: */
140: OPEN set_content_csr(p_rowid);

Line 203: FROM Cs_Kb_Sets_tl

199: l_data VARCHAR2(32000);
200:
201: CURSOR set_title_csr(p_set_id NUMBER, p_lang VARCHAR2) IS
202: SELECT name
203: FROM Cs_Kb_Sets_tl
204: WHERE set_id = p_set_id
205: AND LANGUAGE = p_lang;
206: l_soln_title VARCHAR2(2000);
207:

Line 545: FROM CS_KB_SETS_B b, CS_KB_SETS_TL tl

541: p_temp_clob IN OUT NOCOPY CLOB)
542: IS
543: CURSOR c2(c_set_id IN NUMBER, c_lang IN VARCHAR2) IS
544: SELECT b.set_number, tl.name
545: FROM CS_KB_SETS_B b, CS_KB_SETS_TL tl
546: WHERE b.set_id = c_set_id
547: AND tl.set_id = b.set_id
548: AND tl.LANGUAGE = c_lang;
549: