eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_TRIPS_PVT SQL Statements

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

Line: 14


 PROCEDURE Create_Update_Delete_Fte_Trip
		(
 		p_api_version_number     IN   NUMBER,
		p_init_msg_list          IN   VARCHAR2,
		x_msg_count              OUT NOCOPY  NUMBER,
		x_msg_data               OUT NOCOPY  VARCHAR2,
		 pp_FTE_TRIP_ID                        IN      NUMBER DEFAULT FND_API.G_MISS_NUM,
		 pp_NAME                               IN      VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_STATUS_CODE                        IN      VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_PRIVATE_TRIP                       IN      VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		pp_VALIDATION_REQUIRED                IN      VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_CREATION_DATE                      IN      DATE DEFAULT FND_API.G_MISS_DATE,
		 pp_CREATED_BY                         IN      NUMBER DEFAULT FND_API.G_MISS_NUM,
		 pp_LAST_UPDATE_DATE                   IN      DATE DEFAULT FND_API.G_MISS_DATE,
		 pp_LAST_UPDATED_BY                    IN      NUMBER DEFAULT FND_API.G_MISS_NUM,
		 pp_LAST_UPDATE_LOGIN                  IN      NUMBER DEFAULT FND_API.G_MISS_NUM,
		 pp_PROGRAM_APPLICATION_ID             IN      NUMBER DEFAULT FND_API.G_MISS_NUM,
		 pp_PROGRAM_ID                         IN      NUMBER DEFAULT FND_API.G_MISS_NUM,
		 pp_PROGRAM_UPDATE_DATE                IN      DATE DEFAULT FND_API.G_MISS_DATE,
		 pp_REQUEST_ID                         IN      NUMBER DEFAULT FND_API.G_MISS_NUM,
		 pp_ATTRIBUTE_CATEGORY                 IN      VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_ATTRIBUTE1                         IN      VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_ATTRIBUTE2                         IN      VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_ATTRIBUTE3                         IN      VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_ATTRIBUTE4                         IN      VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_ATTRIBUTE5                        IN       VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_ATTRIBUTE6                         IN      VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_ATTRIBUTE7                         IN      VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_ATTRIBUTE8                        IN       VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_ATTRIBUTE9                        IN       VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_ATTRIBUTE10                       IN       VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_ATTRIBUTE11                       IN       VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_ATTRIBUTE12                       IN       VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_ATTRIBUTE13                       IN       VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_ATTRIBUTE14                       IN       VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_ATTRIBUTE15                       IN       VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
		 pp_ROUTE_ID                          IN       NUMBER DEFAULT FND_API.G_MISS_NUM,
		 p_action_code			   IN 	    VARCHAR2,
		 x_trip_id		OUT NOCOPY	NUMBER,
		 x_name             OUT NOCOPY  VARCHAR2,
		 x_return_status	OUT NOCOPY	VARCHAR2
		) IS
  -- 
  l_api_version_number CONSTANT NUMBER := 1.0;

Line: 58


  l_api_name           CONSTANT VARCHAR2(30):= 'Create_Update_Fte_Trip';

Line: 72


      wsh_debug_sv.dpush (c_sdebug, 'Create_Update_Delete_Fte_Trip');

Line: 104


		 p_trip_info.LAST_UPDATE_DATE       :=pp_last_update_date;

Line: 105


		 p_trip_info.LAST_UPDATED_BY        :=pp_last_updated_by;

Line: 106


		 p_trip_info.LAST_UPDATE_LOGIN      :=pp_last_update_login;

Line: 109


		 p_trip_info.PROGRAM_UPDATE_DATE    :=pp_program_update_date;

Line: 136


	elsif (p_action_code='UPDATE') then
	  	Update_Trip
		(p_trip_info		=>p_trip_info,
		 x_return_status 	=>x_return_status);

Line: 140


	elsif (p_action_code='DELETE') then
 		Delete_Trip(p_trip_id	=>p_trip_info.fte_trip_id,
  		x_return_status	=>x_return_status);

Line: 168


      wsh_debug_sv.dlog (c_debug,'In error in Create_Update_Delete');

Line: 181


      wsh_debug_sv.dlog (c_debug,'In Unexpected error in Create_Update_Delete');

Line: 186


	   wsh_util_core.default_handler('FTE_TRIPS_PVT.Create_Update_Delete_Fte_Trip');

Line: 193


      wsh_debug_sv.dlog (c_debug,'In others in Create_Update_Delete');

Line: 197


  END Create_Update_Delete_Fte_Trip;

Line: 219


    SELECT fte_trips_s.nextval
    FROM sys.dual;

Line: 223


  SELECT fte_trip_id FROM fte_trips
  WHERE name = v_trip_name;

Line: 227


  SELECT fte_trip_id FROM fte_trips
  WHERE fte_trip_id = v_trip_id;

Line: 319


      wsh_debug_sv.dlog (c_debug,'about to insert into fte_trips table...');

Line: 323


  INSERT INTO fte_trips(
 FTE_TRIP_ID         ,
 NAME               ,
 STATUS_CODE         ,
 PRIVATE_TRIP        ,
 VALIDATION_REQUIRED ,
 CREATION_DATE       ,
 CREATED_BY          ,
 LAST_UPDATE_DATE    ,
 LAST_UPDATED_BY     ,
 LAST_UPDATE_LOGIN   ,
 PROGRAM_APPLICATION_ID ,
 PROGRAM_ID             ,
 PROGRAM_UPDATE_DATE    ,
 REQUEST_ID             ,
 ATTRIBUTE_CATEGORY     ,
 ATTRIBUTE1             ,
 ATTRIBUTE2             ,
 ATTRIBUTE3             ,
 ATTRIBUTE4             ,
 ATTRIBUTE5             ,
 ATTRIBUTE6             ,
 ATTRIBUTE7             ,
 ATTRIBUTE8             ,
 ATTRIBUTE9             ,
 ATTRIBUTE10            ,
 ATTRIBUTE11            ,
 ATTRIBUTE12            ,
 ATTRIBUTE13            ,
 ATTRIBUTE14            ,
 ATTRIBUTE15            ,
 ROUTE_ID
 )
 VALUES(
    x_trip_id,
    x_name,
    'OP',
    decode(p_trip_info.private_trip, FND_API.G_MISS_CHAR, NULL, p_trip_info.private_trip),
    decode(p_trip_info.validation_required, FND_API.G_MISS_CHAR, NULL, p_trip_info.validation_required),
    decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
    decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
    decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
    decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
    decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
    decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
    decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
    decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
    decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
    decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
    decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
    decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
    decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
    decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
    decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
    decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
    decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
    decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
    decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
    decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
    decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
    decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),
    decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),
    decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),
    decode(p_trip_info.attribute15, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute15),
    decode(p_trip_info.route_id, FND_API.G_MISS_NUM, NULL, p_trip_info.route_id)
  );

Line: 390


      wsh_debug_sv.dlog (c_debug,'right after insert statement---');

Line: 425


  SELECT fte_trip_id FROM fte_trips
  WHERE name = v_trip_name;

Line: 487


PROCEDURE Update_Trip(
	p_trip_info		IN	fte_trip_rec_type,
	x_return_status 	OUT NOCOPY 	VARCHAR2) IS

  CURSOR check_trip_names (v_trip_name   VARCHAR2) IS
  SELECT fte_trip_id FROM fte_trips
  WHERE name = v_trip_name;

Line: 503


  Validate_UpdateTrip(p_trip_id	      =>p_trip_info.fte_trip_id,
		      p_trip_name     =>p_trip_info.name,
		      p_trip_status   =>p_trip_info.status_code,
		      x_return_status => x_return_status);

Line: 515


  UPDATE fte_trips SET
    fte_trip_id 			= decode(p_trip_info.fte_trip_id,FND_API.G_MISS_NUM, fte_trip_id, p_trip_info.fte_trip_id),
    name				= decode(p_trip_info.name, FND_API.G_MISS_CHAR, name, p_trip_info.name),
    status_code				= decode(p_trip_info.status_code, FND_API.G_MISS_CHAR, status_code, p_trip_info.status_code),
    private_trip=decode(p_trip_info.private_trip, FND_API.G_MISS_CHAR, NULL, p_trip_info.private_trip),
    validation_required=decode(p_trip_info.validation_required, FND_API.G_MISS_CHAR, NULL, p_trip_info.validation_required),
    creation_date=decode(p_trip_info.creation_date, FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
    created_by=decode(p_trip_info.created_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.created_by),
    last_update_date=decode(p_trip_info.last_update_date,FND_API.G_MISS_DATE, SYSDATE, NULL, SYSDATE, p_trip_info.creation_date),
    last_updated_by=decode(p_trip_info.last_updated_by,FND_API.G_MISS_NUM, FND_GLOBAL.USER_ID, NULL, FND_GLOBAL.USER_ID, p_trip_info.last_updated_by),
    last_update_login=decode(p_trip_info.last_update_login,FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID, NULL, FND_GLOBAL.LOGIN_ID, p_trip_info.last_update_login),
    program_application_id=decode(p_trip_info.program_application_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_application_id),
   program_id= decode(p_trip_info.program_id, FND_API.G_MISS_NUM, NULL, p_trip_info.program_id),
    program_update_date=decode(p_trip_info.program_update_date, FND_API.G_MISS_DATE, NULL, p_trip_info.program_update_date),
    request_id=decode(p_trip_info.request_id, FND_API.G_MISS_NUM, NULL, p_trip_info.request_id),
    attribute_category=decode(p_trip_info.attribute_category, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute_category),
    attribute1=decode(p_trip_info.attribute1, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute1),
    attribute2=decode(p_trip_info.attribute2, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute2),
    attribute3=decode(p_trip_info.attribute3, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute3),
    attribute4=decode(p_trip_info.attribute4, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute4),
    attribute5=decode(p_trip_info.attribute5, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute5),
    attribute6=decode(p_trip_info.attribute6, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute6),
    attribute7=decode(p_trip_info.attribute7, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute7),
    attribute8=decode(p_trip_info.attribute8, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute8),
    attribute9=decode(p_trip_info.attribute9, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute9),
    attribute10=decode(p_trip_info.attribute10, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute10),
    attribute11=decode(p_trip_info.attribute11, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute11),
    attribute12=decode(p_trip_info.attribute12, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute12),
    attribute13=decode(p_trip_info.attribute13, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute13),
    attribute14=decode(p_trip_info.attribute14, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute14),
    attribute15=decode(p_trip_info.attribute15, FND_API.G_MISS_CHAR, NULL, p_trip_info.attribute15),
    route_id=decode(p_trip_info.route_id, FND_API.G_MISS_NUM, NULL, p_trip_info.route_id)
  WHERE fte_trip_id = p_trip_info.fte_trip_id;

Line: 565


	   wsh_util_core.default_handler('FTE_TRIPS_PVT.UPDATE_TRIP');

Line: 568


END Update_Trip;

Line: 571


PROCEDURE Validate_UpdateTrip(
	p_trip_id		IN	NUMBER,
	p_trip_name		IN	VARCHAR2,
	p_trip_status		IN	VARCHAR2,
	x_return_status 	OUT NOCOPY 	VARCHAR2) IS

  CURSOR check_trip_names (v_trip_name   VARCHAR2) IS
  SELECT fte_trip_id FROM fte_trips
  WHERE name = v_trip_name;

Line: 627


	   wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_UPDATETRIP');

Line: 630


END Validate_UpdateTrip;

Line: 636


PROCEDURE Delete_Trip(
  p_trip_id		IN	NUMBER,
  x_return_status	OUT NOCOPY	VARCHAR2
  ) IS

  l_trip_id	NUMBER;

Line: 654


   Validate_DeleteTrip(p_trip_id=>l_trip_id,
		x_return_status=>x_return_status
		);

Line: 664


    DELETE FROM fte_trips
    WHERE fte_trip_id = l_trip_id;

Line: 676


	    wsh_util_core.default_handler('FTE_TRIPS_PVT.DELETE_TRIP');

Line: 679


END Delete_Trip;

Line: 682


PROCEDURE Validate_DeleteTrip(
  p_trip_id		IN	NUMBER,
  x_return_status	OUT NOCOPY	VARCHAR2
  ) IS

  CURSOR trip_segments (l_trip_id IN NUMBER) IS
  SELECT wsh_trip_id
  FROM  fte_wsh_trips
  WHERE  fte_trip_id = l_trip_id;

Line: 716


	    FND_MESSAGE.SET_NAME('FTE','FTE_TRIP_DELETE_ERROR');

Line: 724


	    wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_DELETETRIP');

Line: 727


END Validate_DeleteTrip;

Line: 739


  SELECT wsh_trip_id, sequence_number
  FROM  fte_wsh_trips
  WHERE  fte_trip_id = l_trip_id
  order by sequence_number;

Line: 745


  select stop_id, stop_location_id, stop_sequence_number
  from wsh_trip_stops
  where trip_id=l_wsh_trip_id
  order by stop_sequence_number;

Line: 763


  cannot_delete_trip EXCEPTION;

Line: 786


		UPDATE FTE_TRIPS SET validation_required='Y'
		where fte_trip_id=p_trip_id;

Line: 827


	       UPDATE FTE_TRIPS SET validation_required='Y'
		where fte_trip_id=p_trip_id;

Line: 855


		UPDATE FTE_TRIPS SET validation_required='Y'
		where fte_trip_id=p_trip_id;

Line: 882


	       UPDATE FTE_TRIPS SET validation_required='Y'
		where fte_trip_id=p_trip_id;

Line: 920


	       UPDATE FTE_TRIPS SET validation_required='Y'
	       where fte_trip_id=p_trip_id;

Line: 936


        	UPDATE FTE_TRIPS SET validation_required='N'
		where fte_trip_id=p_trip_id;

Line: 964


	    wsh_util_core.default_handler('FTE_TRIPS_PVT.VALIDATE_DELETETRIP');

Line: 988


	SELECT name
	FROM   fte_trips
	WHERE  fte_trip_id = p_trip_id;

Line: 1042


	select delivery_leg_id
	from wsh_delivery_legs wdl, wsh_trip_stops wts
	where wdl.pick_up_stop_id = wts.stop_id
	and wts.trip_id = p_wsh_trip_id
	and wdl.delivery_id=p_del_id;

Line: 1068


		UPDATE wsh_delivery_legs SET fte_trip_id=p_fte_trip_id
		where delivery_leg_id=l_dleg_id;

Line: 1105


	select trip_id
	from wsh_trips
	where load_tender_number = c_tender_number;

Line: 1153


	SELECT stop_id, stop_location_id, stop_sequence_number,
		planned_departure_date,planned_arrival_date
	FROM   wsh_trip_stops
	WHERE  trip_id =  p_trip_id
	AND    stop_sequence_number = ( select max(stop_sequence_number)
				   from wsh_trip_stops
				   where trip_id = p_trip_id);

Line: 1239


	SELECT stop_id, stop_location_id, stop_sequence_number,
		planned_departure_date,planned_arrival_date
	FROM   wsh_trip_stops
	WHERE  trip_id =  p_trip_id
	AND    stop_sequence_number = ( select min(stop_sequence_number)
				   from wsh_trip_stops
				   where trip_id = p_trip_id);

Line: 1319


	SELECT name
	FROM   wsh_trips
	WHERE  trip_id = p_trip_segment_id;

Line: 1397


	SELECT departure_gross_weight, weight_uom_code,
		   departure_volume,volume_uom_code,
		   wt.unit_of_measure_tl weight, vol.unit_of_measure_tl volume ,
		   st.stop_id stopid,st.planned_arrival_date, st.planned_departure_date,
		   st.stop_location_id
	FROM wsh_trip_stops st,mtl_units_of_measure wt, mtl_units_of_measure vol
	WHERE st.trip_id = c_trip_id
	AND wt.UOM_CODE (+)= st.weight_uom_code
	AND vol.UOM_CODE (+)= st.volume_uom_code
	order by st.stop_sequence_number;

Line: 1413


	SELECT distinct(org.organization_name) org_name
	FROM wsh_delivery_legs dlegs, wsh_new_deliveries dlvy,
		wsh_trip_stops stops, org_organization_definitions  org
	WHERE dlegs.delivery_id = dlvy.delivery_id
	AND dlegs.pick_up_stop_id  = stops.stop_id
	AND org.organization_id = dlvy.organization_id
	AND stops.stop_id = c_stop_id;

Line: 1455


	SELECT count(*) INTO l_stop_count FROM WSH_TRIP_STOPS
	WHERE TRIP_ID = l_trip_id;

Line: 1622


		SELECT delivery_id, gross_weight, weight_uom_code, volume, volume_uom_code
		FROM wsh_new_deliveries
		WHERE delivery_id IN
			(SELECT distinct(wdl.delivery_id)
  			 FROM wsh_trip_stops wts, --t
				wsh_delivery_legs wdl --d
			 WHERE wdl.pick_up_stop_id = wts.stop_id
			 AND wts.trip_id = l_trip_id);