APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on WMS_DISPATCHED_TASKS

Line 2629: wms_dispatched_tasks wdt

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
2633: AND wdr.status_code = 'S'

Line 3155: --Step1 Insert into WMS_DISPATCHED_TASKS --as "ACTIVE =9" for the user fnd_global.user_id

3151:
3152: ----*****************New Code Starts***********
3153: --Game plan to support mix of just Load_confirm along with task_confirm
3154: --Step0 Get reouseces information
3155: --Step1 Insert into WMS_DISPATCHED_TASKS --as "ACTIVE =9" for the user fnd_global.user_id
3156: --Step2 Do all MMTT manipulation and then WDT manipulation
3157: --Step3 Update the transaction_header_id of MMTT tasks that need to be dropped TO a NEW same common value AND THEN call TM
3158: --Step4 Archieve task Xfer WDT to WDTH for records that are being dropped
3159: --Step5 Call TM after the loop

Line 3187: --Step1 Insert into WMS_DISPATCHED_TASKS --as "ACTIVE =9"

3183: SELECT employee_id INTO l_person_id
3184: FROM fnd_user WHERE user_id = fnd_global.user_id;
3185:
3186:
3187: --Step1 Insert into WMS_DISPATCHED_TASKS --as "ACTIVE =9"
3188:
3189: INSERT INTO wms_dispatched_tasks
3190: (
3191: task_id

Line 3189: INSERT INTO wms_dispatched_tasks

3185:
3186:
3187: --Step1 Insert into WMS_DISPATCHED_TASKS --as "ACTIVE =9"
3188:
3189: INSERT INTO wms_dispatched_tasks
3190: (
3191: task_id
3192: , transaction_temp_id
3193: , organization_id

Line 3210: wms_dispatched_tasks_s.NEXTVAL

3206: , operation_plan_id
3207: , move_order_line_id
3208: )
3209: VALUES (
3210: wms_dispatched_tasks_s.NEXTVAL
3211: , l_rec.task_id --transaction_temp_id
3212: , l_rec.organization_id
3213: , NVL(l_std_op_id, 2)
3214: , l_person_id

Line 3481: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = l_rec.task_id; --Bug 6987801

3477: IF (l_debug = 1) THEN
3478: trace('Just one MMTT line exists. Close MO and backorder');
3479: END IF;
3480:
3481: DELETE FROM wms_dispatched_tasks WHERE transaction_temp_id = l_rec.task_id; --Bug 6987801
3482:
3483: inv_mo_backorder_pvt.backorder
3484: (p_line_id => l_move_order_line_id
3485: , x_return_status => x_return_status

Line 4065: UPDATE wms_dispatched_tasks

4061:
4062: --Step2.2 Do manipulation of WDT for THIS task status as Loaded Now
4063: -- IT does not have to wait till laterr stage.
4064:
4065: UPDATE wms_dispatched_tasks
4066: SET status = l_g_task_loaded
4067: ,last_update_date = Sysdate
4068: ,loaded_time = Sysdate
4069: ,last_updated_by = fnd_global.user_id