APPS.GMI_LOTUPDATE_PUB dependencies on IC_LOTS_MST

Line 42: , p_lot_rec IN ic_lots_mst%ROWTYPE

38: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
39: , x_return_status OUT NOCOPY VARCHAR2
40: , x_msg_count OUT NOCOPY NUMBER
41: , x_msg_data OUT NOCOPY VARCHAR2
42: , p_lot_rec IN ic_lots_mst%ROWTYPE
43: ) IS
44: l_api_name CONSTANT VARCHAR2(30) := 'update_lot_dff' ;
45: l_api_version CONSTANT NUMBER := 1.0 ;
46: l_count NUMBER;

Line 80: UPDATE ic_lots_mst

76: FND_MSG_PUB.Add;
77: RAISE FND_API.G_EXC_ERROR;
78: END IF;
79:
80: UPDATE ic_lots_mst
81: SET
82: attribute1 = p_lot_rec.attribute1,
83: attribute2 = p_lot_rec.attribute2,
84: attribute3 = p_lot_rec.attribute3,

Line 171: , p_lot_rec IN ic_lots_mst%ROWTYPE

167: , p_validation_level IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL
168: , x_return_status OUT NOCOPY VARCHAR2
169: , x_msg_count OUT NOCOPY NUMBER
170: , x_msg_data OUT NOCOPY VARCHAR2
171: , p_lot_rec IN ic_lots_mst%ROWTYPE
172: ) IS
173: l_api_name CONSTANT VARCHAR2(30) := 'update_lot' ;
174: l_api_version CONSTANT NUMBER := 1.0 ;
175: l_count NUMBER;

Line 178: FROM ic_lots_mst a

174: l_api_version CONSTANT NUMBER := 1.0 ;
175: l_count NUMBER;
176:
177: CURSOR cur_old_lot IS SELECT *
178: FROM ic_lots_mst a
179: WHERE a.item_id = p_lot_rec.item_id
180: AND a.lot_id = p_lot_rec.lot_id;
181:
182:

Line 231: UPDATE ic_lots_mst

227: RAISE FND_API.G_EXC_ERROR;
228: END IF;
229: END IF;
230:
231: UPDATE ic_lots_mst
232: SET
233:
234: expire_date = p_lot_rec.expire_date,
235: attribute1 = p_lot_rec.attribute1,