[Home] [Help]
559: ELSE
560: l_transaction_interface_id := p_transaction_interface_id;
561: END IF;
562:
563: l_serial_control_code := inv_rcv_cache.get_sn_ctrl_code(p_organization_id,p_inventory_item_id);
564:
565: IF l_serial_control_code not in (1,6) THEN -- Bug 9008016
566: SELECT mtl_material_transactions_s.NEXTVAL
567: INTO l_serial_transaction_temp_id
3961: --Must use mmtt quantity and primary quantity for conversion
3962: IF (l_orig_mmtt_rec.transaction_uom = x_orig_mol_rec.uom_code) THEN
3963: l_temp := l_qty_to_splt;
3964: ELSE
3965: l_temp := inv_rcv_cache.convert_qty
3966: (p_inventory_item_id => x_orig_mol_rec.inventory_item_id
3967: ,p_from_qty => l_prim_qty_to_splt
3968: ,p_from_uom_code => p_prim_uom_code
3969: ,p_to_uom_code => l_orig_mmtt_rec.transaction_uom
4484: primary_quantity = l_orig_mmtt_rec.primary_quantity
4485: ,transaction_quantity = Decode(primary_quantity,
4486: transaction_quantity,
4487: l_orig_mmtt_rec.transaction_quantity,
4488: inv_rcv_cache.convert_qty
4489: (x_orig_mol_rec.inventory_item_id
4490: ,l_orig_mmtt_rec.primary_quantity
4491: ,p_prim_uom_code
4492: ,l_orig_mmtt_rec.transaction_uom
4530:
4531: /* Retrieve lot/serial control code call break to split */
4532: /* MTLT/MSLT */
4533: BEGIN
4534: l_lot_control_code := inv_rcv_cache.get_lot_control_code(x_orig_mol_rec.organization_id,
4535: x_orig_mol_rec.inventory_item_id);
4536: l_serial_control_code := 1;
4537: EXCEPTION
4538: WHEN OTHERS THEN
4748: END IF;
4749: l_progress := '240';
4750:
4751: IF (l_orig_mmtt_rec.transaction_uom <> x_orig_mol_rec.uom_code) THEN
4752: l_temp := inv_rcv_cache.convert_qty
4753: (p_inventory_item_id => x_orig_mol_rec.inventory_item_id
4754: ,p_from_qty => l_orig_mmtt_rec.transaction_quantity
4755: ,p_from_uom_code => l_orig_mmtt_rec.transaction_uom
4756: ,p_to_uom_code => x_orig_mol_rec.uom_code
4953:
4954: l_progress := '20';
4955:
4956: -- Needs the primary_uom_code for quantities conversion
4957: l_prim_uom_code := inv_rcv_cache.get_primary_uom_code(l_orig_mol_rec.organization_id,
4958: l_orig_mol_rec.inventory_item_id);
4959:
4960: l_sec_uom_code := l_orig_mol_rec.secondary_uom;
4961:
4980: IF (l_orig_mol_rec.uom_code = l_prim_uom_code) THEN
4981: l_qty_to_splt(l_indx) := p_mo_splt_tb(l_indx).prim_qty;
4982: ELSE
4983:
4984: l_qty_to_splt(l_indx) := inv_rcv_cache.convert_qty
4985: (p_inventory_item_id => l_orig_mol_rec.inventory_item_id
4986: ,p_from_qty => p_mo_splt_tb(l_indx).prim_qty
4987: ,p_from_uom_code => l_prim_uom_code
4988: ,p_to_uom_code => l_orig_mol_rec.uom_code
5339: RAISE fnd_api.g_exc_error;
5340: ELSE -- p_txn_header_id is not null
5341: l_remaining_qty := l_orig_mol_rec.quantity_detailed - l_orig_mol_rec.quantity;
5342: IF (l_prim_uom_code <> l_orig_mol_rec.uom_code) THEN
5343: l_remaining_prim_qty := inv_rcv_cache.convert_qty
5344: (p_inventory_item_id => l_orig_mol_rec.inventory_item_id
5345: ,p_from_qty => l_remaining_qty
5346: ,p_from_uom_code => l_orig_mol_rec.uom_code
5347: ,p_to_uom_code => l_prim_uom_code
5470: l_rsv_update_rec := l_rsv_results_tbl(1);
5471: l_rsv_update_rec.demand_source_line_detail := l_new_wdd_id;
5472: l_rsv_update_rec.primary_reservation_quantity := l_new_mol_rec.primary_quantity;
5473: l_rsv_update_rec.reservation_quantity :=
5474: inv_rcv_cache.convert_qty
5475: (p_inventory_item_id => l_new_mol_rec.inventory_item_id
5476: ,p_from_qty => l_new_mol_rec.primary_quantity
5477: ,p_from_uom_code => l_rsv_results_tbl(1).primary_uom_code
5478: ,p_to_uom_code => l_rsv_results_tbl(1).reservation_uom_code
5988:
5989: l_mmtt_rec.primary_quantity := p_prim_qty_to_splt;
5990:
5991: IF (l_mmtt_rec.transaction_uom <> p_prim_uom_code) THEN
5992: l_mmtt_rec.transaction_quantity := inv_rcv_cache.convert_qty
5993: (p_inventory_item_id => l_mmtt_rec.inventory_item_id
5994: ,p_from_qty => p_prim_qty_to_splt
5995: ,p_from_uom_code => p_prim_uom_code
5996: ,p_to_uom_code => l_mmtt_rec.transaction_uom