eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_PICK_DROP_PVT dependencies on FND_GLOBAL

Line 5: g_newline CONSTANT VARCHAR2(10) := fnd_global.newline;

1: PACKAGE BODY wms_pick_drop_pvt AS
2: /* $Header: WMSPKDPB.pls 120.28.12020000.3 2013/01/31 12:14:24 blavu ship $ */
3:
4: g_pkg_body_ver CONSTANT VARCHAR2(100) := '$Header: WMSPKDPB.pls 120.28.12020000.3 2013/01/31 12:14:24 blavu ship $';
5: g_newline CONSTANT VARCHAR2(10) := fnd_global.newline;
6:
7: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
8:
9: g_xfer_to_lpn_id NUMBER := NULL; --Added for bug 10139672

Line 1850: , last_updated_by = fnd_global.user_id

1846: -- Bug5659809: update last_update_date and last_update_by as well
1847: UPDATE wms_license_plate_numbers
1848: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
1849: , last_update_date = SYSDATE
1850: , last_updated_by = fnd_global.user_id
1851: WHERE lpn_id = c_mmtt_rec.lpn_id;
1852:
1853: IF l_debug = 1 THEN
1854: print_debug

Line 2470: , last_updated_by = fnd_global.user_id

2466: -- Bug5659809: update last_update_date and last_update_by as well
2467: UPDATE wms_license_plate_numbers
2468: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
2469: , last_update_date = SYSDATE
2470: , last_updated_by = fnd_global.user_id
2471: WHERE lpn_id IN
2472: ( SELECT mmtt.content_lpn_id
2473: FROM mtl_material_transactions_temp mmtt
2474: WHERE mmtt.organization_id = g_current_drop_lpn.organization_id

Line 2498: , last_updated_by = fnd_global.user_id

2494: -- Bug5659809: update last_update_date and last_update_by as well
2495: UPDATE wms_license_plate_numbers
2496: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
2497: , last_update_date = SYSDATE
2498: , last_updated_by = fnd_global.user_id
2499: WHERE lpn_id IN
2500: ( SELECT mmtt.content_lpn_id
2501: FROM mtl_material_transactions_temp mmtt
2502: WHERE mmtt.organization_id = g_current_drop_lpn.organization_id

Line 2843: , fnd_global.user_id

2839: , source_line_id
2840: , transaction_mode
2841: , lock_flag
2842: , SYSDATE
2843: , fnd_global.user_id
2844: , SYSDATE
2845: , fnd_global.user_id
2846: , fnd_global.login_id
2847: , request_id

Line 2845: , fnd_global.user_id

2841: , lock_flag
2842: , SYSDATE
2843: , fnd_global.user_id
2844: , SYSDATE
2845: , fnd_global.user_id
2846: , fnd_global.login_id
2847: , request_id
2848: , program_application_id
2849: , program_id

Line 2846: , fnd_global.login_id

2842: , SYSDATE
2843: , fnd_global.user_id
2844: , SYSDATE
2845: , fnd_global.user_id
2846: , fnd_global.login_id
2847: , request_id
2848: , program_application_id
2849: , program_id
2850: , program_update_date

Line 5266: , last_updated_by = fnd_global.user_id

5262: -- Bug5659809: update last_update_date and last_update_by as well
5263: UPDATE wms_license_plate_numbers
5264: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
5265: , last_update_date = SYSDATE
5266: , last_updated_by = fnd_global.user_id
5267: WHERE lpn_id = l_inner_lpn_id;
5268:
5269: IF l_debug = 1 THEN
5270: print_debug ('Updated LPN context to pack since entire LPN is

Line 7587: , last_updated_by = fnd_global.user_id

7583: -- Bug5659809: update last_update_date and last_update_by as well
7584: UPDATE wms_license_plate_numbers wlpn1
7585: SET wlpn1.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
7586: , last_update_date = SYSDATE
7587: , last_updated_by = fnd_global.user_id
7588: WHERE wlpn1.lpn_id IN
7589: ( SELECT mmtt.content_lpn_id
7590: FROM mtl_material_transactions_temp mmtt
7591: , wms_license_plate_numbers wlpn2

Line 9679: , last_updated_by = fnd_global.user_id

9675: -- Bug5659809: update last_update_date and last_update_by as well
9676: UPDATE wms_license_plate_numbers wlpn
9677: SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
9678: , last_update_date = SYSDATE
9679: , last_updated_by = fnd_global.user_id
9680: WHERE wlpn.lpn_id = l_curr_xfer_lpn_id
9681: AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
9682:
9683: IF l_debug = 1 AND SQL%FOUND

Line 9902: , p_user_id => fnd_global.user_id -- 9798240,p_emp_id

9898: , p_loc => p_loc_id
9899: , p_sub => p_subinventory
9900: , p_from_lpn_id => l_curr_xfer_lpn_id
9901: , p_txn_hdr_id => l_txn_header_id
9902: , p_user_id => fnd_global.user_id -- 9798240,p_emp_id
9903: , x_return_status => l_api_return_status
9904: , x_msg_count => l_msg_count
9905: , x_msg_data => l_msg_data
9906: , p_ok_to_process => l_ok_to_process