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_WSH_TRIPS_PVT SQL Statements

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

Line: 64


  SELECT fte_trip_id FROM fte_trips
  WHERE fte_trip_id = v_trip_id;

Line: 68


  SELECT trip_id FROM wsh_trips
  WHERE trip_id = v_trip_id;

Line: 141


  SELECT fte_trip_id FROM fte_wsh_trips
  WHERE fte_trip_id = v_fte_trip_id and sequence_number = v_sequence;

Line: 193


  SELECT status_code
  FROM   fte_trips
  WHERE  fte_trip_id = p_trip_id;

Line: 263


  update_sequence_for_non_open EXCEPTION;

Line: 381


  elsif (p_action_code = 'UPDATE') then

    -- sequence can only be updated for open trip
    if (l_status <> 'OP') then
      RAISE update_sequence_for_non_open;

Line: 388


  end if; -- p_action_code = 'CREATE' or 'UPDATE'

Line: 395


  select count(*) into l_stop_count
  from wsh_trip_stops
  where trip_id = p_trip_info.WSH_TRIP_ID;

Line: 403


	update fte_trips
	  set validation_required = 'Y'
	  where fte_trip_id = p_trip_info.FTE_TRIP_ID;

Line: 456


      select sequence_number into l_previous_sequence_number
      from fte_wsh_trips
      where fte_trip_id = p_trip_info.FTE_TRIP_ID
        and wsh_trip_id = l_previous_segment_id;

Line: 519


	update fte_trips
	  set validation_required = 'Y'
	  where fte_trip_id = p_trip_info.FTE_TRIP_ID;

Line: 565


      select sequence_number into l_next_sequence_number
      from fte_wsh_trips
      where fte_trip_id = p_trip_info.FTE_TRIP_ID
        and wsh_trip_id = l_next_segment_id;

Line: 628


	update fte_trips
	  set validation_required = 'Y'
	  where fte_trip_id = p_trip_info.FTE_TRIP_ID;

Line: 672


    WHEN update_sequence_for_non_open THEN
      FND_MESSAGE.SET_NAME('FTE', 'FTE_INVALID_TRIP_STATUS3');

Line: 722


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

Line: 724


  insert into fte_wsh_trips
  (
 FTE_TRIP_ID         ,
 WSH_TRIP_ID         ,
 SEQUENCE_NUMBER     ,
 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
  )
  values
  (
    decode(p_trip_info.FTE_TRIP_ID, FND_API.G_MISS_NUM, NULL, p_trip_info.FTE_TRIP_ID),
    decode(p_trip_info.WSH_TRIP_ID, FND_API.G_MISS_NUM, NULL, p_trip_info.WSH_TRIP_ID),
    decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),
    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)
  );

Line: 792


    update fte_trips
      set validation_required = 'Y'
      where fte_trip_id = p_trip_info.FTE_TRIP_ID;

Line: 821


PROCEDURE Update_Trip
(
	p_trip_info	     	IN	fte_wsh_trip_rec_type,
	p_validate_flag		IN	VARCHAR2 DEFAULT 'Y',
	x_return_status		OUT NOCOPY	VARCHAR2
) IS

  no_trip_found EXCEPTION;

Line: 836


    Validate_Trip(p_trip_info, 'UPDATE', x_return_status);

Line: 844


  update fte_wsh_trips set
    SEQUENCE_NUMBER = decode(p_trip_info.SEQUENCE_NUMBER, FND_API.G_MISS_NUM, NULL, p_trip_info.SEQUENCE_NUMBER),
    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)
  where fte_trip_id = p_trip_info.fte_trip_id and wsh_trip_id = p_trip_info.wsh_trip_id;

Line: 884


      wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Update_Trip');

Line: 888


END Update_Trip;

Line: 898


PROCEDURE Validate_Trip_For_Delete
(
	P_init_msg_list	        IN   VARCHAR2 DEFAULT FND_API.G_FALSE,
	p_fte_trip_id	     	IN	NUMBER,
	p_wsh_trip_id	     	IN	NUMBER,
	x_msg_count              OUT NOCOPY  NUMBER,
	x_msg_data               OUT NOCOPY  VARCHAR2,
	x_return_status		OUT NOCOPY	VARCHAR2
) IS

  l_status VARCHAR2(30);

Line: 978


    select sequence_number into l_sequence_number
    from fte_wsh_trips
    where fte_trip_id = p_fte_trip_id and wsh_trip_id = p_wsh_trip_id;

Line: 1037


	update fte_trips
	  set validation_required = 'Y'
	  where fte_trip_id = p_fte_trip_id;

Line: 1067


      wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Validate_Trip_For_Delete');

Line: 1076


END Validate_Trip_For_Delete;

Line: 1086


PROCEDURE Delete_Trip
(
	P_init_msg_list	        IN   VARCHAR2 DEFAULT FND_API.G_FALSE,
	p_fte_trip_id	     	IN	NUMBER,
	p_wsh_trip_id	     	IN	NUMBER,
	x_msg_count              OUT NOCOPY  NUMBER,
	x_msg_data               OUT NOCOPY  VARCHAR2,
	x_return_status		OUT NOCOPY	VARCHAR2
) IS

  no_trip_found EXCEPTION;

Line: 1101


      wsh_debug_sv.dpush (c_sdebug, 'Delete_Trip');

Line: 1115


  Validate_Trip_For_Delete
	(
	p_fte_trip_id => p_fte_trip_id,
	p_wsh_trip_id => p_wsh_trip_id,
	x_msg_count => x_msg_count,
	x_msg_data => x_msg_data,
	x_return_status => x_return_status);

Line: 1133


  delete from fte_wsh_trips
  where fte_trip_id = p_fte_trip_id and wsh_trip_id = p_wsh_trip_id;

Line: 1142


    update fte_trips
      set validation_required = 'Y'
      where fte_trip_id = p_fte_trip_id;

Line: 1169


      wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Delete_Trip');

Line: 1178


END Delete_Trip;

Line: 1193


 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,
	P_init_msg_list	        IN   VARCHAR2 DEFAULT FND_API.G_FALSE,
	p_action_code		IN 	VARCHAR2,
	x_msg_count              OUT NOCOPY  NUMBER,
	x_msg_data               OUT NOCOPY  VARCHAR2,
	x_return_status		OUT NOCOPY	VARCHAR2
) IS

  p_trip_info  fte_wsh_trip_rec_type;

Line: 1247


 p_trip_info.LAST_UPDATE_DATE		:=pp_LAST_UPDATE_DATE;

Line: 1248


 p_trip_info.LAST_UPDATED_BY		:=pp_LAST_UPDATED_BY;

Line: 1249


 p_trip_info.LAST_UPDATE_LOGIN		:=pp_LAST_UPDATE_LOGIN;

Line: 1252


 p_trip_info.PROGRAM_UPDATE_DATE	:=pp_PROGRAM_UPDATE_DATE;

Line: 1279


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

Line: 1325


PROCEDURE Create_Update_Trip_Wrapper
(
 pp_FTE_TRIP_ID			IN   NUMBER DEFAULT FND_API.G_MISS_NUM,
 pp_WSH_TRIP_ID                 IN   NUMBER DEFAULT FND_API.G_MISS_NUM,
 pp_SEQUENCE_NUMBER             IN   NUMBER DEFAULT FND_API.G_MISS_NUM,
 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,
	P_init_msg_list	        IN   VARCHAR2 DEFAULT FND_API.G_FALSE,
	p_action_code		IN 	VARCHAR2,
	p_validate_flag		IN	VARCHAR2,
	x_msg_count              OUT NOCOPY  NUMBER,
	x_msg_data               OUT NOCOPY  VARCHAR2,
	x_return_status		OUT NOCOPY	VARCHAR2
) IS

  p_trip_info  fte_wsh_trip_rec_type;

Line: 1370


      wsh_debug_sv.dpush (c_sdebug, 'Create_Update_Trip_Wrapper');

Line: 1395


 p_trip_info.LAST_UPDATE_DATE		:=pp_LAST_UPDATE_DATE;

Line: 1396


 p_trip_info.LAST_UPDATED_BY		:=pp_LAST_UPDATED_BY;

Line: 1397


 p_trip_info.LAST_UPDATE_LOGIN		:=pp_LAST_UPDATE_LOGIN;

Line: 1400


 p_trip_info.PROGRAM_UPDATE_DATE	:=pp_PROGRAM_UPDATE_DATE;

Line: 1426


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

Line: 1464


      wsh_util_core.default_handler('FTE_WSH_TRIPS_PUB.Create_Update_Trip_Wrapper');

Line: 1477


END Create_Update_Trip_Wrapper;