The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT wt.trip_id,
wt.name,
wt.planned_flag,
wt.status_code,
wt.carrier_id,
wt.ship_method_code,
wt.service_level,
wt.mode_of_transport,
wt.lane_id,
wt.schedule_id,
wt.load_tender_status,
wt.tp_plan_name,
ftm.move_id
FROM wsh_trips wt, fte_trip_moves ftm
WHERE wt.trip_id = c_trip_id
AND wt.trip_id = ftm.trip_id (+) ;
SELECT fte_pricing_comp_request_s.nextval
FROM sys.dual;
SELECT auto_rate_tp_rel_trips
FROM wsh_global_parameters;
SELECT trip_id
FROM wsh_trips
WHERE name = c_trip_name;
SELECT mode_of_transportation_code
FROM fte_lanes
WHERE lane_id = c_lane_id;
SELECT mode_of_transportation_code
FROM fte_lanes l, fte_schedules s
WHERE l.lane_id = s.lane_id
AND s.schedules_id = c_schedule_id;
SELECT dl.delivery_leg_id
FROM wsh_delivery_legs dl ,
wsh_trip_stops s
WHERE dl.pick_up_stop_id = s.stop_id
and s.trip_id=c_trip_id;
PROCEDURE Delete_Main_Records(
p_trip_id IN NUMBER,
p_init_prc_log IN VARCHAR2 DEFAULT 'Y',
x_return_status OUT NOCOPY VARCHAR2) IS
l_return_status VARCHAR2(1);
SELECT t.mode_of_transport
FROM wsh_trips t
WHERE t.trip_id=c_trip_id;
FTE_FREIGHT_PRICING_UTIL.set_method(l_log_level,'Delete_Main_Records','start');
FTE_TL_RATING.Delete_Main_Records(
p_trip_id=>p_trip_id,
x_return_status=>l_return_status);
raise FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail;
FTE_FREIGHT_PRICING.delete_invalid_fc_recs (
p_segment_id => p_trip_id,
x_return_status => l_return_status ) ;
raise FTE_FREIGHT_PRICING_UTIL.g_delete_invalid_fc_failed;
FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Delete_Main_Records');
WHEN FTE_FREIGHT_PRICING_UTIL.g_tl_delete_main_rec_fail THEN
x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
FTE_FREIGHT_PRICING_UTIL.set_exception('Delete_Main_Records',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_tl_delete_main_rec_fail');
FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Delete_Main_Records');
WHEN FTE_FREIGHT_PRICING_UTIL.g_delete_invalid_fc_failed THEN
x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
FTE_FREIGHT_PRICING_UTIL.set_exception('Delete_Main_Records',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_delete_invalid_fc_failed');
FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Delete_Main_Records');
FTE_FREIGHT_PRICING_UTIL.set_exception('Delete_Main_Records',FTE_FREIGHT_PRICING_UTIL.G_ERR,'g_others');
FTE_FREIGHT_PRICING_UTIL.unset_method(l_log_level,'Delete_Main_Records');
END Delete_Main_Records;
' LAST_UPDATE_DATE :'||p_rank_rec.last_update_date);
' LAST_UPDATE_BY :'||p_rank_rec.last_updated_by);
' LAST_UPDATE_LOGIN :'||p_rank_rec.last_update_login);
SELECT v.inventory_item_id,
v.organization_id
FROM FTE_VEHICLE_TYPES v
WHERE v.vehicle_type_id=c_vehicle_type;
SELECT delivery_type
FROM wsh_new_deliveries
WHERE delivery_id=c_delivery_id;
select dl.parent_delivery_leg_id
FROM wsh_delivery_legs dl,
wsh_trip_stops s
WHERE dl.delivery_id=c_delivery_id
AND dl.parent_delivery_leg_id is not null
AND dl.pick_up_stop_id = s.stop_id
AND s.trip_id=c_trip_id;
l_lane_rank_tab.DELETE;
l_lane_rank_ref.DELETE;
l_elim_rank_tab.DELETE;
l_elim_rank_ref.DELETE;
l_rate_rank_tab.DELETE;
l_rate_rank_ref.DELETE;
l_sort_rank_tab.DELETE;
l_sort_rank_ref.DELETE;