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.18.12010000.4 2008/12/01 10:22:22 kjujjuru ship $ */
3:
4: g_pkg_body_ver CONSTANT VARCHAR2(100) := '$Header: WMSPKDPB.pls 120.18.12010000.4 2008/12/01 10:22:22 kjujjuru 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: --

Line 1709: , last_updated_by = fnd_global.user_id

1705: -- Bug5659809: update last_update_date and last_update_by as well
1706: UPDATE wms_license_plate_numbers
1707: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
1708: , last_update_date = SYSDATE
1709: , last_updated_by = fnd_global.user_id
1710: WHERE lpn_id = c_mmtt_rec.lpn_id;
1711:
1712: IF l_debug = 1 THEN
1713: print_debug

Line 2327: , last_updated_by = fnd_global.user_id

2323: -- Bug5659809: update last_update_date and last_update_by as well
2324: UPDATE wms_license_plate_numbers
2325: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
2326: , last_update_date = SYSDATE
2327: , last_updated_by = fnd_global.user_id
2328: WHERE lpn_id IN
2329: ( SELECT mmtt.content_lpn_id
2330: FROM mtl_material_transactions_temp mmtt
2331: WHERE mmtt.organization_id = g_current_drop_lpn.organization_id

Line 2355: , last_updated_by = fnd_global.user_id

2351: -- Bug5659809: update last_update_date and last_update_by as well
2352: UPDATE wms_license_plate_numbers
2353: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV
2354: , last_update_date = SYSDATE
2355: , last_updated_by = fnd_global.user_id
2356: WHERE lpn_id IN
2357: ( SELECT mmtt.content_lpn_id
2358: FROM mtl_material_transactions_temp mmtt
2359: WHERE mmtt.organization_id = g_current_drop_lpn.organization_id

Line 2700: , fnd_global.user_id

2696: , source_line_id
2697: , transaction_mode
2698: , lock_flag
2699: , SYSDATE
2700: , fnd_global.user_id
2701: , SYSDATE
2702: , fnd_global.user_id
2703: , fnd_global.login_id
2704: , request_id

Line 2702: , fnd_global.user_id

2698: , lock_flag
2699: , SYSDATE
2700: , fnd_global.user_id
2701: , SYSDATE
2702: , fnd_global.user_id
2703: , fnd_global.login_id
2704: , request_id
2705: , program_application_id
2706: , program_id

Line 2703: , fnd_global.login_id

2699: , SYSDATE
2700: , fnd_global.user_id
2701: , SYSDATE
2702: , fnd_global.user_id
2703: , fnd_global.login_id
2704: , request_id
2705: , program_application_id
2706: , program_id
2707: , program_update_date

Line 4988: , last_updated_by = fnd_global.user_id

4984: -- Bug5659809: update last_update_date and last_update_by as well
4985: UPDATE wms_license_plate_numbers
4986: SET lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
4987: , last_update_date = SYSDATE
4988: , last_updated_by = fnd_global.user_id
4989: WHERE lpn_id = l_inner_lpn_id;
4990:
4991: IF l_debug = 1 THEN
4992: print_debug ('Updated LPN context to pack since entire LPN is

Line 7309: , last_updated_by = fnd_global.user_id

7305: -- Bug5659809: update last_update_date and last_update_by as well
7306: UPDATE wms_license_plate_numbers wlpn1
7307: SET wlpn1.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
7308: , last_update_date = SYSDATE
7309: , last_updated_by = fnd_global.user_id
7310: WHERE wlpn1.lpn_id IN
7311: ( SELECT mmtt.content_lpn_id
7312: FROM mtl_material_transactions_temp mmtt
7313: , wms_license_plate_numbers wlpn2

Line 9360: , last_updated_by = fnd_global.user_id

9356: -- Bug5659809: update last_update_date and last_update_by as well
9357: UPDATE wms_license_plate_numbers wlpn
9358: SET wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PACKING
9359: , last_update_date = SYSDATE
9360: , last_updated_by = fnd_global.user_id
9361: WHERE wlpn.lpn_id = l_curr_xfer_lpn_id
9362: AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_PREGENERATED;
9363:
9364: IF l_debug = 1 AND SQL%FOUND