APPS.WMS_DEVICE_INTEGRATION_PVT dependencies on WMS_DISPATCHED_TASKS

Line 868: UPDATE wms_dispatched_tasks

864: wms_be_task_cancel) then
865: IF (l_debug = 1) THEN
866: trace('No device found: Updating WDT for Task_id::'||wdrrec.task_id);
867: END IF;
868: UPDATE wms_dispatched_tasks
869: SET DEVICE_REQUEST_ID = NULL
870: WHERE TRANSACTION_TEMP_ID = wdrrec.task_id;
871: END IF;
872:

Line 1765: -- Updating wms_dispatched_tasks with the device_id

1761: --Added for bug#9233592 end
1762:
1763: IF (x_return_status = 'S')THEN
1764:
1765: -- Updating wms_dispatched_tasks with the device_id
1766: UPDATE wms_dispatched_tasks
1767: SET DEVICE_REQUEST_ID = l_request_id
1768: WHERE TRANSACTION_TEMP_ID = p_task_trx_id;
1769:

Line 1766: UPDATE wms_dispatched_tasks

1762:
1763: IF (x_return_status = 'S')THEN
1764:
1765: -- Updating wms_dispatched_tasks with the device_id
1766: UPDATE wms_dispatched_tasks
1767: SET DEVICE_REQUEST_ID = l_request_id
1768: WHERE TRANSACTION_TEMP_ID = p_task_trx_id;
1769:
1770: ELSIF (x_return_status = 'E')THEN

Line 1790: -- Updating wms_dispatched_tasks with the device_id

1786: x_return_status);
1787:
1788:
1789: IF (x_return_status = 'S')THEN
1790: -- Updating wms_dispatched_tasks with the device_id
1791: UPDATE wms_dispatched_tasks
1792: SET DEVICE_REQUEST_ID = l_request_id
1793: WHERE transaction_temp_id = p_task_trx_id;
1794:

Line 1791: UPDATE wms_dispatched_tasks

1787:
1788:
1789: IF (x_return_status = 'S')THEN
1790: -- Updating wms_dispatched_tasks with the device_id
1791: UPDATE wms_dispatched_tasks
1792: SET DEVICE_REQUEST_ID = l_request_id
1793: WHERE transaction_temp_id = p_task_trx_id;
1794:
1795: ELSIF (x_return_status = 'E')THEN

Line 2296: -- Updating wms_dispatched_tasks with the device_id

2292: x_return_status);
2293:
2294: IF (x_return_status = 'S')THEN
2295:
2296: -- Updating wms_dispatched_tasks with the device_id
2297: UPDATE wms_dispatched_tasks
2298: SET DEVICE_REQUEST_ID = l_request_id
2299: WHERE TRANSACTION_TEMP_ID = p_task_trx_id;
2300:

Line 2297: UPDATE wms_dispatched_tasks

2293:
2294: IF (x_return_status = 'S')THEN
2295:
2296: -- Updating wms_dispatched_tasks with the device_id
2297: UPDATE wms_dispatched_tasks
2298: SET DEVICE_REQUEST_ID = l_request_id
2299: WHERE TRANSACTION_TEMP_ID = p_task_trx_id;
2300:
2301: ELSIF (x_return_status = 'E')THEN

Line 2321: -- Updating wms_dispatched_tasks with the device_id

2317: x_return_status);
2318:
2319:
2320: IF (x_return_status = 'S')THEN
2321: -- Updating wms_dispatched_tasks with the device_id
2322: UPDATE wms_dispatched_tasks
2323: SET DEVICE_REQUEST_ID = l_request_id
2324: WHERE transaction_temp_id = p_task_trx_id;
2325:

Line 2322: UPDATE wms_dispatched_tasks

2318:
2319:
2320: IF (x_return_status = 'S')THEN
2321: -- Updating wms_dispatched_tasks with the device_id
2322: UPDATE wms_dispatched_tasks
2323: SET DEVICE_REQUEST_ID = l_request_id
2324: WHERE transaction_temp_id = p_task_trx_id;
2325:
2326: ELSIF (x_return_status = 'E')THEN

Line 2879: delete from wms_dispatched_tasks_history

2875: delete from wms_device_requests_hist
2876: where creation_date < p_purge_date and organization_id = p_orgid ;
2877: delete from wms_lpn_histories
2878: where creation_date < p_purge_date and organization_id = p_orgid ;
2879: delete from wms_dispatched_tasks_history
2880: where creation_date < p_purge_date and organization_id = p_orgid ;
2881: delete from wms_exceptions
2882: where creation_date < p_purge_date and organization_id = p_orgid ;
2883: delete from wms_lpn_process_temp ;