DBA Data[Home] [Help]

APPS.WMS_SHIPPING_TRANSACTION_PUB dependencies on FND_GLOBAL

Line 810: FND_GLOBAL.USER_ID,

806: l_locator_id,
807: l_requested_quantity,
808: l_dock_appoint_flag,
809: sysdate,
810: FND_GLOBAL.USER_ID,
811: sysdate,
812: FND_GLOBAL.USER_ID,
813: FND_GLOBAL.LOGIN_ID,
814: l_released_status,

Line 812: FND_GLOBAL.USER_ID,

808: l_dock_appoint_flag,
809: sysdate,
810: FND_GLOBAL.USER_ID,
811: sysdate,
812: FND_GLOBAL.USER_ID,
813: FND_GLOBAL.LOGIN_ID,
814: l_released_status,
815: p_direct_ship_flag
816: );

Line 813: FND_GLOBAL.LOGIN_ID,

809: sysdate,
810: FND_GLOBAL.USER_ID,
811: sysdate,
812: FND_GLOBAL.USER_ID,
813: FND_GLOBAL.LOGIN_ID,
814: l_released_status,
815: p_direct_ship_flag
816: );
817: -- Mrana : 8/30/06: No need to call delivery merge, if the delivery is not open anymore

Line 1965: last_updated_by = FND_GLOBAL.USER_ID

1961: -- change the LPN context
1962: UPDATE WMS_LICENSE_PLATE_NUMBERS
1963: SET lpn_context = WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT,
1964: last_update_date = SYSDATE,
1965: last_updated_by = FND_GLOBAL.USER_ID
1966: where lpn_id = p_outermost_lpn_id;
1967:
1968: -- update the lpn context for all children lpns
1969: FOR l_lpn_id IN nested_children_lpn_cursor LOOP

Line 1973: last_updated_by = FND_GLOBAL.USER_ID

1969: FOR l_lpn_id IN nested_children_lpn_cursor LOOP
1970: UPDATE WMS_LICENSE_PLATE_NUMBERS
1971: SET lpn_context = WMS_Container_PUB.LPN_LOADED_FOR_SHIPMENT,
1972: last_update_date = SYSDATE,
1973: last_updated_by = FND_GLOBAL.USER_ID
1974: where lpn_id = l_lpn_id.lpn_id;
1975: END LOOP;
1976:
1977: --Patchset J LPN hierarchy

Line 2442: last_updated_by = FND_GLOBAL.USER_ID

2438: update wms_shipping_transaction_temp
2439: set delivery_id = l_delivery_id,
2440: delivery_name = l_delivery_name,
2441: last_update_date = SYSDATE,
2442: last_updated_by = FND_GLOBAL.USER_ID
2443: where delivery_detail_id = l_delivery_detail_id;
2444:
2445: EXCEPTION
2446: WHEN NO_DATA_FOUND THEN

Line 2597: last_updated_by = FND_GLOBAL.USER_ID

2593: update wms_shipping_transaction_temp
2594: set delivery_id = l_delivery_id,
2595: delivery_name = l_delivery_name,
2596: last_update_date = SYSDATE,
2597: last_updated_by = FND_GLOBAL.USER_ID
2598: where outermost_lpn_id = (SELECT outermost_lpn_id FROM wms_shipping_transaction_temp
2599: WHERE delivery_detail_id = l_del_rows(l_del_count));
2600: end loop;
2601: end if;

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

2711: debug('Calling WSH_TRIPS_PUB.create_update_trip','update_trip');
2712:
2713: l_trip_info.trip_id := l_trip_id;
2714: l_trip_info.last_update_date := SYSDATE;
2715: l_trip_info.last_updated_by :=FND_GLOBAL.USER_ID;
2716: l_trip_info.last_update_login :=FND_GLOBAL.USER_ID;
2717: l_trip_info.ship_method_code :=p_ship_method_code;
2718:
2719: WSH_TRIPS_PUB.Create_Update_Trip

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

