APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_SET_ELES

Line 542: FROM CS_KB_SET_ELES

538: is_dup NUMBER;
539:
540: CURSOR GET_ELES_TO_UPDATE (p_set_id IN NUMBER) IS
541: SELECT distinct element_id
542: FROM CS_KB_SET_ELES
543: WHERE set_id = p_set_id;
544:
545: --Added to resolve the bug 5947078
546: CURSOR CHECK_STMT_ALREADY_ADDED (p_set_id IN NUMBER, p_ele_id IN NUMBER) IS

Line 548: FROM CS_KB_SET_ELES

544:
545: --Added to resolve the bug 5947078
546: CURSOR CHECK_STMT_ALREADY_ADDED (p_set_id IN NUMBER, p_ele_id IN NUMBER) IS
547: SELECT count(*)
548: FROM CS_KB_SET_ELES
549: WHERE Set_id = p_set_id
550: AND Element_id = p_ele_id;
551:
552: l_check NUMBER;

Line 575: CS_KB_SET_ELES_PKG.Clone_Rows( P_SET_SOURCE_ID => l_old_set_id,

571: );
572:
573: -- Clone the Solution-Statement associations
574: -- Copy the Statements from the old version to the new clone
575: CS_KB_SET_ELES_PKG.Clone_Rows( P_SET_SOURCE_ID => l_old_set_id,
576: P_SET_TARGET_ID => l_new_set_id);
577:
578: -- Clone the Solution External Links
579: l_ret := CS_KB_SET_LINKS_PKG.Clone_Link

Line 624: UPDATE CS_KB_SET_ELES

620: CLOSE CHECK_STMT_ALREADY_ADDED;
621:
622: IF l_check = 0 THEN
623:
624: UPDATE CS_KB_SET_ELES
625: SET Element_id = is_dup
626: WHERE set_id = l_new_set_id
627: AND element_id = eles.element_id;
628:

Line 631: DELETE FROM CS_KB_SET_ELES

627: AND element_id = eles.element_id;
628:
629: ELSE
630:
631: DELETE FROM CS_KB_SET_ELES
632: WHERE set_id = l_new_set_id
633: AND element_id = eles.element_id;
634:
635: END IF;

Line 1188: FROM CS_KB_SET_ELES se,

1184: IS
1185:
1186: CURSOR GET_STATEMENTS_FOR_DUP_CHECK(v_set_id IN NUMBER) IS
1187: SELECT se.element_id, e.element_number
1188: FROM CS_KB_SET_ELES se,
1189: CS_KB_ELEMENTS_B e
1190: WHERE se.set_id = v_set_id
1191: AND se.element_id = e.element_id
1192: AND e.status <> 'PUBLISHED';

Line 1197: FROM CS_KB_SET_ELES

1193:
1194: CURSOR Check_Dup_On_Current_Soln (v_set_id IN NUMBER,
1195: v_dup_element_id IN NUMBER) IS
1196: SELECT count(*)
1197: FROM CS_KB_SET_ELES
1198: WHERE set_id = v_set_id
1199: AND element_id = v_dup_element_id;
1200:
1201: l_dup_element_id NUMBER;

Line 1233: UPDATE CS_KB_SET_ELES

1229: FETCH Check_Dup_On_Current_Soln INTO l_dup_count;
1230: CLOSE Check_Dup_On_Current_Soln;
1231: IF l_dup_count = 0 THEN
1232: -- If Dup doesnt already exist
1233: UPDATE CS_KB_SET_ELES
1234: SET ELEMENT_ID = l_dup_element_id,
1235: LAST_UPDATE_DATE = sysdate,
1236: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1237: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 1245: DELETE FROM CS_KB_SET_ELES

1241: l_delete_status := CS_KB_ELEMENTS_AUDIT_PKG.Delete_Element(rec.element_number);
1242: -- No need to check delete status - if delete not valid ie statement shared then ignore
1243: ELSE
1244: -- If Dup does already exist
1245: DELETE FROM CS_KB_SET_ELES
1246: WHERE Set_Id = p_set_id
1247: AND element_id = rec.element_id;
1248:
1249: END IF;

Line 1756: DELETE FROM CS_KB_SET_ELES WHERE set_id = p_set_id;

1752: DELETE FROM CS_KB_SET_CATEGORIES 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