848: ) RETURN VARCHAR2 IS
849:
850: CURSOR Check_Name_Exists IS
851: SELECT count(*)
852: FROM CS_KB_CATEGORY_GROUPS_VL
853: WHERE name = P_NAME
854: AND category_group_id <> P_CATEGORY_GROUP_ID;
855:
856: l_count NUMBER :=0;
1135: l_login NUMBER := FND_GLOBAL.login_id;
1136:
1137: CURSOR Check_Update IS
1138: SELECT COUNT(*)
1139: FROM CS_KB_CATEGORY_GROUPS_VL
1140: WHERE CATEGORY_GROUP_ID = P_CATEGORY_GROUP_ID
1141: AND NAME = P_NAME;
1142:
1143: BEGIN
1296:
1297:
1298: CURSOR CHECK_DELETE IS
1299: SELECT count(*)
1300: FROM CS_KB_CATEGORY_GROUPS_VL
1301: WHERE category_group_id = P_CATEGORY_GROUP_ID;
1302:
1303: CURSOR CHECK_MEMBERS IS
1304: SELECT count(*)