APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on WMS_DEVICE_REQUESTS_HIST

Line 278: FROM wms_device_requests_hist

274: INTO
275: l_device_id
276: ,l_resp_application_id
277: ,l_resp_id
278: FROM wms_device_requests_hist
279: WHERE request_id = nvl(l_rec.relation_id,-1)
280: --nvl,to handle ERROR: when WCS does NOT pass relation_id or task_id
281: AND task_id = nvl(l_rec.task_id,-1)
282: AND task_summary = 'Y'

Line 304: INSERT INTO wms_device_requests_hist(request_id

300: l_rec.status_msg := 'Error:Null parent_task_id or task_id';
301: END IF;
302:
303:
304: INSERT INTO wms_device_requests_hist(request_id
305: , relation_id -- parent_request_id
306: , task_id
307: , business_event_id
308: , transaction_quantity

Line 2628: wms_device_requests_hist wdrh,

2624: --to avoid LPNS that have been unpacked by TM for non-LPN ctrld sub
2625: AND wlpn.lpn_id IN
2626: (SELECT wdr.xfer_lpn_id
2627: FROM wms_device_requests wdr,
2628: wms_device_requests_hist wdrh,
2629: wms_dispatched_tasks wdt
2630: WHERE wdr.business_event_id = wms_device_integration_pvt.WMS_BE_TASK_CONFIRM
2631: AND wdr.task_id = wdt.transaction_temp_id
2632: AND wdt.task_type IN (4,5,7) -- ONLY for Replenishment, MO Xfer,Staging TASKS

Line 2715: FROM wms_device_requests_hist

2711: --Check if corresponding RECORD exist in the WDRH history table
2712:
2713: BEGIN
2714: SELECT task_id,lpn_id INTO l_txn_temp_id,l_orig_lpn_id
2715: FROM wms_device_requests_hist
2716: WHERE request_id = l_rec.relation_id
2717: AND task_id = l_rec.task_id
2718: AND business_event_id IN (wms_device_integration_pvt.wms_be_pick_release,wms_device_integration_pvt.wms_be_wip_pick_release,wms_device_integration_pvt.wms_be_mo_task_alloc)
2719: AND ROWNUM <2;

Line 4397: UPDATE wms_device_requests_hist

4393: IF (l_debug = 1) THEN
4394: trace('Updating resubmitted records for EXP exception thrown' );
4395: END IF;
4396: --this is set to P in the form while making call to concurrent req
4397: UPDATE wms_device_requests_hist
4398: SET status_code = 'E',resubmit_date = sysdate,
4399: status_msg= 'g_expected_error'
4400: WHERE request_id = l_new_request_id
4401: AND BUSINESS_EVENT_ID IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm);

Line 4434: UPDATE wms_device_requests_hist

4430: IF (l_debug = 1) THEN
4431: trace('Updating resubmitted records for UNEXP exception thrown' );
4432: END IF;
4433: --this is set to P in the form while making call to concurrent req
4434: UPDATE wms_device_requests_hist
4435: SET status_code = 'E',resubmit_date = Sysdate,
4436: status_msg='g_unexpected_error'
4437: WHERE request_id = l_new_request_id
4438: AND BUSINESS_EVENT_ID IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm);