APPS.CS_KB_ELEMENTS_AUDIT_PKG dependencies on CS_KB_SET_ELES

Line 552: FROM CS_KB_SET_ELES

548: RETURN ERROR_STATUS;
549: END IF;
550:
551: SELECT COUNT(*) INTO l_count
552: FROM CS_KB_SET_ELES
553: WHERE element_id = Get_Latest_Version_Id(p_element_number);
554: IF(l_count > 0) THEN
555: FND_MESSAGE.set_name('CS', 'CS_KB_C_ELE_IN_SET_ERR');
556: RETURN ERROR_STATUS;

Line 930: FROM CS_KB_SET_ELES

926: SET last_update_date = l_date,
927: last_updated_by = l_updated_by,
928: last_update_login = l_login
929: WHERE set_id IN (SELECT set_id
930: FROM CS_KB_SET_ELES
931: WHERE element_id = p_element_id);
932:
933: X_RETURN := OKAY_STATUS;
934: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 990: CS_KB_SET_ELES e,

986:
987: CURSOR Get_Current_Cat_Group_Solns IS
988: SELECT distinct s.Set_id, s.Set_Number
989: FROM CS_KB_SETS_B s,
990: CS_KB_SET_ELES e,
991: CS_KB_SET_CATEGORIES c,
992: CS_KB_CAT_GROUP_DENORM d
993: WHERE s.Set_id = e.Set_Id
994: AND e.Element_id = P_ELEMENT_ID

Line 1003: CS_KB_SET_ELES e,

999:
1000: CURSOR Get_Curr_CG_Solns_Upd_Stmt (v_dup_id IN NUMBER) IS
1001: SELECT distinct s.Set_id, s.Set_Number
1002: FROM CS_KB_SETS_B s,
1003: CS_KB_SET_ELES e,
1004: CS_KB_SET_CATEGORIES c,
1005: CS_KB_CAT_GROUP_DENORM d
1006: WHERE s.Set_id = e.Set_Id
1007: AND e.Element_id = P_ELEMENT_ID

Line 1013: FROM CS_KB_SET_ELES se

1009: AND c.Category_id = d.Child_Category_id
1010: AND d.Category_Group_Id = CS_KB_SECURITY_PVT.Get_Category_Group_Id
1011: AND (s.Latest_Version_Flag = 'Y' OR s.Viewable_Version_Flag = 'Y')
1012: AND NOT EXISTS (SELECT 'x'
1013: FROM CS_KB_SET_ELES se
1014: WHERE se.set_id = e.set_id
1015: AND se.element_id = v_dup_id);
1016:
1017: CURSOR Get_Curr_CG_Solns_Rem_Stmt (v_dup_id IN NUMBER) IS

Line 1020: CS_KB_SET_ELES e,

1016:
1017: CURSOR Get_Curr_CG_Solns_Rem_Stmt (v_dup_id IN NUMBER) IS
1018: SELECT distinct s.Set_id, s.Set_Number
1019: FROM CS_KB_SETS_B s,
1020: CS_KB_SET_ELES e,
1021: CS_KB_SET_CATEGORIES c,
1022: CS_KB_CAT_GROUP_DENORM d
1023: WHERE s.Set_id = e.Set_Id
1024: AND e.Element_id = P_ELEMENT_ID

Line 1030: FROM CS_KB_SET_ELES se

1026: AND c.Category_id = d.Child_Category_id
1027: AND d.Category_Group_Id = CS_KB_SECURITY_PVT.Get_Category_Group_Id
1028: AND (s.Latest_Version_Flag = 'Y' OR s.Viewable_Version_Flag = 'Y')
1029: AND EXISTS (SELECT 'x'
1030: FROM CS_KB_SET_ELES se
1031: WHERE se.set_id = e.set_id
1032: AND se.element_id = v_dup_id);
1033:
1034: CURSOR Get_Element_Number IS

Line 1043: CS_KB_SET_ELES e

1039:
1040: CURSOR Stmt_In_Soln_Outside_Cur_CG IS
1041: SELECT count(distinct s.Set_Number)
1042: FROM CS_KB_SETS_VL s,
1043: CS_KB_SET_ELES e
1044: WHERE s.Set_id = e.Set_Id
1045: AND e.Element_id = P_ELEMENT_ID
1046: AND s.Latest_Version_Flag = 'Y'
1047: AND s.Status <> 'OBS'

Line 1050: CS_KB_SET_ELES setele,

1046: AND s.Latest_Version_Flag = 'Y'
1047: AND s.Status <> 'OBS'
1048: AND s.Set_Id IN (SELECT setb.Set_Id
1049: FROM CS_KB_SETS_B setb,
1050: CS_KB_SET_ELES setele,
1051: CS_KB_SET_CATEGORIES setcat,
1052: CS_KB_CAT_GROUP_DENORM denorm
1053: WHERE setb.set_id = setele.Set_Id
1054: AND setele.Element_id = e.Element_id

Line 1146: UPDATE CS_KB_SET_ELES se

1142: -- This returns Solutions in the current Category Group
1143: -- to be updated. Only solutions that do not already
1144: -- contain the new statement will be returned
1145:
1146: UPDATE CS_KB_SET_ELES se
1147: SET se.ELEMENT_ID = l_dup_id,
1148: se.LAST_UPDATE_DATE = sysdate,
1149: se.LAST_UPDATED_BY = FND_GLOBAL.user_id,
1150: se.LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 1162: DELETE FROM CS_KB_SET_ELES se

1158: -- These solutions already contain the new duplicate -
1159: -- therefore we will delete the original statement that
1160: -- was updated.
1161:
1162: DELETE FROM CS_KB_SET_ELES se
1163: WHERE se.Element_Id = P_ELEMENT_ID
1164: AND se.Set_Id = remstmts.Set_Id;
1165:
1166: END LOOP;

Line 1328: UPDATE CS_KB_SET_ELES se

1324: -- Associate New Statement to All Solutions within the
1325: -- current Category Group only
1326: FOR solns IN Get_Current_Cat_Group_Solns LOOP
1327:
1328: UPDATE CS_KB_SET_ELES se
1329: SET se.ELEMENT_ID = l_new_element_id,
1330: se.LAST_UPDATE_DATE = sysdate,
1331: se.LAST_UPDATED_BY = FND_GLOBAL.user_id,
1332: se.LAST_UPDATE_LOGIN = FND_GLOBAL.login_id

Line 1403: CS_KB_SET_ELES SE

1399: FROM CS_KB_ELEMENTS_B E
1400: WHERE E.status <> 'OBS'
1401: AND NOT EXISTS (SELECT 'x'
1402: FROM CS_KB_SETS_B S,
1403: CS_KB_SET_ELES SE
1404: WHERE SE.Set_Id = S.Set_Id
1405: AND SE.Element_Id = E.Element_Id
1406: AND S.Status <> 'OBS'
1407: AND (S.Latest_Version_Flag = 'Y' OR S.Viewable_Version_Flag = 'Y')