APPS.GMI_ITEM_LOT_CONV_PUB SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 156

	(l_ic_item_mst_rec.delete_mark = 1)
  THEN
    FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_ITEM_NO');

Line: 207

     (l_ic_lots_mst_rec.delete_mark = 1) OR
     (l_ic_lots_mst_rec.inactive_ind = 1)
  THEN
    FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_LOT_NO');

Line: 439

  l_ic_item_cnv_rec.last_update_date := SYSDATE;

Line: 440

  l_ic_item_cnv_rec.last_updated_by  := l_user_id;

Line: 442

  l_ic_item_cnv_rec.delete_mark      := 0;

Line: 447

  l_ic_item_cnv_rec.last_update_login :=TO_NUMBER(FND_PROFILE.Value(
					'LOGIN_ID'));

Line: 451

  IF NOT GMI_ITEM_LOT_CONV_PVT.insert_IC_ITEM_CNV(l_ic_item_cnv_rec)
  THEN
    RAISE FND_API.G_EXC_UNEXPECTED_ERROR;