The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NVL(shipping_control,'BUYER'), ship_from_location_id,
line_direction, released_status
FROM wsh_delivery_details
WHERE delivery_detail_Id = l_detail_id;
SELECT NVL(shipping_control, 'BUYER'),
INITIAL_PICKUP_LOCATION_ID,
status_code,
shipment_direction
FROM wsh_new_deliveries
WHERE delivery_Id = l_delivery_id;
select wts.TRIP_ID
from wsh_trip_stops wts, wsh_delivery_legs wdl
where wdl.delivery_id =l_deliveryid AND
wdl.pick_up_stop_id = wts.stop_id;
select delivery_type
from wsh_new_deliveries
WHERE delivery_Id = l_deliveryid;
select wda.delivery_id
from wsh_delivery_assignments_v wda
where wda.delivery_detail_id=l_deldetailid;
select compatibility_id
from wsh_fte_comp_constraints
where EFFECTIVE_DATE_FROM <= sysdate
and nvl(EFFECTIVE_DATE_TO,sysdate) >= sysdate
and rownum = 1;
IF p_action_code = 'UPDATE' THEN
l_cc_action_code:='UPD';
ELSIF p_action_code = 'SELECT-CARRIER' THEN
l_cc_action_code:='ACS';
--following check for update deldetail is not needed as of now
IF p_action_code='UPDATE' THEN
l_cc_action_code:='UPD';
IF p_action_code ='UPDATE' THEN
l_cc_action_code:='UPT';
IF p_action_code ='UPDATE' THEN
l_cc_action_code:='UPS';
ELSIF p_action_code ='DELETE' THEN
l_cc_action_code:='DTS';
SELECT TRIP_ID
, 'Y'
, NAME
, PLANNED_FLAG
, STATUS_CODE
, VEHICLE_ITEM_ID
, VEHICLE_NUMBER
, CARRIER_ID
, SHIP_METHOD_CODE
, VEHICLE_ORGANIZATION_ID
, VEHICLE_NUM_PREFIX
, SERVICE_LEVEL
, MODE_OF_TRANSPORT
FROM wsh_trips
WHERE trip_id = c_trip_id;
SELECT PARENT_DELIVERY_LEG_ID
FROM wsh_delivery_legs
WHERE DELIVERY_LEG_ID = c_del_leg_id
AND DELIVERY_ID = c_del_id;