APPS.FTE_DELIVERY_ACTIVITY SQL Statements

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

Line: 44

    select wsh_delivery_leg_activities_s.nextval into s_activity_id from dual;

Line: 46

    insert into wsh_delivery_leg_activities
        (ACTIVITY_ID, DELIVERY_LEG_ID, ACTIVITY_DATE, ACTIVITY_TYPE, CREATION_DATE, CREATED_BY,
         LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN,
         ACTION_BY, ACTION_BY_NAME, REMARKS, RESULT_STATUS, INITIAL_STATUS, TRIP_ID,CARRIER_ID,MODE_OF_TRANSPORT,SERVICE_LEVEL) values
        (s_activity_id, p_delivery_leg_id, p_activity_date, p_activity_type, sysdate, -1,
         sysdate, -1, 1,
         p_action_by, p_action_by_name, p_remarks, p_result_status, p_initial_status, p_trip_id,p_carrier_id,p_mode_of_transport,p_service_level);

Line: 92

select wdl.delivery_id delivery_id, wdl.delivery_leg_id delivery_leg_id ,
wt.carrier_id carrier_id, wt.mode_of_transport mode_of_transport , wt.service_level service_level
from wsh_delivery_legs wdl, wsh_trip_stops wts,wsh_trips wt
where wdl.pick_up_stop_id = wts.stop_id
and wts.trip_id = p_trip_id
and wt.trip_id= p_trip_id;

Line: 152

	SELECT wdl.delivery_id delivery_id, wdl.delivery_leg_id delivery_leg_id ,
		wt.carrier_id carrier_id, wt.mode_of_transport mode_of_transport ,
		wt.service_level service_level, wt.wf_item_key, wt.rank_id
	FROM wsh_delivery_legs wdl, wsh_trip_stops wts,wsh_trips wt
	WHERE wdl.pick_up_stop_id = wts.stop_id
	AND wts.trip_id = c_trip_id
	AND wt.trip_id= c_trip_id ;

Line: 187

	    SELECT wsh_delivery_leg_activities_s.nextval into s_activity_id FROM DUAL;

Line: 190

	       WSH_DEBUG_SV.logmsg(l_module_name,'Inserting',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line: 196

	    INSERT INTO wsh_delivery_leg_activities
		(	ACTIVITY_ID,
			DELIVERY_LEG_ID,
			ACTIVITY_DATE,
			ACTIVITY_TYPE,
			CREATION_DATE,
			CREATED_BY,
		 	LAST_UPDATE_DATE,
		 	LAST_UPDATED_BY,
		 	LAST_UPDATE_LOGIN,
		 	ACTION_BY,
		 	ACTION_BY_NAME,
		 	REMARKS,
		 	RESULT_STATUS,
		 	INITIAL_STATUS,
		 	TRIP_ID,
		 	CARRIER_ID,
		 	MODE_OF_TRANSPORT,
		 	SERVICE_LEVEL,
		 	RANK_ID,
		 	RANK_VERSION,
		 	WF_ITEM_KEY)
	     VALUES
		(	s_activity_id,
			c_rec.delivery_leg_id,
			SYSDATE,
			p_delivery_leg_activity_rec.activity_type,
			SYSDATE,
			FND_GLOBAL.USER_ID, -- created by
		 	SYSDATE, -- last update date
		 	FND_GLOBAL.USER_ID, -- last updatd by
		 	FND_GLOBAL.USER_ID, -- last upd login
		 	p_delivery_leg_activity_rec.action_by,
		 	p_delivery_leg_activity_rec.action_by_name,
		 	p_delivery_leg_activity_rec.remarks,
		 	p_delivery_leg_activity_rec.result_status,
		 	p_delivery_leg_activity_rec.initial_status,
		 	p_delivery_leg_activity_rec.trip_id,
		 	c_rec.carrier_id,
		 	c_rec.mode_of_transport,
		 	c_rec.service_level,
		 	p_delivery_leg_activity_rec.rank_id,
		 	p_delivery_leg_activity_rec.rank_version,
		 	p_delivery_leg_activity_rec.wf_item_key);