APPS.JAI_GENERAL_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 263: FROM mtl_units_of_measure

259:
260: FUNCTION get_uom_code(p_uom IN VARCHAR2) RETURN VARCHAR2 IS
261: CURSOR c_uom_code IS
262: SELECT uom_code
263: FROM mtl_units_of_measure
264: WHERE unit_of_measure = p_uom;
265:
266: lv_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
267: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.get_uom_code';

Line 266: lv_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;

262: SELECT uom_code
263: FROM mtl_units_of_measure
264: WHERE unit_of_measure = p_uom;
265:
266: lv_uom_code MTL_UNITS_OF_MEASURE.uom_code%TYPE;
267: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.get_uom_code';
268:
269: BEGIN
270: OPEN c_uom_code;

Line 334: p_transaction_uom_code IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,

330: app_exception.raise_exception;
331: END get_matched_boe_no;
332:
333: FUNCTION trxn_to_primary_conv_rate(
334: p_transaction_uom_code IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
335: p_primary_uom_code IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
336: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE
337: ) RETURN NUMBER IS
338: vTransToPrimaryUOMConv NUMBER;

Line 335: p_primary_uom_code IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,

331: END get_matched_boe_no;
332:
333: FUNCTION trxn_to_primary_conv_rate(
334: p_transaction_uom_code IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
335: p_primary_uom_code IN MTL_UNITS_OF_MEASURE.uom_code%TYPE,
336: p_inventory_item_id IN MTL_SYSTEM_ITEMS.inventory_item_id%TYPE
337: ) RETURN NUMBER IS
338: vTransToPrimaryUOMConv NUMBER;
339: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_general_pkg.trxn_to_primary_conv_rate';