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 558: l_secondary_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_formula_rec.inventory_item_id,

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

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

1423: CLOSE Cur_line_item_number;
1424:
1425:
1426: IF l_rec.detail_uom <> V_mass_uom THEN
1427: l_mass_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_rec.inventory_item_id,
1428: pformula_id => 0,
1429: plot_number => l_rec.lot_number,
1430: pcur_qty => l_rec.qty,
1431: pcur_uom => l_rec.detail_uom,

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

1443: l_mass_qty := l_rec.qty;
1444: END IF;
1445:
1446: IF l_rec.detail_uom <> V_vol_uom THEN
1447: l_vol_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_rec.inventory_item_id,
1448: pformula_id => 0,
1449: plot_number => l_rec.lot_number,
1450: pcur_qty => l_rec.qty,
1451: pcur_uom => l_rec.detail_uom,

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

1463: l_vol_qty := l_rec.qty;
1464: END IF;
1465:
1466: IF l_rec.detail_uom <> l_rec.primary_uom THEN
1467: l_primary_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_rec.inventory_item_id,
1468: pformula_id => 0,
1469: plot_number => l_rec.lot_number,
1470: pcur_qty => l_rec.qty,
1471: pcur_uom => l_rec.detail_uom,

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

1760: EXIT WHEN Cur_get_lcf%NOTFOUND;
1761: /* Getting the secondary qty*/
1762: l_secondary_qty := null;
1763: IF (l_formula_rec.qty > 0 AND l_formula_rec.tracking_quantity_ind = 'PS') THEN
1764: l_secondary_qty := gmd_labuom_calculate_pkg.uom_conversion (pitem_id => l_formula_rec.inventory_item_id,
1765: pformula_id => NULL,
1766: plot_number => NULL,
1767: pcur_qty => l_formula_rec.qty,
1768: pcur_uom => l_formula_rec.detail_uom,

Line 1904: l_qty := gmd_labuom_calculate_pkg.uom_conversion

1900: X_value => l_value);
1901: OPEN Cur_get_item(l_rec.inventory_item_id);
1902: FETCH Cur_get_item INTO l_uom;
1903: CLOSE Cur_get_item;
1904: l_qty := gmd_labuom_calculate_pkg.uom_conversion
1905: (pitem_id => l_rec.inventory_item_id,
1906: pformula_id => V_entity_id,
1907: plot_number => NULL,
1908: pcur_qty => 1,