APPS.CS_KB_ELEMENTS_AUDIT_PKG dependencies on CS_KB_SETS_B

Line 925: UPDATE cs_kb_sets_b

921: x_end_active_date => p_end_active_date,
922: x_content_type => p_content_type );
923:
924: -- Mark the Solutions as updated
925: UPDATE cs_kb_sets_b
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

Line 989: FROM CS_KB_SETS_B s,

985: WHERE Element_id = P_ELEMENT_ID;
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

Line 1002: FROM CS_KB_SETS_B s,

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
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

Line 1019: FROM CS_KB_SETS_B s,

1015: AND se.element_id = v_dup_id);
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

Line 1049: FROM CS_KB_SETS_B setb,

1045: AND e.Element_id = P_ELEMENT_ID
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

Line 1061: FROM CS_KB_SETS_B setb2,

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
1064: WHERE setb2.set_id = setb.Set_Id
1065: AND setb2.Latest_Version_Flag = 'Y'

Line 1402: FROM CS_KB_SETS_B S,

1398: SELECT E.element_id
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'