[Home] [Help]
77:
78: TYPE num_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
79:
80: -- Task Record
81: SUBTYPE task_rec IS wms_dispatched_tasks%ROWTYPE;
82:
83: -- ATF Related constants
84: G_ATF_ACTIVATE_PLAN CONSTANT NUMBER := 1;
85: G_ATF_ABORT_PLAN CONSTANT NUMBER := 2;
1473: -- for inventory LPN
1474: -- Bug 2271470
1475:
1476: --Also delete corresponding WDT and MMTTs. bug # 2503594
1477: DELETE FROM wms_dispatched_tasks
1478: WHERE transaction_temp_id IN(
1479: SELECT transaction_temp_id
1480: FROM mtl_material_transactions_temp
1481: WHERE move_order_line_id IN(
1787: SELECT '1'
1788: INTO wdt_exist
1789: FROM DUAL
1790: WHERE EXISTS(SELECT transaction_temp_id
1791: FROM wms_dispatched_tasks
1792: WHERE transaction_temp_id = l_pregen_suggestion.transaction_temp_id);
1793: EXCEPTION
1794: WHEN NO_DATA_FOUND THEN
1795: wdt_exist := '2';
2464: -- End ATF_J calling operation_plan_assignment and init_op_plan_instance
2465:
2466:
2467: -- ATF_J
2468: -- By pass inserting into WMS_DISPATCHED_TASKS
2469: -- if customer is at patchset J or above,
2470: -- because this will be handled by activate_operation_instance.
2471: -- In other words, only insert WMS_DISPATCHED_TASKS if
2472: -- customer release is below patchset J
2467: -- ATF_J
2468: -- By pass inserting into WMS_DISPATCHED_TASKS
2469: -- if customer is at patchset J or above,
2470: -- because this will be handled by activate_operation_instance.
2471: -- In other words, only insert WMS_DISPATCHED_TASKS if
2472: -- customer release is below patchset J
2473:
2474: -- We should not insert record directly into WDT if the drop type is Manual Drop.
2475: -- Since ATF API activate op instance will be called from complete_putaway_wrapper in this case.
3852: END IF;
3853:
3854: SELECT task_id
3855: INTO l_task_id
3856: FROM wms_dispatched_tasks
3857: WHERE transaction_temp_id = p_temp_id
3858: AND ROWNUM < 2; -- prevent exception
3859: --Bug 2127361 fix
3860:
5464: IF (l_debug = 1) THEN
5465: mydebug(' updating WDT with the group id');
5466: END IF;
5467:
5468: UPDATE wms_dispatched_tasks
5469: SET task_group_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
5470: WHERE transaction_temp_id = p_temp_id;
5471:
5472: l_txn_mode := 2;
6030: END discrepancy;
6031:
6032: -- Important, please note that the input parameter, p_user_id
6033: -- does NOT refer to the fnd user id. Instead it refers to the employee id.
6034: -- It is used against the wms_dispatched_tasks.person_id column which
6035: -- is populated with the employee id.
6036: PROCEDURE check_lpn_validity(
6037: p_org_id IN NUMBER
6038: , p_lpn_id IN NUMBER
6492: INTO l_mo_cnt2
6493: FROM DUAL
6494: WHERE EXISTS(
6495: SELECT 1
6496: FROM wms_dispatched_tasks wdt
6497: , mtl_material_transactions_temp mmtt
6498: , mtl_txn_request_lines mtrl
6499: WHERE mtrl.lpn_id = l_lpn_id
6500: AND mtrl.organization_id = l_org_id
6508: SELECT 1 INTO l_mo_cnt2 FROM DUAL WHERE exists
6509: (SELECT 1
6510: FROM mtl_txn_request_lines mol,
6511: mtl_material_transactions_temp mmtt
6512: , wms_dispatched_tasks wdt
6513: WHERE mol.lpn_id=l_lpn_id
6514: AND mol.organization_id=l_org_id
6515: AND mol.line_id=mmtt.move_order_line_id
6516: AND wdt.transaction_temp_id=mmtt.transaction_temp_id
6593: mydebug('Line id' || l_mmtt_line_id);
6594: mydebug('temp id' || l_temp_id);
6595: END IF;
6596:
6597: -- Insert into WMS_DISPATCHED_TASKS_HISTORY with a status of 6, 'complete'
6598:
6599: l_return_status := fnd_api.g_ret_sts_success;
6600: wms_insert_wdth_pvt.insert_into_wdth
6601: ( x_return_status => l_return_status
6617: IF (l_debug = 1) THEN
6618: mydebug('After wmsdt update');
6619: END IF;
6620:
6621: -- Delete this row from wms_dispatched_tasks
6622: DELETE wms_dispatched_tasks
6623: WHERE transaction_temp_id = l_temp_id;
6624:
6625: -- Delete lot and serial records
6618: mydebug('After wmsdt update');
6619: END IF;
6620:
6621: -- Delete this row from wms_dispatched_tasks
6622: DELETE wms_dispatched_tasks
6623: WHERE transaction_temp_id = l_temp_id;
6624:
6625: -- Delete lot and serial records
6626: BEGIN
6712: mydebug('Batch ID: ' || l_transaction_batch_id);
6713: mydebug('Batch Seq: ' || l_transaction_batch_seq);
6714: END IF;
6715:
6716: -- Insert into WMS_DISPATCHED_TASKS_HISTORY with a status of 6, 'complete'
6717:
6718: l_return_status := fnd_api.g_ret_sts_success;
6719: wms_insert_wdth_pvt.insert_into_wdth
6720: ( x_return_status => l_return_status
6732: END IF;
6733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6734: END IF;
6735:
6736: -- Delete this row from wms_dispatched_tasks
6737: DELETE FROM wms_dispatched_tasks
6738: WHERE transaction_temp_id = l_temp_id;
6739:
6740: IF (l_debug = 1) THEN
6733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6734: END IF;
6735:
6736: -- Delete this row from wms_dispatched_tasks
6737: DELETE FROM wms_dispatched_tasks
6738: WHERE transaction_temp_id = l_temp_id;
6739:
6740: IF (l_debug = 1) THEN
6741: mydebug('archive_task: After wmsdt update');
6895: , l_demand_source_header_id
6896: , l_repetitive_line_id
6897: , l_operation_seq_num
6898: , l_secondary_quantity --OPM Convergence
6899: FROM mtl_material_transactions_temp t, wms_dispatched_tasks w
6900: WHERE t.transaction_temp_id = l_temp_id
6901: AND t.organization_id = l_org_id
6902: AND t.transaction_temp_id = w.transaction_temp_id;
6903:
8066: -- Before clean up call abort operations plan
8067:
8068: -- After Abort Operation plan do clean up.
8069:
8070: DELETE FROM wms_dispatched_tasks
8071: WHERE task_type = 2
8072: AND transaction_temp_id IN
8073: (SELECT transaction_temp_id
8074: FROM mtl_material_transactions_temp
8914:
8915:
8916: -- Delete WDT
8917: FORALL i in 1..l_mmtt_id_tab.COUNT
8918: DELETE FROM wms_dispatched_tasks
8919: WHERE transaction_temp_id = l_mmtt_id_tab(i)
8920: AND task_type = 2;
8921:
8922: