APPS.FTE_MLS_TEST_NT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 98

	-- 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);

Line: 107

		FTE_TRIP_RATING_GRP.DELETE_MAIN_RECORDS(
			p_trip_id => l_trip_id,
			x_return_status => l_return_status);

Line: 154

	-- 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);

Line: 198

	-- 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;

Line: 213

	  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);

Line: 236

	  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);