DBA Data[Home] [Help]

APPS.WMS_TASK_MGMT_PUB dependencies on FND_GLOBAL

Line 2086: FND_GLOBAL.USER_ID ,

2082: SELECT p_new_transaction_temp_id --TRANSACTION_TEMP_ID
2083: ,
2084: sysdate --LAST_UPDATE_DATE
2085: ,
2086: FND_GLOBAL.USER_ID ,
2087: sysdate --CREATION_DATE
2088: ,
2089: FND_GLOBAL.USER_ID ,
2090: LAST_UPDATE_LOGIN ,

Line 2089: FND_GLOBAL.USER_ID ,

2085: ,
2086: FND_GLOBAL.USER_ID ,
2087: sysdate --CREATION_DATE
2088: ,
2089: FND_GLOBAL.USER_ID ,
2090: LAST_UPDATE_LOGIN ,
2091: REQUEST_ID ,
2092: PROGRAM_APPLICATION_ID ,
2093: PROGRAM_ID ,

Line 2244: last_updated_by = FND_GLOBAL.USER_ID

2240: LOOP
2241: l_transaction_remaining_qty := l_transaction_remaining_qty - 1;
2242: UPDATE mtl_serial_numbers_temp
2243: SET transaction_temp_id = p_new_transaction_temp_id ,
2244: last_updated_by = FND_GLOBAL.USER_ID
2245: WHERE rowid = msnt.rowid;
2246: UPDATE mtl_serial_numbers msn
2247: SET msn.group_mark_id = p_new_transaction_temp_id ,
2248: last_updated_by = FND_GLOBAL.USER_ID

Line 2248: last_updated_by = FND_GLOBAL.USER_ID

2244: last_updated_by = FND_GLOBAL.USER_ID
2245: WHERE rowid = msnt.rowid;
2246: UPDATE mtl_serial_numbers msn
2247: SET msn.group_mark_id = p_new_transaction_temp_id ,
2248: last_updated_by = FND_GLOBAL.USER_ID
2249: WHERE msn.inventory_item_id = p_inventory_item_id
2250: AND serial_number = msnt.fm_serial_number
2251: AND current_organization_id = p_organization_id;
2252: IF l_transaction_remaining_qty = 0 THEN

Line 2329: last_updated_by = FND_GLOBAL.USER_ID

2325: l_primary_remaining_qty := l_primary_remaining_qty - mtlt.primary_quantity;
2326: l_secondary_remaining_qty := l_secondary_remaining_qty - mtlt.secondary_quantity; -- Added for Bug 16099247
2327: UPDATE mtl_transaction_lots_temp
2328: SET transaction_temp_id = p_new_transaction_temp_id ,
2329: last_updated_by = FND_GLOBAL.USER_ID
2330: WHERE rowid = mtlt.rowid;
2331: IF l_transaction_remaining_qty = 0 THEN
2332: EXIT;
2333: END IF;

Line 2354: last_updated_by = FND_GLOBAL.USER_ID

2350: INTO l_new_serial_txn_temp_id
2351: FROM dual;
2352: UPDATE mtl_transaction_lots_temp
2353: SET serial_transaction_temp_id = l_new_serial_txn_temp_id ,
2354: last_updated_by = FND_GLOBAL.USER_ID
2355: WHERE transaction_temp_id = p_new_transaction_temp_id
2356: AND lot_number = mtlt.lot_number;
2357: split_serial( p_orig_transaction_temp_id => mtlt.serial_transaction_temp_id ,
2358: p_new_transaction_temp_id => l_new_serial_txn_temp_id ,

Line 2375: last_updated_by = FND_GLOBAL.USER_ID

2371: UPDATE mtl_transaction_lots_temp
2372: SET transaction_quantity = l_txn_remaining_qty_mtlt ,
2373: primary_quantity = l_prim_remaining_qty_mtlt ,
2374: secondary_quantity = l_sec_remaining_qty_mtlt , -- Added for Bug 16099247
2375: last_updated_by = FND_GLOBAL.USER_ID
2376: WHERE rowid = mtlt.rowid;
2377: -- As the remaining quantity is already consumed we can safely exit
2378: EXIT ;
2379: END IF;

Line 2485: FND_GLOBAL.USER_ID ,

2481: loaded_time ,
2482: drop_off_time ,
2483: l_sysdate --last_update_date
2484: ,
2485: FND_GLOBAL.USER_ID ,
2486: l_sysdate --creation_date
2487: ,
2488: FND_GLOBAL.USER_ID ,
2489: last_update_login ,

Line 2488: FND_GLOBAL.USER_ID ,

2484: ,
2485: FND_GLOBAL.USER_ID ,
2486: l_sysdate --creation_date
2487: ,
2488: FND_GLOBAL.USER_ID ,
2489: last_update_login ,
2490: attribute_category ,
2491: attribute1 ,
2492: attribute2 ,

Line 2854: FND_GLOBAL.USER_ID ,

2850: transaction_mode ,
2851: lock_flag ,
2852: l_sysdate --LAST_UPDATE_DATE
2853: ,
2854: FND_GLOBAL.USER_ID ,
2855: l_sysdate --CREATION_DATE
2856: ,
2857: FND_GLOBAL.USER_ID ,
2858: last_update_login ,

Line 2857: FND_GLOBAL.USER_ID ,

2853: ,
2854: FND_GLOBAL.USER_ID ,
2855: l_sysdate --CREATION_DATE
2856: ,
2857: FND_GLOBAL.USER_ID ,
2858: last_update_login ,
2859: request_id ,
2860: program_application_id ,
2861: program_id ,

Line 6962: last_updated_by = FND_GLOBAL.USER_ID

6958: UPDATE mtl_material_transactions_temp
6959: SET primary_quantity = primary_quantity - l_split_uom_quantities(i).primary_quantity ,
6960: transaction_quantity = transaction_quantity - l_split_uom_quantities(i).transaction_quantity ,
6961: secondary_transaction_quantity = secondary_transaction_quantity - l_split_uom_quantities(i).secondary_quantity , -- Added for Bug 16099247
6962: last_updated_by = FND_GLOBAL.USER_ID
6963: WHERE transaction_temp_id = p_source_transaction_number;
6964: EXCEPTION
6965: WHEN OTHERS THEN
6966: IF g_debug = 1 THEN

Line 7715: FND_GLOBAL.USER_ID ,

7711: l_machine_resource_id_table(i) ,
7712: l_status_id_table(i) ,
7713: sysdate ,
7714: sysdate ,
7715: FND_GLOBAL.USER_ID ,
7716: sysdate ,
7717: FND_GLOBAL.USER_ID ,
7718: l_task_type_id_table(i) ,
7719: l_priority_table(i) ,

Line 7717: FND_GLOBAL.USER_ID ,

7713: sysdate ,
7714: sysdate ,
7715: FND_GLOBAL.USER_ID ,
7716: sysdate ,
7717: FND_GLOBAL.USER_ID ,
7718: l_task_type_id_table(i) ,
7719: l_priority_table(i) ,
7720: l_move_order_line_id_table(i) ,
7721: l_operation_plan_id_table(i) ,