[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;
1328: -- for inventory LPN
1329: -- Bug 2271470
1330:
1331: --Also delete corresponding WDT and MMTTs. bug # 2503594
1332: DELETE FROM wms_dispatched_tasks
1333: WHERE transaction_temp_id IN(
1334: SELECT transaction_temp_id
1335: FROM mtl_material_transactions_temp
1336: WHERE move_order_line_id IN(
1642: SELECT '1'
1643: INTO wdt_exist
1644: FROM DUAL
1645: WHERE EXISTS(SELECT transaction_temp_id
1646: FROM wms_dispatched_tasks
1647: WHERE transaction_temp_id = l_pregen_suggestion.transaction_temp_id);
1648: EXCEPTION
1649: WHEN NO_DATA_FOUND THEN
1650: wdt_exist := '2';
2292: -- End ATF_J calling operation_plan_assignment and init_op_plan_instance
2293:
2294:
2295: -- ATF_J
2296: -- By pass inserting into WMS_DISPATCHED_TASKS
2297: -- if customer is at patchset J or above,
2298: -- because this will be handled by activate_operation_instance.
2299: -- In other words, only insert WMS_DISPATCHED_TASKS if
2300: -- customer release is below patchset J
2295: -- ATF_J
2296: -- By pass inserting into WMS_DISPATCHED_TASKS
2297: -- if customer is at patchset J or above,
2298: -- because this will be handled by activate_operation_instance.
2299: -- In other words, only insert WMS_DISPATCHED_TASKS if
2300: -- customer release is below patchset J
2301:
2302: -- We should not insert record directly into WDT if the drop type is Manual Drop.
2303: -- Since ATF API activate op instance will be called from complete_putaway_wrapper in this case.
3647: END IF;
3648:
3649: SELECT task_id
3650: INTO l_task_id
3651: FROM wms_dispatched_tasks
3652: WHERE transaction_temp_id = p_temp_id
3653: AND ROWNUM < 2; -- prevent exception
3654: --Bug 2127361 fix
3655:
5218: IF (l_debug = 1) THEN
5219: mydebug(' updating WDT with the group id');
5220: END IF;
5221:
5222: UPDATE wms_dispatched_tasks
5223: SET task_group_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
5224: WHERE transaction_temp_id = p_temp_id;
5225:
5226: l_txn_mode := 2;
5753: END discrepancy;
5754:
5755: -- Important, please note that the input parameter, p_user_id
5756: -- does NOT refer to the fnd user id. Instead it refers to the employee id.
5757: -- It is used against the wms_dispatched_tasks.person_id column which
5758: -- is populated with the employee id.
5759: PROCEDURE check_lpn_validity(
5760: p_org_id IN NUMBER
5761: , p_lpn_id IN NUMBER
6165: INTO l_mo_cnt2
6166: FROM DUAL
6167: WHERE EXISTS(
6168: SELECT 1
6169: FROM wms_dispatched_tasks wdt
6170: , mtl_material_transactions_temp mmtt
6171: , mtl_txn_request_lines mtrl
6172: WHERE mtrl.lpn_id = l_lpn_id
6173: AND mtrl.organization_id = l_org_id
6181: SELECT 1 INTO l_mo_cnt2 FROM DUAL WHERE exists
6182: (SELECT 1
6183: FROM mtl_txn_request_lines mol,
6184: mtl_material_transactions_temp mmtt
6185: , wms_dispatched_tasks wdt
6186: WHERE mol.lpn_id=l_lpn_id
6187: AND mol.organization_id=l_org_id
6188: AND mol.line_id=mmtt.move_order_line_id
6189: AND wdt.transaction_temp_id=mmtt.transaction_temp_id
6266: mydebug('Line id' || l_mmtt_line_id);
6267: mydebug('temp id' || l_temp_id);
6268: END IF;
6269:
6270: -- Insert into WMS_DISPATCHED_TASKS_HISTORY with a status of 6, 'complete'
6271:
6272: l_return_status := fnd_api.g_ret_sts_success;
6273: wms_insert_wdth_pvt.insert_into_wdth
6274: ( x_return_status => l_return_status
6290: IF (l_debug = 1) THEN
6291: mydebug('After wmsdt update');
6292: END IF;
6293:
6294: -- Delete this row from wms_dispatched_tasks
6295: DELETE wms_dispatched_tasks
6296: WHERE transaction_temp_id = l_temp_id;
6297:
6298: -- Delete lot and serial records
6291: mydebug('After wmsdt update');
6292: END IF;
6293:
6294: -- Delete this row from wms_dispatched_tasks
6295: DELETE wms_dispatched_tasks
6296: WHERE transaction_temp_id = l_temp_id;
6297:
6298: -- Delete lot and serial records
6299: BEGIN
6385: mydebug('Batch ID: ' || l_transaction_batch_id);
6386: mydebug('Batch Seq: ' || l_transaction_batch_seq);
6387: END IF;
6388:
6389: -- Insert into WMS_DISPATCHED_TASKS_HISTORY with a status of 6, 'complete'
6390:
6391: l_return_status := fnd_api.g_ret_sts_success;
6392: wms_insert_wdth_pvt.insert_into_wdth
6393: ( x_return_status => l_return_status
6405: END IF;
6406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6407: END IF;
6408:
6409: -- Delete this row from wms_dispatched_tasks
6410: DELETE FROM wms_dispatched_tasks
6411: WHERE transaction_temp_id = l_temp_id;
6412:
6413: IF (l_debug = 1) THEN
6406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6407: END IF;
6408:
6409: -- Delete this row from wms_dispatched_tasks
6410: DELETE FROM wms_dispatched_tasks
6411: WHERE transaction_temp_id = l_temp_id;
6412:
6413: IF (l_debug = 1) THEN
6414: mydebug('archive_task: After wmsdt update');
6568: , l_demand_source_header_id
6569: , l_repetitive_line_id
6570: , l_operation_seq_num
6571: , l_secondary_quantity --OPM Convergence
6572: FROM mtl_material_transactions_temp t, wms_dispatched_tasks w
6573: WHERE t.transaction_temp_id = l_temp_id
6574: AND t.organization_id = l_org_id
6575: AND t.transaction_temp_id = w.transaction_temp_id;
6576:
7729: -- Before clean up call abort operations plan
7730:
7731: -- After Abort Operation plan do clean up.
7732:
7733: DELETE FROM wms_dispatched_tasks
7734: WHERE task_type = 2
7735: AND transaction_temp_id IN
7736: (SELECT transaction_temp_id
7737: FROM mtl_material_transactions_temp
8557:
8558:
8559: -- Delete WDT
8560: FORALL i in 1..l_mmtt_id_tab.COUNT
8561: DELETE FROM wms_dispatched_tasks
8562: WHERE transaction_temp_id = l_mmtt_id_tab(i)
8563: AND task_type = 2;
8564:
8565: