APPS.WMS_PICK_DROP_PVT dependencies on WMS_DISPATCHED_TASKS_HISTORY

Line 10133: UPDATE wms_dispatched_tasks_history wdth

10129: --
10130: -- Update parent_transaction_id in WDTH
10131: --
10132: BEGIN
10133: UPDATE wms_dispatched_tasks_history wdth
10134: SET wdth.parent_transaction_id = l_parent_line_id
10135: , wdth.is_parent = 'N'
10136: WHERE task_id = l_task_id;
10137:

Line 10225: UPDATE wms_dispatched_tasks_history wdth

10221: --
10222: -- Update parent_transaction_id in WDTH
10223: --
10224: BEGIN
10225: UPDATE wms_dispatched_tasks_history wdth
10226: SET wdth.parent_transaction_id = wdth.transaction_id
10227: , wdth.is_parent = 'Y'
10228: WHERE wdth.task_id = parent_rec.task_id
10229: RETURNING wdth.transaction_id INTO l_parent_txn_id;

Line 10254: UPDATE wms_dispatched_tasks_history wdth

10250: --
10251: -- Update child lines
10252: --
10253: BEGIN
10254: UPDATE wms_dispatched_tasks_history wdth
10255: SET wdth.parent_transaction_id = l_parent_txn_id
10256: WHERE wdth.parent_transaction_id = parent_rec.transaction_temp_id;
10257:
10258: IF l_debug = 1 THEN