[Home] [Help]
993: WHERE s.Set_id = e.Set_Id
994: AND e.Element_id = P_ELEMENT_ID
995: AND s.Set_id = c.Set_id
996: AND c.Category_id = d.Child_Category_id
997: AND d.Category_Group_Id = CS_KB_SECURITY_PVT.Get_Category_Group_Id
998: AND (s.Latest_Version_Flag = 'Y' OR s.Viewable_Version_Flag = 'Y');
999:
1000: CURSOR Get_Curr_CG_Solns_Upd_Stmt (v_dup_id IN NUMBER) IS
1001: SELECT distinct s.Set_id, s.Set_Number
1006: WHERE s.Set_id = e.Set_Id
1007: AND e.Element_id = P_ELEMENT_ID
1008: AND s.Set_id = c.Set_id
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
1023: WHERE s.Set_id = e.Set_Id
1024: AND e.Element_id = P_ELEMENT_ID
1025: AND s.Set_id = c.Set_id
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
1055: AND setb.Latest_Version_Flag = 'Y'
1056: AND setb.Status <> 'OBS'
1057: AND setb.Set_id = setcat.Set_id
1058: AND setcat.Category_id = denorm.Child_Category_id
1059: AND denorm.Category_Group_Id <> CS_KB_SECURITY_PVT.Get_Category_Group_Id
1060: AND NOT EXISTS (SELECT 'x'
1061: FROM CS_KB_SETS_B setb2,
1062: CS_KB_SET_CATEGORIES setcat2,
1063: CS_KB_CAT_GROUP_DENORM denorm2
1066: AND setb2.Status <> 'OBS'
1067: AND setb2.Set_id = setcat2.Set_id
1068: AND setcat2.Category_id = denorm2.Child_Category_id
1069: AND denorm2.Category_Group_Id =
1070: CS_KB_SECURITY_PVT.Get_Category_Group_Id )
1071: );
1072:
1073: l_cg_usage_count NUMBER;
1074: l_dup_id NUMBER := NULL;