APPS.CSI_GIS_INSTANCE_GEO_LOC_PVT SQL Statements

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

Line: 23

PROCEDURE INSERT_ROW
(
    p_instance_id             IN          NUMBER
   ,p_inst_latitude           IN          NUMBER
   ,p_inst_longitude          IN          NUMBER
   , x_return_status           OUT NOCOPY  VARCHAR2
)  IS

BEGIN

	x_return_status         := FND_API.G_RET_STS_SUCCESS;

Line: 35

	    INSERT INTO CSI_II_GEOLOCATIONS
	     (
	      INSTANCE_ID,
	      INST_LATITUDE,
	      INST_LONGITUDE,
	      VALID_FLAG,
	      CREATION_DATE,
	      CREATED_BY,
	      LAST_UPDATED_BY,
	      LAST_UPDATE_LOGIN,
	      LAST_UPDATE_DATE
	     )
	     VALUES
	     (
	      p_instance_id,
          p_inst_latitude,
	      p_inst_longitude,
	      'Y',
	      SYSDATE,
          FND_GLOBAL.user_id,
	      FND_GLOBAL.user_id,
	      FND_GLOBAL.login_id,
          SYSDATE
         );

Line: 65

  END INSERT_ROW;

Line: 68

 PROCEDURE UPDATE_ROW
  ( p_instance_id             IN          NUMBER
   ,p_inst_latitude           IN          NUMBER
   ,p_inst_longitude          IN          NUMBER
   ,p_valid_flag              IN          VARCHAR2
   ,x_return_status           OUT NOCOPY  VARCHAR2
)   IS

  l_instance_id NUMBER;

Line: 84

        UPDATE CSI_II_GEOLOCATIONS
	    SET
	      VALID_FLAG         =  p_valid_flag,
	      LAST_UPDATED_BY    =  FND_GLOBAL.user_id,
	      LAST_UPDATE_LOGIN  =  FND_GLOBAL.login_id,
	      LAST_UPDATE_DATE   =  SYSDATE

	    WHERE
	      INSTANCE_ID = p_instance_id;

Line: 94

	          UPDATE CSI_II_GEOLOCATIONS
	    SET
	      INST_LATITUDE           =  p_inst_latitude,
	      INST_LONGITUDE          =  p_inst_longitude,
	      VALID_FLAG         =  NVL(p_valid_flag,'Y'),
	      LAST_UPDATED_BY    =  FND_GLOBAL.user_id,
	      LAST_UPDATE_LOGIN  =  FND_GLOBAL.login_id,
	      LAST_UPDATE_DATE   =  SYSDATE

	    WHERE
	      INSTANCE_ID = p_instance_id;

Line: 116

  END UPDATE_ROW;