APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on FND_GLOBAL

Line 346: , fnd_global.USER_ID

342: , l_rec.task_summary
343: , l_rec.organization_id
344: , l_device_id
345: , SYSDATE
346: , fnd_global.USER_ID
347: , nvl(l_rec.status_code,'E') --Bug#4535546.Added nvl
348: , l_rec.status_msg
349: , l_resp_application_id
350: , l_resp_id

Line 352: , fnd_global.USER_ID

348: , l_rec.status_msg
349: , l_resp_application_id
350: , l_resp_id
351: , SYSDATE
352: , fnd_global.USER_ID
353: , SYSDATE
354: , fnd_global.USER_ID
355: , l_rec.lot_number
356: , l_rec.lot_qty

Line 354: , fnd_global.USER_ID

350: , l_resp_id
351: , SYSDATE
352: , fnd_global.USER_ID
353: , SYSDATE
354: , fnd_global.USER_ID
355: , l_rec.lot_number
356: , l_rec.lot_qty
357: , l_rec.serial_number
358: );

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 3184: FROM fnd_user WHERE user_id = fnd_global.user_id;

3180: AND ROWNUM < 2;
3181:
3182:
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:

Line 3221: , fnd_global.user_id

3217: , l_per_res_id
3218: , l_g_task_active
3219: , SYSDATE
3220: , SYSDATE
3221: , fnd_global.user_id
3222: , SYSDATE
3223: , fnd_global.user_id
3224: , l_wms_task_type
3225: , l_operation_plan_id

Line 3223: , fnd_global.user_id

3219: , SYSDATE
3220: , SYSDATE
3221: , fnd_global.user_id
3222: , SYSDATE
3223: , fnd_global.user_id
3224: , l_wms_task_type
3225: , l_operation_plan_id
3226: , l_move_order_line_id
3227: );

Line 4069: ,last_updated_by = fnd_global.user_id

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
4070: WHERE transaction_temp_id = l_rec.task_id;
4071:
4072:
4073: