[Home] [Help]
555: ELSE
556: l_transaction_interface_id := p_transaction_interface_id;
557: END IF;
558:
559: l_serial_control_code := inv_rcv_cache.get_sn_ctrl_code(p_organization_id,p_inventory_item_id);
560:
561: IF l_serial_control_code <> 1 THEN
562: SELECT mtl_material_transactions_s.NEXTVAL
563: INTO l_serial_transaction_temp_id
3892: --Must use mmtt quantity and primary quantity for conversion
3893: IF (l_orig_mmtt_rec.transaction_uom = x_orig_mol_rec.uom_code) THEN
3894: l_temp := l_qty_to_splt;
3895: ELSE
3896: l_temp := inv_rcv_cache.convert_qty
3897: (p_inventory_item_id => x_orig_mol_rec.inventory_item_id
3898: ,p_from_qty => l_prim_qty_to_splt
3899: ,p_from_uom_code => p_prim_uom_code
3900: ,p_to_uom_code => l_orig_mmtt_rec.transaction_uom
4415: primary_quantity = l_orig_mmtt_rec.primary_quantity
4416: ,transaction_quantity = Decode(primary_quantity,
4417: transaction_quantity,
4418: l_orig_mmtt_rec.transaction_quantity,
4419: inv_rcv_cache.convert_qty
4420: (x_orig_mol_rec.inventory_item_id
4421: ,l_orig_mmtt_rec.primary_quantity
4422: ,p_prim_uom_code
4423: ,l_orig_mmtt_rec.transaction_uom
4461:
4462: /* Retrieve lot/serial control code call break to split */
4463: /* MTLT/MSLT */
4464: BEGIN
4465: l_lot_control_code := inv_rcv_cache.get_lot_control_code(x_orig_mol_rec.organization_id,
4466: x_orig_mol_rec.inventory_item_id);
4467: l_serial_control_code := 1;
4468: EXCEPTION
4469: WHEN OTHERS THEN
4679: END IF;
4680: l_progress := '240';
4681:
4682: IF (l_orig_mmtt_rec.transaction_uom <> x_orig_mol_rec.uom_code) THEN
4683: l_temp := inv_rcv_cache.convert_qty
4684: (p_inventory_item_id => x_orig_mol_rec.inventory_item_id
4685: ,p_from_qty => l_orig_mmtt_rec.transaction_quantity
4686: ,p_from_uom_code => l_orig_mmtt_rec.transaction_uom
4687: ,p_to_uom_code => x_orig_mol_rec.uom_code
4884:
4885: l_progress := '20';
4886:
4887: -- Needs the primary_uom_code for quantities conversion
4888: l_prim_uom_code := inv_rcv_cache.get_primary_uom_code(l_orig_mol_rec.organization_id,
4889: l_orig_mol_rec.inventory_item_id);
4890:
4891: l_sec_uom_code := l_orig_mol_rec.secondary_uom;
4892:
4911: IF (l_orig_mol_rec.uom_code = l_prim_uom_code) THEN
4912: l_qty_to_splt(l_indx) := p_mo_splt_tb(l_indx).prim_qty;
4913: ELSE
4914:
4915: l_qty_to_splt(l_indx) := inv_rcv_cache.convert_qty
4916: (p_inventory_item_id => l_orig_mol_rec.inventory_item_id
4917: ,p_from_qty => p_mo_splt_tb(l_indx).prim_qty
4918: ,p_from_uom_code => l_prim_uom_code
4919: ,p_to_uom_code => l_orig_mol_rec.uom_code
5270: RAISE fnd_api.g_exc_error;
5271: ELSE -- p_txn_header_id is not null
5272: l_remaining_qty := l_orig_mol_rec.quantity_detailed - l_orig_mol_rec.quantity;
5273: IF (l_prim_uom_code <> l_orig_mol_rec.uom_code) THEN
5274: l_remaining_prim_qty := inv_rcv_cache.convert_qty
5275: (p_inventory_item_id => l_orig_mol_rec.inventory_item_id
5276: ,p_from_qty => l_remaining_qty
5277: ,p_from_uom_code => l_orig_mol_rec.uom_code
5278: ,p_to_uom_code => l_prim_uom_code
5401: l_rsv_update_rec := l_rsv_results_tbl(1);
5402: l_rsv_update_rec.demand_source_line_detail := l_new_wdd_id;
5403: l_rsv_update_rec.primary_reservation_quantity := l_new_mol_rec.primary_quantity;
5404: l_rsv_update_rec.reservation_quantity :=
5405: inv_rcv_cache.convert_qty
5406: (p_inventory_item_id => l_new_mol_rec.inventory_item_id
5407: ,p_from_qty => l_new_mol_rec.primary_quantity
5408: ,p_from_uom_code => l_rsv_results_tbl(1).primary_uom_code
5409: ,p_to_uom_code => l_rsv_results_tbl(1).reservation_uom_code
5919:
5920: l_mmtt_rec.primary_quantity := p_prim_qty_to_splt;
5921:
5922: IF (l_mmtt_rec.transaction_uom <> p_prim_uom_code) THEN
5923: l_mmtt_rec.transaction_quantity := inv_rcv_cache.convert_qty
5924: (p_inventory_item_id => l_mmtt_rec.inventory_item_id
5925: ,p_from_qty => p_prim_qty_to_splt
5926: ,p_from_uom_code => p_prim_uom_code
5927: ,p_to_uom_code => l_mmtt_rec.transaction_uom