[Home] [Help]
APPS.WSH_NEW_DELIVERIES_PVT dependencies on WSH_NEW_DELIVERIES_S
Line 39: SELECT wsh_new_deliveries_s.nextval
35: x_return_status OUT NOCOPY VARCHAR2
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
Line 2660: SELECT wsh_new_deliveries_s.nextval
2656: -- Generate delivery ID
2657: --
2658: CURSOR get_next_delivery
2659: IS
2660: SELECT wsh_new_deliveries_s.nextval
2661: FROM dual;
2662: --
2663: CURSOR dlvy_csr(p_delivery_id NUMBER)
2664: IS