APPS.FTE_MOVES_PVT SQL Statements

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

Line: 26

  SELECT fte_moves_s.nextval
  FROM sys.dual;

Line: 58

	insert into FTE_MOVES
	(
		MOVE_ID         ,
		MOVE_TYPE_CODE         ,
		LANE_ID     ,
		SERVICE_LEVEL,
		PLANNED_FLAG,
		TP_PLAN_NAME,
		CM_TRIP_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_move_id,
		p_move_info.MOVE_TYPE_CODE,
		decode(p_move_info.LANE_ID,FND_API.G_MISS_NUM,NULL,p_move_info.LANE_ID),
		decode(p_move_info.SERVICE_LEVEL,FND_API.G_MISS_CHAR,NULL,p_move_info.SERVICE_LEVEL),
		p_move_info.PLANNED_FLAG,
		decode(p_move_info.TP_PLAN_NAME,FND_API.G_MISS_CHAR,NULL,p_move_info.TP_PLAN_NAME),
		decode(p_move_info.CM_TRIP_NUMBER,FND_API.G_MISS_NUM,NULL,p_move_info.CM_TRIP_NUMBER),
		decode(p_move_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.creation_date),
		decode(p_move_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.created_by),
		decode(p_move_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_move_info.last_update_date),
		decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),
		decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),
		decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),
		decode(p_move_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_move_info.program_id),
		decode(p_move_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.program_update_date),
		decode(p_move_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_move_info.request_id)
	);

Line: 122

PROCEDURE UPDATE_MOVE(
	p_init_msg_list	        IN   		VARCHAR2 DEFAULT FND_API.G_FALSE,
	p_move_info		IN		move_rec_type,
	x_return_status		OUT NOCOPY 	VARCHAR2
) IS


BEGIN

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

Line: 139

  UPDATE FTE_MOVES SET
	MOVE_TYPE_CODE  =decode(p_move_info.MOVE_TYPE_CODE,
    				NULL,MOVE_TYPE_CODE,
    				FND_API.G_MISS_CHAR,MOVE_TYPE_CODE,
    				p_move_info.MOVE_TYPE_CODE),
	LANE_ID         =decode(p_move_info.LANE_ID,
    				NULL,LANE_ID,
    				FND_API.G_MISS_NUM,NULL,
    				p_move_info.LANE_ID),
	SERVICE_LEVEL	=decode(p_move_info.SERVICE_LEVEL,
    				NULL,SERVICE_LEVEL,
    				FND_API.G_MISS_CHAR,NULL,
    				p_move_info.SERVICE_LEVEL),
	PLANNED_FLAG	=decode(p_move_info.PLANNED_FLAG,
    				NULL,PLANNED_FLAG,
    				FND_API.G_MISS_CHAR,PLANNED_FLAG,
    				p_move_info.PLANNED_FLAG),
	TP_PLAN_NAME	=decode(p_move_info.TP_PLAN_NAME,
    				NULL,TP_PLAN_NAME,
    				FND_API.G_MISS_CHAR,NULL,
    				p_move_info.TP_PLAN_NAME),
	CM_TRIP_NUMBER	=decode(p_move_info.CM_TRIP_NUMBER,
    				NULL,CM_TRIP_NUMBER,
    				FND_API.G_MISS_NUM,NULL,
    				p_move_info.CM_TRIP_NUMBER),
	last_update_date 	= decode(p_move_info.last_update_date,
				NULL,SYSDATE,
				FND_API.G_MISS_DATE,SYSDATE,
				p_move_info.last_update_date),
	last_updated_by  	= decode(p_move_info.last_updated_by,
				NULL,FND_GLOBAL.USER_ID,
				FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,
				p_move_info.last_updated_by),
	last_update_login	= decode(p_move_info.last_update_login,
				NULL,FND_GLOBAL.LOGIN_ID,
				FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID,
				p_move_info.last_update_login),
	program_application_id = decode(p_move_info.program_application_id,
				NULL,program_application_id,
				FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,
				p_move_info.program_application_id),
	program_id 		= decode(p_move_info.program_id,
				NULL,program_id,FND_API.G_MISS_NUM,
				FND_GLOBAL.CONC_PROGRAM_ID,
				p_move_info.program_id),
	program_update_date = decode(p_move_info.program_update_date,
				NULL,program_update_date,
				FND_API.G_MISS_DATE,SYSDATE,
				p_move_info.program_update_date),
	request_id 		= decode(p_move_info.request_id,
				NULL,request_id,FND_API.G_MISS_NUM,
				FND_GLOBAL.CONC_REQUEST_ID,p_move_info.request_id)
  WHERE move_id = p_move_info.move_id;

Line: 203

	   wsh_util_core.default_handler('FTE_MOVES_PVT.UPDATE_MOVES');

Line: 206

END UPDATE_MOVE;

Line: 209

PROCEDURE DELETE_MOVE(
	p_init_msg_list	        IN   		VARCHAR2 DEFAULT FND_API.G_FALSE,
	p_move_id	     	IN	NUMBER,
	p_validate_flag 	IN  	VARCHAR2 DEFAULT 'Y',
	x_return_status		OUT 	NOCOPY 	VARCHAR2
) IS


BEGIN

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

Line: 226

	DELETE FROM fte_moves
	WHERE move_id = p_move_id;

Line: 236

	-- delete corresponding entries from FTE_TRIP_MOVES
	DELETE FROM FTE_TRIP_MOVES
	WHERE MOVE_ID = p_move_id;

Line: 243

	    wsh_util_core.default_handler('FTE_MOVES_PVT.DELETE_MOVE');

Line: 246

END DELETE_MOVE;

Line: 259

	    SELECT trip_id
	    FROM   fte_trip_moves
	    WHERE  move_id = c_move_id;