The following lines contain the word 'select', 'insert', 'update' or 'delete':
-- If p_service_action indicates service is currently assigned, delete old rates
-- and raise appropriate business event
IF ( p_service_action = 'UPDATE' AND l_trip_id IS NOT NULL
AND l_delivery_leg_id IS NULL ) THEN
IF l_debug_on THEN
WSH_DEBUG_SV.logmsg(l_module_name, 'Deleting Main Records for:'||l_trip_id);
FTE_TRIP_RATING_GRP.DELETE_MAIN_RECORDS(
p_trip_id => l_trip_id,
x_return_status => l_return_status);
-- CREATE: Manual condition, set IS_CURRENT for selected service
-- SET_CURRENT: Only pass user entry as current. Version is increased. Do no
-- pass service tab, only rankId
-- APPEND: Pass in one record service tab (entry has no rankId or sequence)
-- Entry appended to existing list with next ranked seq. Set IS_CURRENT on record.
-- OUT param is the new rankId to be stored on the trip
IF ( l_list_action IS NOT NULL AND l_trip_id IS NOT NULL) THEN
IF ( p_list_action = 'SET_CURRENT' ) THEN
FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION_UIWRAPPER(
p_API_VERSION_NUMBER => 1.0,
p_INIT_MSG_LIST => FND_API.G_TRUE,
p_ACTION_CODE => l_list_action,
p_RANKLIST => p_ss_rate_sort_tab,
p_RANK_ID => l_rank_id,
p_TRIP_ID => l_trip_id,
x_RETURN_STATUS => l_return_status,
x_MSG_COUNT => l_msg_count,
x_MSG_DATA => l_msg_data);
-- Step 4: Update Trip
-- If delivery_id is null, this call is coming from TripWB. Update Trip with
-- current service from FTE_SS_ATTR_REC and rank id.
-- Else this call is coming from DWB or MI. Update Trip with Rank Id only.
IF (l_delivery_id IS NULL ) THEN -- Coming from TWB
l_lane_id := p_ss_attr_rec.lane_id;
FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP(
p_API_VERSION_NUMBER => 1.0,
p_INIT_MSG_LIST => FND_API.G_TRUE,
p_COMMIT => FND_API.G_FALSE,
p_CALLER => 'FTE',
p_SERVICE_ACTION => p_service_action,
p_DELIVERY_ID => l_delivery_id,
p_DELIVERY_LEG_ID => l_delivery_leg_id,
p_TRIP_ID => l_trip_id,
p_LANE_ID => l_lane_id,
p_SCHEDULE_ID => null, -- Need to change to real schedule
p_CARRIER_ID => l_carrier_id,
p_SERVICE_LEVEL => l_service_level,
p_MODE_OF_TRANSPORT => l_mode,
p_VEHICLE_ITEM_ID => l_veh_item_id,
p_VEHICLE_ORG_ID => l_veh_org_id,
p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
x_RETURN_STATUS => l_return_status,
x_MSG_COUNT => l_msg_count,
x_MSG_DATA => l_msg_data);
FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP(
p_API_VERSION_NUMBER => 1.0,
p_INIT_MSG_LIST => FND_API.G_TRUE,
p_COMMIT => FND_API.G_FALSE,
p_CALLER => 'FTE',
p_SERVICE_ACTION => p_service_action,
p_DELIVERY_ID => l_delivery_id,
p_DELIVERY_LEG_ID => l_delivery_leg_id,
p_TRIP_ID => l_trip_id,
p_LANE_ID => FND_API.G_MISS_NUM,
p_SCHEDULE_ID => FND_API.G_MISS_NUM,
p_CARRIER_ID => FND_API.G_MISS_NUM,
p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
p_VEHICLE_ORG_ID => FND_API.G_MISS_NUM,
p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
x_RETURN_STATUS => l_return_status,
x_MSG_COUNT => l_msg_count,
x_MSG_DATA => l_msg_data);