165: CURSOR c_check_del_manifesting(c_delivery_id NUMBER)
166: IS
167: SELECT count(a.delivery_id)
168: FROM wsh_new_deliveries a,
169: mtl_parameters b,
170: wsh_carriers c
171: WHERE a.organization_id = b.organization_id
172: AND a.carrier_id = c.carrier_id
173: AND c.manifesting_enabled_flag = 'Y'
178: CURSOR c_check_del_manifesting2(c_trip_id NUMBER)
179: IS
180: SELECT count(a.delivery_id)
181: FROM wsh_new_deliveries a,
182: mtl_parameters b,
183: wsh_carriers c
184: WHERE a.organization_id = b.organization_id
185: AND a.carrier_id = c.carrier_id
186: AND c.manifesting_enabled_flag = 'Y'
205: CURSOR c_get_del_manifest_enabled(c_delivery_id NUMBER)
206: IS
207: SELECT b.carrier_manifesting_flag
208: FROM wsh_new_deliveries a,
209: mtl_parameters b
210: WHERE a.organization_id = b.organization_id
211: AND a.delivery_id = c_delivery_id;
212: --
213: CURSOR c_carrier_services(c_shp_mthd_cd VARCHAR2)