DBA Data[Home] [Help]

APPS.GML_INTORD_LOT_STS dependencies on IC_ITEM_MST

Line 226: l_item_rec IC_ITEM_MST%ROWTYPE;

222: , x_return_status OUT NOCOPY VARCHAR2
223: , x_msg_data OUT NOCOPY VARCHAR2
224: ) IS
225:
226: l_item_rec IC_ITEM_MST%ROWTYPE;
227: l_trans_rec GMIGAPI.qty_rec_typ;
228: l_ic_jrnl_mst_row ic_jrnl_mst%ROWTYPE;
229: l_ic_adjs_jnl_row1 ic_adjs_jnl%ROWTYPE;
230: l_ic_adjs_jnl_row2 ic_adjs_jnl%ROWTYPE;

Line 267: FROM ic_item_mst

263: x_return_status := FND_API.G_RET_STS_SUCCESS;
264:
265: SELECT *
266: INTO l_item_rec
267: FROM ic_item_mst
268: WHERE item_id = p_item_id;
269:
270: IF l_item_rec.status_ctl = 0 THEN
271: x_msg_data := 'Item is not status controlled';