The following lines contain the word 'select', 'insert', 'update' or 'delete':
x_trohdr_rec.program_update_date := NULL;
inv_trohdr_util.insert_row(x_trohdr_rec);
select move_order_type
from mtl_txn_request_headers h
where h.header_id = V_header_id;
select h.order_number , l.org_id -- 6689912 added org_id
from oe_order_headers_all h
,oe_order_lines_all l
where l.header_id = h.header_id
and l.line_id = V_line_id;
SELECT locator_type
FROM mtl_secondary_inventories
WHERE organization_id = v_org_id
AND secondary_inventory_name = v_sub_code;
SELECT location_control_code
FROM mtl_system_items
WHERE organization_id = v_org_id
AND inventory_item_id = v_item_id;
select transaction_source_type_id
into x_trolin_tbl(l_index).transaction_source_type_id
from mtl_transaction_types
where transaction_type_id = x_trolin_tbl(l_index).transaction_type_id;
SELECT primary_uom_code
,nvl(restrict_locators_code,0)
,nvl(restrict_subinventories_code,0)
INTO l_primary_uom_code
,l_restrict_locators_code
,l_restrict_subinventories_code
FROM mtl_system_items
WHERE organization_id = x_trolin_tbl(l_index).organization_id
AND inventory_item_id = x_trolin_tbl(l_index).inventory_item_id;
SELECT primary_uom_code
,nvl(restrict_locators_code,0)
,nvl(restrict_subinventories_code,0)
INTO l_primary_uom_code
,l_restrict_locators_code
,l_restrict_subinventories_code
FROM mtl_system_items
WHERE organization_id = x_trolin_tbl(l_index).organization_id
AND inventory_item_id = x_trolin_tbl(l_index).inventory_item_id;
SELECT 'Y'
INTO l_result
FROM DUAL
WHERE exists (
SELECT secondary_locator
FROM mtl_secondary_locators
WHERE organization_id = x_trolin_tbl(l_index).organization_id
AND secondary_locator = x_trolin_tbl(l_index).to_locator_id
AND inventory_item_id = x_trolin_tbl(l_index).inventory_item_id);
SELECT 'Y'
INTO l_result
FROM DUAL
WHERE exists (
SELECT secondary_inventory
FROM mtl_item_sub_inventories
WHERE organization_id = x_trolin_tbl(l_index).organization_id
AND secondary_inventory = x_trolin_tbl(l_index).to_subinventory_code
AND inventory_item_id = x_trolin_tbl(l_index).inventory_item_id);
WSH_INTERFACE.Update_Shipping_Attributes
(p_source_code => 'INV',
p_changed_attributes => l_shipping_attr,
x_return_status => l_return_status
);
print_debug('return error from update shipping attributes',l_api_name);
print_debug('return error from update shipping attributes',l_api_name);
WSH_INTERFACE.Update_Shipping_Attributes
(p_source_code => 'INV',
p_changed_attributes => l_shipping_attr,
x_return_status => l_return_status
);
print_debug('return error from update shipping attributes',l_api_name);
print_debug('return error from update shipping attributes',l_api_name);
WSH_INTERFACE.Update_Shipping_Attributes
(p_source_code => 'INV',
p_changed_attributes => l_shipping_attr,
x_return_status => l_return_status
);
print_debug('return error from update shipping attributes',l_api_name);
print_debug('return error from update shipping attributes',l_api_name);
SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL
INTO x_trolin_tbl(l_index).line_id
FROM DUAL;
x_trolin_tbl(l_index).last_update_date := SYSDATE;
x_trolin_tbl(l_index).last_updated_by := fnd_global.user_id;
x_trolin_tbl(l_index).last_update_login := fnd_global.login_id;
l_new_trolin_tbl(l_count).last_updated_by := x_trolin_tbl(l_index).last_updated_by;
l_new_trolin_tbl(l_count).last_update_date := x_trolin_tbl(l_index).last_update_date;
l_new_trolin_tbl(l_count).last_update_login := x_trolin_tbl(l_index).last_update_login;
l_new_trolin_tbl(l_count).program_update_date := x_trolin_tbl(l_index).program_update_date;
SELECT MTL_TXN_REQUEST_LINES_S.NEXTVAL
INTO x_trolin_tbl(l_index).line_id
FROM DUAL;
x_trolin_tbl(l_index).last_update_date := SYSDATE;
x_trolin_tbl(l_index).last_updated_by := fnd_global.user_id;
x_trolin_tbl(l_index).last_update_login := fnd_global.login_id;
l_new_trolin_tbl(l_count).last_updated_by := x_trolin_tbl(l_index).last_updated_by;
l_new_trolin_tbl(l_count).last_update_date := x_trolin_tbl(l_index).last_update_date;
l_new_trolin_tbl(l_count).last_update_login := x_trolin_tbl(l_index).last_update_login;
l_new_trolin_tbl(l_count).program_update_date := x_trolin_tbl(l_index).program_update_date;
inv_trolin_util.insert_mo_lines_bulk
(p_new_trolin_tbl => l_new_trolin_tbl
,x_return_status => x_return_status);
l_new_trolin_tbl.delete;
print_debug('return error from INSERT_MO_LINES_BULK',l_api_name);
l_trolin_tbl(i).operation := INV_GLOBALS.G_OPR_UPDATE;
if (l_trolin_tbl(i).operation = INV_GLOBALS.G_OPR_UPDATE and
(l_trolin_tbl(i).line_id = FND_API.G_MISS_NUM OR
l_trolin_tbl(i).line_id is null ) ) then
--inv_debug.message('update and no line id');
select count(*)
into l_dummy
from mtl_txn_request_headers
where header_id = l_trolin_tbl(i).header_id
and organization_id = l_trolin_tbl(i).organization_id;
l_api_name CONSTANT VARCHAR2(30):= 'Update_Move_Order_line';
UPDATE mtl_txn_request_lines SET
carton_grouping_id = p_carton_grouping_tbl(i)
WHERE line_id = p_move_order_line_tbl(i);