The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
px_COUNTER_VALUE_ID IN OUT NOCOPY NUMBER
,p_COUNTER_ID NUMBER
,p_VALUE_TIMESTAMP DATE
,p_COUNTER_READING NUMBER
,p_RESET_MODE VARCHAR2
,p_RESET_REASON VARCHAR2
,p_ADJUSTMENT_TYPE VARCHAR2
,p_ADJUSTMENT_READING NUMBER
,p_OBJECT_VERSION_NUMBER NUMBER
,p_LAST_UPDATE_DATE DATE
,p_LAST_UPDATED_BY NUMBER
,p_CREATION_DATE DATE
,p_CREATED_BY NUMBER
,p_LAST_UPDATE_LOGIN 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_ATTRIBUTE16 VARCHAR2
,p_ATTRIBUTE17 VARCHAR2
,p_ATTRIBUTE18 VARCHAR2
,p_ATTRIBUTE19 VARCHAR2
,p_ATTRIBUTE20 VARCHAR2
,p_ATTRIBUTE21 VARCHAR2
,p_ATTRIBUTE22 VARCHAR2
,p_ATTRIBUTE23 VARCHAR2
,p_ATTRIBUTE24 VARCHAR2
,p_ATTRIBUTE25 VARCHAR2
,p_ATTRIBUTE26 VARCHAR2
,p_ATTRIBUTE27 VARCHAR2
,p_ATTRIBUTE28 VARCHAR2
,p_ATTRIBUTE29 VARCHAR2
,p_ATTRIBUTE30 VARCHAR2
,p_ATTRIBUTE_CATEGORY VARCHAR2
,p_MIGRATED_FLAG VARCHAR2
,p_COMMENTS VARCHAR2
,p_LIFE_TO_DATE_READING NUMBER
,p_TRANSACTION_ID NUMBER
,p_AUTOMATIC_ROLLOVER_FLAG VARCHAR2
,p_INCLUDE_TARGET_RESETS VARCHAR2
,p_SOURCE_COUNTER_VALUE_ID NUMBER
,p_NET_READING NUMBER
,p_DISABLED_FLAG VARCHAR2
,p_SOURCE_CODE VARCHAR2
,p_SOURCE_LINE_ID NUMBER
,p_INITIAL_READING_FLAG VARCHAR2
) IS
CURSOR C1 IS
SELECT CSI_COUNTER_READINGS_S.nextval
FROM dual;
INSERT INTO CSI_COUNTER_READINGS(
COUNTER_VALUE_ID
,COUNTER_ID
,VALUE_TIMESTAMP
,COUNTER_READING
,RESET_MODE
,RESET_REASON
,ADJUSTMENT_TYPE
,ADJUSTMENT_READING
,OBJECT_VERSION_NUMBER
,LAST_UPDATE_DATE
,LAST_UPDATED_BY
,CREATION_DATE
,CREATED_BY
,LAST_UPDATE_LOGIN
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ATTRIBUTE16
,ATTRIBUTE17
,ATTRIBUTE18
,ATTRIBUTE19
,ATTRIBUTE20
,ATTRIBUTE21
,ATTRIBUTE22
,ATTRIBUTE23
,ATTRIBUTE24
,ATTRIBUTE25
,ATTRIBUTE26
,ATTRIBUTE27
,ATTRIBUTE28
,ATTRIBUTE29
,ATTRIBUTE30
,ATTRIBUTE_CATEGORY
,MIGRATED_FLAG
,COMMENTS
,LIFE_TO_DATE_READING
,TRANSACTION_ID
,AUTOMATIC_ROLLOVER_FLAG
,INCLUDE_TARGET_RESETS
,SOURCE_COUNTER_VALUE_ID
,NET_READING
,DISABLED_FLAG
,SOURCE_CODE
,SOURCE_LINE_ID
,INITIAL_READING_FLAG
)
VALUES(
px_COUNTER_VALUE_ID
,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
,decode(p_VALUE_TIMESTAMP, FND_API.G_MISS_DATE, TO_DATE(NULL), p_VALUE_TIMESTAMP)
,decode(p_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_COUNTER_READING)
,decode(p_RESET_MODE, FND_API.G_MISS_CHAR, NULL, p_RESET_MODE)
,decode(p_RESET_REASON, FND_API.G_MISS_CHAR, NULL, p_RESET_REASON)
,decode(p_ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_ADJUSTMENT_TYPE)
,decode(p_ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL, p_ADJUSTMENT_READING)
,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
,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_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_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
,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_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
,decode(p_COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
,decode(p_LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
,decode(p_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ID)
,decode(p_AUTOMATIC_ROLLOVER_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
,decode(p_INCLUDE_TARGET_RESETS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_TARGET_RESETS)
,decode(p_SOURCE_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_VALUE_ID)
,decode(p_NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
,decode(p_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DISABLED_FLAG)
,decode(p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
,decode(p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID)
,decode(p_INITIAL_READING_FLAG, FND_API.G_MISS_CHAR, NULL, p_INITIAL_READING_FLAG)
);
END Insert_Row;
PROCEDURE Update_Row(
p_COUNTER_VALUE_ID NUMBER
,p_COUNTER_ID NUMBER
,p_VALUE_TIMESTAMP DATE
,p_COUNTER_READING NUMBER
,p_RESET_MODE VARCHAR2
,p_RESET_REASON VARCHAR2
,p_ADJUSTMENT_TYPE VARCHAR2
,p_ADJUSTMENT_READING NUMBER
,p_OBJECT_VERSION_NUMBER NUMBER
,p_LAST_UPDATE_DATE DATE
,p_LAST_UPDATED_BY NUMBER
,p_CREATION_DATE DATE
,p_CREATED_BY NUMBER
,p_LAST_UPDATE_LOGIN 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_ATTRIBUTE16 VARCHAR2
,p_ATTRIBUTE17 VARCHAR2
,p_ATTRIBUTE18 VARCHAR2
,p_ATTRIBUTE19 VARCHAR2
,p_ATTRIBUTE20 VARCHAR2
,p_ATTRIBUTE21 VARCHAR2
,p_ATTRIBUTE22 VARCHAR2
,p_ATTRIBUTE23 VARCHAR2
,p_ATTRIBUTE24 VARCHAR2
,p_ATTRIBUTE25 VARCHAR2
,p_ATTRIBUTE26 VARCHAR2
,p_ATTRIBUTE27 VARCHAR2
,p_ATTRIBUTE28 VARCHAR2
,p_ATTRIBUTE29 VARCHAR2
,p_ATTRIBUTE30 VARCHAR2
,p_ATTRIBUTE_CATEGORY VARCHAR2
,p_MIGRATED_FLAG VARCHAR2
,p_COMMENTS VARCHAR2
,p_LIFE_TO_DATE_READING NUMBER
,p_TRANSACTION_ID NUMBER
,p_AUTOMATIC_ROLLOVER_FLAG VARCHAR2
,p_INCLUDE_TARGET_RESETS VARCHAR2
,p_SOURCE_COUNTER_VALUE_ID NUMBER
,p_NET_READING NUMBER
,p_DISABLED_FLAG VARCHAR2
,p_SOURCE_CODE VARCHAR2
,p_SOURCE_LINE_ID NUMBER
,p_INITIAL_READING_FLAG VARCHAR2
) IS
BEGIN
UPDATE CSI_COUNTER_READINGS
SET
COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
,VALUE_TIMESTAMP = decode(p_VALUE_TIMESTAMP, NULL, VALUE_TIMESTAMP, FND_API.G_MISS_DATE, NULL, p_VALUE_TIMESTAMP)
,COUNTER_READING = decode(p_COUNTER_READING, NULL, COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_COUNTER_READING)
,RESET_MODE = decode(p_RESET_MODE, NULL, RESET_MODE, FND_API.G_MISS_CHAR, NULL, p_RESET_MODE)
,RESET_REASON = decode(p_RESET_REASON, NULL, RESET_REASON, FND_API.G_MISS_CHAR, NULL, p_RESET_REASON)
,ADJUSTMENT_TYPE = decode(p_ADJUSTMENT_TYPE, NULL, ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_ADJUSTMENT_TYPE)
,ADJUSTMENT_READING = decode(p_ADJUSTMENT_READING, NULL, ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL, p_ADJUSTMENT_READING)
,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
,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)
,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
,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)
,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
,MIGRATED_FLAG = decode(p_MIGRATED_FLAG, NULL, MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
,COMMENTS = decode(p_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
,LIFE_TO_DATE_READING = decode(p_LIFE_TO_DATE_READING, NULL, LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
,TRANSACTION_ID = decode(p_TRANSACTION_ID, NULL, TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ID)
,AUTOMATIC_ROLLOVER_FLAG = decode(p_AUTOMATIC_ROLLOVER_FLAG, NULL, AUTOMATIC_ROLLOVER_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
,INCLUDE_TARGET_RESETS = decode(p_INCLUDE_TARGET_RESETS, NULL, INCLUDE_TARGET_RESETS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_TARGET_RESETS)
,SOURCE_COUNTER_VALUE_ID = decode(p_SOURCE_COUNTER_VALUE_ID, NULL, SOURCE_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_VALUE_ID)
,NET_READING = decode(p_NET_READING, NULL, NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
,DISABLED_FLAG = decode(p_DISABLED_FLAG, NULL, DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DISABLED_FLAG)
,SOURCE_CODE = decode(p_SOURCE_CODE, NULL, NULL, SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
,SOURCE_LINE_ID = decode(p_SOURCE_LINE_ID, NULL, SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID)
,INITIAL_READING_FLAG = decode(p_INITIAL_READING_FLAG, NULL, INITIAL_READING_FLAG, FND_API.G_MISS_CHAR, NULL, p_INITIAL_READING_FLAG)
WHERE COUNTER_VALUE_ID = p_COUNTER_VALUE_ID;
END Update_Row;
,p_LAST_UPDATE_DATE DATE
,p_LAST_UPDATED_BY NUMBER
,p_CREATION_DATE DATE
,p_CREATED_BY NUMBER
,p_LAST_UPDATE_LOGIN 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_ATTRIBUTE16 VARCHAR2
,p_ATTRIBUTE17 VARCHAR2
,p_ATTRIBUTE18 VARCHAR2
,p_ATTRIBUTE19 VARCHAR2
,p_ATTRIBUTE20 VARCHAR2
,p_ATTRIBUTE21 VARCHAR2
,p_ATTRIBUTE22 VARCHAR2
,p_ATTRIBUTE23 VARCHAR2
,p_ATTRIBUTE24 VARCHAR2
,p_ATTRIBUTE25 VARCHAR2
,p_ATTRIBUTE26 VARCHAR2
,p_ATTRIBUTE27 VARCHAR2
,p_ATTRIBUTE28 VARCHAR2
,p_ATTRIBUTE29 VARCHAR2
,p_ATTRIBUTE30 VARCHAR2
,p_ATTRIBUTE_CATEGORY VARCHAR2
,p_MIGRATED_FLAG VARCHAR2
,p_COMMENTS VARCHAR2
,p_LIFE_TO_DATE_READING NUMBER
,p_TRANSACTION_ID NUMBER
,p_AUTOMATIC_ROLLOVER_FLAG VARCHAR2
,p_INCLUDE_TARGET_RESETS VARCHAR2
,p_SOURCE_COUNTER_VALUE_ID NUMBER
,p_NET_READING NUMBER
,p_DISABLED_FLAG VARCHAR2
,p_SOURCE_CODE VARCHAR2
,p_SOURCE_LINE_ID NUMBER
,p_INITIAL_READING_FLAG VARCHAR2
) IS
CURSOR C1 IS
SELECT *
FROM CSI_COUNTER_READINGS
WHERE COUNTER_VALUE_ID = p_COUNTER_VALUE_ID
FOR UPDATE of COUNTER_VALUE_ID NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
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.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.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN) OR ((Recinfo.LAST_UPDATE_LOGIN IS NULL) AND (p_LAST_UPDATE_LOGIN IS NULL)))
AND ((Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1) OR ((Recinfo.ATTRIBUTE1 IS NULL) AND (p_ATTRIBUTE1 IS NULL)))
AND ((Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2) OR ((Recinfo.ATTRIBUTE2 IS NULL) AND (p_ATTRIBUTE2 IS NULL)))
AND ((Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3) OR ((Recinfo.ATTRIBUTE3 IS NULL) AND (p_ATTRIBUTE3 IS NULL)))
AND ((Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4) OR ((Recinfo.ATTRIBUTE4 IS NULL) AND (p_ATTRIBUTE4 IS NULL)))
AND ((Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5) OR ((Recinfo.ATTRIBUTE5 IS NULL) AND (p_ATTRIBUTE5 IS NULL)))
AND ((Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6) OR ((Recinfo.ATTRIBUTE6 IS NULL) AND (p_ATTRIBUTE6 IS NULL)))
AND ((Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7) OR ((Recinfo.ATTRIBUTE7 IS NULL) AND (p_ATTRIBUTE7 IS NULL)))
AND ((Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8) OR ((Recinfo.ATTRIBUTE8 IS NULL) AND (p_ATTRIBUTE8 IS NULL)))
AND ((Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9) OR ((Recinfo.ATTRIBUTE9 IS NULL) AND (p_ATTRIBUTE9 IS NULL)))
AND ((Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10) OR ((Recinfo.ATTRIBUTE10 IS NULL) AND (p_ATTRIBUTE10 IS NULL)))
AND ((Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11) OR ((Recinfo.ATTRIBUTE11 IS NULL) AND (p_ATTRIBUTE11 IS NULL)))
AND ((Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12) OR ((Recinfo.ATTRIBUTE12 IS NULL) AND (p_ATTRIBUTE12 IS NULL)))
AND ((Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13) OR ((Recinfo.ATTRIBUTE13 IS NULL) AND (p_ATTRIBUTE13 IS NULL)))
AND ((Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14) OR ((Recinfo.ATTRIBUTE14 IS NULL) AND (p_ATTRIBUTE14 IS NULL)))
AND ((Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15) OR ((Recinfo.ATTRIBUTE15 IS NULL) AND (p_ATTRIBUTE15 IS NULL)))
AND ((Recinfo.ATTRIBUTE16 = p_ATTRIBUTE16) OR ((Recinfo.ATTRIBUTE16 IS NULL) AND (p_ATTRIBUTE16 IS NULL)))
AND ((Recinfo.ATTRIBUTE17 = p_ATTRIBUTE17) OR ((Recinfo.ATTRIBUTE17 IS NULL) AND (p_ATTRIBUTE17 IS NULL)))
AND ((Recinfo.ATTRIBUTE18 = p_ATTRIBUTE18) OR ((Recinfo.ATTRIBUTE18 IS NULL) AND (p_ATTRIBUTE18 IS NULL)))
AND ((Recinfo.ATTRIBUTE19 = p_ATTRIBUTE19) OR ((Recinfo.ATTRIBUTE19 IS NULL) AND (p_ATTRIBUTE19 IS NULL)))
AND ((Recinfo.ATTRIBUTE20 = p_ATTRIBUTE20) OR ((Recinfo.ATTRIBUTE20 IS NULL) AND (p_ATTRIBUTE20 IS NULL)))
AND ((Recinfo.ATTRIBUTE21 = p_ATTRIBUTE21) OR ((Recinfo.ATTRIBUTE21 IS NULL) AND (p_ATTRIBUTE21 IS NULL)))
AND ((Recinfo.ATTRIBUTE22 = p_ATTRIBUTE22) OR ((Recinfo.ATTRIBUTE22 IS NULL) AND (p_ATTRIBUTE22 IS NULL)))
AND ((Recinfo.ATTRIBUTE23 = p_ATTRIBUTE23) OR ((Recinfo.ATTRIBUTE23 IS NULL) AND (p_ATTRIBUTE23 IS NULL)))
AND ((Recinfo.ATTRIBUTE24 = p_ATTRIBUTE24) OR ((Recinfo.ATTRIBUTE24 IS NULL) AND (p_ATTRIBUTE24 IS NULL)))
AND ((Recinfo.ATTRIBUTE25 = p_ATTRIBUTE25) OR ((Recinfo.ATTRIBUTE25 IS NULL) AND (p_ATTRIBUTE25 IS NULL)))
AND ((Recinfo.ATTRIBUTE26 = p_ATTRIBUTE26) OR ((Recinfo.ATTRIBUTE26 IS NULL) AND (p_ATTRIBUTE26 IS NULL)))
AND ((Recinfo.ATTRIBUTE27 = p_ATTRIBUTE27) OR ((Recinfo.ATTRIBUTE27 IS NULL) AND (p_ATTRIBUTE27 IS NULL)))
AND ((Recinfo.ATTRIBUTE28 = p_ATTRIBUTE28) OR ((Recinfo.ATTRIBUTE28 IS NULL) AND (p_ATTRIBUTE28 IS NULL)))
AND ((Recinfo.ATTRIBUTE29 = p_ATTRIBUTE29) OR ((Recinfo.ATTRIBUTE29 IS NULL) AND (p_ATTRIBUTE29 IS NULL)))
AND ((Recinfo.ATTRIBUTE30 = p_ATTRIBUTE30) OR ((Recinfo.ATTRIBUTE30 IS NULL) AND (p_ATTRIBUTE30 IS NULL)))
AND ((Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY) OR ((Recinfo.ATTRIBUTE_CATEGORY IS NULL) AND (p_ATTRIBUTE_CATEGORY IS NULL)))
AND ((Recinfo.MIGRATED_FLAG = p_MIGRATED_FLAG) OR ((Recinfo.MIGRATED_FLAG IS NULL) AND (p_MIGRATED_FLAG IS NULL)))
AND ((Recinfo.COMMENTS = p_COMMENTS) OR ((Recinfo.COMMENTS IS NULL) AND (p_COMMENTS IS NULL)))
AND ((Recinfo.LIFE_TO_DATE_READING = p_LIFE_TO_DATE_READING) OR ((Recinfo.LIFE_TO_DATE_READING IS NULL) AND (p_LIFE_TO_DATE_READING IS NULL)))
AND ((Recinfo.TRANSACTION_ID = p_TRANSACTION_ID) OR ((Recinfo.TRANSACTION_ID IS NULL) AND (p_TRANSACTION_ID IS NULL)))
AND ((Recinfo.AUTOMATIC_ROLLOVER_FLAG = p_AUTOMATIC_ROLLOVER_FLAG) OR ((Recinfo.AUTOMATIC_ROLLOVER_FLAG IS NULL) AND (p_AUTOMATIC_ROLLOVER_FLAG IS NULL)))
AND ((Recinfo.INCLUDE_TARGET_RESETS = p_INCLUDE_TARGET_RESETS) OR ((Recinfo.INCLUDE_TARGET_RESETS IS NULL) AND (p_INCLUDE_TARGET_RESETS IS NULL)))
AND ((Recinfo.SOURCE_COUNTER_VALUE_ID = p_SOURCE_COUNTER_VALUE_ID) OR ((Recinfo.SOURCE_COUNTER_VALUE_ID IS NULL) AND (p_SOURCE_COUNTER_VALUE_ID IS NULL)))
AND ((Recinfo.NET_READING = p_NET_READING) OR ((Recinfo.NET_READING IS NULL) AND (p_NET_READING IS NULL)))
AND ((Recinfo.DISABLED_FLAG = p_DISABLED_FLAG) OR ((Recinfo.DISABLED_FLAG IS NULL) AND (p_DISABLED_FLAG IS NULL)))
AND ((Recinfo.SOURCE_CODE = p_SOURCE_CODE) OR ((Recinfo.SOURCE_CODE IS NULL) AND (p_SOURCE_CODE IS NULL)))
AND ((Recinfo.SOURCE_LINE_ID = p_SOURCE_LINE_ID) OR ((Recinfo.SOURCE_LINE_ID IS NULL) AND (p_SOURCE_LINE_ID IS NULL)))
AND ((Recinfo.INITIAL_READING_FLAG = p_INITIAL_READING_FLAG) OR ((Recinfo.INITIAL_READING_FLAG IS NULL) AND (p_INITIAL_READING_FLAG IS NULL)))
) THEN
return;
PROCEDURE Delete_Row(
p_COUNTER_VALUE_ID NUMBER
) IS
BEGIN
DELETE FROM CSI_COUNTER_READINGS
WHERE COUNTER_VALUE_ID = p_COUNTER_VALUE_ID;
END Delete_Row;