The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT fte_moves_s.nextval
FROM sys.dual;
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)
);
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;
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;
wsh_util_core.default_handler('FTE_MOVES_PVT.UPDATE_MOVES');
END UPDATE_MOVE;
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;
DELETE FROM fte_moves
WHERE move_id = p_move_id;
-- delete corresponding entries from FTE_TRIP_MOVES
DELETE FROM FTE_TRIP_MOVES
WHERE MOVE_ID = p_move_id;
wsh_util_core.default_handler('FTE_MOVES_PVT.DELETE_MOVE');
END DELETE_MOVE;
SELECT trip_id
FROM fte_trip_moves
WHERE move_id = c_move_id;