36: ) IS
37:
38: CURSOR get_next_delivery IS
39: SELECT wsh_new_deliveries_s.nextval
40: FROM sys.dual;
41:
42: CURSOR count_delivery_rows (v_delivery_name VARCHAR2) IS
43: SELECT delivery_id
44: FROM wsh_new_deliveries
2637: --
2638: CURSOR get_next_delivery
2639: IS
2640: SELECT wsh_new_deliveries_s.nextval
2641: FROM dual;
2642: --
2643: CURSOR dlvy_csr(p_delivery_id NUMBER)
2644: IS
2645: SELECT rowid