[Home] [Help]
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
3159: AND wdr.status_code = 'S'
3696:
3697: ----*****************New Code Starts***********
3698: --Game plan to support mix of just Load_confirm along with task_confirm
3699: --Step0 Get reouseces information
3700: --Step1 Insert into WMS_DISPATCHED_TASKS --as "ACTIVE =9" for the user fnd_global.user_id
3701: --Step2 Do all MMTT manipulation and then WDT manipulation
3702: --Step3 Update the transaction_header_id of MMTT tasks that need to be dropped TO a NEW same common value AND THEN call TM
3703: --Step4 Archieve task Xfer WDT to WDTH for records that are being dropped
3704: --Step5 Call TM after the loop
3750: RAISE fnd_api.g_exc_error;
3751: END; -- 14028129
3752:
3753:
3754: --Step1 Insert into WMS_DISPATCHED_TASKS --as "ACTIVE =9"
3755: SELECT count(*) into l_wdt_count from wms_dispatched_tasks where transaction_temp_id = l_rec.task_id;
3756:
3757: IF (l_wdt_count = 0) THEN
3758: IF (l_debug = 1) THEN
3751: END; -- 14028129
3752:
3753:
3754: --Step1 Insert into WMS_DISPATCHED_TASKS --as "ACTIVE =9"
3755: SELECT count(*) into l_wdt_count from wms_dispatched_tasks where transaction_temp_id = l_rec.task_id;
3756:
3757: IF (l_wdt_count = 0) THEN
3758: IF (l_debug = 1) THEN
3759: trace('Inserting the WDT as there is no existing wdt record'||l_wdt_count); --BUG 11841884
3757: IF (l_wdt_count = 0) THEN
3758: IF (l_debug = 1) THEN
3759: trace('Inserting the WDT as there is no existing wdt record'||l_wdt_count); --BUG 11841884
3760: END IF;
3761: INSERT INTO wms_dispatched_tasks
3762: (
3763: task_id
3764: , transaction_temp_id
3765: , organization_id
3778: , operation_plan_id
3779: , move_order_line_id
3780: )
3781: VALUES (
3782: wms_dispatched_tasks_s.NEXTVAL
3783: , l_rec.task_id --transaction_temp_id
3784: , l_rec.organization_id
3785: , NVL(l_std_op_id, 2)
3786: , l_person_id
4080: trace('Just one MMTT line exists. Close MO and backorder');
4081: END IF;
4082:
4083: --Bug#7634524.Delete the WDT we just inserted.
4084: DELETE FROM wms_dispatched_tasks
4085: WHERE transaction_temp_id = l_rec.task_id
4086: AND person_id = l_person_id ; --Bug 6987801 -- 14028129
4087:
4088:
4733: WHERE line_id = l_move_order_line_id;
4734:
4735: END IF; -- l_rec.reason_id IS NOT NULL
4736:
4737: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = l_new_txn_temp_id ;
4738: IF SQL%NOTFOUND THEN
4739: IF (l_debug = 1) THEN
4740: trace ('NO WDT TO DELETE for temp_id : '||l_new_txn_temp_id );
4741: END IF;
4786:
4787: --Step2.2 Do manipulation of WDT for THIS task status as Loaded Now
4788: -- IT does not have to wait till laterr stage.
4789:
4790: UPDATE wms_dispatched_tasks
4791: SET status = l_g_task_loaded
4792: ,last_update_date = Sysdate
4793: ,loaded_time = Sysdate
4794: ,last_updated_by = fnd_global.user_id