APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_CARRIERS

Line 2565: FROM wsh_carriers wc,wsh_carrier_services wcs,wsh_org_carrier_services wocs

2561:
2562: ---BUG No:4241880.Cursor changed
2563: CURSOR get_freight(p_ship_method_code VARCHAR2,p_organization_id NUMBER) IS
2564: SELECT freight_code
2565: FROM wsh_carriers wc,wsh_carrier_services wcs,wsh_org_carrier_services wocs
2566: WHERE wc.carrier_id=wcs.carrier_id AND
2567: wcs.carrier_service_id=wocs.carrier_service_id AND
2568: wcs.ship_method_code = p_ship_method_code AND
2569: wocs.organization_id = p_organization_id;

Line 3002: l_carrier_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;

2998: FROM wsh_exception_definitions_vl
2999: WHERE exception_name = c_exception_name
3000: AND enabled = 'Y';
3001:
3002: l_carrier_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;
3003: l_del_first_trip NUMBER;
3004:
3005: --bug 3314353
3006: l_pick_up_stop_sequence_num NUMBER;

Line 5931: WSH_CARRIERS_GRP.get_carrier_service_mode(

5927:
5928: l_carrier_rec.ship_method_code := p_ship_method;
5929:
5930:
5931: WSH_CARRIERS_GRP.get_carrier_service_mode(
5932: p_carrier_service_inout_rec => l_carrier_rec,
5933: x_return_status => l_return_status);
5934:
5935: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 6108: WSH_CARRIERS_GRP.get_carrier_service_mode(

6104: IF p_ship_method IS NOT NULL THEN
6105:
6106: l_carrier_rec.ship_method_code := p_ship_method;
6107:
6108: WSH_CARRIERS_GRP.get_carrier_service_mode(
6109: p_carrier_service_inout_rec => l_carrier_rec,
6110: x_return_status => l_return_status);
6111:
6112: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN