59:
60: IF p_calc_sub_batch_id IS NOT NULL THEN
61: l_calc_sub_batch_id := p_calc_sub_batch_id;
62: ELSE
63: SELECT cn_calc_submission_batches_s1.NEXTVAL
64: INTO l_calc_sub_batch_id
65: FROM dual;
66: END IF;
67:
726: --+
727: FUNCTION get_calc_sub_batch_id RETURN NUMBER IS
728: l_calc_sub_batch_id NUMBER(15);
729: BEGIN
730: SELECT cn_calc_submission_batches_s1.nextval
731: INTO l_calc_sub_batch_id
732: FROM sys.dual;
733:
734: RETURN l_calc_sub_batch_id;