APPS.WMS_ATF_RUNTIME_PUB_APIS dependencies on WMS_DISPATCHED_TASKS_HISTORY

Line 4999: FROM wms_dispatched_tasks_history

4995:
4996: CURSOR wdth_cursor(v_op_plan_instance_id NUMBER) IS
4997: SELECT task_id,
4998: transaction_id
4999: FROM wms_dispatched_tasks_history
5000: WHERE op_plan_instance_id = v_op_plan_instance_id;
5001:
5002: l_inbound_doc_child_rec inbound_document_details%ROWTYPE;
5003: l_inbound_doc_parent_rec inbound_document_details%ROWTYPE;

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

5760: * as l_inbound_doc_parent_rec.
5761: */
5762: l_progress := 185;
5763:
5764: -- TODO: how is wms_dispatched_tasks_history linked to wms_op_plan_instances
5765: UPDATE wms_dispatched_tasks_history
5766: SET transaction_quantity = l_inbound_doc_parent_rec.transaction_quantity,
5767: last_update_date = Sysdate -- bug 3827507
5768: WHERE op_plan_instance_id =l_wopi_orig_rec.op_plan_instance_id;

Line 5765: UPDATE wms_dispatched_tasks_history

5761: */
5762: l_progress := 185;
5763:
5764: -- TODO: how is wms_dispatched_tasks_history linked to wms_op_plan_instances
5765: UPDATE wms_dispatched_tasks_history
5766: SET transaction_quantity = l_inbound_doc_parent_rec.transaction_quantity,
5767: last_update_date = Sysdate -- bug 3827507
5768: WHERE op_plan_instance_id =l_wopi_orig_rec.op_plan_instance_id;
5769:

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

5781: SELECT mtl_material_transactions_s.NEXTVAL
5782: INTO l_new_temp_id
5783: FROM dual;
5784: -- TODO: how to construct new WDTHs from those linked to orig WOPI
5785: --INSERT INTO wms_dispatched_tasks_history ???;
5786: INSERT INTO wms_dispatched_tasks_history
5787: (
5788: task_id
5789: , transaction_id

Line 5786: INSERT INTO wms_dispatched_tasks_history

5782: INTO l_new_temp_id
5783: FROM dual;
5784: -- TODO: how to construct new WDTHs from those linked to orig WOPI
5785: --INSERT INTO wms_dispatched_tasks_history ???;
5786: INSERT INTO wms_dispatched_tasks_history
5787: (
5788: task_id
5789: , transaction_id
5790: , organization_id

Line 5921: FROM wms_dispatched_tasks_history

5917: , transaction_type_id
5918: , transaction_source_type_id
5919: , transaction_action_id
5920: , l_new_temp_id -- new value to link wdth and we -- lezhang
5921: FROM wms_dispatched_tasks_history
5922: WHERE task_id = l_task_id;
5923:
5924:
5925:

Line 7686: UPDATE wms_dispatched_tasks_history

7682: -- since DBI uses these columns for exception related KPI
7683: -- It is ok for WMS because without parent_transaction_id
7684: -- the aborted WDTH is still viewed as an independent task
7685: -- from control board.
7686: UPDATE wms_dispatched_tasks_history
7687: SET parent_transaction_id = NULL
7688: WHERE transaction_id = p_source_task_id;
7689:
7690: /* UPDATE wms_dispatched_tasks

Line 7705: UPDATE wms_dispatched_tasks_history

7701: END IF;
7702:
7703: l_progress :=200;
7704:
7705: UPDATE wms_dispatched_tasks_history
7706: SET operation_plan_id = NULL,
7707: op_plan_instance_id = NULL,
7708: parent_transaction_id = NULL
7709: WHERE transaction_id = p_source_task_id;