APPS.WMS_DEVICE_CONFIRMATION_PUB dependencies on FND_GLOBAL

Line 347: , fnd_global.USER_ID

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

Line 353: , fnd_global.USER_ID

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

Line 355: , fnd_global.USER_ID

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

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

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

Line 3744: FROM fnd_user WHERE user_id = fnd_global.user_id;

3740:
3741:
3742: BEGIN -- 14028129
3743: SELECT employee_id INTO l_person_id
3744: FROM fnd_user WHERE user_id = fnd_global.user_id;
3745: EXCEPTION
3746: WHEN OTHERS THEN
3747: IF (l_debug = 1) THEN
3748: trace('Error:Cannot find Employee id for user:'||fnd_global.user_id);

Line 3748: trace('Error:Cannot find Employee id for user:'||fnd_global.user_id);

3744: FROM fnd_user WHERE user_id = fnd_global.user_id;
3745: EXCEPTION
3746: WHEN OTHERS THEN
3747: IF (l_debug = 1) THEN
3748: trace('Error:Cannot find Employee id for user:'||fnd_global.user_id);
3749: END IF;
3750: RAISE fnd_api.g_exc_error;
3751: END; -- 14028129
3752:

Line 3793: , fnd_global.user_id

3789: , l_per_res_id
3790: , l_g_task_active
3791: , SYSDATE
3792: , SYSDATE
3793: , fnd_global.user_id
3794: , SYSDATE
3795: , fnd_global.user_id
3796: , l_wms_task_type
3797: , l_operation_plan_id

Line 3795: , fnd_global.user_id

3791: , SYSDATE
3792: , SYSDATE
3793: , fnd_global.user_id
3794: , SYSDATE
3795: , fnd_global.user_id
3796: , l_wms_task_type
3797: , l_operation_plan_id
3798: , l_move_order_line_id
3799: );

Line 4794: ,last_updated_by = fnd_global.user_id

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
4795: WHERE transaction_temp_id = l_rec.task_id;
4796:
4797:
4798: