714:
715: --Verify that the carrier has the correct service level
716: BEGIN
717: SELECT service_level INTO l_temp_char
718: FROM WSH_CARRIER_SERVICES
719: WHERE carrier_id = l_carrier_id
720: AND service_level = l_service_code
721: AND enabled_flag = 'Y'
722: AND rownum = 1;
940: l_result VARCHAR2(10);
941: l_numfetch NUMBER;
942: CURSOR GET_CARRIER_SERVICE (p_carrier_id IN NUMBER, p_service_code IN VARCHAR2, p_mode IN VARCHAR2) IS
943: SELECT 'true'
944: FROM wsh_carrier_services s
945: WHERE s.carrier_id = p_carrier_id
946: AND s.mode_of_transport = p_mode
947: AND s.service_level = p_service_code
948: AND nvl(s.enabled_flag,'N') = 'Y';
948: AND nvl(s.enabled_flag,'N') = 'Y';
949:
950: CURSOR GET_CARRIER_SERVICE2 (p_lane_id IN NUMBER, p_service_code IN VARCHAR2) IS
951: SELECT 'true'
952: FROM wsh_carrier_services s, fte_lanes l
953: WHERE s.carrier_id = l.carrier_id
954: AND s.mode_of_transport=l.mode_of_transportation_code
955: AND l.lane_id = p_lane_id
956: AND s.service_level = p_service_code
1701: x_error_msg OUT NOCOPY VARCHAR2) IS
1702:
1703: CURSOR GET_CARRIER_MODE (p_carrier_id IN NUMBER, p_mode IN VARCHAR2) IS
1704: SELECT mode_of_transport
1705: FROM wsh_carrier_services
1706: WHERE carrier_id = p_carrier_id
1707: AND mode_of_transport = p_mode
1708: AND nvl(enabled_flag,'N') = 'Y';
1709: