DBA Data[Home] [Help]

APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_ELEMENTS_AUDIT_PKG

Line 611: is_dup := CS_KB_ELEMENTS_AUDIT_PKG.Is_Element_Created_Dup(eles.element_id);

607: -- Any Duplicate Statements will be obsoleted
608:
609: FOR eles IN GET_ELES_TO_UPDATE(l_new_set_id) LOOP
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'

Line 1237: l_dup_element_id := CS_KB_ELEMENTS_AUDIT_PKG.Is_Element_Created_Dup(rec.element_id);

1233: -- Published statements. If duplicates exist
1234: -- then remove and replace set_ele link with original PUB statement
1235:
1236: FOR rec IN GET_STATEMENTS_FOR_DUP_CHECK(p_set_id) LOOP
1237: l_dup_element_id := CS_KB_ELEMENTS_AUDIT_PKG.Is_Element_Created_Dup(rec.element_id);
1238:
1239: IF l_dup_element_id <> 0 THEN
1240:
1241: -- Check if the Duplicate has already been added to the solution already

Line 1255: l_delete_status := CS_KB_ELEMENTS_AUDIT_PKG.Delete_Element(rec.element_number);

1251: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1252: WHERE set_id = p_set_id
1253: AND element_id = rec.element_id;
1254:
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