APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_ELEMENTS_B

Line 609: UPDATE CS_KB_ELEMENTS_B

605:
606: is_dup := CS_KB_ELEMENTS_AUDIT_PKG.Is_Element_Created_Dup(eles.element_id);
607:
608: IF is_dup = 0 THEN
609: UPDATE CS_KB_ELEMENTS_B
610: SET status = 'PUBLISHED'
611: WHERE element_id = eles.element_id;
612: ELSE --element is duplicate so set to Obsolete
613: UPDATE CS_KB_ELEMENTS_B

Line 613: UPDATE CS_KB_ELEMENTS_B

609: UPDATE CS_KB_ELEMENTS_B
610: SET status = 'PUBLISHED'
611: WHERE element_id = eles.element_id;
612: ELSE --element is duplicate so set to Obsolete
613: UPDATE CS_KB_ELEMENTS_B
614: SET status = 'OBS'
615: WHERE element_id = eles.element_id;
616:
617: -- Added to resolve the Bug 5947078

Line 1189: CS_KB_ELEMENTS_B e

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