APPS.CS_KB_SECURITY_PVT dependencies on CS_KB_CATEGORY_GROUPS_B

Line 941: FROM CS_KB_CATEGORY_GROUPS_B

937: l_seq NUMBER;
938:
939: CURSOR Check_Insert (v_cg_id NUMBER) IS
940: SELECT COUNT(*)
941: FROM CS_KB_CATEGORY_GROUPS_B
942: WHERE CATEGORY_GROUP_ID = v_cg_id;
943:
944: BEGIN
945:

Line 960: SELECT CS_KB_CATEGORY_GROUPS_B_S.nextval INTO l_seq from dual;

956: RAISE INVALID_IN_PARAMETERS;
957: ELSE
958:
959: IF P_CATEGORY_GROUP_ID IS NULL THEN
960: SELECT CS_KB_CATEGORY_GROUPS_B_S.nextval INTO l_seq from dual;
961: ELSE
962: l_seq := P_CATEGORY_GROUP_ID;
963: END IF;
964:

Line 1593: FROM CS_KB_CATEGORY_GROUPS_B

1589: AND CATEGORY_ID = v_cat_id;
1590:
1591: CURSOR Validate_Category_Group IS
1592: SELECT count(*)
1593: FROM CS_KB_CATEGORY_GROUPS_B
1594: WHERE category_group_id = P_CATEGORY_GROUP_ID;
1595:
1596: CURSOR Validate_Category IS
1597: SELECT count(*)

Line 2593: FROM CS_KB_CATEGORY_GROUPS_B

2589: AND b.visibility_id = v.visibility_id;
2590:
2591: CURSOR GET_CATEGORY_GROUPS IS
2592: SELECT Category_Group_Id
2593: FROM CS_KB_CATEGORY_GROUPS_B
2594: WHERE sysdate BETWEEN nvl(start_date_active, sysdate-1)
2595: AND nvl(end_date_active, sysdate+1);
2596:
2597: --Type NumTabType is VARRAY(10000) of NUMBER;

Line 2698: FROM CS_KB_CATEGORY_GROUPS_B

2694: RETURN NUMBER IS
2695:
2696: CURSOR GET_CATEGORY_GROUP IS
2697: SELECT Category_Group_Id
2698: FROM CS_KB_CATEGORY_GROUPS_B
2699: WHERE Category_Group_id = fnd_profile.value('CS_KB_ASSIGNED_CATEGORY_GROUP')
2700: AND sysdate BETWEEN nvl(Start_Date_Active, sysdate-1)
2701: AND nvl(End_Date_Active, sysdate+1);
2702: