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

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

Line: 27


  SELECT trip_move_id
  FROM fte_trip_moves
  WHERE move_id = v_move_id
  and sequence_number = v_sequence;

Line: 32


  CURSOR check_sequence_update (v_move_id NUMBER,
	                       v_sequence NUMBER,
                               v_trip_move_id NUMBER) IS
  SELECT trip_move_id
  FROM fte_trip_moves
  WHERE move_id = v_move_id
  and sequence_number = v_sequence
  and trip_move_id <> v_trip_move_id;

Line: 42


  SELECT move_id FROM fte_moves
  WHERE move_id = v_move_id;

Line: 79


    OPEN check_sequence_update(p_trip_moves_info.move_id,
                               p_trip_moves_info.sequence_number,
                               p_trip_moves_info.trip_move_id);

Line: 82


    FETCH check_sequence_update INTO l_number;

Line: 83


    l_found := check_sequence_update%FOUND;

Line: 84


    CLOSE check_sequence_update;

Line: 109


      IF check_sequence_update%ISOPEN THEN
        CLOSE check_sequence_update;

Line: 139


  SELECT trip_move_id
  FROM fte_trip_moves
  WHERE move_id = v_move_id
  and trip_id = v_trip_id;

Line: 145


  CURSOR check_unique_trip_update(v_move_id NUMBER,
                                  v_trip_id NUMBER,
                                  v_trip_move_id NUMBER) IS
  SELECT trip_move_id
  FROM fte_trip_moves
  WHERE move_id = v_move_id
  and trip_id = v_trip_id
  and trip_move_id <> v_trip_move_id;

Line: 155


  SELECT trip_id FROM wsh_trips
  WHERE trip_id = v_trip_id;

Line: 195


    OPEN check_unique_trip_update(p_trip_moves_info.move_id,
                           p_trip_moves_info.trip_id,
                           p_trip_moves_info.trip_move_id);

Line: 198


    FETCH check_unique_trip_update INTO l_number;

Line: 200


    IF (check_unique_trip_update%FOUND) THEN
      CLOSE check_unique_trip_update;

Line: 205


    CLOSE check_unique_trip_update;

Line: 224


      if check_unique_trip_update%ISOPEN THEN
        close check_unique_trip_update;

Line: 253


  SELECT fte_trip_moves_s.nextval
  FROM sys.dual;

Line: 292


	insert into FTE_TRIP_MOVES
	(
		TRIP_MOVE_ID	,
		MOVE_ID         ,
		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
	)
	values
	(
		x_trip_move_id,
		p_trip_moves_info.MOVE_ID,
		p_trip_moves_info.TRIP_ID,
		p_trip_moves_info.SEQUENCE_NUMBER,
		decode(p_trip_moves_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_trip_moves_info.creation_date),
		decode(p_trip_moves_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_trip_moves_info.created_by),
		decode(p_trip_moves_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_trip_moves_info.last_update_date),
		decode(p_trip_moves_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_trip_moves_info.last_updated_by),
		decode(p_trip_moves_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_trip_moves_info.last_update_login),
		decode(p_trip_moves_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_trip_moves_info.program_application_id),
		decode(p_trip_moves_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_trip_moves_info.program_id),
		decode(p_trip_moves_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_trip_moves_info.program_update_date),
		decode(p_trip_moves_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_trip_moves_info.request_id)
	);

Line: 340


PROCEDURE Update_Trip_Moves(
	p_init_msg_list	        IN 		VARCHAR2 DEFAULT FND_API.G_FALSE,
	p_trip_moves_info	IN		TRIP_MOVES_REC_TYPE,
	x_return_status		OUT NOCOPY	VARCHAR2
) IS

FTE_DUPLICATE_MOVE exception;

Line: 378


  UPDATE fte_trip_moves SET
    SEQUENCE_NUMBER  	= decode(p_trip_moves_info.SEQUENCE_NUMBER,
    				NULL,SEQUENCE_NUMBER,
    				FND_API.G_MISS_NUM,NULL,
    				p_trip_moves_info.SEQUENCE_NUMBER),
    last_update_date 	= decode(p_trip_moves_info.last_update_date,
    			  	NULL,SYSDATE,
    			  	FND_API.G_MISS_DATE,SYSDATE,
    			  	p_trip_moves_info.last_update_date),
    last_updated_by  	= decode(p_trip_moves_info.last_updated_by,
    				NULL,FND_GLOBAL.USER_ID,
    				FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,
    				p_trip_moves_info.last_updated_by),
    last_update_login	= decode(p_trip_moves_info.last_update_login,
    				NULL,FND_GLOBAL.LOGIN_ID,
    				FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID,
    				p_trip_moves_info.last_update_login),
    program_application_id = decode(p_trip_moves_info.program_application_id,
    				NULL,program_application_id,
    				FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,
    				p_trip_moves_info.program_application_id),
    program_id 		= decode(p_trip_moves_info.program_id,
    				NULL,program_id,FND_API.G_MISS_NUM,
    				FND_GLOBAL.CONC_PROGRAM_ID,
    				p_trip_moves_info.program_id),
    program_update_date = decode(p_trip_moves_info.program_update_date,
    				NULL,program_update_date,
    				FND_API.G_MISS_DATE,SYSDATE,
    				p_trip_moves_info.program_update_date),
    request_id 		= decode(p_trip_moves_info.request_id,
    				NULL,request_id,FND_API.G_MISS_NUM,
    				FND_GLOBAL.CONC_REQUEST_ID,p_trip_moves_info.request_id)
  WHERE trip_move_id = p_trip_moves_info.trip_move_id;

Line: 426


	   wsh_util_core.default_handler('FTE_TRIP_MOVES_PVT.UPDATE_TRIP_MOVES');

Line: 429


END Update_Trip_Moves;

Line: 432


PROCEDURE Delete_Trip_moves(
	p_init_msg_list	        IN 		VARCHAR2 DEFAULT FND_API.G_FALSE,
	p_trip_move_id	     	IN		NUMBER,
	x_return_status		OUT NOCOPY	VARCHAR2
  ) IS


BEGIN

	IF FND_API.to_Boolean( p_init_msg_list )
	THEN
		FND_MSG_PUB.initialize;

Line: 448


	DELETE FROM fte_trip_moves
	WHERE trip_move_id = p_trip_move_id;

Line: 460


	    wsh_util_core.default_handler('FTE_TRIP_MOVES_PVT.DELETE_TRIP_MOVES');

Line: 463


END Delete_Trip_moves;