APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_ELEMENTS_B

Line 614: UPDATE CS_KB_ELEMENTS_B

610:
611: is_dup := CS_KB_ELEMENTS_AUDIT_PKG.Is_Element_Created_Dup(eles.element_id);
612:
613: IF is_dup = 0 THEN
614: UPDATE CS_KB_ELEMENTS_B
615: SET status = 'PUBLISHED'
616: WHERE element_id = eles.element_id;
617: ELSE --element is duplicate so set to Obsolete
618: UPDATE CS_KB_ELEMENTS_B

Line 618: UPDATE CS_KB_ELEMENTS_B

614: UPDATE CS_KB_ELEMENTS_B
615: SET status = 'PUBLISHED'
616: WHERE element_id = eles.element_id;
617: ELSE --element is duplicate so set to Obsolete
618: UPDATE CS_KB_ELEMENTS_B
619: SET status = 'OBS'
620: WHERE element_id = eles.element_id;
621:
622: -- Added to resolve the Bug 5947078

Line 1203: CS_KB_ELEMENTS_B e

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';
1207: