APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on WMS_DISPATCHED_TASKS

Line 848: UPDATE wms_dispatched_tasks

844: wms_be_task_cancel) then
845: IF (l_debug = 1) THEN
846: trace('No device found: Updating WDT for Task_id::'||wdrrec.task_id);
847: END IF;
848: UPDATE wms_dispatched_tasks
849: SET DEVICE_REQUEST_ID = NULL
850: WHERE TRANSACTION_TEMP_ID = wdrrec.task_id;
851: END IF;
852:

Line 1683: -- Updating wms_dispatched_tasks with the device_id

1679: x_return_status);
1680:
1681: IF (x_return_status = 'S')THEN
1682:
1683: -- Updating wms_dispatched_tasks with the device_id
1684: UPDATE wms_dispatched_tasks
1685: SET DEVICE_REQUEST_ID = l_request_id
1686: WHERE TRANSACTION_TEMP_ID = p_task_trx_id;
1687:

Line 1684: UPDATE wms_dispatched_tasks

1680:
1681: IF (x_return_status = 'S')THEN
1682:
1683: -- Updating wms_dispatched_tasks with the device_id
1684: UPDATE wms_dispatched_tasks
1685: SET DEVICE_REQUEST_ID = l_request_id
1686: WHERE TRANSACTION_TEMP_ID = p_task_trx_id;
1687:
1688: ELSIF (x_return_status = 'E')THEN

Line 1708: -- Updating wms_dispatched_tasks with the device_id

1704: x_return_status);
1705:
1706:
1707: IF (x_return_status = 'S')THEN
1708: -- Updating wms_dispatched_tasks with the device_id
1709: UPDATE wms_dispatched_tasks
1710: SET DEVICE_REQUEST_ID = l_request_id
1711: WHERE transaction_temp_id = p_task_trx_id;
1712:

Line 1709: UPDATE wms_dispatched_tasks

1705:
1706:
1707: IF (x_return_status = 'S')THEN
1708: -- Updating wms_dispatched_tasks with the device_id
1709: UPDATE wms_dispatched_tasks
1710: SET DEVICE_REQUEST_ID = l_request_id
1711: WHERE transaction_temp_id = p_task_trx_id;
1712:
1713: ELSIF (x_return_status = 'E')THEN

Line 2212: -- Updating wms_dispatched_tasks with the device_id

2208: x_return_status);
2209:
2210: IF (x_return_status = 'S')THEN
2211:
2212: -- Updating wms_dispatched_tasks with the device_id
2213: UPDATE wms_dispatched_tasks
2214: SET DEVICE_REQUEST_ID = l_request_id
2215: WHERE TRANSACTION_TEMP_ID = p_task_trx_id;
2216:

Line 2213: UPDATE wms_dispatched_tasks

2209:
2210: IF (x_return_status = 'S')THEN
2211:
2212: -- Updating wms_dispatched_tasks with the device_id
2213: UPDATE wms_dispatched_tasks
2214: SET DEVICE_REQUEST_ID = l_request_id
2215: WHERE TRANSACTION_TEMP_ID = p_task_trx_id;
2216:
2217: ELSIF (x_return_status = 'E')THEN

Line 2237: -- Updating wms_dispatched_tasks with the device_id

2233: x_return_status);
2234:
2235:
2236: IF (x_return_status = 'S')THEN
2237: -- Updating wms_dispatched_tasks with the device_id
2238: UPDATE wms_dispatched_tasks
2239: SET DEVICE_REQUEST_ID = l_request_id
2240: WHERE transaction_temp_id = p_task_trx_id;
2241:

Line 2238: UPDATE wms_dispatched_tasks

2234:
2235:
2236: IF (x_return_status = 'S')THEN
2237: -- Updating wms_dispatched_tasks with the device_id
2238: UPDATE wms_dispatched_tasks
2239: SET DEVICE_REQUEST_ID = l_request_id
2240: WHERE transaction_temp_id = p_task_trx_id;
2241:
2242: ELSIF (x_return_status = 'E')THEN

Line 2792: delete from wms_dispatched_tasks_history

2788: delete from wms_device_requests_hist
2789: where creation_date < p_purge_date and organization_id = p_orgid ;
2790: delete from wms_lpn_histories
2791: where creation_date < p_purge_date and organization_id = p_orgid ;
2792: delete from wms_dispatched_tasks_history
2793: where creation_date < p_purge_date and organization_id = p_orgid ;
2794: delete from wms_exceptions
2795: where creation_date < p_purge_date and organization_id = p_orgid ;
2796: delete from wms_lpn_process_temp ;