APPS.WMS_PICK_DROP_PVT dependencies on WMS_DISPATCHED_TASKS_HISTORY

Line 9810: UPDATE wms_dispatched_tasks_history wdth

9806: --
9807: -- Update parent_transaction_id in WDTH
9808: --
9809: BEGIN
9810: UPDATE wms_dispatched_tasks_history wdth
9811: SET wdth.parent_transaction_id = l_parent_line_id
9812: , wdth.is_parent = 'N'
9813: WHERE task_id = l_task_id;
9814:

Line 9902: UPDATE wms_dispatched_tasks_history wdth

9898: --
9899: -- Update parent_transaction_id in WDTH
9900: --
9901: BEGIN
9902: UPDATE wms_dispatched_tasks_history wdth
9903: SET wdth.parent_transaction_id = wdth.transaction_id
9904: , wdth.is_parent = 'Y'
9905: WHERE wdth.task_id = parent_rec.task_id
9906: RETURNING wdth.transaction_id INTO l_parent_txn_id;

Line 9931: UPDATE wms_dispatched_tasks_history wdth

9927: --
9928: -- Update child lines
9929: --
9930: BEGIN
9931: UPDATE wms_dispatched_tasks_history wdth
9932: SET wdth.parent_transaction_id = l_parent_txn_id
9933: WHERE wdth.parent_transaction_id = parent_rec.transaction_temp_id;
9934:
9935: IF l_debug = 1 THEN