APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on WMS_DEVICE_REQUESTS_HIST

Line 279: FROM wms_device_requests_hist

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

Line 305: INSERT INTO wms_device_requests_hist(request_id

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

Line 3154: wms_device_requests_hist wdrh,

3150: --to avoid LPNS that have been unpacked by TM for non-LPN ctrld sub
3151: AND wlpn.lpn_id IN
3152: (SELECT wdr.xfer_lpn_id
3153: FROM wms_device_requests wdr,
3154: wms_device_requests_hist wdrh,
3155: wms_dispatched_tasks wdt
3156: WHERE wdr.business_event_id = wms_device_integration_pvt.WMS_BE_TASK_CONFIRM
3157: AND wdr.task_id = wdt.transaction_temp_id
3158: AND wdt.task_type IN (4,5,7) -- ONLY for Replenishment, MO Xfer,Staging TASKS

Line 3259: FROM wms_device_requests_hist

3255: --Check if corresponding RECORD exist in the WDRH history table
3256:
3257: BEGIN
3258: SELECT task_id,lpn_id INTO l_txn_temp_id,l_orig_lpn_id
3259: FROM wms_device_requests_hist
3260: WHERE request_id = l_rec.relation_id
3261: AND task_id = l_rec.task_id
3262: 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)
3263: AND ROWNUM <2;

Line 5126: UPDATE wms_device_requests_hist

5122: IF (l_debug = 1) THEN
5123: trace('Updating resubmitted records for EXP exception thrown' );
5124: END IF;
5125: --this is set to P in the form while making call to concurrent req
5126: UPDATE wms_device_requests_hist
5127: SET status_code = 'E',resubmit_date = sysdate,
5128: status_msg= 'g_expected_error'
5129: WHERE request_id = l_new_request_id
5130: AND BUSINESS_EVENT_ID IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm);

Line 5163: UPDATE wms_device_requests_hist

5159: IF (l_debug = 1) THEN
5160: trace('Updating resubmitted records for UNEXP exception thrown' );
5161: END IF;
5162: --this is set to P in the form while making call to concurrent req
5163: UPDATE wms_device_requests_hist
5164: SET status_code = 'E',resubmit_date = Sysdate,
5165: status_msg='g_unexpected_error'
5166: WHERE request_id = l_new_request_id
5167: AND BUSINESS_EVENT_ID IN (wms_device_integration_pvt.wms_be_task_confirm,wms_device_integration_pvt.wms_be_load_confirm);