APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_SET_ELES

Line 547: FROM CS_KB_SET_ELES

543: is_dup NUMBER;
544:
545: CURSOR GET_ELES_TO_UPDATE (p_set_id IN NUMBER) IS
546: SELECT distinct element_id
547: FROM CS_KB_SET_ELES
548: WHERE set_id = p_set_id;
549:
550: --Added to resolve the bug 5947078
551: CURSOR CHECK_STMT_ALREADY_ADDED (p_set_id IN NUMBER, p_ele_id IN NUMBER) IS

Line 553: FROM CS_KB_SET_ELES

549:
550: --Added to resolve the bug 5947078
551: CURSOR CHECK_STMT_ALREADY_ADDED (p_set_id IN NUMBER, p_ele_id IN NUMBER) IS
552: SELECT count(*)
553: FROM CS_KB_SET_ELES
554: WHERE Set_id = p_set_id
555: AND Element_id = p_ele_id;
556:
557: l_check NUMBER;

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

576: );
577:
578: -- Clone the Solution-Statement associations
579: -- Copy the Statements from the old version to the new clone
580: CS_KB_SET_ELES_PKG.Clone_Rows( P_SET_SOURCE_ID => l_old_set_id,
581: P_SET_TARGET_ID => l_new_set_id);
582:
583: -- Clone the Solution External Links
584: l_ret := CS_KB_SET_LINKS_PKG.Clone_Link

Line 629: UPDATE CS_KB_SET_ELES

625: CLOSE CHECK_STMT_ALREADY_ADDED;
626:
627: IF l_check = 0 THEN
628:
629: UPDATE CS_KB_SET_ELES
630: SET Element_id = is_dup
631: WHERE set_id = l_new_set_id
632: AND element_id = eles.element_id;
633:

Line 636: DELETE FROM CS_KB_SET_ELES

632: AND element_id = eles.element_id;
633:
634: ELSE
635:
636: DELETE FROM CS_KB_SET_ELES
637: WHERE set_id = l_new_set_id
638: AND element_id = eles.element_id;
639:
640: END IF;

Line 1202: FROM CS_KB_SET_ELES se,

1198: IS
1199:
1200: CURSOR GET_STATEMENTS_FOR_DUP_CHECK(v_set_id IN NUMBER) IS
1201: SELECT se.element_id, e.element_number
1202: FROM CS_KB_SET_ELES se,
1203: CS_KB_ELEMENTS_B e
1204: WHERE se.set_id = v_set_id
1205: AND se.element_id = e.element_id
1206: AND e.status <> 'PUBLISHED';

Line 1211: FROM CS_KB_SET_ELES

1207:
1208: CURSOR Check_Dup_On_Current_Soln (v_set_id IN NUMBER,
1209: v_dup_element_id IN NUMBER) IS
1210: SELECT count(*)
1211: FROM CS_KB_SET_ELES
1212: WHERE set_id = v_set_id
1213: AND element_id = v_dup_element_id;
1214:
1215: l_dup_element_id NUMBER;

Line 1247: UPDATE CS_KB_SET_ELES

1243: FETCH Check_Dup_On_Current_Soln INTO l_dup_count;
1244: CLOSE Check_Dup_On_Current_Soln;
1245: IF l_dup_count = 0 THEN
1246: -- If Dup doesnt already exist
1247: UPDATE CS_KB_SET_ELES
1248: SET ELEMENT_ID = l_dup_element_id,
1249: LAST_UPDATE_DATE = sysdate,
1250: LAST_UPDATED_BY = FND_GLOBAL.user_id,
1251: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 1259: DELETE FROM CS_KB_SET_ELES

1255: l_delete_status := CS_KB_ELEMENTS_AUDIT_PKG.Delete_Element(rec.element_number);
1256: -- No need to check delete status - if delete not valid ie statement shared then ignore
1257: ELSE
1258: -- If Dup does already exist
1259: DELETE FROM CS_KB_SET_ELES
1260: WHERE Set_Id = p_set_id
1261: AND element_id = rec.element_id;
1262:
1263: END IF;

Line 1770: DELETE FROM CS_KB_SET_ELES WHERE set_id = p_set_id;

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