The following lines contain the word 'select', 'insert', 'update' or 'delete':
WSH_WMS_LPN_GRP.create_update_containers
( p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_detail_info_tab => l_detail_info_tab,
p_IN_rec => l_IN_rec,
x_OUT_rec => l_OUT_rec
);
PROCEDURE Update_Container (
-- Standard parameters
p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
x_return_status OUT NOCOPY VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,
x_msg_data OUT NOCOPY VARCHAR2,
-- program specific parameters
p_container_rec IN WSH_CONTAINER_GRP.CHANGEDATTRIBUTETABTYPE
) IS
-- Standard call to check for call compatibility
l_api_version CONSTANT NUMBER := 1.0;
l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
WSH_INVALID_CONT_UPDATE EXCEPTION;
WSH_FAIL_CONT_UPDATE EXCEPTION;
SELECT container_flag, delivery_detail_id, lpn_id, released_status
FROM WSH_DELIVERY_DETAILS
WHERE delivery_detail_id = v_cont_id
AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO');
SELECT delivery_detail_id, container_name
FROM WSH_DELIVERY_DETAILS
WHERE container_name = v_cont_name
AND nvl(LINE_DIRECTION , 'O') IN ('O', 'IO');
SELECT lpn_id
FROM wsh_delivery_details
WHERE delivery_detail_id = l_delivery_detail_id;
l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_CONTAINER';
SAVEPOINT Update_Containers_SP_Grp;
RAISE WSH_INVALID_CONT_UPDATE;
RAISE WSH_INVALID_CONT_UPDATE;
RAISE WSH_FAIL_CONT_UPDATE;
RAISE WSH_FAIL_CONT_UPDATE;
l_IN_rec.action_code := 'UPDATE';
l_IN_rec.action_code := 'UPDATE_NULL';
l_detail_info_tab(1).last_update_date := FND_API.G_MISS_DATE;
l_detail_info_tab(1).last_update_login := FND_API.G_MISS_NUM;
l_detail_info_tab(1).last_updated_by := FND_API.G_MISS_NUM;
l_detail_info_tab(1).program_update_date := FND_API.G_MISS_DATE;
WSH_WMS_LPN_GRP.create_update_containers
( p_api_version => p_api_version,
p_init_msg_list => p_init_msg_list,
p_commit => p_commit,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_detail_info_tab => l_detail_info_tab,
p_IN_rec => l_IN_rec,
x_OUT_rec => l_OUT_rec
);
RAISE WSH_FAIL_CONT_UPDATE;
WHEN WSH_INVALID_CONT_UPDATE then
x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
rollback to Update_Containers_SP_Grp;
fnd_message.set_name('WSH', 'WSH_CONT_INVALID_UPDATE');
WSH_DEBUG_SV.logmsg(l_module_name,'WSH_INVALID_CONT_UPDATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_INVALID_CONT_UPDATE');
rollback to Update_Containers_SP_Grp;
WHEN WSH_FAIL_CONT_UPDATE then
x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
rollback to Update_Containers_SP_Grp;
fnd_message.set_name('WSH', 'WSH_CONT_UPDATE_ERROR');
WSH_DEBUG_SV.logmsg(l_module_name,'WSH_FAIL_CONT_UPDATE exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_FAIL_CONT_UPDATE');
wsh_util_core.default_handler('WSH_CONTAINER_GRP.Update_Container');
rollback to Update_Containers_SP_Grp;
END Update_Container;
l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
SELECT delivery_detail_id, container_flag
FROM WSH_DELIVERY_DETAILS
WHERE delivery_detail_id = v_detail_id
AND nvl(line_direction,'O') in ('O','IO'); -- J-IB-NPARIKH;
SELECT delivery_id, name, status_code
FROM WSH_NEW_DELIVERIES
WHERE delivery_id = v_del_id
AND nvl(shipment_direction,'O') in ('O','IO'); -- J-IB-NPARIKH;;
l_api_name CONSTANT VARCHAR2(30):= 'Update_Containers';
SELECT delivery_detail_id, container_flag
FROM WSH_DELIVERY_DETAILS
WHERE container_name = v_cont_name
--LPN reuse project
AND released_status = 'X'
AND container_flag = 'Y';
SELECT wdd.delivery_detail_id, wdd.container_flag,wdd.released_status,
wdd.organization_id ,wda.delivery_id
FROM WSH_DELIVERY_DETAILS wdd, wsh_delivery_assignments_v wda
WHERE wdd.delivery_detail_id = v_detail_id
AND wdd.delivery_detail_id = wda.delivery_detail_id
AND nvl(wdd.line_direction,'O') in ('O','IO'); -- J-IB-NPARIKH
SELECT delivery_id, name, status_code
FROM WSH_NEW_DELIVERIES
WHERE delivery_id = v_del_id;
SELECT delivery_id, name, status_code
FROM WSH_NEW_DELIVERIES
WHERE name = v_del_name;
SELECT status_code
FROM wsh_new_deliveries
WHERE delivery_id = l_delivery_id;