513: l_control_rec control_rec_type;
514: l_control_id NUMBER;
515: CURSOR c_id IS
516: SELECT amw_controls_s.NEXTVAL
517: FROM DUAL;
518: CURSOR c_rev_id IS
519: SELECT amw_control_rev_s.NEXTVAL
520: FROM DUAL;
521: CURSOR c_id_exists (l_id IN NUMBER) IS
516: SELECT amw_controls_s.NEXTVAL
517: FROM DUAL;
518: CURSOR c_rev_id IS
519: SELECT amw_control_rev_s.NEXTVAL
520: FROM DUAL;
521: CURSOR c_id_exists (l_id IN NUMBER) IS
522: SELECT 1
523: FROM amw_controls_b
524: WHERE control_id = l_id;