APPS.WMS_ATF_RUNTIME_PUB_APIS dependencies on WMS_DISPATCHED_TASKS_HISTORY

Line 5111: FROM wms_dispatched_tasks_history

5107:
5108: CURSOR wdth_cursor(v_op_plan_instance_id NUMBER) IS
5109: SELECT task_id,
5110: transaction_id
5111: FROM wms_dispatched_tasks_history
5112: WHERE op_plan_instance_id = v_op_plan_instance_id;
5113:
5114: l_inbound_doc_child_rec inbound_document_details%ROWTYPE;
5115: l_inbound_doc_parent_rec inbound_document_details%ROWTYPE;

Line 5889: -- TODO: how is wms_dispatched_tasks_history linked to wms_op_plan_instances

5885: * as l_inbound_doc_parent_rec.
5886: */
5887: l_progress := 185;
5888:
5889: -- TODO: how is wms_dispatched_tasks_history linked to wms_op_plan_instances
5890: UPDATE wms_dispatched_tasks_history
5891: SET transaction_quantity = l_inbound_doc_parent_rec.transaction_quantity,
5892: secondary_transaction_quantity = l_inbound_doc_parent_rec.secondary_transaction_quantity, --13431255
5893: last_update_date = Sysdate -- bug 3827507

Line 5890: UPDATE wms_dispatched_tasks_history

5886: */
5887: l_progress := 185;
5888:
5889: -- TODO: how is wms_dispatched_tasks_history linked to wms_op_plan_instances
5890: UPDATE wms_dispatched_tasks_history
5891: SET transaction_quantity = l_inbound_doc_parent_rec.transaction_quantity,
5892: secondary_transaction_quantity = l_inbound_doc_parent_rec.secondary_transaction_quantity, --13431255
5893: last_update_date = Sysdate -- bug 3827507
5894: WHERE op_plan_instance_id =l_wopi_orig_rec.op_plan_instance_id;

Line 5911: --INSERT INTO wms_dispatched_tasks_history ???;

5907: SELECT mtl_material_transactions_s.NEXTVAL
5908: INTO l_new_temp_id
5909: FROM dual;
5910: -- TODO: how to construct new WDTHs from those linked to orig WOPI
5911: --INSERT INTO wms_dispatched_tasks_history ???;
5912: INSERT INTO wms_dispatched_tasks_history
5913: (
5914: task_id
5915: , transaction_id

Line 5912: INSERT INTO wms_dispatched_tasks_history

5908: INTO l_new_temp_id
5909: FROM dual;
5910: -- TODO: how to construct new WDTHs from those linked to orig WOPI
5911: --INSERT INTO wms_dispatched_tasks_history ???;
5912: INSERT INTO wms_dispatched_tasks_history
5913: (
5914: task_id
5915: , transaction_id
5916: , organization_id

Line 6051: FROM wms_dispatched_tasks_history

6047: , transaction_action_id
6048: , l_new_temp_id -- new value to link wdth and we -- lezhang
6049: , l_inbound_doc_parent_split_rec.secondary_transaction_quantity -- 9037915
6050: , l_inbound_doc_parent_split_rec.secondary_uom_code -- 9037915
6051: FROM wms_dispatched_tasks_history
6052: WHERE task_id = l_task_id;
6053:
6054:
6055:

Line 7816: UPDATE wms_dispatched_tasks_history

7812: -- since DBI uses these columns for exception related KPI
7813: -- It is ok for WMS because without parent_transaction_id
7814: -- the aborted WDTH is still viewed as an independent task
7815: -- from control board.
7816: UPDATE wms_dispatched_tasks_history
7817: SET parent_transaction_id = NULL
7818: WHERE transaction_id = p_source_task_id;
7819:
7820: /* UPDATE wms_dispatched_tasks

Line 7835: UPDATE wms_dispatched_tasks_history

7831: END IF;
7832:
7833: l_progress :=200;
7834:
7835: UPDATE wms_dispatched_tasks_history
7836: SET operation_plan_id = NULL,
7837: op_plan_instance_id = NULL,
7838: parent_transaction_id = NULL
7839: WHERE transaction_id = p_source_task_id;