DBA Data[Home] [Help]

APPS.CS_KB_SOLUTION_PVT dependencies on CS_KB_ELEMENTS_AUDIT_PKG

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

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

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

1219: -- Published statements. If duplicates exist
1220: -- then remove and replace set_ele link with original PUB statement
1221:
1222: FOR rec IN GET_STATEMENTS_FOR_DUP_CHECK(p_set_id) LOOP
1223: l_dup_element_id := CS_KB_ELEMENTS_AUDIT_PKG.Is_Element_Created_Dup(rec.element_id);
1224:
1225: IF l_dup_element_id <> 0 THEN
1226:
1227: -- Check if the Duplicate has already been added to the solution already

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

1237: LAST_UPDATE_LOGIN = FND_GLOBAL.login_id
1238: WHERE set_id = p_set_id
1239: AND element_id = rec.element_id;
1240:
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