DBA Data[Home] [Help]

APPS.WSH_MAPPING_DATA dependencies on WSH_CARRIER_SERVICES

Line 722: -- Added nvl to wcs.service_level and wcs.mode_of_transport because they could be NULL in wsh_carrier_services

718: x_return_status OUT NOCOPY VARCHAR2)
719: IS
720:
721: -- Bug fix 2930693
722: -- Added nvl to wcs.service_level and wcs.mode_of_transport because they could be NULL in wsh_carrier_services
723: -- bug 3479643
724: -- Created a separate cursor so that for 945 inbound, we can
725: -- use the delivery's ship method to validate the incoming ship method
726: cursor c_ship_method_cur is

Line 728: from wsh_carrier_services wcs,

724: -- Created a separate cursor so that for 945 inbound, we can
725: -- use the delivery's ship method to validate the incoming ship method
726: cursor c_ship_method_cur is
727: select wcs.ship_method_code
728: from wsh_carrier_services wcs,
729: wsh_carriers_v wcar
730: where wcar.carrier_name = p_carrier_name
731: and nvl(wcs.service_level, '!') = nvl(p_service_level, '!')
732: and nvl(wcs.mode_of_transport, '!') = nvl(p_mode_of_transport, '!')

Line 2862: from wsh_carrier_services wcs,

2858: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2859:
2860: select wc.freight_code, wcs.service_level, wcs.mode_of_transport
2861: into x_carrier_code, x_service_level, x_mode_of_transport
2862: from wsh_carrier_services wcs,
2863: wsh_carriers wc
2864: where wc.carrier_id = wcs.carrier_id
2865: and wcs.ship_method_code = p_ship_method_code;
2866: