DBA Data[Home] [Help]

APPS.WMS_PICKING_PKG dependencies on FND_GLOBAL

Line 678: l_user_id := fnd_global.user_id;

674: AND l_sl_alloc_flag = 'Y'
675: THEN
676: --{
677: l_sl_alloc_flag := 'N';
678: l_user_id := fnd_global.user_id;
679:
680: IF l_lot_control_code = 1 THEN
681: --{
682: -- Only serial controlled item

Line 2266: l_user_id := fnd_global.user_id;

2262: mydebug('MANUAL_PICK: WDT record is available', 'MANUAL_PICK');
2263: END IF;
2264:
2265: -- Update MMTT record with a new header
2266: l_user_id := fnd_global.user_id;
2267:
2268: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
2269: INTO l_txn_hdr_id
2270: FROM DUAL;

Line 2789: l_user_id NUMBER := fnd_global.user_id;

2785:
2786: l_group_sequence_number NUMBER;
2787: l_deliveries_list VARCHAR2(2000);
2788: l_cartons_list VARCHAR2(2000);
2789: l_user_id NUMBER := fnd_global.user_id;
2790: l_count NUMBER := 0;
2791: I NUMBER :=0;
2792: J NUMBER :=NULL;
2793:

Line 4175: last_updated_by = FND_GLOBAL.USER_ID

4171: BEGIN
4172: UPDATE mtl_material_transactions_temp
4173: SET primary_quantity = primary_quantity - l_split_uom_quantities(i).primary_quantity ,
4174: transaction_quantity = transaction_quantity - l_split_uom_quantities(i).transaction_quantity ,
4175: last_updated_by = FND_GLOBAL.USER_ID
4176: WHERE transaction_temp_id = p_source_transaction_number;
4177: EXCEPTION
4178: WHEN OTHERS THEN
4179: IF g_debug = 1 THEN

Line 4925: FND_GLOBAL.USER_ID ,

4921: transaction_mode ,
4922: lock_flag ,
4923: l_sysdate --LAST_UPDATE_DATE
4924: ,
4925: FND_GLOBAL.USER_ID ,
4926: l_sysdate --CREATION_DATE
4927: ,
4928: FND_GLOBAL.USER_ID ,
4929: last_update_login ,

Line 4928: FND_GLOBAL.USER_ID ,

4924: ,
4925: FND_GLOBAL.USER_ID ,
4926: l_sysdate --CREATION_DATE
4927: ,
4928: FND_GLOBAL.USER_ID ,
4929: last_update_login ,
4930: request_id ,
4931: program_application_id ,
4932: program_id ,

Line 5208: FND_GLOBAL.USER_ID ,

5204: loaded_time ,
5205: drop_off_time ,
5206: l_sysdate --last_update_date
5207: ,
5208: FND_GLOBAL.USER_ID ,
5209: l_sysdate --creation_date
5210: ,
5211: FND_GLOBAL.USER_ID ,
5212: last_update_login ,

Line 5211: FND_GLOBAL.USER_ID ,

5207: ,
5208: FND_GLOBAL.USER_ID ,
5209: l_sysdate --creation_date
5210: ,
5211: FND_GLOBAL.USER_ID ,
5212: last_update_login ,
5213: attribute_category ,
5214: attribute1 ,
5215: attribute2 ,

Line 5302: last_updated_by = FND_GLOBAL.USER_ID

5298: l_transaction_remaining_qty := l_transaction_remaining_qty - mtlt.transaction_quantity;
5299: l_primary_remaining_qty := l_primary_remaining_qty - mtlt.primary_quantity;
5300: UPDATE mtl_transaction_lots_temp
5301: SET transaction_temp_id = p_new_transaction_temp_id ,
5302: last_updated_by = FND_GLOBAL.USER_ID
5303: WHERE rowid = mtlt.rowid;
5304: IF l_transaction_remaining_qty = 0 THEN
5305: EXIT;
5306: END IF;

Line 5327: last_updated_by = FND_GLOBAL.USER_ID

5323: INTO l_new_serial_txn_temp_id
5324: FROM dual;
5325: UPDATE mtl_transaction_lots_temp
5326: SET serial_transaction_temp_id = l_new_serial_txn_temp_id ,
5327: last_updated_by = FND_GLOBAL.USER_ID
5328: WHERE transaction_temp_id = p_new_transaction_temp_id
5329: AND lot_number = mtlt.lot_number;
5330: split_serial(
5331: p_orig_transaction_temp_id => mtlt.serial_transaction_temp_id ,

Line 5347: last_updated_by = FND_GLOBAL.USER_ID

5343: -- Update the remaining qty in the mtlt after insert.
5344: UPDATE mtl_transaction_lots_temp
5345: SET transaction_quantity = l_txn_remaining_qty_mtlt ,
5346: primary_quantity = l_prim_remaining_qty_mtlt ,
5347: last_updated_by = FND_GLOBAL.USER_ID
5348: WHERE rowid = mtlt.rowid;
5349: -- As the remaining quantity is already consumed we can safely exit
5350: EXIT ;
5351: END IF;

Line 5396: last_updated_by = FND_GLOBAL.USER_ID

5392: LOOP
5393: l_transaction_remaining_qty := l_transaction_remaining_qty - 1;
5394: UPDATE mtl_serial_numbers_temp
5395: SET transaction_temp_id = p_new_transaction_temp_id ,
5396: last_updated_by = FND_GLOBAL.USER_ID
5397: WHERE rowid = msnt.rowid;
5398: UPDATE mtl_serial_numbers msn
5399: SET msn.group_mark_id = p_new_transaction_temp_id ,
5400: last_updated_by = FND_GLOBAL.USER_ID

Line 5400: last_updated_by = FND_GLOBAL.USER_ID

5396: last_updated_by = FND_GLOBAL.USER_ID
5397: WHERE rowid = msnt.rowid;
5398: UPDATE mtl_serial_numbers msn
5399: SET msn.group_mark_id = p_new_transaction_temp_id ,
5400: last_updated_by = FND_GLOBAL.USER_ID
5401: WHERE msn.inventory_item_id = p_inventory_item_id
5402: AND serial_number = msnt.fm_serial_number
5403: AND current_organization_id = p_organization_id;
5404: IF l_transaction_remaining_qty = 0 THEN

Line 5544: FND_GLOBAL.USER_ID ,

5540: SELECT p_new_transaction_temp_id --TRANSACTION_TEMP_ID
5541: ,
5542: sysdate --LAST_UPDATE_DATE
5543: ,
5544: FND_GLOBAL.USER_ID ,
5545: sysdate --CREATION_DATE
5546: ,
5547: FND_GLOBAL.USER_ID ,
5548: LAST_UPDATE_LOGIN ,

Line 5547: FND_GLOBAL.USER_ID ,

5543: ,
5544: FND_GLOBAL.USER_ID ,
5545: sysdate --CREATION_DATE
5546: ,
5547: FND_GLOBAL.USER_ID ,
5548: LAST_UPDATE_LOGIN ,
5549: REQUEST_ID ,
5550: PROGRAM_APPLICATION_ID ,
5551: PROGRAM_ID ,