APPS.FTE_WSH_TRIPS_PVT dependencies on FTE_TRIPS

Line 64: SELECT fte_trip_id FROM fte_trips

60: x_return_status OUT NOCOPY VARCHAR2
61: ) IS
62:
63: CURSOR check_fte_trip_id (v_trip_id NUMBER) IS
64: SELECT fte_trip_id FROM fte_trips
65: WHERE fte_trip_id = v_trip_id;
66:
67: CURSOR check_wsh_trip_id (v_trip_id NUMBER) IS
68: SELECT trip_id FROM wsh_trips

Line 194: FROM fte_trips

190: IS
191:
192: CURSOR get_status IS
193: SELECT status_code
194: FROM fte_trips
195: WHERE fte_trip_id = p_trip_id;
196:
197: x_status VARCHAR2(30);
198:

Line 295: fte_trips_pvt.get_trip_name

291: END IF;
292:
293: wsh_debug_sv.dlog (c_debug,'about to get trip name...');
294:
295: fte_trips_pvt.get_trip_name
296: (
297: p_trip_id => p_trip_info.FTE_TRIP_ID,
298: x_trip_name => l_fte_trip_name,
299: x_return_status => x_return_status

Line 403: update fte_trips

399: wsh_debug_sv.dlog (c_debug,'wsh_trip_id',p_trip_info.WSH_TRIP_ID);
400: wsh_debug_sv.dlog (c_debug,'stop count',l_stop_count);
401:
402: if (l_stop_count < 2) then
403: update fte_trips
404: set validation_required = 'Y'
405: where fte_trip_id = p_trip_info.FTE_TRIP_ID;
406:
407: -- give warning

Line 519: update fte_trips

515: if (l_connected is null or l_connected = false) then
516:
517: wsh_debug_sv.dlog (c_debug,'about to mark trip invalid...');
518:
519: update fte_trips
520: set validation_required = 'Y'
521: where fte_trip_id = p_trip_info.FTE_TRIP_ID;
522:
523: wsh_debug_sv.dlog (c_debug,'about to set warning message...');

Line 628: update fte_trips

624: if (l_connected is null or l_connected = false) then
625:
626: wsh_debug_sv.dlog (c_debug,'about to mark trip invalid...');
627:
628: update fte_trips
629: set validation_required = 'Y'
630: where fte_trip_id = p_trip_info.FTE_TRIP_ID;
631:
632: wsh_debug_sv.dlog (c_debug,'about to set warning message...');

Line 792: update fte_trips

788:
789: wsh_debug_sv.dlog (c_debug,'about to mark trip invalid...');
790:
791: --mark trip as invalid
792: update fte_trips
793: set validation_required = 'Y'
794: where fte_trip_id = p_trip_info.FTE_TRIP_ID;
795: END IF;
796:

Line 944: fte_trips_pvt.get_trip_name

940: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
941: RETURN;
942: END IF;
943:
944: fte_trips_pvt.get_trip_name
945: (
946: p_trip_id => p_fte_trip_id,
947: x_trip_name => l_fte_trip_name,
948: x_return_status => x_return_status

Line 1037: update fte_trips

1033:
1034: if ((l_next_segment_id is NOT null) AND
1035: (l_previous_segment_id is NOT null)) then
1036:
1037: update fte_trips
1038: set validation_required = 'Y'
1039: where fte_trip_id = p_fte_trip_id;
1040:
1041: -- give warning

Line 1142: update fte_trips

1138: end if;
1139:
1140: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1141: --mark trip as invalid
1142: update fte_trips
1143: set validation_required = 'Y'
1144: where fte_trip_id = p_fte_trip_id;
1145: END IF;
1146: