APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_SETS_TL

Line 156: l_solution_title CS_KB_SETS_TL.NAME%TYPE;

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

Line 161: FROM CS_KB_SETS_TL

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

Line 375: FROM CS_KB_SETS_TL

371: description,
372: composite_assoc_index,
373: positive_assoc_index,
374: negative_assoc_index
375: FROM CS_KB_SETS_TL
376: WHERE Set_Id = v_set_id;
377:
378: BEGIN
379: l_old_set_id := P_ORIG_SET_ID; --Get_Latest_Version_Id(p_set_number);

Line 486: INSERT INTO CS_KB_SETS_TL (

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

Line 1757: DELETE FROM CS_KB_SETS_TL WHERE set_id = p_set_id;

1753: DELETE FROM CS_KB_SET_PRODUCTS WHERE set_id = p_set_id;
1754: DELETE FROM CS_KB_SET_PLATFORMS WHERE set_id = p_set_id;
1755: DELETE FROM CS_KB_SET_LINKS WHERE set_id = p_set_id;
1756: DELETE FROM CS_KB_SET_ELES WHERE set_id = p_set_id;
1757: DELETE FROM CS_KB_SETS_TL WHERE set_id = p_set_id;
1758: UPDATE
1759: CS_KB_SETS_B
1760: SET
1761: latest_version_flag = 'Y'