APPS.GMD_SPREAD_FETCH_PKG dependencies on GMD_LABUOM_CALCULATE_PKG

Line 252: l_secondary_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_batch_rec.inventory_item_id,

248: l_qty := l_batch_rec.plan_qty;
249: END IF;
250: l_secondary_qty := null;
251: IF (l_qty > 0 AND l_batch_rec.tracking_quantity_ind ='PS') THEN
252: l_secondary_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_batch_rec.inventory_item_id,
253: pformula_id => NULL,
254: plot_number => NULL,
255: pcur_qty => l_qty,
256: pcur_uom => l_batch_rec.dtl_um,

Line 386: l_rsv_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_labrec.inventory_item_id,

382: l_rsv_qty := l_reservations_tbl(i).primary_reservation_quantity;
383: ELSIF (l_reservations_tbl(i).secondary_uom_code = l_batch_rec.dtl_um) THEN
384: l_rsv_qty := l_reservations_tbl(i).secondary_reservation_quantity;
385: ELSE
386: l_rsv_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_labrec.inventory_item_id,
387: pformula_id => NULL,
388: plot_number => l_reservations_tbl(i).lot_number,
389: pcur_qty => l_reservations_tbl(i).primary_reservation_quantity,
390: pcur_uom => l_reservations_tbl(i).primary_uom_code,

Line 432: l_primary_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_labrec.inventory_item_id,

428: END IF;
429:
430: l_primary_qty := null;
431: IF (l_labrec.quantity > 0) THEN
432: l_primary_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_labrec.inventory_item_id,
433: pformula_id => NULL,
434: plot_number => l_labrec.lot_number,
435: pcur_qty => l_labrec.quantity,
436: pcur_uom => l_labrec.primary_uom,

Line 557: l_secondary_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_formula_rec.inventory_item_id,

553: EXIT WHEN Cur_get_formula%NOTFOUND;
554: /* Getting the secondary qty*/
555: l_secondary_qty := null;
556: IF (l_formula_rec.qty > 0 AND l_formula_rec.tracking_quantity_ind = 'PS') THEN
557: l_secondary_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_formula_rec.inventory_item_id,
558: pformula_id => NULL,
559: plot_number => NULL,
560: pcur_qty => l_formula_rec.qty,
561: pcur_uom => l_formula_rec.detail_uom,

Line 1388: l_mass_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_rec.inventory_item_id,

1384: END IF;
1385: CLOSE Cur_line_qty;
1386:
1387: IF l_rec.detail_uom <> V_mass_uom THEN
1388: l_mass_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_rec.inventory_item_id,
1389: pformula_id => 0,
1390: plot_number => l_rec.lot_number,
1391: pcur_qty => l_rec.qty,
1392: pcur_uom => l_rec.detail_uom,

Line 1406: l_vol_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_rec.inventory_item_id,

1402: l_mass_qty := l_rec.qty;
1403: END IF;
1404:
1405: IF l_rec.detail_uom <> V_vol_uom THEN
1406: l_vol_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_rec.inventory_item_id,
1407: pformula_id => 0,
1408: plot_number => l_rec.lot_number,
1409: pcur_qty => l_rec.qty,
1410: pcur_uom => l_rec.detail_uom,

Line 1424: l_primary_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_rec.inventory_item_id,

1420: l_vol_qty := l_rec.qty;
1421: END IF;
1422:
1423: IF l_rec.detail_uom <> l_rec.primary_uom THEN
1424: l_primary_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_rec.inventory_item_id,
1425: pformula_id => 0,
1426: plot_number => l_rec.lot_number,
1427: pcur_qty => l_rec.qty,
1428: pcur_uom => l_rec.detail_uom,

Line 1720: l_secondary_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_formula_rec.inventory_item_id,

1716: EXIT WHEN Cur_get_lcf%NOTFOUND;
1717: /* Getting the secondary qty*/
1718: l_secondary_qty := null;
1719: IF (l_formula_rec.qty > 0 AND l_formula_rec.tracking_quantity_ind = 'PS') THEN
1720: l_secondary_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_formula_rec.inventory_item_id,
1721: pformula_id => NULL,
1722: plot_number => NULL,
1723: pcur_qty => l_formula_rec.qty,
1724: pcur_uom => l_formula_rec.detail_uom,