APPS.CS_KB_CTX_PKG dependencies on CS_KB_SETS_TL

Line 144: FROM CS_KB_SETS_TL tl, CS_KB_SETS_B b

140: b.status,
141: tl.content_cache,
142: b.set_number,
143: b.set_type_id
144: FROM CS_KB_SETS_TL tl, CS_KB_SETS_B b
145: WHERE tl.ROWID = p_rowid
146: AND b.set_id = tl.set_id;
147:
148: l_set_number VARCHAR2(30);

Line 157: from CS_KB_SETS_TL tl, CS_KB_SETS_B b

153: /*
154: -- Get the solution id and language, based on the rowid
155: select tl.set_id, tl.language, b.status, tl.content_cache
156: into l_solnid, l_lang, l_status, l_clob
157: from CS_KB_SETS_TL tl, CS_KB_SETS_B b
158: where tl.rowid = p_rowid
159: and b.set_id = tl.set_id;
160: */
161: OPEN set_content_csr(p_rowid);

Line 224: FROM Cs_Kb_Sets_tl

220: l_data VARCHAR2(32000);
221:
222: CURSOR set_title_csr(p_set_id NUMBER, p_lang VARCHAR2) IS
223: SELECT name
224: FROM Cs_Kb_Sets_tl
225: WHERE set_id = p_set_id
226: AND LANGUAGE = p_lang;
227: l_soln_title VARCHAR2(2000);
228:

Line 442: FROM CS_KB_SETS_TL tl, CS_KB_SETS_B b

438: b.status,
439: tl.attachment_content_cache,
440: b.set_number,
441: b.set_type_id
442: FROM CS_KB_SETS_TL tl, CS_KB_SETS_B b
443: WHERE tl.ROWID = p_rowid
444: AND b.set_id = tl.set_id;
445:
446: l_set_number VARCHAR2(30);

Line 455: from CS_KB_SETS_TL tl, CS_KB_SETS_B b

451: /*
452: -- Get the solution id and language, based on the rowid
453: select tl.set_id, tl.language, b.status, tl.content_cache
454: into l_solnid, l_lang, l_status, l_clob
455: from CS_KB_SETS_TL tl, CS_KB_SETS_B b
456: where tl.rowid = p_rowid
457: and b.set_id = tl.set_id;
458: */
459: OPEN set_content_csr(p_rowid);

Line 521: FROM Cs_Kb_Sets_tl

517: l_data VARCHAR2(32000);
518:
519: CURSOR set_title_csr(p_set_id NUMBER, p_lang VARCHAR2) IS
520: SELECT name
521: FROM Cs_Kb_Sets_tl
522: WHERE set_id = p_set_id
523: AND LANGUAGE = p_lang;
524: l_soln_title VARCHAR2(2000);
525:

Line 984: FROM CS_KB_SETS_B b, CS_KB_SETS_TL tl

980: p_temp_clob IN OUT NOCOPY CLOB)
981: IS
982: CURSOR c2(c_set_id IN NUMBER, c_lang IN VARCHAR2) IS
983: SELECT b.set_number, tl.name
984: FROM CS_KB_SETS_B b, CS_KB_SETS_TL tl
985: WHERE b.set_id = c_set_id
986: AND tl.set_id = b.set_id
987: AND tl.LANGUAGE = c_lang;
988: