eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_CTR_ESTIMATED_READINGS_PKG SQL Statements

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

Line: 7


PROCEDURE Insert_Row(
	 px_ESTIMATED_READING_ID        IN OUT NOCOPY NUMBER
 	 ,p_COUNTER_ID                  NUMBER
	 ,p_ESTIMATION_ID               NUMBER
	 ,p_VALUE_TIMESTAMP             DATE
	 ,p_ESTIMATED_METER_READING     NUMBER
	 ,p_NUM_OF_READINGS             NUMBER
	 ,p_PERIOD_START_DATE           DATE
	 ,p_PERIOD_END_DATE             DATE
         ,p_AVG_CALCULATION_START_DATE  DATE
         ,p_ESTIMATED_USAGE             NUMBER
	 ,p_ATTRIBUTE1                  VARCHAR2
	 ,p_ATTRIBUTE2                  VARCHAR2
	 ,p_ATTRIBUTE3                  VARCHAR2
	 ,p_ATTRIBUTE4                 	VARCHAR2
	 ,p_ATTRIBUTE5                  VARCHAR2
	 ,p_ATTRIBUTE6                  VARCHAR2
	 ,p_ATTRIBUTE7                  VARCHAR2
	 ,p_ATTRIBUTE8                  VARCHAR2
	 ,p_ATTRIBUTE9                  VARCHAR2
	 ,p_ATTRIBUTE10                 VARCHAR2
	 ,p_ATTRIBUTE11                 VARCHAR2
	 ,p_ATTRIBUTE12                 VARCHAR2
	 ,p_ATTRIBUTE13                 VARCHAR2
	 ,p_ATTRIBUTE14                 VARCHAR2
	 ,p_ATTRIBUTE15                 VARCHAR2
	 ,p_ATTRIBUTE_CATEGORY          VARCHAR2
         ,p_LAST_UPDATE_DATE            DATE
	 ,p_LAST_UPDATED_BY             NUMBER
         ,p_LAST_UPDATE_LOGIN           NUMBER
         ,p_CREATION_DATE               DATE
	 ,p_CREATED_BY                  NUMBER
	 ,p_OBJECT_VERSION_NUMBER       NUMBER
         ,p_MIGRATED_FLAG               VARCHAR2
   ) IS

   CURSOR C1 IS
   SELECT CSI_CTR_ESTIMATED_READINGS_S.nextval
   FROM   dual;

Line: 53


   INSERT INTO CSI_CTR_ESTIMATED_READINGS(
	 ESTIMATED_READING_ID
 	 ,COUNTER_ID
	 ,ESTIMATION_ID
	 ,VALUE_TIMESTAMP
	 ,ESTIMATED_METER_READING
	 ,NUM_OF_READINGS
	 ,PERIOD_START_DATE
	 ,PERIOD_END_DATE
         ,AVG_CALCULATION_START_DATE
         ,ESTIMATED_USAGE
	 ,ATTRIBUTE1
	 ,ATTRIBUTE2
	 ,ATTRIBUTE3
	 ,ATTRIBUTE4
	 ,ATTRIBUTE5
	 ,ATTRIBUTE6
	 ,ATTRIBUTE7
	 ,ATTRIBUTE8
	 ,ATTRIBUTE9
	 ,ATTRIBUTE10
	 ,ATTRIBUTE11
	 ,ATTRIBUTE12
	 ,ATTRIBUTE13
	 ,ATTRIBUTE14
	 ,ATTRIBUTE15
	 ,ATTRIBUTE_CATEGORY
         ,LAST_UPDATE_DATE
	 ,LAST_UPDATED_BY
         ,LAST_UPDATE_LOGIN
         ,CREATION_DATE
	 ,CREATED_BY
	 ,OBJECT_VERSION_NUMBER
         ,MIGRATED_FLAG
        )
   VALUES(
	 px_ESTIMATED_READING_ID
 	,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
	,decode(p_ESTIMATION_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATION_ID)
	,decode(p_VALUE_TIMESTAMP, FND_API.G_MISS_DATE, TO_DATE(NULL), p_VALUE_TIMESTAMP)
	,decode(p_ESTIMATED_METER_READING, FND_API.G_MISS_NUM, NULL, p_ESTIMATED_METER_READING)
	,decode(p_NUM_OF_READINGS, FND_API.G_MISS_NUM, NULL, p_NUM_OF_READINGS)
	,decode(p_PERIOD_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PERIOD_START_DATE)
	,decode(p_PERIOD_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PERIOD_END_DATE)
        ,decode(p_AVG_CALCULATION_START_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_AVG_CALCULATION_START_DATE)
        ,decode(p_ESTIMATED_USAGE, FND_API.G_MISS_NUM, NULL, p_ESTIMATED_USAGE)
	,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
	,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
	,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
	,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
	,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
	,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
	,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
	,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
	,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
	,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
	,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
	,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
	,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
	,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
	,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
	,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
	,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
	,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
	,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
	,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
	,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
	,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
        ,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG));

Line: 122


END insert_row;

Line: 124


