eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_ATF_RUNTIME_PUB_APIS dependencies on WMS_DISPATCHED_TASKS

Line 1688: * @param p_task_execute_rec -Input of WMS_DISPATCHED_TASKS to be created for the task.

1684: * @param x_msg_count -Returns the message count
1685: * @param x_error_code -Returns appropriate error code in case of any error.
1686: * @param p_source_task_id -Identifier of the document record.
1687: * @param p_activity_id -Identifier of the Activity Type.
1688: * @param p_task_execute_rec -Input of WMS_DISPATCHED_TASKS to be created for the task.
1689: **/
1690:
1691: PROCEDURE ACTIVATE_OPERATION_INSTANCE(
1692: x_return_status OUT NOCOPY VARCHAR2

Line 1701: ,p_task_execute_rec IN WMS_DISPATCHED_TASKS%ROWTYPE ) IS

1697: ,x_consolidation_method_id OUT NOCOPY NUMBER
1698: ,p_source_task_id IN NUMBER
1699: ,p_activity_id IN NUMBER
1700: ,p_operation_type_id IN NUMBER
1701: ,p_task_execute_rec IN WMS_DISPATCHED_TASKS%ROWTYPE ) IS
1702:
1703:
1704: CURSOR c_wdt_details IS
1705: SELECT status

Line 1706: FROM wms_dispatched_tasks

1702:
1703:
1704: CURSOR c_wdt_details IS
1705: SELECT status
1706: FROM wms_dispatched_tasks
1707: WHERE transaction_temp_id=p_source_task_id
1708: AND task_type=g_wms_task_type_putaway;
1709:
1710: CURSOR c_inbound_doc IS

Line 1750: l_wdt_rec WMS_DISPATCHED_TASKS%ROWTYPE := NULL;

1746: WHERE person_id = v_person_id
1747: AND SYSDATE BETWEEN effective_start_date AND effective_end_date;
1748:
1749:
1750: l_wdt_rec WMS_DISPATCHED_TASKS%ROWTYPE := NULL;
1751: l_wdt_details c_wdt_details%ROWTYPE;
1752: l_inbound_doc c_inbound_doc%ROWTYPE;
1753: l_mmtt_rec MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE :=NULL;
1754: l_opertn_instance_details c_operation_instance_details%ROWTYPE := NULL;

Line 1833: DELETE FROM wms_dispatched_tasks

1829: *Delete this WDT record*/
1830: IF (l_wdt_details.status=g_task_status_dispatched) THEN
1831:
1832:
1833: DELETE FROM wms_dispatched_tasks
1834: WHERE transaction_temp_id=p_source_task_id;
1835:
1836: IF (l_debug=1) THEN
1837: print_debug('Deleting the WDT record since in Dispatched status',l_module_name,9);

Line 2777: FROM wms_dispatched_tasks

2773:
2774: BEGIN
2775: SELECT task_id, status
2776: INTO l_wdt_task_id, l_wdt_status
2777: FROM wms_dispatched_tasks
2778: WHERE transaction_temp_id = p_source_task_id
2779: AND task_type IN (g_wms_task_type_putaway, g_wms_task_type_inspect);
2780:
2781: EXCEPTION

Line 2891: UPDATE wms_dispatched_tasks

2887:
2888:
2889: l_progress := 60;
2890:
2891: UPDATE wms_dispatched_tasks
2892: SET status = g_task_status_loaded,
2893: loaded_time = Sysdate,
2894: last_update_date = Sysdate,
2895: last_updated_by = fnd_global.user_id

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 5079: FROM wms_dispatched_tasks

5075: --BUG 5075410: When splitting an MMTT, the WDT must also be
5076: --split. If not, the split qty will not be loaded after the split
5077: BEGIN
5078: SELECT COUNT(1) INTO l_num_wdts_for_mmtt
5079: FROM wms_dispatched_tasks
5080: WHERE transaction_temp_id = l_inbound_doc_child_rec.transaction_temp_id;
5081: EXCEPTION
5082: WHEN OTHERS THEN
5083: print_debug('Num of WDTs for orginal MMTT:'||l_num_wdts_for_mmtt,l_module_name,3);

Line 5104: SELECT wms_dispatched_tasks_s.NEXTVAL

5100: END IF;
5101:
5102: CLOSE inbound_document_details;
5103:
5104: SELECT wms_dispatched_tasks_s.NEXTVAL
5105: INTO l_next_task_id
5106: FROM DUAL;
5107:
5108: IF (l_debug = 1) THEN

Line 5112: INSERT INTO wms_dispatched_tasks

