APPS.GMI_SUMM_INV_PVT SQL Statements

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

Line: 81

  l_summ_inv.last_updated_by  := p_tran_rec.user_id;

Line: 83

  l_summ_inv.last_update_date := SYSDATE;

Line: 90

    RETURN; /* No Update Needed For Firm Planned Orders */

Line: 132

  /*  Update Inventory Summary Table -- */

  IF NOT GMI_SUMM_INV_DB_PVT.UPDATE_IC_SUMM_INV( p_summ_inv => l_summ_inv)
   THEN
      IF NOT GMI_SUMM_INV_DB_PVT.INSERT_IC_SUMM_INV( p_summ_inv => l_summ_inv)
        THEN
        FND_MESSAGE.SET_NAME('GMI','GMI_IC_SUMM_INV_INSERT');

Line: 205

   l_summ_inv.last_updated_by  := p_tran_rec.user_id;

Line: 207

   l_summ_inv.last_update_date := SYSDATE;

Line: 263

  /*  Update Inventory Summary Table -- */

  IF NOT GMI_SUMM_INV_DB_PVT.UPDATE_IC_SUMM_INV( p_summ_inv => l_summ_inv)
  THEN

     IF NOT GMI_SUMM_INV_DB_PVT.INSERT_IC_SUMM_INV( p_summ_inv => l_summ_inv)
     THEN
       FND_MESSAGE.SET_NAME('GMI','GMI_IC_SUMM_INV_INSERT');