APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_SETS_TL

Line 158: l_solution_title CS_KB_SETS_TL.NAME%TYPE;

154:
155: FUNCTION Get_Solution_Title(
156: P_SET_ID IN NUMBER)
157: RETURN VARCHAR2 IS
158: l_solution_title CS_KB_SETS_TL.NAME%TYPE;
159: BEGIN
160:
161: SELECT name
162: INTO l_solution_title

Line 163: FROM CS_KB_SETS_TL

159: BEGIN
160:
161: SELECT name
162: INTO l_solution_title
163: FROM CS_KB_SETS_TL
164: WHERE set_id = p_set_id
165: AND language = USERENV('LANG');
166:
167: RETURN l_solution_title;

Line 378: FROM CS_KB_SETS_TL

374: composite_assoc_index,
375: composite_assoc_attach_index, --12.1.3
376: positive_assoc_index,
377: negative_assoc_index
378: FROM CS_KB_SETS_TL
379: WHERE Set_Id = v_set_id;
380:
381: BEGIN
382: l_old_set_id := P_ORIG_SET_ID; --Get_Latest_Version_Id(p_set_number);

Line 489: INSERT INTO CS_KB_SETS_TL (

485: AND s3.STATUS = 'PUB');
486:
487: FOR tl_rec IN get_tl_rows(l_old_set_id) LOOP
488:
489: INSERT INTO CS_KB_SETS_TL (
490: set_id,
491: language,
492: source_lang,
493: name,

Line 1771: DELETE FROM CS_KB_SETS_TL WHERE set_id = p_set_id;

1767: DELETE FROM CS_KB_SET_PRODUCTS WHERE set_id = p_set_id;
1768: DELETE FROM CS_KB_SET_PLATFORMS WHERE set_id = p_set_id;
1769: DELETE FROM CS_KB_SET_LINKS WHERE set_id = p_set_id;
1770: DELETE FROM CS_KB_SET_ELES WHERE set_id = p_set_id;
1771: DELETE FROM CS_KB_SETS_TL WHERE set_id = p_set_id;
1772: UPDATE
1773: CS_KB_SETS_B
1774: SET
1775: latest_version_flag = 'Y'