APPS.GMD_LABUOM_CALCULATE_PKG dependencies on MTL_UNITS_OF_MEASURE

Line 67: l_item_invum_code mtl_units_of_measure.uom_code%TYPE;

63: plab_id NUMBER,
64: pcnv_factor NUMBER DEFAULT 0) RETURN NUMBER IS
65:
66: -- Variable Declarations
67: l_item_invum_code mtl_units_of_measure.uom_code%TYPE;
68: l_cur_uom_code mtl_units_of_measure.uom_code%TYPE;
69: l_new_uom_code mtl_units_of_measure.uom_code%TYPE;
70: l_cur_um_type mtl_uom_classes.uom_class%TYPE;
71: l_new_um_type mtl_uom_classes.uom_class%TYPE;

Line 68: l_cur_uom_code mtl_units_of_measure.uom_code%TYPE;

64: pcnv_factor NUMBER DEFAULT 0) RETURN NUMBER IS
65:
66: -- Variable Declarations
67: l_item_invum_code mtl_units_of_measure.uom_code%TYPE;
68: l_cur_uom_code mtl_units_of_measure.uom_code%TYPE;
69: l_new_uom_code mtl_units_of_measure.uom_code%TYPE;
70: l_cur_um_type mtl_uom_classes.uom_class%TYPE;
71: l_new_um_type mtl_uom_classes.uom_class%TYPE;
72: l_inv_um_type mtl_uom_classes.uom_class%TYPE;

Line 69: l_new_uom_code mtl_units_of_measure.uom_code%TYPE;

65:
66: -- Variable Declarations
67: l_item_invum_code mtl_units_of_measure.uom_code%TYPE;
68: l_cur_uom_code mtl_units_of_measure.uom_code%TYPE;
69: l_new_uom_code mtl_units_of_measure.uom_code%TYPE;
70: l_cur_um_type mtl_uom_classes.uom_class%TYPE;
71: l_new_um_type mtl_uom_classes.uom_class%TYPE;
72: l_inv_um_type mtl_uom_classes.uom_class%TYPE;
73: l_cur_uom_factor mtl_uom_conversions.conversion_rate%TYPE;

Line 89: CURSOR get_uom_type(Vum_code mtl_units_of_measure.uom_code%TYPE,

85: l_factor_len NUMBER;
86: l_factorrev_len NUMBER;
87: /* Cursor Definitions
88: ==================*/
89: CURSOR get_uom_type(Vum_code mtl_units_of_measure.uom_code%TYPE,
90: Vinventory_item_id mtl_system_items.inventory_item_id%type) IS
91: SELECT 1, uomc.uom_class um_type, uomc.conversion_rate std_factor
92: FROM mtl_uom_conversions uomc, mtl_units_of_measure uom
93: WHERE uom.uom_code = Vum_code

Line 92: FROM mtl_uom_conversions uomc, mtl_units_of_measure uom

88: ==================*/
89: CURSOR get_uom_type(Vum_code mtl_units_of_measure.uom_code%TYPE,
90: Vinventory_item_id mtl_system_items.inventory_item_id%type) IS
91: SELECT 1, uomc.uom_class um_type, uomc.conversion_rate std_factor
92: FROM mtl_uom_conversions uomc, mtl_units_of_measure uom
93: WHERE uom.uom_code = Vum_code
94: AND uomc.uom_code = uom.uom_code
95: AND uomc.inventory_item_id = Vinventory_item_id
96: UNION

Line 98: FROM mtl_uom_conversions a, mtl_units_of_measure b

94: AND uomc.uom_code = uom.uom_code
95: AND uomc.inventory_item_id = Vinventory_item_id
96: UNION
97: SELECT 2, b.uom_class, a.conversion_rate
98: FROM mtl_uom_conversions a, mtl_units_of_measure b
99: WHERE a.uom_code = b.uom_code
100: AND b.uom_code = Vum_code
101: ORDER by 1;
102:

Line 127: FROM mtl_units_of_measure

123: FROM mtl_system_items_kfv
124: WHERE inventory_item_id = Vitem_id;
125: CURSOR Cur_get_um_type (V_uom_code VARCHAR2) IS
126: SELECT uom_class
127: FROM mtl_units_of_measure
128: WHERE uom_code = V_uom_code;
129:
130: l_curr_uom_type VARCHAR2(30);
131: l_new_uom_type VARCHAR2(30);