DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on FND_GLOBAL

Line 863: FND_GLOBAL.USER_ID,

859: l_locator_id,
860: l_requested_quantity,
861: l_dock_appoint_flag,
862: sysdate,
863: FND_GLOBAL.USER_ID,
864: sysdate,
865: FND_GLOBAL.USER_ID,
866: FND_GLOBAL.LOGIN_ID,
867: l_released_status,

Line 865: FND_GLOBAL.USER_ID,

861: l_dock_appoint_flag,
862: sysdate,
863: FND_GLOBAL.USER_ID,
864: sysdate,
865: FND_GLOBAL.USER_ID,
866: FND_GLOBAL.LOGIN_ID,
867: l_released_status,
868: p_direct_ship_flag
869: );

Line 866: FND_GLOBAL.LOGIN_ID,

862: sysdate,
863: FND_GLOBAL.USER_ID,
864: sysdate,
865: FND_GLOBAL.USER_ID,
866: FND_GLOBAL.LOGIN_ID,
867: l_released_status,
868: p_direct_ship_flag
869: );
870: -- Mrana : 8/30/06: No need to call delivery merge, if the delivery is not open anymore

Line 2026: last_updated_by = FND_GLOBAL.USER_ID

2022: -- change the LPN context
2023: UPDATE WMS_LICENSE_PLATE_NUMBERS
2024: SET lpn_context = WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT,
2025: last_update_date = SYSDATE,
2026: last_updated_by = FND_GLOBAL.USER_ID
2027: where lpn_id = p_outermost_lpn_id;
2028:
2029: -- update the lpn context for all children lpns
2030: FOR l_lpn_id IN nested_children_lpn_cursor LOOP

Line 2034: last_updated_by = FND_GLOBAL.USER_ID

2030: FOR l_lpn_id IN nested_children_lpn_cursor LOOP
2031: UPDATE WMS_LICENSE_PLATE_NUMBERS
2032: SET lpn_context = WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT,
2033: last_update_date = SYSDATE,
2034: last_updated_by = FND_GLOBAL.USER_ID
2035: where lpn_id = l_lpn_id.lpn_id;
2036: END LOOP;
2037:
2038: --Patchset J LPN hierarchy

Line 2503: last_updated_by = FND_GLOBAL.USER_ID

2499: update wms_shipping_transaction_temp
2500: set delivery_id = l_delivery_id,
2501: delivery_name = l_delivery_name,
2502: last_update_date = SYSDATE,
2503: last_updated_by = FND_GLOBAL.USER_ID
2504: where delivery_detail_id = l_delivery_detail_id;
2505:
2506: EXCEPTION
2507: WHEN NO_DATA_FOUND THEN

Line 2658: last_updated_by = FND_GLOBAL.USER_ID

2654: update wms_shipping_transaction_temp
2655: set delivery_id = l_delivery_id,
2656: delivery_name = l_delivery_name,
2657: last_update_date = SYSDATE,
2658: last_updated_by = FND_GLOBAL.USER_ID
2659: where outermost_lpn_id = (SELECT outermost_lpn_id FROM wms_shipping_transaction_temp
2660: WHERE delivery_detail_id = l_del_rows(l_del_count));
2661: end loop;
2662: end if;

Line 2776: l_trip_info.last_updated_by :=FND_GLOBAL.USER_ID;

2772: debug('Calling WSH_TRIPS_PUB.create_update_trip','update_trip');
2773:
2774: l_trip_info.trip_id := l_trip_id;
2775: l_trip_info.last_update_date := SYSDATE;
2776: l_trip_info.last_updated_by :=FND_GLOBAL.USER_ID;
2777: l_trip_info.last_update_login :=FND_GLOBAL.USER_ID;
2778: l_trip_info.ship_method_code :=p_ship_method_code;
2779:
2780: WSH_TRIPS_PUB.Create_Update_Trip

Line 2777: l_trip_info.last_update_login :=FND_GLOBAL.USER_ID;

