[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
procedure delete_move_order_reservations(
x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,p_move_order_line_id NUMBER) IS
l_mtl_reservation_rec inv_reservation_global.mtl_reservation_rec_type;
SELECT reservation_id
FROM mtl_reservations
WHERE nvl(staged_flag,'N') = 'N'
AND supply_source_type_id = 13
AND demand_source_type_id in (2,8)
AND demand_source_line_id = p_source_line_id;
select txn_source_line_id
into l_txn_source_line_id
from mtl_txn_request_lines
where line_id = p_move_order_line_id;
inv_reservation_pub.delete_reservation
(p_api_version_number => 1.0,
p_init_msg_lst => fnd_api.g_true,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => x_msg_data,
p_rsv_rec => l_mtl_reservation_rec,
p_serial_number => l_original_serial_number);
debug('after delete reservation return status is ' || x_return_status);
procedure delete_move_order_allocation(
x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,p_move_order_line_id NUMBER) IS
l_txn_source_line_id number;
SELECT reservation_id
FROM mtl_reservations
WHERE nvl(staged_flag,'N') = 'N'
AND supply_source_type_id = 13
AND demand_source_type_id in (2,8)
AND demand_source_line_id = p_source_line_id;
update mtl_serial_numbers
set group_mark_id = null
where serial_number in (select fm_serial_number
from mtl_serial_numbers_temp msnt,
mtl_transaction_lots_temp mtlt,
mtl_material_transactions_temp mmtt
where mmtt.move_order_line_id = p_move_order_line_id
and mtlt.transaction_temp_id = mmtt.transaction_temp_id
and msnt.transaction_temp_id = mtlt.serial_transaction_temp_id
UNION
select fm_serial_number
from mtl_serial_numbers_temp msnt,
mtl_material_transactions_temp mmtt
where mmtt.move_order_line_id = p_move_order_line_id
and msnt.transaction_temp_id = mmtt.transaction_temp_id);
delete from mtl_serial_numbers_temp
where transaction_temp_id in (select transaction_temp_id
from mtl_material_transactions_temp mmtt
where mmtt.move_order_line_id = p_move_order_line_id
UNION
select mtlt.serial_transaction_temp_id
from mtl_material_transactions_temp mmtt,
mtl_transaction_lots_temp mtlt
where mmtt.move_order_line_id = p_move_order_line_id
and mtlt.transaction_temp_id = mmtt.transaction_temp_id);
delete from mtl_transaction_lots_temp
where transaction_temp_id in (select transaction_temp_id
from mtl_material_transactions_temp mmtt
where mmtt.move_order_line_id = p_move_order_line_id);
delete from mtl_material_transactions_temp
where move_order_line_id = p_move_order_line_id;
select transaction_temp_id,transaction_quantity
from mtl_material_transactions_temp
where move_order_line_id = p_move_order_line_id;
l_update_rec inv_reservation_global.mtl_reservation_rec_type;
l_prim_quantity_to_delete NUMBER;
SELECT MRSV.*
FROM MTL_RESERVATIONS MRSV, MTL_TXN_REQUEST_LINES MTRL
WHERE MTRL.LINE_ID = P_MOVE_ORDER_LINE_ID
AND MTRL.TXN_SOURCE_LINE_ID = MRSV.DEMAND_SOURCE_LINE_ID
AND Nvl(MRSV.inventory_item_id,'-9999') = Nvl(p_inventory_item_id,'-9999')
AND Nvl(MRSV.subinventory_code,'@@@@') = Nvl(p_subinventory_code,'@@@@')
AND NVL(MRSV.locator_id,'-9999') = NVL(l_locator_id,'-9999')
AND Nvl(MRSV.revision,'@@@@') = Nvl(l_revision,'@@@@')
AND Nvl(MRSV.LOT_NUMBER,'@@@@') = Nvl(l_lot_number,'@@@@')
AND ROWNUM=1;
select concatenated_segments
into l_item_name
from mtl_system_items_kfv
where inventory_item_id = p_inventory_item_id
and organization_id = p_organization_id;
SELECT expiration_date INTO l_lot_expiration_date
FROM mtl_lot_numbers
WHERE inventory_item_id = p_inventory_item_id
AND organization_id = p_organization_id
AND lot_number = l_lot_number;
select * into l_mmtt_rec
from mtl_material_transactions_temp
where move_order_line_id = p_move_order_line_id
and rownum = 1;
SELECT 1
INTO l_ato_item
FROM mtl_system_items msi
WHERE msi.inventory_item_id = p_inventory_item_id
AND msi.organization_id = p_organization_id
AND msi.replenish_to_order_flag ='Y'
AND msi.bom_item_type = 4;
,p_quantity_to_delete =>l_transaction_rec.transaction_quantity);
, p_quantity_to_delete => 0
, p_ato_serial_pick =>'Y');
l_prim_quantity_to_delete := 1;
l_update_rec := l_rsv_tbl(1);
IF l_update_rec.detailed_quantity > l_prim_quantity_to_delete THEN
l_update_rec.detailed_quantity := l_update_rec.detailed_quantity - l_prim_quantity_to_delete;
l_update_rec.detailed_quantity := 0;
l_update_rec.reservation_quantity := NULL;
IF l_update_rec.primary_reservation_quantity > l_prim_quantity_to_delete THEN
l_update_rec.primary_reservation_quantity := l_update_rec.primary_reservation_quantity - l_prim_quantity_to_delete;
ELSE -- delete entire reservation
l_update_rec.primary_reservation_quantity := 0;
DEBUG('update reservation');
inv_reservation_pub.update_reservation(
p_api_version_number => 1.0
, p_init_msg_lst => fnd_api.g_true
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
, p_original_rsv_rec => l_rsv_tbl(1)
, p_to_rsv_rec => l_update_rec
, p_original_serial_number => l_dummy_sn
, p_to_serial_number => l_dummy_sn
, p_validation_flag => fnd_api.g_true
);
DEBUG('Update reservation returned error');
DEBUG('Update reservation returned unexpected error');
inv_quantity_tree_pub.update_quantities
(p_api_version_number => 1.0,
p_init_msg_lst => fnd_api.g_false,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_organization_id => p_organization_id,
p_inventory_item_id => p_inventory_item_id,
p_tree_mode => l_tree_mode,
p_is_revision_control => l_is_revision_control,
p_is_lot_control => l_is_lot_control,
p_is_serial_control => TRUE,
-- p_demand_source_type_id => p_source_type_id,
-- p_demand_source_header_id => l_trx_source_id,
-- p_demand_source_line_id => l_trx_source_line_id,
p_revision => l_revision,
p_lot_number => l_lot_number,
p_subinventory_code => p_subinventory_code,
p_locator_id => l_locator_id,
p_primary_quantity => -1,
p_quantity_type => l_quantity_type,
p_onhand_source => l_onhand_source,
x_qoh => l_qoh,
x_rqoh => l_rqoh,
x_qr => l_qr,
x_qs => l_qs,
x_att => l_att,
x_atr => l_atr);
FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
inv_quantity_tree_pub.update_quantities
(p_api_version_number => 1.0,
p_init_msg_lst => fnd_api.g_false,
x_return_status => x_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_organization_id => p_organization_id,
p_inventory_item_id => p_inventory_item_id,
p_tree_mode => l_tree_mode,
p_is_revision_control => l_is_revision_control,
p_is_lot_control => l_is_lot_control,
p_is_serial_control => TRUE,
-- p_demand_source_type_id => p_source_type_id,
-- p_demand_source_header_id => l_trx_source_id,
-- p_demand_source_line_id => l_trx_source_line_id,
p_revision => l_revision,
p_lot_number => l_lot_number,
p_subinventory_code => p_to_subinventory_code,
p_locator_id => l_to_locator_id,
p_primary_quantity => 1,
p_quantity_type => l_quantity_type,
p_onhand_source => l_onhand_source,
x_qoh => l_qoh,
x_rqoh => l_rqoh,
x_qr => l_qr,
x_qs => l_qs,
x_att => l_att,
x_atr => l_atr);
FND_MESSAGE.set_token('ROUTINE','INV_QUANTITY_TREE_PUB.UPDATE_QUANTITIES');
SELECT mtl_material_transactions_s.NEXTVAL
INTO l_new_temp_id
FROM dual;
INSERT INTO MTL_MATERIAL_TRANSACTIONS_TEMP
(
TRANSACTION_HEADER_ID
, TRANSACTION_TEMP_ID
, SOURCE_CODE
, SOURCE_LINE_ID
, TRANSACTION_MODE
, LOCK_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, INVENTORY_ITEM_ID
, REVISION
, ORGANIZATION_ID
, SUBINVENTORY_CODE
, LOCATOR_ID
, TRANSACTION_QUANTITY
, PRIMARY_QUANTITY
, TRANSACTION_UOM
, TRANSACTION_COST
, TRANSACTION_TYPE_ID
, TRANSACTION_ACTION_ID
, TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_SOURCE_ID
, TRANSACTION_SOURCE_NAME
, TRANSACTION_DATE
, ACCT_PERIOD_ID
, DISTRIBUTION_ACCOUNT_ID
, TRANSACTION_REFERENCE
, REQUISITION_LINE_ID
, REQUISITION_DISTRIBUTION_ID
, REASON_ID
, LOT_NUMBER
, LOT_EXPIRATION_DATE
, SERIAL_NUMBER
, RECEIVING_DOCUMENT
, DEMAND_ID
, RCV_TRANSACTION_ID
, MOVE_TRANSACTION_ID
, COMPLETION_TRANSACTION_ID
, WIP_ENTITY_TYPE
, SCHEDULE_ID
, REPETITIVE_LINE_ID
, EMPLOYEE_CODE
, PRIMARY_SWITCH
, SCHEDULE_UPDATE_CODE
, SETUP_TEARDOWN_CODE
, ITEM_ORDERING
, NEGATIVE_REQ_FLAG
, OPERATION_SEQ_NUM
, PICKING_LINE_ID
, TRX_SOURCE_LINE_ID
, TRX_SOURCE_DELIVERY_ID
, PHYSICAL_ADJUSTMENT_ID
, CYCLE_COUNT_ID
, RMA_LINE_ID
, CUSTOMER_SHIP_ID
, CURRENCY_CODE
, CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE
, CURRENCY_CONVERSION_DATE
, USSGL_TRANSACTION_CODE
, VENDOR_LOT_NUMBER
, ENCUMBRANCE_ACCOUNT
, ENCUMBRANCE_AMOUNT
, SHIP_TO_LOCATION
, SHIPMENT_NUMBER
, TRANSFER_COST
, TRANSPORTATION_COST
, TRANSPORTATION_ACCOUNT
, FREIGHT_CODE
, CONTAINERS
, WAYBILL_AIRBILL
, EXPECTED_ARRIVAL_DATE
, TRANSFER_SUBINVENTORY
, TRANSFER_ORGANIZATION
, TRANSFER_TO_LOCATION
, NEW_AVERAGE_COST
, VALUE_CHANGE
, PERCENTAGE_CHANGE
, MATERIAL_ALLOCATION_TEMP_ID
, DEMAND_SOURCE_HEADER_ID
, DEMAND_SOURCE_LINE
, DEMAND_SOURCE_DELIVERY
, ITEM_SEGMENTS
, ITEM_DESCRIPTION
, ITEM_TRX_ENABLED_FLAG
, ITEM_LOCATION_CONTROL_CODE
, ITEM_RESTRICT_SUBINV_CODE
, ITEM_RESTRICT_LOCATORS_CODE
, ITEM_REVISION_QTY_CONTROL_CODE
, ITEM_PRIMARY_UOM_CODE
, ITEM_UOM_CLASS
, ITEM_SHELF_LIFE_CODE
, ITEM_SHELF_LIFE_DAYS
, ITEM_LOT_CONTROL_CODE
, ITEM_SERIAL_CONTROL_CODE
, ITEM_INVENTORY_ASSET_FLAG
, ALLOWED_UNITS_LOOKUP_CODE
, DEPARTMENT_ID
, DEPARTMENT_CODE
, WIP_SUPPLY_TYPE
, SUPPLY_SUBINVENTORY
, SUPPLY_LOCATOR_ID
, VALID_SUBINVENTORY_FLAG
, VALID_LOCATOR_FLAG
, LOCATOR_SEGMENTS
, CURRENT_LOCATOR_CONTROL_CODE
, NUMBER_OF_LOTS_ENTERED
, WIP_COMMIT_FLAG
, NEXT_LOT_NUMBER
, LOT_ALPHA_PREFIX
, NEXT_SERIAL_NUMBER
, SERIAL_ALPHA_PREFIX
, SHIPPABLE_FLAG
, POSTING_FLAG
, REQUIRED_FLAG
, PROCESS_FLAG
, ERROR_CODE
, ERROR_EXPLANATION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, MOVEMENT_ID
, RESERVATION_QUANTITY
, SHIPPED_QUANTITY
, TRANSACTION_LINE_NUMBER
, TASK_ID
, TO_TASK_ID
, SOURCE_TASK_ID
, PROJECT_ID
, SOURCE_PROJECT_ID
, PA_EXPENDITURE_ORG_ID
, TO_PROJECT_ID
, EXPENDITURE_TYPE
, FINAL_COMPLETION_FLAG
, TRANSFER_PERCENTAGE
, TRANSACTION_SEQUENCE_ID
, MATERIAL_ACCOUNT
, MATERIAL_OVERHEAD_ACCOUNT
, RESOURCE_ACCOUNT
, OUTSIDE_PROCESSING_ACCOUNT
, OVERHEAD_ACCOUNT
, FLOW_SCHEDULE
, COST_GROUP_ID
, DEMAND_CLASS
, QA_COLLECTION_ID
, KANBAN_CARD_ID
, OVERCOMPLETION_TRANSACTION_ID
, OVERCOMPLETION_PRIMARY_QTY
, OVERCOMPLETION_TRANSACTION_QTY
, END_ITEM_UNIT_NUMBER
, SCHEDULED_PAYBACK_DATE
, LINE_TYPE_CODE
, PARENT_TRANSACTION_TEMP_ID
, PUT_AWAY_STRATEGY_ID
, PUT_AWAY_RULE_ID
, PICK_STRATEGY_ID
, PICK_RULE_ID
, COMMON_BOM_SEQ_ID
, COMMON_ROUTING_SEQ_ID
, COST_TYPE_ID
, ORG_COST_GROUP_ID
, MOVE_ORDER_LINE_ID
, TASK_GROUP_ID
, PICK_SLIP_NUMBER
, RESERVATION_ID
, TRANSACTION_STATUS
, TRANSFER_COST_GROUP_ID
, LPN_ID
, transfer_lpn_id
, content_lpn_id
, cartonization_id
, standard_operation_id
, wms_task_type
, task_priority
, container_item_id
) VALUES
(
l_mmtt_rec.TRANSACTION_HEADER_ID
, l_new_temp_id
, l_mmtt_rec.SOURCE_CODE
, l_mmtt_rec.SOURCE_LINE_ID
, l_mmtt_rec.TRANSACTION_MODE
, l_mmtt_rec.LOCK_FLAG
, sysdate
, p_user_id
, sysdate
, p_user_id
, l_mmtt_rec.LAST_UPDATE_LOGIN
, l_mmtt_rec.REQUEST_ID
, l_mmtt_rec.PROGRAM_APPLICATION_ID
, l_mmtt_rec.PROGRAM_ID
, l_mmtt_rec.PROGRAM_UPDATE_DATE
, l_mmtt_rec.INVENTORY_ITEM_ID
, l_REVISION
, P_ORGANIZATION_ID
, P_SUBINVENTORY_CODE
, decode(P_LOCATOR_ID,0,null, P_LOCATOR_ID)
, 1
, 1
, l_mmtt_rec.TRANSACTION_UOM
, l_mmtt_rec.TRANSACTION_COST
, l_mmtt_rec.TRANSACTION_TYPE_ID
, l_mmtt_rec.TRANSACTION_ACTION_ID
, l_mmtt_rec.TRANSACTION_SOURCE_TYPE_ID
, l_mmtt_rec.TRANSACTION_SOURCE_ID
, l_mmtt_rec.TRANSACTION_SOURCE_NAME
, sysdate --, l_mmtt_rec.TRANSACTION_DATE
, l_period_id --l_mmtt_rec.ACCT_PERIOD_ID
, l_mmtt_rec.DISTRIBUTION_ACCOUNT_ID
, l_mmtt_rec.TRANSACTION_REFERENCE
, l_mmtt_rec.REQUISITION_LINE_ID
, l_mmtt_rec.REQUISITION_DISTRIBUTION_ID
, l_REASON_ID
, l_mmtt_rec.LOT_NUMBER
, l_mmtt_rec.LOT_EXPIRATION_DATE
, l_mmtt_rec.SERIAL_NUMBER
, l_mmtt_rec.RECEIVING_DOCUMENT
, l_mmtt_rec.DEMAND_ID
, l_mmtt_rec.RCV_TRANSACTION_ID
, l_mmtt_rec.MOVE_TRANSACTION_ID
, l_mmtt_rec.COMPLETION_TRANSACTION_ID
, l_mmtt_rec.WIP_ENTITY_TYPE
, l_mmtt_rec.SCHEDULE_ID
, l_mmtt_rec.REPETITIVE_LINE_ID
, l_mmtt_rec.EMPLOYEE_CODE
, l_mmtt_rec.PRIMARY_SWITCH
, l_mmtt_rec.SCHEDULE_UPDATE_CODE
, l_mmtt_rec.SETUP_TEARDOWN_CODE
, l_mmtt_rec.ITEM_ORDERING
, l_mmtt_rec.NEGATIVE_REQ_FLAG
, l_mmtt_rec.OPERATION_SEQ_NUM
, l_mmtt_rec.PICKING_LINE_ID
, l_mmtt_rec.TRX_SOURCE_LINE_ID
, l_mmtt_rec.TRX_SOURCE_DELIVERY_ID
, l_mmtt_rec.PHYSICAL_ADJUSTMENT_ID
, l_mmtt_rec.CYCLE_COUNT_ID
, l_mmtt_rec.RMA_LINE_ID
, l_mmtt_rec.CUSTOMER_SHIP_ID
, l_mmtt_rec.CURRENCY_CODE
, l_mmtt_rec.CURRENCY_CONVERSION_RATE
, l_mmtt_rec.CURRENCY_CONVERSION_TYPE
, l_mmtt_rec.CURRENCY_CONVERSION_DATE
, l_mmtt_rec.USSGL_TRANSACTION_CODE
, l_mmtt_rec.VENDOR_LOT_NUMBER
, l_mmtt_rec.ENCUMBRANCE_ACCOUNT
, l_mmtt_rec.ENCUMBRANCE_AMOUNT
, l_mmtt_rec.SHIP_TO_LOCATION
, l_mmtt_rec.SHIPMENT_NUMBER
, l_mmtt_rec.TRANSFER_COST
, l_mmtt_rec.TRANSPORTATION_COST
, l_mmtt_rec.TRANSPORTATION_ACCOUNT
, l_mmtt_rec.FREIGHT_CODE
, l_mmtt_rec.CONTAINERS
, l_mmtt_rec.WAYBILL_AIRBILL
, l_mmtt_rec.EXPECTED_ARRIVAL_DATE
, p_to_SUBINVENTORY_code
, l_mmtt_rec.TRANSFER_ORGANIZATION
, decode(p_to_locator_id,0,null,p_to_locator_id)
, l_mmtt_rec.NEW_AVERAGE_COST
, l_mmtt_rec.VALUE_CHANGE
, l_mmtt_rec.PERCENTAGE_CHANGE
, l_mmtt_rec.MATERIAL_ALLOCATION_TEMP_ID
, l_mmtt_rec.DEMAND_SOURCE_HEADER_ID
, l_mmtt_rec.DEMAND_SOURCE_LINE
, l_mmtt_rec.DEMAND_SOURCE_DELIVERY
, l_mmtt_rec.ITEM_SEGMENTS
, l_mmtt_rec.ITEM_DESCRIPTION
, l_mmtt_rec.ITEM_TRX_ENABLED_FLAG
, l_mmtt_rec.ITEM_LOCATION_CONTROL_CODE
, l_mmtt_rec.ITEM_RESTRICT_SUBINV_CODE
, l_mmtt_rec.ITEM_RESTRICT_LOCATORS_CODE
, l_mmtt_rec.ITEM_REVISION_QTY_CONTROL_CODE
, l_mmtt_rec.ITEM_PRIMARY_UOM_CODE
, l_mmtt_rec.ITEM_UOM_CLASS
, l_mmtt_rec.ITEM_SHELF_LIFE_CODE
, l_mmtt_rec.ITEM_SHELF_LIFE_DAYS
, l_mmtt_rec.ITEM_LOT_CONTROL_CODE
, l_mmtt_rec.ITEM_SERIAL_CONTROL_CODE
, l_mmtt_rec.ITEM_INVENTORY_ASSET_FLAG
, l_mmtt_rec.ALLOWED_UNITS_LOOKUP_CODE
, l_mmtt_rec.DEPARTMENT_ID
, l_mmtt_rec.DEPARTMENT_CODE
, l_mmtt_rec.WIP_SUPPLY_TYPE
, l_mmtt_rec.SUPPLY_SUBINVENTORY
, l_mmtt_rec.SUPPLY_LOCATOR_ID
, l_mmtt_rec.VALID_SUBINVENTORY_FLAG
, l_mmtt_rec.VALID_LOCATOR_FLAG
, l_mmtt_rec.LOCATOR_SEGMENTS
, l_mmtt_rec.CURRENT_LOCATOR_CONTROL_CODE
, l_mmtt_rec.NUMBER_OF_LOTS_ENTERED
, l_mmtt_rec.WIP_COMMIT_FLAG
, l_mmtt_rec.NEXT_LOT_NUMBER
, l_mmtt_rec.LOT_ALPHA_PREFIX
, l_mmtt_rec.NEXT_SERIAL_NUMBER
, l_mmtt_rec.SERIAL_ALPHA_PREFIX
, l_mmtt_rec.SHIPPABLE_FLAG
, l_mmtt_rec.POSTING_FLAG
, l_mmtt_rec.REQUIRED_FLAG
, l_mmtt_rec.PROCESS_FLAG
, l_mmtt_rec.ERROR_CODE
, l_mmtt_rec.ERROR_EXPLANATION
, l_mmtt_rec.ATTRIBUTE_CATEGORY
, l_mmtt_rec.ATTRIBUTE1
, l_mmtt_rec.ATTRIBUTE2
, l_mmtt_rec.ATTRIBUTE3
, l_mmtt_rec.ATTRIBUTE4
, l_mmtt_rec.ATTRIBUTE5
, l_mmtt_rec.ATTRIBUTE6
, l_mmtt_rec.ATTRIBUTE7
, l_mmtt_rec.ATTRIBUTE8
, l_mmtt_rec.ATTRIBUTE9
, l_mmtt_rec.ATTRIBUTE10
, l_mmtt_rec.ATTRIBUTE11
, l_mmtt_rec.ATTRIBUTE12
, l_mmtt_rec.ATTRIBUTE13
, l_mmtt_rec.ATTRIBUTE14
, l_mmtt_rec.ATTRIBUTE15
, l_mmtt_rec.MOVEMENT_ID
, null -- reservation quantity
, l_mmtt_rec.SHIPPED_QUANTITY
, l_mmtt_rec.TRANSACTION_LINE_NUMBER
, l_mmtt_rec.TASK_ID
, l_mmtt_rec.TO_TASK_ID
, l_mmtt_rec.SOURCE_TASK_ID
, l_mmtt_rec.PROJECT_ID
, l_mmtt_rec.SOURCE_PROJECT_ID
, l_mmtt_rec.PA_EXPENDITURE_ORG_ID
, l_mmtt_rec.TO_PROJECT_ID
, l_mmtt_rec.EXPENDITURE_TYPE
, l_mmtt_rec.FINAL_COMPLETION_FLAG
, l_mmtt_rec.TRANSFER_PERCENTAGE
, l_mmtt_rec.TRANSACTION_SEQUENCE_ID
, l_mmtt_rec.MATERIAL_ACCOUNT
, l_mmtt_rec.MATERIAL_OVERHEAD_ACCOUNT
, l_mmtt_rec.RESOURCE_ACCOUNT
, l_mmtt_rec.OUTSIDE_PROCESSING_ACCOUNT
, l_mmtt_rec.OVERHEAD_ACCOUNT
, l_mmtt_rec.FLOW_SCHEDULE
, l_mmtt_rec.COST_GROUP_ID
, l_mmtt_rec.DEMAND_CLASS
, l_mmtt_rec.QA_COLLECTION_ID
, l_mmtt_rec.KANBAN_CARD_ID
, l_mmtt_rec.OVERCOMPLETION_TRANSACTION_ID
, l_mmtt_rec.OVERCOMPLETION_PRIMARY_QTY
, l_mmtt_rec.OVERCOMPLETION_TRANSACTION_QTY
, l_mmtt_rec.END_ITEM_UNIT_NUMBER
, l_mmtt_rec.SCHEDULED_PAYBACK_DATE
, l_mmtt_rec.LINE_TYPE_CODE
, l_mmtt_rec.PARENT_TRANSACTION_TEMP_ID
, l_mmtt_rec.PUT_AWAY_STRATEGY_ID
, l_mmtt_rec.PUT_AWAY_RULE_ID
, l_mmtt_rec.PICK_STRATEGY_ID
, l_mmtt_rec.PICK_RULE_ID
, l_mmtt_rec.COMMON_BOM_SEQ_ID
, l_mmtt_rec.COMMON_ROUTING_SEQ_ID
, l_mmtt_rec.COST_TYPE_ID
, l_mmtt_rec.ORG_COST_GROUP_ID
, l_mmtt_rec.MOVE_ORDER_LINE_ID
, l_mmtt_rec.TASK_GROUP_ID
, l_mmtt_rec.PICK_SLIP_NUMBER
, null -- reservation id
, 3 -- TRANSACTION_STATUS
, l_mmtt_rec.TRANSFER_COST_GROUP_ID
, l_mmtt_rec.lpn_id
, l_mmtt_rec.transfer_lpn_id
, l_mmtt_rec.content_lpn_id
, l_mmtt_rec.cartonization_id
, l_mmtt_rec.standard_operation_id
, l_mmtt_rec.wms_task_type
, l_mmtt_rec.task_priority
, l_mmtt_rec.container_item_id
);
debug('After inserting to the MMTT');
debug('Inserting the lot '||p_lot_number);
l_return_result := INV_TRX_UTIL_PUB.insert_lot_trx
(p_trx_tmp_id => l_new_temp_id,
p_user_id => p_user_id,
p_lot_number => p_lot_number,
p_trx_qty => 1,
p_pri_qty => 1,
x_ser_trx_id => l_serial_temp_id,
x_proc_msg => x_error_msg);
debug('Before inserting serial number, temp_id is '||to_char(l_new_temp_id));
debug('inserting serial number '||p_serial_number);
l_return_result := inv_trx_util_pub.insert_ser_trx
(p_trx_tmp_id => l_serial_temp_id,
p_user_id => p_user_id,
p_fm_ser_num => p_serial_number,
p_to_ser_num => NULL,
x_proc_msg => x_error_msg);
debug('failed to insert serial '||p_serial_number);
debug('inserted the serial number '||p_serial_number);
select organization_id,from_subinventory_code,from_locator_id
into l_organization_id,l_sub_code,l_locator_id
from mtl_txn_request_lines
where line_id = p_move_order_line_id;
select source_header_id,source_line_id,delivery_detail_id
into l_source_header_id,l_source_line_id,l_delivery_detail_id
from wsh_delivery_details
where move_order_line_id = p_move_order_line_id
and released_status = 'S';
WSH_INTERFACE.Update_Shipping_Attributes
(p_source_code => 'INV',
p_changed_attributes => l_shipping_attr,
x_return_status => l_api_return_status
);
debug('return error from update shipping attributes');
debug('return error from update shipping attributes');