APPS.FTE_TRIPS_PVT dependencies on FTE_TRIPS_S

Line 219: SELECT fte_trips_s.nextval

215: x_return_status OUT NOCOPY VARCHAR2
216: ) IS
217:
218: CURSOR get_next_trip IS
219: SELECT fte_trips_s.nextval
220: FROM sys.dual;
221:
222: CURSOR check_trip_names (v_trip_name VARCHAR2) IS
223: SELECT fte_trip_id FROM fte_trips

Line 515: UPDATE fte_trips SET

511: RETURN;
512: END IF;
513:
514:
515: UPDATE fte_trips SET
516: fte_trip_id = decode(p_trip_info.fte_trip_id,FND_API.G_MISS_NUM, fte_trip_id, p_trip_info.fte_trip_id),
517: name = decode(p_trip_info.name, FND_API.G_MISS_CHAR, name, p_trip_info.name),
518: status_code = decode(p_trip_info.status_code, FND_API.G_MISS_CHAR, status_code, p_trip_info.status_code),
519: private_trip=decode(p_trip_info.private_trip, FND_API.G_MISS_CHAR, NULL, p_trip_info.private_trip),

Line 786: UPDATE FTE_TRIPS SET validation_required='Y'

782: if ((l_segment_sequencenum_prev=l_segment_sequencenum_next)) then
783:
784: wsh_debug_sv.dlog (c_debug,'segment number unique check');
785:
786: UPDATE FTE_TRIPS SET validation_required='Y'
787: where fte_trip_id=p_trip_id;
788:
789: IF (SQL%NOTFOUND) THEN
790: RAISE no_data_found;

Line 827: UPDATE FTE_TRIPS SET validation_required='Y'

823:
824: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
825: wsh_debug_sv.dlog (c_debug,'could not get 1st stop location');
826: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
827: UPDATE FTE_TRIPS SET validation_required='Y'
828: where fte_trip_id=p_trip_id;
829: IF (SQL%NOTFOUND) THEN
830: RAISE no_data_found;
831: END IF;

Line 855: UPDATE FTE_TRIPS SET validation_required='Y'

851: --1. segment shud have atleast 2 stops
852: if ((trip_stops%ROWCOUNT<2)) then
853: CLOSE trip_stops;
854: wsh_debug_sv.dlog (c_debug,'segment shud have atleast 2 stops');
855: UPDATE FTE_TRIPS SET validation_required='Y'
856: where fte_trip_id=p_trip_id;
857:
858: IF (SQL%NOTFOUND) THEN
859: RAISE no_data_found;

Line 882: UPDATE FTE_TRIPS SET validation_required='Y'

878:
879: --2.origin of 1st segment=dest. of next segment
880: if ((l_count>1) AND (l_segment_dest<>l_segment_origin)) then
881: wsh_debug_sv.dlog (c_debug,'origin of 1st segment!=dest. of next segment');
882: UPDATE FTE_TRIPS SET validation_required='Y'
883: where fte_trip_id=p_trip_id;
884: IF (SQL%NOTFOUND) THEN
885: RAISE no_data_found;
886: END IF;

Line 920: UPDATE FTE_TRIPS SET validation_required='Y'

916: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
917: wsh_debug_sv.dlog (c_debug,'could not get last stop location');
918: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
919:
920: UPDATE FTE_TRIPS SET validation_required='Y'
921: where fte_trip_id=p_trip_id;
922: IF (SQL%NOTFOUND) THEN
923: RAISE no_data_found;
924: END IF;

Line 936: UPDATE FTE_TRIPS SET validation_required='N'

932: END LOOP;
933:
934: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
935: wsh_debug_sv.dlog (c_debug,'validation success');
936: UPDATE FTE_TRIPS SET validation_required='N'
937: where fte_trip_id=p_trip_id;
938: IF (SQL%NOTFOUND) THEN
939: RAISE no_data_found;
940: END IF;