326: -- clear any charges entered in SO_FREIGHT_CHARGES
327: delete from so_freight_charges
328: where delivery_id = del_id;
329:
330: -- clear any container entered in WSH_PACKED_CONTAINERS
331: delete from wsh_packed_containers
332: where delivery_id = del_id;
333:
334: OPEN c1(del_id);
327: delete from so_freight_charges
328: where delivery_id = del_id;
329:
330: -- clear any container entered in WSH_PACKED_CONTAINERS
331: delete from wsh_packed_containers
332: where delivery_id = del_id;
333:
334: OPEN c1(del_id);
335: FETCH c1 INTO dep_id;