DBA Data[Home] [Help]

APPS.CSK_SETUP_UTILITY_PKG dependencies on DUAL

Line 808: SELECT CS_KB_SETS_S.NEXTVAL INTO l_next_val FROM DUAL;

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

Line 818: SELECT CS_KB_SET_NUMBER_S.NEXTVAL INTO l_next_val FROM DUAL;

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

Line 828: SELECT CS_KB_ELEMENTS_S.NEXTVAL INTO l_next_val FROM DUAL;

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

Line 838: SELECT CS_KB_ELEMENT_NUMBER_S.NEXTVAL INTO l_next_val FROM DUAL;

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

Line 848: SELECT CS_KB_SOLN_CATEGORIES_S.NEXTVAL INTO l_next_val FROM DUAL;

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)