804: RETURN NUMBER
805: IS
806: l_next_val number;
807: BEGIN
808: SELECT CS_KB_SETS_S.NEXTVAL INTO l_next_val FROM DUAL;
809: return l_next_val;
810: END;
811:
812: --Get next solution Number from sequence
814: RETURN NUMBER
815: IS
816: l_next_val number;
817: BEGIN
818: SELECT CS_KB_SET_NUMBER_S.NEXTVAL INTO l_next_val FROM DUAL;
819: return l_next_val;
820: END;
821:
822: --Get next statement ID from sequence
824: RETURN NUMBER
825: IS
826: l_next_val number;
827: BEGIN
828: SELECT CS_KB_ELEMENTS_S.NEXTVAL INTO l_next_val FROM DUAL;
829: return l_next_val;
830: END;
831:
832: --Get next statement number from sequence
834: RETURN NUMBER
835: IS
836: l_next_val number;
837: BEGIN
838: SELECT CS_KB_ELEMENT_NUMBER_S.NEXTVAL INTO l_next_val FROM DUAL;
839: return l_next_val;
840: END;
841:
842: --Get next category ID
844: RETURN NUMBER
845: IS
846: l_next_val number;
847: BEGIN
848: SELECT CS_KB_SOLN_CATEGORIES_S.NEXTVAL INTO l_next_val FROM DUAL;
849: return l_next_val;
850: END;
851:
852: FUNCTION Calculate_Set_Index_Content (P_SET_ID IN NUMBER)