509: AND l_sl_alloc_flag = 'Y'
510: THEN
511: --{
512: l_sl_alloc_flag := 'N';
513: l_user_id := fnd_global.user_id;
514:
515: IF l_lot_control_code = 1 THEN
516: --{
517: -- Only serial controlled item
2002: mydebug('MANUAL_PICK: WDT record is available', 'MANUAL_PICK');
2003: END IF;
2004:
2005: -- Update MMTT record with a new header
2006: l_user_id := fnd_global.user_id;
2007:
2008: SELECT mtl_material_transactions_s.NEXTVAL txnhdrid
2009: INTO l_txn_hdr_id
2010: FROM DUAL;
2420:
2421: l_group_sequence_number NUMBER;
2422: l_deliveries_list VARCHAR2(2000);
2423: l_cartons_list VARCHAR2(2000);
2424: l_user_id NUMBER := fnd_global.user_id;
2425: l_count NUMBER := 0;
2426: I NUMBER :=0;
2427: J NUMBER :=NULL;
2428:
3743: BEGIN
3744: UPDATE mtl_material_transactions_temp
3745: SET primary_quantity = primary_quantity - l_split_uom_quantities(i).primary_quantity ,
3746: transaction_quantity = transaction_quantity - l_split_uom_quantities(i).transaction_quantity ,
3747: last_updated_by = FND_GLOBAL.USER_ID
3748: WHERE transaction_temp_id = p_source_transaction_number;
3749: EXCEPTION
3750: WHEN OTHERS THEN
3751: IF g_debug = 1 THEN
4492: transaction_mode ,
4493: lock_flag ,
4494: l_sysdate --LAST_UPDATE_DATE
4495: ,
4496: FND_GLOBAL.USER_ID ,
4497: l_sysdate --CREATION_DATE
4498: ,
4499: FND_GLOBAL.USER_ID ,
4500: last_update_login ,
4495: ,
4496: FND_GLOBAL.USER_ID ,
4497: l_sysdate --CREATION_DATE
4498: ,
4499: FND_GLOBAL.USER_ID ,
4500: last_update_login ,
4501: request_id ,
4502: program_application_id ,
4503: program_id ,
4774: loaded_time ,
4775: drop_off_time ,
4776: l_sysdate --last_update_date
4777: ,
4778: FND_GLOBAL.USER_ID ,
4779: l_sysdate --creation_date
4780: ,
4781: FND_GLOBAL.USER_ID ,
4782: last_update_login ,
4777: ,
4778: FND_GLOBAL.USER_ID ,
4779: l_sysdate --creation_date
4780: ,
4781: FND_GLOBAL.USER_ID ,
4782: last_update_login ,
4783: attribute_category ,
4784: attribute1 ,
4785: attribute2 ,
4868: l_transaction_remaining_qty := l_transaction_remaining_qty - mtlt.transaction_quantity;
4869: l_primary_remaining_qty := l_primary_remaining_qty - mtlt.primary_quantity;
4870: UPDATE mtl_transaction_lots_temp
4871: SET transaction_temp_id = p_new_transaction_temp_id ,
4872: last_updated_by = FND_GLOBAL.USER_ID
4873: WHERE rowid = mtlt.rowid;
4874: IF l_transaction_remaining_qty = 0 THEN
4875: EXIT;
4876: END IF;
4893: INTO l_new_serial_txn_temp_id
4894: FROM dual;
4895: UPDATE mtl_transaction_lots_temp
4896: SET serial_transaction_temp_id = l_new_serial_txn_temp_id ,
4897: last_updated_by = FND_GLOBAL.USER_ID
4898: WHERE transaction_temp_id = p_new_transaction_temp_id
4899: AND lot_number = mtlt.lot_number;
4900: split_serial(
4901: p_orig_transaction_temp_id => mtlt.serial_transaction_temp_id ,
4913: -- Update the remaining qty in the mtlt after insert.
4914: UPDATE mtl_transaction_lots_temp
4915: SET transaction_quantity = l_txn_remaining_qty_mtlt ,
4916: primary_quantity = l_prim_remaining_qty_mtlt ,
4917: last_updated_by = FND_GLOBAL.USER_ID
4918: WHERE rowid = mtlt.rowid;
4919: -- As the remaining quantity is already consumed we can safely exit
4920: EXIT ;
4921: END IF;
4962: LOOP
4963: l_transaction_remaining_qty := l_transaction_remaining_qty - 1;
4964: UPDATE mtl_serial_numbers_temp
4965: SET transaction_temp_id = p_new_transaction_temp_id ,
4966: last_updated_by = FND_GLOBAL.USER_ID
4967: WHERE rowid = msnt.rowid;
4968: UPDATE mtl_serial_numbers msn
4969: SET msn.group_mark_id = p_new_transaction_temp_id ,
4970: last_updated_by = FND_GLOBAL.USER_ID
4966: last_updated_by = FND_GLOBAL.USER_ID
4967: WHERE rowid = msnt.rowid;
4968: UPDATE mtl_serial_numbers msn
4969: SET msn.group_mark_id = p_new_transaction_temp_id ,
4970: last_updated_by = FND_GLOBAL.USER_ID
4971: WHERE msn.inventory_item_id = p_inventory_item_id
4972: AND serial_number = msnt.fm_serial_number
4973: AND current_organization_id = p_organization_id;
4974: IF l_transaction_remaining_qty = 0 THEN
5110: SELECT p_new_transaction_temp_id --TRANSACTION_TEMP_ID
5111: ,
5112: sysdate --LAST_UPDATE_DATE
5113: ,
5114: FND_GLOBAL.USER_ID ,
5115: sysdate --CREATION_DATE
5116: ,
5117: FND_GLOBAL.USER_ID ,
5118: LAST_UPDATE_LOGIN ,
5113: ,
5114: FND_GLOBAL.USER_ID ,
5115: sysdate --CREATION_DATE
5116: ,
5117: FND_GLOBAL.USER_ID ,
5118: LAST_UPDATE_LOGIN ,
5119: REQUEST_ID ,
5120: PROGRAM_APPLICATION_ID ,
5121: PROGRAM_ID ,