The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT freight_cost_type_id INTO x_freight_cost_type_id
FROM wsh_freight_cost_types
WHERE name = p_freight_cost_type;
SELECT freight_cost_type_id INTO l_type_id
FROM wsh_freight_cost_types
WHERE freight_cost_type_id = x_freight_cost_type_id;
PROCEDURE Delete_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_pub_freight_costs IN WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType
)
IS
l_return_status VARCHAR2(30);
WSH_FREIGHT_COSTS_PVT.Delete_freight_cost(
p_rowid => NULL,
p_freight_cost_id => p_pub_freight_costs.freight_cost_id,
x_return_status => x_return_status);
END Delete_Freight_Costs;
x_pvt_freight_rec.LAST_UPDATE_DATE := p_pub_freight_rec.LAST_UPDATE_DATE;
x_pvt_freight_rec.LAST_UPDATED_BY := p_pub_freight_rec.LAST_UPDATED_BY;
x_pvt_freight_rec.LAST_UPDATE_LOGIN := p_pub_freight_rec.LAST_UPDATE_LOGIN;
x_pvt_freight_rec.PROGRAM_UPDATE_DATE := p_pub_freight_rec.PROGRAM_UPDATE_DATE;
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_pub_freight_costs IN WSH_FREIGHT_COSTS_PUB.PubFreightCostRecType
, p_action_code IN VARCHAR2
, x_freight_cost_id OUT NOCOPY NUMBER) IS
l_debug_on BOOLEAN;
l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'Create_Update_Freight_Costs';
l_api_name CONSTANT VARCHAR2(30) := 'Create_Update_Freight_Costs';
wsh_debug_sv.push (l_module_name, 'Create_Update_Freight_Costs');
WSH_INTERFACE_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 => l_out_tab );
wsh_util_core.default_handler ('WSH_TRIP_STOPS_GRP.CREATE_UPDATE_STOP');
END Create_Update_Freight_Costs;