230: IF (sql%notfound) THEN
231: raise no_data_found;
232: END IF;
233:
234: DELETE cn_calc_submission_entries_all
235: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
236:
237: DELETE cn_calc_sub_quotas_all
238: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
746: -- 10-JUL-98 Richard Jin Created
747: --+
748: PROCEDURE delete_calc_sub_batch (p_calc_sub_batch_id NUMBER) IS
749: BEGIN
750: DELETE cn_calc_submission_entries_all
751: WHERE calc_sub_batch_id = p_calc_sub_batch_id;
752:
753: DELETE cn_calc_sub_quotas_all
754: WHERE calc_sub_batch_id = p_calc_sub_batch_id;