PROCEDURE Update_Row(
	 p_ESTIMATED_READING_ID         NUMBER
 	 ,p_COUNTER_ID                  NUMBER
	 ,p_ESTIMATION_ID               NUMBER
	 ,p_VALUE_TIMESTAMP             DATE
	 ,p_ESTIMATED_METER_READING     NUMBER
	 ,p_NUM_OF_READINGS             NUMBER
	 ,p_PERIOD_START_DATE           DATE
	 ,p_PERIOD_END_DATE             DATE
         ,p_AVG_CALCULATION_START_DATE  DATE
         ,p_ESTIMATED_USAGE             NUMBER
	 ,p_ATTRIBUTE1                  VARCHAR2
	 ,p_ATTRIBUTE2                  VARCHAR2
	 ,p_ATTRIBUTE3                  VARCHAR2
	 ,p_ATTRIBUTE4                 	VARCHAR2
	 ,p_ATTRIBUTE5                  VARCHAR2
	 ,p_ATTRIBUTE6                  VARCHAR2
	 ,p_ATTRIBUTE7                  VARCHAR2
	 ,p_ATTRIBUTE8                  VARCHAR2
	 ,p_ATTRIBUTE9                  VARCHAR2
	 ,p_ATTRIBUTE10                 VARCHAR2
	 ,p_ATTRIBUTE11                 VARCHAR2
	 ,p_ATTRIBUTE12                 VARCHAR2
	 ,p_ATTRIBUTE13                 VARCHAR2
	 ,p_ATTRIBUTE14                 VARCHAR2
	 ,p_ATTRIBUTE15                 VARCHAR2
	 ,p_ATTRIBUTE_CATEGORY          VARCHAR2
         ,p_LAST_UPDATE_DATE            DATE
	 ,p_LAST_UPDATED_BY             NUMBER
         ,p_LAST_UPDATE_LOGIN           NUMBER
         ,p_CREATION_DATE               DATE
	 ,p_CREATED_BY                  NUMBER
	 ,p_OBJECT_VERSION_NUMBER       NUMBER
         ,p_MIGRATED_FLAG               VARCHAR2) IS
BEGIN
    UPDATE CSI_CTR_ESTIMATED_READINGS
    SET    COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL,  p_COUNTER_ID)
           ,ESTIMATION_ID = decode(p_ESTIMATION_ID, NULL, ESTIMATION_ID, FND_API.G_MISS_NUM, NULL, p_ESTIMATION_ID)
           ,VALUE_TIMESTAMP = decode(p_VALUE_TIMESTAMP, NULL, VALUE_TIMESTAMP, FND_API.G_MISS_DATE, NULL, p_VALUE_TIMESTAMP)
           ,ESTIMATED_METER_READING = decode(p_ESTIMATED_METER_READING, NULL, ESTIMATED_METER_READING, FND_API.G_MISS_NUM, NULL, p_ESTIMATED_METER_READING)
           ,PERIOD_START_DATE = decode(p_PERIOD_START_DATE, NULL, PERIOD_START_DATE, FND_API.G_MISS_DATE, NULL,  p_PERIOD_START_DATE)
  	   ,PERIOD_END_DATE = decode(p_PERIOD_END_DATE, NULL, PERIOD_END_DATE, FND_API.G_MISS_DATE, NULL, p_PERIOD_END_DATE)
           ,ESTIMATED_USAGE = decode(p_ESTIMATED_USAGE, NULL, ESTIMATED_USAGE, FND_API.G_MISS_NUM, NULL, p_ESTIMATED_USAGE)
	   ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
	   ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
	   ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
	   ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
	   ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
	   ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
	   ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
	   ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
	   ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
	   ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
	   ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
	   ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
	   ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
	   ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
	   ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
	   ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
  	   ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE)
	   ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
	   ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
   	   ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE)
	   ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
	   ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
	   ,MIGRATED_FLAG = decode(p_MIGRATED_FLAG, NULL, MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
    WHERE  ESTIMATED_READING_ID = p_ESTIMATED_READING_ID;

Line: 196


END update_row;

Line: 225


         ,p_LAST_UPDATE_DATE            DATE
	 ,p_LAST_UPDATED_BY             NUMBER
         ,p_LAST_UPDATE_LOGIN           NUMBER
         ,p_CREATION_DATE               DATE
	 ,p_CREATED_BY                  NUMBER
	 ,p_OBJECT_VERSION_NUMBER       NUMBER
         ,p_MIGRATED_FLAG               VARCHAR2) IS

   CURSOR C1 IS
   SELECT *
   FROM   CSI_CTR_ESTIMATED_READINGS
   WHERE  ESTIMATED_READING_ID = p_ESTIMATED_READING_ID
   FOR UPDATE of ESTIMATED_READING_ID NOWAIT;

Line: 317


       AND (    ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
            OR (    ( Recinfo.LAST_UPDATE_DATE IS NULL )
                AND (  p_LAST_UPDATE_DATE IS NULL )))
       AND (    ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
            OR (    ( Recinfo.LAST_UPDATED_BY IS NULL )
                AND (  p_LAST_UPDATED_BY IS NULL )))
       AND (    ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
            OR (    ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
                AND (  p_LAST_UPDATE_LOGIN IS NULL )))
       AND (    ( Recinfo.CREATION_DATE = p_CREATION_DATE)
            OR (    ( Recinfo.CREATION_DATE IS NULL )
                AND (  p_CREATION_DATE IS NULL )))
       AND (    ( Recinfo.CREATED_BY = p_CREATED_BY)
            OR (    ( Recinfo.CREATED_BY IS NULL )
                AND (  p_CREATED_BY IS NULL )))
       AND (    ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
            OR (    ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
                AND (  p_OBJECT_VERSION_NUMBER IS NULL )))
       AND (    ( Recinfo.MIGRATED_FLAG = p_MIGRATED_FLAG)
            OR (    ( Recinfo.MIGRATED_FLAG IS NULL )
                AND (  p_MIGRATED_FLAG IS NULL )))
       ) then
       return;

Line: 350


PROCEDURE delete_row(p_ESTIMATED_READING_ID NUMBER) IS
BEGIN
   DELETE FROM CSI_CTR_ESTIMATED_READINGS
   WHERE  ESTIMATED_READING_ID = p_ESTIMATED_READING_ID;

Line: 358


END delete_row;