90: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
91:
92: cursor get_mo_line_info is
93: select mtrl.reference, mtrl.reference_id, mtrl.line_id, mmtt.transaction_source_type_id
94: from mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
95: where mtrl.line_id = mmtt.move_order_line_id
96: and mmtt.transaction_temp_id = p_transaction_id;
97:
98: begin
236: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
237:
238: cursor get_mo_line_info is
239: select mtrl.reference, mtrl.reference_id, mtrl.line_id, mmtt.transaction_source_type_id
240: from mtl_material_transactions_temp mmtt, mtl_txn_request_lines mtrl
241: where mtrl.line_id = mmtt.move_order_line_id
242: and mmtt.transaction_temp_id = p_transaction_id;
243:
244: begin