APPS.INV_GRADE_PKG dependencies on MTL_LOT_NUMBERS

Line 60: FROM mtl_lot_numbers

56: l_orgid NUMBER; --Global Lot ER
57: --Global Lot ER Start
58: CURSOR get_all_orgid(p_item_id IN NUMBER, p_lot_number IN VARCHAR2) IS
59: SELECT organization_id
60: FROM mtl_lot_numbers
61: WHERE inventory_item_id = p_item_id
62: AND lot_number = p_lot_number;
63: --Global Lot ER End
64: BEGIN

Line 78: UPDATE mtl_lot_numbers

74: into l_grade_update_id
75: from dual;
76: -- END SCHANDRU INVERES
77:
78: UPDATE mtl_lot_numbers
79: SET grade_code = p_to_grade_code
80: WHERE lot_number = p_lot_number
81: AND organization_id = p_organization_id
82: AND inventory_item_id = p_inventory_item_id ;

Line 88: UPDATE mtl_lot_numbers

84: --COMMIT ;-- SCHANDRU INVERES
85:
86: --Global Lot ER Start
87: IF l_global_profile = 'Y' THEN
88: UPDATE mtl_lot_numbers
89: SET
90: grade_code = p_to_grade_code
91: WHERE inventory_item_id = p_inventory_item_id
92: AND lot_number = p_lot_number;