APPS.FTE_VALIDATION_PKG dependencies on FTE_LANES

Line 892: FROM fte_lanes

888: x_status := -1;
889:
890: SELECT basis
891: INTO l_basis
892: FROM fte_lanes
893: WHERE lane_id = p_lane_id;
894:
895: IF (l_basis IS NULL) THEN
896: p_lane_tbl(p_lane_tbl.COUNT).basis_flag := false;

Line 952: FROM wsh_carrier_services s, fte_lanes l

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

Line 1357: -- Search for Lane Number in fte_lanes table

1353: FTE_UTIL_PKG.EXIT_DEBUG(l_module_name);
1354: x_status := 1;
1355: RETURN;
1356: ELSIF (p_carrier_id <> -1) THEN
1357: -- Search for Lane Number in fte_lanes table
1358: -- Vijay: added clause to check if laneId is already populated
1359: p_lane_id := FTE_LANE_PKG.GET_LANE_ID(p_lane_number, p_carrier_id);
1360: IF (p_lane_id = -1) THEN
1361: x_error_msg := FTE_UTIL_PKG.GET_MSG(p_name => 'FTE_CAT_LANE_NUMBER_INVALID',

Line 7069: -- Get a new Lane Id from the suquence "fte_lanes_s" for the new lane

7065: RETURN;
7066:
7067: ELSE
7068: --+
7069: -- Get a new Lane Id from the suquence "fte_lanes_s" for the new lane
7070: --+
7071: p_lane_tbl(l_count).lane_id := FTE_LANE_PKG.GET_NEXT_LANE_ID;
7072: p_lane_tbl(l_count).lane_number := l_lane_number;
7073: