APPS.GMI_ITEM_PUB SQL Statements

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

Line: 179

  SELECT gem5_item_id_s.nextval INTO l_item_id FROM dual;

Line: 262

l_ic_item_mst_rec.last_update_date   := SYSDATE;

Line: 264

l_ic_item_mst_rec.last_updated_by    := l_user_id;

Line: 265

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

Line: 268

l_ic_item_mst_rec.delete_mark        := 0;

Line: 373

  IF NOT GMI_ITEM_PVT.insert_ic_item_mst(l_ic_item_mst_rec)
  THEN
    RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line: 384

  l_ic_item_cpg_rec.last_update_date   := SYSDATE;

Line: 386

  l_ic_item_cpg_rec.last_updated_by    := l_user_id;

Line: 387

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

Line: 1052

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

Line: 1127

	  (l_ic_item_mst_rec.delete_mark = 1)
    THEN

      FND_MESSAGE.SET_NAME('GMI','IC_API_INVALID_WHSE_ITEM_NO');