The following lines contain the word 'select', 'insert', 'update' or 'delete':
select expiration_date
into x_lot_exp
from mtl_lot_numbers
where lot_number = p_lot_number
and inventory_item_id = p_inventory_item_id
and organization_id = p_organization_id;
PROCEDURE insertLot(p_header_id IN NUMBER,
p_lot_number IN VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2,
x_err_msg OUT NOCOPY VARCHAR2) IS
l_msg_count NUMBER;
WMS_WIP_INTEGRATION.insert_lot(p_header_id => p_header_id,
p_lot_number => p_lot_number,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => x_err_msg);
end insertLot;
select lot_number
from wip_lpn_completions_lots
where header_id = v_header_id;
wms_wip_integration.insert_lot(p_header_id, lots_rec.lot_number, x_return_status, l_msg_count, x_err_msg);
PROCEDURE updateSerials(p_header_id IN NUMBER,
x_err_msg OUT NOCOPY VARCHAR2,
x_return_status OUT NOCOPY VARCHAR2) IS
cursor serials(v_header_id NUMBER) IS
select fm_serial_number
from wip_lpn_completions_serials
where header_id = v_header_id;
wms_wip_integration.update_serial(p_header_id => p_header_id,
p_serial_number => serials_rec.fm_serial_number,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => x_err_msg);
END updateSerials;
PROCEDURE updateLSAttributes(p_header_id IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_err_msg OUT NOCOPY VARCHAR2) IS BEGIN
x_return_status := fnd_api.G_RET_STS_SUCCESS;
updateSerials(p_header_id, x_err_msg, x_return_status);
end updateLSAttributes;
wms_wip_integration.update_mo_line(p_lpn_id => p_lpn_id,
p_wms_process_flag => 1,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => x_err_msg);
PROCEDURE updateLpnContext(p_api_version IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_lpn_id IN NUMBER,
p_lpn_context IN NUMBER,
x_return_status OUT NOCOPY VARCHAR2,
x_err_msg OUT NOCOPY VARCHAR2) IS
lpnRec WMS_CONTAINER_PUB.LPN;
END updateLpnContext;
update wip_lpn_completions
set subinventory_code = p_subinventory_code,
locator_id = p_locator_id
where header_id = p_header_id
returning wip_entity_id, organization_id, inventory_item_id, wip_entity_type
into l_wipID, l_orgID, l_itemID, l_entityType;
select count(*)
into l_ctoItemCount
from mtl_system_items
where inventory_item_id = l_itemID
and organization_id = l_orgID
and build_in_wip_flag = 'Y'
and base_item_id is not null
and bom_item_type = wip_constants.standard_type
and replenish_to_order_flag = 'Y';
select count(*)
into l_soExistsFlag
from wip_lpn_completions
where header_id = p_header_id
and demand_source_header_id is not null
and demand_source_line is not null;