2773:
2774: l_trip_info.trip_id := l_trip_id;
2775: l_trip_info.last_update_date := SYSDATE;
2776: l_trip_info.last_updated_by :=FND_GLOBAL.USER_ID;
2777: l_trip_info.last_update_login :=FND_GLOBAL.USER_ID;
2778: l_trip_info.ship_method_code :=p_ship_method_code;
2779:
2780: WSH_TRIPS_PUB.Create_Update_Trip
2781: (p_api_version_number => 1.0

Line 4314: last_updated_by = FND_GLOBAL.USER_ID

4310: exit when outermost_lpn_for_trip%NOTFOUND;
4311: UPDATE WMS_LICENSE_PLATE_NUMBERS
4312: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4313: last_update_date = SYSDATE,
4314: last_updated_by = FND_GLOBAL.USER_ID
4315: where lpn_id = l_outermost_lpn_id;
4316:
4317: -- update the lpn context for all children lpns
4318: FOR l_lpn_id IN nested_children_lpn_cursor(l_outermost_lpn_id) LOOP

Line 4322: last_updated_by = FND_GLOBAL.USER_ID

4318: FOR l_lpn_id IN nested_children_lpn_cursor(l_outermost_lpn_id) LOOP
4319: UPDATE WMS_LICENSE_PLATE_NUMBERS
4320: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4321: last_update_date = SYSDATE,
4322: last_updated_by = FND_GLOBAL.USER_ID
4323: where lpn_id = l_lpn_id.lpn_id;
4324: END LOOP;
4325: END LOOP;
4326: close outermost_lpn_for_trip;

Line 4353: last_updated_by = FND_GLOBAL.USER_ID

4349: exit when outermost_lpn_for_dock%NOTFOUND;
4350: UPDATE WMS_LICENSE_PLATE_NUMBERS
4351: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4352: last_update_date = SYSDATE,
4353: last_updated_by = FND_GLOBAL.USER_ID
4354: where lpn_id = l_outermost_lpn_id;
4355:
4356: -- update the lpn context for all children lpns
4357: FOR l_lpn_id IN nested_children_lpn_cursor(l_outermost_lpn_id) LOOP

Line 4361: last_updated_by = FND_GLOBAL.USER_ID

4357: FOR l_lpn_id IN nested_children_lpn_cursor(l_outermost_lpn_id) LOOP
4358: UPDATE WMS_LICENSE_PLATE_NUMBERS
4359: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4360: last_update_date = SYSDATE,
4361: last_updated_by = FND_GLOBAL.USER_ID
4362: where lpn_id = l_lpn_id.lpn_id;
4363: END LOOP;
4364: END LOOP;
4365: close outermost_lpn_for_dock;

Line 5073: l_user := fnd_global.user_id;

5069: l_user NUMBER;
5070: l_login_id NUMBER;
5071: BEGIN
5072:
5073: l_user := fnd_global.user_id;
5074: l_login_id := fnd_global.login_id;
5075:
5076: l_serial_prefix := rtrim(l_fm_serial_number, '0123456789');
5077:

Line 5074: l_login_id := fnd_global.login_id;

5070: l_login_id NUMBER;
5071: BEGIN
5072:
5073: l_user := fnd_global.user_id;
5074: l_login_id := fnd_global.login_id;
5075:
5076: l_serial_prefix := rtrim(l_fm_serial_number, '0123456789');
5077:
5078: insert into mtl_serial_numbers_temp

Line 5652: last_updated_by = fnd_global.user_id

5648: --update lpn_context
5649: UPDATE wms_license_plate_numbers
5650: SET lpn_context = wms_globals.lpn_context_picked,
5651: last_update_date = Sysdate,
5652: last_updated_by = fnd_global.user_id
5653: WHERE organization_id = p_organization_id
5654: AND outermost_lpn_id = p_outermost_lpn_id;
5655:
5656: --patchset J. Shipping API cleanup