The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT wsc.name,
wsc.ship_confirm_rule_id,
wsc.ac_intransit_flag,
wsc.ac_close_trip_flag,
wsc.ac_bol_flag,
wsc.ac_defer_interface_flag,
wsc.report_set_id,
NVL(wsc.ship_method_default_flag, 'R'), -- frontport bug 4310141
wsc.ship_method_code,
wsc.effective_end_date,
wsc.stage_del_flag,
wsc.action_flag
FROM wsh_ship_confirm_rules wsc
WHERE ((p_rule_id IS NOT NULL AND wsc.ship_confirm_rule_id = p_rule_id)
OR (p_rule_name IS NOT NULL AND wsc.name = p_rule_name))
AND (sysdate between wsc.effective_start_date
and nvl(wsc.effective_end_date,sysdate));
SELECT rs.name
FROM wsh_report_sets rs
WHERE rs.report_set_id = p_report_set_id;
select wts.trip_id
from wsh_delivery_legs wdl,
wsh_trip_stops wts
where wdl.pick_up_stop_id = wts.stop_id
and wdl.delivery_id = l_delivery_id
and rownum=1;
SELECT ship_method_code
FROM wsh_new_deliveries
WHERE delivery_id = l_delivery_id;
SELECT wt.ship_method_code
FROM wsh_new_deliveries del,
wsh_delivery_legs dlg,
wsh_trip_stops st,
wsh_trips wt
WHERE del.delivery_id = dlg.delivery_id
AND dlg.pick_up_stop_id = st.stop_id
AND del.initial_pickup_location_id = st.stop_location_id
AND st.trip_id = wt.trip_id
AND del.delivery_id = p_delivery_id
AND rownum = 1 ;
SELECT
DELIVERY_ID
, ORGANIZATION_ID
, STATUS_CODE
, PLANNED_FLAG
, NAME
, INITIAL_PICKUP_DATE
, INITIAL_PICKUP_LOCATION_ID
, ULTIMATE_DROPOFF_LOCATION_ID
, ULTIMATE_DROPOFF_DATE
, CUSTOMER_ID
, INTMED_SHIP_TO_LOCATION_ID
, SHIP_METHOD_CODE
, DELIVERY_TYPE
, CARRIER_ID
, SERVICE_LEVEL
, MODE_OF_TRANSPORT
, shipment_direction
, party_id
, shipping_control
--Added for bug 6625788
, reason_of_transport
, description
FROM WSH_NEW_DELIVERIES
WHERE delivery_id = p_delivery_id;
PROCEDURE Create_Update_Delivery
( p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2 , -- default fnd_api.g_false
p_in_rec IN WSH_DELIVERIES_GRP.Del_In_Rec_Type,
p_rec_attr_tab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
x_del_out_rec_tab OUT NOCOPY WSH_DELIVERIES_GRP.Del_Out_Tbl_Type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2)
IS
--
l_num_warnings NUMBER := 0;
l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_DELIVERY_WRAPPER';
SAVEPOINT CREATE_UPDATE_DEL_WRAP_GRP;
WSH_DELIVERIES_GRP.Create_Update_Delivery(
p_api_version_number => p_api_version_number,
p_init_msg_list => l_init_msg_list,
p_commit => l_commit,
p_in_rec => l_in_rec,
p_rec_attr_tab => l_rec_attr_tab,
x_del_out_rec_tab => x_del_out_rec_tab,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;
wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_DELIVERY');
END Create_Update_Delivery;
SELECT released_status,
organization_id,
container_flag,
source_code,
lpn_id,
CUSTOMER_ID,
INVENTORY_ITEM_ID,
SHIP_FROM_LOCATION_ID,
SHIP_TO_LOCATION_ID,
INTMED_SHIP_TO_LOCATION_ID,
DATE_REQUESTED,
DATE_SCHEDULED,
SHIP_METHOD_CODE,
CARRIER_ID,
shipping_control,
party_id,
/*J inbound logistics: new column jckwok */
line_direction,
source_line_id,
move_order_line_id --R12, X-dock
FROM wsh_delivery_details
WHERE delivery_detail_id = p_det_id;
PROCEDURE Create_Update_Delivery_Detail
(
-- Standard Parameters
p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
-- Procedure Specific Parameters
p_detail_info_tab IN WSH_GLBL_VAR_STRCT_GRP.Delivery_Details_Attr_Tbl_Type,
p_IN_rec IN WSH_GLBL_VAR_STRCT_GRP.detailInRecType,
x_OUT_rec OUT NOCOPY WSH_GLBL_VAR_STRCT_GRP.detailOutRecType
) IS
l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Delivery_Detail';
SELECT wda.delivery_id
FROM wsh_delivery_assignments_v wda
WHERE wda.delivery_detail_id = p_detail_id;
l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_DELIVERY_DETAIL';
WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
wsh_delivery_details_grp.Create_Update_Delivery_Detail(
p_api_version_number => p_api_version_number,
p_init_msg_list => FND_API.G_FALSE,
p_commit => FND_API.G_FALSE,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_detail_info_tab => l_detail_info_tab,
p_IN_rec => l_in_rec,
x_OUT_rec => x_out_rec
);
WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Create_Update_Delivery_Detail');
END Create_Update_Delivery_Detail;
SELECT trip_id
,planned_flag
,lane_id
,load_tender_status
,status_code
,shipments_type_flag
,ignore_for_planning -- OTM R12, glog proj
FROM WSH_TRIPS
WHERE trip_id = p_trip_id;
SELECT stop_id
,status_code
,trip_id
,stop_location_id
,stop_sequence_number
,PLANNED_ARRIVAL_DATE
,PLANNED_DEPARTURE_DATE
,actual_arrival_date
,actual_departure_date
,shipments_type_flag
-- csun 10+ internal location change
,physical_location_id
,physical_stop_id
FROM WSH_TRIP_STOPS
WHERE stop_id = p_stop_id;
PROCEDURE CREATE_UPDATE_STOP(
p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_in_rec IN WSH_TRIP_STOPS_GRP.stopInRecType,
p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type,
x_stop_out_tab OUT NOCOPY WSH_TRIP_STOPS_GRP.stop_out_tab_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
l_api_version_number CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Stop';
l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_STOP';
SAVEPOINT create_update_stop_wrap_grp;
WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP(
p_api_version_number => p_api_version_number,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_in_rec => l_in_rec,
p_rec_attr_tab => l_rec_attr_tab,
x_stop_out_tab => x_stop_out_tab,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
x_stop_wt_vol_out_tab => l_stop_wt_vol_out_tab --bug 2796095
);
ROLLBACK TO create_update_stop_wrap_grp;
ROLLBACK TO create_update_stop_wrap_grp;
ROLLBACK TO create_update_stop_wrap_grp;
wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_STOP');
END Create_Update_Stop;
PROCEDURE Create_Update_Trip(
p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_trip_info_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
p_In_rec IN WSH_TRIPS_GRP.tripInRecType,
x_Out_Tab OUT NOCOPY WSH_TRIPS_GRP.trip_Out_Tab_Type) IS
l_api_version_number CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Trip';
l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'CREATE_UPDATE_TRIP';
SAVEPOINT create_update_trip_wrap_grp;
WSH_TRIPS_GRP.Create_Update_Trip(
p_api_version_number => p_api_version_number,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_trip_info_tab => l_trip_info_tab,
p_In_rec => l_In_rec,
x_Out_tab => x_Out_Tab);
ROLLBACK TO create_update_trip_wrap_grp;
ROLLBACK TO create_update_trip_wrap_grp;
ROLLBACK TO create_update_trip_wrap_grp;
wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_TRIP');
END Create_Update_Trip;
PROCEDURE Create_Update_Freight_Costs(
p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
p_freight_info_tab IN WSH_FREIGHT_COSTS_GRP.freight_rec_tab_type,
p_in_rec IN WSH_FREIGHT_COSTS_GRP.freightInRecType,
x_out_tab OUT NOCOPY WSH_FREIGHT_COSTS_GRP.freight_out_tab_type) IS
l_api_version_number CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Freight_Costs';
l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_Update_Freight_Costs';
SAVEPOINT Create_Update_Freight_Costs_WG;
WSH_FREIGHT_COSTS_GRP.Create_Update_Freight_Costs(
p_api_version_number => p_api_version_number,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_freight_info_tab => l_freight_info_tab,
p_in_rec => l_in_rec,
x_out_tab => x_out_tab );
ROLLBACK TO Create_Update_Freight_Costs_WG;
ROLLBACK TO Create_Update_Freight_Costs_WG;
ROLLBACK TO Create_Update_Freight_Costs_WG;
wsh_util_core.default_handler('WSH_INTERFACE_GRP.CREATE_UPDATE_FREIGHT_COSTS');
END Create_Update_Freight_costs;
PROCEDURE Update_Delivery_Leg(
p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_delivery_leg_tab IN WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,
p_in_rec IN WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,
x_out_rec OUT NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2) IS
l_api_version_number CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30) := 'Update_Delivery_Leg';
l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_DELIVERY_LEGS';
WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg(
p_api_version_number => p_api_version_number,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
p_delivery_leg_tab => p_delivery_leg_tab,
p_in_rec => p_in_rec,
x_out_rec => x_out_rec,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data);
wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg',l_module_name);
END Update_Delivery_Leg;