[Home] [Help]
398:
399: IF p_transaction_uom = l_transaction_uom1 THEN
400: l_conversion_factor := l_conversion_factor1;
401: ELSE
402: l_conversion_factor := inv_convert.inv_um_convert(item_id => l_inventory_item_id,
403: precision => l_g_decimal_precision,
404: from_quantity => 1,
405: from_unit => l_primary_uom,
406: to_unit => p_transaction_uom,
1825: * to suggested UOM
1826: * p_primary_uom is always static.*/
1827: IF p_primary_uom <> p_confirmed_uom
1828: THEN
1829: l_confirmed_prim_qty := inv_convert.inv_um_convert
1830: (item_id => p_inventory_item_id
1831: ,precision => l_g_decimal_precision
1832: ,from_quantity => p_confirmed_trx_qty
1833: ,from_unit => p_confirmed_uom
1840:
1841:
1842: IF p_suggested_uom <> p_confirmed_uom
1843: THEN
1844: l_confirmed_sugg_qty := inv_convert.inv_um_convert
1845: (item_id => p_inventory_item_id
1846: ,precision => l_g_decimal_precision
1847: ,from_quantity => p_confirmed_trx_qty
1848: ,from_unit => p_confirmed_uom
4542: mydebug('Inserted temp_id into mtl_allocations_gtmp: ' || rec_mmtt1.group_temp_id);
4543:
4544: IF p_suggested_uom <> rec_mmtt1.item_primary_uom_code
4545: THEN
4546: l_suggested_mmtt_qty := inv_convert.inv_um_convert
4547: (item_id => rec_mmtt1.inventory_item_id
4548: ,precision => l_g_decimal_precision
4549: ,from_quantity => rec_mmtt1.mmtt_primary_quantity
4550: ,from_unit => rec_mmtt1.item_primary_uom_code
4637: FROM DUAL;
4638: mydebug('l_serial_transaction_temp_id .. ' || l_serial_transaction_temp_id);
4639: IF p_suggested_uom <> rec_mmtt1.item_primary_uom_code
4640: THEN
4641: l_suggested_mtlt_qty := inv_convert.inv_um_convert
4642: (item_id => rec_mmtt1.inventory_item_id
4643: ,precision => l_g_decimal_precision
4644: ,from_quantity => rec_mtlt1.group_lot_primary_quantity
4645: ,from_unit => rec_mmtt1.item_primary_uom_code
5389:
5390: IF (rec_mmtt_to_del.item_primary_uom_code <> rec_cancelled_mols.uom_code)
5391: THEN
5392: l_deleted_mmtt_qty := l_deleted_mmtt_qty +
5393: INV_Convert.inv_um_convert
5394: ( item_id => rec_mmtt_to_del.inventory_item_id
5395: ,precision => 5
5396: ,from_quantity => rec_mmtt_to_del.primary_quantity
5397: ,from_unit => rec_mmtt_to_del.item_primary_uom_code
6033: mydebug ('l_lot_trx_qty:' || l_lot_trx_qty);
6034: IF p_primary_uom <> p_confirmed_uom
6035: THEN
6036: l_progress := '120';
6037: l_lot_prim_qty := inv_convert.inv_um_convert
6038: (item_id => p_inventory_item_id
6039: ,precision => l_g_decimal_precision
6040: ,from_quantity => l_lot_trx_qty
6041: ,from_unit => p_confirmed_uom
6052:
6053: IF p_suggested_uom <> p_confirmed_uom
6054: THEN
6055: l_progress := '120';
6056: l_lot_sugg_qty := inv_convert.inv_um_convert
6057: (item_id => p_inventory_item_id
6058: ,precision => l_g_decimal_precision
6059: ,from_quantity => l_lot_trx_qty
6060: ,from_unit => p_confirmed_uom
6756: --Convert the MMTT primary quantity into MOL UOM
6757: IF p_primary_uom = l_mol_uom THEN
6758: l_mmtt_qty_in_mol_uom := l_sum_mmtt_qty;
6759: ELSE
6760: l_mmtt_qty_in_mol_uom := inv_convert.inv_um_convert
6761: (item_id => p_item_id
6762: ,precision => l_g_decimal_precision
6763: ,from_quantity => l_sum_mmtt_qty
6764: ,from_unit => p_primary_uom
7084: mydebug('l_secondary_uom :'|| l_secondary_uom); -- Bug #4141928
7085: END IF;
7086:
7087: IF (p_trx_uom <> l_primary_uom) THEN
7088: l_pr_qty := inv_convert.inv_um_convert(
7089: item_id => p_item_id
7090: ,precision => null
7091: ,from_quantity => p_trx_qty
7092: ,from_unit => p_trx_uom
7728: t_lpn_lot_qty_table(l_table_index).sec_qty := l_satt; -- Bug #4141928
7729: IF (l_primary_uom = p_trx_uom) THEN
7730: t_lpn_lot_qty_table(l_table_index).trx_qty := l_att;
7731: ELSE
7732: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(
7733: item_id => p_item_id
7734: ,precision => null
7735: ,from_quantity => l_att
7736: ,from_unit => l_primary_uom
8518: t_lpn_lot_qty_table(l_table_index).sec_qty := l_satt; -- Bug #4141928
8519: IF (l_primary_uom = p_trx_uom) THEN
8520: t_lpn_lot_qty_table(l_table_index).trx_qty := l_att;
8521: ELSE
8522: t_lpn_lot_qty_table(l_table_index).trx_qty := inv_convert.inv_um_convert(
8523: item_id => p_item_id
8524: ,precision => null
8525: ,from_quantity => l_att
8526: ,from_unit => l_primary_uom
9410:
9411: -- Now l_lpn_pr_qty is in primary uom, need to convert l_lpn_trx_qty in transaction uom (p_trx_uom)
9412: -- if they are different
9413: IF (p_trx_uom <> l_primary_uom) THEN
9414: l_lpn_trx_qty := inv_convert.inv_um_convert(
9415: item_id => p_item_id
9416: ,precision => null
9417: ,from_quantity => l_lpn_pr_qty
9418: ,from_unit => l_primary_uom
9715: WHERE lpn_id = p_fromlpn_id
9716: AND organization_id = p_org_id;
9717:
9718: IF (p_trx_uom <> l_primary_uom) THEN
9719: x_lpn_qoh := inv_convert.inv_um_convert(
9720: item_id => p_item_id
9721: ,precision => null
9722: ,from_quantity => l_qoh
9723: ,from_unit => l_primary_uom
10092: END IF;
10093: l_att_trx_qty := l_att;
10094: l_trx_qoh := l_qoh;
10095: else
10096: l_att_trx_qty := inv_convert.inv_um_convert(
10097: item_id => p_item_id
10098: ,precision => null
10099: ,from_quantity => l_att
10100: ,from_unit => p_pri_uom
10100: ,from_unit => p_pri_uom
10101: ,to_unit => p_trx_uom
10102: ,from_name => null
10103: ,to_name => null);
10104: l_trx_qoh := inv_convert.inv_um_convert(
10105: item_id => p_item_id
10106: ,precision => null
10107: ,from_quantity => l_qoh
10108: ,from_unit => p_pri_uom