5108: IF (l_debug = 1) THEN
5109: print_debug('Inserting Duplicate WDT records using ID:'||l_next_task_id,l_module_name,3);
5110: END IF;
5111:
5112: INSERT INTO wms_dispatched_tasks
5113: (
5114: task_id
5115: , transaction_temp_id
5116: , organization_id

Line 5213: FROM wms_dispatched_tasks

5209: , l_inbound_doc_child_split_rec.move_order_line_id
5210: , transfer_lpn_id
5211: , l_wopi_split_rec.op_plan_instance_id
5212: , task_method
5213: FROM wms_dispatched_tasks
5214: WHERE transaction_temp_id = l_inbound_doc_child_rec.transaction_temp_id;
5215: END LOOP;
5216: END IF; --IF (l_num_wdts_for_mmtt > 1) THEN
5217: --END BUG 5075410: When splitting an MMTT, the WDT must also be

Line 5462: FROM wms_dispatched_tasks

5458: * If there is a WDT record for the original child MMTT, we need to
5459: * duplicate WDT for each new child MMTT records.
5460: */
5461: SELECT COUNT(1) INTO l_num_wdts_for_mmtt
5462: FROM wms_dispatched_tasks
5463: WHERE transaction_temp_id = l_inbound_doc_child_rec.transaction_temp_id;
5464: /* END: GRACE11-02-2003 */
5465:
5466: /* split parent MMTT, OP_Plan_Instance, OP_Operation_Instance.

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 5777: SELECT wms_dispatched_tasks_s.NEXTVAL

5773: LOOP
5774: FETCH wdth_cursor INTO l_task_id, l_old_temp_id;
5775: EXIT WHEN wdth_cursor%notfound;
5776:
5777: SELECT wms_dispatched_tasks_s.NEXTVAL
5778: INTO l_next_task_id
5779: FROM DUAL;
5780:
5781: SELECT mtl_material_transactions_s.NEXTVAL

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 6096: --INSERT INTO wms_dispatched_tasks ???;

6092: * duplicate WDT for each new child MMTT records.
6093: */
6094: IF (l_num_wdts_for_mmtt > 0) THEN
6095: -- TODO: how to duplicate WDT of original child MMTT (l_inbound_doc_child_rec)???
6096: --INSERT INTO wms_dispatched_tasks ???;
6097: SELECT wms_dispatched_tasks_s.NEXTVAL
6098: INTO l_next_task_id
6099: FROM DUAL;
6100:

Line 6097: SELECT wms_dispatched_tasks_s.NEXTVAL

6093: */
6094: IF (l_num_wdts_for_mmtt > 0) THEN
6095: -- TODO: how to duplicate WDT of original child MMTT (l_inbound_doc_child_rec)???
6096: --INSERT INTO wms_dispatched_tasks ???;
6097: SELECT wms_dispatched_tasks_s.NEXTVAL
6098: INTO l_next_task_id
6099: FROM DUAL;
6100:
6101: INSERT INTO wms_dispatched_tasks

Line 6101: INSERT INTO wms_dispatched_tasks

6097: SELECT wms_dispatched_tasks_s.NEXTVAL
6098: INTO l_next_task_id
6099: FROM DUAL;
6100:
6101: INSERT INTO wms_dispatched_tasks
6102: (
6103: task_id
6104: , transaction_temp_id
6105: , organization_id

Line 6202: FROM wms_dispatched_tasks

6198: , l_inbound_doc_child_split_rec.move_order_line_id
6199: , transfer_lpn_id
6200: , l_wopi_split_rec.op_plan_instance_id
6201: , task_method
6202: FROM wms_dispatched_tasks
6203: WHERE transaction_temp_id = l_inbound_doc_child_rec.transaction_temp_id;
6204:
6205:
6206:

Line 6397: FROM wms_dispatched_tasks

6393:
6394: BEGIN
6395: SELECT task_id, status
6396: INTO l_wdt_task_id, l_wdt_status
6397: FROM wms_dispatched_tasks
6398: WHERE transaction_temp_id = p_source_task_id
6399: AND task_type IN (g_wms_task_type_putaway, g_wms_task_type_inspect);
6400:
6401: EXCEPTION

Line 6444: DELETE wms_dispatched_tasks

6440: END IF;
6441:
6442: l_progress := 40;
6443:
6444: DELETE wms_dispatched_tasks
6445: WHERE task_id = l_wdt_task_id;
6446:
6447: l_progress := 50;
6448:

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 7690: /* UPDATE wms_dispatched_tasks

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
7691: SET operation_plan_id = NULL,
7692: op_plan_instance_id = NULL
7693: WHERE transaction_temp_id = p_source_task_id;
7694:

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;

Line 7841: FROM wms_dispatched_tasks

7837:
7838: CURSOR c_wdt_details IS
7839: SELECT status,
7840: task_id
7841: FROM wms_dispatched_tasks
7842: WHERE transaction_temp_id = p_source_task_id;
7843:
7844: CURSOR c_inbound_document_details IS
7845: SELECT operation_plan_id

Line 7912: /* Update or remove WDT. Based on the p_source_task_id query WMS_DISPATCHED_TASKS and populate WDT record variable as follows:

7908:
7909: l_progress:=20;
7910:
7911:
7912: /* Update or remove WDT. Based on the p_source_task_id query WMS_DISPATCHED_TASKS and populate WDT record variable as follows:
7913: * a. If no record is found in WDT for source_task_id then raise unexpected error and return after populating appropriate error code.
7914: * b. If WDT.status = 'Dispatched' or 'Loaded' THEN
7915: * a. Remove WDT
7916: * End IF; (If Dispatched)

Line 8026: DELETE FROM WMS_DISPATCHED_TASKS

8022:
8023: -- Before we return, we should delete WDT here
8024: -- since now we delete WDT after calling WMS_OP_INBOUND_PVT.Cleanup at the end.
8025:
8026: DELETE FROM WMS_DISPATCHED_TASKS
8027: WHERE transaction_temp_id = p_source_task_id
8028: AND task_id = l_wdt_details.task_id;
8029:
8030: IF c_wdt_details%ISOPEN THEN

Line 8284: DELETE FROM WMS_DISPATCHED_TASKS

8280: /* Deleting the WDT record as the status is being reverted to Load Pending */
8281: -- Moved delete WDT to after calling WMS_OP_INBOUND_PVT.Cleanup
8282: -- because WMS_OP_INBOUND_PVT.Cleanup now calls putaway_cleanup, which assumes WDT still exists.
8283:
8284: DELETE FROM WMS_DISPATCHED_TASKS
8285: WHERE transaction_temp_id = p_source_task_id
8286: AND task_id = l_wdt_details.task_id;
8287:
8288: l_progress := 170;