2712:
2713: l_trip_info.trip_id := l_trip_id;
2714: l_trip_info.last_update_date := SYSDATE;
2715: l_trip_info.last_updated_by :=FND_GLOBAL.USER_ID;
2716: l_trip_info.last_update_login :=FND_GLOBAL.USER_ID;
2717: l_trip_info.ship_method_code :=p_ship_method_code;
2718:
2719: WSH_TRIPS_PUB.Create_Update_Trip
2720: (p_api_version_number => 1.0

Line 4154: last_updated_by = FND_GLOBAL.USER_ID

4150: exit when outermost_lpn_for_trip%NOTFOUND;
4151: UPDATE WMS_LICENSE_PLATE_NUMBERS
4152: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4153: last_update_date = SYSDATE,
4154: last_updated_by = FND_GLOBAL.USER_ID
4155: where lpn_id = l_outermost_lpn_id;
4156:
4157: -- update the lpn context for all children lpns
4158: FOR l_lpn_id IN nested_children_lpn_cursor(l_outermost_lpn_id) LOOP

Line 4162: last_updated_by = FND_GLOBAL.USER_ID

4158: FOR l_lpn_id IN nested_children_lpn_cursor(l_outermost_lpn_id) LOOP
4159: UPDATE WMS_LICENSE_PLATE_NUMBERS
4160: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4161: last_update_date = SYSDATE,
4162: last_updated_by = FND_GLOBAL.USER_ID
4163: where lpn_id = l_lpn_id.lpn_id;
4164: END LOOP;
4165: END LOOP;
4166: close outermost_lpn_for_trip;

Line 4193: last_updated_by = FND_GLOBAL.USER_ID

4189: exit when outermost_lpn_for_dock%NOTFOUND;
4190: UPDATE WMS_LICENSE_PLATE_NUMBERS
4191: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4192: last_update_date = SYSDATE,
4193: last_updated_by = FND_GLOBAL.USER_ID
4194: where lpn_id = l_outermost_lpn_id;
4195:
4196: -- update the lpn context for all children lpns
4197: FOR l_lpn_id IN nested_children_lpn_cursor(l_outermost_lpn_id) LOOP

Line 4201: last_updated_by = FND_GLOBAL.USER_ID

4197: FOR l_lpn_id IN nested_children_lpn_cursor(l_outermost_lpn_id) LOOP
4198: UPDATE WMS_LICENSE_PLATE_NUMBERS
4199: SET lpn_context = 11, --WMS_Container_PUB.LPN_CONTEXT_INV,
4200: last_update_date = SYSDATE,
4201: last_updated_by = FND_GLOBAL.USER_ID
4202: where lpn_id = l_lpn_id.lpn_id;
4203: END LOOP;
4204: END LOOP;
4205: close outermost_lpn_for_dock;

Line 4913: l_user := fnd_global.user_id;

4909: l_user NUMBER;
4910: l_login_id NUMBER;
4911: BEGIN
4912:
4913: l_user := fnd_global.user_id;
4914: l_login_id := fnd_global.login_id;
4915:
4916: l_serial_prefix := rtrim(l_fm_serial_number, '0123456789');
4917:

Line 4914: l_login_id := fnd_global.login_id;

4910: l_login_id NUMBER;
4911: BEGIN
4912:
4913: l_user := fnd_global.user_id;
4914: l_login_id := fnd_global.login_id;
4915:
4916: l_serial_prefix := rtrim(l_fm_serial_number, '0123456789');
4917:
4918: insert into mtl_serial_numbers_temp

Line 5477: last_updated_by = fnd_global.user_id

5473: --update lpn_context
5474: UPDATE wms_license_plate_numbers
5475: SET lpn_context = wms_globals.lpn_context_picked,
5476: last_update_date = Sysdate,
5477: last_updated_by = fnd_global.user_id
5478: WHERE organization_id = p_organization_id
5479: AND outermost_lpn_id = p_outermost_lpn_id;
5480:
5481: --patchset J. Shipping API cleanup