[Home] [Help]
176: IF (p_total_output IS NOT NULL) THEN
177: /* Convert total output qty to standard UOM of FM_YIELD_TYPE */
178: IF (p_uom <> l_yield_um) THEN
179: -- l_total_output := gmicuom.uom_conversion(0, 0, p_total_output, p_uom, l_yield_um, 0);
180: l_total_output := INV_CONVERT.inv_um_convert(item_id => 0
181: ,precision => 5
182: ,from_quantity => p_total_output
183: ,from_unit => p_uom
184: ,to_unit => l_yield_um
204:
205: /* Convert total input qty to standard UOM of FM_YIELD_TYPE */
206: IF (p_uom <> l_yield_um) THEN
207: -- l_total_input := gmicuom.uom_conversion(0, 0, p_total_input, p_uom, l_yield_um, 0);
208: l_total_input := INV_CONVERT.inv_um_convert(item_id => 0
209: ,precision => 5
210: ,from_quantity => p_total_input
211: ,from_unit => p_uom
212: ,to_unit => l_yield_um
268: IF (l_scale_type = 1) THEN
269: l_item_qty := l_item_qty * l_output_ratio;
270: IF (l_line_um <> get_rec.detail_uom) THEN
271:
272: l_item_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
273: ,precision => 5
274: ,from_quantity => l_item_qty
275: ,from_unit => l_line_um
276: ,to_unit => get_rec.detail_uom
328: OPEN cur_item_uom(p_item_id);
329: FETCH cur_item_uom INTO l_item_uom;
330: CLOSE cur_item_uom;
331: IF (p_uom <> l_item_uom) THEN
332: l_quantity := INV_CONVERT.inv_um_convert(item_id => p_item_id
333: ,precision => 5
334: ,from_quantity => p_product_qty
335: ,from_unit => p_uom
336: ,to_unit => l_item_uom
449: x_return_status := FND_API.G_RET_STS_SUCCESS;
450: FOR get_rec IN Cur_get_prods LOOP
451: IF (get_rec.scale_type = 0) THEN
452: IF (get_rec.detail_uom <> p_yield_um) THEN
453: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
454: ,precision => 5
455: ,from_quantity => get_rec.qty
456: ,from_unit => get_rec.detail_uom
457: ,to_unit => p_yield_um
514: x_return_status := FND_API.G_RET_STS_SUCCESS;
515: --Get sum of products in yield UM.
516: FOR get_rec IN Cur_get_details(1) LOOP
517: IF (get_rec.detail_uom <> p_yield_um) THEN
518: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
519: ,precision => 5
520: ,from_quantity => get_rec.qty
521: ,from_unit => get_rec.detail_uom
522: ,to_unit => p_yield_um
535: --Get sum of ingredients in yield UM contributing to yield.
536: FOR get_rec IN Cur_get_details(-1) LOOP
537: IF (get_rec.contribute_yield_ind = 'Y') THEN
538: IF (get_rec.detail_uom <> p_yield_um) THEN
539: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
540: ,precision => 5
541: ,from_quantity => get_rec.qty
542: ,from_unit => get_rec.detail_uom
543: ,to_unit => p_yield_um
607: x_return_status := FND_API.G_RET_STS_SUCCESS;
608: FOR get_rec IN Cur_get_ingreds LOOP
609: IF (get_rec.scale_type = 0) THEN
610: IF (get_rec.detail_uom <> p_yield_um) THEN
611: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
612: ,precision => 5
613: ,from_quantity => get_rec.qty
614: ,from_unit => get_rec.detail_uom
615: ,to_unit => p_yield_um
684: FOR get_rec IN Cur_get_ingreds LOOP
685: IF (get_rec.contribute_yield_ind = 'Y') THEN
686: /* Convert all ingredient values to yield UM and determine contributing qty */
687: IF (get_rec.detail_uom <> p_yield_um) THEN
688: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
689: ,precision => 5
690: ,from_quantity => get_rec.qty
691: ,from_unit => get_rec.detail_uom
692: ,to_unit => p_yield_um
767: BEGIN
768: FOR get_rec IN Cur_get_prods LOOP
769: IF (get_rec.scale_type = 0) THEN
770: IF (get_rec.detail_uom <> p_yield_um) THEN
771: l_conv_qty := INV_CONVERT.inv_um_convert(item_id => get_rec.inventory_item_id
772: ,precision => 5
773: ,from_quantity => get_rec.qty
774: ,from_unit => get_rec.detail_uom
775: ,to_unit => p_yield_um