DBA Data[Home] [Help]

APPS.WMS_TASK_MGMT_PUB dependencies on FND_GLOBAL

Line 2009: FND_GLOBAL.USER_ID ,

2005: SELECT p_new_transaction_temp_id --TRANSACTION_TEMP_ID
2006: ,
2007: sysdate --LAST_UPDATE_DATE
2008: ,
2009: FND_GLOBAL.USER_ID ,
2010: sysdate --CREATION_DATE
2011: ,
2012: FND_GLOBAL.USER_ID ,
2013: LAST_UPDATE_LOGIN ,

Line 2012: FND_GLOBAL.USER_ID ,

2008: ,
2009: FND_GLOBAL.USER_ID ,
2010: sysdate --CREATION_DATE
2011: ,
2012: FND_GLOBAL.USER_ID ,
2013: LAST_UPDATE_LOGIN ,
2014: REQUEST_ID ,
2015: PROGRAM_APPLICATION_ID ,
2016: PROGRAM_ID ,

Line 2167: last_updated_by = FND_GLOBAL.USER_ID

2163: LOOP
2164: l_transaction_remaining_qty := l_transaction_remaining_qty - 1;
2165: UPDATE mtl_serial_numbers_temp
2166: SET transaction_temp_id = p_new_transaction_temp_id ,
2167: last_updated_by = FND_GLOBAL.USER_ID
2168: WHERE rowid = msnt.rowid;
2169: UPDATE mtl_serial_numbers msn
2170: SET msn.group_mark_id = p_new_transaction_temp_id ,
2171: last_updated_by = FND_GLOBAL.USER_ID

Line 2171: last_updated_by = FND_GLOBAL.USER_ID

2167: last_updated_by = FND_GLOBAL.USER_ID
2168: WHERE rowid = msnt.rowid;
2169: UPDATE mtl_serial_numbers msn
2170: SET msn.group_mark_id = p_new_transaction_temp_id ,
2171: last_updated_by = FND_GLOBAL.USER_ID
2172: WHERE msn.inventory_item_id = p_inventory_item_id
2173: AND serial_number = msnt.fm_serial_number
2174: AND current_organization_id = p_organization_id;
2175: IF l_transaction_remaining_qty = 0 THEN

Line 2247: last_updated_by = FND_GLOBAL.USER_ID

2243: l_transaction_remaining_qty := l_transaction_remaining_qty - mtlt.transaction_quantity;
2244: l_primary_remaining_qty := l_primary_remaining_qty - mtlt.primary_quantity;
2245: UPDATE mtl_transaction_lots_temp
2246: SET transaction_temp_id = p_new_transaction_temp_id ,
2247: last_updated_by = FND_GLOBAL.USER_ID
2248: WHERE rowid = mtlt.rowid;
2249: IF l_transaction_remaining_qty = 0 THEN
2250: EXIT;
2251: END IF;

Line 2270: last_updated_by = FND_GLOBAL.USER_ID

2266: INTO l_new_serial_txn_temp_id
2267: FROM dual;
2268: UPDATE mtl_transaction_lots_temp
2269: SET serial_transaction_temp_id = l_new_serial_txn_temp_id ,
2270: last_updated_by = FND_GLOBAL.USER_ID
2271: WHERE transaction_temp_id = p_new_transaction_temp_id
2272: AND lot_number = mtlt.lot_number;
2273: split_serial( p_orig_transaction_temp_id => mtlt.serial_transaction_temp_id ,
2274: p_new_transaction_temp_id => l_new_serial_txn_temp_id ,

Line 2289: last_updated_by = FND_GLOBAL.USER_ID

2285: -- Update the remaining qty in the mtlt after insert.
2286: UPDATE mtl_transaction_lots_temp
2287: SET transaction_quantity = l_txn_remaining_qty_mtlt ,
2288: primary_quantity = l_prim_remaining_qty_mtlt ,
2289: last_updated_by = FND_GLOBAL.USER_ID
2290: WHERE rowid = mtlt.rowid;
2291: -- As the remaining quantity is already consumed we can safely exit
2292: EXIT ;
2293: END IF;

Line 2399: FND_GLOBAL.USER_ID ,

2395: loaded_time ,
2396: drop_off_time ,
2397: l_sysdate --last_update_date
2398: ,
2399: FND_GLOBAL.USER_ID ,
2400: l_sysdate --creation_date
2401: ,
2402: FND_GLOBAL.USER_ID ,
2403: last_update_login ,

Line 2402: FND_GLOBAL.USER_ID ,

2398: ,
2399: FND_GLOBAL.USER_ID ,
2400: l_sysdate --creation_date
2401: ,
2402: FND_GLOBAL.USER_ID ,
2403: last_update_login ,
2404: attribute_category ,
2405: attribute1 ,
2406: attribute2 ,

Line 2766: FND_GLOBAL.USER_ID ,

2762: transaction_mode ,
2763: lock_flag ,
2764: l_sysdate --LAST_UPDATE_DATE
2765: ,
2766: FND_GLOBAL.USER_ID ,
2767: l_sysdate --CREATION_DATE
2768: ,
2769: FND_GLOBAL.USER_ID ,
2770: last_update_login ,

Line 2769: FND_GLOBAL.USER_ID ,

2765: ,
2766: FND_GLOBAL.USER_ID ,
2767: l_sysdate --CREATION_DATE
2768: ,
2769: FND_GLOBAL.USER_ID ,
2770: last_update_login ,
2771: request_id ,
2772: program_application_id ,
2773: program_id ,

Line 6864: last_updated_by = FND_GLOBAL.USER_ID

6860: BEGIN
6861: UPDATE mtl_material_transactions_temp
6862: SET primary_quantity = primary_quantity - l_split_uom_quantities(i).primary_quantity ,
6863: transaction_quantity = transaction_quantity - l_split_uom_quantities(i).transaction_quantity ,
6864: last_updated_by = FND_GLOBAL.USER_ID
6865: WHERE transaction_temp_id = p_source_transaction_number;
6866: EXCEPTION
6867: WHEN OTHERS THEN
6868: IF g_debug = 1 THEN

Line 7616: FND_GLOBAL.USER_ID ,

7612: l_machine_resource_id_table(i) ,
7613: l_status_id_table(i) ,
7614: sysdate ,
7615: sysdate ,
7616: FND_GLOBAL.USER_ID ,
7617: sysdate ,
7618: FND_GLOBAL.USER_ID ,
7619: l_task_type_id_table(i) ,
7620: l_priority_table(i) ,

Line 7618: FND_GLOBAL.USER_ID ,

7614: sysdate ,
7615: sysdate ,
7616: FND_GLOBAL.USER_ID ,
7617: sysdate ,
7618: FND_GLOBAL.USER_ID ,
7619: l_task_type_id_table(i) ,
7620: l_priority_table(i) ,
7621: l_move_order_line_id_table(i) ,
7622: l_operation_plan_id_table(i) ,