APPS.WSH_NEW_DELIVERY_ACTIONS dependencies on WSH_CARRIERS

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

2592:
2593: ---BUG No:4241880.Cursor changed
2594: CURSOR get_freight(p_ship_method_code VARCHAR2,p_organization_id NUMBER) IS
2595: SELECT freight_code
2596: FROM wsh_carriers wc,wsh_carrier_services wcs,wsh_org_carrier_services wocs
2597: WHERE wc.carrier_id=wcs.carrier_id AND
2598: wcs.carrier_service_id=wocs.carrier_service_id AND
2599: wcs.ship_method_code = p_ship_method_code AND
2600: wocs.organization_id = p_organization_id;

Line 3042: l_carrier_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;

3038: FROM wsh_exception_definitions_vl
3039: WHERE exception_name = c_exception_name
3040: AND enabled = 'Y';
3041:
3042: l_carrier_rec WSH_CARRIERS_GRP.Carrier_Service_InOut_Rec_Type;
3043: l_del_first_trip NUMBER;
3044:
3045: --bug 3314353
3046: l_pick_up_stop_sequence_num NUMBER;

Line 6032: WSH_CARRIERS_GRP.get_carrier_service_mode(

6028:
6029: l_carrier_rec.ship_method_code := p_ship_method;
6030:
6031:
6032: WSH_CARRIERS_GRP.get_carrier_service_mode(
6033: p_carrier_service_inout_rec => l_carrier_rec,
6034: x_return_status => l_return_status);
6035:
6036: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN

Line 6209: WSH_CARRIERS_GRP.get_carrier_service_mode(

6205: IF p_ship_method IS NOT NULL THEN
6206:
6207: l_carrier_rec.ship_method_code := p_ship_method;
6208:
6209: WSH_CARRIERS_GRP.get_carrier_service_mode(
6210: p_carrier_service_inout_rec => l_carrier_rec,
6211: x_return_status => l_return_status);
6212:
6213: IF l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN