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:
68: INSERT INTO cn_calc_submission_batches_all
69: ( calc_sub_batch_id,
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;
735: END get_calc_sub_batch_id;
736: