[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_into_wdth
( x_return_status OUT NOCOPY VARCHAR2,
p_txn_header_id IN NUMBER,
p_transaction_temp_id IN NUMBER,
p_transaction_batch_id IN NUMBER,
p_transaction_batch_seq IN NUMBER,
p_transfer_lpn_id IN NUMBER) IS
BEGIN
insert_into_wdth
(x_return_status => x_return_status,
p_txn_header_id => p_txn_header_id,
p_transaction_temp_id => p_transaction_temp_id,
p_transaction_batch_id => p_transaction_batch_id,
p_transaction_batch_seq => p_transaction_batch_seq,
p_transfer_lpn_id => p_transfer_lpn_id,
p_status => 6);
PROCEDURE insert_into_wdth
( x_return_status OUT NOCOPY VARCHAR2,
p_txn_header_id IN NUMBER,
p_transaction_temp_id IN NUMBER,
p_transaction_batch_id IN NUMBER,
p_transaction_batch_seq IN NUMBER,
p_transfer_lpn_id IN NUMBER,
p_status IN NUMBER,
p_orig_transaction_temp_id IN NUMBER DEFAULT NULL) IS --Bug12812580
l_api_name VARCHAR2(30) := 'insert_into_wdth';
INSERT INTO wms_dispatched_tasks_history
( task_id
, transaction_id
, organization_id
, transaction_batch_id
, transaction_batch_seq
, user_task_type
, person_id
, effective_start_date
, effective_end_date
, equipment_id
, equipment_instance
, person_resource_id
, machine_resource_id
, status
, dispatched_time
, last_update_date
, last_updated_by
, creation_date
, created_by
, task_type
, loaded_time
, drop_off_time
, suggested_dest_subinventory
, suggested_dest_locator_id
, operation_plan_id
, move_order_line_id
, transfer_lpn_id
, inventory_item_id
, revision
, transaction_type_id
, transaction_source_type_id
, transaction_action_id
, source_subinventory_code
, source_locator_id
, dest_subinventory_code
, dest_locator_id
, lpn_id
, content_lpn_id
, transaction_temp_id
, priority -- For bug 5401222
,is_parent --ER13869750
,transaction_quantity --ER13869750
,transaction_uom_code --ER13869750
,secondary_transaction_quantity --ER13869750
,secondary_transaction_uom_code --ER13869750
)
(SELECT wdt.task_id
, p_txn_header_id
, wdt.organization_id
, p_transaction_batch_id
, p_transaction_batch_seq
, wdt.user_task_type
, wdt.person_id
, SYSDATE -- wdt.effective_start_date (for bug#5412974)
, SYSDATE -- wdt.effective_end_date (for bug#5412974)
, wdt.equipment_id
, wdt.equipment_instance
, wdt.person_resource_id
, wdt.machine_resource_id
, p_status
, wdt.dispatched_time
, SYSDATE
, fnd_global.user_id
, SYSDATE
, fnd_global.user_id
, wdt.task_type
, wdt.loaded_time
, SYSDATE
, wdt.suggested_dest_subinventory
, wdt.suggested_dest_locator_id
, wdt.operation_plan_id
, wdt.move_order_line_id
, p_transfer_lpn_id
, mmtt.inventory_item_id
, mmtt.revision
, mmtt.transaction_type_id
, mmtt.transaction_source_type_id
, mmtt.transaction_action_id
, mmtt.subinventory_code
, mmtt.locator_id
, mmtt.transfer_subinventory
, mmtt.transfer_to_location
, mmtt.lpn_id
, mmtt.content_lpn_id
, mmtt.transaction_temp_id
, nvl(wdt.priority,mmtt.task_priority) -- For bug 5401222
,Decode (mmtt.parent_line_id,NULL,'N','Y') --ER13869750
,mmtt.transaction_quantity --ER13869750
,mmtt.transaction_UOM --ER13869750
,mmtt.secondary_transaction_quantity --ER13869750
,substr(mmtt.secondary_uom_code,1,3) --ER13869750
FROM wms_dispatched_tasks wdt
, mtl_material_transactions_temp mmtt
WHERE wdt.transaction_temp_id = p_transaction_temp_id
AND wdt.transaction_temp_id = mmtt.transaction_temp_id
);
INSERT INTO wms_dispatched_tasks_history
( task_id
, transaction_id
, organization_id
, transaction_batch_id
, transaction_batch_seq
, user_task_type
, person_id
, effective_start_date
, effective_end_date
, equipment_id
, equipment_instance
, person_resource_id
, machine_resource_id
, status
, dispatched_time
, last_update_date
, last_updated_by
, creation_date
, created_by
, task_type
, loaded_time
, drop_off_time
, suggested_dest_subinventory
, suggested_dest_locator_id
, operation_plan_id
, move_order_line_id
, transfer_lpn_id
, inventory_item_id
, revision
, transaction_type_id
, transaction_source_type_id
, transaction_action_id
, source_subinventory_code
, source_locator_id
, dest_subinventory_code
, dest_locator_id
, lpn_id
, content_lpn_id
, transaction_temp_id
, priority -- For bug 5401222
,is_parent --ER13869750
,transaction_quantity --ER13869750
,transaction_uom_code --ER13869750
,secondary_transaction_quantity --ER13869750
,secondary_transaction_uom_code --ER13869750
)
(SELECT Nvl(wdt.task_id, wms_dispatched_tasks_s.NEXTVAL)
, p_txn_header_id
, Nvl(wdt.organization_id, wdt_orig.organization_id)
, p_transaction_batch_id
, p_transaction_batch_seq
, Nvl(wdt.user_task_type, wdt_orig.user_task_type)
, Nvl(wdt.person_id, wdt_orig.person_id)
, SYSDATE -- wdt.effective_start_date (for bug#5412974)
, SYSDATE -- wdt.effective_end_date (for bug#5412974)
, Nvl(wdt.equipment_id, wdt_orig.equipment_id)
, Nvl(wdt.equipment_instance, wdt_orig.equipment_instance)
, Nvl(wdt.person_resource_id, wdt_orig.person_resource_id)
, Nvl(wdt.machine_resource_id, wdt_orig.machine_resource_id)
, p_status
, wdt.dispatched_time
, SYSDATE
, fnd_global.user_id
, SYSDATE
, fnd_global.user_id
, Nvl(wdt.task_type, wdt_orig.task_type)
, wdt.loaded_time
, SYSDATE
, wdt.suggested_dest_subinventory
, wdt.suggested_dest_locator_id
, wdt.operation_plan_id
, Nvl(wdt.move_order_line_id, mmtt.move_order_line_id)
, p_transfer_lpn_id
, mmtt.inventory_item_id
, mmtt.revision
, mmtt.transaction_type_id
, mmtt.transaction_source_type_id
, mmtt.transaction_action_id
, mmtt.subinventory_code
, mmtt.locator_id
, mmtt.transfer_subinventory
, mmtt.transfer_to_location
, mmtt.lpn_id
, mmtt.content_lpn_id
, mmtt.transaction_temp_id
, nvl(wdt.priority,mmtt.task_priority) -- For bug 5401222
,Decode (mmtt.parent_line_id,NULL,'N','Y') --ER13869750
,mmtt.transaction_quantity --ER13869750
,mmtt.transaction_UOM --ER13869750
,mmtt.secondary_transaction_quantity --ER13869750
,substr(mmtt.secondary_uom_code,1,3) --ER13869750
FROM wms_dispatched_tasks wdt
, mtl_material_transactions_temp mmtt
, wms_dispatched_tasks wdt_orig
WHERE mmtt.transaction_temp_id = p_transaction_temp_id
AND mmtt.transaction_temp_id = wdt.transaction_temp_id (+)
AND wdt_orig.transaction_temp_id = p_orig_transaction_temp_id
);
END insert_into_wdth;