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 1834: DELETE FROM wms_dispatched_tasks

1830: *Delete this WDT record*/
1831: IF (l_wdt_details.status=g_task_status_dispatched) THEN
1832:
1833:
1834: DELETE FROM wms_dispatched_tasks
1835: WHERE transaction_temp_id=p_source_task_id;
1836:
1837: l_task_del_flag := 1; -- 14284768: set to 1 so as to call non autonomous insert for WDT
1838:

Line 2817: FROM wms_dispatched_tasks

2813:
2814: BEGIN
2815: SELECT task_id, status
2816: INTO l_wdt_task_id, l_wdt_status
2817: FROM wms_dispatched_tasks
2818: WHERE transaction_temp_id = p_source_task_id
2819: AND task_type IN (g_wms_task_type_putaway, g_wms_task_type_inspect);
2820:
2821: EXCEPTION

Line 2931: UPDATE wms_dispatched_tasks

2927:
2928:
2929: l_progress := 60;
2930:
2931: UPDATE wms_dispatched_tasks
2932: SET status = g_task_status_loaded,
2933: loaded_time = Sysdate,
2934: last_update_date = Sysdate,
2935: last_updated_by = fnd_global.user_id

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

5187: --BUG 5075410: When splitting an MMTT, the WDT must also be
5188: --split. If not, the split qty will not be loaded after the split
5189: BEGIN
5190: SELECT COUNT(1) INTO l_num_wdts_for_mmtt
5191: FROM wms_dispatched_tasks
5192: WHERE transaction_temp_id = l_inbound_doc_child_rec.transaction_temp_id;
5193: EXCEPTION
5194: WHEN OTHERS THEN
5195: print_debug('Num of WDTs for orginal MMTT:'||l_num_wdts_for_mmtt,l_module_name,3);

Line 5216: SELECT wms_dispatched_tasks_s.NEXTVAL

5212: END IF;
5213:
5214: CLOSE inbound_document_details;
5215:
5216: SELECT wms_dispatched_tasks_s.NEXTVAL
5217: INTO l_next_task_id
5218: FROM DUAL;
5219:
5220: IF (l_debug = 1) THEN

Line 5224: INSERT INTO wms_dispatched_tasks

5220: IF (l_debug = 1) THEN
5221: print_debug('Inserting Duplicate WDT records using ID:'||l_next_task_id,l_module_name,3);
5222: END IF;
5223:
5224: INSERT INTO wms_dispatched_tasks
5225: (
5226: task_id
5227: , transaction_temp_id
5228: , organization_id

Line 5325: FROM wms_dispatched_tasks

5321: , l_inbound_doc_child_split_rec.move_order_line_id
5322: , transfer_lpn_id
5323: , l_wopi_split_rec.op_plan_instance_id
5324: , task_method
5325: FROM wms_dispatched_tasks
5326: WHERE transaction_temp_id = l_inbound_doc_child_rec.transaction_temp_id;
5327: END LOOP;
5328: END IF; --IF (l_num_wdts_for_mmtt > 1) THEN
5329: --END BUG 5075410: When splitting an MMTT, the WDT must also be

Line 5583: FROM wms_dispatched_tasks

5579: * If there is a WDT record for the original child MMTT, we need to
5580: * duplicate WDT for each new child MMTT records.
5581: */
5582: SELECT COUNT(1) INTO l_num_wdts_for_mmtt
5583: FROM wms_dispatched_tasks
5584: WHERE transaction_temp_id = l_inbound_doc_child_rec.transaction_temp_id;
5585: /* END: GRACE11-02-2003 */
5586:
5587: /* split parent MMTT, OP_Plan_Instance, OP_Operation_Instance.

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

5899: LOOP
5900: FETCH wdth_cursor INTO l_task_id, l_old_temp_id;
5901: EXIT WHEN wdth_cursor%notfound;
5902:
5903: SELECT wms_dispatched_tasks_s.NEXTVAL
5904: INTO l_next_task_id
5905: FROM DUAL;
5906:
5907: SELECT mtl_material_transactions_s.NEXTVAL

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

6222: * duplicate WDT for each new child MMTT records.
6223: */
6224: IF (l_num_wdts_for_mmtt > 0) THEN
6225: -- TODO: how to duplicate WDT of original child MMTT (l_inbound_doc_child_rec)???
6226: --INSERT INTO wms_dispatched_tasks ???;
6227: SELECT wms_dispatched_tasks_s.NEXTVAL
6228: INTO l_next_task_id
6229: FROM DUAL;
6230:

Line 6227: SELECT wms_dispatched_tasks_s.NEXTVAL

6223: */
6224: IF (l_num_wdts_for_mmtt > 0) THEN
6225: -- TODO: how to duplicate WDT of original child MMTT (l_inbound_doc_child_rec)???
6226: --INSERT INTO wms_dispatched_tasks ???;
6227: SELECT wms_dispatched_tasks_s.NEXTVAL
6228: INTO l_next_task_id
6229: FROM DUAL;
6230:
6231: INSERT INTO wms_dispatched_tasks

Line 6231: INSERT INTO wms_dispatched_tasks

6227: SELECT wms_dispatched_tasks_s.NEXTVAL
6228: INTO l_next_task_id
6229: FROM DUAL;
6230:
6231: INSERT INTO wms_dispatched_tasks
6232: (
6233: task_id
6234: , transaction_temp_id
6235: , organization_id

Line 6332: FROM wms_dispatched_tasks

6328: , l_inbound_doc_child_split_rec.move_order_line_id
6329: , transfer_lpn_id
6330: , l_wopi_split_rec.op_plan_instance_id
6331: , task_method
6332: FROM wms_dispatched_tasks
6333: WHERE transaction_temp_id = l_inbound_doc_child_rec.transaction_temp_id;
6334:
6335:
6336:

Line 6527: FROM wms_dispatched_tasks

6523:
6524: BEGIN
6525: SELECT task_id, status
6526: INTO l_wdt_task_id, l_wdt_status
6527: FROM wms_dispatched_tasks
6528: WHERE transaction_temp_id = p_source_task_id
6529: AND task_type IN (g_wms_task_type_putaway, g_wms_task_type_inspect);
6530:
6531: EXCEPTION

Line 6574: DELETE wms_dispatched_tasks

6570: END IF;
6571:
6572: l_progress := 40;
6573:
6574: DELETE wms_dispatched_tasks
6575: WHERE task_id = l_wdt_task_id;
6576:
6577: l_progress := 50;
6578:

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

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
7821: SET operation_plan_id = NULL,
7822: op_plan_instance_id = NULL
7823: WHERE transaction_temp_id = p_source_task_id;
7824:

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;

Line 7971: FROM wms_dispatched_tasks

7967:
7968: CURSOR c_wdt_details IS
7969: SELECT status,
7970: task_id
7971: FROM wms_dispatched_tasks
7972: WHERE transaction_temp_id = p_source_task_id;
7973:
7974: CURSOR c_inbound_document_details IS
7975: SELECT operation_plan_id

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

8038:
8039: l_progress:=20;
8040:
8041:
8042: /* Update or remove WDT. Based on the p_source_task_id query WMS_DISPATCHED_TASKS and populate WDT record variable as follows:
8043: * a. If no record is found in WDT for source_task_id then raise unexpected error and return after populating appropriate error code.
8044: * b. If WDT.status = 'Dispatched' or 'Loaded' THEN
8045: * a. Remove WDT
8046: * End IF; (If Dispatched)

Line 8156: DELETE FROM WMS_DISPATCHED_TASKS

8152:
8153: -- Before we return, we should delete WDT here
8154: -- since now we delete WDT after calling WMS_OP_INBOUND_PVT.Cleanup at the end.
8155:
8156: DELETE FROM WMS_DISPATCHED_TASKS
8157: WHERE transaction_temp_id = p_source_task_id
8158: AND task_id = l_wdt_details.task_id;
8159:
8160: IF c_wdt_details%ISOPEN THEN

Line 8414: DELETE FROM WMS_DISPATCHED_TASKS

8410: /* Deleting the WDT record as the status is being reverted to Load Pending */
8411: -- Moved delete WDT to after calling WMS_OP_INBOUND_PVT.Cleanup
8412: -- because WMS_OP_INBOUND_PVT.Cleanup now calls putaway_cleanup, which assumes WDT still exists.
8413:
8414: DELETE FROM WMS_DISPATCHED_TASKS
8415: WHERE transaction_temp_id = p_source_task_id
8416: AND task_id = l_wdt_details.task_id;
8417:
8418: l_progress := 170;